vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBookie - vBulletin Betting Hack (https://vborg.vbsupport.ru/showthread.php?t=65844)

WiseOwl 01-24-2005 11:45 AM

If anyone has any information pertaining to my problem please let me know, I would like to install this modification. I have made all file edits and am ready to upload the php files, but before I do I need to get this problem resolved with the install process of this modification...


When attempting to add database modifications after inserting phrases I get this error... whats wrong ?


Quote:

Database error in vBulletin 3.0.5:

Invalid SQL:
CREATE TABLE vbookie_groups (
group_id SMALLINT UNSIGNED DEFAULT '1' AUTO_INCREMENT NOT NULL PRIMARY KEY,
group_title VARCHAR(255) NOT NULL
) TYPE=MyISAM

mysql error: Invalid default value for 'group_id'

mysql error number: 1067

Date: Monday 24th of January 2005 05:06:19 AM
Script: vbookie_install.php

WiseOwl 01-24-2005 12:23 PM

I noticed "joshskeety" had this problem back in August of 2004 he was looking for assistance 7 diferent times in this thread relating to the same mysql error 1067 that I'am currently having with the install.. also "teamgofast" had the same problem, I don't see a resolution for this anywhere in the 30 pages of this thread..

How do you change the default value of group_id and is that what needs to be changed? any help would be greatly appreciated as to I have already made all file edits and this is the only thing holding me back... thank you

WiseOwl 01-24-2005 02:46 PM

1067 is...

Error: 1067 is a invalid default value for '%s'

i tried to manually add the table "vbookie_items" but it returns #1067 - Invalid default value for 'item_id' so what's the deal ? can I get some support, or should I just give up on the vbookie ????


Ok I managed to add the table, but 3 of the items are incorrect, my synxtax wasnt right, for the following three items...

Quote:

item_id MEDIUMINT UNSIGNED DEFAULT '1' AUTO_INCREMENT NOT NULL PRIMARY KEY,

item_status ENUM('OPEN', 'CLOSED', 'SETTLED', 'ABANDONED') DEFAULT 'OPEN',

item_allow_multiple_bets ENUM('Y', 'N') DEFAULT 'Y',
can someone explain how to set those three correctly in php my admin manually, because the vbookie_install.php does not install the table correctly..

teamgofast 01-26-2005 11:22 PM

bump bump got alot of people who want there vbookie back :(

Quote:

Originally Posted by WiseOwl
1067 is...

Error: 1067 is a invalid default value for '%s'

i tried to manually add the table "vbookie_items" but it returns #1067 - Invalid default value for 'item_id' so what's the deal ? can I get some support, or should I just give up on the vbookie ????


Ok I managed to add the table, but 3 of the items are incorrect, my synxtax wasnt right, for the following three items...



can someone explain how to set those three correctly in php my admin manually, because the vbookie_install.php does not install the table correctly..


WhiteOx2 01-30-2005 06:43 PM

Is there a way to stop the editing of events after they have closed?
Because the person hosting the event can change the odds to there favor payout and then change them back again. :(

I have an honest thief on my board. :D

Spikeh 01-30-2005 07:09 PM

WhiteOx

Your hack works, how did you sort out the settings not saving and reverting back to No in the ACP?

Or anyone else to answer this?

Thanks.

WhiteOx2 01-30-2005 09:33 PM

Spikeh the hack works fine, I've had it installed on 3.0.3 - 3.0.6
I'm not sure what you mean by your above question.

Also I fixed my above question (kinda) by copying and pasting a bit of code in vbookie.php file. :)

Spikeh 01-31-2005 09:20 AM

Hey,

Whenever I alter the settings in the ACP and click Save they revert back to No.

EA Junkie 02-02-2005 05:14 AM

Upgraded vBulletin to 3.0.5 and vBookie no longer works. I've gone back and modified all the code, but continue to get a white screen when clicking on vBookie tab. I run an online sports games site and this hurts our fun...

Help Please!!!

skinny 02-02-2005 04:59 PM

Quote:

Originally Posted by EA Junkie
Upgraded vBulletin to 3.0.5 and vBookie no longer works. I've gone back and modified all the code, but continue to get a white screen when clicking on vBookie tab. I run an online sports games site and this hurts our fun...

Help Please!!!

It has been working fine on my 3.0.6 and did so on 3.0.5. If you are getting a blank screen you've obviously not installed it correctly. Do you have any other hacks installed?

I would suggest uploading the files again, checking the templates once over because there is something not quite right there. You DB should still be intact so you wont lose any data.


All times are GMT. The time now is 01:34 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01694 seconds
  • Memory Usage 1,745KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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