<?php
header("Content-Type: text/html;charset=utf-8");
$s = new sqlhelper($G);
$s->execute_sql("set @mycnt=0;");
$smarty->assign('picarray', $s->select_nav("select @mycnt := @mycnt +1 as id, picname from image_table ;"));
$piccount = $s->select_nav("select count(*) as piccount from image_table ;");
@$smarty->assign('piccount', $piccount[0][piccount]);
// $smarty->display("carousel.tpl");
$smarty->assign('identity', 'admin');
} else {
$smarty->assign('identity', '');
}
//获取当前子菜单id
if (empty($_GET['subid'])) {
$subid = $_POST['subid'];
} else {
$subid = $_GET['subid'];
}
//删除文件
if (@$_POST['function'] == "delart") {
$sql = "delete from article_table WHERE id=" . $_POST['artid'];
$s->execute_sql($sql);
//删除本地缓存
$filename = "templates/article/" . $_POST['artid'] . ".tpl";
@unlink($filename);
}
$smarty->display('nav.tpl');
echo "<br>";
@$smarty->assign('navarray', $s->select_nav("select * from article_table;"));
@($article = $s->select_nav("select title,id from article_table where subid=" . $subid . " order by id ;"));
$i = 0;
foreach ($article as $b) {
//依次取出数组中元素，$a是元素的键名$b是键值
$article[$i]['filename'] = "../article/" . $article[$i]['id'] . ".tpl";
$i++;
}
$smarty->assign('articlearray', $article);
$smarty->assign('subid', $subid);
$smarty->display('article.tpl');
echo '上传文件超过了PHP配置文件中upload_max_filesize选项的值';
break;
case 2:
echo '超过了表单MAX_FILE_SIZE限制的大小';
break;
case 3:
echo '文件部分被上传';
break;
case 4:
echo '没有选择上传文件';
break;
case 6:
echo "没有找到临时目录";
break;
case 7:
case 8:
echo '系统错误';
break;
}
}
}
if (!empty($_POST['imagename'])) {
$sql = "delete from image_table where picname = '" . $_POST['imagename'] . "';";
$s->execute_sql($sql);
//删除文件
//删除本地缓存
@unlink($_POST['imagename']);
}
$smarty->display('admin.tpl');
$smarty->assign('picarray', $s->select_nav("select * from image_table ;"));
$smarty->display("picture.tpl");
@($sql = "delete from nav_table WHERE navid=" . $_POST['navid'] . "");
}
//点击更新导航栏信息
if (@$_POST['function'] == 'update_nav') {
@($sql = "UPDATE nav_table SET navname='" . $_POST['nname'] . "',navsort=" . $_POST['nid'] . " WHERE navid=" . $_POST['navid'] . "");
}
//点击新增子菜单按钮
if (@$_POST['function'] == 'addsub') {
@($sql = "insert into sub_table (subid,subname,subsort,navid) VALUES (" . $_POST[subid] . ",'" . $_POST[subname] . "'," . $_POST[subsort] . "," . $_POST[navid] . ")");
}
//点击删除子菜单按钮
if (@$_POST['function'] == 'delsub') {
@($sql = "delete from sub_table WHERE subid=" . $_POST['subid'] . "");
}
//点击更新子菜单栏信息
if (@$_POST['function'] == 'update_sub') {
@($sql = "UPDATE sub_table SET subname='" . $_POST['sname'] . "',subsort=" . $_POST['sid'] . " WHERE subid=" . $_POST['subid'] . "");
}
@$s->execute_sql($sql);
//目前导航条最的id，继续累加
$newnavid = $s->select_nav("select max(navid) as navid from nav_table");
@$smarty->assign('newnavid', $newnavid[0][navid] + 1);
//目前子菜单最的id，继续累加
$newsubid = $s->select_nav("select max(subid) as subid from sub_table");
@$smarty->assign('newsubid', $newsubid[0][subid] + 1);
//所有导航条和子菜单
$smarty->assign('navarray', $s->select_nav("select * from nav_table order by navsort;"));
$smarty->assign('subarray', $s->select_nav("select * from sub_table order by subsort;"));
$smarty->assign('articlearray', $s->select_nav("select * from article_table order by id;"));
//引用模板文件
// $smarty->display('table.tpl');
$content1 = mysql_real_escape_string($htmlData);
//插入
$time = time();
if (@$_POST['function'] == "updateart") {
$sql = "update navart_table set title ='" . $_POST['title'] . "' where id =" . $_POST['artid'];
$s->execute_sql($sql);
$sql = "update article_table set date = now() where id =" . $_POST['artid'];
$s->execute_sql($sql);
$filename = "templates/article/" . $_POST['artid'] . ".tpl";
// file_put_contents("aaaaaaaaa.txt", $sql);
} else {
$sql = "insert into navart_table(navartid, title, artsort\t,date,count) VALUES (" . $time . ",'" . $_POST['title'] . "',1,now(),0)";
$filename = "templates/article/" . $time . ".tpl";
$s->execute_sql($sql);
}
file_put_contents($filename, $htmlData);
// header("Location: admin.php");
// exit;
}
// print_r($s->select_nav("select * from navart_table order by artsort;"));
//点击删除导航条按钮
if (@$_POST['function'] == 'delnavart') {
@($sql = "delete from navart_table WHERE navartid=" . $_POST['artid'] . "");
//删除本地缓存
$filename = "templates/article/" . $_POST['artid'] . ".tpl";
@unlink($filename);
@$s->execute_sql($sql);
}
$smarty->assign('navartarray', @$s->select_nav("select * from navart_table order by artsort;"));
$smarty->display('admin.tpl');
$smarty->display('addpage.tpl');
//清空密码输入错误时间
}
}
@session_start();
//开启session
//自动登录
if (!empty($_SESSION['username'])) {
header("Location: admin.php");
}
//提交表单过来
if (!empty($username) && !empty($password)) {
$password = sha1($password);
//查询账号信息
$sql = "select username from user_table where username = '******' and password = '******'";
$s = new sqlhelper($G);
$array = $s->select_nav($sql);
//用户名密码是否正确
if (!empty($array)) {
//保留登录信息
@session_start();
$_SESSION['username'] = $_POST['username'];
$_SESSION['password'] = $_POST['password'];
$_SESSION['identity'] = "admin";
//密码输入正确，不提示错误
$smarty->assign('password', "true");
//跳转页面
@session_start();
$_SESSION['logincount'] = 0;
//清空登录错误次数
header("Location: admin.php");
} else {
<?php
//引用类文件
require './common.php';
require './config.php';
$smarty->assign('logined', 'false');
session_start();
//开启session
//自动登录
if (!empty($_SESSION['username'])) {
$smarty->assign('logined', 'true');
}
//赋值
$snav = new sqlhelper($G);
$smarty->assign('navarray', $snav->select_nav("select navname,navid from nav_table order by navsort;"));
$smarty->assign('subarray', $snav->select_nav("select * from sub_table order by subsort;"));
//引用模板文件
// $smarty->display('nav.tpl');
?>
<?php
$s = new sqlhelper($G);
$s->execute_sql("set @mycnt=0;");
$smarty->assign('array2', $s->select_nav("select @mycnt := @mycnt +1 as top1,id,title from article_table order by date desc limit 0,10;"));
// $smarty->display("top.tpl");
<?php
//引用类文件
require './common.php';
require './config.php';
//赋值
$s = new sqlhelper($G);
//获取当前文章id
if (empty($_GET['artid'])) {
$artid = $_POST['artid'];
} else {
$artid = $_GET['artid'];
}
//获取当前子菜单id
if (empty($_GET['subid'])) {
$subid = $_POST['subid'];
} else {
$subid = $_GET['subid'];
}
@($article = $s->select_nav("select * from article_table where id=" . $artid . " ;"));
$article[0]['filename'] = "./templates/article/" . $article[0]['id'] . ".tpl";
$smarty->assign('articletitle', $article[0]['title']);
$smarty->assign('subid', $subid);
$smarty->assign('artid', $artid);
$smarty->display('admin.tpl');
echo "<br>";
$articlecontent = file_get_contents($article[0]['filename']);
$smarty->assign('articlecontent', $articlecontent);
$smarty->display('editarticle.tpl');
<?php
//引用类文件
require './config.php';
require './common.php';
@session_start();
//开启session
//未登录
if (empty($_SESSION['username'])) {
header("Location: login.php");
}
$s = new sqlhelper($G);
//点击更新按钮
if (@$_POST['function'] == 'updatelink') {
$sql = "update link_table set name = '" . $_POST['name'] . "' where src = '" . $_POST['src'] . "'";
$s->execute_sql($sql);
}
//点击新增按钮
if (@$_POST['function'] == 'addlink') {
$sql = "insert into link_table(src,name) VALUES ('" . $_POST['src'] . "','" . $_POST['name'] . "')";
$s->execute_sql($sql);
}
//点击删除按钮
if (@$_POST['function'] == 'dellink') {
$sql = "delete from link_table WHERE src='" . $_POST['src'] . "'";
$s->execute_sql($sql);
}
$smarty->assign('linkarray', $s->select_nav("select * from link_table;"));
//引用模板文件
$smarty->display('admin.tpl');
$smarty->display('addlink.tpl');
} else {
$htmlData = $_POST['content1'];
}
}
//修改后重新提交内容
if (@$_POST['function'] == "updateart") {
$sql = "update navart_table set title ='" . $_POST['title'] . "' where navartid ='" . $_POST['artid'] . "';";
$s->execute_sql($sql);
// file_put_contents("aaaaaaaaa.txt", $sql);
$sql = "update navart_table set date = now() where navartid =" . $_POST['artid'];
$s->execute_sql($sql);
$sql = "update navart_table set artsort = " . $_POST['sort'] . " where navartid =" . $_POST['artid'];
$s->execute_sql($sql);
$filename = "templates/article/" . $_POST['artid'] . ".tpl";
file_put_contents($filename, $htmlData);
header("Location: addpage.php");
exit;
}
//编辑功能显示原始内容
if (!empty($_POST['artid'])) {
$navart = @$s->select_nav("select * from navart_table where navartid = " . $_POST['artid'] . ";");
$navart[0]['filename'] = "./templates/article/" . $navart[0]['navartid'] . ".tpl";
$articlecontent = file_get_contents($navart[0]['filename']);
$smarty->assign('articlecontent', $articlecontent);
@$smarty->assign('navarttitle', $navart[0][title]);
$smarty->assign('artid', $_POST['artid']);
@$smarty->assign('artsort', $navart[0][artsort]);
//print_r($navart);
}
$smarty->display('admin.tpl');
$smarty->display('updatepage.tpl');
} else {
$sql = "update article_table set count=count+1 where id='" . $_GET['artid'] . "'";
$result = mysql_query($sql);
}
//获取导航文章id
if (empty($_GET['navartid'])) {
@($sql = "update navart_table set count=count+1 where navartid='" . $_POST['navartid'] . "'");
$result = mysql_query($sql);
} else {
$sql = "update navart_table set count=count+1 where navartid='" . $_GET['navartid'] . "'";
$result = mysql_query($sql);
}
//赋值
$s = new sqlhelper($G);
//导航条
$smarty->assign('navarray', @$s->select_nav("select navname,navid from nav_table order by navsort;"));
$smarty->assign('subarray', @$s->select_nav("select subname,navid,subid from sub_table order by subsort;"));
//文章列表
if (empty($subid)) {
@($artlist = $s->select_nav("select * from article_table limit 0,1;"));
} else {
@($artlist = $s->select_nav("select * from article_table where subid=" . $subid . " order by id ;"));
}
$smarty->assign('articlearray', $artlist);
//设置各个模块背景颜色
$smarty->assign('navbgcolor', $G['NAVBGCOLOR']);
$smarty->assign('hotbgcolor', $G['HOTBGCOLOR']);
$smarty->assign('lastbgcolor', $G['LASTBGCOLOR']);
$smarty->assign('artbgcolor', $G['ARTBGCOLOR']);
$smarty->assign('newsbgcolor', $G['NEWSBGCOLOR']);
$smarty->assign('adderbgcolor', $G['ADDERBGCOLOR']);
<?php
//引用类文件
require './config.php';
require './common.php';
@session_start();
//开启session
//未登录
if (empty($_SESSION['username'])) {
header("Location: login.php");
}
$s = new sqlhelper($G);
//点击删除按钮
if (@$_POST['function'] == 'delmess') {
$sql = "delete from message_table WHERE id='" . $_POST['id'] . "'";
$s->execute_sql($sql);
}
$smarty->assign('messarray', $s->select_nav("select * from message_table;"));
//引用模板文件
$smarty->display('admin.tpl');
$smarty->display('showmess.tpl');
