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