vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Help - Ekk... bad bad :) (https://vborg.vbsupport.ru/showthread.php?t=11077)

etones 03-11-2001 09:18 AM

Hi all, i use asimply script that grabs the 10 latest posts and puts them on the main page.

However i've just setup a moderator forum and dont want posts from here being displayed. What do I do/change?

The script im using at the moment is this:

<?php
// Set this to the max number of threads to display
$maxthreads = 10;

require("/home/etones/public_html/forums/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$query = "SELECT * FROM thread ORDER BY lastpost DESC LIMIT $maxthreads";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<tr><td width=25 align=right height=15><img border=0 src=\"http://www.e-tones.co.uk/images/main/bullet.gif\" width=17 height=9></td><td width=237 height=15><font color=#000080 size=1>
<A HREF=\"http://www.e-tones.co.uk/forums/showthread.php?threadid=$latest_array[threadid]\" target=_blanc>$latest_array[title]</A></font></td></tr>";
}

?>

Thanks everyone!!

03-11-2001 02:38 PM

Change this line:
Code:

$query = "SELECT * FROM thread ORDER BY lastpost DESC LIMIT $maxthreads";
To something like this:
Code:

$query = "SELECT * FROM thread where forumid='1' or forumid='2' or forumid='3' ORDER BY lastpost DESC LIMIT $maxthreads";
Add all the forumid's of those forums that you would like to be INcluded in the query. Don't add id's of private forums and such. With nearly 70 forums myself that line can become quite long ;)

03-11-2001 02:40 PM

Change as in bold below:
Code:

$query = "SELECT * FROM thread WHERE forumid != 'x' ORDER BY lastpost DESC LIMIT $maxthreads";
and set X to the forum number that you don't want included.

03-11-2001 02:56 PM

yup, thanks all, cheers!


All times are GMT. The time now is 08:49 AM.

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.00914 seconds
  • Memory Usage 1,714KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete