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);