PDA

View Full Version : Miscellaneous Hacks - VSa - Advanced 'New Posts' (AJAX)


Valter
01-16-2010, 10:00 PM
Info:
This hack will show how many new posts/threads have been posted in forums since your 'last visit'. New posts are checked via AJAX, manually or in defined time interval. Optionally you can enable and configure Smart Search Menu to give users ability to search individual forum sections. View screenshots...

Installation:
Import product XML: AdminCP > Plugin System > Manage Products > [Add/Import Product]

To set options:
Go to: AdminCP > vBulletin Options > VSa - Advanced 'New Posts'

Versions:
v1.0 - Apr 29. 2006.
-First version
v2.4 - Jan 18. 2009.
-Latest 3.x version
v3.0 - Jan 17. 2010.
-Updated for vBulletin 4.x
-Mod prefix (Cyb) changed to 'VSa'
v3.0.1 - Jan 17. 2010.
-Fixed bug where individual forum search does not work properly
-Fixed bug where product is not stopped when forums are turned off
v3.0.2 - Apr 11. 2010.
-Fixed: WOL confusion
-New: Compatible with DB thread/forum read marking types
-New: Navbar items merged
-Fixed: Permissions bug
-Fixed: Minor bugs
v3.0.3 - May 21. 2012.
-Compatible with vBulletin 4.2.x

molieman
01-17-2010, 12:24 AM
Love it. Nice job!!!! I love simplicity.

Thank you :)

maidos
01-17-2010, 03:06 AM
can you allow post preview on new threads/posts... like on ere..
alow the users to view the post content... the vb4 got a stupid feature that only allow you to read the thread title and nothing more...

argothiusz
01-17-2010, 03:13 AM
Installed but it's not showing. I see New Post: on the nave bar with no lime color number. Using 4.0.1 vb :)

yilmaz
01-17-2010, 08:36 AM
Installed
Nice job!
Thank you

ProFifaLeagues
01-17-2010, 09:23 AM
another nice hack

Kolbi
01-17-2010, 11:09 AM
Nice hack :)

beduino
01-17-2010, 11:13 AM
Hi
great hack.

It's possible, in future, include a feature? Really I wish exclude some ID forums in the 'new topics'.

Tks in advance
joao barroca
aka beduino

ndut
01-17-2010, 12:21 PM
nice.. thanks

mitch84
01-17-2010, 12:29 PM
I see new posts in navbar but when I click on numbers posts, nothing, don't work

War.Frog
01-17-2010, 05:06 PM
Great hack! Would you consider as a possible future option that, instead of refreshing the count on click, it would jump to the Newposts page?

KissOfDeath
01-17-2010, 06:25 PM
Nice mod if it worked....

the mod smart menu does not retreive posts from individual forums, it shows you all new posts which vbulletin have already

AzzidReign
01-17-2010, 06:30 PM
Nice mod! Thanks.

COL NIL SATIS
01-17-2010, 06:31 PM
looks great!!!!!

meschiash
01-17-2010, 07:10 PM
BUG: If forum is tuned off mod stil working
http://img694.imageshack.us/img694/3107/turnoff.jpg

Valter
01-17-2010, 07:13 PM
I wish exclude some ID forums in the 'new topics'.
Inactive, private, and [can't view] forums are automatically excluded.

Be noted that all users may not see what you are able to.
Would you consider as a possible future option that, instead of refreshing the count on click, it would jump to the Newposts page?
This is possible but 'New Posts' is always linked to that page. :-)

We should leave counts to check for new posts when clicked.


Thanks to all for your replies and bug reports. I'm glad you like this product. Fixed version will be uploaded in a few minutes.

Valter
01-17-2010, 07:31 PM
v3.0.1 - Jan 17. 2010.
-Fixed bug where individual forum search does not work properly
-Fixed bug where product is not stopped when forums are turned off

To upgrade:
- Import product XML, allow overwrite.

KissOfDeath
01-17-2010, 08:01 PM
v3.0.1 - Jan 17. 2010.
-Fixed bug where individual forum search does not work properly
-Fixed bug where product is not stopped when forums are turned off

To upgrade:
- Import product XML, allow overwrite.

It's working great now, thanks

what would be better though is having "New Posts In" replace "New Posts", because "New Posts" contains a link for all new posts anyway

just looks a bit wierd "# New Posts:# 309 (In 295 Threads) ⇒# New Posts In"

Hornstar
01-17-2010, 08:04 PM
this looks really great! nice work.

chingon
01-17-2010, 09:14 PM
Very nice, thank you.

ToNetU
01-18-2010, 01:15 AM
really nice hack, but the problem when i translate the phrases to another language (arabic) it not shown correctly [??? ?? ???]! i translated [3 phrases
screenshot: http://img168.imageshack.us/img168/4484/picture3a.png

thanks.

Dr.osamA
01-18-2010, 02:11 AM
gooog mod

thanxxx Valter

installed
________
Interracial amateur (http://www.++++tube.com/categories/694/amateur/videos/1)

Dr.osamA
01-18-2010, 02:29 AM
really nice hack, but the problem when i translate the phrases to another language (arabic) it not shown correctly [??? ?? ???]! i translated [3 phrases
screenshot: http://img168.imageshack.us/img168/4484/picture3a.png

thanks.

???? ???? ????? ????

plzzz add the arabic version to orignal mod

thanxxx agen
________
Magic Flight (http://mflbvaporizer.com)

ToNetU
01-18-2010, 02:46 AM
تفضل اخوي الهاك معرب

plzzz add the arabic version to orignal mod

thanxxx agen
thank you for trying to help, but it's the same problem!
still shown [??? ??] the same in the screenshot above.

i think it's because of UTF-8! and i have to make the Mod support UTF-8!
if this is the problem how can i do it, because am using Mac, and i donno how to do that :) .. but i know how to do it in Windows by Notepad++ software!

so could you please if that possible to make this Mod. support UTF-8 charset? to give this a try!
because Ajax still not fully supported arabic!

Dr.osama, this mod working with you perfectly?
am using firefox 3.5 mac

Dr.osamA
01-18-2010, 03:03 AM
ToNetU

pm my plzz your email adress
________
Fix Ps3 (http://fixps3.info/)

Gene Steinberg
01-18-2010, 03:22 AM
Nicely done. Except for one thing, and that is that, in my forums at least (see www.theparacast.com/forum as an example), you can't just click on the number to see the new posts and threads, only the label New Posts . This is a mite counterintuitive, particularly for less-skilled users. If this isn't the way it was supposed to work, let me know. Otherwise, I'd recommend it as a fix.

Peace,
Gene

meschiash
01-18-2010, 06:18 AM
When i check new post mod write that i have new post's
https://vborg.vbsupport.ru/
but when i click 'new post' i dont't have any new post's
https://vborg.vbsupport.ru/
when i click 'mark as read' then everything is ok. This situation is always a place where I will read the posts after you click on new posts. It seems that the modification does not refresh the data.

skipper-denmark
01-18-2010, 01:49 PM
hi
i have uninstalled, i works in forum but kills my cms site,

i am running 4.01suite and get this error instead of cms site.

Fatal error: Call to a member function hide_errors() on a non-object in /home/cnncovyh/public_html/packages/vbcms/controller/content.php(84) : eval()'d code on line 4

hope for next version

skipper
www.weatherby.dk

woffie
01-18-2010, 04:58 PM
hi
i have uninstalled, i works in forum but kills my cms site,

i am running 4.01suite and get this error instead of cms site.

Fatal error: Call to a member function hide_errors() on a non-object in /home/cnncovyh/public_html/packages/vbcms/controller/content.php(84) : eval()'d code on line 4

hope for next version

skipper
www.weatherby.dk

I have the suite too and I am not getting that.

War.Frog
01-18-2010, 05:15 PM
When i check new post mod write that i have new post's
http://img707.imageshack.us/img707/6154/1bug.jpg
but when i click 'new post' i dont't have any new post's
http://img188.imageshack.us/img188/585/2bug.jpg
when i click 'mark as read' then everything is ok. This situation is always a place where I will read the posts after you click on new posts. It seems that the modification does not refresh the data.

I have the same situation. I have zero unread posts now, but the mod text is still showing 54 unread in 17 threads.

KissOfDeath
01-18-2010, 05:58 PM
I have the same situation. I have zero unread posts now, but the mod text is still showing 54 unread in 17 threads.

you need to click "mark forums as read" at the bottom of your forum home page to reset it to 0

skipper-denmark
01-18-2010, 07:05 PM
I have the suite too and I am not getting that.

the error went away the i uninstaled the mod. and came again when i uploaded it again

??????

War.Frog
01-18-2010, 07:20 PM
you need to click "mark forums as read" at the bottom of your forum home page to reset it to 0

I know, but that's counterintuitive. They already are read, so I'm having to use that function to fix a count issue with another info display. That's not something I want to have to train members to have to do.

skipper-denmark
01-18-2010, 07:22 PM
the error went away the i uninstaled the mod. and came again when i uploaded it again

??????

Sorry no problem found uout that it was a other mod that make the problems, but only if you hav't saved password and usernavne

it was this that make the problem for me

VSa - Visitors In Last X Hours

https://vborg.vbsupport.ru/showthread.php?p=1959502#post1959502

woffie
01-18-2010, 08:31 PM
This is affecting the whos online on the forum. It is also affecting the who is viewing thread feature. In the whos online, when it is enabled it shows everyone viewing board index. On the who is viewing thread it does not show who is viewing the thread. I tested this with my moderators. We all parked on a thread and I turned this on and the display changed from all three of us to just me. Their view was similar.

iceman-x
01-19-2010, 08:08 AM
Thanks for nice addon :)

kisanjong
01-20-2010, 08:38 AM
Great Mod - Thanks - 5*

3DUInc
01-20-2010, 11:51 PM
tagged for future install excellent work Thanks

MarceloS
01-22-2010, 12:17 PM
Excellent mod. It would be awesome to have an option to also show new blog posts, new group messages, as it does with new posts.

War.Frog
01-22-2010, 11:21 PM
I know, but that's counterintuitive. They already are read, so I'm having to use that function to fix a count issue with another info display. That's not something I want to have to train members to have to do.

Any word on whether this bug will be fixed in a future release?

Charlie98902
01-24-2010, 09:32 PM
On my forum I use the who's online and it refreshes every 15 seconds. If I turn off the ajax refresh check and using the who's online when a new post happens would it show then? Kind of like Paul's it doesn't check but when the forum refreshes it shows if there is new posts. So if I turn off auto refresh will this do the same as I like where yours is better.

New Joe
01-25-2010, 03:44 AM
This is affecting the whos online on the forum. It is also affecting the who is viewing thread feature. In the whos online, when it is enabled it shows everyone viewing board index. On the who is viewing thread it does not show who is viewing the thread. I tested this with my moderators. We all parked on a thread and I turned this on and the display changed from all three of us to just me. Their view was similar.

Same problem, any up-date going to happen for this, or anyone know how to solve this?

meschiash
01-25-2010, 10:39 AM
I have the same situation. I have zero unread posts now, but the mod text is still showing 54 unread in 17 threads.

I have a new bug. When you are on the board and mod check for new posts (you do nothing), user who has email thread subscription, have new email after all new reply without enter into thread.

w-elbalad.com
01-25-2010, 11:18 AM
nice mod < thanks

Valter
01-25-2010, 01:15 PM
I have a new bug. When you are on the board and mod check for new posts (you do nothing), user who has email thread subscription, have new email after all new reply without enter into thread.
It works as it's supposed to, right?

I believe this has nothing with the email sending feature, but I'll check it.

meschiash
01-25-2010, 01:25 PM
For clarification.

If someone has a notice of response to e-mail and is currently on the main forum is a modification from time to time refreshes and checks for new posts.

If at that time to other users update that thread the subscriber receives e-mail every time even though not physically visit the topic.

ps. I apologize for my English but supports the translator

mmhmm
01-25-2010, 01:32 PM
thank you for this. installed.

Charlie98902
01-25-2010, 03:32 PM
Is there way way to use the vb cookie system so when you read threads/posts it clears as you read them?

New Joe
01-25-2010, 11:34 PM
Is there way way to use the vb cookie system so when you read threads/posts it clears as you read them?

Same here, also the Who's on line problem.

Trek
01-25-2010, 11:40 PM
Before I try this out, I need to get some clarification.

Does this only check for new posts since your last visit?

or

Does it check the actual unread posts you have?

I currently use PaulM's Unread Posts mod and it has the option to do either one. Personally, I use the actual unread posts because I think that sometimes people (myself included) access the forums, need to do something else for a bit, click something else and now all the "new" posts are gone, even though they are unread.

In anycase, I'm not trying to stop it from how it's working now (if that is how it works now), but would like to see the same option for defining what is an "unread post" as in Paul's mod.

Thanks!

Charlie98902
01-25-2010, 11:54 PM
Counts the threads and posts made no matter what in the 24 hour period I do believe. I want this mod to be that of the same as Paul's then this one would rock.

War.Frog
02-09-2010, 12:49 AM
Any word on whether this mod will be fixed to display actual unread posts for the user?

Charlie98902
02-09-2010, 01:14 AM
Any word on whether this mod will be fixed to display actual unread posts for the user?

That's what I wanted to see just the unread posts and after you read it, it will reset the unread posts.

War.Frog
02-09-2010, 11:46 AM
Yes exactly. I had to disable this mod because it was causing a lot of confusion. Members with NO unread posts still had their New Posts count incrementing.

New Joe
02-11-2010, 07:55 AM
Is this hack still supported?

War.Frog
02-11-2010, 11:22 AM
From his profile: "Note: All of my products are supported, but I'm busy with my main job, so please be patient when asking for support."

So hopefully that means yes!

(p.s. maybe he's hard at work on updating his Advanced Forum Statistics mod?) :D

modernbliss
02-13-2010, 02:46 AM
Nevermind! I got it to work, but I do have another question. How do I keep the New Posts In option when it moved over to the What's New tab? Is that possible? Great mod, btw! Thanks!

I don't know what I'm doing wrong, but I've uploaded this, followed all the instructions, but nothing is showing up. I just updated tonight and I had the older version of this and it worked fine, so I'm not sure what the problem is. :( Kind of a crappy screenshot, but...

https://vborg.vbsupport.ru/external/2010/02/55.jpg

woffie
02-20-2010, 10:53 AM
It the whos online issue going to be fixed for this?

hanbattin
02-20-2010, 12:22 PM
on vBulletin 4.0.1 it's showing the link, but when i click on the lime color link, that link does not work to me.

TonicWater
02-23-2010, 05:31 PM
yes it is confusing:
1. i cant click on the info
2. it dont show up in "whats new"

waiting for future versions :)

axix20xx
03-01-2010, 10:20 PM
how can i align this to right the ":" make it to show when it align to right

doopz
03-02-2010, 08:44 AM
This is affecting the whos online on the forum. It is also affecting the who is viewing thread feature. In the whos online, when it is enabled it shows everyone viewing board index. On the who is viewing thread it does not show who is viewing the thread. I tested this with my moderators. We all parked on a thread and I turned this on and the display changed from all three of us to just me. Their view was similar.

Same problem, any up-date going to happen for this, or anyone know how to solve this?
Will this be fixed? (is this even seen as a bug?)

War.Frog
03-03-2010, 12:34 PM
I hope this is fixed too - I really like this mod's potential when its numbers don't confuse my members. Also, I don't know if it's even possible, but it would also be nice if the display area for the info was a fixed width. With the AJAX update, changes from 1 to 2 digits etc. can make the toolbar "wiggly" and distracting.

I realize you don't want to just apportion giants swaths of real estate to this, but perhaps consider showing new posts and new thread counts of 100 or more as ">99"? Just a thought.

JonnyThunder
03-05-2010, 10:57 AM
Just wanted to say thanks for this mod. It's very simple but hugely effective!

:-) Nice work fella!

Beor
03-06-2010, 12:55 PM
Hello

I install the plugin, but when active vbsupercharged no view the number of new messages.

Thanks

JonnyThunder
03-09-2010, 10:20 AM
There may be a wee bit of a bug. If you go to post a message and click Preview, my forum comes up with an error just under where the new posts indicator should be. However, this appears to be an intermittent fault - it doesn't always show.

Still love the mod regardless! Nice work.

War.Frog
03-12-2010, 01:21 AM
I hope this is fixed too - I really like this mod's potential when its numbers don't confuse my members. Also, I don't know if it's even possible, but it would also be nice if the display area for the info was a fixed width. With the AJAX update, changes from 1 to 2 digits etc. can make the toolbar "wiggly" and distracting.

Any word on whether a fix is possible for this mod's post counts?

TeknoSounds
03-19-2010, 03:10 AM
Conflicts with vB4 Supercharged. Turning off the javascript compressor seems to do the job.

GeorgeB85
03-20-2010, 03:54 AM
Valter:

Not sure why but this mod seriously bogs down my admincp as well as certain sections of my forum that all members have access to. I have no idea why, but it has been going on for a few weeks. I finally found this mod to be the issue today and once I disabled, things picked up.

Any idea why this mod would do it, and any idea on how to stop it?

Bram H
03-22-2010, 08:20 AM
Saw this way too late (as usual :)). Thanks Valter, another great mod!

Valter
04-10-2010, 06:59 PM
New version is coming with some fixes and improvements, including:
-Fixed bug: WOL confusion
-New: Compatible with DB thread/forum read marking types

Diablotic
04-10-2010, 08:06 PM
That's great news. When can we expect updated version?

Valter
04-11-2010, 06:49 PM
v3.0.2 - Apr 11. 2010.
-Fixed: WOL confusion
-New: Compatible with DB thread/forum read marking types
-New: Navbar items merged
-Fixed: Permissions bug
-Fixed: Minor bugs

To upgrade:
-Import XML, allow overwrite

starman?
04-11-2010, 07:24 PM
Updated and no problems. I like the new look. Thanks Valter.

Smiler2009
04-12-2010, 04:04 PM
Valter,

Super Mod, just one question, I have the album and gallery mod and on the navbar You mod is split by it, i.e. the first nav button says New Posts then comes Gallery and then 9/17 (for example)

Any way I can either move your mod along to the end or stop it doing this in any way?

Regards, Jeff.

Valter
04-12-2010, 07:25 PM
Change plugin execution order to fix this.

Example:
- Adv New Posts = 5
- Gallery = 6

Smiler2009
04-14-2010, 04:55 PM
Thank you Valter, much appreciated.

Jeff.

bayXzor
04-14-2010, 09:27 PM
Installed
Nice job!
Thank you

Robbed
04-14-2010, 09:45 PM
Valter, would it be possible to to create an option so users can exclude forums from new posts in their usercp?. It used to be part of an older hack.

MarceloS
04-15-2010, 01:33 PM
Hi thanks for the excellent mod.

One question:

Is it possible to include the blog posts when you look for new posts?

Kolbi
04-20-2010, 10:18 AM
It would be nice to disable the manually update and the whole dropdown menu.

Xencored
05-06-2010, 04:01 PM
ive used this for years but for some reason its not showing on my skin :(
Please how can i get this to work i love it hard :D

Edit 4.0.3

Xencored
05-18-2010, 01:08 PM
ive used this for years but for some reason its not showing on my skin :(
Please how can i get this to work i love it hard :D

Edit 4.0.3

Valter any idea why its not showing in my navbar?
Thanks

docvader
05-19-2010, 08:24 PM
Works great, but when installed with this album hack:
https://vborg.vbsupport.ru/showthread.php?t=237931&highlight=albums
the gallery link gets between the New Posts link and the green highlighted numbers. I guess the two mods are competing for the same hook in the navbar. Any way of getting the numbers back to the New Post's link without removing the album mod?

Xexiu
05-23-2010, 06:01 PM
Same here, using gallery add-on, and doesn't show up the posts. Added the order to VSA 5 and Gallery 6, and still nothing.

Uninstalled gallery, and the dropdown is blank and posts number aren't showing :(.

Dang, I love this mod, to bad I can't use it as on v3.8!

texasteamplayer
05-28-2010, 12:42 AM
perfect.

texasteamplayer
05-28-2010, 12:48 AM
but what's the "# l #" for? I assume it means x posts in y categories...perhaps?

doesn't seem necessary, and would like to disable it, and just have the drop down.

really great function that was super needed on big boards with too many posts for mods to deal with globally.

Valter
05-28-2010, 05:12 PM
x new posts | in y threads

texasteamplayer
05-29-2010, 01:53 AM
yeah. it makes sense if you're the coder. But....to a new user...it's just some numbers and a line. Possible to say "x posts in y threads"

texasteamplayer
06-02-2010, 07:29 PM
any way to have individual forums, instead of just forum categories, as unread links?

http://img338.imageshack.us/img338/4318/24648768.jpg

for example, our "hosted games" and resident clan categories have dozens of individual forums. Most users would only want to look at a few of these specifically (like CSS and 2142, or =123= clan public and private only). Possible?

Also, what about creating a mod that allows users to designate what their "unread posts" button will do? Meaning...let individual users specify what forums, category, or individual, are going to be searched for unread posts? So...for example, I could set my link to read only the CSS, 2142, BF2 admin, and =123= clan, and hosted games (CSS, 2142, and BF2) only. would be userful in a hurry, for mods, admins, and regular users.

massizero
06-12-2010, 11:07 PM
some users are writing that they don't read any numbers but "database error" what could it be the reason ? thanks

RustyDogma
07-09-2010, 03:09 PM
I love this mod! It would be nice if it could show new posts in groups as well.

Xencored
07-20-2010, 11:12 PM
Is there a way to Disable CMS comments from showing? because it links them to the "none viewing thread" not the main article

Thanks

CVOsporty
08-09-2010, 06:53 PM
Hi new to BBcode and stuff as only ever really used the frebies :D
is there a way that somebody could advise on how to get this to post on everypage of the forum, many regards

DDIG
08-10-2010, 04:04 PM
Gread mod! Thank you very much!

Webby24
09-24-2010, 11:41 AM
Hello,
dont know if this error is known.

But i have the follow error, and this after installation thousand times

Invalid SQL:

SELECT COUNT(*) AS posts, post.threadid
FROM vb3_post as post /*FORCE INDEX (dateline)*/
INNER JOIN vb3_thread as thread USING (threadid)
INNER JOIN vb3_forum AS forum USING (forumid)
LEFT JOIN vb3_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1530)
LEFT JOIN vb3_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1530)
WHERE thread.visible IN (1)
AND thread.forumid NOT IN(64,16,52,22,24,)
AND post.dateline > IF(threadread.readtime IS NULL, 1285316613, threadread.readtime)
AND thread.lastpost > IF(threadread.readtime IS NULL, 1285316613, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1285316613, forumread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1285316613, forumread.readtime)
AND post.dateline > 1285316613 AND thread.lastpost > 1285316613
GROUP BY post.threadid;

MySQL-Fehler : 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 ')
AND post.dateline > IF(threadread.readtime IS NULL, 1285316613, threadre' at line 8

Thanks a lot

Andr?

Head Roller
10-01-2010, 06:25 PM
Very nice Mod.. .thanks

LuisManson
10-13-2010, 02:30 PM
i was wondering how server intensive this is, since i see lots of POST /misc.php?show=vsaanp_newposts HTTP/1.0 in the apache status...

MonsterDK
10-19-2010, 02:44 PM
Need some advice... been advised to remove this if on shared or vps hosting based on that when my forum fills up with members and posts, this mod will be a major down fall.

I am using shared hosting.. can anyone advise on this?

thanks

shanef
10-30-2010, 08:07 PM
how can i exclude forums that i don't want showing new posts?

YankForum
10-31-2010, 02:22 PM
this would be nice if it could be shown up in notification popup menu , like facebook

shanef
11-06-2010, 10:32 PM
how can i exclude forums that i don't want showing new posts?

i guess there is no support?

amorosso
11-07-2010, 01:38 PM
Oh man, now my users can get my butt. Thank you so much.

mmacrypt
11-12-2010, 12:54 AM
love the changes in this mod, just updated, thank you for your work.

Dragaon
11-15-2010, 06:52 PM
installed and it worked fine. After 6 hours the servers CPU maxed out and I had to disable it. :-\

RK KINGKONG
12-28-2010, 06:33 PM
WELL for me it works but where some dont see an error message others do like this for example :
Database Error]]> Database error in vBulletin 4.1.0

Invalid SQL: SELECT COUNT(*) AS posts, post.threadid, post.dateline, thread.forumid FROM post as post LEFT JOIN thread AS thread ON (thread.threadid = post.threadid) WHERE post.visible = '1' AND thread.forumid NOT IN(3,60,58,) AND post.dateline >= 1293531163 GROUP BY post.threadid;

MySQL Error : 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 ') AND post.dateline >= 1293531163 GROUP BY post.threadid' at line 4
Error Number : 1064
Request Date : Tuesday, December 28th 2010 @ 01:18:03 PM
Error Date : Tuesday, December 28th 2010 @ 01:18:04 PM
Script : http://www.righteouskings.com/misc.php?show=vsaanp_newposts
Referrer : http://www.righteouskings.com/forum.php?styleid=30
Classname : vB_Database
MySQL Version :
]]>

