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
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 :/
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
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
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
@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.
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
[Request] How to change job reward. 08/14/2015 - SRO Private Server - 1 Replies i need to know how to change job reward like taking a trade from town to town thief stole trade reward hunter deliver trade reward need to add coins to them all
Change Trade Reward 04/15/2015 - SRO Private Server - 9 Replies i want add coin with gold in trade Thanks
[Exploit]S4 Job Change Mission Reward 02/04/2014 - Grand Chase Hacks, Bots, Cheats & Exploits - 77 Replies sorry about the title to prevent early detection and patch
the title supposed to be
JOB Change Mission BUG
Wanna have Free GC NECKLACE for 1 day and free limited Character Specific JOB AVATAR ARMOR SETS like, alchemist, PK, DA etc.. and a +10 BAG for free
how?
change the Lv. Reward caps. 06/03/2013 - S4 League - 1 Replies so we have the Id's
4031071 Lv.1 Reward Capsule
4031072 Lv.4 Reward Capsule
4031073 Lv.5 Reward Capsule
4031074 Lv.7 Reward Capsule
4031075 Lv.8 Reward Capsule
4031076 Lv.10 Reward Capsule
4031077 Lv.11 Reward Capsule
4031078 Lv.12 Reward Capsule
[TUT] Change Job reward rates, 10/28/2011 - SRO PServer Guides & Releases - 12 Replies _RefShardContentConfig table in SRO_VT_SHARD, nothing more nothing less.. there's korean characters translate them in google you'll understand what is what :)
