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!

[Admin]

Basically yeah.

[LuBi]

What does you code look like sorry I'm juts not having luck with this picking the right templates or anything plus I can't find the avatar code. Really I just want that on top of the forum below the normal stuff added to the table of the forum much like you have it.

[LuBi]

After playing with it a bit I now know I have no clue what I am doing, if you get a chance go to my page and look at what I've done anyhow. I need to know the code for the users avatar, I'll need to find that guest avatar hack and I need to connect the fourmhome with the actual table... problem is I have no clue. If oyu could maybe walk me through it.. or post yours or something, I dunno... any help would be great as usual firefly (this begger aint choosey)

[Admin]

What is it you're trying to do, exactly?
I don't understand a word from your post LuBi.

[LuBi]

I want to mkae a box like yours. Where the admin is, I need to understand what goes into it and the code behind it. If all that's not to much trouble.

In short, I need the code, and the templates to edit.

[Lesane]

Firefly, is it possible that you can give a link to the new threads.

like it says:
There here have been 10 threads....

and then a link on "10" and that link shows the new 10 threads.

Cool if thats possible.

[Admin]

Lesane, there's no link on my numbers.

LuBi, it invloves a lot of new code and templates, I can just "post it all".

[Lesane]

hehe, i know that there is no link on your numbers

but i wonder if there is an way to give a link to that new threads.

It says: There here have been 10 threads....

now is it possible to add a lil hack that gives the number 10 a link and that link shows the 10 new threads.

[over]

Originally posted by Lesane
hehe, i know that there is no link on your numbers

but i wonder if there is an way to give a link to that new threads.

It says: There here have been 10 threads....

now is it possible to add a lil hack that gives the number 10 a link and that link shows the 10 new threads.

vbb's own view new posts code you could edit slightly to do the job u want

[LuBi]

Ok then I have an idea, tell me which things you edit and why, tell me which things you create and why. Also I just need the code for the avatar, The code for the users current avatar. Much like the one in edit options.

Thanks