overmind Posted December 10, 2006 Report Share Posted December 10, 2006 Šodien aiz garlaicības uzcepu šādu te scriptiņu, amxbans aktīvāko banotāju TOP 10 Shis skaita visus banus. <? mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("amxbans") or die(mysql_error()); $query = "SELECT admin_nick, COUNT(admin_nick) as banaani FROM amx_bans GROUP BY admin_nick ORDER BY banaani DESC Limit 10"; $result = mysql_query("$query") or die(mysql_error()); echo "<table border='1' width='250' cellspacing='0' cellpadding='1'> <tr> <td align='center'>#</td> <td align='center'>Admins</td> <td align='center'>Banaani</td> </tr>"; while($row = mysql_fetch_array($result)){ $ranks = $ranks+1; echo " <tr> <td align='center' width='20'>". $ranks .".</td> <td width='180'>". $row['admin_nick'] ."</td> <td align='center' width='50'>". $row['banaani'] ."</td> </tr> "; } echo "</table>"; ?> Bet shis te atkal permanent banus <? mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("amxbans") or die(mysql_error()); $query = "SELECT admin_nick, ban_length, COUNT(admin_nick) as banaani FROM amx_bans WHERE ban_length='0' GROUP BY admin_nick ORDER BY banaani DESC Limit 10"; $result = mysql_query("$query") or die(mysql_error()); echo "<table border='1' width='250' cellspacing='0' cellpadding='1'> <tr> <td align='center'>#</td> <td align='center'>Admins</td> <td align='center'>Banaani</td> </tr>"; while($row = mysql_fetch_array($result)){ $ranks = $ranks+1; echo " <tr> <td align='center' width='20'>". $ranks .".</td> <td width='180'>". $row['admin_nick'] ."</td> <td align='center' width='50'>". $row['banaani'] ."</td> </tr> "; } echo "</table>"; ?> ceru ka kādam noderēs Link to comment Share on other sites More sharing options...
BlackWallStreet Posted December 10, 2006 Report Share Posted December 10, 2006 bija jau gignā nesen manliekas, bet paldies, gan jau daudziem noderēs Link to comment Share on other sites More sharing options...
Thesnake Posted December 10, 2006 Report Share Posted December 10, 2006 tas ir vispar aktīvakie vai šodien? Link to comment Share on other sites More sharing options...
Miedzinjsh[War3-Pro-Player] Posted December 10, 2006 Report Share Posted December 10, 2006 Šodien aiz garlaicības uzcepu šādu te scriptiņu, amxbans aktīvāko banotāju TOP 10 Shis skaita visus banus. <? mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("amxbans") or die(mysql_error()); $query = "SELECT admin_nick, COUNT(admin_nick) as banaani FROM amx_bans GROUP BY admin_nick ORDER BY banaani DESC Limit 10"; $result = mysql_query("$query") or die(mysql_error()); echo "<table border='1' width='250' cellspacing='0' cellpadding='1'> <tr> <td align='center'>#</td> <td align='center'>Admins</td> <td align='center'>Banaani</td> </tr>"; while($row = mysql_fetch_array($result)){ $ranks = $ranks+1; echo " <tr> <td align='center' width='20'>". $ranks .".</td> <td width='180'>". $row['admin_nick'] ."</td> <td align='center' width='50'>". $row['banaani'] ."</td> </tr> "; } echo "</table>"; ?> Bet shis te atkal permanent banus <? mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("amxbans") or die(mysql_error()); $query = "SELECT admin_nick, ban_length, COUNT(admin_nick) as banaani FROM amx_bans WHERE ban_length='0' GROUP BY admin_nick ORDER BY banaani DESC Limit 10"; $result = mysql_query("$query") or die(mysql_error()); echo "<table border='1' width='250' cellspacing='0' cellpadding='1'> <tr> <td align='center'>#</td> <td align='center'>Admins</td> <td align='center'>Banaani</td> </tr>"; while($row = mysql_fetch_array($result)){ $ranks = $ranks+1; echo " <tr> <td align='center' width='20'>". $ranks .".</td> <td width='180'>". $row['admin_nick'] ."</td> <td align='center' width='50'>". $row['banaani'] ."</td> </tr> "; } echo "</table>"; ?> ceru ka kādam noderēs kaa vinju var lietot? Link to comment Share on other sites More sharing options...
de.Fault Posted December 10, 2006 Report Share Posted December 10, 2006 ' date='Dec 10 2006, 18:20'] kaa vinju var lietot? rediģējot un uzmetot uz sava servera. a tu zini kā var lietot smadzenes? Link to comment Share on other sites More sharing options...
Miedzinjsh[War3-Pro-Player] Posted December 10, 2006 Report Share Posted December 10, 2006 rediģējot un uzmetot uz sava servera. a tu zini kā var lietot smadzenes? man jaustaisa kad folderi kuraa shis jaieraksta? Link to comment Share on other sites More sharing options...
Kavacky Posted December 10, 2006 Report Share Posted December 10, 2006 mysql_connect("localhost", "root", "") Time to h4xXx Link to comment Share on other sites More sharing options...
overmind Posted December 10, 2006 Author Report Share Posted December 10, 2006 Time to h4xXx Link to comment Share on other sites More sharing options...
Fragrancer Posted December 10, 2006 Report Share Posted December 10, 2006 overmind lol .... kip tu vinu man uztaisiji, jo man nebija laika, skatos gignaa jau publiceets nakamo script pats taisishu, savadak man besii, ka visadi noobi sha saliks sev .... heh man krutaak, es intregreeju scriptu ieksh e107 menu Tagad man jataisa tavam scriptam update, lai nebutu kaa citiem Link to comment Share on other sites More sharing options...
overmind Posted December 10, 2006 Author Report Share Posted December 10, 2006 overmind lol .... kip tu vinu man uztaisiji, jo man nebija laika, skatos gignaa jau publiceets nakamo script pats taisishu, savadak man besii, ka visadi noobi sha saliks sev .... heh man krutaak, es intregreeju scriptu ieksh e107 menu Tagad man jataisa tavam scriptam update, lai nebutu kaa citiem Da lāāb, nakamreiz pasaki lai nav public Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now