Thread: mYvBindex v3.1
View Single Post
  #1118  
Old 04-24-2003, 10:20 PM
Tigga's Avatar
Tigga Tigga is offline
 
Join Date: Dec 2001
Location: Atlanta
Posts: 1,061
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actually I think you may be able to make the news work without even editing the newthread.php file. If you would like to try this out, here is what you would do...
Open your myvbindex.php file and look for the news query:
PHP Code:
  $getnews $DB_site->query("SELECT thread.threadid,thread.title,replycount,postusername,postuserid,thread.dateline,views,thread.iconid,votenum,votetotal,postid,pagetext,allowsmilie,showsignature,signature".iif($shownewsavatar,",avatarpath,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline AS avatardateline ","")." ".iif($shownewsicon,',thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath','')."
                    FROM thread 
                    LEFT JOIN post ON (thread.threadid=post.threadid) 
                    LEFT JOIN user ON (user.userid=post.userid) 
                    "
.iif ($shownewsavatar,"LEFT JOIN avatar ON (avatar.avatarid=user.avatarid) 
                    LEFT JOIN customavatar ON (customavatar.userid=user.userid) "
,"").
                    "
.iif ($shownewsicon,'LEFT JOIN icon ON icon.iconid=thread.iconid','')."
                    WHERE forumid=
$newsforum AND isnews='Y' 
                    ORDER BY thread.threadid DESC 
$newsmax"); 
Replace that with:
PHP Code:
  $getnews $DB_site->query("SELECT thread.threadid,thread.title,replycount,postusername,postuserid,thread.dateline,views,thread.iconid,votenum,votetotal,MIN(postid),pagetext,allowsmilie,showsignature,signature ".iif($shownewsavatar,",avatarpath,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline AS avatardateline ","")." ".iif($shownewsicon,',thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath','')."
                    FROM thread 
                    LEFT JOIN post ON (thread.threadid=post.threadid) 
                    LEFT JOIN user ON (user.userid=post.userid) 
                    "
.iif ($shownewsavatar,"LEFT JOIN avatar ON (avatar.avatarid=user.avatarid) 
                    LEFT JOIN customavatar ON (customavatar.userid=user.userid) "
,"").
                    "
.iif ($shownewsicon,'LEFT JOIN icon ON icon.iconid=thread.iconid','')."
                    WHERE forumid=
$newsforum AND open<>10 
                    GROUP BY thread.threadid
                    ORDER BY thread.threadid DESC 
$newsmax"); 
There was a problem before with random posts sometimes being displayed on the homepage if the newthread.php file isn't modified, but I'm pretty sure if the query was done that way it should work. If not let me know and I'll see what you would need to change in your newthread.php file instead.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01048 seconds
  • Memory Usage 1,794KB
  • 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
  • (2)bbcode_php
  • (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