query($sSQL); $gversion=$result->fetch(); $result->freeResult($result); require(FILESYSTEM_PATH."modules/google_maps/GoogleMapAPI.class.php"); // get settings from googlemap table $sSQL = "SELECT * FROM ".PREFIX."googlemap WHERE id=1"; $result=$db->query($sSQL); $settings=$result->fetch(); //$class_tpl->assign('googlesettings',$settings); /////////////////////////////////////////////// // values retrieved /////////////////////////////////////////////// // $settings[GoogleKey] // $settings[DisplayGoogle] // $settings[GoogleHeight] // $settings[GoogleWidth] // $settings[DisplayMarker] // $settings[DisplayThumb] // $settings[DisplayAddress] // $settings[DisplayCity] // $settings[DisplayState] // $settings[DisplayZip] // $settings[DisplayPrice] // $settings[DisplayDirections] // $settings[ZoomLevel] // $settings[DisplayMapControls] // $settings[ActivateMarker] // $settings[AddressType] // $settings[AddressField] // $settings[CityField] // $settings[StateField] // $settings[ZipField] // $settings[CountryField] // $settings[EnableField] /////////////////////////////////////////////// // check defined anable field if it equals no then exit // check to see if address is to come from ad owner or extra fields if($settings[AddressType]=="External") { //get extra fields $sSQL = "SELECT f.fID,sValue FROM ".PREFIX."products_fields AS p, `".PREFIX."fields` AS f WHERE p.pID='".$view."' AND f.fSeen='Y' AND p.fID=f.fID ORDER BY f.fOrder ASC"; $result=$db->query($sSQL); while ($rs3=$result->fetch()){ $sql="SELECT fID,fName,fType FROM `".PREFIX."fields` WHERE fID='".$rs3['fID']."' AND fSeen='Y' ORDER BY fOrder ASC"; $result2=$db->query($sql); $rs2=$result2->fetch(); if($rs2['fName'] == $settings[AddressField]){ $googleaddress=$rs3['sValue']; } if($rs2['fName'] == $settings[CityField]){ $googlecity=$rs3['sValue']; } if($rs2['fName'] == $settings[StateField]){ $googlestate=$rs3['sValue']; } if($rs2['fName'] == $settings[ZipField]){ $googlezip=$rs3['sValue']; } if($rs2['fName'] == $settings[CountryField]){ $googlecountry=$rs3['sValue']; } if($rs2['fName'] == $settings[EnableField]){ $mapenabled=safeStripSlashes($rs3['sValue']); } //var_dump($rs); } // end while if($googlecountry == "Not Used"){ $googleaddr = "$googleaddress $googlecity $googlestate $googlezip"; }else{ $googleaddr = "$googleaddress $googlecity $googlestate $googlezip $googlecountry"; } }else{ //get extra fields $sSQL = "SELECT f.fID,sValue FROM ".PREFIX."products_fields AS p, `".PREFIX."fields` AS f WHERE p.pID='".$view."' AND f.fSeen='Y' AND p.fID=f.fID ORDER BY f.fOrder ASC"; $result=$db->query($sSQL); while ($rs3=$result->fetch()){ $sql="SELECT fID,fName,fType FROM `".PREFIX."fields` WHERE fID='".$rs3['fID']."' AND fSeen='Y' ORDER BY fOrder ASC"; $result2=$db->query($sql); $rs2=$result2->fetch(); if($rs2['fName'] == $settings[EnableField]){ $mapenabled=safeStripSlashes($rs3['sValue']); } //var_dump($rs); } // end while if(substr($gversion[version],0,2)=="V3" ){ $googleaddress = safeStripSlashes($rs['address']); $googlecity = safeStripSlashes($rs['city']); $googlestate = safeStripSlashes($rs['state']); $googlezip = safeStripSlashes($rs['zip']); $googlecountry = safeStripSlashes($rs['country']); if($googlecountry == "Not Used"){ $googleaddr = "$googleaddress $googlecity $googlestate $googlezip"; }else{ $googleaddr = "$googleaddress $googlecity $googlestate $googlezip $googlecountry"; } }else{ $GUsers = new Users(); $googleuser=$GUsers->getUser($rs['owner']); $googleaddress = safeStripSlashes($googleuser['address']); $googlecity = safeStripSlashes($googleuser['city']); $googlestate = safeStripSlashes($googleuser['state']); $googlezip = safeStripSlashes($googleuser['zip']); $googlecountry = safeStripSlashes($googleuser['country']); if($googlecountry == "Not Used"){ $googleaddr = "$googleaddress $googlecity $googlestate $googlezip"; }else{ $googleaddr = "$googleaddress $googlecity $googlestate $googlezip $googlecountry"; } } } // end if $class_tpl->assign('googleaddress',$googleaddress); $class_tpl->assign('googlecity',$googlecity); $class_tpl->assign('googlestate',$googlestate); $class_tpl->assign('googlezip',$googlezip); $class_tpl->assign('googlecountry',$googlecountry); $class_tpl->assign('mapenabled',$mapenabled); $class_tpl->assign('adtitle',$GLOBALS[rs][title]); if($settings[DisplayGoogle]=="Y"){ //// get thumbnail name if its set to be displayed if($settings[DisplayThumb]=="Y"){ $iSQL='SELECT ' . 'image ' . 'FROM ' . ''.PREFIX.'prodimages ' . 'WHERE ' . 'pid = '.$view.' ' . 'ORDER BY ' . 'rank ASC'; $iresult=$db->query($iSQL); if ( $iresult->isError() ) { trigger_error('Listing::getImages: Unable to fetch images'); return false; } while ($irs=$iresult->fetch()) { $image[]=$irs; } //echo "
" . $image[0][image]; //filename of first image $markerimage=$image[0][image]; } // end get thumbnail image name $map = new GoogleMapAPI(); $map->disableSidebar(); // 7*28*08 //if($settings[DisplayDirections]=="N"){ // $map->disableDirections(); //} $map->disableDirections(); // 7*28*08 if($settings[DisplayMapControls]=="N"){ $map->disableMapControls(); } if($settings[ActivateMarker]=="M"){ $map->setInfoWindowTrigger('mouseover'); } //$map->setControlSize('small'); //$map->disableScaleControl(); // little bar showing distance $map->setZoomLevel($settings[ZoomLevel]); $map->setHeight($settings[GoogleHeight]."px"); $map->setWidth($settings[GoogleWidth]."px"); $map->setAPIKey($settings[GoogleKey]); if($settings[DisplayMarker]=="Y"){ $map->enableInfoWindow(); // build markerbody $markerbody="" . $GLOBALS[rs][title] . "
"; if($settings[DisplayAddress]=="Y"){ $markerbody.=$googleaddress . "
"; } if($settings[DisplayCity]=="Y"){ $markerbody.= $googlecity . ", "; } if($settings[DisplayState]=="Y"){ $markerbody.= $googlestate . " "; } if($settings[DisplayZip]=="Y"){ $markerbody.= $googlezip . "
"; } if($settings[DisplayCountry]=="Y"){ $markerbody.= $googlecountry . "
"; } if($settings[DisplayPrice]=="Y"){ $markerbody.= "$" . $GLOBALS[rs][price] . "
"; } if($settings[DisplayThumb]=="Y"){ $markerbody.=""; } $map->addMarkerByAddress($googleaddr, "",$markerbody); }else{ $map->disableInfoWindow(); $map->addMarkerByAddress($googleaddr); } $class_tpl->assign('google_map_header',$map->getHeaderJS()); $class_tpl->assign('google_map_js',$map->getMapJS()); $class_tpl->assign('google_map_sidebar',$map->getSidebar()); $class_tpl->assign('google_map',$map->getMap()); } // end if display google } // end function ?> Taiwanted
Work  Work (45)
Teaching Jobs AvailableTeaching Jobs from AgentsTeaching Jobs WantedOther Jobs AvailableOther Jobs WantedProjectsServicesMiscellaneous  
Latest Teaching Job listings
  • Teach Adults Full Time in Banqiao
  • English Teachers
  • English Teacher
  • LiveABC is looking for part-time teachers.
  • IELTS Teacher Required

  • Buy/Sell/Trade  Buy/Sell/Trade (68)
    VehiclesFurnitureElectronicsMoving SalesBooks/CDs/DVDsClothing/AccessoriesSports/Outdoors/TravelHousehold AppliancesMiscellaneous  
    Latest Electronics listings
  • HTC Touch Viva | Mobile Phone | Cell Phone | 85% New
  • Phillips Flatscreen TV / EH Memory Man FX Pedal
  • FujiFilm HS10 30X Super Zooom!
  • Latest Vehicles listings
  • FOR SALE: MERCEDES BENZ E320
  • FINAL PRICE REDUCTION 15k:Manual Motorcycle For Sale
  • AUDI A6, DARK BLUE (SOLD)

  • Housing  Housing (25)
    For RentFor SaleRoommatesLooking to rentShort-term Deals/Timeshares  
    Latest Housing listings
  • Nice Room available
  • Nice Apt. Near MRT Technology Building(NO.110742)
  • Nice Loft Near MRT Yongchun (No. 111513)
  • Furnished Apt. Near MRT Zhongxiao Dunhua(No. 110486)
  • Quiet Apt. Near Daan Forest Park(No. 112184)

  • Miscellaneous  Miscellaneous (1)
    PetsActivitiesLost & FoundEverything ElseAnnouncementsLanguage ExchangePersonals (Forumosa Friends)
    Latest Language Exchange listings