Fix Anti-Dupe Ban

[Chiritokaji]

Mới kiếm được cái AntiDupe...Chưa Test...Share anh em TEst thử coi được ko

use MuOnline

if exists(select * from dbo.sysobjects where type='p' and name='WZ_GetItemSerial')
drop procedure WZ_GetItemSerial
go

CREATE procedure WZ_GetItemSerial
as
BEGIN
DECLARE @ItemSerial int
set nocount on
begin transaction

update GameServerInfo set @ItemSerial = ItemCount = ItemCount+1

if ( @@error <> 0 )
begin
rollback transaction
select -1
end
else
begin
commit transaction
select @ItemSerial
end
END
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

[onetheside123]

bóc tem , anh TTG toàn share query khủng

[TALovexm]

bóc tem , anh TTG toàn share query khủng

Cứ thử chạy cái này đi, sẽ thấy ngay ^^

[vietpro8x]

bữa nay nó dupe xong là seri ko trùng lun hê hê