A simple hack that YOU can help me with.

[Gutspiller]

I have looked all over and it can't be found, but it's pretty simple. All I want is a hack that will count the number of threads in the forums id's I specify for the last 24 hours. But, it has to be able to work on a non-vb page. I don't think this would be that hard, but it would really come in handy. I don't want the final number to be seperate numbers, I want it to add all the new threads in the certain forums together to make a final number. Again, 1 single number of all the new threads created in the forums that I specify and it will reset to zero when the 24 hours is up, and it needs to work on a non-vb page.

It would be nice if I could adjust the time of the 24 hour reset though, but is not nessasary for me to still use the hack.

Please can somebody help me with this?

Thanks for any help or redirection you can offer.

[N!ck]

something like:

PHP Code:

<?
require("/path/to/forums/global.php");
$last24 = time() - 86400;
$threads = $DB_site->fetch_array($DB_site->query("SELECT COUNT(*) as total FROM thread WHERE lastpost > $last24 AND (forumid = 'FORUMID1' OR forumid = 'FORUMID2')"));
echo $threads[total];
?>

that SHOULD work, but i'm no expert and i didn't test this code so...

[Chris M]

Listen...

If he says it works, trust him...

He found a way to stop admins editing my profile, so for that I thank him tremendously...

Satan

[Gutspiller]

OK, so if I want to add more forums to the hack so that adds them to the total would I just add

forumid = '12'

to the end of the line where you say:

forumid = 'FORUMID1' and forumid = 'FORUMID2'?

And how do I change the time for the hack?

BTW thanks for such a fast reply.

EDIT: I test it and it was off, it was only saying 32 and it should of either been over 100 or 0, depending on where the 24 hours mark lies.

I changed the "OR"s to "AND"s and it just stays 0 even when a new thread is created.

Can you please help?

[N!ck]

first, the OR needs to stay "OR".

second, you are correct in changing the "FORUMID1" and "FORUMID2" parts (and you can add more with the same syntax).

third (and i might have misunderstood), what this script does is counts how many threads were posted to in the past 24 hours in the forums you specify.

fourth, the 86400 part is the number of seconds in 24 hours. if you want to change the 24 hours, just do 3600 times the number of hours you desire and replace 86400 with the result.

if i misunderstood what you're looking for, let me know

[Gutspiller]

Nope, still isn't working.

I have all my forum set and it still says there have been 6 posts in the last 24 hours.

And when does the 24 hours start? If you are doing it in seconds, when does it start over? That's what I was asking. I want to change when it started, because for what I am using it for I don't want the 24 hour period to restart right when I am posting my stuff that I want it to track. Right now I need it to start and end at 4:00 AM MDT

I double checked that all the forums I want included in it for the hack to track are in the hack and there id's are correct and it all checks out, so it must be something with the hack.

Any ideas?

[mr e]

My forums are down so this I'm kind of guessing here, but would this work? If you want this on your main page, put this in you index.php, I don't THINK it matters where, but I could be wrong.

PHP Code:

$thisdate = date('Y-m-d');
$getthreadtotal = $DB_site->query_first("SELECT COUNT(*) as total FROM thread WHERE dateline = $thisdate AND forumid = 'FORUMID1' OR forumid = 'FORUMID2'");
$threadtotal = $getthreads[total];

eval("\$threadtotal = \"".gettemplate('forumhome')."\";"); 


Then put $threadtotal somewhere in your forumhome template.

[Gutspiller]

mr e I need this to work on a none vb page and I don't exactly know how to change that code so that it would work.

The date in that code looks like it's static. It looks like if I put in a date that it will always be that date, it wont change. So the first day I used it it would show the last 24 hours, but the next day it would show 48 and so on and so forth. I need something that will only show the latest posts since the last 24 hours and I need to be able to change when the 24 hour period restarts. I don't nessasarly want it to be the 12:00 of the server, or whatnot.

More help please.

[mr e]

It's not a static time because everytime you load the page it checkes the date('Y-m-d'); so today it would equal 2002-05-15 and tomorrow it would equal 2002-05-16. Got it? I'll try to see if I can figure out how to get this on a non-vB page.

[Gutspiller]

Originally posted by mr e
It's not a static time because everytime you load the page it checkes the date('Y-m-d'); so today it would equal 2002-05-15 and tomorrow it would equal 2002-05-16. Got it? I'll try to see if I can figure out how to get this on a non-vB page.

So what happens if the threads that I am trying to track, somebody comes to the page for the first time in the middle of the chunk of posts that I am trying to track? I don't want it to say 50 posts today and tomorrow it has the other 50, when it should really be reading 100.

How does it track it?