Checking number of posts from different website?

[!!!cyr0n_k0r]

Ok, heres what I want to do.
I mod or own, or help mod on many different boards. And I have my own personal start page that is stored locally on my HD.

Is there a way to integreate the portion of the welcome panel hack that says "there have been so and so number of posts since your last visit" into my personal start page?

So I can essentianly check all the boards at once for new content/save bandwith by not having to visit the entire board to see if there have been new posts.

[Xenon]

well you need

a) Acces to all DB's yourself and run the right queries
or
b) Install a small script on every of your Boards which can be included into your startpage...

[!!!cyr0n_k0r]

ok, option 2 sounds easier.

Does a script like this exist?

[Darth Cow]

Originally posted by !!!cyr0n_k0r
ok, option 2 sounds easier.

Does a script like this exist?

Not to my knowledge, but it will be definately included in vBulletin 3.0 .

[Xenon]

it would be just like this:

PHP Code:

<?
require('global.php');
$userid = xx;
$userinfo=$DB_site->query_first("SELECT lastvisit FROM user WHERE userid=$userid");
$newposts=$DB_site->query_first("SELECT COUNT(*) AS total FROM post WHERE dateline>$userinfo[lastvisit]");
$newthreads=$DB_site->query_first("SELECT COUNT(*) AS total FROM thread WHERE lastpost>$userinfo[lastvisit]");

echo "New Posts: ".$newposts[total]." in  ".$newthreads[total]." updated threads!<br>";
?>

just save this on every forum server and include it from within your startpagescript

be sure you enter the correct userid

[!!!cyr0n_k0r]

A little more indepth instructions would help xenon.!

[Xenon]

huh, more instructions?

well, save the code i gave you as for example new.php

then upload new.php into all root directories of your forums (be sure to use your userid )

after that, your startpage (which has to be on a server (or localhost if you have installed php)) would look like that for example:

Private Startpage of cyron...<br><br>.......

change it into:

Private Startpage of cyron...<br>New posts:<br>
On www.vbulletin.org: <?php include('http://www.vbulletin.org/new.php); ?>.......

then upload the file again (it must have a php extension

[!!!cyr0n_k0r]

ok, thanks. Do I have to have php installed on my local machine? If I do I can just upload the php file to a website that is close to me and that will work correct?

[Xenon]

i don't know if you have installed php on your local machine..

but if it ist, yes, you can do so easyily

[!!!cyr0n_k0r]

No, what I said was. DO I have to have php installed. As in, am I required to install it on my local machine?