Register for your free account! | Forgot your password?

You last visited: Today at 15:01

  • Please register to post and access all features, it's quick, easy and FREE!

 

Help with NPC

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
Question 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



Vake24 is offline  
Old   #2
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Vake24 View Post
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...


c1ph3r is offline  
Old   #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
Vake24 is offline  
Old   #4


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
If this is a not existing NPC, you'll have to edit the db_npcresource.rdb in the Client aswell.c


Xijezu is offline  
Old   #5
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Vake24 View Post
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.
c1ph3r is offline  
Old   #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)


Vake24 is offline  
Reply



« Previous Thread | Next Thread »



All times are GMT +2. The time now is 15:01.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.