/*
* This puts everything to their initial state, that needs setting thus (geez, brain fail!!!)
*/
private void initaliseStuff()
{
rtbHelpInformation.IsReadOnly = true;
defaultConfigSettings = new DefaultSettings();
// load default settings from file
defaultConfigSettings = FileHandling.loadDefaultSettings("configSettings.txt");
// set interface to reflect the default settings
txtGMCharactersName.Text = defaultConfigSettings.defaultNameOfCharacter;
txtId.Text = defaultConfigSettings.defaultCreatureGUID;
txtPoint.Text = defaultConfigSettings.defaultPoint;
txtCsvFileName.Text = defaultConfigSettings.defaultCSVFileNameForSaving;
txtDelimiterForSavedCSVFile.Text = defaultConfigSettings.defaultDelimiterForCSVFileSaving;
txtCSVFileNameToLoad.Text = defaultConfigSettings.defaultCSVFileNameForLoading;
txtDelimiterForLoadedCSVFile.Text = defaultConfigSettings.defaultDelimiterForCSVFileLoading;
txtSQLScriptFileName.Text = defaultConfigSettings.defaultSQLScriptFileName;
txtId.Text = defaultConfigSettings.defaultCreatureGUID;
radBiDirectionalPath.IsChecked = defaultConfigSettings.defaultBiDirectionalPathCheckedState;
radOneDirectionPath.IsChecked = defaultConfigSettings.defaultOneDirectionPathCheckedState;
radEntry.IsChecked = defaultConfigSettings.defaultEntryCheckedState;
radGuid.IsChecked = defaultConfigSettings.defaultGuidCheckedState;
bGUID = true;
bBirDirectionalPath = false;
}
/*
* save the default settings, so that we can use them each time the tool is run
*/
private void btnSaveDefaultSettings_Click(object sender, RoutedEventArgs e)
{
// assign current settings to the deafult settings data
defaultConfigSettings.defaultNameOfCharacter = txtGMCharactersName.Text;
defaultConfigSettings.defaultCreatureGUID = txtId.Text;
defaultConfigSettings.defaultPoint = txtPoint.Text;
defaultConfigSettings.defaultCSVFileNameForSaving = txtCsvFileName.Text;
defaultConfigSettings.defaultCSVFileNameForLoading = txtCSVFileNameToLoad.Text;
defaultConfigSettings.defaultSQLScriptFileName = txtSQLScriptFileName.Text;
defaultConfigSettings.defaultBiDirectionalPathCheckedState = (bool)radBiDirectionalPath.IsChecked;
defaultConfigSettings.defaultOneDirectionPathCheckedState = (bool)radOneDirectionPath.IsChecked;
defaultConfigSettings.defaultEntryCheckedState = (bool)radEntry.IsChecked;
defaultConfigSettings.defaultGuidCheckedState = (bool)radGuid.IsChecked;
// save - defaultSettings
FileHandling.saveDefaultSettings("configSettings.txt", defaultConfigSettings);
}
/*
* This loads an existing file that contains CSV data
*/
private void btnLoadCSVFile_Click(object sender, RoutedEventArgs e)
{
// clear the message panel
txtMessagePanel.Text = "";
string[] lineOfData;
char delimiter = txtDelimiterForLoadedCSVFile.Text[0];
// store the data
ArrayList listOfData = new ArrayList();
// load it
if (txtCSVFileNameToLoad.Text == "")
{
listOfData = FileHandling.loadFile("defaultCSVFileNameToLoad");
}
else
{
listOfData = FileHandling.loadFile(txtCSVFileNameToLoad.Text);
}
// store list in ListBox
if (listOfData.Count > 0) // make sure the loading of the CSV data worked
{
// check that the data is valid
foreach (object logLine in listOfData)
{
// split the data
lineOfData = logLine.ToString().Split(delimiter);
if (lineOfData.Length != 4) // must have 4 fields for this tool (X, Y, Z, Orientation)
{
// invalid data - number of elements
txtMessagePanel.Text = "Invalid make up of CSV file - it must contain exactly 4 values, each separated by the specified delimiter!";
break; // exit routine
}
}
lbContinentCoordinates.Items.Clear(); // make sure the ListBox is empty
foreach (object logLine in listOfData)
{
lbContinentCoordinates.Items.Add(logLine);
}
}
else
{
txtMessagePanel.Text = "CSV file was empty or does not exist!";
}
}
/*
* This saves the coordinates and orientation to a file in CSV form (e.g. X, Y, Z, Orientation)
*/
private void btnSaveToFile_Click(object sender, RoutedEventArgs e)
{
// place the contents of the ListBox into a list
ArrayList listOfData = new ArrayList();
for (int i = 0; i < lbContinentCoordinates.Items.Count; i++)
{
listOfData.Add(lbContinentCoordinates.Items[i]);
}
// save the data as is
string fileName = txtCsvFileName.Text;
if (txtCsvFileName.Text == "")
{
FileHandling.saveData("defaultCSVFileName", listOfData);
}
else
{
FileHandling.saveData(fileName, listOfData);
}
}
private void btnGrabData_Click(object sender, RoutedEventArgs e)
{
bool characterNameEntered = false;
if (txtGMCharactersName.Text == "")
{
// inform user of error
txtMessagePanel.Text = "";
txtMessagePanel.Text = "You must enter the name of the character you used to acquire the waypoint data!\r\n";
}
else
{
characterNameEntered = true;
}
bool guidEntered = false; // GUID in the creature table == ID in the creature_movement table
if (txtId.Text == "")
{
// inform user of error
txtMessagePanel.Text += @"You must enter the GUID of the character/NPC you acquired the waypoint data for!";
}
else
{
guidEntered = true;
}
// make sure the user has filled in the required fields - GM Character name and GUID of target creaure/NPC
if (characterNameEntered && guidEntered)
{
// load the log file
logfileList = FileHandling.loadFile("WoWChatLog.txt");
// did we successfully load the data
if (logfileList.Count > 0)
{
string xOrdinate = "";
string yOrdinate = "";
string zOrdinate = "";
// string orientation = "";
// add to the list box
lbContinentCoordinates.Items.Clear(); // make sure the ListBox is empty
foreach (object logLine in logfileList)
{
int startIndex;
int endIndex;
int numberOfChars;
string delimiter = txtDelimiterForSavedCSVFile.Text;
string text = logLine.ToString();
string characterName = txtGMCharactersName.Text;
if (text.IndexOf(characterName) != -1) // locate coords entry
{
// retrieve the X ordinate
startIndex = text.IndexOf("XStart") + 6;
endIndex = text.IndexOf("XEnd");
// grab the data (X ordinate)
numberOfChars = endIndex - startIndex - 1;
xOrdinate = text.Substring(startIndex, numberOfChars);
xOrdinate.Replace(" ", string.Empty);
// lbContinentCoordinates.Items.Add(logLine);
// Y ordinate
startIndex = text.IndexOf("YStart") + 6;
endIndex = text.IndexOf("YEnd");
// grab the data (Y ordinate)
numberOfChars = endIndex - startIndex - 1;
yOrdinate = text.Substring(startIndex, numberOfChars);
yOrdinate.Replace(" ", string.Empty);
// Z ordinate
startIndex = text.IndexOf("ZStart") + 6;
endIndex = text.IndexOf("ZEnd");
// grab the data (Z ordinate)
numberOfChars = endIndex - startIndex - 1;
zOrdinate = text.Substring(startIndex, numberOfChars);
zOrdinate.Replace(" ", "");
// Orientation - remove for now, as too many of these made the animation look very jerky
/*
* startIndex = text.IndexOf("OStart") + 6;
* endIndex = text.IndexOf("OEnd");
* // grab the data (orientation)
* numberOfChars = endIndex - startIndex - 1;
* orientation = text.Substring(startIndex, numberOfChars);
*/
lbContinentCoordinates.Items.Add(xOrdinate + delimiter + yOrdinate + delimiter + zOrdinate);
}
txtMessagePanel.Text = "Job done :-)";
}
}
else // the WoW log file was either empty or could not be loaded
{
txtMessagePanel.Text = "PROBLEM: The WowChatLog.txt file was either empty or could not be loaded. \r\n";
txtMessagePanel.Text += "Have you copied it from the Logs folder of the WoW installation, to the folder of this tool?";
}
}
}
/*
* This saves the data as a SQL script to a text file.
* In this case the SQL script adds records to the creature_movement table
*/
private void btnConvertToSql_Click(object sender, RoutedEventArgs e)
{
outputFileList.Clear();
string line;
string[] componentpart;
string sqlScript = "";
string id = txtId.Text;
int point = Convert.ToInt32(txtPoint.Text); // points in a path - means to know which order the entries are executed in - 1 to n
char delimiter = txtDelimiterForSavedCSVFile.Text[0];
string sTableName;
string sGuidOrEntry;
if (bGUID) // creature_movement
{
sTableName = "creature_movement";
sGuidOrEntry = "id";
}
else // creature_movement_template
{
sTableName = "creature_movement_template";
sGuidOrEntry = "entry";
}
// iterate through the ListBox, converting each entry to SQL script
for (int i = 0; i < lbContinentCoordinates.Items.Count; i++)
{
line = lbContinentCoordinates.Items[i].ToString();
// split the data into its component parts - X, Y, Z, Orientation
componentpart = line.Split(delimiter);
// add it to output list
sqlScript = "INSERT INTO " + sTableName + " (" + sGuidOrEntry + ", `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES (" + id + ", " + point + ", " + componentpart[0] + ", " + componentpart[1] + ", " + componentpart[2] + ", '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');";
point++; // next position in the path
outputFileList.Add(sqlScript);
}
// if we want a bi-directional path (back and forth along the same route)
// write coordinates, from the ListBox, in reverse order
if (bBirDirectionalPath)
{
for (int i = lbContinentCoordinates.Items.Count - 2; i >= 1; i--)
{
line = lbContinentCoordinates.Items[i].ToString();
// split the data into its component parts - X, Y, Z, Orientation
componentpart = line.Split(delimiter);
// add it to output list
sqlScript = "INSERT INTO " + sTableName + " (" + sGuidOrEntry + ", `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES (" + id + ", " + point + ", " + componentpart[0] + ", " + componentpart[1] + ", " + componentpart[2] + ", '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');";
point++; // next position in the path
outputFileList.Add(sqlScript);
}
}
// now save it to file
if (txtSQLScriptFileName.Text == "")
{
FileHandling.saveData("defaultSqlScriptFileName", outputFileList);
}
else
{
FileHandling.saveData(txtSQLScriptFileName.Text, outputFileList);
}
}
