Jump to content
GIGN Forum

Aktivaakie Admini @ Web


Recommended Posts

kaadu veel skriptu ar php no mysql izvelk vajadziigo rowu un count katram koaa un buus!

Luuk skripts:

<?php

echo "<table id='admintop'>
 <tr>
 <th>Admins</th>
 <th>Bani</th>
 </tr>";
 
$con = mysql_connect("mysql_hosts","mysql_useris","mysql_parole");
if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }
mysql_select_db("amxbans", $con);

$result = mysql_query("SELECT count(*), admin_nick FROM amx_bans GROUP BY admin_nick ORDER BY count(*) DESC LIMIT 5"); // DESC LIMIT 5 noziimee, ka vinjsh paraadiis 5 aktiivaakos

while($row = mysql_fetch_array($result))
 {
 $admins = $row['admin_nick'];
 $skaits = $row['count(*)'];
 echo "<tr>
 <td>$admins</td>
 <td>$skaits</td>
 </tr>";
 }
mysql_close($con);
?>
</table>

un sho liekam ieksh savas lapas galvenaa CSS:

/*-------------admintop---------------*/   
#admintop {
  font-size: 10px;
  color: #204815;
  }
  
#admintop td{
  border: dotted;
  border-width: 1 0 0 0;
  padding-right: 20px;
  }
  
#admintop th{
  text-align: left;
  }

CEPUMINJU MAN!

Link to comment
Share on other sites

vnk pasakiet ko lai es ar to CODu daru tieshi kas man jaadara 1.,2.?

es varbuut neesmu tik gudrs ar mysql. ;[

Lai rādītu tos aktīvos adminus tev vajag amxbans Un tad to 1. kodu ieraksti index.php vai kādā citā *.php failā! un to 2. kodu ieraksti iekš *.css failā! Un vis, gatavs!

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

×
×
  • Create New...