function __calc_used_money($facebook) { $President = new President(); $condition = array('facebook_id' => $facebook->getUser()); $me = $President->findBy($condition)->fetch_assoc(); if ($me['used_money'] > 0) { $now = time(); $updated_at = $me['updated_at']; // 回復量を計算 $recover = ($now - $updated_at) * RECOVER_RATE; $used_money = $me['used_money'] - $recover; if ($used_money < 0) { $used_money = 0; } $data = array('used_money' => $used_money, 'updated_at' => $now); $President->update($data, $condition); } }
require_once dirname(__FILE__) . '/../facebook.php'; require_once dirname(__FILE__) . "/../model/President.php"; require_once dirname(__FILE__) . "/../model/Follower.php"; require_once dirname(__FILE__) . "/../model/Party.php"; require_once dirname(__FILE__) . "/../model/Princess.php"; require_once dirname(__FILE__) . '/../calc_used_money.php'; // 下準備なう $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']));
* 未ログインの場合はlogin.phpにリダイレクトされる * また、Partyが未選択の場合は自動的にFollower選択画面に遷移 */ require_once dirname(__FILE__) . '/../facebook.php'; require_once dirname(__FILE__) . '/../model/President.php'; require_once dirname(__FILE__) . '/../model/Princess.php'; require_once dirname(__FILE__) . '/../model/Party.php'; require_once dirname(__FILE__) . '/../model/Follower.php'; require_once dirname(__FILE__) . '/../calc_used_money.php'; // President,Princess,Party モデルを用意 $President = new President(); $Princess = new Princess(); $Party = new Party(); $Follower = new Follower(); // PresidentがDBに存在するか確認 $result = $President->findBy(array('facebook_id' => $facebook->getUser())); // ログイン中のPresiden情報 $me = array(); // MySQLにデータが存在しない場合はINSERT if ($result->num_rows == 0) { $fql = 'SELECT uid,name,pic_small,sex FROM user where uid = me()'; $r = $facebook->api(array('method' => 'fql.query', 'query' => $fql)); // 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;
<?php require dirname(__FILE__) . '/../../model/President.php'; $Model = new President(); if ($resultRef = $Model->findAll()) { $result = $resultRef->fetch_assoc(); var_dump($result); } else { echo "No Result"; } if ($resultRef = $Model->findBy(array('id' => '2'))) { $result = $resultRef->fetch_all(); var_dump($result); } else { echo "No Result"; }