• 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 Acc] Edited Tibia.com Layout

Rizzla

Donator / Photoshop
Joined
Sep 7, 2008
Messages
1,335
Reaction score
2
Location
Sweden -> Stockholm
Nothing special, just edited the orginal website a bit. :)


tibiacom.jpg




DOWNLOAD: tibiacom1.rar


Go to htdocs and create a file called 'wars.php' and paste this:
Code:
<?PHP 
//Litle Config 
$MaxShow = 100; 
//END 

if($action == '') 
{ 
$main_content .= ' 
<P ALIGN=CENTER> 
    <br> 
    <FONT SIZE=4 COLOR=#8A0808> 
        How to use... 
    </FONT> 
    <br> 
    <br> 
    <FONT SIZE=2 COLOR=#DF0101> 
    * <b>/war-invite</b> : 
        <FONT SIZE=1 COLOR=green> 
            Send an invitation to start a war.<br> 
            <u>Example</u>: /war-invite Death Hard 
        </FONT><br> 
    * <b>/war-accept</b> : 
        <FONT SIZE=1 COLOR=green> 
            Accept the invitation to start a war. 
        </FONT><br> 
    * <b>/war-reject</b> : 
        <FONT SIZE=1 COLOR=green> 
            Reject the invitation to start a war. 
        </FONT><br> 
    * <b>/war-cancel-invite</b> : 
        <FONT SIZE=1 COLOR=green> 
            Cancel the invitation already sent to start a war. 
        </FONT><br> 
    * <b>/war-cancel</b> : 
        <FONT SIZE=1 COLOR=green> 
            Finish the current war: it can only be used after 1 day of war. 
        </FONT><br> 
    </FONT> 
    <br> 
    <FONT SIZE=2 COLOR=#8A0808> 
        Those commands can only be executed by guild leaders.<br><br> 
        <table border="1"><tr border="1"><td border="1"><h3>Remember:</h3> 
        <ul> 
        <li>You won't get any frag if you kill someone that is VERSUS you.</li> 
        <li>If you kill someone that is in your guild, you will get a frag.</li> 
        </ul></td></tr></table> 
    </FONT> 
</P> 
'; 
$wars = $SQL->query(" 
    SELECT g.name AS gname, wg.name AS wgname, g.war_time AS gtime, wg.war_time AS wgtime, g.kills AS kills, wg.kills AS ekills, g.show AS s, g.id AS gid, wg.id AS wgid, g.logo_gfx_name AS glogo, wg.logo_gfx_name AS wglogo 
        FROM guilds AS g 
    INNER JOIN guilds AS wg 
        ON wg.id = g.in_war_with 
    ORDER BY s DESC LIMIT 50; 
"); 

foreach ($wars as $k=>$v) { 
if ($v[s] == 1)  
{ 

$glogo = "default_logo.gif"; 
$wglogo = "default_logo.gif"; 

if(!empty($v[glogo])) 
$glogo = $v[glogo]; 
if(!empty($v[wglogo])) 
$wglogo = $v[wglogo]; 

if(is_int($number_of_rows / 2)) { $bgcolor = '#D4C0A1'; } else { $bgcolor = '#D5E1A2'; } $number_of_rows++; 

    $stats .=" 
        <TR BGCOLOR=".$bgcolor."> 
            <TD WIDTH=30%><center><a href='index.php?subtopic=guilds&action=show&guild=" . $v[gid] . "'><font color='#5A2800'>$v[gname]</font></a></center></TD> 
            <TD WIDTH=40%><center><a href='index.php?subtopic=wars&action=show&war=" . $v[gid] . "'><font color='#5A2800'>{$v[kills]} - {$v[ekills]}</font></a></center></TD> 
            <TD WIDTH=30%><center><a href='index.php?subtopic=guilds&action=show&guild=" . $v[wgid] . "'><font color='#5A2800'>$v[wgname]</font></a></center></TD> 
        </TR> 
        <TR BGCOLOR=".$bgcolor."> 
            <TD><center><img border=1 src='guilds/".$glogo."' width='64px' height='64px'/></center></TD> 
            <TD><center><b>Declared at:</b><br />" . date("d/m/y   H:i:s", $v[gtime]) . "<p><b>Started at:</b><br />" . date("d/m/y   H:i:s", $v[wgtime]) . "</center></TD> 
            <TD><center><img border=1 src='guilds/".$wglogo."' width='64px' height='64px'/></center></TD> 
        </TR> 
    "; 

} 
} 
$main_content .= ' 
<table border="0" CELLSPACING=1 CELLPADDING=4 WIDTH=100%><tbody>            <TR BGCOLOR="'.$config['site']['vdarkborder'].'"><td><font color="white" size=4><b><blink>Active Wars</blink></b></font></td></tr></tbody></table> 
'; 
if(!$stats) { 
    $main_content .= ' 
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%> 
            <TR BGCOLOR='.$config['site']['darkborder'].'> 
                <TD> 
                    No active wars in '.$config['server']['serverName'].' yet. 
                </TD> 
            </TR> 
        </TABLE> 
    '; 
} else { 
    $main_content .= " 
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%> 
            $stats 
        </TABLE> 
    ";     
} 

?> 

<?PHP 
$invitations = $SQL->query(" 
    SELECT ig.name AS igname, i.name AS iname, i.id AS iid, ig.id AS igid, i.war_time AS itime, i.logo_gfx_name AS ilogo, ig.logo_gfx_name AS iglogo 
        FROM guilds AS i 
    INNER JOIN guilds AS ig 
        ON ig.id = i.invited_to 
    ORDER BY itime ASC LIMIT 50;     
"); 
foreach ($invitations as $k=>$v) { 

$ilogo = "default_logo.gif"; 
$iglogo = "default_logo.gif"; 

if(!empty($v[ilogo])) 
$ilogo = $v[ilogo]; 
if(!empty($v[iglogo])) 
$iglogo = $v[iglogo]; 

            if(is_int($number_of_rows / 2)) { $bgcolor = '#D4C0A1'; } else { $bgcolor = '#D5E1A2'; } $number_of_rows++; 

    $invi .=" 
        <TR BGCOLOR=".$bgcolor."> 
            <TD width=30%> 
                <center> 
                    <b> 
                        <a href='index.php?subtopic=guilds&action=show&guild=" . $v[iid] . "'><font color='#5A2800'>$v[iname]</font></a> 
                    </b> 
                </center> 
            </TD> 
            <TD width=40%><center>0-0</center></TD> 
            <TD width=30%> 
                <center> 
                    <b> 
                        <a href='index.php?subtopic=guilds&action=show&guild=" . $v[igid] . "'><font color='#5A2800'>$v[igname]</font></a> 
                    </b> 
                </center> 
            </TD> 
        </TR> 
        <TR BGCOLOR=".$bgcolor."> 
            <TD> 
                <center> 
                        <img border=1 src='guilds/".$ilogo."' width='64px' height='64px'/> 
                </center> 
            </TD> 
            <TD><center><b>Declared on:</b><br />" . date("d/m/y   H:i:s", $v[itime]) . "</center></TD> 
            <TD> 
                <center> 
            <img border=1 src='guilds/".$iglogo."' width='64px' height='64px'/> 
                </center> 
            </TD> 
        </TR> 
    "; 
} 
$main_content .= '<br><br><br> 
<table border="0" CELLSPACING=1 CELLPADDING=4 WIDTH=100%><tbody>            <TR BGCOLOR="'.$config['site']['vdarkborder'].'"><td><font color="white" size=4><b><blink>Declared Wars</blink></b></font></td></tr></tbody></table>'; 
if(!$invi) { 
    $main_content .= ' 
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%> 
            <TR BGCOLOR='.$config['site']['darkborder'].'> 
                <TD> 
                    No declared wars in '.$config['server']['serverName'].' yet. 
                </TD> 
            </TR> 
        </TABLE> 
    <br> 
    '; 
} else { 
    $main_content .= " 
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%> 
            $invi 
        </TABLE> 
    "; 
} 
} 

//SHOW FRAGS ~~ 
if($action == 'show') 
{ 
$guild = $ots->createObject('Guild');  
$guild->load($_REQUEST['war']); 
$ranks = $SQL->query(" 
    SELECT  
        * 
    FROM  
        guild_ranks  
    WHERE  
        guild_id = ". $guild->getId() ." 
    ORDER BY 
    level DESC; 
    "); 

foreach ($ranks as $y) 
{ 
    $Players = $SQL->query(" 
    SELECT  
        * 
    FROM  
        players  
    WHERE  
        rank_id = ". $y[id] ."  
    ORDER BY 
    name 
    ASC;"); 
    foreach ($Players as $v) 
    { 
    $totDeaths = 0; 
    $deaths = $SQL->query(" 
    SELECT   
        COUNT(player_id) AS n 
    FROM  
        deaths_in_wars 
    WHERE  
        player_id = ". $v[id] ."  
    GROUP BY  
        player_id 
    DESC LIMIT 1;"); 
        foreach ($deaths as $q) 
        { 
            $totDeaths = $q[n]; 
        } 

if($totDeaths > 1 || $totDeaths == 0){ 
$deathL = "deaths"; 
} 
else{ 
$deathL = "death"; 
} 

    $membersDeaths1 .="<tr bgcolor=#D4C0A1> 
                <td width=70%><a href=index.php?subtopic=characters&name=" . $v[name] . "><u>$v[name]</u></a></td> 
        <td width=30%>$totDeaths $deathL</td> 
    </tr> 
    "; 

    $totFrags = 0; 
    $frags = $SQL->query(" 
    SELECT   
        COUNT(killer) AS m 
    FROM  
        deaths_in_wars 
    WHERE  
        killer = ". $v[id] ."  
    GROUP BY 
    killer 
    DESC LIMIT 1;"); 
        foreach ($frags as $p) 
        { 
            $totFrags = $p[m]; 
        } 

if($totFrags > 1 || $totFrags == 0){ 
$fragL = "frags"; 
} 
else{ 
$fragL = "frag"; 
} 

    $membersFrags1 .= "<tr bgcolor=#D4C0A1> 
                <td width=70%><a href=index.php?subtopic=characters&name=" . $v[name] . "><u>$v[name]</u></a></td> 
        <td width=30%>$totFrags $fragL</td> 
    </tr> 
    "; 
    } 
} 

$guild2 = $ots->createObject('Guild');  
$guild2->load($guild->getCustomField(in_war_with)); 
$ranks2 = $SQL->query(" 
    SELECT  
        * 
    FROM  
        guild_ranks  
    WHERE  
        guild_id = ". $guild2->getId() ." 
    ORDER BY 
    level DESC; 
    "); 

foreach ($ranks2 as $y) 
{ 
    $Players = $SQL->query(" 
    SELECT  
        * 
    FROM  
        players  
    WHERE  
        rank_id = ". $y[id] ."  
    ORDER BY 
    name 
    ASC;"); 
    foreach ($Players as $v) 
    { 
    $totDeaths2 = 0; 
    $deaths = $SQL->query(" 
    SELECT   
        COUNT(player_id) AS n 
    FROM  
        deaths_in_wars 
    WHERE  
        player_id = ". $v[id] ."  
    GROUP BY 
    player_id 
    DESC LIMIT 1;"); 
        foreach ($deaths as $q) 
        { 
            $totDeaths2 = $q[n]; 
        } 

if($totDeaths2 > 1 || $totDeaths2 == 0){ 
$deathL = "deaths"; 
} 
else{ 
$deathL = "death"; 
} 

    $membersDeaths2 .= "<tr bgcolor=#D4C0A1> 
                <td width=70%><a href=index.php?subtopic=characters&name=" . $v[name] . "><u>$v[name]</u></a></td> 
        <td width=30%>$totDeaths2 $deathL</td> 
    </tr> 
    "; 

    $totFrags2 = 0; 
    $frags = $SQL->query(" 
    SELECT   
        COUNT(killer) AS m 
    FROM  
        deaths_in_wars 
    WHERE  
        killer = ". $v[id] ."  
    GROUP BY 
    killer 
    DESC LIMIT 1;"); 
        foreach ($frags as $p) 
        { 
            $totFrags2 = $p[m]; 
        } 

if($totFrags2 > 1 || $totFrags2 == 0){ 
$fragL = "frags"; 
} 
else{ 
$fragL = "frag"; 
} 

    $membersFrags2 .= "<tr bgcolor=#D4C0A1> 
                <td width=70%><a href=index.php?subtopic=characters&name=" . $v[name] . "><u>$v[name]</u></a></td> 
        <td width=30%>$totFrags2 $fragL</td> 
    </tr> 
    "; 
    } 
} 

$deaths3 = $SQL->query(" 
    SELECT  
        *  
    FROM  
        deaths_in_wars  
    WHERE  
        (killer_guild = ". $guild->getId() ." OR killer_guild = ". $guild2->getId() .") 
    ORDER BY  
        date  
    DESC LIMIT ". $MaxShow .";"); 

$deathsG1 = $SQL->query(" 
    SELECT  
        *  
    FROM  
        deaths_in_wars  
    WHERE  
        killer_guild = ". $guild->getId() ."  
    ORDER BY  
        date  
    DESC LIMIT ". $MaxShow .";"); 

$deathsG2 = $SQL->query(" 
    SELECT  
        *  
    FROM  
        deaths_in_wars  
    WHERE  
        killer_guild = ". $guild2->getId() ."  
    ORDER BY  
        date 
    DESC LIMIT ". $MaxShow .";"); 

$Topfragger1 = $SQL->query(" 
    SELECT  
        killer, COUNT(killer) maximo 
    FROM  
        deaths_in_wars 
    WHERE  
        killer_guild =     ". $guild->getId() ."  
    GROUP BY  
        killer 
    ORDER BY  
        maximo  
    DESC LIMIT 1;"); 
     
    foreach ($Topfragger1 as $y)  
        { 
            $name = $ots->createObject('Player'); 
            $name->load($y[killer]); 
            $TopFraggerName = $name->getName(); 
            $numTop1 = $y[maximo]; 
        } 
         
$Topfragger2 = $SQL->query(" 
    SELECT  
        killer, COUNT(killer) maximo 
    FROM  
        deaths_in_wars 
    WHERE  
        killer_guild =     ". $guild2->getId() ."  
    GROUP BY  
        killer 
    ORDER BY  
        maximo  
    DESC LIMIT 1;"); 
     
    foreach ($Topfragger2 as $y)  
        { 
            $name = $ots->createObject('Player'); 
            $name->load($y[killer]); 
            $TopFraggerName2 = $name->getName(); 
            $numTop2 = $y[maximo]; 
        } 
         
$mostDead = $SQL->query(" 
    SELECT  
        player_id, COUNT(player_id) maximo 
    FROM  
        deaths_in_wars 
    WHERE  
        killer_guild =     ". $guild->getId() ."  
    GROUP BY  
        player_id 
    ORDER BY  
        maximo  
    DESC LIMIT 1;"); 
     
    foreach ($mostDead as $y)  
        { 
            $name = $ots->createObject('Player'); 
            $name->load($y[player_id]); 
            $mostDeadName = $name->getName(); 
            $mostDeadNum = $y[maximo]; 
        } 

$mostDead2= $SQL->query(" 
    SELECT  
        player_id, COUNT(player_id) maximo 
    FROM  
        deaths_in_wars 
    WHERE  
        killer_guild =     ". $guild2->getId() ."  
    GROUP BY  
        player_id 
    ORDER BY  
        maximo  
    DESC LIMIT 1;"); 
     
    foreach ($mostDead2 as $y)  
        { 
            $name = $ots->createObject('Player'); 
            $name->load($y[player_id]); 
            $mostDeadName2 = $name->getName(); 
            $mostDeadNum2= $y[maximo]; 
        } 

foreach ($deaths3 as $a=>$b) { 
     
    $killed3 = $ots->createObject('Player'); 
    $killed3->load($b[player_id]); 
    $killedName3 = $killed3->getName(); 

    $killer3 = $ots->createObject('Player'); 
    $killer3->load($b[killer]); 
    $killerName3 = $killer3->getName(); 

    $guild3 = $ots->createObject('Guild'); 
    $guild3->load($b[killer_guild]); 
    $guildName3 = $guild3->getName(); 

    $totKills1 = 0; 
    $killss1 = $SQL->query(" 
    SELECT   
        COUNT(result1) AS m 
    FROM  
        deaths_in_wars 
    WHERE  
        (killer_guild = ". $guild->getId() ." AND date <= ". $b[date] .") 
    GROUP BY 
    result1 
    DESC LIMIT 1;"); 
        foreach ($killss1 as $p) 
        { 
            $totKills1 = $p[m]; 
        } 

    $totKills2 = 0; 
    $killss2 = $SQL->query(" 
    SELECT   
        COUNT(result2) AS n 
    FROM  
        deaths_in_wars 
    WHERE  
        (killer_guild = ". $guild2->getId() ." AND date <= ". $b[date] .") 
    GROUP BY 
    result2 
    DESC LIMIT 1;"); 
        foreach ($killss2 as $q) 
        { 
            $totKills2 = $q[n]; 
        } 

    $kills3 .=" 
        <TR BGCOLOR=#D4C0A1> 
            <TD> 
                        <a href='index.php?subtopic=characters&name=" . $killerName3 . "'><u>$killerName3</u></a> 
            </TD> 
            <TD> 
                        <a href='index.php?subtopic=characters&name=" . $killedName3 . "'><u>$killedName3</u></a> 
            </TD> 
            <TD> 
            $guildName3 
            </TD> 
            <TD> 
            $totKills1:$totKills2 
            </TD> 
            <TD> 
                    " . date("d/m/y   H:i:s", $b[date]) . " 
            </TD> 
        </TR> 
    "; 
} 

if(!empty($mostDeadNum)){$mostDeadNum = $mostDeadNum;}else{$mostDeadNum = 0 + $mostDeadNum;} 
if(!empty($mostDeadNum2)){$mostDeadNum2 = $mostDeadNum2;}else{$mostDeadNum2 = 0 + $mostDeadNum2;} 
if(!empty($numTop1)){$numTop1 = $numTop1;}else{$numTop1 = 0 + $numTop1;} 
if(!empty($numTop2)){$numTop2 = $numTop2;}else{$numTop2 = 0 + $numTop2;} 

foreach ($deathsG1 as $k=>$v) { 
     
    $killed = $ots->createObject('Player'); 
    $killed->load($v[player_id]); 
    $killedName = $killed->getName(); 

    $killer = $ots->createObject('Player'); 
    $killer->load($v[killer]); 
    $killerName = $killer->getName(); 
     
    $kills .=" 
        <TR BGCOLOR="".$config['site'][($k % 2 == 1 ? 'light' : 'dark').'border'].""> 
            <TD> 
                <center> 
                    <b> 
                        <a href='index.php?subtopic=characters&name=" . $killedName . "'>$killedName</a> 
                    </b> 
                </center> 
            </TD> 
            <TD> 
                <center> 
                    <b> 
                        <a href='index.php?subtopic=characters&name=" . $killerName . "'>$killerName</a> 
                    </b> 
                </center> 
            </TD> 
            <TD> 
                <center> 
                    " . date("d/m/y   H:i:s", $v[date]) . " 
                </center> 
            </TD> 
        </TR> 
    "; 
} 

foreach ($deathsG2 as $k=>$v) { 
     
    $killed = $ots->createObject('Player'); 
    $killed->load($v[player_id]); 
    $killedName = $killed->getName(); 

    $killer = $ots->createObject('Player'); 
    $killer->load($v[killer]); 
    $killerName = $killer->getName(); 
     
    $kills2 .=" 
        <TR BGCOLOR="".$config['site'][($k % 2 == 1 ? 'light' : 'dark').'border'].""> 
            <TD> 
                <center> 
                    <b> 
                        <a href='index.php?subtopic=characters&name=" . $killedName . "'>$killedName</a> 
                    </b> 
                </center> 
            </TD> 
            <TD> 
                <center> 
                    <b> 
                        <a href='index.php?subtopic=characters&name=" . $killerName . "'>$killerName</a> 
                    </b> 
                </center> 
            </TD> 
            <TD> 
                <center> 
                    " . date("d/m/y   H:i:s", $v[date]) . " 
                </center> 
            </TD> 
        </TR> 
    "; 
} 

if($numTop1 > 1 || $numTop1 == 0){$fragl1 = "frags";}else{$fragl1 = "frag";} 
if($numTop2 > 1 || $numTop2 == 0){$fragl2 = "frags";}else{$fragl2= "frag";} 
if($mostDeadNum > 1 || $mostDeadNum == 0){$deathl1 = "deaths";}else{$deathl1 = "death";} 
if($mostDeadNum2 > 1 || $mostDeadNum2 == 0){$deathl2 = "deaths";}else{$deathl2 = "death";} 

$main_content .= ' 
<table border="0" CELLSPACING=1 CELLPADDING=4 WIDTH=100%><tbody>            <TR BGCOLOR="'.$config['site']['vdarkborder'].'"><td><font color="white" size=4><b>War Information</b></font></td></tr></tbody></table> 
'; 

$logo = "default_logo.gif"; 
$logo2 = "default_logo.gif"; 
$a = $guild->getCustomField(logo_gfx_name); 
$b = $guild2->getCustomField(logo_gfx_name); 
if(!empty($a)) 
$logo = $a; 
if(!empty($b)) 
$logo2 = $b; 

$main_content .= " 
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%> 
        <TR BGCOLOR='#D4C0A1'> 
            <TD WIDTH='35%'><center><a href='index.php?subtopic=guilds&action=show&guild=".$guild->getId()."'><font color='#5A2800'>".$guild->getName()."</font></a></center></TD> 
            <TD WIDTH='30%'><center><font color='#5A2800'><b>".$guild->getCustomField(kills)." - ".$guild2->getCustomField(kills)."</b></font></center></TD> 
            <TD WIDTH='35%'><center><a href='index.php?subtopic=guilds&action=show&guild=".$guild2->getId()."'><font color='#5A2800'>".$guild2->getName()."</font></a></center></TD> 
        </TR> 
        <TR BGCOLOR='#D4C0A1'> 
            <TD><center><img border=1 src='guilds/".$logo."' width='64px' height='64px'/><p><b><u>Top fragger:</b></u><br /><a href='index.php?subtopic=characters&name=".$TopFraggerName."'>".$TopFraggerName."</a> (".$numTop1." ".$fragl1.")<p><b><u>Most dead:</b></u><br /><a href='index.php?subtopic=characters&name=".$mostDeadName2."'>".$mostDeadName2."</a> (".$mostDeadNum2." ".$deathl2.")</center></TD> 
            <TD><center><b>Declared at:</b><br />" . date("d/m/y   H:i:s", $guild->getCustomField(war_time)) . "<p><b>Started at:</b><br />" . date("d/m/y   H:i:s", $guild2->getCustomField(war_time)) . "</center></TD> 
            <TD><center><img border=1 src='guilds/".$logo2."' width='64px' height='64px'/><p><b><u>Top fragger:</u></b><br /><a href='index.php?subtopic=characters&name=".$TopFraggerName2."'>".$TopFraggerName2."</a> (".$numTop2." ".$fragl2.")<p><b><u>Most dead:</u></b><br /><a href='index.php?subtopic=characters&name=".$mostDeadName."'>".$mostDeadName."</a> (".$mostDeadNum." ".$deathl1.")</center></TD> 
        </TR> 
        </TABLE>     
"; 

$main_content .= ' 
<br><br><table border="0" CELLSPACING=1 CELLPADDING=4 WIDTH=100%><tbody><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><td><font color="white" size=4><b>Kills - '.$guild->getName().' vs '.$guild2->getName().'</b></font></td></tr></tbody></table> 
'; 

$main_content .= " 
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%> 
        <TR BGCOLOR=#D4C0A1> 
            <TD><b>Killer</b></TD> 
            <TD><b>Victim</b></TD> 
            <TD><b>Fragging Guild</b></TD> 
            <TD><b>Result</b></TD> 
            <TD><b>Date</b></TD> 
        </TR> 
    $kills3 
        </TABLE>"; 

$main_content .= ' 
<br><br><table border="0" CELLSPACING=1 CELLPADDING=4 WIDTH=100%><tbody><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><td><font color="white" size=4><b>Most Frags</b></font></td></tr></tbody></table>'; 

$main_content .= " 
    <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%> 
        <TR BGCOLOR=#D4C0A1> 
            <TD width=50%> 
                <div align='right'> 
                    <B> 
                        ". $guild->getName() ." 
                    </B> 
                </div> 
            </TD> 
            <TD width=50%> 
                <div align='left'> 
                    <B> 
                        ". $guild2->getName() ." 
                    </B> 
                </div> 
            </TD> 
        </TR> 
        <TR BGCOLOR=#D4C0A1> 
            <TD> 
                <div align='right'> 
            <img src=guilds/".$logo." width='64px' height='64px' border=1/> 
        </div> 
            </TD> 
            <TD> 
                <div align='left'> 
            <img src=guilds/".$logo2." width='64px' height='64px'border=1/> 
                </div> 
            </TD> 
        </TR> 
    </TABLE> 
    <TABLE ALIGN=LEFT BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=50%> 
        $membersFrags1 
    </TABLE> 
    <TABLE ALIGN=RIGHT BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=50%> 
        $membersFrags2 
    </TABLE> 

"; 
$main_content .= ' 
<table border="0" CELLSPACING=1 CELLPADDING=4 WIDTH=100%><tbody><TR><td><font color="white" size=1>.</font></td></tr></tbody></table>'; 
$main_content .= ' 
<table border="0" CELLSPACING=1 CELLPADDING=4 WIDTH=100%><tbody><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><td><font color="white" size=4><b>Most Deaths</b></font></td></tr></tbody></table>'; 
$main_content .= " 
    <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%> 
        <TR BGCOLOR=#D4C0A1> 
            <TD width=50%> 
        <div align='right'> 
                    <B> 
                        ". $guild->getName() ." 
                    </B> 
        </div> 
            </TD> 
            <TD width=50%> 
        <div align='left'> 
                    <B> 
                        ". $guild2->getName() ." 
                    </B> 
        </div> 
            </TD> 
        </TR> 
        <TR BGCOLOR=#D4C0A1> 
            <TD> 
        <div align='right'> 
            <img src=guilds/".$logo." width='64px' height='64px' border=1 /> 
        </div> 
            </TD> 
            <TD> 
        <div align='left'> 
            <img src=guilds/".$logo2." width='64px' height='64px'border=1 /> 
        </div> 
            </TD> 
        </TR> 
    </TABLE> 
    <TABLE ALIGN=LEFT BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=50%> 
        $membersDeaths1 
    </TABLE> 
    <TABLE ALIGN=RIGHT BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=50%> 
        $membersDeaths2 
    </TABLE> 
"; 
} 
$main_content .= " 
<table border='0' CELLSPACING=1 CELLPADDING=4 WIDTH=100%><tbody><TR><td><div style='text-align: right; margin: 20px auto; font-size: 10px;'> 
      Coded by <a target='blank' href='http://otland.net/members/nahruto/'>Nahruto</a> and <a target='blank' href='http://otland.net/members/xampy/'>Xampy</a> | Fixed & Edited by <a target='blank' href='http://otland.net/members/xampy/'>Xampy</a></div></td></tr></tbody></table>"; 
?>

Create a file called 'powergamers.php' and paste this:
Code:
<?PHP
$limit = 300;
$type = $_REQUEST['type'];
function coloured_value($valuein)
{
	$value2 = $valuein;
	while(strlen($value2) > 3)
	{
		$value .= '.'.substr($value2, -3, 3);
		$value2 = substr($value2, 0, strlen($value2)-3);
	}
	$value = $value2.$value;
	if($valuein > 0)
		return '<font color="green">+'.$value.'</font>';
	elseif($valuein < 0)
		return '<font color="red">'.$value.'</font>';
	else
		return '<font color="black">'.$value.'</font>';
}
if(empty($type))
	$players = $SQL->query(' SELECT * FROM players ORDER BY `players`.`experience`-`players`.`exphist_lastexp` DESC LIMIT '.$limit)->fetchAll();
elseif($type == "sum")
	$players = $SQL->query(' SELECT * FROM players ORDER BY `players`.`exphist1`+`players`.`exphist2`+`players`.`exphist3`+`players`.`exphist4`+`players`.`exphist5`+`players`.`exphist6`+`players`.`exphist7`+`players`.`experience`-`players`.`exphist_lastexp` DESC LIMIT '.$limit)->fetchAll();
elseif($type >= 1 && $type <= 7)
	$players = $SQL->query(' SELECT * FROM players ORDER BY exphist'.(int) $type.' DESC LIMIT '.$limit)->fetchAll();
$main_content .= '<CENTER><H2>Ranking of powergamers</H2></CENTER><BR><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%></TABLE><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD WIDTH=10% CLASS=whites><B>Rank</B></TD><TD WIDTH=75% CLASS=whites><B>Name</B></TD>';
if($type == "sum")
	$main_content .= '<TD WIDTH=15% bgcolor="red" CLASS=whites><b><center><a href="?subtopic=exphist&type=sum">7 Days sum</a></center></B></TD>';
else
	$main_content .= '<TD WIDTH=15% bgcolor="yellow" CLASS=whites><b><center><a href="?subtopic=exphist&type=sum">7 Days sum</a></center></B></TD>';
for($i = 7; $i >= 2; $i--)
	if($type == $i)
		$main_content .= '<TD WIDTH=15% bgcolor="red" CLASS=whites><b><center><a href="?subtopic=exphist&type='.$i.'">'.$i.' Days Ago</a></center></B></TD>';
	else
		$main_content .= '<TD WIDTH=15% bgcolor="yellow" CLASS=whites><b><center><a href="?subtopic=exphist&type='.$i.'">'.$i.' Days Ago</a></center></B></TD>';
if($type == 1)
	$main_content .= '<TD WIDTH=15% bgcolor="red" CLASS=whites><b><center><a href="?subtopic=exphist&type=1">1 Day Ago</a></center></B></TD>';
else
	$main_content .= '<TD WIDTH=15% bgcolor="yellow" CLASS=whites><b><center><a href="?subtopic=exphist&type=1">1 Day Ago</a></center></B></TD>';
if(empty($type))
	$main_content .= '<TD WIDTH=15% bgcolor="red" CLASS=whites><b><center><a href="?subtopic=exphist">Today</a></center></B></TD>';
else
	$main_content .= '<TD WIDTH=15% bgcolor="yellow" CLASS=whites><b><center><a href="?subtopic=exphist">Today</a></center></B></TD>';
$main_content .= '</TR>';
foreach($players as $player)
{
	if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
	$main_content .= '<tr bgcolor="'.$bgcolor.'"><td align="center">'.$number_of_rows.'. </td>';
	if($player['online'] == 1)
		$main_content .= '<td><a href="?subtopic=characters&name='.urlencode($player['name']).'"><b><font color="green">'.$player['name'].'</font></b></a>';
	else
		$main_content .= '<td><a href="?subtopic=characters&name='.urlencode($player['name']).'"><b><font color="red">'.$player['name'].'</font></b></a>';
	$main_content .= '<br />'.$player['level'].' '.$config_vocations[$player['vocation']].'</td><td align="right">'.coloured_value($player['exphist1'] + $player['exphist2'] + $player['exphist3'] + $player['exphist4'] + $player['exphist5'] + $player['exphist6'] + $player['exphist7'] + $player['experience'] - $player['exphist_lastexp']).'</td>';
	$main_content .= '<td align="right">'.coloured_value($player['exphist7']).'</td><td align="right">'.coloured_value($player['exphist6']).'</td><td align="right">'.coloured_value($player['exphist5']).'</td><td align="right">'.coloured_value($player['exphist4']).'</td><td align="right">'.coloured_value($player['exphist3']).'</td><td align="right">'.coloured_value($player['exphist2']).'</td><td align="right">'.coloured_value($player['exphist1']).'</td><td align="right">'.coloured_value($player['experience']-$player['exphist_lastexp']).'</td></tr>';
}
$main_content .= '</TABLE>';
?>

Create a file called 'frags.php' and paste this:
Code:
<?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>';
?>

Create a file called 'addons.php' and paste this:
Code:
<?PHP
$main_content .= '
<center><font size="4">Citizen Outfit</font></center><br />
<b>Backpack addon</b> (First citizen addon)<br />
<img src="./images/addons/Male_Citizen_1.gif"/>
<img src="./images/addons/Female_Citizen_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>100 Minotaur Leathers</li>
</ul><br />


<b>Hat addon</b> (Second citizen addon)<br />
<img src="./images/addons/Male_Citizen_2.gif"/>
<img src="./images/addons/Female_Citizen_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>100 Chicken Feathers</li>
<li>50 Honeycombs</li>
<li>Legion Helmet</li>
</ul><br /><br />

<center><font size="4">Hunter Outfit</font></center><br />

<b>Cloak addon</b> (First hunter addon)<br />
<img src="./images/addons/Male_Hunter_1.gif"/>
<img src="./images/addons/Female_Hunter_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>Royal Steel</li>
<li>Hell steel</li>

<li>Draconian Steel</li>
<li>100 Red Dragon Leathers</li>
<li>100 Lizard Leathers</li>
<li>5 enchanted chicken wings</li>
<li>engraved crossbow</li>
</ul><br/>

<b>Gloves addon</b> (Second hunter addon)<br />
<img src="./images/addons/Male_Hunter_2.gif"/>


<img src="./images/addons/Female_Hunter_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>Sniper Gloves</li>
</ul><br /><br />

<center><font size="4">Mage Outfit</font></center><br />
<b>Ferumbras Hat addon</b><br />
<img src="./images/addons/Male_Mage_2.gif"/>
<img src="./images/addons/Female_Summoner_2.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>Ferumbras Hat</li>
</ul><br />

<b>Wand addon</b><br />
<img src="./images/addons/Male_Mage_1.gif"/>
<img src="./images/addons/Female_Summoner_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>20 Ankhs</li>
<li>Soul Stone</li>

<li>10 magic sulphors</li>
<li>All wands & rods</li>

</ul><br /><br />

<center><font size="4">Knight Outfit</font></center><br />
<b>Sword addon</b><br />
<img src="./images/addons/Male_Knight_1.gif"/>
<img src="./images/addons/Female_Knight_1.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>Chunk of Crude Iron</li>
<li>100 Iron Ores</li>
</ul><br />

<b>Helmet addon</b><br />
<img src="./images/addons/Male_Knight_2.gif"/>
<img src="./images/addons/Female_Knight_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>100 Behemoth Fangs</li>

<li>Damaged Steel Helmets</li>
<li>Warrior Sweat</li>
<li>Royal Steel</li>
</ul><br /><br />
<center><font size="4">Wizard Outfit</font></center><br />
<b>Skull addon</b><br />

<img src="./images/addons/Male_Wizard_2.gif"/>
<img src="./images/addons/Female_Wizard_2.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>medusa shield</li>
<li>dragon scale mail</li>
<li>crown legs</li>
<li>ring of the sky</li>
</ul><br />

<b>Greaves addon</b><br />
<img src="./images/addons/Male_Wizard_1.gif"/>
<img src="./images/addons/Female_Wizard_1.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>50 holy orchids</li>
</ul><br /><br />

<center><font size="4">Summoner Outfit</font></center><br />
<b>Robe addon</b><br />
<img src="./images/addons/Male_Summoner_2.gif"/>
<img src="./images/addons/Female_Mage_2.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>70 bat wings</li>

<li>20 red pieces of cloth</li>
<li>40 ape fur</li>
<li>35 holy orchid</li>
<li>10 spools of spider silk yarn</li>
<li>60 lizard scales</li>
<li>40 red dragon scales</li>
<li>15 magic sulphurs</li>
<li>30 vampire dusts</li>
</ul><br />

<b>Vial Belt addon</b><br />
<img src="./images/addons/Male_Summoner_1.gif"/>
<img src="./images/addons/Female_Mage_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>Winning Lottery Ticket</li>
</ul><br /><br />
<center><font size="4">Druid Outfit</font></center><br />
<b>Animal Skin addon</b><br />
<img src="./images/addons/Male_Druid_2.gif"/>

<img src="./images/addons/Female_Druid_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>60 Green Pieces of Cloth</li>
<li>100 Demon Dusts</li>

</ul><br />

<b>Bear Paws addon</b><br />
<img src="./images/addons/Male_Druid_1.gif"/>
<img src="./images/addons/Female_Druid_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>50 Bear Paws</li>
<li>50 Wolf Paws</li>
</ul><br /><br />
<center><font size="4">Oriental Outfit</font></center><br />

<b>Sabre addon</b><br />
<img src="./images/addons/Male_Oriental_1.gif"/>
<img src="./images/addons/Female_Oriental_1.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>Mermaid Comb</li>
</ul><br />

<b>Turban addon</b><br />
<img src="./images/addons/Male_Oriental_2.gif"/>

<img src="./images/addons/Female_Oriental_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>100 Ape Furs</li>
<li>100 fish fins</li>

<li>100 Blue Pieces of Cloth</li>
<li>2 Enchanted Chicken Wings</li>
</ul><br /><br />
<center><font size="4">Pirate Outfit</font></center><br />
<b>Sabre addon</b><br />
<img src="./images/addons/Male_Pirate_1.gif"/>
<img src="./images/addons/Female_Pirate_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>100 eye patches</li>

<li>100 peg legs</li>
<li>100 Hooks</li>
</ul><br />

<b>Pirate Hat addon</b><br />
<img src="./images/addons/Male_Pirate_2.gif"/>
<img src="./images/addons/Female_Pirate_2.gif"/><br /><br />

Ingredients:<br />
<ul>

<li>Ron the Ripper sabre</li>

<li>Deadeye Devious eye patch</li>
<li>Lethal Lissy shirt</li>
<li>Brutus Bloodbeard hat</li>
</ul><br /><br />
<center><font size="4">Assassin Outfit</font></center><br />
<b>Death Cloak addon</b> (First assassin addon)<br />
<img src="./images/addons/Male_Assassin_1.gif"/>
<img src="./images/addons/Female_Assassin_1.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>50 Blue Piece of Cloths</li>
<li>50 Green Piece of Cloths</li>
<li>50 Red Piece of Cloths</li>
<li>50 Brown Piece of Cloths</li>
<li>50 Yellow Piece of Cloths</li>
<li>50 White Piece of Cloths</li>
<li>10 Spider Silk Yarns = 100 Giant Spider Silks</li>
</ul><br />

<b>Sabre addon</b> (Second assassin addon)<br />
<img src="./images/addons/Male_Assassin_2.gif"/>
<img src="./images/addons/Female_Assassin_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>Nose Ring</li>
<li>30 Behemoth Claws</li>
</ul><br /><br />

<center><font size="4">Beggar Outfit</font></center><br />

<b>Beard addon</b> (First beggar addon)<br />
<img src="./images/addons/Male_Beggar_1.gif"/>
<img src="./images/addons/Female_Beggar_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>100 Ape Furs</li>
<li>2 Crystal Coins</li>
</ul><br />

<b>Staff addon</b> (Second beggar addon)<br />

<img src="./images/addons/Male_Beggar_2.gif"/>
<img src="./images/addons/Female_Beggar_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>50 Iron Ores</li>
<li>Simon the Beggar Favorite Staff</li>
</ul><br /><br />
<center><font size="4">Shaman Outfit</font></center><br />
<b>Voodoo Mask addon</b><br />
<img src="./images/addons/Male_Shaman_1.gif"/>

<img src="./images/addons/Female_Shaman_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>5 dworc vodoo dolls</li>
<li>mandrake</li>
</ul><br />

<b>Voodoo Staff addon</b><br />
<img src="./images/addons/Male_Shaman_2.gif"/>
<img src="./images/addons/Female_Shaman_2.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>5 banana staffs</li>
<li>5 tribal masks</li>
</ul><br /><br />
<center><font size="4">Warrior Outfit</font></center><br />
<b>Spiked Greaves addon</b> (First warrior addon)<br />
<img src="./images/addons/Male_Warrior_1.gif"/>
<img src="./images/addons/Female_Warrior_1.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>100 hardened bones</li>
<li>100 Turtle Shells</li>
<li>fighting spirit</li>
<li>dragon claw</li>
</ul><br />

<b>Sword on Back addon</b> (Second warrior addon)<br />
<img src="./images/addons/Male_Warrior_2.gif"/>
<img src="./images/addons/Female_Warrior_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>100 Iron Ores</li>
<li>royal steel</li>
</ul><br /><br />

<center><font size="4">Nobleman Outfit</font></center><br />
<b>Cloth addon</b><br />
<img src="./images/addons/Male_Nobleman_1.gif"/>
<img src="./images/addons/Female_Nobleman_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>15 Crystal Coins</li>
</ul><br />

<b>Top Hat addon</b><br />
<img src="./images/addons/Male_Nobleman_2.gif"/>

<img src="./images/addons/Female_Nobleman_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>15 Crystal Coins</li>

</ul><br /><br />
<center><font size="4">Barbarian Outfit</font></center><br />
<b>Barbarian Wig</b> (First barbarian addon)<br />
<img src="./images/addons/Male_Barbarian_2.gif"/>
<img src="./images/addons/Female_Barbarian_2.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>Fighting Spirit</li>
<li>Warrior Sweat</li>

<li>50 Pieces of Red Cloth</li>
<li>50 Pieces of Green Cloth</li>
<li>10 Spider Silk Yarn</li>
</ul><br />

<b>Axe</b> (Second barbarian addon)<br />
<img src="./images/addons/Male_Barbarian_1.gif"/>
<img src="./images/addons/Female_Barbarian_1.gif"/><br /><br />

Ingredients:<br />

<ul>
<li>100 Iron Ore</li>
<li>1 Huge Chunk of Crude Iron</li>
<li>50 Perfect Behemoth Fang</li>
<li>50 Lizard Leather</li>
</ul><br /><br />
<center><font size="4">Norseman Outfit</font></center><br />
<b>Spear addon</b><br />
<img src="./images/addons/Male_Norseman_1.gif"/>
<img src="./images/addons/Female_Norseman_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>5 Shards</li>

</ul><br />

<b>Hood/Earmuffs addon</b><br />
<img src="./images/addons/Male_Norseman_2.gif"/>
<img src="./images/addons/Female_Norseman_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>10 Shards</li>

</ul><br /><br />
<center><font size="4">Nightmare Outfit</font></center><br />

<b>Helmet addon</b><br />
<img src="./images/addons/Male_Nightmare_1.gif"/>
<img src="./images/addons/Female_Nightmare_1.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>Steel Helmet</li>
<li>100 Talons</li>
<li>150 Iron Ores</li>

<li>50 Green Pieces of Cloth</li>
<li>50 Red Pieces of Cloth}</li>
<li>500 Demonic Essences</li>
</ul><br />

<b>Lance and shield addon</b><br />
<img src="./images/addons/Male_Nightmare_2.gif"/>

<img src="./images/addons/Female_Nightmare_2.gif"/><br /><br />

Ingredients:<br />
<ul>
<li>Dragon Lance</li>

<li>Demon Shield</li>
<li>200 Talons</li>
<li>1500 Demonic Essences</li>';
?>

Create a file called 'faq.php' and paste this:
Code:
<?php
$main_content .= '<script type="text/javascript"><!--
function show_hide(flip)
{
    var tmp = document.getElementById(flip);
    if(tmp)
        tmp.style.display = tmp.style.display == 'none' ? '' : 'none';
}
--></script>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
    <tr bgcolor=' . $config['site']['vdarkborder'] . '>
        <td>
            <b>' . $config['site']['worlds']['0'] . ''s FAQ</b>
        </td>
</tr>';

$i = 0;
foreach($config['site']['faq'] as $q => $a)
{
    $i++;
    $main_content .= '
    <tr bgcolor="' . (is_int($i / 2) ? $config['site']['darkborder'] : $config['site']['lightborder']) . '">
        <td style="cursor: pointer;" onclick="show_hide('faq_' . $i . ''); return false;">
            ' . $q . '<div id="faq_' . $i . '" style="display: none;"> <b>' . $a . '</b></div>
        </td>
    </tr>';
}

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

Paste this is index.php under highscores:
Code:
        case "wars";
                $topic = "War Statistics";
                $subtopic = "wars";
                include("wars.php");
        break;

        case "powergamers";
                $topic = "Powergamers";
                $subtopic = "powergamers";
                include("powergamers.php");
        break;

        case "onlinetime";
                $topic = "onlinetime";
                $subtopic = "Online Time";
                include("onlinetime.php");
        break;
       
        case "killstatistics";
                $topic = "Last Kills";
                $subtopic = "killstatistics";
                include("killstatistics.php");
        break;
       
        case "houses";
                $topic = "Houses";
                $subtopic = "houses";
                include("houses.php");
        break;


You also have to add some stuff in your PhpMyAdmin, In MySQL execute (phpmyadmin -> 'SQL'):

POWERGAMERS:
Code:
ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';
and
Code:
UPDATE `players` SET `exphist_lastexp`=`players`.`experience`

GUILD WAR:
Code:
ALTER TABLE `guilds` 
ADD `invited_to` INT( 11 ) NOT NULL ,
ADD `invited_by` INT( 11 ) NOT NULL ,
ADD `in_war_with` INT( 11 ) NOT NULL ,
ADD `kills` INT( 11 ) NOT NULL ,
ADD `show` SMALLINT( 1 ) NOT NULL ,
ADD `war_time` INT( 11 ) NOT NULL ;

and
Code:
CREATE TABLE `deaths_in_wars` (
`guild_id` INT( 11 ) NOT NULL ,
`player_id` INT( 11 ) NOT NULL ,
`killer_guild` INT( 11 ) NOT NULL ,
`killer` INT( 11 ) NOT NULL ,
`date` INT( 11 ) NOT NULL ,
`result1` INT( 11 ) NOT NULL ,
`result2` INT( 11 ) NOT NULL 
) ENGINE = MYISAM ;

and
Code:
UPDATE `guilds` SET `invited_to` = 0, `invited_by` = 0, `in_war_with` = 0, `kills` = 0, `show` = 0, `war_time` = 0 WHERE `id` > 0;

Here is all scripts anyways if you need more help:
http://otland.net/f118/0-3-6-0-4-top-fragers-top-guilds-one-database-query-68893/
http://otland.net/f118/gesior-acc-maker-forgotten-server-0-3-5-powergamers-online-time-stats-44762/
http://otland.net/f118/gesior-aac-faq-script-71143/
http://otland.net/f81/fixed-guild-war-system-website-include-all-will-not-count-frags-forgotten-server-0-3-a-32157/
http://otland.net/f118/addons-list-fixed-all-layouts-73854/
 
Last edited:
i dont know, i think i will buying the system from elf, system from xampy got errors on my servers =(

PD: GOT .psd from layout? =)
 
Account maker is already installed! To reinstall open file 'config.ini' in directory 'config' and change:
install = "no"
to:
install = "start"
and enter this site again.

Now What i can do. Can u tell me pls?
 
Back
Top