The Hotel Hack

[zajako]

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/attachment.php?s=&postid=266472

[zajako]

here are some pics...

Buying a room(its free but the wrds say buy a room :P)

[zajako]

a room

[zajako]

main pic

[zajako]

a pm sent with a key

[Xenon]

hey, looks very good...

if it has no security problems, this could nearly replace the pm-system

[zajako]

well, im almost positive it has some security holes, but if it is constructed a lot more secure it can be set up like that for replying with pm's faster and better :}

[MrLister]

looks good. i already have somewhat of a hotel installed i never thought of it as a key, might be a great additon.

thanks

[itstd]

I'm getting this error on the second quiry:
Database error in vBulletin Control Panel 2.2.1:

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

[ULTIMATESSJ]

the idea of this looks pretty kewl, good work, anyone got this working on their forums

[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=$roomnumber&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=$roomnum' 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. :confused:

[Dean C]

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

[itstd]

Me thinks your probabley right Doc. :(

[Neo]

DUDE this is really creative. :D

[Neo]

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


$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/forums/admin/query.php
Referer: http://www.animexplosion.com/forums/admin/query.php

[ZiRu$]

awesome idea......Where do you get the money to buy a room?

Lesanes Store Hack?

[Neo]

@ULTIMATESSJ: use this


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,
PRIMARY KEY (roomactionid)
);

[AntiOnline]

How about adding a user's name above their avatar?

[Chris M]

I like this hack...

Very creative...:)

*Installs*

Satan

[zajako]

ehh, anotehr update, I fixed some email issues and the pm issues, so now it gives a link or at least a correct link that contains there key so they can junmp to thier room quickkly

The hotel v 1.02 :}

[zajako]

itstd, it should work for you board now

anti online, open room.php

find:

for ($i=0; $i < $numberactions; $i++)
{
$add[$i] = '<tr>
<td>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="18%">'.$displayavatar[$i].'</td>
<td width="82%"><center>'.$display[$i].'</center></td>
</tr>
</table>
</td>
</tr>';
$texts = $texts.$add[$i];
$i++;
$add[$i] = ' <tr>
<td>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="82%"><center>'.$display[$i].'</center></td>
<td width="18%">'.$displayavatar[$i].'</td>
</tr>
</table>
</td>
</tr>';

$texts = $texts.$add[$i];

}



and replace with



for ($i=0; $i < $numberactions; $i++)
{
$add[$i] = '<tr>
<td>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="18%">'.$username.'<br>'.$displayavatar[$i].'</td>
<td width="82%"><center>'.$display[$i].'</center></td>
</tr>
</table>
</td>
</tr>';
$texts = $texts.$add[$i];
$i++;
$add[$i] = ' <tr>
<td>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="82%"><center>'.$display[$i].'</center></td>
<td width="18%">'.$username.'<br>'.$displayavatar[$i].'</td>
</tr>
</table>
</td>
</tr>';

$texts = $texts.$add[$i];

}


i have not tested it, but it should work

If it does not, then let me know

For anyone who did not read his request, this coding should put the username above the avatars.

[BigJohnson]

I love this hack. IT would be great if it can be used with Lesanes Store hack though. Also whne you send thw other key to someones PM and it is the wrong PM you get a database error. What can we do about this?

[zajako]

ill make an update to say the user does not exsit, sorry, i had been working on this between many other things, and for got a few minor things, ill make a command to check for that.

Also i might make an option for it to work with the lesane store hack, just post a reply to this requesing this and if there are enough replys Ill try to fit it in my schedule.

[BigJohnson]

WOW. I am using 2.2.5 and when i sign in i get all sorts of wierd stuff. Is this hack done right at ALL? or is it just me? I see the room but below the room it shows my logo again and says invalid key for thats it. When i click send it says invalid key. Anyone no what is wrong? I am using 2.2.5 is 2.2.6 really that much different to do something like this?

[BigJohnson]

I bet everyone would love this hack to work with Lesanes store hack. ZThat would be great.

[Sparkz]

With all the issues this hack has, maybe it should be in the beta section?

[zajako]

well, all issuses except the one just pointed out are solved sparkz, and they were due to changes i had to make to make it so other boards can use it. So i don't think it should be a beta hack. also is anyone else getting the double window error??

IF you tell me the steps you did to get that error , i might be able to see if it is part of the coding that is doing that, or if it is something relateing to your sql, or server.

