function showsublinks($sep = "·", $class = "") { $sres = dbquery("SELECT link_window, link_visibility, link_url, link_name FROM " . DB_SITE_LINKS . "\n\t\tWHERE " . groupaccess('link_visibility') . " AND link_position>='2' AND link_url!='---' ORDER BY link_order ASC"); if (dbrows($sres)) { $i = 0; $res = "<ul>\n"; while ($sdata = dbarray($sres)) { $link_target = $sdata['link_window'] == "1" ? " target='_blank'" : ""; $li_class = $i == 0 ? " class='first-link" . ($class ? " {$class}" : "") . "'" : ($class ? " class='{$class}'" : ""); if (strstr($sdata['link_url'], "http://") || strstr($sdata['link_url'], "https://")) { $res .= "<li" . $li_class . ">" . $sep . "<a href='" . $sdata['link_url'] . "'{$link_target}><span>" . $sdata['link_name'] . "</span></a></li>\n"; } else { $res .= "<li" . $li_class . ">" . $sep . "<a href='" . BASEDIR . $sdata['link_url'] . "'{$link_target}><span>" . $sdata['link_name'] . "</span></a></li>\n"; } $i++; } if (iMEMBER) { $res .= "<li" . $li_class . ">" . $sep . "<a href='" . BASEDIR . "setuser.php?logout=yes'><span>Logout</span></a> </li>\n"; } else { $res .= "<li" . $li_class . ">" . $sep . "<a href='" . BASEDIR . "register.php'><span>Register</span></a> </li>\n"; } $res .= "</ul>\n"; return $res; } }
function LoadNote($player_id, $note_id) { global $db_prefix; $query = "SELECT * FROM " . $db_prefix . "notes WHERE owner_id = {$player_id} AND note_id = {$note_id} LIMIT 1"; $result = dbquery($query); return dbarray($result); }
function LoadUniverse() { global $db_prefix; $query = "SELECT * FROM " . $db_prefix . "uni;"; $result = dbquery($query); return dbarray($result); }
function flood_control($field, $table, $where) { global $userdata, $settings, $locale; $flood = false; if (!iSUPERADMIN && !iADMIN && (!defined("iMOD") || !iMOD)) { $result = dbquery("SELECT MAX(" . $field . ") AS last_post FROM " . $table . " WHERE " . $where); if (dbrows($result)) { $data = dbarray($result); if (time() - $data['last_post'] < $settings['flood_interval']) { $flood = true; $result = dbquery("INSERT INTO " . DB_FLOOD_CONTROL . " (flood_ip, flood_timestamp) VALUES ('" . USER_IP . "', '" . time() . "')"); if (dbcount("(flood_ip)", DB_FLOOD_CONTROL, "flood_ip='" . USER_IP . "'") > 4) { if (iMEMBER && $settings['flood_autoban'] == "1") { require_once INCLUDES . "sendmail_include.php"; require_once INCLUDES . "suspend_include.php"; $result = dbquery("UPDATE " . DB_USERS . " SET user_status='4', user_actiontime='0' WHERE user_id='" . $userdata['user_id'] . "'"); suspend_log($userdata['user_id'], 4, $locale['global_440'], true); $message = str_replace("[USER_NAME]", $userdata['user_name'], $locale['global_442']); sendemail($userdata['user_name'], $userdata['user_email'], $settings['siteusername'], $settings['siteemail'], $locale['global_441'], $message); } elseif (!iMEMBER) { $result = dbquery("INSERT INTO " . DB_BLACKLIST . " (blacklist_ip, blacklist_email, blacklist_reason) VALUES ('" . USER_IP . "', '', '" . $locale['global_440'] . "')"); } } } } } return $flood; }
function panels_list($panel_id = NULL) { $panel_list = ""; $result = dbquery("SELECT panel_id, panel_filename FROM " . DB_PANELS . " ORDER BY panel_id"); while ($data = dbarray($result)) { $panels[] = $data['panel_filename']; } $temp = opendir(INFUSIONS); while ($folder = readdir($temp)) { if (!in_array($folder, array(".", "..")) && strstr($folder, "_panel")) { if (is_dir(INFUSIONS . $folder)) { if (!in_array($folder, $panels)) { $panel_list[] = ucwords(str_replace('_', ' ', $folder)); } } } } closedir($temp); if ($panel_list > 0) { if (count($panel_list)) { sort($panel_list); } if ($panel_id != NULL) { $panel_name = $panel_list[$panel_id]; return $panel_name; } else { return $panel_list; } } }
/** * Get Single Blog Category Data * @param $id * @return array|bool */ public static function get_blogCatData($id) { if (self::validate_blogCat($id)) { return dbarray(dbquery("SELECT * FROM " . DB_BLOG_CATS . " WHERE blog_cat_id='" . intval($id) . "'")); } return FALSE; }
function sendemail_template($template_key, $subject, $message, $user, $receiver, $thread_url = "", $toemail, $sender = "", $fromemail = "") { global $settings; $data = dbarray(dbquery("SELECT * FROM " . DB_EMAIL_TEMPLATES . " WHERE template_key='" . $template_key . "' LIMIT 1")); $message_subject = $data['template_subject']; $message_content = $data['template_content']; $template_format = $data['template_format']; $sender_name = $sender != "" ? $sender : $data['template_sender_name']; $sender_email = $fromemail != "" ? $fromemail : $data['template_sender_email']; $subject_search_replace = array("[SUBJECT]" => $subject, "[SITENAME]" => $settings['sitename'], "[SITEURL]" => $settings['siteurl'], "[USER]" => $user, "[SENDER]" => $sender_name, "[RECEIVER]" => $receiver); $message_search_replace = array("[SUBJECT]" => $subject, "[SITENAME]" => $settings['sitename'], "[SITEURL]" => $settings['siteurl'], "[MESSAGE]" => $message, "[USER]" => $user, "[SENDER]" => $sender_name, "[RECEIVER]" => $receiver, "[THREAD_URL]" => $thread_url); foreach ($subject_search_replace as $search => $replace) { $message_subject = str_replace($search, $replace, $message_subject); } foreach ($message_search_replace as $search => $replace) { $message_content = str_replace($search, $replace, $message_content); } if ($template_format == "html") { $message_content = nl2br($message_content); } if (sendemail($receiver, $toemail, $sender_name, $sender_email, $message_subject, $message_content, $template_format)) { return TRUE; } else { return FALSE; } }
function showratings($rating_type, $rating_item_id, $rating_link) { global $locale, $userdata; $settings = \fusion_get_settings(); if ($settings['ratings_enabled'] == "1") { if (iMEMBER) { $d_rating = dbarray(dbquery("SELECT rating_vote,rating_datestamp FROM " . DB_RATINGS . " WHERE rating_item_id='" . $rating_item_id . "' AND rating_type='" . $rating_type . "' AND rating_user='******'user_id'] . "'")); if (isset($_POST['post_rating'])) { // Rate if (isnum($_POST['rating']) && $_POST['rating'] > 0 && $_POST['rating'] < 6 && !isset($d_rating['rating_vote'])) { $result = dbquery("INSERT INTO " . DB_RATINGS . " (rating_item_id, rating_type, rating_user, rating_vote, rating_datestamp, rating_ip, rating_ip_type) VALUES ('{$rating_item_id}', '{$rating_type}', '" . $userdata['user_id'] . "', '" . $_POST['rating'] . "', '" . time() . "', '" . USER_IP . "', '" . USER_IP_TYPE . "')"); if ($result) { defender::unset_field_session(); } } redirect($rating_link); } elseif (isset($_POST['remove_rating'])) { // Unrate $result = dbquery("DELETE FROM " . DB_RATINGS . " WHERE rating_item_id='{$rating_item_id}' AND rating_type='{$rating_type}' AND rating_user='******'user_id'] . "'"); if ($result) { defender::unset_field_session(); } redirect($rating_link); } } $ratings = array(5 => $locale['r120'], 4 => $locale['r121'], 3 => $locale['r122'], 2 => $locale['r123'], 1 => $locale['r124']); if (!iMEMBER) { $message = str_replace("[RATING_ACTION]", "<a href='" . BASEDIR . "login.php'>" . $locale['login'] . "</a>", $locale['r104']); if (fusion_get_settings("enable_registration") == TRUE) { $message = str_replace("[RATING_ACTION]", "<a href='" . BASEDIR . "login.php'>" . $locale['login'] . "</a> " . $locale['or'] . " <a href='" . BASEDIR . "register.php'>" . $locale['register'] . "</a>", $locale['r104']); } echo "<div class='text-center'>" . $message . "</div>\n"; } elseif (isset($d_rating['rating_vote'])) { echo "<div class='display-block'>\n"; echo openform('removerating', 'post', $rating_link, array('class' => 'display-block text-center')); echo sprintf($locale['r105'], $ratings[$d_rating['rating_vote']], showdate("longdate", $d_rating['rating_datestamp'])) . "<br /><br />\n"; echo form_button('remove_rating', $locale['r102'], $locale['r102'], array('class' => 'btn-default', 'icon' => 'fa fa-times m-r-10')); echo closeform(); echo "</div>\n"; } else { echo "<div class='display-block'>\n"; echo openform('postrating', 'post', $rating_link, array('max_tokens' => 1, 'notice' => 0, 'class' => 'm-b-20 text-center')); echo form_select('rating', $locale['r106'], '', array('options' => $ratings, 'class' => 'display-block text-center')); echo form_button('post_rating', $locale['r103'], $locale['r103'], array('class' => 'btn-primary btn-sm', 'icon' => 'fa fa-thumbs-up m-r-10')); echo closeform(); echo "</div>\n"; } $rating_votes = dbarray(dbquery("\n\t\tSELECT\n\t\tSUM(IF(rating_vote='5', 1, 0)) as r120,\n\t\tSUM(IF(rating_vote='4', 1, 0)) as r121,\n\t\tSUM(IF(rating_vote='3', 1, 0)) as r122,\n\t\tSUM(IF(rating_vote='2', 1, 0)) as r123,\n\t\tSUM(IF(rating_vote='1', 1, 0)) as r124\n\t\tFROM " . DB_RATINGS . " WHERE rating_type='" . $rating_type . "' and rating_item_id='" . intval($rating_item_id) . "'\n\t\t")); if (!empty($rating_votes)) { echo "<div id='ratings' class='rating_container'>\n"; foreach ($rating_votes as $key => $num) { echo progress_bar($num, $locale[$key], FALSE, '10px', TRUE, FALSE); } echo "</div>\n"; } else { echo "<div class='text-center'>" . $locale['r101'] . "</div>\n"; } } }
function EmailExist($email) { global $db_prefix; $email = mb_strtolower($email, 'UTF-8'); $query = "SELECT * FROM " . $db_prefix . "users WHERE (email = '" . $email . "' OR pemail = '" . $email . "')"; $result = dbquery($query); return dbarray($result); }
function Admin_Debug() { global $session; global $db_prefix; global $GlobalUser; if (method() === "POST") { $query = "SELECT * FROM " . $db_prefix . "debug ORDER BY date DESC, error_id DESC LIMIT 50"; $result = dbquery($query); $rows = dbrows($result); while ($rows--) { $msg = dbarray($result); if ($_POST["delmes" . $msg['error_id']] === "on" || $_POST['deletemessages'] === "deleteall") { $query = "DELETE FROM " . $db_prefix . "debug WHERE error_id = " . $msg['error_id']; dbquery($query); } } } $query = "SELECT * FROM " . $db_prefix . "debug ORDER BY date DESC, error_id DESC LIMIT 50"; $result = dbquery($query); ?> <?php echo AdminPanel(); ?> <table class='header'><tr class='header'><td><table width="519"> <form action="index.php?page=admin&session=<?php echo $session; ?> &mode=Debug" method="POST"> <tr><td colspan="4" class="c">Сообщения</td></tr> <tr><th>Действие</th><th>Дата</th><th>От</th><th>Браузер</th></tr> <?php $rows = dbrows($result); while ($rows--) { $msg = dbarray($result); $user = LoadUser($msg['owner_id']); $from = "<a href=\"index.php?page=admin&session={$session}&mode=Users&player_id=" . $msg['owner_id'] . "\">" . $user['oname'] . "</a> [" . $msg['ip'] . "]"; $msg['text'] = str_replace("{PUBLIC_SESSION}", $session, $msg['text']); echo "<tr><th><input type=\"checkbox\" name=\"delmes" . $msg['error_id'] . "\"/></th><th>" . date("m-d H:i:s", $msg['date']) . "</th><th>{$from} </th><th>" . $msg['agent'] . " </th></tr>\n"; echo "<tr><td class=\"b\"> </td><td class=\"b\" colspan=\"3\">" . $msg['text'] . "</td></tr>\n"; } ?> <tr><td class="b"> </td><td class="b" colspan="3"></td></tr> <tr><th colspan="4" style='padding:0px 105px;'></th></tr> <tr><th colspan="4"> <select name="deletemessages"> <option value="deletemarked">Удалить выделенные сообщения</option> <option value="deleteall">Удалить все сообщения</option> </select><input type="submit" value="ok" /></th></tr> <tr><td colspan="4"><center> </center></td></tr> </form> </table> <?php }
function fieldgenerator($db) { $cresult = dbquery("SHOW COLUMNS FROM {$db}"); $col_names = array(); while ($cdata = dbarray($cresult)) { $col_names[] = $cdata['Field']; } return (array) $col_names; }
private function _force_auth($user_id) { global $locale, $settings; $result = dbquery("\tSELECT * FROM " . DB_USERS . " WHERE user_id='" . $user_id . "' LIMIT 1"); if (dbrows($result) == 1) { $user = dbarray($result); ForceAuth::setUserCookie($user['user_id'], $user['user_salt'], $user['user_algo'], true, true); } }
function check_inf($infusion) { $title = dbarray(dbquery("SELECT inf_folder FROM " . DB_PREFIX . "infusions WHERE inf_folder='" . $infusion . "'")); if ($title) { return TRUE; } else { return FALSE; } }
public function UpdateChartVorwoche() { $this->platz(); while ($temp = dbarray($this->platz)) { //echo "Platz : " .$temp['chart_platz'] . " ID: " . $temp['chart_id'] . "<br>"; //echo "Sql : " . "UPDATE " . DB_CHARTS . " SET chart_vorwoche = ".$temp['chart_platz']. " WHERE chart_id = " . $temp['chart_id'] . "<br>"; $resvorw = dbquery("UPDATE " . DB_CHARTS . " SET chart_vorwoche = " . $temp['chart_platz'] . " WHERE chart_id = " . $temp['chart_id']); } return $resvorw; }
function read_session($session_id) { global $sess_read; $result = dbquery("SELECT session_data FROM " . DB_SESSIONS . " WHERE session_id='" . valid_session($session_id) . "'"); if (dbrows($result)) { $sess_read = dbarray($result); return $sess_read['session_data']; } else { return $sess_read = ""; } }
/** * Returns all photos inside the album into an array * @param $album_id */ function move_photos($album_id) { $result = dbquery("SELECT * FROM " . DB_PHOTOS . " WHERE album_id='" . $album_id . "'"); if (dbrows($result) > 0) { while ($photo_data = dbarray($result)) { rename(IMAGES . "photoalbum/album_" . $album_id . "/" . $photo_data['photo_filename'], INFUSIONS . "gallery/photos/" . $photo_data['photo_filename']); rename(IMAGES . "photoalbum/album_" . $album_id . "/" . $photo_data['photo_thumb1'], INFUSIONS . "gallery/photos/" . $photo_data['photo_thumb1']); rename(IMAGES . "photoalbum/album_" . $album_id . "/" . $photo_data['photo_thumb2'], INFUSIONS . "gallery/photos/" . $photo_data['photo_thumb2']); } } }
function delusersaction() { global $locale; opentable($locale['urg_a_dbmgnt_106']); if (isset($_POST['delusers']) && $_POST['delusers'] == '1') { $sql = dbquery("SELECT * FROM " . DB_UG3 . " WHERE owner_id NOT IN (SELECT user_id FROM " . DB_USERS . ")"); if (dbrows($sql) != 0) { //If this member doesn't exist opentable($locale['urg_a_dbmgnt_106']); while ($data = dbarray($sql)) { $deluser = dbquery("DELETE FROM " . DB_UG3 . " WHERE owner_id = '" . $data['owner_id'] . "'"); if ($deluser) { echo "<span style='color: green;'>" . sprintf($locale['urg_a_dbmgnt_109'], $data['owner_name'], $data['owner_id']) . "</span><br />\n"; } else { echo "<span style='color: red;'>" . sprintf($locale['urg_a_dbmgnt_110'], $data['owner_name'], $data['owner_id']) . "</span><br />\n"; } } //end closetable(); opentable($locale['urg_a_dbmgnt_107']); $sql2 = dbquery("SELECT * FROM " . DB_UG3_INVENTORY . " WHERE ownerid NOT IN (SELECT user_id FROM " . DB_USERS . ")"); while ($data2 = dbarray($sql2)) { $delinv = dbquery("DELETE FROM " . DB_UG3_INVENTORY . " WHERE ownerid = '" . $data2['ownerid'] . "'"); if ($delinv) { echo "<span style='color: green;'>" . sprintf($locale['urg_a_dbmgnt_111'], $data2['itemname'], $data2['ownerid']) . "</span><br />\n"; } else { echo "<span style='color: red;'>" . sprintf($locale['urg_a_dbmgnt_112'], $data2['itemname'], $data2['ownerid']) . "</span><br />\n"; } } //end closetable(); opentable($locale['urg_a_dbmgnt_108']); $sql3 = dbquery("SELECT * FROM " . DB_UG3_TRANSACTIONS . " WHERE transaction_user_id NOT IN (SELECT user_id FROM " . DB_USERS . ")"); while ($data3 = dbarray($sql3)) { $deltrans = dbquery("DELETE FROM " . DB_UG3_TRANSACTIONS . " WHERE transaction_user_id = '" . $data3['transaction_user_id'] . "'"); if ($deltrans) { echo "<span style='color: green;'>" . sprintf($locale['urg_a_dbmgnt_113'], $data3['transaction_id'], $data3['transaction_user_id']) . "</span><br />\n"; } else { echo "<span style='color: red;'>" . sprintf($locale['urg_a_dbmgnt_114'], $data3['transaction_id'], $data3['transaction_user_id']) . "</span><br />\n"; } } //end closetable(); } else { opentable($locale['urg_a_dbmgnt_115']); echo "<div>" . $locale['urg_a_dbmgnt_115'] . "</div>\n"; closetable; } } else { echo "<div>" . $locale['urg_a_dbmgnt_116'] . "</div>\n"; } closetable; }
function ExpUpperLimit() { global $db_prefix; $query = "SELECT * FROM " . $db_prefix . "users ORDER BY score1 DESC LIMIT 1"; $result = dbquery($query); if ($result) { $user = dbarray($result); if ($user['score1'] >= 5000000000.0) { return 12000; } } return 9000; }
function getparent($parentid, $title) { global $db_prefix; $result = dbquery("select * from " . $db_prefix . "kroax_kategori where cid={$parentid}"); $data = dbarray($result); if ($data['title'] != "") { $title = $data['title'] . " » " . $title; } if ($data['parentid'] != 0) { $title = getparent($data['parentid'], $title); } return $title; }
/** * SQL Delete Site Link Action * @param $link_id * @return bool|mixed|null|PDOStatement|resource */ public static function delete_sitelinks($link_id) { $result = NULL; if (isnum($link_id)) { $data = dbarray(dbquery("SELECT link_order FROM " . DB_SITE_LINKS . " " . (multilang_table("SL") ? "WHERE link_language='" . LANGUAGE . "' AND" : "WHERE") . " link_id='" . $_GET['link_id'] . "'")); $result = dbquery("UPDATE " . DB_SITE_LINKS . " SET link_order=link_order-1 " . (multilang_table("SL") ? "WHERE link_language='" . LANGUAGE . "' AND" : "WHERE") . " link_order>'" . $data['link_order'] . "'"); if ($result) { $result = dbquery("DELETE FROM " . DB_SITE_LINKS . " WHERE link_id='" . $_GET['link_id'] . "'"); } return $result; } return $result; }
function add_adminimages() { global $fusion_images, $_loaded_; if ($_loaded_['adminimages'] !== true) { $result = dbquery("SELECT admin_title, admin_image, admin_page FROM " . DB_ADMIN); $ac_images = array(); while ($data = dbarray($result)) { $ac_images["ac_" . $data['admin_page'] . $data['admin_title']] = $data['admin_image'] != "" && file_exists(ADMIN . "images/" . $data['admin_image']) ? ADMIN . "images/" . $data['admin_image'] : ADMIN . "images/infusion_panel.gif"; } $fusion_images = array_merge($fusion_images, $ac_images); $_loaded_['adminimages'] = true; } }
function prp_count_cats($cat) { global $prp; $count = 0; $res = dbquery("SELECT cat_id, cat_access" . " FROM " . DB_PRP_CATS . "" . " WHERE top_cat='" . $cat . "'"); while ($data = dbarray($res)) { if ($prp->settings['hide_cats'] && !checkgroup($data['cat_access'])) { continue; } $count += prp_count_cats($data['cat_id']) + 1; } return $count; }
function Admin_Browse() { global $session; global $db_prefix; global $GlobalUser; $query = "SELECT * FROM " . $db_prefix . "browse ORDER BY date DESC LIMIT 50"; $result = dbquery($query); AdminPanel(); $rows = dbrows($result); echo "Последняя история переходов (50 записей):<br>"; echo "<table>\n"; while ($rows--) { $log = dbarray($result); $user = LoadUser($log['owner_id']); ?> <tr><td><table> <tr> <th> <?php echo $user['oname']; ?> </th> <th> <?php echo $log['url']; ?> </th> </tr> <tr> <th rowspan=2> <?php echo $log['method']; ?> <br> <?php echo date("d M Y", $log['date']); ?> <br> <?php echo date("H:i:s", $log['date']); ?> </th> <th> <?php echo print_r(unserialize($log['getdata'])); ?> </th> </tr> <tr> <th> <?php echo print_r(unserialize($log['postdata'])); ?> </th> </tr> </table></td></tr> <?php } echo "</table>\n"; }
function ratings_forum($thread_id) { global $settings, $locale; $text = ""; if ($settings['forum_ratings'] && isnum($thread_id)) { $result = dbquery("SELECT SUM(rating_vote) AS sum, COUNT(rating_vote) AS count\r\n\t\tFROM " . DB_RATINGS . " WHERE rating_type='F' AND rating_item_id='" . (int) $thread_id . "'"); $data = dbarray($result); $rating = $data['count'] ? $data['sum'] / $data['count'] : 0; if ($rating > 0) { $rounded = round($rating); $text = "<img src='" . IMAGES . "ratings/" . $rounded . ".gif' alt='" . $locale['r130'] . $rounded . "' title='" . $locale['r130'] . round($rating, 2) . " " . sprintf($locale['r135'], $data['count']) . "' style='vertical-align:middle; border: 0;' />\n"; } } return $text; }
public static function get_attachments(array $thread_data) { $attachments = array(); if (self::get_attachment_permissions("can_download_attach") == TRUE) { $a_result = dbquery("SELECT * FROM " . DB_FORUM_ATTACHMENTS . " WHERE thread_id='" . intval($thread_data['thread_id']) . "' ORDER BY post_id ASC"); if (dbrows($a_result) > 0) { while ($a_data = dbarray($a_result)) { if (file_exists(INFUSIONS . "forum/attachments/" . $a_data['attach_name'])) { //$this->thread_info['attachments'][$a_data['post_id']][] = $a_data; $attachments[$a_data['post_id']][] = $a_data; } } } } return (array) $attachments; }
function prp_cat_has_child($cat, $child) { if ($cat == $child) { return true; } $query_id = dbquery("SELECT cat_id" . " FROM " . DB_PRP_CATS . "" . " WHERE top_cat='{$cat}'"); while ($data = dbarray($query_id)) { if ($data['cat_id'] == $child) { return true; } if (prp_cat_has_child($data['cat_id'], $child)) { return true; } } return false; }
function get_rating($id, $rtype) { $total = 0; $rows = 0; $sel = dbquery("SELECT rating_vote FROM " . DB_RATINGS . " WHERE rating_item_id='" . (int) $id . "' AND rating_type=" . _db($rtype)); if (dbrows($sel) != 0) { while ($data = dbarray($sel)) { $total = $total + $data['rating_vote']; $rows++; } return $total / $rows; } else { return '0'; } return '0'; }
function send_pm($to, $from, $subject, $message, $smileys = "y") { global $settings; include LOCALE . LOCALESET . "messages.php"; require_once INCLUDES . "sendmail_include.php"; require_once INCLUDES . "flood_include.php"; $msg_settings = dbarray(dbquery("SELECT pm_inbox, pm_email_notify FROM " . DB_MESSAGES_OPTIONS . " WHERE user_id='0'")); $smileys = preg_match("#(\\[code\\](.*?)\\[/code\\]|\\[geshi=(.*?)\\](.*?)\\[/geshi\\]|\\[php\\](.*?)\\[/php\\])#si", $message) ? "n" : $smileys; $error = 0; if (!flood_control("message_datestamp", DB_MESSAGES, "message_from='" . $from . "'")) { $result = dbquery("SELECT u.user_id, u.user_name, u.user_email, u.user_level, mo.pm_email_notify, COUNT(message_id) as message_count FROM " . DB_USERS . " u\n\t\t\tLEFT JOIN " . DB_MESSAGES_OPTIONS . " mo USING(user_id)\n\t\t\tLEFT JOIN " . DB_MESSAGES . " ON message_to=u.user_id AND message_folder='0'\n\t\t\tWHERE u.user_id='{$to}' GROUP BY u.user_id"); if (dbrows($result)) { $data = dbarray($result); $result = dbquery("SELECT user_id, user_name FROM " . DB_USERS . " WHERE user_id='" . $from . "'"); if (dbrows($result)) { $userdata = dbarray($result); if ($to != $from) { if ($data['user_id'] == 1 || $data['user_level'] > 101 || $msg_settings['pm_inbox'] == "0" || $data['message_count'] + 1 <= $msg_settings['pm_inbox']) { $result = dbquery("INSERT INTO " . DB_MESSAGES . " (message_to, message_from, message_subject, message_message, message_smileys, message_read, message_datestamp, message_folder) VALUES('" . $data['user_id'] . "','" . $userdata['user_id'] . "','" . $subject . "','" . $message . "','" . $smileys . "','0','" . time() . "','0')"); $message_content = str_replace("[SUBJECT]", $subject, $locale['626']); $message_content = str_replace("[USER]", $userdata['user_name'], $message_content); $send_email = isset($data['pm_email_notify']) ? $data['pm_email_notify'] : $msg_settings['pm_email_notify']; if ($send_email == "1") { sendemail($data['user_name'], $data['user_email'], $settings['siteusername'], $settings['siteemail'], $locale['625'], $data['user_name'] . $message_content); } } else { // Inbox is full $error = 1; } } else { // Reciever and sender are the same user $error = 2; } } else { // Sender does not exist in DB $error = 3; } } else { // Reciever does not exist in DB $error = 4; } } else { // Floodcontrol exceeded $error = 5; } return $error; }
function GalaxyToolUpdateAllyStats() { global $db_prefix; $list = array(); $query = "SELECT * FROM " . $db_prefix . "ally ORDER BY ally_id ASC"; $result = dbquery($query); $rows = dbrows($result); while ($rows--) { $ally = dbarray($result); $list[$ally['ally_id']] = array(); $list[$ally['ally_id']]['name'] = $ally['tag']; } $text = serialize($list); $f = fopen("galaxytool/ally_statistics.txt", "w"); fwrite($f, $text); fclose($f); }
function whoishere_show($forum_place, $id, $tr = false) { global $locale; if ($forum_place == "index" || $forum_place == "forum") { $res = dbquery("SELECT " . DB_FORUM_OBSERVER . ".user_id, forum_id, thread_id, user_name, user_level FROM " . DB_FORUM_OBSERVER . "\r\n\t\t\tLEFT JOIN " . DB_USERS . " ON " . DB_USERS . ".user_id = " . DB_FORUM_OBSERVER . ".user_id\r\n\t\t\tWHERE forum_id='" . (int) $id . "'"); $guests = 0; $members = array(); while ($data = dbarray($res)) { if (empty($data['user_name'])) { $guests++; } else { $members[] = array("user_id" => $data['user_id'], "user_name" => $data['user_name'], "user_level" => $data['user_level']); } } $whoishere = user_list($guests, $members); if ($forum_place == "index" && $whoishere) { echo "<span class='small'><strong>" . $locale['wih100'] . "</strong> {$whoishere}</span><br />"; } elseif ($forum_place == "forum" && $whoishere) { if ($tr) { echo "<td><strong>" . $locale['wih100'] . "</strong> {$whoishere}</td>"; } else { echo "<div style='padding: 5px;'><strong>" . $locale['wih100'] . "</strong> {$whoishere}</div>"; } } } elseif ($forum_place == "thread") { $res = dbquery("SELECT " . DB_FORUM_OBSERVER . ".user_id, forum_id, thread_id, user_name, user_level FROM " . DB_FORUM_OBSERVER . "\r\n\t\t\tLEFT JOIN " . DB_USERS . " ON " . DB_USERS . ".user_id = " . DB_FORUM_OBSERVER . ".user_id\r\n\t\t\tWHERE thread_id='" . (int) $_GET['thread_id'] . "'"); $guests = 0; $members = array(); while ($data = dbarray($res)) { if (empty($data['user_name'])) { $guests++; } else { $members[] = array("user_id" => $data['user_id'], "user_name" => $data['user_name'], "user_level" => $data['user_level']); } } $whoishere = user_list($guests, $members); if ($whoishere) { if ($tr) { echo "<td>" . $locale['wih100'] . " {$whoishere}</td>"; } else { echo "<div style='padding: 5px;'>" . $locale['wih100'] . " {$whoishere}</div>"; } } } }