Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
You last visited: Today at 07:54

  • Please register to post and access all features, it's quick, easy and FREE!


[FIX]Non-Tradeable Items Trade/Drop/Battle

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2017
Posts: 117
Received Thanks: 216
Arrow [FIX]Non-Tradeable Items Trade/Drop/Battle

hi epvpers,
I can say that I am trying to do something now and
now I am trying to solve or understand something

I tried to wrote a script,test results can be said to work very well.



this script , non-tradeable items blocking by server.
i tried to fix all ways , Trade,Drop,Battle.
when u trading non-tradeable items ,account kicking and in 20 seconds trying trading items delete then 30 second blocking account

If you want to change ReqOg "0" from item.sdata still blocking.



it is still in development stage


Firstly Create Tables ;

and then insert PS_GameLog > Stored Procedures > usp_Insert_Action_Log_E

Quote:
--------------NON-TRADEABLE -NORMAL ITEMS DROPS LOG----------

IF (@ActionType = 112 AND @Text2 LIKE '%Option%')
BEGIN
IF EXISTS (SELECT ItemID FROM PS_GameDefs.dbo.Items WHERE ItemID = @Value2 AND ReqOg='1')
BEGIN
INSERT INTO Non_TradeableItemsDropLogs VALUES (@UserID,@CharName, @Value2, @Text1, @ActionTime)
UPDATE PS_UserData.dbo.Users_Master SET [Status]=-2 WHERE [email protected]


DECLARE @return_value int
SET @CharID = (SELECT top 1 CharID FROM PS_GameData.dbo.Chars WHERE Charname = @CharName)

DECLARE @DropLog varchar(max) = N'/kickcn ' + @CharName

SET @return_value ='0'
EXEC @return_value = PS_GameDefs.[dbo].[Command]
@serviceName = N'ps_game',
@cmmd = @DropLog

WAITFOR DELAY '00:00:59'
UPDATE PS_UserData.dbo.Users_Master SET [Status]=0 Where [email protected]

END
END

-------------------------------------------------END

--------------NON-TRADEABLE -NORMAL ITEMS TAKE LOG----------

IF (@ActionType = 111 AND @Text2 IS NULL)
BEGIN
IF EXISTS (SELECT ItemID FROM PS_GameDefs.dbo.Items WHERE ItemID = @Value2 AND ReqOg='1')
BEGIN
INSERT INTO Non_TradeableItemsTakeLogs VALUES (@UserID,@CharName,@Value1,@Value2,@Text1,@Value3, @ActionTime)
UPDATE PS_UserData.dbo.Users_Master SET [Status]=-2 WHERE [email protected]

SET @CharID = (SELECT top 1 CharID FROM PS_GameData.dbo.Chars WHERE Charname = @CharName)

DECLARE @TakeLog varchar(max) = N'/kickcn ' + @CharName

SET @return_value ='0'
EXEC @return_value = PS_GameDefs.[dbo].[Command]
@serviceName = N'ps_game',
@cmmd = @TakeLog

WAITFOR DELAY '00:00:15' --- For the full confirmation of the account and the data
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID AND ItemUID = @Value1

WAITFOR DELAY '00:00:20' --- Account block in 20 second
UPDATE PS_UserData.dbo.Users_Master SET [Status]=0 Where [email protected]


END
END
-------------------------------------------------END

--------------NON-TRADEABLE -BATTLE ITEMS TAKE LOG----------

IF (@ActionType = 118)
BEGIN
IF EXISTS (SELECT ItemID FROM PS_GameDefs.dbo.Items WHERE ItemID = @Value2 AND ReqOg='1')
BEGIN
INSERT INTO Non_TradeableItemsBattleLogs VALUES (@UserID,@CharName,@Value1,@Value2,@Text1,@ActionT ime)
UPDATE PS_UserData.dbo.Users_Master SET [Status]=-2 WHERE [email protected]

SET @CharID = (SELECT top 1 CharID FROM PS_GameData.dbo.Chars WHERE Charname = @CharName)

DECLARE @VSLog varchar(max) = N'/kickcn ' + @CharName

SET @return_value ='0'
EXEC @return_value = PS_GameDefs.[dbo].[Command]
@serviceName = N'ps_game',
@cmmd = @VSLog

WAITFOR DELAY '00:00:15' --- For the full confirmation of the account and the data
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID AND ItemUID = @Value1

WAITFOR DELAY '00:00:20' --- Account block in 20 second
UPDATE PS_UserData.dbo.Users_Master SET [Status]=0 Where [email protected]

END
END


--------------NON-TRADEABLE -NORMAL ITEMS TRADE TAKE LOG----------

IF (@ActionType = 115)
BEGIN
IF EXISTS (SELECT ItemID FROM PS_GameDefs.dbo.Items WHERE ItemID = @Value2 AND ReqOg='1')
BEGIN
INSERT INTO Non_TradeableItemsTradeTakeLogs VALUES (@UserID,@CharID,@CharName,@Value1,@Value2,@Text1, @Value4,@ActionTime,@Text2)
UPDATE PS_UserData.dbo.Users_Master SET [Status]=-2 WHERE [email protected]

SET @CharID = (SELECT top 1 CharID FROM PS_GameData.dbo.Chars WHERE Charname = @CharName)

DECLARE @TradeTake varchar(max) = N'/kickcn ' + @CharName

