vb.org Archive

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)

Dream 08-22-2005 08:05 PM

[sql]INSERT INTO vbookie_bets_placed (option_id, item_id, userid, bet_amount_placed, bet_odds_against, bet_odds_for, bet_private) VALUES (92, 20, 11209, 39,448, 2, 1, 'N');[/sql]

Andreas 08-22-2005 08:23 PM

I guess you staked "39,448" instead of "39448"?

Dream 08-22-2005 08:39 PM

man thats a serious secutiry issue, I could make queries there I think :O

Andreas 08-22-2005 08:40 PM

Yep.

Dream 08-22-2005 08:50 PM

build 4 corrects that?

want me to edit my posts

edit: and any way we could get maximum odds?

Andreas 08-23-2005 06:28 PM

Build 5 is available now.
For changes see first Post.

TTG 08-23-2005 07:47 PM

Thanks for the update Kirby.
I always thought clicking the 'Install' button provided us with an email when the coder updated a hack .. ?

Andreas 08-23-2005 07:50 PM

If he sends an Update eMail - Yes.
But I only do so for critical Updates.

Rat1972 08-23-2005 08:49 PM

i have a problem.

I did everything the manual said, but when i set a bookie event and, i want to let everyone to set one bet maximum, then the system gives an error: That i only can bet once. But it's my first bet.

When i do: Multiple bets
Then i get this error:

Fatal error: Call to undefined function: query_write_write() in /home/support/domains/supportersworld.nl/public_html/bulletin/vbookie.php on line 1248

I unstalled it, and reinstalled it again, but it doesnt help. Anyone knows what i have to do?

Andreas 08-23-2005 08:54 PM

Sorry. Redownload vbookie.php, that should fix it.

Rat1972 08-23-2005 09:41 PM

i also did that. I deleted the files, load new files up, i did everything, but i still have the problem. Strange :)

Andreas 08-23-2005 09:48 PM

Still the Fatal Error?

Rat1972 08-23-2005 09:57 PM

i got now a new error (the error that i only bet once, is still there)

now i get this, when i set in on multi:

UPDATE vbookie_item_options SET option_n_bets_placed=option_n_bets_placed+1, option_amount_staked=option_amount_staked+ WHERE option_id=1;

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 'WHERE option_id=1' at line 1
Error Number : 1064

Andreas 08-23-2005 10:01 PM

OK, gonna check that ... just discovered a few non-working phrases as well, grmpf.

Rat1972 08-23-2005 10:04 PM

Quote:

Originally Posted by KirbyDE
OK, gonna check that ... just discovered a few non-working phrases as well, grmpf.

oke thanx for your help mate!

Andreas 08-23-2005 10:08 PM

Can you check if it's working correctly on my Board?

Rat1972 08-24-2005 05:11 AM

I downloaded this morning this script again here, i don't know of you chanced anything, but now it works perfect on my board.

Thank you so much for the big help

Biker_GA 08-24-2005 05:17 PM

I've run into an issue with the Showthread template. On line 543 I'm showing:

HTML Code:

<tr valign="top">
        <td class="alt1" <if condition=&quot;!$show['search']">colspan="2"</if>>

There are no close tags for tr and td. Where exactly should the close tag for td go?

Andreas 08-24-2005 05:22 PM

@Rat1972
I ddn't change anything since yesterday (well, I did fix the Phrases but I did not upload the new Files yet)

@Biker_GA
The Template looks somewhat damaged?

Biker_GA 08-24-2005 05:26 PM

Yeah.. Big time.. A LOT of whitespace between sections. Ideal solution would be to fix the template without reloading the entire forum, though.

Andreas 08-24-2005 05:27 PM

Did you try to compare it with the Original?

Biker_GA 08-24-2005 05:33 PM

I don't have that option as there are no changes made to it yet. System considers it as orginal.

Andreas 08-24-2005 05:36 PM

w00t?
Did you install any Hack that automatically modified Templates?

Biker_GA 08-24-2005 05:37 PM

Oh hell. Which one?! LMAO! This plugin/product is towards the end of my list of MANY that I have installed.

rinkrat 08-24-2005 05:40 PM

What do I do to upgrade from a week old version? I don't see it in the files.

Andreas 08-24-2005 05:41 PM

Well then ... you could try to reimport the MASTER Style, but I am not sure if this does work.
Furthermore, you should really find out what caused that ...

@rinkrat
Overwrite the Files, import the Product XML (Overwrite must be ticked) - Done.

Biker_GA 08-24-2005 05:44 PM

