• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Gesior] Could someone help this script for me?

Zistonick

Member
Joined
Mar 24, 2010
Messages
183
Reaction score
14
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?

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
 
Back
Top