You last visited: Today at 03:58
Advertisement
Help with NPC
Discussion on Help with NPC within the Rappelz Private Server forum part of the Rappelz category.
07/15/2012, 10:43
#1
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
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
(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
07/15/2012, 10:48
#2
elite*gold: 0
Join Date: Sep 2008
Posts: 1,606
Received Thanks: 1,210
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
(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
Post your SQL Query...
07/15/2012, 11:33
#3
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
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
07/15/2012, 12:00
#4
elite*gold: 0
Join Date: May 2011
Posts: 5,088
Received Thanks: 3,475
If this is a not existing NPC, you'll have to edit the db_npcresource.rdb in the Client aswell.c
07/15/2012, 12:19
#5
elite*gold: 0
Join Date: Sep 2008
Posts: 1,606
Received Thanks: 1,210
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.
07/15/2012, 13:43
#6
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
thx for help, i try edit client) or if i cant edit client i will use already exsist npc)
All times are GMT +2. The time now is 04:00 .
Help with NPC
(when i try command add_npc server dont do it(with any npc))
