<?php
$user="root";
$password="wuffy";
$database="l2live"; //Char+login DB

$nochar=false;
$voted=false;
$disp = true;
if(($_COOKIE['vote']) != '1')
{
	if(!empty($_POST['name']))
	{
		mysql_connect(localhost,$user,$password);
		@mysql_select_db($database) or die( "Unable to select database");
		$name = strtolower(mysql_real_escape_string($_POST['name']));
		$today = date("mdHi");
		$query="SELECT * FROM characters WHERE char_name='$name' LIMIT 1";
		$result = mysql_query($query);
		if($row = mysql_fetch_array($result))
		{
			$guid = $row['charId'];
			$acct = $row['account_name'];
			$res = mysql_query("SELECT * FROM votewatch WHERE account_name='$acct' LIMIT 1");
			if($r2 = mysql_fetch_array($res))
			{
				$ct = $r2['ctime'];
				if($today-$ct < 1200)
				{
					$disp = false;
					mysql_close();
					return;
				}
				else
				{
					mysql_query("DELETE FROM votewatch WHERE account_name='$acct' LIMIT 1");
				}
			}
			$reward = mysql_real_escape_string($_POST['reward']);
			if($reward == 0)
			{
				mysql_query("INSERT INTO items (owner_id, object_id, item_id, count, enchant_level, loc, loc_data, time_of_use, custom_type1, custom_type2, mana_left, time) VALUES ($guid, '0', '6673', '50000', 0 , INVENTORY , 0 , NULL , '0', '0', '-1', '-1')" );
			}
			else
			{
				mysql_query("INSERT INTO items (owner_id, object_id, item_id, count, enchant_level, loc, loc_data, time_of_use, custom_type1, custom_type2, mana_left, time) VALUES ($guid, '0', '$reward', '50000', 0 , INVENTORY , 0 , NULL , '0', '0', '-1', '-1')" );
			}
			mysql_query("INSERT INTO votewatch(acct_name, ctime) VALUES($acct, $today)");
			$voted = true;
		}
		else
		{
			$nochar = true;
		}
		mysql_close();
	}
}
else
{
	$disp = false;
}

?>
<div id='container' style='-moz-user-select: none; -khtml-user-select: none; user-select: none; cursor:default; padding-bottom:5px; width:320px; border: 4px double red; position: absolute; top:20px; left:20px; background-color:black; color:white;'>
	<div id='header' style='font-family: Arial; margin-bottom: 0.5em; border-bottom: 1px solid red; text-align: center; background-color:gray; color:#ffffff'>
		Please vote for our server!
		<span align='right' style='position:absolute; left: 305px; text-align: right;'>
			<a href='javascript:void();' style='font-size:10px; color:white; text-decoration:none;' onclick='javascript:document.getElementById("container").style.display="none";'>
				[X]
			</a>
		</span>
	</div>
	<div id='text' style='padding: 5px; padding-left: 7px; font-size: 12px; border-bottom: 1px solid red;'>
		Voting for our server helps us grow and evolve,
		and eventually become better than before.
		You can vote once every 12 hours, and you'll get a reward for doing so!
	</div>
	<form style='text-align: center; margin-bottom: 2px; margin-top: 5px;' method='post' action='index.php'>
		<div style='font-size: 12px; valign:center;'>
			Character Name:&nbsp;&nbsp;

			<input type='text' name='name' style='font-size: 12px; width: 80px; background-color: black; color: white; border: 1px solid red;' />
			<input type='submit' style='font-size: 12px; position:relative; top:1px; color:white; height: 17px; border:1px solid red; background-color:black;' value='Vote!' />
		</div>
		<div style='font-size: 12px; valign:center; margin-top: 5px; padding-top: 3px;'>
			Choose a reward:&nbsp;&nbsp;
			<select name='reward' style='background-color: black; color: white; font-family: Arial; font-size: 12px; border: 1px solid red; height: 17px; font-size: 10px;'>
				<option value='0'>10 Gold</option>
				<option value='6673'>Scroll of Agility V</option>
				<option value='27499'>Scroll of Intellect V</option>
				<option value='27500'>Scroll of Protection V</option>
				<option value='27501'>Scroll of Spirit V</option>
				<option value='27502'>Scroll of Stamina V</option>
				<option value='27503'>Scroll of Strength V</option>
			</select>
		</div>
		<?php
			if($nochar)
			{
				echo "<br /><span style='font-size: 12px; color: black; background-color:pink; padding: 3px; position: relative; top: -8px; border: 1px solid red;'>A character with that name was not found</span>";
			}
			if($voted)
			{
				echo "<br /><span style='font-size: 12px; color: white; background-color:black; padding: 3px; position: relative; top: -8px; border: 1px solid red;'>Thank you for voting!</span>";
				echo "<script language='javascript'>setTimeout(\"location.href='votegateway.php'\",3000);</script>";
			}
		?>
	</form>
</div>