Esempi in C# (CSharp) per EVESharp.Database Database.Query

Query() public static method

public static Query ( MySqlDataReader &res, string query ) : bool
res	MySql.Data.MySqlClient.MySqlDataReader
query	string
return	bool

Esempio n. 1

 public static void SetOwner(int itemID, int ownerID)
 {
     Database.Query("UPDATE invtypes SET ownerID=" + ownerID + " WHERE itemID=" + itemID);
 }

Esempio n. 2

 public static void UnloadItem(ulong itemID)
 {
     Database.Query("UPDATE entity SET nodeID=0 WHERE itemID=" + itemID);
 }

Esempio n. 3

 public static void SetItemFlag(int itemID, int flag)
 {
     Database.Query("UPDATE invtypes SET flag=" + flag + " WHERE itemID=" + itemID);
 }

Esempio n. 4

 public static void SetLocation(int itemID, int locationID)
 {
     Database.Query("UPDATE invtypes SET locationID=" + locationID + " WHERE itemID=" + itemID);
 }

Esempio n. 5

 public static void SetItemName(int itemID, string name)
 {
     Database.Query("UPDATE invtypes SET itemName='" + name + "' WHERE itemID=" + itemID);
 }

Esempio n. 6

 public static void SetSingleton(int itemID, bool singleton)
 {
     Database.Query("UPDATE invtypes SET singleton=" + singleton + " WHERE itemID=" + itemID);
 }

Esempio n. 7

 public static void SetQuantity(int itemID, int quantity)
 {
     Database.Query("UPDATE invtypes SET quantity=" + quantity + " WHERE itemID=" + itemID);
 }

Esempio n. 8

 public static void SetCustomInfo(int itemID, string customInfo)
 {
     Database.Query("UPDATE invtypes SET customInfo='" + customInfo + "' WHERE itemID=" + itemID);
 }

Esempio n. 9

 public static void SetBlueprintInfo(int itemID, bool copy, int materialLevel, int productivityLevel, int licensedProductionRunsRemaining)
 {
     Database.Query("UPDATE invblueprints SET blueprintID=" + itemID + " copy=" + copy + " materialLevel=" + materialLevel + " licensedProductionRunsRemaining=" + licensedProductionRunsRemaining);
 }