WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė dovis777· 2012 Kov. 18 21:03:25

Sveiki gal galėtumėte pakeisti šią panelę, kad svečiams nerodytu - tu pakvietęs 0 narių.

Panelė atrodo taip

Pakvietusių top 5:
Tu jau pakvietęs 2 draugus
Vardas	 2
Vardas	 1

openside("Pakvietusių top 5");
$result = dbrows(dbquery("SELECT * FROM `".DB_PREFIX."invites` WHERE `invite_user_id`='".$userdata['user_id']."'"));
echo "Tu jau pakvietęs <b>$result</b> draugus";    
$result = 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($result)) {
   $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&#254;i&#251;r&#235;ti ".$data2['user_name']." profil&#225;'>".$data2['user_name']."</a></td><td align='right' class='tbl1'>
   $time</td></tr>";
   }
   echo "</table>";
   closeside();

Parašė Wasiulis· 2012 Kov. 19 01:03:51

openside("Pakvietusių top 5");
 
$result = dbrows(dbquery("SELECT * FROM `".DB_PREFIX."invites` WHERE `invite_user_id`='".$userdata['user_id']."'"));
 
if (iGUEST) { echo ""; } else {
echo "Tu jau pakvietęs <b>$result</b> draugus"; 
}
$result = 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($result)) {
 
   $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&#254;i&#251;r&#235;ti ".$data2['user_name']." profil&#225;'>".$data2['user_name']."</a></td><td align='right' class='tbl1'>
 
   $time</td></tr>";
 
   }
 
   echo "</table>";
 
   closeside();