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!

[eva2000]

cool gonna install it

[MrLister]

hehe..... idea successfully ripped

Originally posted by FireFly
Clicked it as well since I'm already using this here. Nice job.

[MrLister]

tell me how it goes on a popular board.... that's 2 extra queries on the main page.. but the queries aren't big so shouldn't be a problem

Originally posted by eva2000
cool gonna install it

[eva2000]

Originally posted by MrLister
tell me how it goes on a popular board.... that's 2 extra queries on the main page.. but the queries aren't big so shouldn't be a problem

LOL i already added 16+ extra queries on teh front page from various hacks anyway before this

[FWC]

Originally posted by eva2000
LOL i already added 16+ extra queries on teh front page from various hacks anyway before this

Yeah, I have you page view counter, total thread views and a Firefly posts today query going in addition to this one.

[JJR512]

This hack as it is used on this board has a grammatical error. On the front page of vbulletin.org, it says "There has been xx threads..." It should be have, as described in the instructions above.

[Admin]

LOL, thanks Justin.

[|DarkManX|]

thanks for this hack....

[eva2000]

Originally posted by JJR512
This hack as it is used on this board has a grammatical error. On the front page of vbulletin.org, it says "There has been xx threads..." It should be have, as described in the instructions above.

[JJR512]

Are you rolling your eyes at the fact that this mistake was made, or that I pointed it out?

(If the latter...hey, I'm just trying to help make this site the best it can be, and poor grammar contributes greatly to an unprofessional image. )