$tpl->assign('oconly_found', $oconly_found); $tpl->assign('oconly_dnf', $oconly_dnf); $tpl->assign('oconly_note', $oconly_note); $tpl->assign('oconly_maint', $oconly_maint); // OConly detail statistics if ($show_statistics) { $rs = sql("SELECT COUNT(*) AS `anzahl`, `t`.`id`, IFNULL(`tt`.`text`, `t`.`name`) AS `cachetype`\n\t\t\t FROM `caches` AS `c`\n\t\t\t LEFT JOIN `cache_type` AS `t` ON `t`.`id`=`c`.`type`\n\t\t\t LEFT JOIN `sys_trans` AS `st` ON `st`.`id`=`t`.`trans_id` AND `t`.`name`=`st`.`text`\n\t\t\t LEFT JOIN `sys_trans_text` AS `tt` ON `st`.`id`=`tt`.`trans_id` AND `tt`.`lang`='&2'\n\t\t\t LEFT JOIN `cache_status` ON `cache_status`.`id`=`c`.`status`\n\t\t\t INNER JOIN `caches_attributes` ON `caches_attributes`.`cache_id`=`c`.`cache_id` AND `caches_attributes`.`attrib_id`=6\n\t\t\t WHERE `c`.`user_id`='&1' AND `allow_user_view`='1'\n\t\t\t GROUP BY `t`.`id`\n\t\t\t ORDER BY `anzahl` DESC, `t`.`ordinal` ASC", $userid, $opt['template']['locale']); $tpl->assign_rs('oconly_userstatshidden', $rs); sql_free_result($rs); $rs = sql("SELECT COUNT(*) AS `anzahl`, `t`.`id`, IFNULL(`tt`.`text`, `t`.`name`) AS `cachetype`\n\t\t\t FROM `cache_logs` AS `l`\n\t\t\t LEFT JOIN `caches` AS `c` ON `l`.`cache_id`=`c`.`cache_id`\n\t\t\t LEFT JOIN `cache_type` AS `t` ON `t`.`id`=`c`.`type`\n\t\t\t LEFT JOIN `sys_trans` AS `st` ON `st`.`id`=`t`.`trans_id` AND `t`.`name`=`st`.`text`\n\t\t\t LEFT JOIN `sys_trans_text` AS `tt` ON `st`.`id`=`tt`.`trans_id` AND `tt`.`lang`='&2'\n\t\t\t INNER JOIN `caches_attributes` ON `caches_attributes`.`cache_id`=`c`.`cache_id` AND `caches_attributes`.`attrib_id`=6\n\t\t\t WHERE `l`.`user_id`='&1' AND (`l`.`type`=1 OR `l`.`type`=7)\n\t\t\t GROUP BY `t`.`id`\n\t\t\t ORDER BY `anzahl` DESC, `t`.`ordinal` ASC", $userid, $opt['template']['locale']); $tpl->assign_rs('oconly_userstatsfound', $rs); sql_free_result($rs); } if ($show_oconly81) { require 'lib2/logic/oconly81.inc.php'; set_oconly81_tpldata($userid); } //Titel $menu->SetSelectItem($tpl->menuitem); $tpl->title = $menu->GetMenuTitle() . " " . $record['username']; $tpl->assign('username', $record['username']); $tpl->assign('userid', $userid); $tpl->assign('uuid', $record['uuid']); $tpl->assign('founds', $record['found'] <= 0 ? '0' : $record['found']); $tpl->assign('notfound', $record['notfound'] <= 0 ? '0' : $record['notfound']); $tpl->assign('note', $record['note'] <= 0 ? '0' : $record['note']); $tpl->assign('maintenance', $record['maintenance'] <= 0 ? '0' : $record['maintenance']); $tpl->assign('hidden', $record['hidden'] <= 0 ? '0' : $record['hidden']); $tpl->assign('active', $active); $tpl->assign('recommended', sql_value("SELECT COUNT(*) FROM `cache_rating` WHERE `user_id`='&1'", 0, $userid)); $tpl->assign('maxrecommended', floor($record['found'] * $opt['logic']['rating']['percentageOfFounds'] / 100));
<?php /*************************************************************************** * For license information see doc/license.txt * * Unicode Reminder メモ ***************************************************************************/ require 'lib2/web.inc.php'; require 'lib2/logic/oconly81.inc.php'; $showall = @$_REQUEST['showall'] == 1; $tpl->name = 'oconly81'; $tpl->menuitem = MNU_CACHES_OCONLY81; $tpl->caching = true; $tpl->cache_lifetime = 900; $tpl->cache_id = $showall ? 1 : 0; $login->verify(); sql_temp_table('oconly81'); sql("\n\t\tCREATE TEMPORARY TABLE &oconly81 ENGINE=MEMORY\n\t\tSELECT DISTINCT `user`.`user_id`, `caches`.`terrain`, `caches`.`difficulty`\n\t\tFROM `user`\n\t\tINNER JOIN `cache_logs` ON `cache_logs`.`user_id`=`user`.`user_id` AND `cache_logs`.`type` IN (1,7)\n\t\tINNER JOIN `caches` ON `caches`.`cache_id`=`cache_logs`.`cache_id`\n\t\tINNER JOIN `caches_attributes` ON `caches_attributes`.`cache_id`=`cache_logs`.`cache_id` AND `caches_attributes`.`attrib_id`=6\n\t\tINNER JOIN `user_options` ON `user_options`.`user_id`=`user`.`user_id`\n\t\tWHERE `user_options`.`option_id`=13 AND `user_options`.`option_value`='1'"); // users with 0 OConly founds are filtered out here $rs = sql("\n\t\tSELECT `user`.`username`, `user`.`user_id`, COUNT(*) AS `count`\n\t\tFROM `user`\n\t\tINNER JOIN &oconly81 ON &oconly81.`user_id`=`user`.`user_id`\n\t\tGROUP BY `user`.`user_id`\n\t\tORDER BY `count` DESC, `username` ASC " . ($showall ? "" : "LIMIT " . sql_escape($opt['logic']['oconly81']['default_maxusers'] + 1))); $tpl->assign_rs('users', $rs); sql_free_result($rs); sql_drop_temp_table('oconly81'); set_oconly81_tpldata(0); $tpl->assign('default_maxusers', $opt['logic']['oconly81']['default_maxusers']); $tpl->assign('showall', $showall); $tpl->display();