r63b Retro Problem.

V

Vonne

New Member
Nov 4, 2013
13
0
I can't access my retro (r63b) , would appreciate if anyone could help! I keep getting this message when I try to access localhost :


Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app\class.engine.php on line 107

Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app\class.engine.php on line 107

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\app\class.engine.php:107) in C:\xampp\htdocs\app\tpl\class.html.php on line 32

Edit: If I delete those two codes , I can access my retro but I can't register , I get this message :
Table 'r63b.users' doesn't exist
 
Last edited:
Sort by date Sort by votes
V

Vonne

New Member
Nov 4, 2013
13
0
I got the homepage to work but the client doesn't seem to work for me , all I get is a black screen. I already updated the web build , is there anything else I need to do?

I've tried changing the variables but nothing seems to work.
 
Last edited:
Upvote 0 Downvote
Khalil

Khalil

IDK
Dec 6, 2011
1,642
786
Try out the db i gave you and go check if the links in the client file are correct (js & some css links, the one that are not hosted by Habbo.com but actually, you).
 
Upvote 0 Downvote
Khalil

Khalil

IDK
Dec 6, 2011
1,642
786
Dude, do you keep deleting your users table, or what?

Execute this sql code:

Code: 
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` char(50) NOT NULL,
  `real_name` char(100) NOT NULL DEFAULT '',
  `password` char(42) NOT NULL,
  `mail` varchar(50) NOT NULL DEFAULT '[email protected]',
  `auth_ticket` varchar(60) NOT NULL,
  `rank` int(1) unsigned NOT NULL DEFAULT '1',
  `credits` int(11) NOT NULL DEFAULT '0',
  `vip_points` int(11) NOT NULL DEFAULT '0',
  `activity_points` int(11) NOT NULL DEFAULT '0',
  `activity_points_lastupdate` double(5,0) NOT NULL DEFAULT '0',
  `look` char(100) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
  `gender` enum('M','F') NOT NULL DEFAULT 'M',
  `motto` char(50) NOT NULL,
  `account_created` char(12) NOT NULL,
  `last_online` varchar(20) NOT NULL,
  `online` enum('0','1') NOT NULL DEFAULT '0',
  `ip_last` char(20) NOT NULL,
  `ip_reg` char(20) NOT NULL,
  `home_room` int(10) unsigned NOT NULL DEFAULT '0',
  `respect` int(11) NOT NULL DEFAULT '0',
  `daily_respect_points` int(1) NOT NULL DEFAULT '3',
  `daily_pet_respect_points` int(1) NOT NULL DEFAULT '3',
  `newbie_status` int(1) NOT NULL DEFAULT '3',
  `is_muted` enum('0','1') NOT NULL DEFAULT '0',
  `mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
  `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
  `block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
  `hide_online` enum('0','1') NOT NULL DEFAULT '0',
  `hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
  `mail_verified` varchar(6) NOT NULL DEFAULT '0',
  `vip` enum('0','1') NOT NULL DEFAULT '0',
  `working` varchar(50) NOT NULL DEFAULT '0',
  `secretcode` varchar(8) NOT NULL DEFAULT '0',
  `mymusik` varchar(100) NOT NULL DEFAULT '0',
  `getmoney_date` varchar(20) NOT NULL DEFAULT '0',
  `visibility` enum('EVERYONE','FRIENDS','NOBODY') NOT NULL DEFAULT 'EVERYONE',
  `birth` varchar(10) NOT NULL DEFAULT '0',
  `volume` int(3) NOT NULL DEFAULT '100',
  `dolares` int(11) NOT NULL DEFAULT '0',
  `Weights` int(11) NOT NULL,
  `lastdailycredits` char(18) NOT NULL DEFAULT '',
  `points` int(11) NOT NULL DEFAULT '0',
  `block_trade` enum('1','0') NOT NULL DEFAULT '0',
  `crystals` int(11) NOT NULL DEFAULT '0',
  `achievement_points` int(11) NOT NULL,
  `quests` varchar(200) NOT NULL,
  `queststates` varchar(200) NOT NULL,
  `canchangename` enum('0','1') NOT NULL DEFAULT '1',
  `FavoriteGroup` int(11) NOT NULL DEFAULT '0',
  `one_password` varchar(500) NOT NULL DEFAULT '0',
  `datosreg` varchar(500) NOT NULL DEFAULT '0',
  `country` varchar(500) NOT NULL DEFAULT '0',
  `facebook_id` varchar(255) NOT NULL,
  `marketing` varchar(1) NOT NULL DEFAULT '0',
  `showhome` varchar(10) NOT NULL DEFAULT '1',
  `main` varchar(10) NOT NULL DEFAULT '1',
  `registered` varchar(10) NOT NULL DEFAULT '0000000000',
  `lastonline` varchar(10) NOT NULL DEFAULT '000000000',
  `passed_quiz` enum('0','1') NOT NULL DEFAULT '0',
  `points_online` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
 
Upvote 0 Downvote
JayC

JayC

Well-Known Member
Aug 8, 2013
5,505
1,401
Vonne said:
It's running on localhost ... could you give me directions to the client page?
Click to expand...
Dude. Omg. Are you kidding me right now? localhost/client.php Seriously.

Do me a favor, if you can't figure that out. Go onto the vps and go to start and click shutdown.
 
Upvote 0 Downvote
Khalil

Khalil

IDK
Dec 6, 2011
1,642
786
I'm afraid i'll have to backup JayTouch on what he said, if you don't even know what the client page is or where to find it then you shouldn't be running this hotel as it will die for lack of a technical knowledge, shut it down, learn some stuff and re-open it, or maybe just drop retros, if i were you i wouldn't bother with illegal chat rooms.
 
Upvote 0 Downvote
V

Vonne

New Member
Nov 4, 2013
13
0
Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.

If you think this is a server error, please contact the webmaster.

Error 404
You must be registered for see links

11/8/2013 9:50:42 PM
Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1
Click to expand...

That's what I get from client.php.
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top