Rizzla
Donator / Photoshop
Nothing special, just edited the orginal website a bit.
DOWNLOAD: tibiacom1.rar
Go to htdocs and create a file called 'wars.php' and paste this:
Create a file called 'powergamers.php' and paste this:
Create a file called 'frags.php' and paste this:
Create a file called 'addons.php' and paste this:
Create a file called 'faq.php' and paste this:
Paste this is index.php under highscores:
You also have to add some stuff in your PhpMyAdmin, In MySQL execute (phpmyadmin -> 'SQL'):
POWERGAMERS:
and
GUILD WAR:
and
and
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/
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';
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: