public string ToSQL()
{
string sql = "REPLACE INTO gameobjectcache VALUES (";
sql += Entry + ", ";
sql += (int)Type + ", ";
sql += DisplayID + ", ";
sql += Name.ToSQL() + ", ";
sql += "'" + IconName.ToSQL() + "',";
sql += "'" + CastCaption.ToSQL() + "',";
sql += "'" + UnkString.ToSQL() + "',";
sql += Data.ToSQL() + ", ";
sql += Size + ", ";
sql += QuestItems.ToSQL() + ", ";
sql += Exp + ");";
return(sql);
}
public string ToSQL()
{
string sql = "REPLACE INTO creaturecache VALUES (";
sql += Entry + ", ";
sql += "'" + Name.ToSQL() + "', ";
sql += "'" + SubName.ToSQL() + "',";
sql += "'" + IconName.ToSQL() + "',";
sql += (int)TypeFlags1 + ", ";
sql += (int)TypeFlags2 + ", ";
sql += (int)Type + ", ";
sql += (int)Family + ", ";
sql += (int)Rank + ", ";
sql += KillCredit1 + ", ";
sql += KillCredit2 + ", ";
//sql += DisplayIDs.ToSQL() + ", ";
sql += HealthModifier + ", ";
sql += ManaModifier + ", ";
sql += (RacialLeader ? 1 : 0) + ", ";
sql += QuestItems.ToSQL() + ", ";
sql += MovementID + ", ";
sql += Exp + ");";
return(sql);
}
