PDA

View Full Version : New Posts & Threads Since Last visit


Zachery
06-09-2005, 10:00 PM
Um. I think this one is fairly self explaintiory by now.

It gets a count of the newest posts and threads since their last visit.


Optionally you should add indexes on your post and thread tables for the dateline columns

ALTER TABLE `post` ADD INDEX ( `dateline` );
ALTER TABLE `thread` ADD INDEX ( `dateline` );

Chris M
06-10-2005, 12:36 AM
Installed and working :)

Satan

Link14716
06-10-2005, 12:41 AM
Installed and working :)

Satan
Are you installing everything, hellsatan? :p

Chris M
06-10-2005, 12:43 AM
Are you installing everything, hellsatan? :p
Of course ;)

Can't expect to understand the plugin system unless you install and test everything now can ya ;)

Satan

Brent H
06-10-2005, 01:09 AM
Installed and working :D

ogden2k
06-10-2005, 06:05 PM
Just a question, does this work with any type of Read system option? Or just cookie based?

jpt62089
06-10-2005, 06:20 PM
*Installed :)

Gary King
06-10-2005, 07:04 PM
Installed, but I don't think that is a good location for the text. It should be in the 'Hello, $username' box. IMO.

Logikos
06-10-2005, 08:10 PM
Is the same thing as Gary Kings hack?

Reverend
06-10-2005, 08:29 PM
Installed plugin but nothing is displayed for me.

ogden2k
06-10-2005, 08:30 PM
Ah, I see how this works. It goes by cookie based mark read system. Not bad, but I'd like to see it work with the other read systems too.

Link14716
06-10-2005, 08:37 PM
Ah, I see how this works. It goes by cookie based mark read system. Not bad, but I'd like to see it work with the other read systems too.
It shows how many have been made since last visit: the name of the hack itself shows that it doesn't matter whether it is read or not.

ogden2k
06-10-2005, 08:55 PM
Right, but if you're using the new mark read system and don't view the threads from your last visit, those posts should still count as new.

Reverend
06-10-2005, 08:56 PM
Installed plugin but nothing is displayed for me.My mistake,i forgot to add the navbar edit :o

BTW, i removed the separate (get new posts) link as there is already a link under the posts and threads counts,and i also placed it under the pm stats (same position as Gary's 3.0 hack). Just my own preference.

Thanks for the hack though Zach.

ogden2k
06-10-2005, 09:06 PM
Any way to get this to work wherever you are in the forum? I have this beside new posts (just new posts, not threads, so it shows a number and no text).

Reverend
06-10-2005, 09:16 PM
Any way to get this to work wherever you are in the forum? I have this beside new posts (just new posts, not threads, so it shows a number and no text).Just thinking the same thing ogden. Would be useful to have it on more than just the forumhome.

zetetic
06-10-2005, 10:51 PM
Just thinking the same thing ogden. Would be useful to have it on more than just the forumhome.
Move the plugin to global_start and remove this from the plug-in code:
AND THIS_SCRIPT == 'index'
Then it will work on every page.

Reverend
06-11-2005, 06:53 PM
Move the plugin to global_start and remove this from the plug-in code:
AND THIS_SCRIPT == 'index'
Then it will work on every page.Works a treat. Thanks.

zetetic
06-11-2005, 08:01 PM
Works a treat. Thanks.
Glad to help. :)

Zachery
06-12-2005, 04:14 AM
Glad to help. :)
Unless someone else already has done it I will see about updating and adding a number of unread posts to the display :)

burnist
06-12-2005, 08:48 AM
Installed, seems to be working fine ;)

* burnist clicks install

ogden2k
06-12-2005, 08:39 PM
Since putting this in global start, if there are no new threads, instead of saying 0 it shows nothing, is this normal?

Reverend
06-12-2005, 09:14 PM
Since putting this in global start, if there are no new threads, instead of saying 0 it shows nothing, is this normal?Mine is ok and shows 0.

However one strange thing did happen earlier,it showed -1 new threads.
No threads were deleted,so don't know why it was a minus count.:confused:

Cheertobi
06-13-2005, 01:27 PM
Hi,

does it shows only the number of new posts in forums and threads the user has access to or does it show the number of ALL news posts posted in ALL forums since the last visit?!

I do not want my users to ask me, why they only can see 2 new postings, but the mod shows them that there are 10 new postings ;)

Regrads,

Tobi

ogden2k
06-13-2005, 02:32 PM
Mine is ok and shows 0.

However one strange thing did happen earlier,it showed -1 new threads.
No threads were deleted,so don't know why it was a minus count.:confused:
Please show me your XML file to compare to mine, thanks!

Reverend
06-13-2005, 07:57 PM
Please show me your XML file to compare to mine, thanks!Is it ok to post the code here ?

Reverend
06-13-2005, 08:31 PM
Here's a screenie to show the " -1 "

Zachery
06-13-2005, 11:14 PM
Here's a screenie to show the " -1 "
Can't account for that, I've not had that problem on my boards yet....

Reverend
06-14-2005, 05:58 PM
Can't account for that, I've not had that problem on my boards yet....It just showed " -4 " :surprised:

Seems as though the thread total decreases each time i view a thread and then go back to it in the same session.

I think this only started when i moved the plugin to global_start and removed some of the code as suggested earlier.

Zachery
06-14-2005, 07:06 PM
It just showed " -4 " :surprised:

Seems as though the thread total decreases each time i view a thread and then go back to it in the same session.

I think this only started when i moved the plugin to global_start and removed some of the code as suggested earlier.
Then I'd suggest using my original code and not running that somewhat intensive query on every page view.

Reverend
06-14-2005, 07:23 PM
Then I'd suggest using my original code and not running that somewhat intensive query on every page view.Yep,fair point Zach,and i have now moved it back to forumhome_start. ;)

ogden2k
06-17-2005, 03:45 PM
Sigh, let's hope vB devs come out with a workable solution.

Zachery
06-17-2005, 09:30 PM
Sigh, let's hope vB devs come out with a workable solution.
Why would the vB devs come out with somthing? Its always been rejected due to possible server load...

ogden2k
06-20-2005, 08:34 PM
True, but it could be an option to turn on / off. On 3.0.x I have had this working in the navbar on every page an have not had any performance issues with ~20 members online.

------
edit:
After playing with this a little more, it works great when you are using the cookie mark read system, but if you are using the Database (automatic forum marking) system then that's where the problem comes in.

Lets say user 1 posts a new thread, user 2 logs in and doesn't read it, the new posts option shows as new like it should, user 2 logs out, logs in 2 days later (
Database Read Marking Limit is set to 1 day) and the new posts still reads as one, but when user 2 clicks on New Posts, nothing shows up- But, if you switch back to cookie base mark read system, the thread will show up.

Is there a fix / work around for this?

Zachery
06-20-2005, 09:30 PM
True, but it could be an option to turn on / off. On 3.0.x I have had this working in the navbar on every page an have not had any performance issues with ~20 members online.

------
edit:
After playing with this a little more, it works great when you are using the cookie mark read system, but if you are using the Database (automatic forum marking) system then that's where the problem comes in.

Lets say user 1 posts a new thread, user 2 logs in and doesn't read it, the new posts option shows as new like it should, user 2 logs out, logs in 2 days later (
Database Read Marking Limit is set to 1 day) and the new posts still reads as one, but when user 2 clicks on New Posts, nothing shows up- But, if you switch back to cookie base mark read system, the thread will show up.

Is there a fix / work around for this?
You can add &oldmethod=1 and have it use the old getnew function.

ogden2k
06-20-2005, 10:26 PM
I just tried that under the Database (automatic forum marking) system, and the forum with the new thread does show as "new" but when I click on New Posts, the thread does not show, since I logged out and logged in w/o reading that thread.

<a href="search.php?$session[sessionurl]do=getnew&amp;oldmethod=1" accesskey="2">

southernlady
06-23-2005, 11:53 AM
Has this been updated to beta 2 yet? Liz

