<?php
/************* Membership V2.0 *******************/
/*
Released by AwesomePHP.com, under the GPL License, a
copy of it should be attached to the zip file, or
you can view it on http://AwesomePHP.com/gpl.txt
*/
/************* Membership V2.0 *******************/	

if($is_admin == false){ die();}

if($_POST['rate_id'] == NULL){ $_POST['rate_id'] = $_GET['rate_id'];}

if($_POST['membership_id'] == NULL){$_POST['membership_id'] = $_GET['membership_id'];}

if(!is_numeric($_POST['rate_id']) AND $_GET['do'] != 'Add'){	
	$get_list = "SELECT * FROM `memb_memberships_rates` WHERE `membership_id`='$_POST[membership_id]'";

	$is_count = @mysql_query($get_list);
	$display_limit = '10'; 
	$items_count = @mysql_num_rows($is_count); 
	if($items_count > $display) { 
		$page_count = ceil ($items_count/$display_limit); 
	} else { 
		$page_count = 1; 
	}
	if(is_numeric($second_var)){ 
	    $start = $_GET['start']; 
	} else { 
	    $start = 0; 
	} 
	$get_users = @mysql_query($get_list . " ORDER BY `rate_id` ASC LIMIT $start,$display_limit");
?>
  <table width="100%"  border="1" cellspacing="0" cellpadding="5">
    <tr bgcolor="#BEDEDE">
      <td colspan="4"><div align="center"><font color="#999999" size="4"><strong>Rate List  [<a href="?page=rates&do=Add&membership_id=<?php echo $_POST['membership_id'];?>">Add</a>] </strong></font></div></td>
    </tr>
    <tr bgcolor="#CAFFCA">
      <td width="26%"><div align="center"><font size="2"><strong>Rate Title </strong></font></div></td>
      <td width="26%" bgcolor="#CAFFCA"><div align="center"><font size="2"><strong>Rate Description </strong></font></div></td>
      <td width="26%"><div align="center"><font size="2"><strong>Membership Rate </strong></font></div></td>
      <td width="20%"><div align="center"><font size="2"><strong>Options</strong></font></div></td>
    </tr>
	<?php
	if($items_count <= 0){ echo '<tr><td colspan="4">No rates found.</td><tr>';}
	while($each = mysql_fetch_assoc($get_users)){?>
    <tr>
      <td width="26%"><font color="#990000" size="2"><?php echo $each['rate_title'];?></font></td>
      <td width="26%"><font color="#990000" size="2"><?php echo $each['rate_desc'];?></font></td>
      <td width="26%"><font color="#990000" size="2"><?php echo $each['rate_amount']. ' Paypable Every '. $each['rate_term'].' '.showTerm($each['rate_term_c'])?></font></td>
      <td width="20%"><div align="center"><font size="2">[<a href="?page=rates&rate_id=<?php echo $each['rate_id'];?>&membership_id=<?php echo $_POST['membership_id'];?>">Edit/Remove</a>]</font></div></td>
    </tr>
	<?php } ?>
</table>
<?php } else { 
	if($_POST['rate_id'] != NULL){
		$_POST = mysql_fetch_assoc(mysql_query("SELECT * FROM `memb_memberships_rates` WHERE `rate_id`='$_POST[rate_id]'"));
	}
	?>  
  <form name="rates" id="rates" method="post" action="?page=rates&rate_id=<?php echo $first_var;?>" style="display:inline;">
  <table width="100%"  border="1" cellspacing="0" cellpadding="5">
    <tr bgcolor="#BEDEDE">
      <td colspan="2"><div align="center"><font color="#999999" size="4"><strong>Add/Edit Rate: </strong></font></div></td>
    </tr>
  <?php
  if($message != NULL){?>
  <tr bgcolor="#FFC6C6">
    <td colspan="2"><strong><font color="#FF0000" size="2"><?php echo $message;?></font></strong></td>
  </tr>
  <?php } ?>
    <tr>
      <td width="50%"><font size="2">Rate Title:</font></td>
      <td width="50%"><font size="2">
	    <input name="rate_title" type="text" id="rate_title" value="<?php echo $_POST['rate_title'];?>" class="hiddenText">
      </font></td>
    </tr>
    <tr>
      <td width="50%"><font size="2">Rate Description: </font></td>
      <td width="50%"><font size="2">
        <input name="rate_desc" type="text" id="_desc" value="<?php echo $_POST['rate_desc'];?>" class="hiddenText">
      </font></td>
    </tr>
    <tr>
      <td width="50%"><font size="2">Rate Price: </font></td>
      <td><font size="2">
        <input name="rate_amount" type="text" id="rate_amount" value="<?php echo $_POST['rate_amount'];?>" class="hiddenText">
      </font></td>
    </tr>
    <tr>
      <td><font size="2">Rate Term:</font></td>
      <td><font size="2">
        Payment Every: 
        <input name="rate_term" type="text" id="rate_term" value="<?php echo $_POST['rate_term'];?>" class="hiddenText">
      <select name="rate_term_c" class="hiddenText" id="rate_term_c">
        <option value="D">Days</option>
        <option value="W">Weeks</option>
        <option value="M">Months</option>
        <option value="Y">Years</option>
      </select>
      </font></td>
    </tr>
    <tr>
      <td><font size="2">Automatic renewal: </font></td>
      <td><font size="2">
      <?php if($_POST['rate_automatic'] == '1' || $_POST['rate_automatic'] == NULL){$sel = ' checked';}else{$sel=NULL;}?>
      <input name="rate_automatic" type="radio" value="1"<?php echo $sel;?>>
Yes
<?php if($_POST['rate_automatic'] == '2'){$sel = ' checked';}else{$sel=NULL;}?>
<input name="rate_automatic" type="radio" value="2"<?php echo $sel;?>>
No</font></td>
    </tr>
    <tr>
      <td>2CheckOut Product ID (if any): </td>
      <td><font size="2">
        <input name="2checkout_PID" type="text" id="2checkout_PID" value="<?php echo $_POST['2checkout_PID'];?>" class="hiddenText">
      </font></td>
    </tr>
    <tr bgcolor="#BEDEDE">
      <td colspan="2"><div align="center">
        <font size="2">
        <input type="submit" name="Submit" value="Submit" class="button">
        <input name="doid" type="hidden" id="doid" value="9">
        <input name="rate_id" type="hidden" id="rate_id" value="<?php echo $_POST['rate_id'];?>">
        <input name="membership_id" type="hidden" id="membership_id" value="<?php echo $_POST['membership_id'];?>">
</font></div></td>
    </tr>
    <tr bgcolor="#CAFFCA">
      <td colspan="2"><div align="right">
        <font size="1"></font>
        <table width="100%"  border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td><a href="?page=rates&membership_id=<?php echo $_POST['membership_id'];?>"><strong><font size="1">Return To Rate List</font></strong></a> </td>
            <td><div align="right"><font size="1">
            <input type="checkbox" id="do_delete" name="do_delete" value="yes">
Delete</font></div></td>
          </tr>
        </table>
        </div></td>
    </tr>
  </table>
</form>
<?php } ?>