/**
  * retrieve list of stored sessions
  * @param {array} data received data query parameters
  * @param {boolean} ring: if true exclude "-- Sin asignar --" session 1
  * @return {array} session list in easyui json expected format, or error string
  */
 function select($data, $ring = false)
 {
     $this->myLogger->enter();
     //needed to properly handle multisort requests from datagrid
     $sort = getOrderString(http_request("sort", "s", ""), http_request("order", "s", ""), "Nombre ASC, Comentario ASC");
     // search string
     $search = isset($_GET['where']) ? strval($_GET['where']) : '';
     // evaluate offset and row count for query
     $page = http_request("page", "i", 1);
     $rows = http_request("rows", "i", 50);
     $limit = "";
     if ($page != 0 && $rows != 0) {
         $offset = ($page - 1) * $rows;
         $limit = "" . $offset . "," . $rows;
     }
     // if hidden==0 hide console related sessions
     $ringstr = " AND 1";
     if ($ring) {
         $ringstr = " AND (Sesiones.ID > 1)";
     }
     $searchstr = " AND 1";
     if ($search !== "") {
         $searchstr = "AND (Nombre LIKE '%{$search}%')  AND ( ( Comentario LIKE '%{$search}%' ) OR ( Operador LIKE '%{$search}%') ) ";
     }
     $hiddenstr = " AND 1";
     if ($data['Hidden'] == 0) {
         $hiddenstr = "AND (Nombre != 'Console')";
     }
     $result = $this->__select("Sesiones.ID AS ID,Nombre,Comentario,Operador,Prueba,Jornada,Manga,Tanda,Login,Background,LiveStream,LiveStream2,LiveStream3", "Sesiones,Usuarios", "( Sesiones.Operador = Usuarios.ID ) {$hiddenstr} {$searchstr} {$ringstr}", $sort, $limit);
     $this->myLogger->leave();
     return $result;
 }

 public function retrieveExcelFile()
 {
     // phase 1 retrieve data from browser
     $this->myLogger->enter();
     $this->saveStatus("Loading file...");
     // extraemos los datos de registro
     $data = http_request("Data", "s", null);
     if (!$data) {
         return array("errorMsg" => "importExcel(dogs)::download(): No data to import has been received");
     }
     if (!preg_match('/data:([^;]*);base64,(.*)/', $data, $matches)) {
         return array("operation" => "upload", "errorMsg" => "importExcel(dogs)::download() Invalid received data format");
     }
     // mimetype for excel file is be stored at $matches[1]: and should be checked
     // $type=$matches[1]; // 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', or whatever. Not really used
     $this->myLogger->leave();
     $contents = base64_decode($matches[2]);
     // decodes received data
     // phase 2 store it into temporary file
     $tmpfile = tempnam_sfx(__DIR__ . "/../../../logs", "import", "xlsx");
     $file = fopen($tmpfile, "wb");
     fwrite($file, $contents);
     fclose($file);
     return array("operation" => "upload", "success" => true, "filename" => $tmpfile);
 }

 /**
  * Returns a json easyui datagrid style list of countries
  */
 function enumerate()
 {
     $data = array();
     // to be used on country search
     $q = strtolower(http_request("q", "s", ""));
     // parse country list
     foreach (Country::$countryList as $key => $val) {
         if ($q === "") {
             // no search key, just add
             array_push($data, array('ID' => $key, "Country" => $val));
             continue;
         }
         $k = strtolower($key);
         // search 2-letter country code
         if (strpos($k, $q) !== false) {
             array_push($data, array('ID' => $key, "Country" => $val));
             continue;
         }
         $v = strtolower($val);
         // search for country name
         if ($v === $q) {
             array_push($data, array('ID' => $key, "Country" => $val));
         }
     }
     $result = array('total' => count($data), 'rows' => $data);
     return $result;
 }

function translate($string)
{
    $url = "http://fanyi.youdao.com/openapi.do?keyfrom=bj22222&key=136547222&type=data&doctype=json&version=1.1&q=";
    $str = http_request($url . $string);
    echo $url . $string;
    // $str=mb_convert_encoding($str,'GB2312','UTF-8');
    $pattern = '#translation\\":\\[\\"(.*)\\"\\]#';
    return getPatternResult($pattern, $str);
}

function main($url, $user, $secret_key, $param)
{
    //加速乐开放API主函数
    ksort($param);
    $token = make_signiture($secret_key, $param);
    $header = make_header($user, $token);
    $postdata = http_build_query($param);
    $ret_cont = http_request($url, $postdata, $header);
    return $ret_cont;
}

 function select()
 {
     // evaluate offset and row count for query
     $q = http_request("q", "s", "");
     $c = http_request("Country", "s", "");
     $prov = $q !== "" ? "Provincia LIKE '%{$q}%'" : "1";
     $ctry = $c !== "" ? "AND Pais = '{$c}' " : "";
     $result = $this->__select("*", "Provincias", "({$prov} {$ctry}) OR ( Codigo=0 )", "Provincia ASC", "");
     return $result;
 }

 function create_ticket($resource_url)
 {
     $service_url = $this->service_url . '/';
     //### FIXME: the server should be callable without this
     $data = array('resource_url' => $resource_url);
     $response = http_request($service_url, 'POST', $data);
     if (is_null($response) || $response[0] != 201) {
         return NULL;
     }
     return $this->_parse_ticket($response[1]);
 }

function plugin_ajaxrss_output_url($url)
{
    if (!is_url($url, TRUE)) {
        return '';
    }
    $ret = http_request($url);
    if ($ret['rc'] != 200) {
        return '';
    }
    return $ret['data'];
}

function sendMediaMsg($fromUsername, $media_id, $type)
{
    $access_token = 'OqRc1B_r2iNAVtKLDT7FzUzN-fAN9q3chs1so3bAhUllLakfdGV9U--OpkV_B2cr3ZmJaPJjTI6kZvHvbfO79WenoxhMXl1gOJJ8UAovaQw';
    $url = "https://api.weixin.qq.com/cgi-bin/message/custom/send?access_token=" . $access_token;
    $postData = '{
	"touser":"' . $fromUsername . '",
	"msgtype":"' . $type . '",
	"' . $type . '":{"media_id":"' . $media_id . '"   }
}';
    $result = http_request($url, $postData);
    return $result;
}

 function get_userinfo($token)
 {
     //$created = substr_replace(get_date('Y-m-d\TH:i:sO', UTIME), ':', -2, 0);
     $created = str_replace('+0000', 'Z', gmdate('Y-m-d\\TH:i:sO', time()));
     $headers = array('X-JUGEMKEY-API-CREATED' => $created, 'X-JUGEMKEY-API-KEY' => $this->api_key, 'X-JUGEMKEY-API-TOKEN' => $token, 'X-JUGEMKEY-API-SIG' => hash_hmac('sha1', $this->api_key . $created . $token, $this->sec_key));
     $data = http_request(self::JUGEMKEY_URL_USER, 'GET', $headers);
     $this->response['rc'] = $data['rc'];
     if ($data['rc'] != 200 && $data['rc'] != 401) {
         return $this->response;
     }
     $this->responce_xml_parser($data['data']);
     return $this->response;
 }

 /**
  * token换取用户的openid
  * 需要从威信回调本action : https://open.weixin.qq.com/connect/oauth2/authorize?appid=wxea75c703e3c51ec3&redirect_uri=http%3A%2F%2F119.29.12.215%2FMobile%2FPublic%2Fbangding&response_type=code&scope=snsapi_base#wechat_redirect
  * redirect_uri 必须urlencode 处理。
  */
 private function getOpenid($jumpUrl = '')
 {
     //https://api.weixin.qq.com/sns/oauth2/access_token?appid=APPID&secret=SECRET&code=CODE&grant_type=authorization_code
     $url = "https://api.weixin.qq.com/sns/oauth2/access_token";
     $getData['appid'] = C('AppID');
     $getData['secret'] = C('AppSecret');
     $code = I("get.code");
     if (!empty($code)) {
         $getData['code'] = $code;
     } else {
         $getData['code'] = $this->getToken($jumpUrl);
     }
     $getData['grant_type'] = "authorization_code";
     $data = http_request($getData, $url, false);
     $retArray = json_decode($data, true);
     $openid = $retArray['openid'];
     return $openid;
 }

 function auth($cert)
 {
     $api_sig = md5($this->sec_key . 'api_key' . $this->api_key . 'cert' . $cert);
     $url = HATENA_URL_XML . '?api_key=' . $this->api_key . '&cert=' . $cert . '&api_sig=' . $api_sig;
     $data = http_request($url);
     if ($data['rc'] != 200) {
         return array('has_error' => 'true', 'message' => $data['rc']);
     }
     $xml_parser = xml_parser_create();
     xml_parse_into_struct($xml_parser, $data['data'], $val, $index);
     xml_parser_free($xml_parser);
     foreach ($val as $x) {
         if ($x['type'] != 'complete') {
             continue;
         }
         $this->response[strtolower($x['tag'])] = $x['value'];
     }
     return $this->response;
 }

 /**
  * 認証
  * @param string $cert
  * @return boolean
  */
 function auth($cert)
 {
     $query = array('api_key' => $this->api_key, 'api_sig' => $this->sig, 'cert' => $cert);
     $url = self::HATENA_URL_XML . http_build_query($query);
     $data = http_request($url);
     if ($data['rc'] != 200) {
         return array('has_error' => 'true', 'message' => $data['rc']);
     }
     $xml_parser = xml_parser_create();
     xml_parse_into_struct($xml_parser, $data['data'], $val, $index);
     xml_parser_free($xml_parser);
     foreach ($val as $x) {
         if ($x['type'] !== 'complete') {
             continue;
         }
         $this->response[strtolower($x['tag'])] = $x['value'];
     }
     return $this->response;
 }

