Syntax error phpprobid

frankic · #1 (**permalink**) 03-03-06, 02:20 PM

I keep receiving this error when performing a dutch auction with phpprobid. I am using PHP version 4.1 - there support says its becuase im not using PHP 4.4 or above. I find it hard to believe that there is not an easier fix to this problem without having to upgrade servers. Someone please help.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /vservers/bidcctvc/htdocs/auctiondetails.php on line 549

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /vservers/bidcctvc/htdocs/auctiondetails.php on line 551
n/a (0)

Im also gettting this when i click history of bid

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out FROM probid_bids WHERE id='3'' at line 1
INVALID QUERY: SELECT out FROM probid_bids WHERE id='3

Nico · #2 (**permalink**) 03-03-06, 02:36 PM

Quote:

Originally Posted by frankic

probid_bids WHERE id='3'' at line 1
INVALID QUERY: SELECT out FROM probid_bids WHERE id='3

There are 2 quotes behind the first 3, and there's no quote behind the second. This could be the problem.

As for the other problem, could you post your code?

frankic · #3 (**permalink**) 03-03-06, 03:58 PM

PHP Code:


			
 
<?
## v5.23 -> dec. 13, 2005
session_start();
include_once ("config/config.php");
 
if ($setts['cron_job']==2) {
    $manualCron = TRUE;
    include_once ("cron/cron1.php");
}
 
include ("themes/".$setts['default_theme']."/header.php");
 
if ($_SESSION['counted'][$_GET['id']]!="cntd") {
    $addClick = mysql_query("UPDATE probid_auctions SET clicks=clicks+1 WHERE id='".$_GET['id']."'");
    $_SESSION['counted'][$_GET['id']]="cntd";
}
 
##if ($_SESSION['adminarea']!="Active") $addPattern = " AND deleted!=1";
##else 
$addPattern = "";
 
