vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Add-On Releases - vBookie for vBulletin 4 (https://vborg.vbsupport.ru/showthread.php?t=233473)

dartho 06-08-2011 09:18 PM

Quote:

Originally Posted by BMR (Post 2205245)
That still doesn't really help me, I know where all the bookie templates are I just don't know where to change the input text color.

It was you that asked what template, if you already know which one then edit it, search for the elements you wish to change and change them.

SECTalk.com 06-10-2011 03:41 PM

Not sure if it's suppose to, but there is no "vBookie" prefix in front of threads which include a vbookie event. Any idea if this is possible? There is always the manual option of adding a prefix but I'd rather not do that.

Thanks

SECTalk.com 06-14-2011 06:33 PM

Bump..

dartho 06-17-2011 02:19 AM

As you have worked out, there is no built in support for prefixes. It is no doubt possible, but not something I'm working on

SECTalk.com 06-17-2011 06:07 AM

I have further noticed that the prefix indeed displays when you are looking at a forum, but not on searches. Is there any way to remove the prefix from the forum view?

Thanks

SECTalk.com 06-17-2011 06:11 AM

Nevermind, I see that you can disable the plugin thread prefixes under this product.

This can allow users to setup a custom prefix to manually choose when setting up vbookie threads. It isn't perfect, but it will work. :)

tareqbd 06-18-2011 04:54 AM

Hello, I have installed it with my vb 4.1.3. It's installed well but it's not integrating with vBcredit Deluxe II. Can you help me please.

rootsxrocks 06-18-2011 06:13 AM

You must use the custom setting the credits setting is for the older version of credits.
there is also a action set that Dark created for this.

Viruseater 07-02-2011 02:25 PM

EDIT: nevermind, figured it out.

thanks for porting this to 4x!

Brexen 07-05-2011 09:05 PM

Does anybody link me to vbookie for 4.1.4 i tryed looking for it but cant find it :( please link me to it ...

DS MrSinister 07-06-2011 02:34 AM

How about the first post mate.

Download version 4.0.9

MagicThemeParks 07-06-2011 11:51 AM

Just to confirm: Is the style fix referenced in the 2nd post supposed to be entered before </head> in the "page" template? If so, it was already there and still showing a broken style. Any other suggestions on what we can do to avoid having the vBookie page displaying the header and footer issues?

EDITED: Just reread the posts near the suggested fix and realized it's not the "page" template, but the "VBOOKIE" template that needs that piece of code added. :up:

Dismounted 07-14-2011 12:16 PM

Just a heads up for those of you interested: dmActivityStream now has a vBookie integration. :)

MagicThemeParks 07-29-2011 09:09 PM

How can you increase the number of "News and Events" displayed on the vbookie.php page?

Edited: Found it. Open vBookie.php and go down to line 406 and change the "4" number in the following line to whatever you'd like.

Code:

$newsresult = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "vbookie_news ORDER BY news_id DESC LIMIT 4");

dartho 07-29-2011 09:50 PM

Quote:

Originally Posted by MagicThemeParks (Post 2226589)
How can you increase the number of "News and Events" displayed on the vbookie.php page?

Edit vbookie.php search for $newsresult = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "vbookie_news ORDER BY news_id DESC LIMIT 4"); and change the 4 on the end with the number of news items you want disaplyed.

lapiervb 08-06-2011 09:23 PM

Could this be used to create an NFL Pool?

Jellymedia 08-15-2011 03:08 PM

Looking for a little support, if you don't mind. Our forum has been cripplingly slow for the last few days and it turns out that this query is tying up the user table in our database for at least 20 seconds each time:

PHP Code:

SELECT user.usernameuser.useriduser.vbookie_cash AS vcashuserban.liftdate, if( customavatar.dateline IS NULL NULL ) AS hasAvatar, (

SELECT bet_id
FROM vbookie_bets_placed
WHERE userid 
user.userid
AND bet_private 'N'
AND bet_settled 'Y'
AND bet_amount_won >0
ORDER BY bet_placed DESC 
LIMIT 1 
) AS lastwinid
FROM user
LEFT JOIN userban ON user
.userid userban.userid
LEFT JOIN customavatar ON customavatar
.userid user.userid
WHERE user
.vbookie_cash >450
AND userban.liftdate IS NULL /* REMOVE THIS FOR REAL DATA */
AND (

SELECT bet_amount_won
FROM vbookie_bets_placed
WHERE userid 
user.userid
AND bet_private 'N'
AND bet_settled 'Y'
ORDER BY bet_placed DESC 
LIMIT 1 
) >0/* ^^^^ REMOVE THIS FOR REAL DATA */
ORDER BY user.vbookie_cash DESC 
LIMIT 7 

