View Full Version : New Posts & Threads Since Last visit
Zachery
10 Jun 2005, 02:24
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
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Chris M
10 Jun 2005, 02:36
Installed and working :)
Satan
Link14716
10 Jun 2005, 02:41
Installed and working :)
Satan
Are you installing everything, hellsatan? :p
Chris M
10 Jun 2005, 02:43
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
10 Jun 2005, 03:09
Installed and working :D
ogden2k
10 Jun 2005, 20:05
Just a question, does this work with any type of Read system option? Or just cookie based?
jpt62089
10 Jun 2005, 20:20
*Installed :)
Gary King
10 Jun 2005, 21:04
Installed, but I don't think that is a good location for the text. It should be in the 'Hello, $username' box. IMO.
Logikos
10 Jun 2005, 22:10
Is the same thing as Gary Kings hack?
Reverend
10 Jun 2005, 22:29
Installed plugin but nothing is displayed for me.
ogden2k
10 Jun 2005, 22:30
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
10 Jun 2005, 22:37
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
10 Jun 2005, 22:55
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
10 Jun 2005, 22:56
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
10 Jun 2005, 23:06
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
10 Jun 2005, 23:16
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
11 Jun 2005, 00:51
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:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Then it will work on every page.
Reverend
11 Jun 2005, 20:53
Move the plugin to global_start and remove this from the plug-in code:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Then it will work on every page.Works a treat. Thanks.
zetetic
11 Jun 2005, 22:01
Works a treat. Thanks.
Glad to help. :)
Zachery
12 Jun 2005, 06:14
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
12 Jun 2005, 10:48
Installed, seems to be working fine ;)
/me clicks install
ogden2k
12 Jun 2005, 22:39
Since putting this in global start, if there are no new threads, instead of saying 0 it shows nothing, is this normal?
Reverend
12 Jun 2005, 23:14
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
13 Jun 2005, 15:27
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
13 Jun 2005, 16:32
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
13 Jun 2005, 21:57
Please show me your XML file to compare to mine, thanks!Is it ok to post the code here ?
Reverend
13 Jun 2005, 22:31
Here's a screenie to show the " -1 "
Zachery
14 Jun 2005, 01:14
Here's a screenie to show the " -1 "
Can't account for that, I've not had that problem on my boards yet....
Reverend
14 Jun 2005, 19:58
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
14 Jun 2005, 21:06
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
14 Jun 2005, 21:23
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
17 Jun 2005, 17:45
Sigh, let's hope vB devs come out with a workable solution.
Zachery
17 Jun 2005, 23:30
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
20 Jun 2005, 22:34
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
20 Jun 2005, 23:30
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
21 Jun 2005, 00:26
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&oldmethod=1" accesskey="2">
southernlady
23 Jun 2005, 13:53
Has this been updated to beta 2 yet? Liz
Chris M
23 Jun 2005, 14:00
It works with Beta 2 :)
Satan
southernlady
23 Jun 2005, 14:10
Thanks, :) Liz
southernlady
23 Jun 2005, 14:16
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
27 Jun 2005, 12:49
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&oldmethod=1" accesskey="2">
Any ideas?
southernlady
14 Jul 2005, 13:14
I'm getting this error now:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Running beta 4...has this been updated or should I take it off til it has? Liz
Zachery
14 Jul 2005, 18:04
I'm getting this error now:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
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
14 Jul 2005, 20:18
Thanks, Zachery, all I know is that after taking it out, the parse error went away. Liz
tanyeri24
15 Jul 2005, 03:34
how handle with the file threadsnpostscount.xml
where upload?
Zachery
15 Jul 2005, 07:58
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
15 Jul 2005, 12:33
Zachery, I'll try that. Thanks. Liz
southernlady
15 Jul 2005, 12:55
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
15 Jul 2005, 13:09
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
15 Jul 2005, 13:56
Liz I uploaded a zip with a modified plugin, delete the old one and try that and see what happens.
southernlady
15 Jul 2005, 14:06
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
15 Jul 2005, 14:13
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
15 Jul 2005, 14:33
Zachery, I'm running beta 4 now. not beta 3...that may be the problem. Liz
Zachery
15 Jul 2005, 14:54
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
15 Jul 2005, 15:05
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
15 Jul 2005, 17:35
Liz you should be able to get support on vBA.com :)
Ian Emu-UK
17 Jul 2005, 00:25
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
22 Jul 2005, 20:34
It's saying I have 'Array new posts and 4 new threads'
Any ideas?
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
05 Sep 2005, 02:55
Is it possible to calculate the count of all new threads/posts since last visit into one number?
thetoolman
12 Sep 2005, 22:20
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
12 Sep 2005, 22:55
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
12 Sep 2005, 22:57
ok, but how can i make it work there?
thetoolman
14 Sep 2005, 21:28
any ideas how i can make them appear in the footer?
southernlady
29 Sep 2005, 16:09
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
29 Sep 2005, 17:08
Can 2nd that as well, thx!
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
02 Oct 2005, 18:54
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
02 Oct 2005, 21:56
I cannot stress this enough
DO NOT HAVE THIS RUN ON EVERY PAGE, ITS NOT A GOOD IDEA
Nullifi3d
02 Oct 2005, 23:22
Why? Does it eat too many queries or something?
Zachery
02 Oct 2005, 23:25
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
02 Oct 2005, 23:43
nice, I'd love to have some of the largest tables in the database fully scanned on every page! lol
JulianD
03 Oct 2005, 00:00
Installed =) Thanks!
calldaffer
03 Oct 2005, 16:04
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
03 Oct 2005, 18:44
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
03 Oct 2005, 18:57
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.
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. ;)
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
04 Oct 2005, 03:06
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
04 Oct 2005, 19:42
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
04 Oct 2005, 19:48
Well it counts the posts since your last visit, not the posts that you haven't viewed since your last visit.
predatorkill
10 Oct 2005, 12:43
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 Oct 2005, 13:42
I slipped it down a bit to after this:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
That puts it in the Welcome section that is part of the user cp and under the PM messages. Liz
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 Oct 2005, 20:22
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.
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 Oct 2005, 21:42
Click the SQL link in phpmyadmin, or you can run sql queries from Maintenance >> Execute SQL Query in your forum's AdminCP.
LeeWicKeD
14 Oct 2005, 23:29
great mod,works fine, even at vb3.5gold
find
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
afer that
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Xtrm2Matt
27 Oct 2005, 13:43
~~~ removed ~~~
Just fixed it. Forgot to uninstall the other "New posts" hack before installing this one :)
Thanks anyways :)
Matt
BANDiT600
27 Oct 2005, 14:54
Very very nice!!!
/me installed!
Reverend
29 Oct 2005, 20:31
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
29 Oct 2005, 22:24
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
29 Oct 2005, 22:43
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
30 Oct 2005, 01:37
Good hack :nervous:
ggiersdorf
30 Oct 2005, 18:25
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!?
could someone please explain thisUm, you just had it explaiined to you here.
http://www.vbulletin.org/forum/showthread.php?t=99690
ggiersdorf
30 Oct 2005, 19:57
Paul yes, but I want to change it to tell me # of unread posts. and I dont know how
You can't, without re-writing it.
Will this hack work for Version 3.5.1 ?
Reverend
13 Nov 2005, 00:03
Will this hack work for Version 3.5.1 ? I'm using 3.5.1 and it works fine.
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
20 Nov 2005, 03:06
How do I get this to show on the navbar of EVERY page? Thanks
HMBeaty
23 Nov 2005, 02:13
Anyone?
Zachery
23 Nov 2005, 06:00
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
02 Dec 2005, 17:38
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
02 Dec 2005, 21:04
hmm. Got it fixed.
dark dragun
04 Dec 2005, 10:42
I change up the navbar code. it looked to cluttered, this is simpler.
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Gio Takahashi
12 Dec 2005, 00:19
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.
PennylessZ28
22 Dec 2005, 03:04
excellent
Dantenator
29 Dec 2005, 22:22
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
06 Jan 2006, 17:57
I am also unable to get this hack to work on the CMPS homepage, any clues on what to do?
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
This is the same String linke the new post Link. How can I search only new Threads by klick on new Threads ?
Greetz
Snatch
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...
New Turn,
how i can search only vor new threads since last visit ?
Zachery
16 Jan 2006, 16:37
search.php?do=getnew&oldmethod=1
Chris-777
25 Jan 2006, 17:02
This working on 3.5.3?
Zachery
25 Jan 2006, 20:25
This working on 3.5.3?
Yes.
Chris-777
25 Jan 2006, 21:48
/me clicks install
Thanks as always bud. :)
Devil006
17 Feb 2006, 13:57
Good Job
Thx
Devil006 Clicks Install
Gemilang
14 Mar 2006, 18:15
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.
/me is confused
Zachery
20 Mar 2006, 23:54
I highly advise agsint having it show on all pages.
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:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
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:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
[EDIT]
20060618: removed "$vboptions[bburl]/" in the template code - as https doesn't work
Digital2
11 May 2006, 23:52
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
13 Jun 2006, 01:40
bookmarked. :)
Reverend
15 Jun 2006, 00:33
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
15 Jun 2006, 05:18
I can't see why it wouldn't work.
Reverend
15 Jun 2006, 11:41
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
15 Jun 2006, 11:53
Update: tried it this morning and it is now working correctly. :confused:
Zachery
15 Jun 2006, 19:59
Weird.
Reverend
15 Jun 2006, 20:02
Weird.Yep, can only think it may have been a dateline cache issue after i upgraded to 3.6 :confused:
Zachery
15 Jun 2006, 20:04
Maybe.
MuhammadC
06 Jul 2006, 20:41
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
06 Jul 2006, 22:25
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
06 Jul 2006, 22:47
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
23 Jul 2006, 22:13
Hey guys, 2 quick questions. How many extra queries does this add and does this only display on forum home?
Zachery
24 Jul 2006, 14:42
It adds two queries only to the forumhome.
Hello,
Great add-on, thank you!
When VB 3.6.0 would be supported?
Chris Blount
07 Aug 2006, 13:58
This already works in VB 3.6.
Zachery
08 Aug 2006, 23:41
It is already working for 3.6.
Conspiracy
09 Aug 2006, 12:10
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
06 Oct 2006, 05:29
uber late response but what version of mysql?
ChopBam
13 Nov 2006, 05:10
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
13 Nov 2006, 17:47
Yea, 9/10 times it shouldn't be a big issue. Adding permissions to the query will only make things more comlicated.
Zachery
06 Mar 2007, 19:44
Anyone using this with MySQL5?
Smoothie
06 Mar 2007, 19:57
any chance of fixing the "you don't have the permission to read"?
Zachery
06 Mar 2007, 20:02
any chance of fixing the "you don't have the permission to read"?
Hmmm?
Smoothie
06 Mar 2007, 20:06
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
06 Mar 2007, 20:10
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
06 Mar 2007, 22:16
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
07 Mar 2007, 09:09
Really at best its a minor annoyance TBH. Its not nessary but recomended to help speed the searches up.
Smoothie
07 Mar 2007, 10:40
Thanks.
Sir_Yaro
07 Apr 2007, 17:35
Works on 3.6.5
WebConnection
12 Apr 2007, 07:34
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.
Reverend
11 May 2007, 23:23
Working on 3.6.6
mcyates
15 Jul 2007, 15:09
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:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
What can I do to get this to work.
Zachery
16 Jul 2007, 18:47
Works fine on my 3.6.7 install, not sure what you could have done.
kwallace
24 Oct 2007, 22:08
Does it work w/ the latest version of VB? 3.6.8 patch1
Zachery
25 Oct 2007, 02:53
Yea, why wouldn't it?
RedHacker
18 Sep 2009, 11:18
Zachery not show in vbAdvanced and only show in main forum not show when go to the threads...
vBulletin® v3.6.12, Copyright ©2000-2012, Jelsoft Enterprises Ltd.