99.62T Without MD5 Encrypt

[slayps4]

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

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..

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

[MentaL]

[Dios]

[GUIDE] tag added, next time it will be deleted.

[slayps4]

[GUIDE] tag added, next time it will be deleted.

Sorry ^^

[android]

it functions?

[ChuckyIIX0]

[GUIDE] tag added, next time it will be deleted.

Lol Dios just because Argentina doesn't like Brazil you don't have to hate.. this is a Great Guide.... Im sure this will get John_D mad because he spent time coding MD5 to work.

[mod]Warning added 10%+[/mod]

[gamesq7]

Can you up file in another host? i can't dowload from rapid share
sorry my english!

[Kamil666]

very good man, i know many people will be happy about that :)

[Krysna]

I cant delete memb_info i get this error:
Could not drop object 'dbo.MEMB_INFO' because it is referenced by a FOREIGN KEY constraint.

[popo]

but he sells his MuToolz , i never has seen mutoolz with MD5 if you got pass to me, if not i get this code and get off MD5 shit

[popo]

Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'adminaccess', table 'MuOnline.dbo.MEMB_INFO'; column does not allow nulls. INSERT fails. (severity 16) in C:\AppServ\www\LastKup\modules\doreg.php on line 196

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\LastKup\modules\doreg.php on line 196
Your account has been created succesfully:


Help

[Nocturnal]

Lol Dios just because Argentina doesn't like Brazil you don't have to hate.. this is a Great Guide.... Im sure this will get John_D mad because he spent time coding MD5 to work.

[mod]Warning added 10%+[/mod]

and does it mean he dont have to follow rules too?

anyway great guide.

[bet0x]

Dude, dont be stupid, if you remove the MD5 crypto your server DB can be stoled, and published, bad idea.

add a MD5 support to php its easy, 5' at much..

damn ppl, now someone will saw "My sewer was hacked" :P

[john_d]

nah, it is cool...

and to tell i didn't even spend 5 mins on the md5 thingi... just because i didnt release any Md5 site doesn't mean i don't know how. i just don't feel like it,. far better games out ther to develop than mu.

only reason i released the Mutoolz 2 Md5 support was because of the people who bought Mutoolz from me and they wanted atleast a test for their new server files.

[slayps4]

Procedure of Disconnection Added

[sobix]

Tnx m8...this works for me...hope it dosen`t mess up the db :D

[genius007]

lol wont work coz after log in Gs_cs and Gs crash. =)) i already try this idea long ago.

[commandcom]

[adminaccess] [int] NOT NULL give errors but [adminaccess] [int] NULL seems work ok
but login to game give invalid account error

[scorpyon23]

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



Correction, add this procedure too..

Can u share u db??????

This code dont works in my db... :( dont login in game or in site...

Ajuda aew br auuhuhuua

[_FrAiZ_]

i will test it i hope it works bcause i`m having a problem with MD5 :(

[_FrAiZ_]

i hope it works :) . I`m having a problem with that MD5 :(

[antonijs]

How fix it? In game Invalid Account