Reply to thread

Message

<blockquote data-quote="Diddy" data-source="post: 193677" data-attributes="member: 5596">Sorry&nbsp;[CODE]&lt;?php/*=======================================================================| UberCMS - Advanced Website and Content Management System for uberEmu| #######################################################################| Copyright (c) 2010, Roy 'Meth0d'| http://www.meth0d.org| #######################################################################| This program is free software: you can redistribute it and/or modify| it under the terms of the GNU General Public License as published by| the Free Software Foundation, either version 3 of the License, or| (at your option) any later version.| #######################################################################| This program is distributed in the hope that it will be useful,| but WITHOUT ANY WARRANTY; without even the implied warranty of| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the| GNU General Public License for more details.\======================================================================*/&nbsp;class uberUsers{&nbsp; /**************************************************************************************************/&nbsp;&nbsp; private $userCache = Array();&nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; private $blockedNames = Array('roy', 'meth0d', 'method', 'graph1x', 'graphix', 'admin', 'administrator',&nbsp; &nbsp; 'mod', 'moderator', 'guest', 'undefined');&nbsp; private $blockedNameParts = Array('moderate', 'staff', 'manage', 'system', 'admin', 'uber');&nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; public function IsValidEmail($email = '')&nbsp; {&nbsp; &nbsp; return preg_match(&quot;/^[a-z0-9_\.-]+@([a-z0-9]+([\-]+[a-z0-9]+)*\.)+[a-z]{2,7}$/i&quot;, $email);&nbsp; }&nbsp;&nbsp; public function IsValidName($nm = '')&nbsp; {&nbsp; &nbsp; if (preg_match('/^[a-z0-9]+$/i', $nm) &amp;&amp; strlen($nm) &gt;= 1 &amp;&amp; strlen($nm) &lt;= 32)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; return false;&nbsp; }&nbsp;&nbsp; public function IsNameTaken($nm = '')&nbsp; {&nbsp; &nbsp; return ((mysql_num_rows(dbquery(&quot;SELECT null FROM users WHERE username = '&quot; . $nm . &quot;' LIMIT 1&quot;)) &gt; 0) ? true : false);&nbsp; }&nbsp;&nbsp; public function IdExists($id = 0)&nbsp; {&nbsp; &nbsp; return ((mysql_num_rows(dbquery(&quot;SELECT null FROM users WHERE id = '&quot; . $id . &quot;' LIMIT 1&quot;)) &gt; 0) ? true : false);&nbsp; }&nbsp;&nbsp; public function IsNameBlocked($nm = '')&nbsp; { &nbsp; &nbsp; foreach ($this-&gt;blockedNames as $bl)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; if (strtolower($nm) == strtolower($bl))&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; foreach ($this-&gt;blockedNameParts as $bl)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; if (strpos(strtolower($nm), strtolower($bl)) !== false)&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; return false;&nbsp; } &nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; function Add($username = '', $passwordHash = '', $email = 'default@localhost', $rank = '2', $figure = '', $sex = 'M')&nbsp; {&nbsp; @mysql_query(&quot;INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,credits,activity_points,last_online,account_created,ip_last,ip_reg,expert) VALUES ('&quot; . $username . &quot;','&quot; . $passwordHash . &quot;','&quot; . $email . &quot;','','&quot; . $rank . &quot;','&quot; . $figure . &quot;','&quot; . $sex . &quot;','','25000','2000','&quot;. time() .&quot;','&quot; . date('d-M-Y') . &quot;', '&quot;.$_SERVER['REMOTE_ADDR'].&quot;', '&quot;.$_SERVER['REMOTE_ADDR'].&quot;', '0')&quot;);&nbsp;&nbsp; &nbsp; &nbsp; $id = intval(mysql_free_result(dbquery(&quot;SELECT id FROM users WHERE username = '&quot; . $username . &quot;' LIMIT 1&quot;)));&nbsp; &nbsp; dbquery(&quot;INSERT INTO user_info (user_id,bans,cautions,reg_timestamp,login_timestamp,cfhs,cfhs_abusive) VALUES ('&quot; . $id . &quot;','0','0','&quot; . time(). &quot;','&quot; . time() . &quot;','0','0')&quot;);&nbsp; &nbsp; return $id;&nbsp; }&nbsp;&nbsp; function Delete($id)&nbsp; {&nbsp; &nbsp; dbquery(&quot;DELETE FROM messenger_friendships WHERE user_one_id = '&quot; . $id . &quot;' OR user_two_id = '&quot; . $id . &quot;'&quot;);&nbsp; &nbsp; dbquery(&quot;DELETE FROM messenger_requests WHERE to_id = '&quot; . $id . &quot;' OR from_id = '&quot; . $id . &quot;'&quot;);&nbsp; &nbsp; dbquery(&quot;DELETE FROM users WHERE id = '&quot; . $id . &quot;' LIMIT 1&quot;);&nbsp; &nbsp; dbquery(&quot;DELETE FROM user_subscriptions WHERE user_id = '&quot; . $id . &quot;'&quot;);&nbsp; &nbsp; dbquery(&quot;DELETE FROM user_info WHERE user_id = '&quot; . $id . &quot;' LIMIT 1&quot;);&nbsp; &nbsp; dbquery(&quot;DELETE FROM user_items WHERE user_id = '&quot; . $id . &quot;'&quot;);&nbsp; }&nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; function ValidateUser($username, $password)&nbsp; {&nbsp; &nbsp; return mysql_num_rows(dbquery(&quot;SELECT null FROM users WHERE username = '&quot; . $username . &quot;' AND password = '&quot; . $password. &quot;' LIMIT 1&quot;));&nbsp; }&nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; function Name2id($username = '')&nbsp; {&nbsp; &nbsp; return @intval(mysql_result(dbquery(&quot;SELECT id FROM users WHERE username = '&quot; . $username . &quot;' LIMIT 1&quot;), 0));&nbsp; }&nbsp;&nbsp; function Id2name($id = -1)&nbsp; {&nbsp; &nbsp; if (isset($this-&gt;userCache[$id]['username']))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return $this-&gt;userCache[$id]['username'];&nbsp; &nbsp; } &nbsp;&nbsp; &nbsp; $name = mysql_result(dbquery(&quot;SELECT username FROM users WHERE id = '&quot; . $id . &quot;' LIMIT 1&quot;), 0);&nbsp; &nbsp; $this-&gt;userCache[$id]['username'] = $name;&nbsp; &nbsp; return $name;&nbsp; } &nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; function CacheUser($id)&nbsp; {&nbsp; &nbsp; $data = mysql_fetch_assoc(dbquery(&quot;SELECT * FROM users WHERE id = '&quot; . $id . &quot;' LIMIT 1&quot;));&nbsp;&nbsp; &nbsp; &nbsp; foreach ($data as $key =&gt; $value)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; $this-&gt;userCache[$id][$key] = $value;&nbsp; &nbsp; }&nbsp; }&nbsp;&nbsp; function GetUserVar($id, $var, $allowCache = true)&nbsp; {&nbsp; &nbsp; if ($allowCache &amp;&amp; isset($this-&gt;userCache[$id][$var]))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; if ($var == &quot;last_online&quot;)&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return &quot;&lt;i&gt;Never&lt;/i&gt;&quot;;&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return $this-&gt;userCache[$id][$var];&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; $val = @mysql_result(dbquery(&quot;SELECT &quot; . $var . &quot; FROM users WHERE id = '&quot; . $id . &quot;' LIMIT 1&quot;), 0);&nbsp; &nbsp; $this-&gt;userCache[$id][$var] = $val;&nbsp; &nbsp; return $val;&nbsp; }&nbsp;&nbsp; // do not remove - still used in hk&nbsp; function formatUsername($id, $link = true, $styles = true)&nbsp; {&nbsp; &nbsp; $datas = dbquery(&quot;SELECT id,rank,username FROM users WHERE id = '&quot; . $id . &quot;' LIMIT 1&quot;);&nbsp;&nbsp; &nbsp; &nbsp; if (mysql_num_rows($datas) == 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return '&lt;s&gt;Unknown User&lt;/s&gt;';&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; $data = mysql_fetch_assoc($datas);&nbsp;&nbsp; &nbsp; &nbsp; $prefix = '';&nbsp; &nbsp; $name = $data['username'];&nbsp; &nbsp; $suffix = '';&nbsp;&nbsp; &nbsp; &nbsp; if ($link)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; $prefix .= '&lt;a href=&quot;/user/' . clean($data['username']) . '&quot;&gt;';&nbsp; &nbsp; &nbsp; $suffix .= '&lt;/a&gt;';&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; if ($styles)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; $rank = $this-&gt;getRank($id);&nbsp;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; return clean($prefix . $name . $suffix, true);&nbsp; }&nbsp; // do not remove - still used in hk&nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; function getRank($id)&nbsp; {&nbsp; &nbsp; if (isset($this-&gt;userCache[$id]['rank']))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return $this-&gt;userCache[$id]['rank'];&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; $rankId = @intval(mysql_result(dbquery(&quot;SELECT rank FROM users WHERE id = '&quot; . intval($id) . &quot;' LIMIT 1&quot;), 0));&nbsp; &nbsp; $this-&gt;userCache[$id]['rank'] = $rankId;&nbsp; &nbsp; return $rankId;&nbsp; }&nbsp;&nbsp; function getRankVar($rankId, $var)&nbsp; {&nbsp; &nbsp; return mysql_result(dbquery(&quot;SELECT &quot; . $var . &quot; FROM ranks WHERE id = '&quot; . intval($rankId) . &quot;' LIMIT 1&quot;), 0);&nbsp; }&nbsp;&nbsp; function getRankName($rankId)&nbsp; {&nbsp; &nbsp; return $this-&gt;getRankVar($rankId, 'name');&nbsp; }&nbsp;&nbsp; function hasFuse($id, $fuse)&nbsp; {&nbsp;&nbsp; &nbsp; &nbsp; if (mysql_num_rows(dbquery(&quot;SELECT null FROM fuserights WHERE rank &lt;= '&quot; . $this-&gt;getRank($id) . &quot;' AND fuse = '&quot; . $fuse . &quot;' LIMIT 1&quot;)) == 1)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; return false;&nbsp; }&nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; function GetFriendCount($id, $onlineOnly = false)&nbsp; {&nbsp; &nbsp; $i = 0;&nbsp; &nbsp; $q = dbquery(&quot;SELECT user_two FROM friendships WHERE user_one = '&quot; . $id . &quot;'&quot;);&nbsp;&nbsp; &nbsp; &nbsp; while ($friend = mysql_fetch_assoc($q))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; if (!$onlineOnly)&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $i++;&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $isOnline = mysql_result(dbquery(&quot;SELECT online FROM users WHERE id = '&quot; . $friend['user_two'] . &quot;' LIMIT 1&quot;), 0);&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($isOnline == &quot;1&quot;)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $i++;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; return $i;&nbsp; }&nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; function CheckSSO($id)&nbsp; {&nbsp; &nbsp; global $core;&nbsp;&nbsp; &nbsp; &nbsp; if (strlen($this-&gt;getUserVar($id, 'auth_ticket')) &lt;= 3)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; dbquery(&quot;UPDATE users SET auth_ticket = '&quot; . $core-&gt;generateTicket($this-&gt;getUserVar($id, 'username')) . &quot;' WHERE id = '&quot; . $id . &quot;' LIMIT 1&quot;);&nbsp; &nbsp; }&nbsp; }&nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; function getCredits($id)&nbsp; {&nbsp; &nbsp; return $this-&gt;getUserVar($id, 'credits');&nbsp; }&nbsp;&nbsp; function setCredits($id, $newAmount)&nbsp; {&nbsp; &nbsp; global $core;&nbsp;&nbsp; &nbsp; dbquery(&quot;UPDATE users SET credits = '&quot; . $newAmount. &quot;' WHERE id = '&quot; . $id . &quot;' LIMIT 1&quot;);&nbsp; &nbsp; $core-&gt;Mus('updateCredits:' . $id);&nbsp; }&nbsp;&nbsp; function giveCredits($id, $amount)&nbsp; {&nbsp; &nbsp; global $core;&nbsp;&nbsp; &nbsp; return $this-&gt;setCredits($id, ($this-&gt;getCredits($id) + $amount));&nbsp; &nbsp; $core-&gt;Mus('updateCredits:' . $id);&nbsp; }&nbsp;&nbsp; function takeCredits($id, $amount)&nbsp; {&nbsp; &nbsp; global $core;&nbsp;&nbsp; &nbsp; return $this-&gt;setCredits($id, ($this-&gt;getCredits($id) - $amount));&nbsp; &nbsp; $core-&gt;Mus('updateCredits:' . $id);&nbsp; } &nbsp;&nbsp; function renderHabboImage($id, $size = 'b', $dir = 2, $head_dir = 3, $action = 'wlk', $gesture = 'sml')&nbsp; {&nbsp; &nbsp; $look = $this-&gt;getUserVar($id, 'look');&nbsp;&nbsp; &nbsp; &nbsp; return 'http://www.habbo.co.uk/habbo-imaging/avatarimage?figure=' . $look . '&amp;size=' . $size . '&amp;action=' . $action . ',&amp;gesture=' . $gesture . '&amp;direction=' . $dir . '&amp;head_direction=' . $head_dir;&nbsp; }&nbsp;&nbsp; function getClubDays($id)&nbsp; {&nbsp; &nbsp; $sql = dbquery(&quot;SELECT timestamp_activated, timestamp_expire FROM user_subscriptions WHERE subscription_id = 'habbo_club' AND user_id = '&quot; . $id . &quot;' LIMIT 1&quot;);&nbsp;&nbsp; &nbsp; &nbsp; if (mysql_num_rows($sql) == 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return 0;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; $data = mysql_fetch_assoc($sql);&nbsp; &nbsp; $diff = $data['timestamp_expire'] - time();&nbsp;&nbsp; &nbsp; &nbsp; if ($diff &lt;= 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return 0;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; return ceil($diff / 86400);&nbsp; }&nbsp;&nbsp; function hasClub($id)&nbsp; {&nbsp; &nbsp; return ($this-&gt;getClubDays($id) &gt; 0) ? true : false;&nbsp; }&nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; public static function IsUserBanned($name)&nbsp; {&nbsp; &nbsp; if (uberUsers::GetBan('user', $name, true) != null)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; return false;&nbsp; }&nbsp;&nbsp; public static function IsIpBanned($ip)&nbsp; {&nbsp; &nbsp; if (uberUsers::GetBan('ip', $ip, true) != null)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; return false;&nbsp; }&nbsp;&nbsp; public static function GetBan($type, $value, $mustNotBeExpired = false)&nbsp; {&nbsp; &nbsp; $q = &quot;SELECT * FROM bans WHERE bantype = '&quot; . $type . &quot;' AND value = '&quot; . $value . &quot;' &quot;;&nbsp;&nbsp; &nbsp; &nbsp; if ($mustNotBeExpired)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; $q .= &quot;AND expire &gt; &quot; . time() . &quot; &quot;;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; $q .= &quot;LIMIT 1&quot;;&nbsp;&nbsp; &nbsp; $get = dbquery($q);&nbsp;&nbsp; &nbsp; &nbsp; if (mysql_num_rows($get) &gt; 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return mysql_fetch_assoc($get);&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; return null;&nbsp; } &nbsp;&nbsp; /**************************************************************************************************/&nbsp;&nbsp; public static function GetUserTags($userId)&nbsp; {&nbsp; &nbsp; $tagsArray = Array();&nbsp; &nbsp; $data = dbquery(&quot;SELECT id,tag FROM user_tags WHERE user_id = '&quot; . $userId . &quot;'&quot;);&nbsp;&nbsp; &nbsp; &nbsp; while ($tag = mysql_fetch_assoc($data))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; $tagsArray[$tag['id']] = $tag['tag'];&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; return $tagsArray;&nbsp; }&nbsp;&nbsp; /***************************************************************************/&nbsp; // HOMES&nbsp;&nbsp; public function EatCredits($id, $credits, $restar = true)&nbsp; {&nbsp; &nbsp; if($restar)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; dbquery(&quot;UPDATE users SET credits = credits - &quot;.$credits.&quot; WHERE id = '&quot;.$id.&quot;' LIMIT 1&quot;); &nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; dbquery(&quot;UPDATE users SET credits = &quot;.$credits.&quot; WHERE id = '&quot;.$id.&quot;' LIMIT 1&quot;);&nbsp; &nbsp; }&nbsp; &nbsp; return true; &nbsp; }&nbsp;&nbsp; public static function haveWidget($Id, $var)&nbsp; {&nbsp; &nbsp; $check = mysql_num_rows(dbquery(&quot;SELECT id FROM homes_items WHERE data = '&quot; . $var . &quot;' AND owner_id = '&quot; . $Id . &quot;' LIMIT 1&quot;));&nbsp;&nbsp; &nbsp; &nbsp; if($check &gt; 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; }&nbsp; }&nbsp;&nbsp; public function IsUserOnline($id = USER_ID, $numbers = false)&nbsp; {&nbsp; &nbsp; $CheckOnline = mysql_result(dbquery(&quot;SELECT online FROM users WHERE id = '&quot;.$id.&quot;' LIMIT 1&quot;), 0);&nbsp; &nbsp; if($CheckOnline == '1') {&nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; }&nbsp; }}&nbsp;&nbsp;?&gt;[/CODE]</blockquote>

