Major Additions - The Gameroom - Multiplayer gaming (follow up to Casino)

For vb 4.x: https://vborg.vbsupport.ru/showthread.php?t=239817

This is a late-Beta, it has been tested fairly extensively and all the big kinks should be worked out. That said, once this hits more sites a couple other bugs are bound to work themself out. It works going back at least as far as the 3.6 branch of vBulletin, not sure about 3.5.

This is the free version of The Gameroom by http://vbgaming.org, the follow up / expansion of the Casino plugin for vBulletin. It improves the multiplayer gaming aspects by bringing in more games, and allowing users more options when starting and joining games. Included is a upgrade script for transfering your stats from the Casino to the Gameroom.

Multiplayer games are played live, with embedded chatrooms

Features include:

- Lobby
--- Chatroom for arranging games

- Solo Games
--- Blackjack
--- Let it Ride
--- Roulette
--- Video Poker
--- 3 different slot machines

- Texas Hold'em
--- Multiple tables
--- Customize blinds and rules when creating a game
--- Passwords for private games
--- vBulletin avatars in game
--- Alert sounds to notify to alert you when it is your turn

- 7-Card Stud
--- Multiple tables
--- Set Ante
--- Passwords for private games
--- vBulletin avatars in game
--- Alert sounds to notify to alert you when it is your turn

- Chess
--- Standard chess rules, with legal moves enforced.
--- Alert on Check and Checkmate
--- Tracking of the 50-move rule and Threefold repetition rule
--- Passwords for private games

- Reversi (aka Othello)
--- Legal moves enforced.
--- Passwords for private games

- Statistics
--- Redesigned offering graphs and sortable datagrids

- Betting
--- Module can be turned off if not in use
--- pool bets, where the bets are added together and dived amongst the winners

- Optional status bar
--- Choice of flash or html bar
--- Placed in main template
--- Shows current gameroom status (open multiplayer games, messages can be sent from within, # of open bets in betting module)

- Cash Bonuses for actions that benefit your site
--- Posting
--- Starting threads
--- Referalls
--- Daily sign in
--- Giving rep
--- Recieving Rep
--- Voting
--- Rating threads


August 1st - 0.9.8
- Added Settings to admin section
- Reversi board colours can now be changed
- Reset stats option
- Delete event option (event must be closed & settled first)
- Reduced cpu load of chess and reversi
- Blackjack - Added Surrender option
- poker - players with no money cannot continue
* Update -> upload & overwrite, import product file


0.9.9

- Added volume control
- Added "/buzz" chatroom function
- Added alert to user entering room
- Added audio alert to 'check' in chess
- Fixed bug with getting list of games when certain tabs are dissabled
- Fixed get games timer not shutting off properly when switching tabs
- Fixed decimals in poker when using different cash type
- Fixed names with certain characters messing up stats
- Fixed bug that caused "start game" box to uncheck if you entered a message
- Adjust cash can use userid / usergroupid as well as name
- Not logged in screen in language (can be translated / edited)
- The user that imports the product file is made a admin & mod, rather then using "1" as a default
- cash type to 64-bit value in flash component (for those with really high values)
- Poker time out is set up. You have 60 seconds to act, then forced fold. Warning buzzer and countdown starts at 20 seconds remaining
* Update -> upload & overwrite, import product file


August 3rd (0.9.9RC)
- Update cash in solo games and betting on enter & transfer
- Change event listener on colour selectors in settings, makes it stick properly.
- Theme colour updates on the fly when changed, so you can see what things will look like as you adjust it.
- Fixed a glitch in the board games that would bring text into the game chatroom from the Lobby chat room.
- Fixed a bug relating to the board games when other sections had been turned off
- Added payout chart to game screen for Slots, Video Poker & Let it ride
- Border changes with theme color

1.0.0
- Fixed up some language things
- Added a plugin to cache the html banner templates

1.0.1
- Bug: checkmate on promotion
- Bug: poker all in led to dropping player early
- Bug: foreign language fixes
- Bug: Double posts in chatrooms
- Bug: Update betting cash on tab click
- Bug: Poker Blinds go into pot, even if player can't make them
- Status bar colour updates with Theme
- Possible outcomes in betting up from 8 to 18

Note: There is a 2mb upload limit, so the flash banner came out of the main .zip which finally pushed itself over 2mb.



1.1.1


1.1.1
- Bug: Double entries on betting resolved
- Bug: Fixed error when two players tie with full house
- Bug: Top Poker Players stats displays properly
- Bug: User name colours in lobby now 'stick'
- Edit language is now a tree view, default phrase displays properly
- in game & add game phrases for poker are now in language
- "Players" phrase in Flash Banner reacts to changes in language
- Default Cash is now editable
- Disabled Hooks on XML calls, may improve speed slightly, decrease chances of conflict
- Can override general usertype permissions for each group of games
kjack push when both player & dealer have a blackjack
- Chatroom 'flicker' on new message
- castle through check
- Add users in gameroom count to link
- Seperated framework, Flash caches this once, and only once. Resulting in a smaller file size everytime after the first. It is cached across sites as well, so there is a good chance most people already have it
- Roulette history was showing '37' when it landed on '0'
- Chess - Optional grid labels / moves in chat box

Updating:
1) Upload the framework files, they should go into the main forum folder with the .swf files folder. You will only need to do this once, which is why they are in a seperate file.
2) Upload the files in the main package, make sure everything overwrites old copies.


*********************************
** Common Problems **
*********************************

Non-english letters are not working properly

This is a problem with flash player and has been in there bug tracker for a long time. The workaround is to edit the "gameroom" template, remove the line that ways "wmode='transparent'", the downside it your popup menus will come up behind the flash box, rather then in front of it.

Images are working in IE, but not in Firefox

