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;
}