anyone know why ?? please reply

Brew
01-16-2011, 02:39 PM
Hey Valter!

Can you please update this to ver 4.1.1 or maybe 4.2?

Thanks!

RK KINGKONG
01-21-2011, 01:19 AM
i just updated my vb 4.1 patch 2 / to vb 4.1.1 and for some reason i dont get the error message i use to get . that was random but who cares right it works well ... so far no one has reported back to me yet that they are seeing the error message i posted above . before i couldnt see but others could now so far no one sees it . so imma say its safe to assume it works well with VB 4.1.1

thanks again for a great mod

imedic
01-25-2011, 09:02 PM
Works great in 4.1.1 Tank you. :)
Would love to have also My posts and My threads in the same menu :)

RK KINGKONG
01-25-2011, 09:12 PM
that would be awesome though theres a mod for that already , however having both of these in the same place would be great

my threads & my post
here (https://vborg.vbsupport.ru/showthread.php?t=227856)

Swordman844555
02-13-2011, 07:31 AM
Old Articles from the CMS will reappear as new?

Crossbow
02-17-2011, 01:51 PM
Installed and works great.

Thank you.

Xowi
02-25-2011, 12:55 AM
Another great mod, thanks!

x YNWA x
03-24-2011, 07:12 PM
Getting database emails for errors. On the error it has vsaanp_newposts, I am guessing it stands for vsa advanced new posts. Correct me if I am wrong.

Database error in vBulletin 4.1.2:

Invalid SQL:

SELECT COUNT(*) AS posts, post.threadid, post.dateline, thread.forumid
FROM post as post
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
WHERE post.visible = '1' AND thread.forumid NOT IN(23,24,31,25,26,27,28,) AND
post.dateline >= 1300992412
GROUP BY post.threadid;

MySQL Error : 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 ') AND
post.dateline >= 1300992412
GROUP BY post.threadid' at line 4
Error Number : 1064
Request Date : Thursday, March 24th 2011 @ 12:57:28 PM
Error Date : Thursday, March 24th 2011 @ 12:57:28 PM
Script : http://www.anfieldindex.com/forum/misc.php?show=vsaanp_newposts
Referrer : http://www.anfieldindex.com/forum/index.php
IP Address : 122.177.193.206
Username : thereddyone
Classname : vB_Database
MySQL Version :


Anyone have an idea what this error means and how to fix? I do not think users actually get an onscreen error...

Valter
03-24-2011, 09:23 PM
Try rebuilding forum cache by going to your forum manager and saving the display.

Try also with:
Maintenance > Update Counters > Rebuild Thread Information
Maintenance > Update Counters > Rebuild Forum Information

x YNWA x
03-27-2011, 11:40 PM
Try rebuilding forum cache by going to your forum manager and saving the display.

Try also with:
Maintenance > Update Counters > Rebuild Thread Information
Maintenance > Update Counters > Rebuild Forum Information

Sorry What does saving the display mean? Cheers

Valter
03-30-2011, 05:57 PM
[Save Display Order] button at the bottom of the page.

fatdr
03-31-2011, 06:31 AM
nice mod
thanks

fatdr
03-31-2011, 06:32 AM
Works great in 4.1.2 Thank you.

pselten
04-24-2011, 04:22 PM
Also works great in V4.1.0

Now it says X (posts) in Y (threats)
Is it possible for me to hide the Y and only show the X ?

Thanx in advance,

Paul Selten.

starman?
07-26-2011, 04:35 PM
working just fine and dandy in 4.15 beta! Thanks Walter!!!

Scalemotorcars
08-27-2011, 01:53 PM
Working but is there a way to add the results to subnav on cms pages?

Drache
08-29-2011, 05:49 PM
Does this use a lot server resource or slow server down?

Valter
09-02-2011, 07:30 PM
It depends on your server, number of active users, product settings.

Try and see.

I believe it will work with no problems.

Quest2be1
09-03-2011, 09:17 PM
Hi, I am using VBulletin 4.1.5 and I have installed the latest version of this mod 3.0.2. Basically, when I click on the advanced new posts icon it continues to show me "View New Posts in..." When in fact there are no more new posts to view. Can you please point me in the right direction to resolve this issue? Is SSM the problem and I have to disable it? Thanks in advance for the help.

misericorde
10-16-2011, 08:27 PM
Thank you

Nice

Installed and nominated

RSNF
12-10-2011, 07:25 PM
The mod worked fine for a while and now the following error occurs can anyone help?

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@redsoxnationfans.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Successfulsteps
01-10-2012, 12:15 AM
Anyone having problems in 4.1.9? I would love to see this working on that upgrade!

Valter
01-10-2012, 07:03 AM
Works with no problems with 4.1.9.

garybrun
01-11-2012, 12:35 AM
Its working on my forum 4.1.9a

Valter...
Greetings from Norway and thanks for some excellent hacks.

http://www.minelabowners.com

Emeralda
02-11-2012, 04:36 PM
It works on 4.1.10, at least with it's basic functionality, I haven't gotten deeper yet. But it doesn't show properly here:

http://img860.imageshack.us/img860/2712/269d2539802b4ca1ab11c15.png

Any ideas on how I could get it to work with What's New tab?

depalaza
02-24-2012, 06:21 AM
Try rebuilding forum cache by going to your forum manager and saving the display.

Try also with:
Maintenance > Update Counters > Rebuild Thread Information
Maintenance > Update Counters > Rebuild Forum Information

i have same problem and i have do
-forum manager and saving the display.
Maintenance > Update Counters > Rebuild Thread Information
Maintenance > Update Counters > Rebuild Forum Information


but still error

Invalid SQL: SELECT COUNT(*) AS posts, post.threadid, post.dateline, thread.forumid FROM post as post LEFT JOIN thread AS thread ON (thread.threadid = post.threadid) WHERE post.visible = '1' AND thread.forumid NOT IN(3,10,57,64,79,80,81,73,48,74,87,62,75,71,) AND post.dateline >= 1330064830 GROUP BY post.threadid;

MySQL Error : 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 ') AND post.dateline >= 1330064830 GROUP BY post.threadid' at line 4
Error Number : 1064
Request Date : Thursday, February 23rd 2012 @ 10:52:17 PM
Error Date : Thursday, February 23rd 2012 @ 10:52:18 PM
Script : http://www.blackgamerz.net/misc.php?show=vsaanp_newposts
Referrer : http://www.blackgamerz.net/forum.php
Classname : vB_Database
MySQL Version :

Valter
02-24-2012, 07:25 AM
You have unexpected comma at the end of list of excluded forums.
3,10,57,64,79,80,81,73,48,74,87,62,75,71,

Nirjonadda
02-24-2012, 12:17 PM
Working on my forum 4.1.10

depalaza
02-27-2012, 12:33 PM
You have unexpected comma at the end of list of excluded forums.
3,10,57,64,79,80,81,73,48,74,87,62,75,71,

hmm excluded forum ? where i can find it ? and that message not shown at admin usergroup so it only shown to other usergroup

Valter
05-21-2012, 04:05 PM
v3.0.3 - May 21. 2012.
-Compatible with vBulletin 4.2.x

To upgrade:
-Import XML, allow overwrite
-Revert product templates if modified

Gemma
05-21-2012, 04:12 PM
Thanks for the update :)

