|
You last visited: Today at 10:19
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,086
Received Thanks: 3,472
|
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 +1. The time now is 10:19.
|
|