You likely have some form of image hot linking turned on, it is causing the requests for the images to be blocked.

Locked self out of admin panel

In the tools folder there is a file called 'makemeadmin.php', upload this and go to that page. It will make you admin, don't leave it on your server when you are done.

Updated and it is acting funny

Make sure all of your files are up to date. When you update ensure that all files are overwritten. Having mix matched files will cause funny behaviour. You may also have to clear your cache and reload the page after uploading a new gameroom.swf file.

*********************************
** Uninstall **
*********************************

If you want to uninstall the following procedure will get you through it without tossing any DB errors:

1) Dissable the product, this shuts down all the plugins. If the files are removed and plugins are still active you may see errors on your site.

2) Undo the template changes, changes where made to the navbar template and the postbit / postbit legacy template.

3) Delete all files. If the files are still present and you remove the database entries by uninstalling the product anyone that attempts to access one of them will cause a error. The Flash Banner could cause many as it could still be making calls after the template changes are undone.

gameroom.php
gameroom.swf
gameroomBanner.swf
gameroom/*
includes/cron/gameroom_nightly.php


4) Uninstall the product file, which removes all database entries, that means the following are removed:

tables with 'gameroom_' as a prefix
gameroom_cash field within the user table

[tandy]

Try to update from 0.9.9rc to 1.0, the progress bar expand without stopping and the database crash.
I had to restore my database since the forum was completely out.

Database error in vBulletin 3.8.3:

Invalid SQL:
ALTER TABLE gameroom_chatlog ADD COLUMN soundfx TEXT;

MySQL Error : Duplicate column name 'soundfx'
Error Number : 1060
Request Date : Wednesday, August 5th 2009 @ 07:27:21 AM
Error Date : Wednesday, August 5th 2009 @ 07:27:21 AM
Script : /admincp/plugin.php?do=productimport
Referrer : /admincp/plugin.php?do=productadd
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.81-community-log

[Andrew Green]

Originally Posted by hassshasss

the problem is multi-player poker game cards, and users do not appear.
In a free version. What is the solution?
Below is a screenshot.

I responded on the other site, but it looks like your backend and frontend versions are out of sync, upload again making sure to overwrite everything. Clear your cache and reload.

Originally Posted by tandy

Try to update from 0.9.9rc to 1.0, the progress bar expand without stopping and the database crash.
I had to restore my database since the forum was completely out.

The error you received is a table not getting removed properly on uninstall, won't effect anything as it is trying to redo something that is already done.

Your board problems likely came from taking down the product, but still having people trying to access the files (including banners)

You should never have to uninstall a product to upgrade, just tell it to overwrite.

[dancue]

Originally Posted by Andrew Green

yep, completely forgot about it as it got buried

Here is my first thought, How would such a feature be moderated? If I where to implement it that would probably be the first thing everyone would ask, is how do they control it and keep people from abusing it?

Involving moderators I think would be a mistake, so it would have to be purely honor system. But if there is a interface to do it, disputes are going to end up going to the moderators / admins.

To be honest I'm not sure I see how this would be a benefit, more then a potential headache, over me saying "I'll bet you 100 that ____ happens." and settling through the transfer cash feature.

But if you can sell me on it I'll put some though into it



Well, your "language.php" file isn't where it was expected to be. It should be in the "gameroom" folder, which should be in your forums root folder.

Would you mind me sending you a pm?

[Andrew Green]

Originally Posted by dancue

Would you mind me sending you a pm?

not at all

[Megatr0n]

Andrew, if we overwrite settings.php, will we have to make the edit once more to integare with other cash systems?

Plus, for this update are we required to overwrite that particular file?

[Andrew Green]

Originally Posted by Megatr0n

Andrew, if we overwrite settings.php, will we have to make the edit once more to integare with other cash systems?

Plus, for this update are we required to overwrite that particular file?

If you have been editing your settings through the admin tab overwriting the settings file will not overwrite your settings. Nothing was changed in that file from the last update, I believe the last thing to go into it was the Reversi board colours so if they are in there its up to date.

[macc]

get same database error - and will just overwrite product file ( import) - nothing was uninstalled

all files was uploaded

PHP Code:

Database error in vBulletin 3.8.3:
Invalid SQL:
ALTER TABLE gameroom_chatlog ADD COLUMN soundfx TEXT;
MySQL Error   : Duplicate column name 'soundfx'
Error Number  : 1060
Request Date  : Wednesday, August 5th 2009 @ 11:13:33 AM
Error Date    : Wednesday, August 5th 2009 @ 11:13:33 AM
Script        : http://xxxx./plugin.php?do=productimport
Referrer      : http://xxxx/admincp/plugin.php?do=productadd
IP Address    : xxx.xxx.xx.x
Username      : xxxx
Classname     : vB_Database
MySQL Version : 5.0.81-community 


some fix?

reg

macc

[yotsume]

Banning Individual Members?

Please tell me there is a way to ban a single specific member from using the gameroom?

After all my hard work I have to disable this wonderful mod because there is no way to ban individual users that I can find.

Did I miss something?

CAN YOU AD THIS FEATURE ASAP!!!

[tandy]

Originally Posted by Andrew Green

I
The error you received is a table not getting removed properly on uninstall, won't effect anything as it is trying to redo something that is already done.

Your board problems likely came from taking down the product, but still having people trying to access the files (including banners)

You should never have to uninstall a product to upgrade, just tell it to overwrite.

I always overwrite and still the same error.

[Andrew Green]

Originally Posted by tandy

I always overwrite and still the same error.

Maybe vb doesn't like my 3 digit version numbering... I'll have to look into that.

Reuploaded with it told to ignore the error. If you have already installed this will do nothing, and nothing needs to be done. Just will prevent more questions about that