ipconmanage.php

在传统CMS文章内容管理功能基础上

<?php
/*
    [BBWPS!] (C)2006-2010 小蜜蜂版权所有.
	  This is NOT a freeware, use is subject to license terms
*/
error_reporting(7);
if(!function_exists("CheckRequire")){
	exit("Forbidden");
}
$db= new DB($hostname,$username,$password,$database);
$action=$_REQUEST["act"];
if ($action=="edit"){
	$fiid=$_POST['fiid'];
	$forbidip = $_POST['forbidip'];
	$overtime = $_POST['overtime'];
	foreach ($fiid as $value) {
		$updateSql = "update ".$prefix."forbidip set `forbidip`='".$forbidip[$value]."', `overtime`='".strtotime($overtime[$value])."' where fiid=".$value;
		$db->update($updateSql);
	}
	Meta(0,"?mod=member&f=ipconmanage");
}
elseif ($action=="add"){
	$time = time()+($_POST['forbidtime'])*86400;
	$sql = "insert into ".$prefix."forbidip set `forbidip`='$_POST[forbidip]', `forbidtime`='".time()."', `overtime`='".$time."'";
	$db->insert($sql);
	Meta("?mod=member&f=ipconmanage");
}elseif ($action=="delete"){
	$articleidA=$_POST["fiid"];
	foreach ($articleidA as $articleid){
		$db->update("delete from ".$prefix."forbidip where fiid=$articleid");
	}
	Meta(0,"?mod=member&f=ipconmanage");
}
elseif ($action=="able"){
	$ableidA=$_POST["fiid"];
	foreach ($ableidA as $ableid){
		$db->update("update ".$prefix."forbidip set forbid=1 where fiid=$ableid");
	}
	Meta(0,"?mod=member&f=ipconmanage");
}elseif ($action=="unable"){
	$ableidA=$_POST["fiid"];
	foreach ($ableidA as $ableid){
		$db->update("update ".$prefix."forbidip set forbid=0 where fiid=$ableid");
	}
	Meta(0,"?mod=member&f=ipconmanage");
}
else{
	$p=new Template("./template/member");
	if($action=="search"){
		$sid = $_GET['sip'];
	  $sql = "select fiid,forbidip,forbidtime,forbid,overtime from ".$prefix."forbidip where forbidip like '$sid%'";
	  $sql=str_replace("*","%",$sql);
	}elseif($action=="passtime"){
	  $nowTime = time();
	  $sql="select * from ".$prefix."forbidip where overtime<".$nowTime." order by fiid desc";
  }
	else{
	  $sql="select * from ".$prefix."forbidip";
  }
	$currentpage=$_GET["next"];
	!$currentpage?$whichpage=1:$whichpage=$currentpage;
  $lower_item=($whichpage-1)*30;
  $result=$db->query($sql,false);
  $allMsg=mysql_num_rows($result);
  $allPage=ceil($allMsg/30);
  $db->query($sql." limit $lower_item,30",true);
  $p->set_file("handle","ipbrowselist.html");
  $p->set_block("handle","link","lk");
  include_once("../class/QQWry.php");
  $QQWry=new QQWry;
while ($rs=$db->fetch_object()){
	$p->set_var("fiid",$rs->fiid);
	$p->set_var("forbidip",$rs->forbidip);
	if($rs->forbid=="1"){
		$p->set_var("forbid",$langAdminArray["mem_unlock"]);
	}else {
		$p->set_var("forbid",$langAdminArray["mem_lock"]);
	}
	$p->set_var("forbidtime",date("Y-m-d",$rs->forbidtime));
	$p->set_var("overtime",date("Y-m-d",$rs->overtime));
	$QQWry->QQWry($rs->forbidip);
	$p->set_var("city",$QQWry->Country);
	$p->parse("lk","link",true);
}
unset($QQWry);
$split_page=show_split_page($whichpage,$allPage,"index.php?action=ipconmanage&act=".$action);
$p->set_var("cid",$cid);
$p->set_var("articleid_desc",$sortArray[$field."_desc"]);
$p->set_var("split_page",$split_page);
$p->set_var("allpage",$allPage);
$p->set_var("allmsg",$allMsg);
$p->set_var("whichpage",$whichpage);
$p->parse("output","handle");
$p->p("output");
}
?>