catlistings.php - (Pro Bid 5.5)

[restartcom]

Boa tarde meus queridos do forum!!!

Peço gentilmente, que me ajudem a descobrir e corrigir esses dois erros que ocorre na linha 132 e na linha 164 desse script abaixo, ou se existe alguma outra coisa a ser feito, que não tenha percebido...

O nome do arquivo é "catlisting.php" da loja virtual probid v5.5

Abaixo copiei os dois erros e colei o script completo para vossa analise...

Agradeço muito se alguém puder me ajudar a resolver essa situação, ou

se alguém tiver esse script dessa versão de loja funcionando, por favor envie para mim!!!

_________________________________________________________________________________________________________

Warning: implode() [function.implode]: Invalid arguments passed in /home/megaprom/public_html/leilao/catlistings.php on line 132

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/megaprom/public_html/leilao/catlistings.php on line 164

________________________________________________________________________________________________________

<?

## v5.23 -> dec. 13, 2005

if (!eregi("categories.php",$_SERVER['PHP_SELF'])) header("Location: categories.php?show=subcats");

$parent=$_REQUEST['parent'];

if($parent > 0) {

$croot = $parent;

$nav = "";

$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'];

}

$navigation = "<a href=\"categories.php?show=subcats\"><b>$lang[cat]:</b></a> $nav";

}

headercat( $navigation );

