10-12-2013, 06:23 PM
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 (454, 1, Pumpkin, -1, -1, 12, 32, 20, 4000, 1, 10, 1.3, 20, 1.3, 1500, , -1, 78, 68, 68, 78, 53, 0, 800, 20, 20, 20, 5000, 609, 0, 15, 26, 26, 1.8, 4.5, , , -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\\Monster\\Halloween_monster\\halloween_mon.smc, halloween_mon_walk, halloween_mon_idle, halloween_mon_dam, halloween_mon_att01, halloween_mon_die, halloween_mon_run, halloween_mon_idle, halloween_mon_att01, 1, 0, 0, 0, 0, 0, 0, , , , 0, 0, Pumpkin, , 0, 0, 0, 0, 0, 0, -1, -1, 170, 33, 33, 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 (455, 1, Scarecrow, -1, -1, 33620240, 32, 100, 0, 0, 0, 0, 0, 0, 0, , -1, 10, 10, 10, 10, 10, 10, 10, 10, 100, 100, 10000, 10000, 0, 0, 10000, 10000, 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\\Halloween_corw\\halloween_crow.smc, Halloween_corwhalloween_crow, Halloween_corwhalloween_crow, Halloween_corwhalloween_crow, Halloween_corwhalloween_crow, Halloween_corwhalloween_crow, Halloween_corwhalloween_crow, Halloween_corwhalloween_crow, Halloween_corwhalloween_crow, 1, 0, 0, 0, 0, 0, 0, , , , 0, 0, Scarecrow, , 0, 0, 0, 0, 0, 0, -1, -1, 110, 26, 26, 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);
heres the 2 missing with correct Flags....