Trouble is--or one of the troubles--is that I can't find where this is being executed, so I can't remove/rewrite it. Any idea?

fly 08-15-2011 03:59 PM

Why not just disable the product?

dartho 08-15-2011 09:35 PM

That query is not like any in the stock vbookie. You've modified it and added that in your self somewhere along the way.

Why not search through the vbookie.php and the includes/functions_vbookie.php files and also check the plugins associated with vbookie to see if you can track it down? Failing those you could search your database and also grep your files...

dgparent 08-18-2011 08:00 PM

How the hell do you actually add a event to bet on ??????

bobster65 08-18-2011 08:52 PM

Quote:

Originally Posted by dgparent (Post 2235051)
How the hell do you actually add a event to bet on ??????

create a new thread and check the option to make it a vbookie event. When you submit the thread, you will be taken to the next step which is creating the event.

dgparent 08-18-2011 11:30 PM

OK I finally figured out how to add a event but now I figure out how to actually bet on it ?? I registered as a new user and I still can't figure this freaking thing out each user is given 1000 by default.

dgparent 08-18-2011 11:36 PM

Also I have vbseo installed and when you click on the "Bet Statistics" tab you get a 404 error ??


http://www.collegefootballforum.info...e.php?do=stats

This error might be a result of a empty query set, due to the fact no one can bet

dgparent 08-18-2011 11:41 PM

One other thing this makes no sense, where do you get vBExperience401_20100803.zip ?? I searched every forum here I can't find it , so I can't find \extras\Addons\vBookie.xml either

You can now use also vBExperience as a cash system.

If you have already vBExperience installed, you just need the plugin for it. Download vBExperience401_20100803.zip and install ZIP\extras\Addons\vBookie.xml as a product. After that choose "Custom" as your "Cash/Points System".

dgparent 08-19-2011 12:17 AM

Ok I am starting a game on my site using this I need to be able to do this

1. Each week I post 15 games with lines to bet on users bet vcash on them
2. I want them all in 1 thread not 15 threads

How do you do that? So users can pick and choose between 15 games each week in 1 thread ? If you start with 30 outcomes will that work ? I don't think so.

Basically I need the ability to add as many games with 2 outcomes as I want to ONE thread.

pharlap 08-19-2011 10:35 PM

Quote:

Originally Posted by dgparent (Post 2235131)
OK I finally figured out how to add a event but now I figure out how to actually bet on it ?? I registered as a new user and I still can't figure this freaking thing out each user is given 1000 by default.

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

change 1000 to the start value you want for new users

New Joe 08-24-2011 04:19 AM

How can I add the VCash to the postbit manually?

Mickie D 08-25-2011 08:26 PM

Little problem with this.

When I had the original on vb3 it would give and take money from the bookie.

so whatever the members betted, went into the bookies cash, and if they won they would receive the money from the bookie, if they lost the bookie would keep the cash.

My users liked this as it put an edge on the game - nicking a little from there friends.

Now when they play the money goes no where but they win or lose the amount.

Does anyone have any ideas why the bookie is not getting the money before the game ?

Thanks for any help.

Mick

bobster65 08-27-2011 04:40 AM

Quote:

Originally Posted by Mickie D (Post 2238076)
Little problem with this.

When I had the original on vb3 it would give and take money from the bookie.

so whatever the members betted, went into the bookies cash, and if they won they would receive the money from the bookie, if they lost the bookie would keep the cash.

My users liked this as it put an edge on the game - nicking a little from there friends.

Now when they play the money goes no where but they win or lose the amount.

Does anyone have any ideas why the bookie is not getting the money before the game ?

Thanks for any help.

Mick

That must have been a customization that someone had done for you as vbookie has never been that way.

talkncaasports 09-02-2011 05:58 AM

Quote:

Originally Posted by dgparent (Post 2235146)
Ok I am starting a game on my site using this I need to be able to do this

