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
Kindly , your help would be appreciated
How to change the trade reward
11/24/2015 09:35
deathcode2#1
11/27/2015 23:21
Chiliad#2
Not possible. NPC's are only hardcoded to buy items for gold.
11/28/2015 23:59
Vxo#3
Its true but you can give job points by trading :)Quote:
Not possible. NPC's are only hardcoded to buy items for gold.
11/29/2015 06:03
Chiliad#4
You could, But i dont recommend any procedure based system...Quote:
11/30/2015 18:21
phrenesisSRO#5
is hard to add new money
12/10/2015 12:41
deathcode2#6
Yes that's what i need to do . so is there any expert who can post the procedure code regarding this ?Quote:
12/12/2015 13:55
Pavo xD#7
you can check at youtube will get more info about change rate
12/13/2015 13:02
BadSorrow#8
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.
You need to use query for add reward automatic (with tp).
You need to add many more item etC.. for full work :/
12/13/2015 16:51
gmroske#9
Can You help me i Need Trade Give Gold at my Server + Expen
12/14/2015 02:28
spinal2#10
You need to create new money, to edit all buy/send money.Quote:
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 :/
Possible? to use it coded in _refpriceofpolice like same 'GOLD = 1 - Silks = 2 Coins = 1024 , 512 .......
Actually only see used changing existings money type ..
Follow :Quote:
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
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
* 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
12/16/2015 19:28
tx2013#11
first.Quote:
Kindly , your help would be appreciated
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
12/17/2015 13:33
Exo#12
@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 crap xD He wrote it again for reasons ofc, it's messy and hard to config.
09/24/2016 21:32
Dev.L0RdReVaN#13
what did u mean i have to change priceQuote:
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
can u explain please