esta es la otra parte que continua del codigo
Código PHP:
//**************************************************************
elseif($b=="5") {
if($_POST["id"]=="") {
$rs=mysql_query("select * from subsdetails where RDate < now() order by RDate");
if (mysql_num_rows($rs))
{
print "<br><center><h3>Subscriptions to Renew</h3></center><table width=90% border=1 cellspacing=0 cellpadding=0><tr><Td width=15 align=center>ID</td><td width=90 align=center>Name</td><td width=50 align=center>Payment Details</td><td width=190 align=center>Joining Date</td><td width=190 align=center>Renewal Date</td><td width=190 align=center>Last Update</td><td align=center valign=center>Action</td></tr>";
while($arr=mysql_fetch_array($rs))
{
$query="Select * from members where ID=".$arr[0];
$rs1=mysql_query($query);
$arr1=mysql_fetch_array($rs1);
print "<tr><Td align=center>".$arr[0]."</td><Td align=center>".$arr1[1]."</td><Td align=center>".$arr1[10]."</td><Td align=center>".$arr[1]."</td><Td align=center>".$arr[2]."</td><Td align=center>".$arr[3]."</td><Td align=center>";
print "<form action=admin.php?b=5 method=post><input type=hidden name=id value=".$arr[0]."><input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" value=\"Renew Subscriptions\"></form></td></tr>";
}
print "</table>";
}
else
{
print "<br><center><br><b>No Pending Subscriptions Records Found !</b></center>";
}
}
else {
$rs=mysql_query("update subsdetails set RDate='".date ( "Y-m-d H:i:s", mktime (date("H"),date("i"),date("s"),date("m"),date("d")+$membershipperiod,date("Y")))."' where ID=".$_POST["id"]);
$rs=mysql_query("update subsdetails set UDate='".date ( "Y-m-d H:i:s", mktime (date("H"),date("i"),date("s"),date("m"),date("d"),date("Y")))."' where ID=".$_POST["id"]);
$rs=mysql_query("Select * from members where ID=".$_POST["id"]);
$a=mysql_fetch_array($rs);
if ($a[22]!=0) {
$rs=mysql_query("update members set Total=Total+".$signupbonus.", Unpaid=Unpaid+".$signupbonus." where ID=".$a[22]);
}
for($i=1;$i<=$levels;$i++) {
if ($a[11]!=0) {
$rs=mysql_query("Select * from members where ID=".$a[11]);
if(mysql_num_rows($rs)>0) {
$arr=mysql_fetch_array($rs);
if($i==1)
{$query="update members set Total=Total+".$level1.", Unpaid=Unpaid+".$level1." where ID=".$a[11];
}
elseif($i==2)
{
$query="update members set Total=Total+".$level2.", Unpaid=Unpaid+".$level2." where ID=".$a[11];
}
elseif($i==3)
{
$query="update members set Total=Total+".$level3.", Unpaid=Unpaid+".$level3." where ID=".$a[11];
}
elseif($i==4)
{
$query="update members set Total=Total+".$level4.", Unpaid=Unpaid+".$level4." where ID=".$a[11];
}
elseif($i==5)
{
$query="update members set Total=Total+".$level5.", Unpaid=Unpaid+".$level5." where ID=".$a[11];
}
elseif($i==6)
{
$query="update members set Total=Total+".$level6.", Unpaid=Unpaid+".$level6." where ID=".$a[11];
}
elseif($i==7)
{
$query="update members set Total=Total+".$level7.", Unpaid=Unpaid+".$level7." where ID=".$a[11];
}
elseif($i==8)
{
$query="update members set Total=Total+".$level8.", Unpaid=Unpaid+".$level8." where ID=".$a[11];
}
elseif($i==9)
{
$query="update members set Total=Total+".$level9.", Unpaid=Unpaid+".$level9." where ID=".$a[11];
}
elseif($i==10)
{
$query="update members set Total=Total+".$level10.", Unpaid=Unpaid+".$level10." where ID=".$a[11];
}
$rs = mysql_query($query);
$a[11]=$arr[11];
}//end of if loop checking that ID exists or not
else
{
break;
}
}//end of if loop checking that member with this ID exists or not
else
{
break;
}
}//end of for loop
print "<b>Subscription Successfully Renewed and Commisions have been paid to upline </b>";
}
}