1. Each week I post 15 games with lines to bet on users bet vcash on them
2. I want them all in 1 thread not 15 threads

How do you do that? So users can pick and choose between 15 games each week in 1 thread ? If you start with 30 outcomes will that work ? I don't think so.

Basically I need the ability to add as many games with 2 outcomes as I want to ONE thread.

Unless someone knows something I don't, which is probably going to be the case, that is the way to do it.

That is at least the way I have done it in the past.

If you are wanting all your weeks games to be in one thread, just use as many outcomes as you need. You can have multiple winners for each event.

Mickie D 09-04-2011 05:05 PM

Quote:

Originally Posted by bobster65 (Post 2238596)
That must have been a customization that someone had done for you as vbookie has never been that way.

You could probably ask 500 of my members that use it regularly, that is how it worked and I never made any customizations, or anyone else.

I would however pay for someone to do that no problem, as it was much more fun for everyone.

Still loving this mod though!

Mick

dartho 09-04-2011 09:53 PM

Bobster is correct, that was never default behaviour. There are instuctions in the 3.5 version thread on how to make this change, but I ran into an issue when having a quick look at it under 4.0, so it is more than a quick job (and not one I can do at the moment).

BTW - I still use vb3.8 and have that same code modification.

Mickie D 09-04-2011 10:08 PM

No problem Dartho, thanks for looking.

Can you point me to that information please, I will take a little look.

But I can promise you I never done this modification, very strange?

Regards
Mick

Mickie D 09-04-2011 10:22 PM

Found it here.

https://vborg.vbsupport.ru/showpost....&postcount=716

Will have a look at it tomorrow.

Regards
Mick

dartho 09-04-2011 10:39 PM

Ah - I remember now, you're probably using this version whioch would explain why you did not have to modifiy the code: https://vborg.vbsupport.ru/showthrea...17#post2157617

Mickie D 09-05-2011 04:23 PM

That was exactly the one I installed :)

Thought I was going crackers there.

I have just got in from work but seen that the switch uses "vcash" instead of "vCash"

Looking over it now hopefully I can get it going

Mick

Mickie D 09-05-2011 06:16 PM

I got it working!

It was a very easy fix - you just change the "CASE".

If anyone is interested and all credits to the original add on maker... I done nothing really!

You will need to follow the instructions from this post
https://vborg.vbsupport.ru/showpost....&postcount=716

But when it comes to the edit for function_vbookie.php use this code below

Code:

// Additional pay/debit bookie
function vbookie_take_bookie_cash($userid, $amount)
{
        global $vbulletin;

        $bookie = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid=$userid");

        switch ($vbulletin->options['vbookiecash'])
        {
                case 'vCash':
               
               
                        if($amount > $bookie['vbookie_cash'])
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=0 WHERE userid=$userid");
                        }
                        else
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=vbookie_cash-$amount WHERE userid=$userid");
                        }
                        break;
                case 'uCash':
                        if($amount > $bookie['ucash'])
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ucash=0 WHERE userid=$userid");
                        }
                        else
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ucash=ucash-$amount WHERE userid=$userid");
                        }
                        break;
                case 'eBux':
                        if($amount > $bookie['ebux'])
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ebux=0 WHERE userid=$userid");
                        }
                        else
                        {
                                $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ebux=ebux-$amount WHERE userid=$userid");
                        }
                        break;
                case 'custom':
                        ($hook = vBulletinHook::fetch_hook('vbookie_take_bookie_cash')) ? eval($hook) : false;
        }
}


dartho 09-05-2011 09:32 PM

Excellent - glad you go it working!

CharlieDelta 09-08-2011 05:16 PM

Quote:

Originally Posted by dartho (Post 2004346)
I used to have a max limit on my site (although users could get around this by placing multiple bets) - I'll have a look

Hi dartho, is this something you would be interested in doing. Would be of good use for us.

ProFifaLeagues 09-08-2011 06:07 PM

Quote:

Originally Posted by CharlieDelta (Post 2243486)
Hi dartho, is this something you would be interested in doing. Would be of good use for us.


Would also be of use to us too :) :up:


All times are GMT. The time now is 11:01 PM.

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.02454 seconds
  • Memory Usage 1,848KB
  • 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
  • (1)bbcode_php_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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