Anti Dupe Ban

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 = (case when ItemCount < 0x7effffff then ItemCount+1
else 1
end )
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
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=SUBSTRING(@cr_data,@j*10+1,1)
SET @cr_serial=SUBSTRING(@cr_data,@j*10+4,4)
IF @cr_type<>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=SUBSTRING(@wh_data,@k*10+1,1)
SET @wh_serial=SUBSTRING(@wh_data,@k*10+4,4)
IF @wh_type=@cr_type AND @wh_serial=@cr_serial
SET @find=1
SET @k=@k+1
END
END
END
SET @j=@j+1
END
IF @find=1
BEGIN
INSERT INTO copylog (copy_whdata,copy_acid,copy_date) VALUES (@wh_data,@al_acid,getdate())
-- this is wer u can add more punishment like ban or lock characters
UPDATE Character SET CtlCode=1 WHERE accountid=@al_acid
END
SET NOCOUNT OFF
END
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
DECLARE @al_acid char(50)
set @al_acid = 'ASUS'
UPDATE Character SET CtlCode=1 WHERE accountid=@al_acid
go
select * from AllItemsLog
select * from CopyLog

work and for 1.02N MU Version ?

yes:eat:

What does it mean?? it will atoumatically ban characters that are duplicating items??

yeah i think its also riped without giving credit to...

This procedure makes lag??
Its more easy, if u tell us how do u make, and we add in our procedure wz_getitenserial...

Because i saw you drop de procedure, and create other...

this procedure is good, I use it in my 97r+1.0 server and 1.0m(99.6xT) server too. And I will use it in 1.02n, I got I dont remember where and when I got, works perfectly, virty, dont cause lag... I got 1 time 315 players online and no lag

I of swit to character and my blocked ChaRs esto, I raising of the blockade they, more when this still happens, not has a codig to undo this ae?

Great work, i use in my server.

ty

Credits: ThAuA

?

It was released some time ago

And the Award For The Most Retarded Leecher goes to... -=Craker=-

Congrats! rofl

i put this script in Query Analyzer how to delet him ?
becouse i have BOK of Kundun in shop and when people drop the BOK and exemple drop 2 Dark Soul Gloved when exit the game and want to connect after 5-10 min or other day have the all characters banned :D

i can delet the script from the Query Analyzer ?

work and for 99.6XT version ?
it will atoumatically ban characters that are duplicating items?

Wow! great job man!

Anyway, where did you get this? :rudolph:

Quote:

---

Originally Posted by Shagoon

And the Award For The Most Retarded Leecher goes to... -=Craker=-

Congrats! rofl

---

I dont give a crap of credits. It's good he "released" it because till now I did not know there is such a thing. Then I guess thanks Craker.

its sql job?

this triger is incomplete...
only comparate inventory V/S warehouse


sorry for my english XD

Big Thanks Dude , Great Released.

Can i delete this script ?!I use this in Query Analyzer

How i can add to script function whis disconnect player if it have dupe items?
I don't speak english -)

We need more material at Dupe and Ban stuff!!!

i have problem ... if i have item same serrial (heard,jewel,or another).game msg me mu item dupe and i have DC ... pls help me.

test in 1.02 q :)
tanks dud!

So is this good or not? I would like to know that if a player drops for example 2 hearts of love and they drop the same items will he get banned? I really need to know this.. Thanks in advance :)

Tested = Aproved !

bad script ban me 109 player and me :( don't work good how i delete? plzz

Work in 97d-99i server ?

work and for 99z MU Version ?

work and for 99z MU Version ?

Quote:

---

Originally Posted by stanio

i have problem ... if i have item same serrial (heard,jewel,or another).game msg me mu item dupe and i have DC ... pls help me.

---

In your commonserver search for illegal dupe check or stomething and disable it.

lol i tested it i cant believe it actually works LOL my 2nd account got banned. good job man...im impressed..lol

nice!

Funciona na vers

10x man really useful :)

work on 97d ? :?

cam you make it in 1.00.16 version this is to old.

wOW GOOD JOB MAN

Quote:

---

Originally Posted by jbr05kill

cam you make it in 1.00.16 version this is to old.

---

Right here: http://forum.ragezone.com/f197/relea...n-3-db-336831/

^^ This query ban Char but when resets --> Items serials = FFF --> Ban character

Nice work =D
this is useful

I ran it in my server (after i put two item with the same serial (0x22222222) and it has getting 0 dupes) any1 know why?

I'm very sorry to bump this old thread but i have a question, does this script can ban people who dupe zen, box of kundun's and jewels from the shop?

Thanks in advance.

Ive used this query , now my accounts are banned =x

How can i fix this =x

lol why all char be banned i need delete this scrip help me

I found how Remove this stupid Script u must go:

1. Enterprise Manager.
2. MuOnline.
3. Stored Procedures ( Found the " WZ_GetItemSerial & WZ_GetItemSerial2 " and Delete it.
4. MuOnline>Tables ( Found the " AllItemsLog & CopyLog " and Delete it.

and u remove this :grr: script

TnX throzen. This script is bad!!! :D :D :D becose it baned people for nothing! :@

this script causes too lag, and dont DC, only block account if serial equal of table allitemlog, and dont detect dupe from trade, our itens from NPC.

bad script banned all characters =)) lol

10/10

Quote:

---

Originally Posted by svirki

10/10

---

bulgarian spammer=)) u don`t test it but u give notes...get lost lamer..

stop spam.You embarrassing BG.

What in Romania you don't have a spamemers(WtF).

Script 3/10

working on season 4 or 5?

can anyone say me how to use it ? :?:? sorry for my english

Quote:

---

Originally Posted by jesterlin11

can anyone say me how to use it ? :?:? sorry for my english

---

open sql query analyzer, select mu online database at the top

copy code from this topic

paste in q-analyzer

hit F5 & done

Bad script! This is for noobs that want to messup database! :)) my advice: Do not use it!