TOP Player Last New

[Venn]

hay
i have idea if someone can make Top from 5 players
or top 2 from all skills
and it should showing in lastnews like most powerfull guilds

if you can write this php code for me please

 

[Serginov]

just edit the most powerfull guilds ? Not hard

 

[Venn]

ye i had traied to do that but it wasnt a good idea
just it to hard for me

 

[Venn]

or it can be simple table but i don't now have to add it to layout
and if someone can i want table with account menagment
pools: to write acc number and pass and button to login or recover acc
after login button to menage acc
somethink like that

sorry for english xS

Like this

that tables i want !
And thats my acc layout if it help you edited by me ;p

and i want to put it like that

 

[Venn]

i have wark hardly and thats my effect

now if someone can tell me script for top fraggers

 

[president vankk]

mordem acc?
FAIL for me ;x
TOP Frags:

<?php 
//Script by Elf 
//Made for Modern AAC by Paxton 
require("config.php"); 
$ots = POT::getInstance(); 
$ots->connect(POT::DB_MYSQL, connection()); 
$SQL = $ots->getDBHandle(); 
echo '<div style="text-align: center; font-weight: bold;">Top 30 frags on ' . $config['server_name'] . '</div> 
<table border="0" cellspacing="1" cellpadding="4" width="100%"> 
 <tr> 
  <td  style="text-align: center; font-weight: bold;">Name</td> 
  <td  style="text-align: center; font-weight: bold;">Frags</td> 
 </tr>'; 

$i = 0; 
foreach($SQL->query('SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) as `frags` 
 FROM `killers` k 
 LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` 
 LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` 
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 
 GROUP BY `name` 
 ORDER BY `frags` DESC, `name` ASC 
 LIMIT 0,30;') as $player) 
{ 
 $i++; 
 echo '<tr> 
  <td><a href="'.WEBSITE.'/index.php/character/view/'.$player['name'].'"><center>' . $player['name'] . '</center></a></td> 
  <td><center>' . $player['frags'] . '</center></td> 
 </tr>'; 
} 

echo '</table>'; 
?>

REP+

 

[Pitufo™]

Use the same code from the TOP Player just change in the query from level to frags if you are using "frags" in your players table.

Or if you can't do that simple think, just paste the code in here and ill modify it for you.

 

[Venn]

its gesior acc and thx i have done the table.