function replace_tags($tags = array())
{
global $config, $lang;
require_once $config['basepath'] . '/include/login.inc.php';
$login = new login();
require_once $config['basepath'] . '/include/misc.inc.php';
$misc = new misc();
// Remove tags not found in teh template
$new_tags = $tags;
$tags = array();
foreach ($new_tags as $tag) {
if (strpos($this->page, '{' . $tag . '}') !== false) {
$tags[] = $tag;
}
}
unset($new_tags);
if (sizeof($tags) > 0) {
foreach ($tags as $tag) {
$data = '';
switch ($tag) {
case 'content':
$data = $this->replace_user_action();
break;
case 'templated_search_form':
require_once $config['basepath'] . '/include/search.inc.php';
$search = new search_page();
$data = $search->create_searchpage('no', true);
break;
case 'baseurl':
$data = $config['baseurl'];
break;
case 'template_url':
$data = $config['template_url'];
break;
case 'addthis_button':
global $jscript_last;
$jscript_last .= "\r\n" . '<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js"></script>';
$data = '<a href="http://www.addthis.com/bookmark.php?v=250" class="addthis_button"><img src="http://s7.addthis.com/static/btn/v2/lg-share-en.gif" width="125" height="16" border="0" alt="Share" /></a>';
break;
case 'load_js':
$data = $this->load_js();
break;
case 'load_js_last':
global $jscript_last;
$data = $jscript_last;
break;
case 'tabbed_js':
global $jscript;
$jscript .= '<script type="text/javascript" src="' . $config['baseurl'] . '/tabpane.js"></script>' . "\r\n";
$data = '';
break;
case 'license_tag':
$data = "<!--Open-Realty is distributed by Transparent Technologies and is Licensed under the Open-Realty License. See http://www.open-realty.org/license_info.html for more information.-->";
break;
case 'main_listing_data':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->getMainListingData($_GET['listingID']);
break;
case 'featured_listings_vertical':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsVertical();
break;
case 'featured_listings_horizontal':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsHorizontal();
break;
case 'featured_listings_horizontal_latest':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderLatestFeaturedListingsHorizontal();
break;
case 'random_listings_vertical':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsVertical(0, true);
break;
case 'random_listings_horizontal':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
//$data = $listing->renderFeaturedListingsHorizontal(0, true);
$data = $listing->renderRandomListingsHorizontal();
break;
case 'latest_listings_vertical':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsVertical(0, false, '', true);
break;
case 'latest_listings_horizontal':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsHorizontal(0, false, '', true);
break;
case preg_match("/^featured_listings_horizontal_class_([0-9]*)/", $tag, $feat_class) ? $tag : !$tag:
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsHorizontal(0, FALSE, $feat_class[1]);
break;
case preg_match("/^featured_listings_vertical_class_([0-9]*)/", $tag, $feat_class) ? $tag : !$tag:
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsVertical(0, FALSE, $feat_class[1]);
break;
case preg_match("/^random_listings_horizontal_class_([0-9]*)/", $tag, $feat_class) ? $tag : !$tag:
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsHorizontal(0, TRUE, $feat_class[1]);
break;
case preg_match("/^random_listings_vertical_class_([0-9]*)/", $tag, $feat_class) ? $tag : !$tag:
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsVertical(0, TRUE, $feat_class[1]);
break;
case preg_match("/^latest_listings_horizontal_class_([0-9]*)/", $tag, $feat_class) ? $tag : !$tag:
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsHorizontal(0, false, $feat_class[1], true);
break;
case preg_match("/^latest_listings_vertical_class_([0-9]*)/", $tag, $feat_class) ? $tag : !$tag:
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderFeaturedListingsVertical(0, false, $feat_class[1], true);
break;
case 'headline':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderTemplateAreaNoCaption('headline', $_GET['listingID']);
break;
case 'full_description':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderTemplateAreaNoCaption('center', $_GET['listingID']);
break;
case 'listing_images':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsImages($_GET['listingID'], 'yes');
break;
case 'listing_images_nocaption':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsImages($_GET['listingID'], 'no');
break;
case 'listing_files_select':
require_once $config['basepath'] . '/include/files.inc.php';
$files = new file_handler();
$data = $files->render_files_select($_GET['listingID'], 'listing');
break;
case 'files_listing_vertical':
require_once $config['basepath'] . '/include/files.inc.php';
$files = new file_handler();
$data = $files->render_templated_files($_GET['listingID'], 'listing', 'vertical');
break;
case 'files_listing_horizontal':
require_once $config['basepath'] . '/include/files.inc.php';
$files = new file_handler();
$data = $files->render_templated_files($_GET['listingID'], 'listing', 'horizontal');
break;
case 'slideshow_images':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsMainImageSlideShow($_GET['listingID']);
break;
case 'link_calc':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_calc_link();
break;
case 'link_calc_url':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_calc_link($url_only = 'yes');
break;
case 'link_add_favorites':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_add_favorite_link();
break;
case 'link_add_favorites_url':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_add_favorite_link($url_only = 'yes');
break;
case 'link_printer_friendly':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_printer_friendly_link();
break;
case 'link_email_friend':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_email_friend_link();
break;
case 'link_map':
require_once $config['basepath'] . '/include/maps.inc.php';
$maps = new maps();
$data = $maps->create_map_link();
break;
case 'link_yahoo_school':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_yahoo_school_link();
break;
case 'link_yahoo_neighborhood':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_yahoo_neighborhood_link();
break;
case 'link_printer_friendly_url':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_printer_friendly_link($url_only = 'yes');
break;
case 'link_email_friend_url':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_email_friend_link($url_only = 'yes');
break;
case 'link_map_url':
require_once $config['basepath'] . '/include/maps.inc.php';
$maps = new maps();
$data = $maps->create_map_link($url_only = 'yes');
break;
case 'link_yahoo_school_url':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_yahoo_school_link($url_only = 'yes');
break;
case 'link_yahoo_neighborhood_url':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->create_yahoo_neighborhood_link($url_only = 'yes');
break;
case 'contact_agent_link_url':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->contact_agent_link($url_only = 'yes');
break;
case 'agent_info':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->renderUserInfoOnListingsPage($_GET['listingID']);
break;
case 'listing_email':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->getListingEmail($_GET['listingID']);
break;
case 'hitcount':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->hitcount($_GET['listingID']);
break;
case 'main_image':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsMainImage($_GET['listingID'], 'yes', 'no');
break;
case 'main_image_nodesc':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsMainImage($_GET['listingID'], 'no', 'no');
break;
case 'main_image_java':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsMainImage($_GET['listingID'], 'yes', 'yes');
break;
case 'main_image_java_nodesc':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsMainImage($_GET['listingID'], 'no', 'yes');
break;
case 'listing_images_java':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsImagesJava($_GET['listingID'], 'no');
break;
case 'listing_images_java_caption':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsImagesJava($_GET['listingID'], 'yes');
break;
case 'listing_images_java_rows':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsImagesJavaRows($_GET['listingID']);
break;
case 'listing_images_mouseover_java':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsImagesJava($_GET['listingID'], 'no', 'yes');
break;
case 'listing_images_mouseover_java_caption':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsImagesJava($_GET['listingID'], 'yes', 'yes');
break;
case 'listing_images_mouseover_java_rows':
require_once $config['basepath'] . '/include/images.inc.php';
$images = new image_handler();
$data = $images->renderListingsImagesJavaRows($_GET['listingID'], 'yes');
break;
case 'vtour_button':
require_once $config['basepath'] . '/include/vtour.inc.php';
$vtour = new vtours();
$data = $vtour->rendervtourlink($_GET['listingID']);
break;
case 'listingid':
$data = $_GET['listingID'];
break;
case 'get_creation_date':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->get_creation_date($_GET['listingID']);
break;
case 'get_featured_raw':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->get_featured($_GET['listingID'], 'yes');
break;
case 'get_featured':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->get_featured($_GET['listingID'], 'no');
break;
case 'get_modified_date':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->get_modified_date($_GET['listingID']);
break;
case 'contact_agent_link':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->contact_agent_link();
break;
case 'select_language':
// require_once($config['basepath'] . '/include/multilingual.inc.php');
// $multilingual = new multilingual();
// $data = $multilingual->multilingual_select();
break;
case 'company_name':
$data = $config['company_name'];
break;
case 'company_location':
$data = $config['company_location'];
break;
case 'company_logo':
$data = $config['company_logo'];
break;
case 'show_vtour':
if (isset($_GET['listingID'])) {
require_once $config['basepath'] . '/include/vtour.inc.php';
$vtour = new vtours();
$data = $vtour->show_vtour($_GET['listingID'], false);
} else {
$data = 'No Listing ID';
}
break;
case 'charset':
$data = $config['charset'];
break;
case 'link_edit_listing':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->edit_listing_link();
break;
case 'link_edit_listing_url':
require_once $config['basepath'] . '/include/listing.inc.php';
$listing = new listing_pages();
$data = $listing->edit_listing_link('yes');
break;
case 'template_select':
$data = $this->template_selector();
break;
case 'money_sign':
$data = $config['money_sign'];
break;
case 'horizontal_header_banner':
if (@(include getenv('DOCUMENT_ROOT') . '/advertising/phpadsnew.inc.php')) {
if (!isset($phpAds_context)) {
$phpAds_context = array();
}
$phpAds_raw = view_raw('zone:1', 0, '_self', '', '0', $phpAds_context);
$data = $phpAds_raw['html'];
} else {
$data = '<img src="/images/bannerd.png">';
}
break;
default:
if (preg_match("/^addon_(.*?)_.*/", $tag, $addon_name)) {
$file = $config['basepath'] . '/addons/' . $addon_name[1] . '/addon.inc.php';
if (file_exists($file)) {
include_once $file;
$function_name = $addon_name[1] . '_run_template_user_fields';
$data = $function_name($tag);
} else {
$data = '';
}
} else {
$data = '';
}
break;
}
$this->page = str_replace('{' . $tag . '}', $data, $this->page);
}
}
unset($tags);
unset($tag);
}
*
*/
include "config/config.php";
class maps
{
private $db_connection = null;
public function _construct()
{
if (isset($_POST['type'])) {
if ($_POST['type'] == "traffic") {
$this->marktraffic($_POST['lat'], $_POST['long']);
}
}
}
private function db_connection()
{
try {
$this->db_connection = new PDO('mysql:host=' . DATABASE_HOST . ';dbname=mapfik;charset=utf8', DATABASE_USERNAME, DATABASE_PASSWORD);
return true;
} catch (PDOExcption $e) {
$this->error('ERR_DB_NOT_CONNECTED');
return false;
}
}
private function marktraffic($lat, $long)
{
header("Location:traffic.php?lat=" . $lat . "&long=" . $long);
}
}
$new = new maps();
$new->_construct();
<?php
/*
This file is part of STFC.
Copyright 2006-2007 by Michael Krauss (info@stfc2.de) and Tobias Gafner
STFC is based on STGC,
Copyright 2003-2007 by Florian Brede (florian_brede@hotmail.com) and Philipp Schmidt
STFC is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 3 of the License, or
(at your option) any later version.
STFC is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
$game->init_player();
check_auth(STGC_DEVELOPER);
include_once 'include/libs/maps.php';
$maps = new maps();
$maps->create_galaxy_map();
$maps->create_quadrant_map(1);
$maps->create_quadrant_map(2);
$maps->create_quadrant_map(3);
$maps->create_quadrant_map(4);
break;
}
SystemMessage($user['user_id'], $title, $message);
$sql = 'UPDATE user SET num_sitting=-1 WHERE user_id=' . $user['user_id'];
if (!$db->query($sql)) {
$sdl->log('<b>Error:</b> cannot lock sitting for user ID ' . $user['user_id'] . '!');
}
$sdl->log('User sitting locked: ID ' . $user['user_id'] . ' Name: ' . $user['user_name'] . ' Abuse: ' . $val);
}
}
$sdl->finish_job('Sitting abuse check');
// #######################################################################################
// #######################################################################################
// Create or update galaxy map image
$sdl->start_job('Create galaxy map');
$maps = new maps();
$maps->create_galaxy_detail_map();
if (($destimg = ImageCreateTrueColor(150, 150)) === false) {
$sdl->log('<b>Error:</b> problem creating image');
} else {
if (($srcimg = ImageCreateFromPNG($game_path . 'maps/images/galaxy_detail.png')) === false) {
$sdl->log('<b>Error:</b> problem opening source image');
} else {
if (!ImageCopyResampled($destimg, $srcimg, 0, 0, 0, 0, 150, 159, ImageSX($srcimg), ImageSY($srcimg))) {
$sdl->log('<b>Error:</b> problem resizing image');
} else {
imagepng($destimg, $game_path . 'maps/images/galaxy_detail_small.png');
}
imagedestroy($srcimg);
}
imagedestroy($destimg);
</table>
</td>
</tr>
</table>
');
}
}
display_cartography_jump();
if ($game->planet['planet_id'] != $planet_id) {
if ($planet_is_known && $own_planet) {
display_ferengi_transfer($planet['planet_id'], $planet['system_id'], $planet['system_global_x'], $planet['system_global_y'], $planet['building_11']);
}
}
} elseif (!empty($_GET['system_id']) || !empty($_GET['sector_id']) || !empty($_GET['quadrant_id']) || isset($_GET['galaxy'])) {
include_once 'include/libs/maps.php';
$maps = new maps();
$nav_html = $img_html = $legend_html = '';
$numbers = $letters = array(' ', ' ', ' ', ' ', ' ', ' ', ' ');
if (!empty($_GET['system_id'])) {
if (is_numeric($_GET['system_id'])) {
die(constant($game->sprache("TEXT59")));
} else {
$system_id = (int) decode_system_id($_GET['system_id']);
}
$sql = 'SELECT system_name, sector_id
FROM starsystems
WHERE system_id = ' . $system_id;
if (($system = $db->queryrow($sql)) === false) {
message(DATABASE_ERROR, 'Could not query starsystem data');
}
if (empty($system['sector_id'])) {
/**
* maps::create_map_link()
* This is the function to call to show a map link. It should be called from the listing detail page, or any page where $_GET['listingID'] is set.
* This function then calls the appropriate make_mapname function as specified in the configuration.
*
* @see maps::make_mapquest()
* @see maps::make_yahoo_us()
* @return string Return the URL for the map as long as the required fields are filled out, if not it returns a empty string.
*/
function create_map_link($url_only = 'no')
{
global $conn, $config;
require_once $config['basepath'] . '/include/misc.inc.php';
$misc = new misc();
// Map Type
// Get Address, City, State, Zip
// Create Blank Variables
$display = '';
$address = '';
$city = '';
$state = '';
$zip = '';
// Get Listing ID
$sql_listingID = $misc->make_db_safe($_GET['listingID']);
$listing_title = urlencode(listing_pages::get_title($_GET['listingID']));
// get address
$sql_address_field = $misc->make_db_safe($config['map_address']);
$sql = "SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_field_caption FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsformelements WHERE ((" . $config['table_prefix'] . "listingsdbelements.listingsdb_id = {$sql_listingID}) AND (listingsformelements_field_name = listingsdbelements_field_name) AND (listingsdbelements_field_name = {$sql_address_field}))";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) {
$misc->log_error($sql);
}
while (!$recordSet->EOF) {
$address = urlencode($misc->make_db_unsafe($recordSet->fields['listingsdbelements_field_value']));
$recordSet->MoveNext();
}
// end while
// Add address fields 2 & 3
$sql_address_field = $misc->make_db_safe($config['map_address2']);
$sql = "SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_field_caption FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsformelements WHERE ((" . $config['table_prefix'] . "listingsdbelements.listingsdb_id = {$sql_listingID}) AND (listingsformelements_field_name = listingsdbelements_field_name) AND (listingsdbelements_field_name = {$sql_address_field}))";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) {
$misc->log_error($sql);
}
while (!$recordSet->EOF) {
$address .= ' ' . urlencode($misc->make_db_unsafe($recordSet->fields['listingsdbelements_field_value']));
$recordSet->MoveNext();
}
// end while
$sql_address_field = $misc->make_db_safe($config['map_address3']);
$sql = "SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_field_caption FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsformelements WHERE ((" . $config['table_prefix'] . "listingsdbelements.listingsdb_id = {$sql_listingID}) AND (listingsformelements_field_name = listingsdbelements_field_name) AND (listingsdbelements_field_name = {$sql_address_field}))";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) {
$misc->log_error($sql);
}
while (!$recordSet->EOF) {
$address .= ' ' . urlencode($misc->make_db_unsafe($recordSet->fields['listingsdbelements_field_value']));
$recordSet->MoveNext();
}
// end while
$sql_address_field = $misc->make_db_safe($config['map_address4']);
$sql = "SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_field_caption FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsformelements WHERE ((" . $config['table_prefix'] . "listingsdbelements.listingsdb_id = {$sql_listingID}) AND (listingsformelements_field_name = listingsdbelements_field_name) AND (listingsdbelements_field_name = {$sql_address_field}))";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) {
$misc->log_error($sql);
}
while (!$recordSet->EOF) {
$address .= ' ' . urlencode($misc->make_db_unsafe($recordSet->fields['listingsdbelements_field_value']));
$recordSet->MoveNext();
}
// end while
// get city
$sql_city_field = $misc->make_db_safe($config['map_city']);
$sql = "SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_field_caption FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsformelements WHERE ((" . $config['table_prefix'] . "listingsdbelements.listingsdb_id = {$sql_listingID}) AND (listingsformelements_field_name = listingsdbelements_field_name) AND (listingsdbelements_field_name = {$sql_city_field}))";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) {
$misc->log_error($sql);
}
while (!$recordSet->EOF) {
$city = urlencode($misc->make_db_unsafe($recordSet->fields['listingsdbelements_field_value']));
$recordSet->MoveNext();
}
// end while
// get state
$sql_state_field = $misc->make_db_safe($config['map_state']);
$sql = "SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_field_caption FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsformelements WHERE ((" . $config['table_prefix'] . "listingsdbelements.listingsdb_id = {$sql_listingID}) AND (listingsformelements_field_name = listingsdbelements_field_name) AND (listingsdbelements_field_name = {$sql_state_field}))";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) {
$misc->log_error($sql);
}
while (!$recordSet->EOF) {
$state = urlencode($misc->make_db_unsafe($recordSet->fields['listingsdbelements_field_value']));
$recordSet->MoveNext();
}
// end while
// get zip
$sql_zip_field = $misc->make_db_safe($config['map_zip']);
$sql = "SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_field_caption FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsformelements WHERE ((" . $config['table_prefix'] . "listingsdbelements.listingsdb_id = {$sql_listingID}) AND (listingsformelements_field_name = listingsdbelements_field_name) AND (listingsdbelements_field_name = {$sql_zip_field}))";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) {
$misc->log_error($sql);
}
while (!$recordSet->EOF) {
$zip = urlencode($misc->make_db_unsafe($recordSet->fields['listingsdbelements_field_value']));
$recordSet->MoveNext();
}
// end while
// get zip
$sql_country_field = $misc->make_db_safe($config['map_country']);
$sql = "SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_field_caption FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsformelements WHERE ((" . $config['table_prefix'] . "listingsdbelements.listingsdb_id = {$sql_listingID}) AND (listingsformelements_field_name = listingsdbelements_field_name) AND (listingsdbelements_field_name = {$sql_country_field}))";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) {
$misc->log_error($sql);
}
while (!$recordSet->EOF) {
$country = urlencode($misc->make_db_unsafe($recordSet->fields['listingsdbelements_field_value']));
$recordSet->MoveNext();
}
// end while
if ($address != '' || $city != '' || $state != '' || $zip != '') {
$map_type = 'make_' . $config['map_type'];
$pos = strpos($map_type, 'mapquest');
$pos2 = strpos($map_type, 'multimap');
$pos3 = strpos($map_type, 'global_');
if ($pos3 !== false) {
if ($pos !== false) {
$display = maps::make_mapquest($country, $address, $city, $state, $zip, $listing_title, $url_only);
} elseif ($pos2 !== false) {
$display = maps::make_multimap($country, $address, $city, $state, $zip, $listing_title, $url_only);
}
} elseif ($pos !== false) {
$country = substr($map_type, -2);
$display = maps::make_mapquest($country, $address, $city, $state, $zip, $listing_title, $url_only);
} elseif ($pos2 !== false) {
$country = substr($map_type, -2);
$display = maps::make_multimap($country, $address, $city, $state, $zip, $listing_title, $url_only);
} else {
$display = maps::$map_type($address, $city, $state, $zip, $listing_title, $url_only);
}
}
return $display;
}
/**
* googlemap_display_addon_link()
* This function generates the link to the Google Map. If either of the latitude or
* longitude fields for the current listing are not set, it returns a link to the old
* (default Open-Realty) map.
*
* @return string Returns a hyperlink that will load the map when clicked.
*/
function googlemap_display_addon_link()
{
// Need access to common path information, and current connection
global $config, $lang, $conn;
// Get access to database functions
require_once $config['basepath'] . '/include/misc.inc.php';
$misc = new misc();
$listingID = $misc->make_db_safe($_GET['listingID']);
// grab latitude and longitude of current listing
$sql = "SELECT listingsdbelements_field_value FROM " . $config['table_prefix'] . "listingsdbelements WHERE (listingsdb_id = {$listingID} AND (listingsdbelements_field_name = 'latitude' OR listingsdbelements_field_name = 'longitude'))";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) {
$misc->log_error($sql);
}
$val1 = $misc->make_db_unsafe($recordSet->fields['listingsdbelements_field_value']);
$recordSet->MoveNext();
$val2 = $misc->make_db_unsafe($recordSet->fields['listingsdbelements_field_value']);
// if (latitude and longitude) are set for the current listing
if (!($val1 == '') && !($val2 == '')) {
$sql = "SELECT * FROM " . $config['table_prefix_no_lang'] . "addon_googlemap";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) {
$misc->log_error($sql);
}
$popup = $misc->make_db_unsafe($recordSet->fields['popup']);
// Open map in a pop up window?
if ($popup == 1) {
$map_height = $misc->make_db_unsafe($recordSet->fields['map_height']);
$map_width = $misc->make_db_unsafe($recordSet->fields['map_width']);
$display = '<a href="index.php?action=addon_googlemap_showmap&listingID=' . $_GET['listingID'] . "&popup=1\" onclick=\"window.open(this.href,'_map','location=0,status=0,scrollbars=1,toolbar=0,menubar=0,width={$map_width},height={$map_height}');return false\">";
$display .= '<img src="template/dd2col/images/viewmap.jpg" alt="click to view google map"/></a>';
} else {
$display = '<a href="index.php?action=addon_googlemap_showmap&listingID=' . $_GET['listingID'] . '">' . $lang[map_link] . '</a>';
}
return $display;
}
// Fail gracefully if latitude or longitude not set.
require_once $config['basepath'] . '/include/maps.inc.php';
$map = new maps();
return $map->create_map_link();
}
<?php
require_once 'maps.php';
$mapsServer = new maps();
if (isset($_GET['content'])) {
$content = $_GET['content'];
} else {
die('error: unknown request');
}
if (isset($_GET['contentType'])) {
$contentType = $_GET['contentType'];
} else {
die('error: must set contentType');
}
if ($contentType == 'json') {
header('Content-Type: application/json');
}
switch ($content) {
case 'getPoints':
if (isset($_POST['NELat'])) {
$NELat = $_POST['NELat'];
} else {
die('error: parameter NELat not set');
}
if (isset($_POST['NELng'])) {
$NELng = $_POST['NELng'];
} else {
die('error: parameter NELng not set');
}
if (isset($_POST['SWLat'])) {
$SWLat = $_POST['SWLat'];