Chris M
06-23-2005, 12:00 PM
It works with Beta 2 :)

Satan

southernlady
06-23-2005, 12:10 PM
Thanks, :) Liz

southernlady
06-23-2005, 12:16 PM
There was something I needed to do in the nav bar specifically for beta 2 that screwed up with this on the thread tools. Add the pagenav popup stuff for it in (look for the <!-- PAGENAV POPUP --> comment) That's what I was told to do.

Can y'all help? Liz

ogden2k
06-27-2005, 10:49 AM
I just tried that under the Database (automatic forum marking) system, and the forum with the new thread does show as "new" but when I click on New Posts, the thread does not show, since I logged out and logged in w/o reading that thread.

<a href="search.php?$session[sessionurl]do=getnew&amp;oldmethod=1" accesskey="2">
Any ideas?

southernlady
07-14-2005, 11:14 AM
I'm getting this error now: Parse error: parse error, unexpected '=' in /home/hsphere/local/home/southern/mysouthernlady.com/forum/includes/functions.php(2196) : eval()'d code on line 1
Running beta 4...has this been updated or should I take it off til it has? Liz

Zachery
07-14-2005, 04:04 PM
I'm getting this error now: Parse error: parse error, unexpected '=' in /home/hsphere/local/home/southern/mysouthernlady.com/forum/includes/functions.php(2196) : eval()'d code on line 1
Running beta 4...has this been updated or should I take it off til it has? Liz
I don't see why it would stop working, but I will take a look at this today liz.

southernlady
07-14-2005, 06:18 PM
Thanks, Zachery, all I know is that after taking it out, the parse error went away. Liz

tanyeri24
07-15-2005, 01:34 AM
how handle with the file threadsnpostscount.xml

where upload?

Zachery
07-15-2005, 05:58 AM
Thanks, Zachery, all I know is that after taking it out, the parse error went away. Liz

Hmm, Liz delete it and re-add it, its not causing any problems for me.

southernlady
07-15-2005, 10:33 AM
Zachery, I'll try that. Thanks. Liz

southernlady
07-15-2005, 10:55 AM
Zachery, it still does it on my LIVE board but I took that and put it on my test board and it doesn't do it...so it's conflicting with another plugin, I believe. Is there a way you can help me nail it down? Liz

southernlady
07-15-2005, 11:09 AM
Never mind, Zachery, I found it...it was one having to do with the vbadvanced 3.5 beta error reporting. It conflicted with yours. Liz

Zachery
07-15-2005, 11:56 AM
Liz I uploaded a zip with a modified plugin, delete the old one and try that and see what happens.

southernlady
07-15-2005, 12:06 PM
Zachery, I had taken the portal down for the time being, It and I were having issues and I forget to delete that plugin. So deleting it, and leaving yorus was not a problem.

Me and that danged portal have not gotten along yet. This time it was a header issue. Liz

Zachery
07-15-2005, 12:13 PM
Zachery, I had taken the portal down for the time being, It and I were having issues and I forget to delete that plugin. So deleting it, and leaving yorus was not a problem.

Me and that danged portal have not gotten along yet. This time it was a header issue. Liz

I am running a pre-release of the vBa CMPS 2.0 for beta 3 and I wasn't having any issues.. odd...

southernlady
07-15-2005, 12:33 PM
Zachery, I'm running beta 4 now. not beta 3...that may be the problem. Liz

Zachery
07-15-2005, 12:54 PM
Zachery, I'm running beta 4 now. not beta 3...that may be the problem. Liz

So even with my new file you get an issue ?

southernlady
07-15-2005, 01:05 PM
Yeah, that fixed it...but then again, I'm not running the portal right now. I am on beta 4.

As far as the portal issue goes, I couldn't get my header files to show up regardless of what I did and it was in all the proper places. But this isn't the place to discuss that altho I have yet to find the right place TO discuss that issue since there isn't technically a support board for the beta portal yet. Liz

Zachery
07-15-2005, 03:35 PM
Liz you should be able to get support on vBA.com :)

Ian Emu-UK
07-16-2005, 10:25 PM
It would be great if this used the database marking system to only count the unread posts.

I had a quick play copying some code from search.php but I had no joy with it what so ever, is it possible to find and count the unread post?

peterska2
07-22-2005, 06:34 PM
It's saying I have 'Array new posts and 4 new threads'

Any ideas?

Deimos
08-24-2005, 04:46 PM
Installed this on RC2 and it seems to work ok

Is there a way to exclude certain forums from being counted in the new posts area?

Nullifi3d
09-05-2005, 12:55 AM
Is it possible to calculate the count of all new threads/posts since last visit into one number?

thetoolman
09-12-2005, 08:20 PM
Hi
I have installed this and it works fine in the navbar template, but when i place the code in the footer where my right column hack is, it doesnt display the post number. Any ideas?

Zachery
09-12-2005, 08:55 PM
Hi
I have installed this and it works fine in the navbar template, but when i place the code in the footer where my right column hack is, it doesnt display the post number. Any ideas?

Because it isn't ment to go in the footer template.

thetoolman
09-12-2005, 08:57 PM
ok, but how can i make it work there?

thetoolman
09-14-2005, 07:28 PM
any ideas how i can make them appear in the footer?

southernlady
09-29-2005, 02:09 PM
Zachery, installed Gold last night and this plugin works just fine.

Btw, I am still running a html front page...as soon as vbadvanced goes gold, I'll try it again. Liz

Sooner95
09-29-2005, 03:08 PM
Can 2nd that as well, thx!

Roody
10-02-2005, 04:03 PM
Any way to get this to work wherever you are in the forum? I have this beside new posts (just new posts, not threads, so it shows a number and no text).

Any ideas on how to make this work so it shows up on any page within a forum? Right now it only shows up on the main Forumhome page.

Nullifi3d
10-02-2005, 04:54 PM
Any ideas on how to make this work so it shows up on any page within a forum? Right now it only shows up on the main Forumhome page.Moving the hook location from forumhome_start to global_start should do the trick.

Zachery
10-02-2005, 07:56 PM
I cannot stress this enough

DO NOT HAVE THIS RUN ON EVERY PAGE, ITS NOT A GOOD IDEA

Nullifi3d
10-02-2005, 09:22 PM
Why? Does it eat too many queries or something?

Zachery
10-02-2005, 09:25 PM
Why? Does it eat too many queries or something?

Those queries, esp if you don't run the indexes, cause large if not full table scans...

So its going to read the entire thread and post tables... before it finishes.

Nullifi3d
10-02-2005, 09:43 PM
nice, I'd love to have some of the largest tables in the database fully scanned on every page! lol

JulianD
10-02-2005, 10:00 PM
Installed =) Thanks!

calldaffer
10-03-2005, 02:04 PM
Those queries, esp if you don't run the indexes, cause large if not full table scans...

So its going to read the entire thread and post tables... before it finishes.

Alright so I've installed it and I've got it set it to show on all pages. Gimme worst case scenerio as to what might happen by doing this? Would it just be longer page loads?

Nullifi3d
10-03-2005, 04:44 PM
As your board gets bigger (more posts/threads) page load will increase. Once you board reaches a few hundred thousand posts/threads or even worse in the millions I woud fear being a member of your site.

calldaffer
10-03-2005, 04:57 PM
Currently my board has: Threads: 17,869, Posts: 182,735 and I've noticed no drag on performance...

Zachery, please tell us why you recomend against it and the longterm effects of not doing as you suggested.

Paul M
10-03-2005, 10:53 PM
If you index dateline in your post & thread tables this hack will have a negligable effect, even if run on every page, that's what indexes are for. ;)

Roody
10-04-2005, 12:59 AM
As your board gets bigger (more posts/threads) page load will increase. Once you board reaches a few hundred thousand posts/threads or even worse in the millions I woud fear being a member of your site.

So just putting it on the forumhome_start will prevent this issue from happening?

Nullifi3d
10-04-2005, 01:06 AM
Well it's defaulted to that hook when you install the plugin. Thus, forumhome is the only page that runs the php code to get the post count. As Paul and Zach stated, if you added the indexes it will help alot. I wouldn't recommend running it on every page if you have millions of posts or don't use indexes.

