Hello This is my first tutorial.
How to add mob and skill in jupiter map with correct method and simple query.
What u need?
- Character data txt from korea media pk
- Npcpos txt from korea media pk
- Skill data txt from korea media pk
- Tab_RefHive
- Tab_RefNest
- Tab_RefTactics
As i know, original db vsro is ready for jupiter mob. (Tab_RefNest and Tab_RefHive.) Just Tab_RefTactics is not ready.
Todo: Insert value in Tab_RefTactics.
For Example: we need to spawn monster in jupiter field. (Region id = 90) (look at gameworld table)
1. Open Tab_RefHive, dwHiveID = 1451
2. Search 1451 in Tab_RefNest field
Code:SELECT * FROM [dbo].[Tab_RefNest] WHERE dwHiveID = 1451;
45040 = dwTacticsID
3. Select one region,x,y,z. For example:
22475 1730.45 182.13 1684.46 << seach this in npcpos.txt (from korea media pk)
Ok, now we got mob id = 36306
4. Search 36306 in Character data txt (from korea media pk)
Mob Code = MOB_JUPITER_TEMPLE_GUARD
use this simple query
You can modify value beetwen MOB_JUPITER_TEMPLE_GUARD and MOB_JUPITER_TEMPLE_GUARD as you want.Code:UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 = 'MOB_JUPITER_TEMPLE_GUARD'; exec SP_InsertRefTactics 1,'45040','MOB_JUPITER_TEMPLE_GUARD',0,100,50,130,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,1,0,0,0,'MOB_JUPITER_TEMPLE_GUARD'
You done
Next Step how to make mob attack.
1. Get link id MOB_JUPITER_TEMPLE_GUARD from _RefObjCommon
Link id is = 18722Code:SELECT * FROM [dbo].[_RefObjCommon] WHERE CodeName128 = 'MOB_JUPITER_TEMPLE_GUARD'
2. Search in _RefObjChar
3. Input skill id into field DefaultSkill_1, DefaultSkill_2 .....Code:SELECT * FROM [dbo].[_RefObjChar] WHERE ID = 18722
4. You can get correct skill id with same method like getting mob code.
- Search Skill ID from Character data from Media pk korea.
- Search Skill Code from skill data from Media pk korea.
- Search Skill Code in your DB and get correct Skill ID
- Input Skill ID in _RefObjChar
5. Done
Repeat all step for all dwTactics
Good Luck
** Sorry For My Bad English.







Reply With Quote






