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:
right under it add:

In the template forumhome_welcometext find:
right under it add:

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

Thanks Very Much!

thank you for another great hack

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....

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

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

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

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

2nd! :)

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

cool gonna install it :D

:) hehe..... idea successfully ripped

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 :D

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

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. :)

LOL, thanks Justin. :)

thanks for this hack....:)

:rolleyes:

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. :D)

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

Thanks for the hack

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 ???

Ok, I find the error:

The code to insert is:
Don't use the "lastpost" in the query, "dateline" works better for me :)...

Installed and working, thanks a bunch! :D

Just installed it. Thanks :)

thnx will be adding to my board :) very useful hack

whoa, works great man
JUST what the doctor ordered :D

I had to remove it.

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

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?

Basically yeah.

What does you code look like :( sorry I'm juts not having luck with this picking the right templates :confused: 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.

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) ;)

What is it you're trying to do, exactly?
I don't understand a word from your post 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.

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.

Lesane, there's no link on my numbers. :confused:

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

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 :)

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