public void DeleteMessages(int characterID, int mailboxID, PyList <PyInteger> messageIDs) { Database.PrepareQuery( $"DELETE FROM eveMail WHERE messageID IN ({PyString.Join(',', messageIDs)} AND channelID = @mailboxID", new Dictionary <string, object>() { { "@mailboxID", mailboxID } } ); }
public void DeleteBookmark(PyList <PyInteger> bookmarkIDs, int ownerID) { // do not remove anything if the count is not greater than 0 if (bookmarkIDs.Count == 0) { return; } Database.PrepareQuery( $"DELETE FROM chrBookmarks WHERE ownerID = @characterID AND bookmarkID IN({PyString.Join(',', bookmarkIDs)})", new Dictionary <string, object>() { { "@characterID", ownerID } } ); }
public void MarkMessagesRead(int characterID, PyList <PyInteger> messageIDs) { Database.Query( $"UPDATE eveMail SET `read` = 1 WHERE messageID IN ({PyString.Join(',', messageIDs)})" ); }
public PyDataType GetMultiAllianceShortNamesEx(PyList <PyInteger> ids) { MySqlConnection connection = null; MySqlDataReader reader = Database.PrepareQuery(ref connection, $"SELECT allianceID, shortName FROM alliance_shortnames WHERE allianceID IN ({PyString.Join(',', ids)}" ).ExecuteReader(); using (connection) using (reader) { return(TupleSet.FromMySqlDataReader(Database, reader)); } }
public PyDataType GetMultiLocationsEx(PyList <PyInteger> ids) { MySqlConnection connection = null; MySqlDataReader reader = Database.PrepareQuery(ref connection, $"SELECT itemID as locationID, itemName as locationName, x, y, z FROM invItems LEFT JOIN eveNames USING(itemID) LEFT JOIN invPositions USING (itemID) WHERE itemID IN ({PyString.Join(',', ids)})" ).ExecuteReader(); using (connection) using (reader) { return(TupleSet.FromMySqlDataReader(Database, reader)); } }
public PyDataType GetMultiGraphicsEx(PyList <PyInteger> ids) { MySqlConnection connection = null; MySqlDataReader reader = Database.PrepareQuery(ref connection, $"SELECT graphicID, url3D, urlWeb, icon, urlSound, explosionID FROM eveGraphics WHERE graphicID IN ({PyString.Join(',', ids)})" ).ExecuteReader(); using (connection) using (reader) { return(TupleSet.FromMySqlDataReader(Database, reader)); } }
public PyDataType GetMultiOwnersEx(PyList <PyInteger> ids) { MySqlConnection connection = null; MySqlDataReader reader = Database.PrepareQuery(ref connection, $"SELECT itemID as ownerID, itemName as ownerName, typeID FROM eveNames WHERE itemID IN ({PyString.Join(',', ids)})" ).ExecuteReader(); using (connection) using (reader) { return(TupleSet.FromMySqlDataReader(Database, reader)); } }
public PyDataType GetMultiInvTypesEx(PyList <PyInteger> ids) { MySqlConnection connection = null; MySqlDataReader reader = Database.PrepareQuery(ref connection, $"SELECT typeID, groupID, typeName, description, graphicID, radius, mass, volume, capacity, portionSize, raceID, basePrice, published, marketGroupID, chanceOfDuplicating, dataID FROM invTypes WHERE typeID IN ({PyString.Join(',', ids)})" ).ExecuteReader(); using (connection) using (reader) { return(RowList.FromMySqlDataReader(Database, reader)); } }