also here is an update that should cover the bad username error.

[BigJohnson]

What in this update actualy do i have to do. I dont want to install the whole hack again. Just say what needs to be done lol. Also this are the steps i did and got the error. I bought the room went to mey PM folder clicked here. Sats invalid then i add the room key at the top into the url and then it works. But then i get the double screen. Thats what i do. My server has everything update with mySQl and php and everything. I am running 2.2.5

[Sparkz]

Oh, and please update the file in your first post, instead of spreading multiple files through the thread. Most people look there for updates.

[zajako]

just upload the hotel.php file again

also if you get an error with the pm , then you skipped a part of the instal file where it says to edit room.php where you see http://www.yoursite.com/forums

that should be it, also that may be why your having these issues.

[BigJohnson]

OK i figured the prob out few. I guess i downloaded the wrong zip or something in this thread because it was extremely screwed up. Well now it works. All that i need to no now is what do i do to actually fix the Error message for the wrong name? Also this would be great if it could work with Lesanes store hack. But i think it would be best if more than 2 people can go into room. That would be pretty kool if more than one person can go into a room. Then that would be pretty kool. Now that i have thought of it. I don't think it would be kool with lesanes store hack. lol. I was just thinking and it doesnt seem like that kool of an idea to pay to talk if you can just Pm them. But i really think that it would be kool if you can send a PM to more than one person when buying a room so more than 2 people can be in a room. What do you think?

[BigJohnson]

Well i am still getting the mySQl error when you put in the wrong PM name of someone that does not exist. Everything now works. lol. I figured the Your_site.com one out by editing the files lol. I notticed when i hovered my mouse over the HERE url in my Private Message lol. This is what the SQL error looks like

Database error in vBulletin 2.2.5:

Invalid SQL: INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title ,message,dateline,messageread,folderid) VALUES (NULL,,,1,'Your room Key sent by, Nem','Your room is ready. It is room 7and is named Another. Your key is za20218ja4ko380. To goto your room click here (http://www..com/room.php?action=enterroom&roomnumber=7&roomkey=za20218ja4ko380)',1023445810,0,0)
mysql error: You have an error in your SQL syntax near ',1,'Your room Key sent by, Nem','Your room is ready. It is room 7and is' at line 1

mysql error number: 1064

Date: Friday 07th of June 2002 06:30:10 AM
Script: /hotel.php?action=dobuyroom
Referer: /hotel.php?action=buyroom

[ULTIMATESSJ]

Originally posted by neo
@ULTIMATESSJ: use this


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,
PRIMARY KEY (roomactionid)
);


thanx, i got the hack installed and it works, a few little problems though, when you are talking to someone, their username doesn't show up, but only their avatar, would it be possiblt to put their entire postbit in there, also is it possible for admins to remove rooms and delete posts inside

[Chris M]

Yeh...

That would be good...

Satan

[bandersen]

This looks interesting... it would be nice if it could work with Lesanes store hack :)

[ceo_tfw]

What download do I use, there are so many I am not sure, please can you help

[bandersen]

I have a question - can the receiver ( or Mods or Admins) enter the rooms by clicking a link in the PM and avoid typing room name/key?

[Dr Shark]

Originally posted by ceo_tfw
What download do I use, there are so many I am not sure, please can you help

download the hotelv1.1.zip one i used that one and i didn't have any problems.

[grog6]

Very good hack !

Thx, just installed on a v2.2.1, it works wonderfull

I just add a little modification to refresh pages ! :lick:

[ceo_tfw]

Originally posted by Dr Shark


download the hotelv1.1.zip one i used that one and i didn't have any problems.



thanks and I have installed it, took 5 minutes on version VB 2.2.6 and it is working great

[ceo_tfw]

is there an option that after you open a new HOTEL ROOM you can pm other members with code that you want to enter

[skyline2002]

zajako:
thank you . this is very nice idea. but i think your hack still has many bugs.

just like the bug below:

in register room form, if the room opener forget to fill in some information(just like to username ),and send the form. it will show us a system error.

i think you'd better to add some javascript funcation to chcek,are the Req. information filled. if not, popup a window to tell the opener must fill in xxxxx,before send register form.

sorry about my poor english , hope you can understand it.

thanks in advance!!

[SgtSling]

is there a limit of rooms that peole can create?
Does the posts count towards the post count?

[zajako]

Allright form the top, if your question has already been answered i will answer it again, to clear it up for otehr people
Also i really do hate the quote reply posts, however, in theis situation of being rushed with questions i must :P


Originally posted by ULTIMATESSJ


thanx, i got the hack installed and it works, a few little problems though, when you are talking to someone, their username doesn't show up, but only their avatar, would it be possiblt to put their entire postbit in there, also is it possible for admins to remove rooms and delete posts inside

That is the way the hotel works, i purposely left out all the post bit stuff, cause it is meant for 2 people, in which case you will know the other person by their avatar. and if you want a username, above it read one of my previous posts on this thread explaing ho, i am not 100% sure that it will wor, however, if someone tries it please let me know. To use your post bit, i must make some majore modifications for the hack to work liek that, in which i do not have time for, however, maybe in a future update. About admins removing rooms and deleteing posts, you can do this through your database, in the hotel or hotel post tables.. I will not however make coding for them to be deleted otherwise because that defeats the purpose of 100% private rooms... Although the next big update on it may have an adminpanel option to delete a room that has not been used for a given amount of time.


Originally posted by ceo_tfw
What download do I use, there are so many I am not sure, please can you help

the one in the first thread, it is the most updated, plus on the db page that dl link is updated aswel.


Originally posted by bandersen
I have a question - can the receiver ( or Mods or Admins) enter the rooms by clicking a link in the PM and avoid typing room name/key?

they can send the url of the room to anyone, the url includes the key in it..
You may need to update, to 1.1 to fix the pm link problems, if that is what you are having


Originally posted by skyline2002
zajako:
thank you . this is very nice idea. but i think your hack still has many bugs.

just like the bug below:

in register room form, if the room opener forget to fill in some information(just like to username ),and send the form. it will show us a system error.

i think you'd better to add some javascript funcation to chcek,are the Req. information filled. if not, popup a window to tell the opener must fill in xxxxx,before send register form.

sorry about my poor english , hope you can understand it.

thanks in advance!!

These things will be fixed in the next big update, but for now it is fuctional.

Originally posted by SgtSling
is there a limit of rooms that peole can create?
Does the posts count towards the post count?

No there is no limit there will be admin features to make limits in the next big release of it. It does not count torward post count, but I may also make an admin option for it to int he next big release.

Originally posted by ceo_tfw
is there an option that after you open a new HOTEL ROOM you can pm other members with code that you want to enter

you can forward the email or pm sent to you and otehr people can enter in with the same link, cause the link includes the key.

Originally posted by grog6
Very good hack !

Thx, just installed on a v2.2.1, it works wonderfull

I just add a little modification to refresh pages ! :lick:

Cool, if you want to post a doc with the edits for that, im sure the other peopl eusing it will appriciate it :}

[AntiOnline]

Greetings:

The fix that you provided that is supposed to list the user's name above their avatar doesn't work. All it does is list YOUR username above ALL avatars.

So, in other words, if my handle is AntiOnline, it will post the username AntiOnline above everyone else's avatar too. If my name is Joe, it will post Joe over everyone's avatar, etc.

[bandersen]

Hello - I have installed (2.2.5) and it works fine.

Some input: I made the changes so that username is to show above the avatar. Last posters name show all over the place tho, and only afer posting (not when entering via the link). Is there a fix?

I hope you can also include the following in your update:
PM when someone reply to a message in the room.
Edit posts
Smilies
Resend the key/new key for those that forget.....
Expand number of characters (I just got a SQL error page when my text got too long)

Thank you for a useful hack.

ps. the download in the first thread can't be the latest as I had to use the one in post#32 to make it work.

[zajako]

hmm, i update the one in the first thread, however, you may be right.

for the username above avatars
replace the room.php with the file attached.

I have not tested this file, so i wanted to warn you of that, but it should work and be safe.

[bandersen]

Hi there, I updated the room.php.... name above avatar works when I enter via the link (correct name on coorect line), but when I post.... it only show the first letter of the correct username.
Like for my name bandersen I get a b.

[AntiOnline]

Greetings:

I have the same problem with the usernames.

[zajako]

arg, ill look into getting that to work...

If one of you too aim me at zajako2, i will be able to help you go through and get it fixed, cause i currently do not have the username stuff on my boaards, cause i did not want it... So aim me and we can get if ifixed and ill upload the changes for the fix

