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='******'");
//python console
if ($result[0]['state'] == 1) {
if ($content == 'quit') {
$mysql->runSql("UPDATE python SET state=0 WHERE FromUserName='******'");
$data = '已退出Python终端...';
} else {
$data = python($content);
}
} elseif ($result[0]['state'] == 2) {
if ($content == 'quit') {
$mysql->runSql("UPDATE python SET state=0 WHERE FromUserName='******'");
$data = '已退出Mysql终端...';
} elseif ($content == 'help') {
$data = 'Select' . "\n" . 'Insert' . "\n" . 'Update' . "\n" . 'Delete' . "\n" . 'Create' . "\n" . 'Drop' . "\n" . 'Index' . "\n" . 'Alter';
} else {
if (preg_match('#^(select)#i', $content)) {
$sqlresult = $mysql->getData($content);
if ($mysql->errno() != 0) {
$data = "Error:" . $mysql->errmsg();
} else {
$data = 'mysql> ' . $content . "\n" . '-----------------' . "\n";
foreach ($sqlresult as $row) {
function terminalEngine($content, $openid)
{
global $terminal, $welcome;
$mysql = new SaeMysql();
$result = $mysql->getData("SELECT * FROM python WHERE FromUserName='******'");
if (!$result[0]['state']) {
if ($terminal[$content]) {
changeStatu($openid, $terminal[$content]);
return $welcome[$terminal[$content] - 1];
}
} elseif ($content == 'quit') {
$mysql->runSql("UPDATE python SET state=0 WHERE FromUserName='******'");
return '已退出终端...';
} else {
switch ($result[0]['state']) {
case 1:
//python
$data = python($content);
break;
case 2:
//mysql
$data = mysqlc($content);
break;
case 3:
//sqli
$data = sqli($content);
break;
default:
# code...
break;
}
return $data;
}
}