FTG LIQUID CL
05-22-2012, 01:39 AM
Works like it says,updates fine.Great work as always Valter. Thank you

jdeveaux
05-27-2012, 12:52 AM
I'm testing with 4.2 and getting the same MySQLi error, below:

Note - I've noticed that it only happens if a user logs out or comes to the site and does not have cached login credentials. Once they log-in everything appears to be ok.


Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT COUNT(*) AS posts, post.threadid
FROM vb_post as post /*FORCE INDEX (dateline)*/
INNER JOIN vb_thread as thread USING (threadid)
INNER JOIN vb_forum AS forum USING (forumid)
LEFT JOIN vb_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 0)
LEFT JOIN vb_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 0)
WHERE thread.visible IN (1)
AND thread.forumid NOT IN(7,16,24,8,33,21,136,127,115,138,5,110,25,28,29, 42,80,3,12,134,139,36,131,130,30,99,91,32,82,69,31 ,20,27,26,117,)
AND post.dateline > IF(threadread.readtime IS NULL, 1338082997, threadread.readtime)
AND thread.lastpost > IF(threadread.readtime IS NULL, 1338082997, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1338082997, forumread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1338082997, forumread.readtime)
AND post.dateline > 1338082997 AND thread.lastpost > 1338082997
GROUP BY post.threadid;

