- Joined
- Feb 27, 2013
- Messages
- 1,430
- Reaction score
- 201
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 butt
* 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:
And Media:
7-: For whom have troubles in mBot with Purification Pills
7-Fix: Use this query:
8-: For whom are lazy to add item by SMC on Characters (like me), this is query which will make your life is easier
8-Fix: Use this query:
9-: And this one for clean player's inventory
9-Fix: Use this query:
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 butt
* 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='[COLOR=#ff0000]120[/COLOR]' where ID='673'
UPDATE[dbo].[_RefGame_World_Config]set Value='[COLOR=#ff0000]120[/COLOR]' where ID='651'
UPDATE[dbo].[_RefGame_World_Config]set Value='[COLOR=#ff0000]120[/COLOR]' where ID='662'
UPDATE[dbo].[_RefGame_World_Config]set Value='[COLOR=#ff0000]120[/COLOR]' where ID='618'
UPDATE[dbo].[_RefObjItem]set Param4='[COLOR=#ff0000]120[/COLOR]' where ID='16645'
UPDATE[dbo].[_RefObjItem]set Param4='[COLOR=#ff0000]120[/COLOR]' where ID='16646'
UPDATE[dbo].[_RefObjItem]set Param4='[COLOR=#ff0000]120[/COLOR]' where ID='16647'
UPDATE[dbo].[_RefObjItem]set Param4='[COLOR=#ff0000]120[/COLOR]' where ID='16648'
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 ?? ???? [COLOR=#ff0000]120[/COLOR] ?? ???? 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 ?? ???? [COLOR=#ff0000]120[/COLOR] ?? ???? 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 ?? ???? [COLOR=#ff0000]120[/COLOR] ?? ???? 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 ?? ???? [COLOR=#ff0000]120[/COLOR] ?? ???? 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
8-Fix: Use this query:
Code:
USE [SRO_VT_SHARD]
declare @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name varchar(64)
set @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name = 'CharName'
exec _ADD_ITEM_EXTERN @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name,'ItemName',1,0
9-: And this one for clean player's inventory
9-Fix: Use this query:
Code:
USE [SRO_VT_SHARD]
GO
DECLARE @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID INT = 'CharIDHere'
DECLARE @TSlots INT = 0
DECLARE @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Slot INT = 0
SELECT @TSlots = COUNT(Slot) from _Inventory WHERE CharID = @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID
WHILE @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Slot <= @TSlots
BEGIN
EXEC [_STRG_DEL_ITEM_NoTX] 1, @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID, @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Slot
SET @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Slot = @[I][B][URL="https://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Slot + 1
END
Last edited: