有需要的可以看看,1.0_M什么网站都能用的方法!|奇迹Mu技术 - 梦想仙境中文官方社区论坛

离线sksj888

新手上路

发帖: 98

祝福宝石: 0

威望: 0

玛雅之石: 0

创造宝石: 0

只看楼主倒序阅读使用道具楼主发表于: 2006-08-11

[注意]如果你使用的风的登陆器,要把攻城线设置为不隐藏,否则会卡死!呵呵,别的都正常!

使用方法:替换JoinServer目录下的同名文件,然后在SQL里执行以下查询即可,使用任何网站系统注册游戏!(压缩包里附查询命令)

下载地址:http://www.7j45.com/MuInfo/Html/2006811224725.html

SQL:

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 Chinese_PRC_CI_AS NOT NULL ,
[mang__pwd] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mang_name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mail_addr] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[levl_name] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[part_name] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[auth_code] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Group_code] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[dep_code] [nvarchar] (4) COLLATE Chinese_PRC_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 Chinese_PRC_CI_AS NOT NULL ,
[memb__pwd] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sno__numb] [char] (13) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[post_code] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[addr_info] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[addr_deta] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[tel__numb] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[phon_numb] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[mail_addr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fpas_ques] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fpas_answ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[job__code] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[appl_days] [datetime] NULL ,
[modi_days] [datetime] NULL ,
[out__days] [datetime] NULL ,
[true_days] [datetime] NULL ,
[mail_chek] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[bloc_code] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctl1_code] [char] (1) COLLATE Chinese_PRC_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 Chinese_PRC_CI_AS NULL ,
[memb_name] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[appl_days] [smalldatetime] NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MembInfoModify] (
[Number] [int] NOT NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb__pwd] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (13) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[tel__numb] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[phon_numb] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[mail_addr] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fpas_ques] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fpas_answ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[bloc_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[VI_CURR_INFO] (
[ends_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[chek_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[used_time] [int] NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_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 Chinese_PRC_CI_AS NOT NULL ,
[ctrl_text] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fpas_ques] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[fpas_answ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_guid] [int] NOT NULL ,
[fanw_guid] [int] NOT NULL ,
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[VI_MIDS_INFO] (
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[chek_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[prev_info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[modi_info] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cont_text] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mids_guid] [int] NOT NULL ,
[admin_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

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

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