public function _home() { global $config, $cache; if (!_button()) { $sql = 'SELECT ub, name FROM _artists ORDER BY name'; return _rowset_style($sql, 'artists'); } $name = request_var('name', ''); $sql = 'SELECT * FROM _artists WHERE name = ?'; if (!$a_data = sql_fieldrow(sql_filter($sql, $name))) { fatal_error(); } $sql = 'SELECT m.user_id, m.user_email FROM _artists_auth a, _members m WHERE a.ub = ? AND a.user_id = m.user_id'; $result = sql_rowset(sql_filter($sql, $a_data['ub'])); $mods = w(); foreach ($result as $row) { $mods[] = $row['user_id']; } if (count($mods)) { foreach ($mods as $i => $each) { $sql = 'SELECT COUNT(user_id) AS total FROM _artists_auth WHERE user_id = ?'; $total = sql_field(sql_filter($sql, $each), 'total', 0); if ($total > 1) { unset($mods[$i]); } } } if (count($mods)) { $sql = 'UPDATE _members SET user_auth_control = 0 WHERE user_id IN (??)'; $d_sql[] = sql_filter($sql, _implode(',', $mods)); } $ary_sql = array( 'DELETE FROM _artists WHERE ub = ?', 'DELETE FROM _artists_auth WHERE ub = ?', 'DELETE FROM _artists_fav WHERE ub = ?', 'DELETE FROM _artists_images WHERE ub = ?', 'DELETE FROM _artists_log WHERE ub = ?', 'DELETE FROM _artists_lyrics WHERE ub = ?', 'DELETE FROM _artists_posts WHERE post_ub = ?', 'DELETE FROM _artists_stats WHERE ub = ?', 'DELETE FROM _artists_viewers WHERE ub = ?', 'DELETE FROM _artists_voters WHERE ub = ?', 'DELETE FROM _artists_votes WHERE ub = ?', 'DELETE FROM _forum_topics WHERE topic_ub = ?', 'DELETE FROM _dl WHERE ub = ?' ); $d_sql = sql_filter($ary_sql, $a_data['ub']); $sql = 'SELECT topic_id FROM _forum_topics WHERE topic_ub = ?'; if ($topics = sql_rowset(sql_filter($sql, $a_data['ub']), false, 'topic_id')) { $d_sql[] = sql_filter('DELETE FROM _forum_posts WHERE topic_id IN (??)', _implode(',', $topics)); } $sql = 'SELECT id FROM _dl WHERE ub = ?'; if ($downloads = sql_rowset(sql_filter($sql, $a_data['ub']), false, 'id')) { $ary_sql = array( 'DELETE FROM _dl_fav WHERE dl_id IN (??)', 'DELETE FROM _dl_posts WHERE download_id IN (??)', 'DELETE FROM _dl_vote WHERE ud IN (??)', 'DELETE FROM _dl_voters WHERE ud IN (??)' ); $d_sql = array_merge($d_sql, sql_filter($ary_sql, _implode(',', $downloads))); } if (!_rm($config['artists_path'] . $a_data['ub'])) { _pre('Error al eliminar directorio de artista.', true); } sql_query($d_sql); // Cache $cache->delete('ub_list a_last_images'); redirect(s_link('a')); }
private function remove() { $v = _request(array('event' => 0)); if (_empty($v)) { return; } $sql = 'SELECT * FROM _events WHERE id = ?'; if (!$row = sql_fieldrow(sql_filter($sql, $event))) { _pre('El evento no existe.', true); } $e_artist = explode(nr(), $artist); foreach ($e_artist as $row) { $subdomain = get_subdomain($row); $sql = 'SELECT * FROM _artists WHERE subdomain = ?'; if ($a_row = sql_fieldrow(sql_filter($sql, $subdomain))) { $sql = 'DELETE FROM _artists_events WHERE a_artist = ? AND a_event = ?'; sql_query(sql_filter($sql, $a_row['ub'], $event)); } } return redirect(s_link('events', $row['event_alias'])); }
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() { /* $sql = 'SELECT * FROM _store WHERE store_field = 4 ORDER BY store_value'; $countries = _rowset($sql); foreach ($countries as $row) { $sv = ucwords(_rm_acute($row['store_value'])); $sql = 'UPDATE _store SET store_value = ? WHERE store_id = ?'; _sql(sql_filter($sql, $sv, $row['store_id'])); } */ $sql = 'SELECT DISTINCT store_value FROM _store WHERE store_field = 4 ORDER BY store_value'; $countries = _rowset($sql, 'store_value'); _pre($countries, true); $this->e(''); return; }
public function _home() { global $config, $user, $cache; if (!_button()) { return false; } $topic = request_var('topic', 0); $important = request_var('important', 0); $sql = 'SELECT * FROM _forum_topics WHERE topic_id = ?'; if (!$topicdata = sql_fieldrow(sql_filter($sql, $topic))) { fatal_error(); } $sql_important = ($important) ? ', topic_important = 1' : ''; $sql = 'UPDATE _forum_topics SET topic_color = ?, topic_announce = 1' . $sql_important . ' WHERE topic_id = ?'; sql_query(sql_filter($sql, 'E1CB39', $topic)); return _pre('El tema <strong>' . $topicdata['topic_title'] . '</strong> ha sido anunciado.', true); }
public function _home() { global $config, $user, $cache; if (!_button()) { return false; } $topic_id = request_var('topic_id', 0); if (!$topic_id) { fatal_error(); } $sql = 'SELECT * FROM _forum_topics WHERE topic_id = ?'; if (!$data = sql_fieldrow(sql_filter($sql, $topic_id))) { fatal_error(); } $title = ucfirst(strtolower($data['topic_title'])); $sql = 'UPDATE _forum_topics SET topic_title = ? WHERE topic_id = ?'; sql_query(sql_filter($sql, $title, $topic_id)); return _pre($data['topic_title'] . ' > ' . $title, true); }
public function _home() { global $config, $user, $cache; sql_truncate('_smilies'); $emoticon_path = $config['assets_path'] . 'emoticon/'; $process = 0; $fp = @opendir($emoticon_path); while ($file = @readdir($fp)) { if (preg_match('#([a-z0-9]+)\.(gif|png)#is', $file, $part)) { $insert = array( 'code' => ':' . $part[1] . ':', 'smile_url' => $part[0] ); sql_insert('smilies', $insert); $process++; } } @closedir($fp); $cache->delete('smilies'); return _pre($process . ' emoticons.'); }
public function _home() { global $config, $user, $cache; if (!_button()) { return false; } $username = request_var('username', ''); $password = request_var('password', ''); $username = get_username_base($username); $sql = 'SELECT user_id, username FROM _members WHERE username_base = ?'; if (!$userdata = sql_fieldrow(sql_filter($sql, $username))) { fatal_error(); } $sql = 'UPDATE _members SET user_password = ? WHERE user_id = ?'; sql_query(sql_filter($sql, HashPassword($password), $userdata['user_id'])); return _pre('La contraseña de ' . $userdata['username'] . ' fue actualizada.', true); }
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; if (!_button()) { return false; } $username = request_var('username', ''); if (empty($username)) { fatal_error(); } $username = get_username_base($username); $sql = 'SELECT user_id FROM _members WHERE username_base = ?'; if (!$row = sql_fieldrow(sql_filter($sql, $username))) { fatal_error(); } $sql = 'DELETE FROM _members_unread WHERE user_id = ? AND element <> ?'; sql_query(sql_filter($sql, $row['user_id'], 16)); return _pre('Deleted', true); }
public function _home() { global $config, $user, $cache; if (!_button()) { return false; } $username = request_var('username', ''); $username = get_username_base($username); $sql = 'SELECT * FROM _members WHERE username_base = ?'; if (!$userdata = sql_fieldrow(sql_filter($sql, $username))) { fatal_error(); } $ary_sql = array( 'DELETE FROM _members WHERE user_id = ?', 'DELETE FROM _banlist WHERE ban_userid = ?', 'DELETE FROM _members_group WHERE user_id = ?', 'DELETE FROM _members_iplog WHERE log_user_id = ?', 'DELETE FROM _members_ref_invite WHERE invite_uid = ?', 'DELETE FROM _members_unread WHERE user_id = ?', 'DELETE FROM _poll_voters WHERE vote_user_id = ?', 'DELETE FROM _artists_auth WHERE user_id = ?', 'DELETE FROM _artists_viewers WHERE user_id = ?', 'DELETE FROM _artists_voters WHERE user_id = ?', 'DELETE FROM _dl_voters WHERE user_id = ?', 'UPDATE _members_posts SET poster_id = 1 WHERE poster_id = ?', 'UPDATE _news_posts SET poster_id = 1 WHERE poster_id = ?', 'UPDATE _artists_posts SET poster_id = 1 WHERE poster_id = ?', 'UPDATE _dl_posts SET poster_id = 1 WHERE poster_id = ?', 'UPDATE _events_posts SET poster_id = 1 WHERE poster_id = ?', 'UPDATE _forum_posts SET poster_id = 1 WHERE poster_id = ?', 'UPDATE _forum_topics SET topic_poster = 1 WHERE topic_poster = ?' ); $sql = w(); foreach ($ary_sql as $row) { $sql[] = sql_filter($row, $userdata['user_id']); } $ary_sql = array( 'DELETE FROM _members_ban WHERE user_id = ? OR banned_user = ?', 'DELETE FROM _members_friends WHERE user_id = ? OR buddy_id = ?', 'DELETE FROM _members_ref_assoc WHERE ref_uid = ? OR ref_orig = ?', 'DELETE FROM _members_viewers WHERE viewer_id = ? OR user_id = ?', ); foreach ($ary_sql as $row) { $sql[] = sql_filter($row, $userdata['user_id'], $userdata['user_id']); } sql_query($sql); return _pre('El registro de <strong>' . $userdata['username'] . '</strong> fue eliminado.', true); }
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 $config, $user, $cache; if (!_button()) { return false; } $username1 = request_var('username1', ''); $username2 = request_var('username2', ''); if (empty($username1) || empty($username2)) { fatal_error(); } $username_base1 = get_username_base($username1); $username_base2 = get_username_base($username2); $sql = 'SELECT * FROM _members WHERE username_base = ?'; if (!$userdata = sql_fieldrow(sql_filter($sql, $username_base1))) { _pre('El usuario no existe.', true); } $sql = 'SELECT * FROM _members WHERE username_base = ?'; if ($void = sql_fieldrow(sql_filter($sql, $username_base2))) { _pre('El usuario ya existe.', true); } // $sql = 'UPDATE _members SET username = ?, username_base = ? WHERE user_id = ?'; sql_query(sql_filter($sql, $username2, $username_base2, $userdata['user_id'])); $emailer = new emailer(); $emailer->from('info'); $emailer->use_template('username_change', $config['default_lang']); $emailer->email_address($userdata['user_email']); $emailer->assign_vars(array( 'USERNAME' => $userdata['username'], 'NEW_USERNAME' => $username2, 'U_USERNAME' => s_link('m', $username_base2)) ); $emailer->send(); $emailer->reset(); redirect(s_link('m', $username_base2)); return; }
public function _home() { global $config, $user, $cache; if (!_button()) { return false; } $msg_id = request_var('msg_id', 0); $sql = 'SELECT * FROM _members_posts WHERE post_id = ?'; if (!$d = sql_fieldrow(sql_filter($sql, $msg_id))) { fatal_error(); } $sql = 'DELETE FROM _members_posts WHERE post_id = ?'; sql_query(sql_filter($sql, $msg_id)); $sql = 'UPDATE _members SET userpage_posts = userpage_posts - 1 WHERE user_id = ?'; sql_query(sql_filter($sql, $d['userpage_id'])); if (_button('user')) { $sql = 'SELECT ban_id FROM _banlist WHERE ban_userid = ?'; if (!$row = sql_fieldrow(sql_filter($sql, $d['poster_id']))) { sql_insert('banlist', array('ban_userid' => $d['poster_id'])); } } if (_button('ip')) { $sql = 'SELECT ban_id FROM _banlist WHERE ban_ip = ?'; if (!$row = sql_fieldrow(sql_filter($sql, $d['post_ip']))) { $sql_insert = array( 'ban_ip' => $d['post_ip'] ); sql_insert('banlist', $sql_insert); } } return _pre($d, true); }
public function _home() { global $config, $user, $cache; if (!_button()) { return false; } $userid = request_var('uid', 0); $username = request_var('username', ''); $email = request_var('email', ''); if (empty($username) && empty($email) && !$userid) { fatal_error(); } if (!empty($email)) { $sql = 'SELECT * FROM _members WHERE user_email = ?'; $sql = sql_filter($sql, $email); } else if ($userid) { $sql = 'SELECT * FROM _members WHERE user_id = ?'; $sql = sql_filter($sql, $userid); } else { $sql = 'SELECT * FROM _members WHERE username_base = ?'; $sql = sql_filter($sql, get_username_base($username)); } if (!$userdata = sql_fieldrow($sql)) { fatal_error(); } foreach ($userdata as $k => $void) { if (preg_match('#\d+#is', $k)) { unset($userdata[$k]); } } return _pre($userdata, true); }
protected function _migrate_home() { $sql = 'SELECT * FROM _members WHERE user_id > 1 ORDER BY user_id'; $members = sql_rowset($sql); foreach ($members as $row) { foreach ($row as $k => $v) { if (is_null($v)) { $row->{$k} = ''; } } $sql_insert = array('bio_type' => $row->user_type, 'bio_level' => $row->user_level, 'bio_active' => $row->user_active, 'bio_alias' => $row->username_base, 'bio_name' => $row->username, 'bio_first' => '', 'bio_last' => '', 'bio_key' => $row->user_password, 'bio_address' => $row->user_email, 'bio_gender' => $row->user_gender, 'bio_birth' => $row->user_birthday, 'bio_birthlast' => $row->user_birthday_last, 'bio_regip' => $row->user_regip, 'bio_regdate' => $row->user_regdate, 'bio_session_time' => $row->user_session_time, 'bio_lastpage' => $row->user_lastpage, 'bio_timezone' => $row->user_timezone, 'bio_dst' => $row->user_dst, 'bio_dateformat' => $row->user_dateformat, 'bio_lang' => $row->user_lang, 'bio_country' => $row->user_country, 'bio_avatar' => $row->user_avatar, 'bio_actkey' => '', 'bio_recovery' => '', 'bio_fails' => $row->user_login_tries); $sql = 'INSERT INTO _bio' . sql_build('INSERT', $sql_insert); sql_query($sql); } return _pre('OK.', true); }
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, $cache; if (!_button()) { return false; } $username = request_var('username', ''); $username = get_username_base($username); $sql = 'SELECT user_id, username FROM _members WHERE username_base = ?'; if (!$userdata = sql_fieldrow(sql_filter($sql, $username))) { fatal_error(); } $sql = 'UPDATE _members SET user_send_mass = 0 WHERE user_id = ?'; sql_query(sql_filter($sql, $userdata['user_id'])); return _pre('El usuario ' . $userdata['username'] . ' no recibira email masivo.'); }
public function _home() { global $config, $user, $cache; if (!_button()) { return false; } $username = request_var('username', ''); $username = get_username_base($username); $sql = 'SELECT user_id, username FROM _members WHERE username_base = ?'; if (!$userdata = sql_fieldrow(sql_filter($sql, $username))) { fatal_error(); } $sql = 'UPDATE _members SET user_sig = ? WHERE user_id = ?'; sql_query(sql_filter($sql, '', $userdata['user_id'])); return _pre('La firma de ' . $userdata['username'] . ' ha sido borrada.', true); }
public function _home() { global $config, $user, $cache; if (!_button()) { return false; } $topic = request_var('topic', 0); $title = request_var('title', ''); $sql = 'SELECT * FROM _forum_topics WHERE topic_id = ?'; if (!$topicdata = sql_fieldrow(sql_filter($sql, $topic))) { fatal_error(); } $sql = 'UPDATE _forum_topics SET topic_title = ? WHERE topic_id = ?'; sql_query(sql_filter($sql, $title, $topic)); return _pre('El titulo del tema <strong>' . $topicdata['topic_title'] . '</strong> ha sido cambiado por <strong>' . $title . '</strong>.', true); }
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); }
public function _home() { global $config, $user, $cache; if (!_button()) { return false; } $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_locked = ? WHERE topic_id = ?'; sql_query(sql_filter($sql, !$topicdata['topic_locked'], $topic)); _pre('El tema <strong>' . $topicdata['topic_title'] . '</strong> ha sido ' . (($topicdata['topic_locked']) ? 'abierto' : 'cerrado'), true); return; }
$subdomain = get_username_base($row['vote_option_text']); echo '<h1>' . ucwords($subdomain) . '</h1><br /><blockquote>'; $sql = 'SELECT * FROM _artists WHERE subdomain = ?'; $row3 = sql_fieldrow(sql_filter($sql, $subdomain)); $sql = 'SELECT m.username, m.user_email FROM _artists_auth a, _members m WHERE a.ub = ' . (int) $row3['ub'] . ' AND a.user_id = m.user_id ORDER BY username'; $result4 = sql_rowset(sql_filter($sql, $row3['ub'])); $ii = 0; foreach ($result4 as $row4) { echo (($ii) ? ', ' : '') . $row4['username'] . ' <' . $row4['user_email'] . '>'; $ii++; } echo '</blockquote>'; } echo '</blockquote>'; } _pre('', true); ?>
foreach ($fix as $fixrow) { $fixpart = explode(':', $fixrow); if ($part[1] == $fixpart[0]) { $_new = $part[0] . '@' . $fixpart[1]; $sql = 'UPDATE _members SET user_email = ? WHERE user_id = ?'; sql_query(sql_filter($sql, $_new, $row['user_id'])); $part[1] = $fixpart[1]; } } if (!isset($groups[$part[1]])) { $groups[$part[1]] = 0; } switch ($part[1]) { case 'rockrepublik.net': case 'rockrepublik.com': $rk[$part[1]][] = $row['username'] . ' ' . $row['user_email'] . ' ' . $row['user_public_email']; break; } $groups[$part[1]]++; } _pre($rk); _pre($groups);
protected function _cdate_home() { return _pre(date('j F Y H:i:s', time()), true); }
public function _home() { global $config, $user, $cache; if (!_button()) { $sql = 'SELECT * FROM _team ORDER BY team_name'; $result = sql_rowset($sql); foreach ($result as $i => $row) { if (!$i) _style('team'); _style('team.row', array( 'TEAM_ID' => $row['team_id'], 'TEAM_NAME' => $row['team_name']) ); } return false; } $team = request_var('team', 0); $username = request_var('username', ''); $username = get_username_base($username); $realname = request_var('realname', ''); $ismod = request_var('ismod', 0); $sql = 'SELECT * FROM _team WHERE team_id = ?'; if (!$teamd = sql_fieldrow(sql_filter($sql, $team))) { fatal_error(); } $sql = 'SELECT user_id, username FROM _members WHERE username_base = ?'; if (!$userdata = sql_fieldrow(sql_filter($sql, $username))) { fatal_error(); } $insert = true; $sql = 'SELECT * FROM _team_members WHERE team_id = ? AND member_id = ?'; if ($row = sql_fieldrow(sql_filter($sql, $team, $userdata['user_id']))) { if ($ismod && !$row['member_mod']) { $sql = 'UPDATE _team_members SET member_mod = 1 WHERE team_id = ? AND member_id = ?'; sql_query(sql_filter($sql, $team, $userdata['user_id'])); } $insert = false; } if ($insert) { $insert = array( 'team_id' => $team, 'member_id' => $userdata['user_id'], 'real_name' => $realname, 'member_mod' => $ismod ); sql_insert('team_members', $insert); } $cache->delete('team team_all team_members team_mod team_radio team_colab'); return _pre('El usuario <strong>' . $userdata['username'] . '</strong> fue agregado al grupo <strong>' . $teamd['team_name'] . '</strong>.', true); }
public function _home() { global $config, $user, $cache; $user_id = request_var('uid', 0); if (_button() || $user_id) { $username = request_var('username', ''); $user_email = request_var('user_email', ''); if ($user_id) { $sql = 'SELECT * FROM _members WHERE user_id = '; $sql = sql_filter($sql, $user_id); } else if (!empty($username)) { $username = get_username_base($username); $sql = 'SELECT * FROM _members WHERE username_base = ?'; $sql = sql_filter($sql, $username); } else { $sql = 'SELECT * FROM _members WHERE user_email = ?'; $sql = sql_filter($sql, $user_email); } if (!$userdata = sql_fieldrow($sql)) { exit; } // $user_id = $userdata['user_id']; $sql = 'UPDATE _members SET user_type = ? WHERE user_id = ?'; sql_query(sql_filter($sql, USER_NORMAL, $user_id)); $sql = 'DELETE FROM _crypt_confirm WHERE crypt_code = ? AND crypt_userid = ?'; sql_query(sql_filter($sql, $code, $user_id)); $emailer = new emailer(); $emailer->from('info'); $emailer->use_template('user_welcome_confirm'); $emailer->email_address($userdata['user_email']); $emailer->assign_vars(array( 'USERNAME' => $userdata['username']) ); $emailer->send(); $emailer->reset(); _pre('La cuenta de <strong>' . $userdata['username'] . '</strong> ha sido activada.', true); } $sql = 'SELECT * FROM _members WHERE user_type = 1 ORDER BY username'; $result = sql_rowset($sql); foreach ($result as $i => $row) { if (!$i) _style('list'); _style('list.row', array( 'LINK' => s_link($this->name, $row['user_id']), 'USERNAME' => $row['username'], 'EMAIL' => $row['user_email'], 'DATE' => $row['user_regdate'], 'IP' => $row['user_regip']) ); } return; }
public function _home() { global $config, $user, $cache, $upload, $comments; if (_button()) { $cat_id = request_var('cat_id', 0); $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); } $post_message = $comments->prepare($post_message); $post_desc = $comments->prepare($post_desc); $news_alias = friendly($post_subject); // $sql_insert = array( 'news_fbid' => '', 'cat_id' => $cat_id, 'news_active' => 1, 'news_alias' => $news_alias, 'post_reply' => 0, 'post_type' => 0, 'poster_id' => $user->d('id'), 'post_subject' => $post_subject, 'post_text' => $post_message, 'post_desc' => $post_desc, 'post_views' => 0, 'post_replies' => 0, 'post_time' => time(), 'post_ip' => $user->ip, 'image' => 0 ); $sql = 'INSERT _news' . sql_build('INSERT', $sql_insert); $news_id = sql_query_nextid($sql); // Upload news thumbnail $send = $upload->process($config['news_path'], 'thumbnail'); if (count($this->error)) { $error = array_merge($error, $this->error); return; } if ($send !== false) { foreach ($send as $row) { $resize = $upload->resize($row, $config['news_path'], $config['news_path'], $news_id, array(100, 100), false, false, true); if ($resize === false) { continue; } } } $cache->delete('news'); redirect(s_link('news', $news_alias)); } $sql = 'SELECT cat_id, cat_name FROM _news_cat ORDER BY cat_order'; $news_cat = sql_rowset($sql); foreach ($news_cat as $i => $row) { if (!$i) _style('cat'); _style('cat.row', array( 'CAT_ID' => $row['cat_id'], 'CAT_NAME' => $row['cat_name']) ); } 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; }
public function _home() { global $config, $user, $cache; if (!_button()) { return false; } $orig = request_var('orig', ''); $repl = request_var('repl', ''); $total_1 = $total_2 = $total_3 = 0; $sql = "SELECT * FROM _forum_posts WHERE post_text LIKE '%??%' ORDER BY post_id"; $result = sql_rowset(sql_filter($sql, $orig)); foreach ($result as $row) { $row['post_text'] = str_replace($orig, $repl, $row['post_text']); $sql = 'UPDATE _forum_posts SET post_text = ? WHERE post_id = ?'; sql_query(sql_filter($sql, $row['post_text'], $row['post_id'])); $total_1++; } // $sql = "SELECT * FROM _artists_posts WHERE post_text LIKE '%??%' ORDER BY post_id"; $result = sql_rowset(sql_filter($sql, $orig)); foreach ($result as $row) { $row['post_text'] = str_replace($orig, $repl, $row['post_text']); $sql = 'UPDATE _artists_posts SET post_text = ? WHERE post_id = ?'; sql_query(sql_filter($sql, $row['post_text'], $row['post_id'])); $total_2++; } // $sql = "SELECT * FROM _members_posts WHERE post_text LIKE '%??%' ORDER BY post_id"; $result = sql_rowset(sql_filter($sql, $orig)); foreach ($result as $row) { $row['post_text'] = str_replace($orig, $repl, $row['post_text']); $sql = 'UPDATE _members_posts SET post_text = ? WHERE post_id = ?'; sql_query(sql_filter($sql,$row['post_text'], $row['post_id'])); $total_3++; } return _pre('La frase <strong>' . $orig . '</strong> fue reemplazada por <strong>' . $repl . '</strong> en ' . $total_1 . ' f, ' . $total_2 . ' a, ' . $total_3 . ' m.', true); }