[Guide] 99.62T Without MD5 Encrypt
Page 1 of 1
[Guide] 99.62T Without MD5 Encrypt
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:
Correction, add this procedure too..
Quote:
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
Similar topics
» [Guide] Guide for Dummies/Noobs on server setup
» [Guide] Thorough Guide to Making 1.00L Server [ Router ]
» [Guide] How to setup ur own 97d+99 router guide!
» [Guide] Thorough Server Setup Guide
» [Guide] Vd0Team Server Guide
» [Guide] Thorough Guide to Making 1.00L Server [ Router ]
» [Guide] How to setup ur own 97d+99 router guide!
» [Guide] Thorough Server Setup Guide
» [Guide] Vd0Team Server Guide
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|