Please keep in mind, I'm not a php/mysql guru, however I do know a lil bit.

sim tech
10-04-2005, 05:42 PM
Is it normal to not update very often?

My vBulletin shows that no new message have been posted if you go by the generic image which is on the left side of the forum, but the mod still says "There has been 3 new posts and 0 new threads since your last visit."

Even when I refresh the page it did not change. It does update as far as increasing... I added a test post and it now says there are 4 new posts but the default vbulletin software shows that I have already viewed them.

The only way that I can get the counter to reset is to actually log out of the message board and then back in.

Nullifi3d
10-04-2005, 05:48 PM
Well it counts the posts since your last visit, not the posts that you haven't viewed since your last visit.

predatorkill
10-10-2005, 10:43 AM
My mistake,i forgot to add the navbar edit :o

BTW, i removed the separate (get new posts) link as there is already a link under the posts and threads counts,and i also placed it under the pm stats (same position as Gary's 3.0 hack). Just my own preference.

Thanks for the hack though Zach.


That way is better and more noticeable by the user!!!

i didnt make alter to the sql tables.I must do that?the hack works ok tho...

Nice hack!

Thanks a lot!

southernlady
10-10-2005, 11:42 AM
I slipped it down a bit to after this:
<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl_q]">$vbphrase[private_messages_nav]</phrase></if>

That puts it in the Welcome section that is part of the user cp and under the PM messages. Liz

Quillz
10-10-2005, 04:25 PM
I'd like to install this plug-in, but is running that SQL query required? I know how to access phpMyAdmin, but I don't know where to run the query. I'd like to just not do it if at all possible.

Nullifi3d
10-10-2005, 06:22 PM
If you don't run the query then you'll be scanning your entire post and thread tables each time you featch the data (load the page that shows the totals). I wouldn't reccomend not running the sql query if you have more then a few thousand threads and/or posts.

Quillz
10-10-2005, 07:32 PM
If you don't run the query then you'll be scanning your entire post and thread tables each time you featch the data (load the page that shows the totals). I wouldn't reccomend not running the sql query if you have more then a few thousand threads and/or posts.

I installed this on my test board with 1 member and 1 post. But, just for reference, where exactly do I run this query? I know how to run it, and I know how to access phpMyAdmin. Just don't know where it goes.

Nullifi3d
10-10-2005, 07:42 PM
Click the SQL link in phpmyadmin, or you can run sql queries from Maintenance >> Execute SQL Query in your forum's AdminCP.

LeeWicKeD
10-14-2005, 09:29 PM
great mod,works fine, even at vb3.5gold

vBarab
10-15-2005, 03:27 PM
find

$newthreads = number_format($getnewthreads['count']);


afer that

// Users
$getnewUsers = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE 1 AND joindate >= '{$vbulletin->userinfo['lastvisit']}'");
$newUsers = number_format($getnewUsers['count']);

Xtrm2Matt
10-27-2005, 11:43 AM
~~~ removed ~~~

Just fixed it. Forgot to uninstall the other "New posts" hack before installing this one :)

Thanks anyways :)

Matt

BANDiT600
10-27-2005, 12:54 PM
Very very nice!!!
/me installed!

Reverend
10-29-2005, 06:31 PM
A couple of our members are reporting a small glitch with the new post count.

Sometimes when they go to the main index page it says "there has been 1 new posts and 0 new threads since your last visit.",

but when they click on the "New Posts" link, it says:

"Sorry, there are no new threads to view. You may search for threads updated during the previous 24 hours, here."

Any ideas ???

Zachery
10-29-2005, 08:24 PM
A couple of our members are reporting a small glitch with the new post count.

Sometimes when they go to the main index page it says "there has been 1 new posts and 0 new threads since your last visit.",

but when they click on the "New Posts" link, it says:

"Sorry, there are no new threads to view. You may search for threads updated during the previous 24 hours, here."

Any ideas ???

