I get this error message when installing.. It gets to the "do database modifications" part and then I get..

Database error in vBulletin 3.0.1:

Invalid SQL:
CREATE TABLE vb3_vbookie_groups (
group_id SMALLINT UNSIGNED DEFAULT '1' AUTO_INCREMENT NOT NULL PRIMARY KEY,
group_title VARCHAR(255) NOT NULL
) TYPE=MyISAM

mysql error: Invalid default value for 'group_id'

mysql error number: 1067

Any solutions?

Josh

Same problem here, Just a blank page, followed the instrunctions to a max, still just blank, how did you solve it, since your page now works?

If you followed the instructions perfectly, it would work. That's the way these things go.

Is there a possibility that you have more than one Style available on your forums?

And that the default one is not the one you are looking at?

Most automatic Template installs add the new templates to one style only, requiring the Installee to manually copy and paste the info into other templates.

The fact that nothing is being shown on vBookie.php might suggest that a required template isn't present in the database. The installer only add templates and phrases to the default style (he should if you have another style with the same id then it doesn't work for the default, too), and if you are using a style that's not based on the default you might find that the templates aren't picked up.

Try editing vbookie_install.php and changing "$styleid=$vboptions['styleid'];" (appears twice) to "$styleid=N;" where N is the styleid of your style.

(thanks to Rico for this hint)

Haven't touched templates yet, still using the No.1 one, basic default one.

Changing styleid to 1 doesn't make sense since its default.

All templates are added, same with phrases, databases are made etc... this is just ... :(

Went through the cfg/install, didn't find it.

Going to bring my laptop to work and do a clean install of vb3 and then throw vbookie in there.

If this is the case the installer should work perfectly, an untouched version of vb3 fresh from the factory? :)

I get this error message when installing.. It gets to the "do database modifications" part and then I get..

Database error in vBulletin 3.0.1:

Invalid SQL:
CREATE TABLE vb3_vbookie_groups (
group_id SMALLINT UNSIGNED DEFAULT '1' AUTO_INCREMENT NOT NULL PRIMARY KEY,
group_title VARCHAR(255) NOT NULL
) TYPE=MyISAM

mysql error: Invalid default value for 'group_id'

mysql error number: 1067

Any solutions?

Josh

Hey, I installed vBookie and I get this message. How can I fix it. Thanks :)

------------------------------

Warning: set_time_limit(): Cannot set time limit in safe mode in /public_html/forums/vbookie.php on line 20




Unable to add cookies, header already sent.
File: /public_html/forums/vbookie.php
Line: 20

EDIT: Fixed, I had to change line 20 to:

//set_time_limit(0);

Installed Vbookie and now my permissions for vbarcade aren't working.

Cbookie installation asks me to change the following lines ..

'stylecache',
'arcadesettings'
), $specialtemplates);

What should i do here? Or does that even effect my permissions.

Thanks.

Clicked Install. Great work.

EDIT* I found the problem, thanks

It's possible to have real time odds that change with the bet of user.
Example if all user bet on only two chance, they ar little odd etc...

Perhaps a good idea to futur version ?

I have asked this 6 times now. I also see that other users are asking questions, but not receiving any help. I have waiting patiently for almost a month for some sort of answer, or even a response from the creator or ANYONE that may have seen this SQL error before.

I get this error message when installing.. It gets to the "do database modifications" part and then I get..

Database error in vBulletin 3.0.1:

Invalid SQL:
CREATE TABLE vb3_vbookie_groups (
group_id SMALLINT UNSIGNED DEFAULT '1' AUTO_INCREMENT NOT NULL PRIMARY KEY,
group_title VARCHAR(255) NOT NULL
) TYPE=MyISAM

mysql error: Invalid default value for 'group_id'

mysql error number: 1067

Any solutions?

Josh

Great add-on. All my members are loving it! Would it be possible to include an edit function when bets have been settled, because one of my members did it wrong, and we cant edit the results of the bets?

Also, is it possible to simply clear all the bets made, give everyone 500 vcash and start over again?

I just added it to my largest site and it's an instant hit.

The feedback I've had so far:
- Add vCash to profile, not userbit (something I'm doing).
- More leaders lists then just the top 5 richest. Perhaps a page in itself just for leaders. Overall, last week, last month.
- Categorized leaders.

Suggestions from me:
- Have a "max bet" amount for an event. Here's why: say I want to encourage people playing and I say - new category starting over the next month: whoever gets the highest in the category at the end of the month wins a prize. Well - new members (and members who are unlikely) will be at a huge disadvantage for the prize if I let any amount be bet on these events. Therefore, if I were to say "100 max" or something like that, I can make it a much more even playing field for all involved. Outside events can still be whatever, but these "prize events" need more control over them.

Thanks for listening :)

searched, but can't find anything...
users needing charity aren't getting it (yes, it's on in options).
Any ideas?

