[For Beginners] Collection of Guides/Fixes

[RenePunik]

Hello community, some guides and fixes and i will release it with you. i think some people will find it useless, but as title saying: it is for beginners. though i will release.

1-: For whom getting disconnected when buying Items from Arena Item Manager NPC.
1-Fix: Increase your Arena Coin Stack to 2000 Units.

2-: Since some people's pc firewall are closed, and your ftp guild/union emblems doesn't working. and showing as white logos.
2-Fix: Enable your FileZilla.exe through your firewall and it will works.

3-: Since all are disabling their greenbooks on their servers, I know it's useless, but disabling it will return to you with a new bug. So enable it won't lose you anything. Anyhow it's about quest(s) disappear. when you disable greenbook the quests that on npcs will disappear after greenbook's exp time is finished. though.
3-Fix: Enable greenbook in your server-side and client.

4-: For whom getting disconnected when buying Items from any NPC. and This is because _RefPricePolicyOfItem.
4-Fix: Check your values at _RefPricePolicyOfItem It has wrong values.

5-: Premium params ~ useful for beginners:
* 6582901 = Phy/Mag Dmg abs
* 1868849522 = Phy/Mag Dmg ass
* 25970 = Parry Rate
* 26738 = Attack Rate
* 1819632491 = Alchemy success rate
* 1634493301 = Lucky Rate
* 1937011305 = Str
* 1768846441 = Int
* 6844521 = HP
* 7172201 = MP
* 1752396851 = Moving Speed
* 1752656242 = Zerk
* 1685418593 = Time

6-: Change forgotten world level restrict. "120" is level of restrict.
6-Fix:

USE[SRO_VT_SHARD] ----- Change database's name to your own.
UPDATE[dbo].[_RefGame_World_Config]set Value='120' where ID='673'
UPDATE[dbo].[_RefGame_World_Config]set Value='120' where ID='651'
UPDATE[dbo].[_RefGame_World_Config]set Value='120' where ID='662'
UPDATE[dbo].[_RefGame_World_Config]set Value='120' where ID='618'
UPDATE[dbo].[_RefObjItem]set Param4='120' where ID='16645'
UPDATE[dbo].[_RefObjItem]set Param4='120' where ID='16646'
UPDATE[dbo].[_RefObjItem]set Param4='120' where ID='16647'
UPDATE[dbo].[_RefObjItem]set Param4='120' where ID='16648'

And Media:

1    35901    ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_1    ??? ? 100~120 (?)    xxx    SN_ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_1    SN_ITEM_ETC_TELEPORT_HOLE_TT_DESC    0    0    3    3    12    7    180000    3    0    1    1    1    0    0    1    0    0    1    0    100    0    0    0    1    1    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_ch_eventbox.bsr    item\etc\teleprot_hole.ddj    xxx    xxx    1    2    0    0    1    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    1    ???    0    INS_GOD_WRECK_IN_100_110_LEVEL_1    101    ?? ????    120    ?? ????    4    ??????    6    ???? ??    1    ???? ?? ??    -1    INS_QUEST_TELEPORT    -1    UIIT_STT_GOD_WRECK    18000000    COOLTIME:0x00000071    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
1    35902    ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_2    ??? ? 100~120 (??)    xxx    SN_ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_2    SN_ITEM_ETC_TELEPORT_HOLE_TT_DESC    0    0    3    3    12    7    180000    3    0    1    1    1    0    0    1    0    0    1    0    100    0    0    0    1    1    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_ch_eventbox.bsr    item\etc\teleprot_hole.ddj    xxx    xxx    1    2    0    0    1    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    2    ???    0    INS_GOD_WRECK_IN_100_110_LEVEL_2    101    ?? ????    120    ?? ????    4    ??????    6    ???? ??    1    ???? ?? ??    -1    INS_QUEST_TELEPORT    -1    UIIT_STT_GOD_WRECK    18000000    COOLTIME:0x00000071    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
1    35903    ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_3    ??? ? 100~120 (???)    xxx    SN_ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_3    SN_ITEM_ETC_TELEPORT_HOLE_TT_DESC    0    0    3    3    12    7    180000    3    0    1    1    1    0    0    1    0    0    1    0    100    0    0    0    1    1    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_ch_eventbox.bsr    item\etc\teleprot_hole.ddj    xxx    xxx    1    2    0    0    1    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    3    ???    0    INS_GOD_WRECK_OUT_100_110_LEVEL_3    101    ?? ????    120    ?? ????    8    ??????    6    ???? ??    1    ???? ?? ??    -1    INS_QUEST_TELEPORT    -1    UIIT_STT_GOD_WRECK    18000000    COOLTIME:0x00000071    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
1    35904    ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_4    ??? ? 100~120 (????)    xxx    SN_ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_4    SN_ITEM_ETC_TELEPORT_HOLE_TT_DESC    0    0    3    3    12    7    180000    3    0    1    1    1    0    0    1    0    0    1    0    100    0    0    0    1    1    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_ch_eventbox.bsr    item\etc\teleprot_hole.ddj    xxx    xxx    1    2    0    0    1    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    4    ???    0    INS_GOD_WRECK_OUT_100_110_LEVEL_4    101    ?? ????    120    ?? ????    8    ??????    6    ???? ??    1    ???? ?? ??    -1    INS_QUEST_TELEPORT    -1    UIIT_STT_GOD_WRECK    18000000    COOLTIME:0x00000071    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0

