public static void fetchMonster(ListBox lstMonster)
{
World.monster = new Dictionary <string, Monster>();
MUDEdit.monsterModel = "";
var response = MUDEdit.querySQL("SHOW COLUMNS FROM monster");
var rdr = response.rdr;
while (rdr.Read())
{
MUDEdit.monsterModel += rdr.GetString(0) + ",";
}
response.con.Close();
MUDEdit.monsterModel = MUDEdit.monsterModel.Substring(0, MUDEdit.monsterModel.Length - 1);
Monster m;
response = MUDEdit.querySQL("SELECT " + MUDEdit.monsterModel + " FROM monster");
rdr = response.rdr;
lstMonster.Items.Clear();
while (rdr.Read())
{
String name = rdr.GetString(0);
m = new Monster(name);
World.monster[name] = m;
lstMonster.Items.Add(rdr.GetString(0));
string[] split = MUDEdit.monsterModel.Split(',');
int c = 0;
foreach (string s in split)
{
m.fields[s] = rdr.GetValue(c);
c++;
}
}
response.con.Close();
}
void deleteArea(String name)
{
if (MUDEdit.executeSQL("DELETE FROM area WHERE name='" + name + "'"))
{
MUDEdit.curArea = null;
World.area.Remove(name);
MUDEdit.fetchArea(lstArea);
}
}
void deleteMonster(String name)
{
if (MUDEdit.executeSQL("DELETE FROM monster WHERE name='" + name + "'"))
{
MUDEdit.curMonster = null;
World.monster.Remove(name);
MUDEdit.fetchMonster(lstMonster);
}
}
bool addArea(String name)
{
if (!World.area.ContainsKey(name))
{
Area a = new Area(name);
World.area[name] = a;
if (MUDEdit.executeSQL("INSERT INTO area(name, json) VALUES('" + name + "','" + a.GetJSON() + "')"))
{
MUDEdit.fetchArea(lstArea);
MUDEdit.curArea = World.area[name];
MUDEdit.formArea = new FormArea();
MUDEdit.formArea.Show();
this.Hide();
return(true);
}
}
return(false);
}
bool addMonster(String name)
{
if (!World.monster.ContainsKey(name))
{
Monster m = new Monster(name);
World.monster[name] = m;
if (MUDEdit.executeSQL("INSERT INTO monster(name) VALUES('" + name + "')"))
{
MUDEdit.fetchMonster(lstMonster);
MUDEdit.curMonster = World.monster[name];
MUDEdit.formMonster = new FormMonster();
MUDEdit.formMonster.Show();
this.Hide();
return(true);
}
}
return(false);
}
public static void fetchArea(ListBox lstArea)
{
World.area = new Dictionary <string, Area>();
lstArea.Items.Clear();
Area a = new Area("a");
var response = MUDEdit.querySQL("SELECT name,json FROM area");
var rdr = response.rdr;
while (rdr.Read())
{
String name = rdr.GetString(0);
Console.WriteLine(name);
try {
World.area[name] = (Area)Util.JSONToObject(rdr.GetString(1), a.GetType());
} catch (SqlNullValueException) {
continue;
}
World.area[name] = (Area)Util.JSONToObject(rdr.GetString(1), a.GetType());
lstArea.Items.Add(rdr.GetString(0));
}
response.con.Close();
}
private void btnFetchArea_Click(object sender, EventArgs e)
{
MUDEdit.fetchArea(lstArea);
}
private void btnFetchMob_Click(object sender, EventArgs e)
{
MUDEdit.fetchMonster(lstMonster);
}
private void tabMonster_Enter(object sender, EventArgs e)
{
MUDEdit.fetchMonster(lstMonster);
}
private void tabArea_Enter(object sender, EventArgs e)
{
MUDEdit.fetchArea(lstArea);
}
