[Webseite] Spieler Informationen

$query = mysql_query ("SELECT playerid, name, cash, bankacc, civ_licenses FROM players");
		$weblink = $_SESSION['weblink'];
	while ($row = mysql_fetch_assoc($query))
	{
		if ( $row['playerid'] == $_POST["playerid"] ) {

			$_SESSION['playerID'] = $row['playerid'];
			$_SESSION['playerName'] = $row['name'];
			$_SESSION['playerCash'] = $row['cash'];
			$_SESSION['playerBank'] = $row['bankacc'];
			$_SESSION['playerLizenzen'] = $row['civ_licenses'];
			header("Location: $weblink/playerAnzeige.php");

		} else {




			header("Location: $weblink");

		}
	}

$query = mysql_query ("SELECT playerid, name, cash, bankacc, civ_licenses FROM players WHERE playerid = ".mysql_real_escape_string($_POST['playerid']) ." LIMIT 1");
	if (mysqli_num_rows($result) == 1) {
		$row = mysql_fetch_assoc($query);
		$_SESSION['playerID'] = $row['playerid'];
		$_SESSION['playerName'] = $row['name'];
		$_SESSION['playerCash'] = $row['cash'];
		$_SESSION['playerBank'] = $row['bankacc'];
		$_SESSION['playerLizenzen'] = $row['civ_licenses'];
	        header("Location: ".$_SESSION['weblink']."/playerAnzeige.php");
	} else {
		header("Location: ".$_SESSION['weblink']);
	}

while ($row = mysql_fetch_assoc($query))
	{
		if ( $row['playerid'] == $_POST["playerid"] ) {
			$_SESSION['playerID'] = $row['playerid'];
			$_SESSION['playerName'] = $row['name'];
			$_SESSION['playerCash'] = $row['cash'];
			$_SESSION['playerBank'] = $row['bankacc'];
			$_SESSION['playerLizenzen'] = $row['civ_licenses'];
			header("Location: $weblink/playerAnzeige.php");
		} else {




			header("Location: $weblink");
		}
	}