They already read it :p the mark read system can confuse members.

Reverend
10-29-2005, 08:43 PM
They already read it :p the mark read system can confuse members.err no if it was that simple i would have told them that. :rolleyes:

It happens when they have already marked the previous posts as read.So in this case,no they haven't already read it.

apdcanari
10-29-2005, 11:37 PM
Good hack :nervous:

ggiersdorf
10-30-2005, 04:25 PM
could someone please explain this

I have noticed when I go to my board it says there are 5 new post since last visit etc. No problem when I go to these threads and read them, and go back to the main page I would expect them to say there are 0 new message (posts) not emails that are unread. I have to phyiscally mark the forums read
is there a way to mark a thread read once I read it automatically?

I want it to say there are X unread posts now.

Is it possible to also set this for subscribed threads so it dosent say there are 4000 posts, but there are 12 posts in your subscribed threads!?

Paul M
10-30-2005, 05:53 PM
could someone please explain thisUm, you just had it explaiined to you here.

https://vborg.vbsupport.ru/showthread.php?t=99690

ggiersdorf
10-30-2005, 05:57 PM
Paul yes, but I want to change it to tell me # of unread posts. and I dont know how

Paul M
10-30-2005, 06:42 PM
You can't, without re-writing it.

wii
11-12-2005, 08:28 PM
Will this hack work for Version 3.5.1 ?

Reverend
11-12-2005, 10:03 PM
Will this hack work for Version 3.5.1 ? I'm using 3.5.1 and it works fine.

wii
11-14-2005, 10:15 AM
Do you have a test login so I can see it in action?

Thanks

By the way, how do you get this on the non-forum page?

Members: 13059
Forum Posts: 78791

HMBeaty
11-20-2005, 01:06 AM
How do I get this to show on the navbar of EVERY page? Thanks

HMBeaty
11-23-2005, 12:13 AM
Anyone?

Zachery
11-23-2005, 04:00 AM
How do I get this to show on the navbar of EVERY page? Thanks

Thats alot of extra overhead... are you sure you want to be running large querys on EVERY page displayed on your forum?

Gio Takahashi
12-02-2005, 03:38 PM
There has been Array new posts and 0 new threads since your last visit.

Any explanations why, and how exactly do I fix this?

Gio Takahashi
12-02-2005, 07:04 PM
hmm. Got it fixed.

dark dragun
12-04-2005, 08:42 AM
I change up the navbar code. it looked to cluttered, this is simpler.

<if condition="$vbulletin->userinfo['userid'] != '0' AND THIS_SCRIPT == 'index'"><br /><span class="smallfont"><a href="$vboptions[bburl]/search.php?do=getnew">New posts</a>:$newposts <a href="$vboptions[bburl]/search.php?do=getnew">New threads</a>:$newthreads </span></if>

Gio Takahashi
12-11-2005, 10:19 PM
Hmmm. Curious.

I am wondering if it is possible to add this in the Who's Online page, so that people could see whether there is new post or new threads while idling in the who's online page.

xeyr
12-13-2005, 02:01 AM
Installed, thanks!

PennylessZ28
12-22-2005, 01:04 AM
excellent

Dantenator
12-29-2005, 08:22 PM
I decided to go with having it displayed on every page on my site thinking overhead is not that great a problem because it's a small site. However, I'm having a little trouble with it where the new posts count shows nothing on any search page and also my CMPS homepage. I mean it just doesn't show anything at all, no zero, no nothing. I thought it might be related to the global_start hook. Would I need to change that to something else?

Codeman05
01-06-2006, 03:57 PM
I am also unable to get this hack to work on the CMPS homepage, any clues on what to do?

Snatch
01-06-2006, 05:37 PM
<a href="$vboptions[bburl]/search.php?do=getnew">New threads</a>:$newthreads </span></if>


This is the same String linke the new post Link. How can I search only new Threads by klick on new Threads ?

Greetz
Snatch

NexDog
01-11-2006, 12:16 PM
Will this work outside the navbar? We don't use it but I'd like these stats to show on the left column we have that shows a user his stats when he logs in....I installed it but the links with the stats don't appear. The $newposts and $newthreads variables don't appear to work...

