public function getCity($ip)
{
$record = $this->fetchRow("select * from auto_pre_iptocity WHERE ip = ?", array($ip), 3600);
if (!empty($record)) {
$rec = json_decode($record['details'], 1);
return $rec;
}
if (empty($record)) {
$this->clearCache($this->sql, array($ip));
$details = iptocity($ip);
if (empty($details) || $details['status'] != 'OK') {
return false;
}
$geo = new Models_Geo();
$nearby = $geo->get_nearby_cities($details['lat'], $details['lon']);
$rec = array();
foreach ($nearby as $v) {
$rec = $v;
break;
}
if (empty($rec)) {
return false;
}
$d = array();
$d['ip'] = $ip;
$d['details'] = json_encode($rec);
$this->addDetails('auto_pre_iptocity', $d);
return $rec;
}
return false;
}
public function myBids($uid, $period)
{
$this->checkUser($uid);
$sql = sprintf("SELECT * FROM location_bids WHERE owner_id=%s AND period_bids=%s order by bid_created_dt asc", $this->qstr($uid), $this->qstr($period));
$result = $this->_connMain->Execute($sql);
if ($result->RecordCount() == 0) {
throw new Exception('No Bids available.');
}
$return = array();
$Models_Geo = new Models_Geo();
$return['country'] = array();
$return['state'] = array();
$return['city'] = array();
while (!$result->EOF) {
$location = array();
switch ($result->fields['location_type']) {
case 'Country':
$location = $Models_Geo->getCountryDetails($result->fields['location_id'], 0);
$return['country'][] = array('bidDetail' => $result->fields, 'location' => $location);
break;
case 'State':
$location = $Models_Geo->getStateDetails($result->fields['location_id'], 0);
$return['state'][] = array('bidDetail' => $result->fields, 'location' => $location);
break;
case 'City':
$location = $Models_Geo->getCityDetails($result->fields['location_id'], 0);
$return['city'][] = array('bidDetail' => $result->fields, 'location' => $location);
break;
}
$result->MoveNext();
}
return $return;
}
<?php
check_login();
include SITEDIR . '/includes/navLeftSideVars.php';
if (!empty($_REQUEST['cty'])) {
$status = 0;
$insertSQL = sprintf("INSERT INTO geo_city_owners (cty_id, owner_id, expiry_date, subs_expiry_date, status) VALUES (%s, %s, %s, %s, %s)", GetSQLValueString($_REQUEST['cty'], "int"), GetSQLValueString($_SESSION['user']['id'], "text"), GetSQLValueString(date('Y-m-d H:i:s', strtotime("+1 month")), "date"), GetSQLValueString(date('Y-m-d H:i:s', strtotime("+1 year")), "date"), GetSQLValueString($status, "int"));
mysql_select_db($database_connMain, $connMain);
$Result1 = mysql_query($insertSQL, $connMain) or die(mysql_error());
$insertGoTo = $currentURL;
header(sprintf("Location: %s", $insertGoTo));
exit;
}
//getting owern information
$Models_Geo = new Models_Geo();
$ownerDetails = $Models_Geo->getOwnerDetails($city_id, 0);
if (!empty($ownerDetails)) {
header("Location: " . $currentURL);
exit;
}
?>
<h1><?php
echo $pageTitle;
?>
</h1>
<p>Apply For City Moderator</p>
<form action="<?php
echo PAYPAL_URL;
?>
" method="post">
function matchUserDate($uid, $lat, $lng, $custom_date)
{
if (empty($uid)) {
return false;
}
if (empty($lat)) {
return false;
}
if (empty($lng)) {
return false;
}
if (empty($custom_date)) {
return false;
}
global $modelGeneral;
$query = "SELECT * FROM settings LEFT JOIN geo_cities ON settings.birth_city_id = geo_cities.cty_id WHERE 1 AND settings.uid = ?";
$settingsDetail = $modelGeneral->fetchRow($query, array($uid), 3600);
if (empty($settingsDetail['dob'])) {
return false;
}
if (empty($settingsDetail['birth_city_id'])) {
return false;
}
$geo = new Models_Geo();
$nearby = $geo->get_nearby_cities($lat, $lng);
if (empty($nearby)) {
continue;
}
$cityDetails = array();
foreach ($nearby as $v) {
$cityDetails = $v;
break;
}
if (empty($cityDetails)) {
return false;
}
$to = $cityDetails;
if (empty($to['extraDetails'])) {
$tmp = findCity($to['cty_id']);
unset($tmp['nearby']);
unset($tmp['etc']);
$to = array_merge($to, $tmp);
}
if (!empty($settingsDetail['extraDetails']) && !empty($settingsDetail['birth_city_id'])) {
$tmp = findCity($settingsDetail['birth_city_id']);
unset($tmp['nearby']);
unset($tmp['etc']);
$settingsDetail = array_merge($settingsDetail, $tmp);
}
$to['dob'] = $custom_date;
$matchResult = match($settingsDetail, $to);
return $matchResult;
}
<?php
check_login();
$pageTitle = 'My Cities';
include SITEDIR . '/libraries/addresses/nearby.php';
$Models_Geo = new Models_Geo();
$mycities = $Models_Geo->myOwnedCities($_SESSION['user']['id']);
?>
<h3>My Cities</h3>
<?php
if (empty($mycities)) {
?>
<div>No Cities in your account.</div>
<?php
} else {
foreach ($mycities as $k => $v) {
?>
<a href="<?php
echo makecityurl($v['id'], $v['name']);
?>
/manage/main"><?php
echo $v['name'];
?>
, <?php
echo $v['state'];
?>
, <?php
echo $v['country'];
?>
</a><br>
<strong>Expiry:</strong> <?php
function findCitySearch($searchTerm)
{
$geo = new Models_Geo();
$cities = $geo->findCityDetails($searchTerm, 1);
return $cities;
}
