function cs_categories_dropdown2($mod, $categories_id = 0, $new = 1, $name = 'categories_id') { global $account; $data = array(); $cells = 'categories_id, categories_name, categories_subid'; $categories = cs_sql_select(__FILE__, 'categories', $cells, "categories_mod = '" . $mod . "' AND categories_access <= '" . $account['access_news'] . "'", 'categories_subid ASC, categories_name', 0, 0); $categories = cs_catsort($categories); $data['categories']['options'] = ''; if (!empty($categories)) { foreach ($categories as $cat) { $blank = ''; if (!empty($cat['layer'])) { for ($i = 0; $i < $cat['layer']; $i++) { $blank .= ' '; } $blank .= '»'; } $data['categories']['options'] .= cs_html_option($blank . $cat['categories_name'], $cat['categories_id'], $cat['categories_id'] == $categories_id); } } $data['if']['new'] = !empty($new) ? TRUE : FALSE; $data['dropdown']['name'] = $name; return cs_subtemplate(__FILE__, $data, 'categories', 'cat_dropdown2'); }
$run = 0; $modules = cs_checkdirs('mods'); foreach ($modules as $mods) { $check_axx = empty($account['access_' . $mods['dir'] . '']) ? 0 : $account['access_' . $mods['dir'] . '']; if (!empty($mods['categories']) and $check_axx > 2) { $mods['dir'] == $where ? $sel = 1 : ($sel = 0); $data['mod'][$run]['sel'] = cs_html_option($mods['name'], $mods['dir'], $sel); $run++; } } $data['head']['getmsg'] = cs_getmsg(); $data['sort']['name'] = cs_sort('categories', 'manage', $start, $where, 1, $sort); $data['sort']['url'] = cs_sort('categories', 'manage', $start, $where, 3, $sort); $select = 'categories_id, categories_name, categories_url, categories_subid'; $data['cat'] = cs_sql_select(__FILE__, 'categories', $select, $mdp, $order, $start, $account['users_limit']); $data['cat'] = cs_catsort($data['cat']); $categories_loop = !empty($data['cat']) ? count($data['cat']) : ''; for ($run = 0; $run < $categories_loop; $run++) { $blank = ''; if (!empty($data['cat'][$run]['layer'])) { for ($i = 0; $i < $data['cat'][$run]['layer']; $i++) { $blank .= ' '; } $blank .= cs_icon('add_sub_task'); } $data['cat'][$run]['subcat_layer'] = $blank; $cs_cat_name = cs_secure($data['cat'][$run]['categories_name']); $data['cat'][$run]['category'] = cs_link($cs_cat_name, 'categories', 'view', 'id=' . $data['cat'][$run]['categories_id']); $data['cat'][$run]['url'] = ''; if (!empty($data['cat'][$run]['categories_url'])) { $cs_cat_url = cs_secure($data['cat'][$run]['categories_url']);
<?php // ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('articles'); require_once 'mods/categories/functions.php'; $start = empty($_GET['start']) ? 0 : (int) $_GET['start']; $cs_sort[1] = 'categories_name DESC'; $cs_sort[2] = 'categories_name ASC'; $sort = empty($_GET['sort']) ? 1 : (int) $_GET['sort']; $order = 'categories_subid, ' . $cs_sort[$sort]; $cat_where = "categories_mod = 'articles' AND categories_access <= '" . $account['access_categories'] . "'"; $cells = 'categories_name, categories_id, categories_text, categories_picture, categories_subid'; $data['categories'] = cs_sql_select(__FILE__, 'categories', $cells, $cat_where, $order, $start, 0); $data['categories'] = cs_catsort($data['categories']); $categories_loop = is_array($data['categories']) ? count($data['categories']) : 0; $data['sort']['category'] = cs_sort('articles', 'list', $start, '', 1, $sort); if (!empty($categories_loop)) { for ($run = 0; $run < $categories_loop; $run++) { $data['categories'][$run]['space'] = cs_catspaces($data['categories'][$run]['layer']); $data['categories'][$run]['categories_name'] = cs_link(cs_secure($data['categories'][$run]['categories_name']), 'articles', 'listcat', 'id=' . $data['categories'][$run]['categories_id']); $data['categories'][$run]['articles_count'] = cs_sql_count(__FILE__, 'articles', 'categories_id = ' . $data['categories'][$run]['categories_id']); $data['categories'][$run]['categories_text'] = cs_secure($data['categories'][$run]['categories_text'], 1); $data['if']['catimg'] = empty($data['categories'][$run]['categories_picture']) ? false : true; $data['categories'][$run]['url_catimg'] = ''; //categorie_image //$data['categories'][$run]['url_catimg'] = empty($data['if']['catimg']) ? '' : 'uploads/categories/'.$data['categories'][$run]['categories_picture']; } } echo cs_subtemplate(__FILE__, $data, 'articles', 'list');
cs_sql_query(__FILE__, "DELETE FROM {pre}_read WHERE users_id = '" . $account['users_id'] . "' AND read_since < '" . $cs_readtime . "'"); # fetch unread threads grouped per board for later checks $tables = 'threads thr LEFT JOIN {pre}_read red ON thr.threads_id = red.threads_id AND red.users_id = ' . $account['users_id']; $needed = "thr.threads_last_time > '" . $cs_readtime . "' AND (red.threads_id IS NULL OR thr.threads_last_time > red.read_since)" . ' AND thr.threads_ghost = 0 GROUP BY thr.board_id'; $values = 'thr.board_id AS board_id'; $unread = cs_sql_select(__FILE__, $tables, $values, $needed, 0, 0, 0); $unread = is_array($unread) ? $unread : array(); foreach ($unread as $untop => $unboard) { $unread_array['' . $unboard['board_id'] . ''] = 0; } } $categories_id = empty($_GET['id']) ? 0 : (int) $_GET['id']; $where = "categories_mod = 'board' AND categories_access <= " . $account['access_board']; $select = 'categories_name, categories_id, categories_subid'; $order = 'categories_subid ASC, categories_order ASC, categories_name ASC'; $data['categories'] = cs_catsort(cs_sql_select(__FILE__, 'categories', $select, $where, $order, 0, 0), $categories_id); $count_categories = empty($data['categories']) ? 0 : count($data['categories']); $data['if']['category'] = empty($categories_id) ? false : true; $data['category']['name'] = !empty($categories_id) ? $data['categories'][0]['categories_name'] : ''; for ($run_1 = 0; $run_1 < $count_categories; $run_1++) { $data['categories'][$run_1]['list_url'] = cs_url('board', 'list', 'id=' . $data['categories'][$run_1]['categories_id']); $from = "board boa LEFT JOIN {pre}_read red ON boa.board_last_threadid = red.threads_id AND red.users_id = " . $account['users_id'] . " LEFT JOIN {pre}_members mem ON boa.squads_id = mem.squads_id AND mem.users_id = " . $account['users_id']; $select = 'boa.board_id AS board_id, boa.board_name AS board_name, boa.board_text AS board_text, boa.board_pwd AS board_pwd, ' . 'boa.board_threads AS board_threads, boa.board_comments AS board_comments, boa.board_access AS board_access,' . 'boa.board_last_time AS board_last_time, boa.board_last_user AS board_last_user, boa.board_last_userid AS board_last_userid,' . 'boa.board_last_thread AS board_last_thread, boa.board_last_threadid AS board_last_threadid, red.read_since AS read_since'; $where = "categories_id = '" . $data['categories'][$run_1]['categories_id'] . "' AND (board_access <= " . $account['access_board'] . " OR mem.users_id = " . $account['users_id'] . ")"; $order = 'board_order ASC, board_name ASC'; $data['categories'][$run_1]['board'] = cs_sql_select(__FILE__, $from, $select, $where, $order, 0, 0); if (empty($data['categories'][$run_1]['board'])) { $data['categories'][$run_1]['board'] = array(); } $data['categories'][$run_1]['blank'] = ''; $data['categories'][$run_1]['iconwidth'] = 36;
<?php // ClanSphere 2010 - www.clansphere.net // $Id$ $cs_lang = cs_translate('files'); require 'mods/categories/functions.php'; $where = "categories_mod = 'files' AND categories_access <= '" . $account['access_files'] . "' AND categories_subid = '0'"; $cells = 'categories_id, categories_name, categories_picture, categories_text, categories_subid'; $categories_data = cs_sql_select(__FILE__, 'categories', $cells, $where, 'categories_subid ASC, categories_name', 0, 0); $categories_data = cs_catsort($categories_data); $categories_loop = count($categories_data); $data = array(); $data['categories'] = array(); for ($run = 0; $run < $categories_loop; $run++) { $data['categories'][$run]['id'] = $categories_data[$run]['categories_id']; $data['categories'][$run]['name'] = cs_secure($categories_data[$run]['categories_name']); $data['categories'][$run]['count'] = cs_sql_count(__FILE__, 'files', "categories_id = '" . $categories_data[$run]['categories_id'] . "'"); $data['categories'][$run]['text'] = ''; $data['categories'][$run]['if']['text'] = false; if (!empty($categories_data[$run]['categories_text'])) { $data['categories'][$run]['text'] = cs_secure($categories_data[$run]['categories_text'], 1); $data['categories'][$run]['if']['text'] = true; } $data['categories'][$run]['picture'] = ''; $data['categories'][$run]['if']['picture'] = false; if (!empty($categories_data[$run]['categories_picture'])) { $data['categories'][$run]['picture'] = cs_html_img('uploads/categories/' . $categories_data[$run]['categories_picture']); $data['categories'][$run]['if']['picture'] = true; } $sub_where = "categories_mod = 'files' AND categories_access <= '" . $account['access_files'] . "'"; $sub_where .= " AND categories_subid = '" . $categories_data[$run]['categories_id'] . "'";