How to remove 0 message:
Open Pk2 Extractor
Extract textuisystem.txt
Here is the path
Pk2Extractor> Media > server_dep > silkroad > textdata > textuisystem.txt
Press Ctrl+F
Search for UIIT_MSG_VIETNAM_MRSYSTEM
Then Find text
You will find this
[/CODE]
Disable alchemy materials from dropping
Change Stacks for items
Add CTF
How to change spawn place for new char
How to add items to start items
How to change Level of char
PHP Code:
Alıntıdır İngilizcedir Fakat Cok Rahat Anlıyacagınız Düşüyorum
Open Pk2 Extractor
Extract textuisystem.txt
Here is the path
Pk2Extractor> Media > server_dep > silkroad > textdata > textuisystem.txt
Press Ctrl+F
Search for UIIT_MSG_VIETNAM_MRSYSTEM
Then Find text
You will find this
Kod:
PHP Code:
1 UIIT_MSG_VIETNAM_MRSYSTEM_100 100% ?? ?????.. 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_50 50% ?? ?????. 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_0 0% ?? ?????. 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_PLAYTIME ?? %d?? %d?? ??? ????. 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_TOOLTIP_100 100% ?? ?? 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_TOOLTIP_50 50% ?? ?? 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_TOOLTIP_0 0% ?? ?? 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_OVERTIME ?? %d?? ?? ??? ????. 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_PLAYTIME_WARNING ?? %d?? %d?? ??? ????. 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_PLAYTIME_FOR_50 ?? %d?? %d?? ??? ????. 50%% ?? ?????. 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_50_WARNING ?? %d?? %d?? ??? ????. 50%% ?? ?????. 0 0 0 0 0 0 0 0 0 0 0 0 0
1 UIIT_MSG_VIETNAM_MRSYSTEM_OVERTIME_WARNING ?? %d?? ?? ??? ????. 0 0 0 0 0 0 0 0 0 0 0 0 0
You must change 1 in the first to 0
So it will be like that
[CODE]PHP Code:
0 UIIT_MSG_VIETNAM_MRSYSTEM_100 100% ?? ?????.. 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_50 50% ?? ?????. 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_0 0% ?? ?????. 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_PLAYTIME ?? %d?? %d?? ??? ????. 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_TOOLTIP_100 100% ?? ?? 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_TOOLTIP_50 50% ?? ?? 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_TOOLTIP_0 0% ?? ?? 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_OVERTIME ?? %d?? ?? ??? ????. 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_PLAYTIME_WARNING ?? %d?? %d?? ??? ????. 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_PLAYTIME_FOR_50 ?? %d?? %d?? ??? ????. 50%% ?? ?????. 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_50_WARNING ?? %d?? %d?? ??? ????. 50%% ?? ?????. 0 0 0 0 0 0 0 0 0 0 0 0 0
0 UIIT_MSG_VIETNAM_MRSYSTEM_OVERTIME_WARNING ?? %d?? ?? ??? ????. 0 0 0 0 0 0 0 0 0 0 0 0 0
Disable alchemy materials from dropping
Kod:
USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 6679 AND 5414
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 6082 AND 6371
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 10501 AND 10527
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 11499 AND 11668
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 12554 AND 12569
Kod:
First go to refobjcommon
Find the item you want to change maxstack
Like you want for elixirs
PHP Code:
ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B
You scroll and check the "Link" For it.
For example this item have link : 2029
then go to refobitem and look for 2029, You will see a row Called 'MaxStack'
Change it
then go to media.pk2
Then look for itemdata_xx
Search for this "ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B".
And change the number that exist after the xx xx and change it same to db
Example
Quote:
1 3679 ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B SN_ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B_TT_D ESC 0 0 3 3 10 1 180000 3 0 1 1 1 255 3 1 0 0 0 0 100000 0 0 0 600 20000 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_reinforce_recipe_weapon_b.ddj xxx xxx 1 2 0 0 2 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0 0 0 0 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 100663296 ?????? 841489939 1,2,3,4 286331153 5,6,7,8 286002188 9,10,11,12 0 ?????? 0 ?????? -1 xxx -1 xxx -1 xxx 1 [??] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
Where is the red "1" Change it
Kod:
Go to SMC
SR_Schedule
Click at "SCHEDULE_DEF_FLAG_WORLD_PARTICIPATION"
Choose (M) 10
And select type (01) Everydays
And make it like that
PHP Code:
3:50 ~ 4:00 (10min) 10min
5:50 ~ 6:00 (10min) 10min
7:50 ~ 8:00 (10min) 10min
9:50 ~ 10:00 (10min) 10min
11:50 ~ 12:00 (10min) 10min
13:50 ~ 14:00 (10min) 10min
15:50 ~ 16:00 (10min) 10min
17:50 ~ 18:00 (10min) 10min
19:50 ~ 20:00 (10min) 10min
21:50 ~ 22:00 (10min) 10min
23:50 ~ 24:00 (10min) 10min
Then go to "SCHEDULE_DEF_FLAG_WORLD"
And make this
flag_world - 1:55 ~ 6:21 (26min) 26min
PHP Code:
1:55 ~ 2:21 (26min) 26min
3:55 ~ 4:21 (26min) 26min
5:55 ~ 6:21 (26min) 26min
6:55 ~ 7:21 (26min) 26min
7:55 ~ 8:21 (26min) 26min
9:55 ~ 10:21 (26min) 26min
11:55 ~ 12:21 (26min) 26min
13:55 ~ 14:21 (26min) 26min
15:55 ~ 16:21 (26min) 26min
17:55 ~ 18:21 (26min) 26min
19:55 ~ 20:21 (26min) 26min
21:55 ~ 23:21 (26min) 26min
23:55 ~ 24:21 (26min) 26min
Kod:
Go to sro_vt_shard.
Programmability
Stored Procedures
Then click modify at _AddNewChar
Look at @StartPos_X
@StartPos_Y
@StartPos_Z
And change them
You can get the coords you want from your main account
Just login in ur main and stay on place you want
then go to sro_vt_shard tables
_Char table.Click open table
Look for PosX,PosY,PosZ And copy them to there
Kod:
Go to sro_vt_shard.
Programmability
Stored Procedures
Then click modify at _AddNewChar
Scroll down into you find this
Quote:
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_60EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20,1
Click Enter and add the item you want and then the second, is they amount,and then 1
Kod:
How to change Sox Drop rate:
Go to sro_vt_shard
Search for "_RefDropClassSel_RareEquip" Table
Click open table
And there you see 10 is default mean = 1x
change to 15 if you want 1.5x and so on
Query to change item mall price
Kod:
use SRO_VT_SHARD
PHP Code:
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%%'
Change XX to the price you want
Change PACKAGE_ITEM_MALL_AVATAR_M_ To the RefPackageItemCodeName you want
PHP Code:
Kod:
USE [SRO_VT_SHARD_INIT]
GO
--by Saif1999
Declare @CharName Varchar (64)
Set @CharName = 'Put your char name here'
UPDATE dbo._Char
--change 100 to the level of your char you want
SET CurLevel= 100
SET MaxLevel = 100
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
How to change HWAN level (For yellow title)
PHP Code:
USE [SRO_VT_SHARD_INIT]
GO
--by Saif1999
Declare @CharName Varchar (64)
Set @CharName = 'Put your char name here'
UPDATE dbo._Char
--change 3 to hwanlevel you want
SET HwanLevel = 3
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
How to change Stone success rate
USE SRO_VT_SHARD
GO
UPDATE _RefObjItem
SET Param4 = Put here desired rate
WHERE ID BETWEEN 4630 AND 5013
Example : if the value 70, it will be 70% etc
Son düzenleme: