/**
* Inserts new guild
*
* @param string $name
* @param string $server
* @param string $region
*/
function _insertGuild($name, $server, $region, $faction)
{
global $roster;
$query = "SELECT " . "guild_id " . "FROM `" . $roster->db->table('guild') . "` " . "WHERE " . "`guild_name`='" . $roster->db->escape($name) . "' " . "AND `server`='" . $roster->db->escape($server) . "' " . "AND `faction`='" . $roster->db->escape($faction) . "' " . "AND `region`='" . $roster->db->escape($region) . "';";
$ret = $roster->db->query_first($query);
if (!$ret) {
// we are gona get a lil more guild info now a days......
include_once ROSTER_LIB . 'armory.class.php';
$armory = new Rosterarmory();
$data = $armory->pull_xmln('', $name, $server, 'roster');
$query = "INSERT " . "INTO `" . $roster->db->table('guild') . "` " . "SET " . "`guild_name`='" . $roster->db->escape($name) . "', " . "`server`='" . $roster->db->escape($server) . "', " . "`faction`='" . $roster->db->escape($faction) . "', " . "`guild_num_members`='" . $data->guildInfo->guildHeader['count'] . "', " . "`region`='" . $roster->db->escape($region) . "';";
if (!$roster->db->query($query)) {
die_quietly($roster->db->error(), 'Database Error', __FILE__, __LINE__, $query);
} else {
$query = "SELECT LAST_INSERT_ID();";
$ret = $roster->db->query_first($query);
}
}
$this->_debug(2, $ret, 'Inserted guild to DB', $ret ? 'OK' : 'Failed');
return $ret;
}
function _updateGuild($name, $server, $region)
{
global $roster;
// we are gona get a lil more guild info now a days......
include_once ROSTER_LIB . 'armory.class.php';
$armory = new Rosterarmory();
$data = $armory->pull_xmln('', $name, $server, 'roster');
if ($data->guildInfo->guildHeader['faction'] == "0") {
$faction = "Alliance";
}
if ($data->guildInfo->guildHeader['faction'] == "1") {
$faction = "Horde";
}
//UPDATE `wowroster`.`roster_guild` SET `guild_num_members` = '1741' WHERE `roster_guild`.`guild_id` =9;
$query = "Update `" . $roster->db->table('guild') . "` " . "SET " . "`server`='" . $roster->db->escape($server) . "', " . "`faction`='" . $roster->db->escape($faction) . "', " . "`guild_num_members`='" . $data->guildInfo->guildHeader['count'] . "', " . "`region`='" . $roster->db->escape($region) . "' " . " WHERE `guild_name`='" . $roster->db->escape($name) . "';";
$ret = $roster->db->query($query);
if (!$roster->db->query($query)) {
die_quietly($roster->db->error(), 'Database Error', __FILE__, __LINE__, $query);
} else {
$query = "SELECT LAST_INSERT_ID();";
$ret = $roster->db->query_first($query);
}
$this->_debug(2, $ret, 'Update Guild to DB', $ret ? 'OK' : 'Failed');
return $ret;
}
