$President = new President(); $Follower = new Follower(); $Party = new Party(); $Princess = new Princess(); // facebook_idの取得 $facebook_id = $facebook->getUser(); // President情報の取得 $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");
require_once dirname(__FILE__) . '/../facebook.php'; require_once dirname(__FILE__) . '/../model/Follower.php'; require_once dirname(__FILE__) . '/../model/Party.php'; require_once dirname(__FILE__) . '/../calc_used_money.php'; // Follower,Party Model用意 $Follower = new Follower(); $Party = new Party(); // 全Follower情報取得を試みる $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)); $followers_data = array(); // 全Followerの情報がMySQLにあるか確認 なければINSERT foreach ($followers as $follower) { $uid = $follower['uid']; $result = $Follower->findBy(array('facebook_id' => $uid)); if ($result->num_rows == 0) { // INSERTするデータを用意 $data = array('facebook_id' => $uid, 'name' => $follower['name'], 'power' => Job::getPower($uid), 'money' => Job::getMoney($uid), 'pic' => $follower['pic'], 'sex' => $follower['sex'] == 'male' ? 0 : 1, 'job_name' => Job::getMood($uid) . Job::getPosition($uid) . Job::getJob($uid)); $Follower->insert($data); array_push($followers_data, $data); } else { $follower_info = $result->fetch_assoc(); array_push($followers_data, $follower_info); } } $party = array('', '', ''); $result = $Party->findBy(array('president_id' => $facebook->getUser())); $index = 0; while ($p = $result->fetch_assoc()) { $party[$index++] = $p; }