function plugin_brokenlink_action()
{
    global $vars, $_brokenlink_msg;
    $retval = array('msg' => $_brokenlink_msg['msg_title'], 'body' => '');
    if (empty($vars['page'])) {
        $retval['body'] = $_brokenlink_msg['msg_param_error'];
        return $retval;
    }
    // ユーザ認証されていない
    $id = Auth::check_auth();
    if (empty($id)) {
        $retval['body'] = $_brokenlink_msg['msg_not_access'];
        return $retval;
    }
    if (!exist_plugin('xbel')) {
        $retval['body'] = $_brokenlink_msg['msg_not_found_xbel'];
        return $retval;
    }
    $links = xbel::get_link_list($vars['page']);
    $data = '';
    foreach ($links as $href => $aname) {
        $rc = http_request($href, 'HEAD');
        switch ($rc['rc']) {
            case 200:
                // Ok
            // Ok
            case 301:
                // Moved Permanently
            // Moved Permanently
            case 401:
                // Unauthorized
                continue;
            default:
                $data .= '-[[' . $aname . '>' . $href . ']] (' . $rc['rc'] . ")\n";
        }
    }
    if ($data == '') {
        $data = $_brokenlink_msg['msg_all_ok'];
    }
    $retval['body'] = RendererFactorty::factory($data);
    return $retval;
}

 public function postLogin($args)
 {
     $username = Input::get('username');
     $password = Input::get('password');
     $this->validate(Input::all(), ['username' => 'required']);
     try {
         $user = new User();
         $user = $user->find(['username', '=', $username]);
         // dd($user);
         if (count($user) === 1) {
             if (Hash::check($password, $user->password)) {
                 Session::put(Config::get('session.name'), $user);
                 return is_ajax() ? http_request() : Redirect::to('/');
             }
         }
     } catch (\Exception $e) {
         throw $e;
     }
     return Redirect::back();
 }

 function auth($vars)
 {
     if (!isset($vars['sig'])) {
         return array('has_error' => 'true', 'message' => 'Signature is not found.');
     }
     if (!isset($vars['token'])) {
         return array('has_error' => 'true', 'message' => 'Token is not found.');
     }
     if (isset($vars['userdata'])) {
         $this->response['userdata'] = Utility::decode($vars['userdata']);
     }
     $query = array();
     static $keys = array('app_key', 'userhash', 'token', 't', 'v', 'userdata');
     foreach ($keys as $key) {
         if (!isset($vars[$key])) {
             continue;
         }
         $query[$key] = $vars[$key];
     }
     $api_sig = $this->make_hash($query);
     if ($api_sig !== $vars['sig']) {
         return array('has_error' => 'true', 'message' => 'Comparison error of signature.');
     }
     // ログオンしてから 10分経過している場合には、タイムアウトとする
     $time_out = UTIME - self::LIVEDOOR_TIMEOUT;
     if ($vars['t'] < $time_out) {
         return array('has_error' => 'true', 'message' => 'The time-out was done.');
     }
     if (LIVEDOOR_PERMS !== 'id') {
         return array('has_error' => 'false', 'message' => '');
     }
     $post = array('app_key' => $this->app_key, 'format' => 'xml', 'token' => $vars['token'], 't' => UTIME, 'v' => self::LIVEDOOR_VERSION);
     $post['sig'] = $this->make_hash($post);
     $data = http_request(self::LIVEDOOR_URL_GETID, 'POST', '', $post);
     if ($data['rc'] != 200) {
         return array('has_error' => 'true', 'message' => $data['rc']);
     }
     $this->responce_xml_parser($data['data']);
     $has_error = $this->response['error'] == 0 ? 'false' : 'true';
     return array('has_error' => $has_error, 'message' => $this->response['message']);
 }

 /**
  * Send a HTTP request to a URI using HTTP extension.
  *
  * Does not support non-blocking.
  *
  * @param string    $url  The URL to handle.
  * @param str|array $args Optional. Override the defaults.
  *
  * @return array 'headers', 'body', 'cookies' and 'response' keys.
  */
 protected function _doExecute($url, $args)
 {
     switch ($args[org_tubepress_impl_http_HttpClientChain::ARGS_METHOD]) {
         case org_tubepress_api_http_HttpClient::HTTP_METHOD_POST:
             $args[org_tubepress_impl_http_HttpClientChain::ARGS_METHOD] = HTTP_METH_POST;
             break;
         case org_tubepress_api_http_HttpClient::HTTP_METHOD_PUT:
             $args[org_tubepress_impl_http_HttpClientChain::ARGS_METHOD] = HTTP_METH_PUT;
             break;
         case org_tubepress_api_http_HttpClient::HTTP_METHOD_GET:
         default:
             $args[org_tubepress_impl_http_HttpClientChain::ARGS_METHOD] = HTTP_METH_GET;
     }
     $urlAsArray = parse_url($url);
     if ('http' != $urlAsArray['scheme'] && 'https' != $urlAsArray['scheme']) {
         $url = preg_replace('|^' . preg_quote($urlAsArray['scheme'], '|') . '|', 'http', $url);
     }
     $sslVerify = isset($args[org_tubepress_impl_http_HttpClientChain::ARGS_SSL_VERIFY]) && $args[org_tubepress_impl_http_HttpClientChain::ARGS_SSL_VERIFY];
     $args[org_tubepress_impl_http_HttpClientChain::ARGS_TIMEOUT] = (int) ceil($args[org_tubepress_impl_http_HttpClientChain::ARGS_TIMEOUT]);
     $options = array('timeout' => $args[org_tubepress_impl_http_HttpClientChain::ARGS_TIMEOUT], 'connecttimeout' => $args[org_tubepress_impl_http_HttpClientChain::ARGS_TIMEOUT], 'redirect' => 5, 'useragent' => $args[org_tubepress_impl_http_HttpClientChain::ARGS_USER_AGENT], 'headers' => $args[org_tubepress_impl_http_HttpClientChain::ARGS_HEADERS], 'ssl' => array('verifypeer' => $sslVerify, 'verifyhost' => $sslVerify));
     $strResponse = @http_request($args[org_tubepress_impl_http_HttpClientChain::ARGS_METHOD], $url, $args[org_tubepress_impl_http_HttpClientChain::ARGS_BODY], $options, $info);
     // Error may still be set, Response may return headers or partial document, and error
     // contains a reason the request was aborted, eg, timeout expired or max-redirects reached.
     if (false === $strResponse || !empty($info['error'])) {
         throw new Exception($info['response_code'] . ': ' . $info['error']);
     }
     $headersBody = self::_breakRawStringResponseIntoHeaderAndBody($strResponse);
     $theHeaders = $headersBody[org_tubepress_impl_http_HttpClientChain::ARGS_HEADERS];
     $theBody = $headersBody[org_tubepress_impl_http_HttpClientChain::ARGS_BODY];
     unset($headersBody);
     $theHeaders = self::_getProcessedHeaders($theHeaders);
     if (!empty($theBody) && isset($theHeaders['headers']['transfer-encoding']) && 'chunked' == $theHeaders['headers']['transfer-encoding']) {
         $theBody = @http_chunked_decode($theBody);
     }
     if (true === $args['decompress'] && true === org_tubepress_impl_http_clientimpl_Encoding::shouldDecode($theHeaders['headers'])) {
         $theBody = http_inflate($theBody);
     }
     return array('headers' => $theHeaders['headers'], 'body' => $theBody, 'response' => $theHeaders['response'], 'cookies' => $theHeaders['cookies']);
 }

 function get_regkeys()
 {
     $rc = array();
     $regkeys = CACHE_DIR . 'regkeys.txt';
     $now = time();
     if (file_exists($regkeys)) {
         $time_regkeys = filemtime($regkeys) + TYPEKEY_CACHE_TIME;
     } else {
         $time_regkeys = $now;
     }
     if ($now < $time_regkeys) {
         $idx = 0;
         $data = file($regkeys);
     } else {
         $data = http_request(TYPEKEY_REGKEYS);
         // if ($data['rc'] != 200) return $rc;
         if ($data['timeout'] && file_exists($regkeys)) {
             // タイムアウト時でキャッシュがあれば、再利用する。
             $idx = 0;
             $data = file($regkeys);
         } else {
             $idx = 'data';
             $fp = fopen($regkeys, 'w');
             @flock($fp, LOCK_EX);
             rewind($fp);
             fputs($fp, $data[$idx]);
             @flock($fp, LOCK_UN);
             fclose($fp);
         }
     }
     foreach (explode(' ', $data[$idx]) as $x) {
         list($key, $val) = explode('=', $x);
         $rc[$key] = trim($val);
     }
     return $rc;
 }

 function shareJuez()
 {
     $juez1 = http_request("Juez1", "i", 1);
     $juez2 = http_request("Juez2", "i", 1);
     $sql = "UPDATE Mangas SET Juez1={$juez1}, Juez2={$juez2} WHERE ( Jornada={$this->jornada} )";
     $res = $this->query($sql);
     if (!$res) {
         return $this->error($this->conn->error);
     }
     $this->myLogger->leave();
     return "";
 }

 /**
  * search all jornadas related to provided prueba that matches provided criteria
  * @param {integer} $allowClosed 1:allow listing closed jornadas; 0:don't
  * @param {integer} $hideUnassigned 1:exclude, 0:include '-- Sin asignar --' journeys
  * @return {array} requested data
  */
 function searchByPrueba($allowClosed = 0, $hideUnassigned = 0)
 {
     $this->myLogger->enter();
     // evaluate search terms
     $q = http_request("q", "s", "");
     $cerrada = $allowClosed == 0 ? " AND ( Cerrada=0 )" : "";
     $unassigned = $hideUnassigned == 1 ? " AND ( Nombre <> '-- Sin asignar --' )" : "";
     $where = "( Prueba = {$this->prueba} ) {$cerrada} {$unassigned}";
     if ($q !== "") {
         $where = "( Prueba = {$this->prueba} ) {$cerrada} {$unassigned} AND ( (Nombre LIKE '%{$q}%') OR (Numero LIKE '%{$q}%') ) ";
     }
     // retrieve result from parent __select() call
     $result = $this->__select("*", "Jornadas", $where, "Numero ASC", "");
     // return composed array
     $this->myLogger->leave();
     return $result;
 }