[FEATURE] Require Adminstrator Approval on Registration

[bootsy52]

I've made up a patch that forces the activation of any new users who have registered by an administrator before they can log in.

You get a new option in the Administrator Panel where you can activate this.
GlobalConfiguration->Site->Require Administrator Activation

The diff is made agains Mambo 4.5.2.3 and also works if you have applied my dynamic_url patch

The patch is here:

http://smp-synergie.de/patches/activ...istrator.patch

For german users of Mambo there exists an additional patch for the German formal Language File,
to apply this please first apply the common patch above and then this

http://smp-synergie.de/patches/activ...r-german.patch

Apply all patches by

cd $MAMBO_INSTALLDIR
patch -p0 < activation-by-administrator.patch
patch -p0 < activation-by-administrator-german.patch

Maybe someone has a the same urgent need for this than I got

Carsten

P.S. BTW, anyone interested to have more fields on the registration page ? Like Company,Street,City,ZipCode,Phone ? I just ask, because I have to do that, too for my site, so I can make the changes common enough to share it among others

[bootsy52]

This patch is an enhanced version of the above requiring quite a bit more changes to Mambo, so if you want to use this version of the patch you have to make changes to your database as well (but it's just to add 1 column).

So here is the description of what it does:

1) You have a new option under GlobalConfiguration->Site: Require Administrator Activation
(same as in the patch above) which also adds a new configuration variable to configuration.php

You can now use 4 combinations of the options "Require Administrator Activation" and "Use New Account Activation"

Case 1

Use New Account Activation => NO
Require Administrator Activation => NO

Same behavior as specifiying "Use New Account Activation" => NO without the patch applied.
Any new user can register without needing to activate the account by clicking on the activation link.

Case 2

Use New Account Activation => YES
Require Administrator Activation => NO

Same behavior as specifiying "Use New Account Activation" => YES without the patch applied.
Any new user receives an email containing a link to activate the account.

Case 3

Use New Account Activation => YES
Require Administrator Activation => YES

Any new user who registers receives a confirmation link which has to clicked to confirm that registration is done by the person who owns this email address and that the supplied data is correct.

Once the User has confirmed his/her registration an E-mail is send out to the Administrators containing an activation link to finally activate this account after the user/data has been reviewed.

Case 4

Use New Account Activation => NO
Require Administrator Activation => YES

Any new user who registers receives an confirmation E-mail that his/her registration has been received and that the registration has to be activated by an administrative person.

The administrators receive an E-mail informing them that a new user has registered containing an activation link to activate the account after they have reviewed the user/data.

2) You will got a new column in the users administration named "Confirmed by User" which shows the state of the user confirmation of the registration.

You can also use the normal block/unblock Link activate a user as usual this also sets "Confirmed by User" field to active

To apply this patch do the following:

1. Download it from
http://smp-synergie.de/patches/activ...enhanced.patch

2. cd $MAMBO_INSTALLDIR
3. patch -p0 < activation-by-administrator-enhanced.patch

If you have the "german formal" Language pack installed you can apply the following patch in the same way after you have applied the above patch.

Download it from:
http://smp-synergie.de/patches/activ...-germany.patch

You now have to add the column "AdministratorActivation" to your mos_users table (or whatever prefix you have chosen on installation)

Download for MySQL from:
http://smp-synergie.de/patches/activ...nced-mysql.sql

For a MySQL installation you can do the change by issuing the following SQL command:

ALTER TABLE mos_users ADD COLUMN AdministratorActivation varchar(100) AFTER activation;

Have fun, hope someone has a need for this.
Also I would be glad if this change could make it into the Mambo core.

Carsten

[bootsy52]

For those of you unfamilar with patching (or don't have a unix based OS) I've uploaded a zip archive containing the patch together with the already patched files, so you could simply unzip this file in the MAMBO_INSTALLATION directory and you're done

Download from here:

http://smp-synergie.de/patches/Activ...inistrator.zip

[eskim]

Great stuff!
One question, this works only in english o german istalled languages, how can modify it to work with other languages.
Thanx ))

[bootsy52]

Just add and translate the following constants
o the language file language/language.php

DEFINE('_SEND_SUB_ACTIVATE_BYADMINISTRATOR'
DEFINE('_SEND_SUB_ACTIVATE_COMPLETE'
DEFINE('_USEND_MSG_ACTIVATE_BYADMINISTRATOR'
DEFINE('_USEND_MSG_ACTIVATE_COMPLETE'
DEFINE('_ASEND_MSG_ACTIVATE_BYADMINISTRATOR'
DEFINE('_USEND_MSG_ACTIVATE_COMBINED'
DEFINE('_REG_COMPLETE_ACTIVATE_BYADMINISTRATOR'
DEFINE('_REG_COMPLETE_ACTIVATE_BYUSER'
DEFINE('_REG_ACTIVATE_COMPLETE_BYUSER'

[hbmarar]

Originally Posted by bootsy52

P.S. BTW, anyone interested to have more fields on the registration page ? Like Company,Street,City,ZipCode,Phone ? I just ask, because I have to do that, too for my site, so I can make the changes common enough to share it among others

hi,

Thanks bootsy52. I was looking for such a feature and if you have any new version releae with above entioned please do update me.

Though I have not installed, I would like to thank you for your tweaking was the exact thing i was looking for.

The all I can do is wishing you a nice day and great time and thanks once again for sharing it.

Regards
Harish

[bootsy52]

The latest Version should be always available from here:

http://smp-synergie.de/patches/Activ...inistrator.zip

[hbmarar]

hi,

I am having a problem with your Activation-by-administraor.I have attached a screenshot of the file in the frontend.

please do help me and i believe you would find some time to sugest me what i should be doing.

Harish


NO problems for now.i just missed the AdministratorActivatioon table yesterday as Indian team was killing the sri lankan team in cricket.

Sorry

[eendsley]

Can this be made into a component, module, mambot that runs the scripts to do the complete install without patch/upload/modify?

[bootsy52]

Originally Posted by hbmarar

hi,

I am having a problem with your Activation-by-administraor.I have attached a screenshot of the file in the frontend.

please do help me and i believe you would find some time to sugest me what i should be doing.

Harish

Where should that screenshot be ?

[bootsy52]

I'm not sure if this can be made up into a component or mambot.

I'll take a look at it

[MrFullSwing]

Can this be used at the same time as your extended_registration modification? If the extended_registration is installed first & then the activation_by_administrator you do not see the extended fields in the backend admin for users. If you install the activation_by_administrator first & then the extended_registration you then cannot login to the backend admin.

Obviously both modifiactions replace some of the same mambo files. Is it possible that you could create a zip file that has the mambo files modified for both your modifications to work togeather??

Thanks.

[bootsy52]

Originally Posted by MrFullSwing

Obviously both modifiactions replace some of the same mambo files. Is it possible that you could create a zip file that has the mambo files modified for both your modifications to work togeather??

Thanks.

The Extended Registration includes also the Activation-by-Administrator patch,
remember that this patch was made against Mambo-4.5.2.3

So if you download:

http://smp-synergie.de/patches/Exten...ion-Fields.zip

you get both the Activation-by-Administrator Patch and Extended-Registration-Fields Patch, installing this is sufficient to get both.

[MrFullSwing]

Thanks

[djkac]

Sorry for the total nOOb question but how do I:

Add the following columns to the "mos_users" table:

company varchar(80) NOT NULL default '',
address varchar(100) NOT NULL default '',
zipcode int NOT NULL default '0',
city varchar(50) NOT NULL default '',
phone varchar(50) NOT NULL default ''

Is there a tutorial somewhere you can point me to...please?

[djkac]

..nevermind. I think I figured it out.

[Bon@karl]

Hi Carsten,
I want to patch my Joomla 1.04 installation with your fine Activation-by-Administrator, but while doing so, I get an error. The System let me know:

Warning: Invalid argument supplied for foreach() in /web/includes/frontend.php on line 64

I tested it out. I copied file per file back from my backup. As I copied the joomla.php back, the error disappeared.

Do you something know about this Problem, or does somewhere a component or modul exist where this error occurs? Could you send me the changes you made in this File?

Next step is to try the Patch in an new clean installation, and then install all my used modules and componentes.

The activation works fine with the original joomla.php, but when I click on "fastactivation" in the eMail the system send me, it tells me that no such account exist. If I approve the user by the admin-interface, the user don't get a message, that his account is active.

I hope you could help me. If you need files, or other informations, please let me know.

Best regards from Trier (Germany)
Mathias

[Bon@karl]

STOP...

I did find the Problem... while uploading the patch via FTP again, I found some backupfiles including a backup of joomla.php. JACL made the backup. So I deleted JACL, and patch again... great, works fine.

So, if someone use JACL, first delet the modul, patch the system, and install the modul again.

Great Patch... :-D

Best regards
Mathias

[Bon@karl]

Attention. Groups and Accesslevel will be deleted while uninstalling JACL.

Best regards
Mathias

[bootsy52]

Nice, I just thought I had to work during christmas and new year :-)
BTW, for all others, I'm not available until 01th of 2006
Best regards from Lemgo (Germany)