Community Add-Ons

FULL PACKAGE
I have corrected a mistake in installation instruction, asking for changes in create_account.php, when inserting the dropdown for membership selection, it used the sort order instead of membership ID, which has eaten up by 4 hours.

Another fix, I have updated the paypal_ipn.php to add the membership fees in handling charges (sorry no other way I can see).

this is a full packge, still need to work in that.
added screenshoots.
Manual page
Install, fixed miss speeling
better .sql file install/desinstall.

I have taken the liberty of working more on this addon that i love, and have modified another admin file to do the work of Inserting/Editing/Deleting the Membership Types which was surely needed to make this a truly viable addon for non php/mySQL gifted folks. The zip contains the files and very basic instructions to add the admin stuff.

NOTE: The admin menu/box file was written for CRE Loaded so it will need modifying by someone to be osC compatible, but thats minor compared to the ability this gives all users of this mod :) Have Fun!

$mem_query = tep_db_query("select sort_order, ID, CONCAT(membership_name,' ($',membership_fee,')') as membername from " . TABLE_SUBS_MEMBERSHIP_TYPES . " order by sort_order, membership_fee");
while ($mem_values = tep_db_fetch_array($mem_query)) {
$mem_array[] = array('id' => $mem_values['ID'], 'text' => $mem_values['membername']);
}

mad a small typo in the last posting, sorry: use this one instead.

$mem_query = tep_db_query("select sort_order, CONCAT(membership_name,' ($',membership_fee,')') as

membername from " . TABLE_SUBS_MEMBERSHIP_TYPES . " order by sort_order, membership_fee");
while ($mem_values = tep_db_fetch_array($mem_query)) {
$mem_array[] = array('id' => $mem_values['ID'], 'text' => $mem_values['membername']);
}

zip is a dummy file...

hi there, wanted a way to add a sort order for the membership dropdown selection on the create account page :) here it is:

in create_account.php change the following:

<!--Joseph Franklyn McElroy Corporate Performance Artists Start //-->
<tr>
<td class="main"><?php echo ENTRY_MEMBERSHIP_LEVEL; ?></td>
<td class="main">
<?php
$mem_array = array();
$mem_array[] = array('id' => '0', 'text' => 'Select');
$mem_query = tep_db_query("select sort_order, CONCAT(membership_name,' ($',membership_fee,')') as

membername from " . TABLE_SUBS_MEMBERSHIP_TYPES . " order by sort_order, membership_fee");
while ($mem_values = tep_db_fetch_array($mem_query)) {
$mem_array[] = array('id' => $mem_values['sort_order'], 'text' => $mem_values['membername']);
}
echo tep_draw_pull_down_menu('mem_id', $mem_array);
?>
</td>
</tr>
<!--Joseph Franklyn McElroy Corporate Performance Artists End //-->


in the sql statement change th following:


CREATE TABLE `subs_membership_types` (
`ID` int(11) NOT NULL auto_increment,
`membership_name` varchar(255) NOT NULL default '',
`membership_fee` float NOT NULL default '0',
`membership_length` int(11) NOT NULL default '12',
`products_id` int(11) default NULL,
`sort_order` int(2) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

Updated to manage multiple membership levels with different fees for each level - also fixed to keep track of last payment. Currently no edit function for membership levels table in admin.

This contrib adds a membership feature so that when a customer places their first order the membership fee is automatically added to the order total and shown at the time of order confirmation. The membership fee is then added again after the set number of months. There are settings in the admin menu for the membership fee amount and number of months before next fee is charged. Admin settings are found under modules-->order total