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;