These are the modifications I've made so far:

In Reply to
Opt-Out
uCash
yet Another Award System
New PM on Forum Home
Welcome Panel
Multi Quote
Quote post in PM
Create reported post as thread
vBookie

It's strange... There are obvious errors in the template, yet the forums are working fine.

Andreas 08-24-2005 05:46 PM

Well, don't know how I can help you on this. Sorry.

Rat1972 08-24-2005 06:21 PM

Quote:

Originally Posted by KirbyDE
@Rat1972
I ddn't change anything since yesterday (well, I did fix the Phrases but I did not upload the new Files yet)

@Biker_GA
The Template looks somewhat damaged?

Strange i did it yesterday 20 times, and everytime the error.
I woke up this morning and i tried again and it works.
On my other forum there was no problem and it worked the first time.

I am glad it worked and ofcourse for the support you give here.

Glovebox 08-26-2005 11:23 AM

Excuse me if this is a dumb question, but when Im trying to change the usergroup permissions. (Can Post vBookie Events, Can Edit other people's vBookie Events , Can Bet on vBookie Events) After I update it, they just change straight back to no..

Any help?

Adam

Andreas 08-26-2005 07:56 PM

Do you have other Hacks installed as well?

Glovebox 08-26-2005 08:31 PM

Yeah, Inferno Warning System 1.2 Right Column 1.0 uCash 1.1.1 vBookie 1.0.5 Build 6 vBShout 1.6 Yet Another Award System 3.5

Andreas 08-26-2005 08:42 PM

I don't think any of these could conflict with vBookie but just to be sure:
Did you try to disable them?
Which bitfield_xxx.xml Files do you have in includes?

Glovebox 08-26-2005 08:49 PM

I just have bitfield_vbookie.xml and bitfield_vbulletin.xml. You mean in /includes/xml right?

Didnt try to disable any, I will try that now.

plateau 08-26-2005 10:45 PM

new function suggestion:

put restriction on the lowest stake which users can bet on an event. such as, at least 20, 50... like this.

Gizmo5h1t3 08-26-2005 11:25 PM

Quote:

Originally Posted by plateau
new function suggestion:

put restriction on the lowest stake which users can bet on an event. such as, at least 20, 50... like this.

works the other way as well, might be an idea to have a high limit, to stop one or two members racing away by betting with all their money....

this discourages some membes from taking part, as its human nature to want the most money, if that unobtainable, they just give up using vbookie...
ive seen it happen...

plateau 08-30-2005 06:08 PM

Quote:

Originally Posted by Gizmo5h1t3
works the other way as well, might be an idea to have a high limit, to stop one or two members racing away by betting with all their money....

this discourages some membes from taking part, as its human nature to want the most money, if that unobtainable, they just give up using vbookie...
ive seen it happen...


yes, u r right mate. that's a good idea.

found another bug:

when u edit an event, the Month for the Accept Until wont be shown as what u set previously, it will always show the current month. e.g. if u previously set it to September, and then you edit it, it will show Auguest, then u have to change it back to Sept., at least.

wcbryant 08-31-2005 07:57 PM

Under 3.0.x, my site has been using vCash for my bookie events. I'm moving my production site to 3.5.x tonight, and I really want to change that to uCash, but my users really want to keep their totals from the last year, except for some who were recently shorted their starting totals because of a configuration mistake.

So two questions/calls for help as I struggle with mysql;

1. Does anyone know of a way (been looking around for about an hour, and haven't found anything), perhaps a query, to copy all vcash values to ucash in the database?

2. Can anyone suggest a query that would give all users with less than X ucash, Y as a new balance -- but only if their userid is greater than Z?

Thanks in advance.

Andreas 08-31-2005 08:01 PM

1. [sql]update user set ucash=vbookie_cash[/sql]
2. [sql]update user set ucash=y where ucash<x and userid>z[/sql]

wcbryant 09-01-2005 08:05 PM

When I ran that query after upgrading vB from 3.0.1 to 3.5.0, and upgrading Bookie as well, it reset everyone to 500. Not sure how or why.

I still have a live copy of my database on another box with all the appropriate vCash data. Trying not to sound completely helpless, can someone suggest (in specific terms) how to extract that info from that db, and import it into the other one?

Can mysqldump for example just pull the one row, and create an sql file I could use to import it into the other?

Thanks in advance for any advice.


All times are GMT. The time now is 11:10 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.03244 seconds
  • Memory Usage 1,811KB
  • 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_html_printable
  • (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
  • (40)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