How to change the trade reward

deathcode2 · 11/24/2015, 09:35

i want to change the trade reward to give job point beside the gold when i going to sell my good at the NPC . Any idea out there ?
Kindly , your help would be appreciated

Chiliad · 11/27/2015, 23:21

Not possible. NPC's are only hardcoded to buy items for gold.

Vxo · 11/28/2015, 23:59

Quote:

Originally Posted by Chiliad

Not possible. NPC's are only hardcoded to buy items for gold.

Its true but you can give job points by trading

Chiliad · 11/29/2015, 06:03

Quote:

Originally Posted by Vxo

Its true but you can give job points by trading

You could, But i dont recommend any procedure based system...

~~phrenesisSRO~~ · 11/30/2015, 18:21

is hard to add new money

deathcode2 · 12/10/2015, 12:41

Quote:

Originally Posted by Vxo

Its true but you can give job points by trading

Yes that's what i need to do . so is there any expert who can post the procedure code regarding this ?

~~Pavo xD~~ · 12/12/2015, 13:55

you can check at youtube will get more info about change rate

~~BadSorrow~~ · 12/13/2015, 13:02

You can change it, but is hard.

You need to create new money, to edit all buy/send money.
You need to use query for add reward automatic (with tp).
You need to add many more item etC.. for full work :/

gmroske · 12/13/2015, 16:51

Can You help me i Need Trade Give Gold at my Server + Expen

spinal2 · 12/14/2015, 02:28

Quote:

Originally Posted by BadSorrow

You can change it, but is hard.

You need to create new money, to edit all buy/send money.
You need to use query for add reward automatic (with tp).
You need to add many more item etC.. for full work :/

You need to create new money, to edit all buy/send money.

Possible? to use it coded in _refpriceofpolice like same 'GOLD = 1 - Silks = 2 Coins = 1024 , 512 .......

Actually only see used changing existings money type ..

Quote:

Originally Posted by deathcode2

Yes that's what i need to do . so is there any expert who can post the procedure code regarding this ?

Follow :

ADD IN LOG DB.

_AddLogChar

Code:

  if (@EventID = 6) -- Auto Coin Granting and Contribution resetting logout

		Begin

			Exec SRO_VT_LOG.dbo._RoyalAutoCoinGranting @CharID

		end

Execute Query .

Code:

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_RoyalAutoCoinGranting]    Script Date: 12/13/2015 11:29:35 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE procedure [dbo].[_RoyalAutoCoinGranting]  

@CharID INT 

as 



    Declare @JobType tinyint =  

    (Select JobType from SRO_VT_SHARD.dbo._Chartrijob where CharID = @CharID) 

    , @amount int

	, @amount2 int

	, @EventID        tinyint

    , @RemainGold int

	, @elixiramount int 

    , @dividerhunter bigint = 17000000

	, @dividertrader bigint = 9000000

	, @Dividercontrthiefs bigint = 5000

	, @dividerthiefs bigint = 100000

	, @dividerhunterex bigint = 3000000

	, @dividertraderex bigint = 3000000

	, @dividerthiefsex tinyint = 3000000

	, @Charname varchar(30) = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID) 

    , @contribution int = (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) 

    , @contribution15 int = (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID)
	
	, @contribution2 int

	, @contribution3 int

	, @contribution4 int

	, @charname16 varchar(16)

	, @kills int; 





If (@JobType = 1 ) 

 begin  

        set @contribution = 

            (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) 

        set @Charname = 

            (select CharName16 from SRO_VT_SHARD.dbo._CharNameList where CharID = @CharID) 

        set @charname16 = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] where CharID = @CharID)

	    Set @Amount = 

            (select ROUND(@contribution/@Dividertrader,0)) 

		    Set @amount2 = 

            (select ROUND(@contribution/@Dividertrader/20,0)) 



             

    if @amount >= 1 

     begin 

	    Exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @Charname,'ITEM_ETC_ARENA_COIN', @amount,0
		

        Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) 

        Values (@CharID,@amount,GETDATE()) 

		 
		



        UPDATE SRO_VT_SHARD.dbo._CharTriJob SET Contribution = 0 WHERE CharID = @CharID 
	END
     End  

 end 

-- Hunter 

