Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 02-14-2009, 05:27 PM
sparklywater sparklywater is offline
 
Join Date: Jun 2008
Posts: 248
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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&amp;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.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:14 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05891 seconds
  • Memory Usage 2,421KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (1)postbit_attachment
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_attachment
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete