/** * 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;