function getDeviceTokenBadge($username, $update_badge_type = '') { $strQuery = "SELECT t.device_token,t.token,t.`message_badge`,t.`appointment_badge`,t.`labreports_badge`,t.`prescription_badge`\n FROM `users` AS mu\n INNER JOIN `api_tokens` AS t ON mu.id = t.id\n WHERE `username` = ?"; $result = sqlQuery($strQuery, array($username)); if ($result) { $badge = $result['message_badge'] + $result['appointment_badge'] + $result['labreports_badge'] + $result['prescription_badge'] + 1; updateBadge($result['token'], $update_badge_type); return array('device_token' => $result['device_token'], 'badge' => $badge); } else { return false; } }
function getDeviceTokenBadge($username, $update_badge_type = '') { global $db; $strQuery = "SELECT t.device_token,t.token,t.`message_badge`,t.`appointment_badge`,t.`labreports_badge`,t.`prescription_badge`\n FROM `users` AS mu\n INNER JOIN `api_tokens` AS t ON mu.id = t.id\n WHERE `username` ='" . $username . "'"; $result = $db->get_row($strQuery); if ($result) { $badge = $result->message_badge + $result->appointment_badge + $result->labreports_badge + $result->prescription_badge + 1; updateBadge($result->token, $update_badge_type); return array('device_token' => $result->device_token, 'badge' => $badge); } else { return false; } }