-
Notifications
You must be signed in to change notification settings - Fork 0
/
list.php
94 lines (90 loc) · 3.73 KB
/
list.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
<?php
define('IN_QY',true);
session_start();
require("include/common.inc.php");
define('SCRIPT','list');
if(!$_COOKIE['userid']){
echo "<script type='text/javascript'>location.href='login.php';</script>";
exit;
}
$sqlu = "select * from tbl_user where id=".$_COOKIE['userid'];
$queryu=mysql_query($sqlu);
$rowu=mysql_fetch_array($queryu);
$time2=strtotime($rowu['beizhu1']);
$time1=strtotime(date("Y-m-d H:i:s"));
$tt = ceil(($time2-$time1)/86400);
$sqla = "select count(*) as cc from tbl_info where userid='".$_COOKIE['username']."'";
$querya=mysql_query($sqla);
$rowa=mysql_fetch_array($querya);
$s = $rowu['anums']-$rowa['cc'];
$sa = $rowu['anums']-1;
if($_GET["act"]=="del"){
$sqlw="delete from tbl_info where infoid=".$_GET['infoid'];
$sqlt="UPDATE tbl_user SET anums='$sa' WHERE id=".$_COOKIE["userid"];
mysql_query($sqlw);
mysql_query($sqlt);
mysql_close();
echo "<script type='text/javascript'>alert('\u6210\u529f\u5220\u9664\u0021');location.href='list.php?page=".$_GET["page"]."';</script>";
exit;
}
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="UTF-8">
<title>文章列表 - 亿分享</title>
<meta name="description" content="" />
<meta name="viewport" content="width=device-width , initial-scale=1.0 , user-scalable=0 , minimum-scale=1.0 , maximum-scale=1.0" />
<script type='text/javascript' src='js/jquery-2.0.3.min.js'></script>
<script type='text/javascript' src='js/LocalResizeIMG.js'></script>
<script type='text/javascript' src='js/patch/mobileBUGFix.mini.js'></script>
<link rel="stylesheet" href="css/css.css">
<style>
.list1 ul li { background:#f7f7f7 url(images/dotline.jpg) repeat-x top; padding:10px; height:auto; overflow:hidden; zoom:1;}
.list1 ul li .pic {max-width:30%;}
.list1 ul li .pic img{width:50px;height:50px}
.list_txt h6 {padding-left:10px;max-width:60%;color:#333; font-size:14px; padding-top:5px; line-height:16px; height:24px; overflow: hidden; }
.list1 ul li a { color:#333; }
.bot_main li.ico_2{
background:#F1901F;
}
</style>
</head>
<body>
<div class="apply" id="apply">
<p>文章列表<span style="float:right;font-size:12px;margin-right:10px">剩余文章数：<?=$s?> 剩余天数：<?=$tt?>天</span></p>
<div class="list1" style="margin-bottom:50px;">
<br>
<dd><div style='margin-left:8px; margin-top:-5px; margin-right:10px; font-size:14px; color:#FF0000;'>说明：已经分享出去的内容千万不能删除，否则用户在阅读分享的文章将会消失。</div></dd>
<ul>
<?
if($_GET['page']){
$count = ($_GET['page']-1)*20+1;
}else{
$count = 1;
}
$page_sql = "select * from tbl_info where userid='".$_COOKIE['username']."' order by id desc";
qy_page($page_sql,20);
$sql="select * from tbl_info where userid='".$_COOKIE['username']."' ORDER by id DESC LIMIT $_pagenum,$_pagesize";
$_id ='&';
$query=mysql_query($sql);
while($row=mysql_fetch_array($query)){
?>
<li>
<div class="list_txt">
<a href="view.php?fid=<?=$row['infoid']?>"><h6 style="overflow:hidden;height:30px;line-height:30px;"><?=$count?>、<?=$row['title']?></h6></a><br>阅读次数:<?=$row['wcount']?> 广告点击:<?=$row['acount']?><span style="float:right;font-size:12px;margin-right:10px;margin-top:-23px"><a href="edit_article_2.php?fid=<?=$row['infoid']?>" onClick="if (confirm('确定要编辑吗？')) return true; else return false;">编辑</a> <a href="list.php?infoid=<?=$row['infoid']?>&act=del&page=<?=$_GET['page']?>" onClick="if (confirm('确定要删除吗？')) return true; else return false;">删除</a></span>
</div>
</li>
<?
$count++;
}
?>
<li>
<?=qy_paging3()?>
</li>
</ul>
</div>
</div>
<? include('foot.php');?>
</body>
</html>