if ($weekday == 0) {
$weekday = 7;
}
if ($weekday == $rUser['watchmail_day']) {
$nextmail = date($sDateformat, mktime($rUser['watchmail_hour'], 0, 0, date('n'), date('j') + 7, date('Y')));
} elseif ($weekday > $rUser['watchmail_day']) {
$nextmail = date($sDateformat, mktime($rUser['watchmail_hour'], 0, 0, date('n'), date('j') - $weekday + $rUser['watchmail_day'] + 7, date('Y')));
} else {
$nextmail = date($sDateformat, mktime($rUser['watchmail_hour'], 0, 0, date('n'), date('j') + 6 - $rUser['watchmail_day'], date('Y')));
}
}
sql("UPDATE user SET watchmail_nextmail='&1' WHERE user_id='&2'", $nextmail, $rUser['user_id']);
}
mysql_free_result($rsUsers);
/* end send out everything that has to be sent */
CleanupAndExit($watchpid);
function process_owner_log($user_id, $log_id)
{
global $dblink, $logowner_text;
// echo "process_owner_log($user_id, $log_id)\n";
$rsLog = sql("SELECT cache_logs.cache_id cache_id, cache_logs.text text, cache_logs.text_html text_html, cache_logs.date logdate, user.username username, caches.name cachename FROM `cache_logs`, `user`, `caches` WHERE (cache_logs.user_id = user.user_id) AND (cache_logs.cache_id = caches.cache_id) AND (cache_logs.id ='&1')", $log_id);
$rLog = sql_fetch_array($rsLog);
mysql_free_result($rsLog);
$watchtext = $logowner_text;
$logtext = $rLog['text'];
if ($rLog['text_html'] != 0) {
$logtext = html_entity_decode($logtext, ENT_COMPAT, 'UTF-8');
$h2t =& new html2text($logtext);
$logtext = $h2t->get_text();
/*
$logtext = html_entity_decode($logtext, ENT_COMPAT, 'UTF-8');
$sDateformat = 'Y-m-d H:i:s';
/* end with some constants */
/* begin db connect */
db_connect();
if ($dblink === false) {
echo 'Unable to connect to database';
exit;
}
/* end db connect */
$rsNotify = sql("\tSELECT `notify_waiting`.`id`, `notify_waiting`.`cache_id`, `notify_waiting`.`type`,\n\t\t\t\t`user`.`username`,\n\t\t\t\t`user2`.`email`, `user2`.`username` as `recpname`, `user2`.`latitude` as `lat1`, `user2`.`longitude` as `lon1`, `user2`.`user_id` as `recid`,\n\t\t\t\t`caches`.`name` as `cachename`, `caches`.`date_hidden`, `caches`.`latitude` as `lat2`, `caches`.`longitude` as `lon2`, `caches`.`wp_oc`,\n\t\t\t\t`cache_type`.`de` as `cachetype`,\n\t\t\t\t`cache_size`.`de` as `cachesize`\n\t\t\tFROM `notify_waiting`, `caches`, `user`, `user` `user2`, `cache_type`, `cache_size`, `cache_status`\n\t\t\tWHERE `notify_waiting`.`cache_id`=`caches`.`cache_id`\n\t\t\t AND `notify_waiting`.`user_id`=`user2`.`user_id`\n\t\t\t AND `caches`.`user_id`=`user`.`user_id`\n\t\t\t AND `caches`.`type`=`cache_type`.`id`\n\t\t\t AND `caches`.`status`=`cache_status`.`id`\n\t\t\t AND `caches`.`size`=`cache_size`.`id`\n\t\t\t AND `cache_status`.`allow_user_view`=1");
while ($rNotify = sql_fetch_array($rsNotify)) {
sql("DELETE FROM `notify_waiting` WHERE `id` ='&1'", $rNotify['id']);
process_new_cache($rNotify);
}
mysql_free_result($rsNotify);
CleanupAndExit($notifypid);
/* end send out everything that has to be sent */
function process_new_cache($notify)
{
global $notify_text, $mailfrom, $mailsubject, $debug, $debug_mailto, $rootpath;
//echo "process_new_cache(".$notify['id'].")\n";
$fehler = false;
// mail-template lesen
switch ($notify['type']) {
case notify_new_cache:
// Type: new cache
$mailbody = read_file($rootpath . 'util/notification/notify_newcache.email');
break;
default:
$fehler = true;
break;
****************************************************************************/
//prepare the templates and include all neccessary
$rootpath = '../../';
$pidfile = '/var/www/www.opencaching.de/html/cache/search.pid';
// chdir to proper directory (needed for cronjobs)
chdir(substr(realpath($_SERVER['PHP_SELF']), 0, strrpos(realpath($_SERVER['PHP_SELF']), '/')));
require_once $rootpath . 'lib/clicompatbase.inc.php';
require_once $rootpath . 'lib/ftsearch.inc.php';
// use posix pid-files to lock process
if (!CreatePidFile($pidfile)) {
CleanupAndExit($pidfile, "Another instance is running!");
exit;
}
db_connect();
ftsearch_refresh();
CleanupAndExit($pidfile);
//
// checks if other instance is running, creates pid-file for locking
//
function CreatePidFile($PidFile)
{
if (!CheckDaemon($PidFile)) {
return false;
}
if (file_exists($PidFile)) {
echo "Error: Pidfile (" . $PidFile . ") already present at " . __FILE__ . ":" . __LINE__ . "!\n";
return false;
} else {
if ($pidfile = @fopen($PidFile, "w")) {
fputs($pidfile, posix_getpid());
fclose($pidfile);
