Encripting Password after transfering acc.

[limpamesa]

When i have transfered all 99b accounts to 99.6x I had to encript all accounts so I have created this to make automatic and I thought it was good so I decided to share with you. I hope it helps.

Instructions: Before importing all accs to your MEMB_INFO table you can creat a new field called memb_passw. Import data and store passoword from old database MEMB_INFO.memb__pwd to the new field memb_passw. Use this script to creat repassowords procedure and run it.
It will store encripted passords from memb_passw to MEMB_INFO.memb__pwd.

Sry my bad english. Im brazilian.
=========================

USE [Muonline]
GO
/****** Object: StoredProcedure [dbo].[repasswords] Script Date: 08/15/2006 02:10:11 ******/
/****** By Limpamesa ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[repasswords]
AS

DECLARE @ACC INT,@SENHA VARCHAR(10),@CONTA VARCHAR(10),@cnt int

set @cnt = 0
DECLARE LISTA CURSOR LOCAL FOR
SELECT memb_guid FROM dbo.MEMB_INFO

OPEN LISTA
FETCH NEXT FROM LISTA INTO @ACC
WHILE @@FETCH_STATUS = 0
BEGIN

SET @CONTA=(SELECT memb___id FROM MEMB_INFO WHERE memb_guid=@ACC)
SET @SENHA=(SELECT memb_passw FROM MEMB_INFO WHERE memb_guid=@ACC)

BEGIN
BEGIN TRANSACTION
SET NOCOUNT ON

EXECUTE Encripta @SENHA, @CONTA
set @cnt = @cnt + 1
print convert(varchar,@cnt) + ') ' + @CONTA+ ' SENHA = '+@SENHA

IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SET NOCOUNT OFF
END

FETCH NEXT FROM LISTA INTO @ACC
END
CLOSE LISTA
DEALLOCATE LISTA

 

[yanivman]

lol nice
ty

 

[hoangkhuong]

can you post database for server you run plz. I try to do for text you post don't not run for server me.
Thank
Sory my bad English. I'm Vietnames

 

[CALYSTO]

Good work but... don

 

[1Word]

nvm..

 

[limpamesa]

can you post database for server you run plz. I try to do for text you post don't not run for server me.
Thank
Sory my bad English. I'm Vietnames

Im using Muonline database where is memb_info table but if your database is other so just change first line or erase it: USE [Muonline]

Actually you need create in your database, memb_info a new field called memb_passw varchar(10) where is used to register normal passwords not encripted and when you run repassoword procedure it will make encriptation and store in right original field memb__pwd varbinary(16)

 

[popo]

U are really amazing on SQL really..

RULES thanks bro this really helpful

 

[didi3d]

pow limpamesa ele naum ta encryptando as senhas conforme seu Guide alguma ideia de onde pode ser o erro ?

 

[Camus_anth]

thanks a lot for this code

 

[limpamesa]

pow limpamesa ele naum ta encryptando as senhas conforme seu Guide alguma ideia de onde pode ser o erro ?

Make sure you have WZ_MD5_MOD.dll installed (if not, see other guide to install it)


After create this procedure, open a new window in query analyzer and drag and drop "repasswords" procedure and run it (in muonline or me_muonline deppending what database you put de memb_info table).

You just need run once for encript all passwords at on time.

Portugues:

Tenha certeza que instalou corretamente o WZ_MD5_MOD.dll senao procura como instalar.

Depois de criada a procedure (rodando este script), abra uma nova janela, arrasta a procedure rescem criada "repasswords" e execute-a.

So precisa executar uma unica vez que vai encriptografar toda a tabela memb info de uma s

 

[zimbred]

Hello.

I Have problem with this script. When I execute him, Query Analizer obtain this error:

"Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'Encripta'. The stored procedure will still be created."

How can I fix this?

Sory for my english .

 

[didi3d]

Make sure you have WZ_MD5_MOD.dll installed (if not, see other guide to install it)


After create this procedure, open a new window in query analyzer and drag and drop "repasswords" procedure and run it (in muonline or me_muonline deppending what database you put de memb_info table).

You just need run once for encript all passwords at on time.

Portugues:

Tenha certeza que instalou corretamente o WZ_MD5_MOD.dll senao procura como instalar.

Depois de criada a procedure (rodando este script), abra uma nova janela, arrasta a procedure rescem criada "repasswords" e execute-a.

So precisa executar uma unica vez que vai encriptografar toda a tabela memb info de uma s

 

[limpamesa]

pow tipo até a parte do MD5 vc tava certo eu naum tinha ele mas como assim executar seu script e depois executar a procedure dele? ele cria outro script q deve ser excutado ou é só executar o seu script após colocar o MD5 q funfa na boa ? tem como explcar melhor isso da janela com a procedure "repasswords" ?

Yes, this scritp only is used to create the procedure called repasswords that you will use to encript all accounts or memb_info when you run repassords procedure. Dificult to run this procedure? Just open a new window and type repasswords and run it.

Well, dont mistake. This procedure is used to help in transfer accounts. You will need change your web site to encript passwords normal like this code to encript password in (change password page in asp code or register new account page in asp):

cripty="dbo.Encripta " & ps_psd1 & "," & ps_loginname & ""
set rs2 = Server.CreateObject("ADODB.Recordset")
set rs2=conn.execute(cripty)
set rs2 = nothing()
' where ps_psd1 is the passoword and ps_loginname is account name.

 

[limpamesa]

Hello.

I Have problem with this script. When I execute him, Query Analizer obtain this error:

"Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'Encripta'. The stored procedure will still be created."

How can I fix this?

Sory for my english .

Make sure you have WZ_MD5_MOD.dll installed (if not, see other guide to install it)

 

[spartan]

this sounds very useful, i'll use it when i have to transfer the accounts in the database, thx limpamesa!

 

[paty123]

error:


Server: Msg 512, Level 16, State 1, Procedure repasswords, Line 17
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Server: Msg 512, Level 16, State 1, Procedure repasswords, Line 18
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Pls Help.

 

[didi3d]

cara enfim venho te agradecer pois sua Procedure é realmente 100% pelo menos pra mim encriptou tudin na boa =)

This procedure works 100% follow the steps from limpamesa and you can too
thx man

 

[makcia]

good script thanks very much.