MySQL Error : 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 ')
AND post.dateline > IF(threadread.readtime IS NULL, 1338082997, threadre' at line 8 Error Number : 1064 Request Date : Saturday, May 26th 2012 @ 08:44:21 PM
Error Date : Saturday, May 26th 2012 @ 08:44:22 PM
Script : http://site/misc.php?show=vsaanp_newposts
Referrer : http://site/login.php?do=logout&logouthash=1338082833-3f51cc6f70209b349b14a91f036f538d64af7e12
IP Address :
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

Regards,

John

Valter
05-27-2012, 06:38 AM
At the end of list of excluded forums you have extra comma which produces error:
...27,26,117,).

It should not be there. Try rebuilding Forum Information.

Honk0815
05-27-2012, 09:19 AM
Can I use the addon with vbcms?
I have only in Forum Advanced 'New Posts' (AJAX) and i need this in cms too

jdeveaux
05-27-2012, 12:24 PM
At the end of list of excluded forums you have extra comma which produces error:
...27,26,117,).

It should not be there. Try rebuilding Forum Information.

I've tried rebuilding the forums, threads, flushing the cache, even tried to figure out where it is picking up the list in the Database.

:erm:

CAG CheechDogg
06-11-2012, 10:13 AM
How do you exclude certain forums?

