$reitingas = 1; //1 - rodomas nariu TOP pagal reitinga, 0 - nerodomas nariu TOP pagal reitinga openside("TOP nariai"); if ($reitingas == 1) { echo "

Pagal reitingą

\n"; $result = dbquery("SELECT user_id, user_name FROM ".$db_prefix."reitingai LEFT JOIN ".DB_USERS." ON reitingas_nariui=user_id WHERE reitingas_tipas='N' GROUP BY user_id ORDER BY SUM(reitingas_balsas) DESC LIMIT 0,5"); if (dbrows($result)) { while ($data = dbarray($result)) { $reitingas = dbresult(dbquery("SELECT SUM(reitingas_balsas) FROM ".$db_prefix."reitingai WHERE reitingas_nariui='".$data['user_id']."' && reitingas_tipas='N'"), 0); $reitingas == "" ? $reitingas = 0 : ""; echo "

".trimlink($data['user_name'], 25)." [".$reitingas."]

\n"; } } $limit = "0,5"; } else { $limit = "0,10"; } echo "

Pagal gautų reitingų vidurkį

\n"; $result = dbquery("SELECT user_id, user_name FROM ".$db_prefix."reitingai LEFT JOIN ".DB_USERS." ON reitingas_nariui=user_id GROUP BY user_id ORDER BY SUM(reitingas_balsas) DESC LIMIT ".$limit); if (dbrows($result)) { while ($data = dbarray($result)) { $reitingas = dbresult(dbquery("SELECT SUM(reitingas_balsas) FROM ".$db_prefix."reitingai WHERE reitingas_nariui='".$data['user_id']."'"), 0); $reitingas == "" ? $reitingas = 0 : ""; echo "

".trimlink($data['user_name'], 25)." [".$reitingas."]

\n"; } } closeside();