function checkJob(&$job)
{
$last_run = strftime(DB_DATE_FORMAT, time() - $job->interval);
$count = sqll_value("SELECT COUNT(*) FROM `sys_cron` WHERE `name`='&1' AND `last_run`>'&2' AND `last_run`<=NOW()", 0, $job->name, $last_run);
if ($count != 1) {
$job->run();
sqll("INSERT INTO `sys_cron` (`name`, `last_run`) VALUES ('&1', NOW()) ON DUPLICATE KEY UPDATE `last_run`=NOW()", $job->name);
}
}
function checkJob(&$job)
{
global $ignore_interval;
$max_last_run = strftime(DB_DATE_FORMAT, time() - ($ignore_interval ? 0 : $job->interval));
$count = sqll_value("SELECT COUNT(*)\n FROM `sys_cron`\n WHERE\n `name` = '&1'\n AND `last_run` > '&2'\n AND `last_run` <= NOW()", 0, $job->name, $max_last_run);
if ($count != 1) {
$job->run();
sqll("INSERT INTO `sys_cron` (`name`, `last_run`)\n VALUES ('&1', NOW())\n ON DUPLICATE KEY UPDATE `last_run` = NOW()", $job->name);
}
}
function geodb_landkreisFromLocid($locid)
{
if (!is_numeric($locid)) {
return 0;
}
$locid = $locid + 0;
$rs = sqll("SELECT `rb`.`text_val` `regierungsbezirk` FROM `geodb_textdata` `ct`, `geodb_textdata` `rb`, `geodb_hierarchies` `hr` WHERE `ct`.`loc_id`=`hr`.`loc_id` AND `hr`.`id_lvl5`=`rb`.`loc_id` AND `ct`.`text_type`=500100000 AND `rb`.`text_type`=500100000 AND `ct`.`loc_id`='&1' AND `hr`.`id_lvl5`!=0", $locid);
if ($r = sql_fetch_array($rs)) {
return $r['regierungsbezirk'];
} else {
return '';
}
}
function getCacheIcon($user_id, $cache_id, $cache_status, $cache_userid, $iconname)
{
$cacheicon_searchable = false;
$cacheicon_type = "";
$inactive = false;
// mark if found
if (isset($user_id)) {
$found = 0;
$resp = sqll("SELECT `type` FROM `cache_logs` WHERE `cache_id`='&1' AND `user_id`='&2' ORDER BY `type`", $cache_id, $user_id);
while ($row = sql_fetch_assoc($resp)) {
if ($found <= 0) {
switch ($row['type']) {
case 1:
case 7:
$found = $row['type'];
$cacheicon_type = "-found";
$inactive = true;
break;
case 2:
$found = $row['type'];
$cacheicon_type = "-dnf";
break;
}
}
}
}
if ($cache_userid == $user_id) {
$cacheicon_type = "-owner";
$inactive = true;
switch ($cache_status) {
case 1:
$cacheicon_searchable = "-s";
break;
case 2:
$cacheicon_searchable = "-n";
break;
case 3:
$cacheicon_searchable = "-a";
break;
case 4:
$cacheicon_searchable = "-a";
break;
}
} else {
switch ($cache_status) {
case 1:
$cacheicon_searchable = "-s";
break;
case 2:
$inactive = true;
$cacheicon_searchable = "-n";
break;
case 3:
$inactive = true;
$cacheicon_searchable = "-a";
break;
case 4:
$inactive = true;
$cacheicon_searchable = "-a";
break;
}
}
// cacheicon
$iconname = mb_eregi_replace("\\..*", "", $iconname);
$iconname .= $cacheicon_searchable . $cacheicon_type . ".gif";
return array($iconname, $inactive);
}
function save()
{
foreach ($this->nOptions as $record) {
sqll("INSERT INTO `user_options` (`user_id`, `option_id`, `option_visible`, `option_value`) \r\n\t\t\t VALUES ('&1', '&2', '&3', '&4') ON DUPLICATE KEY UPDATE `option_visible`='&3', `option_value`='&4'", $this->nUserId, $record['id'], $record['option_visible'], $this->tidy_html_description($record['option_value']));
}
return true;
}
