vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Help me finish these few lines of code (https://vborg.vbsupport.ru/showthread.php?t=47371)

Gutspiller 01-04-2003 08:51 PM
Help me finish these few lines of code
 
I have this code

PHP Code:

<?
$last24 = time() - 86400;
$threads = $DB_site->fetch_array($DB_site->query("SELECT COUNT(*) as total FROM thread WHERE lastpost > $last24 AND (forumid = '143' OR forumid = '162' OR forumid = '161' OR forumid = '163' OR forumid = '145' OR forumid = '153' OR forumid = '164' OR forumid = '155' OR forumid = '167' OR forumid = '158' OR forumid = '165' OR forumid = '166')"));
echo $threads[total];
?>
which outputs the number of threads in a few of my forums. It's used to show how much news is posted every 24 hours. Those forum ids are the ids for all my forums for news. But the output number is not only the number of threads, but REPLIES also. Since I only want it to track news and news is only in the first post of each thread, can somebody help me get it so that it doesn't count replies?

I'm also using close to the same code

PHP Code:
<?
$last24 = time() - 0;
$threads = $DB_site->fetch_array($DB_site->query("SELECT COUNT(*) as total FROM thread WHERE lastpost < $last24 AND (forumid = '143' OR forumid = '162' OR forumid = '161' OR forumid = '163' OR forumid = '145' OR forumid = '153' OR forumid = '164' OR forumid = '155' OR forumid = '167' OR forumid = '158' OR forumid = '165' OR forumid = '166' OR forumid = '127')"));
echo number_format($threads[total]);
?>
to track the total amount of news posts ever posted. On this one I don't know if it's tracking replies also or not, but if it is, I don't want it too.

Let me know if you need more info, if you care to see how I'm using it you can head to http://www.3dNewz.com and see it in the top right of the front page.

Thanks for any help you can provide.

Xenon 01-04-2003 09:31 PM
hmm, it doesn't look wrong, seems everything is ok, but you should make it better readable:
also the lastpost < time() - 0 is not needed...

PHP Code:
<?
$threads = $DB_site->fetch_array($DB_site->query("SELECT COUNT(*) as total FROM thread WHERE forumid IN (143,162,161,163,145,153,164,155,167,158,165,166,127)"));
echo number_format($threads[total]);
?>

and yes, it's just counting the thread ammount, not the replies,

Gutspiller 01-04-2003 10:10 PM
Quote:
Originally posted by Xenon
hmm, it doesn't look wrong, seems everything is ok, but you should make it better readable:
also the lastpost < time() - 0 is not needed...

PHP Code:
<?
$threads = $DB_site->fetch_array($DB_site->query("SELECT COUNT(*) as total FROM thread WHERE forumid IN (143,162,161,163,145,153,164,155,167,158,165,166,127)"));
echo number_format($threads[total]);
?>

and yes, it's just counting the thread ammount, not the replies,
Well I wasn't sure about the bottom code that I posted, but the first code that I posted, I know for a fact is counting the replies, because on days that I don't post news it will say 1 or a few posts and then I look at people have made replies to news posts. So I still need help with the top code on how to fix it. Thanks so far though. :)

Xenon 01-04-2003 10:17 PM
yes, the first one would update when a new post is made instead of this:
Code:
WHERE lastpost < $last24
use
Code:
WHERE dateline < $last24


All times are GMT. The time now is 07:27 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.02981 seconds
  • Memory Usage 1,722KB
  • 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
  • (2)bbcode_code_printable
  • (4)bbcode_php_printable
  • (1)bbcode_quote_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