[Release] Duped Item Finder

Mortred

Active Member
Joined
Jun 11, 2008
Messages
646
Reaction score
182
ENG:
This program Deletes all duped items found on a character,inventory or vault
Just run the dupefinder.exe and it will delete all duped items


BG:Тая програма намира всички дупени итеми.Отворете dupefinder.exe то почва да сканирва.След сканирването автоматично се трият дупените итеми.


Click Here To Download
 

MorgaN

New Member
Joined
Apr 23, 2008
Messages
708
Reaction score
101
and one more i have test one dupe i make ring +9 and dont delete it :(
 

RhysFox

New Member
Joined
Jun 30, 2008
Messages
918
Reaction score
298
Even if it doesn't delete them automatically its better. Because there is a lot of pleasure deleting the items yourself (rofl).
 

MorgaN

New Member
Joined
Apr 23, 2008
Messages
708
Reaction score
101
and how i delete the dupe items and were xd :headbang:
 

RhysFox

New Member
Joined
Jun 30, 2008
Messages
918
Reaction score
298
The Dupe Finder should show you in which account and which chars are the duped items, then you enter your MuEditorv2.1 or whatever, and you use it to delete the items. Or just make a test run... go dupe some items make a test run and make a Screen Shot and show me :yes:.
 

KR373N

Well-Known Member
Joined
May 18, 2008
Messages
1,944
Reaction score
445
Няма ли някой скрипт направо ?

ето ти

PHP:
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
 
  • Like
Reactions: airotica

Lesh0

New Member
Joined
Apr 22, 2008
Messages
705
Reaction score
89
Тоя скрипт с qa ли се слага ? и какво прави делва дупените предмети или банва ацц-то ??
 

JusTFucK

New Member
Joined
Jun 26, 2008
Messages
64
Reaction score
4
Нз ама не ти го препоръчвам. Всички се оплакваха от огромен лаг докато бях с него.
 

aLegRo0

New Member
Joined
Aug 20, 2008
Messages
419
Reaction score
22
искъм некаф скрипт за блок на херото и залепяне на итемите ..
 
Thread starter Similar threads Forum Replies Date
D [Release] Item Upgrade Warehouse Releases 8
DemonuMu [Release] ExTeam Season 2 Episode 4 + Custom Items,Quests,Commands & Stable +Sources Releases 2
D [Release] Item Upgrade Beta Releases 11
L [Release] ExTeam Season 4 Ep 6 FULL + Stable AntiCheat, DDos, Customs, New Item Releases 9
R [Release] Main 1.0m + Glow + Support for new items & Textures + Cam3D + Minimizer Releases 6
A [Release] MBT-MuServer 97d+New Items+Custom+All Updates Releases 8
L [Release] MuServer 1.06a Files S4 + 166 New Items Running 100% Releases 3
C [Release] ExTeam Season 2 Episode 4 + [Custom Items.Quests.Commands] Stable +Sources Releases 4
eNyce [Release] Repack TT 11.70.52 + Custom Item Releases 5
K [Release] Effect of items Releases 2
Angerfist [Release] Rage Fighter Items/Skills Shop Codes Releases 0
D [Release] S6 Ep3 with Custom Items Releases 4
freeruner [Release] 97d99i Pack Monstersetbase, Shops, Eventitembag) all rates: easy/normall/h Releases 6
freeruner [Release] Пакет: Shops , Eventitembag , Monstersetbase for 97d Releases 17
miroslavcc [Release] MuMaker All Items Season 6 Releases 1
suh1q [Release] Good Eventitembags for 97d99i Releases 0
f0und [Release] MuServer S4 Files [1.06a] + 166 New Items Releases 17
Dungeon [Release] DarksTeam MuServer 97d99i - New Items Releases 53
bacardi [Release] Titans Tech 10.07.65 Season 6 + Custom Items Releases 44
L [Release] Glow Editor With 500+ Custom items Releases 2
L [Release] Reset with items Script [ XTYLING WEB ] Releases 2
Victtorio [Release] EliteMu Old Web Releases 27
fantoma4u [Release] Glow Editor With 500+ Custom items Releases 9
EminescuX [Release] Boxs Eventitembags for S3 Ep2 by EminescuX Releases 0
crazyboy [Release] R.F. Items Query For S-y WebShop Releases 7
Dungeon [Release] MuServer 1.04x + 95 New items Releases 8
Dungeon [Release] Season III Episode I + New Item + 3D Camera Releases 22
Dungeon [Release] MuServer 1.05 + eDataServer + Wings S4 + Items Releases 10
Dungeon [Release] MuServer 1.04h [ Season3 ] + 80 New Items Releases 33
L [Release] MuServer 97d99i+New Items Releases 59
B [Release] Eventitembags for 99.62T Releases 0
B [Release] MuServer 97d + Season 3 and 4 Items Releases 111
kocebs [Release] WebShop items S4 for sql 2008 Releases 3
Dungeon [Release] MuServer 97d99i + 52 new items + 2 maps Releases 30
Shatter [Release] WZItemShopServer 1.0.1.4 Releases 6
Dungeon [Release] MuServer 97d99i + 28 New items Releases 23
Dungeon [Release] MuMaker Season 5 + New items Releases 8
suh1q [Release] 97d99i Eventitembags Releases 5
Dungeon [Release] EventItemBag Editor + Updates Releases 7
DarkMaster [Release] 99b Main + AntiHack & 100+ Items Support Releases 20
Man1aK [Release] Map Codes, Shops, Eventitembags Releases 10
MorgaN [Release] Box of Kundun fixed s2 s3 items Releases 1
clamp [Release] MBT MuServer 97d99i + New Items & Customs Releases 189
RhysFox [Release] EventitemsBags for 97d99i and other Releases 4
parsy [Release] Season 4 items for 1.04J and 1.04X (Not Skin) Releases 13
Gasolincho [Release] Good event_bok items for Season III Releases 7
oovan [Release] Dupe Finder Releases 17

Similar threads