nvm... my bad - i found it on your website.

GREAT SYSTEM! THANKS! I'LL TRY TO DONATE SOON! :)

Cool hack tjdrico! One of the best. Will install when I can.

I had some problems, but I worked through it... but now I was wondering this:

- Richest Members in vBookie Stats only shows my richest uShop/uCash members, except the 2 richest. The two richest have like $13.xx and $17.xx, and 3rd richest has $7.xx ... the list in vBookie starts at the $7.xx person. (If that made any sense)

- Also, when I click the option to add an event with the thread, I don't get taken to a "Post a vBookie Event" page... any ideas... ? I did set my usergroup to be able to add events

Regarding the first, which version of the installation file did you have? Is it version 1.0.3? Check the 'includes/functions_vbookie.php' file, and the 'function vbookie_get_richest()' function. You should see this code:

The main point here is that there is a "+0" on the uttpoints_pointsfield column, as this forces it to be an integer rather than a string.

The second suggests that you didn't make all the changes correctly, or missed one all together. One suspect would be this one in 'newthread.php':

FIND
AFTER, ADD
The change above is what specifies the page you are directed to after submitting a new thread. Double check all the changes prescribed in the installation instructions.

Thanks for the quick reply...

- Regarding the first issue(how my Store uses decimals), is there a way to fix this? Or do you suggest changing my point system over to integers?? I liked the idea of dollars and cents

- New Event... well everything seems correct... I'm gonna try to double check...

ahhhh... found it :nervous:

That's what I forgot ... thanks again for your help

*clicked install*

Well, actually, the "+0" should just convert it to a number, not strictly an integer. The problem with the ordering was that the uttpoints field is a VARCHAR, so "ORDER BY" uses dictionary ordering. In dictionary ordering "8.5" comes after "700", so the numbers come out wrong. The "+0" forces them to be viewed as numbers, so "8.5" comes before "700".

I don't know why it uses a char field rather than a decimal or int for a numeric amount, but it seems to work OK and the +0 on my SELECT should fix it if it's not present in your copy of the file.

tjdrico, this is a great hack and how about: don't the money the users lost goes thrash, there should be an account like 'bet master' to keep all of the money users have lost and pay how much they won. and you should make it like: in ACP admin can have the option that if he wants the money goes to someone and if yes enter the user id of that person.
hope it gives more fun ^^

Silly question I'm sure, but how would one settle an event?
Is there not an option shown to do so until the end date/time has passed?

No, the "Settle" option is only shown once the "This event will pay out after" date has been reached. If you want to settle a bet before that time, edit it and change the date. Presumably, however, one wouldn't settle an event until the result is known, so it makes sense to set the "This event will pay out after " to that time in the first place. It defaults to being the same as the "accept bets until" date/time, which should be before the result is known. ;)

Excellent hack. HOTM level stuff!