dlewisr
06-12-2012, 09:28 AM
Nice one. Works with 4.2.0. Does exactly what it says on the tin.

Cheers

jdeveaux
06-18-2012, 06:36 PM
I've tried rebuilding the forums, threads, flushing the cache, even tried to figure out where it is picking up the list in the Database.

:erm:

By chance I've discovered that this issue is caused by installing a combination of VSA Hacks... now the new question is which one :confused:

I'm going through and testing one by one but thus far I haven't found the smoking gun. Installed by itself it works great.

root2012
11-05-2012, 01:43 PM
I have a problem after install

Datenbankfehler in vBulletin 4.1.0:

Invalid SQL:

SELECT COUNT(*) AS posts, post.threadid
FROM post as post /*FORCE INDEX (dateline)*/
INNER JOIN thread as thread USING (threadid)
INNER JOIN forum AS forum USING (forumid)
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 67)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 67)
WHERE thread.visible IN (1)
AND thread.forumid NOT IN(106,107,108,109,110,99,100,)
AND post.dateline > IF(threadread.readtime IS NULL, 1352086208, threadread.readtime)
AND thread.lastpost > IF(threadread.readtime IS NULL, 1352086208, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1352086208, forumread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1352086208, forumread.readtime)
AND post.dateline > 1352086208 AND thread.lastpost > 1352086208
GROUP BY post.threadid;

