MMORG ZONE
Would you like to react to this message? Create an account in a few clicks or log in to continue.

[Guide] 99.62T Without MD5 Encrypt

Go down

[Guide] 99.62T Without MD5 Encrypt Empty [Guide] 99.62T Without MD5 Encrypt

Post by  Sun Dec 23, 2007 10:35 am

Download this
JoinServer (RapidShare)
JoinServer.exe (FileFront)


and put this query in your DB "MuOnline", or "Me_MuOnline" If you use more than one databases

Quote:


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MANG_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[MANG_INFO]

GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[MEMB_INFO]

GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_OUT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[MEMB_OUT]

GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MembInfoModify]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[MembInfoModify]

GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_CURR_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[VI_CURR_INFO]

GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_FQNW_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[VI_FQNW_INFO]

GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_MIDS_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[VI_MIDS_INFO]

GO


CREATE TABLE [dbo].[MANG_INFO] (

[mang_guid] [int] NOT NULL ,

[mang___id] [nvarchar] (15) COLLATE Polish_CI_AS NOT NULL ,

[mang__pwd] [nvarchar] (15) COLLATE Polish_CI_AS NOT NULL ,

[mang_name] [nvarchar] (20) COLLATE Polish_CI_AS NOT NULL ,

[mail_addr] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,

[levl_name] [nvarchar] (30) COLLATE Polish_CI_AS NULL ,

[part_name] [nvarchar] (30) COLLATE Polish_CI_AS NULL ,

[auth_code] [nvarchar] (30) COLLATE Polish_CI_AS NULL ,

[appl_days] [nvarchar] (8) COLLATE Polish_CI_AS NOT NULL ,

[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,

[Group_code] [nvarchar] (2) COLLATE Polish_CI_AS NULL ,

[dep_code] [nvarchar] (4) COLLATE Polish_CI_AS NOT NULL ,

[perm] [int] NOT NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MEMB_INFO] (

[memb_guid] [int] IDENTITY (1, 1) NOT NULL ,

[memb___id] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[memb__pwd] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[memb_name] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[sno__numb] [char] (13) COLLATE Polish_CI_AS NOT NULL ,

[post_code] [char] (6) COLLATE Polish_CI_AS NULL ,

[addr_info] [varchar] (50) COLLATE Polish_CI_AS NULL ,

[addr_deta] [varchar] (50) COLLATE Polish_CI_AS NULL ,

[tel__numb] [varchar] (20) COLLATE Polish_CI_AS NULL ,

[phon_numb] [varchar] (15) COLLATE Polish_CI_AS NULL ,

[mail_addr] [varchar] (50) COLLATE Polish_CI_AS NULL ,

[fpas_ques] [varchar] (50) COLLATE Polish_CI_AS NULL ,

[fpas_answ] [varchar] (50) COLLATE Polish_CI_AS NULL ,

[job__code] [char] (2) COLLATE Polish_CI_AS NULL ,

[appl_days] [datetime] NULL ,

[modi_days] [datetime] NULL ,

[out__days] [datetime] NULL ,

[true_days] [datetime] NULL ,

[mail_chek] [char] (1) COLLATE Polish_CI_AS NULL ,

[bloc_code] [char] (1) COLLATE Polish_CI_AS NOT NULL ,

[ctl1_code] [char] (1) COLLATE Polish_CI_AS NOT NULL ,

[adminaccess] [int] NOT NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MEMB_OUT] (

[out__guid] [int] NOT NULL ,

[memb_guid] [int] NOT NULL ,

[sno__numb] [nvarchar] (7) COLLATE Polish_CI_AS NULL ,

[memb_name] [nvarchar] (15) COLLATE Polish_CI_AS NULL ,

[appl_days] [smalldatetime] NULL ,

[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MembInfoModify] (

[Number] [int] NOT NULL ,

[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[memb__pwd] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[sno__numb] [nvarchar] (13) COLLATE Polish_CI_AS NOT NULL ,

[tel__numb] [nvarchar] (20) COLLATE Polish_CI_AS NULL ,

[phon_numb] [nvarchar] (15) COLLATE Polish_CI_AS NULL ,

[mail_addr] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,

[fpas_ques] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,

[fpas_answ] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,

[bloc_code] [nvarchar] (1) COLLATE Polish_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[VI_CURR_INFO] (

[ends_days] [nvarchar] (8) COLLATE Polish_CI_AS NULL ,

[chek_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,

[used_time] [int] NULL ,

[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[memb_guid] [int] NOT NULL ,

[sno__numb] [nvarchar] (18) COLLATE Polish_CI_AS NOT NULL ,

[Bill_Section] [int] NULL ,

[Bill_Value] [int] NULL ,

[Bill_Hour] [int] NULL ,

[Surplus_Point] [int] NULL ,

[Surplus_Minute] [datetime] NULL ,

[Increase_Days] [int] NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[VI_FQNW_INFO] (

[appl_code] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[ctrl_text] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,

[fpas_ques] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,

[fpas_answ] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,

[appl_days] [nvarchar] (8) COLLATE Polish_CI_AS NOT NULL ,

[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,

[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[memb_guid] [int] NOT NULL ,

[fanw_guid] [int] NOT NULL ,

[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[sno__numb] [nvarchar] (18) COLLATE Polish_CI_AS NOT NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[VI_MIDS_INFO] (

[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[sno__numb] [nvarchar] (18) COLLATE Polish_CI_AS NOT NULL ,

[appl_days] [nvarchar] (8) COLLATE Polish_CI_AS NOT NULL ,

[chek_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,

[prev_info] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,

[modi_info] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,

[cont_text] [ntext] COLLATE Polish_CI_AS NOT NULL ,

[mids_guid] [int] NOT NULL ,

[admin_name] [nvarchar] (10) COLLATE Polish_CI_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO


ALTER TABLE MEMB_INFO ALTER COLUMN memb__pwd VARCHAR(10) NOT NULL

GO


Correction, add this procedure too..
Quote:


USE [MuOnline]

GO

/****** Object: StoredProcedure [dbo].[WZ_DISCONNECT_MEMB] Script Date: 07/22/2006 21:38:28 ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER ON

GO



CREATE PROCEDURE [dbo].[WZ_DISCONNECT_MEMB]


@uid varchar(20)

AS

Begin


BEGIN TRANSACTION


SET NOCOUNT ON


IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)

WHERE memb___id = @uid )

Begin

UPDATE MEMB_STAT

SET DisConnectTM = (getdate()), connectstat = 0 WHERE memb___id = @uid

End

ELSE

Begin

INSERT INTO MEMB_STAT ( memb___id,DisConnectTM,connectstat) valueS (

@uid,

(getdate()),

0

)

End



IF(@@Error <> 0 )

ROLLBACK TRANSACTION

ELSE

COMMIT TRANSACTION


SET NOCOUNT OFF

End



Favourite Game : MuOnline
Registration date : 1969-12-31

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum