Ok i managed to get the options menu working now.
When i try and create something in the vbindex i get an sql error...
Invalid SQL:
## GET POLL ##
SELECT thread.pollid, thread.forumid, open, threadid, replycount, question, poll.dateline,
options, votes, active, numberoptions, timeout, multiple, voters,
pollvote.voteoption, pollvote.userid AS voteuserid
FROM vb3_test_thread AS thread
LEFT JOIN vb3_test_poll AS poll ON (thread.pollid = poll.pollid)
LEFT JOIN vb3_test_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN vb3_test_pollvote AS pollvote ON(thread.pollid = pollvote.pollid AND pollvote.userid = 1)
WHERE forumid NOT IN (0)
AND deletionlog.primaryid IS NULL
AND thread.pollid <> 0
AND thread.open <> 10
AND thread.visible = '1'
AND thread.forumid IN (TEST)
ORDER BY thread.threadid DESC
LIMIT 1
mysql error: Unknown column 'TEST' in 'where clause'
mysql error number: 1054
|