[grog6]

To refresh pages, just add in the template hotel_room under

<td bgcolor="{tableheadbgcolor}" colspan="2"><normalfont color="{tableheadtextcolor}" class="thtcolor"><b>Reponsez</b></normalfont></td>
</tr>
<tr>
<td bgcolor="{secondaltcolor}" valign="top" nowrap><normalfont><b>Your answer:</b></normalfont>

this

<center><br><a href="roomupdate.php?action=postreply&roomnumber=$roomnumber&username=$bbuserinfo[username]&userid=$bbuserinfo[userid]&roomkey=$roomkey"><img src="refresh.gif" border=0 alt="Refresh"></a></center>

and upload this gif to your root directory

[zajako]

I have found a fix for the usernames with help from banderson, however, the error with using ' is present on his board as well, im looking into that error...

[grog6]

For the ' error, i've the solution zajako, i try to correct it on your files and email them to you ;)

[zajako]

Alright, we got the hack fixed, ' works as well as usernames, all other errors, previously should be fixed as well.
Also i have moved it to using post bit templates now, so that you can custimise stuf flike usernames and bold stuf as you want.

to update from the previous

upload the new room.php over the old one
upload the new roomupdate.php over the old one
make the hotel_postbit template (found in the teplate folder)
make the hotel_postbit2 template (also found in the template folder)

and it should be updated

This update is hotel hack v 1.5
Ill attach it here as well as the first post, because i have been told that the first post did not work.

[zajako]

lol, grog i got it, i forgot to do addslashes

[grog6]

Oki zajako ;)

[Tenpit]

Using the ' key in a room title gives MySQL errors. For example,

Harry's Room as a room title - Throws a MySQL wobbly.

Any way around this?

[zajako]

ahh, yes, im sorry, ill get that fixed too... THis hack was kinda rushed do to a certien somebody s i forgot a lot of minor details.

Ill get this update don later on, i have work in a few.

[ZiRu$]

Can you please make it work with Lesane's store hack

[zajako]

im waing for lesane to get on icq, so i can discuss a ton of stuff with him.

[jjj0923]

it's pretty interesting but it seems like an elaborate substitute for AOL IM or am I missing something.

In any event - it's a very cool hack and thanks....but I'll still wait for a good Instant Message Hack to come along.

- jeff

[BigJohnson]

Can we make it so more than one person can come into the room because if not this hack is pretty much useless if you have a PM system. I would love this hack to allow more than one person to come in so we can have a conversation and everyone aloud in can read. This would be a lot more use ful i think. I would loe that feature in this hotel hack please. Any one?

[Shokkka]

Yea that would be cooler.

[ZiRu$]

Originally posted by zajako
im waing for lesane to get on icq, so i can discuss a ton of stuff with him.

lesane only gets on 1nce a month....u should pm him

[zajako]

I have pmed him, and we are supposed to talk on icq, i have many details to talk to him about so it needs to be live...

also more than 2 people can join a room, you just got to give them the key seperately.

[Lesane]

It's better to pm/email me since i'm not often on icq or any other chat messenger. I was a few days ago on icq, u were on away status -> sleeping..hehe.

[BigJohnson]

O thats kool. wait more than 2 can but you dont get to see there user name so what a big let down. Is there any way to make it better.

[ZiRu$]

are you gonna make this with lesanes store? I dont care how long, just wonderin if it is

[bandersen]

Zajako, was this fixed? I hope we can look into this before you get busy with the Store Hack... you see me online.

Originally posted by Tenpit
Using the ' key in a room title gives MySQL errors. For example,

Harry's Room as a room title - Throws a MySQL wobbly.

Any way around this?

[BigJohnson]

Yes this was fixed already. I would really like the thing where more people can go in and you can see everones avatar and username.

[bandersen]

I dont think it was fixed... try type that ' in the room name. The other ' error I know was fixed, as I was the test forum for that :)

[BigJohnson]

O i c i never ested that one out yet. I am going to test that right now.

[BigJohnson]

Ok everything works fine for me. This hack is amazing. I just figured out that you can add more people to this hotel. I love it. But i was wondering one thing. Do you no where you type the User name to the other person you want to send the key and stuff to. Is there any way you can make it so you can send it to mulitple people instead of just one when you are buying a room. That yould be great.

