public static function query_allmemneweve() { $sql = "SELECT * FROM `tk_buburegusr`"; $result = dbconn::db_GetAll($sql); $m = 0; foreach ($result as $row) { $result[$m]['sns_info'] = dbconn::getFBUserById($row['usr_uid']); $result[$m]['definfo'] = dbconn::get_oneusr($row['usr_uid']); $sql2 = "SELECT * FROM `tk_bubu_deviceids` WHERE `dev_uid` = '" . $result[$m]['definfo']['id'] . "';"; $result[$m]['deviceids'] = dbconn::db_GetAll($sql2); $result[$m]['countn'] = dbconn::count_member_xu($row['usr_uid']); #$count = dbconn::count_comkey( $result[$m]['usr_makekey'] ); #$result[$m]['countn'] = $count + ( count( $result[$m]['deviceids'] ) * 50 ) ; $m++; } return $result; }
ini_set('display_errors', 'On'); require '../../inc/config.php'; require PATH_INC . '/class_user.php'; require '../dbconn.php'; if (!empty($_GET['offerme2_click'])) { $_SESSION['offerme2_click'] = $_GET['offerme2_click']; } $user_id = User::getId(); //使用者編號 $memberloginkey = false; $is_new_user = isset($_SESSION['is_new_user']) ? $_SESSION['is_new_user'] : 0; if (!empty($user_id)) { $memberloginkey = true; $memberloginkey = true; $userdata = dbconn::getUserById($user_id); $userfbdata = dbconn::getFBUserById($user_id); dbconn::insertMem($user_id, $is_new_user); $hi_ticket_str = dbconn::make_ticket(0, $user_id, $is_new_user); } else { //強制設定登入後導回頁面 $_SESSION['login:next:tag'] = 'event'; $_SESSION['login:next'] = "/event/BuBuTripTicket/m.register.php?ticket=1"; } ?> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="google-site-verification" content="" /> <meta name="description" content="親子自駕旅遊網BuBuTrip吉祥物誕生了!9/13(日)在台北市立動物園將隆重與大家相見~我們將帶來好玩的互動遊戲,有野餐墊、扇子、名信片、冰淇淋、爆米花多項好禮送給你!更棒的是,活動現場會送出Dyson戴森無線吸塵器(價值$27,900元)一台!另外,還會抽出兩部小朋友界最夯的捷安特滑步車(價值$3,280),心動了就千萬別錯過,等你喔~"> <meta name="keywords" content="BuBuTrip、親子自駕旅遊網、吉祥物、Dyson戴森無線吸塵器、捷安特滑步車、野餐墊、扇子、名信片、冰淇淋、爆米花、台北市立動物園" />
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; }