vb.org Archive - vBookie for vBulletin 3.5

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	09-27-2007 02:14 PM

Quote:

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

09-28-2007 06:32 AM

Quote:

Originally Posted by jbd (Post 1348243)

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

Quote:

function vbookie_do_charity()

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

Code:

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	09-28-2007 02:23 PM

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

09-30-2007 04:07 PM

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	10-03-2007 10:04 PM

Quote:

Originally Posted by BozzaJos (Post 1243071)

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 :cool:

timnp

10-04-2007 09:29 AM

Quote:

Originally Posted by pgowder (Post 1340523)

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

10-04-2007 12:19 PM

Quote:

Originally Posted by timnp (Post 1352683)

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

10-04-2007 12:30 PM

Quote:

Originally Posted by pgowder (Post 1352762)

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

10-04-2007 12:42 PM

I have this line now:

Code:

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

All times are GMT. The time now is 05:48 PM.

Page 162 of 244

162

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03726 seconds Memory Usage 1,774KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (8)bbcode_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: