[MODDB] Advanced Double Activation Pack

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!
Ideas Centre
User avatar
Martin Truckenbrodt
Registered User
Posts: 3045
Joined: Sun Mar 23, 2003 6:22 pm
Location: Franconia
Name: Martin Truckenbrodt
Contact:

[MODDB] Advanced Double Activation Pack

Post by Martin Truckenbrodt » Sun Oct 14, 2007 9:22 pm

Hello,

the MOD has been validated to the MOD DB. Please look here: http://www.phpbb.com/community/viewtopi ... 9&t=753485

Bye Martin
Last edited by Martin Truckenbrodt on Sat Feb 09, 2008 9:23 am, edited 12 times in total.
Free tutorial: Installing MODs in phpBB 3.0
Advanced Block MOD - Prevent spam on your phpBB 3.0 board with Stop Forum Spam, BotScout, Akismet, Project Honey Pot and several IP-RBL and Domain-RBL DNS blacklists!
My MODs
Use the official phpBB Ideas to vote missing core features!!!

ToXiQ
Registered User
Posts: 69
Joined: Mon Jun 05, 2006 4:54 pm

Re: [RC] Advanced Double Activation Pack

Post by ToXiQ » Mon Oct 15, 2007 8:25 am

Wow, this is great Martin! Will try to find time to implement this on soon on our test database.

regards Walter

User avatar
Martin Truckenbrodt
Registered User
Posts: 3045
Joined: Sun Mar 23, 2003 6:22 pm
Location: Franconia
Name: Martin Truckenbrodt
Contact:

Re: [RC] Advanced Double Activation Pack

Post by Martin Truckenbrodt » Mon Oct 15, 2007 6:56 pm

Hello,
I've updated to version 1.0.3.

Bye Martin
Free tutorial: Installing MODs in phpBB 3.0
Advanced Block MOD - Prevent spam on your phpBB 3.0 board with Stop Forum Spam, BotScout, Akismet, Project Honey Pot and several IP-RBL and Domain-RBL DNS blacklists!
My MODs
Use the official phpBB Ideas to vote missing core features!!!

User avatar
Martin Truckenbrodt
Registered User
Posts: 3045
Joined: Sun Mar 23, 2003 6:22 pm
Location: Franconia
Name: Martin Truckenbrodt
Contact:

Re: [RC] Advanced Double Activation Pack

Post by Martin Truckenbrodt » Tue Oct 16, 2007 11:02 am

Hello,
I've updated to version 1.0.5.

Bye Martin
Free tutorial: Installing MODs in phpBB 3.0
Advanced Block MOD - Prevent spam on your phpBB 3.0 board with Stop Forum Spam, BotScout, Akismet, Project Honey Pot and several IP-RBL and Domain-RBL DNS blacklists!
My MODs
Use the official phpBB Ideas to vote missing core features!!!

ToXiQ
Registered User
Posts: 69
Joined: Mon Jun 05, 2006 4:54 pm

Re: [RC] Advanced Double Activation Pack

Post by ToXiQ » Tue Oct 16, 2007 12:35 pm

you are going to fast for me now :)

keep em going!!!

regards Walter

User avatar
Martin Truckenbrodt
Registered User
Posts: 3045
Joined: Sun Mar 23, 2003 6:22 pm
Location: Franconia
Name: Martin Truckenbrodt
Contact:

Re: [RC] Advanced Double Activation Pack

Post by Martin Truckenbrodt » Tue Oct 16, 2007 2:02 pm

Hello ToXiQ,
the MOD is okay. Just little problems with the MOD validation. :? E.g. I'm a newbie in MODX.

Test and Try and please give me a feedback! :)

Bye Martin
Free tutorial: Installing MODs in phpBB 3.0
Advanced Block MOD - Prevent spam on your phpBB 3.0 board with Stop Forum Spam, BotScout, Akismet, Project Honey Pot and several IP-RBL and Domain-RBL DNS blacklists!
My MODs
Use the official phpBB Ideas to vote missing core features!!!

ToXiQ
Registered User
Posts: 69
Joined: Mon Jun 05, 2006 4:54 pm

Re: [RC] Advanced Double Activation Pack

Post by ToXiQ » Tue Oct 16, 2007 2:46 pm

Hello Martin,

I can only try this weekend :( I am in some exams these days where I have to focus on!

I let you know this weekend.

regards Walter

User avatar
rossnick
Registered User
Posts: 52
Joined: Thu Nov 22, 2001 5:55 pm
Location: Québec, Canada

Re: [RC] Advanced Double Activation Pack

Post by rossnick » Tue Oct 16, 2007 3:11 pm

Hi Martin !

Thanks for this mod...

Unfortunatly, when I open the xml file, I can't see the mod as with other mods in xml format... I've tried with FF and IE...
Nicolas Ross
640kb Productions, Personal blog (not very updated often)

In most countries selling harmful things
like drugs is punishable. Then howcome people
can sell Microsoft software and go unpunished?

User avatar
Martin Truckenbrodt
Registered User
Posts: 3045
Joined: Sun Mar 23, 2003 6:22 pm
Location: Franconia
Name: Martin Truckenbrodt
Contact:

Re: [RC] Advanced Double Activation Pack

Post by Martin Truckenbrodt » Tue Oct 16, 2007 5:55 pm

Hello ToXiQ,
Exams always are more important! Tomorrow I will start learning for a exam (MS 70-296).

Hello rossnick,
I still have the same problem. I imagine there is a How-To-Topic somewhere here? :|

[edit 18-11-2007:] You need the correct modx.prosilver.en.xsl file.

http://www.phpbb.com/community/viewtopi ... 1&t=540287

Forget the information under http://www.phpbb.com/mods/modx/ . Most (all ? ) of this information is written only for phpBB2. :roll:

install.txt code deleted.[/edit]

Bye Martin
Last edited by Martin Truckenbrodt on Sun Nov 18, 2007 9:53 pm, edited 2 times in total.
Free tutorial: Installing MODs in phpBB 3.0
Advanced Block MOD - Prevent spam on your phpBB 3.0 board with Stop Forum Spam, BotScout, Akismet, Project Honey Pot and several IP-RBL and Domain-RBL DNS blacklists!
My MODs
Use the official phpBB Ideas to vote missing core features!!!

semag
Registered User
Posts: 8
Joined: Fri Nov 16, 2007 6:30 am

Re: [RC] Advanced Double Activation Pack

Post by semag » Fri Nov 16, 2007 7:03 am

Martin-

I've been very interested in this feature as it is the only way to get a semi-secure idea of your userbase - i.e. they'll give you a valid Email and then you get to compare that domain to a customer base.

I've been trying to install it, but run into an error the first time my test user tries to click the activation link. I get an SQL error saying that "user_level" is not a valid part of the "where" clause, and I believe it's in this part of the code (in the includes/ucp/ucp_activate.php directory) :

Code: Select all

$sql = 'SELECT username, user_email, user_lang, user_notify_type
            FROM ' . USERS_TABLE . '
            WHERE user_level = ' . ADMIN;
Has the underlying database in phbb3 changed since you wrote this?

semag
Registered User
Posts: 8
Joined: Fri Nov 16, 2007 6:30 am

Re: [RC] Advanced Double Activation Pack

Post by semag » Fri Nov 16, 2007 7:16 pm

Ok.... so I've sort of hacked up the part that I just posted, and I got the first part of the activation working:

I changed it from above, to:

Code: Select all

            $sql = 'SELECT username, user_email, user_lang, user_notify_type
            FROM ' . USERS_TABLE . '
            WHERE user_type = 3';
I changed "user_level" to "user_type" and also looked at the database so I'm assuming the ADMIN TYPE is 3.

However, at this point I'm getting a page that says:

Code: Select all

Information

The activation key you supplied does not match any in the database.
I looked in the DB, and the key has slightly changed, to this:

Code: Select all

+------------------+
| user_actkey      |
+------------------+
|  . 45L7V38NZD .  | 
I haven't looked into this yet....

semag
Registered User
Posts: 8
Joined: Fri Nov 16, 2007 6:30 am

Re: [RC] Advanced Double Activation Pack

Post by semag » Fri Nov 16, 2007 10:17 pm

Just in case anyone is still paying attention. I've been able to hack this together.

First I changed this line:

Code: Select all

'U_ACTIVATE' => "$server_url/ucp.$phpEx?mode=activate&u={$user_row['user_id']}&k=$user_actkey&acc_admin",
And added a "=1" at the end.

Then, I changed the following line to remove the ". " from before and after the User act_key

Code: Select all

                       $sql = 'UPDATE ' . USERS_TABLE . "
                       SET user_actkey = ' . $user_actkey . '
                       WHERE user_id = {$user_row['user_id']}";
So that it looks like this

Code: Select all

                       $sql = 'UPDATE ' . USERS_TABLE . "
                       SET user_actkey = '$user_actkey'
                       WHERE user_id = {$user_row['user_id']}";
This seems to have everything working... although I'd really like to know that I didn't screw anything up. Any help out there?

User avatar
Martin Truckenbrodt
Registered User
Posts: 3045
Joined: Sun Mar 23, 2003 6:22 pm
Location: Franconia
Name: Martin Truckenbrodt
Contact:

Re: [RC] Advanced Double Activation Pack

Post by Martin Truckenbrodt » Sat Nov 17, 2007 9:26 am

Hello semag,
sorry, perhaps the txt install file is not okay. Please look at the xml file.

I will check it next days for you. And I will compare it with the code on the support and test forum on my website.

Please give me samoe days.

Bye Martin
Free tutorial: Installing MODs in phpBB 3.0
Advanced Block MOD - Prevent spam on your phpBB 3.0 board with Stop Forum Spam, BotScout, Akismet, Project Honey Pot and several IP-RBL and Domain-RBL DNS blacklists!
My MODs
Use the official phpBB Ideas to vote missing core features!!!

User avatar
Martin Truckenbrodt
Registered User
Posts: 3045
Joined: Sun Mar 23, 2003 6:22 pm
Location: Franconia
Name: Martin Truckenbrodt
Contact:

Re: [RC] Advanced Double Activation Pack

Post by Martin Truckenbrodt » Sun Nov 18, 2007 10:01 pm

semag wrote:Ok.... so I've sort of hacked up the part that I just posted, and I got the first part of the activation working:

I changed it from above, to:

Code: Select all

            $sql = 'SELECT username, user_email, user_lang, user_notify_type
            FROM ' . USERS_TABLE . '
            WHERE user_type = 3';
....
Hello,
there is an failure in the install.txt. I've deleted teh code above cause now I'm only workiung with the xml file.
Use this code:

Code: Select all

//Advanced Double Activation Pack begin
		else if ($config['require_activation'] == USER_ACTIVATION_USER_ADMIN && !$update_password && !$acc_admin)
		{

			$sql = 'SELECT username, user_email, user_lang, user_notify_type 
				FROM ' . USERS_TABLE . '
				WHERE user_type = ' . USER_FOUNDER;
			
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not select Administrators', '', __LINE__, __FILE__, $sql);
			}
			
			include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

			$messenger = new messenger(false);

			$messenger->template('admin_activate', $user_row['user_lang']);

			while ($admin_row = $db->sql_fetchrow($result))
			{

				$server_url = generate_board_url();

				$messenger->to(trim($admin_row['user_email']), trim($admin_row['username']));

				$messenger->headers('X-AntiAbuse: Board servername - ' . $config['server_name']);
				$messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);
				$messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);
				$messenger->headers('X-AntiAbuse: User IP - ' . $user->ip);

				$messenger->assign_vars(array(
					'USERNAME'			=> htmlspecialchars_decode($user_row['username']),
					'U_USER_DETAILS'	=> "$server_url/memberlist.$phpEx?mode=viewprofile&u={$user_row['user_id']}",
					'U_ACTIVATE'		=> "$server_url/ucp.$phpEx?mode=activate&u={$user_row['user_id']}&k=$user_actkey&acc_admin=1",
					'U_VERIFY' 			=> "$server_url/adm/index.$phpEx?i=users$mode=verify&u={$user_row['user_id']}")

				);

				$messenger->send($admin_row['user_notify_type']);

				$message = 'ACCOUNT_INACTIVE_USER_ADMIN';

			}

		}
//Advanced Double Activation Pack end
Now I'm working on the next version of the MOD. I hope to finish it this week. It's still hard for me. I have no former experience in MODX. The MOD team member validating my MOD says that I should us more IN LINE edits.

Bye Martin
Free tutorial: Installing MODs in phpBB 3.0
Advanced Block MOD - Prevent spam on your phpBB 3.0 board with Stop Forum Spam, BotScout, Akismet, Project Honey Pot and several IP-RBL and Domain-RBL DNS blacklists!
My MODs
Use the official phpBB Ideas to vote missing core features!!!

lathamjohnp
Registered User
Posts: 4
Joined: Tue Jan 16, 2007 10:05 am

Re: [RC] Advanced Double Activation Pack

Post by lathamjohnp » Fri Dec 14, 2007 8:43 pm

Martin,

I'm sure you are busy, but do you have any updates on this MOD?

I think it would be fantastic - I don't understand why it isn't a standard feature of phpBB!

FWIW I could never get the Double Activation mod working in phpBB2, maybe this will be better?

Cheers,
John

Locked

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