$facebook = new Facebook($config); $loginParams = array('scope' => 'user_birthday'); $statusParam = array('ok_session' => 'Now Login', 'no_user' => 'No User', 'no_session' => 'No Session'); if ($facebook->getUser()) { $fql = 'SELECT uid,name,pic,sex FROM user WHERE uid IN(SELECT uid2 FROM friend where uid1 = me())'; $followers = $facebook->api(array('method' => 'fql.query', 'query' => $fql)); foreach ($followers as $follower) { $data = array(); $data['facebook_id'] = $follower['uid']; $data['name'] = $follower['name']; $data['pic'] = $follower['pic']; $data['power'] = rand(1, 100); $data['money'] = rand(1, 100); $data['job_name'] = Job::getJob(); $uid = $follower['uid']; $result = $Follower->findBy(array('facebook_id' => $uid)); if ($result->num_rows == 0) { $Follower->insert($data); var_dump($data); } echo "<hr />"; } } else { ?> <a href="<?php echo $facebook->getLoginUrl($loginParams); ?> ">ログイン</a><br /> <?php } ?>
$presidents = $President->findBy(array('facebook_id' => $facebook_id)); if ($presidents->num_rows == 0) { echo 'president取得の失敗なう'; die; } $president = $presidents->fetch_assoc(); // Presidentに紐付くParty情報の取得 $party = array(); $result = $Party->findBy(array('president_id' => $facebook_id)); while ($row = $result->fetch_assoc()) { array_push($party, $row); } // Presidentに紐付くPartyに紐付くFollowers情報の取得 $followers = array(); foreach ($party as $party_member) { $result = $Follower->findBy(array('facebook_id' => $party_member['follower_id'])); while ($row = $result->fetch_assoc()) { array_push($followers, $row); } } // Presidentに紐付くPrincess情報の取得 $result = $Princess->findBy(array('facebook_id' => $president['princess_id'])); if ($result->num_rows == 0) { header("HTTP/1.1 301 Moved Permanently"); header("Location: /princess/"); die; } $princess = $result->fetch_assoc(); // followersのmoneyの合計 $total_money = 0; foreach ($followers as $follower) {
// Presidentデータを用意 $data = array('facebook_id' => $r[0]['uid'], 'name' => $r[0]['name'], 'pic' => $r[0]['pic_small'], 'updated_at' => time(), 'point' => 0, 'level' => 0, 'sex' => $r[0]['sex'] == 'male' ? 0 : 1); $President->insert($data); $me = $data; } else { $me = $result->fetch_assoc(); } $me['power'] = 0; $me['money'] = 0; // Party情報取得を試みる $party = array(); $partyResult = $Party->findBy(array('president_id' => $facebook->getUser())); // Partyが0以上 = 誰かしらデッキに入ってる場合 if ($partyResult->num_rows > 0) { while ($p = $partyResult->fetch_assoc()) { $follower = $Follower->findBy(array('facebook_id' => $p['follower_id'])); $f = $follower->fetch_assoc(); if (!is_null($f)) { array_push($party, $f); $me['power'] += $f['power']; $me['money'] += $f['money']; } } } // Partyが空=未選択の場合, /follower/index.phpにリダイレクト if (count($party) == 0) { header("HTTP/1.1 301 Moved Permanently"); header("Location: /follower/index.php"); } // Princess情報取得を試みる $princess = array();