Moderator Needed

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
User avatar
DoYouSpeakWak
Registered User
Posts: 2310
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Contact:

Re: Moderator Needed

Post by DoYouSpeakWak »

Hey Rich

I have a bit of problem with this mod

On a 3.0.0 board i had this installed as the install.xml says (with the function in functions.php) and everything was fine. I then claned up the board and updated it. Added this mod again, but this time i added what goes in functions.php to index.php and to mcp.php

And this happend at index and mcp

Code: Select all

Time : 1.038s | 11 Queries | GZIP : On | Memory Usage: 826.93 KiB
SQL Report_1262691279167.png
SQL Report_1262691279167.png (7.84 KiB) Viewed 1125 times
If i remove the stuff from index and mcp it loads like this

Code: Select all

Time : 0.042s | 9 Queries | GZIP : On | Memory Usage: 766.84 KiB
And the sql query from above goes away.

There are no post or topics reported or anything else. Well nothing shows up in mcp or index. Even though the 3.0.0 had debug off im pretty sure the load wasnt that high before. Or on phpbb3bbcodes.com were this is also installed similar to this.

Any idea why ?

P.s If added to functions.php again it still has the high load. So i guess it must have been like this all the time. Well i hope there is a way to bring down the load without removing this mod. Its very practical.
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid services. 10+ years of experience with phpBB3 and as System Administrator.
User avatar
RMcGirr83
Former Team Member
Posts: 21497
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Moderator Needed

Post by RMcGirr83 »

Try optimizing those tables in phpbbmyadmin...then again that is quite a lot of forums. Not sure.

here's my sql report
mod_needed.jpg
mod_needed.jpg (34.68 KiB) Viewed 1123 times
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
The Future
Registered User
Posts: 5
Joined: Sun Dec 27, 2009 5:27 am
Contact:

Re: Moderator Needed

Post by The Future »

Nice MOD. I needed something like this for my forum.
User avatar
DoYouSpeakWak
Registered User
Posts: 2310
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Contact:

Re: Moderator Needed

Post by DoYouSpeakWak »

Thanks for the advise

That got it down a bit, But this mod is stilling killing the load time.

Code: Select all

Time : 0.720s | 11 Queries | GZIP : On | Memory Usage: 940.53 KiB
Its a bit strange to me, Of couse there are alot of posts on the board. 325K compared to your site and phpbb3bbcodes.com but can that really add 16 times more load ? I guess it can.

Making a tweak to only check certain forums doesnt seem to be a solution either, would properly add another query. Not even sure its posible.
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid services. 10+ years of experience with phpBB3 and as System Administrator.
User avatar
RMcGirr83
Former Team Member
Posts: 21497
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Moderator Needed

Post by RMcGirr83 »

DYSW, let's try something if you don't mind.

OPEN

includes/moderator_needed.php

FIND

Code: Select all

			$sql_where = ' WHERE (' . $db->sql_in_set('forum_id', get_forum_list('m_approve')) . ' or ' . $db->sql_in_set('forum_id', get_forum_list('m_report')) . ') AND (post_reported = 1 or post_approved = 0)';
REPLACE WITH

Code: Select all

			$sql_where = ' WHERE (' . $db->sql_in_set('forum_id', array_merge(array_intersect(get_forum_list('m_approve'), get_forum_list('m_report')))) . ') AND (post_reported = 1 or post_approved = 0)';

does that help any?
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
User avatar
DoYouSpeakWak
Registered User
Posts: 2310
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Contact:

Re: Moderator Needed

Post by DoYouSpeakWak »

RMcGirr83 wrote:DYSW, let's try something if you don't mind.

OPEN

includes/moderator_needed.php

FIND

Code: Select all

			$sql_where = ' WHERE (' . $db->sql_in_set('forum_id', get_forum_list('m_approve')) . ' or ' . $db->sql_in_set('forum_id', get_forum_list('m_report')) . ') AND (post_reported = 1 or post_approved = 0)';
REPLACE WITH

Code: Select all

			$sql_where = ' WHERE (' . $db->sql_in_set('forum_id', array_merge(array_intersect(get_forum_list('m_approve'), get_forum_list('m_report')))) . ') AND (post_reported = 1 or post_approved = 0)';

does that help any?
Good question. Ill try it soonish, gotta get my cpu back in the localserver first.No more 800mhz duron :D
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid services. 10+ years of experience with phpBB3 and as System Administrator.
Lord Phobos
Registered User
Posts: 613
Joined: Tue May 18, 2004 11:41 pm

Re: Moderator Needed

Post by Lord Phobos »

Hi!

I have an old version ( 1.0.2 ) of this MOD installed, but in the /contrib folder I only find update_103a_104.xml .

Can you provide me a file to upgrade from 1.0.2 to 1.0.3?

Thanks.
User avatar
DoYouSpeakWak
Registered User
Posts: 2310
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Contact:

Re: Moderator Needed

Post by DoYouSpeakWak »

RMcGirr83 wrote:DYSW, let's try something if you don't mind.

OPEN

includes/moderator_needed.php

FIND

Code: Select all

			$sql_where = ' WHERE (' . $db->sql_in_set('forum_id', get_forum_list('m_approve')) . ' or ' . $db->sql_in_set('forum_id', get_forum_list('m_report')) . ') AND (post_reported = 1 or post_approved = 0)';
REPLACE WITH

Code: Select all

			$sql_where = ' WHERE (' . $db->sql_in_set('forum_id', array_merge(array_intersect(get_forum_list('m_approve'), get_forum_list('m_report')))) . ') AND (post_reported = 1 or post_approved = 0)';

does that help any?
No there is no diffrence to the load time and memoery use. :cry:
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid services. 10+ years of experience with phpBB3 and as System Administrator.
User avatar
RMcGirr83
Former Team Member
Posts: 21497
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Moderator Needed

Post by RMcGirr83 »

Nothing I can do...sorry.
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
User avatar
DoYouSpeakWak
Registered User
Posts: 2310
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Contact:

Re: Moderator Needed

Post by DoYouSpeakWak »

RMcGirr83 wrote:Nothing I can do...sorry.
You tried, i just hope i can give some help back at some point. :)
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid services. 10+ years of experience with phpBB3 and as System Administrator.
Lord Phobos
Registered User
Posts: 613
Joined: Tue May 18, 2004 11:41 pm

Re: Moderator Needed

Post by Lord Phobos »

Lord Phobos wrote:Hi!

I have an old version ( 1.0.2 ) of this MOD installed, but in the /contrib folder I only find update_103a_104.xml .

Can you provide me a file to upgrade from 1.0.2 to 1.0.3?

Thanks.
Please?
User avatar
RMcGirr83
Former Team Member
Posts: 21497
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Moderator Needed

Post by RMcGirr83 »

Just uninstall it and install the newest version

Version 1.0.2
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
vladale
Registered User
Posts: 10
Joined: Wed Oct 11, 2006 3:01 pm

Re: Moderator Needed

Post by vladale »

Is there a option to notify moderators / administrators by e-mail for all posts that are in moderation queue?
User avatar
RMcGirr83
Former Team Member
Posts: 21497
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Moderator Needed

Post by RMcGirr83 »

Not with this mod there isn't. There another similar mod floating around on here that, IIRC, does though.
Appreciate the extensions/mods/support then buy me a beerImage
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
romeo_piter
Registered User
Posts: 83
Joined: Mon Nov 09, 2009 7:11 pm
Location: Russia

Re: Moderator Needed

Post by romeo_piter »

Could you please give me a link to 1.0.3 mod version for 3.0.5?
Locked

Return to “[3.0.x] MOD Database Releases”