function landkreisFromLocid($locid) { if (!is_numeric($locid)) { return ''; } return XDb::xMultiVariableQueryValue("SELECT `rb`.`text_val` `regierungsbezirk`\n FROM `geodb_textdata` `ct`, `geodb_textdata` `rb`, `geodb_hierarchies` `hr`\n WHERE `ct`.`loc_id`=`hr`.`loc_id`\n AND `hr`.`id_lvl5`=`rb`.`loc_id`\n AND `ct`.`text_type`=500100000\n AND `rb`.`text_type`=500100000\n AND `ct`.`loc_id`= :1\n AND `hr`.`id_lvl5`!=0", 0, $locid); }
function isGeokretInCache($cacheid) { $res = XDb::xSql("SELECT wp_oc, wp_gc, wp_nc, wp_ge, wp_tc\n FROM caches WHERE cache_id = ? LIMIT 1", $cacheid); $cache_record = XDb::xFetchArray($res); // get cache waypoint $cache_wp = ''; if ($cache_record['wp_oc'] != '') { $cache_wp = $cache_record['wp_oc']; } else { if ($cache_record['wp_gc'] != '') { $cache_wp = $cache_record['wp_gc']; } else { if ($cache_record['wp_nc'] != '') { $cache_wp = $cache_record['wp_nc']; } else { if ($cache_record['wp_ge'] != '') { $cache_wp = $cache_record['wp_ge']; } else { if ($cache_record['wp_tc'] != '') { $cache_wp = $cache_record['wp_tc']; } } } } } $gkNum = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM gk_item\n WHERE id IN (\n SELECT id FROM gk_item_waypoint\n WHERE wp = :1\n )\n AND stateid<>1 AND stateid<>4\n AND stateid <>5 AND typeid<>2", 0, $cache_wp); if ($gkNum == 0) { return 0; } else { return 1; } }
$code2 = $sCode; $adm2 = XDb::xMultiVariableQueryValue("SELECT `name` FROM `nuts_codes` WHERE `code`= :1", 0, $sCode); $sCode = mb_substr($sCode, 0, 2); } if (mb_strlen($sCode) == 2) { $code1 = $sCode; if (checkField('countries', 'list_default_' . $lang)) { $lang_db = $lang; } else { $lang_db = "en"; } $eLang = XDb::xEscape($lang_db); // try to get localised name first $adm1 = XDb::xMultiVariableQueryValue("SELECT `countries`.`{$eLang}` FROM `countries`\n WHERE `countries`.`short`= :1 ", 0, $sCode); if ($adm1 == null) { $adm1 = XDb::xMultiVariableQueryValue("SELECT `name` FROM `nuts_codes` WHERE `code`= :1 ", 0, $sCode); } } tpl_set_var('country', $adm1); tpl_set_var('region', $adm3); } else { tpl_set_var('country', ""); tpl_set_var('region', ""); } //From Google $url = '//maps.googleapis.com/maps/api/geocode/json?latlng=' . $lat . ',' . $lon . '&sensor=false&language=' . $lang; $data = @file_get_contents($url); $jsondata = json_decode($data, true); //print_r($jsondata); if (isset($jsondata['status']) && strtoupper($jsondata['status']) == 'OK') { $woj = $jsondata['results']['0']['address_components']['5']['long_name'];
tpl_set_var('cache_stat', $rs_stat); $ran = XDb::xMultiVariableQueryValue("SELECT count(cache_id) FROM caches WHERE `caches`.`status` = '1' AND `caches`.`user_id`= :1 ", 0, $user_id); tpl_set_var('activeN', $ran); $run = XDb::xMultiVariableQueryValue("SELECT count(cache_id) FROM caches WHERE `caches`.`status` = '2' AND `caches`.`user_id`= :1", 0, $user_id); tpl_set_var('unavailableN', $run); $rarn = XDb::xMultiVariableQueryValue("SELECT count(cache_id) FROM caches WHERE `caches`.`status` = '3' AND `caches`.`user_id`= :1 ", 0, $user_id); tpl_set_var('archivedN', $rarn); $rnpn = XDb::xMultiVariableQueryValue("SELECT count(cache_id) FROM caches WHERE `caches`.`status` = '5' AND `caches`.`user_id`= :1 ", 0, $user_id); tpl_set_var('notpublishedN', $rnpn); $rapn = XDb::xMultiVariableQueryValue("SELECT count(cache_id) FROM caches WHERE `caches`.`status` = '4' AND `caches`.`user_id`= :1", 0, $user_id); tpl_set_var('approvalN', $rapn); $rbln = XDb::xMultiVariableQueryValue("SELECT count(cache_id) FROM caches WHERE `caches`.`status` = '6' AND `caches`.`user_id`=:1", 0, $user_id); tpl_set_var('blockedN', $rbln); $LOGS_PER_PAGE = 50; $PAGES_LISTED = 10; $total_logs = XDb::xMultiVariableQueryValue("SELECT count(cache_id) FROM caches WHERE `caches`.`status` = :1 AND `caches`.`user_id`= :2 ", 0, $stat_cache, $user_id); $pages = ""; $total_pages = ceil($total_logs / $LOGS_PER_PAGE); if (!isset($_GET['start']) || intval($_GET['start']) < 0 || intval($_GET['start']) > $total_logs) { $start = 0; } else { $start = intval($_GET['start']); } // obsluga sortowania kolumn if (!isset($_GET['col']) || intval($_GET['col']) < 1 || intval($_GET['col']) > 7) { $sort_col = 1; } else { $sort_col = intval($_GET['col']); } if (!isset($_GET['sort']) || intval($_GET['sort']) < 0 || intval($_GET['sort']) > 1) { $sort_sort = 2;
// send email to RR $emailheaders = "Content-Type: text/plain; charset=utf-8\r\n"; $emailheaders .= "From: " . $site_name . " <" . $cache_reporter['email'] . ">\r\n"; $emailheaders .= "Reply-To: " . $site_name . " <" . $cache_reporter['email'] . ">"; mb_send_mail($octeam_email, tr('reportcache07') . " (" . $cache['wp_oc'] . ")", $email_content, $emailheaders); // echo($octeam_email. tr('reportcache07'). $email_content. $emailheaders); } else { $tplname = 'reportcache_sent_owner'; } //get email address of cache owner if ($_POST['adresat'] == "rr") { $email_content = file_get_contents($stylepath . '/email/newreport_cacheowner.email'); } else { $email_content = file_get_contents($stylepath . '/email/newreport_cacheowneronly.email'); } $cache_owner = XDb::xMultiVariableQueryValue("SELECT `email` FROM `user` WHERE `user_id`=:1", '', $cache['user_id']); $email_content = mb_ereg_replace('{server}', $absolute_server_URI, $email_content); $email_content = mb_ereg_replace('{reportcache10}', tr('reportcache10'), $email_content); $email_content = mb_ereg_replace('{reportcache11}', tr('reportcache11'), $email_content); $email_content = mb_ereg_replace('{reportcache12}', tr('reportcache12'), $email_content); $email_content = mb_ereg_replace('{reportcache15}', tr('reportcache15'), $email_content); $email_content = mb_ereg_replace('{reportcache17}', tr('reportcache17'), $email_content); $email_content = mb_ereg_replace('{reportcache18}', tr('reportcache18'), $email_content); $email_content = mb_ereg_replace('{reportcache19}', tr('reportcache19'), $email_content); $email_content = mb_ereg_replace('{octeamEmailsSignature}', $octeamEmailsSignature, $email_content); $email_content = mb_ereg_replace('{date}', date($datetimeFormat), $email_content); $email_content = mb_ereg_replace('{submitter}', $usr['username'], $email_content); $email_content = mb_ereg_replace('{cachename}', $cache['name'], $email_content); $email_content = mb_ereg_replace('{cache_wp}', $cache['wp_oc'], $email_content); $email_content = mb_ereg_replace('{cacheid}', $cacheid, $email_content); $email_content = mb_ereg_replace('{reason}', reason($_POST['reason']), $email_content);
if (!isset($_SESSION['user_id'])) { print 'no hacking please!'; exit; } $ptAPI = new powerTrailBase(); if (isset($_REQUEST['rcalcAll'])) { recalculateOnce(); print '<br><br><b>cachePoints were updated</b>'; exit; } isset($_REQUEST['projectId']) ? $projectId = $_REQUEST['projectId'] : exit; isset($_REQUEST['cacheId']) ? $cacheId = (int) $_REQUEST['cacheId'] : exit; isset($_REQUEST['rmOtherUserCacheFromPt']) ? $rmOtherUserCacheFromPt = true : ($rmOtherUserCacheFromPt = false); $db = OcDb::instance(); // check if cache is already cannected with any power trail $resultPowerTrailId['PowerTrailId'] = XDb::xMultiVariableQueryValue('SELECT `PowerTrailId` FROM `powerTrail_caches` WHERE `cacheId` = :1', false, $cacheId); if (isset($_REQUEST['removeByCOG']) && $_SESSION['ptRmByCog'] === 1) { removeCacheFromPowerTrail($cacheId, $resultPowerTrailId, $db, $ptAPI); recalculate($resultPowerTrailId['PowerTrailId']); print 'removedByCOG'; exit; } if (isset($resultPowerTrailId['PowerTrailId']) && $resultPowerTrailId['PowerTrailId'] != 0) { $geocacheIsAttaschedToPt = true; } else { $geocacheIsAttaschedToPt = false; } if ($rmOtherUserCacheFromPt === true) { if ($geocacheIsAttaschedToPt === true) { removeCacheFromPowerTrail($cacheId, $resultPowerTrailId, $db, $ptAPI); recalculate($resultPowerTrailId['PowerTrailId']);
} $tplname = 'ustat'; if ($user_id != $usr['userid']) { // do not highlight My stats menu item if browsing other users stats $mnu_siteid = 'start'; } $stat_menu = array('title' => 'Statictics', 'menustring' => 'Statistics', 'siteid' => 'statlisting', 'visible' => false, 'filename' => 'ustatsg2.php?userid=' . $user_id, 'submenu' => array(array('title' => tr('generla_stat'), 'menustring' => tr('general_stat'), 'visible' => true, 'filename' => 'viewprofile.php?userid=' . $user_id, 'newwindow' => false, 'siteid' => 'general_stat', 'icon' => 'images/actions/stat'), array('title' => tr('graph_created'), 'menustring' => tr('graph_created'), 'visible' => true, 'filename' => 'ustatsg1.php?userid=' . $user_id, 'newwindow' => false, 'siteid' => 'createstat', 'icon' => 'images/actions/stat'))); $content = ""; $rsGeneralStat = XDb::xSql("SELECT hidden_count, founds_count, log_notes_count, notfounds_count, username\n FROM `user` WHERE user_id= ? LIMIT 1", $user_id); $user_record = XDb::xFetchArray($rsGeneralStat); tpl_set_var('username', $user_record['username']); if ($user_record['founds_count'] == 0) { $content .= '<p> </p><p> </p><div class="content2-container bg-blue02"><p class="content-title-noshade-size1"> <img src="tpl/stdstyle/images/blue/logs.png" class="icon32" alt="Caches Find" title="Caches Find" /> ' . tr("graph_find") . '</p></div><br /><br /><p> <b>' . tr("there_is_no_caches_found") . '</b></p>'; } else { // calculate diif days between date of register on OC to current date $ddays = XDb::xMultiVariableQueryValue("SELECT TO_DAYS( NOW() ) - TO_DAYS(`date_created`) `diff` FROM `user` WHERE user_id= :1 LIMIT 1 ", 0, $user_id); $rsGeneralStat = XDb::xSql("SELECT YEAR(`date_created`) usertime,hidden_count, founds_count, log_notes_count, username\n FROM `user` WHERE user_id= ? LIMIT 1", $user_id); if ($rsGeneralStat !== false) { $user_record = XDb::xFetchArray($rsGeneralStat); XDb::xFreeResults($rsGeneralStat); tpl_set_var('username', $user_record['username']); } $content .= '<p> </p><p> </p><div class="content2-container bg-blue02"><p class="content-title-noshade-size1"> <img src="tpl/stdstyle/images/blue/logs.png" class="icon32" alt="Caches Find" title="Caches Find" /> ' . tr("graph_find") . '</p></div><br />'; $content .= '<p><img src="graphs/PieGraphustat.php?userid=' . $user_id . '&t=cf" border="0" alt="" width="500" height="300" /></p>'; $year = date("Y"); $content .= '<p><img src="graphs/BarGraphustat.php?userid=' . $user_id . '&t=cfm' . $year . '" border="0" alt="" width="500" height="200" /></p>'; if ($user_record['usertime'] != $year) { $yearr = $year - 1; $content .= '<p><img src="graphs/BarGraphustat.php?userid=' . $user_id . '&t=cfm' . $yearr . '" border="0" alt="" width="500" height="200" /></p>'; } $content .= '<p><img src="graphs/BarGraphustat.php?userid=' . $user_id . '&t=cfy" border="0" alt="" width="500" height="200" /></p>';
<?php use Utils\Database\XDb; //prepare the templates and include all neccessary require_once './lib/common.inc.php'; //Preprocessing if ($error == false) { $cache_id = isset($_REQUEST['cacheid']) ? $_REQUEST['cacheid'] : ''; $target = isset($_REQUEST['target']) ? $_REQUEST['target'] : 'mywatches.php'; if ($usr !== false) { //add to caches $geocacheExist = XDb::xMultiVariableQueryValue('SELECT user_id FROM caches WHERE cache_id= :1', -1, $cache_id); if ($geocacheExist > -1) { // (check if user is not curently watching specified cache) $isWatched = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM `cache_watches` WHERE `cache_id` = :1 AND `user_id` = :2", 1, $cache_id, $usr['userid']); // if so proceed to add to database if ($isWatched < 1) { // increase this cache watchers count XDb::xSql('UPDATE caches SET watcher=watcher+1 WHERE cache_id= ? ', $cache_id); //add watch XDb::xSql('INSERT INTO `cache_watches` (`cache_id`, `user_id`, `last_executed`) VALUES (?, ?, NOW())', $cache_id, $usr['userid']); //add to user XDb::xSql('UPDATE user SET cache_watches=cache_watches+1 WHERE user_id= ? ', $usr['userid']); } tpl_redirect($target); } } } tpl_BuildTemplate();
?> <table class="table" width="760" style="line-height: 1.6em; font-size: 10px;"> <tr><td> <?php global $lang, $rootpath; if (!isset($rootpath)) { $rootpath = './'; } //include template handling require_once $rootpath . 'lib/common.inc.php'; if (isset($_REQUEST['region'])) { $region = $_REQUEST['region']; } echo '<table width="97%"><tr><td align="center"><center><b> ' . tr('ranking_by_number_of_created_caches') . ' </b><br />tylko aktywne skrzynki<br />'; $woj = XDb::xMultiVariableQueryValue("SELECT nuts_codes.name FROM nuts_codes WHERE code= :1 ", 0, $region); echo '<br /><b><font color="blue">' . $woj . '</font></b></center></td></tr></table>'; echo '<table border="1" bgcolor="white" width="97%">' . "\n"; $wyniki = XDb::xSql("SELECT count(*) count, user.username nick,caches.user_id userid\n FROM caches\n JOIN user USING(user_id)\n JOIN cache_location USING (cache_id)\n WHERE caches.status=1 AND caches.type<>6\n AND cache_location.code3= ?\n GROUP BY caches.user_id\n ORDER by count DESC, user.username ASC", $region); $licznik = 0; $wartosc = 0; echo '<tr class="bgcolor2"><td align="right"> <b>' . tr('ranking') . '</b> </td><td align="center"> <b>' . tr('number_of_caches') . '</b> </td><td align="center"> <b>' . tr('username') . '</b> </td></tr>'; echo '<tr><td height="2"></td></tr>'; while ($wynik = XDb::xFetchArray($wyniki)) { if ($wartosc == 0) { $wartosc = $wynik['count']; $licznik = 1; echo "<tr class='bgcolor2'><td align='right'> <b>{$licznik}</b> </td><td align='right'> <b>" . $wynik['count'] . "</b> </td><td><a href='viewprofile.php?userid=" . $wynik['userid'] . "'>" . htmlspecialchars($wynik['nick']) . "</a>"; } else { if ($wartosc == $wynik['count']) { echo ', <a href="viewprofile.php?userid=' . $wynik['userid'] . '">' . htmlspecialchars($wynik['nick']) . '</a>';
<?php use Utils\Database\XDb; //prepare the templates and include all neccessary require_once './lib/common.inc.php'; if ($usr['admin']) { $_SESSION['submitted'] = false; $cachename = XDb::xMultiVariableQueryValue("SELECT name FROM caches WHERE cache_id= :1 ", 0, $_REQUEST['cacheid']); tpl_set_var('cachename', $cachename); tpl_set_var('cacheid', $_REQUEST['cacheid']); $tplname = 'add_rr_comment'; tpl_BuildTemplate(); }
//wp-type $type_not_ok = false; if ($sel_type == -1) { tpl_set_var('type_message', $typewp_not_ok_message); $error = true; $type_not_ok = true; } //no errors? if (!($descwp_not_ok || $lon_not_ok || $lat_not_ok || $type_not_ok)) { //add record XDb::xSql("INSERT INTO `waypoints` (\n `wp_id`, `cache_id`,`longitude`,`latitude`,`type` ,\n `status` ,`stage` ,`desc` ,`opensprawdzacz`)\n VALUES ('', ?, ?, ?, ?, ?, ?, ?, ?)", $cache_id, $longitude, $latitude, $sel_type, $wp_status, $wp_stage, $wp_desc, $opensprawdzacz_taknie); XDb::xSql("UPDATE `caches` SET `last_modified`=NOW() WHERE `cache_id`= ? ", $cache_id); // ==== opensprawdzacz =============================================== // add/update active status to/in opensprawdzacz table if ($opensprawdzacz_taknie == 1 && $sel_type == 3) { $proba = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM `opensprawdzacz` WHERE `cache_id` = :1 ", 0, $cache_id); if ($proba == 0) { XDb::xSql("INSERT INTO `opensprawdzacz`(`id`, `cache_id`, `proby`, `sukcesy`)\n VALUES ('', '{$cache_id}', 0, 0)"); } } // ==== opensprawdzacz end =========================================== tpl_redirect('editcache.php?cacheid=' . urlencode($cache_id)); } else { tpl_set_var('general_message', $error_general); } // end submit } XDb::xFreeResults($cache_rs); XDb::xFreeResults($wp_rs); } else { $no_tpl_build = true;
/** * This function is moved from clicompatbase * @param unknown $cacheid */ public static function setCacheDefaultDescLang($cacheid) { $r['desc_languages'] = XDb::xMultiVariableQueryValue("SELECT `desc_languages` FROM `caches`\n WHERE `cache_id`= :1 LIMIT 1", null, $cacheid); if (mb_strpos($r['desc_languages'], 'PL') !== false) { $desclang = 'PL'; } else { if (mb_strpos($r['desc_languages'], 'EN') !== false) { $desclang = 'EN'; } else { if ($r['desc_languages'] == '') { $desclang = ''; } else { $desclang = mb_substr($r['desc_languages'], 0, 2); } } } XDb::xSql("UPDATE `caches` SET\n `default_desclang`= ?, `last_modified`=NOW()\n WHERE cache_id= ? LIMIT 1", $desclang, $cacheid); }
$allok = false; } } if ($allok == true) { //ok, wir haben eine gĂźltige uuid und sind der owner ... $fna = mb_split('\\.', $url); $extension = mb_strtolower($fna[count($fna) - 1]); // datei und in DB lĂśschen @unlink($picdir . '/' . $uuid . '.' . $extension); XDb::xSql("DELETE FROM `pictures` WHERE `uuid`= ? LIMIT 1", $uuid); XDb::xSql("INSERT INTO `removed_objects` (`localID`, `uuid`, `type`, `removed_date`, `node`)\n VALUES (?, ?, 6, NOW(), ?)", $localid, $uuid, $oc_nodeid); switch ($type) { // log case 1: XDb::xSql("UPDATE `cache_logs` SET `picturescount`=`picturescount`-1, `last_modified`=NOW()\n WHERE `id`= ? LIMIT 1", $objectid); $r['cache_id'] = XDb::xMultiVariableQueryValue("SELECT `cache_id` FROM `cache_logs`\n WHERE `deleted`=0 AND `id`= :1 LIMIT 1", 0, $objectid); tpl_redirect('viewlogs.php?cacheid=' . urlencode($r['cache_id'])); break; // cache // cache case 2: XDb::xSql("UPDATE `caches` SET `picturescount`=`picturescount`-1, `last_modified`=NOW()\n WHERE `cache_id`= ? LIMIT 1", $objectid); tpl_redirect('editcache.php?cacheid=' . urlencode($objectid)); break; } tpl_redirect('index.php'); exit; } else { $tplname = 'message'; tpl_set_var('messagetitle', $message_title_internal); tpl_set_var('message_start', '');
require_once './lib/common.inc.php'; $message = false; //Preprocessing if ($error == false) { //user logged in? if ($usr == false) { $target = urlencode(tpl_get_current_page()); tpl_redirect('login.php?target=' . $target); } else { $tplname = 'editpic'; require_once $stylepath . '/editpic.inc.php'; $uuid = isset($_REQUEST['uuid']) ? $_REQUEST['uuid'] : 0; if (!$uuid) { $message = $message_picture_not_found; } $owner = XDb::xMultiVariableQueryValue("SELECT `user_id` FROM `pictures` WHERE `uuid`= :1 LIMIT 1", 0, $uuid); if ($usr['admin'] || $owner == $usr['userid']) { if (!$message) { $rs = XDb::xSql("SELECT `pictures`.`spoiler`, `pictures`.`display`, `pictures`.`title`, `pictures`.`object_id`,\n `pictures`.`object_type`, `caches`.`name`, `caches`.`cache_id`\n FROM `pictures`, `caches`\n WHERE `caches`.`cache_id`=`pictures`.`object_id` AND `pictures`.`uuid`= ? AND `pictures`.`user_id`= ? LIMIT 1", $uuid, $owner); if (!($row = XDb::xFetchArray($rs))) { $message = $message_picture_not_found; } } } if (!$message) { if (isset($_POST['submit'])) { if ($_FILES['file']['name'] != '') { // check if the file has been uploaded successfully if ($_FILES['file']['error'] != 0) { // oops ... no idea what I should do now $tplname = 'message';
if ($allok == true) { //check if object exists and we are the owner (allowed to upload a pic) switch ($type) { // log case 1: $rs = XDb::xSql("SELECT `user_id`, `cache_id` FROM `cache_logs` WHERE `deleted`=0 AND `id`= ?", $objectid); if (!($r = XDb::xFetchArray($rs))) { $allok = false; } else { if ($r['user_id'] != $usr['userid'] && $usr['admin'] == false) { $allok = false; } $cacheid = $r['cache_id']; tpl_set_var('cacheid', $cacheid); tpl_set_var('pictypedesc', $pictypedesc_log); $rCache['name'] = XDb::xMultiVariableQueryValue("SELECT `name` FROM `caches` WHERE `cache_id`= :1 LIMIT 1", '', $cacheid); tpl_set_var('cachename', htmlspecialchars($rCache['name'], ENT_COMPAT, 'UTF-8')); tpl_set_var('begin_cacheonly', '<!--'); tpl_set_var('end_cacheonly', '-->'); } XDb::xFreeResults($rs); break; // cache // cache case 2: $rs = XDb::xSql("SELECT `user_id`, `cache_id`, `name` FROM `caches` WHERE `cache_id`= ? LIMIT 1", $objectid); if (!($r = XDb::xFetchArray($rs))) { $allok = false; } else { tpl_set_var('cachename', htmlspecialchars($r['name'], ENT_COMPAT, 'UTF-8')); tpl_set_var('cacheid', $r['cache_id']);
<?php use Utils\Database\XDb; use Utils\Database\OcDb; require './lib/common.inc.php'; require $stylepath . '/usertops.inc.php'; if ($error == false) { $userid = isset($_REQUEST['userid']) ? $_REQUEST['userid'] + 0 : 0; $tplname = 'usertops'; $username = XDb::xMultiVariableQueryValue("SELECT `username` FROM `user` WHERE `user_id`= :1 LIMIT 1", null, $userid); if (!is_null($username)) { // user found tpl_set_var('userid', $userid); tpl_set_var('username', $username); } else { // user not found tpl_set_var('userid', 0); tpl_set_var('username', '-Not Found-'); $userid = 0; $username = "******"; $notop5 = $user_notfound; } $i = 0; $content = ''; $dbc = OcDb::instance(); $s = $dbc->multiVariableQuery("SELECT `cache_rating`.`cache_id` AS `cache_id`, `caches`.`name` AS `cachename`,\n `user`.`username` AS `ownername`, `user`.`user_id` AS `owner_id`\n FROM `cache_rating`, `caches`, `user`\n WHERE `cache_rating`.`cache_id` = `caches`.`cache_id`\n AND `caches`.`user_id`=`user`.`user_id`\n AND `cache_rating`.`user_id`= :1 ORDER BY `caches`.`name` ASC", $userid); if ($dbc->rowCount($s) != 0) { while ($r = $dbc->dbResultFetch($s)) { $thisline = $viewtop5_line; $thisline = mb_ereg_replace('{cachename}', htmlspecialchars($r['cachename'], ENT_COMPAT, 'UTF-8'), $thisline); $thisline = mb_ereg_replace('{cacheid}', htmlspecialchars($r['cache_id'], ENT_COMPAT, 'UTF-8'), $thisline);
function notifyOwner($cacheid, $msgType) { // msgType - 0 = cache accepted, 1 = cache declined (=archived) global $stylepath, $usr, $octeam_email, $site_name, $absolute_server_URI, $octeamEmailsSignature; $user_id = getCacheOwnerId($cacheid); $cachename = getCachename($cacheid); if ($msgType == 0) { $email_content = file_get_contents($stylepath . '/email/activated_cache.email'); } else { $email_content = file_get_contents($stylepath . '/email/archived_cache.email'); } $email_headers = "Content-Type: text/plain; charset=utf-8\r\n"; $email_headers .= "From: {$site_name} <{$octeam_email}>\r\n"; $email_headers .= "Reply-To: {$octeam_email}\r\n"; $email_content = mb_ereg_replace('{server}', $absolute_server_URI, $email_content); $email_content = mb_ereg_replace('{cachename}', $cachename, $email_content); $email_content = mb_ereg_replace('{cacheid}', $cacheid, $email_content); $email_content = mb_ereg_replace('{octeamEmailsSignature}', $octeamEmailsSignature, $email_content); $email_content = mb_ereg_replace('{cacheArchived_01}', tr('cacheArchived_01'), $email_content); $email_content = mb_ereg_replace('{cacheArchived_02}', tr('cacheArchived_02'), $email_content); $email_content = mb_ereg_replace('{cacheArchived_03}', tr('cacheArchived_03'), $email_content); $email_content = mb_ereg_replace('{cacheArchived_04}', tr('cacheArchived_04'), $email_content); $email_content = mb_ereg_replace('{cacheArchived_05}', tr('cacheArchived_05'), $email_content); $email_content = mb_ereg_replace('{Cacheactivated_01}', tr('Cacheactivated_01'), $email_content); $email_content = mb_ereg_replace('{Cacheactivated_02}', tr('Cacheactivated_02'), $email_content); $email_content = mb_ereg_replace('{Cacheactivated_03}', tr('Cacheactivated_03'), $email_content); $email_content = mb_ereg_replace('{Cacheactivated_04}', tr('Cacheactivated_04'), $email_content); $email_content = mb_ereg_replace('{Cacheactivated_05}', tr('Cacheactivated_05'), $email_content); $owner_email = XDb::xMultiVariableQueryValue("SELECT `email` FROM `user` WHERE `user_id`= :1 LIMIT 1", '', $user_id); if ($msgType == 0) { //send email to owner mb_send_mail($owner_email['email'], tr('viewPending_01') . ": " . $cachename, $email_content, $email_headers); //send email to approver mb_send_mail($usr['email'], tr('viewPending_01') . ": " . $cachename, tr('viewPending_02') . ":\n" . $email_content, $email_headers); // generate automatic log about status cache $log_text = tr("viewPending_03"); $log_uuid = create_uuid(); XDb::xSql("INSERT INTO `cache_logs`\n (`id`, `cache_id`, `user_id`, `type`, `date`, `text`, `text_html`, `text_htmledit`, `date_created`, `last_modified`, `uuid`, `node`,`encrypt`)\n VALUES ('', ?, ?, '12', NOW(), ?, '0', '0', NOW(), NOW(), ?, '2', '0')", $cacheid, $usr['userid'], $log_text, $log_uuid); } else { //send email to owner mb_send_mail($owner_email['email'], tr('viewPending_04') . ": " . $cachename, $email_content, $email_headers); //send email to approver mb_send_mail($usr['email'], tr('viewPending_04') . ": " . $cachename, tr('viewPending_05') . ":\n" . $email_content, $email_headers); // generate automatic log about status cache $log_text = tr("viewPending_06"); $log_uuid = create_uuid(); XDb::xSql("INSERT INTO `cache_logs`\n (`id`, `cache_id`, `user_id`, `type`, `date`, `text`, `text_html`, `text_htmledit`, `date_created`, `last_modified`, `uuid`, `node`,`encrypt`)\n VALUES ('', ?, ?, ?, NOW(), ?, ?, ?, NOW(), NOW(), ?, ?, ?)", $cacheid, $usr['userid'], 12, $log_text, 0, 0, $log_uuid, 2, 0); } }
function user_id2uuid($id) { XDb::xMultiVariableQueryValue('SELECT uuid FROM user WHERE user_id= :1 LIMIT 1', $id); }
// Y $only_active .= " AND caches.status = 2"; } } } $result = XDb::xSql("SELECT caches.cache_id, caches.name, user.username, caches.wp_oc as wp, caches.votes, caches.score,\n caches.topratings, caches.latitude, caches.longitude, caches.type, caches.status as status,\n datediff(now(), caches.date_hidden) as old, caches.user_id,\n IF(cache_id IN\n (\n SELECT cache_id\n FROM cache_logs\n WHERE deleted=0 AND user_id= ?\n AND (type=1 OR type=8)\n ), 1, 0\n ) as found\n FROM user, caches\n WHERE (caches.user_id = user.user_id)\n AND caches.latitude > ? AND caches.latitude < ?\n AND caches.longitude > ? AND caches.longitude < ?\n " . XDb::xEscape($only_active) . " " . $filter_by_type_string . "\n ORDER BY " . XDb::xEscape($ORDERBY) . "\n LIMIT " . XDb::xEscape($page) . ", " . XDb::xEscape($PER_PAGE), $user_id, $latSW, $latNE, $lonSW, $lonNE); echo "<?xml version=\"1.0\" encoding=\"" . $ENCODING . "\"?>\n"; echo "<markers>\n"; while ($res = XDb::xFetchArray($result)) { if (!isset($_REQUEST['print_list']) || onTheList($_SESSION['print_list'], $res['cache_id']) == -1) { $druk = "druk=\"y\""; } else { $druk = "druk=\"n\""; } $founds = XDb::xMultiVariableQueryValue("SELECT count(*) FROM cache_logs\n WHERE deleted=0 AND cache_id = :1\n AND (type=1 OR type=8)", 0, $res['cache_id']); $notfounds = XDb::xMultiVariableQueryValue("SELECT count(*) FROM cache_logs\n WHERE deleted=0 AND cache_id = :1 AND type=2", 0, $res['cache_id']); if ($res['votes'] > 2) { $score = $res['score']; } else { $score = ""; } echo "<marker id=\"" . htmlspecialchars($res['cache_id']) . "\" name=\"" . htmlspecialchars($res['name']) . "\" lat=\"" . htmlspecialchars($res['latitude']) . "\" lng=\"" . htmlspecialchars($res['longitude']) . "\" owner=\"" . htmlspecialchars($res['username']) . "\" owner_id=\"" . htmlspecialchars($res['user_id']) . "\" type=\"" . htmlspecialchars(typeLetter($res['type'])) . "\" found=\"" . $res['found'] . "\" old=\"" . htmlspecialchars($res['old']) . "\" score=\"" . htmlspecialchars($score) . "\" topratings=\"" . htmlspecialchars($res['topratings']) . "\" notfounds=\"" . htmlspecialchars($notfounds) . "\" votes=\"" . htmlspecialchars($res['votes']) . "\" founds=\"" . htmlspecialchars($founds) . "\" status=\"" . htmlspecialchars($res['status']) . "\" wp=\"" . htmlspecialchars($res['wp']) . "\" " . $druk . "/>\n"; } $res2['num'] = XDb::xMultiVariableQueryValue("SELECT count(cache_id) as num FROM caches\n WHERE caches.status = 1\n AND caches.latitude > :1\n AND caches.latitude < :2\n AND caches.longitude > :3\n AND caches.longitude < :4 ", 0, $latSW, $latNE, $lonSW, $lonNE); $pages = ''; for ($i = 0; $i < $res2['num'] / $PER_PAGE; $i++) { $pages .= "<a href=\"javascript:load_data(" . $i . ");\">" . ($i + 1) . "</a> "; } $pages = htmlspecialchars($pages); echo "<data count=\"" . $res2['num'] . "\" pager=\"" . $pages . "\" />\n"; echo "</markers>";
if (!isset($rootpath)) { $rootpath = './'; } //include template handling require_once $rootpath . 'lib/common.inc.php'; setlocale(LC_TIME, 'pl_PL.UTF-8'); echo '<table width="97%"><tr><td align="center"><center><b>' . tr('Stats_t5_01') . '</b><br /><br />' . tr('Stats_t5_02') . ': (z% - <b><font color="green">X</font>/<font color="blue">Y</font></b>) X- ' . tr('Stats_t5_03') . ', Y - ' . tr('Stats_t5_04') . ', <br /> z - ' . tr('Stats_t5_05') . ' % ' . tr('Stats_t5_06') . ' (X/Y)*100<br /><br /></center></td></tr> </table>'; echo '<table border="1" bgcolor="white" width="97%" style="font-size:11px; line-height:1.6em;">' . "\n"; $linie = XDb::xSql("SELECT count(*) count, user.username username, user.user_id user_id\n FROM caches, cache_rating, user\n WHERE `cache_rating`.`cache_id`=caches.cache_id\n AND caches.user_id=user.user_id\n AND caches.type <> 6\n GROUP BY `user`.`user_id`\n ORDER BY `count` DESC, `user`.`username` ASC"); echo '<tr><td class="bgcolor2" align="right"><b>' . tr('Stats_t5_07') . '</b> </td><td class="bgcolor2" align="center"><img src="images/rating-star.png" border="0" alt="Recommendations" /> <b>' . tr('Stats_t5_08') . '</b> </td><td class="bgcolor2" align="center"><b>' . tr('Stats_t5_09') . '</b> </td></tr><tr><td>'; $l2 = ""; $licznik = 0; while ($linia = XDb::xFetchArray($linie)) { $l1 = $linia['count']; $x = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM caches\n WHERE `caches`.`topratings` >= 1\n AND caches.type <> 6\n AND caches.user_id= :1 ", 0, $linia['user_id']); $y = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM caches\n WHERE user_id= :1\n AND status <> 4 AND status <> 5\n AND status <> 6 AND type <> 6", 0, $linia['user_id']); if ($y != 0) { $xy = sprintf("%.u", $x / $y * 100); } else { $xy = 0; } if ($l2 != $l1) { $licznik++; echo "</td></tr><tr><td class=\"bgcolor2\" align=\"right\"> <b>{$licznik}</b> </td><td class=\"bgcolor2\" align=\"right\"> <b>{$l1}</b> </td>"; echo "<td class=\"bgcolor2\"><a class=\"links\" href=\"viewprofile.php?userid=" . $linia['user_id'] . "\">" . htmlspecialchars($linia['username']) . " (<font color=\"firebrick\">{$xy}% - </font><font color=\"green\">{$x}</font>/<font color=\"blue\">{$y}</font>)</a>"; $l2 = $l1; } else { echo ", <a class=\"links\" href=\"viewprofile.php?userid=" . $linia['user_id'] . "\">" . htmlspecialchars($linia['username']) . " (<font color=\"firebrick\">{$xy}% - </font><font color=\"green\">{$x}</font>/<font color=\"blue\">{$y}</font>)</a>"; } } echo '</td></tr></table>' . "\n";
use Utils\Database\XDb; // Unicode Reminder ?? setlocale(LC_TIME, 'pl_PL.UTF-8'); //setlocale(LC_TIME, 'pl_PL.ISO-8859-2'); //prepare the templates and include all neccessary require_once './lib/common.inc.php'; global $dynbasepath; // Parameter $jpeg_qualitaet = 80; $fontfile = "./lib/fonts/arial.ttf"; # get userid and style from URL $userid = isset($_REQUEST['userid']) ? $_REQUEST['userid'] : 0; // nie licz spotkan, skrzynek jeszcze nieaktywnych, zarchiwizowanych i wstrzymanych $hidden = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM caches\n WHERE user_id= :1 AND status <> 2 AND status <> 3 AND status <> 4\n AND status <> 5 AND status <> 6 AND type <> 6", 0, $userid); $found = XDb::xMultiVariableQueryValue("SELECT COUNT(*) founds_count FROM cache_logs\n WHERE user_id= :1 AND type=1 AND deleted=0", 0, $userid); # get detailed info from DB $rs = XDb::xSql("SELECT `username`, `statpic_logo`, `statpic_text` FROM `user`\n WHERE `user_id`= ? LIMIT 1", $userid); if ($record = XDb::xFetchArray($rs)) { $username = $record['username']; $logo = isset($record['statpic_logo']) ? $record['statpic_logo'] : 0; $logotext = isset($record['statpic_text']) ? $record['statpic_text'] : 'Opencaching'; } else { $userid = 0; $username = "******"; $logo = 0; $logotext = 'Opencaching'; } XDb::xFreeResults($rs); $userid = $userid + 0; if (!file_exists($dynbasepath . 'images/statpics/statpic' . $userid . '.jpg')) {
//crypt the log ROT13, but keep HTML-Tags and Entities $data_text = str_rot13_html($data_text); } else { $logtext .= "<br/>"; } $logtext .= $data_text; $tmp_log = mb_ereg_replace('{logtext}', $logtext, $tmp_log); $content .= "\n" . $tmp_log; } XDb::xFreeResults($rs_logs); $content .= '</ul></div><br />'; } } // ----------------- begin owner section ---------------------------------- if ($user_id == $usr['userid'] || $usr['admin']) { $rscheck = XDb::xMultiVariableQueryValue("SELECT count(*) FROM caches\n WHERE (status = 4 OR status = 5 OR status = 6) AND `user_id`= :1", 0, $user_id); if ($rscheck != 0) { $content .= '<br /><div class="content-title-noshade box-blue">'; } //get not published caches DATE_FORMAT(`caches`.`date_activate`,'%d-%m-%Y'), $geocachesNotPublished = $user->getGeocachesNotPublished(); if ($geocachesNotPublished->count() > 0) { $content .= '<p><span class="content-title-noshade txt-blue08">' . tr('not_yet_published') . ':</span></p><br /><div><ul style="margin: -0.9em 0px 0.9em 0px; padding: 0px 0px 0px 10px; list-style-type: none; line-height: 1.2em; font-size: 115%;">'; foreach ($geocachesNotPublished as $geocache) { $content .= "\n" . buildGeocacheHtml($geocache, $cache_notpublished_line); } $content .= '</ul></div>'; } $waitAproveGeocaches = $user->getGeocachesWaitAproove(); if ($waitAproveGeocaches->count() > 0) { $content .= '<br /><p><span class="content-title-noshade txt-blue08">' . tr('caches_waiting_approve') . ':</span></p><br /><div><ul style="margin: -0.9em 0px 0.9em 0px; padding: 0px 0px 0px 10px; list-style-type: none; line-height: 1.2em; font-size: 115%;">';
require_once $rootpath . 'okapi/facade.php'; \okapi\Facade::schedule_user_entries_check($log_record['cache_id'], $log_record['user_id']); \okapi\Facade::disable_error_handling(); //Update last found $lastFoundDate = XDb::xMultiVariableQueryValue("SELECT MAX(`date`) AS `date` FROM `cache_logs`\n WHERE `type` = 1 AND `cache_id`= :1 AND deleted = 0", 'NULL', $log_record['cache_id']); XDb::xSql("UPDATE `caches` SET `last_found`=?, `founds`=?, `notfounds`=?, `notes`=? WHERE `cache_id`=?", $lastFoundDate, $cache_record['founds'], $cache_record['notfounds'], $cache_record['notes'], $log_record['cache_id']); unset($cache_record); //display cache page tpl_redirect('viewcache.php?cacheid=' . urlencode($log_record['cache_id'])); exit; } // check if user has already found this cache and is not editing the found log (i.e. is able to change another comment's type to 'found') $already_found_in_other_comment = 0; $founds2 = XDb::xMultiVariableQueryValue("SELECT count(*) as founds FROM `cache_logs`\n WHERE user_id= :1 AND cache_id= :2 AND type='1' AND deleted=0", 0, $usr['userid'], $log_record['cache_id']); if ($founds2 > 0) { $founds3 = XDb::xMultiVariableQueryValue("SELECT count(*) as founds FROM `cache_logs`\n WHERE id= :1 AND type=1 AND deleted=0", 0, $log_id); if ($founds3 == 0) { $already_found_in_other_comment = 1; } } //build logtypeoptions $logtypeoptions = ''; foreach ($log_types as $type) { // skip if permission=O ???? and not owner if ($type['permission'] == 'B' && $log_record['user_id'] != $cache_user_id && $usr['admin'] == false) { continue; } if ($log_record['logtype'] != $type['id'] && $log_record['cachestatus'] != 1) { continue; } if ($log_record['logtype'] != $type['id'] && $log_record['cachestatus'] == 1 && $log_record['user_id'] == $cache_user_id) {
function doesUserExist($username) { return XDb::xMultiVariableQueryValue("SELECT user_id FROM user WHERE username= :1 ", 0, $username); }
$to[] = '- '; $from[] = ']]>'; $to[] = ']] >'; $from[] = ''; $to[] = ''; for ($i = 0; $i < count($from); $i++) { $str = str_replace($from[$i], $to[$i], $str); } return str_replace('[\\x00-\\x09|\\x0A-\\x0E-\\x1F]', '', $str); //filterevilchars } $username = XDb::xMultiVariableQueryValue("SELECT username FROM user WHERE user_id= :1 LIMIT 1", '', $user_id); tpl_set_var('username', $username); $LOGS_PER_PAGE = 50; $PAGES_LISTED = 10; $total_logs = XDb::xMultiVariableQueryValue("SELECT count(id) FROM cache_logs, caches WHERE `cache_logs`.`cache_id`=`caches`.`cache_id`\n AND `cache_logs`.`deleted`=0\n AND `caches`.`status` != 4\n AND `caches`.`status` != 5\n AND `caches`.`status` != 6\n AND `cache_logs`.`user_id`= :1 ", 0, $user_id); $pages = ""; $total_pages = ceil($total_logs / $LOGS_PER_PAGE); if (!isset($_GET['start']) || intval($_GET['start']) < 0 || intval($_GET['start']) > $total_logs) { $start = 0; } else { $start = intval($_GET['start']); } $startat = max(0, floor(($start / $LOGS_PER_PAGE + 1) / $PAGES_LISTED) * $PAGES_LISTED); if ($start / $LOGS_PER_PAGE + 1 >= $PAGES_LISTED) { $pages .= '<a href="my_logs.php?userid=' . $user_id . '&start=' . max(0, ($startat - $PAGES_LISTED - 1) * $LOGS_PER_PAGE) . '">{first_img}</a> '; } else { $pages .= "{first_img_inactive}"; } for ($i = max(1, $startat); $i < min($startat + $PAGES_LISTED, $total_pages + 1); $i++) { $page_number = ($i - 1) * $LOGS_PER_PAGE;
} $cache_uuid = create_uuid(); //add record to caches table XDb::xSql("INSERT INTO `caches` SET\n `cache_id` = '', `user_id` = ?, `name` = ?, `longitude` = ?, `latitude` = ?, `last_modified` = NOW(),\n `date_created` = NOW(), `type` = ?, `status` = ?, `country` = ?, `date_hidden` = ?, `date_activate` = ?,\n `founds` = 0, `notfounds` = 0, `watcher` = 0, `notes` = 0, `last_found` = NULL, `size` = ?, `difficulty` = ?,\n `terrain` = ?, `uuid` = ?, `logpw` = ?, `search_time` = ?, `way_length` = ?, `wp_gc` = ?,\n `wp_nc` = ?, `wp_ge` = ?, `wp_tc` = ?, `node` = ? ", $usr['userid'], $name, $longitude, $latitude, $sel_type, $sel_status, $sel_country, date('Y-m-d', $hidden_date), $activation_date, $sel_size, $difficulty, $terrain, $cache_uuid, $log_pw, $search_time, $way_length, $wp_gc, $wp_nc, $wp_ge, $wp_tc, $oc_nodeid); $cache_id = XDb::xLastInsertId(); // insert cache_location $code1 = $sel_country; $eLang = XDb::xEscape($lang); $adm1 = XDb::xMultiVariableQueryValue("SELECT `countries`.{$eLang} FROM `countries`\n WHERE `countries`.`short`= :1 ", 0, $code1); // 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 = XDb::xMultiVariableQueryValue("SELECT `name` FROM `nuts_codes`\n WHERE `code`= :1 ", 0, $sel_region); } else { $code3 = null; $adm3 = null; } XDb::xSql("INSERT INTO `cache_location` (cache_id,adm1,adm3,code1,code3)\n VALUES ( ?, ?, ?, ?, ?)", $cache_id, $adm1, $adm3, $code1, $code3); // update cache last modified, it is for work of cache_locations update information XDb::xSql("UPDATE `caches` SET `last_modified`=NOW() WHERE `cache_id`= ? ", $cache_id); // waypoint erstellen setCacheWaypoint($cache_id, $oc_waypoint); $desc_uuid = create_uuid(); //add record to cache_desc table $desc = userInputFilter::purifyHtmlString($desc); $db->multiVariableQuery("INSERT INTO `cache_desc` (\n `cache_id`, `language`, `desc`, `hint`,\n `short_desc`, `last_modified`, `uuid`, `node` )\n VALUES (:1, :2, :3, :4, :5, NOW(), :6, :7)", $cache_id, $sel_lang, $desc, nl2br(htmlspecialchars($hints, ENT_COMPAT, 'UTF-8')), $short_desc, $desc_uuid, $oc_nodeid); GeoCache::setCacheDefaultDescLang($cache_id); // insert cache-attributes
function getUsername($userid) { return XDb::xMultiVariableQueryValue("SELECT username FROM user WHERE user_id= :1 ", null, $userid); }
$access_log[$cache_id] = true; $_SESSION['CACHE_ACCESS_LOG_GPX_' . $user_id] = $access_log; } } $thisline = $gpxLine; $lat = sprintf('%01.5f', $r['latitude']); $thisline = str_replace('{lat}', $lat, $thisline); $lon = sprintf('%01.5f', $r['longitude']); $thisline = str_replace('{lon}', $lon, $thisline); $time = date($gpxTimeFormat, strtotime($r['date_hidden'])); $thisline = str_replace('{{time}}', $time, $thisline); $thisline = str_replace('{{waypoint}}', $r['waypoint'], $thisline); $thisline = str_replace('{cacheid}', $r['cacheid'], $thisline); $thisline = str_replace('{cachename}', cleanup_text($r['name']), $thisline); $thisline = str_replace('{country}', tr($r['country']), $thisline); $region = XDb::xMultiVariableQueryValue("SELECT `adm3` FROM `cache_location` WHERE `cache_id`= :1 LIMIT 1", 0, $r['cacheid']); $thisline = str_replace('{region}', $region, $thisline); // modified coords if ($r['cache_mod_cords_id'] > 0) { // check if we have user coords $thisline = str_replace('{mod_suffix}', '(F)', $thisline); } else { $thisline = str_replace('{mod_suffix}', '', $thisline); } if ($r['hint'] == '') { $thisline = str_replace('{hints}', '', $thisline); } else { $thisline = str_replace('{hints}', cleanup_text($r['hint']), $thisline); } $logpw = $r['logpw'] == "" ? "" : "" . tr('search_gpxgc_01') . " <br />"; $thisline = str_replace('{shortdesc}', cleanup_text($r['short_desc']), $thisline);
myText.value = myText.value.substr(0, start) + parSmiley + selText + myText.value.substr(end); /* Cursorposition hinter Smiley setzen */ myText.selectionStart = start + parSmiley.length; myText.selectionEnd = start + parSmiley.length; } /* fuer die anderen Browser */ else { alert(navigator.appName + ': Setting smilies is not supported'); } } function _chkFound() { <?php $founds = XDb::xMultiVariableQueryValue("SELECT count(cache_id)\n FROM cache_logs\n WHERE `deleted`=0\n AND cache_id = :1\n AND user_id = :2\n AND type='1'", 0, $_REQUEST['cacheid'], $usr['userid']); ?> if (document.logform.logtype.value == "1" || (<?php echo $founds; ?> > 0 && document.logform.logtype.value == "3") || document.logform.logtype.value == "7") { document.logform.r.disabled = false; //document.logform.rating.disabled = false; } else { document.logform.r.disabled = false; //document.logform.rating.disabled = true; }
function user_id2uuid($id) { return XDb::xMultiVariableQueryValue("SELECT `uuid` FROM `user` WHERE `user_id`= :1 LIMIT 1", '', $id); }