/**
* 调用微信接口，重新获取access_token
* @return string
*/
private function _getNewAccessToken()
{
// 获取新的access_token
$apiUrl = sprintf($this->_apiUrl, APP_ID, APP_SECRET);
$newAccessToken = Curl::doCurl($apiUrl);
// 判断是否获取成功
if (!$newAccessToken['errcode'] && !empty($newAccessToken['access_token'])) {
// 将新获取的access_token更新到数据库
$c_time = time() - 200;
// 将获取到的时间提前一点
$mysql = new SaeMysql();
$sql = "SELECT `c_time`, `t_value` FROM `weixin_access_token`";
$data = $mysql->getData($sql);
//$data = DbPDO::table('weixin_access_token')->find();
if (!$data) {
// 首次插入
//DbPDO::table('weixin_access_token')->where(array('id'=>1))->add(array('c_time' => $c_time, 't_value' => $newAccessToken['access_token']));
$sql = "INSERT INTO `weixin_access_token` (`c_time`, `t_value`) VALUES ({$c_time}, " . $newAccessToken['access_token'] . ")";
} else {
// 修改
//DbPDO::table('weixin_access_token')->where(array('id'=>1))->save(array('c_time' => $c_time, 't_value' => $newAccessToken['access_token']));
$sql = "UPDATE `weixin_access_token` SET `c_time` = {$c_time} , `t_value` = " . $newAccessToken['access_token'] . " WHERE id = 1";
}
$mysql->runSql($sql);
$mysql->closeDb();
} else {
throw new Exception($newAccessToken['errcode'] . '-' . $newAccessToken['errmsg']);
}
return $newAccessToken['access_token'];
}
static function getPrintCode($uid)
{
$mysql = new SaeMysql();
// 获取当前的 print code
$sql = "SELECT `print_code` FROM `printers` WHERE `uid` = '" . $uid . "'";
$old_code = $mysql->getVar($sql);
// 清空所有 print code 为 old code 的数据
$sql = "DELETE FROM `wx_images` WHERE `print_code` = '{$old_code}'";
$mysql->runSql($sql);
// 为了避免重复，先取出所有的print code
$sql = "SELECT `code` FROM `printers`";
$codes = $mysql->getData($sql);
// 生成新的print code
$new_code = mt_rand(1000, 9999);
$canAdd = false;
while (!$canAdd) {
$canAdd = true;
foreach ($codes as $codeItem) {
if ($codeItem['code'] == $new_code) {
$new_code = mt_rand(1000, 9999);
$canAdd = false;
break;
}
}
}
$sql = "UPDATE `printers` SET `code` = '" . $new_code . "' WHERE `uid` = '" . $uid . "'";
$mysql->runSql($sql);
$mysql->closeDb();
return $new_code;
}
function getAstrosData()
{
$mysql = new SaeMysql();
$sql0 = "SELECT * FROM `" . tname("astro") . "` LIMIT 12";
$astros = $mysql->getData($sql0);
return $astros;
}
function TimingTask()
{
// load urls
$mysql = new SaeMysql();
$sql = "SELECT url FROM `url`";
$data = $mysql->getData( $sql );
$mysql->closeDb();
$queue = new SaeTaskQueue('task_queue_0_2');
$array = array();
for($i = 0; $i < sizeof($data); ++$i)
{
//$array[] = array('url'=>"http://urlwatcher.sinaapp.com/url_watch.php", "postdata"=>"target=".$data[$i], "prior"=>true);
$array[] = array('url'=>"http://urlwatcher.sinaapp.com/url_watch.php?target=" . $data[$i]["url"], "postdata"=>NULL, "prior"=>true);
}
$queue->addTask($array);
$ret = $queue->push();
if ($ret === false)
{
var_dump($queue->errno(), $queue->errmsg());
echo "Failed.";
}
else
{
echo "Success.";
print_r($array);
}
}
public function index()
{
$mysql = new SaeMysql();
$sql = "SELECT * FROM `scrawl` WHERE sid = 1";
$data = $mysql->getData($sql);
if ($mysql->errno() != 0) {
die("Error:" . $mysql->errmsg());
}
$this->assign('svg', $data[0]['data']);
$this->display();
}
function get_book_count($bookid)
{
if (empty($bookid)) {
return "数量异常";
}
$mysql = new SaeMysql();
$sql = "SELECT count FROM bookinfo WHERE id = '" . $bookid . "'";
$data = $mysql->getData($sql);
if (empty($data[0][0])) {
return "数量异常";
}
//取到总备货数量
$count1 = intval($data[0][0]);
$sql = "SELECT SUM(count) FROM sellinfo WHERE bookid = '" . $bookid . "' GROUP BY null";
$data = $mysql->getData($sql);
$count2 = 0;
if (!empty($data[0][0])) {
$count2 = intval($data[0][0]);
}
return strval($count1 - $count2);
}
function ShowDiff($group_id, $from, $to, &$summary)
{
$mysql = new SaeMysql();
$sql = "SELECT url FROM `url` WHERE `group_id`=" . $group_id;
$urls = $mysql->getData( $sql );
$results = array();
for($i = 0; $i < sizeof($urls); ++$i)
{
$title = "";
$content_diff = "";
$sql_from = "SELECT content FROM `web_content` WHERE `url`='" . $urls[$i]['url'] . "' AND `date`='" . $from . "'";
$sql_to = "SELECT content FROM `web_content` WHERE `url`='" . $urls[$i]['url'] . "' AND `date`='" . $to . "'";
$content_from = $mysql->getVar( $sql_from );
$content_to = $mysql->getVar( $sql_to );
if (!$content_from || !$content_to)
{
array_attach($results, foutput('failed', $urls[$i]['url'], NULL, $summary));
}
else
{
if ($content_from !== $content_to)
{
$content_diff = GetFormattedDiff($content_from, $content_to);
if (is_string($content_diff))
{
array_attach($results, foutput('changed', $urls[$i]['url'], $content_diff, $summary));
}
else
{
array_attach($results, foutput('error', $urls[$i]['url'], NULL, $summary));
}
}
else
{
array_attach($results, foutput('identical', $urls[$i]['url'], NULL, $summary));
}
}
}
$mysql->closeDb();
return $results;
}
public function update(){
$query = "update toupiao set {$this->pingwei} = {$this->score} where keshi_name = '{$this->jiemu}'";
//echo $query;
$mysql = new SaeMysql();
$query_submit = "select didSubmit from score_pingwei where score like '{$this->pingwei}'";
$resultOfQuery_submit = $mysql->getData($query_submit);
//var_dump($this->pingwei);
//var_dump($resultOfQuery_submit);
if ($resultOfQuery_submit[0]["didSubmit"] > 1 || ($this -> score>100)|| ($this -> score<75)) {
# code...
$this->show_error();
}else{
$mysql->runSql( $query );
$mysql->closeDb();
$this->show_success();
}
}
<?php
include 'header.php';
$mysql = new SaeMysql();
$sql = "select * from member";
$result = $mysql->getData($sql);
?>
<P>
<H2>New Income:</H2>
<P>
<form method="post" action="addIncome.php">
<table border="0">
<tr>
<td>amount:</td>
<td><input type="text" maxlength="255" size="30" name="amount" /><font color="red">(*number only)</font></td>
</tr>
<tr>
<td>from:</td>
<td>
<select name="memberId">
<?php
foreach ($result as $member) {
?>
<option value="<?php
echo $member[id];
?>
"/><?php
echo $member[name];
?>
</option>
<?php
<h1 align="center">医务科后台</h1>
<?php
//creat timestamp for record
$t = time();
$datestamp = date("Y-m-d H:i", $t);
echo "<h6 align='center'>现在时间：" . $datestamp . "</h6>";
//connect database
require_once 'conn.php';
//define openid
//getdata for person
$sql = "SELECT * FROM personalinformation_records WHERE 'check_rsk'='checked' ORDER BY id DESC";
$mysql = new SaeMysql();
//echo the result
echo "<table border='1' align='center' class='datalist'>";
$num = 0;
$query_sql = $mysql->getData($sql);
$numoflist = count($query_sql);
//$get_data =mysql_query("select * from waimai where class='{$class}' ORDER BY ord DESC");//查询
if ($numoflist <= 10) {
//如果总数小于等于10则全部生成
// makeList($get_data);
} else {
//总数大于10则分页
if (!isset($_GET['limit'])) {
$limitHead = 0;
} else {
$limitHead = $_GET['limit'];
}
//如果没有传递参数 那么初始化为0
$limitEnd = $limitHead + 10;
if ($limitEnd >= $numoflist) {
}
//列表数据获取、分页
//计算总数
$count = $mysql->getVar("select COUNT(*) from class where status=1");
//如果数据表里有数据
if ($count) {
//每页显示记录数
$page_num = 2;
//如果无页码参数则为第一页
if ($page == 0) {
$page = 1;
}
//计算开始的记录序号
$from_record = ($page - 1) * $page_num;
//获取符合条件的数据
$class_list = $mysql->getData("select A.class_id,A.class_name,B.class_name as fclass_name\n from class A left join class B on A.class_fid=B.class_id where A.status=1 \n order by A.class_id desc \n limit {$from_record},{$page_num}");
//分页函数
$multi = multi($count, $page_num, $page, "class_manager.php");
}
?>
<!--页面名称-->
<h3>部门管理<a href="class_add.php">新增部门>></a></h3>
<!--列表开始-->
<table border=1>
<tr>
<td>序号</td><td>部门名称</td><td>所属上级</td><td>操作</td>
</tr>
<?php
if ($class_list) {
foreach ($class_list as $value) {
public function update()
{
$check_caozuo = "select caozuo from toupiao where id ={$this->jiemu}";
$query = "update toupiao set {$this->pingwei} = {$this->score} where id = {$this->jiemu}";
//echo $query;
$mysql = new SaeMysql();
$mysql_caozuo = new SaeMysql();
$result_check = $mysql_caozuo->getData($check_caozuo);
//var_dump($result_check);
if ($result_check[0]['caozuo'] == "1") {
# code...
$result = $mysql->runSql($query);
if ($result) {
$this->show_success();
} else {
$this->show_fail();
}
} else {
$this->show_error();
}
//$result->free();
//$mysqli->close();
}
$sql = "update class set class_name='{$class_name}',class_fid='{$class_fid}',edittime='{$nowtime}'\n where class_id={$old_class_id}";
$mysql->runSql($sql);
} else {
//新增
$sql = "insert into class (class_name,class_fid,addtime,edittime,status) values ('{$class_name}',\n '{$class_fid}','{$nowtime}','{$nowtime}',1)";
$mysql->runSql($sql);
}
if ($mysql->errno() != 0) {
echo "<script>alert('" . $mysql->errmsg() . "');history.back();</Script>";
exit;
} else {
echo "<script>alert('操作成功！');location='class_add.php?class_id={$old_class_id}';</Script>";
exit;
}
}
$class_list = $mysql->getData("select class_name,class_id from class where status=1 order by class_fid asc");
?>
<!--页面名称-->
<h3>部门添加/修改<a href="class_manager.php">返回>></a></h3>
<!--表单开始-->
<form action="?" method="post" name="class_add" id="class_add" enctype="multipart/form-data">
<p>
部门名称：<input type="text" value="<?php
echo $class_value["class_name"];
?>
" name="class_name">
</p>
<p>
上级部门：
<select name="class_fid">
<option value="0">无上级部门</option>
$mysql = new SaeMysql();
$pagesize = 10;
$sql = "select count(*) as num from income";
$myrow = $mysql->getLine($sql);
$num = $myrow["num"];
$pages = intval($num / $pagesize);
if ($num % $pagesize) {
$pages++;
}
if (empty($_GET['page'])) {
$page = 1;
} else {
$page = intval($_GET['page']);
}
$offset = $pagesize * ($page - 1);
$datas = $mysql->getData("select t.* from (select a.id,a.amount,a.member_id,a.time,b.name from income a ,member b where a.member_id = b.id order by a.time desc)t limit {$offset},{$pagesize}");
echo "<table>\n";
if (is_array($datas)) {
foreach ($datas as $data) {
?>
<tr>
<td align="right">amount:</td><td align="left"><B><?php
echo $data["amount"];
?>
</B></td>
<td align="right">from:</td><td align="left"><B><?php
echo $data["name"];
?>
</B></td>
<td align="right">time:</td><td align="left"><B><?php
echo $data["time"];
<th>节目序号</th>
<th>节目名称</th>
<th>表演者</th>
<th>小组</th>
<th>总分</th>
<th>平均分</th>
<th>（去）总分</th>
<th>（去）平均分</th>
</tr>
<?php
//connect database
$mysql = new SaeMysql();
//mysqli_query($mysqli,"SET NAMES utf8");
$query = "select * from toupiao";
$result = $mysql->getData($query);
//var_dump($result);
$array_pingfeng = array();
//创建数组 存储qu平均分后的数组 记录id和平均分
for ($i = 0; $i < count($result); $i++) {
$row = $result[$i];
// var_dump($row);
$num_child_row = count($row) - 5;
$array_score = array_slice($row, 5);
//off 5 argues
sort($array_score);
$total_score = array_sum($array_score);
$total_pingjun_score = $total_score / $num_child_row;
array_pop($array_score);
array_shift($array_score);
$delete_score = array_sum($array_score);
function makeTimu($min, $max, $num, $i)
{
if ($num != 0 && $num > 0) {
# code...
$num = intval($num) + $i - 1;
$hasRan = array();
while ($i <= $num) {
srand((double) microtime() * 1000000);
$a = rand($min, $max);
//只要是随机的生成还没有存在于数组中
if (!in_array($a, $hasRan)) {
# code...
array_push($hasRan, $a);
$mysql = new SaeMysql();
//链接数据库
$sql = "select * from zhiShiJingDa_TiKu where id = {$a}";
$data = $mysql->getData($sql);
//var_dump($data);
//list($id,$timu,$xuanxiang01,$xuanxiang02,$xuanxiang03,$xuanxiang04,$daan) = $data[0];
//echo $timu;
echo '
<div class="panel">
<div class="panel-wrapper">
<h2 class="title">第' . ($i + 1) . '题</h2>
<p>
<span class="vote_title">' . $data[0]["timu"] . '</span>
<input name="timu[' . $i . '][timu_id]" type="text" hidden="true" value="' . $data[0]["id"] . '" />
<br/>
<br/>
<input name="timu[' . $i . '][timu_daan]" type="radio" value="A" />
<span>A、' . $data[0]["xuanxiang01"] . '</span></li>
<br/>
<input name="timu[' . $i . '][timu_daan]" type="radio" value="B" />
<span>B、' . $data[0]["xuanxiang02"] . '</span></li>
<br/>
<input name="timu[' . $i . '][timu_daan]" type="radio" value="C" />
<span>C、' . $data[0]["xuanxiang03"] . '</span>
</p>
</div>
';
$i++;
}
}
}
}
}
//列表数据获取、分页
//计算总数
$count = $mysql->getVar("select COUNT(*) from question_tb where status=1");
//如果数据表里有数据
if ($count) {
//每页显示记录数
$page_num = 10;
//如果无页码参数则为第一页
if ($page == 0) {
$page = 1;
}
//计算开始的记录序号
$from_record = ($page - 1) * $page_num;
//获取符合条件的数据
$class_list = $mysql->getData("select *\n from question_tb \n order by question_id desc \n limit {$from_record},{$page_num}");
//分页函数
$multi = multi($count, $page_num, $page, "question_manager.php");
}
?>
<!--页面名称-->
<h3>题目管理<a href="question_add.php">新增题目>></a></h3>
<!--列表开始-->
<table border=1>
<tr>
<td>序号</td><td>题目名称</td><td>选项</td><td>答案</td><td>操作</td>
</tr>
<?php
if ($class_list) {
foreach ($class_list as $value) {
function DBinsert($userid, $username)
{
$mysql = new SaeMysql();
$sql_1 = "SELECT * FROM `users` WHERE `weiboid` =" . $userid;
//$sql_1 = "SELECT * FROM `users` LIMIT 10";
$data = $mysql->getData($sql_1);
if ($mysql->errno() != 0) {
die("Error_1:" . $mysql->errmsg());
}
if (count($data) == 0) {
$sql_2 = "INSERT INTO `users` ( `weiboid` , `weiboname` ) VALUES ('" . $userid . "','" . $username . "') ";
$mysql->runSql($sql_2);
} else {
foreach ($data as $v1) {
echo '<p/>';
echo 'weiboname: ' . $v1['weiboname'] . '<br/>';
}
}
$sql_3 = "SELECT `pynames` FROM `users` WHERE `weiboid` =" . $userid;
$data = $mysql->getData($sql_3);
if ($mysql->errno() != 0) {
die("Error_3:" . $mysql->errmsg());
}
if (checkArray($data)) {
echo 'pyname is null <br/>';
} else {
//echo "length of data=".count($data).'<br/>';
foreach ($data as $v1) {
//echo '<p/>';
//echo 'pynames: ' . $v1['pynames'] . '<br/>';
$ps = explode(",", $v1['pynames']);
//echo "length of ps=".count($ps).'<br/>';
foreach ($ps as $v2) {
//echo '<p/>';
//echo 'pynames: ' . $v2 . '<br/>';
$sql_4 = "SELECT `pynames` FROM `users` WHERE `weiboid` =" . $v2;
$data_4 = $mysql->getData($sql_4);
if ($mysql->errno() != 0) {
die("Error_4:" . $mysql->errmsg());
}
if (count($data_4) == 0) {
echo '<p/>';
echo 'pynames: ' . $v2 . ' 还没有使用本服务<br/>';
} else {
echo 'pynames: ' . $v2 . ' 选中的有：';
foreach ($data_4 as $v3) {
//echo '<p/>';
echo $v3['pynames'] . '<br/>';
if (strpos($v3['pynames'], (string) $userid, 0) === false) {
//echo '没有找到';
} else {
echo '用户' . $v2 . '也选择了您！';
}
}
}
}
//SelectTag($ps);
}
}
$mysql->closeDb();
}
<?php
include 'header.php';
$mysql = new SaeMysql();
$mysql->runSql("set names 'utf8'");
$sql = "select * from member";
$members = $mysql->getData($sql);
echo "<table>\n";
foreach ($members as $member) {
?>
<tr>
<td align="right">name:</td><td align="left"><B><?php
echo $member["name"];
?>
</B></td>
<td align="right">updateTime:</td><td align="left"><B><?php
echo $member["updatetime"];
?>
</B></td>
</tr>
<tr>
<td colspan="2">balance:<FONT <?php
if ($member["balance"] < 0) {
echo "color=\"red\"";
}
?>
><?php
echo $member["balance"];
?>
</FONT></td>
</tr>
private function getAnalysedRepory($reports)
{
$kv = new SaeKV();
$kv->init();
$maxDaysOfMonth = $kv->get('maxDaysOfMonth');
$increaseRate = $kv->get('increaseRate');
$salesTarget = $kv->get('salesTarget');
$manTarget = $kv->get('manTarget');
$cosmeticsTarget = $kv->get('cosmeticsTarget');
$mysql = new SaeMysql();
$month = $reports[0][1];
$day = $reports[0][2];
$sql = "SELECT SUM(`dailySales`) FROM `sales_amount` WHERE `date` = '2016-" . $month . "-" . $day . "'";
$data = $mysql->getData($sql);
$lastYearDailySales = $data[0]['SUM(`dailySales`)'];
$sql = "SELECT SUM(`monthlySales`) FROM `sales_amount` WHERE `date` = '2016-" . $month . "-" . $day . "'";
$data = $mysql->getData($sql);
$lastYearMonthlySales = $data[0]['SUM(`monthlySales`)'];
$dailyTarget = $this->sum($reports, 3);
$realSales = $this->sum($reports, 4);
$totalSales = $this->sum($reports, 6);
$cosmeticsSales = $this->sum($reports, 7);
$manSales = $this->sum($reports, 8);
$line1 = "华东大区，" . $month . "月" . $day . "日，时间进度" . round($day / $maxDaysOfMonth * 100) . "%，当月目标增长率" . $increaseRate . "%\r\n";
$line2 = "1）当日指标：" . $dailyTarget . "，实际销量：" . $realSales . "，当日达成率:" . round($realSales / $dailyTarget * 100, 1) . "%，同比增长：" . round(($realSales / $lastYearDailySales - 1) * 100, 1) . "%；\r\n";
$line3 = "2）当月指标：" . $salesTarget . "，累计销售：" . $totalSales . "，累计达成率：" . round($totalSales / $salesTarget * 100, 1) . "%，同比增长：" . round(($totalSales / $lastYearMonthlySales - 1) * 100, 1) . "%；\r\n";
$line4 = "3）重点品：男士销售：" . $manSales . "元，男士指标达成：" . round($manSales / $manTarget * 100, 1) . "%；彩妆销售：" . $cosmeticsSales . "元，彩妆指标达成：" . round($cosmeticsSales / $cosmeticsTarget * 100, 1) . "%；\r\n";
$line5 = "4）执行反馈：无";
return $line1 . $line2 . $line3 . $line4 . $line5;
}
<?php
if (!(isset($_COOKIE['name']) && $_COOKIE['islogin'] === '1')) {
//echo "111";
header("location:login.html");
exit;
} else {
//如果传入的name在评委数据库中没有查到 就提示查无此人 及返回重新登入，如果正确则获取相对应的score值
//include("conn.php");
$mysql = new SaeMysql();
$check_pingwei = "SELECT * FROM `personalinformation_users` WHERE `user` like '%" . $_COOKIE['name'] . "%'";
//$result_check= $mysqli->query($check_pingwei);
$result_check = $mysql->getData($check_pingwei);
///var_dump($result_check);
//echo "222";
if (empty($result_check)) {
header("location:login.html");
exit;
}
}
error_reporting(E_ALL ^ E_NOTICE ^ E_WARNING);
?>
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
<meta name="Description" content="登入页面" />
<meta name="Keywords" content="登入" />
<link href="login.css" rel="stylesheet" type="text/css" media="all" />
<title>个人信息录入</title>
<script src='jquery-1.11.1.min.js'>
//echo $link;
$pagesize = 10;
$sql = "select count(*) as num from outcome";
$myrow = $mysql->getLine($sql);
$num = $myrow["num"];
$pages = intval($num / $pagesize);
if ($num % $pagesize) {
$pages++;
}
if (empty($_GET['page'])) {
$page = 1;
} else {
$page = intval($_GET['page']);
}
$offset = $pagesize * ($page - 1);
$rs = $mysql->getData("select t.* from (select * from outcome order by time desc)t limit {$offset},{$pagesize}");
echo "<table>\n";
if (is_array($rs)) {
foreach ($rs as $data) {
?>
<tr>
<td align="right">amount:</td><td align="left"><B><?php
echo $data["amount"];
?>
</B></td>
<td align="right">reason:</td><td align="left"><B><?php
echo $data["reason"];
?>
</B></td>
<td align="right">personNum:</td><td align="left"><B><?php
echo $data["personnum"];
<?php
header("Content-Type:application/json;charset=UTF-8");
$code = $_GET['code'];
$poc = array("poc_1" => 1, "poc_2" => 2, "poc_3" => 3, "poc_4" => 4, "poc_5" => 5, "poc_6" => 6, "poc_7" => 7, "poc_8" => 8, "poc_9" => 9, "poc_10" => 10);
//参数 code验证
if (strpos($code, "||") == false) {
echo json_encode(array("status" => false, "msg" => "error code!"));
exit;
}
list($key, $value) = explode("||", $code);
if ($value != strtoupper(substr(md5("hongcha" . $key . "android"), 1, -1))) {
echo json_encode(array("status" => false, "msg" => "error code!"));
exit;
}
$mysql = new SaeMysql();
$sql = "select * from result where code ='" . $mysql->escape($code) . "'";
$data = $mysql->getData($sql);
$result = array();
if ($data) {
$tmpdata = $data[0];
foreach ($tmpdata as $key => $value) {
if ($key != "code" && $key != "id" && $key != "token" && $key != "ua") {
$result[$key] = intval($value);
}
}
echo json_encode(array("status" => true, "msg" => $result));
} else {
echo json_encode(array("status" => false, "msg" => "query empty!"));
}
$mysql->closeDb();
</div>
<div class="daterange">
<label for="from">From</label>
<input type="text" id="from" name="from"/>
<label for="to">to</label>
<input type="text" id="to" name="to"/>
<select id="url_group" name="url_group">
<?php
include_once( 'saemysql.class.php' );
$mysql = new SaeMysql();
$sql = "SELECT * FROM `url_group`";
$groups= $mysql->getData( $sql );
for ($i = 0; $i < sizeof($groups); $i++)
{
echo '<option value="' . $groups[$i]['group_id'] . '">' . $groups[$i]['group_name'] . '</option>';
}
$mysql->closeDb();
?>
</select>
<button id="go" name="go">GO</button >
</div>
<div class="error" id="errortext">
<table class="table table-hover">
<thead>
<tr>
<th>题目编号</th>
<th>描述</th>
<th>正确答案</th>
<th>查看</th>
<th>修改</th>
<th>删除</th>
</tr>
</thead>
<tbody>
<?php
$mysql = new SaeMysql();
$sql = "select `id`,`question`,`right_answer` from `choice_question` order by `id` DESC";
$rows = $mysql->getData($sql);
$mysql->closeDb();
// print_r($rows);
foreach ($rows as $row) {
echo "<tr>";
echo "<td>" . $row["id"] . "</td>";
echo "<td>" . substr_cut($row["question"], 50) . "</td>";
echo "<td><code>" . $row["right_answer"] . "</code></td>";
echo "<td><a class=\"btn btn-info\" href=\"./index.php?id=7&qid=" . $row["id"] . "\">查看</a></td>";
echo "<td><a class=\"btn btn-primary\" href=\"./index.php?id=8&qid=" . $row["id"] . "\">修改</a></td>";
echo "<td><a class=\"btn btn-danger\" href=\"../function/admin/common-action.php?cmd=delete-choice&id=" . $row["id"] . "\">删除</a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
<?php
$channel = new SaeChannel();
$name = 'user' . time() . '-' . rand(0, 10000);
$duration = 3600;
$url = $channel->createChannel($name, $duration);
$mysql = new SaeMysql();
$sql = "SELECT name FROM online LIMIT 1";
$sqlback = $mysql->getData($sql);
if ($sqlback[0]['name']) {
$to = $sqlback[0]['name'];
$mysql->runSql("delete from online where name='{$to}'");
} else {
$mysql->runSql("insert into online(name) values('{$name}')");
}
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, time(), $msgType, "你已经退出当前答题，寻求帮助请输入“help”，重新挑战请输入“go”！");
echo $resultStr;
exit;
}
//用户查询最好成绩
if (strtolower($form_Content) == "best") {
$question_value = $mysql->getLine("select * from answer_tb where answer_user='******' order by answer_time asc limit 0,1");
//回复消息
$msgType = "text";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, time(), $msgType, "你最好的成绩为：" . $question_value["answer_time"] . "秒\n\n完成时间为：" . $question_value["create_time"]);
echo $resultStr;
exit;
}
//用户查询历史成绩，最新的10次
if (strtolower($form_Content) == "history") {
$question_list = $mysql->getData("select * from answer_tb where answer_user='******' \n \t\t\torder by create_time desc limit 0,10");
$out_str = "";
foreach ($question_list as $key => $value) {
$out_str .= $key + 1 . ". 在" . $value["create_time"] . "完成答题，成绩为答错" . $value["answer_error"] . "次，用时" . $value["answer_time"] . "秒\n\n";
}
//回复消息
$msgType = "text";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, time(), $msgType, $out_str);
echo $resultStr;
exit;
}
//开始答题
if (strtolower($form_Content) == "go") {
//从题库中随机抽取5道题目
$question_list = $mysql->getData("select *\n from question_tb \n where question_id >=\n (select floor(80+rand()*((select max(question_id) from question_tb)-(select min(question_id) from question_tb)) + \n (select min(question_id) from question_tb)))\n order by question_id limit " . $question_nums);
//将数组序列化存放到缓存，创建当前用户题库，时间设定10分钟
function matchEngine($content)
{
global $reg_arr, $biaoqing;
foreach ($reg_arr as $key => $value) {
if (preg_match($key, $content, $matches)) {
switch ($value) {
case 'dream':
$data = dream($matches[2]);
break;
case 'translate':
$data = translateAPI($matches[2]);
break;
case 'biaoqing':
$data = $biaoqing[rand(0, count($biaoqing) - 1)];
break;
case 'changeSimsimiKey':
$s = new SaeStorage();
$s->write('simsimi', 'simi.txt', $matches[2]);
$data = '更改成功！';
break;
case 'md5':
$data = md5($matches[2]);
break;
case 'qrcode':
$qrcode = 'http://chart.apis.google.com/chart?cht=qr&chs=400x400&choe=UTF-8&chl=' . $matches[2];
$data = array(array('title' => $matches[2], 'cover' => $qrcode, 'link' => $qrcode));
break;
case 'bingSearch':
$bingweb = bing($matches[2], 'Web');
$bingimage = bing($matches[2], 'Image');
$data = array(array('title' => $matches[2], 'note' => '', 'cover' => $bingimage[0], 'link' => ''));
//max:7
for ($i = 0; $i < 5; $i++) {
array_push($data, array('title' => $bingweb[$i]['title'] . "\n" . '------------------------------------------', 'note' => $bingweb[$i]['description'], 'cover' => '', 'link' => $bingweb[$i]['url']));
}
break;
case 'wiki':
$wiki = wiki($matches[2], $lng);
$data = array();
for ($i = 0; $i < 5; $i++) {
array_push($data, array('title' => $wiki[$i]['title'] . "\n" . '------------------------------------------', 'note' => $wiki[$i]['snippet'], 'cover' => '', 'link' => 'http://zh.wikipedia.org/wiki/' . $wiki[$i]['title']));
}
break;
case 'doubanMovie1':
$m = doubanMovies($matches[2]);
$data = array(array('title' => $m[0]['title'], 'note' => $m[0]['year'] . ' ' . $m[0]['average'], 'cover' => $m[0]['images']->large, 'link' => $m[0]['alt']));
for ($i = 1; $i <= 5; $i++) {
array_push($data, array('title' => $m[$i]['title'], 'note' => '又名:' . $m[$i]['original_title'] . "\n" . '上映日期:' . $m[$i]['year'] . "\n" . '评价:' . $m[$i]['average'], 'cover' => $m[$i]['images']->small, 'link' => $m[$i]['alt']));
}
break;
case 'doubanMovie2':
$m = doubanMovies($matches[2]);
$movie = doubanMovie($m[0]['id']);
$xinxi = '又名:';
foreach ($movie['aka'] as $value) {
$xinxi .= $value . '/';
}
$xinxi .= "\n" . '上映日期:' . $movie['year'] . "\n" . '制片国家:';
foreach ($movie['countries'] as $value) {
$xinxi .= $value . '/';
}
$xinxi .= "\n" . '类型:';
foreach ($movie['genres'] as $value) {
$xinxi .= $value . '/';
}
$xinxi .= "\n" . '评价:' . $movie['average'];
$data = array(array('title' => $movie['title'], 'cover' => $movie['images'], 'link' => $movie['mobile_url']), array('note' => $xinxi, 'link' => $movie['mobile_url']), array('title' => '简介', 'note' => $movie['summary'], 'link' => $movie['mobile_url']), array('title' => '导演', 'note' => $movie['directors'][0]->name, 'cover' => $movie['directors'][0]->avatars->small, 'link' => $movie['directors'][0]->alt), array('title' => '主演', 'note' => $movie['casts'][0]->name, 'cover' => $movie['casts'][0]->avatars->small, 'link' => $movie['casts'][0]->alt));
break;
case 'doubanBook1':
$b = doubanBooks($matches[2]);
$data = array(array('title' => $b[0]['title'], 'note' => $b[0]['author'][0] . ' ' . $b[0]['average'], 'cover' => $b[0]['images']->large, 'link' => $b[0]['alt']));
for ($i = 1; $i <= 4; $i++) {
array_push($data, array('title' => $b[$i]['title'], 'note' => '作者:' . $b[$i]['author'][0] . "\n" . '出版社:' . $b[$i]['publisher'] . "\n" . '出版日期:' . $b[$i]['pubdate'] . "\n" . '价格:' . $b[$i]['price'] . "\n" . '评价:' . $b[$i]['average'] . "\n" . '导言:' . $b[$i]['summary'], 'cover' => $b[$i]['images']->small, 'link' => $b[$i]['alt']));
}
break;
case 'doubanBook2':
$b = doubanBooks($matches[2]);
$bk = doubanBook($b[0]['id']);
$data = array(array('title' => $bk['title'], 'cover' => $bk['images'], 'link' => $bk['alt']), array('note' => '作者:' . $bk['author'][0] . "\n" . '出版社:' . $bk['publisher'] . "\n" . '出版日期:' . $bk['pubdate'] . "\n" . '价格:' . $bk['price'] . "\n" . '评价:' . $bk['average'], 'link' => $bk['alt']), array('title' => '导言:', 'note' => $bk['summary'], 'link' => $bk['alt']));
break;
case 'doubanMusic1':
$m = doubanMusics($matches[2]);
$data = array(array('title' => $m[0]['title'], 'note' => $m[0]['average'], 'cover' => $m[0]['image'], 'link' => $m[0]['alt']));
for ($i = 1; $i <= 4; $i++) {
array_push($data, array('title' => $m[$i]['title'], 'note' => '作者:' . $m[$i]['author'][0]->name . "\n" . '出版社:' . $m[$i]['publisher'][0] . "\n" . '出版日期:' . $m[$i]['pubdate'][0] . "\n" . '表演者:' . $m[$i]['singer'][0] . "\n" . '评价:' . $m[$i]['average'] . "\n" . '类型:' . $m[$i]['version'][0], 'cover' => $m[$i]['image'], 'link' => $m[$i]['alt']));
}
break;
case 'doubanMusic2':
$m = doubanMusics($matches[2]);
$mu = doubanMusic($m[0]['id']);
$data = array(array('title' => $mu['title'], 'cover' => $mu['image'], 'link' => $mu['mobile_link']), array('note' => '表演者:' . $mu['singer'][0] . "\n" . '专辑类型:' . $mu['version'][0] . "\n" . '发行时间:' . $mu['pubdate'][0] . "\n" . '作者:' . $mu['author'][0]->name . "\n" . '出版者:' . $mu['publisher'][0] . "\n" . '评价:' . $mu['average'], 'link' => $mu['mobile_link']), array('title' => '简介:', 'note' => $mu['summary'], 'link' => $mu['mobile_link']));
break;
case 'moments1':
$moment = $matches[2];
$time = time();
$date = date("Y-m-d H:i:s", time());
$mysql = new SaeMysql();
$res = $mysql->getData("SELECT alias FROM info WHERE FromUserName='******'");
$alias = $res[0]['alias'];
if (!$alias) {
$data = '由于你是第一次发送动态，请按照以下格式回复基本信息:' . "\n" . '昵称:+你的昵称';
} else {
$mysql->runSql("INSERT INTO moments(FromUserName,alias,moment,time,date) VALUES ('{$openid}','{$alias}','{$moment}',{$time},'{$date}')");
$data = "发送成功，你可以现在上传一张图片作为配图，当然也可以不上传啦。回复[动态]查看";
}
break;
case 'moments2':
$alias = $matches[2];
$mysql = new SaeMysql();
$res = $mysql->getData("SELECT * FROM info");
$num = 0;
while ($res[$num]) {
if ($alias == $res[$num]['alias'] || $alias == '小u' || $alias == 'urinx') {
$t = 1;
} elseif ($openid == $res[$num]['FromUserName']) {
$u = 1;
}
$num++;
}
if ($t) {
$data = '该用户名已被注册，请重新输入';
} else {
if ($u) {
$mysql->runSql("UPDATE info SET alias='{$alias}' WHERE FromUserName='******'");
$data = '更改成功!';
} else {
$mysql->runSql("INSERT INTO info(FromUserName,alias) VALUES ('{$openid}','{$alias}')");
$data = '注册成功!';
}
}
break;
default:
# code...
break;
}
}
}
return $data;
}
<?php
if (defined('SAE_MYSQL_DB')) {
$sql = new SaeMysql();
} else {
require 'x/mysql.class.php';
}
$list = $sql->getData('SELECT * FROM imouto_article ORDER BY created DESC LIMIT 0,15');
$h = '<?xml version="1.0" encoding="UTF-8"?>' . "\n" . '<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">' . "\n" . '<channel>' . "\n" . ' <title>卜卜口</title>' . "\n" . ' <link>http://mouto.org/</link>' . "\n" . ' <description>94年少年。</description>' . "\n" . ' <lastBuildDate>' . date('D, d M Y H:i:s ', $list[0]['created']) . '</lastBuildDate>' . "\n" . ' <language>zh-CN</language>' . "\n";
foreach ($list as $p) {
$h .= ' <item>' . "\n" . ' <title><![CDATA[' . $p['title'] . ']]></title>' . "\n" . ' <link>http://mouto.org/#!' . $p['pid'] . '</link>' . "\n" . ' <category>' . $p['category'] . '</category>' . "\n" . ' <pubDate>' . date('D, d M Y H:i:s ', $p['created']) . '</pubDate>' . "\n" . ' <description><![CDATA[';
if ($p['cover']) {
$h .= '<p><img src="http://ww2.sinaimg.cn/large/' . $p['cover'] . '.jpg"></p>';
}
$h .= $p['text'] . ']]></description>' . "\n" . ' </item>' . "\n";
}
$h .= '</channel>' . "\n" . '</rss>';
header('Content-type: application/rss+xml;charset=utf-8');
exit($h);
file_put_contents('rss.xml', $h);
$ghost = array('短篇鬼故事' => 1, '长篇鬼故事' => 2, '校园鬼故事' => 3, '医院鬼故事' => 4, '家里鬼故事' => 5, '民间鬼故事' => 6, '灵异事件' => 7, '听鬼故事' => 10, '中国灵异' => 25, '灵异知识库' => 26, '推理小说' => 46);
$help = '这是目前小u有的功能:' . "\n" . '-----------------' . "\n" . '[小u]' . "\n" . ':查看小u的基本信息，以及功能介绍和近期更新' . "\n" . '-----------------' . "\n" . '[帮助]' . "\n" . ':查看使用帮助' . "\n" . '-----------------' . "\n" . '[查水表]' . "\n" . ':查询寝室的水电费(华科)' . "\n" . '-----------------' . "\n" . '[每日一句]' . "\n" . ':每天更新一句英语，中英对照' . "\n" . '-----------------' . "\n" . '[点歌]' . "\n" . ':小u每天会为大家推荐好的歌曲，希望大家喜欢。如果想给某人点歌的话，可以直接跟我说哦' . "\n" . '-----------------' . "\n" . '[笑话]' . "\n" . ':郁闷时看看笑话吧，小u这里有好多笑话等着你呢' . "\n" . '-----------------' . "\n" . '[新闻]' . "\n" . ':没事的时候大家多看看新闻吧，小u不懈的为你奉送中' . "\n" . '-----------------' . "\n" . '[彩票]' . "\n" . ':每天的彩票信息一目了然' . "\n" . '-----------------' . "\n" . '翻译' . "\n" . ':发送"#+你要翻译的内容",即可收到详细结果，例如:#doofus' . "\n" . '-----------------' . "\n" . '天气+找小u' . "\n" . ':点击下面的“+”，发送你的的位置信息，即可收到本地的天气预报，并且看到你和小u的距离哟。' . "\n" . '-----------------' . "\n" . 'bing搜索' . "\n" . ':发送"%+你要搜索的内容",即可收到详细结果，例如:%dweeb' . "\n" . '-----------------' . "\n" . '维基百科' . "\n" . ':发送"&+你要搜索的内容",小u会根据你的输入自动判断查询中文维基或是英文,(*^__^*) 嘻嘻。例如:&spaz' . "\n" . '-----------------' . "\n" . '二维码' . "\n" . ':发送"*+你要生成的内容",小u会返回生成的二维码。例如:*嘟嘟噜' . "\n" . '-----------------';
$help .= "\n" . '豆瓣' . "\n" . '1.书' . "\n" . ' bs:关键字 搜索相关的书籍' . "\n" . ' b:书名 查看详细内容' . "\n" . '2.音乐' . "\n" . ' ms:关键字 搜索相关的音乐' . "\n" . ' m:音乐名 查看详细内容' . "\n" . '3.电影' . "\n" . ' vs:关键字 搜索相关的电影' . "\n" . ' v:电影名 查看详细内容' . "\n" . '-----------------';
$help .= "\n" . '动态' . "\n" . ':发送":+你要分享的文字"即可，大家可以回复[动态]查看，都可以看到哦。例如 :这是我发的第一个说说' . "\n" . '-----------------';
$help .= "\n" . '美女识别' . "\n" . ':上传图片，看看小u的眼力吧' . "\n" . '-----------------' . "\n" . '周公解梦' . "\n" . ':发送"梦到xxx",小u来预测吉凶，例如"梦到小u"' . "\n" . '-----------------' . "\n" . '手机号码查询' . "\n" . ':直接发送手机号' . "\n" . '-----------------';
$help .= "\n" . '[鬼故事]' . "\n" . ':小u精心为你准备的鬼故事哟，超吓人的说，午夜凌晨看一看好阔怕。。' . "\n" . '-----------------' . "\n" . '[短篇鬼故事]' . "\n" . ':让喜欢鬼故事的读者在这里快速感受到不一样的诡异，篇幅较短，适合想快速阅读完鬼故事的朋友' . "\n" . '-----------------' . "\n" . '[长篇鬼故事]' . "\n" . ':篇幅较长，情节曲折，剧情跌宕起伏，一个好的长篇鬼故事，就是一次刺激的心灵旅行' . "\n" . '-----------------' . "\n" . '[校园鬼故事]' . "\n" . ':这里的鬼故事都与校园有关或者是发生在学校里的鬼故事，让喜爱鬼故事的读者了解更多的校园鬼故事' . "\n" . '-----------------' . "\n" . '[医院鬼故事]' . "\n" . ':我们在恐怖鬼片里也常见到发生在医院里的鬼故事事件，但有更多的鬼故事等待你去发现，一起来看医院鬼故事吧' . "\n" . '-----------------' . "\n" . '[家里鬼故事]' . "\n" . ':发生在家里的鬼故事比较多，快来看看都有哪些恐怖的家里鬼故事吧' . "\n" . '-----------------';
$help .= "\n" . '[民间鬼故事]' . "\n" . ':中国民间鬼故事来源于古代的传奇小说，和现代的民间流传奇闻中。同时鬼故事网也搜集了国外吸血鬼的故事，欢迎大家阅读民间鬼故事' . "\n" . '-----------------' . "\n" . '[灵异事件]' . "\n" . ':灵异事件在世界各地每个角落经常发生，你身边是否也有灵异事件呢？灵异事件频道最全面的记录最新真实灵异事件，中国灵异事件，国外灵异事件，灵异鬼故事大全，带你进入灵异鬼故事的世界' . "\n" . '-----------------' . "\n" . '[中国灵异]' . "\n" . ':整理最全的中国真实灵异事件大全，将会带您走入从古到今发生在中国的灵异事件' . "\n" . '-----------------' . "\n" . '[灵异知识库]' . "\n" . ':灵异知识大全,例如如何避鬼,招鬼,阵法、鬼魂禁忌等等详细内容' . "\n" . '-----------------';
$help .= "\n" . '[推理小说]' . "\n" . ':内容涵盖惊悚、悬疑、侦探、武侠等，一切以推理为出发点，挑战思维极限，考验缜密的逻辑。风格：先锋、酷炫、丰富多彩、可读性强。杂志力推原创，名家新秀携手亮相，联手打造包罗万象，令人耳目一新、心驰神往的异度空间' . "\n" . '-----------------' . "\n" . '[听鬼故事]' . "\n" . ':张震讲鬼故事,吓死你不偿命' . "\n" . '-----------------';
$help .= "\n" . '#[xx]内的内容xx是指你发送给小u的';
// 接收位置
if ($type == 'location') {
$uriID = 'oTHwbt_9H0QVjJn8AdI-fmkHdKgM';
$X = $xml->Location_X;
$Y = $xml->Location_Y;
$sql = "SELECT Location_X,Location_Y FROM info WHERE FromUserName='******'";
$sqlback = $mysql->getData($sql);
$pre_X = $sqlback[0]['Location_X'];
$pre_Y = $sqlback[0]['Location_Y'];
$wData = weatherAPI($X, $Y);
//天气查询
$distance = W::getDistance($X, $Y, $pre_X, $pre_Y);
//计算距离
if ($openid == $uriID) {
$mysql->runSql("UPDATE info SET Location_X='{$X}',Location_Y='{$Y}' WHERE FromUserName='******'");
$data = '主人的位置已上传' . "\n" . 'X:' . $X . "\n" . 'Y:' . $Y . "\n" . '相距上次位置' . $distance . 'km';
} else {
$data = '哦哦，你和我的距离只有' . $distance . 'km哟';
}
$data .= "\n" . '------------------------------' . "\n" . $wData;
} elseif ($type == 'text') {
$result = $mysql->getData("SELECT * FROM python WHERE FromUserName='******'");
