vb.org Archive - vBookie for vBulletin 3.5

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - vBookie for vBulletin 3.5 (https://vborg.vbsupport.ru/showthread.php?t=94128)

hmm well thats nice. Your threadid in the example you posted is 6743

I have this running on my 3.8 board, it works, but with issues.
Single & Multiple Events can be created without issue & Thread is also created without issue.
When settling events is when I get database errors every time about Duplicate Keys.
Are these caused by the same member betting more then one event? If so, how can this be corrected.

Code:

Invalid SQL:

INSERT INTO vbookie_news (news_text,news_type,news_time) VALUES('<b>oZ.wildjay-eddie</b> won <b>125</b>!','winner',1265523235);



MySQL Error : Duplicate entry '<b>oZ.wildjay-eddie</b> won <b>125</b>!' for key 'news_text'

Error Number : 1062

Also, when deleting an event on the vbookie main page, then the thread, the Bookie News & Events Section on the main vbookie page still shows the event I just removed.
This has to be manually removed via database.
What can be done to have it remove the event from the Bookie News & Events Section on the main vbookie page when the proper steps were taken to remove an event.
================================================== ======

Also, on the main vbookie page in the Bookie News & Events Section, After bets have been settled, each event only shows one winner & how much he/she won....how can I expand it to show more winners of each event?

I did not read through every page of this thread, but I did search for Duplicate Entery & looked through many pages to find a remedy.
Thank you in advance.

so how the hell do you give new users a default amount of vcash??

I may be wrong, but asking a different way just might help & maybe searching through this thread you just might find the answer.
Top right side, Search this modSearch for changing default vcash.

did your suggested search. found 3 people asking the same question and they were either ignored or confronted with similar snide responses as yours.

if you don't know, just say so.

Quote:

Originally Posted by theybannedme (Post 1981516)

so how the hell do you give new users a default amount of vcash??

Edit the default value of vbookie_cash in your DB.

Something like

ALTER TABLE user CHANGE COLUMN vbookie_cash vbookie_cash BIGINT(20) UNSIGNED NULL DEFAULT 10000;

should do it. Change 10000 to whatever, and add a tableprefix to "user" if you have one

Quote:

Originally Posted by dartho (Post 1981609)

Edit the default value of vbookie_cash in your DB.

Something like

ALTER TABLE user CHANGE COLUMN vbookie_cash vbookie_cash BIGINT(20) UNSIGNED NULL DEFAULT 10000;

should do it. Change 10000 to whatever, and add a tableprefix to "user" if you have one

Getting database error after i passed this query. I edited the xml file and set my default vCash :)

Quote:

Originally Posted by romeo12 (Post 1984342)

Getting database error after i passed this query. I edited the xml file and set my default vCash :)

edited xml and reinstalled and it didn't work :confused:

So, I read on the first post about the fact that this mod does not work for 3.6+ but see other sites that are running 3.7 and 3.8 using it.

Is there one 'all stop shop' posting or several posts that will make it functional with 3.8?

I'm going to start looking through the 160 pages to find the info, but I'd appreciate the help if anyone knows the key to get this working properly :D

By the way, I'm surprised that no one has taken this one over as it is a pretty popular hack / mod for sports-related sites.

Quote:

Originally Posted by dartho (Post 1979440)

Yeah you can do this by going to the URL
vbookie.php?t=xxxxx&vbookieeventoptions=0&do=newev ent
where xxxxx is the threadid of the trhead you wish to add an event to

hey dartho... just getting around to this now. I'm trying to add a bookie event to an existing event using the url you provided.

However, when I try to go to this page I get a message saying I don't have permission to access this page. (Not sufficient privileges to access this page?) but I am the admin.

Any ideas about this?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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:

Phrase Groups Available:

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