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>";
}
}
}
}
