![]() |
[release] Ammount of new posts since last visit :)
1 Attachment(s)
This should be a simple one,
This will show how many new posts there have been since a persons last visit, this now does show the ammount of new threads too, silly me, i forgot to update the varible when i copied the posts querry :D this will add 2 queries to your forumhome, however i must warn that with this even only running on the forumhome, these queries might still be rather large if you have a very active forum. at least from what i understand :) updated with brads suggestion id also take a look at this post as you may wish to include this into this template mod http://www.vbulletintemplates.com/mo...05&postcount=8 live @ http://www.digitalkore.net |
Excellent addon!
|
i belive assassingod made it hackable, i try to stay away from hacking files when i can help it :)
|
http://www.vbulletintemplates.com/mo...ead.php?t=1572
Asuming the db hasent changed more then I think it has from vB 2 this query should help out larger boards: Code:
ALTER TABLE post ADD INDEX('dateline') |
how so brad?
|
Quote:
|
so would the querys need to be changed at all?
|
1 Attachment(s)
Quote:
Ive attached a php script that will do it for you, just upload it to the admincp directory and it should work. Also you can cut down on alot of load by not running the querys for guests, to do so change the php block to this: PHP Code:
Im not trying to bash this modification, you just have to be real careful when releasing/installing something like this, because it dose open the door up to all sorts of server load problems if not added correctly.. |
thanks brad, ill update my txt and point users to your attachment :)
im more than aware of this :\ and i didnt think about disabling it for guests, sliped my mind which i should know better as i already turn alot of things off for guests. i do belive i did give somewhat of a warning however i updated the txt instuctions to check for guests as well and redid abit of the html to make it look abit nicer to users who are guests :) |
brad i noticed a small error in your coding when for !== would still show for guests while != will not run the querry for guests, ive updated my txt file :) anyone who installed this should update their phpinclude_start tempalte :D
|
All times are GMT. The time now is 01:37 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|