My Budylist Cant Open

[Guest]

last time it can be opened..(neva edit anything)

[amylee]

copy n paste the buddylist section of script here

[Guest]

//////////////////////////////////Buddies

else if($action=="buds")
{
addonline(getuid_sid($sid),"Viewing My Buddies List","lists.php?action=buds");
echo "<card id=\"main\" title=\"Buddies\">";
$uid = getuid_sid($sid);
echo "<p align=\"center\">";
//echo "<img src=\"logos/buddylist.gif\" alt=\"buddylist\"/>
";
$bmsg = parsemsg(getbudmsg($uid), $sid);
if($bmsg!="")
{echo "($bmsg)</p>";}else
{echo "</p>";}
echo popup($sid);
//////ALL LISTS SCRIPT <<
if($page=="" || $page<=0)$page=1;
$num_items = getnbuds($uid); //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.name, b.place, b.userid FROM ibwf_users a
INNER JOIN ibwf_online b ON a.id = b.userid
GROUP BY 1,2
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=&#39;".$uid."&#39; OR b.tid=&#39;".$uid."&#39;) AND b.agreed=&#39;1&#39; AND a.id!=&#39;".$uid."&#39; 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&amp;who=$item[2]&amp;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&amp;page=$ppage&amp;s id=$sid&amp;view=$view\">«Prev</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"lists.php?action=buds&amp;page=$npage&amp;s id=$sid&amp;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=\"lists.php?action=buds&amp;sid=$sid\">Refres h</a>
";
echo "<a href=\"inbox.php?action=popupto&amp;sid=$sid\">Sen d Popup</a>
";
echo "<a href=\"inbox.php?action=popdialog&amp;sid=$sid\">P opup Dialog</a>
";
$popmsgs = mysql_fetch_array(mysql_query("SELECT popmsg FROM ibwf_users WHERE id=&#39;".$uid."&#39;"));
if($popmsgs[0]==0){
echo "<a href=\"index.php?action=popenable&amp;sid=$sid\">E nable Popups</a>
";
}else{
echo "<a href=\"index.php?action=popdisable&amp;sid=$sid\"> Disable Popups</a>
";
}
echo "<a href=\"index.php?action=chbmsg&amp;sid=$sid\">Chan ge Mood</a>
";
echo "<a href=\"inbox.php?action=main&amp;sid=$sid\">Inbox</a>
";
echo "<a href=\"index.php?action=chat&amp;sid=$sid\">Chatro oms</a>
";
echo forumlink($sid);
echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"../images/home.gif\" alt=\"\"/>Home</a>";
echo "</p>";
echo "</card>";
}

[subzero]

nothing to do with your script

11.16.0-CURRENT 18546 (CPANEL)

it not working with newer cpanels

[Guest]

nothing to do with your script

11.16.0-CURRENT 18546 (CPANEL)

it not working with newer cpanels[/b]

whats u mean??

[quiksilverX]

Does any1 know how to fix this? Coz im getting da same error nw!

[SiLeNce]

$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=&#39;".$uid."&#39; OR b.tid=&#39;".$uid."&#39;) AND b.agreed=&#39;1&#39; AND a.id!=&#39;".$uid."&#39; GROUP BY 1,2 ORDER BY a.lastact DESC LIMIT $limit_start, $items_per_page";[/b]

just changing to

$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=&#39;".$uid."&#39; OR b.tid=&#39;".$uid."&#39;) AND b.agreed=&#39;1&#39; AND a.id!=&#39;".$uid."&#39; GROUP BY 2,1 ORDER BY a.lastact DESC LIMIT $limit_start, $items_per_page";[/b]

// try ..