Hi everyone!
Im making a server and im trying to put my old script of gesior in the new gesior, and this scripts arent working for me, could someone fix?
and the other one
Thank you
Im making a server and im trying to put my old script of gesior in the new gesior, and this scripts arent working for me, could someone fix?
PHP:
<?PHP
$quest_list = $config['site']['quests'];
if(!$quest_list)
{
$main_content .= 'Uzupe³nij storage questow w cofingu';
break;
}
$players = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id < '.$config['site']['players_group_id_block'].' AND account_id != 1');
$nr_gracza = 0;
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD align="left" COLSPAN=2 CLASS=white width="90%"><B>Best quest makers</B></TD></TR>';
foreach ($players as $player)
{
$ilosc_questow_wykonanych = 0;
$ilosc_questow = 0;
foreach($quest_list as $storage => $name)
{
$ilosc_questow++;
$quest_baza = $SQL->query("SELECT * FROM player_storage WHERE player_id = ".$player['id']." AND `key` = '".$quest_list[$storage]."'");
foreach($quest_baza as $idd)
$ilosc_questow_wykonanych++;
}
$ilosc_procent =($ilosc_questow_wykonanych / $ilosc_questow) * 100;
$gracz_wynik[$player['name']] = $ilosc_procent;
}
$gracze_wyniki = arsort($gracz_wynik);
foreach($gracz_wynik as $gracz => $procent)
{
if(is_int($nr_gracza / 2))
$bgcolor = $config['site']['darkborder'];
else
$bgcolor = $config['site']['lightborder'];
$nr_gracza++;
$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD width=60%>'.$gracz.'</td><td>'.number_format($procent,0).'%<div title="'.number_format($procent,0).'%" style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: green; width: '.$procent.'%; height: 3px;"></td></tr>';
}
$main_content .= '</table>';
?>
and the other one
PHP:
<?PHP
$main_content .= '<div style="text-align: center; font-weight: bold;"><h2>Top 15 guilds on ' . $config['server']['serverName'] . '</h2></div>
<center><table border="0" cellspacing="1" cellpadding="4" width="80%">
<tr bgcolor="'.$config['site']['vdarkborder'].'">
<td width="10%"><b><font color=white><center>Pos</font></center></b></td>
<td width="20%"><b><font color=white><center>Logo</center></b></font></td>
<td width="30%"><b><font color=white><center>Guild Name</center></b></font></td>
<td width="20%"><b><font color=white><center>Kills</center></b></font></td>
</tr>';
$i = 0;
foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`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`
LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
GROUP BY `name`
ORDER BY `frags` DESC, `name` ASC
LIMIT 0, 15;') as $guild)
{
$i++;
$main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']). '">
<td>
<center>'.$i.'</center>
</td>
<td>
<center><img src="guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/></center>
</td>
<td>
<center><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '">' . $guild['name'] . '</a></center>
</td>
<td>
<center>' . $guild['frags'] . ' kills</center>
</td>
</tr>';
}
$main_content .= '</table><br />';
$main_content .= '<div style="text-align: right; font-size: 10;">Based on <a href=http://otland.net/members/elf>Elf\'s</a> code. System made by <a href=http://otland.net/members/kekox>Kekox.</a></div>';
?>
Thank you