The Hotel Hack

This hack creates a private board where people can reg rooms and use there keys to meet people there. Once in the board they can do whatever they like privately. THe only people who can get in is the people with the key. The key is a password that allow you to veiw the private board. ALso these boards are not included in the search database.


version 1.6
https://vborg.vbsupport.ru/attachmen...&postid=266472

[itstd]

and this error when I try to buy a room:

Database error in vBulletin 2.2.1:

Invalid SQL: SELECT roomnumber FROM hotel WHERE roomname = 'Test Room' AND roomkey = 'za14821ja37ko81'. To goto your room click <a href="room.php?action=enterroom&roomnumber=$roomnu mber&roomkey=$roomkey">here</a>
mysql error: You have an error in your SQL syntax near '. To goto your room click <a href="room.php?action=enterroom&roomnumber=$roomnu m' at line 1

mysql error number: 1064

Date: Thursday 06th of June 2002 06:10:47 PM

[Dr Shark]

itstd you might be getting them error's because its for 2.2.6 and your using a 2.2.1.

[Dean C]

this hack looks good... ill let a few ppl test this first then ill have a go at installing it

[itstd]

Me thinks your probabley right Doc.

[Neo]

DUDE this is really creative.

[Neo]

Big prob with the code you... and its this

PHP Code:

             $roomnumber=$DB_site->query_first("SELECT roomnumber FROM hotel WHERE roomname = '$roomname' AND roomkey = '$key'. To goto your room click <a href=".'"room.php?action=enterroom&roomnumber=$roomnumber&roomkey=$roomkey">here</a>'); 


now tell me why.. I bet you cant guess

[geniuscrew]

Will admins still be able to view it? Imagine if you can't and they're planning to take your boards down!!

Eeeek!

[CloakSim]

Looks very nice

[zajako]

damn, ill update and fix that error, guys.

I accidentlay pasted the line for sending pms, in a query cause i had no sleep for 48 hours and all that junk...

GC, If you look in the database you can read them, afterall you can do the same for pm's

I also improved the emails and pm sends....

soory bout that and this update should fix that problem.

[ULTIMATESSJ]

i just tried installing and this came up

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: CREATE TABLE hotelposts (
roomactionid int(10) NOT NULL auto_increment,
roomnumber int(10) NOT NULL,
username varchar(50) NOT NULL,
userid int(10) NOT NULL DEFAULT '0',
roomaction mediumtext DEFAULT '0',
PRIMARY KEY (roomactionid)
);
mysql error: BLOB column 'roomaction' can't have a default value

mysql error number: 1101

Date: Thursday 06th of June 2002 10:26:11 PM
Script: http://www.animexplosion.com/forums/...dmin/query.php
Referer: http://www.animexplosion.com/forums/admin/query.php