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 _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()) {
$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, $comments;
$this->_artist();
if ((_button() && $this->create()) || (_button('remove') && $this->remove())) {
return;
}
$sql = 'SELECT *
FROM _artists_video
WHERE video_a = ?
ORDER BY video_added DESC';
$result = sql_rowset(sql_filter($sql, $this->object['ub']));
foreach ($result as $i => $row) {
if (!$i) _style('video');
_style('video.row', array(
'ID' => $row['video_id'],
'CODE' => $row['video_code'],
'NAME' => $row['video_name'],
'TIME' => $user->format_date($row['video_added']))
);
}
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 _home() {
global $config, $user, $comments;
$this->_artist();
if (_button()) {
$message = request_var('message', '');
$message = $comments->prepare($message);
$sql = 'UPDATE _artists SET bio = ?
WHERE ub = ?';
sql_query(sql_filter($sql, $message, $this->object['ub']));
_style('updated');
}
$sql = 'SELECT bio
FROM _artists
WHERE ub = ?';
$bio = sql_field(sql_filter($sql, $this->object['ub']), 'bio');
v_style(array(
'MESSAGE' => $bio)
);
return;
}
public function run() {
global $user;
$sql = 'SELECT *
FROM _today_objects o
INNER JOIN _today_type t ON t.type_id = o.object_type
WHERE object_bio = ?
GROUP BY o.object_type
ORDER BY t.type_order, o.object_relation';
if (!$elements = sql_rowset(sql_filter($sql, $user->d('user_id')))) {
return false;
}
$this->downloads = new downloads();
foreach ($elements as $row) {
if ($response = $this->{$row['type_alias']}()) {
_style($row['type_alias'], array(
'ID' => $row['type_id'])
);
foreach ($response as $_row) {
_style($row['type_alias'] . '.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 $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 $config, $user, $cache;
$submit2 = _button('submit2');
if (_button() || $submit2) {
$news_id = request_var('news_id', 0);
$sql = 'SELECT *
FROM _news
WHERE news_id = ?';
if (!$news_data = sql_fieldrow(sql_filter($sql, $news_id))) {
fatal_error();
}
if ($submit2) {
$post_subject = request_var('post_subject', '');
$post_desc = request_var('post_desc', '', true);
$post_message = request_var('post_text', '', true);
if (empty($post_desc) || empty($post_message)) {
_pre('Campos requeridos.', true);
}
$comments = new _comments();
$post_message = $comments->prepare($post_message);
$post_desc = $comments->prepare($post_desc);
//
$sql = 'UPDATE _news SET post_subject = ?, post_desc = ?, post_text = ?
WHERE news_id = ?';
sql_query(sql_filter($sql, $post_subject, $post_desc, $post_message, $news_id));
$cache->delete('news');
redirect(s_link('news', $news_id));
}
if (_button()) {
_style('edit', array(
'ID' => $news_data['news_id'],
'SUBJECT' => $news_data['post_subject'],
'DESC' => $news_data['post_desc'],
'TEXT' => $news_data['post_text'])
);
}
}
if (!_button()) {
_style('field');
}
return;
}
public function home()
{
global $core;
$v = $this->__(array('a', 'p' => 0));
if (f($v['a'])) {
$sql = 'SELECT area_id
FROM _reference_area
WHERE area_alias = ?';
if (!_field(sql_filter($sql, $v['a']), 'area_id', 0)) {
_fatal();
}
$sql = 'SELECT COUNT(r.ref_id) AS total
FROM _reference r, _reference_area a
WHERE a.area_alias = ?
AND r.ref_area = a.area_id
ORDER BY r.ref_time DESC';
$ref_total = _field(sql_filter($sql, $v['a']), 'total', 0);
$sql = 'SELECT *
FROM _reference r, _reference_area a
WHERE a.area_alias = ?
AND r.ref_area = a.area_id
ORDER BY r.ref_time DESC
LIMIT ??, ??';
$ref = _rowset(sql_filter($sql, $v['a'], $v['p'], $core->v('ref_pages')));
} else {
$sql = 'SELECT COUNT(ref_id) AS total
FROM _reference
ORDER BY ref_time DESC';
$ref_total = _field($sql, 'total', 0);
$sql = 'SELECT *
FROM _reference r, _reference_area a
WHERE r.ref_area = a.area_id
ORDER BY r.ref_time DESC
LIMIT ??, ??';
$ref = _rowset(sql_filter($sql, $v['p'], $core->v('ref_pages')));
}
if ($v['p'] && $ref_total) {
redirect(_link());
} else {
_style('noref');
}
foreach ($ref as $i => $row) {
if (!$i) {
_style('ref');
}
if ($this->has_plugin($row['ref_content'])) {
$this->parse_plugin($row);
continue;
}
_style('ref.row', _vs(array('id' => $row['ref_id'], 'link' => _link($row['ref_alias']), 'subject' => $row['ref_subject'], 'content' => _message($row['ref_content']), 'time' => _format_date($row['ref_time'])), 'ref'));
}
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 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;
}
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 $core;
$v = $this->__(w('url'));
if (!f($v['url'])) {
$v['url'] = $core->v('address');
}
if (!f($v['url'])) {
return;
}
if (preg_match('/.*?\\.css/i', $v['url'])) {
$css = array($v['url']);
} else {
$parse = parse_url($v['url']);
$f = netsock($parse['host'], $parse['path']);
preg_match_all('#<link .*? href="(.*?\\.css.*?)".*?\\/>#i', $f, $css);
$css = $css[1];
}
foreach ($css as $row) {
$a_parse = parse_url($row);
if (!isset($a_parse['host'])) {
$a_parse['host'] = $parse['host'];
}
$fcss = netsock($a_parse['host'], $a_parse['path'], 80, true);
$pat = '(#([0-9A-Fa-f]{3,6})\\b)|(rgb\\(\\s*\\b([0-9]|[1-9][0-9]|1[0-9][0-9]|2[0-4][0-9]|25[0-5])\\b\\s*,\\s*\\b([0-9]|[1-9][0-9]|1[0-9][0-9]|2[0-4][0-9]|25[0-5])\\b\\s*,\\s*\\b([0-9]|[1-9][0-9]|1[0-9][0-9]|2[0-4][0-9]|25[0-5])\\b\\s*\\))|(rgb\\(\\s*(\\d?\\d%|100%)+\\s*,\\s*(\\d?\\d%|100%)+\\s*,\\s*(\\d?\\d%|100%)+\\s*\\))';
preg_match_all('/' . $pat . '/i', $fcss, $all_color);
$group = w();
foreach ($all_color[1] as $pat_row) {
$pat_row = strtoupper($pat_row);
if (!isset($group[$pat_row])) {
$group[$pat_row] = 1;
}
}
_style('list', array('FILE' => $row));
$group = array_keys($group);
sort($group);
foreach ($group as $color_row) {
_style('list.row', array('COLOR' => str_replace('#', '', $color_row)));
}
}
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;
}
private function update() {
global $config, $upload;
$v = _request(array('event_id' => 0));
$sql = 'SELECT *
FROM _events
WHERE id = ?';
if (!$event_data = sql_fieldrow(sql_filter($sql, $v->event_id))) {
return;
}
$filepath_1 = $config['events_path'] . 'future/';
$filepath_2 = $config['events_path'] . 'future/thumbnails/';
$f = $upload->process($filepath_1, 'event_image', 'jpg');
if ($upload->error) {
_style('error', array(
'MESSAGE' => parse_error($upload->error))
);
return;
}
foreach ($f as $row) {
$xa = $upload->resize($row, $filepath_1, $filepath_1, $v->event_id, array(600, 400), false, false, true);
if ($xa === false) {
continue;
}
$xb = $upload->resize($row, $filepath_1, $filepath_2, $v->event_id, array(100, 75), false, false);
}
$sql = 'UPDATE _events SET event_update = ?
WHERE id = ?';
sql_query(sql_filter($sql, time(), $v->event_id));
return redirect(s_link('events', $event_data['event_alias']));
}
public function home()
{
$cols = w('Email Nickname Cumpleaños País');
$sql = 'SELECT user_email, user_username, user_birthday, country_name
FROM _members m, _countries c
WHERE m.user_type = ?
AND m.user_country = c.country_id
ORDER BY m.user_username';
$members = _rowset(sql_filter($sql, 1));
foreach ($members as $i => $rowm) {
if (!$i) {
_style('table');
foreach ($cols as $j => $field) {
if (!$j) {
_style('table.head', array('TITLE' => '#'));
}
_style('table.head', array('TITLE' => $field));
}
}
_style('table.row');
$j = 0;
foreach ($rowm as $f => $row) {
if (!$j) {
_style('table.row.col', array('VALUE' => $i + 1));
}
switch ($f) {
case 'user_birthday':
$row_year = substr($row, 0, 4);
$row_month = substr($row, 4, 2);
$row_day = substr($row, 6, 2);
$row = _format_date(_timestamp($row_month, $row_day, $row_year), 'd F Y');
break;
}
_style('table.row.col', array('VALUE' => $row));
$j++;
}
}
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;
}
protected function _cat_home()
{
global $user;
$v = $this->__(array('g' => 0));
if ($v['g']) {
$sql = 'SELECT group_id
FROM _groups
WHERE group_id = ?';
if (!_field(sql_filter($sql, $v['g']), 'group_id', 0)) {
_fatal();
}
}
$sql_filter = $v['g'] ? sql_filter('= ??', $v['g']) : '> 0';
$sql = 'SELECT c.cat_id, c.cat_name, g.group_name AS group_alias, g.group_email
FROM _tickets_cat c, _groups g
WHERE c.cat_group ??
AND c.cat_group = g.group_id
AND g.group_id IN (??)
ORDER BY cat_group, cat_name';
if (!_rowset_style(sql_filter($sql, $sql_filter, $user->auth_groups()), 'cat')) {
_style('no_cat');
}
$sql = 'SELECT group_id, group_name, group_email
FROM _groups
WHERE group_id IN (??)
ORDER BY group_name';
_rowset_style(sql_filter($sql, $user->auth_groups()), 'groups');
return;
}
public function home()
{
global $core, $bio;
$page = 15;
$today = _htimestamp('md');
_pre($bio->v('is_bio'), true);
_style('status_post');
// Friends birthday
if ($bio->v('auth_member')) {
$sql = "SELECT bio_id, bio_alias, bio_name\r\n\t\t\t\tFROM _bio\r\n\t\t\t\tWHERE bio_id IN (\r\n\t\t\t\t\t\tSELECT fan_of\r\n\t\t\t\t\t\tFROM _bio_fans\r\n\t\t\t\t\t\tWHERE fan_assoc = ?\r\n\t\t\t\t\t)\r\n\t\t\t\t\tAND bio_active = ?\r\n\t\t\t\t\tAND bio_birth LIKE '%??'\r\n\t\t\t\tORDER BY bio_name";
$birthday = _rowset(sql_filter($sql, $bio->v('bio_id'), 1, $today));
} else {
$sql = "SELECT bio_id, bio_alias, bio_name, bio_avatar, bio_avatar_up\r\n\t\t\t\tFROM _bio\r\n\t\t\t\tWHERE bio_level = ?\r\n\t\t\t\t\tAND bio_birth LIKE '%??'\r\n\t\t\t\tORDER BY bio_name";
$birthday = _rowset(sql_filter($sql, 1, $today));
}
foreach ($birthday as $i => $row) {
if (!$i) {
_style('birthday');
}
_style('birthday.row', array('A' => _a($row), 'NAME' => $row['bio_name'], 'AVATAR' => _avatar($row)));
}
// Board topics
if ($bio->v('auth_member')) {
$sql = 'SELECT t.topic_id, t.topic_alias, t.topic_title, h.highlight_class
FROM _board_topics t
INNER JOIN _board_forums f ON f.forum_id = t.topic_forum
LEFT JOIN _board_highlight h ON t.topic_highlight = h.highlight_id
RIGHT JOIN _board_disallow d ON t.topic_id = d.disallow_topic AND d.disallow_bio = ?
WHERE t.topic_show = ?
ORDER BY t.topic_shine DESC, t.topic_time DESC
LIMIT ??';
$topics = _rowset(sql_filter($sql, $bio->v('bio_id'), 1, 10));
} else {
$sql = 'SELECT t.topic_id, t.topic_alias, t.topic_title, h.highlight_class
FROM _board_topics t
INNER JOIN _board_forums f ON f.forum_id = t.topic_forum
LEFT JOIN _board_highlight h ON t.topic_highlight = h.highlight_id
WHERE t.topic_show = ?
ORDER BY t.topic_shine DESC, t.topic_time DESC
LIMIT ??';
$topics = _rowset(sql_filter($sql, 1, 10));
}
foreach ($topics as $i => $row) {
if (!$i) {
_style('board_topics');
}
_style('board_topics.row', _vs(array('ID' => $row['topic_id'], 'TITLE' => $row['topic_title'], 'CLASS' => $row['highlight_class']), 'TOPIC'));
}
if ($bio->v('auth_member')) {
// Messages
$sql = 'SELECT *
FROM _bio_messages
INNER JOIN _bio ON message_from = bio_id
INNER JOIN _bio_messages_type ON message_type = type_id
WHERE message_to = ?
AND message_active = ?
ORDER BY message_time DESC';
$messages = _rowset(sql_filter($sql, $bio->v('bio_id'), 1));
foreach ($messages as $i => $row) {
if (!$i) {
_style('messages');
}
_style('messages.row', array('U_MESSAGE' => _link(), '' => ''));
}
// Friend requests
$sql = 'SELECT b.bio_alias, b.bio_name
FROM _bio_friends
INNER JOIN _bio ON friend_assoc = bio_id
WHERE friend_bio = ?
AND friend_pending = ?
ORDER BY friend_time DESC';
$requests = _rowset(sql_filter($sql, $bio->v('bio_id'), 1));
foreach ($requests as $i => $row) {
if (!$i) {
_style('friend_request');
}
_style('friend_request.row', array('U_APPROVE' => _link('home', array('x1' => 'friend', 'x2' => 'approve', 'a' => $row['bio_alias'])), 'U_DENY' => _link('home', array('x1' => 'friend', 'x2' => 'deny', 'a' => $row['bio_alias'])), 'A' => _a($row), 'BIO_NAME' => $row['bio_name']));
}
}
// Banners
$this->announce('home');
return;
}
print <<<EOS
<table border='1' class='mmdata'>
EOS;
$keys = array_keys($row);
foreach ($keys as $key) {
print <<<EOS
<tr>
<th>{$key}</th>
<td class='l'>{$row[$key]}</td>
</tr>
EOS;
}
print <<<EOS
</table>
EOS;
}
### function }}}
if ($mode == 'view') {
pagehead();
$agid = $form['agid'];
ptitle("agents [id={$agid}]");
_view1();
pagetail();
exit;
}
pagehead();
_style();
ptitle('Agent List');
_listview();
pagetail();
exit;
