PHP insert_dolog函数代码示例

function EditMemberConnect($add, $userid, $username)
{
    global $empire, $dbtbpre;
    $add[id] = (int) $add[id];
    if (empty($add[appname]) || !$add[id]) {
        printerror("EmptyMemberConnect", "history.go(-1)");
    }
    $add[isclose] = (int) $add[isclose];
    $add[myorder] = (int) $add[myorder];
    $add[appname] = eaddslashes(ehtmlspecialchars($add[appname]));
    $add[appid] = eaddslashes($add[appid]);
    $add[appkey] = eaddslashes($add[appkey]);
    $add[qappname] = eaddslashes($add[qappname]);
    $add[appsay] = eaddslashes($add[appsay]);
    $sql = $empire->query("update {$dbtbpre}enewsmember_connect_app set appname='{$add['appname']}',appid='{$add['appid']}',appkey='{$add['appkey']}',isclose='{$add['isclose']}',myorder='{$add['myorder']}',qappname='{$add['qappname']}',appsay='{$add['appsay']}' where id='{$add['id']}'");
    $appr = $empire->fetch1("select apptype from {$dbtbpre}enewsmember_connect_app where id='{$add['id']}'");
    if ($sql) {
        GetConfig();
        //操作日志
        insert_dolog("id=" . $add[id] . "&apptype=" . $appr[apptype] . "<br>appname=" . $add[appname]);
        printerror("EditMemberConnectSuccess", "MemberConnect.php" . hReturnEcmsHashStrHref2(1));
    } else {
        printerror("DbError", "history.go(-1)");
    }
}

function ClearSearchAll($start, $line, $userid, $username)
{
    global $empire, $dbtbpre, $class_r, $fun_r;
    $line = (int) $line;
    if (empty($line)) {
        $line = 500;
    }
    $start = (int) $start;
    $b = 0;
    $sql = $empire->query("select id,classid,sid from {$dbtbpre}enewssearchall where sid>{$start} order by sid limit " . $line);
    while ($r = $empire->fetch($sql)) {
        $b = 1;
        $newstart = $r['sid'];
        if (empty($class_r[$r[classid]]['tbname'])) {
            $empire->query("delete from {$dbtbpre}enewssearchall where sid='{$r['sid']}'");
            continue;
        }
        $num = $empire->gettotal("select count(*) as total from {$dbtbpre}ecms_" . $class_r[$r[classid]]['tbname'] . " where id='{$r['id']}' and classid='{$r['classid']}' limit 1");
        if (!$num) {
            $empire->query("delete from {$dbtbpre}enewssearchall where sid='{$r['sid']}'");
        }
    }
    if (empty($b)) {
        //操作日志
        insert_dolog("");
        printerror('ClearSearchAllSuccess', 'ClearSearchAll.php');
    }
    echo "<meta http-equiv=\"refresh\" content=\"0;url=ClearSearchAll.php?enews=ClearSearchAll&line={$line}&start={$newstart}\">" . $fun_r[OneClearSearchAllSuccess] . "(ID:<font color=red><b>" . $newstart . "</b></font>)";
    exit;
}

function DelAdClass($classid, $userid, $username)
{
    global $empire, $public_r, $dbtbpre;
    $classid = (int) $classid;
    if (!$classid) {
        printerror("NotChangeAdClassid", "history.go(-1)");
    }
    //验证权限
    CheckLevel($userid, $username, $classid, "ad");
    $c = $empire->fetch1("select classname from {$dbtbpre}enewsadclass where classid='{$classid}'");
    $sql = $empire->query("delete from {$dbtbpre}enewsadclass where classid='{$classid}'");
    /*
    //删除广告内容
    $a=$empire->query("select adid from {$dbtbpre}enewsad where classid='$classid'");
    while($r=$empire->fetch($a))
    {
    	$file="../../../d/js/acmsd/".$public_r[adfile].$r[adid].".js";
    	DelFiletext($file);
        }
    */
    if ($sql) {
        //操作日志
        insert_dolog("classid=" . $classid . "<br>classname=" . $c[classname]);
        printerror("DelAdClassSuccess", "AdClass.php");
    } else {
        printerror("DbError", "history.go(-1)");
    }
}

function EditPlface($add, $userid, $username)
{
    global $empire, $dbtbpre;
    $facefile = $add[facefile];
    $faceword = $add[faceword];
    $count = count($faceword);
    $plface = '||';
    for ($i = 0; $i < $count; $i++) {
        $facefile[$i] = DoRepPlface($facefile[$i]);
        $faceword[$i] = DoRepPlface($faceword[$i]);
        if ($faceword[$i]) {
            $plface .= $faceword[$i] . "##" . $facefile[$i] . "||";
        }
    }
    $sql = $empire->query("update {$dbtbpre}enewspublic set plface='{$plface}' limit 1");
    if ($sql) {
        GetPlfaceJs();
        GetConfig();
        //操作日志
        insert_dolog("");
        printerror("EditPlfaceSuccess", "plface.php");
    } else {
        printerror("DbError", "history.go(-1)");
    }
}

function DelSearchKey_all($add, $userid, $username)
{
    global $empire, $dbtbpre;
    //验证权限
    CheckLevel($userid, $username, $classid, "searchkey");
    $searchid = $add['searchid'];
    $count = count($searchid);
    if (empty($count)) {
        printerror("EmptySearchId", "history.go(-1)");
    }
    $ids = '';
    for ($i = 0; $i < $count; $i++) {
        $dh = ',';
        if ($i == 0) {
            $dh = '';
        }
        $ids .= $dh . intval($searchid[$i]);
    }
    $sql = $empire->query("delete from {$dbtbpre}enewssearch where searchid in (" . $ids . ");");
    if ($sql) {
        //操作日志
        insert_dolog("");
        printerror("DelSearchKeySuccess", "SearchKey.php" . hReturnEcmsHashStrHref2(1));
    } else {
        printerror("DbError", "history.go(-1)");
    }
}

function ReInfoUrl($start, $classid, $from, $retype, $startday, $endday, $startid, $endid, $tbname, $userid, $username)
{
    global $empire, $public_r, $class_r, $fun_r, $dbtbpre;
    //验证权限
    //CheckLevel($userid,$username,$classid,"changedata");
    $start = (int) $start;
    $tbname = RepPostVar($tbname);
    if (empty($tbname) || !eCheckTbname($tbname)) {
        printerror("ErrorUrl", "history.go(-1)");
    }
    $add1 = '';
    //按栏目刷新
    $classid = (int) $classid;
    if ($classid) {
        if (empty($class_r[$classid][islast])) {
            $where = ReturnClass($class_r[$classid][sonclass]);
        } else {
            $where = "classid='{$classid}'";
        }
        $add1 = " and (" . $where . ")";
    }
    //按ID刷新
    if ($retype) {
        $startid = (int) $startid;
        $endid = (int) $endid;
        if ($endid) {
            $add1 .= " and id>={$startid} and id<={$endid}";
        }
    } else {
        $startday = RepPostVar($startday);
        $endday = RepPostVar($endday);
        if ($startday && $endday) {
            $add1 .= " and truetime>=" . to_time($startday . " 00:00:00") . " and truetime<=" . to_time($endday . " 23:59:59");
        }
    }
    $b = 0;
    $sql = $empire->query("select id,classid,checked from {$dbtbpre}ecms_" . $tbname . "_index where id>{$start}" . $add1 . " order by id limit " . $public_r[delnewsnum]);
    while ($r = $empire->fetch($sql)) {
        $b = 1;
        $new_start = $r[id];
        //返回表
        $infotb = ReturnInfoMainTbname($tbname, $r['checked']);
        $infor = $empire->fetch1("select newspath,filename,groupid,isurl,titleurl from " . $infotb . " where id='{$r['id']}' limit 1");
        $infourl = GotoGetTitleUrl($r['classid'], $r['id'], $infor['newspath'], $infor['filename'], $infor['groupid'], $infor['isurl'], $infor['titleurl']);
        $empire->query("update " . $infotb . " set titleurl='{$infourl}' where id='{$r['id']}' limit 1");
    }
    if (empty($b)) {
        insert_dolog("");
        //操作日志
        printerror("ReInfoUrlSuccess", $from);
    }
    echo $fun_r[OneReInfoUrlSuccess] . "(ID:<font color=red><b>" . $new_start . "</b></font>)<script>self.location.href='ReInfoUrl.php?enews=ReInfoUrl&tbname={$tbname}&classid={$classid}&start={$new_start}&from=" . urlencode($from) . "&retype={$retype}&startday={$startday}&endday={$endday}&startid={$startid}&endid={$endid}" . hReturnEcmsHashStrHref(0) . "';</script>";
    exit;
}

function PushInfoToZt($add,$userid,$username){
	global $empire,$dbtbpre,$class_r;
	$classid=(int)$add['classid'];
	$tid=(int)$add['tid'];
	$ztid=$add['ztid'];
	$cid=$add['cid'];
	$id=$add['id'];
	$count=count($ztid);
	if(!$count||!$id)
	{
		echo"<script>window.close();</script>";
		exit();
	}
	//表名
	$tbname='';
	if($classid)
	{
		$tbname=$class_r[$classid]['tbname'];
	}
	elseif($tid)
	{
		$tbr=$empire->fetch1("select tbname from {$dbtbpre}enewstable where tid='$tid'");
		$tbname=$tbr['tbname'];
	}
	if(!$tbname)
	{
		printerror('ErrorUrl','');
	}
	//ID
	$id=eReturnInids($id);
	$where='id in ('.$id.')';
	$ztids='';
	$zcids='';
	for($i=0;$i<$count;$i++)
	{
		$true_ztid=(int)$ztid[$i];
		if(!$true_ztid)
		{
			continue;
		}
		$true_cid=(int)$cid[$true_ztid];
		if($true_cid<0)
		{
			$true_cid=0;
		}
		$ztids.=$dh.$true_ztid;
		$dh=',';
		AddMoreInfoToZt($true_ztid,$true_cid,$tbname,$where,1);
	}
	//操作日志
	insert_dolog("classid=$classid&tid=$tid<br>ztid=".$ztids."<br>id=".$id);
	echo"<script>alert('推送成功');window.close();</script>";
	exit();
}

function EditZtOrder($ztid, $myorder, $userid, $username)
{
    global $empire, $dbtbpre;
    for ($i = 0; $i < count($ztid); $i++) {
        $newmyorder = (int) $myorder[$i];
        $ztid[$i] = (int) $ztid[$i];
        $sql = $empire->query("update {$dbtbpre}enewszt set myorder='{$newmyorder}' where ztid='{$ztid[$i]}'");
    }
    //操作日志
    insert_dolog("");
    printerror("EditZtOrderSuccess", $_SERVER['HTTP_REFERER']);
}

function SetWap($add, $userid, $username)
{
    global $empire, $dbtbpre;
    $wapopen = (int) $add['wapopen'];
    $wapdefstyle = (int) $add['wapdefstyle'];
    $wapshowmid = RepPostVar($add['wapshowmid']);
    $waplistnum = (int) $add['waplistnum'];
    $wapsubtitle = (int) $add['wapsubtitle'];
    $wapchar = (int) $add['wapchar'];
    $sql = $empire->query("update {$dbtbpre}enewspublic set wapopen={$wapopen},wapdefstyle={$wapdefstyle},wapshowmid='{$wapshowmid}',waplistnum={$waplistnum},wapsubtitle={$wapsubtitle},wapshowdate='{$add['wapshowdate']}',wapchar={$wapchar} limit 1");
    //操作日志
    insert_dolog("");
    printerror("SetWapSuccess", "SetWap.php");
}

