Recent content by Witchy Moo

it won't :), it just marks that quest id 1 and 2 are finished.

It's related to default quest. Open your SHARD's [_AddNewChar] SP, find these lines: ----------------------------------------------------------------------------- -- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â ----------------------------------------------------------------------------- INSERT INTO...

Try creating the guild manually from database by executing Guild create SP: USE [SRO_VT_SHARD] EXEC [_Guild_Create] 'GuildNameHere', CharIDHere see if you encounter some errors there

For "normal" equip, change probability value in [_RefDropClassSel_Equip] table For "rare" equip, change probability value in [_RefDropClassSel_RareEquip] table Fields are ProbGroup32 to Probgroup34 for 12D items -- Normal SELECT ProbGroup32, ProbGroup33, ProbGroup34 FROM...

SELECT a.*, b.CodeName128 FROM [_RefDropItemAssign] a WITH (NOLOCK) INNER JOIN [_RefObjCommon] b ON a.RefItemID = b.ID WHERE b.CodeName128 LIKE 'ITEM_%12%' good luck ;)

You need to make your own "delivery" system for it. I removed the query for automatic scroll delivery on level up because it might spike your server resources (say, 100+ players level up at same time, might burden the SQL)... Safest way is to make some kind of trigger for it, for example...

Hello, Here I'll share simple SQL query to check and update "Max Plus" (with and without Adv. Elixir) of items in 2 different methods: (doesn't matter which, both has same effect) Method 1: Real time after fusing Method 2: On login/logout session Why login/logout session? well as far as I...

Try by executing the SP directly from your SQL and teleport the char, see if it works. EXEC [SRO_VT_SHARD].[dbo].[_ADD_AUTOEQUIP_GEAR] 'CharacterName', 7 good luck

Agreed on ID thingy. Moreover, that screenshot showed shop item IDs, which even more worse I might say :P, numbers are too big and yet only less than 2500 records in the table. [_RefPackageItems] and its related tables are easier to sort and manage. And you can even truncate 'em many times over...

see if the item available in _RefObjCommon SELECT a.CodeName128 FROM _RefObjCommon a INNER JOIN _RefScrapOfPackageItem b ON a.CodeName128 = b.RefItemCodeName WHERE a.[Service] = 1 AND a.CodeName128 LIKE 'ITEM_ETC_CURE_ALL_04' if result is empty, means it's not available in _RefObjCommon or not...

creative, nice one ;)

yep, effect should be for area attack if i don't misunderstand you. You can try adding these Params in front (must go first before the attack/debuff effects) of skill column that you want: VALUE 1 VALUE 2 VALUE 3 VALUE 4 VALUE 5 VALUE 6 6645362 1 2 500 8 0 A little explanation of what i...

added ;) have fun

Safest way is to do this when character login/logout, since changing item plus from database trigger or _AddLogItem query without refreshing the client will cause misinformation between client and server and it might cause the client dc coz wrong information received from the server. Say...

Hello, here I'll share simple query to find tables containing "JID", "UserJID", or "CharID", for cleanup purposes. Well actually, it'll be easier to cleanup the whole thing if you wanna start fresh, and this prolly old and useless to you, but I'll share it anyway. Now the boring part: USE...