vb.org Archive
Page 70 of 108 « First 20606869 70 717280 Last »
Show 40 post(s) from this thread on one page

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)

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.username, user.userid, user.vbookie_cash AS vcash, userban.liftdate, if( customavatar.dateline IS NULL , NULL , 1 ) 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 ??????


All times are GMT. The time now is 10:26 PM.
Page 70 of 108 « First 20606869 70 717280 Last »
Show 40 post(s) from this thread on one page

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.02016 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
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)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