| hpidriver |
08-03-2011 07:53 PM |
Quote:
Originally Posted by CyBrSuFr
(Post 2093725)
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? |
More Information