PDA

View Full Version : Custom Question not sorted


lawsu
09-02-2008, 02:02 PM
Hi,

I have created a number of custom questions for a product category and was sorted in my preferred order.

However, it does not show to be sorted when user answer them.

(by the way, I am already a registered user. Do I post in this pre-sales thread?)

wterpilo
09-02-2008, 04:11 PM
Hi
please open /functions/api/class.auction_questions.inc.php and goto line #61. You should have there that sql statement
$sql = $ilance->db->query("
SELECT *
FROM " . DB_PREFIX . $table1 . "
WHERE cid = '" . intval($cid) . "'
AND visible = '1'
", 0, null, __FILE__, __LINE__);
Change it to
$sql = $ilance->db->query("
SELECT *
FROM " . DB_PREFIX . $table1 . "
WHERE cid = '" . intval($cid) . "'
AND visible = '1'
ORDER BY sort
", 0, null, __FILE__, __LINE__);
and it should show questions as you need. It has been fixed for 3.1.7 :)

Wojtek

Peter
09-02-2008, 04:42 PM
Lawsu - Your access was upgraded to the licensed forum areas.

Regards,
Peter