![]() |
oh boy, I figured it out. Had to go to the functions_showthread, define a global and put it in that postbit section. Can't believe I did it. Don't even kow php and mysql. The whole thing has been trial and error and help from people like you.
|
Quote:
thats me till i get it right. |
oops. This is returning only one item
$pollist = $DB_site->query("SELECT thread.threadid AS thread_id,thread.title AS thread_title,thread.pollid AS thread_pollid,poll.pollid AS poll_pollid, poll.active AS poll_active,poll.dateline AS poll_dateline,poll.public AS poll_public,user.userid,user.username FROM " . TABLE_PREFIX . "thread AS thread, " . TABLE_PREFIX . "poll AS poll, " . TABLE_PREFIX . "user AS user LEFT JOIN " . TABLE_PREFIX . "deletionlog AS dlog_t ON (dlog_t.primaryid = thread.threadid AND dlog_t.type = 'thread') LEFT JOIN " . TABLE_PREFIX . "deletionlog AS dlog_p ON (dlog_p.primaryid = poll.pollid AND dlog_p.type = 'poll') WHERE thread.pollid = poll.pollid AND poll.active = '1' AND dlog_t.primaryid IS NULL AND dlog_p.primaryid IS NULL ORDER BY poll.dateline ASC LIMIT 10"); |
any chance you got your problem figured out, Lionel? Im doing something similar (actually, just a test by returning all forum titles), but its only returning the first row.
|
Quote:
|
All times are GMT. The time now is 09:00 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|