I get this error when I surf on one of the vbookie pages:

I just upgraded to 4.1.9 and keep getting this db error. Can't settle bets nor can we make new ones or create new items to bet on:

Database error in vBulletin 4.1.9:

Invalid SQL:
SELECT
SUM(bet_amount_won) AS sumbets
FROM vbookie_bets_placed
WHERE bet_settled='Y' AND userid=2
AND dateline >
GROUP BY 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 'GROUP BY userid' at line 6
Error Number : 1064
Request Date : Monday, December 19th 2011 @ 07:10:52 PM
Error Date : Monday, December 19th 2011 @ 07:10:52 PM
Script : http://www.1stdegreefreebies.com/for...and=1324343450
Referrer : http://www.1stdegreefreebies.com/forums/index.php
IP Address : **left off on purpose**
Username : Unregistered
Classname : vB_Database
MySQL Version :

Hi dartho, wow, another great mod from you (or ported at least) ... I've just installed this on my forum, and it should go down a treat, I reckon! (When people aren't busy posting in the girlfriend thread).

Just one simple question, where can I edit the template for the bet info? Eg:

https://vborg.vbsupport.ru/external/2011/12/22.jpg

I want to change that odds column where it says (1.10) and (0.83) to $2.10 and $1.83, which I'm correct in saying would be the actual return, wouldn't it? Just to make it a bit simpler for the less seasoned gamblers to use. Should be easy enough, whack in a $ and add one to the numbers, I assume?

Cheers for any help. :)

edit the vBookie: Show Events in Showthread plugin, search for
replace with
then edit the vbookie_outcomebits_nobet and vbookie_outcomebits temapltes and search for
and change to

Thanks dartho!!! Works perfectly, of course! :)

I'm just having a mess around with this, and I'd like the $ change to take effect on bet.odds_decimal as well ... is that possible? This is for the event info screen. I've got the $ sign in there, but can't get the 1 to add on.

Hi dartho,
Please let me know where I can find the yellow word in the pictures to translate in to my language? I use "Search in Phrases" but no thing is change
Thanks

https://vborg.vbsupport.ru/external/2011/12/3.png

https://vborg.vbsupport.ru/external/2011/12/4.png

@SRSC, they are all phrased an can be changed in Phrase Manager.

The language in the second screen capture you have will not change until new information is posted as those statements are recorded in the database based on phrases at the time they were created.

@thenamesgould - check the vbookie.php file andsearch for ['odds_decimal'] and make changes like you did in the plugin

I already changed "OPEN" to new phrase but it not change in the 1st picture? or it will change from new bet created on?
please confirm that

Is it possible to change the name vCash to something else? Instead of in profiles of showing up as vCash i want it to show MPH Chips is this possible to do?