Snatch
01-16-2006, 11:10 AM
New Turn,

how i can search only vor new threads since last visit ?

Zachery
01-16-2006, 02:37 PM
search.php?do=getnew&oldmethod=1

Snake
01-24-2006, 08:47 PM
Screenshots?

Guest210212002
01-25-2006, 03:02 PM
This working on 3.5.3?

Zachery
01-25-2006, 06:25 PM
This working on 3.5.3?

Yes.

Guest210212002
01-25-2006, 07:48 PM
* Guest210212002 clicks install

Thanks as always bud. :)

Devil006
02-17-2006, 11:57 AM
Good Job
Thx

Devil006 Clicks Install

Gemilang
03-14-2006, 04:15 PM
I'm getting this error when running the query:
#1146 - Table 'houseboa_vb1.post' doesn't exist
I looked at my tables, and there is a 'post' table.

* Gemilang is confused

Zachery
03-20-2006, 09:54 PM
I highly advise agsint having it show on all pages.

s?dpol
05-11-2006, 07:24 PM
Hi,

I just installed this nice plugin. In order to enable the use of the phrase system I modifed it a bit.

If somebody would like to do so as well :

upload the xml file
open the template navbar
find: <strong>$vboptions[bbtitle]</strong>
add after:
<if condition="$vbulletin->userinfo['userid'] != '0' AND THIS_SCRIPT == 'index'"><br /><span class="smallfont"><a href="search.php?do=getnew"><phrase 1="$newposts" 2="$newthreads">$vbphrase[navbar_sincelastvisit]</phrase></a></span></if>
add new Phrase
Variablenname: navbar_sincelastvisit
Text: {1} neue Themen und {2} neue Beitr?ge seit Ihrem letzten Besuch.
Deutsch: {1} neue Themen und {2} neue Beitr?ge seit Ihrem letzten Besuch.
English: {1} new Threads and {2} new Posts since your last visit.
Execute the following queries in order to add a index on the used table colums:
ALTER TABLE `post` ADD INDEX ( `dateline` );
ALTER TABLE `thread` ADD INDEX ( `dateline` );


[EDIT]
20060618: removed "$vboptions[bburl]/" in the template code - as https doesn't work

Digital2
05-11-2006, 09:52 PM
Why am I only getting this text with no numbers plugged into it?

There has been new posts and new threads since your last visit.
( Get New Posts )

Yes, the database fields being queried are the correct ones and are correctly defined in the plugin.

Also, the following query was made succesfully:

ALTER TABLE `vbfpost` ADD INDEX ( `dateline` );
ALTER TABLE `vbfthread` ADD INDEX ( `dateline` );

GrendelKhan{TSU
06-12-2006, 11:40 PM
bookmarked. :)

Reverend
06-14-2006, 10:33 PM
Doesn't appear to be working on my 3.6.0 B2. Its showing the wrong totals. Posts 4 Threads 210 since last visit. :confused:

Can anyone confirm this still works with 3.6.0 B2.

Zachery
06-15-2006, 03:18 AM
I can't see why it wouldn't work.

Reverend
06-15-2006, 09:41 AM
I can't see why it wouldn't work.Thats what i initially thought, but obviously something is screwed on mine. I've reinstalled the plugin and ran the db queries still same issue with the totals.

Reverend
06-15-2006, 09:53 AM
Update: tried it this morning and it is now working correctly. :confused:

Zachery
06-15-2006, 05:59 PM
Weird.

Reverend
06-15-2006, 06:02 PM
Weird.Yep, can only think it may have been a dateline cache issue after i upgraded to 3.6 :confused:

Zachery
06-15-2006, 06:04 PM
Maybe.

MuhammadC
07-06-2006, 06:41 PM
Good, for smaller forums. My page generation times went from 0.15 seconds to 2.5 with this plugin installed. Neat, but too intensive for my forum. :cool:

