Parašė edeni· 2010 Vas. 28 19:02:41
#9
if(iMEMBER) {
openside("Pakviesk draugа, per savo nuorodа");
echo "Tavo nuoroda: http://tavosaitas.lt/invite.php?....$userdata['user_id']."";
$result1 = dbquery("SELECT * FROM `".DB_PREFIX."invites` GROUP by `invite_user_id` ORDER by COUNT(*) DESC LIMIT 5");
echo "<table class='tbl-border' width='100%'>";
while ($data = dbarray($result1)) {
$time = dbrows(dbquery("SELECT * FROM `".DB_PREFIX."invites` WHERE `invite_user_id`='".$data['invite_user_id']."'"));
$data2 = dbarray(dbquery("SELECT * FROM `".DB_PREFIX."users` WHERE `user_id`='".$data['invite_user_id']."'"));
echo "<tr><td class='tbl2' align='left'>
<a href='".BASEDIR."profile.php?lookup=".$data2['user_id']."'
title='Perюiыrлti ".$data2['user_name']." profilб'>".$data2['user_name']."</a></td><td align='right' class='tbl1'>
$time</td></tr> ";
}
echo "</table>";
$result2 = dbrows(dbquery("SELECT * FROM `".DB_PREFIX."invites` WHERE `invite_user_id`='".$userdata['user_id']."'"));
openside("Pakvietei");
echo "Tu jau pakvietęs <b>$result2</b> draugus";
closeside();
}else{
openside("Daugiausiai pakvietė");
$result1 = dbquery("SELECT * FROM `".DB_PREFIX."invites` GROUP by `invite_user_id` ORDER by COUNT(*) DESC LIMIT 5");
echo "<table class='tbl-border' width='100%'>";
while ($data = dbarray($result1)) {
$time = dbrows(dbquery("SELECT * FROM `".DB_PREFIX."invites` WHERE `invite_user_id`='".$data['invite_user_id']."'"));
$data2 = dbarray(dbquery("SELECT * FROM `".DB_PREFIX."users` WHERE `user_id`='".$data['invite_user_id']."'"));
echo "<tr><td class='tbl2' align='left'>
<a href='".BASEDIR."profile.php?lookup=".$data2['user_id']."'
title='Perюiыrлti ".$data2['user_name']." profilб'>".$data2['user_name']."</a></td><td align='right' class='tbl1'>
$time</td></tr> ";
}
echo "</table>";
closeside();
}
Pamegink
Redagavo edeni· 2010 Vas. 28 19:02:52