[zajako]

yes, I will do that, on my next "major" update, however, with the crash of one of my servers I am very very busy recently,

[BigJohnson]

O that sucks. Well that would be great. I can't wait for the update. This is such a great feature.

[Link14716]

Great hack!

I just hope that the full postbit template can be used in the next ver.

Keep up the good work!

[zajako]

Ok, sorry for the long delay on this updae, i have insaney busy.

The title eror is fixed, you can now have ' in it. sorry for that incovience her it is.... hotel hack v 1.6

[bandersen]

Thanks!

[bandersen]

Hi - I just upgraded, but get errors. If you see me online we can debug....

[zajako]

ok, we debugged it, the file worked, it was not a problem with the update, it was something that was never fixed from the old one. However i did fix it this time round. The attached hotel.php file is fixed, just replace the old one. The fix is when you don't fill out the pm box it gives a mysql error, now it just says bad user.

[StevenTN]

Ok I have a question... why don't the avatars work as they are supposed to? My forum has avatars that are selected by post count, and I want them to be used instead of having a "No avatar selected" graphic. Also, I want the Post Reply Box BEFORE the footer (it shows up after the footer). Look at the attachment.

I haven't been screwing with the templates or anything by the way.

[Erwin]

Bug:

The new hotel.php file still has errors - you are still sent a key in PM and new rooms are still being made even if not all the fields are filled in.

Suggestion:

How about an automatic database pruner that deletes old rooms automatically, eg. after 2 weeks - otherwise I can see the database explode with old rooms filled with posts that no one else reads.

[zajako]

Ok I have a question... why don't the avatars work as they are supposed to? My forum has avatars that are selected by post count, and I want them to be used instead of having a "No avatar selected" graphic. Also, I want the Post Reply Box BEFORE the footer (it shows up after the footer). Look at the attachment.

I haven't been screwing with the templates or anything by the way.

whatver custom hacks you are using, probably are not compatible with it. Your avatar system, would have to be custom done on this hack. And i usually do not do custom hack jobs for people.

and erwin, ill fix those errors with it next time i get a chance. about tha suggestion, its not a bad one, however, i would have to completey redo the hack for that. And i do not have the time to do that.

[BigJohnson]

What is going on with the big update with this hack. Will it had a field to sent the key to multiple users? Will it delete rooms after a certain time they have not been finctional? PLease incluse these new things. That would be so great thanks. Please also tell us what is in the new update u are ging to release. Thanks so much.

[StevenTN]

Originally posted by zajako


whatver custom hacks you are using, probably are not compatible with it. Your avatar system, would have to be custom done on this hack. And i usually do not do custom hack jobs for people.

and erwin, ill fix those errors with it next time i get a chance. about tha suggestion, its not a bad one, however, i would have to completey redo the hack for that. And i do not have the time to do that.

It is not a custom hack at all... we are simply using the usertitle over the avatar, and have an image tag within the usertitle to draw an avatar. I'd like to be able to use those usertitles anyway within the hack. The Entry for the usertitle looks EXACTLY like this...

Jr. Poster<br><img src="http://www.coasterforum.com/images/rank01.gif">

I don't see it too hard to include it in a newer version, plus you might want to fix some grammar problems in some of your scripts (like the e-mail/PM that goes out to the users who request a room).

[hypedave]

I found a bug in this hack, none of my users are aware of it yet, but soon someone will find it,

here is what happened, two of my users were in the hotel room

I went to go view Whosonline and saw the link to their hotel room, clicked on the link and Boom it entered me into their hotel room, i could see all previous conversations they were having

has anyone ran into this problem yet ?

[BigJohnson]

ouch that couns pretty bad but i found thatone out and i gixed that. Just change the url part for the online.php part in the hack.

[hypedave]

Originally posted by BigJohnson
ouch that couns pretty bad but i found thatone out and i gixed that. Just change the url part for the online.php part in the hack.


how and where in the online.php did you change that, because I hace searched my online.php and the store hack is no where in there. also the install instructions do not refer to the online.php

thanks,

[BigJohnson]

When do you think that database thing add on can be made. That is like something that is really really needed.

[ZiRu$]

when will it work with the Store Hack?

[Keta]

i would really love to add this to my store...nice hack!!

[BigJohnson]

