}
function getdeviceTokenAndSendMessage($udid, $message)
{
echo "UDID = " . $udid;
$query = "select apns_devices.pid, apns_devices.devicetoken from apns_devices WHERE apns_devices.deviceuid = '" . $udid . "'";
$devices = ConnectionFactory::SelectRowsAsClasses($query, array(), __CLASS__);
print_r($device);
die;
//$inactiveUsers = User::lastTwoDayInactive();
foreach ($devices as $device) {
echo "DEVICE TOKEN = " . $device->devicetoken;
sendMessageToDevice($device->devicetoken, $message);
}
}
$query = "select apns_devices.pid, apns_devices.devicetoken from apns_devices ";
$devices = ConnectionFactory::getAssociativeArray($query);
//$inactiveUsers = User::lastTwoDayInactive();
foreach ($devices as $device) {
sendMessage($device['devicetoken']);
}
// $conditions = array();
//
// // $conditions['deviceuid'] = $user['udid'];
// $deviceToken = ConnectionFactory::getAssociativeArray('devicetoken', 'apns_devices', $conditions);
// echo $deviceToken;
// if($userPid>0){
// sendMessage(sendMessage);
//// $apns->newMessage($userPid);
//// $apns->addMessageAlert("You didn'nt login from last two days");
//// $apns->queueMessage();
// }
public static function resetTimer($user_id)
{
$query = "update user_timers set stamina_timer = NOW(), health_timer = NOW(), energy_timer = NOW() Where user_id = " . $user_id;
if (ConnectionFactory::getAssociativeArray($query)) {
return true;
}
}
public function updateIncomeOfflineTimer()
{
$query = "Select users.cash + ((users.income - users.upkeep ) * TIMESTAMPDIFF(HOUR, user_timers.health_timer, NOW())) as CASH\n from users, user_timers\n WHERE users.id = user_timers.user_id AND TIMESTAMPDIFF(HOUR, user_timers.income_timer, NOW()) > 1";
//echo $query;
if (ConnectionFactory::getAssociativeArray($query)) {
return true;
}
}
