A simple hack that YOU can help me with.

[Andy Z]

Every time the page loads it will execute that query, every day the date() part will change with the server's clock. So the next day for your server it would return different results. With nicksaunders code it would pull the threads from the last 24 hours from the time the person called the page from his/her browser. To get this on a non-vB page, it still has to be a php-processed page (usually only .php like extensions). On the non-vB page put:
<?php
require('/home/username/public_html/forums/global.php');
?>
and replace that path with the paths to your forums (on most linux hosts that should be pretty close).

[Gutspiller]

Originally posted by andypotter
Every time the page loads it will execute that query, every day the date() part will change with the server's clock. So the next day for your server it would return different results. With nicksaunders code it would pull the threads from the last 24 hours from the time the person called the page from his/her browser. To get this on a non-vB page, it still has to be a php-processed page (usually only .php like extensions). On the non-vB page put:
<?php
require('/home/username/public_html/forums/global.php');
?>
and replace that path with the paths to your forums (on most linux hosts that should be pretty close).

Like I said, I want to be able to adjust the time. I said that in my first post. I don't want it specific on page loads, server time, or users time. I want to set the when the 24 hour block restarts. THAT is what I want the code for. Can somebody please provide the code for that?

[N!ck]

the 24 hours is always 24 hours before you loaded the page. it never starts over.

once again, this is the number of THREADS affected, and the script doesn't lie . if you want to change it to show posts, i'll have to do a left join which is a pain in the butt (actually, i'm lazy and don't want to do it unnecessarily)

[Gutspiller]

Originally posted by nicksaunders
the 24 hours is always 24 hours before you loaded the page. it never starts over.

once again, this is the number of THREADS affected, and the script doesn't lie . if you want to change it to show posts, i'll have to do a left join which is a pain in the butt (actually, i'm lazy and don't want to do it unnecessarily)

I am a little confused as to what you mean. Also, it still doesn't show the posts in the right forum. I have included everything that you said and it still will show a number of posts that haven't been posted in the forums that I have specified to watch. I didn't think this hack would be this hard? :ermm:

I just want it to work. (and so far it hasn't worked once) :disappointed:

Can you fix it? I mean if you haven't even tested it, I don't see how you can be so sure you know exactly what it's doing.

[N!ck]

i don't think i'm advanced enough to do this then :P

firefly, assistance please. thanks

[Gutspiller]

Originally posted by nicksaunders
i don't think i'm advanced enough to do this then :P

firefly, assistance please. thanks

OK, thanks for all your help anyhow.