Example #1
0
function processCartoMine($luaData, $gatherwords)
{
    global $wowdb;
    $query = "SELECT `map`,`number` FROM `" . GATHERER_TABLE . "` where `nodeType` = 'MINE';";
    $result = $wowdb->query($query) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query);
    if ($wowdb->num_rows($result) > 0) {
        $dbData = array();
        while ($row = $wowdb->fetch_assoc($result)) {
            $coords = toXY($row['number']);
            $xPos = $coords['xPos'];
            $yPos = $coords['yPos'];
            $dbData[$row['map']]['x'] = $xPos;
            $dbData[$row['map']]['y'] = $yPos;
            $dbData[$row['map']]['id'] = $row['number'];
        }
    }
    $wowdb->free_result($result);
    $wowdb->resetMessages();
    $inserts = '';
    foreach ($luaData as $zone => $data) {
        $old = array("'", ' ', 'SHATTERAH_CITY', 'SHATTRATH_CITY', 'THE_BARRENS', 'BLADES_EDGE_MOUNTAINS', 'NETHERSTORM', 'THE_HINTERLANDS', 'GHOSTLANDS');
        $new = array('', '_', 'SHATTRATH', 'SHATTRATH', 'BARRENS', 'BLADES_EDGE_MOUNTAINS', 'NETHERSTORM', 'HINTERLANDS', 'GHOSTLANDS');
        $map = str_replace($old, $new, strtoupper($zone));
        if (is_array($data)) {
            foreach ($data as $number => $mine) {
                $coords = toXY($number);
                $xPos = $coords['xPos'];
                $yPos = $coords['yPos'];
                $id = toID($xPos, $yPos);
                $gtype = 'MINE';
                $index = $gatherwords['zonecont'][$map];
                $nodeNumber = array_search($mine, $gatherwords['node_names']['MINE']);
                if (isset($dbData) && isset($dbData[$map]) && (isset($dbData[$map]['id']) && $dbData[$map]['id'] != $id || $dbData[$map]['y'] != $yPos && $dbData[$map]['x'] != $xPos)) {
                    continue;
                } else {
                    if (!empty($inserts)) {
                        $inserts .= ", ";
                    }
                    $inserts .= "( '" . $id . "', '" . $nodeNumber . "', '" . $wowdb->escape($map) . "', '" . $wowdb->escape($gtype) . "', '" . $index . "' )";
                }
            }
        }
    }
    if (!empty($inserts)) {
        $query = "INSERT INTO `" . GATHERER_TABLE . "` (`number`, `nodeNumber`, `map`, `nodeType`, `continent`) VALUES ";
        $query = $query . $inserts . ';';
        $result = $wowdb->query($query) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query);
    }
}
Example #2
0
unset($roster_dir);
// Include gatherer's conf and locale files
include_once $gatherer_dir . 'conf.php';
include_once $gatherer_dir . 'localization.php';
unset($gatherer_dir);
// Get our map and continent if they exist
$continent = isset($_GET['continent']) ? $_GET['continent'] : '';
$map = isset($_GET['map']) ? $_GET['map'] : '';
// Grab our data
$query = "SELECT * FROM `" . GATHERER_TABLE . "` WHERE `continent` = '{$continent}' AND `map` = '{$map}' ORDER BY `nodeType` DESC;";
$result = $wowdb->query($query) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query);
header('Content-type: text/xml');
echo "<map>\n <a_map continent=\"" . $gatherwords['continents'][$continent] . "\" map=\"" . $gatherwords['zones'][$continent][$map] . "\" image=\"" . ROSTER_URL . "/images/MAP/{$continent}/{$map}.jpg\"> \n";
while ($row = mysql_fetch_array($result)) {
    $nodeName = isset($gatherwords['node_names'][$row['nodeType']]) ? $gatherwords['node_names'][$row['nodeType']] : $row['nodeType'];
    $coords = toXY($row['number']);
    $xPos = $coords['xPos'];
    $yPos = $coords['yPos'];
    echo "<Gatherable Gtype=\"" . $row['nodeType'] . "\" XPos=\"" . $xPos * 1000 . "\" YPos=\"" . $yPos * 668 . "\" Icon=\"" . ROSTER_URL . "/images/" . $row['nodeType'] . "/" . $row['nodeNumber'] . ".png\" GatherableName=\"" . $gatherwords['node_names'][$row['nodeType']][$row['nodeNumber']] . "\" />";
}
echo "</a_map> \n </map> \n";
function toID($xPos, $yPos)
{
    return round($xPos * 10000, 0) + round($yPos * 10000, 0) * 10001;
}
function toXY($num)
{
    $return['xPos'] = $num % 10001 / 10000;
    $return['yPos'] = floor($num / 10001) / 10000;
    return $return;
}