[ABD] Membership Management with Paypal IPN

[DonkeyBike]

Fantastic Mod, it's exactly what I need.

[Qwertyip]

Hello..

My administration section ist working anymore. I cant remove someone, or change their group ect.
I've even restored it back to a point im 100% sure it was working.

Anyone else have this problem?

[spi21]

Hi, just checking to see if this is still being worked on. Thanks

[the pips]

Hi, just checking to see if this is still being worked on. Thanks

Hi,
Yes, I'm still working on it but personal issues has meant I've had to put, what is essentially a hobby, on the back burner. I'm very hopeful that I'll be able to get back to coding very very soon.

Regards
Doug

[kreaper]

Gonna keep and eye on this mod will be exactly what I need once its done!

[the pips]

Just a quick update. I'm finding a little bit more time to work on the mod so I'm hoping to have a new version ready for download very soon now.

Regards
Doug

[alterastro]

Hi

I'm excited by this mod - it is exactly what I need for my club, so thanks!

Quick question though, without having to read through 43 pages - Is it possible to integrate this with a membership that is already running? i.e. can we manually add people that are already members, including renewal date and joining date etc? A batch import from excel would be nice

Thanks again and I'm looking forward to the updates

Nick

[alterastro]

I've tried installing but have a couple of errors using automod and I'm on 3.0.11:

When uploading the zip file to Automod I get:

[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/adm/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/images/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/includes/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/language/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/styles/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/styles/prosilver/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/styles/prosilver/template/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/styles/prosilver/theme/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/language/en/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/language/en/acp/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/language/en/mods/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/includes/acp/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/includes/acp/info/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 292: fread() [function.fread]: Length parameter must be greater than 0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 295: fopen(./../store/mods/membership_management_v1_tmp/root/adm/style/) [function.fopen]: failed to open stream: Is a directory
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_compress.php on line 315: fclose(): supplied argument is not a valid stream resource
[phpBB Debug] PHP Warning: in file [ROOT]/adm/index.php on line 150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3833)
[phpBB Debug] PHP Warning: in file [ROOT]/adm/index.php on line 152: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3833)
[phpBB Debug] PHP Warning: in file [ROOT]/adm/index.php on line 153: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3833)
[phpBB Debug] PHP Warning: in file [ROOT]/adm/index.php on line 154: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3833)

But clicking back shows it has uploaded ok. I went ahead and installed and seemed to go ok, but it failed with one error:

Membership Management
PHP Version: 5.2.17
DBMS: MySQL 5.0.95-log
phpBB3 Version: 3.0.11

Custom Profile Fields
SQL ERROR The used table type doesn't support BLOB/TEXT columns

Is there anything I can do?

Thanking you muchly

Nick

[the pips]

Wow, I can only assume the package is corrupt. I'm currently working on splitting the module into two. Membership and payments. I've already uploaded the membership component (see 1st post) and I'm hoping to get the payment mod tidied away very quickly.

I'd recommend you install the membership element first and get that working the way you want before delving into the mysteries of Paypal

Regards
Doug

[MydnyteSyn]

I've installed this mod but when I run the createMembership.php file, it produces an error.

Membership Management
PHP Version: 5.3.16
DBMS: MySQL(i) 5.1.65-cll
phpBB3 Version: 3.0.11

Adding a new database table: phpbb_membership
SQL 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 '0 DEFAULT 'a' NOT NULL,
1 int(11) DEFAULT '0' NOT NULL,
2 DEFAULT 'o' NOT NU' at line 14

[the pips]

I've installed this mod but when I run the createMembership.php file, it produces an error.

Membership Management
PHP Version: 5.3.16
DBMS: MySQL(i) 5.1.65-cll
phpBB3 Version: 3.0.11

Adding a new database table: phpbb_membership
SQL 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 '0 DEFAULT 'a' NOT NULL,
1 int(11) DEFAULT '0' NOT NULL,
2 DEFAULT 'o' NOT NU' at line 14

Sorry about that. I made the dumb error of making a "simple" change after I'd tested and got it wrong. I've corrected createMembership.php and uploaded the corrected zip.

Regards
Doug

[MydnyteSyn]

Thanks. I downloaded from the first page and re-uploaded everything. Visited the createMembership.php link but nothing happened at all. Also, I am now unable to login to my forum and I also cannot login to the admin CP. As soon as I login, I'm immediately logged out as soon as I click the ACP link or go to the forum index.

[MydnyteSyn]

Also, the instructions say:

If you want to use the Payments system with this mod yo will also need to run createPayment.php. This will set up the configs and create the modules.
Once you've finished installing everything please remember to purge your cache when you've finished.

But there is no createPayment.php file.

In the instructions it says:

Find
Tip: This may be a partial find and not the whole line.

Code: Select all

				$message = $message . '<br /><br />' . sprintf($user->lang['RETURN_INDEX'], '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a>');

Replace with
Tip: Replace the preceding line(s) to find with the following lines.

Code: Select all

				if ($premium_sub_option==1)
				{
					$auth->login($data['username'], $data['new_password']);
					if (empty($user->lang['CONTINUE_APPLICATION']))
					{
						redirect(append_sid("{$phpbb_root_path}application.$phpEx","mode=apply&member=1&r=1&i={$user_id}&g={$config['ms_subscription_group']}"));
					}
					else
					{
						$message = sprintf($user->lang['CONTINUE_APPLICATION'], '<a href="' . append_sid("{$phpbb_root_path}application.$phpEx","mode=apply&member=1&r=1&i={$user_id}&g={$config['ms_subscription_group']}") . '">', '</a>');
					}
				}
				else
				{
					if ($premium_sub_option==2)
					{
						redirect(append_sid("{$phpbb_root_path}application.$phpEx","mode=apply&member=1&r=1&i={$user_id}&g={$config['ms_subscription_group']}"));
					}
					$message = $message . '<br /><br />' . sprintf($user->lang['RETURN_INDEX'], '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a>');
				}
				trigger_error($message);

But, this line:

Code: Select all

trigger_error($message);

is already there. Should there be two instances of trigger_error($message); ? If there should only be the single instance, you might want to remove that line from the instructions to avoid confusion

[MydnyteSyn]

After restoring my forum and making fresh back ups of both the files and the database, I tried installing this mo one more time as it's perfect for the non-profit organization I'm designing a site and forum for. These are the results:

• createMembership.php doesn't do anything. It's just a blank white page.
  
  Cannot access the forum/acp/portal - all blank white pages
  
  Should include edits for subSilver2. I know I'm not the only person using a theme that is based on subSilver2.

I'm going to continue watching this topic as I hope the bugs all get worked out. I really like/need a mod like this.

[alterastro]

Wow, I can only assume the package is corrupt. I'm currently working on splitting the module into two. Membership and payments. I've already uploaded the membership component (see 1st post) and I'm hoping to get the payment mod tidied away very quickly.

I'd recommend you install the membership element first and get that working the way you want before delving into the mysteries of Paypal

Regards
Doug

Many thanks Doug

I uninstalled to original and the Membership component seemed to install without errors but when I click Membership on the board index I get:

General Error
SQL ERROR [ mysql4 ]

Unknown column 'shopping_basket' in 'field list' [1054]

SQL

SELECT shopping_basket FROM phpbb_sessions WHERE session_id = "cfc6ef64b3db4d2b9faf0ca8d4eb54b2"

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/payment_class.php
LINE: 243
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/payment_class.php
LINE: 53
CALL: payment_class->retrieve_shopping_basket()

FILE: [ROOT]/application.php
LINE: 101
CALL: payment_class->__construct()

Any ideas?

Thanks

Nick