public function removeLog(GeoCacheLog $log, $request = null)
{
$result = false;
if ($log === false) {
$this->errors[] = 'No such log';
return false;
}
if ($log->getNode() != OcConfig::instance()->getOcNodeId()) {
$this->errors[] = 'Wrong Node';
return false;
}
$loggedUser = \lib\Objects\ApplicationContainer::Instance()->getLoggedUser();
if ($loggedUser === false) {
$this->errors[] = 'User is not looged-in';
return false;
}
if ($log->getUser()->getUserId() === $loggedUser->getUserId() || $log->getGeoCache()->getOwner()->getUserId() == $loggedUser->getUserId() || $loggedUser->getIsAdmin()) {
if ($log->getUser()->getUserId() !== $loggedUser->getUserId()) {
EmailSender::sendRemoveLogNotification(__DIR__ . '/../../tpl/stdstyle/email/removed_log.email.html', $log, $loggedUser);
}
$updateQuery = "UPDATE `cache_logs` SET deleted = 1, `del_by_user_id` = :1 , `last_modified`=NOW(), `last_deleted`=NOW() WHERE `cache_logs`.`id`=:2 LIMIT 1";
$db = OcDb::instance();
$db->multiVariableQuery($updateQuery, $loggedUser->getUserId(), $log->getId());
$log->getUser()->recalculateAndUpdateStats();
if ($log->getType() == GeoCacheLog::LOGTYPE_MOVED) {
$this->handleMobileGeocachesAfterLogDelete($log);
}
if ($log->getType() == GeoCacheLog::LOGTYPE_FOUNDIT || $log->getType() == GeoCacheLog::LOGTYPE_ATTENDED) {
$this->cacheScoreHandlingAfterRemoveLog($log);
}
//call eventhandler
require_once __DIR__ . '/../eventhandler.inc.php';
event_remove_log($log->getGeoCache()->getCacheId(), $loggedUser->getUserId());
$this->updateGeocacheAfterLogRemove($log, $db);
$result = true;
} else {
$this->errors[] = 'User has no privileages to delete this log';
}
return $result;
}
}
sql_free_result($rs);
// evtl. discard cache recommendation
discard_recommendation($log_id);
// move to archive, even if own log (uuids are used for OKAPI replication)
sql("INSERT IGNORE INTO `cache_logs_archived` SELECT *, '0' AS `deletion_date`, '&2' AS `deleted_by`, 0 AS `restored_by` FROM `cache_logs` WHERE `cache_logs`.`id`='&1' LIMIT 1", $log_id, $usr['userid']);
// remove log entry
sql("DELETE FROM `cache_logs` WHERE `cache_logs`.`id`='&1' LIMIT 1", $log_id);
// now tell OKAPI about the deletion;
// this will trigger an okapi_syncbase update, if OKAPI is installed:
sql("UPDATE `cache_logs_archived` SET `deletion_date`=NOW() WHERE `id`='&1'", $log_id);
// do not use slave server for the next time ...
db_slave_exclude();
//call eventhandler
require_once $opt['rootpath'] . 'lib/eventhandler.inc.php';
event_remove_log($log_record['cache_id'], $log_record['log_user_id']);
//cache anzeigen
tpl_redirect('viewcache.php?cacheid=' . urlencode($log_record['cache_id']));
exit;
}
// quickfix: this is coded in res_logentry_logitem.tpl (after smarty migration)
switch ($log_record['log_type']) {
case 1:
$sLogTypeText = t("%1 found the Geocache", $log_record['log_username']);
break;
case 2:
$sLogTypeText = t("%1 didn't find the Geoacache", $log_record['log_username']);
break;
case 3:
$sLogTypeText = t("%1 wrote a note", $log_record['log_username']);
break;
function removelog($log_id, $language, $lang)
{
global $tplname, $usr, $lang, $stylepath, $oc_nodeid, $error_wrong_node, $removed_message_title, $removed_message_end, $emailheaders, $rootpath, $cacheid, $log_record, $cache_types, $cache_size, $cache_status, $dblink, $octeamEmailsSignature;
$log_rs = sql("SELECT `cache_logs`.`node` AS `node`, `cache_logs`.`uuid` AS `uuid`, `cache_logs`.`cache_id` AS `cache_id`, `caches`.`user_id` AS `cache_owner_id`,\n `caches`.`name` AS `cache_name`, `cache_logs`.`text` AS `log_text`, `cache_logs`.`type` AS `log_type`,\n `cache_logs`.`user_id` AS `log_user_id`, `cache_logs`.`date` AS `log_date`,\n `log_types`.`icon_small` AS `icon_small`,\n `log_types_text`.`text_listing` AS `text_listing`,\n `user`.`username` as `log_username`\n FROM `log_types`, `log_types_text`, `cache_logs`, `caches`, `user`\n WHERE `cache_logs`.`id`='&1'\n AND `cache_logs`.`user_id`=`user`.`user_id`\n AND `caches`.`cache_id`=`cache_logs`.`cache_id`\n AND `log_types_text`.`log_types_id`=`log_types`.`id` AND `log_types_text`.`lang`='&2'\n AND `cache_logs`.`deleted` = &3\n AND `log_types`.`id`=`cache_logs`.`type`", $log_id, $lang, 0);
//log exists?
if (mysql_num_rows($log_rs) == 1) {
$log_record = sql_fetch_array($log_rs);
mysql_free_result($log_rs);
include $stylepath . '/removelog.inc.php';
if ($log_record['node'] != $oc_nodeid) {
tpl_errorMsg('removelog', $error_wrong_node);
exit;
}
//cache-owner or log-owner
if ($log_record['log_user_id'] == $usr['userid'] || $log_record['cache_owner_id'] == $usr['userid'] || $usr['admin']) {
if ($usr['admin'] && isset($_POST['userid'])) {
$commit = 1;
} else {
$commit = isset($_REQUEST['commit']) ? $_REQUEST['commit'] : 0;
}
//we are the logger
if ($log_record['log_user_id'] == $usr['userid']) {
$tplname = 'removelog_logowner';
} else {
$tplname = 'removelog_cacheowner';
if ($commit == 1) {
//send email to logowner schicken
$email_content = read_file($stylepath . '/email/removed_log.email');
$message = isset($_POST['logowner_message']) ? $_POST['logowner_message'] : '';
if ($message != '') {
//message to logowner
$message = $removed_message_title . "\n" . $message . "\n" . $removed_message_end;
}
//get cache owner name
$cache_owner_rs = sql("SELECT `username` FROM `user` WHERE `user_id`='&1'", $log_record['cache_owner_id']);
$cache_owner_record = sql_fetch_array($cache_owner_rs);
//get email address of logowner
$log_user_rs = sql("SELECT `email`, `username` FROM `user` WHERE `user_id`='&1'", $log_record['log_user_id']);
$log_user_record = sql_fetch_array($log_user_rs);
$email_content = mb_ereg_replace('{log_owner}', $log_user_record['username'], $email_content);
$email_content = mb_ereg_replace('{cache_owner}', $cache_owner_record['username'], $email_content);
$email_content = mb_ereg_replace('{cache_name}', $log_record['cache_name'], $email_content);
$email_content = mb_ereg_replace('{log_entry}', $log_record['log_text'], $email_content);
$email_content = mb_ereg_replace('{comment}', $message, $email_content);
$email_content = mb_ereg_replace('{removedLog_01}', tr('removedLog_01'), $email_content);
$email_content = mb_ereg_replace('{removedLog_02}', tr('removedLog_02'), $email_content);
$email_content = mb_ereg_replace('{removedLog_03}', tr('removedLog_03'), $email_content);
$email_content = mb_ereg_replace('{octeamEmailsSignature}', $octeamEmailsSignature, $email_content);
$email_content = mb_ereg_replace('{removedLog_04}', tr('removedLog_04'), $email_content);
//send email (only on single removement)
mb_send_mail($log_user_record['email'], $removed_log_title, $email_content, $emailheaders);
}
}
if ($commit == 1) {
// do not acually delete logs - just mark them as deleted.
sql("UPDATE `cache_logs` SET deleted = 1, `del_by_user_id` =" . $usr['userid'] . " , `last_modified`=NOW(), `last_deleted`=NOW() WHERE `cache_logs`.`id`='&1' LIMIT 1", $log_id);
recalculateUserStats($log_record['log_user_id']);
// remove from cache_moved for log "MOVED" (mobilniaki by Łza)
// (kod istniejący wcześniej, zaadaptowany)
if ($log_record['log_type'] == 4) {
// jesli log jest ostatni - przywrocenie kordow z przedostatniego "przeniesiona"
$check_cml = sql("SELECT `latitude`,`longitude`,`id` FROM `cache_moved` WHERE `log_id`='&1'", $log_id);
if (mysql_num_rows($check_cml) != 0) {
$xy_log = sql_fetch_array($check_cml);
$check_cmc = sql("SELECT `latitude`,`longitude` FROM `caches` WHERE `cache_id`='&1'", $log_record['cache_id']);
if (mysql_num_rows($check_cmc) != 0) {
$xy_cache = sql_fetch_array($check_cmc);
if ($xy_cache['latitude'] == $xy_log['latitude'] && $xy_cache['longitude'] == $xy_log['longitude']) {
sql("DELETE FROM `cache_moved` WHERE `log_id`='&1' LIMIT 1", $log_id);
$get_xy = sql("SELECT `latitude`,`longitude` FROM `cache_moved` WHERE `cache_id`='&1' ORDER BY `date` DESC LIMIT 1", $log_record['cache_id']);
$old_xy = sql_fetch_array($get_xy);
if ($old_xy['longitude'] != '' && $old_xy['latitude'] != '') {
sql("UPDATE `caches` SET `last_modified`=NOW(), `longitude`='&1', `latitude`='&2' WHERE `cache_id`='&3'", $old_xy['longitude'], $old_xy['latitude'], $log_record['cache_id']);
}
} else {
sql("DELETE FROM `cache_moved` WHERE `log_id`='&1' LIMIT 1", $log_id);
}
} else {
sql("DELETE FROM `cache_moved` WHERE `log_id`='&1' LIMIT 1", $log_id);
}
}
}
if ($log_record['log_type'] == 1 || $log_record['log_type'] == 7) {
// remove cache from users top caches, because the found log was deleted for some reason
sql("DELETE FROM `cache_rating` WHERE `user_id` = '&1' AND `cache_id` = '&2'", $log_record['log_user_id'], $log_record['cache_id']);
// Notify OKAPI's replicate module of the change.
// Details: https://github.com/opencaching/okapi/issues/265
require_once $rootpath . 'okapi/facade.php';
\okapi\Facade::schedule_user_entries_check($log_record['cache_id'], $log_record['log_user_id']);
\okapi\Facade::disable_error_handling();
// recalc scores for this cache
sql("DELETE FROM `scores` WHERE `user_id` = '&1' AND `cache_id` = '&2'", $log_record['log_user_id'], $log_record['cache_id']);
$sql = "SELECT count(*) FROM scores WHERE cache_id='" . sql_escape($log_record['cache_id']) . "'";
$liczba = mysql_result(mysql_query($sql), 0);
$sql = "SELECT SUM(score) FROM scores WHERE cache_id='" . sql_escape($log_record['cache_id']) . "'";
$suma = @mysql_result(@mysql_query($sql), 0) + 0;
// obliczenie nowej sredniej
if ($liczba != 0) {
$srednia = $suma / $liczba;
} else {
$srednia = 0;
}
$sql = "UPDATE caches SET votes='" . sql_escape($liczba) . "', score='" . sql_escape($srednia) . "' WHERE cache_id='" . sql_escape($log_record['cache_id']) . "'";
mysql_query($sql);
}
//call eventhandler
require_once $rootpath . 'lib/eventhandler.inc.php';
event_remove_log($cacheid, $usr['userid'] + 0);
//update cache-stat if type or log_date changed
$cache_rs = sql("SELECT `founds`, `notfounds`, `notes` FROM `caches` WHERE `cache_id`='&1'", $log_record['cache_id']);
$cache_record = sql_fetch_array($cache_rs);
mysql_free_result($cache_rs);
if ($log_record['log_type'] == 1 || $log_record['log_type'] == 7) {
$cache_record['founds']--;
} elseif ($log_record['log_type'] == 2 || $log_record['log_type'] == 8) {
$cache_record['notfounds']--;
} elseif ($log_record['log_type'] == 3) {
$cache_record['notes']--;
}
//Update last found
$last_tmp = $log_record['cache_id'];
$lastfound_rs = sql("SELECT MAX(`cache_logs`.`date`) AS `date` FROM `cache_logs` WHERE ((cache_logs.`type`=1) AND (cache_logs.`cache_id`='{$last_tmp}'))");
$lastfound_record = sql_fetch_array($lastfound_rs);
if ($lastfound_record['date'] === NULL) {
$lastfound = 'NULL';
} else {
$lastfound = $lastfound_record['date'];
}
sql("UPDATE `caches` SET `last_found`='&1', `founds`='&2', `notfounds`='&3', `notes`='&4' WHERE `cache_id`='&5'", $lastfound, $cache_record['founds'], $cache_record['notfounds'], $cache_record['notes'], $log_record['cache_id']);
unset($cache_record);
if (!isset($_POST['userid'])) {
//cache anzeigen
$_GET['cacheid'] = $log_record['cache_id'];
$_REQUEST['cacheid'] = $log_record['cache_id'];
require 'viewcache.php';
}
} else {
tpl_set_var('cachename', htmlspecialchars($log_record['cache_name'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('cacheid', htmlspecialchars($log_record['cache_id'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('logid_urlencode', htmlspecialchars(urlencode($log_id), ENT_COMPAT, 'UTF-8'));
tpl_set_var('logid', htmlspecialchars($log_id, ENT_COMPAT, 'UTF-8'));
$log = read_file($stylepath . '/viewcache_log.tpl.php');
$log = mb_ereg_replace('{date}', htmlspecialchars(strftime("%d %B %Y", strtotime($log_record['log_date'])), ENT_COMPAT, 'UTF-8'), $log);
if (isset($log_record['recommended']) && $log_record['recommended'] == 1) {
$log = mb_ereg_replace('{ratingimage}', $rating_picture, $log);
} else {
$log = mb_ereg_replace('{ratingimage}', '', $log);
}
$log = mb_ereg_replace('{username}', htmlspecialchars($log_record['log_username'], ENT_COMPAT, 'UTF-8'), $log);
$log = mb_ereg_replace('{userid}', htmlspecialchars($log_record['log_user_id'] + 0, ENT_COMPAT, 'UTF-8'), $log);
tpl_set_var('log_user_name', htmlspecialchars($log_record['log_username'], ENT_COMPAT, 'UTF-8'));
$log = mb_ereg_replace('{type}', htmlspecialchars($log_record['text_listing'], ENT_COMPAT, 'UTF-8'), $log);
$log = mb_ereg_replace('{logimage}', icon_log_type($log_record['icon_small'], ""), $log);
$log = mb_ereg_replace('{logfunctions}', '', $log);
$log = mb_ereg_replace('{logpictures}', '', $log);
$log = mb_ereg_replace('{logtext}', $log_record['log_text'], $log);
$log = mb_ereg_replace('{username_aktywnosc}', '', $log);
$log = mb_ereg_replace('{kordy_mobilniaka}', '', $log);
tpl_set_var('log', $log);
//make the template and send it out
tpl_BuildTemplate();
}
} else {
//TODO: hm ... no permission to remove the log
d('no permission to remove the log');
}
} else {
//TODO: log doesn't exist
d('log doesn\'t exist');
}
}
//send email
mb_send_mail($log_user_record['email'], $removed_log_title, $email_content, $emailheaders);
}
}
if ($commit == 1) {
// move to archive
sql("INSERT INTO `cache_logs_archived` SELECT * FROM `cache_logs` WHERE `cache_logs`.`id`='&1' LIMIT 1", $log_id);
//log entfernen
sql("DELETE FROM `cache_logs` WHERE `cache_logs`.`id`='&1' LIMIT 1", $log_id);
// remove cache from users top caches, because the found log was deleted for some reason
sql("DELETE FROM `cache_rating` WHERE `user_id` = '&1' AND `cache_id` = '&2'", $log_record['log_user_id'], $log_record['cache_id']);
// do not use slave server for the next time ...
db_slave_exclude();
//call eventhandler
require_once $rootpath . 'lib/eventhandler.inc.php';
event_remove_log($cacheid, $usr['userid'] + 0);
//cache anzeigen
tpl_redirect('viewcache.php?cacheid=' . urlencode($log_record['cache_id']));
exit;
}
// quickfix: this is coded in res_logentry_logitem.tpl (after smarty migration)
switch ($log_record['log_type']) {
case 1:
$sLogTypeText = t("%1 found the Geocache", $log_record['log_username']);
break;
case 2:
$sLogTypeText = t("%1 didn't find the Geoacache", $log_record['log_username']);
break;
case 3:
$sLogTypeText = t("%1 wrote a note", $log_record['log_username']);
break;
function revertLog($log_id, $language, $lang)
{
// set $debug = true to display debug messages (or false to hide).
$debug = false;
global $tplname, $usr, $lang, $stylepath, $oc_nodeid, $error_wrong_node, $removed_message_title, $removed_message_end, $emailheaders, $rootpath, $cacheid, $log_record, $cache_types, $cache_size, $cache_status, $dblink;
$logRs = new dataBase($debug);
$logRsQuery = "SELECT `cache_logs`.`node` AS `node`, `cache_logs`.`uuid` AS `uuid`, `cache_logs`.`cache_id` AS `cache_id`, `caches`.`user_id` AS `cache_owner_id`,\n `caches`.`name` AS `cache_name`, `cache_logs`.`text` AS `log_text`, `cache_logs`.`type` AS `log_type`,\n `cache_logs`.`user_id` AS `log_user_id`, `cache_logs`.`date` AS `log_date`,\n `log_types`.`icon_small` AS `icon_small`,\n `log_types_text`.`text_listing` AS `text_listing`,\n `user`.`username` as `log_username`\n FROM `log_types`, `log_types_text`, `cache_logs`, `caches`, `user`\n WHERE `cache_logs`.`id`=:log_id\n AND `cache_logs`.`user_id`=`user`.`user_id`\n AND `caches`.`cache_id`=`cache_logs`.`cache_id`\n AND `log_types_text`.`log_types_id`=`log_types`.`id` AND `log_types_text`.`lang`=:lang\n AND `cache_logs`.`deleted` = 1\n AND `log_types`.`id`=`cache_logs`.`type`";
$logRs->paramQuery($logRsQuery, array('log_id' => array('value' => $log_id, 'data_type' => 'integer'), 'lang' => array('value' => $lang, 'data_type' => 'string')));
//log exists?
if ($logRs->rowCount() == 1) {
$log_record = $logRs->dbResultFetch();
unset($logRs);
// include($stylepath . '/removelog.inc.php');
if ($log_record['node'] != $oc_nodeid) {
tpl_errorMsg('removelog', $error_wrong_node);
exit;
}
//cache-owner or log-owner
if ($log_record['log_user_id'] == $usr['userid'] || $log_record['cache_owner_id'] == $usr['userid'] || $usr['admin']) {
// revert the log.
$revert = new dataBase($debug);
$query = "UPDATE `cache_logs` SET deleted = 0 , `last_modified`=NOW() WHERE `cache_logs`.`id`=:log_id LIMIT 1";
$revert->paramQuery($query, array('log_id' => array('value' => $log_id, 'data_type' => 'i')));
unset($revert);
//user stats update
$statUpd = new dataBase();
$query = "SELECT `founds_count`, `notfounds_count`, `log_notes_count` FROM `user` WHERE `user_id`=:user_id";
$statUpd->paramQuery($query, array('user_id' => array('value' => $log_record['log_user_id'], 'data_type' => 'i')));
$user_record = $statUpd->dbResultFetch();
unset($statUpd);
if ($log_record['log_type'] == 1 || $log_record['log_type'] == 7) {
$user_record['founds_count']++;
} elseif ($log_record['log_type'] == 2) {
$user_record['notfounds_count']++;
} elseif ($log_record['log_type'] == 3) {
$user_record['log_notes_count']++;
}
$updateUser = new dataBase($debug);
$query = "UPDATE `user` SET `founds_count`=:var1, `notfounds_count`=:var2, `log_notes_count`=:var3 WHERE `user_id`=:var4";
$params = array('var1' => array('value' => $user_record['founds_count'], 'data_type' => 'i'), 'var2' => array('value' => $user_record['notfounds_count'], 'data_type' => 'i'), 'var3' => array('value' => $user_record['log_notes_count'], 'data_type' => 'i'), 'var4' => array('value' => $log_record['log_user_id'], 'data_type' => 'i'));
$updateUser->paramQuery($query, $params);
unset($updateUser, $params, $user_record);
//call eventhandler
require_once $rootpath . 'lib/eventhandler.inc.php';
event_remove_log($cacheid, $usr['userid'] + 0);
//update cache-stat if type or log_date changed
$cachStat = new dataBase($debug);
$query = "SELECT `founds`, `notfounds`, `notes` FROM `caches` WHERE `cache_id`=:var1";
$cachStat->paramQuery($query, array('var1' => array('value' => $log_record['cache_id'], 'data_type' => 'i')));
$cache_record = $cachStat->dbResultFetch();
unset($cachStat);
if ($log_record['log_type'] == 1 || $log_record['log_type'] == 7) {
$cache_record['founds']++;
} elseif ($log_record['log_type'] == 2 || $log_record['log_type'] == 8) {
$cache_record['notfounds']++;
} elseif ($log_record['log_type'] == 3) {
$cache_record['notes']++;
}
//Update last found
$lastF = new dataBase();
$query = "SELECT MAX(`cache_logs`.`date`) AS `date` FROM `cache_logs` WHERE ((cache_logs.`type`=1) AND (cache_logs.`cache_id`=:last_tmp))";
$lastF->paramQuery($query, array('last_tmp' => array('value' => $log_record['cache_id'], 'data_type' => 'i')));
$lastfound_record = $lastF->dbResultFetch();
unset($statUpd);
if ($lastfound_record['date'] === NULL) {
$lastfound = 'NULL';
} else {
$lastfound = $lastfound_record['date'];
}
$updateCache = new dataBase();
$query = "UPDATE `caches` SET `last_found`=:var1, `founds`=:var2, `notfounds`=:var3, `notes`=:var4 WHERE `cache_id`=:var5";
$params = array('var1' => array('value' => $lastfound, 'data_type' => 'string'), 'var2' => array('value' => $cache_record['founds'], 'data_type' => 'i'), 'var3' => array('value' => $cache_record['notfounds'], 'data_type' => 'i'), 'var4' => array('value' => $cache_record['notes'], 'data_type' => 'i'), 'var5' => array('value' => $log_record['cache_id'], 'data_type' => 'i'));
$updateCache->paramQuery($query, $params);
unset($updateCache, $params, $cache_record);
$_GET['cacheid'] = $log_record['cache_id'];
$_REQUEST['cacheid'] = $log_record['cache_id'];
require 'viewcache.php';
} else {
//TODO: hm ... no permission to revert the log
$_GET['cacheid'] = $log_record['cache_id'];
$_REQUEST['cacheid'] = $log_record['cache_id'];
require 'viewcache.php';
}
} else {
//TODO: log doesn't exist
$_GET['cacheid'] = $log_record['cache_id'];
$_REQUEST['cacheid'] = $log_record['cache_id'];
require 'viewcache.php';
}
}
