[Release] Room On Register

Joe · Aug 10, 2016

Yeah, just make an enum and when the room is made set noob=0 instead of 1 or something a long those lines.

MadMonsterMan · Aug 10, 2016

Yeah the 2nd code was not tested though, I just coded it in notepad.

OH ON THE 2ND CODE THERE ISN'T A TEST TO SEE IF THERE IS A NEW USER OR NOT! TAKE THAT FROM EXAMPLE #1 OTHERWISE IT WILL MAKE A NEW ROOM EVERYTIME

Fixed The Code:

Code:

// Starter
$getStats = mysql_query("SELECT null FROM `user_stats` WHERE id = '".$_SESSION['user']['id']."'");
if(mysql_num_rows($getStats) != 1){
        $randomRoomID = mysql_fetch_assoc(mysql_query("SELECT `id` FROM room_starters ORDER BY RAND() LIMIT 1"));

        $getRoom = mysql_fetch_assoc(mysql_query("SELECT * FROM `rooms` WHERE id = '".$randomRoomID['id']."' LIMIT 1"));

        $starterCaption = "Welcome " . $_SESSION['user']['username'];
        mysql_query("INSERT INTO `rooms` (roomtype, caption, owner, description, model_name, wallpaper, floor, wallthick, floorthick, allow_hidewall) VALUES ('public','".$starterCaption."','".$_SESSION['user']['id']."','Welcome to iHabbo','".$getRoom['model_name']."','".$getRoom['wallpaper']."','".$getRoom['floor']."','".$getRoom['wallthick']."','".$getRoom['floorthick']."','".$getRoom['allow_hidewall']."')");

        $lastRoomID = mysql_fetch_assoc(mysql_query("SELECT id FROM rooms ORDER BY `id` DESC LIMIT 1"));
        mysql_query("UPDATE `users` SET `home_room` = '".$lastRoomID['id']."' WHERE `id` = '".$_SESSION['user']['id']."'");
        $getItems = mysql_query("SELECT * FROM `items` WHERE `room_id` = '".$randomRoomID['id']."'");

    while($CurItem = mysql_fetch_assoc($getItems)){
        mysql_query("INSERT INTO `items` (user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos) VALUES ('".$_SESSION['user']['id']."','".$lastRoomID['id']."','".$CurItem['base_item']."','".$CurItem['extra_data']."','".$CurItem['x']."','".$CurItem['y']."','".$CurItem['z']."','".$CurItem['rot']."','".$CurItem['wall_pos']."')");
    }

}

Just incase they try and copy and paste lmao

PHP:

<?php
// Starter
$getStats = mysql_query("SELECT null FROM `user_stats` WHERE id = '".$_SESSION['user']['id']."'");
if(mysql_num_rows($getStats) != 1){
        $randomRoomID = mysql_fetch_assoc(mysql_query("SELECT `id` FROM room_starters ORDER BY RAND() LIMIT 1"));

        $getRoom = mysql_fetch_assoc(mysql_query("SELECT * FROM `rooms` WHERE id = '".$randomRoomID['id']."' LIMIT 1"));

        $starterCaption = "Welcome " . $_SESSION['user']['username'];
        mysql_query("INSERT INTO `rooms` (roomtype, caption, owner, description, model_name, wallpaper, floor, wallthick, floorthick, allow_hidewall) VALUES ('public','".$starterCaption."','".$_SESSION['user']['id']."','Welcome to iHabbo','".$getRoom['model_name']."','".$getRoom['wallpaper']."','".$getRoom['floor']."','".$getRoom['wallthick']."','".$getRoom['floorthick']."','".$getRoom['allow_hidewall']."')");

        $lastRoomID = mysql_fetch_assoc(mysql_query("SELECT id FROM rooms ORDER BY `id` DESC LIMIT 1"));
        mysql_query("UPDATE `users` SET `home_room` = '".$lastRoomID['id']."' WHERE `id` = '".$_SESSION['user']['id']."'");
        $getItems = mysql_query("SELECT * FROM `items` WHERE `room_id` = '".$randomRoomID['id']."'");

    while($CurItem = mysql_fetch_assoc($getItems)){
        mysql_query("INSERT INTO `items` (user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos) VALUES ('".$_SESSION['user']['id']."','".$lastRoomID['id']."','".$CurItem['base_item']."','".$CurItem['extra_data']."','".$CurItem['x']."','".$CurItem['y']."','".$CurItem['z']."','".$CurItem['rot']."','".$CurItem['wall_pos']."')");
    }

}
?>

elbello · Aug 10, 2016

tried V2 nothing happened. Plus emu habbon edit.

MadMonsterMan · Aug 10, 2016

V1 tested on Plus Emulator Haboon Edit fully working.

elbello · Aug 10, 2016

Could yuo help me?

pedro1212 · Aug 27, 2016

WUAHHAHA gracias

Komandaki · Sep 7, 2016

download room_model ?

Danbo · Sep 11, 2016

thanks, good work

Sovngarde · Sep 20, 2016