Ok i'm trying to install this hack and everything has gone fine up to this point.
i've already installed uShop_&_uCash_095a and the problem i'm having is this part in the INIT.PHP file..
the hack says
FIND
REPLACE WITH
but the ushop hack has already changed tis part into this
and if i try to include the other code like this.
i get this error

any help on this would be very grateful :)

You missed something out. Try this

Im not sure but that should work, i have not got the shop hack installed.

thanx alot that did the trick =]

ok i dont know if this has been covered cause this thread is huge, but i use ucash, and the vbookie works and all but its using its own money system and not the ucash like i selected it to use in the vbookie control panel, help is GREATLY appreciated.

/me clicks install!

i hate to be a bother, but i really need this fixed as the members want to use this hack. thanks again

just installed 1.0.4 - seems to be working ok not really tested it alot yet seems good though,

although i have one problem though, in the adminCP there is no menu on the left for me to get into the settings for it, any idea what i might have done as i have checked the edited files and they all seem ok, any ideas?

thanks
Rob

You didn't edit forums/admincp/index.php correctly, or not at all.

Installed. Great hack. Works well on vb 3.0.3 (just took some time finding some of the code that had changed since the code has changed since 3.0.0).

However, it isn't sending pm's or emails to those who have placed bets, to notify them of the bet being settled.

The vbookie_email_betsettledbody template says:
But there are no vBookie settings for members that enable/disable email alerts. Wuttup?

Also, how can I place betting limits? I think someone else asked about this previously, but I don't recall seeing a response. I'd like to be able to limit the amount of bets at times, for specific bets. Is this possible?

i have sorted the problem now

inside admincp/index.php

there is 2 lines which match this one
if (can_administer('canadminstyles'))

i added the construct nav commands at the wrong part of the doc.

all sorted now though

Also, there seems to be an error when calculating "Total Amount Staked".

While for the individual outcomes, it calculates it fine...it is in the top summary of each event that it miscalculates. Instead of adding up all that has been staked...it doubles the actual total staked in each outcome.

If you click info, then add up for each outcome, the "Total Amount Staked" column...it should equal the amount in the summary, correct? Instead, the summary has this amount X2 for some reason.

You shouldn't have 2 instances of if (can_administer('canadminstyles'))...on a fresh vBs admincp/index.php that line is used to show the style settings to those admins with permission to administer styles.

One other point to note is that 3.0.3s includes/functions_showthread.php lacks the So, instead, find and add the required bit under that.

can someone please answer my problem i posted, the vbookie cant be used correctly until this is fixed

kevin i had that problem as well. there are 2 database entries for different points and ucash is pointed at one and vbookie is pointed at the other. i just copied one to the other and it was fixed

can you explain which ones if its not a problem? im really rusty at coding and working through the database, well i mean i havent forgotten but like yeah...im kinda lost :( can i fix this problem with running a query?

I've got a pretty important question that I haven't seen addressed...

Does this software account for bets that go push?

Event's can be "Abandoned" and all bets are returned to the users if that's what you mean.

I don't want the whole event abandoned... I just want certain outcomes that "push" abandoned. A "push" is a common outcome on many wagers...

Ugh. This thing is going to explode in my face if I can't refund stakes on outcomes that push.

The only way to do something like that with the current system would be to separate any events that can be pushed into their own event, and then abandon it if they push.

Ugh. I was afraid you would say that.

I don't mean to be negative, but this hack doesn't make sense without a feature that allows an outcome to be a push. I'm using this for a sports forum, and in sports there are often outcomes that go "push" while there is still action that nets wins and losses. This is very common in sports, especially NFL.

There really should be an option for an outcome to go "push" that doesn't wreck the action on all the other bets.

There's no way I can manage all these games if i'm having to have three seperate threads to bet one game...

To see how I am using this in an NFL format, please view this thread:
http://www.orangemane.com/BB/showthread.php?t=16833

It's all together, and consice. Everybody can see how each game is being bet.

"Push" is a standard in gambling. If this hack is going to be used in football forums, "push" outcomes are important to have without having to mess up the other action... and without having to have a dozen different threads to bet a single game. There's only one bet in standard football betting that doesn't go push...

Unfortunately, my users have got action placed already and the NFL season starts this week.

Also, for reference, there are 16 games a week in the NFL, with three standard bets...

1. MoneyLine
2. Over/Under
3. Point Spread

To seperate those into three seperate threads per single game is the difference between managing 16 threads a week (opening and closing) and almost 50 threads each week. That's about a hundred threads each week for NFL forum admins to manage when you figure that you've got to close last week's results, and then you've got to open next week's action. That's a huge time investment.

I love the hack, but a "push" outcome is incredibly important.

I'm sure you thought about this already - but for the meantime you can use half values for spreads and over/unders.

Yeah, I thought about that for next week... But for this week, It's difficult to do that without causing a board riot since bets have already been placed.

Hopefully, for the future, a column next to the "pay out" column can be added for pushes.