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;
}
}
