Since Your Last Visit!

Somebody here request it so I made it quickly.... Basically this hack here tells your users how many new posts and threads there have been since hteir last visit on the main page.

An example is https://vborg.vbsupport.ru and right under your username.

INSTRUCTIONS:
Inside index.php (not admin) find:

PHP Code:

// if user is know, then welcome 


right under it add:

PHP Code:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]'");
$getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]'"); 


In the template forumhome_welcometext find:

PHP Code:

Welcome back, <b>$bbuserinfo[username]</b> 


right under it add:

PHP Code:

<br>There have been <b>$getnewthread[threads]</b> threads and <b>$getnewpost[posts]</b> posts since your last visit! 


That's it! If you installed the hack please click the install button!

[Ifrani]

Is it possible, that it only count posts ? The number of posts an threads is always the same... ?!?

[Lesane]

Thanks for the hack

[Ifrani]

I doublecheck all changes for this hack, but it still displays only posts and it is not counting the new threads (display the same number as posts)...
Is that only my problem ???

[Ifrani]

Ok, I find the error:

The code to insert is:

PHP Code:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE dateline > '$bbuserinfo[lastvisit]'");
$getnewpost=$DB_site->query_first("SELECT COUNT(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]'"); 


Don't use the "lastpost" in the query, "dateline" works better for me ...

[Alien]

Installed and working, thanks a bunch!

[Mr. X]

Just installed it. Thanks

[over]

thnx will be adding to my board very useful hack

[snyx]

whoa, works great man
JUST what the doctor ordered

[philliplewisuk]

I had to remove it.

I have 300 members on my forum at most times and adding it just made it error and error!

[LuBi]

FireFly what do I edit just to make it like yours.

>>Welcome back, user
Avatar Time Now
last vist
There have been XX posts
Click Here to view posts

Which do I edit? forumhome template itself?