7-: For whom have troubles in mBot with Purification Pills
7-Fix: Use this query:

USE [SRO_VT_SHARD]
UPDATE _RefObjItem SET Param4='20000', Desc4_128='COOLTIME:0x000000C8'
WHERE ID BETWEEN 5861 and 5864

8-: For whom are lazy to add item by SMC on Characters (like me), this is query which will make your life is easier :P
8-Fix: Use this query:

USE [SRO_VT_SHARD] 
declare @CharName varchar(64)  
set @CharName = 'CharName' 
exec _ADD_ITEM_EXTERN @CharName,'ItemName',1,0

9-: And this one for clean player's inventory
9-Fix: Use this query:

USE [SRO_VT_SHARD]
GO
DECLARE @CharID INT = 'CharIDHere'
DECLARE @TSlots INT = 0
DECLARE @CharSlot INT = 0
SELECT @TSlots = COUNT(Slot) from _Inventory WHERE CharID = @CharID
WHILE @CharSlot <= @TSlots
BEGIN
    EXEC [_STRG_DEL_ITEM_NoTX] 1, @CharID, @CharSlot
    SET @CharSlot = @CharSlot + 1
END

[MentaL]

[TheRock2015]

Thanks. appreciate your work.

[blapanda]

Greenbook potential fix:
HourForMeterRateLevelFirst 22
HourForMeterRateLevelSecond 23
(server.cfg)

Parameters do have null-slots/params and do also have a range of pre-reserved slots.
E.g.

1685418593

15000

1886743667

2000

6645362

2

1

10

1

0

5

1702062192

1751474540

5864

0

0

0

(not going to explain what what is.)
If you are missing here some params (even if they are "0"), your server and/or your client will always crash.
I figured most of the pre-parammeters and can actually build completely new skills out of it.

So, just mentioning some builder parameters won't help any newbie out there, and most of us do know how ... "kryll pro devz like" they are.

[sacphonghung]

#2 how to enable?

[RenePunik]

For adding FileZilla in your firewall:
- Open Control Panel.- Choose System and Security.
- Windows Firewall.
- and you will see in left corner (Allow an app or feautre through Windows Firewall) Just click on it.
- Then, you have to browse your FileZilla.exe file.
- Done.

[eydol]

please can u teach me how to edit cooldown skill ?
like Reverse Immolation skill

and i have a problem wit buged charachter who use revers to return to last recall point at Mirror Dimension and job temple
and i don't know why and how fix it !!
please help me

[RoyalDevil]

Can you explain me how to change the required Job cave level ? I changed it in _RefGame_ًWorld_Config in db & client still doesn't work.

Thanks a lot.

[Blacksheep25]

Can you explain me how to change the required Job cave level ? I changed it in _RefGame_ًWorld_Config in db & client still doesn't work.

Thanks a lot.

Did you change the required level for Job cave in the _RefTeleLink table?

[RoyalDevil]

