public bool UpdateCharacter(DDO_Character charDdo)
{
cmd = "update `character` set `occupation`=\"" + charDdo.m_occupation.ToString() + "\",`name`=\"" + charDdo.m_name + "\" where charid=" + charDdo.m_characterId + ";";
try { pool.ExecuteSql(database, cmd); } catch { return(false); }
return(true);
}
//CHARACTER
public int InsertCharacter(DDO_Character charDdo)
{
cmd = "insert into `character` values(null," + charDdo.m_playerId + ",\"" + charDdo.m_occupation.ToString() + "\",\"" + charDdo.m_name + "\");select last_insert_id();";
DataSet ds = new DataSet();
try { pool.ExecuteSql(database, cmd, ds); } catch { return(-1); }
return(int.Parse(ds.Tables[0].Rows[0]["last_insert_id()"].ToString()));
}
public DDO_Character[] GetCharacterByPlayerId(int playerId)
{
cmd = "select * from `character` where playerid=" + playerId + ";";
DataSet ds = new DataSet();
pool.ExecuteSql(database, cmd, ds);
int x = ds.Tables[0].Rows.Count;
DDO_Character[] res = new DDO_Character[x];
for (int i = 0; i < x; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
int id = int.Parse(dr["charid"].ToString());
int playerid = int.Parse(dr["playerid"].ToString());
OccupationType ocu = (OccupationType)Enum.Parse(typeof(OccupationType), dr["occupation"].ToString());
string name = dr["name"].ToString();
res[i] = new DDO_Character(id, playerid, ocu, name);
}
return(res);
}
public bool GetCharacterById(int charid, out DDO_Character c)
{
cmd = "select * from `character` where charid=" + charid + ";";
DataSet ds = new DataSet();
pool.ExecuteSql(database, cmd, ds);
if (ds.Tables[0].Rows.Count == 0)
{
c = default(DDO_Character);
return(false);
}
DataRow dr = ds.Tables[0].Rows[0];
int id = int.Parse(dr["charid"].ToString());
int playerid = int.Parse(dr["playerid"].ToString());
OccupationType ocu = (OccupationType)Enum.Parse(typeof(OccupationType), dr["occupation"].ToString());
string name = dr["name"].ToString();
c = new DDO_Character(id, playerid, ocu, name);
return(true);
}