SET @return_value ='0'
EXEC @return_value = PS_GameDefs.[dbo].[Command]
@serviceName = N'ps_game',
@cmmd = @TradeTake

DECLARE @ItemDelete int
SET @ItemDelete = (SELECT top 1 ItemID FROM PS_GameLog.dbo.Non_TradeableItemsTradeTakeLogs WHERE [email protected] ORDER BY Date DESC)


WAITFOR DELAY '00:00:20' --- Account block in 30 second
UPDATE PS_UserData.dbo.Users_Master SET [Status]=0 Where [email protected]
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID AND [email protected]

END
END
-------------------------------------------------END
Regards,



XareL is offline  
Thanks
16 Users
Old 05/18/2018, 01:53   #2
 
elite*gold: 0
Join Date: Dec 2016
Posts: 119
Received Thanks: 38
This mean if i trade an "non tradable " item game will kick me and delete item?

Even if i use injector to trade item ?!


[ADM]Beno™ is offline  
Old 05/18/2018, 12:28   #3
 
elite*gold: 0
Join Date: Nov 2017
Posts: 117
Received Thanks: 216
Arrow

Quote:
Originally Posted by [ADM]Beno™ View Post
This mean if i trade an "non tradable " item game will kick me and delete item?

Even if i use injector to trade item ?!
Use the cheat you want as this server triggers. ReqOq value of 1 will get dc
XareL is offline  
Thanks
4 Users
Old 06/10/2018, 16:41   #4
 
elite*gold: 0
Join Date: May 2018
Posts: 13
Received Thanks: 2
*** job! Thank you.


Brownback is offline  
Old 06/11/2018, 03:33   #5
 
elite*gold: 0
Join Date: Nov 2017
Posts: 117
Received Thanks: 216
Quote:
Originally Posted by Brownback View Post
*** job! Thank you.
if you want to thank me you can press thank you button

XareL is offline  
Thanks
2 Users
Old 06/11/2018, 17:20   #6
 
elite*gold: 0
Join Date: May 2018
Posts: 13
Received Thanks: 2
Quote:
Originally Posted by XareL View Post
if you want to thank me you can press thank you button

Already ^_^
Brownback is offline  
Thanks
1 User
Old 07/27/2018, 08:26   #7
 
elite*gold: 0
Join Date: Sep 2016
Posts: 30
Received Thanks: 4
PS_GameDefs.[dbo].[Command] dosen't exists. The procedure is in OMG_GameWeb.
Nix27 is offline  
Old 07/27/2018, 16:38   #8
 
elite*gold: 0
Join Date: Nov 2017
Posts: 117
Received Thanks: 216
Quote:
Originally Posted by Nix27 View Post
PS_GameDefs.[dbo].[Command] dosen't exists. The procedure is in OMG_GameWeb.
firstly you need to make adjustments
XareL is offline  
Thanks
2 Users
Old 07/27/2018, 20:25   #9
 
elite*gold: 0
Join Date: Sep 2016
Posts: 30
Received Thanks: 4
Quote:
USE [OMG_GameWEB]
GO
--lets create the procedure, run this:
CREATE PROCEDURE [dbo].[Command]
@serviceName NVARCHAR (4000), @cmmd NVARCHAR (4000)
AS EXTERNAL NAME [PSMagent].[StoredProcedures].[Command]

but the procedure is created in OMG_GameWEB.
Nix27 is offline  
Old 07/27/2018, 21:52   #10
 
elite*gold: 0
Join Date: Nov 2017
Posts: 117
Received Thanks: 216
Quote:
Originally Posted by Nix27 View Post
but the procedure is created in OMG_GameWEB.
If you do not know how to change it,you better do not for yourself
XareL is offline  
Thanks
1 User
Old 07/27/2018, 22:06   #11
 
elite*gold: 0
Join Date: Sep 2016
Posts: 30
Received Thanks: 4
Quote:
Originally Posted by XareL View Post
...
It works perfectly


Nix27 is offline  
Reply

Tags
developer, non-tradeable items, shaiya, shaiyaepvp



« [Release]League of Legends Map (Jungle) | Shaiya Remake | [RELEASE]PS_LOGIN WITHOUT EXPLOITS »

Similar Threads
[HELP] Start items tradeable a non tradeable item!
11/02/2015 - SRO PServer Ask the Experts - 4 Replies
Anyone help me to make started item tradeable to non tradeable ? :confused:
[Tuturial]Trading non-tradeable items tradeable without Item.SDATA
02/16/2015 - Shaiya Hacks, Bots, Cheats & Exploits - 13 Replies
Hello :p I'm making this release We can trade non-tradeable items tradeable. Steps 1] Open Shaiya Packet Editor
[REQUEST] Non-tradeable item to tradeable
09/07/2013 - Shaiya Private Server - 5 Replies
Hi, I have an item that is currently non-tradeable and would like to pass it to another one of my toons. Is this possible nowdays? And if it is could someone help me to do it or point me in the right direction so i can work out how? Thanks if you can help me :)
Make a non tradeable a tradeable item
06/09/2013 - Shaiya - 21 Replies
Hi all i play Shaiya Portuguese from aeria and some items are not tradeable i wanna know if any hack can make them tradeable. Tyvm
RO2 Non Tradeable Item to Tradeable Item
04/15/2013 - Ragnarok Online - 3 Replies
:) Share it



All times are GMT +1. The time now is 07:54.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.