📄 upgrade_member.php
字号:
<?
include "logincheck.php";
include "myconnect.php";
///////////////////////////////////////////////////////////////////////////////
/// THE CODE OF THIS SCRIPT HAS BEEN DEVELOPED BY SOFTBIZ SOLUTIONS /////
/// AND IS MEANT TO BE USED ON THIS SITE ONLY AND IS NOT FOR REUSE, /////
/// RESALE OR REDISTRIBUTION. /////
/// IF YOU NOTICE ANY VIOLATION OF ABOVE PLEASE REPORT AT: /////
/// admin@softbizscripts.com /////
/// http://www.softbizscripts.com /////
/// http://www.softbizsolutions.com /////
///////////////////////////////////////////////////////////////////////////////
/////////add new code
if(count($_POST)>0)
{
$errcnt=0;
if(!checkdate($_REQUEST["month"],$_REQUEST["day"],$_REQUEST["year"]))
{
$errmsg[$errcnt]="Expiry Date value is not a valid date.";
$errcnt++;
}
$month=(int)$_REQUEST["month"];
$day=(int)$_REQUEST["day"];
$year=(int)$_REQUEST["year"];
if($month<10)
$month="0".$month;
if($day<10)
$day="0".$day;
$exp=$year.$month.$day."235959";
$memtype=(int)$_POST["memtype"];
if($errcnt==0)
{
mysql_query("update sbbleads_members set sb_memtype=$memtype,sb_expiry_date='$exp'
where sb_id=".$_POST["id"]);
if(mysql_affected_rows()>0)
{
header("Location: "."members.php?msg=".urlencode("Currency has been updated."));
die();
}
else
{
header("Location: "."upgrade_member.php?id=".$_POST["id"]."&msg=".urlencode("Some error occurred. Please try again."));
die();
}
}
}
/////////////////////
function main()
{
global $errcnt,$errmsg;
$config=mysql_fetch_array(mysql_query("select * from sbbleads_config"));
$id=$_REQUEST["id"];
$mem=mysql_fetch_array(mysql_query("select *, UNIX_TIMESTAMP(sb_expiry_date) as expiry from sbbleads_members where sb_id=$id"));
$memtype=$mem["sb_memtype"];
$day=date("d",time());
$month=date("m",time());
$year=date("Y",time());
?>
<script language="JavaScript1.1">
function Validator()
{
return (true);
}
</script>
<?
if(count($_POST)>0)
{
$memtype=$_POST["memtype"];
$day=$_POST["day"];
$month=$_POST["month"];
$year=$_POST["year"];
if($errcnt<>0)
{
?>
<table width="90%" border="0" align="center" cellpadding="2" cellspacing="0" class="errorstyle">
<tr>
<td colspan="2"><strong> Your request cannot be processed due to following
reasons</strong></td>
</tr>
<tr height="10">
<td colspan="2"></td>
</tr>
<?
for ($i=0;$i<$errcnt;$i++)
{
?>
<tr valign="top">
<td width="6%"> <?php echo $i+1;?></td>
<td width="94%"><?php echo $errmsg[$i]; ?></td>
</tr>
<?
}
?>
</table>
<?
}
}
?>
<table width="90%" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"> <div align="center">
<table width="100%" border="0" cellspacing="10" cellpadding="2">
<form action="upgrade_member.php" method="post" name="frm1" id="frm1" onSubmit="return Validator();" >
<tr align="left" class="row1">
<td height="26" colspan="3" bgcolor="#004080"><font size="3" face="Arial, Helvetica, sans-serif"><font color="#FFFFFF" size="2"><strong> Upgrade
Membership of <font color="#FFCC00"><?php
echo $mem["sb_username"];
?></font></strong></font></font></td>
</tr>
<tr class="row1">
<td align="right" bgcolor="#F5F5F5"><font size="2" face="Arial, Helvetica, sans-serif"><strong>
<input name="id" type="hidden" id="id" value="<? echo $id;?>">
Current Status:</strong></font></td>
<TD align=left valign="top" class="onepxtable"> </TD>
<td><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">Currently
<font color="#FF0000">
<?php
$mem_type=mysql_fetch_array(mysql_query("select * from sbbleads_levels where sb_id=".$mem["sb_memtype"]));
echo $mem_type["sb_levelname"];
?>
</font></font></strong><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"><B>Expired
on:</B>
<?
if($mem["expiry"]<>0)
{ echo sb_date($mem["expiry"]);}
else
{ echo $config["sb_null_char"]; }
?>
</font></strong></td>
</tr>
<tr class="row1">
<td width="40%" align="right" bgcolor="#F5F5F5"> <div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><strong>
Membership Level:</strong></font></div></td>
<TD align=left valign="top" class="onepxtable"><font color=red
size=2 face="Arial, Helvetica, sans-serif">*</font></TD>
<td width="60%"><select name="memtype">
<?php
$level_q=mysql_query("select * from sbbleads_levels order by sb_levelid");
while($level=mysql_fetch_array($level_q))
{ ?>
<option value="<?php echo $level["sb_levelid"]; ?>" <?php
if($memtype==$level["sb_levelid"]) {echo "selected";}
?>>
<?php
echo $level["sb_levelname"];
?>
</option>
<?php
}
?>
</select> </td>
</tr>
<tr valign="top" class="row1">
<td align="right" bgcolor="#F5F5F5"><font face="Verdana, Arial, Helvetica, sans-serif"><strong><font size="2" face="Arial, Helvetica, sans-serif">Expiry
Date:</font></strong></font></td>
<TD align=left class="onepxtable"><font color=red
size=2 face="Arial, Helvetica, sans-serif">*</font></TD>
<td><font size="2"><font color="#333333" face="Verdana, Arial, Helvetica, sans-serif"><strong>
<select name="month" id="select13" class="box4">
<?
for ($i=1; $i<=12; $i++)
{
?>
<option value="<? print($i); ?>"
<?
if ($i==$month)
{ echo " selected ";
}
?>
><? print($i);?></option>
<?
}//next for
?>
</select>
/
<select name="day" id="select14" class="box4">
<?
for ($i=1; $i<=31; $i++)
{
?>
<option value="<? print($i);?>"
<?
if ($i==$day)
{ echo " selected ";
}
?>
><? print($i);?></option>
<?
}
?>
</select>
/
<select name="year" id="select15" class="box4">
<?
for ($i=date("Y",time()); $i<=2020; $i++)
{
?>
<option value="<? print($i);?>"
<?
if ($i==$year)
{ echo " selected ";
}
?>
><? print($i);?></option>
<?
}
?>
</select>
</strong><font size="1">(mm/dd/yyyy) </font></font></font></td>
</tr>
<tr class="row1">
<td width="40%" align="right" bgcolor="#F5F5F5"><font size="2" face="Arial, Helvetica, sans-serif"> </font></td>
<td width="6"> </td>
<td width="60%"> <input name="Submit" type="submit" class="submit" value="Update"></td>
</tr>
</form>
</table>
</div></td>
</tr>
<tr>
<td align="left" valign="top"> <div align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong> </strong></font></div></td>
</tr>
</table>
<?
}//end main
include "template.php";
///////////////////////////////////////////////////////////////////////////////
/// THE CODE OF THIS SCRIPT HAS BEEN DEVELOPED BY SOFTBIZ SOLUTIONS /////
/// AND IS MEANT TO BE USED ON THIS SITE ONLY AND IS NOT FOR REUSE, /////
/// RESALE OR REDISTRIBUTION. /////
/// IF YOU NOTICE ANY VIOLATION OF ABOVE PLEASE REPORT AT: /////
/// admin@softbizscripts.com /////
/// http://www.softbizscripts.com /////
/// http://www.softbizsolutions.com /////
///////////////////////////////////////////////////////////////////////////////
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -