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'] . "'";