Reverend
07-06-2006, 08:25 PM
My page generation times went from 0.15 seconds to 2.5 with this plugin installed. Yeah of course they did. :rolleyes:

Whats that smell?

Zachery
07-06-2006, 08:47 PM
Good, for smaller forums. My page generation times went from 0.15 seconds to 2.5 with this plugin installed. Neat, but too intensive for my forum. :cool:
pages? maybe you shouldn't have removed the code to only have it run on the forumhome.

Smoothie
07-23-2006, 08:13 PM
Hey guys, 2 quick questions. How many extra queries does this add and does this only display on forum home?

Zachery
07-24-2006, 12:42 PM
It adds two queries only to the forumhome.

WeArab
08-07-2006, 08:47 AM
Hello,

Great add-on, thank you!

When VB 3.6.0 would be supported?

Chris Blount
08-07-2006, 11:58 AM
This already works in VB 3.6.

Zachery
08-08-2006, 09:41 PM
It is already working for 3.6.

Conspiracy
08-09-2006, 10:10 AM
I ran the query and I got this error

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
ALTER TABLE `thread` ADD INDEX ( `dateline` )' at line 1

why?
I've installed it on another forum and it was fine, I'm not good with MySQL so I wouldn't know where to look for the right syntax, could someone help ?

Zachery
10-06-2006, 03:29 AM
uber late response but what version of mysql?

ChopBam
11-13-2006, 03:10 AM
I believe I found a problem with this one.
I just noticed that the number of new posts includes posts you don't have the permission to read, and I'm sure this applies to threads too.

Zachery
11-13-2006, 03:47 PM
Yea, 9/10 times it shouldn't be a big issue. Adding permissions to the query will only make things more comlicated.

Zachery
03-06-2007, 05:44 PM
Anyone using this with MySQL5?

Smoothie
03-06-2007, 05:57 PM
any chance of fixing the "you don't have the permission to read"?

Zachery
03-06-2007, 06:02 PM
any chance of fixing the "you don't have the permission to read"?
Hmmm?

Smoothie
03-06-2007, 06:06 PM
I believe I found a problem with this one.
I just noticed that the number of new posts includes posts you don't have the permission to read, and I'm sure this applies to threads too.

Yea, 9/10 times it shouldn't be a big issue. Adding permissions to the query will only make things more comlicated.

That :)

Zachery
03-06-2007, 06:10 PM
Like i said, on a normal forum with decent activity it shouldn't be an issue. I'd have to add permissions checks and I'd rather not do that, it makes things more complicated.

Smoothie
03-06-2007, 08:16 PM
I haven't installed it yet because of this ever-so-slight problem.

If I do install, is it still necessary to run those 2 queries?

Optionally you should add indexes on your post and thread tables for the dateline columns

Zachery
03-07-2007, 07:09 AM
Really at best its a minor annoyance TBH. Its not nessary but recomended to help speed the searches up.

Smoothie
03-07-2007, 08:40 AM
Thanks.

Sir_Yaro
04-07-2007, 03:35 PM
Works on 3.6.5

WebConnection
04-12-2007, 05:34 AM
Hi,

Why is it that the link of the new post and new thread are the same? Is there a way that the link of the new thread will just display the new threads?

Thanks.

amir86
04-12-2007, 09:28 PM
Installed - Thanks.

Reverend
05-11-2007, 09:23 PM
Working on 3.6.6

mcyates
07-15-2007, 01:09 PM
Im using vb 3.6.7 PL1 and I want this script to work on my forum as the other script I have been using, the welcome panel one, adds 9 queries to the forumhome.

I'm getting this error:
There has been Array new posts and 0 new threads since your last visit.

What can I do to get this to work.

Zachery
07-16-2007, 04:47 PM
Works fine on my 3.6.7 install, not sure what you could have done.

kwallace
10-24-2007, 08:08 PM
Does it work w/ the latest version of VB? 3.6.8 patch1

Zachery
10-25-2007, 12:53 AM
Yea, why wouldn't it?

RedHacker
09-18-2009, 09:18 AM
Zachery not show in vbAdvanced and only show in main forum not show when go to the threads...