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

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

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

Me thinks your probabley right Doc. :(

DUDE this is really creative. :D

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


now tell me why.. I bet you cant guess ;)

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

Eeeek!

Looks very nice :)

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.

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