Nothing better like BAN Dupers! :)

YO!

Ok! Now i will tell you how to atomaticly ban users who copy items!
There is two ways how to excute scripts!

FIRST WAY:

• Open your Enterprise Manager
• Go to Magnament and start you'r SQL Server Agent!
• Close Enterprise Manager and open SQL Query Analyzer!
• Select user SA and write SQL Password!
• Change database from Master to MuOnline!
• Insert this script:

Quote:

---

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 warehouse SET pw=5555,items=null WHERE accountid=@al_acid
END
SET NOCOUNT OFF
END
END


GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

use MuOnline
select * from AllItemsLog
select * from CopyLog

use MuOnline
select * from CopyLog

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

select * from copylog

dissel: update warehouse set pw = '' where AccountID = 'account_here'

---

• Push Green arrow and then push to blue arrow!
• Close Query Analyzer and don't save file!

SECOND WAY:

• Open Query Analyzer!
• Select User SA and write your password!
• Download SQL SCRIPT from here -> RapidShare: 1-Click Webhosting
• Change database from Master to MuOnline!
• Select File -> Open!
• Open downloadet SQl Script file!
• Push Green arrow and then push to blue arrow!
• Close Query Analyzer and don't save file!

Now you hawe script witch automaticly ban users with copied items!
Dont forget! SQL Server Agent Must be runned or script will be not working!

Good script but what about if a duper trade a duped item to a commoner ?

This is work for new db 0.99.88T, 1.00.16 etc..?

this is a trigger antidupe. is old and in server with more than 90 online players LAG and impossible open characters and vault.

i recommend log analises for find users dupers:

error-L3 with pTransaction(1) is a really dupe.

in my server, users with more than 3 lines i BAN.

Very Good Script!

1. - Script working on all versions!
2. - Script is modificied by me and dont hawe lags when connecter meany peoples!
3. - Script automaticly find duped items and ban that user!No mather are his duper or not! If they hawe duped items,they will be baned!

Sorry My English,I just now Wakeup!

so works with no problems in 1.00.16? and no lags?

This is old script,but i modificed it! So you can use it for random versions! Its works 100% and don't hawe any lags on server! It's tested by me!

Quote:

---

Originally Posted by BlackEye

This is old script,but i modificed it! So you can use it for random versions! Its works 100% and don't hawe any lags on server! It's tested by me!

---

its impossible to work for all versions.. 1.02N and s2 servers have other item coding

& How to remove this script :| .
Sr my bad english

Its not good script !!! If one noob fast duped much kundun box and droping another noob picki up items and all have blocked :( Soo need edit script ! its not good..

i will check script,maby something i can do!

That script is useless since it's highly NOT recommended to be used in big servers.As mentioned above if your server has more than 60-70 users then you are f*cked up ^^ Your CPU usage will be increased dramatically and whole server will lag...

So...to be used in a small server like 20-30 people? ^^ Useless because such servers don't stay alive for more than 2-3 months :)

Quote:

---

Originally Posted by LifeStealer

That script is useless since it's highly NOT recommended to be used in big servers.As mentioned above if your server has more than 60-70 users then you are f*cked up ^^ Your CPU usage will be increased dramatically and whole server will lag...

So...to be used in a small server like 20-30 people? ^^ Useless because such servers don't stay alive for more than 2-3 months :)

---

Werry interesting,but then why i use this script and on server playing more than 90 peoples!
CPU usage is 2-10%!
Server has no lags!
Script works fine!!! :construct

BlackEye script by bater if scan faster and not block login but first put disconnect and then block... :)

This Script Ban all chars when use command to change extra Vault (/ware)

Is there a way to use this script without the ban chars using this command?

yah he is right how to use this script without the ban chars i use this command how?

anyone know how remove this shit?

Its not shit but need edit this script ! how Ramove this ? Simple go in Msql
MuOnline Stored Procedures --> find WZ_GetItemSerial click and paste this:


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

Quote:

---

Originally Posted by sawiukas

Its not shit but need edit this script ! how Ramove this ? Simple go in Msql
MuOnline Stored Procedures --> find WZ_GetItemSerial click and paste this:


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

---

This script above serves to put what?

its standart of 97 ver mb and another but dont no 100%

i paste this and it help

drop trigger [dbo].[trg_CheckSameID] GO

BlackEye : nice script works fine, but i wanted only to scan excellent items, what do i need to modify

how can i cancel it?!! anyone please :[[[
all my chars in server is banned
i even open account in my friend house
made char..re enter then he ban too
its bugged for me
please how cancel it

this is not your script .. script exist from 2005 :bad::bad:

Quote:

---

Originally Posted by drorking57

how can i cancel it?!! anyone please :[[[
all my chars in server is banned
i even open account in my friend house
made char..re enter then he ban too
its bugged for me
please how cancel it

---

if that was did maybe all of you player are duper...

It's good sctiptu on sersion 97d?

How i edit the script to disconnect the player who is doing dupe automatic , ? :thumbup1:

How cand i remove this script? Who cand help me? 10x

Quote:

---

Originally Posted by $efu_SM

How cand i remove this script? Who cand help me? 10x

---

Some wan? :/:

Who cand edit this scripr or how cand i edit his script to bann users and disconnect them from the game when the dupe is maid ? When de dupe is maid and the script detect team tu block caracter and disconnect automatic from the server tu can not transfer them or sell them . Poate cineva sa il editeze asa ?Can someone edit ?

Where I see all the characters blocked by this script? And date and time they were blocked?

Hello..

I am Sorry for i am bump that post
but i get problem with that script
it is banned even my charcter it is realy bad script
pliz if someone can give me script to dellete that
i will be thanks full
have a nice day

BARAMOS
NewAgeMU.com.nu
MUnewage.com.nu