function getcountphoto($albumid, $userid)
{
$public_function = new public_function();
$select_photo_size_sql = "select ids,photo_author,photo_album from blog_photo where photo_author='{$userid}' and photo_album='{$albumid}'";
$select_photo_size_num = $public_function->getnum($public_function->getresult($select_photo_size_sql));
return $select_photo_size_num;
}
function getcountalbum($moduleid)
{
$public_function = new public_function();
$select_album_sql = "select * from blog_album where album_module='{$moduleid}'";
$select_album_num = $public_function->getnum($public_function->getresult($select_album_sql));
return $select_album_num;
}
function getcountmen($user_type)
{
$public_function = new public_function();
$user_dept_sql = "select user_type from blog_user where user_type='{$user_type}'";
$user_dept_result = $public_function->getresult($user_dept_sql);
return $public_function->getnum($user_dept_result);
}
function getmenurightnum($menuid, $usertype)
{
$public_function = new public_function();
$menu_right_sql = "select * from blog_menu_user where menuid='{$menuid}' and usertype='{$usertype}'";
$menu_right_result = $public_function->getresult($menu_right_sql);
return $public_function->getnum($menu_right_result);
}
function getcountmenbydept($dpid)
{
$public_function = new public_function();
$user_dept_sql = "select user_dept from blog_user where user_dept='{$dpid}'";
$user_dept_result = $public_function->getresult($user_dept_sql);
return $public_function->getnum($user_dept_result);
}
function getcountmennologin($user_type)
{
$public_function = new public_function();
$user_dept_sql = "select user_type,user_isedlogin from blog_user where user_type='{$user_type}' and user_isedlogin=0";
$user_dept_result = $public_function->getresult($user_dept_sql);
return $public_function->getnum($user_dept_result);
}
function del($pid)
{
$public_function = new public_function();
$sql = "select * from blog_menu where menu_pid='{$pid}'";
$delsql = "delete from blog_menu where menu_id='{$pid}'";
$result = $public_function->getresult($sql);
$num = $public_function->getnum($result);
for ($i = 0; $i < $num; $i++) {
$array = $public_function->getarray($result);
del($array['menu_id']);
}
$result1 = $public_function->getresult($delsql);
echo "<script>location.href='../add_new_menu.php?'</script>";
}
function update_iseduse($pid, $ise)
{
$public_function = new public_function();
$sql = "select * from blog_menu where menu_pid='{$pid}'";
$updatesql = "update blog_menu set menu_isedshow='{$ise}' where menu_id='{$pid}'";
$result = $public_function->getresult($sql);
$num = $public_function->getnum($result);
for ($i = 0; $i < $num; $i++) {
$array = $public_function->getarray($result);
update_iseduse($array['menu_id'], $ise);
}
$result1 = $public_function->getresult($updatesql);
if ($result1 > 0) {
echo "<script>location.href='../update_menu.php?info=success&menuid=" . $pid . "'</script>";
} else {
echo "<script>location.href='../update_menu.php?info=fail'</script>";
}
}
function del($pid)
{
$public_function = new public_function();
$sql = "select * from flow_sort where sort_parent='{$pid}'";
$delsql = "delete from flow_sort where sort_id='{$pid}'";
$result = $public_function->getresult($sql);
$num = $public_function->getnum($result);
for ($i = 0; $i < $num; $i++) {
$array = $public_function->getarray($result);
del($array['sort_id']);
}
$result1 = $public_function->getresult($delsql);
$public_function->getresult("delete from flow_type where flow_sort not in(select sort_id from flow_sort)");
$public_function->getresult("delete from flow_print_tpl where flow_id not in(select flow_id from flow_type)");
$public_function->getresult("delete from flow_process where flow_id not in(select flow_id from flow_type)");
$public_function->getresult("delete from flow_query_tpl where flow_id not in(select flow_id from flow_type)");
$public_function->getresult("delete from flow_rule where flow_id not in(select flow_id from flow_type)");
$public_function->getresult("delete from flow_run where flow_id not in(select flow_id from flow_type)");
$public_function->getresult("delete from flow_run_log where flow_id not in(select flow_id from flow_type)");
$public_function->getresult("delete from flow_timer where flow_id not in(select flow_id from flow_type)");
echo "<script>location.href='../update_flow_type.php'</script>";
}
<?php
require_once '../../../include/conmysql.php';
require_once '../../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$typesname = str_replace(" ", "", $_GET['typesname']);
$select_sql = "select typesname from blog_richeng_type where typesname='{$typesname}'";
$select_result = $public_function->getresult($select_sql);
$select_num = $public_function->getnum($select_result);
if ($select_num > 0) {
echo "<script>location.href='../richeng_fl.php'</script>";
} else {
$sql = "insert into blog_richeng_type(typesname) values('{$typesname}')";
$result = $public_function->getresult($sql);
echo "<script>location.href='../richeng_fl.php'</script>";
}
}else{
echo getUserNameBySessionUID($userid)."(".$user_type_array['usertypename'].")";
}*/
?>
</div>
</div>
<!--头部结束-->
<!--左边菜单开始-->
<div class="left_c left">
<h1>系统菜单</h1>
<div class="acc">
<?php
$sql = "select * from blog_menu " . $usertype_sql . " order by menu_order";
$result = $public_function->getresult($sql);
$num = $public_function->getnum($result);
for ($i = 0; $i < $public_function->getnum($result); $i++) {
echo "<div>";
$array = $public_function->getarray($result);
$array_id = $array['menu_id'];
$result1 = $public_function->getresult("select * from blog_menu " . $usertype_sql . " and menu_pid='{$array_id}' order by menu_order");
$num1 = $public_function->getnum($result1);
if ($num1 > 0) {
?>
<a class="one" href="#" title="<?php
echo $array['menu_name'];
?>
"><?php
echo $array['menu_name'];
?>
</a>
require_once '../../../include/conmysql.php';
require_once '../../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$idsone = str_replace(" ", "", $_GET['ids']);
$idsall = str_replace(" ", "", $_GET['ids']);
$idsalldel = explode(',', $idsall);
$ty = str_replace(" ", "", $_GET['ty']);
$page = str_replace(" ", "", $_GET['page']);
$yeshu = str_replace(" ", "", $_GET['yeshu']);
$pagesize = str_replace(" ", "", $_GET['pagesize']);
$cnt = str_replace(" ", "", $_GET['cnt']);
$dates = str_replace(" ", "", $_GET['dates']);
$richeng_sql = "select ids,contents,starttime,endtime,types,userid,dates,date_format(dates,'%Y-%m-%d') as dates1,titles,importent from blog_richeng where userid='{$blog_userid}' and date_format(dates,'%Y-%m-%d')='{$dates}'";
$richeng_result = $public_function->getresult($richeng_sql);
$richeng_num = $public_function->getnum($richeng_result);
//echo $richeng_num;
if ($ty == "delone") {
$delone_sql = "delete from blog_richeng where ids='{$idsone}'";
$delone_result = $public_function->getresult($delone_sql);
if ($delone_result > 0) {
$info = "success";
} else {
$info = "fail";
}
rturnPage($page, $yeshu, $info, $cnt);
} else {
if ($ty == "delall") {
for ($i = 0; $i < count($idsalldel); $i++) {
$sql = "delete from blog_richeng where ids='{$idsalldel[$i]}'";
$delall_richeng = $public_function->getresult($sql);
}
});
});
</script>
</head>
<body style="background-color: #ececec;">
<div class="st_tree" style="width:300px;overflow: auto;">
<?php
$userid = $_SESSION['UID'];
$utype = $_SESSION['UTYPE'];
$usertype_sql = "";
if ($utype == 1) {
$usertype_sql = "";
} else {
$usertype_sql = "where menu_id in(select menuid from blog_menu_user where usertype='{$utype}')";
}
//获取公共类
$public_function = new public_function();
$sql = "select * from blog_menu " . $usertype_sql . " order by menu_order";
$result = $public_function->getresult($sql);
for ($i = 0; $i < $public_function->getnum($result); $i++) {
$r[] = $public_function->getarray($result);
}
echo getTreeupdate($r, 0);
?>
</div>
</body>
</html>
<?php
require_once '../../include/conmysql.php';
require_once '../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
//日记分类管理
if ($_REQUEST['edtype'] == "edit") {
$blog_type_id = $_REQUEST['blog_type_id'];
if ($blog_type_id != null || $blog_type_id != 0 || $blog_type_id != "") {
$blog_type_name = $_REQUEST['blog_type_name'];
//查询当前名称是否存在数据库
$select_blog_type_sql = "select blog_type_name,blog_type_user from blog_type where blog_type_name='{$blog_type_name}' and blog_type_user='******'";
if ($public_function->getnum($public_function->getresult($select_blog_type_sql)) > 0) {
echo "<script>alert('该名称已存在');location.href='blog_type_construct.php'</script>";
} else {
$select_blog_type_sql = "update blog_type set blog_type_name='{$blog_type_name}' where blog_type_id='{$blog_type_id}'";
$select_blog_type_result = $public_function->getresult($select_blog_type_sql);
echo "<script>location.href='blog_type_construct.php'</script>";
}
} else {
$blog_type_name1 = $_REQUEST['blog_type_name1'];
$select_blog_type_sql1 = "insert into blog_type(blog_type_name,blog_type_user) value('{$blog_type_name1}','{$blog_userid}')";
$select_blog_type_result = $public_function->getresult($select_blog_type_sql1);
echo "<script>location.href='blog_type_construct.php'</script>";
}
} elseif ($_REQUEST['edtype'] == "del") {
$blogtypeid = $_REQUEST['blogtypeid'];
$del_blog_type = "delete from blog_type where blog_type_id='{$blogtypeid}'";
$del_blog_type_result = $public_function->getresult($del_blog_type);
$update_blog_type_sql = "update blog_blog set blog_type=1 where blog_userid='{$blog_userid}'";
" name="link_name" id="link_name" style="width:210px;" placeholder="╩С╚в═Эои├ч│к"/></td>
</tr>
<tr>
<td width="100px" align="right">═ЭоиБ║</td>
<td align="left" width="400"><input type="text" value="<?php
echo $select_url_array['link_url'];
?>
" name="link_url" id="link_url" style="width:400px;" placeholder="╩С╚в═Эои"/></td>
</tr>
<tr>
<td width="100px" align="right">ио└ЯБ║</td>
<td align="left" width="210">
<select name="link_module">
<?php
$urltyperesult = getAllCanUseWebSiteType();
$urltypenum = $public_function->getnum($urltyperesult);
for ($i = 0; $i < $urltypenum; $i++) {
$urltypearray = $public_function->getarray($urltyperesult);
?>
<option value="<?php
echo $urltypearray['ids'];
?>
" <?php
if ($select_url_array['link_module'] == $urltypearray['ids'] || $urltypearray['ids'] == $urlmoduleid) {
echo "selected";
}
?>
><?php
echo $urltypearray['module_name'];
?>
</option>
require_once '../../include/public_function.php';
require_once '../../include/blog_menu_function.php';
require_once '../../include/user_function.php';
$public_function = new public_function();
$user_function = new user_function();
$username = str_replace(" ", "", $_GET['pid']);
$userid = str_replace(" ", "", $_GET['uid']);
header("content-type:text/html;charset=gb2312");
if ($username == "") {
echo "<font color='red'>警告:用户名不能为空!</font>";
exit;
} else {
$ui_result = mysql_query("select user_name,user_id from blog_user where user_id='{$userid}'");
$ui_array = mysql_fetch_array($ui_result);
if ($ui_array['user_name'] == $username) {
echo "<font color='red'>*</font>用户名可包含数字、字母、下划线和汉字,2-20";
exit;
} else {
$sql = "select user_name,user_isedlogin from blog_user where user_name='" . $username . "'";
$query = $public_function->getresult($sql);
$num = $public_function->getnum($query);
$array = $public_function->getarray($query);
if ($num > 0) {
echo "<font color='red'>警告:系统已存在该用户名</font>";
exit;
} else {
echo "<font color='green'>√ 恭喜:该用户名可以使用</font>";
exit;
}
}
}
<?php
require_once '../include/conmysql.php';
require_once '../include/public_function.php';
require_once '../include/photo_gl_function.php';
$public_function=new public_function();
$blog_type_user=$_SESSION['UID'];
$mid=str_replace(" ", "", $_GET['mid']);
$url=str_replace(" ", "", $_GET['url']);
$menu_sql="select ids,module_name,module_iseduse,module_sort,module_url,module_showhome,module_isedmenu,module_url
from picture_module where module_isedmenu=1 order by module_sort asc";
$menu_result=$public_function->getresult($menu_sql);
$menu_num=$public_function->getnum($menu_result);
//获取推荐的相册
$album_sql="select ids,album_name,album_desc,album_author,album_createdate,photo_size,album_iseddel,album_right,album_fangke,album_pinglun,album_zan,album_bg,album_module,album_isedhot,album_isedshow from blog_album where album_iseddel=0 and album_isedshow=1 and album_module='$mid' order by ids desc";
$album_result=$public_function->getresult($album_sql);
$album_num=$public_function->getnum($album_result);
$pagesize=4;
$yeshu=ceil($album_num/$pagesize); //求得一共需要多少页
$geshu=3; //一页显示10个页码*-*
if($_POST['page']!=null){
$page=$_POST["page"];
}else{
$page=$_GET["page"];
}
if(empty($page))
{
$page=1;
}
<?php
require_once '../../include/conmysql.php';
require_once '../../include/public_function.php';
$public_function = new public_function();
$blog_type_user = $_SESSION['UID'];
$url = $_GET['url'];
$select_blog_album_right_sql = "select album_right,album_right_name,album_right_desc from blog_album_right";
$select_blog_album_right_result = $public_function->getresult($select_blog_album_right_sql);
$select_blog_album_right_num = $public_function->getnum($select_blog_album_right_result);
$album_right = $_POST['album_right'];
$album_name = $_POST['album_name'];
$album_desc = $_POST['album_desc'];
$album_module = $_POST['album_module'];
/* if($album_desc0=="说说这个相册的故事...(非必填)"){
$album_desc="";
}else{
$album_desc=$album_desc0;
} */
$album_createdate = CURRENT_TIME;
$insert_blog_sql = "insert into blog_album(album_name,album_desc,album_author,album_createdate,album_right,album_module) \nvalue('{$album_name}','{$album_desc}','{$blog_type_user}','{$album_createdate}','{$album_right}','{$album_module}')";
if ($album_name == "" || $album_name == null || $album_name == "相册名称") {
$info1 = "相册名称";
$info2 = "说说这个相册的故事...(非必填)";
} else {
$select_album_name_sql = "select album_name,album_author from blog_album where album_name='{$album_name}' and album_author='{$blog_type_user}'";
if ($public_function->getnum($public_function->getresult($select_album_name_sql)) > 0) {
$info = "该相册已创建";
} else {
$public_function->getresult($insert_blog_sql);
$album = mysql_insert_id();
<?php
require_once '../include/conmysql.php';
require_once '../include/public_function.php';
require_once '../include/album_gl_function.php';
$public_function = new public_function();
$blog_type_user = $_SESSION['UID'];
$moduleid = str_replace(" ", "", $_GET['moduleid']);
$select_blog_album_right_sql = "select album_right,album_right_name,album_right_desc from blog_album_right";
$select_blog_album_right_result = $public_function->getresult($select_blog_album_right_sql);
$select_blog_album_right_num = $public_function->getnum($select_blog_album_right_result);
$album_right = str_replace(" ", "", $_POST['album_right']);
$album_name = str_replace(" ", "", $_POST['album_name']);
$album_desc = str_replace(" ", "", $_POST['album_desc']);
$album_module = str_replace(" ", "", $_POST['album_module']);
$url = str_replace(" ", "", $_GET['url']);
$page = str_replace(" ", "", $_GET['page']);
$album_createdate = CURRENT_TIME;
if ($album_name == "" || $album_name == null || $album_name == "相册名称") {
$info1 = "相册名称";
$info2 = "说说这个相册的故事...(非必填)";
} else {
if (strlen($album_name) > 40) {
$info1 = "相册名称的长度不能超过20个字符";
echo "<html>\n\t\t<head>\n\t\t<script charset='utf-8' src='../js/jquery-1.6.min.js'></script>\n\t\t<script src='../plugins/layer/lib.js'></script>\n\t\t<script src='../plugins/layer/layer.min.js'></script>\n\t\t<script src='../plugins/layer/laycode.min.js'></script>\n\t\t<script src='../js/gl_user/gl_user.js'></script>\n\t\t</head>\n\t\t<body>";
echo "<meta http-equiv='content-type' content='application/xhtml;charset=gb2312' />\n\t\t\t<script>\n\t\t\tvar ii1 = layer.load('" . $info1 . "');\n \t\tsetTimeout(function(){\n \t\tparent.location.href='" . $url . ".php?page=" . $page . "';\n \t\t}, 1000);\n\t\t\t</script>";
echo "</body></html>";
} else {
$select_album_name_sql = "select album_name,album_author from blog_album where album_name='{$album_name}' and album_author='{$blog_type_user}'";
$result1 = mysql_query($select_album_name_sql);
$num1 = mysql_num_rows($result1);
$dept_pid = $dept_pid0;
}
$dept_duty = str_replace(" ", "", $_POST['dept_duty']);
//根据用户组ID号修改用户组名称
$usergrouptype_sql = "select ids,dept_name,dept_num,dept_fax,dept_pid,dept_duty,dept_order from blog_dept where ids='{$usergrouptype_id}'";
$usergrouptype_array = $public_function->getarray($public_function->getresult($usergrouptype_sql));
//echo $dept_duty."<br/>".$dept_fax."<br/>".$dept_name."<br/>".$dept_num."<br/>".$dept_order."<br/>".$dept_pid;
if ($_POST['types'] == "updates") {
if ($usergrouptype_id != 0 || $usergrouptype_id != null || $usergrouptype_id != "") {
if ($usergrouptype_array['dept_name'] == $dept_name) {
$update_user_group_sql = "update blog_dept\n\t\t\tset dept_name='{$dept_name}',\n\t\t\tdept_num='{$dept_num}',\n\t\t\tdept_fax='{$dept_fax}',\n\t\t\tdept_pid='{$dept_pid}',\n\t\t\tdept_duty='{$dept_duty}',\n\t\t\tdept_order='{$dept_order}'\n\t\t\twhere ids='{$usergrouptype_id}'";
$update_user_type_result = mysql_query($update_user_group_sql);
echo "<script>alert('部门信息更新成功!');location.href='update_dept.php?ids=" . $usergrouptype_id . "'</script>";
} else {
$select_user_type_sql = "select dept_name,dept_pid from blog_dept where dept_name='{$dept_name}' and dept_pid='{$dept_pid}'";
if ($public_function->getnum($public_function->getresult($select_user_type_sql)) > 0) {
echo "<script>alert('同一部门下面不能出现重复的子部门!');location.href='update_dept.php?ids=" . $usergrouptype_id . "'</script>";
} else {
$update_user_group_sql = "update blog_dept\n\t\t\t\tset dept_name='{$dept_name}',\n\t\t\t\tdept_num='{$dept_num}',\n\t\t\t\tdept_fax='{$dept_fax}',\n\t\t\t\tdept_pid='{$dept_pid}',\n\t\t\t\tdept_duty='{$dept_duty}',\n\t\t\t\tdept_order='{$dept_order}'\n\t\t\t\twhere ids='{$usergrouptype_id}'";
$update_user_type_result = mysql_query($update_user_group_sql);
echo "<script>alert('部门信息更新成功!');location.href='update_dept.php?ids=" . $usergrouptype_id . "'</script>";
}
}
} else {
$select_user_type_sql = "select dept_name,dept_pid from blog_dept where dept_name='{$dept_name}' and dept_pid='{$dept_pid}'";
if ($public_function->getnum($public_function->getresult($select_user_type_sql)) > 0) {
echo "<script>alert('同一部门下面不能出现重复的子部门!');location.href='update_dept.php?ids=" . $usergrouptype_id . "'</script>";
} else {
$insert_user_group_sql = "insert into blog_dept(dept_name,dept_num,dept_fax,dept_pid,dept_duty,dept_order) \n\t\t\tvalues('{$dept_name}','{$dept_num}','{$dept_fax}','{$dept_pid}','{$dept_duty}','{$dept_order}')";
$insert_user_type_result = $public_function->getresult($insert_user_group_sql);
$mysql_insert_utype = mysql_insert_id();
<?php
require_once '../../include/conmysql.php';
require_once '../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$topname = str_replace(" ", "", $_POST['topname']);
$operation = str_replace(" ", "", $_POST['operation']);
$url = str_replace(" ", "", $_GET['url']);
$url1 = str_replace(" ", "", $_POST['url']);
$title_sql = "select * from blog_toptitle";
$title_result = $public_function->getresult($title_sql);
$title_array = $public_function->getarray($title_result);
$title_num = $public_function->getnum($title_result);
$sql = "insert into blog_toptitle(topname) values('{$topname}')";
$usql = "update blog_toptitle set topname='{$topname}'";
if ($operation == "add") {
if ($title_num > 0) {
$result = $public_function->getresult($usql);
if ($result > 0) {
$info = "网站顶部标题更新成功";
} else {
$info = "由于网络原因,操作失败,请稍后重试...";
}
} else {
$result1 = $public_function->getresult($sql);
if ($result1 > 0) {
$info = "网站顶部标题更新成功";
} else {
$info = "由于网络原因,操作失败,请稍后重试...";
}
<?php
require_once '../include/conmysql.php';
require_once '../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
if ($_SESSION['UID'] == null || $_SESSION['UID'] == 0) {
echo "<script>location.href='../admin.php'</script>";
}
$create_date = CURRENT_TIME;
//用户分类
$user_type_sql = "select usertype,usertypename from blog_user_type where usertype!=1 and usertype!=3 and usertype!=12 order by usertype desc";
$user_type_result = $public_function->getresult($user_type_sql);
$user_type_num = $public_function->getnum($user_type_result);
$types = str_replace(" ", "", $_GET['types']);
$url = str_replace(" ", "", $_GET['url']);
$page = str_replace(" ", "", $_GET['page']);
if ($types == "update") {
$user_name = str_replace(" ", "", $_GET['user_name']);
$user_id = str_replace(" ", "", $_GET['user_id']);
$user_type = str_replace(" ", "", $_GET['user_type']);
//$user_dept=str_replace(" ", "", $_GET['user_dept']);
$user_truename = str_replace(" ", "", $_GET['user_truename']);
$user_passwd0 = str_replace(" ", "", $_GET['user_passwd']);
$userorder0 = str_replace(" ", "", $_GET['userorder']);
if ($userorder0 == 0) {
$userorder = 0;
} else {
$userorder = $userorder0;
}
$ui_result = mysql_query("select user_name,user_id from blog_user where user_id='{$user_id}'");
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$menuid = $_GET['menuid'];
if ($public_function->getbgbyuser($blog_userid) != "") {
$bg = $public_function->getbgbyuser($blog_userid);
} else {
if ($public_function->getbgbysys() != "") {
$bg = $public_function->getbgbysys();
} else {
$bg = "images/bg/bg3.jpg";
}
}
//获取所有菜单
$menuall_sql = "select menu_id,menu_pid,menu_name,menu_intro,menu_order,menu_icon,menu_url,menu_type,menu_isedshow from blog_menu";
$menuall_result = $public_function->getresult($menuall_sql);
$menuall_num = $public_function->getnum($menuall_result);
//获取菜单
$menu_sql = "select menu_id,menu_pid,menu_name,menu_intro,menu_order,menu_icon,menu_url,menu_type,menu_isedshow from blog_menu where menu_id='{$menuid}'";
$menu_result = $public_function->getresult($menu_sql);
$menu_num = $public_function->getnum($menu_result);
$menu_array = $public_function->getarray($menu_result);
//通过父ID查询菜单名
function getmenuname($pid)
{
$pmenusql = "select menu_id,menu_name from blog_menu where menu_id='{$pid}'";
$public_function = new public_function();
$pmenuresult = $public_function->getresult($pmenusql);
$pmenuarray = $public_function->getarray($pmenuresult);
$menu_name = $pmenuarray['menu_name'];
return $menu_name;
}
/* $richeng_type_sql="select ids,typesname from blog_richeng_type";
$richeng_type_result=$public_function->getresult($richeng_type_sql);
$richeng_type_num=$public_function->getnum($richeng_type_result); */
//获取日程的重要程度
/* $richeng_imp_type_sql="select ids,importent from blog_richeng_isedimport";
$richeng_imp_type_result=$public_function->getresult($richeng_imp_type_sql);
$richeng_imp_type_num=$public_function->getnum($richeng_imp_type_result); */
//根据ID号查询需要修改的日程信息
/* $richengid=str_replace(" ", "", $_GET['ids']);
$richeng_sql="select ids,contents,starttime,endtime,types,userid,dates,titles,importent from blog_richeng where ids='$richengid'";
$richeng_result=$public_function->getresult($richeng_sql);
$richeng_array=$public_function->getarray($richeng_result); */
//select date_format(dates,"%Y-%m-%d") as d from blog_richeng group by date_format(dates,"%Y-%m-%d")
$richeng_sql1 = "select ids,contents,starttime,endtime,types,userid,dates,titles,importent from blog_richeng where userid='{$blog_userid}'";
$richeng_result1 = $public_function->getresult($richeng_sql1);
$richeng_num1 = $public_function->getnum($richeng_result1);
$richeng_sql = "select ids,contents,starttime,endtime,types,userid,date_format(dates,'%Y-%m-%d') as dates,titles,importent from blog_richeng where userid='{$blog_userid}' group by date_format(dates,'%Y-%m-%d') order by dates desc";
$richeng_result = $public_function->getresult($richeng_sql);
$richeng_num = $public_function->getnum($richeng_result);
$pagesize = 1;
$yeshu = ceil($richeng_num / $pagesize);
//求得一共需要多少页
$geshu = 3;
//一页显示10个页码*-*
if ($_POST['page'] != null) {
$page = $_POST["page"];
} else {
$page = $_GET["page"];
}
if (empty($page)) {
$page = 1;
if ($_SESSION['UID'] == null || $_SESSION['UID'] == 0) {
echo "<script>location.href='../admin.php'</script>";
}
$uid = $_GET['uid'];
if ($public_function->getbgbyuser($blog_userid) != "") {
$bg = $public_function->getbgbyuser($blog_userid);
} else {
if ($public_function->getbgbysys() != "") {
$bg = $public_function->getbgbysys();
} else {
$bg = "images/bg/bg3.jpg";
}
}
$select_user_sql = "select user_id,user_name,user_birthday,user_jiguan,\n\t\tuser_address,user_xiexing,user_ganqing,user_xianjudi,user_guxiang,user_zhiye,\n\t\tuser_companyname,user_companyaddress,user_companyxiangxiaddress,user_aihao,user_touxiang,\n\t\tuser_isedlogin,user_truename,user_sex,user_type from blog_user where user_id='{$uid}'";
$select_user_result = $public_function->getresult($select_user_sql);
$select_user_num = $public_function->getnum($select_user_result);
$select_user_array = $public_function->getarray($select_user_result);
function getusergroup($user_type)
{
$public_function = new public_function();
$u_type_sql = "select usertype,usertypename from blog_user_type where usertype='{$user_type}'";
$u_array = $public_function->getarray($public_function->getresult($u_type_sql));
return $u_array['usertypename'];
}
//用户分类
$user_type_sql = "select usertype,usertypename from blog_user_type";
$user_type_result = $public_function->getresult($user_type_sql);
$user_type_num = $public_function->getnum($user_type_result);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
require_once '../include/conmysql.php';
require_once '../include/public_function.php';
require_once 'function/xm_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$utype = $_SESSION['UTYPE'];
if ($_SESSION['UID'] == null || $_SESSION['UID'] == 0) {
echo "<script>location.href='../admin.php'</script>";
}
$xmid = str_replace(" ", "", $_GET['xmid']);
$url = str_replace(" ", "", $_GET['url']);
$url1 = str_replace(" ", "", $_GET['url1']);
$page = str_replace(" ", "", $_GET['page']);
//获取资料列表选项,通过项目的ID号获取项目分类，然后通过项目分类获取对应所需的资料
$zlselectresult = getOneZLSelectResult($xmid, 0);
$zlselectnum = $public_function->getnum($zlselectresult);
//获取项目信息通过项目ID号
$xmresultbyid = getXMXXByXmID($xmid);
$xmarraybyid = $public_function->getarray($xmresultbyid);
//项目资料是否齐全
$xm_zl_isedqq = $xmarraybyid['xm_zl_isedqq'];
//项目资料不齐全的原因
$xm_zl_bqq_yy = $xmarraybyid['xm_zl_bqq_yy'];
$xm_zl_bqq_yy_0 = explode(",", $xm_zl_bqq_yy);
//资料信息
$ziliaoxx = $xmarraybyid['ziliaoxx'];
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
//$user_passwd=md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5("123456"))))))))))));
$sql1 = "update blog_user set user_name='{$user_name}',user_type='{$user_type}',jg_mc='{$jg_mc}',user_truename='{$jg_jc}',jg_fr='{$jg_fr}',fr_dh='{$fr_dh}',jg_lxr='{$jg_lxr}',jg_lxrdh='{$jg_lxrdh}',update_date='{$create_date}' where user_id='{$user_id}'";
} else {
$user_passwd = md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5($_REQUEST['user_passwd']))))))))))));
$sql1 = "update blog_user set user_name='{$user_name}',user_type='{$user_type}',user_passwd='{$user_passwd}',jg_mc='{$jg_mc}',user_truename='{$jg_jc}',jg_fr='{$jg_fr}',fr_dh='{$fr_dh}',jg_lxr='{$jg_lxr}',jg_lxrdh='{$jg_lxrdh}',update_date='{$create_date}' where user_id='{$user_id}'";
}
$updateresult = mysql_query($sql1);
if ($updateresult > 0) {
echo "<script>alert('机构信息更新成功');location.href='" . $url . ".php?page=" . $page . "';</script>";
} else {
echo "<script>alert('由于网络原因,操作失败,请稍后重试...');location.href='" . $url . ".php?page=" . $page . "';</script>";
}
} else {
$ised_yes_sql = "select user_name,user_type,user_passwd from blog_user where user_name='{$user_name}'";
$ised_yes_result = $public_function->getresult($ised_yes_sql);
$ised_yes_num = $public_function->getnum($ised_yes_result);
if ($ised_yes_num > 0) {
echo "<script>alert('系统已经存在该机构信息,请重新换一个机构名称?');location.href='" . $url . ".php?page=" . $page . "';</script>";
} else {
if ($user_passwd0 == "") {
//$user_passwd=md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5("123456"))))))))))));
$sql2 = "update blog_user set user_name='{$user_name}',user_type='{$user_type}',jg_mc='{$jg_mc}',user_truename='{$jg_jc}',jg_fr='{$jg_fr}',fr_dh='{$fr_dh}',jg_lxr='{$jg_lxr}',jg_lxrdh='{$jg_lxrdh}',update_date='{$create_date}' where user_id='{$user_id}'";
} else {
$user_passwd2 = md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5($_REQUEST['user_passwd']))))))))))));
$sql2 = "update blog_user set user_name='{$user_name}',user_type='{$user_type}',user_passwd='{$user_passwd2}',jg_mc='{$jg_mc}',user_truename='{$jg_jc}',jg_fr='{$jg_fr}',fr_dh='{$fr_dh}',jg_lxr='{$jg_lxr}',jg_lxrdh='{$jg_lxrdh}',update_date='{$create_date}' where user_id='{$user_id}'";
}
$updateresult2 = mysql_query($sql2);
if ($updateresult2 > 0) {
echo "<script>alert('机构信息更新成功');location.href='" . $url . ".php?page=" . $page . "';</script>";
} else {
echo "<script>alert('由于网络原因,操作失败,请稍后重试...');location.href='" . $url . ".php?page=" . $page . "';</script>";
<?php require_once '../../include/conmysql.php'; require_once '../../include/public_function.php'; $public_function = new public_function(); $blog_id = $_REQUEST['blogid']; $blog_type_user = $_SESSION['UID']; $blog_userid = $_SESSION['UID']; //获取日记存在的权限 $blog_type_sql = "select blog_type_id,blog_type_name,blog_type_intro,blog_type_user from blog_type where blog_type_user='******' or blog_type_user=0"; $blog_type_result = $public_function->getresult($blog_type_sql); $blog_type_num = $public_function->getnum($blog_type_result); ?> <!DOCTYPE html> <html> <head> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"/> <title>添加日志分类</title> <link rel="stylesheet" href="../../css/public.css" /> </head> <body> <div style="height:35px;line-height:30px;font-size: 15px;"> <span><img src="../../images/green_arrow.gif" alt="批量设置日记分类" align="absmiddle"/> <?php echo "批量设置日记分类"; ?> </span> </div> <div class="module_content" id="module_content"> <form enctype="multipart/form-data" name="example" action="publish_riji.php?rijiotype=xiugaifenlei&page=<?php echo $_REQUEST['page'];
$bg=$public_function->getbgbyuser($blog_userid);
}else if($public_function->getbgbysys()!=""){
$bg=$public_function->getbgbysys();
}else{
$bg="../../images/bg/bg3.jpg";
}
$types_option=turn_string_str($_GET['types']);
//日记管理
$select_blog_sql="select blog_id,blog_title,
blog_content,blog_userid,blog_type,blog_right,blog_date,
blog_viewtime,blog_shoucangtime,blog_zhuanfatime,blog_zantime,
blog_fenxiangtime,blog_isedview,blog_isedzhuanzai,blog_isedshoucang,
blog_isedzan,blog_isedfenxiang,blog_isedshow from blog_blog where blog_userid='$blog_userid'
order by blog_id desc";
$select_blog_result=$public_function->getresult($select_blog_sql);
$select_blog_num=$public_function->getnum($select_blog_result);
$settypes="gl_blog";
if($types_option=="setpagesize"){
$public_function->setPageSize(turn_string_sql($_GET['pagesizeset']), turn_string_sql($_GET['settypes']), $blog_userid);
echo "<script>location.href='gl_blog.php'</script>";
}
$ised_pagesize_result=mysql_query("select * from czj_pagesize where types='$settypes' and userid='$blog_userid'");
$ised_pagesize_num=mysql_num_rows($ised_pagesize_result);
$ised_pagesize_array=mysql_fetch_array($ised_pagesize_result);
if($ised_pagesize_num>0){
$pagesize=$ised_pagesize_array['pagesize'];
}else{
$pagesize=$PAGESIZE;
}
}else if($public_function->getbgbysys()!=""){
$bg=$public_function->getbgbysys();
}else{
$bg="images/bg/bg3.jpg";
}
//获取用户信息
$select_user_sql="select
user_id,
user_name,
user_isedlogin,
user_truename,
user_sex,
user_xianjudi,update_date
user_type from blog_user where user_type>'$user_type' order by update_date desc";
$select_user_result=$public_function->getresult($select_user_sql);
$select_user_num=$public_function->getnum($select_user_result);
$settypes="gl_user/gl_user";
$ised_pagesize_result=mysql_query("select * from czj_pagesize where types='$settypes' and userid='$blog_userid'");
$ised_pagesize_num=mysql_num_rows($ised_pagesize_result);
$ised_pagesize_array=mysql_fetch_array($ised_pagesize_result);
if($ised_pagesize_num>0){
$pagesize=$ised_pagesize_array['pagesize'];
}else{
$pagesize=$PAGESIZE;
}
/* if(getonepagesize($blog_userid)==""||getonepagesize($blog_userid)==null||getonepagesize($blog_userid)==0){
$pagesize=5;
}else{
$pagesize=getonepagesize($blog_userid);
