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) { pg_prepare( $dbcon, "alterar_senha_query", "UPDATE pbx_usuarios SET senha = md5($1), def_senha = 0, senha_ult_atualiza = 'now' WHERE id = $2"); $return = pg_execute($dbcon, "alterar_senha_query", array($senha, $idUser)); if (!$return) { return false; } pg_prepare($dbcon, "alterar_controle_acesso", "UPDATE pbx_controle_acesso SET acs_erro = 2 WHERE acs_login = $1 AND acs_erro = 1 "); $return = pg_execute($dbcon, "alterar_controle_acesso", array($login)); if (!$return) { return false; } return true; } ?>