|
1) {
$tmpusrcurtime = new DateTime();
$tmpusrcurtime->setTimestamp($EditMem['BanTime']);
$tmpusrcurtime->setTimezone($utctz);
$BanMonth=$tmpusrcurtime->format("m");
$BanDay=$tmpusrcurtime->format("d");
$BanYear=$tmpusrcurtime->format("Y");
$EditMem['BanTime'] = $BanMonth."/".$BanDay."/".$BanYear; }
$EditMem['Interests']=sql_result($result,0,"Interests");
$EditMem['Signature']=sql_result($result,0,"Signature");
$EditMem['Avatar']=sql_result($result,0,"Avatar");
$EditMem['AvatarSize']=sql_result($result,0,"AvatarSize");
$EditMem['Title']=sql_result($result,0,"Title");
$EditMem['Website']=sql_result($result,0,"Website");
$EditMem['Gender']=sql_result($result,0,"Gender");
$EditMem['PostCount']=sql_result($result,0,"PostCount");
$EditMem['Karma']=sql_result($result,0,"Karma");
$EditMem['TimeZone']=sql_result($result,0,"TimeZone");
$EditMem['DST']=sql_result($result,0,"DST");
$EditMem['IP']=sql_result($result,0,"IP");
$mpquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."mempermissions\" WHERE \"id\"=%i LIMIT 1", array($_POST['id']));
$mpresult=sql_query($mpquery,$SQLStat);
$mpnum=sql_num_rows($mpresult);
$EditMemPerm['PermissionID'] = sql_result($mpresult,0,"PermissionID");
$EditMemPerm['CanViewBoard'] = sql_result($mpresult,0,"CanViewBoard");
$EditMemPerm['CanViewOffLine'] = sql_result($mpresult,0,"CanViewOffLine");
$EditMemPerm['CanEditProfile'] = sql_result($mpresult,0,"CanEditProfile");
$EditMemPerm['CanAddEvents'] = sql_result($mpresult,0,"CanAddEvents");
$EditMemPerm['CanPM'] = sql_result($mpresult,0,"CanPM");
$EditMemPerm['CanSearch'] = sql_result($mpresult,0,"CanSearch");
$EditMemPerm['CanDoHTML'] = sql_result($mpresult,0,"CanDoHTML");
$EditMemPerm['CanUseBBTags'] = sql_result($mpresult,0,"CanUseBBTags");
$EditMemPerm['CanViewIPAddress'] = sql_result($mpresult,0,"CanViewIPAddress");
$EditMemPerm['CanViewUserAgent'] = sql_result($mpresult,0,"CanViewUserAgent");
$EditMemPerm['FloodControl'] = sql_result($mpresult,0,"FloodControl");
$EditMemPerm['SearchFlood'] = sql_result($mpresult,0,"SearchFlood");
$EditMemPerm['HasModCP'] = sql_result($mpresult,0,"HasModCP");
$EditMemPerm['HasAdminCP'] = sql_result($mpresult,0,"HasAdminCP");
$EditMemPerm['ViewDBInfo'] = sql_result($mpresult,0,"ViewDBInfo");
$MemIPList[0] = $EditMem['IP'];
$MemIPArrayNum = 1;
$MemPostIP = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."posts\" WHERE \"UserID\"=%i ORDER BY \"TimeStamp\" ASC ", array($EditMem['ID']));
$mppresult = sql_query($MemPostIP,$SQLStat);
$mppnum = sql_num_rows($mppresult);
$mppi = 0;
while ($mppi < $mppnum) {
$MemPostCheckIP=sql_result($mppresult,$mppi,"IP");
if(!in_array($MemPostCheckIP, $MemIPList)) {
$MemIPList[$MemIPArrayNum] = $MemPostCheckIP;
++$MemIPArrayNum; }
$MemPostCheckEditIP=sql_result($mppresult,$mppi,"EditIP");
if(!in_array($MemPostCheckEditIP, $MemIPList) && $MemPostCheckEditIP!="0") {
$MemIPList[$MemIPArrayNum] = $MemPostCheckEditIP;
++$MemIPArrayNum; }
++$mppi; }
sql_free_result($mppresult);
$MemEventIP = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."posts\" WHERE \"UserID\"=%i ORDER BY \"TimeStamp\" ASC ", array($EditMem['ID']));
$mepresult = sql_query($MemEventIP,$SQLStat);
$mepnum = sql_num_rows($mepresult);
$mepi = 0;
while ($mepi < $mepnum) {
$MemEventCheckIP=sql_result($mepresult,$mepi,"IP");
if(!in_array($MemEventCheckIP, $MemIPList)) {
$MemIPList[$MemIPArrayNum] = $MemEventCheckIP;
++$MemIPArrayNum; }
++$mepi; }
sql_free_result($mepresult);
$fullistnum = count($MemIPList);
$fullisti = 0;
$fulliplist = null;
while($fullisti < $fullistnum) {
$fulliplist = $fulliplist." ".$MemIPList[$fullisti]."";
++$fullisti; }
?>
1) {
$BirthExpl = explode("/",$_POST['MemBanTime']);
if(count($BirthExpl)!="3") {
$_POST['MemBanTime'] = "0"; $BirthExpl[0] = "0"; $BirthExpl[1] = "0"; $BirthExpl[2] = "0"; }
if(!is_numeric($BirthExpl[0])) { $BirthExpl[0] = "0"; }
if(!is_numeric($BirthExpl[1])) { $BirthExpl[1] = "0"; }
if(!is_numeric($BirthExpl[2])) { $BirthExpl[2] = "0"; }
if(count($BirthExpl)=="3"&&checkdate($BirthExpl[0],$BirthExpl[1],$BirthExpl[2])===true) {
if(is_numeric($BirthExpl[0])&&is_numeric($BirthExpl[1])&&is_numeric($BirthExpl[2])) {
if(pre_strlen($BirthExpl[0])=="1") { $BirthExpl[0] = "0".$BirthExpl[0]; }
if(pre_strlen($BirthExpl[1])=="1") { $BirthExpl[1] = "0".$BirthExpl[1]; }
if(pre_strlen($BirthExpl[0])=="2"&&pre_strlen($BirthExpl[1])=="2"&&pre_strlen($BirthExpl[2])=="4") {
$BirthIn = mktime(12,12,12,$BirthExpl[0],$BirthExpl[1],$BirthExpl[2]);
$tmpusrcurtime = new DateTime();
$tmpusrcurtime->setTimestamp($BirthIn);
$tmpusrcurtime->setTimezone($utctz);
$BirthMonth=$tmpusrcurtime->format("m");
$BirthDay=$tmpusrcurtime->format("d");
$BirthYear=$tmpusrcurtime->format("Y");
$_POST['MemBanTime'] = $BirthIn; }
if(pre_strlen($BirthExpl[0])!="2"||pre_strlen($BirthExpl[1])!="2"||pre_strlen($BirthExpl[2])!="4") {
$_POST['MemBanTime'] = "0"; $BirthMonth="0"; $BirthDay="0"; $BirthYear="0"; } }
if (!is_numeric($BirthExpl[0])||!is_numeric($BirthExpl[1])||!is_numeric($BirthExpl[2])) {
$_POST['MemBanTime'] = "0"; $BirthMonth="0"; $BirthDay="0"; $BirthYear="0"; } }
if(count($BirthExpl)=="3"&&
checkdate($BirthExpl[0],$BirthExpl[1],$BirthExpl[2])===false) {
$_POST['MemBanTime'] = "0"; $BirthMonth="0"; $BirthDay="0"; $BirthYear="0"; }
if(count($BirthExpl)!="3") {
$_POST['MemBanTime'] = "0"; $BirthMonth="0"; $BirthDay="0"; $BirthYear="0"; } }
if($DMemName!==null&&($_POST['id']!="0"||$_POST['id']!="-1")&&
($_POST['gid']!=$GuestGroupID||$_POST['gid']!=$ValidateGroupID)) {
if($_POST['MemName']==$DMemName||$username_check>=1) {
if($_POST['id']!=1) {
if(!is_numeric($_POST['MemPermID'])) { $_POST['MemPermID'] = "0"; }
$dmquery = sql_pre_query("UPDATE \"".$Settings['sqltable']."members\" SET \"GroupID\"=%i,\"LevelID\"=%i,\"HiddenMember\"='%s',\"WarnLevel\"=%i,\"BanTime\"=%i,\"PostCount\"=%i,\"Karma\"=%i WHERE \"id\"=%i", array($_POST['gid'],$_POST['lid'],$_POST['MemHidden'],$_POST['MemWarnLevel'],$_POST['MemBanTime'],$_POST['MemPostCount'],$_POST['MemKarma'],$_POST['id']));
$dpmquery = sql_pre_query("UPDATE \"".$Settings['sqltable']."mempermissions\" SET \"PermissionID\"=%i,\"CanViewBoard\"='%s',\"CanViewOffLine\"='%s',\"CanEditProfile\"='%s',\"CanAddEvents\"='%s',\"CanPM\"='%s',\"CanSearch\"='%s',\"CanDoHTML\"='%s',\"CanUseBBTags\"='%s',\"CanViewIPAddress\"='%s',\"CanViewUserAgent\"='%s',\"FloodControl\"=%i,\"SearchFlood\"=%i,\"HasModCP\"='%s',\"HasAdminCP\"='%s',\"ViewDBInfo\"='%s' WHERE \"id\"=%i", array($_POST['MemPermID'],$_POST['CanViewBoard'],$_POST['CanViewOffLine'],$_POST['CanEditProfile'],$_POST['CanAddEvents'],$_POST['CanPM'],$_POST['CanSearch'],$_POST['CanDoHTML'],$_POST['CanUseBBTags'],$_POST['CanViewIPAddress'],$_POST['CanViewUserAgent'],$_POST['FloodControl'],$_POST['SearchFlood'],$_POST['HasModCP'],$_POST['HasAdminCP'],$_POST['ViewDBInfo'],$_POST['id'])); }
if($_POST['id']==1) {
$dmquery = sql_pre_query("UPDATE \"".$Settings['sqltable']."members\" SET \"HiddenMember\"='%s',\"WarnLevel\"=%i,\"BanTime\"=%i,\"PostCount\"=%i,\"Karma\"=%i WHERE \"id\"=%i", array($_POST['MemHidden'],$_POST['MemWarnLevel'],$_POST['MemBanTime'],$_POST['MemPostCount'],$_POST['MemKarma'],$_POST['id']));
$dpmquery = sql_pre_query("UPDATE \"".$Settings['sqltable']."mempermissions\" SET \"CanDoHTML\"='%s',\"CanUseBBTags\"='%s',\"FloodControl\"=%i,\"SearchFlood\"=%i WHERE \"id\"=%i", array($_POST['CanDoHTML'],$_POST['CanUseBBTags'],$_POST['FloodControl'],$_POST['SearchFlood'],$_POST['id'])); } }
if($_POST['MemName']!=$DMemName&&$username_check<1) {
if($_POST['id']!=1) {
if(!is_numeric($_POST['MemPermID'])) { $_POST['MemPermID'] = "0"; }
$dmquery = sql_pre_query("UPDATE \"".$Settings['sqltable']."members\" SET \"Name\"='%s',\"GroupID\"=%i,\"LevelID\"=%i,\"HiddenMember\"='%s',\"WarnLevel\"=%i,\"BanTime\"=%i,\"PostCount\"=%i,\"Karma\"=%i WHERE \"id\"=%i", array($_POST['MemName'],$_POST['gid'],$_POST['lid'],$_POST['MemHidden'],$_POST['MemWarnLevel'],$_POST['MemBanTime'],$_POST['MemPostCount'],$_POST['MemKarma'],$_POST['id']));
$dpmquery = sql_pre_query("UPDATE \"".$Settings['sqltable']."mempermissions\" SET \"PermissionID\"=%i,\"CanViewBoard\"='%s',\"CanViewOffLine\"='%s',\"CanEditProfile\"='%s',\"CanAddEvents\"='%s',\"CanPM\"='%s',\"CanSearch\"='%s',\"CanDoHTML\"='%s',\"CanUseBBTags\"='%s',\"CanViewIPAddress\"='%s',\"CanViewUserAgent\"='%s',\"FloodControl\"=%i,\"SearchFlood\"=%i,\"HasModCP\"='%s',\"HasAdminCP\"='%s',\"ViewDBInfo\"='%s' WHERE \"id\"=%i", array($_POST['MemPermID'],$_POST['CanViewBoard'],$_POST['CanViewOffLine'],$_POST['CanEditProfile'],$_POST['CanAddEvents'],$_POST['CanPM'],$_POST['CanSearch'],$_POST['CanDoHTML'],$_POST['CanUseBBTags'],$_POST['CanViewIPAddress'],$_POST['CanViewUserAgent'],$_POST['FloodControl'],$_POST['SearchFlood'],$_POST['HasModCP'],$_POST['HasAdminCP'],$_POST['ViewDBInfo'],$_POST['id'])); }
if($_POST['id']==1) {
$dmquery = sql_pre_query("UPDATE \"".$Settings['sqltable']."members\" SET \"Name\"='%s',\"HiddenMember\"='%s',\"WarnLevel\"=%i,\"BanTime\"=%i,\"PostCount\"=%i,\"Karma\"=%i WHERE \"id\"=%i", array($_POST['MemName'],$_POST['MemHidden'],$_POST['MemWarnLevel'],$_POST['MemBanTime'],$_POST['MemPostCount'],$_POST['MemKarma'],$_POST['id']));
$dpmquery = sql_pre_query("UPDATE \"".$Settings['sqltable']."mempermissions\" SET \"CanViewBoard\"='%s',\"CanViewOffLine\"='%s',\"CanEditProfile\"='%s',\"CanAddEvents\"='%s',\"CanPM\"='%s',\"CanSearch\"='%s',\"CanDoHTML\"='%s',\"CanUseBBTags\"='%s',\"CanViewIPAddress\"='%s',\"CanViewUserAgent\"='%s',\"FloodControl\"=%i,\"SearchFlood\"=%i WHERE \"id\"=%i", array($_POST['CanViewBoard'],$_POST['CanViewOffLine'],$_POST['CanEditProfile'],$_POST['CanAddEvents'],$_POST['CanPM'],$_POST['CanSearch'],$_POST['CanDoHTML'],$_POST['CanUseBBTags'],$_POST['CanViewIPAddress'],$_POST['CanViewUserAgent'],$_POST['FloodControl'],$_POST['SearchFlood'],$_POST['id'])); } }
sql_query($dmquery,$SQLStat);
sql_query($dpmquery,$SQLStat); }
?>
|