function petInfoSetup()
{
include '../library/server.config.php';
include_once '../library/opendb.php';
$string = file_get_contents("../library/pet-types.json");
$pet_type = json_decode($string, true);
$db_socket = initSocket();
$query = "SELECT * FROM " . $configValue['DB_TEAM_TABLE'] . " WHERE id = '" . $_SESSION['curr_id'] . "'";
$statement = $db_socket->prepare($query);
$statement->execute();
if ($statement->rowCount() == 1) {
//we have pet info in this scope
$res = $statement->fetchAll();
for ($i = 1; $i < 5; $i++) {
$pet_query = "SELECT * FROM " . $configValue['DB_PET_TABLE'] . " WHERE id = '" . $res[0][$i] . "'";
$pet_stmt = $db_socket->prepare($pet_query);
$pet_stmt->execute();
if ($pet_stmt->rowCount() == 1) {
//we have base pet info at this scope; base stats, equip coordinates
$pet_res = $pet_stmt->fetchAll();
$img_uri = $pet_type[$pet_res[0]['type']]['base_img'];
echo "<div class='pet-select'><img src='http://" . $_SERVER['HTTP_HOST'] . '/' . $img_uri . "' width='100' height='100' />";
echo "<p>" . $pet_res[0]['name'] . "</p></div>";
}
}
}
include '../library/closedb.php';
}
function getName()
{
#currently dont use this function, we need a seperate db other that auth_list to handle
#non authorization reqlike getting a character name
include __DIR__ . 'opendb.php';
$db_socket = initSocket();
$query = "SELECT charname FROM " . $configValue['DB_USER_TABLE'] . " WHERE id = '" . $_SESSION['curr_id'] . "'";
$statement = $db_socket->prepare($query);
$statement->execute();
if ($statement->rowCount() == 1) {
$res = $statement->fetchAll();
echo $res[0]['charname'];
} else {
echo '{NO ENTRY}';
}
include 'closedb.php';
return;
}
$json["shop_ary"] = [];
for ($i = 0; $i < count($item_json["items"]); $i++) {
if ($item_json["items"][$i]["rarity"] == "common") {
array_push($json["shop_ary"], $item_json["items"][$i]);
}
}
echo json_encode($json);
}
//api call to purchase an item
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$string = file_get_contents("../library/item-types.json");
$item_json = json_decode($string, true);
//includes for db/variables
include '../library/server.config.php';
include_once '../library/opendb.php';
$db_socket = initSocket();
$json['error'] = [];
$target_item = $item_json['items'][$_POST['item_id']];
if (isset($_POST['user_id'])) {
$price = $target_item['price'];
//first check if user has enough neo-shekels to purchase
$query = "SELECT currency FROM " . $configValue['DB_USER_TABLE'] . " WHERE id=" . $_POST['user_id'];
$statement = $db_socket->prepare($query);
$statement->execute();
if ($statement->rowCount() == 1) {
$res = $statement->fetchAll();
if ($price > $res[0]['currency']) {
$diff = $price - $res[0]['currency'];
array_push($json['error'], "Not enough neo-shekels! You are short " . $diff . ".");
} else {
//make sure there is an empty inv slot
