* * 根据传入的$type确定执行的操作 * $type='list': 显示文章信息列表 * $type='details': 显示某篇文章信息的具体内容 * $type='leaveword': 用户评论 * $type='zan': 用户点赞 */ header("content-type:text/json;charset=utf-8"); require_once '../../../common/php/dbaccess.php'; require_once '../../../common/php/uploadFiles.php'; require_once '../../../common/php/regexTool.class.php'; require_once '../../../common/php/leaveword.class.php'; require_once '../../../common/php/zan.class.php'; $db = new DB(); $lwd = new LWD('wx_leaveword'); $zan = new ZAN('wx_zan'); $regex = new regexTool(); session_start(); $openid = $_SESSION['openid']; // if($openid != ""){ $type = $_REQUEST['type']; //list:列表显示;details:具体内容显示 if ($type == 'list') { /** * ************显示文章信息列表*************** */ $page = $_REQUEST['page']; $moduleId = $_REQUEST['moduleId']; $list = array(); //根据moduleId查询模块名称 $sql_name = "select name from wx_articlelist_module where id=" . $moduleId;
* $type='check': 查看某项活动的详情以及用户参与情况,并显示出三个比较热门的参与情况 * $type='details': 查看某项活动的某个用户参与的具体信息,以及其他用户对其的评论和点赞 * $type='leaveword': 用户评论 * $type='zan': 用户点赞 */ header("content-type:text/html;charset=utf-8"); require_once '../../../common/php/dbaccess.php'; require_once '../../../common/php/uploadFiles.php'; require_once '../../../common/php/regexTool.class.php'; require_once '../../../common/php/leaveword.class.php'; require_once '../../../common/php/zan.class.php'; session_start(); $openid = $_SESSION['openid']; $db = new DB(); $lwd = new LWD('wx_activity_leaveword'); $zan = new ZAN('wx_activity_zan'); $regex = new regexTool(); $type = $_GET['type']; if ($type == "ing") { /***************************显示当前正在进行的活动*************************/ //将活动中的过期的活动关闭 //wx_activity_interact_project表 $sql_valid_activity = "select valid,end,id from wx_activity_interact_project"; $res_valid_activity = $db->execsql($sql_valid_activity); $nowTime = time(); foreach ($res_valid_activity as $val_valid_activity) { if ($val_valid_activity['valid'] == 1) { if (strtotime($val_valid_activity['end']) <= $nowTime) { $sql_update_activity = "update wx_activity_interact_project set valid=0 where id='{$val_valid_activity['id']}'"; $res_update_activity = $db->execsql($sql_update_activity); }
* $type='updateLeaveword': 后台管理员编辑、修改文章信息的评论内容 * $type= 'top':将某篇文章置顶 */ header("content-type:text/json;charset=utf-8"); require_once '../../../common/php/dbaccess.php'; require_once '../../../common/php/uploadFiles.php'; require_once '../../../common/php/regexTool.class.php'; require_once '../../../common/php/leaveword_pc.class.php'; require_once '../../../common/php/zan.class.php'; require_once '../../../common/php/strlen.php'; $type = $_REQUEST['type']; //list:列表显示;details:具体内容显示 session_start(); $db = new DB(); $lwd = new LWD('wx_leaveword'); $zan = new ZAN('wx_zan'); $regex = new regexTool(); define(IP, "www.chinwhiz.cn"); if ($type == 'list') { /** * ************显示文章信息列表*************** */ $page = $_REQUEST['page']; $moduleId = $_REQUEST['moduleId']; $list = array(); $num = 10; //每页显示10条 $start = ($page - 1) * $num; //本页显示的起始位置 // 从wx_info中查询出文章信息的基本文章信息 $sql_info_num = "select id from wx_info where moduleId='{$moduleId}' ";
<?php header("content-type:text/html;charset=utf-8"); require_once '../../../common/php/dbaccess.php'; require_once '../../../common/php/uploadFiles.php'; require_once '../../../common/php/regexTool.class.php'; require_once '../../../common/php/leaveword_pc.class.php'; require_once '../../../common/php/zan.class.php'; $db = new DB(); $lwd = new LWD('wx_activity_leaveword'); $zan = new ZAN('wx_activity_zan'); $regex = new regexTool(); $type = $_REQUEST['type']; if ($type == 'list') { /***************将过期的活动关闭,并分页显示图片互动活动列表*******************/ //将活动中的过期的活动关闭 //wx_activity_interact_project表 $sql_valid_activity = "select valid,end,id from wx_activity_interact_project"; $res_valid_activity = $db->execsql($sql_valid_activity); // var_dump($res_valid_activity); $nowTime = time(); // echo $nowTime;die; foreach ($res_valid_activity as $val_valid_activity) { if ($val_valid_activity['valid'] == 1) { if (strtotime($val_valid_activity['end']) <= $nowTime) { $sql_update_activity = "update wx_activity_interact_project set valid=0 where id='{$val_valid_activity['id']}'"; $res_update_activity = $db->execsql($sql_update_activity); } } } /* //wx_vote_project表