Path bug fixed. I am very sorry for inconvinience.

What exactly linkback?

ah.. nevermind I just realized it is a VBSEO function and not a vbulletin function.

thank you for the request and the mod. It's excellent!

Thanks for the update ;)

HI WHEN I CLICK ON THREAD MODERATION I GET THIS ERROR

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT * FROM user as u
LEFT JOIN usergroup as ug ON (u.usergroupid = ug.usergroupid)
LEFT JOIN post as p ON (u.userid = p.userid)
WHERE postid=;

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 '' at line 4
Error Number : 1064
Request Date : Thursday, August 7th 2008 @ 06:44:30 PM
Error Date : Thursday, August 7th 2008 @ 06:44:30 PM
Script : http://www.yc-spicy.com/moderation.p...type=moderated
Referrer : http://www.yc-spicy.com/
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.51a-community

After you click on moderation you are taken to standard VBulletin page. My mod has no relation to that effect. Try to click corresponding link in modcp or user profile that has the same effect. Links are taken from there.

Does anyone else has the same problems?

I have just installed this & currently have no outstanding posts or threads to modify at the moment but it is still showing as 1 thread awaiting moderation.

I have checked via Admin screen & searched on older posts but there is nothing to moderate. Why is it showing this?:confused:

I don't know. Check your moderation table. It should be empty, when nothing to moderate

I have just checked table called 'moderation' and it is empty. :confused:

that happened to me before,I did that when i was deleting a post that was in moderation and it never went away so i went to the moderation table and empty it so everything was good after that.You may want to do it.

Thank you but HOW do I empty it?

If I look in phpmyadmin & browse the table there are '0' rows so I thought it was empty.

I am amazed that so few people have installed this mod. I guess it is because of the bugs that where in previous versions.

Please post your experience with the latest version.

This cause me errors with VBadvanced.

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE vbadv_dyna_entries SET views = views+1 WHERE entryid =;

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 '' at line 1
Error Number : 1064
Request Date : Thursday, August 14th 2008 @ 12:14:35 AM
Error Date : Thursday, August 14th 2008 @ 12:14:35 AM
Script : http://www.queeruk.net/guide/showentry.php?e=90
Referrer : http://www.queeruk.net/guide/
IP Address :
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-community

Never tried this hack appearing in navbar menu.
I am still waiting for an update of quick moderation box for vBadvanced CMPS.

I don't think it is a problem of my hack.

nice job thx :)

Everything works fine without it. I enable your hack and then it stops working which is a shame.

I now have 2 bugs

1. I cannot clear the Thread Notification=1, even though the moderation table is EMPTY (see my post above)

2. I have now enabled Calendar Moderations & although it correctly shows one event awaiting moderation, the link in the pull-down is not correct - it just goes go to "myforum.com/1" wheras as post notofications go to "myforum.com/moderation.php?do=viewposts&type=moderated"

The same happens for Users & Album pictures.

There doesn't seem to be an option on the User Profile to moderate events - is that right? Do you have to go to modcp? - it looks like the link should be to "myforum.com/modcp/moderate.php?do=events"

Please can you look. Thanks.

2holwebs
#2 Bug fixed. xml reuploaded. Thank you for reporting.

But I still cannot fix your bug #1. On my forum all is shown correctly. Can you please execute the following SQL on your forum DB and tell me the result:

Hi,

have redownloaded & bug with calandar events is now fixed thanks.

Have run the query on my dbase for table moderation as requested:

Showing rows 0 - 0 (1 total, Query took 0.0002 sec)

so you're right there is one row there but vB shows 'no threads to moderate'. I've reported it on vbulletin.com although I know I could delete it manually but I wonder if there is a bug there.:confused:

You can also check using phpMyAdmin, what is actually inside this moderation table

Hi there,

This is the EXACT problem I reported as well on page [2?] of this thread.

vbAdvanced Dynamics was NOT working with your mod - 'entryid' variable is not populated/empty.

You mentioned you will look into it.. any luck to find the issue?

As soon as I disable your mod - the Dynamics is working fine again.. so - well - yes, we think there is a problem with this mod - somewhere..


Cheers,
aproape

dude, 4 queries onto the forumhome?

Where I can get this hack?

Queries are executed only for members of usergroups you selected. I hope, you don't have 1000 admins/mods per forum?
If you have any ideas on how to achieve the same goal in smaller amount of queries, you are welcome to post them here.

Hi there,

vbadvanced.com

The product is called Dynamics [we bought it].

---

Two more details on our testing of your product:

1. We do not have the admincp folder - it was renamed for security reasons. It seems that you have hardcoded that path into your script.. please use the VB variable/path so it can work with custom-defined admin folders.

2. If we leave as default - all notifications unchecked [latest version - 1.2.2] - the script does _not_ break the 'entryid=' variable.

If we select only the album pictures moderation notification, again - script does not break the entryid

However - if we select any of the following: threads, posts or visitor messages [alone or together] - the script breaks again Dynamics.

Thought the above might help.


Cheers,
aproape

*bump*

the notifications link doesnt show up for me

Please consider to add support for blogs, Links and Downloads Manager and Photopost Pro.

When I click the visitor messages link it only refreshes the home page. Same with users awaiting moderation

By the way, I am using VBSEO. The other links so far seem to work fine otherwise

aproape, all issues you reported are fixed in 1.1.3. Thank you for valuable feedback!
chadi, try 1.1.3 also. I guess your problems are also fixed
Alfa1, can you provide me with link to Photopost Pro?

<a href="http://www.photopost.com" target="_blank">www.photopost.com</a>

2Alfa1:
Can you provide me with links which leads to moderation of items of these two mods?

Thanks. One problem, why does it take you to the admin panel to moderate visitor messages?

Photopost:
Moderate pictures: domain.com/photopost/adm-misc.php?admact=approve
Moderate comments: domain.com/photopost/adm-misc.php?admact=modcom

Links and Download manager:
moderate links: domain.com/forum/local_links.php?action=mod

vbulletin Blog:
moderate blogs: domain.com/forum/blog.php?type=moderated&do=list
Moderate blog comments: domain.com/forum/blog.php?type=moderated&do=comments

In addition to afla's post above, I use Photopost's vbgallery photo script, so I hope you can add these too.

I think, that I need to redesign mod a little...

Hi there FractalizeR!

You're most welcome and.. confirmed!

Indeed - no more Dynamics errors this time ;-)

Marked as [Installed] and I'll continue to provide feedback if we find anything else.. thanks!


Cheers,
aproape

yep it works fine with mine now

I am glad all is working ok ;)