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.

[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]

Originally Posted by 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.

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]

Originally Posted by Gizmo5h1t3

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. [sql]update user set ucash=vbookie_cash[/sql]
2. [sql]update user set ucash=y where ucash<x and userid>z[/sql]

[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.