📄 member.inc.php
字号:
<?php
function membercattree( $url, $tblcat )
{
global $msql;
global $strTopCat;
$FormString .= "<table width=100% border=0 cellspacing=3 cellpadding=0><tr><td class=dtree>";
$FormString .= "<script type=text/javascript src=js/dirtree.js></script>";
$FormString .= "<script type=text/javascript> <!-- \n";
$FormString .= "function dtree(){";
$FormString .= "d = new dTree('d');";
$FormString .= "d.add(0,-1,'".$strTopCat."','{$url}?pid=0'); \n";
$msql->query( "select * from {$tblcat} order by xuhao" );
while ( $msql->next_record( ) )
{
$catid = $msql->f( "catid" );
$pid = $msql->f( "pid" );
$cat = $msql->f( "cat" );
$FormString .= "d.add({$catid},{$pid},'{$cat}','{$url}?pid={$catid}'); \n";
}
$FormString .= "document.write(d); } \n //--></script><script>dtree();</script>";
$FormString .= "</td></tr></table>";
echo $FormString;
}
function membertypeid2membertype( $membertypeid )
{
global $fsql;
global $tbl_member_type;
global $strMemberTypeAll;
$fsql->query( "select membertype from {$tbl_member_type} where membertypeid='{$membertypeid}'" );
if ( $fsql->next_record( ) )
{
$membertype = $fsql->f( "membertype" );
}
else
{
$membertype = $strMemberTypeAll;
}
return $membertype;
}
function memberid2user( $memberid )
{
global $fsql;
global $tbl_member;
$fsql->query( "select user from {$tbl_member} where memberid='{$memberid}'" );
if ( $fsql->next_record( ) )
{
$user = $fsql->f( "user" );
}
return $user;
}
function memberdel( $memberid )
{
global $msql;
global $tbl_member;
global $tbl_member_rights;
global $tbl_member_nums;
global $strMemberNotice2;
if ( isset( $memberid ) && $memberid != "" )
{
$msql->query( "delete from {$tbl_member_rights} where memberid='{$memberid}'" );
$msql->query( "delete from {$tbl_member_nums} where memberid='{$memberid}'" );
$msql->query( "delete from {$tbl_member} where memberid='{$memberid}'" );
}
else
{
err( $strMemberNotice2, "", "" );
}
}
function default2member( $memberid, $changetypeid )
{
global $msql;
global $fsql;
global $tbl_member_rights;
global $tbl_default_rights;
global $strMemberNotice3;
if ( $memberid == "" || $changetypeid == "" )
{
err( $strMemberNotice3, "", "" );
}
else
{
$msql->query( "delete from {$tbl_member_rights} where memberid='{$memberid}'" );
$msql->query( "select * from {$tbl_default_rights} where membertypeid='{$changetypeid}'" );
while ( $msql->next_record( ) )
{
$secureid = $msql->f( "secureid" );
$securetype = $msql->f( "securetype" );
$secureset = $msql->f( "secureset" );
$fsql->query( "insert into {$tbl_member_rights} values(\r\n\t\t0,\r\n\t '{$memberid}',\r\n\t '{$secureid}',\r\n\t '{$securetype}',\r\n\t '{$secureset}'\r\n\t\t)" );
}
}
}
function showexptime( $exptime )
{
global $strNolimit;
if ( $exptime == 0 )
{
$sayexptime = $strNolimit;
}
else if ( $exptime <= time( ) - 1 )
{
$sayexptime = "<font color=red>".date( "Y-n-j", $exptime )."</font>";
}
else
{
$sayexptime = date( "Y-n-j", $exptime );
}
echo $sayexptime;
}
function memberform( $membertypeid )
{
global $msql;
global $fsql;
global $tsql;
global $tbl_member_regform;
global $tbl_member_zone;
global $tbl_member_cat;
global $company;
global $name;
global $user;
global $password;
global $sex;
global $birthday;
global $addr;
global $tel;
global $mov;
global $fax;
global $postcode;
global $email;
global $url;
global $Province;
global $zoneid;
global $passtype;
global $passcode;
global $qq;
global $msn;
global $maillist;
global $bz;
global $catid;
global $strMemberResetPass;
global $strMan;
global $strWoman;
global $strYear;
global $strMonth;
global $strDay;
$birth0 = substr( $birthday, 0, 4 );
$birth1 = substr( $birthday, 4, 2 );
$birth2 = substr( $birthday, 6, 2 );
$tbl_member_regform_now = $tbl_member_regform."_".$membertypeid;
$msql->query( "select * from {$tbl_member_regform_now} where used='1' and formcolname!='repass' order by xuhao" );
while ( $msql->next_record( ) )
{
$formcolname = $msql->f( "formcolname" );
$formname = $msql->f( "formname" );
$FormString .= "<tr>";
switch ( $formcolname )
{
case "user" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input readonly class=input type=text size=25 name=u value='".$user."'> ".$mustfillstr." ".$intro."</td>";
break;
case "password" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=password size=25 name=".$formcolname." value='******'> ".$mustfillstr." ".$intro." <input type=checkbox name=ResetPass value='yes' onClick=\"regform.password.value='';regform.password.focus()\">".$strMemberResetPass."</td>";
break;
case "company" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=50 name=".$formcolname." value='".$company."'> ".$mustfillstr." ".$intro."</td>";
break;
case "name" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=30 name=".$formcolname." value='".$name."'> ".$mustfillstr." ".$intro."</td>";
break;
case "sex" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><select name=".$formcolname." class=input><option value='1' ".seld( $sex, "1" ).">".$strMan."</option><option value='2' ".seld( $sex, "2" ).">".$strWoman."</option></select> ".$mustfillstr." ".$intro."</td>";
break;
case "zoneid" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con>";
$FormString .= "<SCRIPT language=javascript src='js/zone.js'></SCRIPT>";
$FormString .= "<script language=javascript>";
$fsql->query( "select * from {$tbl_member_zone} where pid = '0' order by xuhao" );
$i = 0;
while ( $fsql->next_record( ) )
{
$zone_id = $fsql->f( "catid" );
$zone = $fsql->f( "cat" );
$FormString .= "pList.add(new province(\"{$zone}\",\"{$zone_id}\"));";
$tsql->query( "select * from {$tbl_member_zone} where pid = '{$zone_id}' order by xuhao " );
$e = 0;
while ( $tsql->next_record( ) )
{
$szoneid = $tsql->f( "catid" );
$szone = $tsql->f( "cat" );
$FormString .= "pList.addAt('{$i}',new area(\"{$szone}\",\"{$szoneid}\"));";
if ( $szoneid == $zoneid )
{
$Province = $i;
}
$e++;
}
if ( $e < 1 )
{
$FormString .= "pList.addAt('{$i}',new area(\"ALL\",\"{$zone_id}\"));";
if ( $zone_id == $zoneid )
{
$Province = $i;
}
}
$i++;
}
$FormString .= "</script>";
$FormString .= "<select onKeyUp='if(window.event.keyCode==13) document.regform.zoneid.focus();' onChange=provinceSelChange(regform.zoneid,regform.Province.value,'".$zoneid."') name=Province>";
$FormString .= "<script language=javascript>";
$FormString .= "document.write(pList.getOptionString('".$Province."'));";
$FormString .= "</script></select>";
$FormString .= "<div id='zonediv' style='position:absolute; width:150px; height:26px; z-index:1'>";
$FormString .= "<select onKeyUp='if(window.event.keyCode==13) document.regform.regCardNum.focus();' name=zoneid>";
$FormString .= "<script language=javascript>";
$FormString .= "document.write(pList.getOptionAreasString(regform.Province.value,regform.zoneid,'".$zoneid."',1));";
$FormString .= "</script></select></div>";
$FormString .= $mustfillstr." ".$intro."</td>";
break;
case "catid" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><select name='catid'>";
$fsql->query( "select * from {$tbl_member_cat} order by catpath" );
while ( $fsql->next_record( ) )
{
$lpid = $fsql->f( "pid" );
$lcatid = $fsql->f( "catid" );
$cat = $fsql->f( "cat" );
$catpath = $fsql->f( "catpath" );
$lcatpath = explode( ":", $catpath );
$tsql->query( "select catid from {$tbl_member_cat} where pid='{$lcatid}'" );
if ( $tsql->next_record( ) )
{
$ifson = "yes";
}
else
{
$ifson = "no";
}
if ( $ifson == "no" )
{
$i = 0;
for ( ; $i < sizeof( $lcatpath ) - 2; $i++ )
{
$tsql->query( "select catid,cat from {$tbl_member_cat} where catid='{$lcatpath[$i]}'" );
if ( $tsql->next_record( ) )
{
$ncatid = $tsql->f( "cat" );
$ncat = $tsql->f( "cat" );
$ppcat .= $ncat."/";
}
}
if ( $catid == $lcatid )
{
$str .= "<option value='".$lcatid."' selected>".$ppcat.$cat."</option>";
}
else
{
$str .= "<option value='".$lcatid."'>".$ppcat.$cat."</option>";
}
$ppcat = "";
}
}
$FormString .= $str."</select>";
$FormString .= $mustfillstr." ".$intro."</td>";
break;
case "addr" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=50 name=".$formcolname." value='".$addr."'> ".$mustfillstr." ".$intro."</td>";
break;
case "tel" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=30 name=".$formcolname." value='".$tel."'> ".$mustfillstr." ".$intro."</td>";
break;
case "fax" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=30 name=".$formcolname." value='".$fax."'> ".$mustfillstr." ".$intro."</td>";
break;
case "mov" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=30 name=".$formcolname." value='".$mov."'> ".$mustfillstr." ".$intro."</td>";
break;
case "postcode" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=6 name=".$formcolname." value='".$postcode."'> ".$mustfillstr." ".$intro."</td>";
break;
case "email" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=50 name=".$formcolname." value='".$email."'> ".$mustfillstr." ".$intro."</td>";
break;
case "url" :
if ( !isset( $url ) || $url == "" )
{
$url = "http://";
}
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=50 name=".$formcolname." value='".$url."'> ".$mustfillstr." ".$intro."</td>";
break;
case "passtype" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=30 name=".$formcolname." value='".$passtype."'> ".$mustfillstr." ".$intro."</td>";
break;
case "passcode" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=30 name=".$formcolname." value='".$passcode."'> ".$mustfillstr." ".$intro."</td>";
break;
case "qq" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=30 name=".$formcolname." value='".$qq."'> ".$mustfillstr." ".$intro."</td>";
break;
case "msn" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=50 name=".$formcolname." value='".$msn."'> ".$mustfillstr." ".$intro."</td>";
break;
case "maillist" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input type=checkbox name=maillist value='1' ".checked( $maillist, "1" )."> ".$mustfillstr." ".$intro."</td>";
break;
case "bz" :
$FormString .= "<td class=title align=right >".$formname."</td><td class=con><textarea class=input1 name=bz cols=50 rows=3>".$bz."</textarea> ".$mustfillstr." ".$intro."</td>";
break;
case "birthday" :
$FormString .= "<td class=title align=right>".$formname."</td><td class=con><input class=input type=text size=4 name=birth0 value='".$birth0."'> ".$strYear." <input class=input type=text size=2 name=birth1 value='".$birth1."'> ".$strMonth." <input class=input type=text size=2 name=birth2 value='".$birth2."'> ".$strDay." ".$mustfillstr." ".$intro."</td>";
break;
}
$FormString .= "</tr>";
}
return $FormString;
}
function explist( $ho, $mi, $se, $mm, $dd, $yy )
{
global $strYear;
global $strMonth;
global $strDay;
$String = "<select name=yy>";
$i = 2006;
for ( ; $i <= 2030; $i++ )
{
if ( $i == $yy )
{
$String .= "<option value=".$i." selected>".$i."</option>";
}
else
{
$String .= "<option value=".$i.">".$i."</option>";
}
}
$String .= "</select> ".$strYear;
$String .= "<select name=mm>";
$i = 1;
for ( ; $i <= 12; $i++ )
{
if ( strlen( $i ) < 2 )
{
$ii = "0".$i;
}
else
{
$ii = $i;
}
if ( $ii == $mm )
{
$String .= "<option value=".$ii." selected>".$i."</option>";
}
else
{
$String .= "<option value=".$ii.">".$i."</option>";
}
}
$String .= "</select> ".$strMonth;
$String .= "<select name=dd>";
$i = 1;
for ( ; $i <= 31; $i++ )
{
if ( strlen( $i ) < 2 )
{
$ii = "0".$i;
}
else
{
$ii = $i;
}
if ( $ii == $dd )
{
$String .= "<option value=".$ii." selected>".$i."</option>";
}
else
{
$String .= "<option value=".$ii.">".$i."</option>";
}
}
$String .= "</select> ".$strDay;
$String .= "<input type=hidden name=ho value=".$ho.">";
$String .= "<input type=hidden name=mi value=".$mi.">";
$String .= "<input type=hidden name=se value=".$se.">";
return $String;
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -