} $tpl->redirect($tpl->checkTarget($target, 'mywatches.php')); } elseif ($action == 'remove') { $target = isset($_REQUEST['target']) ? $_REQUEST['target'] : ''; $cacheid = isset($_REQUEST['cacheid']) ? $_REQUEST['cacheid'] + 0 : 0; sql("DELETE FROM `cache_watches` WHERE `cache_id`='&1' AND `user_id`='&2'", $cacheid, $login->userid); $tpl->redirect($tpl->checkTarget($target, 'mywatches.php')); } else { $rs = sql("\n SELECT\n `cache_watches`.`cache_id` AS `cacheid`,\n `caches`.`wp_oc` AS `wp`,\n `caches`.`name` AS `name`,\n `stat_caches`.`last_found` AS `lastfound`,\n `caches`.`type` AS `type`,\n `caches`.`status` AS `status`,\n `ca`.`attrib_id` IS NOT NULL AS `oconly`\n FROM\n `cache_watches`\n INNER JOIN `caches` ON `cache_watches`.`cache_id`=`caches`.`cache_id`\n INNER JOIN `cache_status` ON `caches`.`status`=`cache_status`.`id`\n LEFT JOIN `stat_caches` ON `caches`.`cache_id`=`stat_caches`.`cache_id`\n LEFT JOIN `caches_attributes` `ca` ON `ca`.`cache_id`=`caches`.`cache_id` AND `ca`.`attrib_id`=6\n WHERE (`cache_status`.`allow_user_view`=1 OR `caches`.`user_id`='&1')\n AND `cache_watches`.`user_id`='&1'\n ORDER BY `caches`.`name`", $login->userid); $tpl->assign_rs('watches', $rs); sql_free_result($rs); if (isset($_REQUEST['dontwatchlist'])) { $list = new cachelist($_REQUEST['dontwatchlist'] + 0); if ($list->exist()) { $list->watch(false); } } // The following parameter and variable names are suboptimal; they refer only the the // cache lists and are evaluated by res_cachelists.tpl. $tpl->assign('cachelists', cachelist::getListsWatchedByMe()); $tpl->assign('show_status', false); $tpl->assign('show_user', true); // Do not show watchers because this would allow conclusions on what the list owner watches. $tpl->assign('show_watchers', false); $tpl->assign('show_edit', false); $tpl->assign('togglewatch', 'mywatches.php'); $tpl->assign('removewatch_confirm', true); $tpl->assign('disable_listwatchicon', true); } $tpl->assign('action', $action); $tpl->display();