Hello guys
I will share some tutorials that will help you if you have a vsro server
Lets start
-----------------------------------------------------------------------
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
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
So it will be like that
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
How to raise alchemy rate
Go to sro_vt_shard -- > Open table RefObjItem
We need ID's from 2033 to 2044
Ok scroll to right what we need is Param2,Param3,Param4
Like if we want to make 2x
We use this formula : Param2 = Param2 * 2
So we open calculate and we do *2 to the currently number that we have in Param2
And put new number on
Then we do the same to param3 and param4
Then Excute
We need ID's from 2033 to 2044
Ok scroll to right what we need is Param2,Param3,Param4
Like if we want to make 2x
We use this formula : Param2 = Param2 * 2
So we open calculate and we do *2 to the currently number that we have in Param2
And put new number on
Then we do the same to param3 and param4
Then Excute
Disable alchemy materials from dropping
USE
PHP Code:
[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
Change Stacks for items
First go to refobjcommon
Find the item you want to change maxstack
Like you want for elixirs
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
Find the item you want to change maxstack
Like you want for elixirs
PHP Code:
ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B
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
Where is the red "1" Change itQuote:
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
Add CTF
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
Then go to "SCHEDULE_DEF_FLAG_WORLD"
And make this
flag_world - 1:55 ~ 6:21 (26min) 26min
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
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
How to change spawn place for new char
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
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
How to add items to start items
Go to sro_vt_shard.
Programmability
Stored Procedures
Then click modify at _AddNewChar
Scroll down into you find this
Programmability
Stored Procedures
Then click modify at _AddNewChar
Scroll down into you find this
Click Enter and add the item you want and then the second, is they amount,and then 1Quote:
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
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
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
use SRO_VT_SHARD
Change XX to the price you want
Change PACKAGE_ITEM_MALL_AVATAR_M_ To the RefPackageItemCodeName you want
PHP Code:
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%%'
Change PACKAGE_ITEM_MALL_AVATAR_M_ To the RefPackageItemCodeName you want
How to change Level of char
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 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)
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)
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
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
How to Clean shard log db
Quote:
USE [LOG_DB]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]
How to Clean shard db
Quote:
USE SRO_VT_SHARD
GO
truncate table _CharSkill
truncate table _CharSkillMastery
truncate table _GuildMember
truncate table _BlockedWhisperers
truncate table _Inventory
truncate table _InventoryForAvatar
truncate table _InventoryForLinkedStorage
truncate table _TrainingCampMember
truncate table _TrainingCampSubMentorHonorPoint
truncate table _TrainingCampHonorRank
truncate table _TrainingCampBuffStatus
delete from _TrainingCamp
truncate table _StaticAvatar
truncate table _User
truncate table _Friend
truncate table _Memo
truncate table _TimedJob
truncate table _CharTrijobSafeTrade
delete from _CharTrijob
truncate table _InvCOS
delete from _CharCOS where ID > 0
delete from _Char where charid > 0
truncate table _Chest
truncate table _ChestInfo
truncate table _ItemPool
delete from _Items where ID64 > 0
delete from _AccountJID
truncate table _GuildChest
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
truncate table _GuildWar
delete from _Guild where ID > 0
delete from _AlliedClans where ID > 0
truncate table _CharNameList
truncate table _CharQuest
truncate table _ClientConfig
truncate table _DeletedChar
truncate table _SiegeFortressStruct
truncate table _SiegeFortressStoneState
truncate table _SiegeFortressRequest
truncate table _SiegeFortressObject
truncate table _SiegeFortressItemForge
truncate table _SiegeFortressBattleRecord
delete from _SiegeFortress
truncate table _OpenMarket
How to delete the accounts from database
Quote:
USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans]
Fix Privileged IP table
Quote:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: Table [dbo].[_PrivilegedIP] Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
DROP TABLE _PrivilegedIP
GO
CREATE TABLE [dbo].[_PrivilegedIP](
[IP1] [tinyint] NOT NULL,
[IP2] [tinyint] NOT NULL,
[IP3] [tinyint] NOT NULL,
[IP4] [tinyint] NOT NULL,
[IP5] [tinyint] NOT NULL,
[IP6] [tinyint] NOT NULL,
[IP7] [tinyint] NOT NULL,
[IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO
Delete pk stats from all players
Quote:
USE [SRO_VT_SHARD]
UPDATE _Char SET
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0
Add new drop for unique or mob
Quote:
USE SRO_VT_SHARD_INIT
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
SET @MonsterID = [Desired Monster ID] -- Check RefObjCommon to find the desired ID
SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5
SET @ItemID = [Desired Item ID] -- Check RefObjCommon to find the desired item ID
INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
For 5 page inventory pet fix
Quote:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 02/10/2012 11:32:15 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_AddNewCOS]
@OwnerCharID int,
@RefObjID int,
@Level int,
@HP int,
@MP int,
@HGP int,
@KeeperNPC int,
@State int,
@InventorySize int,
@itemID int,
@PickItemConfig tinyint,
@RentEndTime smalldatetime
as
begin tran
declare @COS_ID int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @MaxInventorySize tinyint
select @MaxInventorySize = InventorySize
from _RefObjCommon, _RefObjChar
where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID
if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
begin
rollback tran
return -5
end
insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @COS_ID = @@identity
if (@COS_ID = 0 OR @@error <> 0)
begin
rollback tran
return -1
end
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @Slot int
set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values(@COS_ID, @Slot, 0)
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
rollback tran
return -2
end
set @Slot = @Slot + 1
end
end
/* --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -3
END
*/
if( @itemID <> 0 )
begin
update _Items set Data = @COS_ID where ID64 = @itemID
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
declare @Serial64 bigint
select @Serial64 = Serial64 from _Items where Data = @COS_ID
exec _AddTimedJobForPet @COS_ID,5,22926,1992999999,1111708465,1,112,0,0,0, 0,0,@Serial64
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
end
commit tran
return @COS_ID
More comming soon + Will add more photos
Stay tuned
//TODO