Help with NPC

Hi!
I have problem with my custom NPC(buffer)!
I create LUA script and .sql file, i execute .sql file in database (DBO ARCADIA .rdb.NPCresourse)
But NPC don't spawn in game:confused: (when i try command add_npc server dont do it(with any npc))
Lua script work 100% (when i put LUA script in other npc it work)
Why NPC don't spawn in game?
Anybody know how i can fix it?
If need my .sql or LUA for more information i can give it!

P.S sorry for my bad English:pimp:

Quote:

Originally Posted by Vake24 Hi! I have problem with my custom NPC(buffer)! I create LUA script and .sql file, i execute .sql file in database (DBO ARCADIA .rdb.NPCresourse) But NPC don't spawn in game:confused: (when i try command add_npc server dont do it(with any npc)) Lua script work 100% (when i put LUA script in other npc it work) Why NPC don't spawn in game? Anybody know how i can fix it? If need my .sql or LUA for more information i can give it! P.S sorry for my bad English:pimp:

Post your SQL Query...

this is sql:
P.S i noob in MSSQL before i start play rappelz i work with MYSQL

If this is a not existing NPC, you'll have to edit the db_npcresource.rdb in the Client aswell.c

Quote:

Originally Posted by Vake24 this is sql: Code: USE [Arcadia] GO INSERT INTO [dbo].[NPCResource] ([id] ,[text_id] ,[name_text_id] ,[race_id] ,[sexsual_id] ,[x] ,[y] ,[z] ,[face] ,[local_flag] ,[is_periodic] ,[begin_of_period] ,[end_of_period] ,[face_x] ,[face_y] ,[face_z] ,[model_file] ,[hair_id] ,[face_id] ,[body_id] ,[weapon_item_id] ,[shield_item_id] ,[clothes_item_id] ,[helm_item_id] ,[gloves_item_id] ,[boots_item_id] ,[belt_item_id] ,[mantle_item_id] ,[necklace_item_id] ,[earring_item_id] ,[ring1_item_id] ,[ring2_item_id] ,[motion_id] ,[is_roam] ,[roaming_id] ,[standard_walk_speed] ,[standard_run_speed] ,[walk_speed] ,[run_speed] ,[attackable] ,[offensive_type] ,[spawn_type] ,[chase_range] ,[regen_time] ,[level] ,[stat_id] ,[attack_range] ,[attack_speed_type] ,[hp] ,[mp] ,[attack_point] ,[magic_point] ,[defence] ,[magic_defence] ,[attack_speed] ,[magic_speed] ,[accuracy] ,[avoid] ,[magic_accuracy] ,[magic_avoid] ,[ai_script] ,[contact_script] ,[texture_group]) VALUES (12000 ,100007025 ,105007025 ,3 ,2 ,222546 ,20331 ,0 ,0 ,0 ,0 ,0 ,0 ,-2 ,-5 ,15 ,'ain_angel_lv1' ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,'0' ,'NPC_Emperior_mage_contact()' ,-1) P.S i noob in MSSQL before i start play rappelz i work with MYSQL

The easiest way to add an npc is using an existing one and only change x, y and contact script...this should work for you. Otherwise you have to edit your npcresource like xijezu told you.

thx for help, i try edit client) or if i cant edit client i will use already exsist npc)