Example #1
0
 public static function count_member_xu($uid = 0)
 {
     //查詢會員資料
     $user = dbconn::get_usruid($uid);
     //取得成功邀請的人數
     $count = dbconn::count_comkey($user['usr_makekey']);
     //取得會員APP啟用資料
     $sql2 = "SELECT * FROM `tk_bubu_deviceids` WHERE `dev_uid` = '" . $uid . "';";
     $deviceids = dbconn::db_GetAll($sql2);
     //計算會員實得栗子數
     $countn = $count + count($deviceids) * 50;
     return $countn;
 }
Example #2
0
 public static function query_all_tripname()
 {
     $sql = "SELECT * FROM `tk_tripname`";
     $m = 0;
     foreach ($result as $user) {
         #$result[$m]['user_info'] = dbconn::getUserById( $user['mem_uid'] );
         $result[$m]['sns_info'] = dbconn::getFBUserById($user['mem_uid']);
         $result[$m]['ticket_info'] = dbconn::make_ticket(0, $user['mem_uid'], 0);
         $m++;
     }
     $result = dbconn::db_GetAll($sql);
     return $result;
 }