If (@JobType = 3 ) 

 begin  

        set @contribution = 

            (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) 

        set @contribution4 = @contribution*1.5

		set @Charname = 

            (select CharName16 from SRO_VT_SHARD.dbo._CharNameList where CharID = @CharID) 

        set @charname16 = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] where CharID = @CharID)

		Set @Amount = 

            (select ROUND(@contribution/@Dividerhunter,0)) 

		Set @amount2 = 

            (select ROUND(@contribution/@Dividerhunter/20,0)) 


             

    if @amount >= 1 

     begin 

        Exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @Charname,'ITEM_ETC_ARENA_COIN', @amount,0 
		


		Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) 

        Values (@CharID,@amount,GETDATE()) 
		
        UPDATE SRO_VT_SHARD.dbo._Char SET RemainGold = RemainGold+@contribution4 WHERE CharID = @CharID 


		UPDATE SRO_VT_SHARD.dbo._CharTriJob SET Contribution = 0 WHERE CharID = @CharID 

     End  
	 END
 end 


 --Now for thiefs 



If (@JobType = 2 ) 

 begin  

        set @RemainGold = 

            (select RemainGold from SRO_VT_SHARD.dbo._Char where CharID = @CharID) 

		set @contribution = 

            (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) 

        set @contribution2 = @contribution15*800
		
			set @charname16 = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] where CharID = @CharID)

		set @Charname = 

            (select CharName16 from SRO_VT_SHARD.dbo._CharNameList where CharID = @CharID)
					
        Set @Amount = (select ROUND(@contribution/@Dividerthiefs,0)) 

		Set @amount2 = (select ROUND(@contribution/@Dividerthiefs/15,0)) 



     if @amount >= 1

     begin 

	    exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @Charname,'ITEM_ETC_ARENA_COIN', @amount, 0;
		

		Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) 

        Values (@CharID,@amount,GETDATE()) 

	

        UPDATE SRO_VT_SHARD.dbo._Char SET RemainGold = RemainGold+@contribution2 WHERE CharID = @CharID 
	
	
		UPDATE SRO_VT_SHARD.dbo._CharTriJob SET Contribution = 0 WHERE CharID = @CharID 

     End  
	 END

 end

EXPLANATION

* If (@JobType = 1 ) - TRADERs

* If (@JobType = 2 ) - THIEFs

* If (@JobType = 3 ) - HUNTERs

exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @Charname,'ITEM_ETC_ARENA_COIN', @amount, 0;

* COMAND TO REWARD PLAYER

* ITEM REWARD - CAN BE TRADED as You LIKE

Created Tablet

Code:

USE [SRO_VT_LOG]
GO

/****** Object:  Table [dbo].[RoyalCoinLogHunters]    Script Date: 12/13/2015 11:36:34 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[RoyalCoinLogHunters](
	[CharID] [int] NULL,
	[Amount] [int] NULL,
	[EventTime] [smalldatetime] NULL
) ON [PRIMARY]

GO

FINISH.

tx2013 · 12/16/2015, 19:28

Quote:

Originally Posted by deathcode2

i want to change the trade reward to give job point beside the gold when i going to sell my good at the NPC . Any idea out there ?
Kindly , your help would be appreciated

first.
First you make sure you buy costs 5 stars goods.
For example, 280 million
If the transport grid =140
so The price of each of the goods is
280000000/140/40=50000
so in _Refpricepolicyofitem cost =50000
The second step
see _Refobjcommon price and sellprice
price=cost
sellprice =Thieves robbed of money after selling the goods
You can decide to sell the goods in accordance with the thieves rob prices
third step
_ItemQuotation -BaseQuot, Quot_LB, Quot_UB exchange rate

Exo · 12/17/2015, 13:33

@spinal Well, since you keep copying stuff from that leaked old db or I don't know if that was released or w/e! Akasch stopped using that query if I remember xD It's lame, really lame, slow, buggy, and you know total **** xD He wrote it again for reasons ofc, it's messy and hard to config.

Dev.L0RdReVaN · 09/24/2016, 21:32

Quote:

Originally Posted by tx2013

first.
First you make sure you buy costs 5 stars goods.
For example, 280 million
If the transport grid =140
so The price of each of the goods is
280000000/140/40=50000
so in _Refpricepolicyofitem cost =50000
The second step
see _Refobjcommon price and sellprice
price=cost
sellprice =Thieves robbed of money after selling the goods
You can decide to sell the goods in accordance with the thieves rob prices
third step
_ItemQuotation -BaseQuot, Quot_LB, Quot_UB exchange rate

what did u mean i have to change price
can u explain please