[HELP] UberCMS Chrome Edit Register Error

[LeagueHotel]

Hello Dev,
I'm using Uber2.0 Chrome Edit and I'm having an issue whenever new users try to register I get this database error:

Does anyone have the solution for this?

Thank you, xox

 

[Jerry]

Go to class.users.php in /inc and look for this code;

dbquery("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,credits,vip_points,activity_points,last_online,account_created,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "','','10000','100','10000','', UNIX_TIMESTAMP() ,'" .$_SERVER['REMOTE_ADDR'] . "')");

and Replace it with this;

dbquery("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,credits,activity_points,last_online,account_created,ip_last,ip_reg,newbie_status) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "','[HOTELNAME] Newbie|','50000','25000','" . time() . "','" . time() . "', '".$_SERVER['REMOTE_ADDR']."', '".$_SERVER['REMOTE_ADDR']."', '0')");

Other options:
"[HOTELNAME] NEWBIE|" = Change that to your hotel name.
"50000" = Credits start default for users.
"25000" = Pixels/Duckets start default for users.

 

[LeagueHotel]

Go to class.users.php in /inc and look for this code;

dbquery("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,credits,vip_points,activity_points,last_online,account_created,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "','','10000','100','10000','', UNIX_TIMESTAMP() ,'" .$_SERVER['REMOTE_ADDR'] . "')");

and Replace it with this;

dbquery("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,credits,activity_points,last_online,account_created,ip_last,ip_reg,newbie_status) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "','[HOTELNAME] Newbie|','50000','25000','" . time() . "','" . time() . "', '".$_SERVER['REMOTE_ADDR']."', '".$_SERVER['REMOTE_ADDR']."', '0')");

Other options:
"[HOTELNAME] NEWBIE|" = Change that to your hotel name.
"50000" = Credits start default for users.
"25000" = Pixels/Duckets start default for users.

That seemed to work. Cheers Amigo!

Now I'm getting an error where I disconnect as soon as I hit 'Rooms' the error in my emulator is..

7/25/2014 4:48:48 PM: Error: System.NullReferenceException: Object reference not set to an instance of an object.
at Phoenix.HabboHotel.Navigators.PublicItem.method_0(ServerMessage Message5_0) in c:\Users\Makennan\Desktop\3.11.0\Phoenix\HabboHotel\Navigators\PublicItem.cs:line 56
at Phoenix.HabboHotel.Navigators.Navigator.method_5() in c:\Users\Makennan\Desktop\3.11.0\Phoenix\HabboHotel\Navigators\Navigator.cs:line 147
at Phoenix.Communication.Messages.Navigator.GetOfficialRoomsMessageEvent.Handle(GameClient Session, ClientMessage Event) in c:\Users\Makennan\Desktop\3.11.0\Phoenix\Communication\Messages\Navigator\GetOfficialRoomsMessageEvent.cs:line 10
at Phoenix.HabboHotel.GameClients.GameClient.method_13(Byte[]& byte_0) in c:\Users\Makennan\Desktop\3.11.0\Phoenix\HabboHotel\GameClients\GameClient.cs:line 482