[QUOTE="Diddy, post: 193677, member: 5596"] Sorry [CODE]<?php /*======================================================================= | UberCMS - Advanced Website and Content Management System for uberEmu | ####################################################################### | Copyright (c) 2010, Roy 'Meth0d' | http://www.meth0d.org | ####################################################################### | This program is free software: you can redistribute it and/or modify | it under the terms of the GNU General Public License as published by | the Free Software Foundation, either version 3 of the License, or | (at your option) any later version. | ####################################################################### | This program is distributed in the hope that it will be useful, | but WITHOUT ANY WARRANTY; without even the implied warranty of | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | GNU General Public License for more details. \======================================================================*/ class uberUsers { /**************************************************************************************************/ private $userCache = Array(); /**************************************************************************************************/ private $blockedNames = Array('roy', 'meth0d', 'method', 'graph1x', 'graphix', 'admin', 'administrator', 'mod', 'moderator', 'guest', 'undefined'); private $blockedNameParts = Array('moderate', 'staff', 'manage', 'system', 'admin', 'uber'); /**************************************************************************************************/ public function IsValidEmail($email = '') { return preg_match("/^[a-z0-9_\.-]+@([a-z0-9]+([\-]+[a-z0-9]+)*\.)+[a-z]{2,7}$/i", $email); } public function IsValidName($nm = '') { if (preg_match('/^[a-z0-9]+$/i', $nm) && strlen($nm) >= 1 && strlen($nm) <= 32) { return true; } return false; } public function IsNameTaken($nm = '') { return ((mysql_num_rows(dbquery("SELECT null FROM users WHERE username = '" . $nm . "' LIMIT 1")) > 0) ? true : false); } public function IdExists($id = 0) { return ((mysql_num_rows(dbquery("SELECT null FROM users WHERE id = '" . $id . "' LIMIT 1")) > 0) ? true : false); } public function IsNameBlocked($nm = '') { foreach ($this->blockedNames as $bl) { if (strtolower($nm) == strtolower($bl)) { return true; } } foreach ($this->blockedNameParts as $bl) { if (strpos(strtolower($nm), strtolower($bl)) !== false) { return true; } } return false; } /**************************************************************************************************/ function Add($username = '', $passwordHash = '', $email = 'default@localhost', $rank = '2', $figure = '', $sex = 'M') { @mysql_query("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,credits,activity_points,last_online,account_created,ip_last,ip_reg,expert) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "','','25000','2000','". time() ."','" . date('d-M-Y') . "', '".$_SERVER['REMOTE_ADDR']."', '".$_SERVER['REMOTE_ADDR']."', '0')"); $id = intval(mysql_free_result(dbquery("SELECT id FROM users WHERE username = '" . $username . "' LIMIT 1"))); dbquery("INSERT INTO user_info (user_id,bans,cautions,reg_timestamp,login_timestamp,cfhs,cfhs_abusive) VALUES ('" . $id . "','0','0','" . time(). "','" . time() . "','0','0')"); return $id; } function Delete($id) { dbquery("DELETE FROM messenger_friendships WHERE user_one_id = '" . $id . "' OR user_two_id = '" . $id . "'"); dbquery("DELETE FROM messenger_requests WHERE to_id = '" . $id . "' OR from_id = '" . $id . "'"); dbquery("DELETE FROM users WHERE id = '" . $id . "' LIMIT 1"); dbquery("DELETE FROM user_subscriptions WHERE user_id = '" . $id . "'"); dbquery("DELETE FROM user_info WHERE user_id = '" . $id . "' LIMIT 1"); dbquery("DELETE FROM user_items WHERE user_id = '" . $id . "'"); } /**************************************************************************************************/ function ValidateUser($username, $password) { return mysql_num_rows(dbquery("SELECT null FROM users WHERE username = '" . $username . "' AND password = '" . $password. "' LIMIT 1")); } /**************************************************************************************************/ function Name2id($username = '') { return @intval(mysql_result(dbquery("SELECT id FROM users WHERE username = '" . $username . "' LIMIT 1"), 0)); } function Id2name($id = -1) { if (isset($this->userCache[$id]['username'])) { return $this->userCache[$id]['username']; } $name = mysql_result(dbquery("SELECT username FROM users WHERE id = '" . $id . "' LIMIT 1"), 0); $this->userCache[$id]['username'] = $name; return $name; } /**************************************************************************************************/ function CacheUser($id) { $data = mysql_fetch_assoc(dbquery("SELECT * FROM users WHERE id = '" . $id . "' LIMIT 1")); foreach ($data as $key => $value) { $this->userCache[$id][$key] = $value; } } function GetUserVar($id, $var, $allowCache = true) { if ($allowCache && isset($this->userCache[$id][$var])) { if ($var == "last_online") { return "Never"; } else { return $this->userCache[$id][$var]; } } $val = @mysql_result(dbquery("SELECT " . $var . " FROM users WHERE id = '" . $id . "' LIMIT 1"), 0); $this->userCache[$id][$var] = $val; return $val; } // do not remove - still used in hk function formatUsername($id, $link = true, $styles = true) { $datas = dbquery("SELECT id,rank,username FROM users WHERE id = '" . $id . "' LIMIT 1"); if (mysql_num_rows($datas) == 0) { return '<s>Unknown User</s>'; } $data = mysql_fetch_assoc($datas); $prefix = ''; $name = $data['username']; $suffix = ''; if ($link) { $prefix .= '<a href="/user/' . clean($data['username']) . '">'; $suffix .= '</a>'; } if ($styles) { $rank = $this->getRank($id); } return clean($prefix . $name . $suffix, true); } // do not remove - still used in hk /**************************************************************************************************/ function getRank($id) { if (isset($this->userCache[$id]['rank'])) { return $this->userCache[$id]['rank']; } $rankId = @intval(mysql_result(dbquery("SELECT rank FROM users WHERE id = '" . intval($id) . "' LIMIT 1"), 0)); $this->userCache[$id]['rank'] = $rankId; return $rankId; } function getRankVar($rankId, $var) { return mysql_result(dbquery("SELECT " . $var . " FROM ranks WHERE id = '" . intval($rankId) . "' LIMIT 1"), 0); } function getRankName($rankId) { return $this->getRankVar($rankId, 'name'); } function hasFuse($id, $fuse) { if (mysql_num_rows(dbquery("SELECT null FROM fuserights WHERE rank <= '" . $this->getRank($id) . "' AND fuse = '" . $fuse . "' LIMIT 1")) == 1) { return true; } return false; } /**************************************************************************************************/ function GetFriendCount($id, $onlineOnly = false) { $i = 0; $q = dbquery("SELECT user_two FROM friendships WHERE user_one = '" . $id . "'"); while ($friend = mysql_fetch_assoc($q)) { if (!$onlineOnly) { $i++; } else { $isOnline = mysql_result(dbquery("SELECT online FROM users WHERE id = '" . $friend['user_two'] . "' LIMIT 1"), 0); if ($isOnline == "1") { $i++; } } } return $i; } /**************************************************************************************************/ function CheckSSO($id) { global $core; if (strlen($this->getUserVar($id, 'auth_ticket')) <= 3) { dbquery("UPDATE users SET auth_ticket = '" . $core->generateTicket($this->getUserVar($id, 'username')) . "' WHERE id = '" . $id . "' LIMIT 1"); } } /**************************************************************************************************/ function getCredits($id) { return $this->getUserVar($id, 'credits'); } function setCredits($id, $newAmount) { global $core; dbquery("UPDATE users SET credits = '" . $newAmount. "' WHERE id = '" . $id . "' LIMIT 1"); $core->Mus('updateCredits:' . $id); } function giveCredits($id, $amount) { global $core; return $this->setCredits($id, ($this->getCredits($id) + $amount)); $core->Mus('updateCredits:' . $id); } function takeCredits($id, $amount) { global $core; return $this->setCredits($id, ($this->getCredits($id) - $amount)); $core->Mus('updateCredits:' . $id); } function renderHabboImage($id, $size = 'b', $dir = 2, $head_dir = 3, $action = 'wlk', $gesture = 'sml') { $look = $this->getUserVar($id, 'look'); return 'http://www.habbo.co.uk/habbo-imaging/avatarimage?figure=' . $look . '&size=' . $size . '&action=' . $action . ',&gesture=' . $gesture . '&direction=' . $dir . '&head_direction=' . $head_dir; } function getClubDays($id) { $sql = dbquery("SELECT timestamp_activated, timestamp_expire FROM user_subscriptions WHERE subscription_id = 'habbo_club' AND user_id = '" . $id . "' LIMIT 1"); if (mysql_num_rows($sql) == 0) { return 0; } $data = mysql_fetch_assoc($sql); $diff = $data['timestamp_expire'] - time(); if ($diff <= 0) { return 0; } return ceil($diff / 86400); } function hasClub($id) { return ($this->getClubDays($id) > 0) ? true : false; } /**************************************************************************************************/ public static function IsUserBanned($name) { if (uberUsers::GetBan('user', $name, true) != null) { return true; } return false; } public static function IsIpBanned($ip) { if (uberUsers::GetBan('ip', $ip, true) != null) { return true; } return false; } public static function GetBan($type, $value, $mustNotBeExpired = false) { $q = "SELECT * FROM bans WHERE bantype = '" . $type . "' AND value = '" . $value . "' "; if ($mustNotBeExpired) { $q .= "AND expire > " . time() . " "; } $q .= "LIMIT 1"; $get = dbquery($q); if (mysql_num_rows($get) > 0) { return mysql_fetch_assoc($get); } return null; } /**************************************************************************************************/ public static function GetUserTags($userId) { $tagsArray = Array(); $data = dbquery("SELECT id,tag FROM user_tags WHERE user_id = '" . $userId . "'"); while ($tag = mysql_fetch_assoc($data)) { $tagsArray[$tag['id']] = $tag['tag']; } return $tagsArray; } /***************************************************************************/ // HOMES public function EatCredits($id, $credits, $restar = true) { if($restar) { dbquery("UPDATE users SET credits = credits - ".$credits." WHERE id = '".$id."' LIMIT 1"); } else { dbquery("UPDATE users SET credits = ".$credits." WHERE id = '".$id."' LIMIT 1"); } return true; } public static function haveWidget($Id, $var) { $check = mysql_num_rows(dbquery("SELECT id FROM homes_items WHERE data = '" . $var . "' AND owner_id = '" . $Id . "' LIMIT 1")); if($check > 0) { return true; } else { return false; } } public function IsUserOnline($id = USER_ID, $numbers = false) { $CheckOnline = mysql_result(dbquery("SELECT online FROM users WHERE id = '".$id."' LIMIT 1"), 0); if($CheckOnline == '1') { return true; } else { return false; } } } ?>[/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members