vb.org Archive - vBookie for vBulletin 3.5

Wouldn't it just be a WHERE clause? something like UPDATE user SET vbookie_cash=500 WHERE userid=x

(I'm not a coder but maybe one can chime in and confirm)

Cheers,

Regs.

you are correct Regs :up:

WhisperXBA

08-18-2008 10:11 PM

Hello, thanks for the quick input, that is what I already tried, I saw the WHERE command while searching for the other SQL entries.

UPDATE user SET vbookie_cash=500 WHERE userid=_____ does not work.

error number: 1054
error desc: Unknown column 'admin' in 'where clause'

--------------

I have gotten one step further by entering:

UPDATE user SET vbookie_cash=500 WHERE userid='accountname'

(adding single quotes around the userid)

However, that doesn`t give me the 1054 error, but will give me an affected rows of zero, no change to the user`s vCash. The userid is spelled correctly, obviously.

milla da killa

08-20-2008 12:10 PM

Quote:

Originally Posted by serge2k6 (Post 1600954)

no, I already tried the bitfield fix.

edit: I don't have the option for a vbookie even below the poll option.

That's because you didn't change the usergroup permissions or didn't follow the incredibly basic instructions.

bobster65

08-20-2008 03:49 PM

Quote:

Originally Posted by WhisperXBA (Post 1601850)

that is because userid is a NUMBER, not the members name. use WHERE username='accountname'

RvG2	08-21-2008 06:59 PM

Quote:

Originally Posted by Andreas (Post 1506931)

Please do not PM me with questions about this piece of crap.

There won't be any further development, nor am I willing to give anyone permission to re-use this code.

Thanks for your understanding.

I was wondrin' what makes you think this is a piece of crap... :(

I really love this mod. :)

BTW, a mod with 2000 replies makes sense after all... ;)

Lombardo

08-22-2008 12:11 PM

When i select "post a vbookie event" and click to post tthread, it just comes up a normal thread and not the options to do my vbookie event, any ideas? Doesn't matter, i've fixed that.

My next problem no matter what date or time i set on an event i can't place any bets, all my permissions are set correctly, i'm 100% sure of that. Any ideas? :(

The times are backwards, my board time is gmt and my bookie is gmt but i have to set it for 4am if i want it to end at 4pm :( how do i fix that

msu2k

08-25-2008 03:47 PM

Quote:

Originally Posted by Andreas (Post 1506931)

I don't understand this whatsoever. If you're going to abandon this, why not let someone else try to resurrect it? There are 600+ vBulletin owners that have a use for it apparently, why not throw them a bone? It is an integral part of my forums and probably many others. Hell, charge for it if you want even, it is valuable enough to many of our communities that many would probably be willing to support it financially.

nick-harper

08-29-2008 12:27 PM

I would be willing to pay for this.

Quads

08-29-2008 08:39 PM

Seems I have everything working / installed correctly, however I can't seem to post vbookie events in the new threads. I never seem to get this option in the posting of a new thread: https://vborg.vbsupport.ru/attachmen...9&d=1123815803

I have created a new user group ("Bookie") and given them access to create events / manage, as well edited forum permissions. I see the vBookie option in the menubar, all works there. However unable to create an event in the thread.

Perhaps something I missed?
I've tried searching through the thread, but at 135 pages, it's quite tough.

Any input would be greatly appreciated.

bobster65

08-29-2008 09:23 PM

Quote:

Originally Posted by Quads (Post 1610157)

did you rebuild the bit fields so the permissions don't default back to no?

Append this to your forms URL..

/admincp/index.php?do=buildbitfields

All times are GMT. The time now is 12:25 AM.

Page 201 of 244

201

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

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