View Single Post
  #7  
Old 12-16-2010, 04:50 AM
just.b.jealous just.b.jealous is offline
 
Join Date: Aug 2009
Location: Middle of no where.
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Awesome man, I can't appreciate it enough. I almost have it working- you might as well say it is. Last question, swear. Any way to pull the threads id into it as well? I'm trying to wrap the threads title with an href leading to the thread it's pulling, you'll see what I mean:

HTML Code:
$numposts='10';

$thrdqry = $vbulletin->db->query_read("
    SELECT thread.title, username, post.dateline, post.pagetext FROM " . TABLE_PREFIX . "thread AS thread
            LEFT JOIN " . TABLE_PREFIX . "post AS post ON thread.firstpostid = post.postid
            WHERE thread.forumid IN (61, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 130, 131, 132, 133, 134, 136, 137, 138, 139) AND thread.visible = '1'
    ORDER BY thread.dateline DESC
    LIMIT 0, $numposts ");

while ($thrds = $vbulletin->db->fetch_array($thrdqry))    
{
    $postdate = vbdate($vbulletin->options['dateformat'], $thrds['dateline'], true);
    $posttime = vbdate($vbulletin->options['timeformat'], $thrds['dateline']);
    $homepage_recentpost .=<<<EOD
<div class="post-1 post type-post hentry category-uncategorized" id="post-1">
	<h2 class="title"><a href="showthread.php?t=THREADID" target="_blank" alt="$thrds[title]" title="$thrds[title]">
		$thrds[title]
</a>
	</h2>
	<div class="postdate">
		<img src="images/date.png" /> $postdate <img src="images/user.png" /> $thrds[username] 
	</div>
	<div class="entry">
		<p>$thrds[pagetext]</p><br/><a href="showthread.php?t=THREADID" target="_blank" alt="$thrds[title]" title="$thrds[title]">
		Read more..
</a><br/>
	</div>
</div>
EOD;
            
}
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01200 seconds
  • Memory Usage 1,769KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_html
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete