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

Reply
 
Thread Tools Display Modes
  #1  
Old 05-06-2007, 07:43 AM
b3hr0uz b3hr0uz is offline
 
Join Date: Apr 2006
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default last post on forum homepage

Code:
<?phpinclude 'includes/config.php'; 
$forum_url = "/"; // Change this to reflect to your forum's URL.
mysql_connect($config['MasterServer']['servername'], $config['MasterServer']['username'], $config['MasterServer']['password']) OR die ("Cannot connect to your database"); 
mysql_select_db($config['Database']['dbname']) OR die("Cannot connect to your database"); 
echo "<marquee scrollamount='3' onmouseover=stop() onmouseout=start() scrolldelay='80' direction='up' style='color: #008000'><div align='center'><table border='0' cellspacing='2' cellpadding='2' dir='rtl' width='80%'>";
$thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter FROM thread WHERE visible=1 AND open=1 ORDER BY lastpost DESC LIMIT 13");
while($thread_get=mysql_fetch_array($thread_sql)){
$poster = $thread_get['lastposter'];
$tid = $thread_get['threadid'];
$getp=mysql_fetch_array(mysql_query("SELECT postid FROM post WHERE threadid=$tid ORDER BY postid DESC"));
$pid = $getp['postid'];
$title = substr($thread_get['title'],0,500);
echo "<meta ********************=Content-Type content=text/html; charset=utf-8></td><link rel=StyleSheet href='client************/style.css' type=text/css><td width='60%' align=center><a target='_top' href='showthread.php?p=$pid#post$pid'><b>
<span style='text-decoration: none'>$title</span></b></FONT></a></td><td width='25%' align=center><font color='#404040' face='Tahoma' style='font-size: 9pt'><span lang='fa'>توسط</span> $poster</FONT></td></tr>";
}
echo "</table></div></marquee>";
?>
hey guys that a code i wrote. i saved it as aa.php in my forum dir. but i dont know how to include it in my homepage so it can be seen on the top ( under my navbar links like members list ...)

Thanks in advance

no replies?? dannng
Reply With Quote
Reply


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 03:06 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.08235 seconds
  • Memory Usage 2,160KB
  • 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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)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
  • (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_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
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete