"; echo "Are you sure to init $sysTypeName 's alarm?"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; exit(); } */ echo "
It's need some minutes,Please wait...
"; if($initAll > 0){ $clearSql = "DELETE FROM sysInfoDef "; }else{ $clearSql = "DELETE FROM sysInfoDef WHERE sysTypeNo = '$sysTypeNo'"; } if($DEBUG) echo "
clearSql=$clearSql"; mysqli_query($pubConn,$clearSql); echo mysqli_error($pubConn); if($initAll > 0){ $getSysConfSql = "SELECT sysTypeNo,maxSysNum,maxSubSysNum FROM sysConf "; }else{ $getSysConfSql = "SELECT sysTypeNo,maxSysNum,maxSubSysNum FROM sysConf WHERE sysTypeNo= '$sysTypeNo' "; } if($DEBUG) echo "
getSysConfSql=$getSysConfSql"; $sysConfResult=mysqli_query($pubConn,$getSysConfSql); echo mysqli_error($pubConn); $k=0; while($sysConfRows = mysqli_fetch_array($sysConfResult)){ $sysTypeNo = $sysConfRows[sysTypeNo]; $maxSysNum = $sysConfRows[maxSysNum]; $maxSubSysNum = $sysConfRows[maxSubSysNum]; if($DEBUG) echo "
sysTypeNo=$sysTypeNo"; if($DEBUG) echo "
maxSysNum=$maxSysNum"; if($DEBUG) echo "
maxSubSysNum=$maxSubSysNum"; for($i=0;$i<$maxSysNum;$i++){ for($j=0;$j<$maxSubSysNum;$j++){ $insertSql = "REPLACE sysInfoDef (sysTypeNo,sysNo,subSysNo,ip,sysAlias) VALUES ('$sysTypeNo','$i','$j','','') "; if($DEBUG) echo "
insertSql=$insertSql"; mysqli_query($pubConn,$insertSql); echo mysqli_error($pubConn); } } if($initAll > 0){ if(($k % 10) == 0){ print(">>"); flush(); } }else{ print(">>"); flush(); } $k++; } if($initAll > 0){ echo "
All Alias initialized!
"; }else{ echo "
$sysTypeName 's Alias initialized!!"; } ?>