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; }
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; }