Code:
<?phpfunction get_users_online(){
$sql=mysql_query("SELECT id FROM `users` WHERE `online` = '1'");
$return=mysql_num_rows($sql);
return $return;
}
function get_userinfo($get){
$id2=mysql_real_escape_string($_SESSION['id']);
$sql=mysql_query("SELECT * FROM `users` WHERE `id` LIKE '$id2'");
$return=mysql_fetch_array($sql);
return $return[$get];
}
function get_AddUserP($username = '', $password = '', $mail = '', $figure = '', $motto = '')
{
mysql_query("INSERT INTO users (username, password, mail, look, motto, account_created, last_online, ip_last, ip_reg, auth_ticket) VALUES ('".$username."', '".$password."', '".$mail."', '".$figure."', '".$motto."', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), '".$_SERVER['REMOTE_ADDR']."', '".$_SERVER['REMOTE_ADDR']."', '')");
$user_id = mysql_insert_id();
mysql_query("INSERT INTO user_stats (id, RoomVisits, OnlineTime, Respect, RespectGiven, GiftsGiven, GiftsReceived, DailyRespectPoints, DailyPetRespectPoints) VALUES ('".$user_id."', 0, 0, 0, 0, 0, 0, 3, 3)");
mysql_query("INSERT INTO user_info (user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive) VALUES ('".$user_id."', '0', '0', UNIX_TIMESTAMP(), '0', '0', '0')");
}
function get_AddUserA($username = '', $password = '', $mail = '', $figure = '', $motto = '')
{
mysql_query("INSERT INTO `users` (`username`, `password`, `mail`, `rank`, `credits`, `belcredits`, `pixels`, `look`, `gender`, `online`, `ip_last`, `auth_ticket`, `ip_reg`, `motto`, `account_created`, `achievement_points`, `last_online`, `currentquestid`, `currentquestprogress`) VALUES ('".$username."', '".$password."', '".$mail."', '1', '".get_settings("initial_credits")."', '".get_settings("initial_credits")."', '".get_settings("initial_pixels")."', '".$figure."', 'M', '0', '0', '0', '0', '".$motto."', '0', '0', '0', '0', '0');") or die (mysql_error());
}
function get_ValidName($u_name = '')
{
if(preg_match('/^[a-zA-Z0-9._:,-]+$/i', $u_name) && !preg_match('/mod-/i', $u_name))
return true;
else
return false;
}
function get_NameTaken($u_name = '')
{
return (mysql_num_rows(mysql_query("SELECT * FROM users WHERE username = '".$u_name."'")) > 0 ? true : false);
}
function get_ValidMail($mail = '')
{
return preg_match("/^[a-z0-9_\.-]+@([a-z0-9]+([\-]+[a-z0-9]+)*\.)+[a-z]{2,7}$/i", $mail);
}
function get_MailTaken($mail = '')
{
return (mysql_num_rows(mysql_query("SELECT * FROM users WHERE mail = '".$mail."' LIMIT 1")) > 0 ? true : false);
}
function get_UserID($u_name = '')
{
$query = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE username = '".$u_name."' LIMIT 1"));
return $query['id'];
}
function CheckName($name) {
$q = mysql_query("SELECT * FROM users WHERE username = '".SQLi($name)."'");
if(mysql_num_rows($q) > 0) { return true; } else { return false; }
}
function NewUser($name, $email, $pass) {
mysql_query("INSERT INTO `users` (`id`, `username`, `password`, `mail`, `rank`, `credits`, `pixels`, `look`, `gender`, `motto`) VALUES (NULL, '".SQLi($name)."', '".SQLi($pass)."', '".SQLi($email)."', '1', '1000', '500', 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62', 'M', 'Welcome to Hotel');");
}
function get_cinfo($string) {
if($string="online"){
if($emulator="azure") {
echo get_userinfo("online");
}
elseif ($emulator="phoenix") {
echo get_userinfo("online");
}
}
if($string="pixels") {
if($emulator="azure") {
echo get_userinfo("pixels");
}
elseif ($emulator="phoenix") {
echo get_userinfo("activity_points");
}
}
}
?>
mobbo - The kick Ass Habbo Network
Reply With Quote
Originally Posted by Giles121
