$viso_nariu = dbcount("(user_id)", DB_USERS);   //infomacija
echo $viso_nariu;   //atvaizdavimas
 
$viso_nariu = dbcount("(user_id)", DB_USERS);    //kiek nariu turime
 
$visoadminubendrai = dbcount("(user_id)", DB_USERS, "user_level>'101'");  //super adminai ir adminai   
 
$viso_superadminu = dbcount("(user_id)", DB_USERS, "user_level='103'");   //super adminu     
 
$viso_adminu = dbcount("(user_id)", DB_USERS, "user_level='102'");  //administratoriu
 
$vienos_dienos_nariai = dbcount("(user_id)", DB_USERS, "(user_lastvisit - user_joined) < '8601'  && user_status = '0'");     
 
$nariu_permetus = dbcount("(user_id)", DB_USERS, "(user_lastvisit + '31536000') < $time  && user_status = '0'");  // nariai prisijunge per metus     
 
$nariai_bepostu = dbcount("(user_id)", DB_USERS, "(user_lastvisit + '31536000') < $time  && user_posts = '0' && user_status = '0'");     //nariai neparase pranesimu per metus
 
 $nariai_perdumetus = dbcount("(user_id)", DB_USERS, "(user_lastvisit + '63072000') < $time  && user_status = '0'");  //nariai prisijunge pries 2 metus
 
$nariai_neprisijunge = dbcount("(user_id)", DB_USERS, "user_lastvisit = '0'  && user_status = '0'"); //niekada neprisijunge nariai
 
$nariai_aktyvus = dbcount("(user_id)", DB_USERS, "(user_lastvisit + '15768000') < $time && user_posts !='0' && user_status = '0'");   //nariai prisijunge per paskutinius 6 menesius ir kanors parase forume
 
$nario_pranesimas = dbcount("(user_id)", DB_USERS, "user_posts = '0'  && user_status = '0'");   //nariai nieko neparase  
 
$nariai_parase = dbcount("(user_id)", DB_USERS, "user_posts != '0'  && user_status = '0'");   //nariai kanors parase  
 
$pprocentaliai = round($nariai_parase*100/$viso_nariu); //procentaliai parase nariai, reikalingas $viso_nariu kintamasis auksciau
 
$nariu_temos = dbcount("(user_id)", DB_USERS, "user_theme != 'Default'  && user_status = '0'"); //nariai pasikeite pagrindini dizaina
 
$narioemali = dbcount("(user_id)", DB_USERS, "user_hide_email = '0'  && user_status = '0'"); // nariai pasislepe savo el. pasta
 
$avatarai = dbcount("(user_id)", DB_USERS, "user_avatar != ''  && user_status = '0'");  //nariai su avataru
 
$webai = dbcount("(user_id)", DB_USERS, "user_web != ''  && user_status = '0'");  //nariai turintys saitus      
 
$uzbanintupost = dbcount("(user_id)", DB_USERS, "user_status = '1' && user_posts != '0'");  //uzbanintu nariu pranesimu
 
$banned = dbcount("(user_id)", DB_USERS, "user_status = '1'");    //uzbanintu nariu
 
$blacklist = dbcount("(blacklist_id)", DB_BLACKLIST);   //juodajame sarase nariu
 
$blacklistips = dbcount("(blacklist_ip)", DB_BLACKLIST, "blacklist_ip != ''");   //juodajame sarase ip
 
$pmr = dbcount("(message_id)", DB_MESSAGES, "message_read = '1'");   // viso perskaitytu privaciu zinuciu 
 
$pmnr = dbcount("(message_id)", DB_MESSAGES, "message_read = '0'"); //viso neperskaitytu zinuciu
 
Parsed in 0.102 seconds, using GeSHi 1.0.8.10