vBookie for vBulletin 3.5

[Andreas]

vBookie

Introduction

This is a Port of the original vBookie Hack (https://vborg.vbsupport.ru/showthread.php?t=65844) 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.

[Dream]

sounds cool gonna test this

[Neal-UK]

sounds cool gonna test this

ohh you nice* thing, gonna install this. Excellent work.

EDIT: * thought i'd better remove sexy just in case your a male :ermm:

[Dream]

I am, but im still sexay

tho I didnt make this mod, kirby did

you talking to me?

[Neal-UK]

I am, but im still sexay

tho I didnt make this mod, kirby did

you talking to me?

lol, no.

Where are the forum settings? I can turn it on and off via vb options but there's no extra menu on the left. I've rebuilt bitfields, etc

[Andreas]

Well, there are no new Entries in the Nav :)

=> Usergroup Manager and Forumpermissions

Rebuild Bitfields is not necessary, the Product XML does that already.

[Dream]

oh ok, you quoted me

[Neal-UK]

Well, there are no new Entries in the Nav :)

=> Usergroup Manager and Forumpermissions

Rebuild Bitfields is not necessary, the Product XML does that already.

right all settings are correct, however when I go to create a new post the option to add a vBookie event is not showing

[Andreas]

LOL, all Plugins in the XML are disabled.
Might be a good Idea to enable them ^.^

[Neal-UK]

LOL, all Plugins in the XML are disabled.
Might be a good Idea to enable them ^.^