$auctionDetails = getSqlRow("SELECT * FROM probid_auctions WHERE id='".$_GET['id']."' AND active=1".$addPattern);
$isAuction = getSqlNumber("SELECT * FROM probid_auctions WHERE id='".$_GET['id']."' AND active=1".$addPattern);
if ($isAuction > 0) {
    $sellerDetails = getSqlRow("SELECT * FROM probid_users WHERE id='".$auctionDetails['ownerid']."'"); 
 
    include_once("formchecker.php");
 
    ### add the messaging function
    if ($action=="submit_question") {
        if ($_GET['question_type']=="private") {            
            $ownerId = $auctionDetails['ownerid'];
            $senderId = $_SESSION['memberid'];
            $auctionId = $_GET['id'];
            $message = $_GET['message'];
            include ("mails/askquestion.php");
            $msgSys_msg = "<p align=center><strong>$lang[askquestionokmsg]</strong></p>";
        } else if ($_GET['question_type']=="public") {
            if (trim($_GET['message'])!="") {
                $currentTime = time();
                $message = remSpecialChars(trim($_GET['message']));
                ## we check if an exact message hasnt been posted yet
                $ismsg = getSqlRow("SELECT id FROM probid_public_msg WHERE auctionid='".$_GET['id']."' AND 
                ownerid='".$auctionDetails['ownerid']."' AND posterid='".$_SESSION['memberid']."' AND 
                msgtype='Q' AND content='".$message."'");
 
                if (!$ismsg&&$_SESSION['memberid']>0) {
                    $addMsg = mysql_query("INSERT INTO probid_public_msg 
                    (auctionid, ownerid, posterid, msgtype, content, regdate) VALUES
                    ('".$_GET['id']."', '".$auctionDetails['ownerid']."', '".$_SESSION['memberid']."', 
                    'Q', '".$message."', '".$currentTime."')"); 
                    $answerid = mysql_insert_id();
                    $prepareSellerMsg = mysql_query("INSERT INTO probid_public_msg 
                    (auctionid, ownerid, posterid, msgtype, content, regdate, answerid) VALUES
                    ('".$_GET['id']."', '".$auctionDetails['ownerid']."', '".$auctionDetails['ownerid']."', 
                    'A', '', '', '".$answerid."')"); 
                    $msgSys_msg = "<p align=center><strong>$lang[askquestionokmsg2]</strong></p>";
                    $sellerId = $auctionDetails['ownerid'];
                    $auctionId = $auctionDetails['id'];
                    include ("mails/notifysellerquestionposted.php");
                }
            } else {
                $msgSys_msg = "<p align=center><strong>$lang[askquestionokmsg3]</strong></p>";
            }
        }
        echo "<script>document.location.href='auctiondetails.php?id=".$_GET['id']."'</script>";
    }
 
    if ($action=="submit_answer") {
        $currentTime = time();
        $message = remSpecialChars(trim($_GET['content']));
        $addSellerMsg = mysql_query("UPDATE probid_public_msg SET
        content='".$message."', regdate='".$currentTime."' WHERE 
        answerid='".$_GET['answerid']."' AND ownerid='".$_SESSION['memberid']."' 
        AND posterid='".$_SESSION['memberid']."'") or die(mysql_error());
 
        $questionUserId = getSqlField("SELECT posterid FROM probid_public_msg WHERE id='".$_GET['answerid']."'","posterid");
        $auctionId = $auctionDetails['id'];
        include ("mails/notifybuyeranswerposted.php");
 
        $msgSys_msg = "<p align=center><strong>$lang[askquestionokmsg4]</strong></p>";
        echo "<script>document.location.href='auctiondetails.php?id=".$_GET['id']."'</script>";
    }
    ### end of messaging function
 
    $binAuction=FALSE;
    if ($auctionDetails['bidstart']==$auctionDetails['bnvalue']&&$auctionDetails['bn']=="Y") $binAuction=TRUE;    
    ### We decide if the auction is about to start, if it didnt, then only the owner can see it.
    $notStarted=FALSE;
    if (strtotime($auctionDetails['startdate'])>time()) $notStarted=TRUE;
    if ($auctionDetails['ownerid']==$_SESSION['memberid']) $notStarted=FALSE;
    if ($notStarted==TRUE) {
        headerdetails($lang[auctdetserror]);
        echo "<p class=contentfont align=center>$lang[auctiondidntstart]</p>";
    } else { ?>
 
<table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td nowrap class="contentfont"><img src="themes/<?=$setts['default_theme'];?>/img/system/home.gif" align="absmiddle" border="0" hspace="5"><a href="index.php">
<?=$lang[backtohomepage];?>
</a></td>
<td width="7">&nbsp;</td>
<td class="topitempage" width="100%"><?
         $nav = "";
         $nav2 = "";
        $parent=$auctionDetails['category'];
         if($parent > 0) {
             $croot = $parent;
             $cntr = 0;
             while ($croot>0) {
                 $sbcts = mysql_query(" SELECT id,parent FROM probid_categories WHERE id='".$croot."' ") or die(mysql_error());
                $crw = mysql_fetch_array($sbcts);
                 if($cntr == 0) {
                     $nav = $c_lang[$crw['id']];
                 } else {
                     if($parent != $croot) {
                         $nav = "<a href=\"categories.php?parent=".$crw[id]."\">".$c_lang[$crw['id']]."</a> > ".$nav;
                     }
                 }
                 $cntr++;
                 $croot = $crw['parent'];
             }
         } 
        $parent=$auctionDetails['addlcategory'];
         if($parent > 0) {
             $croot = $parent;
             $cntr = 0;
             while ($croot>0) {
                 $sbcts = mysql_query("SELECT id,parent FROM probid_categories WHERE id='".$croot."'") or die(mysql_error());
 
                $crw = mysql_fetch_array($sbcts);
                 if($cntr == 0) {
                     $nav2 = $c_lang[$crw['id']];
                 } else {
                     if($parent != $croot) {
                         $nav2 = "<a href=\"categories.php?parent=".$crw[id]."\">".$c_lang[$crw['id']]."</a> > ".$nav2;
                     }
                 }
                 $cntr++;
                 $croot = $crw['parent'];
             }
         } 
        if (strlen($nav) || strlen($nav2)) {
            echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
                        <tr class=\"topitem\" valign=\"top\">
                        <td nowrap><b>$lang[itemlistedon]:</b></td>
                        <td width=\"7\">&nbsp;</td>
                        <td width=\"100%\">$nav";
            if (strlen($nav2) && strlen($nav)) echo "<br>";
            echo "$nav2</td></tr></table>";
        } ?></td>
</tr>
</table>
<div><img src="themes/<?=$setts['default_theme'];?>/img/pixel.gif" width="1" height="5"></div>
<? headerdetails("<table cellpadding=0 cellspacing=0 border=0 width=100%><tr><td class='itemid'>".$imgarritem.$auctionDetails['itemname']."</td><td align=right class='itemidend'><b>$lang[itemid]: ".$_GET['id']."</b>&nbsp;&nbsp;</td></tr></table>");?>
<? 
$fields=array(); 
$getPics=mysql_query("SELECT * FROM probid_auction_images WHERE auctionid='".$auctionDetails['id']."'"); 
$nbPics=mysql_num_rows($getPics); 
if ($nbPics>0) { 
while ($addlPicture=mysql_fetch_array ($getPics)) { 
array_push($fields, $addlPicture['name']); 
}} 
?>
<SCRIPT LANGUAGE = "JavaScript">
function WinOpen1(amount) {
venster = window.open("currency_converter.php?AMOUNT=<?=$auctionDetails['bidstart'];?>","popDialog","height=220,width=650,toolbar=no,resizable=yes,scrollbars=yes,left=10,top=10")
}
function WinOpen2(amount) {
venster = window.open("currency_converter.php?AMOUNT=<?=$auctionDetails['bnvalue'];?>","popDialog","height=220,width=650,toolbar=no,resizable=yes,scrollbars=yes,left=10,top=10")
}
function WinOpen3() {
venster = window.open("currency_converter.php?AMOUNT=<?=$auctionDetails['minbidcurr'];?>","popDialog","height=220,width=650,toolbar=no,resizable=yes,scrollbars=yes,left=10,top=10")
}
function WinOpen4() {
venster = window.open("currency_converter.php","popDialog","height=220,width=650,toolbar=no,resizable=yes,scrollbars=yes,left=10,top=10")
}
// end hide -->
</SCRIPT>
<SCRIPT LANGUAGE="JavaScript"> 
<!-- Begin 
NewImg = new Array ( 
"makethumb.php?pic=<?=$auctionDetails['picpath']?>&w=100&sq=Y" 
<? foreach($fields as $field) {?> 
,"makethumb.php?pic=<?=$field;?>&w=100&sq=Y" 
<?}?> 
); 
var ImgNum = 0; 
var ImgLength = NewImg.length - 1; 
 
//Time delay between Slides in milliseconds 
var delay = 2000; 
 
var lock = false; 
var run; 
function chgImg(direction) { 
if (document.images) { 
ImgNum = ImgNum + direction; 
if (ImgNum > ImgLength) { 
ImgNum = 0; 
} 
if (ImgNum < 0) { 
ImgNum = ImgLength; 
} 
document.slideshow.src = NewImg[ImgNum]; 
} 
} 
function auto() { 
if (lock == true) { 
lock = false; 
window.clearInterval(run); 
} 
else if (lock == false) { 
lock = true; 
run = setInterval("chgImg(1)", delay); 
} 
} 
// End --> 
</script>
<!-- Table for subhead -->
<table width="100%" border="0" cellpadding="3" cellspacing="2" class="subitem">
<tr class="contentfont" >
<td width="1%"><? if ($_SESSION['membersarea']=="Active"||$_SESSION['accsusp']==2) { 
     echo "<img src='themes/".$setts['default_theme']."/img/system/status1.gif' vspace=5>";
     } else { echo "<img src='themes/".$setts['default_theme']."/img/system/status.gif' vspace=5>"; }?>
</td>
<td width="25%" class="contentfont"><? if ($_SESSION['membersarea']=="Active"||$_SESSION['accsusp']==2) { ?>
<?=$lang[welcome];?>
, <br>
<b><? echo $_SESSION['membername']; ?></b>
<? } else { echo $lang[status_bidder_seller]; }?>
</td>
<td align="center" class="leftborder"><a href="javascript:popUp('auction.printview.php?id=<?=$_REQUEST['id'];?>');"><img src="themes/<?=$setts['default_theme'];?>/img/system/print.gif" align="absmiddle" border="0" hspace="5">
<?=$lang[printview]?>
</a></td>
<td align="center" class="leftborder"><a href="itemwatch.php?id=<?=$auctionDetails['id'];?>&itemname=<?=$auctionDetails['itemname'];?>"><img src="themes/<?=$setts['default_theme'];?>/img/system/watch.gif" align="absmiddle" border="0" hspace="5">
<?=$lang[watchthisitem]?>
</a></td>
<td align="center" class="leftborder"><a href="auctionfriend.php?owner=<?=$auctionDetails['ownerid'];?>&auctionid=<?=$auctionDetails['id'];?>"><img src="themes/<?=$setts['default_theme'];?>/img/system/tofriend.gif" align="absmiddle" border="0" hspace="5">
<?=$lang[sendtofriend]?>
</a>&nbsp;&nbsp;</td>
</tr>
<?
$winnerLogged = getSqlNumber("SELECT id FROM probid_winners WHERE buyerid='".$_SESSION['memberid']."' AND auctionid='".$_GET['id']."' AND directpayment_paid=0"); 
if ($auctionDetails['acceptdirectpayment']&&($auctionDetails['closed']!=0||$auctionDetails['auctiontype']=="dutch")&&$auctionDetails['ownerid']!=$_SESSION['memberid']&&$winnerLogged) { 
    ## new function, calculate payment, it's intended for dutch auctions especially
    $getDpPayment = mysql_query("SELECT amount, quant_req, quant_offered FROM probid_winners WHERE
    buyerid='".$_SESSION['memberid']."' AND auctionid='".$_GET['id']."' AND directpayment_paid=0"); 
    $dpQuant = 0;
    $paymentAmount = 0;
    $postageC = 0;
    while ($dpPayment = mysql_fetch_array($getDpPayment)) {
        $dpQuant = ($dpPayment['quant_offered']>0) ? $dpPayment['quant_offered'] : 1;
        $paymentAmount += $dpQuant * $dpPayment['amount'];
        $postageC += $dpQuant * $auctionDetails['postage_costs'];
    }
    $paymentAmount += $postageC;
 
    if ($paymentAmount!="n/a"&&$paymentAmount!=""&&$paymentAmount>0) { ?>
<!-- Header Direct Payment -->
<tr height="21">
<td colspan="5" class="c4"><b>&raquo; <? echo (strtoupper($lang[headdirectpayment]));?></b></td>
</tr>
<tr>
<td colspan="5" class="c5"><img src="themes/<?=$setts['default_theme'];?>/img/pixel.gif" width="1" height="1"></td>
</tr>
<tr>
<td colspan="5"><!-- End Header Direct Payment -->
<table width="100%" border="0" cellspacing="1" cellpadding="0" class="c2">
<tr valign="top">
<td width="100%"><?
    if ($auctionDetails['paidwithdirectpayment']) {
        echo "<center>" . $lang[paiddirectpayment] . "</center>";
    } else {
        echo "<div style='padding: 6px;'>".$lang[you_won_item]."";
        echo "<b>".$auctionDetails[itemname]."</b>!<br>";
        echo "".$lang[you_won_item2]."</div>";
        $paymentAmount=number_format($paymentAmount,2,'.','');
        $returnUrl=$path."paymentdone.php";
        $failureUrl=$path."paymentfailed.php";
        $notifyUrl=$path."paymentprocess.php?table=100";
        paypalForm($auctionDetails['id']."_".$_SESSION['memberid'],$auctionDetails['directpaymentemail'],$paymentAmount,$auctionDetails['currency'],$returnUrl,$failureUrl,$notifyUrl,100,TRUE);
    } ?>
</td>
</tr>
</table></td>
</tr>
<?     } } ?>
</table>
<br>
<!-- 3 cell table -->
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="3">
<tr valign="top">
<td width="20%" align="center" class="contentfont"><? 
if ($auctionDetails['picpath']!="") 
echo " \n". 
"<table width=\"100%\" border=\"0\" cellspacing=\"5\" cellpadding=\"3\" class=\"border\">\n". 
" <tr> \n". 
" <td height=\"110\" align=\"center\" class=\"c2\"> \n". 
" <img src=\"makethumb.php?pic=".$auctionDetails['picpath']."&w=100&sq=Y\" name=\"slideshow\"> \n". 
" </td> \n". 
" </tr> \n". 
" <tr class=\"contentfont\"> \n". 
" <td align=center class=\"c3\"> \n". 
" <a href=\"javascript:chgImg(-1)\"><img src=\"themes/".$setts['default_theme']."/img/system/back.gif\" width=\"15\" height=\"15\" border=\"0\" align=\"absmiddle\"></a>&nbsp;&nbsp;<a href=\"javascript:auto()\" align=\"absmiddle\">$lang[autostop]</a>&nbsp;&nbsp;<a href=\"javascript:chgImg(1)\"><img src=\"themes/".$setts['default_theme']."/img/system/right.gif\" width=\"15\" height=\"15\" border=\"0\" align=\"absmiddle\"></a> \n". 
 
" </td> \n". 
" </tr> \n". 
"</table> \n". 
""; 
$getpics=mysql_query("SELECT * FROM probid_auction_images WHERE auctionid='".$_GET['id']."'"); ?>
<? 
    $daysLeft = daysleft($auctionDetails['enddate'],$setts['date_format']);
    $timeLeft = timeleft($auctionDetails['enddate'],$setts['date_format']);
    $currentBid = getSqlField("SELECT * FROM probid_bids WHERE auctionid='".$_GET['id']."' AND bidderid='".$_SESSION['memberid']."' ORDER BY bidamount DESC","bidamount") or die(mysql_error());
    $isCurrentBid = getSqlNumber("SELECT * FROM probid_bids WHERE auctionid='".$_GET['id']."' AND bidderid='".$_SESSION['memberid']."'"); 
    $showBN = showBuyNow($auctionDetails['rp'],$auctionDetails['rpvalue'],$auctionDetails['maxbid'],$auctionDetails['nrbids']);
?>
<? if ($auctionDetails['closed']==0&&$auctionDetails['ownerid']!=$_SESSION['memberid']&&$daysLeft>0&&!$binAuction) { ?>
<? if ($_SESSION['membersarea']!="Active") { ?>
<p align="center"><b><font class='redfont'>
<?=$lang[bid_errreg]?>
</font></b><br>
<br>
<a href="<?=$path_ssl;?>login.php?auctionid=<?=$_REQUEST['id'];?>">
<?=$lang[memberlogin];?>
</a> </p>
<? } else { ?>
<?    if (!$binAuction) { ?>
<br>
<table width="100%" border="0" cellspacing="1" cellpadding="1" class="border">
<form action="bid.php" method="post">
<? if ($auctionDetails['auctiontype']=="dutch") { ?>
<tr>
<td rowspan="3" valign="top" class="c2"><img src="themes/<?=$setts['default_theme'];?>/img/system/ma_bidding.gif" align="absmiddle" border="0" hspace="1" vspace="1"></td>
<td class="c2"><?=$lang[quant]?>
:
<input name="quantity" type="text" id="quantity" value="1" size="3"></td>
</tr>
<? } ?>
<tr>
<? if ($auctionDetails['auctiontype']=="dutch") { } else {?>
<td rowspan="2" class="c2"><img src="themes/<?=$setts['default_theme'];?>/img/system/ma_bidding.gif" align="absmiddle" border="0" hspace="1" vspace="1"></td>
<? } ?>
<td width="100%" class="c3"><strong>
<?=$auctionDetails['currency'];?>
</strong>
<input name="maxbid" type="text" id="maxbid" size="7">
<? 
        if ($auctionDetails['auctiontype']=="standard") {
            if ($auctionDetails['maxbid']==0) $minimumBid = $auctionDetails['bidstart'];
            else $minimumBid = setMinBid($auctionDetails['maxbid'],$auctionDetails['bi'],$auctionDetails['bivalue'],$auctionDetails['auctiontype']);
        } else {
            $maximumBid = $auctionDetails['maxbid'];
            $getBids = mysql_query("SELECT * FROM probid_bids WHERE 
            bidamount='".$maximumBid."' AND auctionid='".$auctionDetails['id']."'");
            $quantity = 0;
            while ($bids = mysql_fetch_array($getBids)) {
                $quantity += $bids['quantity'];
            }
            if ($auctionDetails['maxbid']==0) $minimumBid=$auctionDetails['bidstart'];
            else if ($quantity<$auctionDetails['quantity']) $minimumBid=$auctionDetails['maxbid'];
            else $minimumBid=setMinBid($auctionDetails['maxbid'],$auctionDetails['bi'],$auctionDetails['bivalue'],$auctionDetails['auctiontype']);
        } ?>
<input type="hidden" name="itemname" value="<?=remSpecialChars($auctionDetails['itemname']);?>">
<input type="hidden" name="auctionid" value="<?=$auctionDetails['id'];?>">
<input type="hidden" name="action" value="bid_CONF">
<input type="hidden" name="quant_avail" value="<?=$auctionDetails['quantity'];?>">
</td>
</tr>
<tr class="c4">
<td width="100%"><input name="placebidok" type="submit" id="placebidok" value="<?=$lang[placebid]?>"></td>
</tr>
</form>
</table>
<?                 } }}
 
 
        else if ($auctionDetails['ownerid']==$_SESSION['memberid']&&$auctionDetails['closed']==0&&!$binAuction) 
        echo "<table width=100% border=0 cellspacing=0 cellpadding=0><tr><td align='center' class='topitempage alertfont'>$lang[biderr_youpost]</td></tr></table>";
        else if ($auctionDetails['closed']!=0&&!$binAuction) echo "<br><table width=100% border=0 cellspacing=0 cellpadding=0><tr><td align='center' class='topitempage alertfont'>$lang[biderr_bidclosed]</td></tr></table>";
        else if ($daysleft<=0&&!$binAuction) echo "<br><table width=100% border=0 cellspacing=0 cellpadding=0><tr><td align='center' class='topitempage alertfont'>$lang[biderr_bidclosed]</td></tr></table>";
        else if ($binAuction) echo "<br><table width=100% border=0 cellspacing=0 cellpadding=0><tr><td align='center' class='topitempage alertfont'>$lang[buynowonlyauctionalalert]</td></tr></table>";
 
?>
</td>
<td width="50%"><!-- Start Table for item details -->
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr class="c5">
<td><img src="themes/<?=$setts['default_theme'];?>/img/pixel.gif" width="1" height="1"></td>
<td><img src="themes/<?=$setts['default_theme'];?>/img/pixel.gif" width="1" height="1"></td>
</tr>
<? if (!$binAuction) { ?>
<tr valign="top" class="c3">
<td nowrap><b>
<?=$lang[currbid]?>
:</b></td>
<td><b><? echo displayAmount($auctionDetails['maxbid'],$auctionDetails['currency']);?></b></td>
</tr>
<tr valign="top" class="c2">
<td nowrap><b>
<?=$lang[startbid]?>
:</b></td>
<td><b><font class="redfont"><? echo displayAmount($auctionDetails['bidstart'],$auctionDetails['currency']);?></font></b> [ <span class="contentfont"><a href="javascript:WinOpen1()">
<?=$lang[convert];?>
</a></span> ]</td>
</tr>
<? 
        if ($_SESSION['membersarea']=="Active") { 
             $currentBid = getSqlField("SELECT * FROM probid_bids WHERE 
             auctionid='".$_GET['id']."' AND bidderid='".$_SESSION['memberid']."' ORDER BY bidamount DESC","bidamount") or die(mysql_error());
             $isCurrentBid = getSqlNumber("SELECT * FROM probid_bids WHERE auctionid='".$_GET['id']."' AND bidderid='".$_SESSION['memberid']."'");
             if ($isCurrentBid>0) { ?>
<tr valign="top" class="c3">
<td><b>
<?=$lang[yourbid]?>
:</b></td>
<td><font class='greenfont'><b><? echo displayAmount($currentBid,$auctionDetails['currency']);?></b></font></td>
</tr>
<?     }
        } ?>
<? } ?>
<tr valign="top" class="c2">
<td><b>
<?=$lang[quant]?>
:</b></td>
<td><b>
<?=$auctionDetails['quantity'];?>
</b></td>
</tr>
<? if (!$binAuction) { ?>
<tr valign="top" class="c3">
<td nowrap><b>
<?=$lang[num_bids]?>
:</b></td>
<td class="contentfont"><?=$auctionDetails['nrbids'];?>
<? 
             if ($auctionDetails['nrbids']>0) { 
    echo "<a href=\"bidhistory.php?id=".$auctionDetails['id']."&name=".remSpecialChars($auctionDetails['itemname'])."&quantity=".$auctionDetails['quantity']."\">".$lang[viewhistory]."</a>";
            } ?></td>
</tr>
<? } ?>
<tr valign="top" class="c2">
<td><b>
<?=$lang[timeleft]?>
:</b></td>
<td><? 
            $daysLeft = daysleft($auctionDetails['enddate'],$setts['date_format']);
            $timeLeft = timeleft($auctionDetails['enddate'],$setts['date_format']);
            echo ($daysLeft>0) ? $timeLeft : $lang[bidclosed]; ?>
</td>
</tr>
<tr valign="top" class="c3">
<td><b>
<?=$lang[location]?>
:</b></td>
<td><? echo $auctionDetails['zip'].", ".$sellerDetails['city'].", ".$sellerDetails['state'];?></td>
</tr>
<tr valign="top" class="c2">
<td><b>
<?=$lang[country]?>
:</b></td>
<td><?=$auctionDetails['country'];?></td>
</tr>
<tr valign="top" class="c3">
<td><b>
<?=$lang[started]?>
:</b></td>
<td><? echo displaydatetime($auctionDetails['startdate'],$setts['date_format']);?></td>
</tr>
<tr valign="top" class="c2">
<td><b>
<?=$lang[ends]?>
:</b></td>
<td><? echo displaydatetime($auctionDetails['enddate'],$setts['date_format']);?></td>
</tr>
<tr class="c2">
<td><b>
<?=$lang[status]?>
:</b></td>
<td><? echo ($auctionDetails['closed']==0)?"<font class='greenfont'><b>".$lang[open]."</b></font>":"<font class='redfont'><b>".$lang[closed]."</b></font>";?></td>
</tr>
<tr class="c3">
<td colspan="2" class="contentfont"><table border="0" width="100%" cellpadding="0" cellspacing="0">
<tr>
<?
                ## if there is a reserve price, the BIN will exist until maxbid<resprice
                ## otherwise it will exist only until a bid is placed
                $showBN = showBuyNow($auctionDetails['rp'],$auctionDetails['rpvalue'],$auctionDetails['maxbid'],$auctionDetails['nrbids']);
                if ($showBN&&$auctionDetails['closed']==0) { 
                    $bnValue=displayAmount($auctionDetails['bnvalue'],$auctionDetails['currency']);
                    echo "<td align=\"center\">";
                    if ($auctionDetails['ownerid']!=$_SESSION['memberid']&&$auctionDetails['closed']!=1) { 
                        echo (($auctionDetails['bn']=="Y"&&$auctionDetails['active']==1&&$layout['act_buynow']==1)?"<strong><a href=\"buynow.php?id=".$auctionDetails['id']."\"><img src=themes/".$setts['default_theme']."/img/system/buyitnow.gif border=0 alt=\"".$lang[buynow]."\"><br> ".$lang[bynow_for]." ".$bnValue."</a></strong> [ <span class=contentfont><a href=\"javascript:WinOpen2()\">$lang[convert]</a></span> ]":"");
                    } else if ($auctionDetails['ownerid']==$_SESSION['memberid']&&$auctionDetails['closed']!=1) { 
                        echo $lang[cantusebuyout];
                    } else {
                        echo "<strong>".(($auctionDetails['bn']=="Y"&&$auctionDetails['active']==1&&$layout['act_buynow']==1)?"<img src=themes/".$setts['default_theme']."/img/system/buyitnow.gif border=0 alt=\"".$lang[buynow]."\"><br> ".$lang[bynow_for]." ".$bnValue."":"")."</strong>";
                    }
                    echo "</td>";
                } 
                echo "<td width=\"10\"></td>"; ?>
</tr>
</table></td>
</tr>
<tr class="c2">
<td colspan="2"><font class='bluefont'>
<? 
            if ($auctionDetails['rp']=="Y") { 
                if ($auctionDetails['rpwinner']==0) echo ($auctionDetails['rpvalue']>$auctionDetails['maxbid']) ? $lang[reservenotmet] : $lang[reservemet]; 
                echo ($auctionDetails['closed']==1&&$auctionDetails['rpvalue']>$auctionDetails['maxbid']&&$_SESSION['memberid']==$auctionDetails['ownerid']&&$auctionDetails['nrbids']>0&&$auctionDetails['rpwinner']==0) ? "&nbsp; <span class=\"contentfont\">[ <a href=\"reserveoffers.php?id=".$auctionDetails['id']."\"><strong>$lang[makeresoffer]</strong></a> ]</span>" : "";
            } ?>
</font> </td>
</tr>
<tr class="c3">
<td colspan="2" class="contentfont"><? 
             if ($setts['swap_items']==1&&$auctionDetails['ownerid']!=$_SESSION['memberid']&&$auctionDetails['closed']!=1&&$auctionDetails['isswap']=="Y"&&$auctionDetails['deleted']!=1) {
                echo "<a href=\"swapitems.php?id=".$auctionDetails['id']."\">".$lang[offerswap]."</a>";
            } ?>
</td>
</tr>
<? if (!$binAuction||$auctionDetails['closed']==1) { ?>
<tr class="c2">
<td><b>
<? echo ($auctionDetails['closed']==1) ? $lang[winnerss] : $lang[highbid]; ?>
:</b></td>
<td class="contentfont"><b>
<? 
            if ($auctionDetails['closed'] == 1) { 
                $getAuctionWinner = mysql_query("SELECT buyerid, bnpurchase, amount FROM probid_winners WHERE auctionid='".$auctionDetails['id']."'") or die(mysql_error());
                $nbWinners = mysql_num_rows($getAuctionWinner);
                while ($auctionWinner = mysql_fetch_array($getAuctionWinner)) {
                    $bidderName = getSqlField("SELECT username FROM probid_users WHERE id='".$auctionWinner['buyerid']."'","username");
                    echo "<font class='greenfont'>".displayAmount($auctionWinner['amount'],$auctionDetails['currency'])."</font> - ".$bidderName." <a href=\"viewfeedback.php?owner=".$auctionWinner['buyerid']."&auction=".$auctionDetails['id']."\">".getFeedback($auctionWinner['buyerid'])."</a>";
                    if ($auctionWinner['bnpurchase']==1) echo "</b> [ ".$lang[purchasedwithbn]." ] <b>";
                    if ($nbWinners>0) echo "<br>";
                    $foundWinner = TRUE;
                }
                if (!$foundWinner) echo $lang[na];
            } else { 
                echo ($auctionDetails['rpvalue']<=$auctionDetails['maxbid'])?"<font class='greenfont'><b>":"";
                echo displayAmount($auctionDetails['maxbid'],$auctionDetails['currency']);
                echo ($auctionDetails['rpvalue']<=$auctionDetails['maxbid'])?"</b></font><br>":"";
 
                if ($auctionDetails['maxbid']>0) {
                    echo " - ";
                    if ($auctionDetails['private']!="Y") {
                        $getBidderId=mysql_query("SELECT * FROM probid_bids WHERE auctionid='".$auctionDetails['id']."' AND out=0 AND invalid=0 ORDER BY id DESC");
                        $nbBidders = mysql_num_rows($getBidderId);
                        ## display only one high bidder, and a (more...) link to a popup if there are more high bidders
                        $highBidder=mysql_fetch_array($getBidderId);
 
                        $bidderName = getSqlField("SELECT username FROM probid_users WHERE id='".$highBidder['bidderid']."'","username");
                        echo $bidderName." <a href=\"viewfeedback.php?owner=".$highBidder['bidderid']."&auction=".$auctionDetails['id']."\">".getFeedback($highBidder['bidderid'])."</a>";
 
                        if ($nbBidders>1) echo " [ <a href=\"javascript:popUpSmall('popup_allbidders.php?id=$_GET[id]');\">".$lang[more_bidders]."</a> ]";
                    } else { 
                        echo $lang[bidderhidden]; 
                    }
                } 
            } ?></b></td>
</tr>
<? } ?>
<tr class="c5">
<td colspan="2"><img src="themes/<?=$setts['default_theme'];?>/img/pixel.gif" width="1" height="1"></td>
</tr>
<tr>
<td colspan="2"><strong>
<?=$lang[item_is_watched_by];?>
<?=getSqlNumber("SELECT DISTINCT userid FROM probid_auction_watch WHERE auctionid='".$_GET['id']."'"); ?>
<?=$lang[people];?>
</strong></td>
</tr>
</table></td>
<td width="30%"><table width="100%" border="0" cellspacing="1" cellpadding="3" class="contentfont">
<tr>
<td class="c1"><?=$lang[sellerinfo]?></td>
</tr>
<tr class="c5">
<td><img src="themes/<?=$setts['default_theme'];?>/img/pixel.gif" width="1" height="1"></td>
</tr>
<tr>
<td class="c3"><? echo $sellerDetails['username'];?> <a href="viewfeedback.php?owner=<?=$sellerDetails['id'];?>&auction=<?=$auctionDetails['id'];?>"> <? echo getFeedback($sellerDetails['id']);?> </a> </td>
</tr>
<tr class="c2">
<td><b>&raquo;</b>
<? if ($sellerDetails['regdate']!=0) echo $lang[regsince]." ".date(substr($setts['date_format'],0,7),$sellerDetails['regdate'])." ".$lang[inthe]." ".$sellerDetails['country']; ?>
</td>
</tr>
<tr class="c3">
<td><b>&raquo;</b> <a href="otheritems.php?owner=<?=$auctionDetails['ownerid'];?>&nick=<?=$sellerDetails['username'];?>">
<?=$lang[seeallauctsseller]?>
</a></td>
</tr>
<?
        $shopDets = getSqlRow("SELECT aboutpage_type, store_active FROM probid_users WHERE id='".$sellerDetails['id']."'");
        if ($shopDets['aboutpage_type']==2&&$shopDets['store_active']==1) { ?>
<tr class="c2">
<td><b>&raquo;</b> <a href="shop.php?userid=<?=$auctionDetails['ownerid'];?>">
<?=$lang[seeshop]?>
</a></td>
</tr>
<? } ?>
<tr class="c2">
<td align="center"><table width="100%" cellpadding="2" cellspacing="1" border="0" class="c4" >
<tr class="c3">
<td nowrap>&nbsp;<b>
<?=$lang[feedback_rating];?>
</b>:</td>
<td width="100%"><? echo calcFeedback($sellerDetails['id']);?></td>
</tr>
<tr class="c2 positive">
<td nowrap><img src="images/5stars.gif"></td>
<td><? echo getSqlNumber("SELECT userid FROM probid_feedbacks WHERE userid='".$auctionDetails['ownerid']."' AND submitted=1 AND rate=5"); ?></td>
</tr>
<tr class="c3 positive">
<td nowrap><img src="images/4stars.gif"></td>
<td><? echo getSqlNumber("SELECT userid FROM probid_feedbacks WHERE userid='".$auctionDetails['ownerid']."' AND submitted=1 AND rate=4"); ?></td>
</tr>
<tr class="c2 neutral">
<td nowrap><img src="images/3stars.gif"></td>
<td><? echo getSqlNumber("SELECT userid FROM probid_feedbacks WHERE userid='".$auctionDetails['ownerid']."' AND submitted=1 AND rate=3"); ?></td>
</tr>
<tr class="c3 negative">
<td nowrap><img src="images/2stars.gif"></td>
<td><? echo getSqlNumber("SELECT userid FROM probid_feedbacks WHERE userid='".$auctionDetails['ownerid']."' AND submitted=1 AND rate=2"); ?></td>
</tr>
<tr class="c2 negative">
<td nowrap><img src="images/1stars.gif"></td>
<td><? echo getSqlNumber("SELECT userid FROM probid_feedbacks WHERE userid='".$auctionDetails['ownerid']."' AND submitted=1 AND rate=1"); ?></td>
</tr>
<tr class="c3">
<td colspan="2" align="center"><a href="viewfeedback.php?owner=<?=$sellerDetails['id'];?>&auction=<?=$auctionDetails['id'];?>">
<?=$lang[view_fb];?>
</a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<br>
<!-- Header Descriptions -->
<? header5(strtoupper($lang[descr]));?>
<!-- End Header Descriptions -->
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr> <a name="descr"></a>
<td class="contentfont"><?    echo addSpecialChars($auctionDetails['description']); ?>
</td>
</tr>
<tr>
<td><? $getPics=mysql_query("SELECT * FROM probid_auction_images WHERE auctionid='".$auctionDetails['id']."'"); 
$nbPics=mysql_num_rows($getPics); 
if ($auctionDetails['picpath']!="") { ?>
<table width="100%" cellpadding="6" cellspacing="1" border="0">
<tr align="center">
<td valign="top" class="picselect"><table cellpadding="3" cellspacing="1" border="0">
<tr align="center">
<td><b>
<?=$lang[selectapicture];?>
</b></td>
</tr>
<tr align="center">
<td><a href="javascript:doPic('makethumb.php?pic=<?=$auctionDetails['picpath'];?>&w=500&sq=Y');"> <img src="makethumb.php?pic=<?=$auctionDetails['picpath'];?>&w=60&sq=Y" border="1"></a> </td>
</tr>
<?
if ($nbPics>0) { 
while ($addlPicture=mysql_fetch_array($getPics)) { ?>
<tr>
<td><a href="javascript:doPic('makethumb.php?pic=<?=$addlPicture['name'];?>&w=500&sq=Y');"> <img src="makethumb.php?pic=<?=$addlPicture['name'];?>&w=60&sq=Y" border="1"></a> </td>
</tr>
<? }} ?>
</table></td>
<td width="100%" class="picselectmain"align="center"><img name="mainpic" src="makethumb.php?pic=<?=$auctionDetails['picpath'];?>&w=500&sq=Y" border="1" alt="<?=$auctionDetails['itemname'];?>"></td>
</tr>
</table>
<? } ?>
</td>
</tr>
<tr>
<td align="center"><table cellpadding="3" cellspacing="1" border="0" class="counter">
<tr>
<td nowrap><?=$lang[itemviewed]?>
<strong>
<?=$auctionDetails['clicks'];?>
</strong>
<?=$lang[times]?>
</td>
</tr>
</table></td>
</tr>
</table>
<br>
<? if ($setts['enable_asq']=="Y") { ?>
<!-- Header Ask Seller a Question Section (Public and Private questions) -->
<? header5(strtoupper($lang[askseller]));?>
<? $getPublicMsg = mysql_query("SELECT * FROM probid_public_msg WHERE auctionid='".$_GET['id']."' AND msgtype='Q'") or die(mysql_error());
$isPublicMsg = mysql_num_rows($getPublicMsg); 
if ($isPublicMsg>0) { ?>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<? while ($publicMsg = mysql_fetch_array($getPublicMsg)) { ?>
<tr class="c3">
<td width="11" align="center"><img src="themes/<?=$setts['default_theme'];?>/img/system/q.gif"></td>
<td width="60"><strong>
<?=$lang[question];?>
</strong></td>
<td><?=$publicMsg['content'];?></td>
</tr>
<? 
    $answer = getSqlField("SELECT content FROM probid_public_msg WHERE answerid='".$publicMsg['id']."'","content");
    if ($_SESSION['memberid']!=$auctionDetails['ownerid']) {
         if ($answer!=""&&$answer!="n/a") { ?>
<tr class="c2">
<td width="11" align="center"><img src="themes/<?=$setts['default_theme'];?>/img/system/a.gif"></td>
<td width="60"><strong>
<?=$lang[answer];?>
</strong></td>
<td><?=$answer;?></td>
</tr>
<? 
        }
    } else { ?>
<form action="auctiondetails.php" method="get">
<input type="hidden" name="id" value="<?=$_GET['id'];?>">
<input type="hidden" name="answerid" value="<?=$publicMsg['id'];?>">
<tr class="c2">
<td width="11" align="center"></td>
<td><strong>
<?=$lang[answer];?>
</strong></td>
<td><textarea name="content" cols="60" rows="2" class="contentfont"><?=$answer;?>
</textarea>
&nbsp;
<input type="submit" value="<?=$lang[answer];?>" name="postanswerok"></td>
</tr>
</form>
<? } ?>
<tr>
<td align="center" colspan="3" class="c4"><img src="themes/<?=$setts['default_theme'];?>/img/pixel.gif" width="1" height="1"></td>
</tr>
<? } ?>
</table>
<? } ?>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<? if ($_SESSION['membersarea']=="Active"&&$_SESSION['accsusp']!=2) { ?>
 
<? if ($_SESSION['memberid']==$auctionDetails['ownerid']) { ?>
<? if ($isPublicMsg>0) { ?>
<tr class="c2">
<td align="center"><?=$lang[plsanswerqs];?></td>
</tr>
<? } ?>
<? } else if ($auctionDetails['closed']==1) { ?>
<tr class="c2">
<td align="center"><?=$lang[errorauctclosednoq];?></td>
</tr>
<? } else { ?>
<form action="auctiondetails.php" method="get">
<input type="hidden" name="id" value="<?=$_GET['id'];?>">
<tr>
<td><table width="100%" border="0" cellpadding="2" cellspacing="2" align="center" class="border">
<tr class="contentfont" valign="top">
<td class="c2" width="10"><img src="themes/<?=$setts['default_theme'];?>/img/system/i_faq.gif"></td>
<td class="c2" align="right" width="20%"><strong>
<?=$lang[askseller];?>
</strong></td>
<td class="c3"><textarea name="message" cols="40" rows="3" class="contentfont"></textarea></td>
<td class="c3" width="80%"><div style="padding: 2px;">
<select name="question_type">
<? $publicQ = getSqlField("SELECT default_public_questions FROM probid_users WHERE id='".$auctionDetails['ownerid']."'","default_public_questions");
            if ($publicQ == "Y"&&$setts['enable_asq']=="Y") { ?>
<option value="public" selected>
<?=$lang[postqpublic];?>
</option>
<? } ?>
<option value="private">
<?=$lang[postqprivate];?>
</option>
</select>
</div>
<div style="padding: 2px;">
<input name="postquestionok" type="submit" id="postquestionok" value="<?=$lang[submit]?>">
</div></td>
</tr>
</table></td>
</tr>
</form>
<? } ?>
<? } else { ?>
<tr class="c2">
<td align="center" class="contentfont">[ <a href="<?=$path_ssl;?>login.php?auctionid=<?=$_GET['id'];?>">
<?=$lang[logintopostqs];?>
</a> ]</td>
</tr>
<? } ?>
</table>
<br>
<? }
$mainCat_primary = getMainCat($auctionDetails['category']);
$mainCat_secondary = getMainCat($auctionDetails['addlcategory']);
 
$getFields = mysql_query("SELECT DISTINCT f.boxid, f.boxname, f.boxtype, d.boxvalue FROM 
probid_fields_data d, probid_fields f WHERE d.auctionid='".$_GET['id']."' AND f.active='1' AND d.boxid = f.boxid AND 
(f.categoryid='".$mainCat_primary."' OR f.categoryid='".$mainCat_secondary."' OR f.categoryid='0') ORDER BY f.fieldorder ASC") or die(mysql_error()); 
$isFields = mysql_num_rows($getFields);
if ($isFields) { ?>
<!-- Header Additional Custom Fields -->
<? header5(strtoupper($lang[addfields]));?>
<!-- End Header Additional Custom Fields -->
<table width="90%" border="0" cellspacing="1" cellpadding="4" align="center">
<? while ($fields=mysql_fetch_array($getFields)) { $toDisp = ""; ?>
<tr class="<? echo (($count++)%2==0)?"c3":"c2"; ?>">
<td align="right" width="50%"><strong>
<?=$fields['boxname'];?>
</strong></td>
<td><?
    if ($fields['boxtype']=="checkbox") {
        $chkValues = explode(";",$fields['boxvalue']);
        for ($i=0; $i<count($chkValues); $i++) { 
            $chkRes = getSqlField("SELECT boxcaption FROM probid_fields WHERE boxid='".$fields['boxid']."' AND boxvalue='".trim($chkValues[$i])."'","boxcaption");
            $toDisp .= ((trim($chkRes)!="n/a") ? $chkRes : "")."&nbsp; &nbsp; ";
        }    
    } else if ($fields['boxtype']=="radio") {
        $toDisp = getSqlField("SELECT boxcaption FROM probid_fields WHERE boxid='".$fields['boxid']."' AND boxvalue='".$fields['boxvalue']."'","boxcaption")." ";
    } else if ($fields['boxtype']=="list") {
        $toDisp = getSqlField("SELECT boxcaption FROM probid_fields WHERE boxid='".$fields['boxid']."' AND boxvalue='".$fields['boxvalue']."'","boxcaption")." ";
    } else {
        $toDisp = $fields['boxvalue'];
    }
    echo $toDisp;
    ?>
</td>
</tr>
<? } ?>
</table>
<br>
<? } ?>
<!-- Header Payment -->
<? header5(strtoupper($lang[payment]));?>
<!-- End Header Payment -->
<table width="100%" border="0" cellspacing="0" cellpadding="10">
<? if ($auctionDetails['acceptdirectpayment']) { ?>
<tr valign="top">
<td class="c2" align="center"><strong>
<?=$lang[sellerpreferspaypal];?>
</strong><br>
<br>
<img src="http://images.paypal.com/images/x-click-but02.gif" align="absmiddle"> <img src="themes/<?=$setts['default_theme'];?>/img/system/cards.gif" width="280" height="30" align="absmiddle"></td>
</tr>
<? } ?>
<tr valign="top">
<td><?
        $paymentMethods=explode("<br>",$auctionDetails['pm']);
        $nbPaymentMethods=count($paymentMethods);
        ?>
<table border="0" cellspacing="4" cellpadding="4" align="center">
<? 
         for ($i=0;$i<$nbPaymentMethods;$i+=4) { 
            $j=$i+1;
            $k=$i+2;
            $l=$i+3; ?>
<tr valign="top" align="center" style="font: bold;">
<td><? 
             $paymentLogo=getSqlField("SELECT * FROM probid_payment_methods WHERE name='".$paymentMethods[$i]."'","logourl"); 
echo $paymentMethods[$i].(($paymentLogo!=""&&$paymentLogo!="n/a")?"<br><img src=\"".$paymentLogo."\" border=0>":"");?></td>
<td><? 
             $paymentLogo=getSqlField("SELECT * FROM probid_payment_methods WHERE name='".$paymentMethods[$j]."'","logourl");
            echo $paymentMethods[$j].(($paymentLogo!=""&&$paymentLogo!="n/a")?"<br><img src=\"".$paymentLogo."\" border=0>":"");?></td>
<td><? 
             $paymentLogo=getSqlField("SELECT * FROM probid_payment_methods WHERE name='".$paymentMethods[$k]."'","logourl");
echo $paymentMethods[$k].(($paymentLogo!=""&&$paymentLogo!="n/a")?"<br><img src=\"".$paymentLogo."\" border=0>":"");?></td>
<td><? 
             $paymentLogo=getSqlField("SELECT * FROM probid_payment_methods WHERE name='".$paymentMethods[$l]."'","logourl");
echo $paymentMethods[$l].(($paymentLogo!=""&&$paymentLogo!="n/a")?"<br><img src=\"".$paymentLogo."\" border=0>":"");?></td>
</tr>
<? } ?>
</table></td>
</tr>
</table>
<a name="payment"></a>
<!-- Header SHIPPING -->
<? header5(strtoupper($lang[shipping]));?>
<!-- End Header SHIPPING -->
<table width="100%" border="0" cellspacing="1" cellpadding="10">
<tr valign="top">
<td><?
    if ($auctionDetails['sc']=="BP") echo "<li>".$lang[buyerpaysshipment]."</li>";
    else echo "<li>".$lang[sellerpaysshipment]."</li>";
    if ($auctionDetails['scint']=="Y") echo "<li>".$lang[sellershipinternat]."</li>"; 
    else echo "<li>".$lang[seller_not_shipinternat]."</li>";?>
</td>
</tr>
<? if ($setts['shipping_costs']==1) { ?>
<tr valign="top">
<td class="contentfont"><strong>
<?=$lang[postagecosts]?>
:</strong>
<?=displayAmount($auctionDetails['postage_costs'],$auctionDetails['currency'],"YES");?>
<br>
<strong>
<?=$lang[insurance]?>
:</strong>
<?=displayAmount($auctionDetails['insurance'],$auctionDetails['currency'],"YES");?>
<br>
<strong>
<?=$lang[servicetype]?>
:</strong>
<?=$auctionDetails['type_service'];?>
<? if ($auctionDetails['shipping_details']!="") 
         echo "<br><br><strong>$lang[sp_details]</strong><br>".$auctionDetails['shipping_details'];
     ?></td>
</tr>
<? } ?>
</table>
<? 
$getOtherItems = mysql_query("SELECT * FROM probid_auctions WHERE id!='".$auctionDetails['id']."' AND 
active=1 AND closed=0 AND deleted!=1 AND listin!='store' AND ownerid='".$auctionDetails['ownerid']."' ORDER BY rand()"); 
$nbOtherItems = mysql_num_rows($getOtherItems);
 
 
if ($setts['nb_other_items_adp']>0&&$nbOtherItems>0) { 
    $numb = 0;
    $name = array();
    $id = array();
    $pic = array();
    $currency = array();
    $maxbid = array();
    $enddate = array();
    $bidstart = array();
    while ($otherItems = mysql_fetch_array($getOtherItems)) {
        $id[$numb] = $otherItems['id'];
        $name[$numb] = $otherItems['itemname'];
        $pic[$numb] = $otherItems['picpath'];
        $maxbid[$numb] = $otherItems['maxbid'];
        $enddate[$numb] = $otherItems['enddate'];
        $bidstart[$numb] = $otherItems['bidstart'];
        $currency[$numb] = $otherItems['currency'];
        $numb++;
    } ?>
<br>
<table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td align='center' class='topitempage alertfont'><?=$lang[seller_assumes_resp1];?>
<strong>
<?=getSqlField("SELECT username FROM probid_users WHERE id='".$auctionDetails['ownerid']."'","username");?>
</strong>,
<?=$lang[seller_assumes_resp2];?>
</td>
</tr>
</table>
<br />
<!-- Header Other Items -->
<? header5(strtoupper($lang[otheritems]));?>
<table width="100%" border="0" cellspacing="1" cellpadding="10">
<tr valign="top">
<td class="contentfont"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<? 
     $fct = 0;
     for ($k=0;$k<$setts['nb_other_items_adp'];$k++) { 
            $w=100/$setts['nb_other_items_adp'];
            $width=$w."%"; ?>
<td width="<?=$width;?>" align="center" valign="top"><? if ($name[$fct]!="") { ?>
<table width="100%" border="0" cellspacing="5" cellpadding="3">
<tr>
<td height="110" align="center" class="gradient"><a href="<?=$site_url;?>auctiondetails.php?id=<?=$id[$fct];?>"><img src="<? echo (($pic[$fct]!="")?"makethumb.php?pic=".$pic[$fct]."&w=".$layout['w_feat_hp']."&sq=Y":"images/noimg.gif");?>" border="0"></a> </td>
</tr>
<tr class="c1">
<td class="sell"><img src="themes/default/img/arrow1.gif" width="9" height="9" vspace="0" hspace="4" align="absmiddle"><a href="<?=$site_url;?>auctiondetails.php?id=<?=$id[$fct];?>"> <? echo titleResize($name[$fct]);?> </a></td>
</tr>
<tr class="c2">
<td valign="top" class="smallfont"><strong>
<?=$lang[startbid];?>
:</strong> <? echo displayAmount($bidstart[$fct],$currency[$fct]);?><br>
<strong>
<?=$lang[currbid]?>
:</strong> <? echo displayAmount($maxbid[$fct],$currency[$fct]);?><br>
<strong>
<?=$lang[ends]?>
:</strong> <? echo displaydatetime($enddate[$fct],$setts['date_format']); $fct++; ?> </td>
</tr>
</table>
<? } ?></td>
<? } ?>
</tr>
</table></td>
</tr>
</table>
<? } ?>
<? if ($auctionDetails['closed']==0&&$auctionDetails['ownerid']!=$_SESSION['memberid']&&$daysLeft>0&&!$binAuction) { ?>
<!-- Header BID ON THIS ITEM -->
<a name="bid"></a>
<? header5(strtoupper($lang[bidthisitem]));?>
<!-- End Header BID ON THIS ITEM -->
<!-- Body BID ON THIS ITEM -->
<p align="center"><b><font class='redfont'>
<?=$lang[bid_errreg]?>
</font></b></p>
<? header5($lang[memberlogin]); ?>
<? if ($_SESSION['membersarea']!="Active") { 
    if ($setts['is_ssl']==1) {
        echo "<p align=\"center\" class=\"contentfont\">[ <a href=\"".$path_ssl."login.php?auctionid=".$auctionDetails['id']."\"><strong>".$lang[login_secure]."</strong></a> ]</p>";
    } else { ?>
<form action="login.php" method="post">
<input type="hidden" name="auctionid" value="<?=$auctionDetails['id'];?>">
<table width="400" border="0" cellpadding="4" cellspacing="4" align="center" class="border">
<tr class="c3">
<td width="50%" align="right"><?=$lang[username]?></td>
<td width="50%"><input name="username" type="text" id="state4" class="contentfont"></td>
</tr>
<tr class="c2">
<td width="50%" align="right"><?=$lang[pass]?></td>
<td width="50%"><input name="password" type="password" id="state5" class="contentfont"></td>
</tr>
<tr>
<td colspan="2" align="center" class="c4"><input name="loginok" type="submit" id="loginok" value="<?=$lang[memberlogin]?>"></td>
</tr>
<tr class="c2">
<td colspan="2" align="center" class="contentfont"><a href="<?=$path_ssl;?>register.php">
<?=$lang[signupnow]?>
</a></td>
</tr>
</table>
</form>
<?     }
} else { 
    if (!$binAuction) { ?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<form action="bid.php" method="post">
<tr class="c4">
<td colspan="2"><b>
<?=$auctionDetails['itemname'];?>
</b></td>
</tr>
<tr class="c5">
<td colspan="2"><img src="themes/<?=$setts['default_theme'];?>/img/pixel.gif" width="1" height="1"></td>
</tr>
<tr class="c3">
<td><?=$lang[currbid]?>
:</td>
<td width="100%"><font class='redfont'><b><? echo displayAmount($auctionDetails['maxbid'],$auctionDetails['currency']);?></b></font></td>
</tr>
<? if ($auctionDetails['auctiontype']=="dutch") { ?>
<tr class="c2">
<td><?=$lang[quant]?>
:</td>
<td><input name="quantity" type="text" id="quantity" value="1" size="8"></td>
</tr>
<? } ?>
<tr class="c2">
<td nowrap><?=$lang[yourmaxbid]?>
:</td>
<td width="100%"><strong>
<?=$auctionDetails['currency'];?>
</strong>
<input name="maxbid" type="text" id="maxbid" size="15">
&nbsp;&nbsp;
<?=$lang[minbid]?>
:
<? 
        if ($auctionDetails['auctiontype']=="standard") {
            if ($auctionDetails['maxbid']==0) $minimumBid = $auctionDetails['bidstart'];
            else $minimumBid = setMinBid($auctionDetails['maxbid'],$auctionDetails['bi'],$auctionDetails['bivalue'],$auctionDetails['auctiontype']);
            echo displayAmount($minimumBid,$auctionDetails['currency']);
        } else {
            $maximumBid = $auctionDetails['maxbid'];
            $getBids = mysql_query("SELECT * FROM probid_bids WHERE 
            bidamount='".$maximumBid."' AND auctionid='".$auctionDetails['id']."'");
            $quantity = 0;
            while ($bids = mysql_fetch_array($getBids)) {
                $quantity += $bids['quantity'];
            }
            if ($auctionDetails['maxbid']==0) $minimumBid=$auctionDetails['bidstart'];
            else if ($quantity<$auctionDetails['quantity']) $minimumBid=$auctionDetails['maxbid'];
            else $minimumBid=setMinBid($auctionDetails['maxbid'],$auctionDetails['bi'],$auctionDetails['bivalue'],$auctionDetails['auctiontype']);
            echo displayAmount($minimumBid,$auctionDetails['currency']);
        } ?>
<input type="hidden" name="itemname" value="<?=remSpecialChars($auctionDetails['itemname']);?>">
<input type="hidden" name="auctionid" value="<?=$auctionDetails['id'];?>">
<input type="hidden" name="action" value="bid_CONF">
<input type="hidden" name="quant_avail" value="<?=$auctionDetails['quantity'];?>">
</td>
</tr>
<tr class="c3">
<td>&nbsp;</td>
<td width="100%"><input name="placebidok" type="submit" id="placebidok" value="<?=$lang[placebid]?>"></td>
</tr>
</form>
</table>
<?                 } 
            } 
        } 
        else if ($auctionDetails['ownerid']==$_SESSION['memberid']&&$auctionDetails['closed']==0&&!$binAuction) echo $lang[biderr_youpost];
        else if ($auctionDetails['closed']!=0&&!$binAuction) echo $lang[biderr_bidclosed];
        else if ($daysleft<=0&&!$binAuction) echo $lang[biderr_bidclosed];
        else if ($binAuction) echo $lang[buynowonlyauctionalalert];
    }?>
<? } else { 
    header5($lang[auctdetserror]);
    echo "<p align=center><strong>$lang[aucterrormsg]</strong></p>";
    $auctionSusp = getSqlNumber("SELECT id FROM probid_auctions WHERE id='".$_GET['id']."' AND active='0'");
    if ($auctionSusp)
        echo "<p align=center><strong>$lang[aucterrorsellermsg]</strong></p>";
}
include ("themes/".$setts['default_theme']."/footer.php"); ?>

grandmastr · #4 (**permalink**) 03-17-06, 02:39 AM

I have the same problem

Is there a fix for this?

ThaiAuto · #5 (**permalink**) 05-19-06, 11:04 PM

Try to cut condition AND out=0 from line 549
I don't know if it effect to others display result. Then you line 549 will becomes

$getBidderId=mysql_query("SELECT * FROM probid_bids WHERE auctionid='".$auctionDetails['id']."' AND invalid=0 ORDER BY id DESC");

ThaiAuto · #6 (**permalink**) 05-20-06, 12:01 AM

Both errrors come from the field name out
try to change it to be, for example, exout then your .sql file line containing out will be like this
`exout` tinyint(4) NOT NULL default '0',

Then the auctiondetail.php line 549 will become

$getBidderId=mysql_query("SELECT * FROM probid_bids WHERE auctionid='".$auctionDetails['id']."' AND exout=0 AND invalid=0 ORDER BY id DESC");

And the bidhistory.php wil become
Line 55,56
$getBidHistory = mysql_query("SELECT h.* FROM probid_bids_history h, probid_bids b WHERE
h.auctionid='".$_GET['id']."' AND h.bidid=b.id ORDER BY b.exout ASC, h.id DESC");

Line 64
$isOut = getSqlField("SELECT exout FROM probid_bids WHERE id='".$bidHistory['bidid']."'","exout");

Line 73
echo (getSqlField("SELECT rpwinner FROM probid_bids WHERE id='".$bidHistory['bidid']."'","rpwinner")>0&&getSqlField("SELECT exout FROM probid_bids WHERE id='".$bidHistory['bidid']."'","exout")!=1) ? "[ <span class=greenfont>$lang[fixedpricewinner]</span> ]" : "";

Please let me know the result too.

ThaiAuto · #7 (**permalink**) 05-20-06, 12:33 AM

Or you can just add the quote to the out
Then the auctiondetail.php line 549 will become

$getBidderId=mysql_query("SELECT * FROM probid_bids WHERE auctionid='".$auctionDetails['id']."' AND 'out'=0 AND invalid=0 ORDER BY id DESC");

Syntax error phpprobid

Internet Services

Website Development

Tech Hardware