Buddylist

**Guest** · 27.07.08, 15:18

Bro i saw ya recodings..... Use the oraginal codings its wrking

//////////////////////////////////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 "";
//echo "<img src=\"logos/buddylist.gif\" alt=\"buddylist\"/>
";
$bmsg = parsemsg(getbudmsg($uid), $sid);
if($bmsg!="")
{echo "($bmsg)";}else
{echo "";}
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='".$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";

echo "";
$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 "";
echo "";
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"lists.php?action=buds&page=$ppage&s id=$sid&view=$view\">«Prev</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"lists.php?action=buds&page=$npage&s id=$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 "";
////// UNTILL HERE >>
echo "";
echo "<a href=\"lists.php?action=buds&sid=$sid\">Refres h</a>
";
echo "<a href=\"inbox.php?action=popupto&sid=$sid\">Sen d Popup</a>
";
echo "<a href=\"inbox.php?action=popdialog&sid=$sid\">P opup Dialog</a>
";
$popmsgs = mysql_fetch_array(mysql_query("SELECT popmsg FROM ibwf_users WHERE id='".$uid."'"));
if($popmsgs[0]==0){
echo "<a href=\"index.php?action=popenable&sid=$sid\">E nable Popups</a>
";
}else{
echo "<a href=\"index.php?action=popdisable&sid=$sid\"> Disable Popups</a>
";
}
echo "<a href=\"index.php?action=chbmsg&sid=$sid\">Chan ge Mood</a>
";
echo "<a href=\"inbox.php?action=main&sid=$sid\">Inbox</a>
";
echo "<a href=\"index.php?action=chat&sid=$sid\">Chatro oms</a>
";
echo forumlink($sid);
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"../images/home.gif\" alt=\"\"/>Home</a>";
echo "";
echo "</card>";
}

**inet** · 29.07.08, 07:43

bro i think you use the same sever with some of the filipino wap leaders..

bro in the current script you use the problem is in the queries i think.. some queries makes browsing slow..
that was the main problem in your old rpg page.. lol just fix the errors ..
i still remember playing in that page refreshes the page in a slow mode..

bro congrats is your second year?

when i browse your site i feel i am in a slow world... theres a remedy on that..

i experienced that one time.

**thanatos** · 29.07.08, 12:34

bro i think you use the same sever with some of the filipino wap leaders..
bro in the current script you use the problem is in the queries i think.. some queries makes browsing slow..
that was the main problem in your old rpg page.. lol just fix the errors ..
i still remember playing in that page refreshes the page in a slow mode..

bro congrats is your second year?
when i browse your site i feel i am in a slow world... theres a remedy on that..

i experienced that one time.[/b]

fixed already my rpg.. made some other options too

its not my second year bro.. i started building my site just a year ago. so its only a year up to now.

so what could be the remedy for queries that causes my site too slow?

**inet** · 31.07.08, 05:48

fixed already my rpg.. made some other options too

its not my second year bro.. i started building my site just a year ago. so its only a year up to now.

so what could be the remedy for queries that causes my site too slow?

[/b]

bro i just want to share this thing..

-------------------------------from yahoo answers------------
min0taur p

Undecided Question
Show me another »
How to minimize database queries.. My wap site http://pinoywap.net has this problem?
2 months ago (Tiebreaker)

-----------------------------------------you got the same problem with min0taur

yes i got this the same news somewhere hehehe this information will help you much!

Budget: $ 20-100
Project Creator: min0taur

Rating: (No Feedback Yet)
Required Skills: Database Development, MySQL, PHP, Programming
Attached Files: (None)

NEW
SEND
DISCUSS
CONTACT
OPTIONS

Description
I have a wapsite http://pinoywap.net (WML and XHTML) and I always got mysql and server problems. The site gets all the server loads and small servers will crash. My host says that the problem is on my php script mysql queries. Im new in this field so dont know how to decrease my site server loads. I want mysql and php expert to help me fix my site server loads or mysql problem

Profile

Quick Links
Main Page http://www.getacoder.com/buyer/min0taur/

Location: Daet, Philippines
Employees: n/a

Description:
Description not yet provided.

Buddylist

Buddylist

Comment

Comment

Comment

Comment