<?php

	$connectionid = mysql_connect ("localhost", "testme", "sippe123");
	if (!mysql_select_db ("testme", $connectionid))
	{
		die ("Keine Verbindung zur Datenbank");
	}
	$szName = $_POST['Name'];
	$szPWD = $_POST['PWD'];
	$szHWID = $_POST['HWID'];
	if( $_POST['Reason'] == 'Information' )
	{
		$user = $szName;
		$pw = $szPWD;
		$qry = mysql_query("SELECT * FROM `user` WHERE (username like '".$user."')");
		$myHWID = $szHWID;
		$userid;

		while($sys=mysql_fetch_array($qry))
		{
			$password = md5(md5($pw).$sys['salt']);
			$userid = $sys['userid'];
		}

		$sql = "SELECT ".
				"* ".
				"FROM ".
				"user ".
				"WHERE ".
				"(username like '".$user."') AND ".
				"(password = '".$password."')";
		$result = mysql_query ($sql);

		if( !$result )
		{
			die ('InformationError1\r\n');
		}
		echo "HackInformation\r\n";

		while($UserInfo = mysql_fetch_array($result))
		{

			$qrysubs2 = mysql_query("SELECT * FROM `subscriptionlog` WHERE (userid like '".$userid."')");

			if( !$qrysubs2 )
			{
				die ('InformationError2\r\n');
			}
			while($subinfo2 = mysql_fetch_array($qrysubs2))
			{
				if( $subinfo2['status'] == 1)
				{
					if($subinfo2['HWID'] == $myHWID)
					{
						echo "Confirmed\r\n";
						break;
					}
					else if($subinfo2['HWID'] == 0)
					{
						$aendern = "UPDATE subscriptionlog Set HWID='".$myHWID."' WHERE userid = '".$userid."'";
						$update = mysql_query($aendern);

						echo "Confirmed\r\n";
						break;
					}
					else if($subinfo2['HWID'] != $myHWID)
					{
						die ('ERROR HWID\r\n');
					}
				}
			}

			$qrysubs = mysql_query("SELECT * FROM `subscriptionlog` WHERE (userid like '".$userid."')");

			if( !$qrysubs )
			{
				die ('InformationError3\r\n');
			}

			while($subinfo = mysql_fetch_array($qrysubs))
			{
				if( $subinfo['status'] == 1)
				{
					if($subinfo['HWID'] == $myHWID)
					{
						$qryinfo = mysql_query("SELECT * FROM `IniuriaProducts` WHERE (subid like '".$subinfo['subscriptionid']."')");
						while($Products = mysql_fetch_array($qryinfo))
						{
							$datum = date("d.m.Y H:i",$subinfo['expirydate']);
							echo '\zProduct:'.$Products['Product'].'\nType:'.$Products['Type'].'\nGame:'.$Products['Game'].'\nProductInformation:'.$Products['Information'].'\nDetection:'.$Products['DetectionState'].'\nExpires:'.$datum.'';
							break;
						}
					}
				}
			}
		}
		return;
	}
?>