public LootDrop(MySqlConnection connection, QueryConfig config)
: base(config)
{
_newQuery = _queries.GetExtensionQuery("NewInsert");
//_newQuery = _queries.ExtensionQueries.FirstOrDefault(x => x.Name == "NewInsert");
_connection = connection;
}
public DoorManagerDatabase(string zone, int version, MySqlConnection connection, QueryConfig config)
: base(zone, version, config)
{
_connection = connection;
RetrieveDoors(zone);
Created();
}
public LootDrop(int id,MySqlConnection connection, QueryConfig config)
: base(config)
{
_connection = connection;
_id = id;
Lookup(id);
}
public ZoneRoamAreasDatabase(string zone, MySqlConnection connection, QueryConfig config)
: base(zone, config)
{
_connection = connection;
var sql = String.Format(SelectString, SelectArgValues);
var results = Database.QueryHelper.RunQuery(_connection, sql);
foreach (var row in results)
{
var ra = new RoamArea(_queryConfig);
ra.SetProperties(Queries, row);
RoamAreas.Add(ra);
}
foreach (var area in RoamAreas)
{
sql = String.Format(area.SelectString, area.SelectArgValues);
results = Database.QueryHelper.RunQuery(_connection, sql);
foreach (var row in results)
{
var entry = new RoamAreaEntry(_queryConfig);
entry.SetProperties(area.Queries, row);
area.Vertices.Add(entry);
entry.Created();
}
area.Created();
}
this.Created();
}
public SpawnGroupAggregatorDatabase(MySqlConnection connection,QueryConfig config)
: base(config)
{
_connection = connection;
_getMaxId = Queries.GetExtensionQuery("GetMaxID");
_getByZone = Queries.GetExtensionQuery("GetByZone");
}
public ZoneGridsDatabase(string zone, MySqlConnection connection, QueryConfig config)
: base(zone, config)
{
_connection = connection;
Lookup();
Created();
}
public RoamAreaEntry(int number, int roamAreaId, string zone, QueryConfig config)
: base(config)
{
_roamAreaid = roamAreaId;
_zone = zone;
_number = number;
}
public ZoneSpawnsDatabase(MySqlConnection connection, QueryConfig config)
: base(config)
{
_connection = connection;
_allVersions = Queries.GetExtensionQuery("GetAllVersions");
_getMaxZoneId = Queries.GetExtensionQuery("GetMaxZoneID");
_getMaxId = Queries.GetExtensionQuery("GetMaxID");
}
public Waypoint(int gridId, int zoneId, int number, QueryConfig config)
: base(config)
{
GridId = gridId;
ZoneId = zoneId;
Number = number;
Dirty = false;
}
public NpcAggregatorDatabase(MySqlConnection connection, QueryConfig config)
: base(config)
{
_connection = connection;
_lookupByZone = _queries.GetExtensionQuery("LookupByZone");
_maxIdForZone = _queries.GetExtensionQuery("MaxIdForZone");
//_lookupByZone = _queries.ExtensionQueries.FirstOrDefault(x => x.Name == "LookupByZone");
//_maxIdForZone = _queries.ExtensionQueries.FirstOrDefault(x => x.Name == "MaxIdForZone");
}
public SpawnGroupEditTabViewModel(MySqlConnection connection,QueryConfig config)
{
if (connection != null && connection.State == System.Data.ConnectionState.Open)
{
_manager = new SpawnGroupAggregatorDatabase(connection, config);
_npcFinder = new NpcAggregatorDatabase(connection, config);
}
else
{
_manager = new SpawnGroupAggregatorLocal(config);
_npcFinder = new NpcAggregatorLocal(config);
}
_manager.DataLoaded += new SpawnGroupDataLoadedHandler(_manager_DataLoaded);
InitCommands();
}
public NpcTypeEditViewModel(MySqlConnection connection, EQEmu.Database.QueryConfig config, NpcPropertyTemplateManager templates)
{
_connection = connection;
_config = config;
_templates = templates;
_modelMappings = Npc.LoadModelMappings("modelmapping.xml");
if (connection != null && connection.State == System.Data.ConnectionState.Open)
{
_npcs = new NpcAggregatorDatabase(connection, config);
}
else
{
_npcs = new NpcAggregatorLocal(config);
}
_npcs.Created();
_npcs.NPCs.CollectionChanged += new System.Collections.Specialized.NotifyCollectionChangedEventHandler(NPCs_CollectionChanged);
Models.CollectionChanged += new System.Collections.Specialized.NotifyCollectionChangedEventHandler(Models_CollectionChanged);
}
public ZonePointsDatabase(string zone, MySqlConnection connection, QueryConfig config)
: base(zone,config)
{
_connection = connection;
string sql = String.Format(SelectString, SelectArgValues);
var results = QueryHelper.RunQuery(_connection, sql);
ZonePoint zp;
if (results != null)
{
foreach (Dictionary<string, object> row in results)
{
zp = new ZonePoint(_queryConfig);
zp.SetProperties(Queries, row);
zp.Created();
Points.Add(zp);
}
}
Created();
}
public static QueryConfig Create(XElement root)
{
var config = new QueryConfig();
if (root.Name != XMLTagName) return null;
foreach (var query in root.Elements(TypeQueries.XMLTagName))
{
var type = query.Attribute("type");
if (type == null) continue;
var objType = Assembly.GetExecutingAssembly().GetType(type.Value);
if (objType == null) continue;
config._typeQueryMappings[objType] = TypeQueries.Create(query);
}
foreach (var query in root.Elements(TypeQueriesExtension.XMLTagName))
{
var type = query.Attribute("type");
if (type == null) continue;
var objType = Assembly.GetExecutingAssembly().GetType(type.Value);
if (config._typeQueryMappings.ContainsKey(objType))
{
var obj = TypeQueriesExtension.Create(query) as TypeQueriesExtension;
if (obj != null)
{
config.TypeQueryMappings[objType].ExtensionQueries.Add(obj);
}
}
}
return config;
}
public ZoneGrids(string zone,QueryConfig config)
: base(config)
{
_zone = zone;
}
/*
public LootTable(int id,MySqlConnection connection, QueryConfig _config) : base(_config)
{
_connection = connection;
_id = id;
Lookup(id);
}
*/
public LootTable(MySqlConnection connection, QueryConfig config)
: base(config)
{
_connection = connection;
}
public LootTableAggregatorLocal(QueryConfig config)
: base(config)
{
}
public ZoneSpawnsLocal(QueryConfig config)
: base(config)
{
Created();
}
public ZoneRoamAreasLocal(string zone, QueryConfig config)
: base(zone, config)
{
Created();
}
public Door(QueryConfig config)
: base(config)
{
}
public ZoneSpawns(QueryConfig config)
: base(config)
{
}
public RoamAreaEntry(QueryConfig config)
: base(config)
{
}
public DoorManager(string zone,int version,QueryConfig config)
: base(config)
{
_zone = zone;
_version = version;
}
public LootDropEntry(MySqlConnection connection, QueryConfig _config)
: base(_config)
{
_connection = connection;
}
public ZonePoint(QueryConfig config)
: base(config)
{
}
public NpcAggregatorLocal(QueryConfig config)
: base(config)
{
}
public SpawnGroupDatabase(MySqlConnection connection, QueryConfig config)
: base(config)
{
_connection = connection;
_getSpawn2 = Queries.GetExtensionQuery("GetSpawn2");
}
public DoorManagerLocal(string zone, int version, QueryConfig config)
: base(zone, version, config)
{
Created();
}
public ZoneRoamAreas(string zone,QueryConfig config)
: base(config)
{
_zone = zone;
}
public Waypoint(QueryConfig config)
: base(config)
{
Dirty = false;
}
