📄 members1.php
字号:
<td><font size="1"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="email.php?id=<? echo $rs_query["sb_email"];?>&return_str=<? echo $return_str;?>"><? echo $rs_query["sb_email"]; ?></a></font></strong></font></td>
</tr>
<tr>
<td><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">#
<? echo " ".$rs_query["sb_id"]; ?></font></td>
</tr>
<tr>
<td><font size="1" face="Arial, Helvetica, sans-serif"> </font></td>
</tr>
<tr>
<td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"><B>Registered
on:</B><br>
<?
echo sb_date($rs_query["signup"]);
?>
</font></strong></td>
</tr>
<tr>
<td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif">Last
Login:<br>
<?
if($rs_query["lastlogin"]<>0)
{ echo sb_date($rs_query["lastlogin"]);}
else
{ echo $config["sb_null_char"]; }
?>
</font></strong></td>
</tr>
</table></td>
<td width="136" bgcolor="<? echo $bgcolor?>"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"><? echo $rs_query["sb_username"]; ?></font></strong></td>
</tr>
<tr>
<td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif">
<?
echo $rs_query["sb_firstname"]." ".$rs_query["sb_lastname"];
?>
</font></strong></td>
</tr>
<tr>
<td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif">
<?
echo $rs_query["sb_street"];
?>
</font></strong></td>
</tr>
<tr>
<td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif">
<?
echo $rs_query["sb_zip"].", ".$rs_query["sb_city"];
?>
</font></strong></td>
</tr>
<tr>
<td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif">
<?
echo $rs_query["sb_state"].", ";
$country=mysql_fetch_array(mysql_query("select * from sbbleads_country where id=".$rs_query["sb_country"]));
if($country)
{
echo " ".$country["country"];
}
?>
</font></strong></td>
</tr>
</table></td>
<td align="left" bgcolor="<? echo $bgcolor?>">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<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=".$rs_query["sb_memtype"]));
echo $mem_type["sb_levelname"];
?>
</font> </font></strong></td>
</tr>
<tr>
<td><strong><font color="#333333" size="1" face="Arial, Helvetica, sans-serif"><B>Expired
on:</B><br>
<?
if($rs_query["expiry"]<>0)
{ echo sb_date($rs_query["expiry"]);}
else
{ echo $config["sb_null_char"]; }
?>
</font></strong></td>
</tr>
<tr>
<form name="form2" method="post" action="members.php">
<td>
<input name="id" type="hidden" id="id" value="<? echo $rs_query["sb_id"];?>">
<input type="submit" name="subscription" value="Update Subscription" onClick="javascript: return confirm('Do you really want to update subscription of this Member?');">
</td></form>
</tr>
<tr>
<form name="form1" method="post" action="members.php" ><td>
<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($rs_query["sb_memtype"]==$level["sb_levelid"]) {echo "selected";}
?>><?php
echo $level["sb_levelname"];
?></option><?php
}
?></select>
<input name="id" type="hidden" id="id" value="<? echo $rs_query["sb_id"];?>">
<input type="submit" name="Update" value="Update" onClick="javascript: return confirm('Do you really want to update Membership?');">
</td></form>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
<td width="169" align="right" bgcolor="<? echo $bgcolor?>"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">Offers
Posted </font></strong></font><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif"> </font></font></td>
</tr>
<tr>
<td align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">Sell
Offers</font></strong></font></td>
<td align="left">
<a href="selloffers.php?sb_uid=<?php echo $rs_query["sb_id"];?>">
<font size="1" face="Arial, Helvetica, sans-serif"><?
$num=mysql_query("select * from sbbleads_offers where sb_uid=".$rs_query["sb_id"]);
$num=mysql_num_rows($num);
echo $num;
?></font></a></td>
</tr>
<tr>
<td align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">Buy
Offers</font></strong></font></td>
<td align="left"><a href="buyoffers.php?sb_uid=<?php echo $rs_query["sb_id"];?>">
<font size="1" face="Arial, Helvetica, sans-serif">
<?
$num=mysql_query("select * from sbbleads_offers_buy where sb_uid=".$rs_query["sb_id"]);
$num=mysql_num_rows($num);
echo $num;
?>
</font></a></td>
</tr>
<tr>
<td align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">Product
Catalogs </font></strong></font></td>
<td align="left"><a href="products.php?sb_uid=<?php echo $rs_query["sb_id"];?>">
<font size="1" face="Arial, Helvetica, sans-serif">
<?
$num=mysql_query("select * from sbbleads_products where sb_uid=".$rs_query["sb_id"]);
$num=mysql_num_rows($num);
echo $num;
?>
</font></a></td>
</tr>
<tr valign="top">
<td align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif">
Company Profile</font></strong></font></td>
<td align="left"> <font size="1" face="Arial, Helvetica, sans-serif">
<?
$num=mysql_query("select * from sbbleads_companyprofiles where sb_uid=".$rs_query["sb_id"]);
$num=mysql_num_rows($num);
if($num>0)
{
?>
<a href="profiles.php?sb_uid=<?php echo $rs_query["sb_id"];?>"> <font size="1" face="Arial, Helvetica, sans-serif">
Yes</a>
<?
}
else
echo "No";
?>
</font></td>
</tr>
</table></td>
</tr>
<tr valign="top">
<td height="25" colspan="4" bgcolor="<? echo $bgcolor?>"><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="editmember.php?id=<? echo $rs_query["sb_id"];?>" >Edit
Profile</a>] </font><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="delete_member.php?id=<? echo $rs_query["sb_id"];?>" onClick="javascript: return confirm('All the Offers and other information related to the Member will be deleted.\n\nDo you really want to delete the Member?');">Delete</a>]
</font><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="messages.php?both_m=<? echo $rs_query["sb_id"];?>">Mailbox</a>] </font><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="messages.php?from_m=<? echo $rs_query["sb_id"];?>">Messages
Sent</a>] </font><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="messages.php?to_m=<? echo $rs_query["sb_id"];?>">Messages
Recieved</a>]</font><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif"><font size="1"> </font><font size="2" face="Arial, Helvetica, sans-serif"><font size="1">[<a href="suspend_member.php?sb_id=<? echo $rs_query["sb_id"];?>"><?php
if($rs_query["sb_suspended"]=="no")
{ echo "Suspend";}
else
{ echo "Unsuspend";}
?></a>] [<a href="upgrade_member.php?id=<? echo $rs_query["sb_id"];?>">
Upgrade Membership</a>]</font></font></font></font></font></font></font></font></font></font></font></td>
</tr>
<?
$cnt=$cnt+1;
$jmpcnt=$jmpcnt+1;
$rs_query=mysql_fetch_array($query);
}// wend
?>
</table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25" bgcolor="#004080"> <p> <strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">
Pages:
<?
if ($pg>1)
{
echo " <a href='".$_SERVER['PHP_SELF']."?pg=".($pg-1).$strpass."' class='pagelink'><font color='#FFCC00'>";
}//end if
if ($pages<>1)
echo "Previous";
if ($pg>1)
{
echo "</font></a> ";
}//end if
echo " ";
for ($i=1; $i<=$pages; $i++)
{
if ($pg<>$i)
{
echo " <a href='".$_SERVER['PHP_SELF']."?pg=".$i.$strpass."' class='pagelink'><font color='#FFCC00'>";
echo $i;
echo "</font></a> ";
}
else
{
echo " ".$i." ";
}
}//for
echo " ";
if ($pg<$pages )
{
echo " <a href='".$_SERVER['PHP_SELF']."?pg=".($pg+1).$strpass."' class='pagelink'><font color='#FFCC00'>";
}//end if
if ($pages<>1)
{
echo "Next";
}//end if
if ($pg<>($pages))
{
echo "</font></a> ";
}//end if
?>
</font></strong></p></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td><div align="center"> </div></td>
</tr>
</table></td>
</tr>
</table>
<?
}//main()
include "template.php";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -