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