示例#1
0
 /**
  * 获取用户表信息
  *
  * @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;
 }
示例#2
0
 /**
  * 获取用户表信息
  *
  * @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;
 }
示例#3
0
 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;
 }
示例#4
0
 /**
  * 获取用户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;
 }
示例#5
0
 /**
  * 获取用户道具信息
  *
  * @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;
 }
示例#6
0
 * 情報を`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) {
示例#7
0
 /**
  * 随机十个用户信息
  *
  * @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;
 }
示例#8
0
 * 通話終了後に情報を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();
示例#9
0
 /**
  * 获取一个邮件信息
  *
  * @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;
 }
示例#10
0
 function __construct($settings)
 {
     $this->settings = $settings;
     $database = new Database();
     $this->pdo = $database->getPdo();
 }
示例#11
0
 function __construct()
 {
     $database = new Database();
     $this->pdo = $database->getPdo();
 }
示例#12
0
            $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) {
示例#13
0
 /**
  * 获取表定义
  *
  * @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);
 }