<?php
	/*
		Author: Multivitamin <multivitamin.wtf>
	*/







	session_start();
	if (!empty($_GET['logout'])) session_destroy();
	$error = [];
	$config = [];
	$license_trans = [];




	/*
		##############################################################
		##	DATABASE AUTHENTICATION									##
		##	AND STEAM API KEY 										##
		##############################################################
	*/
	$config['db_ip'] = '127.0.0.1';		//Database IP Adress
	$config['db_port'] = 3306;			//Database Port
	$config['db_user'] = '';		//Database Username
	$config['db_pass'] = '';			//Database User Password
	$config['db_table'] = 'altislife';	//Database Table
	$config['steam_api_key'] = '';		//Steam API Key from http://steamcommunity.com/dev/apikey




	/*
		##############################################################
		##    License Translations									##
		##    You will need to extend these licenses 				##
		##############################################################
	*/
	$license_trans['license_civ_driver'] = 'Driver License';
	$license_trans['license_civ_boat'] = 'Boating License';
	$license_trans['license_cop_cg'] = 'Coast Guard';
















	/*
		##############################################################
		##    Script here	 										##
		##	  Do not Edit if you dont want to break things			##
		##############################################################
	*/
	function parseLicense($string) {
		$return = [];
		if (preg_match_all("/\[{1,2}`([A-z0-9-_]{1,})`,(0|1)\][,|\]]/i", $string, $out)) {
			for ($i = 1; $i <= count($out[1]); $i++) {
				if ($out[2][$i-1]) $return[] = $out[1][$i-1];
			}
		}
		return $return;
	}







	require_once('openid.php');
	$openid = new LightOpenId($_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI']);	    
	if(!$openid->mode) {
        if(isset($_GET['login'])) {
            $openid->identity = 'http://steamcommunity.com/openid/';
            header('Location: ' . $openid->authUrl());
        }
    } elseif($openid->mode != 'cancel') {
        if($openid->validate()) {
            $id = $openid->identity;
            $ptn = "/^http:\/\/steamcommunity\.com\/openid\/id\/(7[0-9]{15,25}+)$/";
            preg_match($ptn, $id, $matches);
            $url = "http://api.steampowered.com/ISteamUser/GetPlayerSummaries/v0002/?key=".$config['steam_api_key']."&steamids=".$matches[1];
            $players = json_decode(file_get_contents($url),1)['response']['players'];
            if (count($players) == 1) $_SESSION['steamid'] = $players[0]['steamid'];
        }
    }




    if (!empty($_SESSION['steamid'])) {
		$conn = new mysqli($config['db_ip'], $config['db_user'], $config['db_pass'], $config['db_table'], $config['db_port']);
		if ($conn->connect_errno) {
		    $error[] = ['danger', 'Failed to connect to MySQL: '.$conn->connect_error];
		} else {
			$result = $conn->query(
				'SELECT 
					p.name,
					p.aliases,
					p.cash,
					p.bankacc,
					p.coplevel,
					p.mediclevel,
					p.civ_licenses,
					p.cop_licenses,
					p.med_licenses,
					p.civ_stats,
					p.cop_stats,
					p.med_stats,
					p.arrested
				FROM players p
				WHERE p.playerid = '.$conn->escape_string($_SESSION['steamid']) .'
				LIMIT 1'
			);
			if ($result->num_rows == 1) {
				$data = $result->fetch_assoc();
				$data['parsed_license_civ'] = parseLicense($data['civ_licenses']);
				$data['parsed_license_cop'] = parseLicense($data['cop_licenses']);
				$data['parsed_license_med'] = parseLicense($data['med_licenses']);
				$error[] = ['success', 'Welcome <b>'.$data['name'].'</b>!'];
			} else if ($result->num_rows < 1) {
				$error[] = ['info', 'User with SteamID <b>'.$_SESSION['steamid'].'</b> has not been found in our Database!'];
			} else {
				$error[] = ['danger', 'Error! There are duplicates in our Database!'];
			}
		}
	}
?>
<html>
	<head>
		<title>ArmA Player Info</title>
		<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
	</head>
	<body>
		<div class="container" style="padding-top:3%">
			<?php foreach ($error as $err) { ?> 
				<div class="alert alert-<?php echo $err[0] ?>" role="alert"><?php echo $err[1]; ?></div>
			<?php } ?>
			<?php if (!empty($data)) { ?>
				<div class="panel panel-default">
					<table class="table">







						<tr class="active">
							<td colspan="2">
								General
							</td>
						<tr>
						<tr>
							<td>CASH</td>
							<td><?php echo $data['cash'] ?>$</td>
						</tr>
						<tr>
							<td>ATM</td>
							<td><?php echo $data['bankacc'] ?>$</td>
						</tr>
						<tr>







						<!-- CIVILIAN -->
						<tr class="info">
							<td colspan="2">
								Civilian
							</td>
						<tr>
						<tr>
							<td>Arrested</td>
							<td><?php echo $data['arrested'] ?></td>
						</tr>
						<tr>
							<td>Hunger</td>
							<td><?php echo preg_match("/\[([0-9]{1,}),[0-9]{1,}\]/i", $data['civ_stats'], $out) ? $out[1].'%' : "100%"; ?></td>
						</tr>
						<tr>
							<td>Thirst</td>
							<td><?php echo preg_match("/\[[0-9]{1,},([0-9]{1,})\]/i", $data['civ_stats'], $out) ? $out[1].'%' : "100%"; ?></td>
						</tr>
						<tr>
							<td>Licenses</td>
							<td><?php if (!$data['parsed_license_civ']) echo 'NONE'; ?></td>
						</tr>
						<?php if ($data['parsed_license_civ']) { foreach ($data['parsed_license_civ'] as $l) { ?>
						<tr>
							<td></td>
							<td><?php echo array_key_exists($l, $license_trans) ? $license_trans[$l] : $l; ?></td>
						</tr>
						<?php }} ?>










						<!-- COP -->
						<?php if ($data['coplevel'] > 0) { ?>
							<tr class="info">
								<td colspan="2">
									Cop
								</td>
							<tr>
							<tr>
								<td>Level</td>
								<td><?php echo $data['coplevel'] ?></td>
							</tr>
							<tr>
								<td>Hunger</td>
								<td><?php echo preg_match("/\[([0-9]{1,}),[0-9]{1,}\]/i", $data['cop_stats'], $out) ? $out[1].'%' : "100%"; ?></td>
							</tr>
							<tr>
								<td>Thirst</td>
								<td><?php echo preg_match("/\[[0-9]{1,},([0-9]{1,})\]/i", $data['cop_stats'], $out) ? $out[1].'%' : "100%"; ?></td>
							</tr>
							<tr>
								<td>Licenses</td>
								<td><?php if (!$data['parsed_license_cop']) echo 'NONE'; ?></td>
							</tr>
							<?php if ($data['parsed_license_cop']) { foreach ($data['parsed_license_cop'] as $l) { ?>
							<tr>
								<td></td>
								<td><?php echo array_key_exists($l, $license_trans) ? $license_trans[$l] : $l; ?></td>
							</tr>
							<?php }} ?>
						<?php } ?>







						<!-- MEDICLEVEL -->
						<?php if ($data['mediclevel'] > 0) { ?>
							<tr class="info">
								<td colspan="2">
									Medic
								</td>
							<tr>
							<tr>
								<td>Level</td>
								<td><?php echo $data['mediclevel'] ?></td>
							</tr>
							<tr>
								<td>Hunger</td>
								<td><?php echo preg_match("/\[([0-9]{1,}),[0-9]{1,}\]/i", $data['med_stats'], $out) ? $out[1].'%' : "100%"; ?></td>
							</tr>
							<tr>
								<td>Thirst</td>
								<td><?php echo preg_match("/\[[0-9]{1,},([0-9]{1,})\]/i", $data['med_stats'], $out) ? $out[1].'%' : "100%"; ?></td>
							</tr>
							<tr>
								<td>Licenses</td>
								<td><?php if (!$data['parsed_license_med']) echo 'NONE'; ?></td>
							</tr>
							<?php if ($data['parsed_license_med']) { foreach ($data['parsed_license_med'] as $l) { ?>
							<tr>
								<td></td>
								<td><?php echo array_key_exists($l, $license_trans) ? $license_trans[$l] : $l; ?></td>
							</tr>
							<?php }} ?>
						<?php } ?>







						</tr>
					</table>
				</div>
			<?php } else if (empty($_SESSION['steamid'])) { ?>
				<div class="jumbotron">
					<h1>Get Access to your Ingame Data!</h1>
					<p>Sign in through Steam!</p>
					<p><form action="?login" method="POST"><input type="image" src="http://cdn.steamcommunity.com/public/images/signinthroughsteam/sits_small.png"></form></p>
				</div>
			<?php }; ?>
		</div>
	</body>
</html>