MySQL-Fehler : 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 ')
AND post.dateline > IF(threadread.readtime IS NULL, 1352086208, threadre' at line 8
Fehler-Nr. : 1064
Fehler-Zeit : Monday, November 5th 2012 @ 03:27:08 PM
Datum : Monday, November 5th 2012 @ 03:27:09 PM
Skript : http://new/vb4/misc.php?show=vsaanp_newposts
Referrer : http://new/vb4/forum.php

emperatour
12-19-2012, 01:42 PM
Dear Valter,
Above the search results, the name of my private subforums will be shown to people who has no permission. This list is returned from {vb:raw criteriaDisplay}.

Please provide a fix for this issue.

<div id="pagetitle">
<h1>
<vb:if condition="$search_back_url">
<a href="{vb:raw search_back_url}"><strong>{vb:rawphrase search}:</strong></a>
<vb:else />
<strong>{vb:rawphrase search}:</strong>
</vb:if>
</h1>
<p class="description">
{vb:raw criteriaDisplay}
</p>
</div>

I appreciate your work.

Amaury
02-08-2013, 05:36 PM
So, under New Posts in your screenshot, what does 3 | 2 mean?

Dwarden
03-16-2013, 09:26 AM
v3.0.3 - May 21. 2012.
-Compatible with vBulletin 4.2.x

To upgrade:
-Import XML, allow overwrite
-Revert product templates if modified

well I tried update from 3.0.2 to 3.0.3 and the post counter is gone on 4.2.x forum
reverting to 3.0.2 fixes it

Dear Valter,
Above the search results, the name of my private subforums will be shown to people who has no permission. This list is returned from {vb:raw criteriaDisplay}.

Please provide a fix for this issue.

<div id="pagetitle">
<h1>
<vb:if condition="$search_back_url">
<a href="{vb:raw search_back_url}"><strong>{vb:rawphrase search}:</strong></a>
<vb:else />
<strong>{vb:rawphrase search}:</strong>
</vb:if>
</h1>
<p class="description">
{vb:raw criteriaDisplay}
</p>
</div>

I appreciate your work.

where this goes to please ?

NoMatt3r
08-30-2013, 02:57 PM
Installed on 4.2.1 and working great!

But it still shows 4 | 6 altough i've already read the new posts/threads. And the SSM shows forums although the usergroup doesn't have permissions.

Bubble #5
09-10-2013, 04:12 PM
Found what appears to be a major bug with this mod (4.2.1).

When you close the forum, AND also try to log into it, the amount of new posts turns into your forum closed message. If you are not logged in and the forum is closed the message does not appear. Here is a screenshot;

Could not fix the bug noted above.

Deleted hack. Shame, it had lots of nice features.

Dwarden
10-29-2013, 09:39 PM
seems like there are problems with 4.2.2 (both 3.0.2 and 3.0.3) ...

[] [error] [client] PHP Fatal error: Nesting level too deep - recursive dependency? in Unknown on line 0, referer: http://forums.somewhere.com/showthread.php?163352-somepage/page5

and indication of 500 error leading to the /misc.php?show=vsaanp_newposts

whole forum goes to stall and needs server restart

anyone have tips how resolve it ?
and is there anyone who runs runs 3.0.3 on vB 4.2.2 ?

GamerUnguided
02-10-2014, 07:48 PM
So has anybody had any luck with this not appearing on certain themes? is there some template edit i can add to make it show?

root2012
06-16-2014, 01:29 PM
Any ideas on how I could get it to work with What's New tab?

Gierade
01-27-2017, 11:18 AM
Plugin stopped working after updating to 4.2.3 PL 2 forum PHP version 5.4.45 - any ideas how to fix it?
Does not display the counter of new threads.

roiarthur
05-12-2017, 10:41 AM
The mod is malfunctioning with Vbulletin 4.2.5

roiarthur
05-14-2017, 10:53 AM
The stats will not refresh after viewing the new messages, someone can help to fix it please?