/** * 获取用户表信息 * * @access public * @param integer $uid 用户id * @return integer 结果 */ public static function getUserRank($user_id, $pdo = null) { if (is_null($pdo)) { $pdo = Database::getPdo(); } $stmt = $pdo->prepare("SELECT (SELECT count(*)+1 from user_info where k.n_max_checkpoint<n_max_checkpoint or (k.n_max_checkpoint=n_max_checkpoint and k.n_battle<n_battle ) or (k.n_max_checkpoint=n_max_checkpoint and k.n_battle=n_battle and k.t_create_time<t_create_time )) as rank from user_info k where n_id={$user_id}"); $stmt->execute(); $user_info = self::fetchToArray($stmt); return isset($user_info[0]) ? $user_info[0] : $user_info; }
/** * 获取用户表信息 * * @access public * @param string $user_account 用户id * @return integer 结果 */ public static function getUserInfo($id, $pdo = null) { if (is_null($pdo)) { $pdo = Database::getPdo(); } $stmt = $pdo->prepare("SELECT * FROM user where n_id = :id"); $stmt->bindValue(":id", $id); $stmt->execute(); $user_info = self::fetchToArray($stmt); return isset($user_info[0]) ? $user_info[0] : $user_info; }
public static function getUserInfo($uid, $pdo = null) { if (is_null($pdo)) { $pdo = Database::getPdo(); } $stmt = $pdo->prepare("SELECT n_coin,n_diamond,n_soul FROM user_info where n_id = :uid "); $stmt->bindValue(":uid", $uid); $stmt->execute(); $user_info = self::fetchToArray($stmt); return $user_info[0] ? $user_info[0] : $user_info; }
/** * 获取用户ID * * @access public * @param string $user_account 用户名 * @param string $user_pwd 用户密码 * @return integer 结果 */ public static function getUserID($user_account, $user_pwd, $pdo = null) { if (is_null($pdo)) { $pdo = Database::getPdo(); } $stmt = $pdo->prepare("SELECT n_id FROM regist_list where s_account = :user_account and s_password = :user_pwd"); $stmt->bindValue(":user_account", $user_account); $stmt->bindValue(":user_pwd", $user_pwd); $stmt->execute(); $user_info = self::fetchToArray($stmt); return isset($user_info[0]) ? $user_info[0]['n_id'] : $user_info; }
/** * 获取用户道具信息 * * @access public * @param string $user_name 查找的昵称 * @return integer 结果 */ public static function getItemInfo($user_id, $pdo = null) { if (is_null($pdo)) { $pdo = Database::getPdo(); } $stmt = $pdo->prepare("SELECT s_item_info FROM user_info where n_id=:user_id"); $stmt->bindValue(":user_id", $user_id); $stmt->execute(); $user_info = self::fetchToArray($stmt); $user_info = isset($user_info[0]) ? $user_info[0] : $user_info; $arr = unserialize($user_info['s_item_info']); return $arr; }
* 情報を`queue_data`テーブルに格納 * * @author rutoru * @package Twilio-MiniCC * @GitHub https://github.com/rutoru/Twilio-MiniCC */ // DB接続クラス require_once 'Database.php'; // 設定クラス require_once 'Conf.php'; // Twilio Helperライブラリ(index.phpと同じ場所にServicesフォルダが存在する前提) require_once 'Services/Twilio.php'; try { // INSERT $db = new Database(); $stmt = $db->getPdo()->prepare('INSERT INTO `queue_data`(`CallSid`, `From`, `To`, `CallStatus`, `ApiVersion`, `Direction`, `ForwardedFrom`, `CallerName`, `QueueSid`, `QueueTime`, `DequeingCallSid`, `Time`)' . ' VALUES (:CallSid,:From,:To,:CallStatus,:ApiVersion,:Direction,:ForwardedFrom,:CallerName,' . ':QueueSid,:QueueTime,:DequeingCallSid,NOW())'); // Standard Parameters $stmt->bindValue(':CallSid', filter_input(INPUT_POST, 'CallSid')); $stmt->bindValue(':From', filter_input(INPUT_POST, 'From')); $stmt->bindValue(':To', filter_input(INPUT_POST, 'To')); $stmt->bindValue(':CallStatus', filter_input(INPUT_POST, 'CallStatus')); $stmt->bindValue(':ApiVersion', filter_input(INPUT_POST, 'ApiVersion')); $stmt->bindValue(':Direction', filter_input(INPUT_POST, 'Direction')); $stmt->bindValue(':ForwardedFrom', filter_input(INPUT_POST, 'ForwardedFrom')); $stmt->bindValue(':CallerName', filter_input(INPUT_POST, 'CallerName')); // Queue Parameters $stmt->bindValue(':QueueSid', filter_input(INPUT_POST, 'QueueSid')); $stmt->bindValue(':QueueTime', filter_input(INPUT_POST, 'QueueTime')); $stmt->bindValue(':DequeingCallSid', filter_input(INPUT_POST, 'DequeingCallSid')); $stmt->execute(); } catch (Exception $e) {
/** * 随机十个用户信息 * * @access public * @param integer $condition 查找的ID字符串 * @return array 结果 */ public static function getTenInfo($user_id, $pdo = null) { if (is_null($pdo)) { $pdo = Database::getPdo(); } $stmt = $pdo->prepare("SELECT n_id FROM user_info where n_id not in (" . $user_id . ")"); $stmt->execute(); $friend_Info = self::fetchToArray($stmt); shuffle($friend_Info); $friend_Info = array_slice($friend_Info, 0, 10); foreach ($friend_Info as $key => $value) { $condition .= $value['n_id'] . ','; } $condition = substr($condition, 0, -1); $stmt = $pdo->prepare("SELECT n_id,s_name,n_head,n_sex,n_battle,n_max_checkpoint FROM user_info WHERE n_id in (" . $condition . ")"); $stmt->execute(); $friend_Info = self::fetchToArray($stmt); return $friend_Info; }
* 通話終了後に情報をstatuscallback_dataテーブルに格納 * * @author rutoru * @package Twilio-MiniCC * @GitHub https://github.com/rutoru/Twilio-MiniCC */ // DB接続クラス require_once 'Database.php'; // 設定クラス require_once 'Conf.php'; // Twilio Helperライブラリ(index.phpと同じ場所にServicesフォルダが存在する前提) require_once 'Services/Twilio.php'; try { // INSERT $db = new Database(); $stmt = $db->getPdo()->prepare('INSERT INTO `statuscallback_data`(`CallSid`, `From`, `To`, `CallStatus`, `ApiVersion`, `Direction`, `ForwardedFrom`, `CallerName`, `CallDuration`, `RecordingUrl`, `RecordingSid`, `RecordingDuration`, `Time`)' . ' VALUES (:CallSid,:From,:To,:CallStatus,:ApiVersion,:Direction,:ForwardedFrom,:CallerName,' . ':CallDuration,:RecordingUrl,:RecordingSid,:RecordingDuration,NOW())'); // Standard Parameters $stmt->bindValue(':CallSid', filter_input(INPUT_POST, 'CallSid')); $stmt->bindValue(':From', filter_input(INPUT_POST, 'From')); $stmt->bindValue(':To', filter_input(INPUT_POST, 'To')); $stmt->bindValue(':CallStatus', filter_input(INPUT_POST, 'CallStatus')); $stmt->bindValue(':ApiVersion', filter_input(INPUT_POST, 'ApiVersion')); $stmt->bindValue(':Direction', filter_input(INPUT_POST, 'Direction')); $stmt->bindValue(':ForwardedFrom', filter_input(INPUT_POST, 'ForwardedFrom')); $stmt->bindValue(':CallerName', filter_input(INPUT_POST, 'CallerName')); // StatusCallback Parameters $stmt->bindValue(':CallDuration', filter_input(INPUT_POST, 'CallDuration')); $stmt->bindValue(':RecordingUrl', filter_input(INPUT_POST, 'RecordingUrl')); $stmt->bindValue(':RecordingSid', filter_input(INPUT_POST, 'RecordingSid')); $stmt->bindValue(':RecordingDuration', filter_input(INPUT_POST, 'RecordingDuration')); $stmt->execute();
/** * 获取一个邮件信息 * * @access public * @param string $user_id 用户ID * @return integer 结果 */ public static function getOneMail($mail_id, $pdo = null) { if (is_null($pdo)) { $pdo = Database::getPdo(); } $stmt = $pdo->prepare("SELECT n_receive_id,n_item_type,n_item_num FROM mail_system where n_id=:mail_id and n_type=1"); $stmt->bindValue(":mail_id", $mail_id); $stmt->execute(); $mail_info = self::fetchToArray($stmt); return $mail_info[0] ? $mail_info[0] : $mail_info; }
function __construct($settings) { $this->settings = $settings; $database = new Database(); $this->pdo = $database->getPdo(); }
function __construct() { $database = new Database(); $this->pdo = $database->getPdo(); }
$response->redirect('information.xml'); break; default: // 1,2以外の場合は再入力 $gather = $response->gather(array('numDigits' => 1, 'timeout' => '10', 'method' => 'POST')); $gather->say('再度入力をお願いします。' . 'お問い合わせは1を、' . '最新の製品情報をお聞きになりたい場合は2を押してください。', array('language' => Conf::LANG)); // タイムアウトとなった場合はオペレータに接続 $response->say('入力が確認できませんでした。オペレータにおつなぎします。しばらくお待ちください。', array('language' => Conf::LANG)); $response->enqueue(Conf::QUEUE, array('waitUrl' => 'wait.php', 'action' => $enqueue_action_url, 'method' => Conf::METHOD)); break; } } else { try { // 発信電話番号を取得し、DB照会 $db = new Database(); $stmt = $db->getPdo()->prepare('SELECT telnum FROM operators WHERE telnum = :ani'); $stmt->bindValue(':ani', filter_input(INPUT_POST, 'From')); $stmt->execute(); // 発信者がオペレータだった場合 if ($stmt->rowCount()) { // operator_queue.phpへリダイレクト $response->redirect('operator_queue.php'); } else { // IVRの提供。電話入力(DTMF入力)値を収集 $gather = $response->gather(array('numDigits' => 1, 'timeout' => '10', 'method' => Conf::METHOD)); $gather->say('こちらは、サンプルコールセンタです。' . 'お問い合わせは1を、最新の製品情報をお聞きになりたい場合は2を押してください。', array('language' => Conf::LANG)); // タイムアウトとなった場合はオペレータに接続 $response->say('入力が確認できませんでした。オペレータにおつなぎします。しばらくお待ちください。', array('language' => Conf::LANG)); $response->enqueue(Conf::QUEUE, array('waitUrl' => 'wait.php', 'action' => $enqueue_action_url, 'method' => Conf::METHOD)); } } catch (Exception $e) {
/** * 获取表定义 * * @access public * @return array 表注释 */ public static function getTableDefine() { $class_name = get_called_class(); $class = new $class_name(); $table_name = '`' . $class::getTableName() . '`'; if (!isset($pdo)) { $pdo = Database::getPdo(); } $stmt = $pdo->prepare("SHOW FULL COLUMNS FROM " . $table_name); if ($stmt === false) { return null; } return self::fetchToArray($stmt); }