X31zM2E9

1<?php
2//get_gamedata.php
3
4
5
6
7include("config.php");
8if($_GET["apireqkey"]==$requestapikey){
9	
10}
11else{
12	die("Wrong api request key!");
13}
14
15echo "hmm";
16
17/////////////////////LOCATION DATA/////////////////////////////////
18if($_GET["func"]=="location"){
19//connection to api
20$mysqli = new mysqli($dbhost, $dbusername, $dbpassword, $dbname);
21
22
23if (mysqli_connect_errno()) {
24    printf("Connect failed: %s\n", mysqli_connect_error());
25    exit();
26}
27
28$charID = $_GET["charID"];
29
30
31$query = "SELECT `chars`.`LocationID`, `chars`.`id`, `locations`.* FROM `chars` LEFT JOIN `locations` ON `chars`.`LocationID` = `locations`.`id` WHERE `chars`.`id` = '$charID'";
32
33if ($stmt = $mysqli->prepare($query)) {
34    $stmt->execute();
35    $stmt->bind_result($userloc, $userID, $locationID, $locationName, $locationGraphic, $locationInventory);
36    $stmt->fetch();
37     echo "{";
38	 echo '"locationID": "' . $userloc . '",';
39        echo '"locationName": "' . $locationName . '",';
40         echo '"locationGraphic": "' . $locationGraphic . '",';
41			echo '"locationInv": "' . $locationInventory . '"';
42        echo "}";
43    
44
45    /* close statement */
46    $stmt->close();
47}
48
49/* close connection */
50$mysqli->close();
51
52}
53
54?>