Hey whats going on with the big update for this hack. I think it should have something where you can go to the admin CP and prune rooms and posts. That is somehting I think which is need for that hack because The rooms cant just stay in the database. It takes up way to much room. Are you doing anything about that hack because you said there was a big update a while ago hehe.

[Neo]

LOL, I would really love to add the quick reply hack to my store when will that be added?

[ZiRu$]

Originally posted by BigJohnson
Hey whats going on with the big update for this hack. I think it should have something where you can go to the admin CP and prune rooms and posts. That is somehting I think which is need for that hack because The rooms cant just stay in the database. It takes up way to much room. Are you doing anything about that hack because you said there was a big update a while ago hehe.

word

[traekwon]

I'm getting an error with the room name on top of each room. Instead of the title, it just says "A".

What's wrong?

[ZiRu$]

Damn this thread had potentional

But you gotta put the time into it....and fill our add-on requests

[bandersen]

Hi Zajako - do you have time to include the control panel part of this hack? We launch in Sept. and I think I must take it down if I can't somehow control things.....

[Link14716]

Originally posted by bandersen
This looks interesting... it would be nice if it could work with Lesanes store hack :)

As it seems by popular demand (and for my own pleasure) (I have ALWAYS wanted to say that ;)), I have whipped the code together get this hotel hack to work with Lesane's Store Hack, where people have to spend money on a room rather than just getting it for free. Expect this to be released by today/tommorow (for whatever time zone your in). :)

DISCLAIMER: I own nothing.

EDIT: It's up: https://vborg.vbsupport.ru/showthread.php?s=&threadid=41525

[Link14716]

Originally posted by traekwon
I'm getting an error with the room name on top of each room. Instead of the title, it just says "A".

What's wrong?

I also got that error in v1.6. To fix it, downgrade to v1.5.

[momzone]

Originally posted by Link14716


I also got that error in v1.6. To fix it, downgrade to v1.5.

I could not find V1.5 so I did a workaround on V1.6 that corrects the "Room Name" problem.

Look in the room.php file near line 33 for this code.

$roomname= stripslashes($roomname);

and either comment it out or remove it and now the "Room Name shows up.

[Link14716]

Post with v1.5 (https://vborg.vbsupport.ru/showthread.php?postid=259973#post259973)

But if that walkaround works (haven't tried it, sticking with 1.5 for now), then I'd stick with 1.6 and use that walkaround :)

[hondastyle]

Originally posted by hypedave



how and where in the online.php did you change that, because I hace searched my online.php and the store hack is no where in there. also the install instructions do not refer to the online.php

thanks,


Go to your online.php file and find this line of code (around line 267):

$userinfo[where] = "<b>Unknown Location:</b>
<a href=\"$userinfo[location]\">$userinfo[location]</a>";


change it to:

$userinfo[where] = "<b>Unknown Location</b>";


Hope this helps.

[proxyMX]

The idea is amazing, And im already using it, however an upgraded design wouldnt hurt, but i dun wanna touch the code incase it bites, and this SERIOUSLY needs an admin cp on my server phpadmin takes ages tp aces

[zajako]

"Hi Zajako - do you have time to include the control panel part of this hack? We launch in Sept. and I think I must take it down if I can't somehow control things....."

I have lost my isp and it is hard to test coding.. I am online at my parents house so its a lil hard to do this.
Hopefully ill make the new version before sept. I hope to have a connection by that time...

[proxyMX]

I found out how to modify the design, using the templates doh! I Think all the CP needs is some easy integration with SQL queries, i think Firefly made a hack for this, perhaps you could build upon it and modify it for the hotel,

[Link14716]

zajako, you might need to add some code to online.php. Hold on whilke I make it, because Unkown Location leads to a room, and I want to know where the location is. Hold on.

[eXtremeTim]

Link hurry up and make that code please. :)

[eXtremeTim]

Major bug. HTML works in the rooms.

[Link14716]

Yes HTML works in rooms, it isn't a bug, but it could be pretty bad. I don't know enough PHP to tell you how to fix it (and really I have HTML enabled everywhere, so....), but, here is the Who's Online Code....

In Online.php:

Find: case 'gallery':
$userinfo[where] = "Viewing Picture <a href='gallery.php?s=$session[sessionhash]'>Gallery</a>";
break;

Add After: case 'hotel':
$userinfo[where] = "At The <a href='hotel.php?s=$session[sessionhash]'>Hotel Enterance</a>";
break;
case 'room':
$userinfo[where] = "In A Hotel Room";
break;

