99.6XT without MD5 encrypt

[slayps4]

JoinServer.exe
DataBase with corrections and passwords "varchar"

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

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

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

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

[MentaL]

[yanivman]

i love MD5 hehe but thx at all :)

[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 ???

[yachex]

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

[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

[satek]

how can i get these querys in my DB?

[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?

[MAXDANGER]

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

[NeTw0rK]

Imposible created guild :(

[3D50N]

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

[slayps4]

found a bug in my Database on Create guild

here is the correction

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

[EponyM]

Great guide, worked for me :)

[didi3d]

vlw msm hein slapy ta arrebentando ^^

Brazil forever e erver

[rolke]

hmmm :/

[renanzin]

POE AI 1 FIX TBM PARA PARA DE DAR ISSO AKI O


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

[inquisitor]

Nice. But why would someone want to disable md5?

[_opex_]

can you explain how to put all this in DB where i need to put all this plz help

[Jabberwock]

thanks for this DB, that works nice =) 11/10 ^^

[virty]

Valeu pelo topicoooo caraaaaaaaaaaaa!!!!

Very good!!

Brazil forever!

[virty]

Valeu pelo topicoooo caraaaaaaaaaaaa!!!!

Very good!!

Brazil forever!

[evgenii007]

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

[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!

[Myky4]

Nice Work Man!

[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

[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!