<?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['membership_id'] == NULL){	$_POST['membership_id'] = $_GET['membership_id'];}


if(!is_numeric($_POST['membership_id']) AND $_GET['do'] != 'Add'){	
	$get_list = "SELECT * FROM `memb_memberships`";
	$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 `membership_title` 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>Membership List  [<a href="?page=memberships&do=Add">Add</a>] </strong></font></div></td>
    </tr>
	<?php
	if($items_count > $display_limit){
	?>
    <tr>
      <td colspan="4"><div align="center"><?php include('pagination.php');?></div></td>
    </tr>
	<?php } ?>
    <tr bgcolor="#CAFFCA">
      <td width="26%"><div align="center"><font size="2"><strong>Membership Name </strong></font></div></td>
      <td width="26%" bgcolor="#CAFFCA"><div align="center"><font size="2"><strong>Membership Description </strong></font></div></td>
      <td width="26%"><div align="center"><font size="2"><strong>Membership File Location </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 memberships found.</td><tr>';}
	while($each = mysql_fetch_assoc($get_users)){?>
    <tr>
      <td width="26%"><font color="#990000" size="2"><?php echo $each['membership_title'];?></font></td>
      <td width="26%"><font color="#990000" size="2"><?php echo $each['membership_desc'];?></font></td>
      <td width="26%"><font color="#990000" size="2"><?php echo $each['membership_file'];?></font></td>
      <td width="20%"><div align="center"><font size="2">[<a href="?page=memberships&membership_id=<?php echo $each['membership_id'];?>">Edit/Remove</a>] [<a href="?page=payments&membership_id=<?php echo $each['membership_id'];?>">Payments</a>] </font></div></td>
    </tr>
	<?php } ?>
</table>
<?php } else { 
	if($_POST['membership_id'] != NULL){
		$_POST = mysql_fetch_assoc(mysql_query("SELECT * FROM `memb_memberships` WHERE `membership_id`='$_POST[membership_id]'"));
	}
	?>  
  <form name="membership" id="membership" method="post" action="?page=memberships&membership_id=<?php echo $_POST['membership_id'];?>" 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 Membership: </strong></font></div></td>
    </tr>
    <tr>
      <td width="50%"><font size="2">Membership Name: </font></td>
      <td width="50%"><font size="2">
	    <input name="membership_title" type="text" id="membership_title" value="<?php echo $_POST['membership_title'];?>" class="hiddenText">
      </font></td>
    </tr>
    <tr>
      <td width="50%"><font size="2">Membership Description: </font></td>
      <td width="50%"><font size="2">
        <input name="membership_desc" type="text" id="membership_desc" value="<?php echo $_POST['membership_desc'];?>" class="hiddenText">
      </font></td>
    </tr>
    <tr>
      <td width="50%"><font size="2">Membership .fdaccess file location: </font></td>
      <td><font size="2">
        <input name="membership_file" type="text" id="membership_file" value="<?php echo $_POST['membership_file'];?>" class="hiddenText">
      </font></td>
    </tr>
    <tr>
      <td><font size="2">Is Membership free? Will skip rates:</font></td>
      <td><font size="2">
      <?php if($_POST['membership_free'] == '1' || $_POST['membership_free'] == NULL){$sel = ' checked';}else{$sel=NULL;}?>
      <input name="membership_free" type="radio" value="1"<?php echo $sel;?>>
Yes
<?php if($_POST['membership_free'] == '2'){$sel = ' checked';}else{$sel=NULL;}?>
<input name="membership_free" type="radio" value="2"<?php echo $sel;?>>
No</font></td>
    </tr>
    <tr>
      <td><font size="2">Is Membership public? User can join it? </font></td>
      <td><font size="2">
      <?php if($_POST['membership_public'] == '1' || $_POST['membership_public'] == NULL){$sel = ' checked';}else{$sel=NULL;}?>
      <input name="membership_public" type="radio" value="1"<?php echo $sel;?>>
Yes
<?php if($_POST['membership_public'] == '2'){$sel = ' checked';}else{$sel=NULL;}?>
<input name="membership_public" type="radio" value="2"<?php echo $sel;?>>
No</font></td>
    </tr>
	<?php
	if($_GET['do'] != 'Add'){?>
    <tr bgcolor="#BEDEDE">
      <td colspan="2"><div align="center"><font color="#999999" size="4"><strong>Membership Rates: </strong></font></div></td>
    </tr>
    <tr>
      <td colspan="2"><div align="center"><iframe src="?page=rates&membership_id=<?php echo $_POST['membership_id'];?>" width="100%" height="200" frameborder="0"></iframe></div></td>
    </tr>
	<?php } ?>
    <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="6">
        <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">
	  <?php
	  if($_POST['membership_id'] == 1){
	  echo 'This membership can not be deleted and must stay free/public (to enable payments).';
	  } else {
	  ?>        
<input type="checkbox" id="do_delete" name="do_delete" value="yes">
Delete &amp; Move Users To:
<select id="move_to" name="move_to">
		    <option value="">-----------</option>
            <?php
	  $query = mysql_query("SELECT * FROM `memb_memberships` WHERE `membership_id`!='$_POST[membership_id]'");
	  
	  while($em = mysql_fetch_assoc($query)){
	  	echo '<option value="'.$em['membership_id'].'">'.$em['membership_title'].'</option>';
	  }
	  ?>
        </select>
		<?php } ?>
        </font></div></td>
    </tr>
  </table>
</form>
<?php } ?>