if ($nbFeatItems>0) { ?>

<table width=100%" border="0" cellpadding="0" cellspacing="0">

<?

$numb=0;

for ($i=0;$i<$j;$i++) { ?>

<tr>

<? for ($k=0;$k<$layout['nb_feat_cat];$k++) {

$w=100/$layout['nb_feat_cat'];

$width=$w."%"; ?>

<td width=<?=$width;?>" align="center" valign="top"> <? if ($name[$numb]!="") { ?>

<table width="100%" border="0" cellspacing="5" cellpadding="3">

<tr>

<td height="110" align="center" class="gradient"><a href="<?=$path;?>auctiondetails.php?id=<?=$fid[$numb];?>"><img src="<? echo (($pic[$numb]!="")?"makethumb.php?pic=".$pic[$numb]."&w=".$layout['w_feat_cat]."&sq=Y&b=Y":"themes/".$setts['default_theme']."/img/system/noimg.gif");?>" border=0"></a> </td>

</tr>

<tr class="c1">

<td class="sell"><?=$imgarrwhite;?>

<a href="<?=$path;?>auctiondetails.php?id=<?=$fid[$numb];?>">

<?=$name[$numb];?>

</a></td>

</tr>

<tr class="c2">

<td valign="top" class="smallfont"><strong>

<?=$lang[currbid]?>

:</strong> <? echo displayAmount(getSqlField("SELECT * FROM probid_auctions WHERE id='".$fid[$numb]."'","maxbid"),$currency[$numb]);?><br>

<strong>

<?=$lang[ends]?>

:</strong> <? echo displaydatetime(getSqlField("SELECT * FROM probid_auctions WHERE id='".$fid[$numb]."'","enddate"),$setts['date_format]);

$numb++; ?> </td>

</tr>

</table>

<? } ?></td>

<? } ?>

</tr>

<? } ?>

</table>

<? } ?>

<!-- End Items pics -->

<table width="100%" border="0" cellspacing="2" cellpadding="0">

<tr>

<? $isSubcats = getSqlNumber("SELECT id FROM probid_categories WHERE parent='".$_REQUEST['parent']."'");

if ($isSubcats>0) { ?>

<td width=150" valign="top"> <table width="100%" border="0" cellpadding="3" cellspacing="0" class="contentfont">

<tr>

<td class="c4"><img src="themes/<?=$setts['default_theme];?>/img/pixel.gif" width="1" height="3"></td>

<td class="c3" width="100%"><img src="themes/<?=$setts['default_theme'];?>/img/pixel.gif" width=1" height="3"></td>

</tr>

<? $getSubCategories=mysql_query("SELECT id,items_counter, hidden, parent FROM probid_categories WHERE parent='".$_REQUEST['parent]."' ORDER BY theorder ASC, name ASC");

while ($subCategories=mysql_fetch_array($getSubCategories)) {

if ($subCategories['hidden']==1&&$subcategories['parent']==0) {

## do nothing (v5.23 addition)

} else { ?>

<tr>

<td class=c3">   </td>

<td class="c2" width="100%"><a href="categories.php?parent=<?=$subCategories['id];?>"><? echo $c_lang[$subCategories['id']]?></a> <? echo ($subCategories['items_counter']>0) ? "(".$subCategories['items_counter'].")":"";?></td>

</tr>

<? }

} ?>

</table></td>

<? } ?>

<td valign=top"> <table width="100%" border="0" cellspacing="1" cellpadding="3">

<tr class="c1">

<td width="50" align="center" class="submenu"><?=$lang[picture]?></td>

<td align="center" class="submenu"><a href="categories.php?parent=<?=$_REQUEST['parent];?>&start=<?=$_REQUEST['start'];?>&orderField=itemname&orderType=<?=$newOrder;?>"><?=$lang[auc_name]?></a></td>

<td width=60" align="center" class="submenu"><a href="categories.php?parent=<?=$_REQUEST['parent];?>&start=<?=$_REQUEST['start'];?>&orderField=maxbid&orderType=<?=$newOrder;?>"><?=$lang[lastbid]?></a></td>

<td width=40" align="center" class="submenu"><a href="categories.php?parent=<?=$_REQUEST['parent];?>&start=<?=$_REQUEST['start'];?>&orderField=nrbids&orderType=<?=$newOrder;?>"><?=$lang[bids]?></a></td>

<td width=130" align="center" class="submenu"><a href="categories.php?parent=<?=$_REQUEST['parent];?>&start=<?=$_REQUEST['start'];?>&orderField=enddate&orderType=<?=$newOrder;?>"><?=$lang[endsin]?></a></td>

</tr>

<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>

<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>

<td><img src="themes/<?=$setts['default_theme];?>/img/pixel.gif" width="1" height="1"></td>

</tr>

<?

// newest function

if ($_GET['start'] == "") $start = 0;

else $start = $_GET['start'];

$limit = 20;

$croot = $_REQUEST['parent'];

$cntr=0;

while ($croot>0) {

$crw = getSqlRow("SELECT * FROM probid_categories WHERE id=$croot'");

if($cntr == 0) {

$catname = $crw['name];

} else {

if($crw['parent'] != $croot) {

$catname = "$crw[name] : $catname";

}

}

$cntr++;

$croot = $crw['parent'];

}

$catname = trim($catname);

## get all subcats

asort($cat_array);

if ($catname!=") {

while (list($cat_array_id, $cat_array_name)=each($cat_array)) {

$strResult = strpos($cat_array_name,$catname);

if (trim($strResult)=="0") $cat_id[$catcnt++] = $cat_array_id;

}

$all_subcats = implode (",",$cat_id);

$subcatquery="(a.category IN (".$all_subcats.") OR a.addlcategory IN (".$all_subcats.")) AND ";

} else {

$subcatquery = "";

}

$mysqlVersion = substr(mysql_get_server_info(),0,1);

if ($mysqlVersion>=4) {

$additionalQuery = "SQL_CALC_FOUND_ROWS ";

} else {

## this is only used if the mySql is older than v4. Slower version

$nbItems = getSqlNumber("SELECT DISTINCT a.id, a.itemname, a.picpath, a.maxbid, a.currency,

a.nrbids, a.enddate FROM probid_auctions a WHERE

".$subcatquery."

a.active=1 AND a.closed=0 AND a.deleted!=1 AND a.listin!='store'

ORDER BY a.".$orderField." ".$orderType);

}

$getAuctions = mysql_query("SELECT ".$additionalQuery." DISTINCT a.id, a.itemname, a.picpath, a.maxbid, a.currency,

a.nrbids, a.enddate FROM probid_auctions a WHERE

".$subcatquery."

a.active=1 AND a.closed=0 AND a.deleted!=1 AND a.listin!='store'

ORDER BY a.".$orderField." ".$orderType." LIMIT $start,$limit");

if ($mysqlVersion>=4) $nbItems = mysql_result(mysql_query("Select FOUND_ROWS() AS nbr"),0,"nbr");

if ($nbItems==0) {

echo "<tr><td colspan=5 class=contentfont align=center>".$lang[noauct]."</td></tr>";

} else {

if ($nbItems>($start+$limit)) $final = $start+$limit;

else $final = $nbItems;

while ($auction = mysql_fetch_array($getAuctions)) { ?>

<tr class="<? echo (($count++)%2==0)?"c2":"c3"; ?>">

<td align="center"><?

if ($auction['picpath]!="") {

echo "<a href=\"auctiondetails.php?id=".$auction['id']."\"><img src=\"makethumb.php?pic=.$auction['picpath]."&w=40&sq=Y&b=Y\" border=0></a>";

} else echo "N/A"; ?> </td>

<td nowrap="nowrap" class=contentfont><span class="<? echo setStyle($auction['id']);?>"><a href=auctiondetails.php?id=<?=$auction['id];?>">

<?=$auction['itemname'];?>

</a> <? echo itemPics($auction['id']);?></span> </td>

<td align=center" class=contentfont><? echo displayAmount($auction['maxbid],$auction['currency']);?> </td>

<td class=contentfont align=center"><b>

<?=$auction['nrbids];?>

</b> </td>

<td align="center" class=contentfont><? echo timeleft($auction['enddate'],$setts['date_format']);?></td>

</tr>

<? } ?>

<tr>

<td colspan=5 class=contentfont align=center><?

paginate($start,$limit,$nbItems,"categories.php","&parent=.$_REQUEST['parent]."&orderField=$orderField&orderType=$orderType");

?></td>

</tr>

<? }?>

</table></td>

</tr>

</table>

Editado Fevereiro 16, 2010 por restartcom