99.6XT without MD5 encrypt

Printable View

10-08-06
slayps4

99.6XT without MD5 encrypt

JoinServer.exe
DataBase with corrections and passwords "varchar"

If you don't use my DB aplly this query in your DB..

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

Quote:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WZ_DISCONNECT_MEMB]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[WZ_DISCONNECT_MEMB]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
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

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

FOUND A BUG IN MY DATABASE ON CREATE GUILD HERE IS THE CORRECTION

Quote:

use [MuOnline]
GO

/****** Object: Table [dbo].[Guild] Script Date: 14/8/2006 15:53:04 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Guild]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Guild]
GO

/****** Object: Table [dbo].[GuildMember] Script Date: 14/8/2006 15:53:04 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GuildMember]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GuildMember]
GO

/****** Object: Table [dbo].[Guild] Script Date: 14/8/2006 15:53:04 ******/
CREATE TABLE [dbo].[Guild] (
[G_Name] [varchar] (8) COLLATE Polish_CI_AS NOT NULL ,
[G_Mark] [varbinary] (32) NULL ,
[G_Score] [int] NULL ,
[G_Master] [varchar] (10) COLLATE Polish_CI_AS NULL ,
[G_Count] [int] NULL ,
[G_Notice] [varchar] (60) COLLATE Polish_CI_AS NULL ,
[Number] [int] IDENTITY (1, 1) NOT NULL ,
[G_Type] [int] NOT NULL ,
[G_Rival] [int] NOT NULL ,
[G_Union] [int] NOT NULL
) ON [PRIMARY]
GO

/****** Object: Table [dbo].[GuildMember] Script Date: 14/8/2006 15:53:05 ******/
CREATE TABLE [dbo].[GuildMember] (
[Name] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[G_Name] [varchar] (8) COLLATE Polish_CI_AS NOT NULL ,
[G_Level] [tinyint] NULL ,
[G_Status] [tinyint] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Guild] WITH NOCHECK ADD
CONSTRAINT [PK_Guild] PRIMARY KEY CLUSTERED
(
[G_Name]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[GuildMember] WITH NOCHECK ADD
CONSTRAINT [PK_GuildMember] PRIMARY KEY CLUSTERED
(
[Name]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Guild] WITH NOCHECK ADD
CONSTRAINT [DF_Guild_G_Type] DEFAULT (0) FOR [G_Type],
CONSTRAINT [DF_Guild_G_Rival] DEFAULT (0) FOR [G_Rival],
CONSTRAINT [DF_Guild_G_Union] DEFAULT (0) FOR [G_Union]
GO

ALTER TABLE [dbo].[GuildMember] WITH NOCHECK ADD
CONSTRAINT [DF_GuildMember_G_Status] DEFAULT (0) FOR [G_Status]
GO

ALTER procedure WZ_GuildCreate
@GuildName varchar(8),
@MasterName varchar(10)
as
BEGIN
DECLARE @ErrorCode int

SET @ErrorCode = 0
SET XACT_ABORT ON

Set nocount on
begin transaction

INSERT INTO Guild (G_Name, G_Master) VALUES (@GuildName, @MasterName)
IF ( @@Error <> 0 )
BEGIN
SET @ErrorCode = 1
END

IF ( @ErrorCode = 0 )
BEGIN

INSERT GuildMember (Name, G_Name, G_Level) VALUES (@MasterName, @GuildName, 1)
IF ( @@Error <> 0 )
BEGIN
SET @ErrorCode = 2
END
END

IF ( @ErrorCode <> 0 )
rollback transaction
ELSE
commit transaction

select @ErrorCode

Set nocount off
SET XACT_ABORT OFF
END
GO
10-08-06
yanivman

i love MD5 hehe but thx at all :)
10-08-06
didi3d

erro:

Server: Msg 3726, Level 16, State 1, Line 4
Could not drop object 'dbo.MEMB_INFO' because it is referenced by a FOREIGN KEY constraint.
Server: Msg 2714, Level 16, State 6, Line 2
There is already an object named 'MEMB_INFO' in the database.

whats a problem

PT : cara sempre da isso nessa tabela sabe como resolver ???
10-08-06
yachex

woow ... - . entonces kon eso k se logra !! usar kualer web ??
o debo usar una que tambien trabaje kon MD5 !!
10-08-06
yachex

thank you very much. good if use your DB that this without MD5, I can use any Web. that is certain. please I need that answer
10-08-06
satek

how can i get these querys in my DB?
11-08-06
Kamil666

Works Well like HELL! Good JOB MAN!, All Pages now work with this stuff.
Did you test it all ? Does This Join Server is compatible and have all what got MD5Joinserver? I got Castle Siege problem after i use this JoinServer but i am not sure Join Server is a problem, can you test all with this JoinServer?
11-08-06
MAXDANGER

aew mano poderia me postar la para nois tamo no maior sufoco na vm ajuda la veio psota isso traduzido para nos vlw
12-08-06
NeTw0rK