function SetRewrite($add, $userid, $username)
{
    global $empire, $dbtbpre;
    CheckLevel($userid, $username, $classid, "public");
    //验证权限
    $sql = $empire->query("update {$dbtbpre}enewspublic set rewriteinfo='" . eaddslashes($add[rewriteinfo]) . "',rewriteclass='" . eaddslashes($add[rewriteclass]) . "',rewriteinfotype='" . eaddslashes($add[rewriteinfotype]) . "',rewritetags='" . eaddslashes($add[rewritetags]) . "',rewritepl='" . eaddslashes($add[rewritepl]) . "' limit 1");
    if ($sql) {
        GetConfig();
        //操作日志
        insert_dolog("");
        printerror("SetRewriteSuccess", "SetRewrite.php" . hReturnEcmsHashStrHref2(1));
    } else {
        printerror("DbError", "history.go(-1)");
    }
}

function ClearTags($start, $line, $userid, $username)
{
    global $empire, $dbtbpre, $class_r, $fun_r;
    $line = (int) $line;
    if (empty($line)) {
        $line = 500;
    }
    $start = (int) $start;
    $b = 0;
    $sql = $empire->query("select id,classid,tid,tagid from {$dbtbpre}enewstagsdata where tid>{$start} order by tid limit " . $line);
    while ($r = $empire->fetch($sql)) {
        $b = 1;
        $newstart = $r['tid'];
        if (empty($class_r[$r[classid]]['tbname'])) {
            $empire->query("delete from {$dbtbpre}enewstagsdata where tid='{$r['tid']}'");
            $empire->query("update {$dbtbpre}enewstags set num=num-1 where tagid='{$r['tagid']}'");
            continue;
        }
        $index_r = $empire->fetch1("select id,classid,checked from {$dbtbpre}ecms_" . $class_r[$r[classid]]['tbname'] . "_index where id='{$r['id']}' limit 1");
        if (!$index_r['id']) {
            $empire->query("delete from {$dbtbpre}enewstagsdata where tid='{$r['tid']}'");
            $empire->query("update {$dbtbpre}enewstags set num=num-1 where tagid='{$r['tagid']}'");
        } else {
            //返回表
            $infotb = ReturnInfoMainTbname($class_r[$r[classid]]['tbname'], $index_r['checked']);
            //主表
            $infor = $empire->fetch1("select stb from " . $infotb . " where id='{$r['id']}' limit 1");
            //返回表信息
            $infodatatb = ReturnInfoDataTbname($class_r[$r[classid]]['tbname'], $index_r['checked'], $infor['stb']);
            //副表
            $finfor = $empire->fetch1("select infotags from " . $infodatatb . " where id='{$r['id']}' limit 1");
            $tagr = $empire->fetch1("select tagname from {$dbtbpre}enewstags where tagid='{$r['tagid']}'");
            if (!stristr(',' . $finfor['infotags'] . ',', ',' . $tagr['tagname'] . ',')) {
                $empire->query("delete from {$dbtbpre}enewstagsdata where tid='{$r['tid']}'");
                $empire->query("update {$dbtbpre}enewstags set num=num-1 where tagid='{$r['tagid']}'");
            } elseif ($index_r['classid'] != $r[classid]) {
                $empire->query("update {$dbtbpre}enewstagsdata set classid='{$index_r['classid']}' where tid='{$r['tid']}'");
            }
        }
    }
    if (empty($b)) {
        //操作日志
        insert_dolog("");
        printerror('ClearTagsSuccess', 'ClearTags.php' . hReturnEcmsHashStrHref2(1));
    }
    echo "<meta http-equiv=\"refresh\" content=\"0;url=ClearTags.php?enews=ClearTags&line={$line}&start={$newstart}" . hReturnEcmsHashStrHref(0) . "\">" . $fun_r[OneClearTagsSuccess] . "(ID:<font color=red><b>" . $newstart . "</b></font>)";
    exit;
}

function SetPayFen($add, $userid, $username)
{
    global $empire, $dbtbpre;
    $add[paymoneytofen] = (int) $add[paymoneytofen];
    $add[payminmoney] = (int) $add[payminmoney];
    if (empty($add[paymoneytofen])) {
        printerror("EmptySetPayFen", "history.go(-1)");
    }
    $sql = $empire->query("update {$dbtbpre}enewspublic set paymoneytofen='{$add['paymoneytofen']}',payminmoney='{$add['payminmoney']}'");
    if ($sql) {
        //操作日志
        insert_dolog("moneytofen={$add['paymoneytofen']}&minmoney={$add['payminmoney']}");
        printerror("SetPayFenSuccess", "SetPayFen.php");
    } else {
        printerror("DbError", "history.go(-1)");
    }
}

function DelDownRecord($add, $userid, $username)
{
    global $empire, $dbtbpre;
    if (empty($add['downtime'])) {
        printerror("EmptyDownTime", "history.go(-1)");
    }
    //验证权限
    CheckLevel($userid, $username, $classid, "deldownrecord");
    $truetime = to_time($add['downtime']);
    $sql = $empire->query("delete from {$dbtbpre}enewsdownrecord where truetime<=" . $truetime);
    if ($sql) {
        //操作日志
        insert_dolog("time={$add['downtime']}");
        printerror("DelDownRecordSuccess", "DelDownRecord.php");
    } else {
        printerror("DbError", "history.go(-1)");
    }
}

function DelDownurl($urlid, $userid, $username)
{
    global $empire, $dbtbpre;
    $urlid = (int) $urlid;
    if (empty($urlid)) {
        printerror("NotChangeDownurlid", "history.go(-1)");
    }
    //验证权限
    CheckLevel($userid, $username, $classid, "downurl");
    $sql = $empire->query("delete from {$dbtbpre}enewsdownurlqz where urlid='{$urlid}'");
    if ($sql) {
        //操作日志
        insert_dolog("urlid=" . $urlid);
        printerror("DelDownurlSuccess", "url.php" . hReturnEcmsHashStrHref2(1));
    } else {
        printerror("DbError", "history.go(-1)");
    }
}

function SetClassInfoType($add, $logininid, $loginin)
{
    global $empire, $dbtbpre;
    CheckLevel($logininid, $loginin, $classid, "class");
    //验证权限
    $classid = (int) $add['classid'];
    if (empty($classid)) {
        printerror("ErrorUrl", "history.go(-1)");
    }
    $cr = $empire->fetch1("select classid,modid,classname,islast from {$dbtbpre}enewsclass where classid='{$classid}'");
    if (!$cr['classid'] || !$cr['islast'] || !$cr['modid']) {
        printerror("ErrorUrl", "history.go(-1)");
    }
    $noclassinfo = (int) $add['noclassinfo'];
    if ($noclassinfo == 1) {
        $ttids = '-';
    } else {
        $typeid = $add['typeid'];
        $count = count($typeid);
        $ttids = '';
        if ($count) {
            $dh = '';
            for ($i = 0; $i < $count; $i++) {
                $tid = (int) $typeid[$i];
                if (empty($tid)) {
                    continue;
                }
                $ttids .= $dh . $tid;
                $dh = ',';
            }
            if ($ttids) {
                $ttids = ',' . $ttids . ',';
            }
        }
    }
    $sql = $empire->query("update {$dbtbpre}enewsclassadd set ttids='{$ttids}' where classid='{$classid}'");
    if ($sql) {
        insert_dolog("classid={$classid}&classname={$cr['classname']}");
        //操作日志
        printerror("SetClassInfoTypeSuccess", "ClassInfoType.php?classid={$classid}" . hReturnEcmsHashStrHref2(0));
    } else {
        printerror("DbError", "history.go(-1)");
    }
}