/**
* Builds a basic SPARQL query
* @param string $query SPARQL query string
* @return array an array of associative arrays containing the bindings
*/
function sparqlSelect($query)
{
global $endpoint;
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, $endpoint);
curl_setopt($curl, CURLOPT_POST, true);
curl_setopt($curl, CURLOPT_POSTFIELDS, getQueryData($query));
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
$content = curl_exec($curl);
curl_close($curl);
$xml = simplexml_load_string($content);
$results = array();
foreach ($xml->results->result as $result) {
$arr = array();
foreach ($result->binding as $binding) {
$name = $binding['name'];
$arr["{$name}"] = (string) $binding->children();
}
array_push($results, $arr);
}
return $results;
}
echo "\r\n";
}
mysql_free_result($result);
break;
case 'get_user_meeting':
$userid = getQueryData('userid');
$sql = "select a.meetingid, b.meetingname\r\n\t\t\t\t\tfrom tbl_user_meeting a, tbl_meeting b \r\n\t\t\t\t\twhere a.delete_flag=0 and b.delete_flag=0 and a.meetingid=b.id and a.userid='" . $userid . "'";
$result = querySQL($db, $sql);
$data = array();
while ($row = mysql_fetch_assoc($result)) {
$data[] = $row;
}
responseData(true, null, $data);
break;
case 'get_all_meeting':
$userid = getQueryData('userid');
$sql = "select id as meetingid, meetingname from tbl_meeting where delete_flag=0 and\r\n\t\t\t\t\t\t\tid not in (select meetingid from tbl_user_meeting where delete_flag=0 and userid='" . $userid . "')";
$result = querySQL($db, $sql);
$data = array();
while ($row = mysql_fetch_assoc($result)) {
$data[] = $row;
}
responseData(true, null, $data);
break;
default:
responseData(false, 'invalid function');
break;
}
} catch (Exception $e) {
responseData(false, $e->getMessage());
}
}
$sql .= "\r\n\t\t\t\t\t\t) a left outer join\r\n\t\t\t\t\t\t(\r\n\t\t\t\t\t\tselect \r\n\t\t\t\t\t\t\tdistinct\r\n\t\t\t\t\t\t\tuserid,\r\n\t\t\t\t\t\t\t(case when date_format(start_time, '%Y') < '" . $current . "' then -13 else 0 end) + month(start_time) as start_time, \r\n\t\t\t\t\t\t\t(case when date_format(coalesce(end_time, start_time), '%Y') > '" . $current . "' then +13 else 0 end) + month(end_time) as end_time\r\n\t\t\t\t\t\t\tfrom tbl_user_history\r\n\t\t\t\t\t\t\twhere date_format(start_time, '%Y') <= '" . $current . "' and \r\n\t\t\t\t\t\t\t\t\tdate_format(coalesce(end_time, start_time), '%Y') >= '" . $current . "'\r\n\t\t\t\t\t\t) c on a.t >= c.start_time and a.t <= coalesce(c.end_time, c.start_time)\r\n\t\t\t\t\t\tgroup by a.t\r\n\t\t\t\t\t";
$params["current"] = $current;
}
}
}
$result = querySQL($db, $sql);
$data = array();
while ($row = mysql_fetch_assoc($result)) {
$data[] = $row;
}
responseData(true, null, $data, $params);
break;
case 'channel':
$x_type = getQueryData('type');
$x_pos = getQueryData('pos');
$params = array();
if ($x_type == 'date') {
$current = executeScalar($db, "select date_format(date_add(now(), INTERVAL " . $x_pos . " DAY), '%Y-%m-%d')");
$sql = "\r\n\t\t\t\t\t\tselect \r\n\t\t\t\t\t\t\ta.name as x, \r\n\t\t\t\t\t\t\tcoalesce(floor(sum(timestampdiff(second, \r\n\t\t\t\t\t\t\tcase when b.start_time < '" . $current . "' then '" . $current . "' else b.start_time end, \r\n\t\t\t\t\t\t\tcase when b.end_time > date_add('" . $current . "', INTERVAL 1 DAY) then date_add('" . $current . "', INTERVAL 1 DAY) else b.end_time end\r\n\t\t\t\t\t\t\t)/60)), 0) as y\r\n\t\t\t\t\t\tfrom tbl_channel a left outer join tbl_user_history b\r\n\t\t\t\t\t\ton b.delete_flag=0 and b.end_time is not null\r\n\t\t\t\t\t\tand date_format(b.start_time, '%Y-%m-%d') <= '" . $current . "' and\r\n\t\t\t\t\t\tdate_format(b.end_time, '%Y-%m-%d') >= '" . $current . "'\r\n\t\t\t\t\t\tand a.id=b.channelid\r\n\t\t\t\t\t\twhere a.delete_flag=0\r\n\t\t\t\t\t\tgroup by a.channelid\r\n\t\t\t\t\t\torder by a.name\r\n\t\t\t\t\t";
$params["current"] = $current;
} else {
if ($x_type == 'month') {
$current = executeScalar($db, "select date_format(date_add(now(), INTERVAL " . $x_pos . " MONTH), '%Y-%m')");
$sql = "\r\n\t\t\t\t\t\tselect \r\n\t\t\t\t\t\t\ta.name as x, \r\n\t\t\t\t\t\t\tcoalesce(floor(sum(timestampdiff(second, \r\n\t\t\t\t\t\t\tcase when b.start_time < '" . $current . "-1' then '" . $current . "-1' else b.start_time end, \r\n\t\t\t\t\t\t\tcase when b.end_time > date_add('" . $current . "-1', INTERVAL 1 MONTH) then date_add('" . $current . "-1', INTERVAL 1 MONTH) else b.end_time end\r\n\t\t\t\t\t\t\t)/60)), 0) as y\r\n\t\t\t\t\t\tfrom tbl_channel a left outer join tbl_user_history b\r\n\t\t\t\t\t\ton b.delete_flag=0 and b.end_time is not null\r\n\t\t\t\t\t\tand date_format(b.start_time, '%Y-%m') <= '" . $current . "' and\r\n\t\t\t\t\t\tdate_format(b.end_time, '%Y-%m') >= '" . $current . "'\r\n\t\t\t\t\t\tand a.id=b.channelid\r\n\t\t\t\t\t\twhere a.delete_flag=0\r\n\t\t\t\t\t\tgroup by a.channelid\r\n\t\t\t\t\t\torder by a.name\r\n\t\t\t\t\t";
$params["current"] = $current;
}
}
$result = querySQL($db, $sql);
$data = array();
while ($row = mysql_fetch_assoc($result)) {
}
}
if ($pdate != null || $ptime != null) {
$sql .= ", program_time = concat(\r\n\t\t\t\t\t\t\t\t\t\tdate_format(" . ($pdate == null ? "program_time" : correctSQL($data["pdate"])) . ", '%Y-%m-%d '), \r\n\t\t\t\t\t\t\t\t\t\ttime_format(" . ($ptime == null ? "program_time" : correctSQL($data["ptime"])) . ", '%H:%i'))";
}
$sql = $sql . " where delete_flag=0 and id=" . correctSQL($data["id"]);
executeSQL($db, $sql);
$result = querySQL($db, "select * from tbl_channel_program where id = " . correctSQL($data["id"]));
while ($row = mysql_fetch_assoc($result)) {
$return[] = $row;
break;
}
responseData(true, null, $return);
break;
case 'channel_program_destroy':
$data = getQueryData('data');
$data = json_decode($data, true);
$id = correctSQL($data);
$sql = "update tbl_channel_program set delete_flag=1, update_id=" . correctSQL($login_id) . ", update_date=now() where id=" . $id;
executeSQL($db, $sql);
$sql = "select * from tbl_channel_program where delete_flag=0 and id=" . $id;
$result = querySQL($db, $sql);
$data = array();
while ($row = mysql_fetch_assoc($result)) {
$data[] = $row;
}
responseData(true, null, $data);
break;
default:
responseData(false, 'invalid function');
break;
$data = getQueryData('data');
$data = json_decode($data, true);
$return = array();
$sql = "update tbl_user_status set memo=" . correctSQL($data["memo"]) . " where delete_flag=0 and id=" . correctSQL($data["id"]);
$logger->debug(preg_replace('/\\s+/', ' ', $sql));
executeSQL($db, $sql);
responseData2(true, null);
break;
case 'usermail_create':
try {
$userid = getQueryData('userid');
$email = getQueryData('email');
$serviceid = getQueryData('serviceid');
$period = getQueryData('period');
$money = getQueryData('money');
$content = getQueryData('content');
$sql = "select password from tbl_user where userid=" . correctSQL($userid) . " and delete_flag=0";
$logger->debug(preg_replace('/\\s+/', ' ', $sql));
$password = executeScalar($db, $sql);
$msg = '
お客様へ<br><br>
この度は、SKYLIVE365サービスをご利用頂き誠に有難う御座いました。<br>
ご購入頂いたID及び明細は下記の通りです。<br>
ID：<font color="red">' . 'PP' . $userid . '</font><br>
PW：<font color="red">' . $password . '</font><br>
注：パスワードは初回ログイン後、お客様自身でご自由に変更可能です。<br>
有効期限：<font color="red">' . $period . '</font><br>
注：有効期限は初回ログイン時点からカウントさせて頂きます。<br>
(注：有効期限は購入日からカウントさせて頂きます。)<br>
請求料金+Paypalの手数料：<font color="red">' . $money . '円</font><br>
何か不明な点御座いましたら、総合アフターサポートまでご連絡ください。<br>
$data = array();
while ($row = mysql_fetch_assoc($result)) {
$data[] = $row;
}
responseData(true, null, $data);
break;
case 'deletechannel':
$serviceid = getQueryData('serviceid');
$channelid = getQueryData('channelid');
$sql = "update tbl_service_channel set delete_flag=1, update_id=" . correctSQL($login_id) . ", update_date=now() where serviceid='" . $serviceid . "' and channelid='" . $channelid . "' and delete_flag=0";
executeSQL($db, $sql);
responseData(true, null);
break;
case 'addchannel':
$serviceid = getQueryData('serviceid');
$channelid = getQueryData('channelid');
$sql = "select count(*) from tbl_service_channel where delete_flag=0 and serviceid='" . $serviceid . "' and channelid='" . $channelid . "'";
$cnt = executeScalar($db, $sql);
if ($cnt == 0) {
$sql = "insert into tbl_service_channel (serviceid, channelid, create_id, create_date, update_id, update_date) \r\n\t\t\t\t\t\t\t\tvalues ('" . $serviceid . "', '" . $channelid . "', " . correctSQL($login_id) . ", now(), " . correctSQL($login_id) . ", now());";
executeSQL($db, $sql);
}
responseData(true, null);
break;
default:
responseData(false, 'invalid function');
break;
}
} catch (Exception $e) {
responseData(false, $e->getMessage());
}
$ret = SendSocketRequest($row["ip"], STREAMSERVERPORT, $req);
if ($ret != null && $ret["success"] == 'true')
responseData(true, null);
else
responseData(false, $ret["msg"]);
*/
} else {
responseData(false, 'invalid function');
}
break;
case 'tracker_status':
$channelid = getQueryData('channelid');
$channel_hashid = getQueryData('channel_hashid');
$server = getQueryData('server');
$user = getQueryData('user');
// get channel list
$channel_list = array();
if (isset($channel_hashid)) {
$channel_list[] = $channel_hashid;
} else {
if ($memcached != null) {
$data = $memcached->get('channel_list');
$channel_list = array_keys($data);
}
}
$data = array();
$channel_names = array();
// get peer list
foreach ($channel_list as $channel) {
$peer_list_id = 'peer_list_' . $channel;
