$activation_date = "'" . date('Y-m-d H:i:s', mktime($activate_hour, 0, 0, $activate_month, $activate_day, $activate_year)) . "'";
} elseif ($publish == 'notnow') {
$sel_status = 5;
$activation_date = 'NULL';
} else {
// should never happen
$activation_date = 'NULL';
}
$cache_uuid = create_uuid();
//add record to caches table
sql("INSERT INTO `caches` (\r\n\t\t\t\t\t\t\t\t\t\t\t\t`cache_id`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`user_id`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`name`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`longitude`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`latitude`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`type` ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`status` ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`country` ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`date_hidden` ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`date_activate` ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`size` ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`difficulty` ,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`terrain`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`uuid`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`logpw`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`search_time`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`way_length`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`wp_gc`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`wp_nc`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t`node`\r\n\t\t\t\t\t\t\t\t\t\t\t) VALUES (\r\n\t\t\t\t\t\t\t\t\t\t\t\t'', '&1', '&2', '&3', '&4', '&5', '&6', '&7', '&8', {$activation_date}, \r\n\t\t\t\t\t\t\t\t\t\t\t\t'&9', '&10', '&11', '&12', '&13', '&14', '&15', '&16', '&17', '&18')", $usr['userid'], $name, $longitude, $latitude, $sel_type, $sel_status, $sel_country, date('Y-m-d', $hidden_date), $sel_size, $difficulty, $terrain, $cache_uuid, $log_pw, $search_time, $way_length, $wp_gc, $wp_nc, $oc_nodeid);
$cache_id = mysql_insert_id($dblink);
// do not use slave server for the next time ...
db_slave_exclude();
// waypoint erstellen
setCacheWaypoint($cache_id);
$desc_uuid = create_uuid();
//add record to cache_desc table
if ($descMode != 1) {
sql("INSERT INTO `cache_desc` (\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`id`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`cache_id`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`language`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`desc`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`desc_html`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`hint`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`short_desc`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`last_modified`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`uuid`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`desc_htmledit`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`node`\r\n\t\t\t\t\t\t\t\t\t\t\t\t) VALUES ('', '&1', '&2', '&3', '1', '&4', '&5', NOW(), '&6', '&7', '&8')", $cache_id, $sel_lang, $desc, nl2br(htmlspecialchars($hints, ENT_COMPAT, 'UTF-8')), $short_desc, $desc_uuid, $descMode == 3 ? 1 : 0, $oc_nodeid);
} else {
sql("INSERT INTO `cache_desc` (\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`id`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`cache_id`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`language`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`desc`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`desc_html`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`hint`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`short_desc`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`last_modified`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`uuid`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`desc_htmledit`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`node`\r\n\t\t\t\t\t\t\t\t\t\t\t\t) VALUES ('', '&1', '&2', '&3', '0', '&4', '&5', NOW(), '&6', 0, '&7')", $cache_id, $sel_lang, nl2br(htmlspecialchars($desc, ENT_COMPAT, 'UTF-8')), nl2br(htmlspecialchars($hints, ENT_COMPAT, 'UTF-8')), $short_desc, $desc_uuid, $oc_nodeid);
}
// insert cache-attributes
for ($i = 0; $i < count($cache_attribs); $i++) {
if ($cache_attribs[$i] + 0 > 0) {
sql("INSERT INTO `caches_attributes` (`cache_id`, `attrib_id`) VALUES ('&1', '&2')", $cache_id, $cache_attribs[$i] + 0);
}
}
// only if cache is published NOW or activate_date is in the past
if ($publish == 'now2' || $publish == 'later' && mktime($activate_hour, 0, 0, $activate_month, $activate_day, $activate_year) <= $today) {
// check if selected country has no districts, then use $default_region
if ($sel_region == -1) {
$sel_region = $default_region;
}
if ($sel_region != "0") {
$code3 = $sel_region;
$adm3 = sqlValue("SELECT `name` FROM `nuts_codes` WHERE `code`='" . sql_escape($sel_region) . "'", 0);
} else {
$code3 = null;
$adm3 = null;
}
sql("INSERT INTO `cache_location` (cache_id,adm1,adm3,code1,code3) VALUES ('&1','&2','&3','&4','&5')", $cache_id, $adm1, $adm3, $code1, $code3);
// update cache last modified, it is for work of cache_locations update information
sql("UPDATE `caches` SET `last_modified`=NOW() WHERE `cache_id`='&1'", $cache_id);
// waypoint erstellen
setCacheWaypoint($cache_id, $oc_waypoint);
$desc_uuid = create_uuid();
//add record to cache_desc table
$desc = userInputFilter::purifyHtmlString($desc);
$query = "INSERT INTO `cache_desc` (\n `cache_id`,\n `language`,\n `desc`,\n `hint`,\n `short_desc`,\n `last_modified`,\n `uuid`,\n `node`\n ) VALUES (:1, :2, :3, :4, :5, NOW(), :6, :7)";
$db->multiVariableQuery($query, $cache_id, $sel_lang, $desc, nl2br(htmlspecialchars($hints, ENT_COMPAT, 'UTF-8')), $short_desc, $desc_uuid, $oc_nodeid);
setCacheDefaultDescLang($cache_id);
// insert cache-attributes
for ($i = 0; $i < count($cache_attribs); $i++) {
if ($cache_attribs[$i] + 0 > 0) {
sql("INSERT INTO `caches_attributes` (`cache_id`, `attrib_id`) VALUES ('&1', '&2')", $cache_id, $cache_attribs[$i] + 0);
}
}
// only if no approval is needed and cache is published NOW or activate_date is in the past
if (!$needs_approvement && ($publish == 'now' || $publish == 'later' && mktime($activate_hour, 0, 0, $activate_month, $activate_day, $activate_year) <= $today)) {
//do event handling
<?php
$rootpath = '../../';
require_once $rootpath . 'lib/settings.inc.php';
require_once $rootpath . 'lib/clicompatbase.inc.php';
/* begin db connect */
$bFail = false;
$dblink = mysql_connect($dbserver, $dbusername, $dbpasswd);
if ($dblink != false) {
//database connection established ... set the used database
if (@mysql_select_db($dbname, $dblink) == false) {
$bFail = true;
mysql_close($dblink);
$dblink = false;
}
} else {
$bFail = true;
}
if ($bFail == true) {
echo 'Unable to connect to database';
exit;
}
/* end db connect */
$rs = sql('SELECT `cache_id` FROM `caches` WHERE ISNULL(`wp_oc`)');
while ($r = mysql_fetch_array($rs)) {
setCacheWaypoint($r['cache_id']);
}
mysql_free_result($rs);
