vBookie for vBulletin 3.5

vBookie

Introduction

This is a Port of the original vBookie Hack created by tdjrico; full credits to him for the idea and the kind permission to port his work

A t t e n t i o n
This Hack is unsopported and incompatible with vBulletin 3.6+
You are hereby advised to not use it.
Please do not ask me about support and/or updates - there will be none.

[BozzaJos]

Hey guys,

First of all, this is an awesome hack, many thanks Andreas for making this for us! I've got an error tho when I go to Bet Statistics. I got the following error:

Invalid SQL:
SELECT username, bankmoney+money AS cash FROM user ORDER BY cash DESC LIMIT 5;

MySQL Error  : Unknown column 'bankmoney' in 'field list'
Error Number : 1054

I have no clue what this means or how to fix this. Could anyone help me out with this problem?

[sinisterpain]

Originally Posted by BozzaJos

Hey guys,

First of all, this is an awesome hack, many thanks Andreas for making this for us! I've got an error tho when I go to Bet Statistics. I got the following error:

Invalid SQL:
SELECT username, bankmoney+money AS cash FROM user ORDER BY cash DESC LIMIT 5;

MySQL Error  : Unknown column 'bankmoney' in 'field list'
Error Number : 1054

I have no clue what this means or how to fix this. Could anyone help me out with this problem?

Do you have a cash system installed ? If so did you set the value in vbookie settings for it?

[BozzaJos]

I used the file you posted a couple of pages back. The one with iCash automaticly build in. Got iCash installed and put the settings on use iCash.

The rest also works. I can bet on matches, it takes away the points from the user and when I win I get the points so vbookie recognizes the points system.

[sinisterpain]

Originally Posted by BozzaJos

I used the file you posted a couple of pages back. The one with iCash automaticly build in. Got iCash installed and put the settings on use iCash.

The rest also works. I can bet on matches, it takes away the points from the user and when I win I get the points so vbookie recognizes the points system.

Are you running Ibank with this? The error seems to point to bankmoney.

[BozzaJos]

Nope, I don't have iBank installed. Really hope you (or someone else) can help me out with this problem. Don't like making it public to my members while there's a db error in it.

[sinisterpain]

Originally Posted by BozzaJos

Nope, I don't have iBank installed. Really hope you (or someone else) can help me out with this problem. Don't like making it public to my members while there's a db error in it.

I just fixed the problem you are having with my files. Please download my zip again, the only file you need to upload to your webserver is the includes->functions_vbookie.php file.
I had changed the functions file to include Ibank money table to show the richest user in vbookie. Let me know if this resolves the issue.

[BozzaJos]

Very nice! It's all good now.. many thanks for your help Sinister.

By the way, I tested this hack by creating a new event. When I made this event there were suddenly two items @ vbookie.php. When the event was over and I cashed out the winner, the first item stayed there. When I click on Thread or Info it says "No Thread specified. If you followed a valid link, please notify the administrator". Is there any way of removing this item (probably in mysql table??)? My knowledge about this all isn't so big so if anyone could help me out (with details), I would appreciate it a lot. Thanks in advance.

And thanks again Sinister for fixing my original problem.

P.S. Another small question. I make events for Football (Soccer) matches. I want to do that you can say which team wins or a draw. However, the odds for the outcomes are most of the times 2.7, 1.5, 3.6 etc. etc. When I did the test event I noticed that you can't do numbers with 1 decimal.. only full numbers. It automaticly made 3 of 2.7 and 1 of 1.3. Is there a way to work with decimals? Only thing I could think of is doing for example 27 to 10, this automaticly makes it 2.7 to 1. But I was wondering if there might be an easier/more logical way of doing this?

[ShayOUU]

where do you upload the contents of the upload folder too? forum root?

[BozzaJos]

Originally Posted by ShayOUU

where do you upload the contents of the upload folder too? forum root?

Yes, just upload it all to the forum root.

[ShayOUU]

and is this intergrateable with VbPlaza 1.5.8?