Did you change the required level for Job cave in the _RefTeleLink table?

Thanks again blacksheep25 =)
I tried to edit it, but actually i couldn't do. didn't understand where can i find the job cave & where can i find the Required level.

[Blacksheep25]

Thanks again blacksheep25 =)
I tried to edit it, but actually i couldn't do. didn't understand where can i find the job cave & where can i find the Required level.

If you look into the _RefTeleport table you will find a column called "ID" and another called "CodeName128" Look for ones that have "GATE_TEMPLE_", "GATE_DESERT_" and look at the "ID" and match that ID to the one in "_RefTeleLink" and thats how you know which one is which :)

[RoyalDevil]

If you look into the _RefTeleport table you will find a column called "ID" and another called "CodeName128" Look for ones that have "GATE_TEMPLE_", "GATE_DESERT_" and look at the "ID" and match that ID to the one in "_RefTeleLink" and thats how you know which one is which :)

Done, thanks a lot =)
Should i edit it in _RefGame_World_Config too right?

[Blacksheep25]

Done, thanks a lot =)
Should i edit it in _RefGame_World_Config too right?

_RefGameWorldGroup_Config? There might be some stuff there to edit, just take a look at anything for TEMPLE.

[RoyalDevil]

_RefGameWorldGroup_Config? There might be some stuff there to edit, just take a look at anything for TEMPLE.

Yeah done it, thanks =)

[RenePunik]

Thread has been updated with new querys and fixes. as well as thread's main title.

[Witchy Moo]

In addition to @RenePunik's query about cleaning inventory, this one is to see inventory and storage items :)

now the boring part:

USE [SRO_VT_SHARD]
GO
SET NOCOUNT ON;

/*
 * Check items in inventory and storage
 * Witchy Moo 20150622
 */
DECLARE @CharName VARCHAR(64)
DECLARE @CharID INT
DECLARE @userJID INT
DECLARE @ItemID BIGINT
DECLARE @CharSlot TINYINT
DECLARE @codename128 VARCHAR(64)

SET @CharName = 'Witchy'    -- set character name here

/* Check items in inventory */
PRINT CHAR(10)+'Inventory Items:'
SELECT @CharID = CharID FROM [_Char] WHERE CharName16 = LTRIM(RTRIM(@CharName))
DECLARE cur CURSOR FOR SELECT ItemID, Slot FROM [_Inventory] WITH (NOLOCK) WHERE CharID = @CharID AND ItemID > 0 ORDER BY Slot ASC
OPEN cur
FETCH NEXT FROM cur INTO @ItemID, @CharSlot
WHILE @@FETCH_STATUS = 0
BEGIN
    SELECT @codename128 = CodeName128 FROM [_RefObjCommon] WITH (NOLOCK) WHERE ID = (SELECT RefItemID FROM [_Items] WITH (NOLOCK) WHERE ID64 = @ItemID)
    PRINT '- Inventory slot ' + CAST(@CharSlot AS VARCHAR) + ': ' + @codename128
    FETCH NEXT FROM cur INTO @ItemID, @CharSlot
END;
CLOSE cur
DEALLOCATE cur
/* Check items in storage */
PRINT CHAR(10)+'Storage Items:'
SELECT @userJID = UserJID FROM _User WHERE CharID = @CharID
DECLARE cur CURSOR FOR SELECT ItemID, Slot FROM [_Chest] WITH (NOLOCK) WHERE UserJID = @userJID AND (ItemID <> 0 AND ItemID IS NOT NULL) ORDER BY Slot ASC
OPEN cur
FETCH NEXT FROM cur INTO @ItemID, @CharSlot
WHILE @@FETCH_STATUS = 0
BEGIN
    SELECT @codename128 = CodeName128 FROM [_RefObjCommon] WITH (NOLOCK) WHERE ID = (SELECT RefItemID FROM [_Items] WITH (NOLOCK) WHERE ID64 = @ItemID)
    PRINT '- Storage Slot ' + CAST(@CharSlot AS VARCHAR) + ': ' + @codename128
    FETCH NEXT FROM cur INTO @ItemID, @CharSlot
END;
CLOSE cur
DEALLOCATE cur

Result:

cheers ;)