[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.
gordyr
Registered User
Posts: 1
Joined: Tue Jun 14, 2011 6:20 pm

Re: [Dev] Membership Application and Management

Post by gordyr »

I got this error when running the creatmembership.php file after editing the templates and copying the files.

Possibly a mistake on my part?


Membership Management
PHP Version: 5.2.17
DBMS: MySQL 5.1.52
phpBB3 Version: 3.0.8

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 'DEFAULT '0' NOT NULL,
PRIMARY KEY (membership_no)
) CHARACTER SET utf8 COLLATE ' at line 13
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [Dev] Membership Application and Management

Post by the pips »

How odd, there's two tables installed and they use identical syntax but one works and the other doesn't. I've modified the install information and uploaded the package again.

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

Re: [Beta] Membership Application and Management

Post by the pips »

Wayhay! I've just had an email from someone that's just installed the mod on their site and it worked!!
As I've corrected a couple of small anomolies I'm changing it from Dev to Beta.

Let me know how you get on.

Regards
Doug
baller1234
Registered User
Posts: 129
Joined: Sat May 29, 2010 9:43 am

Re: [Beta] Membership Application and Management

Post by baller1234 »

finaly a mod that works.. Im going to install this right now!

Ill let you know how it works out..

btw, how do you setup paypal to use IPN? i need to fill in some url (on paypal site) but whats the url? Just my forum url or domain?
the pips
Registered User
Posts: 511
Joined: Sat Mar 21, 2009 5:33 pm

Re: [Beta] Membership Application and Management

Post by the pips »

I've added a word document with some notes on setting up the mod at http://www.development.arvclub.co.uk/download.

Hope it helps

Regards
Doug
baller1234
Registered User
Posts: 129
Joined: Sat May 29, 2010 9:43 am

Re: [Beta] Membership Management with Paypal IPN

Post by baller1234 »

thanx alot..

when i click on one of these: (except members)

Image

I get this error..

SQL ERROR [ mysqli ]

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 '3'' at line 1 [1064]

SQL

SELECT count(u.user_id) AS user_count FROM (phpbb3_users u) LEFT JOIN phpbb3_membership m ON (u.user_id = m.user_id AND m.group_id=5) LEFT JOIN phpbb3_profile_fields_data pfd ON (pfd.user_id = u.user_id) WHERE user_type=0 AND ug.group_id='5 AND m.remindertype='3'

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_membership.php
LINE: 169
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_membership.php
LINE: 470
CALL: view_members()

FILE: includes/functions_module.php
LINE: 512
CALL: acp_membership->main()

FILE: adm/index.php
LINE: 87
CALL: p_master->load_active()
baller1234
Registered User
Posts: 129
Joined: Sat May 29, 2010 9:43 am

Re: [Beta] Membership Management with Paypal IPN

Post by baller1234 »

i had to find out where the url was to make a payment. Not added anywhere?? When i found out you need to use application.php i used it with a test account..

When i click on the paypal button i get this error:

General Error
SQL ERROR [ mysqli ]

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

Doesnt matter wich option i choose..

Also, i dont see any option to just pay with an email adres??

ps. It would also be nice to have a multiple payments..

example: if a member pays 30 euro they get 3 months access to a group and when they pay 10 1 month. So it would be nice to have no subscription or a option to turn it off.. (more like a donate mod) and when they contribute they recieve access for the ammount they paid?

example: User pays 10 euro and is added to a vip group for a month. when the month is over the user is removed from the group automatic. (so no subscription is involved.) Alot of my users dont like subscriptions.

Thanx in advance
User avatar
4_seven
I've Been Banned!
Posts: 5155
Joined: Wed Apr 30, 2008 1:41 am

Re: [Beta] Membership Management with Paypal IPN

Post by 4_seven »

Unknown column 'shopping_basket' in 'field list'
For every phpbb3 admin it must be clear, that this 'table column' don't exist. ;)
So create this column..
Current Mods | Mod Base | php(BB) programming | No help via PM
baller1234
Registered User
Posts: 129
Joined: Sat May 29, 2010 9:43 am

Re: [Beta] Membership Management with Paypal IPN

Post by baller1234 »

hehe.. i know. But i just tell it to author.. maby its a bug or something
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 »

Stupid typo I'm afraid. I've corrected the error and updated the installation package again.
I've also copied acp_membership.php onto the download page. Simply replace \includes\acp_membership.php with this one.

Regards
Doug
baller1234 wrote:thanx alot..

when i click on one of these: (except members)

Image

I get this error..

SQL ERROR [ mysqli ]

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 '3'' at line 1 [1064]

SQL

SELECT count(u.user_id) AS user_count FROM (phpbb3_users u) LEFT JOIN phpbb3_membership m ON (u.user_id = m.user_id AND m.group_id=5) LEFT JOIN phpbb3_profile_fields_data pfd ON (pfd.user_id = u.user_id) WHERE user_type=0 AND ug.group_id='5 AND m.remindertype='3'

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_membership.php
LINE: 169
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_membership.php
LINE: 470
CALL: view_members()

FILE: includes/functions_module.php
LINE: 512
CALL: acp_membership->main()

FILE: adm/index.php
LINE: 87
CALL: p_master->load_active()
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:i had to find out where the url was to make a payment. Not added anywhere?? When i found out you need to use application.php i used it with a test account..
I've uploaded some instructions on setting up Paypal and I'll keep working on them. Don't you just hate writing documentation? :lol:
baller1234 wrote: When i click on the paypal button i get this error:

General Error
SQL ERROR [ mysqli ]

Unknown column 'shopping_basket' in 'field list' [1054]
Doesnt matter wich option i choose..
How on earth did I miss that? shopping_basket is a new field TYPE BLOB in the sessions table. I'll modify the installer tonight but in the meantime you could add it yourself through phpMyadmin.
baller1234 wrote: Also, i dont see any option to just pay with an email adres??
I think this is a Paypal thing. If you've used Paypal on that computer before then it displays the logon page. If you haven't then it gives you a different page. I'll do some digging on the Paypal developers site and see if there's a way to modify it's behaviour.
baller1234 wrote: ps. It would also be nice to have a multiple payments..

example: if a member pays 30 euro they get 3 months access to a group and when they pay 10 1 month. So it would be nice to have no subscription or a option to turn it off.. (more like a donate mod) and when they contribute they recieve access for the ammount they paid?
That's a very interesting idea. It's just a quantity isn't it? i.e. 3 x 1 month at 10 euro. I'm sure that will be very straightforward to implement. I'll look at that.
baller1234 wrote: example: User pays 10 euro and is added to a vip group for a month. when the month is over the user is removed from the group automatic. (so no subscription is involved.) Alot of my users dont like subscriptions.
The mod does do this. The Cron task removes users when their grace period expires. Set it to 1 day and you're there. I take your point about subscriptions but they don't have to use it. They can simply make a one-off payment.
baller1234 wrote: Thanx in advance
No problem and thanks for your help and ideas.

Regards
Doug
baller1234
Registered User
Posts: 129
Joined: Sat May 29, 2010 9:43 am

Re: [Beta] Membership Management with Paypal IPN

Post by baller1234 »

great btw, I found another small typo:

In the install.xml its

Code: Select all

create_Membership.php 
and in the zippackage its

Code: Select all

createMembership.php
.

Also when i click on Click Here to run membership reports

i get:

Code: Select all

File not found

Firefox cant find file on http://url.com/unet/generate_mailing_list.php?sid=8454c38fbca22c6af38798316d3689d1 niet vinden.
That's a very interesting idea. It's just a quantity isn't it? i.e. 3 x 1 month at 10 euro. I'm sure that will be very straightforward to implement. I'll look at that.
Not exacly, But it would be a nice addition :P.. i created this on my site:
Image

Just predefined values, and based on that they recieve access for the ammount they contribute.
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:great btw, I found another small typo:

In the install.xml its

Code: Select all

create_Membership.php 
and in the zippackage its

Code: Select all

createMembership.php
.

Also when i click on Click Here to run membership reports

i get:

Code: Select all

File not found

Firefox cant find file on http://url.com/unet/generate_mailing_list.php?sid=8454c38fbca22c6af38798316d3689d1 niet vinden.
That's a very interesting idea. It's just a quantity isn't it? i.e. 3 x 1 month at 10 euro. I'm sure that will be very straightforward to implement. I'll look at that.
Not exacly, But it would be a nice addition :P.. i created this on my site:
Image

Just predefined values, and based on that they recieve access for the ammount they contribute.
Thanks for the typo. Now corrected. I'm confused by the error with generate_mailing_list.php. It's definitely in the root directory and that's where the ACP is expecting it to be. Odd.

I'll have to think about how to add multiple subscription terms. I'd been thinking along the lines of creating a subscription table with description, period, price and group and presenting it as a dropdown list just as you're doing.
Another approach would be to allow discounts for multiple purchases. Buy 6 and pay for 4 sort of thing.

Lot's to consider here!

Regards
Doug
baller1234
Registered User
Posts: 129
Joined: Sat May 29, 2010 9:43 am

Re: [Beta] Membership Management with Paypal IPN

Post by baller1234 »

hey there,

I tried your new install file but i get a blank page when i run it..

This doesnt work.

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('sessions', 'shopping_basket', array('BLOB', 0)),
		),
	},
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 »

Oh, darn it. UMIL doesn't support BLOB. Change

Code: Select all

         array('sessions', 'shopping_basket', array('BLOB', 0)),
to

Code: Select all

         array('sessions', 'shopping_basket', array('MTEXT_UNI', '')),
I'll update the package soonest.

Regards
Doug
Locked

Return to “[3.0.x] Abandoned MODs”