public function _home() {
global $config, $user, $cache;
if (!_button()) {
$sql = 'SELECT forum_id, forum_name
FROM _forums
ORDER BY forum_order ASC';
$result = sql_rowset($sql);
foreach ($result as $i => $row) {
if (!$i) _style('forums');
_style('forums.row', array(
'FORUM_ID' => $row['forum_id'],
'FORUM_NAME' => $row['forum_name'])
);
}
return false;
}
$list = request_var('listContainer', array(0));
$orderid = 10;
foreach ($list as $catid) {
$sql = 'UPDATE _forums SET forum_order = ?
WHERE forum_id = ?';
sql_query(sql_filter($sql, $orderid, $catid));
$orderid += 10;
}
_pre('Update.', true);
}
public function _home() {
global $config, $user, $cache;
$sql = 'SELECT e.event_topic, f.forum_name, t.topic_id, t.topic_title, t.topic_views, t.topic_replies
FROM _forum_topics t
LEFT JOIN _events e ON e.event_topic = t.topic_id
INNER JOIN _forums f ON t.forum_id = f.forum_id
WHERE t.forum_id NOT IN (38)
ORDER BY t.topic_time DESC
LIMIT 100';
$result = sql_rowset($sql);
foreach ($result as $i => $row) {
if (!$i) _style('topics');
_style('topics.row', array(
'TOPIC_ID' => s_link('topic', $row['topic_id']),
'TOPIC_FORUM' => $row['forum_name'],
'TOPIC_EVENT' => $row['event_topic'],
'TOPIC_TITLE' => $row['topic_title'],
'TOPIC_VIEWS' => $row['topic_views'],
'TOPIC_REPLIES' => $row['topic_replies'])
);
}
return;
}
public function _home() {
global $config, $user, $cache;
$artist = request_var('a', '');
$redirect = request_var('r', '');
if (!empty($artist)) {
redirect(s_link('acp', array($redirect, 'a' => $artist)));
}
$artist_select = '';
if (!$user->is('founder')) {
$sql = 'SELECT ub
FROM _artists_auth
WHERE user_id = ?';
$artist_select = ' WHERE ub IN (' . _implode(',', sql_rowset(sql_filter($sql, $user->d('user_id')), false, 'ub')) . ') ';
}
$sql = 'SELECT ub, subdomain, name
FROM _artists
??
ORDER BY name';
$artists = sql_rowset(sql_filter($sql, $artist_select));
foreach ($artists as $i => $row) {
if (!$i) _style('artist_list');
_style('artist_list.row', array(
'URL' => s_link('acp', array($redirect, 'a' => $row['subdomain'])),
'NAME' => $row['name'])
);
}
return;
}
public function config() {
$sql = 'SELECT *
FROM _application';
$config = sql_rowset($sql, 'config_name', 'config_value');
return $config;
}
public function _home() {
global $config, $user, $cache;
$this->_artist();
if ($this->remove()) {
return;
}
$sql = 'SELECT *
FROM _events e, _artists_events a
WHERE a.a_artist = ?
AND a.a_event = e.id
ORDER BY e.date DESC';
$result = sql_rowset(sql_filter($sql, $this->object['ub']));
foreach ($result as $i => $row) {
if (!$i) _style('events');
_style('events.row', array(
'ID' => $row['id'],
'TITLE' => $row['title'],
'DATE' => $user->format_date($row['date']))
);
}
return;
}
public function _home() {
global $config, $user, $cache;
if (_button()) {
$forum_id = request_var('fid', 0);
$forum_alias = request_var('falias', '');
$sql = 'UPDATE _forums SET forum_alias = ?
WHERE forum_id = ?';
sql_query(sql_filter($sql, $forum_alias, $forum_id));
_pre($forum_id . ' > ' . $forum_alias, true);
}
$sql = 'SELECT forum_id, forum_name
FROM _forums
ORDER BY forum_order';
$result = sql_rowset($sql);
foreach ($result as $i => $row) {
if (!$i) _style('forums');
_style('forums.row', array(
'FORUM_ID' => $row['forum_id'],
'FORUM_NAME' => $row['forum_name'])
);
}
return;
}
public function _artist() {
global $user;
if ($user->is('artist')) {
$sql = 'SELECT a.ub
FROM _artists_auth t
INNER JOIN _artists a ON a.ub = t.ub
WHERE t.user_id = ?';
if ($artist_ary = sql_rowset(sql_filter($sql, $user->d('user_id')), false, 'ub')) {
$sql_where = sql_filter('WHERE ub IN (??)', implode(',', $artist_ary));
}
}
$artist = request_var('a', '');
$module = request_var('module', '');
$url = s_link('acp', array('artist_select', 'r' => $module));
if (empty($artist)) {
redirect($url);
}
if (!$this->object = get_artist($artist, true)) {
fatal_error();
}
v_style(array(
'ARTIST_SELECT' => $url,
'ARTIST_NAME' => $this->object['name'])
);
return;
}
public function home()
{
global $core, $bio;
$v = $this->__(array_merge(w('r'), _array_keys(w('v'), 0)));
if (!empty($v->v)) {
$sql = 'SELECT *
FROM _objects o, _objects_type t
WHERE o.object_id = ?
AND t.type_alias = ?
AND o.object_type = t.type_id';
$video = sql_rowset(sql_filter($sql, $v->v, 'tv'));
$sql = 'SELECT *
FROM _objects o, _objects_type t, _bio b
WHERE o.object_id <> ?
AND t.type_alias = ?
AND o.object_type = t.type_id
AND o.object_bio = b.bio_id
ORDER BY o.object_time';
$tv_list = sql_rowset(sql_filter($sql, $v->v, 'tv'));
$tv = w();
foreach ($video as $row) {
$tv[] = $row;
}
foreach ($tv_list as $row) {
$tv[] = $row;
}
//_pre($tv, true);
} else {
$sql = 'SELECT *
FROM _objects o, _objects_type t, _bio b
WHERE t.type_alias = ?
AND o.object_type = t.type_id
AND o.object_bio = b.bio_id
ORDER BY o.object_time';
$tv = sql_rowset(sql_filter($sql, 'tv'));
}
foreach ($tv as $i => $row) {
if (!$i) {
_style('tv', array('FIRST_SUBJECT' => $row->object_subject));
}
//$preg = preg_match("^http://(?<domain>([^./]+\\.)*youtube\\.com)(/v/|/watch\\?v=)(?<videoId>[A-Za-z0-9_-]{11})", $row->object_content);
preg_match('#(?<=(?:v|i)=)[a-zA-Z0-9-]+(?=&)|(?<=(?:v|i)\\/)[^&\\n]+|(?<=embed\\/)[^"&\\n]+|(?<=(?:v|i)=)[^&\\n]+|(?<=youtu.be\\/)[^&\\n]+#', $row->object_content, $preg);
$embed = '<iframe width="560" height="315" src="http://www.youtube.com/embed/' . $preg[0] . '" frameborder="0" allowfullscreen></iframe>';
$_row = array('ID' => $row->object_id, 'BIO' => $row->object_bio, 'SUBJECT' => $row->object_subject, 'CONTENT' => $row->object_content, 'VIDEO' => $preg[0], 'EMBED' => !$i ? $embed : '<a href="' . _link('tv', array('v' => $row->object_id)) . '" class="thumbnail"><img src="http://i2.ytimg.com/vi/' . $preg[0] . '/default.jpg" alt=""><br /><h5>' . $row->object_subject . '</h5></a>', 'EMBED2' => !$i ? $embed : '<img src="http://i2.ytimg.com/vi/' . $preg[0] . '/default.jpg" alt="" width="140" height="140" rel="' . _link('tv', array('v' => $row->object_id)) . '" />', 'EMBED3' => !$i ? $embed : '<a href="' . _link('tv', array('v' => $row->object_id)) . '"><img src="http://i2.ytimg.com/vi/' . $preg[0] . '/default.jpg" alt="" width="140" height="140"></a>', 'SPAN' => !$i ? 'span6' : 'span2', 'TIME' => $bio->format_date($row->object_time));
_style('tv.row', array_merge($_row, $this->_profile($row)));
}
$sql = 'SELECT *
FROM _objects_rel_type
ORDER BY type_alias';
$rel_type = sql_rowset($sql);
foreach ($rel_type as $i => $row) {
if (!$i) {
_style('rel_type', array('TV_URL' => _link('tv')));
}
$row->type_alias = _link('tv', array('r' => $row->type_alias));
_style('rel_type.row', $row);
}
return;
}
public function home()
{
global $core, $bio;
$v = $this->__(array_merge(w('a r'), _array_keys(w('s'), 0)));
if (!empty($v->a)) {
}
if (!empty($v->r)) {
$sql = 'SELECT *
FROM _objects o, _objects_type t, _bio b, _objects_rel_assoc ra, _objects_rel_type rt
WHERE t.type_alias = ?
AND rt.type_alias = ?
AND o.object_bio = b.bio_id
AND ra.assoc_object = o.object_id
AND ra.assoc_rel_type = rt.type_id
ORDER BY o.object_time
LIMIT ??, ??';
$news = sql_rowset(sql_filter($sql, 'news', $v->r, $v->s, $core->v('objects_per_page')));
$sql = 'SELECT COUNT(object_id) AS total
FROM _objects o, _objects_type t, _objects_rel_assoc ra, _objects_rel_type rt
WHERE t.type_alias = ?
AND rt.type_alias = ?
AND ra.assoc_object = o.object_id
AND ra.assoc_rel_type = rt.type_id';
$news_total = sql_field(sql_filter($sql, 'news', $v->r), 'total', 0);
} else {
$sql = 'SELECT *
FROM _objects o, _objects_type t, _bio b
WHERE t.type_alias = ?
AND o.object_type = t.type_id
AND o.object_bio = b.bio_id
ORDER BY o.object_time
LIMIT ??, ??';
$news = sql_rowset(sql_filter($sql, 'news', $v->s, $core->v('objects_per_page')));
$sql = 'SELECT COUNT(object_id) AS total
FROM _objects o, _objects_type t
WHERE t.type_alias = ?
AND o.object_type = t.type_id';
$news_total = sql_field(sql_filter($sql, 'news'), 'total', 0);
}
foreach ($news as $i => $row) {
if (!$i) {
_style('news', _pagination(_link('news'), 's:%d', $news_total + 1, $core->v('objects_per_page'), $v->s));
}
$_row = array('ID' => $row->object_id, 'BIO' => $row->object_bio, 'SUBJECT' => $row->object_subject, 'CONTENT' => _message($row->object_content), 'TIME' => $bio->format_date($row->object_time));
_style('news.row', array_merge($_row, $this->_profile($row)));
}
$sql = 'SELECT *
FROM _objects_rel_type
ORDER BY type_alias';
$rel_type = sql_rowset($sql);
foreach ($rel_type as $i => $row) {
if (!$i) {
_style('rel_type', array('NEWS_URL' => _link('news')));
}
$row->type_alias = _link('news', array('r' => $row->type_alias));
_style('rel_type.row', $row);
}
return;
}
public function _home() {
global $config, $cache, $user;
if (!_button()) {
$sql = 'SELECT cat_id, cat_name
FROM _news_cat
ORDER BY cat_id';
$result = sql_rowset($sql);
foreach ($result as $i => $row) {
if (!$i) _style('categories');
_style('categories.row', array(
'CAT_ID' => $row['cat_id'],
'CAT_NAME' => $row['cat_name'])
);
}
return false;
}
$t = request_var('news_id', 0);
$f = request_var('cat_id', 0);
if (!$f || !$t) {
fatal_error();
}
//
$sql = 'SELECT *
FROM _news
WHERE news_id = ?';
if (!$tdata = sql_fieldrow(sql_filter($sql, $t))) {
fatal_error();
}
//
$sql = 'SELECT *
FROM _news_cat
WHERE cat_id = ?';
if (!$fdata = sql_fieldrow(sql_filter($sql, $f))) {
fatal_error();
}
//
$sql = 'UPDATE _news SET cat_id = ?
WHERE news_id = ?';
sql_query(sql_filter($sql, $f, $t));
return redirect(s_link('news', $t));
}
private function elements() {
$sql = 'SELECT *
FROM _win
ORDER BY win_date';
$win = sql_rowset($sql);
foreach ($win as $i => $row) {
if (!$ui) _style('win');
_style('win.row', array(
));
}
return;
}
public function _home() {
global $config, $user, $cache;
if (_button()) {
$topic = request_var('topic', 0);
$sql = 'SELECT *
FROM _forum_topics
WHERE topic_id = ?';
if (!$topicdata = sql_fieldrow(sql_filter($sql, $topic))) {
fatal_error();
}
$sql = 'UPDATE _forum_topics
SET topic_color = ?, topic_announce = 0, topic_important = 0
WHERE topic_id = ?';
sql_query(sql_filter($sql, '', $topic));
_style('updated', array(
'MESSAGE' => 'El tema <strong>' . $topicdata['topic_title'] . '</strong> ha sido normalizado.')
);
}
$sql = 'SELECT t.topic_id, t.topic_title, f.forum_name
FROM _forums f, _forum_topics t
WHERE f.forum_id = t.forum_id
AND (topic_announce = 1
OR topic_important = 1)
ORDER BY forum_order, topic_title';
$topics = sql_rowset($sql);
$forum_name = '';
foreach ($topics as $i => $row) {
if (!$i) _style('topics');
if ($forum_name != $row['forum_name']) _style('topics.forum', array('FORUM_NAME' => $row['forum_name']));
$forum_name = $row['forum_name'];
_style('topics.forum.row', array(
'TOPIC_ID' => $row['topic_id'],
'TOPIC_TITLE' => $row['topic_title'])
);
}
return;
}
public function _home() {
global $config, $user, $cache;
$limit = 225;
$steps = 0;
$items = 0;
$trash = w();
//
$sql = "SELECT *
FROM _members
WHERE user_type NOT IN (??)
AND user_email <> ''
AND user_id NOT IN (
SELECT ban_userid
FROM _banlist
WHERE ban_userid <> 0
)
ORDER BY username";
$result = sql_rowset(sql_filter($sql, USER_INACTIVE));
foreach ($result as $row) {
if (!preg_match('/^[a-z0-9&\'\.\-_\+]+@[a-z0-9\-]+\.([a-z0-9\-]+\.)*?[a-z]+$/is', $row['user_email'])) {
$trash[] = $row['user_email'];
continue;
}
if (!$items || $items == $limit) {
$items = 0;
$steps++;
_style('step', array(
'STEPS' => $steps)
);
}
_style('step.item', array(
'USERNAME' => $row['username'],
'USER_EMAIL' => $row['user_email'])
);
$items++;
}
return;
}
public function run() {
$sql = 'SELECT *
FROM _awards_type
ORDER BY type_order';
$types = sql_rowset($sql);
foreach ($types as $i => $row) {
if (!$i) _style('awards');
_style('awards.row', array(
'NAME' => $row['type_name'],
'DESC' => $row['type_desc'])
);
}
return;
}
public function home()
{
$now = time();
$sql = 'SELECT *
FROM _contest
WHERE contest_start > ??
AND contest_end < ??
ORDER BY contest_start';
$contest = sql_rowset(sql_filter($sql, $now, $now));
foreach ($contest as $i => $row) {
if (!$i) {
_style('contest');
}
_style('contest.row', array('URL' => _link('contest', $row->contest_alias), 'SUBJECT' => $row->contest_subject, 'END' => _format_date($row->contest_end)));
}
return;
}
public function run() {
global $cache, $comments;
$alias = request_var('alias', '');
if (!empty($alias)) {
$sql = 'SELECT *
FROM _help_cat c, _help_modules m, _help_faq f
WHERE c.help_module = m.module_id
AND f.help_id = c.help_id
AND m.module_name = ?
ORDER BY f.faq_question_es';
$module = sql_rowset(sql_filter($sql, $alias));
foreach ($module as $i => $row) {
if (!$i) _style('module', array('TITLE' => $row['help_es']));
_style('module.row', array(
'QUESTION' => $row['faq_question_es'],
'ANSWER' => $comments->parse_message($row['faq_answer_es']))
);
}
}
if (!$help = $cache->get('help')) {
$sql = 'SELECT *
FROM _help_cat c, _help_modules m
WHERE c.help_module = m.module_id
ORDER BY c.help_order';
if ($help = sql_rowset($sql)) {
$cache->save('help', $help);
}
}
foreach ($help as $i => $row) {
if (!$i) _style('categories');
_style('categories.row', array(
'URL' => s_link('help', $row['module_name']),
'TITLE' => $row['help_es'])
);
}
return;
}
function _artists() {
$sql = 'SELECT name, subdomain, genre, datetime, local, location
FROM _artists
ORDER BY datetime DESC
LIMIT 15';
$result = sql_rowset($sql);
foreach ($result as $row) {
$this->xml[] = array(
'title' => $row['name'],
'link' => s_link('a', $row['subdomain']),
'description' => ($row['genre'] . "<br />" . (($row['local']) ? 'Guatemala' : $row['location'])),
'pubdate' => $row['datetime']
);
}
return;
}
public function __construct()
{
$sql = 'SELECT *
FROM _config';
$this->config = sql_rowset($sql, 'config_name', 'config_value');
if ($this->v('site_disable')) {
exit('not_running');
}
$address = $this->v('site_address');
$host_addr = array_key(explode('/', array_key(explode('//', $address), 1)), 0);
if ($host_addr != get_host()) {
$allow_hosts = get_file(XFS . XCOR . 'store/domain_alias');
foreach ($allow_hosts as $row) {
if (substr($row, 0, 1) == '#') {
continue;
}
$remote = strpos($row, '*') === false;
$row = !$remote ? str_replace('*', '', $row) : $row;
$row = str_replace('www.', '', $row);
if ($row == get_host()) {
$sub = str_replace($row, '', get_host());
$sub = f($sub) ? $sub . '.' : ($remote ? 'www.' : '');
$address = str_replace($host_addr, $sub . $row, $address);
$this->v('site_address', $address, true);
break;
}
}
}
if (strpos($address, 'www.') !== false && strpos(get_host(), 'www.') === false && strpos($address, get_host())) {
$page_protocol = array_key(explode('//', _page()), 0);
$a = $this->v('site_address') . str_replace(str_replace('www.', '', $page_protocol . $address), '', _page());
redirect($a, false);
}
$this->cache_dir = XFS . XCOR . 'cache/';
if (is_remote() && @file_exists($this->cache_dir) && @is_writable($this->cache_dir) && @is_readable($this->cache_dir)) {
$this->cache_f = true;
}
//
// Load additional objects.
//
$this->email = _import('emailer');
$this->cache = _import('cache');
return;
}
public function _home() {
global $config, $user, $cache, $upload;
if (_button()) {
$news_id = request_var('news_id', 0);
$sql = 'SELECT news_id
FROM _news
WHERE news_id = ?';
if (!sql_field(sql_filter($sql, $news_id), 'news_id', 0)) {
fatal_error();
}
$filepath_1 = $config['news_path'];
$f = $upload->process($filepath_1, 'add_image', 'jpg');
if (!sizeof($upload->error) && $f !== false) {
foreach ($f as $row) {
$xa = $upload->resize($row, $filepath_1, $filepath_1, $news_id, array(100, 75), false, false, true);
}
redirect(s_link());
}
_style('error', array(
'MESSAGE' => parse_error($upload->error))
);
}
$sql = 'SELECT *
FROM _news
ORDER BY post_time DESC';
$result = sql_rowset($sql);
foreach ($result as $row) {
_style('news_list', array(
'NEWS_ID' => $row['news_id'],
'NEWS_TITLE' => $row['post_subject'])
);
}
return;
}
public function _home() {
global $config, $user, $cache;
$username = request_var('username', '');
$ip = request_var('ip', '');
if (_button() && ($username || $ip)) {
if ($username) {
$username_base = get_username_base($username);
$sql = 'SELECT m.username, l.*
FROM _members m, _members_iplog l
WHERE m.user_id = l.log_user_id
AND m.username_base = ?
ORDER BY l.log_time DESC';
$sql = sql_filter($sql, $username_base);
} else if ($ip) {
$sql = 'SELECT m.username, l.*
FROM _members m, _members_iplog l
WHERE m.user_id = l.log_user_id
AND l.log_ip = ?
ORDER BY l.log_time DESC';
$sql = sql_filter($sql, $ip);
}
$result = sql_rowset($sql);
foreach ($result as $i => $row) {
if (!$i) _style('log');
_style('log.row', array(
'UID' => $row['log_user_id'],
'USERNAME' => $row['username'],
'TIME' => $user->format_date($row['log_time']),
'ENDTIME' => (($row['log_endtime']) ? $user->format_date($row['log_endtime']) : ' '),
'DIFFTIME' => (($row['log_endtime']) ? _implode(' ', timeDiff($row['log_endtime'], $row['log_time'], true, 1)) : ' '),
'IP' => $row['log_ip'],
'AGENT' => $row['log_agent'])
);
}
}
return;
}
public function _home() {
global $config, $user, $cache;
if (!_button()) {
return false;
}
$topic_id = request_var('topic_id', '');
if (empty($topic_id)) {
fatal_error();
}
$sql = 'SELECT *
FROM _poll_options
WHERE topic_id = ?';
if (!$data_opt = sql_fieldrow(sql_filter($sql, $topic_id))) {
fatal_error();
}
$sql = 'SELECT v.*, m.username, r.vote_option_text
FROM _poll_voters v, _members m, _poll_results r
WHERE v.vote_id = ?
AND v.vote_id = r.vote_id
AND v.vote_user_id = m.user_id
AND r.vote_option_id = v.vote_cast';
$result = sql_rowset(sql_filter($sql, $data_opt['vote_id']));
echo '<table>';
foreach ($result as $row) {
echo '<tr>
<td>' . $row['username'] . '</td>
<td>' . $row['vote_option_text'] . '</td>
<td>' . $row['vote_user_ip'] . '</td>
</tr>';
}
echo '</table><br /><br /><br />';
return;
}
public function _home() {
global $config, $user, $cache;
$sql = 'SELECT user_id, username, username_base, user_points
FROM _members
WHERE user_points <> 0
ORDER BY user_points DESC, username';
$result = sql_rowset($sql);
foreach ($result as $i => $row) {
if (!$i) _style('members');
_style('members.row', array(
'BASE' => s_link('m', $row['username_base']),
'USERNAME' => $row['username'],
'POINTS' => $row['user_points'])
);
}
return;
}
public function _home() {
global $config, $user, $cache;
$sql = 'SELECT d.*, m.username, m.username_base
FROM _radio_dj_log d, _members m
WHERE d.log_uid = m.user_id
ORDER BY log_time DESC';
$result = sql_rowset($sql);
foreach ($result as $i => $row) {
if (!$i) _style('report');
_style('report.row', array(
'LINK' => s_link('m', $row['username_base']),
'NAME' => $row['username'],
'TIME' => $user->format_date($row['log_time']))
);
}
return;
}
public function _home() {
global $config, $user, $cache;
$this->_artist();
if ($this->create()) {
return;
}
$ini_year = mktime(0, 0, 0, 1, 1);
$sql = 'SELECT *
FROM _events
WHERE date > ??
ORDER BY date DESC';
$events = sql_rowset(sql_filter($sql, $ini_year));
$last_month = '';
foreach ($events as $i => $row) {
if (!$i) _style('events');
$row_month = ucfirst($user->format_date($row['date'], 'F \'y'));
if ($last_month != $row_month) {
$last_month = $row_month;
_style('events.month', array(
'NAME' => $row_month)
);
}
_style('events.month.row', array(
'ID' => $row['id'],
'TITLE' => $row['title'],
'DATE' => $user->format_date($row['date']))
);
}
return;
}
public function _home() {
global $config, $user, $cache, $comments;
$sql = 'SELECT *
FROM _members_unread
WHERE element = ?
GROUP BY item';
$result = sql_rowset(sql_filter($sql, UH_T));
foreach ($result as $row) {
$sql2 = 'SELECT topic_id
FROM _forum_topics
WHERE topic_id = ?';
if (!sql_field(sql_filter($sql, $row['item']), 'topic_id', 0)) {
$user->delete_all_unread(UH_T, $row['item']);
}
}
_pre('Deleted', true);
return;
}
public function _home() {
global $config, $user;
if ($this->update()) {
return;
}
$sql = 'SELECT *
FROM _events
WHERE date > ?
ORDER BY date DESC';
$result = sql_rowset(sql_filter($sql, time()));
foreach ($result as $row) {
_style('event_list', array(
'EVENT_ID' => $row['id'],
'EVENT_TITLE' => $row['title'],
'EVENT_DATE' => $user->format_date($row['date']))
);
}
return;
}
public function _home() {
global $config, $user, $cache;
$sql = 'SELECT *
FROM _forum_topics_nopoints
ORDER BY exclude_topic';
$result = sql_rowset($sql);
foreach ($result as $i => $row) {
$sql = 'UPDATE _forum_topics
SET topic_points = 0
WHERE topic_id = ?';
sql_query(sql_filter($sql, $row['exclude_topic']));
if (!$i) _style('topics');
_style('topics.rows', array(
'NAME' => $row['exclude_topic'])
);
}
return;
}
public function _home() {
global $config, $user, $cache;
$auth = array(16 => 'radio', 17 => 'mod');
$sql = 'SELECT *
FROM _members_unread
WHERE element = 8
ORDER BY user_id, element, item';
$result = sql_rowset($sql);
foreach ($result as $row) {
$delete = false;
$t = search_topic($row['item']);
if ($t !== false) {
if (in_array($t['forum_id'], array(16, 17))) {
$a = $user->is($auth[$t['forum_id']], $row['user_id']);
if (!$a) {
$delete = true;
}
}
} else {
$delete = true;
}
if ($delete) {
$sql = 'DELETE LOW_PRIORITY FROM _members_unread
WHERE user_id = ?
AND element = 8
AND item = ?';
sql_query(sql_filter($sql, $row['user_id'], $row['item']));
}
}
return _pre('Finished.', true);
}
function layout($where = 1, $error = array(), $params = array())
{
global $db, $user, $config, $userdata;
page_header();
echo '<div class="vsep-pre"><div class="vsep1"> </div></div>';
switch ($where) {
case 1:
if (!sizeof($params)) {
$params = $userdata;
}
?>
<div class="vsep-pre"><div class="vsep1"> </div></div>
<form action="<?php
echo s_link('ranks');
?>
" method="post">
<div class="colorbox darkborder pad10">
<div align="center" class="h2"><?php
echo $userdata['username'];
?>
</div>
<div class="ie-widthfix">
<?php
show_error($error);
?>
<br />
<table cellpadding="5" cellspacing="0" border="1" bordercolor="#999999" class="table-collapse" align="center">
<tr>
<td>Rango Mínimo</td>
<td><input type="text" name="user_rank_min" value="<?php
echo $params['user_rank_min'];
?>
" /></td>
</tr>
<tr>
<td>Rango Máximo</td>
<td><input type="text" name="user_rank_max" value="<?php
echo $params['user_rank_max'];
?>
" /></td>
</tr>
</table>
<div align="center">
<?php
echo s_hidden(array('userid' => $userdata['user_id']));
?>
<br />
<input type="submit" class="submitdata" name="submit" value="Realizar consulta" />
</div>
</div>
</div>
</form>
<?php
break;
case 2:
$sql = 'SELECT *
FROM _users
WHERE user_id <> 1
AND user_adm = 0
ORDER BY username';
if ($result = sql_rowset($sql)) {
echo '<div class="tdisb pad10 red colorbox dsm ie-widthfix">';
foreach ($result as $row) {
echo '<div class="pad4">• <a href="' . s_link('ranks', $row['user_id']) . '">' . $row['username'] . '</a></div>';
}
}
break;
}
echo '</div>';
page_footer();
}
<div class="header">
<div class="header_title">
Purge trash
</div>
</div>
<div class="container">
<?php
sql_order("objTitle");
sql_where(array("objEid*" => "objid", "objPending" => 0, "objCreator" => $_auth["useid"], "objDeleted" => 1, "objDeletedBy" => $_auth["useid"], "objDeleteDate<!" => "DATE_SUB( NOW(), INTERVAL 30 DAY )"));
$result = sql_rowset("objects, objExtData");
$showForm = sql_num_rows($result) > 0 && !isset($_POST["submit"]);
if ($showForm) {
?>
<form action="<?php
echo url(".");
?>
" method="post">
<div>
Select deleted submissions you want to purge forever:
</div>
<?php
}
include_once INCLUDES . "submission.php";
while ($objData = sql_next($result)) {
if (isset($_POST["delete" . $objData["objid"]])) {
eraseSubmission($objData["objid"], false, false);
notice("Purged: " . $objData["objTitle"]);
continue;
}
if ($showForm) {
?>
