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.

[Mark K]

Installed perfectly on 3.6.8, no problems at all, thx!

Note: when you have a winning bet, you should get whatever you staked back plus the odds, atm you only just get the odds small bug/error whatever you wanna call it!

[jbd]

Hi all,

We used to have vBookie integrated with vbbux/vbplaza. As that is now defunct we switched to vbCredits but had problems getting vbookie to integrate. As a result I have reinstalled vBookie but now get the following DB error when attempting to add an event..

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE user SET =25 WHERE < 25;

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 '=25 WHERE < 25' at line 1
Error Number : 1064
Date : Thursday, September 27th 2007 @ 04:07:43 PM
Script : http://www.mydomain.co.uk/forums/vbookie.php
Referrer : http://www.mydomain.co.uk/forums/vbo...=0&do=newevent
IP Address : xx.189.47.233
Username : thisuser
Classname : vB_Database

I am using the most recent release and have already make the required changes to the
vBookie: Redirect to vbookie.php when posting new Event plugin.

Does anyone have any advice?

[jambo_1969]

Originally Posted by jbd

Hi all,

We used to have vBookie integrated with vbbux/vbplaza. As that is now defunct we switched to vbCredits but had problems getting vbookie to integrate. As a result I have reinstalled vBookie but now get the following DB error when attempting to add an event..



I am using the most recent release and have already make the required changes to the
vBookie: Redirect to vbookie.php when posting new Event plugin.

Does anyone have any advice?

In your functions_vbookie.php check you have a function called...

function vbookie_do_charity()

That is the function that gives the amount 25 if a user has less than 25 in the bank.

case 'vcash':
				$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=" . $vbulletin->options['vbookiegivetopoor'] . " WHERE vbookie_cash < " . $vbulletin->options['vbookiegivetopoor']);

Maybe try re-uploading the php file, overwriting the existing one ?

[jbd]

Thanks for the reply.

I have since resolved the problem. It was caused by a legacy plugin associated with vbPlaza. The automatic uninstall of vbBux/vbPlaza leaves behind 5 enabled plugins, they are:

vBookie With vbPlaza - Do Charity
vBookie With vbPlaza - Get Richest Users
vBookie With vbPlaza - Get User Cash
vBookie With vbPlaza - Give User Cash
vBookie With vbPlaza - Take User Cash

It was the Do Charity plugin causing the error.

Disabling these plugins resolved the issue.

Those who previously had vbPlaza installed and now wish to use vbCredits (or any other custom points system) will likely need to do the same.

[Deadman_014]

Ok, I'm using vBux and I posted an event but its not letting me bet. The white betting boxes aren't there and it says I can't bet on this event. And yes, all the permissions are right. Any help with this? I'm using 3.6.8 and I believe I've done everything correctly :/.

[Geez]

Originally Posted by BozzaJos

Is it possible to remove 1 single match? Upgraded my forum and imported the database but a couple of matches appear @ OPEN and CLOSED but when I click on thread it says invalid page. Is it possible to remove those matches via phpmyadmin? If so, can anyone tell me exactly how? I ain't good with mysql and php.

Much appreciated! Thanks in advance...

*EDIT*

Never mind.. already found it! Thanks anyway!

anyone know where this can be found, and possibly how to do it? im brand new to the vb scene

[timnp]

Originally Posted by pgowder

Having a strange problem.

http://www.luckpredictions.com/vbookie.php

I have enough events for 3 pages, and the script shows that there should be 3 pages.

But when you click on page 2 or 3, the vbookie loads, but doesn't show any events.

Anyone seen this? Is there a fix?

Hi

We were having this problem too. Its a little bug in the code. Here is the fix.
In vbookie.php, find the line that says the following, in my copy it was line 361.

Your looking for:

PHP Code:

$pagenav = construct_page_nav($pagenumber, $perpage, $n_page_items, 'vbookie.php?' . $vbulletin->session->vars['sessionurl'] . "do=main&type=type"); 


and change it to:

PHP Code:

$pagenav = construct_page_nav($pagenumber, $perpage, $n_page_items, 'vbookie.php?' . $vbulletin->session->vars['sessionurl'] . "do=main&type=" . $type); 


A very tiny change. You're changing the end of the line so that it doesn't read

PHP Code:

&type=type"); 


and so that it does read

PHP Code:

&type=" . $type); 


Hope that helps

[pgowder]

Originally Posted by timnp

Hi

We were having this problem too. Its a little bug in the code. Here is the fix.
In vbookie.php, find the line that says the following, in my copy it was line 361.

Your looking for:

PHP Code:

$pagenav = construct_page_nav($pagenumber, $perpage, $n_page_items, 'vbookie.php?' . $vbulletin->session->vars['sessionurl'] . "do=main&type=type"); 


and change it to:

PHP Code:

$pagenav = construct_page_nav($pagenumber, $perpage, $n_page_items, 'vbookie.php?' . $vbulletin->session->vars['sessionurl'] . "do=main&type=" . $type); 


A very tiny change. You're changing the end of the line so that it doesn't read

PHP Code:

&type=type"); 


and so that it does read

PHP Code:

&type=" . $type); 


Hope that helps

Thanks, but my page 2 is still blank.

http://www.luckpredictions.com/vbook...pe=type&page=2

[timnp]

Originally Posted by pgowder

Thanks, but my page 2 is still blank.

http://www.luckpredictions.com/vbook...pe=type&page=2

Hi, I don't think that you can have made the change properly.
Can you check?

The link to your second page should be this: http://www.luckpredictions.com/vbook...pe=OPEN&page=2

Notice how in the one you posted it has &type=type, but the one I just posted has &type=OPEN, (OPEN would normally change depending on what type of bet you are viewing (closed, open, abandoned, etc). I can't see how you would still be having this problem if the patch wasnt applied as &type=type only has one occourence in that file and it should have been removed if you did the fix I suggested.

Also, if you keep using the link that you posted it will always be an empty page. The link its self is broken because it has the type=type problem, go to your page one and click the link to the next page each time, dont bookmark until its fixed

[pgowder]

I have this line now:

$pagenav = construct_page_nav($pagenumber, $perpage, $n_page_items, 'vbookie.php?' . $vbulletin->session->vars['sessionurl'] . "do=main&type=" . $type);