PHP XDb::xMultiVariableQueryValue方法代码示例

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>&nbsp;</p><p>&nbsp;</p><div class="content2-container bg-blue02"><p class="content-title-noshade-size1">&nbsp;<img src="tpl/stdstyle/images/blue/logs.png" class="icon32" alt="Caches Find" title="Caches Find" />&nbsp;&nbsp;&nbsp;' . 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>&nbsp;</p><p>&nbsp;</p><div class="content2-container bg-blue02"><p class="content-title-noshade-size1">&nbsp;<img src="tpl/stdstyle/images/blue/logs.png" class="icon32" alt="Caches Find" title="Caches Find" />&nbsp;&nbsp;&nbsp;' . tr("graph_find") . '</p></div><br />';
     $content .= '<p><img src="graphs/PieGraphustat.php?userid=' . $user_id . '&amp;t=cf"  border="0" alt="" width="500" height="300" /></p>';
     $year = date("Y");
     $content .= '<p><img src="graphs/BarGraphustat.php?userid=' . $user_id . '&amp;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 . '&amp;t=cfm' . $yearr . '"  border="0" alt="" width="500" height="200" /></p>';
     }
     $content .= '<p><img src="graphs/BarGraphustat.php?userid=' . $user_id . '&amp;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">&nbsp;&nbsp;<b>' . tr('ranking') . '</b>&nbsp;&nbsp;</td><td align="center">&nbsp;&nbsp;<b>' . tr('number_of_caches') . '</b>&nbsp;&nbsp;</td><td align="center">&nbsp;&nbsp;<b>' . tr('username') . '</b>&nbsp;&nbsp;</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'>&nbsp;&nbsp;<b>{$licznik}</b>&nbsp;&nbsp;</td><td align='right'>&nbsp;&nbsp;<b>" . $wynik['count'] . "</b>&nbsp;&nbsp;</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']);