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 20:12

  • 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: 83
Received Thanks: 124
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.

Use with betaalfa's releases

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
13 Users
Old   #2
 
elite*gold: 0
Join Date: Dec 2016
Posts: 64
Received Thanks: 24
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   #3
 
elite*gold: 0
Join Date: Nov 2017
Posts: 83
Received Thanks: 124
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
3 Users
Old   #4
 
elite*gold: 0
Join Date: May 2018
Posts: 10
Received Thanks: 0
*** job! Thank you.


Brownback is offline  
Old   #5
 
elite*gold: 0
Join Date: Nov 2017
Posts: 83
Received Thanks: 124
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  
Old   #6
 
elite*gold: 0
Join Date: May 2018
Posts: 10
Received Thanks: 0
Quote:
Originally Posted by XareL View Post
if you want to thank me you can press thank you button

Already ^_^


Brownback is offline  
Reply

Tags
developer, non-tradeable items, shaiya, shaiyaepvp



« Previous Thread | Next Thread »

Similar Threads
[HELP] Start items tradeable a non tradeable item!
Anyone help me to make started item tradeable to non tradeable ? :confused:
4 Replies - SRO PServer Ask the Experts
[Tuturial]Trading non-tradeable items tradeable without Item.SDATA
Hello :p I'm making this release We can trade non-tradeable items tradeable. Steps 1] Open Shaiya Packet Editor
13 Replies - Shaiya Hacks, Bots, Cheats & Exploits
[REQUEST] Non-tradeable item to tradeable
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...
5 Replies - Shaiya Private Server
Make a non tradeable a tradeable item
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
21 Replies - Shaiya
RO2 Non Tradeable Item to Tradeable Item
:) Share it
3 Replies - Ragnarok Online



All times are GMT +2. The time now is 20:12.


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.