
11-07-2007, 11:56 PM
|
|
|
Join Date: Apr 2007
Posts: 390
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by goblues
This module doesn't differentiate between open and closed auctions. If you wish to show only current and active auctions find in your forumroot/modules/vba_vbay.php file:
Find;
Code:
SELECT id, name, price, completetime, bids
FROM " . TABLE_PREFIX . "vbay_items
ORDER BY id DESC LIMIT 5
");
and replace with:
Code:
SELECT id, name, price, completetime, bids, completed
FROM " . TABLE_PREFIX . "vbay_items WHERE completed = 0
ORDER BY id DESC LIMIT 5
");
|
This worked like a charm. Slick as you please
|