$db = new GW2DB(); $conn = $db->connect(); // Should check v2/build to see if there is a new build, if so, // delete everything in the items table // If there isn't a new build since last time, simply check if we // already have the item id in the table and skip it if we have. $stmt_build = $conn->query("SELECT opt_val FROM options WHERE opt_key='build'"); if ($stmt_build->rowCount() == 0) { $conn->query("INSERT INTO options SET opt_key='build',opt_val='0'"); $build_ver = 0; } else { $stmt_build_ver = $stmt_build->fetch(); $build_ver = $stmt_build_ver[0]; } $stmt_build->closeCursor(); $api_build_ver_result = $api->api_call('v2/build'); $api_build_ver = $api_build_ver_result->id; $overwrite = 0; if ($api_build_ver != $build_ver) { print "Build version changed. Purging item data as we go\n"; $overwrite = 1; $conn->query("UPDATE options SET opt_val='{$api_build_ver}' WHERE opt_key='build'"); } else { print "Build version the same as previous run. {$build_ver} / {$api_build_ver}\n"; } // Used to check if an item exists in the db already $stmt_exists = $conn->prepare("SELECT * FROM items WHERE item_id=:item_id"); $stmt_exists->bindParam('item_id', $ex_item_id); // Store the entire response for the item in the json field since we don't // need to query by type etc just yet. This may change later. $stmt = $conn->prepare("INSERT INTO items SET item_id=:item_id,name=:name,icon=:icon,json=:json ON DUPLICATE KEY UPDATE name=:name,icon=:icon,json=:json");
</head> <body> <h1>Guild Bank</h1> <?php require 'Config.php'; require 'GW2API.php'; require 'GW2DB.php'; $api = new GW2API(); $db = new GW2DB(); $conn = $db->connect(); $stmt = $conn->prepare("SELECT * FROM guildhall_upgrades WHERE upgrade_id=:upgrade_id"); $stmt->bindParam('upgrade_id', $upgrade_id); $stmt_item = $conn->prepare("SELECT * FROM items WHERE item_id=:item_id"); $stmt_item->bindParam('item_id', $item_id); $api->set_api_key(API_KEY); $stash = $api->api_call("/v2/guild/" . GUILD_ID . "/stash"); foreach ($stash as $section) { print "<table>\n"; $upgrade_id = $section->upgrade_id; $stmt->execute(); $upgrade = $stmt->fetch(); print "<tr><th colspan=\"10\">"; print $upgrade['name'] . "<br>"; print $section->note . "<br>"; print "Coins: " . coins_to_gold($section->coins) . "</th></tr>"; print "<tr>\n"; $count = 0; foreach ($section->inventory as $item) { print "<td style=\"text-align:center\">"; if ($item) { $item_id = $item->id;
<?php if (array_key_exists('HTTP_HOST', $_SERVER)) { die("<pre>Not a CGI</pre>"); } require 'Config.php'; require 'GW2API.php'; require 'GW2DB.php'; // GW2API object from gw2api.php $api = new GW2API(); $db = new GW2DB(); $conn = $db->connect(); # Guild related stuff $api->set_api_key(API_KEY); // *** Update Treasury stuff *** $treasury = $api->api_call('v2/guild/' . GUILD_ID . '/treasury', array()); $stmt = $conn->prepare("SELECT * FROM guildhall_treasury WHERE item_id=:item_id"); $stmt->bindParam('item_id', $find_item_id); $stmt_add_t = $conn->prepare("INSERT INTO guildhall_treasury SET item_id=:item_id,qty=:qty"); $stmt_add_t->bindParam('item_id', $add_item_id); $stmt_add_t->bindParam('qty', $add_qty); $stmt_upd_t = $conn->prepare("UPDATE guildhall_treasury SET qty=:qty WHERE item_id=:item_id"); $stmt_upd_t->bindParam('item_id', $upd_item_id); $stmt_upd_t->bindParam('qty', $upd_qty); $stmt_add_tr = $conn->prepare("INSERT INTO guildhall_treasury_req SET item_id=:item_id,upgrade_id=:upgrade_id,qty=:qty"); $stmt_add_tr->bindParam('item_id', $add_item_id); $stmt_add_tr->bindParam('upgrade_id', $add_upgrade_id); $stmt_add_tr->bindParam('qty', $add_qty); $stmt_del_tr = $conn->prepare("DELETE FROM guildhall_treasury_req WHERE item_id=:item_id"); $stmt_del_tr->bindParam('item_id', $del_item_id); foreach ($treasury as $item) {
<?php if (array_key_exists('HTTP_HOST', $_SERVER)) { die("<pre>Not a CGI</pre>"); } require 'Config.php'; require 'GW2API.php'; require 'GW2DB.php'; $api = new GW2API(); $db = new GW2DB(); $conn = $db->connect(); $upgrades = $api->api_call('v2/guild/upgrades'); $all_upgrades = array(); while (!empty($upgrades)) { $get_upgrades = array(); while (count($upgrades) > 0 && count($get_upgrades) < 190) { $ex_upgrade_id = array_shift($upgrades); array_push($get_upgrades, $ex_upgrade_id); } $get_upgrades_result = fetch_upgrades($get_upgrades); $all_upgrades = array_merge($all_upgrades, $get_upgrades_result); } print "Found " . count($all_upgrades) . " upgrades\n"; $conn->query("DELETE FROM guildhall_upgrades"); $conn->query("DELETE FROM guildhall_upgrade_cost"); $conn->query("DELETE FROM guildhall_upgrade_prereq"); $stmt_gu = $conn->prepare("INSERT INTO guildhall_upgrades SET upgrade_id=:gu_upgrade_id,name=:gu_name,type=:gu_type,icon=:gu_icon,required_level=:gu_req_level,experience=:gu_xp"); $stmt_gu->bindParam('gu_upgrade_id', $gu_upgrade_id); $stmt_gu->bindParam('gu_name', $gu_name); $stmt_gu->bindParam('gu_type', $gu_type); $stmt_gu->bindParam('gu_icon', $gu_icon);
<?php if (array_key_exists('HTTP_HOST', $_SERVER)) { die("<pre>Not a CGI</pre>"); } require 'Config.php'; require 'GW2API.php'; $api = new GW2API(); $api->set_api_key(API_KEY); $account = $api->api_call("/v2/account"); foreach ($account->guilds as $guild) { $guild_info = $api->api_call("/v1/guild_details.json?guild_id=" . $guild); print "Name: " . $guild_info->guild_name . "\n"; print "Id: " . $guild . "\n\n"; }