function run()
{
$db = new dataBase();
$db->switchDebug(false);
$sql = "delete from CACHE_ACCESS_LOGS where date_sub(now(), INTERVAL 5 DAY) > event_date";
set_time_limit(360);
$db->simpleQuery($sql);
$total_deleted = $db->rowCount();
set_time_limit(60);
unset($db);
echo "total_deleted={$total_deleted}\n";
}
echo "<tr><td>{$row['id']}</td><td>{$row['name']}</td></tr>";
}
echo '</table>';
die;
}
}
require_once './lib/common.inc.php';
// ob_start();
echo '<b>start</b><br>';
$db = new dataBase();
$db->simpleQuery("drop table if exists transaction_test;");
$db->simpleQuery("\n create table transaction_test (\n id int(10) not null auto_increment,\n name varchar(50) not null,\n PRIMARY KEY (id)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
$db2 = new dataBase();
// test transaction isolation
$db2->beginTransaction();
$db2->simpleQuery("insert into transaction_test (name) values('Asia')");
$db2->simpleQuery("insert into transaction_test (name) values('Kasia')");
$db2->simpleQuery("insert into transaction_test (name) values('Natalia')");
check_database_count($db, 0, __LINE__);
// test commit
$db2->commit();
check_database_count($db, 3, __LINE__);
// test no-transaction
$db2->simpleQuery("insert into transaction_test (name) values('Basia')");
check_database_count($db, 4, __LINE__);
// test rollback
$db2->beginTransaction();
$db2->simpleQuery("delete from transaction_test where name = 'Kasia'");
if ($db2->rowCount() !== 1) {
echo "Expected 1 row to be deleted!<br>";
die;
//powertrail vel geopath variables
$pt_cache_intro_tr = tr('pt_cache');
$pt_icon_title_tr = tr('pt139');
for ($i = 0; $i < $db->rowCount(); $i++) {
$record = $db->dbResultFetch();
if ($i > 0) {
$log_ids .= ', ' . $record['id'];
} else {
$log_ids = $record['id'];
}
}
$rsQuery = "SELECT cache_logs.id, cache_logs.cache_id AS cache_id,\n cache_logs.type AS log_type,\n cache_logs.date AS log_date,\n `cache_logs`.`encrypt` `encrypt`,\n cache_logs.user_id AS luser_id,\n cache_logs.text AS log_text,\n cache_logs.text_html AS text_html,\n caches.name AS cache_name,\n caches.user_id AS cache_owner,\n user.username AS user_name,\n caches.user_id AS user_id,\n user.user_id AS xuser_id,\n caches.wp_oc AS wp_name,\n caches.type AS cache_type,\n cache_type.icon_small AS cache_icon_small,\n log_types.icon_small AS icon_small,\n log_types.pl as pl,\n IF(ISNULL(`cache_rating`.`cache_id`), 0, 1) AS `recommended`,\n COUNT(gk_item.id) AS geokret_in,\n `PowerTrail`.`id` AS PT_ID,\n `PowerTrail`.`name` AS PT_name,\n `PowerTrail`.`type` As PT_type,\n `PowerTrail`.`image` AS PT_image\n FROM (cache_logs INNER JOIN caches ON (caches.cache_id = cache_logs.cache_id)) INNER JOIN user ON (cache_logs.user_id = user.user_id) INNER JOIN log_types ON (cache_logs.type = log_types.id) INNER JOIN cache_type ON (caches.type = cache_type.id) LEFT JOIN `cache_rating` ON `cache_logs`.`cache_id`=`cache_rating`.`cache_id` AND `cache_logs`.`user_id`=`cache_rating`.`user_id`\n LEFT JOIN gk_item_waypoint ON gk_item_waypoint.wp = caches.wp_oc\n LEFT JOIN gk_item ON gk_item.id = gk_item_waypoint.id AND\n\n gk_item.stateid<>1 AND gk_item.stateid<>4 AND gk_item.typeid<>2 AND gk_item.stateid !=5\n LEFT JOIN `powerTrail_caches` ON cache_logs.cache_id = `powerTrail_caches`.`cacheId`\n LEFT JOIN `PowerTrail` ON `PowerTrail`.`id` = `powerTrail_caches`.`PowerTrailId` AND `PowerTrail`.`status` = 1\n WHERE cache_logs.deleted=0 AND cache_logs.id IN ({$log_ids}) AND cache_logs.cache_id=caches.cache_id AND caches.status<> 4 AND caches.status<> 5 AND caches.status<> 6\n GROUP BY cache_logs.id\n ORDER BY cache_logs.date_created DESC";
$file_content = '';
$tr_myn_click_to_view_cache = tr('myn_click_to_view_cache');
$bgColor = '#eeeeee';
$db->simpleQuery($rsQuery);
for ($i = 0; $i < $db->rowCount(); $i++) {
if ($bgColor == '#eeeeee') {
$bgColor = '#ffffff';
} else {
$bgColor = '#eeeeee';
}
$log_record = $db->dbResultFetch();
$file_content .= '<tr bgcolor="' . $bgColor . '">';
$file_content .= '<td style="width: 70px;">' . htmlspecialchars(date($dateFormat, strtotime($log_record['log_date'])), ENT_COMPAT, 'UTF-8') . '</td>';
if ($log_record['geokret_in'] != '0') {
$file_content .= '<td width="22"> <img src="images/gk.png" border="0" alt="" title="GeoKret" /></td>';
} else {
$file_content .= '<td width="22"> </td>';
}
//$rating_picture
<?php
$rootpath = __DIR__ . DIRECTORY_SEPARATOR;
require_once $rootpath . 'lib/common.inc.php';
$db = new dataBase();
$countryCode = addslashes($_REQUEST['countryCode']);
$selectedRegion = $_REQUEST['selectedRegion'];
$query = "SELECT `code`, `name` FROM `nuts_codes` WHERE `code` LIKE '" . $countryCode . "__' ORDER BY `name` COLLATE utf8_polish_ci ASC";
$db->simpleQuery($query);
$regons = $db->dbResultFetchAll();
if (count($regons) == 0) {
if (isset($_REQUEST['searchForm']) && $_REQUEST['searchForm'] == 1) {
$regionoptions = '<option value="">' . tr('search01') . '</option>';
} else {
$regionoptions = '<option value="-1">-</option>';
}
} else {
if (isset($_REQUEST['searchForm']) && $_REQUEST['searchForm'] == 1) {
$regionoptions = '<option value="">' . tr('search01') . '</option>';
} else {
$regionoptions = '<option value="0">' . tr('select_regions') . '</option>';
}
foreach ($regons as $record) {
if ($record['code'] == $selectedRegion) {
$regionoptions .= '<option value="' . htmlspecialchars($record['code'], ENT_COMPAT, 'UTF-8') . '" selected="selected" >' . htmlspecialchars($record['name'], ENT_COMPAT, 'UTF-8') . '</option>';
} else {
$regionoptions .= '<option value="' . htmlspecialchars($record['code'], ENT_COMPAT, 'UTF-8') . '">' . htmlspecialchars($record['name'], ENT_COMPAT, 'UTF-8') . '</option>';
}
$regionoptions .= "\n";
}
}
/**
*
* @@param array $opt - database accesing data from opencaching config
* @param float $lat geografical latitude (coordinates)
* @param float $lon geografical longitude (coordinates)
*
* @return array with code and names of regions selected from input geografical coordinates.void
*/
public function GetRegion($lat, $lon)
{
require_once __DIR__ . '/lib/gis/gis.class.php';
$lat_float = (double) $lat;
$lon_float = (double) $lon;
$sCode = '';
$tmpqery = "SELECT `level`, `code`, AsText(`shape`) AS `geometry` FROM `nuts_layer` WHERE WITHIN(GeomFromText('POINT({$lon} {$lat})'), `shape`) ORDER BY `level` DESC";
$db = new dataBase();
$db->simpleQuery($tmpqery);
$rsLayers = $db->dbResultFetchAll();
foreach ($rsLayers as $rLayers) {
if (gis::ptInLineRing($rLayers['geometry'], 'POINT(' . $lon . ' ' . $lat . ')')) {
$sCode = $rLayers['code'];
break;
}
}
if ($sCode != '') {
$adm1 = null;
$code1 = null;
$adm2 = null;
$code2 = null;
$adm3 = null;
$code3 = null;
$adm4 = null;
$code4 = null;
if (mb_strlen($sCode) > 5) {
$sCode = mb_substr($sCode, 0, 5);
}
if (mb_strlen($sCode) == 5) {
$code4 = $sCode;
$q = "SELECT `name` FROM `nuts_codes` WHERE `code`='{$sCode}'";
$db->simpleQuery($q);
$re = $db->dbResultFetch();
$adm4 = $re["name"];
unset($re, $q);
$sCode = mb_substr($sCode, 0, 4);
}
if (mb_strlen($sCode) == 4) {
$code3 = $sCode;
$q = "SELECT `name` FROM `nuts_codes` WHERE `code`='{$sCode}'";
$db->simpleQuery($q);
$re = $db->dbResultFetch();
$adm3 = $re["name"];
unset($re, $q);
$sCode = mb_substr($sCode, 0, 3);
}
if (mb_strlen($sCode) == 3) {
$code2 = $sCode;
$q = "SELECT `name` FROM `nuts_codes` WHERE `code`='{$sCode}'";
$db->simpleQuery($q);
$re = $db->dbResultFetch();
$adm2 = $re["name"];
unset($re, $q);
$sCode = mb_substr($sCode, 0, 2);
}
if (mb_strlen($sCode) == 2) {
$code1 = $sCode;
// try to get localised name first
$q = "SELECT `countries`.`pl` FROM `countries` WHERE `countries`.`short`='{$sCode}'";
// TODO: country column should be localized
$db->simpleQuery($q);
$re = $db->dbResultFetch();
$adm1 = $re["pl"];
unset($re, $q);
if ($adm1 == null) {
$q = "SELECT `name` FROM `nuts_codes` WHERE `code`='{$sCode}'";
$db->simpleQuery($q);
$re = $db->dbResultFetch();
$adm1 = $re["name"];
unset($re, $q);
}
}
$wynik['adm1'] = $adm1;
$wynik['adm2'] = $adm2;
$wynik['adm3'] = $adm3;
$wynik['adm4'] = $adm4;
$wynik['code1'] = $code1;
$wynik['code2'] = $code2;
$wynik['code3'] = $code3;
$wynik['code4'] = $code4;
} else {
$wynik = false;
}
return $wynik;
}
public static function removeDbRows($rowsString)
{
$db = new dataBase();
$query = "DELETE FROM `GeoKretyAPIerrors` WHERE id in ({$rowsString})";
$db->simpleQuery($query);
}
$tmpline = str_replace('{new}', $caches_newstring, $tmpline);
} else {
$tmpline = str_replace('{new}', '', $tmpline);
}
$tmpline = str_replace('{diffpic}', icon_difficulty("diff", $caches_record['difficulty']), $tmpline);
$tmpline = str_replace('{terrpic}', icon_difficulty("terr", $caches_record['terrain']), $tmpline);
$typy = array(0 => 0, 1 => 0, 2 => 0);
if ($CalcFNC) {
$sql_liczniki = 'SELECT count(cache_logs.type) as typy, cache_logs.type as type
FROM `cache_logs`, `log_types`
WHERE `cache_logs`.`cache_id`=\'' . sql_escape($caches_record['cache_id']) . '\'
AND `cache_logs`.`deleted`=0
AND `log_types`.`id`=`cache_logs`.`type`
GROUP BY cache_logs.type
ORDER BY cache_logs.type ASC';
$dbc->simpleQuery($sql_liczniki);
$typy_i = 0;
while ($row = $dbc->dbResultFetch()) {
$typy[$row['type'] - 1] = $row['typy'];
}
$tmpline = str_replace('{logtypes1}', "<span " . str_pad($typy[0], 5, 0, STR_PAD_LEFT) . " style='color:green'>" . $typy[0] . "</span>.<span style='color:red'>" . $typy[1] . "</span>.<span style='color:black'>" . $typy[2] . "</span>", $tmpline);
$dbc->reset();
}
$tmpline = str_replace('{find}', $typy[0], $tmpline);
$tmpline = str_replace('{notfind}', $typy[1], $tmpline);
$tmpline = str_replace('{comment}', $typy[2], $tmpline);
// das letzte found suchen
if ($CalcEntry) {
$sql = 'SELECT `cache_logs`.`id` `id`, `cache_logs`.`type` `type`, `cache_logs`.`date` `date`,
`log_types`.`icon_small` `icon_small`,
cache_logs.text AS log_text
