getMessage(); $color = 'red'; } $smarty->assign("msg", $msg); $smarty->assign("color", $color); $smarty->display('alterarsenha.tpl'); function userExists($dbcon, $idUser) { $query = "SELECT count(*) FROM pbx_usuarios WHERE id = '$idUser';"; $return = pg_query($dbcon, $query); $result = pg_fetch_assoc($return); if (!$result['count']) { return false; } return true; } function changePassword($dbcon, $idUser, $login, $senha) { $query = "UPDATE pbx_usuarios SET senha = md5('$senha'), def_senha = 0, senha_ult_atualiza = 'now' WHERE id = '$idUser'; "; $query .= "UPDATE pbx_controle_acesso SET acs_erro = 2 WHERE acs_login = '$login' AND acs_erro = 1; "; $return = pg_query($dbcon, $query); if (!$return) { return false; } return true; } ?>