Newbie Spellweaver
- Joined
- Aug 22, 2014
- Messages
- 68
- Reaction score
- 19
Hey folks,
I wanna release a simple version of my anti cheat query (no error handlers etc).
Query description:
on trader goods pickup the query check if the character is thief and his location is in town while he pick up
if so then the item he picked up get removed. (takes effect after teleport).
Tutorial:
-Add this query to the bottom of your _AddLogItem procedure.
Don't remove the header comment!
Press thanks if you use this query!
I wanna release a simple version of my anti cheat query (no error handlers etc).
Query description:
on trader goods pickup the query check if the character is thief and his location is in town while he pick up
if so then the item he picked up get removed. (takes effect after teleport).
Code:
/**_# TriJob Anti Cheat by Syloxx (simple)*/
IF @[I][B][URL="http://forum.ragezone.com/members/2000154287.html"]operation[/URL][/B][/I] = 144
BEGIN
DECLARE @JobType tinyint
, @IsBattleField bit
, @ItemID int
SELECT @JobType = CTJ.JobType
, @IsBattleField = R.IsBattleField
FROM SRO_VT_SHARD.dbo._Char C
INNER JOIN SRO_VT_SHARD.dbo._CharTriJob CTJ ON C.CharID = CTJ.CharID
INNER JOIN SRO_VT_SHARD.dbo._RefRegion R ON C.LatestRegion = R.wRegionID
WHERE C.CharID = @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID
IF @JobType = 2 AND @IsBattleField = 0
BEGIN
SELECT @ItemID = ID64
FROM SRO_VT_SHARD.dbo._Items
WHERE Serial64 = @ItemSerial
UPDATE SRO_VT_SHARD.dbo._InvCOS
SET ItemID = 0
WHERE ItemID = @ItemID
/*
INSERT INTO _AntiCheatLog
VALUES @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID, @ItemSerial, GETDATE())
*/
END
END
Tutorial:
-Add this query to the bottom of your _AddLogItem procedure.
Don't remove the header comment!
Press thanks if you use this query!