this doesnt work on 99B+ and chaos goblin dupe method.
Printable View
this doesnt work on 99B+ and chaos goblin dupe method.
Imao is there a goblin dupe method ? i havent know about any stuff like that .
it works. caught many dupers :thumbup:
but i need help, what's the code if i want to empty the duper's vault?
in the i posted
change the
update warehouse set pw=5555 where ....
to
update waehouse set pw=5555, items=null where ....
thanks a lot john_d :)
Damn.. this is crazy.. it is really slowing everything down.
i suggest we make a better more optimze one.
lol same here.. when i run the second trigger,... bang! craches my system. but the first one is doing great.
first is also lagging.. with 500 people online it almost impossible to login.. .
lag is thing must be happening cos' these trigger will use a great deal of server's resources( loop effect)
also a bug is found.. it doesnt really stop duping..
it bans the people who buy dupe items.. hehehe.. wat about the real dupers.
yes in 99B+ its ral easy to dupe using the chaos goblinQuote:
Originally Posted by 2SeXy
about the dupe using chaos goblin, can you explain further?
don't explain the metod, or the noob's will see it, than they will dupe.
sigh... so this trigger is still useless?Quote:
Originally Posted by john_d
a way to over do is..
do a trade-drop-dupe-bug.. then dont pick up item.. give it let some1 pick up the drop dupe item.. then go sell it.. hehehe
bang the person who bought it .. is caught.. lolz
Hi, I have tested in 99b+ and this trigger (the first one) works. When the char terminates the dupe process, the vault is locked, and (in my case) the account was blocked. My players when discover they have been caught imediatelly sell the item in inventory and come to me to tell me they lost the pw from warehouse :DQuote:
Originally Posted by phillips41
Poor kids !!!
With the vault locked they can't do nothing with the duped item. And now the account is blocked and I dont unblock this type of player.
But, the trigger this surely works !
nice man, this trigger is good to smal servers, were there isen't much players, wen there are a lot of players, it will cause the lag that john_d said.
so, u say is good for small server with how many acc's?
Corect my mistake plzz
i use Query analyzer and here is script
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 (0) 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
--???????????????ID??
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
and here is mistake
Server: Msg 170, Level 15, State 1, Procedure trg_CheckSameID, Line 59
Line 59: Incorrect syntax near 'END'.
so whats wrong help me plzz !
it work for me how do i unlock the vault?
dissel: update warehouse set pw = '' where AccountID = 'account_here'
thanks nkerzQuote:
Originally Posted by nkerz
-- this is wer u can add more punishment like ban or lock characters
UPDATE warehouse SET pw=5555 WHERE accountid=@al_acid
when i put 5555 in vault code the password is incorrect. and il check in the database warehouse to check the password its 5555 also. what is the error ?
and when i use the script?
the dataserv 1 error
SQLSTATE:2400, diagnosis:[Microsoft]ODBC SQL Server Driver]invalid cursor staGeQuevedCompletaionStatus failed with error 64
pls help!!!
when u say "password is incorrect" u mean in game? u r trying to unlock vault?
Tem que rodar diariamente esse script ou uma vez somente?
Start this script only 1 or every day?
What if they can only use the chaos goblin dupe method in a non-trade server? When they log out to go into the trade server, will their dupe be caught? Just trying to think around the problem... legit players getting blocked is NOT an option :eh:Quote:
Originally Posted by john_d