Error when posting an event:

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
SELECT FROM FORUM WHERE userid='';

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM FORUM WHERE userid=''' at line 1
Error Number : 1064
Date : Friday, August 12th 2005 @ 03:44:04 AM
Script : http://www.******.com/forum/showthread.php?t=1711
Referrer : http://www.******.com/forum/vbookie.php?t=1711&vbookieeventoptions=0&do=newevent

[Andreas]

That is a really strange corrupted Query ... doesn't happen to me.
When exactly do you get this?

Edit: I cant find a reference to FORUM (uppercase) in any Query.

Could it be that this is caused by another Hack?

[Neal-UK]

That is a really strange corrupted Query ... doesn't happen to me.
When exactly do you get this?

after filling in all the vBookie bet details and then clicked submit. Will having a db prefix effect anything?

[Andreas]

It shouldn't. My Testbed has a Prefix too.

[Neal-UK]

It shouldn't. My Testbed has a Prefix too.

FORUM is my table prefix, 'FORUMusergroup' for example.

[Andreas]

I C.
Then the above query doesn't even make less sense as it's totally missing a Table Name ... which could be caused by uCash

[DS MrSinister]

Nice job KirbyDE. now i need to get my test site backup and running. :banana:

[Neal-UK]

I C.
Then the above query doesn't even make less sense as it's totally missing a Table Name ... which could be caused by uCash

yup, if i dont use ucash for vbookie it works fine

[Andreas]

Try the attached File please. If the uCash feature does work then i'll update the ZIP.

[Neal-UK]

Try the attached File please. If the uCash feature does work then i'll update the ZIP.

lol, too late. Just removed uCash as no one bothered with it as no shop was available and vBookie was a very popular mod.

I'll try it however on my other forum (Second link in sig).

[Neal-UK]

lol, too late. Just removed uCash as no one bothered with it as no shop was available and vBookie was a very popular mod.

I'll try it however on my other forum (Second link in sig).

No, get this:

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
INSERT INTO vbookie_bets_placed (option_id, item_id, userid, bet_amount_placed, bet_odds_against, bet_odds_for, bet_private) VALUES (13, 7, 1, 50, 2, 1, 'N');

MySQL Error : Got error 28 from table handler
Error Number : 1030
Date : Friday, August 12th 2005 @ 05:29:34 AM
Script : http://www.meeting4fun.com/forum/vbookie.php
Referrer : http://www.meeting4fun.com/forum/showthread.php?t=75
IP Address : 195.92.168.164

[BigIke]

Kirby, I'm gonna come out and say it. I love you.

[taffy056]

Kirby,

Thanks very much for this hack, I am not saying I love you but it comes close :) by the way installed with no problems!

taffy

[Andreas]

@nealparry
That is a mySQL Problem then ... Disk full? Table damaged?

[Link14716]

@nealparry
That is a mySQL Problem then ... Disk full? Table damaged?

Error code 28: No space left on device.

[Neal-UK]

Error code 28: No space left on device.

naff hosting company, this site is still with the poor one. Glad I moved the main one a few weeks ago.

[Gizmo5h1t3]

works a charm..but i havent enabled ucash yet..;)

[MrNase]

I can't edit bets?! I tried to edit the odds but that didn't work..

[rinkrat]

Try the attached File please. If the uCash feature does work then i'll update the ZIP.


I came to complain about the same error with the no name table and this fixed it (with Ucash). Now I can create a bet. So far so good. Go ahead and add that to the zip because it fixed the error.

[rinkrat]

I just tried editing a bet and that works fine but I noticed that the payout time of 2 PM today Pacific time is being translated to 6 AM tomorrow for some reason in the actual thread.

[Biker_GA]

Kirby. When I make the change to the SHOWTHREAD template, I receive this error:

The following error occurred when attempting to evaluate this template:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/social/public_html/forum/includes/adminfunctions_template.php(3510) : eval()'d code on line 543

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

[TTG]

Installed and working well .. thanks for working on the conversion KirbyDE .. great job.

[Gizmo5h1t3]

used the attached .php file, now it works fine with RC2...and ucash

[TTG]

Like most hacks .. this one adds quite a few templates to the list in your style manager.
Anyone wanting to tidy up their templates :-

edit your includes/adminfunctions_template.php .. search for
'aaa' => 'AAA Old Backup'

add this above 'vbookie' => 'vBookie',

[Link14716]

Like most hacks .. this one adds quite a few templates to the list in your style manager.
Anyone wanting to tidy up their templates :-

edit your includes/adminfunctions_template.php .. search for
'aaa' => 'AAA Old Backup'

add this above 'vbookie' => 'vBookie',

You don't need to do a file edit for that. I forget the name of the hook, but there is one.

[turfy]

Real Time Odds ? :(

[Andreas]

@MrNase
Confirmed. Gonna look at that.

@rinkrat
The Time displayed in the Thread follows your Timezone Settings, might this be the issue?
If not please explain the problem a bit further :)

@Biker_GA
You are doing smth. wrong.

@turfy
Don't understand your comment, sorry.

I've updated the ZIP with the modified functions_vbookie.php, so uCash should work now.
Also Templates are now grouped in Style Manager.

[turfy]

Real time is Odds who depends of the betting (pari mutuel).

In vbookie you choose the odds at the beginning and the odds don't change. I hope an option who the odds change with betting, the most bet is the favorite. The final and paid odd is the odd at the end time. Sorry for my english. You understand ?

[Andreas]

I don't understand a word, sorry :)
If somebody did, would be nice if he could explain it to me. Thanks.

[FASherman]

Bets determine the odds...

Lets say I have 100 bets spread out over 6 possibilities.

Option 1: 40 bets odds 2:5
Option 2: 20 bets odds 1:5
Option 3: 15 bets odds 3:20
Option 4: 18 bets odds 9:50
Option 5: 5 bets odds 1:20
Option 6: 2 bets odds 1:50

Odds are ever changing based on the betting trends. Every single new bet changes the odds slightly.

[Andreas]

I C.
Hmm, i'll think about if it's possible to implement that.

[turfy]

Thanks FASherman :D

http://en.wikipedia.org/wiki/Parimutuel

[Dream]

are the phrases hardcoded in this one?

how many queries does it add and where are they added?

can this be disabled/enabled per forum? how are you using this modification, enabled in all forums? hows the experience so far?

[Andreas]

A lot of Phrases are still hardcoded, yes.
This is one of the ToDo-Entries
It adds 2-3 Queries to showthread.php if a Thread contains an Event. If it doesn't there are no Queries added.
Permissions can be defined for each Forum/Usergroup

[FASherman]

I C.
Hmm, i'll think about if it's possible to implement that.
Its just a function:

IF (ODDS EQ PARAMUTUAL) THEN
ODDS ARE 1:(TOTAL BETS/BETS_THIS_OPTION)
ELSE
HOWEVER YOU DO IT NOW
ENDIF

[Dream]

installation went ok, there are some stuff in the intall.html you should remove, "installing vbookie/upload files/do code mods".

where does the money comes from, the house or from the others?

WOL for vbookie.php isnt set

any way you can add your little mod to it so the thread is only posted when the user finishes creating the event?

the posticon in the forum list is showing the poll image

the event poster cant edit his own event

when you edit an event all dates reset to the current day

"private bet" should have a <label>

[Biker_GA]

@Biker_GA
You are doing smth. wrong.


Hmmmmm.... Don't think so. Done a lot of these, and I'm following the instructions to the letter. As soon as I put $vbookie_event in SHOWTHREAD and save, that error pops up.

[Andreas]

@Dream

The Payouts are: Stake + Odds*Stake

Yes, WOL is missing - gonna add that asap.

I could hide the Thread until the Event is ready, yes.
Gona think about that.

The Posticon should show a Dollar sign, at least it does for me?

Event Poster cannot Edit own Event: Hmm, should work. Gonna test that.

Dates resetting could be caused by a Bug in RC1, if you use this.

@Biker_GA
Revert your SHOWTHREAD Template, and then try to make the changes.
If this still doesn't work, send me a PM with ACP Login.

[sabret00the]

Its just a function:

IF (ODDS EQ PARAMUTUAL) THEN
ODDS ARE 1:(TOTAL BETS/BETS_THIS_OPTION)
ELSE
HOWEVER YOU DO IT NOW
ENDIF

surely real time odd's aren't possible without getting the odds from RSS feeds?

[MrNase]

@MrNase
Confirmed. Gonna look at that.



Fixed?

[FASherman]

surely real time odd's aren't possible without getting the odds from RSS feeds?
I don't think that was the request. He's not asking to have the current Vegas odds of the Patriots to win the 2006 Superbowl and update in realtime.
The request was to run an event as a paramutual event which means all of the data is internal.

This is pretty simple stuff. Lets say the Patriots are playing the Bengals and 100 people place bets. If all 100 bet $1 on the Patriots. then the odds are 1:1. You get back what you paid in, $1. Makes sense, right?

Lets say 99 bet on the Pats. One person bets on the Bengals. If the Pats win, those 99 get $1.01. The odds were 100:99.

However, if an "Any Given Sunday" miracle happens, the one person who bet on the Bengals at 100:1 odds gets $100 for his buck.

Payout is commensurate to risk.

[.Tim]

I just tried editing a bet and that works fine but I noticed that the payout time of 2 PM today Pacific time is being translated to 6 AM tomorrow for some reason in the actual thread.

I'm having the same problem. I choose 7:30pm and it shows up as 1:30pm.

[Floris]

Very nice work K, good job on all these resources and keep them coming. I will keep my eyes on this one for a while until it feels a bit more stable and has your todo list items implemented. I've tested it and it was fun to play with.

[Andreas]

I'm having the same problem. I choose 7:30pm and it shows up as 1:30pm.
I don't really understand the Problem, nor am I able to reproduce it.
I've created a new Event with Bet End 28.08.2005 07:30 PM GMT+1, and this is exactly how it does show up in the Thread for me?

http://kirbydemos.ath.cx/forum/showthread.php?t=14

@MrNase
Should be fixed on my Board. Feel free to test it.

[.Tim]

I don't really understand the Problem, nor am I able to reproduce it.
I've created a new Event with Bet End 28.08.2005 07:30 PM GMT+1, and this is exactly how it does show up in the Thread for me?

http://kirbydemos.ath.cx/forum/showthread.php?t=14

@MrNase
Should be fixed on my Board. Feel free to test it.

Well, it's coming out right for you because yours is set for GMT +1 and mine is GMT -5. There's the 6 hour difference I'm experiencing. If you changed your timezone to central time and created a new event I bet you'd experience the same issue I'm having. :ermm:

[Andreas]

OK, I changed my Timezone to Central Time, then posted a new Event 28.08.2005 07:30 PM GMT.
It shows up as 1:30 PM, which is correct?

[.Tim]

OK, I changed my Timezone to Central Time, then posted a new Event 28.08.2005 07:30 PM GMT.
It shows up as 1:30 PM, which is correct?

Yes, that's what happens to me. If I want it to end at 7:30pm central time on August 14th. I have to set it to end at 1:30am August 15th, so that it adjusts to the correct time after submitting. It's kind of annoying that it doesn't show up as the time I choose, really the only problem I have with the hack though. :D

[Andreas]

Sorry, I don't understand the Problem.
If you want an Event to end at 14. August 2005 7:30 PM Central Time, then just submit it this way?

[.Tim]

Sorry, I don't understand the Problem.
If you want an Event to end at 14. August 2005 7:30 PM Central Time, then just submit it this way?

I do but it shows up as 6 hours earlier than the time I chose. I choose for it to end at 7:30pm central time but after I submit it, it shows it as ending at 1:30pm central time.

[Andreas]

I cannot reproduce this Problem, sorry.
Did you test at my Board?

http://kirbydemos.ath.cx/forum

[.Tim]

I cannot reproduce this Problem, sorry.
Did you test at my Board?

http://kirbydemos.ath.cx/forum

It doesn't give me the option to post an event at your board.

[.Tim]

Okay, here are some screenshots to show you what happens.

I choose 11pm central time and then submit, you'll see that in the first screenshot.
I submit it and in the thread, it shows up as 5pm.

[Boots]

great hack but the times are FUBAR. I'll take a look at the code and see if I can figure out whats going on.

[Boots]

When you create an event, time is saved in database as GMT

but

When displaying an event from the database the date is displayed as whatever timezone you are in (ie GMT-4 HOURS)

thats a bug...

[Boots]

if you create your event and you just manually add the timezone offset to the event it seems to display correctly.

ie my timezone is GMT -4

I created an event and made my end time +4 hours of what I actually wanted. It displays correctly now.

[Andreas]

It doesn't give me the option to post an event at your board.
You have to join the necessary Usergroups :)
http://kirbydemos.ath.cx/forum/profile.php?do=editusergroups

I do understand your Problem, but as said I cannot reproduce it.

[.Tim]

You have to join the necessary Usergroups :)
http://kirbydemos.ath.cx/forum/profile.php?do=editusergroups

I do understand your Problem, but as said I cannot reproduce it.

It works just fine on your board. :ermm:

I've tried everything I can think of, adjusting the default board timezone, my timezone. Nothing.

[Andreas]

That's, as said, my Problem: I can't reproduce the effect ...

[.Tim]

That's, as said, my Problem: I can't reproduce the effect ...

Yeah I know, that's okay. I'll just tell my users about it and what to do.

[Boots]

You have to join the necessary Usergroups :)
http://kirbydemos.ath.cx/forum/profile.php?do=editusergroups

I do understand your Problem, but as said I cannot reproduce it.

Your default time zone for your forum is GMT



All times are GMT. The time now is 04:08 AM.


Set it to a different one like Atlantic Time (GMT-4) and then add an event. You will reproduce the error. When I switch my forum to GMT it works fine.

[Lord Brar]

Woeeeeeee! I was waiting for it :) Thanks.

[kall]

I can't find the Setting to allow a forum to have vbookie events posted to it. :(

[Andreas]

Your default time zone for your forum is GMT



Set it to a different one like Atlantic Time (GMT-4) and then add an event. You will reproduce the error. When I switch my forum to GMT it works fine.
I've changed the Board default Timezone to Central Time, then posted a new Event for 28.08.2005 7:30 pm Central Time:
http://kirbydemos.ath.cx/forum/showthread.php?t=19

Shows up as 29.08.2005 2:30 am, which is correct as my Timezone is GMT+1.

@Kall
ACP / Forums & Moderators / Forum Permissions

[rinkrat]

I have the same problem, like I said before.

[jesus likes pie]

woah

[Boots]

I've changed the Board default Timezone to Central Time, then posted a new Event for 28.08.2005 7:30 pm Central Time:
http://kirbydemos.ath.cx/forum/showthread.php?t=19

Shows up as 29.08.2005 2:30 am, which is correct as my Timezone is GMT+1.

@Kall
ACP / Forums & Moderators / Forum Permissions

Would you like a testing account on my forum?

[Andreas]

Security Warning
This Hack contained a serious XSS vulnerbilitie.
If you are not using Version 1.0.5 Build 3 yet (eg. downloaded this Hack before 14.08.2005 19:10 CEST) I strongly recommend to update immediately to keep your installation safe.
Security Warning

[kall]

@Kall
ACP / Forums & Moderators / Forum Permissions
D'oh! So it is.

Why isn't it in Forum Manager - Edit Forum (or is it Usergroup Manager?) We have to use Custom Permissions for vBookie? Just wondering.

[kall]

Oh, and.. You rock! It's working!

If you leaev this boxbit of a typo in vbookie.php.. :)

[Andreas]

@kall
It's in Usergroup Manager as well ;)

[kall]

@kall
It's in Usergroup Manager as well ;)

Maybe I spoke too soon..I can't seem to get it to allow me to bet. :(

*edit* Nevermind. Must be caching something or something. Or I'm just stupid. :) All good now.

(I did change the ucash to money (the name of the field on my forums) in the includes file...that may have helped.)

[plateau]

in the vBookie Installation it says:

Of course, you can do whatever you see fit, here. You might prefer to only allow vBookie events to be created in a specific forum, rather than in every forum. To do this, just set the permissions for specific forums as normal.

however i couldnt find where to set the permission, there is no options related to vBookie in each of the forum management pages.

thx.

[Andreas]

ACP / Forums & Moderators / Forum Permissions
Select the Forum and Usergroup, uncheck "Can post vBookie Events"

[plateau]

ACP / Forums & Moderators / Forum Permissions
Select the Forum and Usergroup, uncheck "Can post vBookie Events"


thanks mate, the problem solved :rolleyes:

another problem found:

i am using the chinese version of the uCash hack, which was modified by the chinese-vbulletin development group to suit for the chinese vb. and i found that when i enabled the uCash in the vBookie settings, it doesnt work.

so, any ways to solve it, or to modify the code so it can be related to my chinese uCash system? thanks!!!

[Andreas]

I can't read chinese ... so obviously I can't tell what's going wrong.
If you can tell me, i'll try to fix it.

[plateau]

right, what i found is: if i enable the uCash and off the vCash in the ACP, then nobody can place the stake and bet on the event. as the first attached image shows.

now i can only use vCash.......... :rolleyes:

as the second image idicates, it works fine with vCash.

thank u Kirby.

[Andreas]

Does it work with the standard, english uCash?
If so, where can I get access to the chinese uCash?

[plateau]

Does it work with the standard, english uCash?
If so, where can I get access to the chinese uCash?

mmm, i think i need to install a fresh chinese vb first, then the eng. uCash, and vBookie, and then do some tests to see the results...

anyone has already successfully tested the uCash on vBookie?

anyway, i ll get some more information about my problem, and get back to u. cheers.

[Andreas]

Yes, see Posts above - there are Users that successfully got uCash and vBookie working.

Btw @ all that had Time Problems:
Do they still appear with Build 3?

@MrNase
Editing Events should work now.
Confirmed?

[TTG]

I'm not using ucash .. how do the members receive extra cash for posting. ?
Everyone starts with 500, but that hasn't increased since installation.

[Boots]

time issue appears to be resolved in the latest release!

[rinkrat]

yep. Thanks :)

[plateau]

Hello Kirby,

I ve checked with vb chinese team, they said the chinese vb cash system is diff. from the english one.

what i think is, is there anyway to modify the code so the vBookie can be applied on the chn. cash system?

i had a look on the database, in the user table, the column for vbookie cash is called vbookie_cash, and the one for chn. cash system is called money.

so can we just modify the coding, to repalce the 'vbookie_cash' with 'money'? thus the users can use the chn. cash system to play the vbookie.

maybe not that simple, but i believe it is possible. maybe in the vbookie, you can provide a 'port' to let people configure it to suit for any vbulletin cash systems.

cheers!

[mcyates]

Get this error when i run the vbookie.php file, also i have no permisions in my usergroupd for vbookie and their is no vbookie link in the navbar. I have settings in the options of vbulletin but thats it, anyway here is the error i get:

Warning: main(/home/myfootba/public_html/VB350/includes/functions_vbookie.php): failed to open stream: No such file or directory in /vbookie.php on line 77

Fatal error: main(): Failed opening required '/home/myfootba/public_html/VB350/includes/functions_vbookie.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/myfootba/public_html/VB350/vbookie.php on line 77

[mcyates]

I can now see vbookie.php fine now, but i still have no optinos in the usergroup options.

[mcyates]

its ok i've fixed it. My own fault.

[Dream]

@MrNase
Editing Events should work now.
Confirmed?

poster still cant edit his events here

[fpouk]

I only have 1 problem... whenever i post a vbookie event and i enter dates for last day to bet and payout day and click update event... no matter what date i put it gets put to August 1st 2005 and August 2nd 2005 for payout after i submit event?

any help will be appreciated

[Andreas]

@fpouk
Which vBookie Version and vBulletin Version do you run?

@Dream
Also on my Board?

[TTG]

I'm not using ucash .. how do the members receive extra cash for posting. ?
Everyone starts with 500, but that hasn't increased since installation.

no update for this problem .. ?

[Andreas]

They receive Cash if they win.
Or, if it is enabled, 25 when a new Event is placed.

(Reminder: Make the amount a Setting)

[Dream]

@Dream
Also on my Board?

is that a retoric question or would you want me to try? where shoult I register to try?...

[.Tim]

Btw @ all that had Time Problems:
Do they still appear with Build 3?

Seems to be working just fine for me now, thanks.:D

[wcbryant]

This is mostly to Kirby, but really to anyone who might have the relevant knowledge.

My users have been begging for agest for a way to tweak vBookie so that it also supports private (or public) bets between users. My site is related to college athletics. There will always be one user who feels X is absolutely true, and one or two other posters will feel he couldn't possibly be more wrong. They're hoping to be able to put their vCash where their mouths are by spawning their own little personal events in the system between themselves.

I know I could have my mods create new events every time it gets up, but over a few thousand users and the course of a college football season, that could get seriously out of hand.

Just wanted to toss it out there and see if anyone had any ideas or suggestions.

[concreteweb]

Hi Kirby,

I have a strange(?) one. Your instructions say:

"When you have installed vBookie and made all the file and template modifications, you are ready so set it up. Go to your AdminCP and expand the vBookie item. Then click on General Settings."

I don't have a vBookie item! I've uninstalled and re-installed. No change. vBookie is running on the forum, but I have not been able to set it up yet.

Any clues?

v: 3.5 RC2
latest vbookie files d/l'd.

[Andreas]

Well, I just took the old Readme and updated it to suit the new Format ... obviously some things slipped through ;)

ACP / vBulletin Options / vBulletin Options / vBookie Settings

@wcbryant
I don't understand your Request exactly ... private Bets are already possible.
Can you explain exactly what you want?

[TTG]

Or, if it is enabled, 25 when a new Event is placed.

(Reminder: Make the amount a Setting)

Don't seem to have that option .. you updated it recently !?

[Andreas]

No, it's there since the first 3.5 Release.
vBulletin / vBulletin Options / vBookie Settings / Give to the Poor= Yes

[plateau]

in the vbookie settings, there is no option related to charity, only three are listed there.

[Andreas]

Hmm ... for me it is. Lemme check the XML ...

[concreteweb]

Well, I just took the old Readme and updated it to suit the new Format ... obviously some things slipped through ;)

ACP / vBulletin Options / vBulletin Options / vBookie Settings

@wcbryant
I don't understand your Request exactly ... private Bets are already possible.
Can you explain exactly what you want?

Excellent! Looks I found it just when you were posting this. Thanks.

[Andreas]

@plateau
Was missing in the XML. I've updated the ZIP and also changed install.html.
Version Number has not been changed as there are no changes.

[plateau]

@plateau
Was missing in the XML. I've updated the ZIP and also changed install.html.
Version Number has not been changed as there are no changes.

thanks mate! :rolleyes:

[TTG]

@plateau
Was missing in the XML. I've updated the ZIP and also changed install.html.


thanks for checking and updating KirbyDE

[plateau]

thanks for checking and updating KirbyDE

wa...............u r so kind, mate. :rolleyes:

[plateau]

$vbphrase[vbookie_redirect_deleted]

Your <i>vBookie</i> event has been deleted. If there were any stakes placed on an unsettled bet, they have been returne. You will now be taken back to the main <i>vBookie</i> page.

returened

[.Tim]

I deleted a thread and forgot to delete the test event first, is there a way to delete the test event now that the thread is gone?

[wcbryant]

@wcbryant
I don't understand your Request exactly ... private Bets are already possible.
Can you explain exactly what you want?

Sorry Kirby, end of a long day when I wrote that, and it didn't read well.

To start off, I should have called it "person-to-person" betting, and not "private."

I'd like to figure out a way to add another class of events. I have moderators who create site-wide events, always sports related on my site. No one else is able to create vBookie events, for the sake of not polluting the system. What I'd like, what my users are asking for, is a way (perhaps through PM) for users to create and have a record of private 2-person bets. These wouldn't be bets anyone else could participate it.

I imagine it would work something like this. User1 and User2 disagree about something. User1 thinks the sky is blue, User2 thinks it's red. User1 spawns a bet which is sent privately to User2, and selects 'terms' for the bet. Public/private result, odds, close date, perhaps even select another user (User3, here) as an impartial judge. User2 receives a PM detailing the terms, and has to accept or decline the bet. When the close date arrives, either User1, or (ideally, if an impartial judge was selected) User3, enters the results and processes the bet. In this case, User1 or 3 record that the sky is indeed blue, as it was even odds for 100 vCash each, the cash held by the event is released to User1. You could even go as far as to allow a % to go to User3 as a service tip. Maybe a seperate 'news' section within vBookie could annouce the results of these, with the level of detail provided to the public dependant upon User1 having selected a public or private person-to-person bet.

I know that's a convoluted way to ask for a pretty simple thing. I do know this *could* be done through the system now. But it would cause a few unhappy problems. First and foremost, it would flood the vBookie system on my site with events, the ones we're doing on a site-wide level would be lost in the deluge. Secondly, it would mean one of my mods having to create an event for the people in question every single time they want an event. I guess my hope is that a "person-to-person" side of vBookie could be opened up that would allow the users to deal with their little side bets without mod intervention, and without flooding vBookie's bet listings with literally hundreds of new events. Doing this through PMs would also mean I wouldn't have to have thousands of new threads created for every little side bet people want to run.

Hope this makes some sense. It's the end of yet another long day. :) If I'm the only one who would get some use out of such a system, obviously I can toss a request out there for a bit of custom coding in another area of vb.org. I just know it's come up before, so I thought I'd toss it in here to see if there's a 'market' at all for such a feature.

(edit: Re-reading this, I wonder if it's too big a hassle to reasonably suggest here. As a non-coder, I just have no idea whatsoever.)

All that aside, thanks SO much for converting this. It was one of my last few "must-have's" for 3.5.0. Now I just need someone to help svc out with AWS and I'm good to go. :)

[fpouk]

@fpouk
Which vBookie Version and vBulletin Version do you run?

@Dream
Also on my Board?

sorry i meant to reply back... everything is working fine now.

[Dream]

found a bug with uCash

when the value has more than 3 digits, vbookie tries to insert the value using 99,999.99 format

[Andreas]

Uh? That's a strange bug.
Can you explain a bit more as to when this happens exactly, which errors you get?

[Dream]

INSERT INTO vbookie_bets_placed (option_id, item_id, userid, bet_amount_placed, bet_odds_against, bet_odds_for, bet_private) VALUES (92, 20, 11209, 39,448, 2, 1, 'N');

[Andreas]

I guess you staked "39,448" instead of "39448"?

[Dream]

man thats a serious secutiry issue, I could make queries there I think :O

[Andreas]

Yep.

[Dream]

build 4 corrects that?

want me to edit my posts

edit: and any way we could get maximum odds?

[Andreas]

Build 5 is available now.
For changes see first Post.

[TTG]

Thanks for the update Kirby.
I always thought clicking the 'Install' button provided us with an email when the coder updated a hack .. ?

[Andreas]

If he sends an Update eMail - Yes.
But I only do so for critical Updates.

[Rat1972]

i have a problem.

I did everything the manual said, but when i set a bookie event and, i want to let everyone to set one bet maximum, then the system gives an error: That i only can bet once. But it's my first bet.

When i do: Multiple bets
Then i get this error:

Fatal error: Call to undefined function: query_write_write() in /home/support/domains/supportersworld.nl/public_html/bulletin/vbookie.php on line 1248

I unstalled it, and reinstalled it again, but it doesnt help. Anyone knows what i have to do?

[Andreas]

Sorry. Redownload vbookie.php, that should fix it.

[Rat1972]

i also did that. I deleted the files, load new files up, i did everything, but i still have the problem. Strange :)

[Andreas]

Still the Fatal Error?

[Rat1972]

i got now a new error (the error that i only bet once, is still there)

now i get this, when i set in on multi:

UPDATE vbookie_item_options SET option_n_bets_placed=option_n_bets_placed+1, option_amount_staked=option_amount_staked+ WHERE option_id=1;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE option_id=1' at line 1
Error Number : 1064

[Andreas]

OK, gonna check that ... just discovered a few non-working phrases as well, grmpf.

[Rat1972]

OK, gonna check that ... just discovered a few non-working phrases as well, grmpf.

oke thanx for your help mate!

[Andreas]

Can you check if it's working correctly on my Board?

[Rat1972]

I downloaded this morning this script again here, i don't know of you chanced anything, but now it works perfect on my board.

Thank you so much for the big help

[Biker_GA]

I've run into an issue with the Showthread template. On line 543 I'm showing:

<tr valign="top">
<td class="alt1" <if condition=&quot;!$show['search']">colspan="2"</if>>

There are no close tags for tr and td. Where exactly should the close tag for td go?

[Andreas]

@Rat1972
I ddn't change anything since yesterday (well, I did fix the Phrases but I did not upload the new Files yet)

@Biker_GA
The Template looks somewhat damaged?

[Biker_GA]

Yeah.. Big time.. A LOT of whitespace between sections. Ideal solution would be to fix the template without reloading the entire forum, though.

[Andreas]

Did you try to compare it with the Original?

[Biker_GA]

I don't have that option as there are no changes made to it yet. System considers it as orginal.

[Andreas]

w00t?
Did you install any Hack that automatically modified Templates?

[Biker_GA]

Oh hell. Which one?! LMAO! This plugin/product is towards the end of my list of MANY that I have installed.

[rinkrat]

What do I do to upgrade from a week old version? I don't see it in the files.

[Andreas]

Well then ... you could try to reimport the MASTER Style, but I am not sure if this does work.
Furthermore, you should really find out what caused that ...

@rinkrat
Overwrite the Files, import the Product XML (Overwrite must be ticked) - Done.

[Biker_GA]

These are the modifications I've made so far:

In Reply to
Opt-Out
uCash
yet Another Award System
New PM on Forum Home
Welcome Panel
Multi Quote
Quote post in PM
Create reported post as thread
vBookie

It's strange... There are obvious errors in the template, yet the forums are working fine.

[Andreas]

Well, don't know how I can help you on this. Sorry.

[Rat1972]

@Rat1972
I ddn't change anything since yesterday (well, I did fix the Phrases but I did not upload the new Files yet)

@Biker_GA
The Template looks somewhat damaged?

Strange i did it yesterday 20 times, and everytime the error.
I woke up this morning and i tried again and it works.
On my other forum there was no problem and it worked the first time.

I am glad it worked and ofcourse for the support you give here.

[Glovebox]

Excuse me if this is a dumb question, but when Im trying to change the usergroup permissions. (Can Post vBookie Events, Can Edit other people's vBookie Events , Can Bet on vBookie Events) After I update it, they just change straight back to no..

Any help?

Adam

[Andreas]

Do you have other Hacks installed as well?

[Glovebox]

Yeah, Inferno Warning System 1.2 Right Column 1.0 uCash 1.1.1 vBookie 1.0.5 Build 6 vBShout 1.6 Yet Another Award System 3.5

[Andreas]

I don't think any of these could conflict with vBookie but just to be sure:
Did you try to disable them?
Which bitfield_xxx.xml Files do you have in includes?

[Glovebox]

I just have bitfield_vbookie.xml and bitfield_vbulletin.xml. You mean in /includes/xml right?

Didnt try to disable any, I will try that now.

[plateau]

new function suggestion:

put restriction on the lowest stake which users can bet on an event. such as, at least 20, 50... like this.

[Gizmo5h1t3]

new function suggestion:

put restriction on the lowest stake which users can bet on an event. such as, at least 20, 50... like this.

works the other way as well, might be an idea to have a high limit, to stop one or two members racing away by betting with all their money....

this discourages some membes from taking part, as its human nature to want the most money, if that unobtainable, they just give up using vbookie...
ive seen it happen...

[plateau]

works the other way as well, might be an idea to have a high limit, to stop one or two members racing away by betting with all their money....

this discourages some membes from taking part, as its human nature to want the most money, if that unobtainable, they just give up using vbookie...
ive seen it happen...


yes, u r right mate. that's a good idea.

found another bug:

when u edit an event, the Month for the Accept Until wont be shown as what u set previously, it will always show the current month. e.g. if u previously set it to September, and then you edit it, it will show Auguest, then u have to change it back to Sept., at least.

[wcbryant]

Under 3.0.x, my site has been using vCash for my bookie events. I'm moving my production site to 3.5.x tonight, and I really want to change that to uCash, but my users really want to keep their totals from the last year, except for some who were recently shorted their starting totals because of a configuration mistake.

So two questions/calls for help as I struggle with mysql;

1. Does anyone know of a way (been looking around for about an hour, and haven't found anything), perhaps a query, to copy all vcash values to ucash in the database?

2. Can anyone suggest a query that would give all users with less than X ucash, Y as a new balance -- but only if their userid is greater than Z?

Thanks in advance.

[Andreas]

1. update user set ucash=vbookie_cash
2. update user set ucash=y where ucash<x and userid>z

[wcbryant]

When I ran that query after upgrading vB from 3.0.1 to 3.5.0, and upgrading Bookie as well, it reset everyone to 500. Not sure how or why.

I still have a live copy of my database on another box with all the appropriate vCash data. Trying not to sound completely helpless, can someone suggest (in specific terms) how to extract that info from that db, and import it into the other one?

Can mysqldump for example just pull the one row, and create an sql file I could use to import it into the other?

Thanks in advance for any advice.

[Andreas]

When I ran that query after upgrading vB from 3.0.1 to 3.5.0, and upgrading Bookie as well, it reset everyone to 500. Not sure how or why.

That's default behaviour of the Install Code for a fresh install (it can't detect that a 3.0 Version was already installed, so it is a fresh install).

To avoid this, edit the XML and remove/comment out

if ($installed_version === null)
{
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=500");
$db->query_write("INSERT INTO " . TABLE_PREFIX . "vbookie_news (news_text,news_type,news_time) VALUES('vBookie installed!','general',".mktime().")");
}

before you are importing it.

[wcbryant]

I see. Not a big deal since I still have all the old vCash data in the old database.

Obviously it's above and beyond providing support for the hack, but can you suggest a way I might pull that vbookie_cash data out of the one dbase, and import it as ucash into the live one?

Thanks again, Kirby, apologies for all the questions.

[Andreas]

If you are lucky and have mySQL 4:
- Copy the User Table to another Table incl. Data
- In this new Table, drop all columns except Userid and vbookie_cash (optional)
- Export this new Table
- Import the exported Table in the other Database
- update user, imported_user_copy set user.vbookie_cash=imported_user_copy.vbookie_cash where user.userid=imported_user_copy.userid

... or write an ImpEx Module for it ;)

[Kurisu]

That's strange. I installed uCash and vBookie, set all required settings and permissions but I'm not able to post vBookie Events. All vBookie Event permissions of the administrator group are set to "yes", yet I don't get the option to post a vBookie Event with a new thread.
I got curious and set the member's usergroup permissions to "yes", logged in with a user account and got the option "post a vBookie Event with this thread". But I didn't got to set-up a vBookie Event either...

[Andreas]

Check your Permissions.
When you checked he Box, did a Form to post an Event come up afterwards?

[Kurisu]

I triple checked the permissions.

I tried again and now it worked for my user account (the form came up) but not for my admin account, although both should have the same permissions.

[Andreas]

Check your Permissions is all I can say.

[Kurisu]

Thought you'd say that *g*
Well, adding a secondary usergroup did the trick.

Btw: How do I chance the "vBookie:" before a thread?

[Andreas]

Phrase vbookie_event_thread_prefix in Phrasegroup Forum Display

[Kurisu]

Thanks :)
Now it's working finde :)

[Flow Fusion]

Can I get some help? Preview works but when I hit submit I get's nothing but the text.

[plateau]

Please only click Install if you actually have installed/are using this Hack, and click Uninstall whan you don't use it any longer!

yes, i m definitely using it, even on a chinese system. thank mate ^&^

[Bobby S]

Excuse me if this is a dumb question, but when Im trying to change the usergroup permissions. (Can Post vBookie Events, Can Edit other people's vBookie Events , Can Bet on vBookie Events) After I update it, they just change straight back to no..

Any help?

Adam

I have exactly the same problem! I upgraded to rc2 last night, and added the members visited today hack, and the rss newsfeeds.

Could I just update the table in the database in the meantime? What are they, and what should they be changed to?

[Flow Fusion]

I'm just looking for any help. I have had the same issue for the longest with no help or ideas...

[y2krazy]

I made several changes to the basic templates and I added a footer to most of the templates, like I do with all the other hacks to make them look more streamlined with the forums. Screenshots are included.

Phrase Manager -> Add New Phrase
Varname: vbookie_footer
Text: Powered by <b></b> v1.0 by <a href="http://www.infernotechnologies.net/" target="_blank">Zero Tolerance</a>

Style Manager -> Choose the Style to Edit -> "vbookie_confirm_abandon_event"
Replace entire template with:

<form action="vbookie.php" method="post">
<input type="hidden" name="item_id" value="$item_id">

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat">$vbphrase[vbookie_abandon_event]</td>
</tr>
<tr>
<td class="alt1" align="center">
$vbphrase[vbookie_confirm_abandon_event]<br />
</td>
</tr>
<tr>
<td align="center">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="t" value="$threadid" />
<input type="hidden" name="do" value="confirmedabandon" />
<input type="submit" class="button" name="preview" value="Yes, I Want To Abandon This Event" accesskey="p" tabindex="1" />
</td>
</tr>
</table>

</form>

Style Manager -> Choose the Style to Edit -> "vbookie_confirm_delete_event"
Replace entire template with:

<form action="vbookie.php" method="post">
<input type="hidden" name="item_id" value="$item_id">

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat">$vbphrase[vbookie_delete_event]</td>
</tr>
<tr>
<td class="alt1" align="center">
$vbphrase[vbookie_confirm_delete_event]<br />
</td>
</tr>
<tr>
<td align="center">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="t" value="$threadid" />
<input type="hidden" name="do" value="confirmeddelete" />
<input type="submit" class="button" name="preview" value="Yes, I Want To Delete This Event" accesskey="p" tabindex="1" />
</td>
</tr>
</table>

</form>

Style Manager -> Choose the Style to Edit -> "vbookie_main"
Replace entire template with:

<!-- vbookie welcome -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr align="center">
<td class="tcat" width="40%">$vbphrase[welcome_to_the_bookie]</td>
<td class="tcat" width="40%">$vbphrase[bookie_news_and_events]</td>
</tr>
<tr align="center">
$welcomeblock
<td class="alt1" width="40%" valign="top">$bookienews</td>
</tr>
<tr>
<td class="tcat" align="right" colspan="2"><span class="smallfont">$vbphrase[vbookie_footer]</span></td>
</tr>
</table>

<!-- /vbookie welcome -->

<!-- small space -->
<span class="smallfont"><br />
</span>
<!-- /small space -->

<!-- bet items -->
<form action="vbookie.php" method="get">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr align="center">
<td class="tcat" colspan="6"><phrase 1="$type">$vbphrase[currently_showing_x_events]</phrase> $vbphrase[switch_to]
<select name="type">
<option value="OPEN">$vbphrase[event_open]</option>
<option value="CLOSED">$vbphrase[event_closed]</option>
<option value="SETTLED">$vbphrase[event_settled]</option>
<option value="ABANDONED">$vbphrase[event_abandoned]</option>
</select>
$vbphrase[events]
<input type="submit" class="button" name="selecttype" accesskey="g" value="Go" style="font-weight:normal" tabindex="1" /></td>
</tr>
<tr align="center">
<td class="thead">$vbphrase[item]</td><td class="thead">$vbphrase[group]</td><td class="thead">$vbphrase[status]</td><td class="thead">$vbphrase[added]</td><td class="thead">$vbphrase[open_until]</td><td class="thead">$vbphrase[payouts_after]</td>
</tr>
$betitembits
</table>


<if condition="$show['pagenav']"><br /><div align="$stylevar[right]">$pagenav</div></if>

</form>
<!-- /bet items -->

Style Manager -> Choose the Style to Edit -> "vbookie_main_items_bit"
Replace entire template with:

<tr>
<td class="$bgclass">$item[item_title]<span class="smallfont"><br /><a href="showthread.php?t=$item[threadid]">$vbphrase[thread]</a> | <a href="vbookie.php?do=viewitem&amp;item_id=$item[item_id]">$vbphrase[info]</a>
<if condition="$can_delete"> | <a href="vbookie.php?do=deleteitem&amp;item_id=$item[item_id]">$vbphrase[delete]</a></if></span></td>
<td class="$bgclass" align="center"><span class="smallfont">$item[group_title]</span></td>
<td class="$bgclass" align="center"><span class="smallfont">$item[item_status]</span></td>
<td class="$bgclass" align="center"><span class="smallfont">$item[created]</span></td>
<td class="$bgclass" align="center"><span class="smallfont">$item[openuntil]</span></td>
<td class="$bgclass" align="center"><span class="smallfont">$item[payafter]</span></td>
</tr>

Style Manager -> Choose the Style to Edit -> "vbookie_stats"
Replace entire template with:

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr>
<td class="tcat" colspan="8">
$vbphrase[vbookie_stats]
</td>
</tr>

<tr align="center">
<td class="thead"><b>$vbphrase[event_totals]</b></td>
</tr>
<tr align="left">
<td class="alt1"><span class="smallfont">$system_totals_bits</td>
</tr>

<tr align="center">
<td class="thead"><b>$vbphrase[most_popular_events]</b></td>
</tr>
<tr align="left">
<td class="alt1"><span class="smallfont">$most_popular_event_bits</span></td>
</tr>


<tr align="center">
<td class="thead"><b>$vbphrase[top_paying_events]</b></td>
</tr>
<tr align="left">
<td class="alt1"><span class="smallfont">$top_paying_event_bits</span></td>
</tr>

<tr align="center">
<td class="thead"><b>$vbphrase[top_paying_outcomes]</b></td>
</tr>
<tr align="left">
<td class="alt1"><span class="smallfont">$top_paying_outcome_bits</span></td>
</tr>

<tr align="center">
<td class="thead"><b>$vbphrase[top_paying_bets]</b></td>
</tr>
<tr align="left">
<td class="alt1"><span class="smallfont">$top_paying_bet_bits</span></td>
</tr>

<tr align="center">
<td class="thead"><b>$vbphrase[top_winners]</b></td>
</tr>
<tr align="left">
<td class="alt1"><span class="smallfont">$top_winners_bits</span></td>
</tr>

<tr align="center">
<td class="thead"><b>$vbphrase[richest_people]</b></td>
</tr>
<tr align="left">
<td class="alt1"><span class="smallfont">$richest_people</span></td>
</tr>
<tr>
<td class="tcat" align="right"><span class="smallfont">$vbphrase[vbookie_footer]</span></td>
</tr>
</table>

Style Manager -> Choose the Style to Edit -> "vbookie_view_bet"
Replace entire template with:

<tr>
<td class="$bgclass">$bet[username]</td>
<td class="$bgclass" align="center">$bet[bet_amount_placed]</td>
<td class="$bgclass">$bet[bet_odds_against]/$bet[bet_odds_for]</td>
<td class="$bgclass" align="right">($bet[odds_decimal])</td>
<if condition="$bet[bet_settled]=='N'">
<td class="$bgclass" align="center">-</td>
<else />
<td class="$bgclass" align="center">$bet[bet_amount_won]</td>
</if>
</tr>

Style Manager -> Choose the Style to Edit -> "vbookie_view_bets"
Replace entire template with:

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" colspan="8">
$vbphrase[vbookie_view_my_bets]
</td>
</tr>
<tr>
<td class="thead" align="center">$vbphrase[event]</td>
<td class="thead" align="center">$vbphrase[group]</td>
<td class="thead" align="center">$vbphrase[vbookie_outcome]</td>
<td class="thead" align="center">$vbphrase[status]</td>
<td class="thead" align="center">$vbphrase[vbookie_stake]</td>
<td class="thead" colspan="2" align="center">$vbphrase[vbookie_odds]</td>
<td class="thead" align="center">$vbphrase[amount_won]</td>
</tr>
$betbits
<tr>
<td class="tcat" align="right" colspan="8"><span class="smallfont">$vbphrase[vbookie_footer]</span></td>
</tr>
</table>

<if condition="$show['pagenav']"><br /><div align="$stylevar[right]">$pagenav</div></if>

Style Manager -> Choose the Style to Edit -> "vbookie_view_event"
Replace entire template with:

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat">$vbphrase[vbookie_event]<span class="normal">: $eventinfo[question] ($eventinfo[group])</span></td>
</tr>
<tr>
<td class="thead">$vbphrase[vbookie_event_info]</td>
</tr>
<tr valign="top">

<td class="panelsurround" align="center">
<div class="panel">
<div align="$stylevar[left]">

<div class="fieldset">
<table cellpadding="0" cellspacing="$stylevar[formspacer]px" border="0">
<tr>
<td><span class="smallfont">$vbphrase[vbookie_this_event_is] <strong>$eventinfo[item_status]</strong>.</span></td>
</tr>
<tr>
<td><span class="smallfont">$vbphrase[vbookie_this_event_will_accept_bets_until] <strong>$eventinfo[openuntil_date] at $eventinfo[openuntil_time]</strong>.</span></td>
</tr>
<tr>
<td><span class="smallfont">$vbphrase[vbookie_this_event_will_pay_out_after] <strong>$eventinfo[payafter_date] at $eventinfo[payafter_time]</strong>.</span></td>
</tr>
<tr>
<td><span class="smallfont"><strong>$vbphrase[vbookie_event_n_bets]</strong>: $eventinfo[item_n_bets_placed]</span></td>
</tr>
<tr>
<td><span class="smallfont"><strong>$vbphrase[vbookie_event_total_staked]</strong>: $eventinfo[item_amount_staked]</span></td>
</tr>
<if condition="$eventinfo[item_status]=='SETTLED'">
<tr>
<td><span class="smallfont"><strong>$vbphrase[vbookie_event_total_won]</strong>: $eventinfo[item_amount_won]</span></td>
</tr>
</if>
</table>
</div>

</div>
</div>
</td>

</tr>
</table>

<br />

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead">$vbphrase[vbookie_outcomes]</td>
</tr>
<tr valign="top">

<td class="panelsurround" align="center">
<div class="panel">
<div align="$stylevar[left]">

<div class="fieldset">
<table cellpadding="0" cellspacing="$stylevar[formspacer]px" border="0" width="100%">
$outcomebits
</table>
</div>

</div>
</div>
</td>

</tr>
<tr>
<td class="tcat" align="right"><span class="smallfont">$vbphrase[vbookie_footer]</span></td>
</tr>
</table>

Style Manager -> Choose the Style to Edit -> "vbookie_view_my_bet"
Replace entire template with:

<tr>
<td class="$bgclass">$bet[item_title]<span class="smallfont"><br /><a href="showthread.php?t=$bet[threadid]">Thread</a> | <a href="vbookie.php?do=viewitem&amp;item_id=$bet[item_id]">Info</a></span></td>
<td class="$bgclass" align="center"><span class="smallfont">$bet[group_title]</span></td>
<td class="$bgclass" align="center"><span class="smallfont">$bet[option_title]</span></td>
<td class="$bgclass" align="center"><span class="smallfont">$bet[item_status]</span></td>
<td class="$bgclass" align="center"><span class="smallfont">$bet[bet_amount_placed]</span></td>
<td class="$bgclass" align="center"><span class="smallfont">$bet[bet_odds_against]/$bet[bet_odds_for]</span></td>
<td class="$bgclass" align="center"><span class="smallfont"> ($bet[odds_decimal]) </span></td>
<if condition="$bet[bet_settled]=='N'">
<td class="$bgclass" align="center"><span class="smallfont">-</span></td>
<else />
<td class="$bgclass" align="center"><span class="smallfont">$bet[bet_amount_won]</span></td>
</if>
</tr>

Style Manager -> Choose the Style to Edit -> "vbookie_view_outcome"
Replace entire template with:

<tr>
<td class="thead" colspan="2">
<strong>$outcome[outcome]</strong>
</td>
</tr>
<tr>
<td>
<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" align="left" width="50%">
<tr>
<td class="thead" colspan="2">
<strong>$vbphrase[vbookie_event_outcome_info]</strong>
</td>
</tr>
<tr>
<td class="alt1">
<strong>$vbphrase[vbookie_event_current_odds]</strong>:
</td>
<td class="alt1">
$outcome[odds_against]/$outcome[odds_for] ($outcome[odds_decimal])

</td>
</tr>
<tr>
<td class="alt1">
<strong>$vbphrase[vbookie_event_n_bets]</strong>:
</td>
<td class="alt1">
$outcome[n_bets_placed]
</td>
</tr>
<tr>
<td class="alt1">
<strong>$vbphrase[vbookie_event_total_staked]</strong>:
</td>
<td class="alt1">
$outcome[amount_staked]
</td>
</tr>
<if condition="$eventinfo[item_status]=='SETTLED'">
<tr>
<td class="alt1">
<strong>$vbphrase[vbookie_event_total_won]</strong>:
</td>
<td class="alt1">
$outcome[amount_won]
</td>
</tr>
</if>
</table>

<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" align="left" width="50%">
<tr>
<td class="thead" colspan="6">
$vbphrase[vbookie_event_bets_placed]
</td>
</tr>
<tr>
<td class="thead">
$vbphrase[vbookie_bet_placed_by]
</td>
<td class="thead" align="center">
$vbphrase[vbookie_bet_placed_amount]
</td>
<td class="thead" colspan="2" align="center">
$vbphrase[vbookie_bet_placed_odds]
</td>
<td class="thead" align="center">
$vbphrase[vbookie_bet_amount_won]
</td>
</tr>
$bets
</table>
</td>
</tr>

You can test the vBookie out yourself at my site if you wish, too(see my sig for a link).

[Andreas]

Can I get some help? Preview works but when I hit submit I get's nothing but the text.
What does "nothing but the Text" mean?

@all those having Problems setting the Permissions
Do you get Errors when hitting Save by any chance?
Do you have other bitfield_xxx.xml Files, and which?

[Bobby S]

What does "nothing but the Text" mean?

@all those having Problems setting the Permissions
Do you get Errors when hitting Save by any chance?

No, it gives the saved usergroup administrators successfully message.

Do you have other bitfield_xxx.xml Files, and which?

Where would I find them? Sorry I'm really stupid sometimes :(

[Andreas]

includes/xml
Which bitfield_xxx.xml Files do you have there?

[Bobby S]

includes/xml
Which bitfield_xxx.xml Files do you have there?

bitfield_vbookie.xml and bitfield_vbulletin.xml

Does that help? [he asked hopefully] :)

[Andreas]

Ok, that means no other Bitfields, eg. no reason why it should not work.
Feel free to send me a PM with an ACP Login, otherwise I can't help much - sorry.

[Bobby S]

Ok, that means no other Bitfields, eg. no reason why it should not work.
Feel free to send me a PM with an ACP Login, otherwise I can't help much - sorry.

That's me sorted, thanks Kirby!

[Andreas]

@Everybody who got the same Problem as Bobby_S (setting reverting to No):

The Bitfield XML must be uploaded before the Product XML is being imported - as stated in the documentation.
If you are not sure if you did that:

Check if the File is present and call admincp/index.php?do=buildbitfields

That should fix the Problem.

[Oap JTRipper]

the only problem we have is that when a new member joins he doesnt get any vcash

had to run a sql querie to up date them

is there a setting somewhere

[Andreas]

Hmm, are you using vCash or uCash?

[Oap JTRipper]

I am using vcash

this is on my test bed localhost, but ill quickly run through what i did

1. we had 2 users Admin & Dave
2. installed vbookie
3.Admin & Dave had 500 vcash
4. added 2 new members same group as admin & Dave
5. They didnt have any vcash
6. Ran the sql query update user set vbookie_cash=500 where vbookie_cash<20
7. The new members now had 500 vcash

[Andreas]

Hmm,, just tested - works for me.
Did you add the new Members through ACP?

[Oap JTRipper]

yep

is that why

[Andreas]

There is an Input Control in the left Column to enter vCash, it's 0 by default :)

If a User registers via the Frontend he will get 500, as the feild is not set there and the Table Default is 500.

Anyway, I think it would be a good idea to introduce a new setting for this in future Versions.

[Chad F.]

I made a test event then deleted the thread but the event is still listed under News & Events, is there any way I can get rid of this? Thanks.

[plateau]

can ver1.6 be used in RC3?

anyway i m trying...

[plateau]

it is ok for RC3, tested successfully..............^&^

[Flow Fusion]

Can I get some help? When I hit submit I get's nothing.

[Andreas]

What does "I get's nothing" mean?

[Flow Fusion]

When I hit submit it shows nothing. But when I hit preview everything looks fine.

[Andreas]

Nothing = Blank Screen, Normal Thread, ...?

[Flow Fusion]

Normal thread. No vBookie event.

[Andreas]

Check your Template Edits.

[Flow Fusion]

I have over and over but hey...I'll try again.

[plateau]

in the vbookie_item_options table, if the option_pays=Y, there should be a WIN! displayed for the related option in an event.

but after i have upgraded to RC3, the WIN! disappeared for all the events.

thanks for help................

[plateau]

meaning that:

<if condition="$outcome[option_pays]=='Y'">
$vbphrase[win]
<else />
&nbsp;
</if>

doesnt run properly.

[Andreas]

It does, just the Phrase is in the wrong Phrasegroup.

As a temporary solution, create a Phrase win in Phrasegroup Showthread

[plateau]

ok, thanks.

u ll solve it in next version? anyway. cheers.

[Andreas]

Yes, will be fixed in the next Version.

[turfy]

No news about my option request ? :)

[Andreas]

I am not a wware of any Request.
Submit it to the Tracker (http://bugs.kirbydemos.ath.cx) to make sure it won't get lost.

[turfy]

I am not a wware of any Request.
Submit it to the Tracker (http://bugs.kirbydemos.ath.cx) to make sure it won't get lost.

https://vborg.vbsupport.ru/showpost.php?p=755171&postcount=39

New Option, not a bug. :)

[kall]

Looks like the Richest Members section of the Bookie Stats takes the value from the vbookiecash field, rather than the one defined..

[Vizionz]

ya know what would make this script the best ever. if it could use xml and grab like nfl nba mlb soccer nhl games per day or week. and post the bets themself. i dont know if it would be possible. since it would have to get odds somehow and fill in alot of fields. but that would be so fresh if it automatically added stuff like that

[Andreas]

@kall
Please report it as a Bug so I can take care of it and it won't be lost.
Thank you.

@visionz
Can you elaborate a bit more?
Where should the XML data come from?

[Vizionz]

<a href="http://sports.yahoo.com/top/odds.html" target="_blank">http://sports.yahoo.com/top/odds.html</a>

i dont know if could grab stuff from there or not

[Sooner95]

is this working ok in 3.5 gold, or should we wait for an update?

[Andreas]

I expect it to be working fine on gold, but I don't know and I am not going to test it at the moment.

[Vizionz]

its working on gold fine

[jojo77]

I made a test event then deleted the thread but the event is still listed under News & Events, is there any way I can get rid of this? Thanks.

I have the same problem here. Anyway to fix this even int MySql query?

[Andreas]

No. Can't b fixed.

[jojo77]

Hey Kirby, is there anyway to have a max bet? I found code in this thread but I think 3.5 is a little different since I don't see that code in there.

https://vborg.vbsupport.ru/showthread.php?t=65844&page=27&pp=15&highlight=reset

[jojo77]

Another big issue here. I have registered users Can Bet on FHQ Bookie Events set to Yes but for some reason they still can't bet on events. But as admin I can bet. Suggestions on what I should look at?

[Andreas]

Check your Permissions is all I can say.

I'll take a look at that max bet stuff.

[jojo77]

got that part to work. didn't know there were permissions within each forum to have to set

[rb290]

i installed it and everything but where do I go to add events ?

[rb290]

I cannot find "Post a vBookie Event" anywhere to put up bets but I do have the vBookie installed

some help please.

[goblues]

You have to create a thread, and it works the same as you create a poll. It will be an option when the thread is created. Clear as mud? Hope that helps.

[rb290]

ok thanks i got it now :)

[rb290]

how do I settle the bets ?

[Flow Fusion]

I tried to run the installer but I get this message...

Fatal error: Call to a member function on a non-object in /home/giftedso/public_html/gs/admincp/vbookie_install.php on line 1176

[Andreas]

@Flow Fusion
Wrong thread. This hack does not have a File vbookie_install.php

@rb290
Go to the Thread

[mclark2112]

Is there any way to retain my users old vCash from before the 3.5 upgrade? I haven't updated vBookie yet, so I'm sure it is still in the database.

Also, is this somewhat ready for primetime?

[xug]

Is there any way to retain my users old vCash from before the 3.5 upgrade? I haven't updated vBookie yet, so I'm sure it is still in the database.

Also, is this somewhat ready for primetime?

Yeah, any info for people who have this already in their database?

[Flow Fusion]

OK I have everything working except 2 issues. Here are the screen caps of both.

http://giftedgraphics.net/flow/cap.jpg

http://giftedgraphics.net/flow/cap2.jpg

I don't see the text and therefore I cannot add an event.

[Andreas]

Uninstall the Product and then import it again, seems like you are missing phrases.

[Flow Fusion]

Reimport the XML, seems like you are missing phrases.
I tried and I get MySQL Error : Duplicate entry 'vbookieactive' for key 1
Error Number : 1062
Date : Monday, October 10th 2005 @ 06:09:20 AM
Script : http://giftedsouls.com/gs/admincp/plugin.php
Referrer : http://giftedsouls.com/gs/admincp/plugin.php?do=productadd
IP Address :
Username :
Classname : vb_database

[nexialys]

in the product manager, there is some missing features, like "re-install phrases only", or templates... this would be awesome to find...
/me look at KirbyDE... maybe some ideas will pop up from his brain!

[Flow Fusion]

OK it happens when I try to uninstall and reinstall I get this message...

MySQL Error : Duplicate entry 'vbookieactive' for key 1
Error Number : 1062
Date : Monday, October 10th 2005 @ 04:59:32 PM
Script : http://giftedsouls.com/gs/admincp/plugin.php
Referrer : http://giftedsouls.com/gs/admincp/plugin.php?do=productadd

[leeman]

Installed "outa the box" ....

Works like a charm.

Thanx for a great mod .....

[Andreas]

@Flow Fusion
Set your Board to debug mode, then send me a PM with an ACP login and permission to run queries.

[dutchbb]

Is there a way to make it use the vb reputation points for vbookie money?

[Brimstone]

Thank you for this hack update, we are loving it. The only error we get (which doesn't affect the functionality of betting) is this page that is displayed after a bet is placed:

No Thread specified. If you followed a valid link, please notify the administrator

Any ideas? Thank you for your time, everyone.

[007]

Would it be possible to add a feature where users can add their own options to bet on, and only one user can bet on each option?

In a nutshell, pick a number between 1 and 1,000. No repeat guesses. I don't want to have to add hundreds of options when probably 50 or so is the max that will be bet on. It wouldn't be numbers, but basically I want people to be able to put in their own entry and limit each entry to 1 bet.

Possible?

Also, does this work with 3.5 uCash right now or not?

[vandaboy]

I get an "Could not find phrase 'edirect_betthanks'."
error after posting a bet. I realize that it should be the "redirect_betthanks" phrase it is looking for but I cannot find the script pointing to it. Any help would be appredciated.

[Andreas]

Please report it as a Bug so I can keep track of it.
Thank you. :)

[hitmanuk2k]

How do you reset all the betting stats?

[Andreas]

Which betting stats?

[hitmanuk2k]

Erm, all of them. We had been using uCash for bets in 3.0.0 but are now just going to use the vBookie cash. So we want to have all the bet statistics, "Event with most bets" etc. reseting so we can have a fresh start.

Thanks for the solution to my other problem regarding usergroups by the way.

[VaaKo]

there is something which I don't understand!

I have made a test bookie on my board
http://www.oneforum.org/showthread.php?%20t=8627

now people will place their bets, right?
but how will they know who won?
how will they win points or loose?
this is what I don't get, please explain!

[Andreas]

@hitmanuk2k
If you uninstall the product and then install, all vBookies Data will be deleted.
If that is what you want.

[Sooner95]

Heya Kirby, you plan on releasing a 3.5 gold release of this? thanks

[Andreas]

@Sooner95
No. There are currently no bugs that need to be fixed, so I don't see reason for an update.

[Sooner95]

well in that case, I will install this version then. Thx bud!

[hitmanuk2k]

@hitmanuk2k
If you uninstall the product and then install, all vBookies Data will be deleted.
If that is what you want.So is there no query I can run to empty the database tables for vBookie?

[Rabbitoh Warren]

I have the same problem here. Anyway to fix this even int MySql query?I just ran this query to remove traces of my first test event. Change news_id where appropriate. Use at your own risk.

DELETE FROM vbookie_news WHERE news_id = '?'