[ABD] Approve Mod

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
kenji
Registered User
Posts: 40
Joined: Thu Oct 10, 2002 7:48 am

Post by kenji »

i have tested this MOD and it seems to be fine without interfering the existing flow of the forum. :P

Aceman,
Can you please help to allow notification of poster via email (instead of PM) once a topic/post has been approve?

Thanks a lot.
fishfreek
Registered User
Posts: 695
Joined: Tue May 14, 2002 3:05 pm
Location: Virginia
Contact:

Post by fishfreek »

kenji,

Yes I said that in my post.
While I dont doub this mod has some database changes usually mods include a php script taht you upload and run that makes these changes for you.


Now since i have yet to download this mod I dont know if there was a db install script or if there where some mysql commands that where in the install script that needed to be run.

If there is not a db install script it might be a good idea aceman to add that to the final release to make it easier for those less adept at making db changes.
Have you joined the PetAdvice Network?

Are you in or around the Shenandoah Valley area? If so ask me how to join our local Shenandoah Valley aquarium group.
kenji
Registered User
Posts: 40
Joined: Thu Oct 10, 2002 7:48 am

Post by kenji »

Opps. Sorry :oops:

Yeah,
The best is when it's release along with phpBB 2.0.5 :P
Kenji
Morgy
Registered User
Posts: 20
Joined: Thu Jun 06, 2002 6:19 pm

Post by Morgy »

fishfreek wrote: If you do not have FTP access to the server then you will have to get someone who does have that access level to install the mod for you.

Fishfreak and kenji,

I have fpt access to www.ourserver.ch/mypage and know how to edit and correctly upload php files.

But I don't have MySQL access to the database of www.ourserver.ch

Morgy
AceMan
Registered User
Posts: 337
Joined: Thu Nov 15, 2001 6:47 am
Contact:

Post by AceMan »

someone try this on a test forum?...

add a new file w/ this , then goto it in your browser, then delete this file
<?php

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//

if (!$userdata['session_logged_in'])
{
redirect(append_sid("login.$phpEx", true));
}
else if ($userdata['user_level'] != ADMIN)
{
message_die(GENERAL_MESSAGE, $lang['Not_admin']);
}

$sql = "DROP TABLE IF EXISTS phpbb_approve_forums;
CREATE TABLE phpbb_approve_forums (
forum_id smallint(5) unsigned NOT NULL default '0',
enabled tinyint(1) NOT NULL default '0',
approve_posts tinyint(1) NOT NULL default '0',
approve_topics tinyint(1) NOT NULL default '0',
approve_users tinyint(1) NOT NULL default '0',
approve_poste tinyint(1) NOT NULL default '0',
approve_topice tinyint(1) NOT NULL default '0',
approve_notify tinyint(1) NOT NULL default '0',
approve_notify_approval tinyint(1) NOT NULL default '0',
approve_notify_type tinyint(1) NOT NULL default '0',
approve_notify_message tinyint(1) NOT NULL default '0',
approve_notify_message_len smallint(5) NOT NULL default '500',
approve_notify_user varchar(255) NOT NULL default '0',
approve_notify_posts tinyint(1) NOT NULL default '0',
approve_notify_poste tinyint(1) NOT NULL default '0',
approve_notify_topics tinyint(1) NOT NULL default '0',
approve_notify_topice tinyint(1) NOT NULL default '0',
PRIMARY KEY (forum_id)
) TYPE=MyISAM;";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_MESSAGE, 'Error creating new tables');
}

$sql = "DROP TABLE IF EXISTS phpbb_approve_posts;
CREATE TABLE phpbb_approve_posts (
approval_id mediumint(8) unsigned NOT NULL auto_increment,
topic_id mediumint(8) unsigned NOT NULL default '0',
post_id mediumint(8) unsigned NOT NULL default '0',
is_topic tinyint(1) NOT NULL default '0',
is_post tinyint(1) NOT NULL default '0',
poster_id mediumint(8) NOT NULL default '0',
PRIMARY KEY (approval_id),
KEY post_id (post_id),
KEY topic_id (topic_id)
) TYPE=MyISAM;";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_MESSAGE, 'Error creating new tables');
}

$sql = "DROP TABLE IF EXISTS phpbb_approve_topics;
CREATE TABLE phpbb_approve_topics (
topic_id mediumint(8) unsigned NOT NULL default '0',
approve_moderate tinyint(1) NOT NULL default '0',
PRIMARY KEY (topic_id)
) TYPE=MyISAM;";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_MESSAGE, 'Error creating new tables');
}

$sql = "DROP TABLE IF EXISTS phpbb_approve_users;
CREATE TABLE phpbb_approve_users (
user_id mediumint(8) NOT NULL default '0',
approve_moderate tinyint(1) NOT NULL default '0',
PRIMARY KEY (user_id)
) TYPE=MyISAM;";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_MESSAGE, 'Error creating new tables');
}

echo("Tables Added!");
?>
AceMan
Registered User
Posts: 337
Joined: Thu Nov 15, 2001 6:47 am
Contact:

Post by AceMan »

kenji, I didn't do email notify on the user becuse they could just turn on the notify-via-email when a new PM shows up

anyone else really need this feature?
kenji
Registered User
Posts: 40
Joined: Thu Oct 10, 2002 7:48 am

Post by kenji »

but there are ppl who dont wish to have the system to notify them upon new PM(s). This is becoz they don't want the system to "spam" them whenever there's a new PM.

Imagine, in a day, there are 10 PM for one particular user and thus, he wil receives 10 email from the system which not very healthy. :P

Therefore, upon approval, email is a much better way of notify the poster.

Aceman,
Which part of the code i shall change if i want an email to be send out instead of PM. Please help. :?:

Thanks.
Kenji
JLB
Registered User
Posts: 72
Joined: Sat Jan 11, 2003 12:20 pm
Location: France

What about if Mod Post Notification is installed?

Post by JLB »

What about if Mod Post Notification is installed? http://www.phpbb.com/phpBB/viewtopic.php?t=72781

Can both mods work together? Won't the moderators be notified twice when a forum is moderated?

thanks
kenji
Registered User
Posts: 40
Joined: Thu Oct 10, 2002 7:48 am

Post by kenji »

i'm not sure though. need Aceman to answer :wink:
but that mod is kinda complex as it needs 45 minutes to install.

it's not necessary though. maybe Aceman have an easier solution to that.

thanks JLB.
Kenji
kenji
Registered User
Posts: 40
Joined: Thu Oct 10, 2002 7:48 am

Post by kenji »

Aceman,

I'm not sure if it is a bug but when i click on "Find all posts by member", it shows all the topic/post posted by member including those that are not approve.

The search function is fine. Did searched the non-approve topic but somehow it didn't show it out.

Thanks.
Kenji
AceMan
Registered User
Posts: 337
Joined: Thu Nov 15, 2001 6:47 am
Contact:

Post by AceMan »

kenji, please research ALL search functionality w/ non-approve posts, topics, and in forums set for approval & post your results here.. thanks!


as far as having the system e-mail USER's, i'll add the option somehow if I can find out a way of being non-obtrusive to the user.
fishfreek
Registered User
Posts: 695
Joined: Tue May 14, 2002 3:05 pm
Location: Virginia
Contact:

Post by fishfreek »

In my view the user should always have the ability to turn off e-mail notify on any item. Simular to the way they can elect to not get e-mail notify of nwe PM's or new replys to topics.

I myself get hundreds of e-mails per day and dont mind but I know of others who have a cow if they get more than 10.

Having the ability to turn it off would be the least obtrusive way possible in my book.
Have you joined the PetAdvice Network?

Are you in or around the Shenandoah Valley area? If so ask me how to join our local Shenandoah Valley aquarium group.
kenji
Registered User
Posts: 40
Joined: Thu Oct 10, 2002 7:48 am

Post by kenji »

Hi,

Went thru the whole MOD and all i can say is that the flow of the MOD is good. :D

Beside the one i post earlier regarding the "find all post by member", there's another one i came upon which the message the notification of new PM (once the post has been approve).

Here it says..
You have received a new private message to your account on "" and you
have requested that you be notified on this event. You can view your new
message by clicking on the following link:

Parameter was not pass to the email (denote "")

I will continue to test on other possibility.
Wat abt you, Aceman, is the MOD working correctly on your side?

Thanks.
Kenji
kenji
Registered User
Posts: 40
Joined: Thu Oct 10, 2002 7:48 am

Post by kenji »

There's already an option in our profile whereby we can choose whether we want to be notify upon new PM.

"Notify on new Private Message"

But seriously, i think upon approval, an email should be sent out instead :P .
Kenji
fishfreek
Registered User
Posts: 695
Joined: Tue May 14, 2002 3:05 pm
Location: Virginia
Contact:

Post by fishfreek »

kenji wrote: There's already an option in our profile whereby we can choose whether we want to be notify upon new PM.

"Notify on new Private Message"

But seriously, i think upon approval, an email should be sent out instead :P .


Right. And that is why there should be an option that says smething like

"Notify when posts have been approved"

or somethign like that in the profile as a on/off flaged item.
Have you joined the PetAdvice Network?

Are you in or around the Shenandoah Valley area? If so ask me how to join our local Shenandoah Valley aquarium group.
Locked

Return to “[2.0.x] MODs in Development”