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