where($userid, $bikenum);
break;
case "removenote":
logrequest($userid, $action);
checksession();
checkprivileges($userid);
checkbikeno($bikenum);
removenote($userid, $bikenum);
break;
case "revert":
logrequest($userid, $action);
checksession();
$bikenum = trim($_GET["bikeno"]);
checkprivileges($userid);
checkbikeno($bikenum);
revert($userid, $bikenum);
break;
case "last":
logrequest($userid, $action);
checksession();
checkprivileges($userid);
if ($_GET["bikeno"]) {
$bikenum = trim($_GET["bikeno"]);
checkbikeno($bikenum);
last($userid, $bikenum);
} else {
last($userid);
}
break;
case "stands":
logrequest($userid, $action);
mapcraft.pieces as p,
mapcraft.pieces_comments as c
WHERE
c.piece = p.id AND type = \'info\' AND p.pie = pies.id
ORDER BY
timestamp DESC LIMIT 1
)
WHERE pies.updated IS NULL');
}
function revert()
{
global $connection;
pg_query($connection, 'ALTER TABLE pies DROP COLUMN updated');
}
#
# Main
#
try {
if (count($argv) > 1 && $argv[1] == '-r') {
echo "Reverting ...\n";
revert();
} else {
echo "Applying ...\n";
apply();
}
} catch (Exception $e) {
echo "Error: " . $e->getMessage() . "\n";
exit(1);
}
function api($rig, $cmd)
{
global $haderror, $error;
global $miner, $port, $hidefields;
$socket = getsock($rig, $miner, $port);
if ($socket != null) {
socket_write($socket, $cmd, strlen($cmd));
$line = readsockline($socket);
socket_close($socket);
if (strlen($line) == 0) {
$haderror = true;
$error = "WARN: '{$cmd}' returned nothing\n";
return $line;
}
# print "$cmd returned '$line'\n";
$line = api_convert_escape($line);
$data = array();
$objs = explode('|', $line);
foreach ($objs as $obj) {
if (strlen($obj) > 0) {
$items = explode(',', $obj);
$item = $items[0];
$id = explode('=', $items[0], 2);
if (count($id) == 1 or !ctype_digit($id[1])) {
$name = $id[0];
} else {
$name = $id[0] . $id[1];
}
if (strlen($name) == 0) {
$name = 'null';
}
$sectionname = preg_replace('/\\d/', '', $name);
if (isset($data[$name])) {
$num = 1;
while (isset($data[$name . $num])) {
$num++;
}
$name .= $num;
}
$counter = 0;
foreach ($items as $item) {
$id = explode('=', $item, 2);
if (isset($hidefields[$sectionname . '.' . $id[0]])) {
continue;
}
if (count($id) == 2) {
$data[$name][$id[0]] = revert($id[1]);
} else {
$data[$name][$counter] = $id[0];
}
$counter++;
}
}
}
return $data;
}
return null;
}
break;
case "LIST":
//checkUserPrivileges($sms->Number()); //allowed for all users as agreed
checkUserPrivileges($sms->Number());
validateReceivedSMS($sms->Number(), count($args), 2, _('with stand name:') . " LIST RACKO");
listBikes($sms->Number(), $args[1]);
break;
case "ADD":
checkUserPrivileges($sms->Number());
validateReceivedSMS($sms->Number(), count($args), 3, _('with email, phone, fullname:') . " ADD king@earth.com 0901456789 Martin Luther King Jr.");
add($sms->Number(), $args[1], $args[2], trim(urldecode($sms->Text())));
break;
case "REVERT":
checkUserPrivileges($sms->Number());
validateReceivedSMS($sms->Number(), count($args), 2, _('with bike number:') . " REVERT 47");
revert($sms->Number(), $args[1]);
break;
// case "NEAR":
// case "BLIZKO":
// near($sms->Number(),$args[1]);
// case "NEAR":
// case "BLIZKO":
// near($sms->Number(),$args[1]);
case "LAST":
checkUserPrivileges($sms->Number());
validateReceivedSMS($sms->Number(), count($args), 2, _('with bike number:') . " LAST 47");
last($sms->Number(), $args[1]);
break;
default:
unknownCommand($sms->Number(), $args[0]);
}
$url = url_to_api($_REQUEST['url']);
if ($url === false) {
$error = _('Could not parse the URL.');
}
} else {
$error = isset($_REQUEST['replace']) ? _('Replace with what?') : _('Add what?');
}
if (isset($url) && $url) {
$validation = array();
update_data_array(is_array($url) ? $url : array($url));
}
} elseif (isset($_REQUEST['clear'])) {
clear_data();
$text = '';
} elseif (isset($_REQUEST['revert'])) {
$text = revert();
$validation = array();
} elseif (isset($_REQUEST['download'])) {
$e = prepare_export();
if (is_array($e)) {
$osm = create_osm($e);
header("Cache-Control: no-cache, must-revalidate");
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT");
header('Content-Type: application/x-openstreetmap+xml');
header('Content-Disposition: attachment; filename=level0_export.osm');
header('Content-Length: ' . mb_strlen($osm, '8bit'));
echo $osm;
exit;
} else {
$error = sprintf(_('Error preparing data: %s.'), $e);
}
where($userid, $bikeno);
break;
case "removenote":
logrequest($userid, $action);
checksession();
checkprivileges($userid);
checkbikeno($bikeno);
removenote($userid, $bikeno);
break;
case "revert":
logrequest($userid, $action);
checksession();
$bikeno = trim($_GET["bikeno"]);
checkprivileges($userid);
checkbikeno($bikeno);
revert($userid, $bikeno);
break;
case "last":
logrequest($userid, $action);
checksession();
checkprivileges($userid);
if ($_GET["bikeno"]) {
$bikeno = trim($_GET["bikeno"]);
checkbikeno($bikeno);
last($userid, $bikeno);
} else {
last($userid);
}
break;
case "stands":
logrequest($userid, $action);
$k = '0';
}
return $k;
}
$category = $_GET['category'];
if ($category == 0 || $category == 1001 || $category == 1002) {
$major_category = 0;
} else {
$major_category = $_GET['majorCategory'];
if ($major_category == -1) {
$major_category = 0;
}
}
$date = $_GET['dt'];
$where = "where postcategoryid={$category} and postmajorcategoryid={$major_category} and analysisdate='{$date}'";
$sql = "select c20,c10,c6,c5,c4,c3,c2,c1 from talkcount {$where} order by analysisdate asc";
$db = new MyDB();
$res = $db->query($sql);
//获取相应的分段统计消息数
while ($result = $db->fetch_assoc($res)) {
$mc = $result;
}
foreach ($mc as $key => $value) {
$k = revert($key);
$row["talkratio"] = $k;
$row["value"] = $value;
$carr[] = $row;
}
$arr = array("tableData" => $mc, "chartData" => $carr);
$db->close();
echo json_encode($arr);
<?php
/**
* - Revert words in the sentence
* Input: hello world
* Output: olleh dlrow
*
* @param string $str Sentence to revert
* @return string Sentence with reverted words
*/
function revert($str)
{
$arr = str_split($str);
$out = '';
$revert = [];
foreach ($arr as $char) {
if ($char === ' ') {
$out .= implode($revert) . ' ';
$revert = [];
} else {
array_unshift($revert, $char);
}
}
return $out . implode($revert);
}
// Test case
var_dump(revert('Hello World'));
// string -> olleH dlroW
