Printable View
I want querys for this ratess
SoX Drop Rate x1
Alchemy Rate x1
Magic POP: 1x
Job rate: 10x
and offsets of GameServer rates:
EXP & SP Rate: 70x
Party EXP Rate: 70x
Drop Rate: 70x
Gold drop Rate: 30x
And I want mobile donating system
and want make FTW [Saturday 18:00 - 19:30 GMT+0.00]
I know in SMC but i don't know how...
and want to make my ftw working 100% hotan-bandit-jangan what is codes for doors unqiues etc..
with this rate if you will have 50 player you will be a king :)
trade rate are not rate but ye nob call rate is only sell price rize
you can get all these Information when you know how use this Forum
Greetz
Thats alot of request, let's start one by one and see if those works for you.
SoX Drop Rate x1 - do not know the official drops, but you can assign drops with the rate you want individually. Go Here
Alchemy Rate, magic POP, Job Rate, please use the search button. There's ton of tutorial I've used included Gameserver rates. Note that gold rate has to be edit on database and not server.cgi.
If you can't seem to find them, let me know and I'll post the link for ya.
For FTW and donating system, see if other can help with that as I don't use that feature. I rarely have anybody on my server. Just myself testing to get experience.
Sox drop rate :
USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 1 -- Here we set the multiplier value! Default: 10
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE
alchemy rate ( not sure how many x )
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134944072' where ID='2044'
MAGIC POP RATE :
USE [SRO_VT_SHARD]
GO
/* MsSQL Script For Change Magic Pop Rates - CEZALAND - ! ******** ! */
DECLARE @Rate int
SET @Rate = 1
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint
JOB rate :
USE [SRO_VT_SHARD_INIT]
GO
UPDATE dbo._RefObjCommon
SET Price = 383*10
WHERE Price = 383
UPDATE dbo._RefObjCommon
SET SellPrice = 191*10
WHERE SellPrice = 191
UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*10
WHERE Cost = 383
don't forget to set itemdata in media.pk2 aswell
If you want to change the game server you must look @ server.cfg ( same folder as the game server )
i hope i helped you a bit :)
I love you ^^
thanks very very very very much ^^
But when i execute this USE [SRO_VT_SHARD_INIT]
GO
UPDATE dbo._RefObjCommon
SET Price = 383*10
WHERE Price = 383
UPDATE dbo._RefObjCommon
SET SellPrice = 191*10
WHERE SellPrice = 191
UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*10
WHERE Cost = 383
I got 0 rows effected...
I make sure i write correct DB Name don't worry about that...
Quote:
Originally Posted by RenePunik
Oeps :P uhmm something went wrong it should be USE [SRO_VT_SHARD]
don't know if you changed it ?