• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Gold in Users

Status
Not open for further replies.
sonikboy

sonikboy

Skilled Illusionist
10 Happy Years
Joined
Sep 5, 2011
Messages
360
Reaction score
14
good day

I need help

I want to put in the delivery of medals that were tb gold Deliver
example

the first striker gold = 20
the first defender = 20 gold
each classification gold x

thank you
 
The Best DDoS Protected Servers
allycol93

allycol93

Junior Spellweaver
Joined
Jan 7, 2012
Messages
147
Reaction score
100
TravianZ could be easy enough, don't know about dboor though.

I may make a TravianZ one because I haven't done anything clone related in a while




OK, I have done it, it was fairly easy to do, i'm sure it works ok, I took the medal script straight from yi12345 github (I tested on localost (just editing db))

You can switch rewards off.

1st place: 100 gold
2nd place: 75 gold
3rd place: 50 gold
4th place: 40 gold
5th place: 25 gold
6th place: 10 gold
7th place: 10 gold
8th place: 10 gold
9th place: 10 gold
10th place: 10 gold

Bonus medals: 20 gold

Bonus medals are top 3 for x weeks, attack and def in same week etc, these all can be edited.


Replace medals.php with:


PHP: 
<?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(); ?>
 
sonikboy

sonikboy

Skilled Illusionist
10 Happy Years
Joined
Sep 5, 2011
Messages
360
Reaction score
14
thank you

Better and faster could not
be thou art big thank people like that are what makes this the best forum
 
abofrfor

abofrfor

Newbie Spellweaver
Joined
Jun 11, 2012
Messages
25
Reaction score
1
Good man .. Thank you

Excellent code works correctly
 
Apsaugininkas

Apsaugininkas

Newbie Spellweaver
Joined
Sep 26, 2011
Messages
46
Reaction score
0
That system works when update top10 and where give that gold on Attackers, Defender, Robers and reward SUM?
 
Status
Not open for further replies.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
166
Guests online
11,979
Total visitors
12,145
Totals may include hidden visitors.

Forum statistics

Threads
429,198
Messages
4,590,913
Members
281,307
Latest member
ismodev
Most visitors online was 12720 , on 2 May 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top