vb.org Archive - vBookie for vBulletin 3.5

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:

Code:

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

02-24-2007 01:13 AM

Quote:

Originally Posted by BozzaJos (Post 1189083)

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:

Code:

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

02-24-2007 09:37 AM

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

02-24-2007 11:06 AM

Quote:

Originally Posted by BozzaJos (Post 1189619)

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

BozzaJos

02-24-2007 11:33 AM

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

02-24-2007 12:39 PM

Quote:

Originally Posted by BozzaJos (Post 1189644)

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

02-24-2007 01:39 PM

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

02-24-2007 02:00 PM

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

BozzaJos

02-24-2007 02:07 PM

Quote:

Originally Posted by ShayOUU (Post 1189712)

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

Yes, just upload it all to the forum root.

ShayOUU

02-24-2007 02:14 PM

and is this intergrateable with VbPlaza 1.5.8?

All times are GMT. The time now is 06:52 PM.

Page 138 of 244

138

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03577 seconds Memory Usage 1,745KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: