[For Beginners] Collection of Guides/Fixes
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:
Code:
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:
Code:
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:
Code:
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:
Code:
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:
Code:
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
Re: [For Beginners] Collection of Guides/Fixes
Thanks. appreciate your work.
Re: [For Beginners] Collection of Guides/Fixes
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.
Re: [For Beginners] Collection of Guides/Fixes
Re: [For Beginners] Collection of Guides/Fixes
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.
Re: [For Beginners] Collection of Guides/Fixes
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
Re: [For Beginners] Collection of Guides/Fixes
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.
Re: [For Beginners] Collection of Guides/Fixes
Quote:
Originally Posted by
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.
Did you change the required level for Job cave in the _RefTeleLink table?
Re: [For Beginners] Collection of Guides/Fixes
Quote:
Originally Posted by
blacksheep25
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.
Re: [For Beginners] Collection of Guides/Fixes
Quote:
Originally Posted by
RoyalDevil
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 :)
Re: [For Beginners] Collection of Guides/Fixes
Quote:
Originally Posted by
blacksheep25
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?
Re: [For Beginners] Collection of Guides/Fixes
Quote:
Originally Posted by
RoyalDevil
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.
Re: [For Beginners] Collection of Guides/Fixes
Quote:
Originally Posted by
blacksheep25
_RefGameWorldGroup_Config? There might be some stuff there to edit, just take a look at anything for TEMPLE.
Yeah done it, thanks =)
Re: [For Beginners] Collection of Guides/Fixes/Query
Thread has been updated with new querys and fixes. as well as thread's main title.
1 Attachment(s)
Additional query: inventory + storage slots info
In addition to @RenePunik's query about cleaning inventory, this one is to see inventory and storage items :)
now the boring part:
Code:
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:
Attachment 152328
cheers ;)
Re: Additional query: inventory + storage slots info
Quote:
Originally Posted by
Witchy Moo
In addition to @
RenePunik's query about cleaning inventory, this one is to see inventory and storage items :)
now the boring part:
Code:
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:
Attachment 152328
cheers ;)
Nice one.
