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!

[atrl]

Thanks Very Much!

[Neo]

thank you for another great hack

[|DarkManX|]

getting this error with 2.2

Database error in vBulletin 2.2.0:

Invalid SQL: SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '1004590373
mysql error: You have an error in your SQL syntax near ''1004590373' at line 1

mysql error number: 1064

Date: Thursday 01st of November 2001 12:10:23 AM
Script: http://www.partylounge.net/tof/tof/index.php?
Referer:



don't get what i did wrong....

[MrLister]

yikes sorry.... add a ' after $bbuserinfo[lastvisit] or look above. i fixed it.

[FWC]

Add a ' right before the last " in each query. You also need to add posts to the forumhome_welcometext.

[MrLister]

yup.. it's fully fixed now.. thx

Originally posted by FWC
Add a ' right before the last " in each query. You also need to add posts to the forumhome_welcometext.

[FWC]

Hey, I'm the first guy to click "Installed". Thanks!

[JJR512]

2nd!

[Admin]

Clicked it as well since I'm already using this here. Nice job.