private void valueLookup(IniFileSectionStart test, IniFileValue r) { String parsed = ""; switch (r.Key.ToString()) { case "BuffType": parsed = r.Value.ToString(); type = parsed.Replace("'", "\\'"); break; case "BuffAsset": parsed = r.Value.ToString(); asset_name = parsed.Replace("'", "\\'"); break; case "BuffToolTip": parsed = r.Value.ToString(); tooltip = parsed.Replace("'", "\\'"); break; case "BuffAltToolTip": parsed = r.Value.ToString(); alt_tooltip = parsed.Replace("'", "\\'"); break; case "IsGoodBuff": bool boolTest = bool.Parse(r.Value.ToString()); is_good_buff = Convert.ToInt32(boolTest); break; } }
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 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 *****"); }
private void sectionLookup(IniFileSectionStart test, IniFileValue r) { switch (r.Key.ToString()) { case "EffectClass": //valueLookup(r); Console.Out.WriteLine(r.Value); effectClass = r.Value.ToString(); break; case "Description": description = r.Value.ToString(); break; case "StartLinkID": startLinkID = int.Parse(r.Value.ToString()); break; case "NextLinkID": nextLinkID = int.Parse(r.Value.ToString()); break; case "BaseAssetID": baseAssetID = int.Parse(r.Value.ToString()); break; case "SFX": soundFxFile = r.Value.ToString(); break; } }
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 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 *****"); }
private void valueLookup(IniFileSectionStart test, IniFileValue r) { String parsed = ""; switch (r.Key.ToString()) { case "Activated": bool boolTest = bool.Parse(r.Value.ToString()); is_activated = Convert.ToInt32(boolTest); break; case "Category": parsed = r.Value.ToString(); category = parsed.Replace("'", "\\'"); break; case "Description": parsed = r.Value.ToString(); description = parsed.Replace("'", "\\'"); break; case "Desc_1": parsed = r.Value.ToString(); desc_1 = parsed.Replace("'", "\\'"); break; case "Desc_2": parsed = r.Value.ToString(); desc_2 = parsed.Replace("'", "\\'"); break; case "Desc_3": parsed = r.Value.ToString(); desc_3 = parsed.Replace("'", "\\'"); break; case "Desc_4": parsed = r.Value.ToString(); desc_4 = parsed.Replace("'", "\\'"); break; case "Desc_5": parsed = r.Value.ToString(); desc_5 = parsed.Replace("'", "\\'"); break; case "Desc_6": parsed = r.Value.ToString(); desc_6 = parsed.Replace("'", "\\'"); break; case "Desc_7": parsed = r.Value.ToString(); desc_7 = parsed.Replace("'", "\\'"); break; case "Desc_8": parsed = r.Value.ToString(); desc_8 = parsed.Replace("'", "\\'"); break; case "Desc_9": parsed = r.Value.ToString(); desc_9 = parsed.Replace("'", "\\'"); break; case "Range": //range = Convert.ToInt32(r.Value.ToString()); break; case "Warrior": warrior_max_level = Convert.ToInt32(r.Value.ToString()); break; case "Sentinel": sentinel_max_level = Convert.ToInt32(r.Value.ToString()); break; case "Privateer": privateer_max_level = Convert.ToInt32(r.Value.ToString()); break; case "Defender": defender_max_level = Convert.ToInt32(r.Value.ToString()); break; case "Explorer": explorer_max_level = Convert.ToInt32(r.Value.ToString()); break; case "Seeker": seeker_max_level = Convert.ToInt32(r.Value.ToString()); break; case "Enforcer": enforcer_max_level = Convert.ToInt32(r.Value.ToString()); break; case "Scout": scout_max_level = Convert.ToInt32(r.Value.ToString()); break; case "Tradesman": tradesman_max_level = Convert.ToInt32(r.Value.ToString()); break; } }