public static function oGetCoords($sAddress) { $sAddress = trim($sAddress); $sAddressHash = Utilitu::sConditionalHash($sAddress); $oAddress = DirectDB::oSelectOne(self::$sTable, array('address_hash' => $sAddressHash)); if (!$oAddress) { $sResponse = Curl::sGet('http://maps.google.com/maps/api/geocode/json?address=' . urlencode($sAddress) . '&sensor=false'); $oResponse = json_decode($sResponse); $oFirstResult = $oResponse->results[0]; $oFRC = $oFirstResult->geometry->location; DirectDB::iInsert(self::$sTable, array('address_hash' => $sAddressHash, 'address_stub' => substr($sAddress, 0, 64), 'fetched' => date('Y-m-d H:i:s'), 'x' => '' . $oFRC->lng . '', 'y' => '' . $oFRC->lat . '', 'response' => $sResponse)); $oAddress = DirectDB::oSelectOne(self::$sTable, array('address_hash' => $sAddressHash)); } $oCoords = new StdClass(); $oCoords->nX = $oAddress->x; $oCoords->nY = $oAddress->y; return $oCoords; }
Maps::vWipeDatabase(); Ad::vWipeDatabase(); } if (isset($_REQUEST['ad_html'])) { $oAds = DirectDB::oSelectOne('ads', array('id' => intval($_REQUEST['ad_html']))); $oHtml = DirectDB::oSelectOne('ads_htmls', array('id' => intval($oAds->html_id))); $sHtml = $oHtml->html; ODT::vDump(WgGesuchtReader::oParseHtml(null, $sHtml)); exit($sHtml); } $bFetch = isset($_REQUEST['fetch']) || isset($_REQUEST['fetch_and_parse']); $bParse = isset($_REQUEST['parse']) || isset($_REQUEST['fetch_and_parse']); if (isset($_REQUEST['search_html'])) { if (isset($_REQUEST['url'])) { $aWhere = array('url' => array('%like%' => $_REQUEST['url'])); $oHtml = DirectDB::oSelectOne('ads_htmls', $aWhere, 'id , url', 'ORDER BY fetched DESC LIMIT 1'); ODT::vDump($oHtml); } } if ($bFetch) { Ad::vDeleteDuplicateUrlAds(); WgGesuchtReader::vFetch(); } if ($bParse) { $iParse = intval($_REQUEST['parse']); if ($iParse) { $oAd = WgGesuchtReader::oParseHtml($iParse); ODT::vDump($oAd); $oHtml = Ad::oGetHtml($iParse); ODT::vDump($oHtml); } else {
public static function oGetEarliestHtmlForUrl($sUrl) { $sExtra = 'ORDER BY fetched ASC LIMIT 1'; $sWhere = array('url_hash' => Utilitu::sConditionalHash($sUrl)); $oReturn = DirectDB::oSelectOne('ads_htmls', $sWhere, '*', $sExtra); return $oReturn; }