Also in online.php
Find: case 'gallery.php':
$userinfo[activity] = 'gallery';
break;
Add After:
case 'hotel.php':
$userinfo[activity] = 'hotel';
break;
case 'room.php':
$userinfo[activity] = 'room';
break;

[eXtremeTim]

See i know alot about php but im not familar with the vb's html stripping coding.

[DarkDraco07]

AHHH i know this is old but why is this happening!!!
when i click on the click here link in the private message it goes to www.your-site.com/blahblah
I CANT FIX IT!!!!!!!!!!

[DarkDraco07]

SOMEONE PLEASE HELP, IM GONNA DIE

[DarkDraco07]

SOMEONE LOOK IN THIS THREAD AND HELP ME!!!!!!!!!

[proxyMX]

" well, im almost positive it has some security holes"

Security Holes? This thing is TOTALLY unacceptable security wise, ive had to remove it because my users were complaining that people were setting up "warez" Rooms, as in rooms they hadnt bought from lesanes store.

[supersimon]

i cant see tha text i started posting in my hotel and now it doesnt show teh text teh background is black and teh text is black how can i chnage this i looked in all tha templates but i had no luck can someone hepl ???????

[zajako]

dark it tells you in the instructions, there is a place where you must edit out all the your site lines to your sites's url
also the lesane modification i did not make otherwise i would make it more secure... it was made to be free not cost gold of sort so that means i did not need to secure the creation if it was free...

there are a lot of securty bugs with it and i really don't have time to modify it. i ahve devoted all my time for hacking to my rpg hacks, then i will come back and upgrade these when i finish them. sorry for all those i have inconvienced, ,and if someone wants to amke updates for it they may feel free to attach there mods to this thread. I hope to have my rpg hack done in 1 to 2 months from now, if not sooner. At this rate it coud be sooner.

[supersimon]

i cant see tha text i started posting in my hotel and now it doesnt show teh text teh background is black and teh text is black how can i chnage this i looked in all tha templates but i had no luck can someone help ???????

[Colon33]

Hey Zajako. Is there anyway that this can be integrated into Vivi's Itemshop? Cause i was thinking that points could purchase a hotel room. Would be a really cool addition i think. Or just someway that when you click a getting a room it would take away a certain number of points from you that you acquired from the itemshop add-on. :) Let me know, i am really interested, i tried myself but as of yet, unsuccessful.

[Link14716]

Vivi's itemshop is not ment for that, Lesane's Store is, and I already released said addon. Link's in siggy. ;)

[Colon33]

What exactly is LESANES store hack? Can it be used just like VIVI'S? Cause i was under the impression it used REAL money. Or do people gain points by posting and they can buy items like in VIVIS's shop. Do the items people buy get displayed in there POSTBIT? See i run a SEMI-RPG board and VIVI's shop is great.

Also how can i fix the error in the HOTEL Hack here. I get a Database error when i dont fill in a persons name as the second person to get a KEY. I cant just leave the bottom part blank. How can i fix this?

[Link14716]

Lesane's Store is VERY similar to Vivi's, but instead of items, the store hack let's you do things with money (earned by posting) like Changing your Custom Title, Username, etc.

But hell, I could easily make one up to work with the Itemshop, should be even easier than the Store version :)

[Colon33]

Cause thats what i am looking for really. Maybe an itemshop built into the store hack. Cause i like the features of the store hack but its doesnt have options to make items that users can buy and have little icons next to there names... Cause Vivis item shop is still amazing if not a little rough around the edges. Descriptions, icons, the works. Just like VIVI's. It would be great if you could make something like this. :)

[Link14716]

Well, I made my hack to integrate the store hack work with Vivi's Itemshop, will post in a second.

EDIT: https://vborg.vbsupport.ru/showthread.php?s=&threadid=43524 :)

[dynamite]

Is it possible to make the script where you are only able to have a room for a certain period of time, after that you would have to get a new one. The reason I ask is I am using the hotel/store integration hack and think it would be great if people had to buy the room and then it would only be available for say 24 hours (kind of like a real hotel room), after that they would have to buy a new room. This would encourage people to participate more and earn more points so they could keep buying new private rooms, rather than get the private room and have it forever! Thanks!

[nbb]

