how do u let a buddylist display eg.
buddylist(1/0)
buddylist(1/0)
$sql = "SELECT a.lastact, a.name, a.id, b.uid, b.tid, b.reqdt FROM ibwf_users a INNER JOIN ibwf_buddies b ON (a.id = b.uid) OR (a.id=b.tid) WHERE (b.uid='".$uid."' OR b.tid='".$uid."') AND b.agreed='1' AND a.id!='".$uid."' GROUP BY 1,2 ORDER BY a.lastact DESC LIMIT $limit_start, $items_per_page";
$sql = "SELECT a.lastact, a.name, a.id, b.uid, b.tid, b.reqdt FROM ibwf_users a INNER JOIN ibwf_buddies b ON (a.id = b.uid) OR (a.id=b.tid) WHERE (b.uid='".$who."' OR b.tid='".$who."') AND b.agreed='1' AND a.id!='".$who."' GROUP BY 1,2 ORDER BY a.lastact DESC LIMIT $limit_start, $items_per_page";
else if($action=="buds") { addonline(getuid_sid($sid),"Viewing Buddies List","lists.php?action=buds"); echo "<card id=\"main\" title=\"Buddies\">"; $who = $_GET["who"]; echo "<p align=\"center\">"; //echo "<img src=\"logos/buddylist.gif\" alt=\"buddylist\"/> "; //////ALL LISTS SCRIPT << if($page=="" || $page<=0)$page=1; $num_items = getnbuds($who); //changable $items_per_page= 10; $num_pages = ceil($num_items/$items_per_page); if(($page>$num_pages)&&$page!=1)$page= $num_pages; $limit_start = ($page-1)*$items_per_page; //changable sql $sql = "SELECT a.lastact, a.name, a.id, b.uid, b.tid, b.reqdt FROM ibwf_users a INNER JOIN ibwf_buddies b ON (a.id = b.uid) OR (a.id=b.tid) WHERE (b.uid='".$who."' OR b.tid='".$who."') AND b.agreed='1' AND a.id!='".$who."' GROUP BY 1,2 ORDER BY a.lastact DESC LIMIT $limit_start, $items_per_page"; echo "<p align=\"center\">"; $items = mysql_query($sql); echo mysql_error(); if(mysql_num_rows($items)>0) { while ($item = mysql_fetch_array($items)) { if(isonline($item[2])) { $iml = "<img src=\"../images/onl.gif\" alt=\"+\"/>"; }else{ $iml = "<img src=\"../images/ofl.gif\" alt=\"-\"/>"; } $bmsg = parsemsg(getbudmsg($item[2]), $sid); if($bmsg!="") { $budmood="($bmsg)"; }else{ $budmood=""; } $lnk = "<a href=\"index.php?action=viewuser&who=$item[2]&sid=$sid\">$iml$item[1]</a>$budmood"; echo "$lnk "; } } echo "</p>"; echo "<p align=\"center\">"; if($page>1) { $ppage = $page-1; echo "<a href=\"lists.php?action=buds&page=$ppage&sid=$sid&view=$view\">«Prev</a> "; } if($page<$num_pages) { $npage = $page+1; echo "<a href=\"lists.php?action=buds&page=$npage&sid=$sid&view=$view\">Next»</a>"; } echo " $page/$num_pages "; if($num_pages>2) { $rets = "Jump to page<input name=\"pg\" format=\"*N\" size=\"3\"/>"; $rets .= "<anchor>[GO]"; $rets .= "<go href=\"lists.php\" method=\"get\">"; $rets .= "<postfield name=\"action\" value=\"$action\"/>"; $rets .= "<postfield name=\"sid\" value=\"$sid\"/>"; $rets .= "<postfield name=\"page\" value=\"$(pg)\"/>"; $rets .= "</go></anchor>"; echo $rets; } echo "</p>"; ////// UNTILL HERE >> echo "<p align=\"center\">"; echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"../images/home.gif\" alt=\"\"/>Home</a>"; echo "</p>"; echo "</card>"; }
Comment