<?php
#################################################################################
## -= YOU MAY NOT REMOVE OR CHANGE THIS NOTICE =- ##
## --------------------------------------------------------------------------- ##
## Filename medals.php ##
## Added Rewards: aggenkeech ##
## Developed by: Dixie ##
## License: TravianX Project ##
## Copyright: TravianX (c) 2010-2011. All rights reserved. ##
## ##
#################################################################################
// Reward amounts
// 1st: 100, 2nd: 75, 3rd: 50, 4th: 40, 5th: 25, 6th-10th: 10, Bonus medals: 20 gold
// Switch to false if you want normal medal script with no rewards
define("REWARDS", true);
// Edit these if you want
$position1Reward = 100;
$position2Reward = 75;
$position3Reward = 50;
$position4Reward = 40;
$position5Reward = 25;
$position6to10Reward = 10;
$bonusMedalReward = 20;
include_once("GameEngine/Account.php");
mysql_connect(SQL_SERVER, SQL_USER, SQL_PASS);
mysql_select_db(SQL_DB);
if(mysql_num_rows(mysql_query("SELECT id FROM ".TB_PREFIX."users WHERE access = 9 AND id = ".$session->uid)) != '1') die("Hacking attemp!");
// determine which week we are
$q = "SELECT * FROM ".TB_PREFIX."medal order by week DESC LIMIT 0, 1";
$result = mysql_query($q);
if(mysql_num_rows($result))
{
$row = mysql_fetch_assoc($result);
$week = ($row['week']+1);
}
else
{
$week='1';
}
// do same for ally week
$q = "SELECT * FROM ".TB_PREFIX."allimedal order by week DESC LIMIT 0, 1";
$result = mysql_query($q);
if(mysql_num_rows($result))
{
$row = mysql_fetch_assoc($result);
$allyweek = ($row['week']+1);
}
else
{
$allyweek='1';
}
// Was the form submitted (remove the next 2 lines and the } at th end of this code block to automate e.g cronjob)
if(isset($_GET['giveout']))
{
// Attackers of the week
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY ap DESC Limit 10");
$i = 0;
while($row = mysql_fetch_array($result))
{
$i++;
$img="t2_".($i)."";
$quer = "insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '1', '".($i)."', '".$week."', '".$row['ap']."', '".$img."')";
$resul = mysql_query($quer);
if(REWARDS == true)
{
if($i == 1) { $reward = $position1Reward; }
elseif($i == 2) { $reward = $position2Reward; }
elseif($i == 3) { $reward = $position3Reward; }
elseif($i == 4) { $reward = $position4Reward; }
elseif($i == 5) { $reward = $position5Reward; }
else { $reward = $position6to10Reward; }
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$reward." WHERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
// Defenders of the week
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY dp DESC Limit 10");
$i=0;
while($row = mysql_fetch_array($result))
{
$i++;
$img = "t3_".($i)."";
$quer = "insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '2', '".($i)."', '".$week."', '".$row['dp']."', '".$img."')";
$resul = mysql_query($quer);
if(REWARDS == true)
{
if($i == 1) { $reward = $position1Reward; }
elseif($i == 2) { $reward = $position2Reward; }
elseif($i == 3) { $reward = $position3Reward; }
elseif($i == 4) { $reward = $position4Reward; }
elseif($i == 5) { $reward = $position5Reward; }
else { $reward = $position6to10Reward; }
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$reward." WHERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
// Rank climbers of the week
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY clp DESC Limit 10");
$i=0;
while($row = mysql_fetch_array($result))
{
$i++;
$img="t1_".($i)."";
$quer = "insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '10', '".($i)."', '".$week."', '".$row['clp']."', '".$img."')";
$resul = mysql_query($quer);
if(REWARDS == true)
{
if($i == 1) { $reward = $position1Reward; }
elseif($i == 2) { $reward = $position2Reward; }
elseif($i == 3) { $reward = $position3Reward; }
elseif($i == 4) { $reward = $position4Reward; }
elseif($i == 5) { $reward = $position5Reward; }
else { $reward = $position6to10Reward; }
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$reward." WHERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
// Robbers of the week
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY RR DESC Limit 10");
$i=0;
while($row = mysql_fetch_array($result))
{
if($row['RR'] >= 0)
{
$i++;
$img="t4_".($i)."";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '4', '".($i)."', '".$week."', '".$row['RR']."', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
if($i == 1) { $reward = $position1Reward; }
elseif($i == 2) { $reward = $position2Reward; }
elseif($i == 3) { $reward = $position3Reward; }
elseif($i == 4) { $reward = $position4Reward; }
elseif($i == 5) { $reward = $position5Reward; }
else { $reward = $position6to10Reward; }
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$reward." WHERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
// part of the bonus attack + defense from top 10
// Get the top 10 attackers
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY ap DESC Limit 10");
while($row = mysql_fetch_array($result))
{
// Get the top 10 defenders
$result2 = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY dp DESC Limit 10");
while($row2 = mysql_fetch_array($result2))
{
if($row['id']==$row2['id'])
{
$query3="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 5";
$result3=mysql_query($query3);
$row3=mysql_fetch_row($result3);
// see what color the ribbon must have
if($row3[0]<='2')
{
$img="t22".$row3[0]."_1";
switch ($row3[0])
{
case "0":
$tekst="";
break;
case "1":
$tekst="twice ";
break;
case "2":
$tekst="three times ";
break;
}
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '5', '0', '".$week."', '".$tekst."', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
}
}
// you stand for 3rd / 5th / 10th time in the top 3 attackers
// Get the top 10 attackers
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY ap DESC Limit 10");
while($row = mysql_fetch_array($result))
{
$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 1 AND plaats<=3";
$result1=mysql_query($query1);
$row1=mysql_fetch_row($result1);
// 2 weeks already, give bronze
if($row1[0]=='3')
{
$img="t120_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '6', '0', '".$week."', 'Three', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
// 4 weeks already, give silver
if($row1[0]=='5')
{
$img="t121_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '6', '0', '".$week."', 'Five', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
// 9 weeks already, give gold
if($row1[0]=='10')
{
$img="t122_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '6', '0', '".$week."', 'Ten', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
// attacker bonus medals again
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY ap DESC Limit 10");
while($row = mysql_fetch_array($result))
{
$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 1 AND plaats<=10";
$result1=mysql_query($query1);
$row1=mysql_fetch_row($result1);
//2 already, give bronze
if($row1[0]=='3')
{
$img="t130_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '12', '0', '".$week."', 'Three', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//4 already, give silver
if($row1[0]=='5')
{
$img="t131_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '12', '0', '".$week."', 'Five', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//9 already give gold
if($row1[0]=='10')
{
$img="t132_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '12', '0', '".$week."', 'Ten', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
// Def bonus medals
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY dp DESC Limit 10");
while($row = mysql_fetch_array($result))
{
$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 2 AND plaats<=3";
$result1=mysql_query($query1);
$row1=mysql_fetch_row($result1);
//2 times already give bronze
if($row1[0]=='3')
{
$img="t140_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '7', '0', '".$week."', 'Three', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//4 already, give silver
if($row1[0]=='5')
{
$img="t141_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '7', '0', '".$week."', 'Five', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//9 times already, give gold
if($row1[0]=='10')
{
$img="t142_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '7', '0', '".$week."', 'Ten', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
// you stand for 3rd / 5th / 10th time in the top 3 defenders
// Get the top 10 defenders
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY dp DESC Limit 10");
while($row = mysql_fetch_array($result))
{
$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 2 AND plaats<=10";
$result1=mysql_query($query1);
$row1=mysql_fetch_row($result1);
//2 times already, give bronze
if($row1[0]=='3')
{
$img="t150_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '13', '0', '".$week."', 'Three', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//4 times already, give silver
if($row1[0]=='5')
{
$img="t151_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '13', '0', '".$week."', 'Five', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//9 times already, give gold
if($row1[0]=='10')
{
$img="t152_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '13', '0', '".$week."', 'Ten', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
// you stand for 3rd / 5th / 10th time in the top 3 climbers
// Get the top 10 climbers
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY Rc DESC Limit 10");
while($row = mysql_fetch_array($result))
{
$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 3 AND plaats<=3";
$result1=mysql_query($query1);
$row1=mysql_fetch_row($result1);
//2 times already, give bronze
if($row1[0]=='3')
{
$img="t100_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '8', '0', '".$week."', 'Three', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//4 times already give silver
if($row1[0]=='5')
{
$img="t101_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '8', '0', '".$week."', 'Five', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//9 times already, give gold
if($row1[0]=='10')
{
$img="t102_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '8', '0', '".$week."', 'Ten', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
// you stand for 3rd / 5th / 10th time in the top 3 climbers
// Get the top 10 climbers
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY Rc DESC Limit 10");
while($row = mysql_fetch_array($result))
{
$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 3 AND plaats<=10";
$result1=mysql_query($query1);
$row1=mysql_fetch_row($result1);
//2 times already give bronze
if($row1[0]=='3')
{
$img="t110_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '14', '0', '".$week."', 'Three', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//4 times already give silver
if($row1[0]=='5')
{
$img="t111_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '14', '0', '".$week."', 'Five', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//9 times already give gold
if($row1[0]=='10')
{
$img="t112_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '14', '0', '".$week."', 'Ten', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
// you stand for 3rd / 5th / 10th time in the top 3 climbers
// Get the top3 rank climbers
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY clp DESC Limit 10");
while($row = mysql_fetch_array($result))
{
$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 10 AND plaats<=3";
$result1=mysql_query($query1);
$row1=mysql_fetch_row($result1);
//2 times already give bronze
if($row1[0]=='3')
{
$img="t200_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '11', '0', '".$week."', 'Three', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//4 times already give silver
if($row1[0]=='5')
{
$img="t201_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '11', '0', '".$week."', 'Five', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//9 times already, give gold
if($row1[0]=='10')
{
$img="t202_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '11', '0', '".$week."', 'Ten', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
// you stand for 3rd / 5th / 10th time in the top 10klimmers
// Get the top3 rank climbers
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY clp DESC Limit 10");
while($row = mysql_fetch_array($result))
{
$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 10 AND plaats<=10";
$result1=mysql_query($query1);
$row1=mysql_fetch_row($result1);
//2 times already give bronze
if($row1[0]=='3')
{
$img="t210_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '16', '0', '".$week."', 'Three', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//4 times already, give silver
if($row1[0]=='5')
{
$img="t211_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '16', '0', '".$week."', 'Five', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//9 times already, give gold
if($row1[0]=='10')
{
$img="t212_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '16', '0', '".$week."', 'Ten', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
//je staat voor 3e / 5e / 10e keer in de top 10 overvallers
//Pak de top10 overvallers
// RAIDERS
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY RR DESC Limit 10");
while($row = mysql_fetch_array($result))
{
$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 4 AND plaats<=3";
$result1=mysql_query($query1);
$row1=mysql_fetch_row($result1);
//2x in gestaan, dit is 3e dus lintje (brons)
if($row1[0]=='3')
{
$img="t160_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '9', '0', '".$week."', 'Three', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//4x in gestaan, dit is 5e dus lintje (zilver)
if($row1[0]=='5')
{
$img="t161_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '9', '0', '".$week."', 'Five', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//9x in gestaan, dit is 10e dus lintje (goud)
if($row1[0]=='10')
{
$img="t162_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '9', '0', '".$week."', 'Ten', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
//je staat voor 3e / 5e / 10e keer in de top 10 overvallers
//Pak de top10 overvallers
$result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY RR DESC Limit 10");
while($row = mysql_fetch_array($result))
{
$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 4 AND plaats<=10";
$result1=mysql_query($query1);
$row1=mysql_fetch_row($result1);
//2x in gestaan, dit is 3e dus lintje (brons)
if($row1[0]=='3')
{
$img="t170_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '15', '0', '".$week."', 'Three', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//4x in gestaan, dit is 5e dus lintje (zilver)
if($row1[0]=='5')
{
$img="t171_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '15', '0', '".$week."', 'Five', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
//9x in gestaan, dit is 10e dus lintje (goud)
if($row1[0]=='10')
{
$img="t172_1";
$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '15', '0', '".$week."', 'Ten', '".$img."')";
$resul=mysql_query($quer);
if(REWARDS == true)
{
$sql = "UPDATE ".TB_PREFIX."users SET gold = gold + ".$bonusMedalReward." WERE id = ".$row['id']."";
$query = mysql_query($sql);
}
}
}
// Reset all player medal stats
$query="SELECT * FROM ".TB_PREFIX."users WHERE id > 5 ORDER BY id+0 DESC";
$result=mysql_query($query);
for ($i=0; $row=mysql_fetch_row($result); $i++)
{
mysql_query("UPDATE ".TB_PREFIX."users SET ap=0, dp=0,Rc=0,clp=0, RR=0 WHERE id = ".$row[0]."");
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Start alliance Medals
//attackers
$result = mysql_query("SELECT * FROM ".TB_PREFIX."alidata ORDER BY ap DESC Limit 10");
$i=0;
while($row = mysql_fetch_array($result))
{
$i++;
$img="a2_".($i)."";
$quer="insert into ".TB_PREFIX."allimedal(allyid, categorie, plaats, week, points, img) values('".$row['id']."', '1', '".($i)."', '".$allyweek."', '".$row['ap']."', '".$img."')";
$resul=mysql_query($quer);
}
//defenders
$result = mysql_query("SELECT * FROM ".TB_PREFIX."alidata ORDER BY dp DESC Limit 10");
$i=0;
while($row = mysql_fetch_array($result))
{
$i++;
$img="a3_".($i)."";
$quer="insert into ".TB_PREFIX."allimedal(allyid, categorie, plaats, week, points, img) values('".$row['id']."', '2', '".($i)."', '".$allyweek."', '".$row['dp']."', '".$img."')";
$resul=mysql_query($quer);
}
//Overvallers v/d Week
$result = mysql_query("SELECT * FROM ".TB_PREFIX."alidata ORDER BY RR DESC Limit 10");
$i=0;
while($row = mysql_fetch_array($result))
{
if($row['RR'] >= 0)
{
$i++;
$img="a4_".($i)."";
$quer="insert into ".TB_PREFIX."allimedal(allyid, categorie, plaats, week, points, img) values('".$row['id']."', '4', '".($i)."', '".$allyweek."', '".$row['RR']."', '".$img."')";
$resul=mysql_query($quer);
}
}
//Rank climbers of the week
$result = mysql_query("SELECT * FROM ".TB_PREFIX."alidata ORDER BY clp DESC Limit 10");
$i=0;
while($row = mysql_fetch_array($result))
{
$i++;
$img="a1_".($i)."";
$quer="insert into ".TB_PREFIX."allimedal(allyid, categorie, plaats, week, points, img) values('".$row['id']."', '3', '".($i)."', '".$allyweek."', '".$row['clp']."', '".$img."')";
$resul=mysql_query($quer);
}
// Reset alliance medal stats
$query="SELECT * FROM ".TB_PREFIX."alidata ORDER BY id+0 DESC";
$result=mysql_query($query);
for($i=0; $row=mysql_fetch_row($result); $i++)
{
mysql_query("UPDATE ".TB_PREFIX."alidata SET ap=0, dp=0, RR=0, clp=0 WHERE id = ".$row[0]."");
}
} // end of has form been submitted
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title><?php echo SERVER_NAME ?></title>
<link REL="shortcut icon" HREF="favicon.ico"/>
<meta http-equiv="cache-control" content="max-age=0" />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="expires" content="0" />
<meta http-equiv="imagetoolbar" content="no" />
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<script src="mt-full.js?0ac36" type="text/javascript"></script>
<script src="unx.js?0ac36" type="text/javascript"></script>
<script src="new.js?0ac36" type="text/javascript"></script>
<link href="<?php echo GP_LOCATE; ?>lang/en/lang.css?f4b7c" rel="stylesheet" type="text/css" />
<link href="<?php echo GP_LOCATE; ?>lang/en/compact.css?f4b7c" rel="stylesheet" type="text/css" />
<?php
if($session->gpack == null || GP_ENABLE == false)
{
echo "<link href='".GP_LOCATE."travian.css?e21d2' rel='stylesheet' type='text/css' />
<link href='".GP_LOCATE."lang/en/lang.css?e21d2' rel='stylesheet' type='text/css' />";
}
else
{
echo "<link href='".$session->gpack."travian.css?e21d2' rel='stylesheet' type='text/css' />
<link href='".$session->gpack."lang/en/lang.css?e21d2' rel='stylesheet' type='text/css' />";
}
?>
<script type="text/javascript">
window.addEvent('domready', start);
</script>
</head>
<body class="v35 ie ie8">
<div class="wrapper">
<img style="filter:chroma();" src="img/x.gif" id="msfilter" alt="" />
<div id="dynamic_header"></div>
<?php include("Templates/header.tpl"); ?>
<div id="mid">
<?php include("Templates/menu.tpl"); ?>
<div id="content" class="login">
<?php
if(isset($_GET['giveout']))
{?>
<h1>Top 10 Medals</h1><br />
Done:<br />
-Top 10 Attacker<br />
-Top 10 Defender<br />
-Top 10 Robbers<br />
-Top 10 Alliance Attacker<br />
-Top 10 Alliance Defencer<br />
-Top 10 Alliance Robbers<br />
-Top 10 Alliance Climbers<br />
-Top 10 Rank Climbers<br />
-Bonus: Attacker AND Defender<br />
-Bonus: 3/5/10 times in a row top 3 Rank Climbers<br />
-Bonus: 3/5/10 times top 3 Attack<br />
-Bonus: 3/5/10 times top 3 Defence<br />
-Bonus: 3/5/10 times top 3 Robber<br />
-Bonus: 3/5/10 times in a row top 10 Attack<br />
-Bonus: 3/5/10 times in a row top 10 Defence<br />
-Bonus: 3/5/10 times in a row top 10 Rank Climbers<br />
-Bonus: 3/5/10 times in a row top 10 Robber<br />
<?php
if(REWARDS == true)
{ ?>
-Gold Rewards<br /><?php
}
}
else
{ ?>
<h1><br/>Top 10 Medals</h1><br />
Click <a href="?giveout">here</a>, to give the medals away for <b>week <?php echo $week; ?></b>!
<br/>WARNING: Loading next page can take some time!<?php
} ?>
</div>
<div id="side_info" class="outgame"></div>
<div class="clear"></div>
</div>
<div class="footer-stopper outgame"></div>
<div class="clear"></div>
<?php include("Templates/footer.tpl"); ?>
<div id="ce"></div>
</body>
</html>
<?php mysql_close(); ?>