/** * Update one User in the database * * @author Jonathan Sandoval <*****@*****.**> * @param User $User The User to update * @return boolean If was possible to update */ static function updateUser($User = null) { if ($User === null) { return false; } $tableUser = DatabaseManager::getNameTable('TABLE_USER'); $id = $User->getId(); $username = $User->getUsername(); $type = $User->getType(); $password = $User->getPassword(); $User->getIdChurch() == 0 ? $idChurch = 'null' : ($idChurch = $User->getIdChurch()); $offline = $User->getOffline(); $lastAct = $User->getLastActivityTime(); $language = $User->getLanguage(); $idPaperConfig = $User->getIdPaperConfig(); $ip = $User->getAddressIP(); $query = "UPDATE {$tableUser}\r\n SET username = '******', type = '{$type}', password = '******', \r\n idChurch = {$idChurch}, offline = {$offline}, language = '{$language}',\r\n lastActivityTime = '{$lastAct}', idPaperConfig = {$idPaperConfig}, \r\n addressIP = '{$ip}'\r\n WHERE {$tableUser}.id = {$id}"; return DatabaseManager::singleAffectedRow($query); }