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