View Single Post
  #1642  
Old 08-03-2011, 07:53 PM
hpidriver hpidriver is offline
 
Join Date: Jun 2009
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by CyBrSuFr View Post
Installed on VB 3.8.5 and only had one error that was quickly resolved with the following edit to Vbay.php on Line 130 right after the SELECT * FROM there is an extra ' before the " that needs to be removed for the link to the category to work correctly.

Code:
 $get_all_items = $db->query("SELECT * FROM `" . TABLE_PREFIX . "vbay_items` where completed='0' AND catid = '" . $vbulletin->GPC['showcat'] . "' " . $sort . " LIMIT " . ($limitlower - 1) . ", " . $vbulletin->GPC['max'] . "");
Code:
$get_all_items = $db->query("SELECT * FROM " . TABLE_PREFIX . "vbay_items` where completed='0' AND catid = '" . $vbulletin->GPC['showcat'] . "' " . $sort . " LIMIT " . ($limitlower - 1) . ", " . $vbulletin->GPC['max'] . "");
Thank you for that tip, I just installed on VB 3.8.6 and vbay is at least functional.
However I have run into another issue, when trying to sort auctions by time,price,or anything I get a database error
Code:
SELECT * FROM vbay_items` where completed='0' AND catid = '1' ORDER BY `completetime` DESC LIMIT 0, 10;
Is this being caused by another rogue ' mark?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01164 seconds
  • Memory Usage 1,763KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete