function get_location_id($ip_address)
{
if (geoLocationDatabaseInstalled() == true) {
$clean['ip_address'] = ip2long($ip_address);
$mysql['ip_address'] = mysql_real_escape_string($clean['ip_address']);
$location_sql = "SELECT location_id FROM 202_locations_block WHERE location_block_ip_from >= '" . $mysql['ip_address'] . "' AND location_block_ip_to <= '" . $mysql['ip_address'] . "'";
$location_row = memcache_mysql_fetch_assoc($location_sql);
$location_id = $location_row['location_id'];
return $location_id;
} else {
return 0;
}
}
?>
</td>
<td class="date"><?php
echo $html['click_time'];
?>
</td>
<td class="ppc"><?php
echo $html['browser_id'];
?>
</td>
<td class="ppc"><?php
echo $html['platform_id'];
?>
</td>
<?php
if (geoLocationDatabaseInstalled() == true) {
echo '<td class="flag">' . $html['location'] . '</td>';
}
?>
<td class="ppc"><?php
echo $ppc_network_icon;
?>
</td>
<td class="filter">
<?php
if ($click_row['click_filtered'] == '1') {
?>
<img style="margin-right: auto;" src="/xtracks-img/icons/16x16/delete.png" alt="Filtered Out Click" title="filtered out click"/>
<?php
} elseif ($click_row['click_lead'] == '1') {
?>
</tr>
<tr>
<th>Memcache Running <a href="#" onclick="alert('If memcache is installed, but not running, check your 202-config.php to make sure your connecting to a server that has memcache installed');">[?]</a></th>
<td><?php
if ($memcacheWorking) {
echo 'Yes';
} else {
echo 'No';
}
?>
</td>
</tr>
<tr>
<th>Geo-Location DB Installed <a href="http://prosper202.com/apps/docs/geolocationdb/">[?]</a></th>
<td><?php
if (geoLocationDatabaseInstalled() == false) {
echo 'No ';
} else {
echo 'Yes';
}
?>
</td>
</tr>
<tr>
<th>Default Keyword Preference</th>
<td><?php
$mysql['user_id'] = mysql_real_escape_string($_SESSION['user_id']);
$user_sql = "SELECT * FROM 202_users_pref WHERE user_id='" . $mysql['user_id'] . "'";
$user_result = _mysql_query($user_sql);
$user_row = mysql_fetch_assoc($user_result);
$html['keyword_pref'] = htmlentities(strtoupper($user_row['user_keyword_searched_or_bidded']));