Community Add-Ons

$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