public void GenerateSQL()
{
mainForm.textBox_SQLOutput.Clear();
foreach (var npcsInMap in npcsByMap)
{
foreach (var npc in npcsInMap.Value)
{
uint itr = 0;
string SQLtext = "";
bool hasEvents = npc.Value.Events.Count > 0;
if (hasEvents)
{
SQLtext += "-- " + GetCreatureName(npc.Key) + "\r\n";
SQLtext += "UPDATE `creature_template` SET `AIName` = \"LegionCombatAI\", `ScriptName` = \"\" WHERE `entry` = " + npc.Key + ";\r\n";
SQLtext += "DELETE FROM `combat_ai_events` WHERE `entry` = " + npc.Key + ";\r\n";
SQLtext += "INSERT INTO `combat_ai_events` (`entry`, `id`, `start_min`, `start_max`, `repeat_min`, `repeat_max`, `repeat_fail`, `spell_id`, `event_check`, `event_flags`, `attack_dist`, `difficulty_mask`, `comment`) VALUES\r\n";
}
foreach (CombatAIEventDataEntry combatEntry in npc.Value.Events)
{
string query = CombatAICreator.CreateCombatEntryValues(combatEntry, itr);
if (itr + 1 >= npc.Value.Events.Count)
{
query += ";\r\n";
}
else
{
query += ",\r\n";
}
SQLtext += query;
itr++;
}
if (hasEvents)
{
SQLtext += "\r\n\n";
mainForm.textBox_SQLOutput.AppendText(SQLtext);
}
}
}
MessageBox.Show("SQL Queries Generated");
}
