赤壁手工注册账号教程

1、打开，下载xp_md5.dll

2、打开SQL2005数据库，选择master数据库，执行如下语句：

USE master;
EXEC sp_addextendedproc 'xp_md5', 'xp_md5.dll'; --这里写你文件实际位置

3、执行如下语句

USE master;
CREATE FUNCTION [dbo].[fn_md5] (@data TEXT)
RETURNS CHAR(32) AS
BEGIN
  DECLARE @hash CHAR(32)
  EXEC master.dbo.xp_md5 @data, -1, @hash OUTPUT
  RETURN @hash
END;

USE master;

CREATE FUNCTION [dbo].[fn_md5x] (@data IMAGE, @len INT = -1)
RETURNS CHAR(32) AS
BEGIN
  DECLARE @hash CHAR(32)
  EXEC master.dbo.xp_md5 @data, @len, @hash OUTPUT
  RETURN @hash
END;

--如果执行有问题就一段一段选择执行

4、打开赤壁数据库，执行如下语句：

select upper('0x'+master.dbo.fn_md5('test'+'test')); --先执行，将结果复制出来

INSERT INTO account
                      (id, name, passwd, creatime, usertype)
VALUES     (96, 'test', 0x05A671C66AEFEA124CC08B76EA6D30BB, GETDATE(), 0);

INSERT INTO users
                      (id, prompt, answer, truename, idnumber, email, mobilenumber, province, city, phonenumber, address, postalcode, gender, birthday, ,

passwd2)
VALUES     (96, 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 0, GETDATE(), 'test',
                      0x05A671C66AEFEA124CC08B76EA6D30BB);