/* * 查询对应课程成绩 */ /* * 查询对应课程成绩 */ case 'getGrade': if (!array_key_exists('user_id', $_GET) || !array_key_exists('lesson_id', $_GET)) { $result->outputErrResult('001'); } $user_id = $_GET['user_id']; $lesson_id = $_GET['lesson_id']; $db = new WebTrainDBConnection(); $studyRS = $db->query("SELECT * FROM lesson_study WHERE lesson_id='{$lesson_id}' AND user_id='{$user_id}' AND pay_flag=1 LIMIT 1"); if (!$studyRS) { $db->close(); $result->outputErrResult('004'); } $studyObj = $studyRS->fetch_object(); if ($studyObj == NULL) { $db->close(); $result->outputErrResult('501'); } $retObj = new stdClass(); $retObj->study_id = $studyObj->study_id; $retObj->theory_score = $studyObj->theory_score; $retObj->practical_score = $studyObj->practical_score; $retObj->communicate_ability = $studyObj->communicate_ability; $retObj->study_ability = $studyObj->study_ability; $retObj->study_attitube = $studyObj->study_attitube; $retObj->innovation = $studyObj->innovation;
public function parse($token) { // 使用-将token拆成两段 // [0]:info // [1]:userid $token_array = explode('-', $token); // 规则规定,token_array必将是长度为2的数组 if (2 != count($token_array)) { $this->error = 05; return false; } // 使用.拆分第一段 // [0]:类型 // [1]:校验字符串 // [2]:timeout // [3]:timegen // [4]:ticket $token_info = explode('.', $token_array[0]); // 规则规定,token_info必将是长度5的数组 if (5 != count($token_info)) { $this->error = 05; return false; } // 进行token的md5校验 $verifystring = $token_array[1] . $token_info[4] . TOKEN_GEN_SEED; if (md5($verifystring) != $token_info[1]) { $this->error = 05; return false; } // 查询token是否匹配 $db = new WebTrainDBConnection(); if ($result = $db->query('SELECT token,email_token FROM pineapple_user WHERE user_id=' . $token_array[1])) { if ($result->num_rows == 0) { $result->close(); $db->close(); $this->error = 05; return false; } $obj = $result->fetch_object(); if ($token_info[0] == NORMAL_TOKEN) { $res_token = $obj->token; } elseif ($token_info[0] == EMAIL_TOKEN) { $res_token = $obj->email_token; } else { $result->close(); $db->close(); $this->error = 05; return false; } if ($token != $res_token) { $result->close(); $db->close(); $this->error = 05; return false; } $result->close(); } else { $db->close(); $this->error = 04; return false; } $db->close(); // 检查是否超时 $outoftime = $token_info[3] + $token_info[2]; $currenttime = @gmmktime(); if ($currenttime > $outoftime) { $this->error = 05; return false; } // 完整过滤,填充信息 $this->m_type = $token_info[0]; $this->m_timeout = $token_info[2]; $this->m_timegen = $token_info[3]; $this->m_ticket = $token_info[4]; $this->m_userid = $token_array[1]; $this->error = 0; return true; }