public BuffParser(int start, int end) { for (int i = start; i < end; i++) { try { IniFileReader reader = new IniFileReader("C:\\Documents and Settings\\Josh\\Desktop\\buffdef.ini"); IniFileSectionStart test = reader.GotoSection("BUFF-"+i); List<IniFileValue> test2 = reader.ReadSectionValues(); foreach (IniFileValue r in test2) { valueLookup(test, r); } id = int.Parse(test.SectionName.Replace("BUFF-", "")); String query = "INSERT INTO buffs SET buff_id='" + id + "', type='"+type+"', "+ "asset_name='"+asset_name+"', asset_id='"+asset_id+"', tooltip='"+tooltip+"', "+ "alt_tooltip='"+alt_tooltip+"', is_good_buff='"+is_good_buff+"';"; DataTable buffInsert = Database.executeQuery(Database.DatabaseName.net7, query); Console.Out.WriteLine(query); reader.Close(); } catch (Exception e) { //Console.Out.WriteLine(e+", "+ e.Message); //throw; } } Console.Out.WriteLine("***** Finished *****"); }
public EffectsParser(int start, int end) { for (int i = start; i < end; i++) { try { IniFileReader reader = new IniFileReader("C:\\Documents and Settings\\Josh\\Desktop\\effect.ini"); IniFileSectionStart test = reader.GotoSection("EFFECT-"+i); List<IniFileValue> test2 = reader.ReadSectionValues(); //Console.Out.WriteLine(test.SectionName); foreach (IniFileValue r in test2) { sectionLookup(test, r); } int effectID = int.Parse(test.SectionName.Replace("EFFECT-", "")); String query = "INSERT INTO effects SET effect_id='"+effectID+"', effect_class='"+effectClass+"', descriiption='"+description+"', "+ "start_link_id='"+startLinkID+"', next_link_id='"+nextLinkID+"', base_asset_id='"+baseAssetID+"', "+ "sound_fx_file='"+soundFxFile+"';"; DataTable effectInsert = Database.executeQuery(Database.DatabaseName.net7, query); Console.Out.WriteLine(query); reader.Close(); } catch (Exception e) { //Console.Out.WriteLine(e+", "+ e.Message); //throw; } } Console.Out.WriteLine("***** Finished *****"); }
public SkillParser() { IniFileReader reader = new IniFileReader("C:\\Documents and Settings\\Josh\\Desktop\\cskill_t.ini"); IniFileSectionStart skillList = reader.GotoSection("All Skills"); List<IniFileValue> skillListNames = reader.ReadSectionValues(); foreach (IniFileValue r in skillListNames) { skill_id = int.Parse(r.Key.ToString()); String parsedName = r.Value.ToString(); skill_name = parsedName.Replace("'", "\\'"); IniFileReader reader2 = new IniFileReader("C:\\Documents and Settings\\Josh\\Desktop\\cskill_t.ini"); IniFileSectionStart skills = reader2.GotoSection(skill_name); List<IniFileValue> skillvalues = reader2.ReadSectionValues(); foreach (IniFileValue r2 in skillvalues) { valueLookup(skills, r2); } insertIntoDB(); reader2.Close(); } reader.Close(); Console.Out.WriteLine("***** Finished *****"); }
public BaseAssetParser() { for (int i = 0; i < 2411; i++) { rslid = -1; try { IniFileReader reader = new IniFileReader("C:\\Documents and Settings\\Josh\\Desktop\\basset.ini"); IniFileSectionStart test = reader.GotoSection("BASE-"+i); List<IniFileValue> test2 = reader.ReadSectionValues(); foreach (IniFileValue r in test2) { if(r.Key == "RSLID") { rslid = int.Parse(r.Value.ToString()); } } int id = int.Parse(test.SectionName.Replace("BASE-", "")); String query = "UPDATE assets SET rslid='"+rslid+"' where base_id='"+id+"';"; DataTable insert = Database.executeQuery(Database.DatabaseName.net7, query); Console.Out.WriteLine(query); reader.Close(); } catch (Exception e) { //Console.Out.WriteLine(e+", "+ e.Message); //throw; } } Console.Out.WriteLine("***** Finished *****"); }