• Vá em Iniciar >>Todos os Programas >> Microsoft SQL Server >> Query Analyzer
• Será aberto um recorrente que diz conectar ao SQL Server, em seguida entre com seu Loguim e Senha do SQL.
•Após entrar no Query analyzer irá abrir um grande espaço para inserir um texto, neste espaço cole o seguinte código:
if exists(select * from dbo.sysobjects where type='p' and name='WZ_GetItemSerial') drop procedure WZ_GetItemSerial go CREATE procedure WZ_GetItemSerial as GO if exists
(select * from dbo.sysobjects where id = object_id(N'[dbo].[trg_CheckSameID]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trg_CheckSameID] GO BEGIN DECLARE @ItemSerial int set nocount on begin transaction update GameServerInfo set @ItemSerial = ItemCount = (case when ItemCount < 0x7effffff then ItemCount+1 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trg_CheckSameID]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trg_CheckSameID] GO GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trg_CheckSameID]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trg_CheckSameID] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AllItemsLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[AllItemsLog] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CopyLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CopyLog] GO CREATE TABLE [dbo].[AllItemsLog] ( [items_id] [int] IDENTITY (1, 1) NOT NULL , [items_type] [binary] (1) NOT NULL , [items_serial] [binary] (4) NOT NULL , [items_acid] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CopyLog] ( [copy_id] [int] IDENTITY (1, 1) NOT NULL , [copy_acid] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [copy_whdata] [binary] (1200) NOT NULL , [copy_date] [datetime] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[AllItemsLog] ADD CONSTRAINT [DF_CT_ITEM_item] DEFAULT (0) FOR [items_type], CONSTRAINT [DF_CT_ITEM_itemid] DEFAULT (0) FOR [items_serial], CONSTRAINT [DF_CT_ITEM_itemrole] DEFAULT ('') FOR [items_acid] GO CREATE INDEX [IX_CT_ITEM] ON [dbo].[AllItemsLog]([items_type], [items_serial]) ON [PRIMARY] GO ALTER TABLE [dbo].[CopyLog] ADD CONSTRAINT [DF_CopyLog_copy_date] DEFAULT (getdate()) FOR [copy_date] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE TRIGGER [dbo].[trg_CheckSameID] ON [dbo].[character] FOR UPDATE AS BEGIN IF UPDATE(inventory) BEGIN SET NOCOUNT ON DECLARE @wh_acid varchar(10), @wh_data binary(1200), @wh_type binary(1), @wh_serial binary(4), @cr_user varchar(10), @cr_acid varchar(10), @cr_data binary(760), @cr_type binary(1), @cr_serial binary(4), @al_acid varchar(10), @j int, @k int, @find bit SELECT @cr_acid=i.accountid, @cr_data=i.inventory FROM inserted i SET @j=0 SET @find=0 WHILE @j<76 and="" cr_data="" is="" not="" null="" begin="" set="" cr_type="" cr_serial="SUBSTRING(@cr_data,@j*10+4,4)" if="">0xFF AND @cr_serial<>0x00000000 BEGIN SELECT @al_acid=items_acid FROM allitemslog WHERE items_type=@cr_type AND items_serial=@cr_serial IF @al_acid IS NULL INSERT INTO allitemslog (items_type,items_serial,items_acid) VALUES (@cr_type,@cr_serial,@cr_acid) ELSE BEGIN UPDATE allitemslog SET items_acid=@cr_acid WHERE items_type=@cr_type AND items_serial=@cr_serial SELECT @wh_data=items FROM warehouse WHERE accountid=@al_acid SET @k=0 WHILE @k<120 and="" wh_data="" is="" not="" null="" begin="" set="" wh_type="@cr_type" wh_serial="@cr_serial" if="" find="1" k="@k+1" end="" j="@j+1" insert="" into="" copylog="" copy_whdata="" copy_acid="" copy_date="" values="" al_acid="ASUS" getdate="" --="" this="" wer="" u="" can="" add="" more="" punishment="" like="" ban="" or="" lock="" characters="" update="" character="" ctlcode="1" where="" accountid="@al_acid" nocount="" off="" go="" quoted_identifier="" ansi_nulls="" on="" declare="declare" char="" 50="" select="" from="" allitemslog="" presione="" f5="" e="" depois="" ctrl="" n="" ir="" abrir="" outra="" tela="" nesta="" cole="" o="" seguinte="" c="" digo:="" d="" novamente="" mais="" uma="" vez="" digo="" abaixo:="" pressione="" est="" pronto="" em="" seguida="" feche="" todas="" as="" janelas="" abertas="" salvando="" os="" logs="" aonde="" desejar="" obs:="" sistema="" funciona="" apenas="" com="" players="" online="" p="">else 1 end) if(@@error <> 0) begin rollback transaction select-1 end else begin commit transaction select @ItemSerial end END
