public void Save(object o) { db db1 = new db(); character t = (character)o; if (t.IsDirty) { // save dirt to database db1 = new MMO.db(); db1.SetCommand("s_SaveCharacter", CommandType.StoredProcedure); db1.AddParam <int>("id", SqlDbType.Int, 4, t.id); db1.AddParam <int>("login", SqlDbType.Int, 4, owner.loginID); db1.AddParam <string>("charactername", SqlDbType.VarChar, 50, t.name); db1.AddParam <int>("charactertype", SqlDbType.Int, 4, 0); db1.AddParam <int>("hp", SqlDbType.Int, 4, t.hp); db1.AddParam <int>("stamina", SqlDbType.Int, 4, t.stamina); db1.AddParam <int>("mana", SqlDbType.Int, 4, t.mana); db1.AddParam <int>("x", SqlDbType.Int, 4, t.x); db1.AddParam <int>("y", SqlDbType.Int, 4, t.y); // return value of runscalar is the new or old id of tile t.id = Int32.Parse(db1.RunScalar().ToString()); // no dirt to save t.IsDirty = false; } }
public void Save(object o) { db db1 = new db(); character t = (character)o; if (t.IsDirty) { // save dirt to database db1 = new MMO.db(); db1.SetCommand("s_SaveCharacter", CommandType.StoredProcedure); db1.AddParam<int>("id", SqlDbType.Int, 4, t.id); db1.AddParam<int>("login", SqlDbType.Int, 4, owner.loginID); db1.AddParam<string>("charactername", SqlDbType.VarChar, 50, t.name); db1.AddParam<int>("charactertype", SqlDbType.Int, 4, 0); db1.AddParam<int>("hp", SqlDbType.Int, 4, t.hp); db1.AddParam<int>("stamina", SqlDbType.Int, 4, t.stamina); db1.AddParam<int>("mana", SqlDbType.Int, 4, t.mana); db1.AddParam<int>("x", SqlDbType.Int, 4, t.x); db1.AddParam<int>("y", SqlDbType.Int, 4, t.y); // return value of runscalar is the new or old id of tile t.id = Int32.Parse(db1.RunScalar().ToString()); // no dirt to save t.IsDirty = false; } }
public List <character> GetCharacters() { db db1 = new db(); db1.SetCommand("s_CharactersGet", CommandType.StoredProcedure); db1.AddParam <int>("LoginID", SqlDbType.Int, 4, owner.loginID); db1.Read(); // access the datareader within the class while (db1.dr.Read()) { character chr1 = new character(); chr1.id = Int32.Parse(db1.dr["id"].ToString()); chr1.hp = Int32.Parse(db1.dr["hp"].ToString()); chr1.mana = Int32.Parse(db1.dr["mana"].ToString()); chr1.owner = owner.loginName; chr1.stamina = Int32.Parse(db1.dr["stamina"].ToString()); //chr1.tile_on = Int32.Parse(db1.dr["tile_on"].ToString()); chr1.x = Int32.Parse(db1.dr["x"].ToString()); chr1.y = Int32.Parse(db1.dr["y"].ToString()); chr1.name = db1.dr["charactername"].ToString(); list.Add( chr1 ); } return(list); }
private int GetLoginID(string username) { MMO.db db1 = new db(); /* if not exist, create and then return id */ db1.SetCommand("s_LoginIDGet", CommandType.StoredProcedure); db1.AddParam <string>("Login", SqlDbType.NVarChar, 50, username); return(Int32.Parse(db1.RunScalar().ToString())); }
public void Save(object o) { Tile t = (Tile)o; if (t.IsDirty) { // save dirt to database db1 = new MMO.db(); db1.SetCommand("s_SaveTile", CommandType.StoredProcedure); db1.AddParam <int>("id", SqlDbType.Int, 4, t.Id); db1.AddParam <int>("x", SqlDbType.Int, 4, t.X); db1.AddParam <int>("y", SqlDbType.Int, 4, t.Y); db1.AddParam <int>("tile_type_id", SqlDbType.Int, 4, t.Tile_Type_Id); // return value of runscalar is the new or old id of tile t.Id = Int32.Parse(db1.RunScalar().ToString()); // no dirt to save t.IsDirty = false; } }
public TileDB(int characterid) /* Constructor for Tiles around usernames character */ { db1 = new MMO.db(); Tiles = new List <MMO.Tile>(); db1.SetCommand("s_TilesGet", CommandType.StoredProcedure); db1.AddParam <int>("characterid", SqlDbType.Int, 4, characterid); db1.Read(); // access the datareader within the class while (db1.dr.Read()) { AddTile(Int32.Parse(db1.dr["id"].ToString()), Int32.Parse(db1.dr["x"].ToString()), Int32.Parse(db1.dr["y"].ToString()), Int32.Parse(db1.dr["tile_type_id"].ToString()) ); } }
public TileDB(int characterid) /* Constructor for Tiles around usernames character */ { db1 = new MMO.db(); Tiles = new List<MMO.Tile>(); db1.SetCommand("s_TilesGet", CommandType.StoredProcedure); db1.AddParam<int>("characterid", SqlDbType.Int, 4, characterid); db1.Read(); // access the datareader within the class while (db1.dr.Read()) { AddTile(Int32.Parse(db1.dr["id"].ToString()), Int32.Parse(db1.dr["x"].ToString()), Int32.Parse(db1.dr["y"].ToString()), Int32.Parse(db1.dr["tile_type_id"].ToString()) ); } }
public void Save(object o) { Tile t = (Tile)o; if (t.IsDirty) { // save dirt to database db1 = new MMO.db(); db1.SetCommand("s_SaveTile", CommandType.StoredProcedure); db1.AddParam<int>("id", SqlDbType.Int, 4, t.Id); db1.AddParam<int>("x", SqlDbType.Int, 4, t.X); db1.AddParam<int>("y", SqlDbType.Int, 4, t.Y); db1.AddParam<int>("tile_type_id", SqlDbType.Int, 4, t.Tile_Type_Id); // return value of runscalar is the new or old id of tile t.Id = Int32.Parse(db1.RunScalar().ToString()); // no dirt to save t.IsDirty = false; } }