10-13-2013, 05:27 AM
Ok well in order to get event Npc working you need to spawn them where they go ...first spawn the Scarecrow in all your towns also the christmas trees when you Enable the event the Npcs will show up where u spawned them ..... So you need to add 454 455 to your towns so they spawn when the event is turned on .... I have not gotten Scare crow to work for the event ...but the christmas try has .... 484 486 484 is the Tree Event manager and should be placed in all your towns where 486 is for show ......best of luck .... I have not gotten to events yet for my release but i hope my info what i have will help for now ....
@ did you need the npc sql ...here it is for Chrismass
INSERT INTO `newproject_data`.`t_npc` (`a_index`, `a_enable`, `a_name`, `a_family`, `a_skillmaster`, `a_flag`, `a_flag1`, `a_level`, `a_exp`, `a_prize`, `a_sight`, `a_size`, `a_move_area`, `a_attack_area`, `a_skill_point`, `a_descr`, `a_sskill_master`, `a_str`, `a_dex`, `a_int`, `a_con`, `a_attack`, `a_magic`, `a_defense`, `a_resist`, `a_attacklevel`, `a_defenselevel`, `a_hp`, `a_mp`, `a_attackType`, `a_attackSpeed`, `a_recover_hp`, `a_recover_mp`, `a_walk_speed`, `a_run_speed`, `a_skill0`, `a_skill1`, `a_skill2`, `a_skill3`, `a_item_0`, `a_item_1`, `a_item_2`, `a_item_3`, `a_item_4`, `a_item_5`, `a_item_6`, `a_item_7`, `a_item_8`, `a_item_9`, `a_item_10`, `a_item_11`, `a_item_12`, `a_item_13`, `a_item_14`, `a_item_15`, `a_item_16`, `a_item_17`, `a_item_18`, `a_item_19`, `a_item_percent_0`, `a_item_percent_1`, `a_item_percent_2`, `a_item_percent_3`, `a_item_percent_4`, `a_item_percent_5`, `a_item_percent_6`, `a_item_percent_7`, `a_item_percent_8`, `a_item_percent_9`, `a_item_percent_10`, `a_item_percent_11`, `a_item_percent_12`, `a_item_percent_13`, `a_item_percent_14`, `a_item_percent_15`, `a_item_percent_16`, `a_item_percent_17`, `a_item_percent_18`, `a_item_percent_19`, `a_minplus`, `a_maxplus`, `a_probplus`, `a_product0`, `a_product1`, `a_product2`, `a_product3`, `a_product4`, `a_file_smc`, `a_motion_walk`, `a_motion_idle`, `a_motion_dam`, `a_motion_attack`, `a_motion_die`, `a_motion_run`, `a_motion_idle2`, `a_motion_attack2`, `a_scale`, `a_attribute`, `a_fireDelayCount`, `a_fireDelay0`, `a_fireDelay1`, `a_fireDelay2`, `a_fireDelay3`, `a_fireEffect0`, `a_fireEffect1`, `a_fireEffect2`, `a_fireObject`, `a_fireSpeed`, `a_name_usa`, `a_descr_usa`, `a_aitype`, `a_aiflag`, `a_aileader_flag`, `a_ai_summonHp`, `a_aileader_idx`, `a_aileader_count`, `a_crafting_category`, `a_productIndex`, `a_hit`, `a_dodge`, `a_magicavoid`, `a_job_attribute`, `a_npc_choice_trigger_count`, `a_npc_choice_trigger_ids`, `a_npc_kill_trigger_count`, `a_npc_kill_trigger_ids`, `a_createprob`, `a_socketprob_0`, `a_socketprob_1`, `a_socketprob_2`, `a_socketprob_3`, `a_jewel_0`, `a_jewel_1`, `a_jewel_2`, `a_jewel_3`, `a_jewel_4`, `a_jewel_5`, `a_jewel_6`, `a_jewel_7`, `a_jewel_8`, `a_jewel_9`, `a_jewel_10`, `a_jewel_11`, `a_jewel_12`, `a_jewel_13`, `a_jewel_14`, `a_jewel_15`, `a_jewel_16`, `a_jewel_17`, `a_jewel_18`, `a_jewel_19`, `a_jewel_percent_0`, `a_jewel_percent_1`, `a_jewel_percent_2`, `a_jewel_percent_3`, `a_jewel_percent_4`, `a_jewel_percent_5`, `a_jewel_percent_6`, `a_jewel_percent_7`, `a_jewel_percent_8`, `a_jewel_percent_9`, `a_jewel_percent_10`, `a_jewel_percent_11`, `a_jewel_percent_12`, `a_jewel_percent_13`, `a_jewel_percent_14`, `a_jewel_percent_15`, `a_jewel_percent_16`, `a_jewel_percent_17`, `a_jewel_percent_18`, `a_jewel_percent_19`) VALUES (483, 1, Christmas Gift box, -1, -1, 8, 0, 1, 1000, 0, 10, 1, 10, 2, 500, , -1, 38, 28, 28, 38, 1, 0, 54, 0, 1, 1, 150, 86, 0, 19, 2, 2, 2, 2, , , -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, -1, -1, -1, -1, Data\\Item\\Common\\pandora_box.smc, pandora_box, pandora_box_idle, pandora_box, pandora_box, pandora_box_die, pandora_box, pandora_box, pandora_box, 2, 0, 0, 0, 0, 0, 0, , , , 0, 0, Christmas Gift box, , 0, 0, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, , 0, , 0, 0, 0, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `newproject_data`.`t_npc` (`a_index`, `a_enable`, `a_name`, `a_family`, `a_skillmaster`, `a_flag`, `a_flag1`, `a_level`, `a_exp`, `a_prize`, `a_sight`, `a_size`, `a_move_area`, `a_attack_area`, `a_skill_point`, `a_descr`, `a_sskill_master`, `a_str`, `a_dex`, `a_int`, `a_con`, `a_attack`, `a_magic`, `a_defense`, `a_resist`, `a_attacklevel`, `a_defenselevel`, `a_hp`, `a_mp`, `a_attackType`, `a_attackSpeed`, `a_recover_hp`, `a_recover_mp`, `a_walk_speed`, `a_run_speed`, `a_skill0`, `a_skill1`, `a_skill2`, `a_skill3`, `a_item_0`, `a_item_1`, `a_item_2`, `a_item_3`, `a_item_4`, `a_item_5`, `a_item_6`, `a_item_7`, `a_item_8`, `a_item_9`, `a_item_10`, `a_item_11`, `a_item_12`, `a_item_13`, `a_item_14`, `a_item_15`, `a_item_16`, `a_item_17`, `a_item_18`, `a_item_19`, `a_item_percent_0`, `a_item_percent_1`, `a_item_percent_2`, `a_item_percent_3`, `a_item_percent_4`, `a_item_percent_5`, `a_item_percent_6`, `a_item_percent_7`, `a_item_percent_8`, `a_item_percent_9`, `a_item_percent_10`, `a_item_percent_11`, `a_item_percent_12`, `a_item_percent_13`, `a_item_percent_14`, `a_item_percent_15`, `a_item_percent_16`, `a_item_percent_17`, `a_item_percent_18`, `a_item_percent_19`, `a_minplus`, `a_maxplus`, `a_probplus`, `a_product0`, `a_product1`, `a_product2`, `a_product3`, `a_product4`, `a_file_smc`, `a_motion_walk`, `a_motion_idle`, `a_motion_dam`, `a_motion_attack`, `a_motion_die`, `a_motion_run`, `a_motion_idle2`, `a_motion_attack2`, `a_scale`, `a_attribute`, `a_fireDelayCount`, `a_fireDelay0`, `a_fireDelay1`, `a_fireDelay2`, `a_fireDelay3`, `a_fireEffect0`, `a_fireEffect1`, `a_fireEffect2`, `a_fireObject`, `a_fireSpeed`, `a_name_usa`, `a_descr_usa`, `a_aitype`, `a_aiflag`, `a_aileader_flag`, `a_ai_summonHp`, `a_aileader_idx`, `a_aileader_count`, `a_crafting_category`, `a_productIndex`, `a_hit`, `a_dodge`, `a_magicavoid`, `a_job_attribute`, `a_npc_choice_trigger_count`, `a_npc_choice_trigger_ids`, `a_npc_kill_trigger_count`, `a_npc_kill_trigger_ids`, `a_createprob`, `a_socketprob_0`, `a_socketprob_1`, `a_socketprob_2`, `a_socketprob_3`, `a_jewel_0`, `a_jewel_1`, `a_jewel_2`, `a_jewel_3`, `a_jewel_4`, `a_jewel_5`, `a_jewel_6`, `a_jewel_7`, `a_jewel_8`, `a_jewel_9`, `a_jewel_10`, `a_jewel_11`, `a_jewel_12`, `a_jewel_13`, `a_jewel_14`, `a_jewel_15`, `a_jewel_16`, `a_jewel_17`, `a_jewel_18`, `a_jewel_19`, `a_jewel_percent_0`, `a_jewel_percent_1`, `a_jewel_percent_2`, `a_jewel_percent_3`, `a_jewel_percent_4`, `a_jewel_percent_5`, `a_jewel_percent_6`, `a_jewel_percent_7`, `a_jewel_percent_8`, `a_jewel_percent_9`, `a_jewel_percent_10`, `a_jewel_percent_11`, `a_jewel_percent_12`, `a_jewel_percent_13`, `a_jewel_percent_14`, `a_jewel_percent_15`, `a_jewel_percent_16`, `a_jewel_percent_17`, `a_jewel_percent_18`, `a_jewel_percent_19`) VALUES (484, 1, Christmas tree, -1, -1, 33620240, 0, 100, 0, 0, 0, 0, 0, 0, 0, , -1, 10, 10, 10, 10, 10, 10, 10, 10, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, , , -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, -1, -1, -1, -1, Data\\Npc\\Christmas_tree\\christmastree.smc, christmastree, christmastree, christmastree, christmastree, christmastree, christmastree, christmastree, christmastree, 1, 0, 0, 0, 0, 0, 0, , , , 0, 0, Christmas tree, , 0, 0, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, , 0, , 0, 0, 0, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `newproject_data`.`t_npc` (`a_index`, `a_enable`, `a_name`, `a_family`, `a_skillmaster`, `a_flag`, `a_flag1`, `a_level`, `a_exp`, `a_prize`, `a_sight`, `a_size`, `a_move_area`, `a_attack_area`, `a_skill_point`, `a_descr`, `a_sskill_master`, `a_str`, `a_dex`, `a_int`, `a_con`, `a_attack`, `a_magic`, `a_defense`, `a_resist`, `a_attacklevel`, `a_defenselevel`, `a_hp`, `a_mp`, `a_attackType`, `a_attackSpeed`, `a_recover_hp`, `a_recover_mp`, `a_walk_speed`, `a_run_speed`, `a_skill0`, `a_skill1`, `a_skill2`, `a_skill3`, `a_item_0`, `a_item_1`, `a_item_2`, `a_item_3`, `a_item_4`, `a_item_5`, `a_item_6`, `a_item_7`, `a_item_8`, `a_item_9`, `a_item_10`, `a_item_11`, `a_item_12`, `a_item_13`, `a_item_14`, `a_item_15`, `a_item_16`, `a_item_17`, `a_item_18`, `a_item_19`, `a_item_percent_0`, `a_item_percent_1`, `a_item_percent_2`, `a_item_percent_3`, `a_item_percent_4`, `a_item_percent_5`, `a_item_percent_6`, `a_item_percent_7`, `a_item_percent_8`, `a_item_percent_9`, `a_item_percent_10`, `a_item_percent_11`, `a_item_percent_12`, `a_item_percent_13`, `a_item_percent_14`, `a_item_percent_15`, `a_item_percent_16`, `a_item_percent_17`, `a_item_percent_18`, `a_item_percent_19`, `a_minplus`, `a_maxplus`, `a_probplus`, `a_product0`, `a_product1`, `a_product2`, `a_product3`, `a_product4`, `a_file_smc`, `a_motion_walk`, `a_motion_idle`, `a_motion_dam`, `a_motion_attack`, `a_motion_die`, `a_motion_run`, `a_motion_idle2`, `a_motion_attack2`, `a_scale`, `a_attribute`, `a_fireDelayCount`, `a_fireDelay0`, `a_fireDelay1`, `a_fireDelay2`, `a_fireDelay3`, `a_fireEffect0`, `a_fireEffect1`, `a_fireEffect2`, `a_fireObject`, `a_fireSpeed`, `a_name_usa`, `a_descr_usa`, `a_aitype`, `a_aiflag`, `a_aileader_flag`, `a_ai_summonHp`, `a_aileader_idx`, `a_aileader_count`, `a_crafting_category`, `a_productIndex`, `a_hit`, `a_dodge`, `a_magicavoid`, `a_job_attribute`, `a_npc_choice_trigger_count`, `a_npc_choice_trigger_ids`, `a_npc_kill_trigger_count`, `a_npc_kill_trigger_ids`, `a_createprob`, `a_socketprob_0`, `a_socketprob_1`, `a_socketprob_2`, `a_socketprob_3`, `a_jewel_0`, `a_jewel_1`, `a_jewel_2`, `a_jewel_3`, `a_jewel_4`, `a_jewel_5`, `a_jewel_6`, `a_jewel_7`, `a_jewel_8`, `a_jewel_9`, `a_jewel_10`, `a_jewel_11`, `a_jewel_12`, `a_jewel_13`, `a_jewel_14`, `a_jewel_15`, `a_jewel_16`, `a_jewel_17`, `a_jewel_18`, `a_jewel_19`, `a_jewel_percent_0`, `a_jewel_percent_1`, `a_jewel_percent_2`, `a_jewel_percent_3`, `a_jewel_percent_4`, `a_jewel_percent_5`, `a_jewel_percent_6`, `a_jewel_percent_7`, `a_jewel_percent_8`, `a_jewel_percent_9`, `a_jewel_percent_10`, `a_jewel_percent_11`, `a_jewel_percent_12`, `a_jewel_percent_13`, `a_jewel_percent_14`, `a_jewel_percent_15`, `a_jewel_percent_16`, `a_jewel_percent_17`, `a_jewel_percent_18`, `a_jewel_percent_19`) VALUES (485, 1, Rudolph, -1, -1, 8, 0, 23, 1932, 99, 6, 1, 30, 1.5, 1000, , -1, 82, 72, 72, 82, 65, 0, 333, 22, 23, 23, 1762, 1007, 0, 19, 28, 28, 7, 7, -1 0, -1 0, -1, -1, 85, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, -1, -1, -1, -1, Data\\Npc\\Rudolth\\rudolth.smc, rudolth_walk, rudolth_idle, rudolth_idle, rudolth_idle, rudolth_die, rudolth_run, rudolth_idle2, rudolth_idle, 1, 0, 0, 0, 0, 0, 0, , , , 0, 0, Elite Ravenous Larva, , 0, 0, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, , 0, , 0, 0, 0, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `newproject_data`.`t_npc` (`a_index`, `a_enable`, `a_name`, `a_family`, `a_skillmaster`, `a_flag`, `a_flag1`, `a_level`, `a_exp`, `a_prize`, `a_sight`, `a_size`, `a_move_area`, `a_attack_area`, `a_skill_point`, `a_descr`, `a_sskill_master`, `a_str`, `a_dex`, `a_int`, `a_con`, `a_attack`, `a_magic`, `a_defense`, `a_resist`, `a_attacklevel`, `a_defenselevel`, `a_hp`, `a_mp`, `a_attackType`, `a_attackSpeed`, `a_recover_hp`, `a_recover_mp`, `a_walk_speed`, `a_run_speed`, `a_skill0`, `a_skill1`, `a_skill2`, `a_skill3`, `a_item_0`, `a_item_1`, `a_item_2`, `a_item_3`, `a_item_4`, `a_item_5`, `a_item_6`, `a_item_7`, `a_item_8`, `a_item_9`, `a_item_10`, `a_item_11`, `a_item_12`, `a_item_13`, `a_item_14`, `a_item_15`, `a_item_16`, `a_item_17`, `a_item_18`, `a_item_19`, `a_item_percent_0`, `a_item_percent_1`, `a_item_percent_2`, `a_item_percent_3`, `a_item_percent_4`, `a_item_percent_5`, `a_item_percent_6`, `a_item_percent_7`, `a_item_percent_8`, `a_item_percent_9`, `a_item_percent_10`, `a_item_percent_11`, `a_item_percent_12`, `a_item_percent_13`, `a_item_percent_14`, `a_item_percent_15`, `a_item_percent_16`, `a_item_percent_17`, `a_item_percent_18`, `a_item_percent_19`, `a_minplus`, `a_maxplus`, `a_probplus`, `a_product0`, `a_product1`, `a_product2`, `a_product3`, `a_product4`, `a_file_smc`, `a_motion_walk`, `a_motion_idle`, `a_motion_dam`, `a_motion_attack`, `a_motion_die`, `a_motion_run`, `a_motion_idle2`, `a_motion_attack2`, `a_scale`, `a_attribute`, `a_fireDelayCount`, `a_fireDelay0`, `a_fireDelay1`, `a_fireDelay2`, `a_fireDelay3`, `a_fireEffect0`, `a_fireEffect1`, `a_fireEffect2`, `a_fireObject`, `a_fireSpeed`, `a_name_usa`, `a_descr_usa`, `a_aitype`, `a_aiflag`, `a_aileader_flag`, `a_ai_summonHp`, `a_aileader_idx`, `a_aileader_count`, `a_crafting_category`, `a_productIndex`, `a_hit`, `a_dodge`, `a_magicavoid`, `a_job_attribute`, `a_npc_choice_trigger_count`, `a_npc_choice_trigger_ids`, `a_npc_kill_trigger_count`, `a_npc_kill_trigger_ids`, `a_createprob`, `a_socketprob_0`, `a_socketprob_1`, `a_socketprob_2`, `a_socketprob_3`, `a_jewel_0`, `a_jewel_1`, `a_jewel_2`, `a_jewel_3`, `a_jewel_4`, `a_jewel_5`, `a_jewel_6`, `a_jewel_7`, `a_jewel_8`, `a_jewel_9`, `a_jewel_10`, `a_jewel_11`, `a_jewel_12`, `a_jewel_13`, `a_jewel_14`, `a_jewel_15`, `a_jewel_16`, `a_jewel_17`, `a_jewel_18`, `a_jewel_19`, `a_jewel_percent_0`, `a_jewel_percent_1`, `a_jewel_percent_2`, `a_jewel_percent_3`, `a_jewel_percent_4`, `a_jewel_percent_5`, `a_jewel_percent_6`, `a_jewel_percent_7`, `a_jewel_percent_8`, `a_jewel_percent_9`, `a_jewel_percent_10`, `a_jewel_percent_11`, `a_jewel_percent_12`, `a_jewel_percent_13`, `a_jewel_percent_14`, `a_jewel_percent_15`, `a_jewel_percent_16`, `a_jewel_percent_17`, `a_jewel_percent_18`, `a_jewel_percent_19`) VALUES (486, 1, decorated a Christmas tree, -1, -1, 16, 0, 100, 0, 0, 0, 0, 0, 0, 0, , -1, 10, 10, 10, 10, 10, 10, 10, 10, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, , , -1, -1, 1843, 1844, 1316, 1317, 2604, -1, -1, 2606, 2607, 2608, 2609, 2610, -1, -1, -1, -1, -1, -1, -1, -1, 200, 200, 250, 250, 100, 0, 0, 20, 20, 20, 20, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, -1, -1, -1, -1, Data\\Npc\\Christmas_tree\\christmastree.smc, christmastree, christmastree, christmastree, christmastree, christmastree, christmastree, christmastree, christmastree, 1, 0, 0, 0, 0, 0, 0, , , , 0, 0, decorated a Christmas tree, , 0, 0, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, , 0, , 0, 0, 0, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
CDWriter