The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#3
|
|||
|
|||
![]()
I'm not sure what you mean. This is the query I am using to fetch the rows:
Code:
SELECT post.postid, post.pagetext as pagetext, post.userid, post.username, post.dateline AS date, thread.forumid, thread.title as thread_title, thread.threadid, forum.forumid, forum.title as forum_title, thread.replycount as replies, thread.views as views FROM " . TABLE_PREFIX . "thread AS thread INNER JOIN " . TABLE_PREFIX . "post AS post on (post.postid = thread.lastpostid) INNER JOIN " . TABLE_PREFIX . "forum AS forum on (thread.forumid = forum.forumid) WHERE post.visible = '1' AND thread.visible = '1' AND open = '1' ORDER BY date DESC LIMIT $sel_limitlowerminus1,$perpage And this is the code for constructing the rows: Code:
<tr> <td alt="Go to last post in thread '$WQfield[thread_title]'" title="Go to last post in thread '$WQfield[thread_title]'" style="cursor:pointer;" onclick="window.location.href='$vboptions[bburl]/showthread.php?$session[sessionurl]p=$WQfield[postid]'" class="alt1" WIDTH="42%" VALIGN="middle" align="left"><div style="font-size: 11px"><a href="$vboptions[bburl]/showthread.php?$session[sessionurl]p=$WQfield[postid]"><b>$WQfield[thread_title]</td><td align="center" class="alt1" WIDTH="23%" VALIGN="middle"><span style="font-size: 11px">$WQfield[date]</span></td> <td alt="View profile of $WQfield[username]" title="View profile of $WQfield[username]" style="cursor:pointer;" onclick="window.location.href='$vboptions[bburl]/member.php?$session[sessionurl]u=$WQfield[userid]'" align="center" class="alt1" WIDTH="19%" VALIGN="middle"><div style="font-size: 11px"><a href='$vboptions[bburl]/member.php?$session[sessionurl]u=$WQfield[userid]'><b>$WQfield[username]</b></a></div></td> <td align="center" class="alt1" WIDTH="8%" VALIGN="middle" align="center" style="font-size: 11px">$WQfield[views]</td> <td onclick="who($WQfield[threadid]); return false;" alt="View who has posted in thread '$WQfield[thread_title]'" title="View who has posted in thread '$WQfield[thread_title]'" align="center" class="alt1" WIDTH="8%" VALIGN="middle" align="center" style="font-size: 11px; cursor:pointer"><a alt="View who has posted in thread '$WQfield[thread_title]'" title="View who has posted in thread '$WQfield[thread_title]'" href="misc.php?do=whoposted&t=$WQfield[threadid]" onclick="who($WQfield[threadid]); return false;">$WQfield[replies]</a></td> </tr> Basically I want to be able to add something to a particular row of that table. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|