Imposible created guild :(
14-08-06
3D50N

Quote:

Originally Posted by slayps4

JoinServer.exe
DataBase with corrections and passwords "varchar"

If you don't use my DB aplly this query in your DB..

sabe dizer se tem algum bug??? por causa da db unificada e do join server sem md5??
14-08-06
slayps4

found a bug in my Database on Create guild

here is the correction

Quote:

use [MuOnline]
GO

/****** Object: Table [dbo].[Guild] Script Date: 14/8/2006 15:53:04 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Guild]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Guild]
GO

/****** Object: Table [dbo].[GuildMember] Script Date: 14/8/2006 15:53:04 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GuildMember]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GuildMember]
GO

/****** Object: Table [dbo].[Guild] Script Date: 14/8/2006 15:53:04 ******/
CREATE TABLE [dbo].[Guild] (
[G_Name] [varchar] (8) COLLATE Polish_CI_AS NOT NULL ,
[G_Mark] [varbinary] (32) NULL ,
[G_Score] [int] NULL ,
[G_Master] [varchar] (10) COLLATE Polish_CI_AS NULL ,
[G_Count] [int] NULL ,
[G_Notice] [varchar] (60) COLLATE Polish_CI_AS NULL ,
[Number] [int] IDENTITY (1, 1) NOT NULL ,
[G_Type] [int] NOT NULL ,
[G_Rival] [int] NOT NULL ,
[G_Union] [int] NOT NULL
) ON [PRIMARY]
GO

/****** Object: Table [dbo].[GuildMember] Script Date: 14/8/2006 15:53:05 ******/
CREATE TABLE [dbo].[GuildMember] (
[Name] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[G_Name] [varchar] (8) COLLATE Polish_CI_AS NOT NULL ,
[G_Level] [tinyint] NULL ,
[G_Status] [tinyint] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Guild] WITH NOCHECK ADD
CONSTRAINT [PK_Guild] PRIMARY KEY CLUSTERED
(
[G_Name]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[GuildMember] WITH NOCHECK ADD
CONSTRAINT [PK_GuildMember] PRIMARY KEY CLUSTERED
(
[Name]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Guild] WITH NOCHECK ADD
CONSTRAINT [DF_Guild_G_Type] DEFAULT (0) FOR [G_Type],
CONSTRAINT [DF_Guild_G_Rival] DEFAULT (0) FOR [G_Rival],
CONSTRAINT [DF_Guild_G_Union] DEFAULT (0) FOR [G_Union]
GO

ALTER TABLE [dbo].[GuildMember] WITH NOCHECK ADD
CONSTRAINT [DF_GuildMember_G_Status] DEFAULT (0) FOR [G_Status]
GO

ALTER procedure WZ_GuildCreate
@GuildName varchar(8),
@MasterName varchar(10)
as
BEGIN
DECLARE @ErrorCode int

SET @ErrorCode = 0
SET XACT_ABORT ON

Set nocount on
begin transaction

INSERT INTO Guild (G_Name, G_Master) VALUES (@GuildName, @MasterName)
IF ( @@Error <> 0 )
BEGIN
SET @ErrorCode = 1
END

IF ( @ErrorCode = 0 )
BEGIN

INSERT GuildMember (Name, G_Name, G_Level) VALUES (@MasterName, @GuildName, 1)
IF ( @@Error <> 0 )
BEGIN
SET @ErrorCode = 2
END
END

IF ( @ErrorCode <> 0 )
rollback transaction
ELSE
commit transaction

select @ErrorCode

Set nocount off
SET XACT_ABORT OFF
END
GO
16-08-06
EponyM

Great guide, worked for me :)
16-08-06
didi3d

vlw msm hein slapy ta arrebentando ^^

Brazil forever e erver
16-08-06
rolke

hmmm :/
16-08-06
renanzin

POE AI 1 FIX TBM PARA PARA DE DAR ISSO AKI O
http://img20.imageshack.us/img20/7239/oopf0.jpg

DETALHE EU SEI QUE ISSO E DO TEU JOINSERV POR QUE EU USO JOINSERV ORIGINAL DO ADDAN MAS E COM MD5 DAI NAO PEGA POR CAUSA DA SUA DATA BASE TERIA COMO VOCE DA 1 REVISADA NISSO LEK
17-08-06
inquisitor

Nice. But why would someone want to disable md5?
23-08-06
_opex_

can you explain how to put all this in DB where i need to put all this plz help
27-08-06
Jabberwock

thanks for this DB, that works nice =) 11/10 ^^
09-09-06
virty

Bomm...

Valeu pelo topicoooo caraaaaaaaaaaaa!!!!

Very good!!

Brazil forever!
09-09-06
virty

Valeu pelo topicoooo caraaaaaaaaaaaa!!!!

Very good!!

Brazil forever!
14-09-06
evgenii007

i am using that DB but ppls can't create guild!
26-09-06
Myky4

Nice All Worke Fine!
But 1 bug or what is it When you Create Acc on The Web the Acc was created Succ but When i go too my Db The is no Acc Why so?
SORRY For my Bad ENGLISH!!
I'm Russian!
28-09-06
Myky4

Nice Work Man!
12-10-06
celmae

Ive already downloaded your new DB.. still cant create guild..

can we configure this joinserver to work same as normal MD5 joinserver..?

like for example is the hide and show of CS_GS and GS
21-10-06
yachex

good. very good contribution. the problem is that I cannot create guild! some solution. somebody that please finds neat the problem of the creation of clans.! I wait for its aid!
05-01-07
artikz

Quote:

Originally Posted by evgenii007

i am using that DB but ppls can't create guild!

im using this db to and there is no possibility to create guild:nono: :nono: :nono:
06-01-07
MagicMelody

Can't create guild,please help i use your procedure, i very need to be without md5, sry bad english.. writing Guild already exists!! Please help
25-02-07
SAKA

Re: [Guide] 99.6XT without MD5 encrypt

Sucks Md5
17-03-07
LuisaoADM

Re: [Guide] 99.6XT without MD5 encrypt

When i Put Any Item on the Vault it just Bugs... and the item disapears how to solve that?
01-03-09
coloor

Re: [Guide] 99.6XT without MD5 encrypt

Links are dead please reupload the links..