//public void titem_Import() //{ // AllLists.tItemMenuData.Clear(); // AllLists.tItemMenu.Clear(); // LoadFromDatabase.LoadFromDatabaseSQL = "SELECT * FROM t_item "; // foreach (DataRow row in (InternalDataCollectionBase)mySQL.GetFromQuery(LoadFromDatabase.LoadFromDatabaseSQL).Rows) // { // tItem titem = new tItem(); // titem.index = Convert.ToInt32(row["a_index"]); // titem.typeIdx = Convert.ToInt32(row["a_type_idx"]); // titem.subTypeIdx = Convert.ToInt32(row["a_subtype_idx"]); // titem.enable = Convert.ToInt32(row["a_enable"]); // titem.wearing = Convert.ToInt32(row["a_wearing"]); // titem.num0 = Convert.ToInt32(row["a_num_0"]); // titem.num1 = Convert.ToInt32(row["a_num_1"]); // titem.num2 = Convert.ToInt32(row["a_num_2"]); // titem.num3 = Convert.ToInt32(row["a_num_3"]); // titem.num4 = Convert.ToInt32(row["a_num_4"]); // titem.minLevel = Convert.ToInt32(row["a_level"]); // titem.maxLevel = Convert.ToInt32(row["a_leve2"]); // titem.weight = Convert.ToInt32(row["a_weight"]); // titem.price = Convert.ToInt32(row["a_price"]); // titem.maxUse = Convert.ToInt32(row["a_max_use"]); // titem.skillpoint = Convert.ToInt32(row["a_skill_point"]); // titem.sskillmaster = Convert.ToInt32(row["a_sskill_master"]); // titem.str = Convert.ToInt32(row["a_str"]); // titem.dex = Convert.ToInt32(row["a_dex"]); // titem.INT = Convert.ToInt32(row["a_int"]); // titem.con = Convert.ToInt32(row["a_con"]); // titem.attack = Convert.ToInt32(row["a_attack"]); // titem.magic = Convert.ToInt32(row["a_magic"]); // titem.defense = Convert.ToInt32(row["a_defense"]); // titem.resist = Convert.ToInt32(row["a_resist"]); // titem.attacklevel = Convert.ToInt32(row["a_attacklevel"]); // titem.defenselevel = Convert.ToInt32(row["a_defenselevel"]); // titem.hp = Convert.ToInt32(row["a_hp"]); // titem.mp = Convert.ToInt32(row["a_mp"]); // titem.attacktype = Convert.ToInt32(row["a_attackType"]); // titem.attackspeed = Convert.ToInt32(row["a_attackSpeed"]); // titem.recoverhp = Convert.ToInt32(row["a_recover_hp"]); // titem.recovermp = Convert.ToInt32(row["a_recover_mp"]); // titem.walkspeed = Convert.ToSingle(row["a_walk_speed"]); // titem.runspeed = Convert.ToSingle(row["a_run_speed"]); // titem.skill0 = Convert.ToString(row["a_skill0"]); // titem.skill1 = Convert.ToString(row["a_skill1"]); // titem.skill2 = Convert.ToString(row["a_skill2"]); // titem.skill3 = Convert.ToString(row["a_skill3"]); // titem.drop0 = Convert.ToInt32(row["a_item_0"]); // titem.drop1 = Convert.ToInt32(row["a_item_1"]); // titem.drop2 = Convert.ToInt32(row["a_item_2"]); // titem.drop3 = Convert.ToInt32(row["a_item_3"]); // titem.drop4 = Convert.ToInt32(row["a_item_4"]); // titem.drop5 = Convert.ToInt32(row["a_item_5"]); // titem.drop6 = Convert.ToInt32(row["a_item_6"]); // titem.drop7 = Convert.ToInt32(row["a_item_7"]); // titem.drop8 = Convert.ToInt32(row["a_item_8"]); // titem.drop9 = Convert.ToInt32(row["a_item_9"]); // titem.drop10 = Convert.ToInt32(row["a_item_10"]); // titem.drop11 = Convert.ToInt32(row["a_item_11"]); // titem.drop12 = Convert.ToInt32(row["a_item_12"]); // titem.jewel7 = Convert.ToInt32(row["a_jewel_7"]); // titem.jewel8 = Convert.ToInt32(row["a_jewel_8"]); // titem.jewel9 = Convert.ToInt32(row["a_jewel_9"]); // titem.jewel10 = Convert.ToInt32(row["a_jewel_10"]); // titem.jewel11 = Convert.ToInt32(row["a_jewel_11"]); // titem.jewel12 = Convert.ToInt32(row["a_jewel_12"]); // titem.jewel13 = Convert.ToInt32(row["a_jewel_13"]); // titem.jewel14 = Convert.ToInt32(row["a_jewel_14"]); // titem.jewel15 = Convert.ToInt32(row["a_jewel_15"]); // titem.jewel16 = Convert.ToInt32(row["a_jewel_16"]); // titem.jewel17 = Convert.ToInt32(row["a_jewel_17"]); // titem.jewel18 = Convert.ToInt32(row["a_jewel_18"]); // titem.jewel19 = Convert.ToInt32(row["a_jewel_19"]); // titem.jeweldrop0 = Convert.ToInt32(row["a_jewel_percent_0"]); // titem.jeweldrop1 = Convert.ToInt32(row["a_jewel_percent_1"]); // titem.jeweldrop2 = Convert.ToInt32(row["a_jewel_percent_2"]); // titem.jeweldrop3 = Convert.ToInt32(row["a_jewel_percent_3"]); // titem.jeweldrop4 = Convert.ToInt32(row["a_jewel_percent_4"]); // titem.jeweldrop5 = Convert.ToInt32(row["a_jewel_percent_5"]); // titem.jeweldrop6 = Convert.ToInt32(row["a_jewel_percent_6"]); // titem.jeweldrop7 = Convert.ToInt32(row["a_jewel_percent_7"]); // titem.jeweldrop8 = Convert.ToInt32(row["a_jewel_percent_8"]); // titem.jeweldrop9 = Convert.ToInt32(row["a_jewel_percent_9"]); // titem.jeweldrop10 = Convert.ToInt32(row["a_jewel_percent_10"]); // titem.jeweldrop11 = Convert.ToInt32(row["a_jewel_percent_11"]); // titem.jeweldrop12 = Convert.ToInt32(row["a_jewel_percent_12"]); // titem.jeweldrop13 = Convert.ToInt32(row["a_jewel_percent_13"]); // titem.jeweldrop14 = Convert.ToInt32(row["a_jewel_percent_14"]); // titem.jeweldrop15 = Convert.ToInt32(row["a_jewel_percent_15"]); // titem.jeweldrop16 = Convert.ToInt32(row["a_jewel_percent_16"]); // titem.jeweldrop17 = Convert.ToInt32(row["a_jewel_percent_17"]); // titem.jeweldrop18 = Convert.ToInt32(row["a_jewel_percent_18"]); // titem.jeweldrop19 = Convert.ToInt32(row["a_jewel_percent_19"]); // titem.zoneflag = Convert.ToInt64(row["a_zone_flag"]); // titem.extraflag = Convert.ToInt64(row["a_extra_flag"]); // titem.rvrvalue = Convert.ToInt32(row["a_rvr_value"]); // titem.rvrgrade = Convert.ToInt32(row["a_rvr_grade"]); // titem.bound = Convert.ToInt32(row["a_bound"]); // titem.lifetime = Convert.ToInt32(row["a_lifetime"]); // AllLists.tItemMenuData.Add(titem); // AllLists.tItemMenu.Add(titem.index.ToString() + " - " + titem.name.ToString()); // } //} public void tnpc_Import() { AllLists.tnpc_MenuData.Clear(); AllLists.tnpc_Menu.Clear(); LoadFromDatabase.LoadFromDatabaseSQL = "SELECT * FROM t_npc"; foreach (DataRow row in (InternalDataCollectionBase)mySQL.GetFromQuery(LoadFromDatabase.LoadFromDatabaseSQL).Rows) { tnpc tnpc = new tnpc(); tnpc.index = Convert.ToInt32(row["a_index"]); tnpc.enable = Convert.ToInt32(row["a_enable"]); tnpc.name = Convert.ToString(row["a_name"]); tnpc.family = Convert.ToInt32(row["a_family"]); tnpc.skillmaster = Convert.ToInt32(row["a_skillmaster"]); tnpc.flag = Convert.ToInt32(row["a_flag"]); tnpc.flag1 = Convert.ToInt32(row["a_flag1"]); tnpc.stateflag = Convert.ToInt32(row["a_state_flag"]); tnpc.level = Convert.ToInt32(row["a_level"]); tnpc.exp = Convert.ToInt32(row["a_exp"]); tnpc.prize = Convert.ToInt32(row["a_prize"]); tnpc.sight = Convert.ToInt32(row["a_sight"]); tnpc.size = Convert.ToSingle(row["a_size"]); tnpc.movearea = Convert.ToInt32(row["a_move_area"]); tnpc.attackarea = Convert.ToSingle(row["a_attack_area"]); tnpc.skillpoint = Convert.ToInt32(row["a_skill_point"]); tnpc.sskillmaster = Convert.ToInt32(row["a_sskill_master"]); tnpc.str = Convert.ToInt32(row["a_str"]); tnpc.dex = Convert.ToInt32(row["a_dex"]); tnpc.INT = Convert.ToInt32(row["a_int"]); tnpc.con = Convert.ToInt32(row["a_con"]); tnpc.attack = Convert.ToInt32(row["a_attack"]); tnpc.magic = Convert.ToInt32(row["a_magic"]); tnpc.defense = Convert.ToInt32(row["a_defense"]); tnpc.resist = Convert.ToInt32(row["a_resist"]); tnpc.attacklevel = Convert.ToInt32(row["a_attacklevel"]); tnpc.defenselevel = Convert.ToInt32(row["a_defenselevel"]); tnpc.hp = Convert.ToInt32(row["a_hp"]); tnpc.mp = Convert.ToInt32(row["a_mp"]); tnpc.attacktype = Convert.ToInt32(row["a_attackType"]); tnpc.attackspeed = Convert.ToInt32(row["a_attackSpeed"]); tnpc.recoverhp = Convert.ToInt32(row["a_recover_hp"]); tnpc.recovermp = Convert.ToInt32(row["a_recover_mp"]); tnpc.walkspeed = Convert.ToSingle(row["a_walk_speed"]); tnpc.runspeed = Convert.ToSingle(row["a_run_speed"]); tnpc.skill0 = Convert.ToString(row["a_skill0"]); tnpc.skill1 = Convert.ToString(row["a_skill1"]); tnpc.skill2 = Convert.ToString(row["a_skill2"]); tnpc.skill3 = Convert.ToString(row["a_skill3"]); tnpc.drop0 = Convert.ToInt32(row["a_item_0"]); tnpc.drop1 = Convert.ToInt32(row["a_item_1"]); tnpc.drop2 = Convert.ToInt32(row["a_item_2"]); tnpc.drop3 = Convert.ToInt32(row["a_item_3"]); tnpc.drop4 = Convert.ToInt32(row["a_item_4"]); tnpc.drop5 = Convert.ToInt32(row["a_item_5"]); tnpc.drop6 = Convert.ToInt32(row["a_item_6"]); tnpc.drop7 = Convert.ToInt32(row["a_item_7"]); tnpc.drop8 = Convert.ToInt32(row["a_item_8"]); tnpc.drop9 = Convert.ToInt32(row["a_item_9"]); tnpc.drop10 = Convert.ToInt32(row["a_item_10"]); tnpc.drop11 = Convert.ToInt32(row["a_item_11"]); tnpc.drop12 = Convert.ToInt32(row["a_item_12"]); tnpc.drop13 = Convert.ToInt32(row["a_item_13"]); tnpc.drop14 = Convert.ToInt32(row["a_item_14"]); tnpc.drop15 = Convert.ToInt32(row["a_item_15"]); tnpc.drop16 = Convert.ToInt32(row["a_item_16"]); tnpc.drop17 = Convert.ToInt32(row["a_item_17"]); tnpc.drop18 = Convert.ToInt32(row["a_item_18"]); tnpc.drop19 = Convert.ToInt32(row["a_item_19"]); tnpc.droprate0 = Convert.ToInt32(row["a_item_percent_0"]); tnpc.droprate1 = Convert.ToInt32(row["a_item_percent_1"]); tnpc.droprate2 = Convert.ToInt32(row["a_item_percent_2"]); tnpc.droprate3 = Convert.ToInt32(row["a_item_percent_3"]); tnpc.droprate4 = Convert.ToInt32(row["a_item_percent_4"]); tnpc.droprate5 = Convert.ToInt32(row["a_item_percent_5"]); tnpc.droprate6 = Convert.ToInt32(row["a_item_percent_6"]); tnpc.droprate7 = Convert.ToInt32(row["a_item_percent_7"]); tnpc.droprate8 = Convert.ToInt32(row["a_item_percent_8"]); tnpc.droprate9 = Convert.ToInt32(row["a_item_percent_9"]); tnpc.droprate10 = Convert.ToInt32(row["a_item_percent_10"]); tnpc.droprate11 = Convert.ToInt32(row["a_item_percent_11"]); tnpc.droprate12 = Convert.ToInt32(row["a_item_percent_12"]); tnpc.droprate13 = Convert.ToInt32(row["a_item_percent_13"]); tnpc.droprate14 = Convert.ToInt32(row["a_item_percent_14"]); tnpc.droprate15 = Convert.ToInt32(row["a_item_percent_15"]); tnpc.droprate16 = Convert.ToInt32(row["a_item_percent_16"]); tnpc.droprate17 = Convert.ToInt32(row["a_item_percent_17"]); tnpc.droprate18 = Convert.ToInt32(row["a_item_percent_18"]); tnpc.droprate19 = Convert.ToInt32(row["a_item_percent_19"]); tnpc.minplus = Convert.ToInt32(row["a_minplus"]); tnpc.maxplus = Convert.ToInt32(row["a_maxplus"]); tnpc.probplus = Convert.ToInt32(row["a_probplus"]); tnpc.product0 = Convert.ToInt32(row["a_product0"]); tnpc.product1 = Convert.ToInt32(row["a_product1"]); tnpc.product2 = Convert.ToInt32(row["a_product2"]); tnpc.product3 = Convert.ToInt32(row["a_product3"]); tnpc.product4 = Convert.ToInt32(row["a_product4"]); tnpc.filesmc = Convert.ToString(row["a_file_smc"]); tnpc.motionwalk = Convert.ToString(row["a_motion_walk"]); tnpc.motionidle = Convert.ToString(row["a_motion_idle"]); tnpc.motiondam = Convert.ToString(row["a_motion_dam"]); tnpc.motionattack = Convert.ToString(row["a_motion_attack"]); tnpc.motiondie = Convert.ToString(row["a_motion_die"]); tnpc.motionrun = Convert.ToString(row["a_motion_run"]); tnpc.motionidle2 = Convert.ToString(row["a_motion_idle2"]); tnpc.motionattack2 = Convert.ToString(row["a_motion_attack2"]); tnpc.scale = Convert.ToSingle(row["a_scale"]); tnpc.attribute = Convert.ToInt32(row["a_attribute"]); tnpc.firedelaycount = Convert.ToInt32(row["a_fireDelayCount"]); tnpc.firedelay0 = Convert.ToSingle(row["a_fireDelay0"]); tnpc.firedelay1 = Convert.ToSingle(row["a_fireDelay1"]); tnpc.firedelay2 = Convert.ToSingle(row["a_fireDelay2"]); tnpc.firedelay3 = Convert.ToSingle(row["a_fireDelay3"]); tnpc.fireeffect0 = Convert.ToString(row["a_fireEffect0"]); tnpc.fireeffect1 = Convert.ToString(row["a_fireEffect1"]); tnpc.fireeffect2 = Convert.ToString(row["a_fireEffect2"]); tnpc.fireobject = Convert.ToInt32(row["a_fireObject"]); tnpc.firespeed = Convert.ToSingle(row["a_fireSpeed"]); tnpc.aitype = Convert.ToInt32(row["a_aitype"]); tnpc.aiflag = Convert.ToInt32(row["a_aiflag"]); tnpc.aileaderflag = Convert.ToInt32(row["a_aileader_flag"]); tnpc.aisummonhp = Convert.ToInt32(row["a_ai_summonHp"]); tnpc.aileaderidx = Convert.ToInt32(row["a_aileader_idx"]); tnpc.aileadercount = Convert.ToInt32(row["a_aileader_count"]); tnpc.npcchoicetriggercount = Convert.ToInt32(row["a_npc_choice_trigger_count"]); tnpc.npcchoicetriggerids = Convert.ToString(row["a_npc_choice_trigger_ids"]); tnpc.npcchoicetriggercount = Convert.ToInt32(row["a_npc_kill_trigger_count"]); tnpc.npckilltriggerids = Convert.ToString(row["a_npc_kill_trigger_ids"]); tnpc.createprob = Convert.ToInt32(row["a_createprob"]); tnpc.socketprob0 = Convert.ToInt32(row["a_socketprob_0"]); tnpc.socketprob1 = Convert.ToInt32(row["a_socketprob_1"]); tnpc.socketprob2 = Convert.ToInt32(row["a_socketprob_2"]); tnpc.socketprob3 = Convert.ToInt32(row["a_socketprob_3"]); tnpc.jewel0 = Convert.ToInt32(row["a_jewel_0"]); tnpc.jewel1 = Convert.ToInt32(row["a_jewel_1"]); tnpc.jewel2 = Convert.ToInt32(row["a_jewel_2"]); tnpc.jewel3 = Convert.ToInt32(row["a_jewel_3"]); tnpc.jewel4 = Convert.ToInt32(row["a_jewel_4"]); tnpc.jewel5 = Convert.ToInt32(row["a_jewel_5"]); tnpc.jewel6 = Convert.ToInt32(row["a_jewel_6"]); tnpc.jewel7 = Convert.ToInt32(row["a_jewel_7"]); tnpc.jewel8 = Convert.ToInt32(row["a_jewel_8"]); tnpc.jewel9 = Convert.ToInt32(row["a_jewel_9"]); tnpc.jewel10 = Convert.ToInt32(row["a_jewel_10"]); tnpc.jewel11 = Convert.ToInt32(row["a_jewel_11"]); tnpc.jewel12 = Convert.ToInt32(row["a_jewel_12"]); tnpc.jewel13 = Convert.ToInt32(row["a_jewel_13"]); tnpc.jewel14 = Convert.ToInt32(row["a_jewel_14"]); tnpc.jewel15 = Convert.ToInt32(row["a_jewel_15"]); tnpc.jewel16 = Convert.ToInt32(row["a_jewel_16"]); tnpc.jewel17 = Convert.ToInt32(row["a_jewel_17"]); tnpc.jewel18 = Convert.ToInt32(row["a_jewel_18"]); tnpc.jewel19 = Convert.ToInt32(row["a_jewel_19"]); tnpc.jeweldrop0 = Convert.ToInt32(row["a_jewel_percent_0"]); tnpc.jeweldrop1 = Convert.ToInt32(row["a_jewel_percent_1"]); tnpc.jeweldrop2 = Convert.ToInt32(row["a_jewel_percent_2"]); tnpc.jeweldrop3 = Convert.ToInt32(row["a_jewel_percent_3"]); tnpc.jeweldrop4 = Convert.ToInt32(row["a_jewel_percent_4"]); tnpc.jeweldrop5 = Convert.ToInt32(row["a_jewel_percent_5"]); tnpc.jeweldrop6 = Convert.ToInt32(row["a_jewel_percent_6"]); tnpc.jeweldrop7 = Convert.ToInt32(row["a_jewel_percent_7"]); tnpc.jeweldrop8 = Convert.ToInt32(row["a_jewel_percent_8"]); tnpc.jeweldrop9 = Convert.ToInt32(row["a_jewel_percent_9"]); tnpc.jeweldrop10 = Convert.ToInt32(row["a_jewel_percent_10"]); tnpc.jeweldrop11 = Convert.ToInt32(row["a_jewel_percent_11"]); tnpc.jeweldrop12 = Convert.ToInt32(row["a_jewel_percent_12"]); tnpc.jeweldrop13 = Convert.ToInt32(row["a_jewel_percent_13"]); tnpc.jeweldrop14 = Convert.ToInt32(row["a_jewel_percent_14"]); tnpc.jeweldrop15 = Convert.ToInt32(row["a_jewel_percent_15"]); tnpc.jeweldrop16 = Convert.ToInt32(row["a_jewel_percent_16"]); tnpc.jeweldrop17 = Convert.ToInt32(row["a_jewel_percent_17"]); tnpc.jeweldrop18 = Convert.ToInt32(row["a_jewel_percent_18"]); tnpc.jeweldrop19 = Convert.ToInt32(row["a_jewel_percent_19"]); tnpc.zoneflag = Convert.ToInt64(row["a_zone_flag"]); tnpc.extraflag = Convert.ToInt64(row["a_extra_flag"]); tnpc.rvrvalue = Convert.ToInt32(row["a_rvr_value"]); tnpc.rvrgrade = Convert.ToInt32(row["a_rvr_grade"]); tnpc.bound = Convert.ToInt32(row["a_bound"]); tnpc.lifetime = Convert.ToInt32(row["a_lifetime"]); AllLists.tnpc_MenuData.Add(tnpc); AllLists.tnpc_Menu.Add(tnpc.index.ToString() + " - " + tnpc.name.ToString()); } }
public static void tnpc_Update(tnpc npc) { try { using (MySqlConnection mySqlConnection = new MySqlConnection(mySQL.ConnectionString)) { MySqlCommand mySqlCommand = new MySqlCommand(); mySqlConnection.Open(); mySqlCommand.Connection = mySqlConnection; string str = "INSERT INTO t_npc (" + "a_index, " + "a_enable ," + "a_name ," + "a_family ," + "a_skillmaster ," + "a_flag ," + "a_flag1 ," + "a_state_flag ," + "a_level ," + "a_exp ," + "a_prize ," + "a_sight ," + "a_size ," + "a_move_area ," + "a_attack_area ," + "a_skill_point ," + "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_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 ," + "a_zone_flag ," + "a_extra_flag ," + "a_rvr_value ," + "a_rvr_grade ," + "a_bound ," + "a_lifetime" + ")" + "VALUES (" + "@index, " + "@enable ," + "@name ," + "@family ," + "@skillmaster ," + "@flag ," + "@flag1 ," + "@state_flag ," + "@level ," + "@exp ," + "@prize ," + "@sight ," + "@size ," + "@move_area ," + "@attack_area ," + "@skill_point ," + "@sskill_master ," + "@str ," + "@dex ," + "@int ," + "@con ," + "@attack ," + "@magic ," + "@defense ," + "@resist ," + "@attacklevel ," + "@defenselevel ," + "@hp ," + "@mp ," + "@attackType ," + "@attackSpeed ," + "@recover_hp ," + "@recover_mp ," + "@walk_speed ," + "@run_speed ," + "@skill0 ," + "@skill1 ," + "@skill2 ," + "@skill3 ," + "@item_0 ," + "@item_1 ," + "@item_2 ," + "@item_3 ," + "@item_4 ," + "@item_5 ," + "@item_6 ," + "@item_7 ," + "@item_8 ," + "@item_9 ," + "@item_10 ," + "@item_11 ," + "@item_12 ," + "@item_13 ," + "@item_14 ," + "@item_15 ," + "@item_16 ," + "@item_17 ," + "@item_18 ," + "@item_19 ," + "@item_percent_0 ," + "@item_percent_1 ," + "@item_percent_2 ," + "@item_percent_3 ," + "@item_percent_4 ," + "@item_percent_5 ," + "@item_percent_6 ," + "@item_percent_7 ," + "@item_percent_8 ," + "@item_percent_9 ," + "@item_percent_10 ," + "@item_percent_11 ," + "@item_percent_12 ," + "@item_percent_13 ," + "@item_percent_14 ," + "@item_percent_15 ," + "@item_percent_16 ," + "@item_percent_17 ," + "@item_percent_18 ," + "@item_percent_19 ," + "@minplus ," + "@maxplus ," + "@probplus ," + "@product0 ," + "@product1 ," + "@product2 ," + "@product3 ," + "@product4 ," + "@file_smc ," + "@motion_walk ," + "@motion_idle ," + "@motion_dam ," + "@motion_attack ," + "@motion_die ," + "@motion_run ," + "@motion_idle2 ," + "@motion_attack2 ," + "@scale ," + "@attribute ," + "@fireDelayCount ," + "@fireDelay0 ," + "@fireDelay1 ," + "@fireDelay2 ," + "@fireDelay3 ," + "@fireEffect0 ," + "@fireEffect1 ," + "@fireEffect2 ," + "@fireObject ," + "@fireSpeed ," + "@aitype ," + "@aiflag ," + "@aileader_flag ," + "@ai_summonHp ," + "@aileader_idx ," + "@aileader_count ," + "@crafting_category ," + "@productIndex ," + "@hit ," + "@dodge ," + "@magicavoid ," + "@job_attribute ," + "@npc_choice_trigger_count ," + "@npc_choice_trigger_ids ," + "@npc_kill_trigger_count ," + "@npc_kill_trigger_ids ," + "@createprob ," + "@socketprob_0 ," + "@socketprob_1 ," + "@socketprob_2 ," + "@socketprob_3 ," + "@jewel_0 ," + "@jewel_1 ," + "@jewel_2 ," + "@jewel_3 ," + "@jewel_4 ," + "@jewel_5 ," + "@jewel_6 ," + "@jewel_7 ," + "@jewel_8 ," + "@jewel_9 ," + "@jewel_10 ," + "@jewel_11 ," + "@jewel_12 ," + "@jewel_13 ," + "@jewel_14 ," + "@jewel_15 ," + "@jewel_16 ," + "@jewel_17 ," + "@jewel_18 ," + "@jewel_19 ," + "@jewel_percent_0 ," + "@jewel_percent_1 ," + "@jewel_percent_2 ," + "@jewel_percent_3 ," + "@jewel_percent_4 ," + "@jewel_percent_5 ," + "@jewel_percent_6 ," + "@jewel_percent_7 ," + "@jewel_percent_8 ," + "@jewel_percent_9 ," + "@jewel_percent_10 ," + "@jewel_percent_11 ," + "@jewel_percent_12 ," + "@jewel_percent_13 ," + "@jewel_percent_14 ," + "@jewel_percent_15 ," + "@jewel_percent_16 ," + "@jewel_percent_17 ," + "@jewel_percent_18 ," + "@jewel_percent_19 ," + "@zone_flag ," + "@extraflag ," + "@rvr_value ," + "@rvr_grade ," + "@bound ," + "@lifetime " + ")"; mySqlCommand.CommandText = str; mySqlCommand.Prepare(); mySqlCommand.Parameters.AddWithValue("@index", npc.index); mySqlCommand.Parameters.AddWithValue("@enable", npc.enable); mySqlCommand.Parameters.AddWithValue("@name", npc.name); mySqlCommand.Parameters.AddWithValue("@family", npc.family); mySqlCommand.Parameters.AddWithValue("@skillmaster", npc.skillmaster); mySqlCommand.Parameters.AddWithValue("@flag", npc.flag); mySqlCommand.Parameters.AddWithValue("@flag1", npc.flag1); mySqlCommand.Parameters.AddWithValue("@state_flag", npc.stateflag); mySqlCommand.Parameters.AddWithValue("@level", npc.level); mySqlCommand.Parameters.AddWithValue("@exp", npc.exp); mySqlCommand.Parameters.AddWithValue("@prize", npc.prize); mySqlCommand.Parameters.AddWithValue("@sight", npc.sight); mySqlCommand.Parameters.AddWithValue("@size", npc.size); mySqlCommand.Parameters.AddWithValue("@move_area", npc.movearea); mySqlCommand.Parameters.AddWithValue("@attack_area", npc.attackarea); mySqlCommand.Parameters.AddWithValue("@skill_point", npc.skillpoint); mySqlCommand.Parameters.AddWithValue("@sskill_master", npc.sskillmaster); mySqlCommand.Parameters.AddWithValue("@str", npc.str); mySqlCommand.Parameters.AddWithValue("@dex", npc.dex); mySqlCommand.Parameters.AddWithValue("@int", npc.INT); mySqlCommand.Parameters.AddWithValue("@con", npc.con); mySqlCommand.Parameters.AddWithValue("@attack", npc.attack); mySqlCommand.Parameters.AddWithValue("@magic", npc.magic); mySqlCommand.Parameters.AddWithValue("@defense", npc.defense); mySqlCommand.Parameters.AddWithValue("@resist", npc.resist); mySqlCommand.Parameters.AddWithValue("@attacklevel", npc.attacklevel); mySqlCommand.Parameters.AddWithValue("@defenselevel", npc.defenselevel); mySqlCommand.Parameters.AddWithValue("@hp", npc.hp); mySqlCommand.Parameters.AddWithValue("@mp", npc.mp); mySqlCommand.Parameters.AddWithValue("@attackType", npc.attacktype); mySqlCommand.Parameters.AddWithValue("@attackSpeed", npc.attackspeed); mySqlCommand.Parameters.AddWithValue("@recover_hp", npc.recoverhp); mySqlCommand.Parameters.AddWithValue("@recover_mp", npc.recovermp); mySqlCommand.Parameters.AddWithValue("@walk_speed", npc.walkspeed); mySqlCommand.Parameters.AddWithValue("@run_speed", npc.runspeed); mySqlCommand.Parameters.AddWithValue("@skill0", npc.skill0); mySqlCommand.Parameters.AddWithValue("@skill1", npc.skill1); mySqlCommand.Parameters.AddWithValue("@skill2", npc.skill2); mySqlCommand.Parameters.AddWithValue("@skill3", npc.skill3); mySqlCommand.Parameters.AddWithValue("@item_0", npc.drop0); mySqlCommand.Parameters.AddWithValue("@item_1", npc.drop1); mySqlCommand.Parameters.AddWithValue("@item_2", npc.drop2); mySqlCommand.Parameters.AddWithValue("@item_3", npc.drop3); mySqlCommand.Parameters.AddWithValue("@item_4", npc.drop4); mySqlCommand.Parameters.AddWithValue("@item_5", npc.drop5); mySqlCommand.Parameters.AddWithValue("@item_6", npc.drop6); mySqlCommand.Parameters.AddWithValue("@item_7", npc.drop7); mySqlCommand.Parameters.AddWithValue("@item_8", npc.drop8); mySqlCommand.Parameters.AddWithValue("@item_9", npc.drop9); mySqlCommand.Parameters.AddWithValue("@item_10", npc.drop10); mySqlCommand.Parameters.AddWithValue("@item_11", npc.drop11); mySqlCommand.Parameters.AddWithValue("@item_12", npc.drop12); mySqlCommand.Parameters.AddWithValue("@item_13", npc.drop13); mySqlCommand.Parameters.AddWithValue("@item_14", npc.drop14); mySqlCommand.Parameters.AddWithValue("@item_15", npc.drop15); mySqlCommand.Parameters.AddWithValue("@item_16", npc.drop16); mySqlCommand.Parameters.AddWithValue("@item_17", npc.drop17); mySqlCommand.Parameters.AddWithValue("@item_18", npc.drop18); mySqlCommand.Parameters.AddWithValue("@item_19", npc.drop19); mySqlCommand.Parameters.AddWithValue("@item_percent_0", npc.droprate0); mySqlCommand.Parameters.AddWithValue("@item_percent_1", npc.droprate1); mySqlCommand.Parameters.AddWithValue("@item_percent_2", npc.droprate2); mySqlCommand.Parameters.AddWithValue("@item_percent_3", npc.droprate3); mySqlCommand.Parameters.AddWithValue("@item_percent_4", npc.droprate4); mySqlCommand.Parameters.AddWithValue("@item_percent_5", npc.droprate5); mySqlCommand.Parameters.AddWithValue("@item_percent_6", npc.droprate6); mySqlCommand.Parameters.AddWithValue("@item_percent_7", npc.droprate7); mySqlCommand.Parameters.AddWithValue("@item_percent_8", npc.droprate8); mySqlCommand.Parameters.AddWithValue("@item_percent_9", npc.droprate9); mySqlCommand.Parameters.AddWithValue("@item_percent_10", npc.droprate10); mySqlCommand.Parameters.AddWithValue("@item_percent_11", npc.droprate11); mySqlCommand.Parameters.AddWithValue("@item_percent_12", npc.droprate12); mySqlCommand.Parameters.AddWithValue("@item_percent_13", npc.droprate13); mySqlCommand.Parameters.AddWithValue("@item_percent_14", npc.droprate14); mySqlCommand.Parameters.AddWithValue("@item_percent_15", npc.droprate15); mySqlCommand.Parameters.AddWithValue("@item_percent_16", npc.droprate16); mySqlCommand.Parameters.AddWithValue("@item_percent_17", npc.droprate17); mySqlCommand.Parameters.AddWithValue("@item_percent_18", npc.droprate18); mySqlCommand.Parameters.AddWithValue("@item_percent_19", npc.droprate19); mySqlCommand.Parameters.AddWithValue("@minplus", npc.minplus); mySqlCommand.Parameters.AddWithValue("@maxplus", npc.maxplus); mySqlCommand.Parameters.AddWithValue("@probplus", npc.probplus); mySqlCommand.Parameters.AddWithValue("@product0", npc.product0); mySqlCommand.Parameters.AddWithValue("@product1", npc.product1); mySqlCommand.Parameters.AddWithValue("@product2", npc.product2); mySqlCommand.Parameters.AddWithValue("@product3", npc.product3); mySqlCommand.Parameters.AddWithValue("@product4", npc.product4); mySqlCommand.Parameters.AddWithValue("@file_smc", npc.filesmc); mySqlCommand.Parameters.AddWithValue("@motion_walk", npc.motionwalk); mySqlCommand.Parameters.AddWithValue("@motion_idle", npc.motionidle); mySqlCommand.Parameters.AddWithValue("@motion_dam", npc.motiondam); mySqlCommand.Parameters.AddWithValue("@motion_attack", npc.motionattack); mySqlCommand.Parameters.AddWithValue("@motion_die", npc.motiondie); mySqlCommand.Parameters.AddWithValue("@motion_run", npc.motionrun); mySqlCommand.Parameters.AddWithValue("@motion_idle2", npc.motionidle2); mySqlCommand.Parameters.AddWithValue("@motion_attack2", npc.motionattack2); mySqlCommand.Parameters.AddWithValue("@scale", npc.scale); mySqlCommand.Parameters.AddWithValue("@attribute", npc.attribute); mySqlCommand.Parameters.AddWithValue("@fireDelayCount", npc.firedelaycount); mySqlCommand.Parameters.AddWithValue("@fireDelay0", npc.firedelay0); mySqlCommand.Parameters.AddWithValue("@fireDelay1", npc.firedelay1); mySqlCommand.Parameters.AddWithValue("@fireDelay2", npc.firedelay2); mySqlCommand.Parameters.AddWithValue("@fireDelay3", npc.firedelay3); mySqlCommand.Parameters.AddWithValue("@fireEffect0", npc.fireeffect0); mySqlCommand.Parameters.AddWithValue("@fireEffect1", npc.fireeffect1); mySqlCommand.Parameters.AddWithValue("@fireEffect2", npc.fireeffect2); mySqlCommand.Parameters.AddWithValue("@fireObject", npc.fireobject); mySqlCommand.Parameters.AddWithValue("@fireSpeed", npc.firespeed); mySqlCommand.Parameters.AddWithValue("@aitype", npc.aitype); mySqlCommand.Parameters.AddWithValue("@aiflag", npc.aiflag); mySqlCommand.Parameters.AddWithValue("@aileader_flag", npc.aileaderflag); mySqlCommand.Parameters.AddWithValue("@ai_summonHp", npc.aisummonhp); mySqlCommand.Parameters.AddWithValue("@aileader_idx", npc.aileaderidx); mySqlCommand.Parameters.AddWithValue("@aileader_count", npc.aileadercount); mySqlCommand.Parameters.AddWithValue("@crafting_category", npc.craftingcategory); mySqlCommand.Parameters.AddWithValue("@productIndex", npc.productindex); mySqlCommand.Parameters.AddWithValue("@hit", npc.hit); mySqlCommand.Parameters.AddWithValue("@dodge", npc.dodge); mySqlCommand.Parameters.AddWithValue("@magicavoid", npc.magicavoid); mySqlCommand.Parameters.AddWithValue("@job_attribute", npc.jobattribute); mySqlCommand.Parameters.AddWithValue("@npc_choice_trigger_count", npc.npcchoicetriggercount); mySqlCommand.Parameters.AddWithValue("@npc_choice_trigger_ids", npc.npcchoicetriggerids); mySqlCommand.Parameters.AddWithValue("@npc_kill_trigger_count", npc.npckilltriggercount); mySqlCommand.Parameters.AddWithValue("@npc_kill_trigger_ids", npc.npckilltriggerids); mySqlCommand.Parameters.AddWithValue("@createprob", npc.createprob); mySqlCommand.Parameters.AddWithValue("@socketprob_0", npc.socketprob0); mySqlCommand.Parameters.AddWithValue("@socketprob_1", npc.socketprob1); mySqlCommand.Parameters.AddWithValue("@socketprob_2", npc.socketprob2); mySqlCommand.Parameters.AddWithValue("@socketprob_3", npc.socketprob3); mySqlCommand.Parameters.AddWithValue("@jewel_0", npc.jewel0); mySqlCommand.Parameters.AddWithValue("@jewel_1", npc.jewel1); mySqlCommand.Parameters.AddWithValue("@jewel_2", npc.jewel2); mySqlCommand.Parameters.AddWithValue("@jewel_3", npc.jewel3); mySqlCommand.Parameters.AddWithValue("@jewel_4", npc.jewel4); mySqlCommand.Parameters.AddWithValue("@jewel_5", npc.jewel5); mySqlCommand.Parameters.AddWithValue("@jewel_6", npc.jewel6); mySqlCommand.Parameters.AddWithValue("@jewel_7", npc.jewel7); mySqlCommand.Parameters.AddWithValue("@jewel_8", npc.jewel8); mySqlCommand.Parameters.AddWithValue("@jewel_9", npc.jewel9); mySqlCommand.Parameters.AddWithValue("@jewel_10", npc.jewel0); mySqlCommand.Parameters.AddWithValue("@jewel_11", npc.jewel1); mySqlCommand.Parameters.AddWithValue("@jewel_12", npc.jewel2); mySqlCommand.Parameters.AddWithValue("@jewel_13", npc.jewel3); mySqlCommand.Parameters.AddWithValue("@jewel_14", npc.jewel4); mySqlCommand.Parameters.AddWithValue("@jewel_15", npc.jewel5); mySqlCommand.Parameters.AddWithValue("@jewel_16", npc.jewel6); mySqlCommand.Parameters.AddWithValue("@jewel_17", npc.jewel7); mySqlCommand.Parameters.AddWithValue("@jewel_18", npc.jewel8); mySqlCommand.Parameters.AddWithValue("@jewel_19", npc.jewel9); mySqlCommand.Parameters.AddWithValue("@jewel_percent_0", npc.jeweldrop0); mySqlCommand.Parameters.AddWithValue("@jewel_percent_1", npc.jeweldrop1); mySqlCommand.Parameters.AddWithValue("@jewel_percent_2", npc.jeweldrop2); mySqlCommand.Parameters.AddWithValue("@jewel_percent_3", npc.jeweldrop3); mySqlCommand.Parameters.AddWithValue("@jewel_percent_4", npc.jeweldrop4); mySqlCommand.Parameters.AddWithValue("@jewel_percent_5", npc.jeweldrop5); mySqlCommand.Parameters.AddWithValue("@jewel_percent_6", npc.jeweldrop6); mySqlCommand.Parameters.AddWithValue("@jewel_percent_7", npc.jeweldrop7); mySqlCommand.Parameters.AddWithValue("@jewel_percent_8", npc.jeweldrop8); mySqlCommand.Parameters.AddWithValue("@jewel_percent_9", npc.jeweldrop9); mySqlCommand.Parameters.AddWithValue("@jewel_percent_10", npc.jeweldrop10); mySqlCommand.Parameters.AddWithValue("@jewel_percent_11", npc.jeweldrop11); mySqlCommand.Parameters.AddWithValue("@jewel_percent_12", npc.jeweldrop12); mySqlCommand.Parameters.AddWithValue("@jewel_percent_13", npc.jeweldrop13); mySqlCommand.Parameters.AddWithValue("@jewel_percent_14", npc.jeweldrop14); mySqlCommand.Parameters.AddWithValue("@jewel_percent_15", npc.jeweldrop15); mySqlCommand.Parameters.AddWithValue("@jewel_percent_16", npc.jeweldrop16); mySqlCommand.Parameters.AddWithValue("@jewel_percent_17", npc.jeweldrop17); mySqlCommand.Parameters.AddWithValue("@jewel_percent_18", npc.jeweldrop18); mySqlCommand.Parameters.AddWithValue("@jewel_percent_19", npc.jeweldrop19); mySqlCommand.Parameters.AddWithValue("@zone_flag", npc.zoneflag); mySqlCommand.Parameters.AddWithValue("@extraflag", npc.extraflag); mySqlCommand.Parameters.AddWithValue("@rvr_value", npc.rvrvalue); mySqlCommand.Parameters.AddWithValue("@rvr_grade", npc.rvrgrade); mySqlCommand.Parameters.AddWithValue("@bound", npc.bound); mySqlCommand.Parameters.AddWithValue("@lifetime", npc.lifetime); mySqlCommand.ExecuteNonQuery(); mySqlConnection.Close(); } } catch (MySqlException ex) { int num = (int)MessageBox.Show(ex.Message.ToString()); } }