Omg, thanks thanks thanks its so helpfull!

LeComet · Oct 17, 2016

Nice Release, no complaints.

Scronnie7 · Feb 7, 2017

Any support for this for brain cms? it calls on the database way differently. can't figure it out

JynX · Feb 7, 2017

Scronnie7 said:
Any support for this for brain cms? it calls on the database way differently. can't figure it out

If I get a minute I'll code it if someone else doesn't before me I'll post it here

Scronnie7 · Feb 7, 2017

Ok needing it quick. Thanks!

anthonyy · Feb 8, 2017

Okay, so I have my hotel on local host it's just for me to learn new stuff, and i've had my hotel working and i've been on the client for most of the day.

then i followed your tutorial...
and everything was fine, i just had a black room, so i thought to myself, i'll do everyone again just to double check. Next thing you know i'm unable to get onto my client it's stuck at 76% I've deleted the code that was added from the client but for some reason it's still stuck at 76% so i'm a little confused. my emu has come up with no errors and so have the mod tools on google chrome. If anyone has any ideas or has come across this themselves then please let me know how to fix thank you. :up:

JayC · Feb 8, 2017

anthonyy said:
Okay, so I have my hotel on local host it's just for me to learn new stuff, and i've had my hotel working and i've been on the client for most of the day.

then i followed your tutorial...
and everything was fine, i just had a black room, so i thought to myself, i'll do everyone again just to double check. Next thing you know i'm unable to get onto my client it's stuck at 76% I've deleted the code that was added from the client but for some reason it's still stuck at 76% so i'm a little confused. my emu has come up with no errors and so have the mod tools on google chrome. If anyone has any ideas or has come across this themselves then please let me know how to fix thank you.

Go into your `Rooms` table, did it make the room successfully with the correct room_id?

Wulles · Feb 8, 2017

How to use this on RevCMS with PlusEmulator?

anthonyy · Feb 13, 2017

this works great release! but unfortunately every time a user who already has a welcome room enters it creates a new welcome room for them. for example 1 user has 4 rooms, how to stop this from happening?

JayC · Feb 13, 2017

anthonyy said:
this works great release! but unfortunately every time a user who already has a welcome room enters it creates a new welcome room for them. for example 1 user has 4 rooms, how to stop this from happening?

That can only happen if the code is not correct:

Code:

<?php
// Starter
$getStats = mysql_query("SELECT null FROM `user_stats` WHERE id = '".$_SESSION['user']['id']."'");
if(mysql_num_rows($getStats) != 1){
  $getRoomKit = mysql_fetch_assoc(mysql_query("SELECT * FROM room_starterkit ORDER BY RAND() LIMIT 1"));
  $welcomeMessage = "Welcome " . $_SESSION['user']['username'];
  mysql_query("INSERT INTO `rooms` (caption,owner,description,model_name,wallpaper,floor) VALUES ('".$welcomeMessage."', '".$_SESSION['user']['id']."', 'Welcome to Hablore', '".$getRoomKit['room_Model']."', '".$getRoomKit['room_Wallpaper']."', '".$getRoomKit['room_Floor']."') ");
  $theRoomID = mysql_fetch_assoc(mysql_query("SELECT id FROM `rooms` ORDER BY `id` DESC LIMIT 1"));
  mysql_query("UPDATE `users` SET `home_room` = '".$theRoomID['id']."' WHERE `id` = '".$_SESSION['user']['id']."'");
  $getRoomItems = mysql_query("SELECT * FROM room_itemkits WHERE roomKit = '".$getRoomKit['id']."'");

  while($currItem = mysql_fetch_assoc($getRoomItems)){
    mysql_query("INSERT INTO `items`(user_id,room_id,base_item,extra_data,x,y,z,rot,wall_pos) VALUES ('".$_SESSION['user']['id']."','".$theRoomID['id']."','".$currItem['item_BaseID']."', '".$currItem['extra_data']."', '".$currItem['x']."', '".$currItem['y']."', '".$currItem['z']."','".$currItem['rot']."', '".$currItem['wall_pos']."')");
  }

}
?>

$getStats = mysql_query("SELECT null FROM `user_stats` WHERE id = '".$_SESSION['user']['id']."'");
if(mysql_num_rows($getStats) != 1){

This will test if they have ever entered the client before, because on first login you get a row created for your user stats

anthonyy · Feb 21, 2017

does anyone know how to remove this from my hotel? I've deleted the code from the client.php and truncate all the tables in navicat but it's still creating rooms for users.

JayC · Feb 21, 2017

anthonyy said:
does anyone know how to remove this from my hotel? I've deleted the code from the client.php and truncate all the tables in navicat but it's still creating rooms for users.

Make sure you deleted the client code under the right skin.

[Release] Room On Register

Well-Known Member

Member

New Member

Member

New Member

New Member

New Member

New Member

New Member

Retaliation 3

New Member

Posting Freak

New Member

Member

Always Learning

New Member

Member

Always Learning

Member

Always Learning

Users who are viewing this thread