Top Frags

[allianz]

Hi
I would like for me create top frags a script for my site.
use the Gesior ACC Maker.
please help me.
My site is this on my ot.
http://elerawar.servegame.com:8090
SERVER IS AN ENFORCED.

 

[LucasFerraz]

translating to english:
He wants a top frags script to his Gesior.
------------------------------------------------

Enjoy!

<?php


$main_content .= '<div style="text-align: center; font-weight: bold;">Top 30 frags on ' . $config['server']['serverName'] . '</div>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
	<tr bgcolor="' . $config['site']['vdarkborder'] . '">
		<td class="white" style="text-align: center; font-weight: bold;">Name</td>
		<td class="white" 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++;
	$main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']) . '">
		<td><a href="?subtopic=characters&name=' . urlencode($player['name']) . '">' . $player['name'] . '</a></td>
		<td style="text-align: center;">' . $player['frags'] . '</td>
	</tr>';
}

$main_content .= '</table>';
?>

 

[allianz]

hello, I put the script in the htdocs created a php file and put your script as I passed.
top frags when I click on the site.
appears in the following.
Invalid subtopic. Can not load page.
should I do?

s necessary to add a tag in the database?
which ?
Please explain

 

[LucasFerraz]

You must add in index.php

	case "fragers";
   		 $topic = "Top Fragers";
  		 $subtopic = "fragers";
  		 include("fragers.php");
	break;

 

[allianz]

Thank you for rep.
I have one more question.
I have one item in my item applied it refines ...
I wonder if you know a way to beat type 100 frags you get and you can enter this item ...
purchase.
Have to prove that over 100 frags you have ..
a sort of automatic check that you have 100 frags to purchase the item
Example refiner 20 frags = 100 buy .!!!!
how to do this?
Thanks for the Rep

 

[LucasFerraz]

Didn't understand, pm me in portugueese, I know you are Brazilian

 

[allianz]

Okk Tudo Bem.

Eu tenhu um item em meu server que ele refina item...
tipo deixa +1,+2,+3,+4, almentando o atk deles.
E eu Gostaria de saber se vc sabe um jeito pra fazer para comprar eles tipo.
você conseguindo 100 frags você ganha 20 item que refina .. entendeu ?
ai teria que logar no site para ter um auto check comprovando que Você tem 100 frags para poder comprar o Items.
+/- isso.
Sera que vc pode me ajudar ?
Obrigado

 

[allianz]

Help Me Please