Vip System kod

</ul>

<font color="blue"><h1>Aktivera</h1></font>
<?php
	if (empty($_POST['vipcode']) || empty($_POST['steamid']))
	{
	}
	else
	{
		if (!preg_match('/^STEAM_(0|1):(0|1):\d{5,11}$/', $_POST['steamid']))
		{
			echo '<span style="color: #FF0000;">Det angivna Steam-ID:t är ogiltigt.</span>';
		}
		else
		{
              mysql_connect('83.168.227.169:3306', 'u1172440_adsa', '******');
              mysql_select_db('db1172440_asddasdsa');

			function db_escape ($post)
			{
				if (is_string($post))
				{
					if (get_magic_quotes_gpc())
					{
						$post = stripslashes($post);
					}
					return mysql_real_escape_string($post);
				}

				foreach ($post as $key => $val)
				{
					$post[$key] = db_escape($val);
				}

				return $post;
			}

			else
			{
				$vipcode = db_escape($_POST['vipcode']);
				$sql = "SELECT id FROM vip WHERE code='$vipcode'";
				$result = mysql_query($sql) or die(mysql_error());
				if (mysql_num_rows($result) > 0)
				{
					$steamid = db_escape($_POST['steamid']);
					mysql_query("UPDATE smf_members SET id_group = 7 WHERE id_member = " . mysql_result($forumuserid, 0) . " AND id_group = 0") or die(mysql_error());
					mysql_query("INSERT INTO sb_admins(user, authid, password, gid, email, validate, extraflags, srv_group, expire)
							VALUES('{$_POST['forumusername']}', '$steamid', '794db403ff612717abdf7bd7e7a7a98f147106eb', -1, (SELECT email_address FROM smf_members WHERE id_member = " . mysql_result($forumuserid, 0) . "), 0, 0, 'VIP', '$tid')");

					$sb_uid = mysql_insert_id();
					mysql_query("INSERT INTO sb_admins_servers_groups (admin_id, group_id, srv_group_id, server_id) VALUES($sb_uid, 1, -1, 1)");
                                        mysql_query("INSERT INTO sb_admins_servers_groups (admin_id, group_id, srv_group_id, server_id) VALUES($sb_uid, 1, -1, 2)");
                                        mysql_query("INSERT INTO sb_admins_servers_groups (admin_id, group_id, srv_group_id, server_id) VALUES($sb_uid, 1, -1, 3)");


					mysql_query("DELETE FROM vip WHERE id = " . mysql_result($result, 0));

					echo 'VIP har blivit aktiverat för forumkontot <b>' . '</b> och Steam-ID <b>' . $steamid . '</b>.';
				}
				else
				{
					echo '<span style="color: #FF0000;">Den angivna VIP koden är ogiltig.</span>';
				}
			}
		}
	}

echo '        
    <form action="" method="post">
	<table>
    	<tr>
			<td><b><font color="black">Forums namn:</font></b></td>
			<td><input type="text" name="forumusername" /></td>
		</tr>
		<tr>
			<td><b><font color="black">VIP kod:</font></b></td>
			<td><input type="text" name="vipcode" /></td>
		</tr>
		<tr>
			<td><b><font color="black">STEAMID:</font></b></td>
			<td><input type="text" name="steamid" /></td>
		</tr>
		<tr>
			<td> </td>
			<td><input type="submit" name="vip_activate" value="Aktivera din VIP" /></td>
		</tr>
	</table>
    
</form>
';
?>
</font></font>
</html>