Works fine on 2.2.8., only one problem...

at: "http://www.mydomain.com/forums/room.php3?action=enterroom&roomnumber=1&roomkey=za3ja0ko41"

I get twice an errorline on the to saying:

Warning: Using scalar variable $roomname as an array or object in /homepages/xx/xxxxxxx/htdocs/board/room.php3 on line 101

Can anybody help?

[Schorsch]

thanks for your work :)

seems to work fine :banana:

regards,
Schorsch

[ZeroXcape]

Originally posted by dynamite
Is it possible to make the script where you are only able to have a room for a certain period of time, after that you would have to get a new one. The reason I ask is I am using the hotel/store integration hack and think it would be great if people had to buy the room and then it would only be available for say 24 hours (kind of like a real hotel room), after that they would have to buy a new room. This would encourage people to participate more and earn more points so they could keep buying new private rooms, rather than get the private room and have it forever! Thanks! I totally agree. I'm using it the same way with the store hack... it'd be nice to limit these hotels somehow.

[Link14716]

Well, I did do something like that for my Arcade Pass Hack for the arcade. I'll see what I can do. :)

[vetrivex]

I don't see anywhere in the hotel.php where it has http://yoursite.com/forums.......

[vetrivex]

never mind, I found it, it was labeled www.yoursite.com/forums yet in the .php it was www.your-site.com/forums

just thought I'd clear it up ;)

[superman]

hummm, does anyone know if this works for 2.3.0?

*notices his old name is vetrivex* I wonder why it wouldn't let me post anymore, it was set in my vb licesne screen *shrugs*

[trafix]

Sorry guys, I appologise, its just that i have spent a bit of time in this...

1) room name dosnt show up
2) link is displayed in online.php

need to fix there bugs

[xs1]

Invalid SQL: INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title ,message,dateline,messageread,folderid) VALUES (NULL,,,1,'Your room Key sent by, Admin','Your room is ready. It is room 1and is named 1. Your key is za6084ja55ko559. To goto your room click here (http://www.*/board/room.php?action=enterroom&roomnumber=1&roomkey=za6084ja55ko559)',1052652591,0,0)
mysql error: You have an error in your SQL syntax near ',1,'Your room Key sent by, Admin','Your room is ready. It is room 1and is named' at line 1

mysql error number: 1064

Date: Sunday 11th of May 2003 12:29:51 PM
Script: http://www.*/board/board/hotel.php?action=dobuyroom
Referer: http://www.*/board/hotel.php?action=buyroom

[Holidazed]

Well, it seems I have a problem

the hotel hack works great if the fields are filled out. However if "Where do you want the other key sent?" area blank (the spot where you put in a PM account) it gives the following error. However, if you select email and leave it blank it works just fine.

Ideas??


Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title ,message,dateline,messageread,folderid) VALUES (NULL,,,724,'Your room Key sent by, DK','Your room is ready. It is room 9 and is named . Your key is za22863ja3ko83. To goto your room click here (http://www.DungeonKeepersDomain.com/mb/room.php?action=enterroom&roomnumber=9&roomkey=za22863ja3ko83)',1056148907,0,0)
mysql error: You have an error in your SQL syntax near ',724,'Your room Key sent by, DK','Your room is ready. It is room 9 and is named' at line 1

mysql error number: 1064

Date: Friday 20th of June 2003 06:41:47 PM
Script: http://www.DungeonKeepersDomain.com/mb/mb/hotel.php?action=dobuyroom
Referer: http://www.dungeonkeepersdomain.com/mb/hotel.php?action=buyroom

[Holidazed]

Hello? Anybody home?

[yavar]

1) room name dosnt show up
2) link is displayed in online.php
3) user can't reset posts
4) user can,t change password
need to fix there bugs

[mariannet]

I hope omeone can help.

Everything installed ok, but I keep getting told that the table isn't there, even though it is:

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO hotel (roomnumber,roomname,roomowner,ownerid,roomkey,sen dkey,keyrecipiant) VALUES (NULL,'DulleMors Oase','DulleMor','1','za17388ja65ko365','1','')
mysql error: Table 'duller3.hotel' doesn't exist

mysql error number: 1146

Date: Sunday 12th of October 2003 07:24:29 PM
Script: http://cgi.dullernes-univers.dk/ms/ms/hotel.php?action=dobuyroom
Referer: