[ABD] Membership Management with Paypal IPN

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Locked
baller1234
Registered User
Posts: 129
Joined: Sat May 29, 2010 9:43 am

Re: [Beta] Membership Management with Paypal IPN

Post by baller1234 »

still doesnt work.. I think this is wrong:

Code: Select all

   '0.1.0-beta' => array(
      // only change is to add the shopping basket to the sessions table
      'table_column_add' => array(
         array('phpbb3_sessions', 'shopping_basket', array('MTEXT_UNI', '')),
      ),
   },
mind the last line..

Code: Select all

 },
When i replaced it with

Code: Select all

)
the installer worked.. Dont think its a blob error?

The edit in cron.php broke my cron.php.

In the install file it says after:

Code: Select all

		}
			}
		}
But i think it should be

Code: Select all

			}
			}
		}
	break;
Because now cron.php is functioning normal again..


Also, i tested it with the sandbox.. but you can only pay with a creditcard and not with your email adres. Is there a way to adjust that? Also, an option to set the application form off would be nice. Its not needed on every forum?

More inspiration:
This mod uses subscriptions with just an email adres, and group add.. Its just outdated, take a look, maby some inspiration: http://bbs.loewen.com.sg/viewtopic.php?t=3607
User avatar
Blue Blood
Registered User
Posts: 767
Joined: Sat Apr 11, 2009 7:09 am
Location: U§A
Name: Blue Blood
Contact:

Re: [Beta] Membership Management with Paypal IPN

Post by Blue Blood »

uninstall is not removing the Custom profile fields
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [Beta] Membership Management with Paypal IPN

Post by the pips »

baller1234 wrote:still doesnt work.. I think this is wrong:

Code: Select all

   '0.1.0-beta' => array(
      // only change is to add the shopping basket to the sessions table
      'table_column_add' => array(
         array('phpbb3_sessions', 'shopping_basket', array('MTEXT_UNI', '')),
      ),
   },
mind the last line..

Code: Select all

 },
When i replaced it with

Code: Select all

)
the installer worked.. Dont think its a blob error?

The edit in cron.php broke my cron.php.

In the install file it says after:

Code: Select all

		}
			}
		}
But i think it should be

Code: Select all

			}
			}
		}
	break;
Because now cron.php is functioning normal again..


Also, i tested it with the sandbox.. but you can only pay with a creditcard and not with your email adres. Is there a way to adjust that? Also, an option to set the application form off would be nice. Its not needed on every forum?

More inspiration:
This mod uses subscriptions with just an email adres, and group add.. Its just outdated, take a look, maby some inspiration: http://bbs.loewen.com.sg/viewtopic.php?t=3607
Thanks for your feedback, it's much appreciated. I've been fully occupied with other demands on my time but I'll try to upload a new package this evening.

Payment without Paypal account
As I promised I've done a bit of digging on payments without a paypal account. Here's a couple of bit's I've found
When a buyer enters checkout, a secure credit card checkout will automatically appear if the buyer doesn't already have a PayPal account or if they can't remember their password.
and
When you reach the checkout, look out for the credit card symbols then simply click the 'continue' link and you will be able to complete your purchase using your credit card or bank account.
and
To turn the feature on or off, simply log in to PayPal, go to Profile, click ‘Website Payment Preferences’ under the Selling Preferences column and tick the yes/no box under PayPal Account Optional.
This feature is available to Premier and Business account holders only.
I can add an option to make a Paypal account mandatory but you can't do it the other way. I'll add what I've found into my notes.

No Application Form
The mod allows you to add new fields or turn off application form fields that aren't needed. A slight adjustment and we'll be able to bypass the form completely. If it's too complicated I'll add another item into the ACP for presentation of the application form.

Other planned changed
A couple of other features that will be in the next release are
1. Up to 5 payment periods. i.e. £4 for 1 month, £10 for 3 months, £25 for 1 year.
2. User entered amount. i.e a donation.

Inspiration
I did have a look at the loewen mod before I started, it's not been updated in years and I wasn't really that impressed. What is it about that mod that you like?

Regards
Doug
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [Beta] Membership Management with Paypal IPN

Post by the pips »

Blue Blood wrote:uninstall is not removing the Custom profile fields
Thanks for the feedback. I've not really tested uninstall :D I'll investigate.

Regards
Doug
jbarrouk
Registered User
Posts: 218
Joined: Mon May 15, 2006 3:10 am
Contact:

Re: [ALPHA] Membership Management with Paypal IPN

Post by jbarrouk »

Thanks for the updates Doug.
wmtoo
Registered User
Posts: 237
Joined: Wed Jan 28, 2004 3:21 am
Name: Josi
Contact:

Re: [ALPHA] Membership Management with Paypal IPN

Post by wmtoo »

baller1234, where are you seeing this code:

Code: Select all

   '0.1.0-beta' => array(
      // only change is to add the shopping basket to the sessions table
      'table_column_add' => array(
         array('phpbb3_sessions', 'shopping_basket', array('MTEXT_UNI', '')),
      ),
   },
I played with this mod on a developing, though not live, site and it trashed my ACP and now I can't figure out how to UNDO it so that I can try it again. I've removed all of the files, un-edited the files... and still my ACP is just a blank page that just shows phpbb and nothing else. When I View Source, all of the code is there - but I see nothing except the ACP logo and links to go to Index page.

When I ran the create file for this mod, it gave me that blank ACP page.

Also, the instructions mention a Temp/createMembership.php file - though there is none.

Doug, I do appreciate the work you've done on this. I know you're busy, so it means a lot that you're putting this together.
wmtoo
Registered User
Posts: 237
Joined: Wed Jan 28, 2004 3:21 am
Name: Josi
Contact:

Re: [ALPHA] Membership Management with Paypal IPN

Post by wmtoo »

FYI - I edited this mod for subsilver2 - not a big deal since the edits fit in nearly perfectly. I used a $-sign graphic I already had in my subsilver2/theme/images folder called money.png. For your own forum, you'll want to locate/use whatever image works for you and then rename money.png to the image name you upload.

Code: Select all

Upload all prosilver style files for the Membership Mgmt mod to the subsilver2 folder
Find/Upload an image for your currency to the subsilver2/theme/images folder, rename the image in the edit file if your image is not called 'money.png'

Code: Select all

Open subsilver2/template/index_body.html

Find
<!-- INCLUDE forumlist_body.html -->

Add before
<!-- IF RENEWAL_MESSAGE -->
		<!-- INCLUDE renewal.html -->

<!-- ENDIF -->

Code: Select all

Open subsilver2/template/overall_header.html

Find
				<!-- IF not S_IS_BOT -->
					<!-- IF S_DISPLAY_MEMBERLIST -->&nbsp; &nbsp;<a href="{U_MEMBERLIST}"><img src="{T_THEME_PATH}/images/icon_mini_members.gif" width="12" height="13" alt="*" /> {L_MEMBERLIST}</a><!-- ENDIF -->
					<!-- IF S_USER_LOGGED_IN -->&nbsp; &nbsp;<a href="{U_PROFILE}"><img src="{T_THEME_PATH}/images/icon_mini_profile.gif" width="12" height="13" alt="*" /> {L_PROFILE}</a><!-- ENDIF -->
				<!-- ENDIF -->
			</td>
		</tr>

Add before
					&nbsp; &nbsp;<a href="{U_MEMBERSHIP}"><img src="{T_THEME_PATH}/images/money.png" width="12" height="13" alt="*" />{L_MEMBERSHIP}</a>
Note that in the original edits file, it says to Add MEMBERLIST to the prosilver/overall_header file - it should say MEMBERSHIP.

Now - how do I modify the fields for the application?
Last edited by wmtoo on Sun Jul 03, 2011 6:55 pm, edited 1 time in total.
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [ALPHA] Membership Management with Paypal IPN

Post by the pips »

wmtoo wrote:baller1234, where are you seeing this code:

Code: Select all

   '0.1.0-beta' => array(
      // only change is to add the shopping basket to the sessions table
      'table_column_add' => array(
         array('phpbb3_sessions', 'shopping_basket', array('MTEXT_UNI', '')),
      ),
   },
That bit of code is in createMembership.php
wmtoo wrote: I played with this mod on a developing, though not live, site and it trashed my ACP and now I can't figure out how to UNDO it so that I can try it again. I've removed all of the files, un-edited the files... and still my ACP is just a blank page that just shows phpbb and nothing else. When I View Source, all of the code is there - but I see nothing except the ACP logo and links to go to Index page.

When I ran the create file for this mod, it gave me that blank ACP page.
Oh My, I've just tried it myself and got exactly the same. Obviously I've got something screwy in the permissions part of the createMembership, I'd strongly recommend removing this section until I've got time to investigate it further.

Code: Select all

		'permission_set' => array(
			array('ROLE_ADMIN_FULL', 'u_approve_application'),
			array('ROLE_ADMIN_FULL', 'u_mark_paid'),
		),
I think what's happening is that it isn't removing the permissions from the role (which is what I intended) but it's actually removing the role (which is definitely NOT what's intended). I restored the permissions by just granting the role all permissions again.
wmtoo wrote: Also, the instructions mention a Temp/createMembership.php file - though there is none.
You can safely ignore any reference to the temp folder. It's yet another oversight on my part :(
wmtoo wrote: Doug, I do appreciate the work you've done on this. I know you're busy, so it means a lot that you're putting this together.
I really appreciate the comment. All I've got to do now is persuade my wife that it's worth it!

Regards
Doug
Last edited by the pips on Sun Jul 03, 2011 11:04 am, edited 2 times in total.
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [ALPHA] Membership Management with Paypal IPN

Post by the pips »

wmtoo wrote:FYI - I edited this mod for subsilver2 - not a big deal since the edits fit in nearly perfectly. I used a $-sign graphic I already had in my subsilver2/theme/images folder called money.png. For your own forum, you'll want to locate/use whatever image works for you and then rename money.png to the image name you upload.

Code: Select all

Upload all prosilver style files for the Membership Mgmt mod to the subsilver2 folder
Find/Upload an image for your currency to the subsilver2/theme/images folder, rename the image in the edit file if your image is not called 'money.png'

Code: Select all

Open subsilver2/template/index_body.html

Find
<!-- INCLUDE forumlist_body.html -->

Add before
<!-- IF RENEWAL_MESSAGE -->
		<!-- INCLUDE renewal.html -->

<!-- ENDIF -->

Code: Select all

Open subsilver2/template/overall_header.html

Find
				<!-- IF not S_IS_BOT -->
					<!-- IF S_DISPLAY_MEMBERLIST -->&nbsp; &nbsp;<a href="{U_MEMBERLIST}"><img src="{T_THEME_PATH}/images/icon_mini_members.gif" width="12" height="13" alt="*" /> {L_MEMBERLIST}</a><!-- ENDIF -->
					<!-- IF S_USER_LOGGED_IN -->&nbsp; &nbsp;<a href="{U_PROFILE}"><img src="{T_THEME_PATH}/images/icon_mini_profile.gif" width="12" height="13" alt="*" /> {L_PROFILE}</a><!-- ENDIF -->
				<!-- ENDIF -->
			</td>
		</tr>

Add before
					&nbsp; &nbsp;<a href="{U_MEMBERSHIP}"><img src="{T_THEME_PATH}/images/money.png" width="12" height="13" alt="*" />{L_MEMBERSHIP}</a></li>
Note that in the original edits file, it says to Add MEMBERLIST to the prosilver/overall_header file - it should say MEMBERSHIP.
That's absolutely brilliant. Thank you for helping on that.
wmtoo wrote: Now - how do I modify the fields for the application?
I've tried to use as many standard features as possible. The application form is built from Custom Profile Fields. Any active custom profile fields that begins ‘ms_’ are presented so all you need do is create a new one. (ACP, Users and Groups, Custom Profile Fields). You can turn them off by marking them invalid or deleting them completely.

All of the features of CPFs are there, variable types, mandatory, validation.

Regards
Doug
User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

Re: [ALPHA] Membership Management with Paypal IPN

Post by Neuropass »

Great mod. Where can I donate to you?

Now feedback and error. (debug mode on in config.php)
after installation when I click on:

configure paypal IPN
configure bank transfers


I get the following error:

Code: Select all

[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2

and when you click on:


membership settings:

Code: Select all

[phpBB Debug] PHP Notice: in file /includes/acp/acp_membership.php on line 56: Undefined variable: s_forum_options
[phpBB Debug] PHP Notice: in file /includes/acp/acp_membership.php on line 92: Undefined index: lang

On the install script there is a double entry about the membership edit, template file.




After going through the membership form and clicking on paypal button I get:


Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

SQL

SELECT shopping_basket FROM phpbb_sessions WHERE session_id = "7477bf4ec85d7fcc5be48dbea7548868"

BACKTRACE

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

FILE: includes/payment_class.php
LINE: 120
CALL: dbal_mysql->sql_query()

FILE: includes/payment_class.php
LINE: 27
CALL: payment_class->retrieve_shopping_basket()

FILE: includes/paypal_class.php
LINE: 51
CALL: payment_class->__construct()

FILE: application.php
LINE: 78
CALL: paypal_class->__construct()

then if you click on back button it won't go back it will do nothing.





If you uninstall the mod (it won't remove custom profile fields) when you deactivate them and try to delete you get this:


Code: Select all

General Error
SQL ERROR [ mysql4 ]

Can't DROP 'pf_ms_publish'; check that column/key exists [1091]

SQL

ALTER TABLE phpbb_profile_fields_data DROP COLUMN pf_ms_publish

BACKTRACE

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

FILE: includes/acp/acp_profile.php
LINE: 172
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_profile->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()


enough for now. How's that as a debugger??? lol You better fix that! :lol:
Last edited by Neuropass on Mon Jul 04, 2011 4:59 am, edited 6 times in total.
wmtoo
Registered User
Posts: 237
Joined: Wed Jan 28, 2004 3:21 am
Name: Josi
Contact:

Re: [ALPHA] Membership Management with Paypal IPN

Post by wmtoo »

Doug - small change to my subsilver overall_header template... removed </li> from the Add before verbiage.
w3man
Registered User
Posts: 1
Joined: Sun Jul 10, 2011 3:51 am

Re: [ALPHA] Membership Management with Paypal IPN

Post by w3man »

I installed the mod. I am receiving this on the membership.php form:

Cannot instantiate non-existent class: paypal_class in \forum\application.php on line 78

Any help would be appreciated.

Thanks
User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

Re: [ALPHA] Membership Management with Paypal IPN

Post by Neuropass »

Neuropass wrote:Great mod. Where can I donate to you?

Now feedback and error. (debug mode on in config.php)
after installation when I click on:

configure paypal IPN
configure bank transfers


I get the following error:

Code: Select all

[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2
[phpBB Debug] PHP Notice: in file /adm/index.php on line 282: Undefined offset: 2

and when you click on:


membership settings:

Code: Select all

[phpBB Debug] PHP Notice: in file /includes/acp/acp_membership.php on line 56: Undefined variable: s_forum_options
[phpBB Debug] PHP Notice: in file /includes/acp/acp_membership.php on line 92: Undefined index: lang

On the install script there is a double entry about the membership edit, template file.




After going through the membership form and clicking on paypal button I get:


Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

SQL

SELECT shopping_basket FROM phpbb_sessions WHERE session_id = "7477bf4ec85d7fcc5be48dbea7548868"

BACKTRACE

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

FILE: includes/payment_class.php
LINE: 120
CALL: dbal_mysql->sql_query()

FILE: includes/payment_class.php
LINE: 27
CALL: payment_class->retrieve_shopping_basket()

FILE: includes/paypal_class.php
LINE: 51
CALL: payment_class->__construct()

FILE: application.php
LINE: 78
CALL: paypal_class->__construct()

then if you click on back button it won't go back it will do nothing.





If you uninstall the mod (it won't remove custom profile fields) when you deactivate them and try to delete you get this:


Code: Select all

General Error
SQL ERROR [ mysql4 ]

Can't DROP 'pf_ms_publish'; check that column/key exists [1091]

SQL

ALTER TABLE phpbb_profile_fields_data DROP COLUMN pf_ms_publish

BACKTRACE

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

FILE: includes/acp/acp_profile.php
LINE: 172
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_profile->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()


enough for now. How's that as a debugger??? lol You better fix that! :lol:
bump
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [ALPHA] Membership Management with Paypal IPN

Post by the pips »

Thank you everyone for your help in finding errrmmm non-documented product enhancement opportunities.

Taking on board Neuropass's mention of debug I decided to investigate it and turned it on. Boy, did that throw up a few issues. I think I've modified everything so the mod at least works without warning messages now.

configure paypal IPN
configure bank transfers

Fixed

membership settings
Fixed

On the install script there is a double entry about the membership edit, template file.
Fixed

Unknown column 'shopping_basket' in 'field list' [1054]
This one had already been identified and fixed but is now in the installer.

then if you click on back button it won't go back it will do nothing.
The whole business of cancelling (and changing your mind again) as well as going back one stage is taking considerably longer to resolve than I thought. I've rewritten quite a chunk but still have work to do.

If you uninstall the mod (it won't remove custom profile fields) when you deactivate them and try to delete you get this:
I've rewritten the uninstall routine and it now seems to be working ok.
Uninstalling permissions
This still isn't working properly so I'm inclined to remove the whole bit of adding permissions to roles until I can get it working.

Also, the instructions mention a Temp/createMembership.php file - though there is none.
Fixed

I'm hoping I'm going to be able to put a new download package up in the next few days but I'll keep you posted.

Regards
Doug
User avatar
Volksdevil
Registered User
Posts: 2414
Joined: Sun Oct 03, 2010 2:03 pm
Location: Lancashire, UK
Name: Neil
Contact:

Re: [ALPHA] Membership Management with Paypal IPN

Post by Volksdevil »

Fantastic idea this, look forward to staying updated. Keep up the good work, it's appreciated! :D
the pips wrote: then if you click on back button it won't go back it will do nothing.
The whole business of cancelling (and changing your mind again) as well as going back one stage is taking considerably longer to resolve than I thought. I've rewritten quite a chunk but still have work to do.
I'm no coder, but could a simple link be used here? "Return to" Or "Cancel and return to" something like that?
Edit: Ah, I think you are trying to literally go back a page during the membership form submitting? Maybe a 'Cancel and retrun to home page" or "Cancel and start again"

I'm simple like that :oops: :lol:
My phpBB Extensions
Finally found great Website Hosting from Image KUALO!
Do NOT use 123-reg.co.uk - Incapable of running phpBB!
:ugeek: TekNeil - Streamer on Mixer | My Volkswagen Corrado G60
Locked

Return to “[3.0.x] Abandoned MODs”