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;
}
}
