<?php
// Update the locally stored cache of items with the
// item data from the API.
// If there is a new build available, this wipes out the whole item
// cache and rebuilds it with the latest information.
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();
// 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;
body {
background: #1a1c21;
color: #cecaba;
}
h1 {
font-size: 22px;
}
</style>
</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>";
<?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";
}
