/// <summary>
/// Loads the broadcast texts form the database.
/// </summary>
private static void LoadBroadcastText()
{
string query =
$"SELECT ID, MaleText, FemaleText FROM {Settings.HotfixesDatabase}.broadcast_text;";
using (var reader = SQLConnector.ExecuteQuery(query))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
var id = Convert.ToInt32(reader["Id"]);
var maleText = Convert.ToString(reader["MaleText"]);
var femaleText = Convert.ToString(reader["FemaleText"]);
if (!BroadcastMaleTexts.ContainsKey(maleText))
{
BroadcastMaleTexts[maleText] = new List <int>();
}
BroadcastMaleTexts[maleText].Add(id);
if (!BroadcastFemaleTexts.ContainsKey(femaleText))
{
BroadcastFemaleTexts[femaleText] = new List <int>();
}
BroadcastFemaleTexts[femaleText].Add(id);
}
}
}
/// <summary>
/// Loads the broadcast texts form the database.
/// </summary>
private static void LoadBroadcastText()
{
string query =
"SELECT ID, MaleText, FemaleText, EmoteID1, EmoteID2, EmoteID3, EmoteDelay1, EmoteDelay2, EmoteDelay3, UnkEmoteID, Language, Type, SoundID1, SoundID2, PlayerConditionID " +
$"FROM {Settings.HotfixesDatabase}.broadcast_text;";
using (var reader = SQLConnector.ExecuteQuery(query))
{
if (reader == null)
{
return;
}
while (reader.Read())
{
var id = Convert.ToInt32(reader["Id"]);
var maleText = Convert.ToString(reader["MaleText"]);
var femaleText = Convert.ToString(reader["FemaleText"]);
if (!BroadcastMaleTexts.ContainsKey(maleText))
{
BroadcastMaleTexts[maleText] = new List <int>();
}
BroadcastMaleTexts[maleText].Add(id);
if (!BroadcastFemaleTexts.ContainsKey(femaleText))
{
BroadcastFemaleTexts[femaleText] = new List <int>();
}
BroadcastFemaleTexts[femaleText].Add(id);
if (!Settings.UseDBC)
{
continue;
}
var broadcastText = new BroadcastTextEntry()
{
MaleText = maleText,
FemaleText = femaleText,
};
broadcastText.EmoteID = new ushort[3];
broadcastText.EmoteID[0] = Convert.ToUInt16(reader["EmoteID1"]);
broadcastText.EmoteID[1] = Convert.ToUInt16(reader["EmoteID2"]);
broadcastText.EmoteID[2] = Convert.ToUInt16(reader["EmoteID3"]);
broadcastText.EmoteDelay = new ushort[3];
broadcastText.EmoteDelay[0] = Convert.ToUInt16(reader["EmoteDelay1"]);
broadcastText.EmoteDelay[1] = Convert.ToUInt16(reader["EmoteDelay2"]);
broadcastText.EmoteDelay[2] = Convert.ToUInt16(reader["EmoteDelay3"]);
broadcastText.UnkEmoteID = Convert.ToUInt16(reader["UnkEmoteID"]);
broadcastText.Language = Convert.ToByte(reader["Language"]);
broadcastText.Type = Convert.ToByte(reader["Type"]);
broadcastText.SoundID = new uint[2];
broadcastText.SoundID[0] = Convert.ToUInt32(reader["SoundID1"]);
broadcastText.SoundID[1] = Convert.ToUInt32(reader["SoundID2"]);
broadcastText.PlayerConditionID = Convert.ToUInt32(reader["PlayerConditionID"]);
if (!DBC.DBC.BroadcastText.ContainsKey(id))
{
DBC.DBC.BroadcastText.Add(id, broadcastText);
}
else
{
DBC.DBC.BroadcastText[id] = broadcastText;
}
}
}
}
