Hello! Please tell me where I went wrong or what haven't I done?
I don't see NPCs in the game which made. Rappelz 9,4
As I did NPS
DELETE FROM [dbo].[NPCResource] WHERE (id = 15600) OR (id = 15601)
INSERT [dbo].[NPCResource] ([id], [text_id], [name_text_id], [race_id], [sexsual_id], [x], [y], [z], [face], [local_flag], [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], [type]) VALUES (15600, 100015600, 105015600, 99, 0, 152749, 76988, 0, 30, 0, 5, -6, 17, N'beast_rapter_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, N'0', N'NPC_des_shop_init()', -1, 0)
INSERT [dbo].[NPCResource] ([id], [text_id], [name_text_id], [race_id], [sexsual_id], [x], [y], [z], [face], [local_flag], [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], [type]) VALUES (15601, 100015601, 105015601, 99, 0, 137837, 105324, 0, 30, 0, 5, -6, 17, N'beast_rapter_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, N'0', N'NPC_des_shop_init()', -1, 0)
Like looks in the database.
id text_id name_text_id race_id sexsual_id x y z face local_flag 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 type
15600 100015600 105015600 99 0 152749 76988 0 30 0 5 -6 17 beast_rapter_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_des_shop_init() -1 0
id text_id name_text_id race_id sexsual_id x y z face local_flag 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 type
15601 100015601 105015601 99 0 137837 105324 0 30 0 5 -6 17 beast_rapter_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_des_shop_init() -1 0
Lua script name: NPC_des_shop_contact
--================================================== ==========
-- <<<<<< All in One Shop >>>>>>
--================================================== ==========
function NPC_des_shop_init()
cprint( "AiO Shop" )
set_npc_name( "All in One Shop" )
end
function NPC_des_shop_contact()
dlg_title( "Supermarket" )
dlg_text( "Welcome to the All in One Shop. Please select a category" )
dlg_menu( "Bear Cash Shop Decoration", "open_market( 'bearload_eventshop' )" )
dlg_menu( "Cash Shop Pet Items", "open_market( 'Creature_card' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'rental_shop_weapon_rank5' )" )
dlg_menu( "Rank 6 weapon", "open_market( 'rental_shop_weapon_rank6' )" )
dlg_menu( "Rank 7 weapon", "open_market( 'rental_shop_weapon_rank7' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'rental_shop_weapon_rank4' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'rental_shop_weapon_rank3' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'rental_shop_weapon_rank2' )" )
dlg_menu( "Rank 7 armor", "open_market( 'rental_shop_armor_rank7' )" )
dlg_menu( "Rank 6 armor", "open_market( 'rental_shop_armor_rank6' )" )
dlg_menu( "Rank 5 armor", "open_market( 'rental_shop_armor_rank5' )" )
dlg_menu( "Rank 4 armor", "open_market( 'rental_shop_armor_rank4' )" )
dlg_menu( "Rank 3 armor", "open_market( 'rental_shop_armor_rank3' )" )
dlg_menu( "Rank 2 armor", "open_market( 'rental_shop_armor_rank2' )" )
dlg_menu( "Rank 7 helm", "open_market( 'crushop_Newequip_helm_7rank' )" )
dlg_menu( "Rank 6 weapon", "open_market( 'Newequip_mantle_helm_rank_7' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'crushop_Newequip_weapon_mantle' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'crushop_Newequip_helm_6rank' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'Newequip_mantle_helm_rank_6' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'crushop_Newequip_helm_5rank' )" )
dlg_menu( "Rank 5mani helm", "open_market( 'Newequip_mantle_helm_rank_5' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'deva_weapon' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'rondoh_weapon' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'secroute_weapon' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'flat_sum_deva_weapon' )" )
dlg_menu( "Rank 7 helm", "open_market( 'flat_sum_asura_weapon' )" )
dlg_menu( "Rank 6 weapon", "open_market( 'flat_sum_gaia_weapon' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'flat_sum_rondoh_weapon' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'asura_weapon' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'gaia_weapon' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'Ancient_relic_weapon' )" )
dlg_menu( "Rank 6 weapon", "open_market( 'crushop_Newequip_helm_4rank' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'Newequip_mantle_helm_rank_4' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'deva_equip' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'asura_equip' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'gaia_equip' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'Ancient_relic_equip' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'rondoh_equip' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'secroute_equip' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'flat_sum_deva_equip' )" )
dlg_menu( "Rank 7 helm", "open_market( 'flat_sum_asura_equip' )" )
dlg_menu( "Rank 6 weapon", "open_market( 'flat_sum_gaia_equip' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'flat_sum_rondoh_equip' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'crushop_Newequip_helm_3rank' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'Newequip_mantle_helm_rank_3' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'crushop_Newequip_helm_2rank' )" )
dlg_menu( "Rank 6 weapon", "open_market( 'Newequip_mantle_helm_rank_2' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'deva_etc' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'asura_etc' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'gaia_etc' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'beginner_weapon' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'beginner_etc' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'desert_etc' )" )
dlg_menu( "Rank 6 weapon", "open_market( 'mare_etc' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'Ancient_relic_etc' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'rondoh_etc' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'secroute_etc' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'secroute_etc_KR' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'flat_sum_deva_etc' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'flat_sum_asura_etc' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'flat_sum_gaia_etc' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'flat_sum_rondoh_etc' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'flat_sum_mare_etc' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'flat_sum_desert_etc' )" )
dlg_menu( "Rank 6 weapon", "open_market( 'flat_sum_beginner_etc' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'flat_sum_Ancient_relic_etc' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'sec_sever_merchant_etc' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'nosec_sever_merchant_etc' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'crushop_Newequip_armors' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'crushop_Newequip_weapon_mantle' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'secroute_deco' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'NPC_Event_Japan_summer' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'normal_riding' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'official_riding' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'sec_sever_secmerchant_etc' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'sec_sever_mare_merchant_etc' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'nosec_sever_mare_merchant_etc' )" )
dlg_menu( "Rank 6 weapon", "open_market( 'expansion_acc_bag' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'crushop_hair' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'deathmatch_only' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'boost_chip' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'secroute_boost_chip' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'inhance_helper_randombox' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'bearload_shop_creturecard' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'bearload_shop_creturecard_me' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'bearload_shop_equipment' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'bearload_shop_skillcard' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'bearload_shop_soulstone' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'bearload_shop' )" )
dlg_menu( "Rank 6 weapon", "open_market( 'bearload_shop_onlybear' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'bearload_shop_beardeco' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'Rondoh_Battlearena_roma_Lv1' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'Rondoh_Battlearena_darkmage_Lv1' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'Rondoh_Battlearena_indian_Lv1' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'foodshop_etc' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'secroute_foodshop_etc' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'Rondoh_Battlearena_Etc' )" )
dlg_menu( "Rank 5 weapon", "open_market( 'Rondoh_Battlearena_consumables' )" )
dlg_menu( "Rank 4 weapon", "open_market( 'event_pluto_shop_rondo' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'event_pluto_shop_asura' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'event_pluto_shop_deva' )" )
dlg_menu( "Rank 3 weapon", "open_market( 'event_pluto_shop_gaia' )" )
dlg_menu( "Rank 2 weapon", "open_market( 'bearload_shop_cube' )" )
dlg_menu( "deva item", "open_market( 'deva_itemUP_suppert' )" )
dlg_menu( "asura item", "open_market( 'Asura_itemUP_suppert' )" )
dlg_menu( "Beginer item", "open_market( 'Beginner_itemUP_suppert' )" )
dlg_menu( "Gai item", "open_market( 'Gaia_itemUP_suppert' )" )
dlg_menu( "Rondo itemn", "open_market( 'Rondoh_itemUP_suppert' )" )
dlg_menu( "nosec sever", "open_market( 'nosec_sever_bulcajoin' )" )
dlg_menu( "sec sever bulcajoin", "open_market( 'sec_sever_bulcajoin' )" )
dlg_menu( "Sec sever", "open_market( 'sec_sever_bulcajoin_sec' )" )
dlg_menu( "tp quest", "open_market( 'tp_quest' )" )
dlg_menu( "Event ramadan1", "open_market( 'event_ramadan1_shop' )" )
dlg_menu( "create farm", "open_market( 'creature_farm' )" )
dlg_menu( "Deco effect", "open_market( 'deco_effect' )" )
dlg_menu( "event ramadan2", "open_market( 'event_ramadan2_shop' )" )
dlg_menu( "Deco me", "open_market( 'secroute_deco_me' )" )
dlg_menu( "Costume", "open_market( 'crushop_costume' )" )
dlg_menu( "Paralelnii MIR Kyhec", "open_market( 'parallelworld_merchant_etc' )" )
dlg_menu( "Crushop", "open_market( 'crushop_etc' )" )
dlg_menu( "all crushop", "open_market( 'crushop_summon' )" )
dlg_menu( "New Rank 2 weapon", "open_market( 'newbie_2rank_weapon' )" )
dlg_menu( "New Rank 3 weapon", "open_market( 'newbie_3rank_weapon' )" )
dlg_menu( "New Rank 4 weapon", "open_market( 'newbie_4rank_weapon' )" )
dlg_menu( "New Rank 5 weapon", "open_market( 'newbie_5rank_weapon' )" )
dlg_menu( "New Rank 6 weapon", "open_market( 'newbie_6rank_weapon' )" )
dlg_menu( "Broken Taming card", "open_market( 'Broken_Taming_Card' )" )
dlg_menu( "Buff", "buff_select_player()" )
dlg_menu( "Pet Buff", "buff_select_creature()" )
dlg_menu( "@90010002", '' )
dlg_show()
end
function buff_select_player()
dlg_text("Посмотрим, что у нас есть ")
dlg_menu("Physical Attack - 20,000R", "buff_player(1007)")
dlg_menu("Magical Attack - 20,000R", "buff_player(1008)")
dlg_menu("Physical Defense - 20,000R", "buff_player(1009)")
dlg_menu("Magical Defense - 20,000R", "buff_player(1010)")
dlg_menu("Attack Speed - 20,000R", "buff_player(1011)")
dlg_menu("Cast Speed - 20,000R", "buff_player(1012)")
dlg_menu("Благословение жизни - 20,000R", "buff_player(163404)")
dlg_menu("Благословение разума - 20,000R", "buff_player(163405)")
dlg_menu("Благословение мудрости - 20,000R", "buff_player(163406)")
dlg_menu("Благословение Силы - 20,000R", "buff_player(163407)")
dlg_menu("Скорость ветра - 20,000R", "buff_player(13423)")
dlg_menu("Дух камня - 20,000R", "buff_player(13424)")
dlg_menu("Сила священного пламени - 20,000R", "buff_player(13425)")
dlg_menu("Get All Buffs - 140,000R", "buff_player(0)")
dlg_menu( "Goodbuy", '' )
dlg_show()
end
function buff_select_creature()
dlg_text("1")
dlg_menu("Physical Attack - 20,000R", "buff_creature(1007)")
dlg_menu("Magical Attack - 20,000R", "buff_creature(1008)")
dlg_menu("Physical Defense- 20,000R", "buff_creature(1009)")
dlg_menu("Magical Defense- 20,000R", "buff_creature(1010)")
dlg_menu("Attack Speed - 20,000R", "buff_creature(1011)")
dlg_menu("Cast Speed - 20,000R", "buff_creature(1012)")
dlg_menu("Благословение жизни - 20,000R", "buff_creature(163404)")
dlg_menu("Благословение разума - 20,000R", "buff_creature(163405)")
dlg_menu("Благословение мудрости - 20,000R", "buff_creature(163406)")
dlg_menu("Благословение Силы - 20,000R", "buff_creature(163407)")
dlg_menu("Скорость ветра - 20,000R", "buff_creature(13423)")
dlg_menu("Дух камня - 20,000R", "buff_creature(13424)")
dlg_menu("Сила священного пламени - 20,000R", "buff_creature(13425)")
dlg_menu("Get All Buffs - 140,000R", "buff_creature(0)")
dlg_menu( "Goodbuy", '' )
dlg_show()
end
function buff_player(buffcode)
local gold = get_value("gold")
gold = tonumber(gold)
if buffcode == 0 then
if gold >= 140000 then
sv("gold", gold-140000)
update_gold_chaos()
add_state(1007, 18, 900000)
add_state(1008, 18, 900000)
add_state(1009, 18, 900000)
add_state(1010, 18, 900000)
add_state(1011, 18, 900000)
add_state(1012, 18, 900000)
add_state(1013, 18, 900000)
add_state(163404, 18, 900000)
add_state(163405, 18, 900000)
add_state(163406, 18, 900000)
add_state(163407, 18, 900000)
add_state(13423, 18, 900000)
add_state(13424, 18, 900000)
add_state(13425, 18, 900000)
buff_select_player()
else
dlg_text("Sorry, you do not have enough money.")
dlg_menu("Goodbye!", "")
dlg_show()
end
else
if gold >= 20000 then
sv("gold", gold-20000)
update_gold_chaos()
add_state("" .. buffcode .. "", 18, 900000)
buff_select_player()
else
dlg_text("Sorry, you do not have enough money.")
dlg_menu("Goodbye!", "")
dlg_show()
end
end
end
function buff_creature(buffcode)
local gold = get_value("gold")
gold = tonumber(gold)
if buffcode == 0 then
if gold >= 140000 then
sv("gold", gold-140000)
update_gold_chaos()
add_cstate(1007, 18, 900000)
add_cstate(1008, 18, 900000)
add_cstate(1009, 18, 900000)
add_cstate(1010, 18, 900000)
add_cstate(1011, 18, 900000)
add_cstate(1012, 18, 900000)
add_cstate(1013, 18, 900000)
add_state(163404, 18, 900000)
add_state(163405, 18, 900000)
add_state(163406, 18, 900000)
add_state(163407, 18, 900000)
add_state(13423, 18, 900000)
add_state(13424, 18, 900000)
add_state(13425, 18, 900000)
buff_select_creature()
else
dlg_text("Sorry, you do not have enough money.")
dlg_menu("Goodbye!", "")
dlg_show()
end
else
if gold >= 20000 then
sv("gold", gold-20000)
update_gold_chaos()
add_cstate("" .. buffcode .. "", 18, 900000)
buff_select_creature()
else
dlg_text("Sorry, you do not have enough money.")
dlg_menu("Goodbye!", "")
dlg_show()
end
end
end
This is my .bat . Forgot what to add to make it run more clients. 9.4 server, also i cant seem to GM myself any suggestion and tips would be nice!