protected void CreateAllianceClick(object src, EventArgs args) { AllianceInfo info = new AllianceInfo(); info.Name = name.Text; info.Tag = tag.Text; info.Motto = motto.Text; info.Ranking = 1000; info.RankingBattles = 0; int id = AllianceUtility.Persistance.Register(info); User user = (User)Page.User; user.AllianceId = id; user.AllianceRank = AllianceMember.Role.Admiral; UserUtility.bd.saveUser(user, ""); if (user.RulerId > 0) { Ruler ruler = Universe.instance.getRuler(user.RulerId); ruler.AllianceId = id; ruler.AllianceRank = AllianceMember.Role.Admiral; } Page.Response.Redirect(Page.Request.RawUrl, false); }
protected ArrayList FromDataSet(DataSet ds) { ArrayList list = new ArrayList(); foreach (DataRow row in ds.Tables[0].Rows) { AllianceInfo info = new AllianceInfo(); info.Id = (int)row["alliance_id"]; info.Ranking = (int)row["alliance_rank"]; info.RankingBattles = (int)row["alliance_rankBattles"]; info.Name = (string)row["alliance_name"]; info.Motto = (string)row["alliance_motto"]; info.Tag = (string)row["alliance_tag"]; //info.RegistDate = (DateTime) row["alliance_regist"]; UserUtility.bd.setAllianceMembers(info); list.Add(info); } return(list); }
protected void CreateAllianceClick( object src, EventArgs args ) { AllianceInfo info = new AllianceInfo(); info.Name = name.Text; info.Tag = tag.Text; info.Motto = motto.Text; info.Ranking = 1000; info.RankingBattles = 0; int id = AllianceUtility.Persistance.Register(info); User user = (User) Page.User; user.AllianceId = id; user.AllianceRank = AllianceMember.Role.Admiral; UserUtility.bd.saveUser(user, ""); if( user.RulerId > 0 ) { Ruler ruler = Universe.instance.getRuler(user.RulerId); ruler.AllianceId = id; ruler.AllianceRank = AllianceMember.Role.Admiral; } Page.Response.Redirect(Page.Request.RawUrl, false); }
public override void Save(AllianceInfo info) { StringWriter writer = new StringWriter(); writer.Write("UPDATE Alliances SET "); writer.Write("alliance_name='{0}', ", info.Name); writer.Write("alliance_tag='{0}', ", info.Tag); writer.Write("alliance_motto='{0}', ", info.Motto); writer.Write("alliance_rank='{0}', ", info.Ranking); writer.Write("alliance_rankBattles='{0}' ", info.RankingBattles); writer.Write("WHERE alliance_id={0}", info.Id); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = writer.ToString(); cmd.ExecuteNonQuery(); } catch (Exception e) { HttpContext.Current.Trace.Warn("MySQL", e.ToString()); Console.WriteLine("Update alliance: " + e.ToString()); } finally { conn.Close(); } }
protected ArrayList PopulateUsers(DataSet ds, string idstr) { ArrayList list = new ArrayList(); foreach (DataRow row in ds.Tables[0].Rows) { User user = new User(); user.Nick = (string)row["user_nick"]; user.Mail = (string)row["user_mail"]; user.UserId = (int)row[idstr]; user.RulerId = (int)row["user_ruler_id"]; user.EloRanking = (int)row["user_rank"]; user.AllianceId = (int)row["user_alliance_id"]; user.AllianceRank = AllianceInfo.ToAllianceRank((string)row["user_alliance_rank"]); user.Wins = (int)row["user_wins"]; user.Losses = (int)row["user_losses"]; list.Add(user); } return(list); }
/// <summary>Preenche um User com os seus dados</summary> private bool fillUserInformation( User user, string query ) { HttpContext.Current.Trace.Write("MySQL","Query String: " + query); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = query; MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); HttpContext.Current.Trace.Write("MySQL","Has Rows: " + reader.HasRows.ToString()); user.Nick = (string) reader["user_nick"]; user.Mail = (string) reader["user_mail"]; user.UserId = (int) reader["IDUsers"]; user.RulerId = (int) reader["user_ruler_id"]; user.EloRanking = (int) reader["user_rank"]; user.AllianceId = (int) reader["user_alliance_id"]; user.AllianceRank = AllianceInfo.ToAllianceRank((string) reader["user_alliance_rank"]); if( reader["user_regist"] != DBNull.Value ) { user.RegistDate = (DateTime) reader["user_regist"]; } else { user.RegistDate = DateTime.Now; } if( reader["user_lastLogin"] != DBNull.Value ) { user.LastLogin = (DateTime) reader["user_lastLogin"]; } else { user.LastLogin = DateTime.Now; } user.Skin = (int) reader["user_skin"]; user.Lang = (string) reader["user_lang"]; user.ImagesDir = (string) reader["user_imagesDir"]; user.Website = (string) reader["user_website"]; user.Avatar = (string) reader["user_avatar"]; user.Msn = (string) reader["user_msn"]; user.Icq = (string) reader["user_icq"]; user.Jabber = (string) reader["user_jabber"]; user.Aim = (string) reader["user_aim"]; user.Yahoo = (string) reader["user_yahoo"]; user.SetRoles( getRoles(user.UserId) ); return true; } catch( Exception e ) { HttpContext.Current.Trace.Warn("MySQL",e.Message); Console.WriteLine("EXCEPTION: " + e); return false; } finally { conn.Close(); } }
/// <summary> /// Preenche um User com os seus dados /// </summary> public override void fillUser( User user ) { NpgsqlConnection conn = new NpgsqlConnection(OrionGlobals.getConnectionString("connectionStringPG")); NpgsqlCommand cmd = new NpgsqlCommand("OrionsBelt_UsersGetUser", conn); cmd.CommandType=CommandType.StoredProcedure; cmd.CommandTimeout = 0; cmd.Parameters.Add("@user_mail",user.Mail); try { conn.Open(); reader = cmd.ExecuteReader(); if( reader.HasRows ) { reader.Read(); user.Nick = (string) getField("user_nick"); user.UserId = (int) getField("user_id"); if ( getField("user_ruler_id") != DBNull.Value ) user.RulerId = (int) getField("user_ruler_id"); user.EloRanking = (int) getField("user_rank"); user.RegistDate = (DateTime) getField("user_registDate"); user.LastLogin = (DateTime) getField("user_lastLogin"); user.Skin = (int) getField("user_skin"); user.Lang = (string) getField("user_lang"); user.ImagesDir = (string) getField("user_imagesDir"); user.Website = (string) getField("user_website"); user.Avatar = (string) getField("user_avatar"); user.Msn = (string) getField("user_msn"); user.Icq = (string) getField("user_icq"); user.Jabber = (string) getField("user_jabber"); user.Aim = (string) getField("user_aim"); user.Yahoo = (string) getField("user_yahoo"); user.AllianceId = (int) reader["user_alliance_id"]; user.AllianceRank = AllianceInfo.ToAllianceRank( reader["user_alliance_rank"].ToString() ); user.Wins = (int) reader["user_wins"]; user.Losses = (int) reader["user_losses"]; }else { ExceptionLog.log("User não encontrado", "Mail: " + user.Mail==null?"null":user.Mail ); } reader = null; } catch( NpgsqlException e ) { throw new AlnitakException("Erro ao executar o procedimento 'OrionsBelt_UsersGetUser' @ NpgsqlServerUserutility::fillUser ",e); } finally { conn.Close(); } }
public override void Save( AllianceInfo info ) { PostGre.PostGreParam [] param = new PostGreParam[6]; param[0] = new PostGreParam( info.Name ,NpgsqlDbType.Varchar,150 ); param[1] = new PostGreParam( info.Tag ,NpgsqlDbType.Varchar,150 ); param[2] = new PostGreParam( info.Motto ,NpgsqlDbType.Varchar,150 ); param[3] = new PostGreParam( info.Ranking ,NpgsqlDbType.Integer ); param[4] = new PostGreParam( info.RankingBattles ,NpgsqlDbType.Integer ); param[5] = new PostGreParam( info.Id ,NpgsqlDbType.Integer ); PostGreServerUtility.executeNonQuery2("orionsbelt_alliancesavealliance", param ); }
int IComparer.Compare(object x, object y) { AllianceInfo a1 = x as AllianceInfo; AllianceInfo a2 = y as AllianceInfo; if (a1 == null || a2 == null) { return(0); } return(-a1.Score.CompareTo(a2.Score)); }
public override void Save(AllianceInfo info) { PostGre.PostGreParam [] param = new PostGreParam[6]; param[0] = new PostGreParam(info.Name, NpgsqlDbType.Varchar, 150); param[1] = new PostGreParam(info.Tag, NpgsqlDbType.Varchar, 150); param[2] = new PostGreParam(info.Motto, NpgsqlDbType.Varchar, 150); param[3] = new PostGreParam(info.Ranking, NpgsqlDbType.Integer); param[4] = new PostGreParam(info.RankingBattles, NpgsqlDbType.Integer); param[5] = new PostGreParam(info.Id, NpgsqlDbType.Integer); PostGreServerUtility.executeNonQuery2("orionsbelt_alliancesavealliance", param); }
public override int Register( AllianceInfo info ) { PostGre.PostGreParam [] param = new PostGreParam[5]; param[0] = new PostGreParam( info.Name ,NpgsqlDbType.Varchar,150 ); param[1] = new PostGreParam( info.Tag ,NpgsqlDbType.Varchar,150 ); param[2] = new PostGreParam( info.Motto ,NpgsqlDbType.Varchar,150 ); param[3] = new PostGreParam( info.Ranking ,NpgsqlDbType.Integer ); param[4] = new PostGreParam( info.RankingBattles ,NpgsqlDbType.Integer ); DataSet ds = PostGreServerUtility.getFromDB("OrionsBelt_AllianceRegisterAlliance", param ); return int.Parse(ds.Tables[0].Rows[0][0].ToString()); }
/// <summary>Obtém um User dado o seu id</summary> public override User getUser( int id ) { NpgsqlConnection conn = new NpgsqlConnection(OrionGlobals.getConnectionString("connectionStringPG")); NpgsqlCommand cmd = new NpgsqlCommand("OrionsBelt_UsersGetUserById", conn); cmd.CommandType=CommandType.StoredProcedure; cmd.CommandTimeout = 0; cmd.Parameters.Add("@id",id); try { conn.Open(); reader = cmd.ExecuteReader(); if( reader.Read() ) { User user = new User(); user.Nick = (string) reader["user_nick"]; user.UserId = (int) reader["user_id"]; user.RulerId = (int) reader["user_ruler_id"]; user.EloRanking = (int) reader["user_rank"]; user.RegistDate = (DateTime) getField("user_registDate"); user.LastLogin = (DateTime) getField("user_lastLogin"); user.Skin = (int) reader["user_skin"]; user.Lang = (string) reader["user_lang"]; user.ImagesDir = (string) reader["user_imagesDir"]; user.Website = (string) reader["user_website"]; user.Avatar = (string) reader["user_avatar"]; user.Msn = (string) reader["user_msn"]; user.Icq = (string) reader["user_icq"]; user.Jabber = (string) reader["user_jabber"]; user.Aim = (string) reader["user_aim"]; user.Yahoo = (string) reader["user_yahoo"]; user.AllianceId = (int) reader["user_alliance_id"]; user.AllianceRank = AllianceInfo.ToAllianceRank( reader["user_alliance_rank"].ToString() ); user.Wins = (int) reader["user_wins"]; user.Losses = (int) reader["user_losses"]; return user; }else return null; } catch( Exception e ) { throw new AlnitakException("Erro ao executar o procedimento 'OrionsBelt_UsersGetUserById' @ NpgsqlServerUserutility::getUser : " + e.Message,e); } finally { conn.Close(); } }
/// <summary>Guarda um User com os seus dados na Base de Dados</summary> public override void saveUser( User user, string password ) { /* UPDATE Users user_mail='', user_pass='', user_msn='', user_icq='', user_jabber='', user_aim='', user_yahoo='', user_signature='', user_imagesDir='' WHERE user_id= */ // StringWriter writer = new StringWriter(); writer.Write("UPDATE Users SET "); writer.Write("user_ruler_id={0}, ", user.RulerId); writer.Write("user_nick='{0}', ", user.Nick); writer.Write("user_skin={0}, ", user.Skin); writer.Write("user_lang='{0}', ", user.Lang); writer.Write("user_website='{0}', ", user.Website); writer.Write("user_avatar='{0}', ", user.Avatar); writer.Write("user_rank='{0}', ", user.EloRanking); writer.Write("user_alliance_id='{0}', ", user.AllianceId); writer.Write("user_alliance_rank='{0}', ", AllianceInfo.FromAllianceRole(user.AllianceRank)); writer.Write("user_msn='{0}', ", user.Msn); writer.Write("user_icq='{0}', ", user.Icq); writer.Write("user_jabber='{0}', ", user.Jabber); writer.Write("user_aim='{0}', ", user.Aim); writer.Write("user_yahoo='{0}', ", user.Yahoo); writer.Write("user_signature='{0}', ", user.Signature); writer.Write("user_imagesDir='{0}' ", user.ImagesDir); writer.Write("WHERE IDUsers={0}", user.UserId); string query = writer.ToString(); HttpContext.Current.Trace.Write("MySQL","Query String: " + query); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = query; cmd.ExecuteNonQuery(); } catch( Exception e ) { HttpContext.Current.Trace.Warn("MySQL",e.Message); Console.WriteLine("Update exception: " + e.Message); } finally { conn.Close(); } }
public override int Register(AllianceInfo info) { PostGre.PostGreParam [] param = new PostGreParam[5]; param[0] = new PostGreParam(info.Name, NpgsqlDbType.Varchar, 150); param[1] = new PostGreParam(info.Tag, NpgsqlDbType.Varchar, 150); param[2] = new PostGreParam(info.Motto, NpgsqlDbType.Varchar, 150); param[3] = new PostGreParam(info.Ranking, NpgsqlDbType.Integer); param[4] = new PostGreParam(info.RankingBattles, NpgsqlDbType.Integer); DataSet ds = PostGreServerUtility.getFromDB("OrionsBelt_AllianceRegisterAlliance", param); return(int.Parse(ds.Tables[0].Rows[0][0].ToString())); }
public static void Update(AllianceInfo one, AllianceInfo two, BattleResult result) { Ranking r1 = new Ranking(); r1.EloRanking = one.Ranking; Ranking r2 = new Ranking(); r2.EloRanking = two.Ranking; Update(r1, r2, result); one.Ranking = r1.EloRanking; two.Ranking = r2.EloRanking; }
public override void setAllianceMembers( AllianceInfo info ){ string query = string.Format("SELECT * FROM `Users` where abs(user_alliance_id) = {0}", info.Id); DataSet ds = MySqlUtility.getQuery(query); ArrayList all = PopulateUsers(ds, "IDUsers"); ArrayList members = new ArrayList(); ArrayList wannabe = new ArrayList(); foreach( User user in all ) { if( user.AllianceId < 0 ) { wannabe.Add(user); } else { members.Add(user); } } info.Members = members; info.Wannabe = wannabe; }
int IComparer.Compare(object x, object y) { AllianceInfo a1 = x as AllianceInfo; AllianceInfo a2 = y as AllianceInfo; if (a1 == null || a2 == null) { return(0); } int byRank = -a1.Ranking.CompareTo(a2.Ranking); if (byRank != 0) { return(byRank); } return(-a1.AverageRanking.CompareTo(a2.AverageRanking)); }
protected void WriteAlliances(HtmlTextWriter writer, ArrayList all) { int max = 50; if (all.Count < max) { max = all.Count; } writer.WriteLine("<table class='planetFrame'>"); writer.WriteLine("<tr class='resourceTitle'>"); writer.WriteLine("<th class='resourceTitle'>#</th>"); writer.WriteLine("<th class='resourceTitle'>{0}</th>", CultureModule.getContent("section_alliance")); writer.WriteLine("<th class='resourceTitle'>{0}</th>", CultureModule.getContent("alliance_tag")); writer.WriteLine("<th class='resourceTitle'>{0}</th>", CultureModule.getContent("alliance_members")); writer.WriteLine("<th class='resourceTitle'>{0}</th>", CultureModule.getContent("planetas")); writer.WriteLine("<th class='resourceTitle'>{0}</th>", CultureModule.getContent("spaceTitle")); writer.WriteLine("<th class='resourceTitle'>{0}</th>", CultureModule.getContent("section_topranks")); writer.WriteLine("<th class='resourceTitle'>{0}</th>", CultureModule.getContent("score")); writer.WriteLine("</tr>"); for (int i = 0; i < max; ++i) { AllianceInfo info = (AllianceInfo)all[i]; if (!info.HasMembers) { continue; } writer.WriteLine("<tr onmouseover='overResource(this);' onmouseout='outResource(this);'>"); writer.WriteLine("<td class='resourceCell'>{0}</td>", i + 1); writer.WriteLine("<td class='resourceCell'>{0}</td>", OrionGlobals.getLink(info)); writer.WriteLine("<td class='resourceCell'>{0}</td>", info.Tag); writer.WriteLine("<td class='resourceCell'>{0}</td>", info.Members.Count); writer.WriteLine("<td class='resourceCell'>{0}</td>", info.TotalPlanets); writer.WriteLine("<td class='resourceCell'>{0}</td>", info.TotalSpace); writer.WriteLine("<td class='resourceCell'><b title='Avg: {1}'>{0}</b> ({2})</td>", info.Ranking, info.AverageRanking, info.RankingBattles); writer.WriteLine("<td class='resourceCell'><b title='{1}'>{0}</b> (<span class='green'>{2}</span>/<span class='red'>{3}</span>)</td>", info.Score, info.AverageScore, info.TotalRoundWins, info.TotalRoundDefeats); writer.WriteLine("</tr>"); } writer.WriteLine("</table>"); }
public static void RankingBattleEndend(Ruler one, Ruler two, BattleResult result) { try { User uone = UserUtility.bd.getUser(one.ForeignId); User utwo = UserUtility.bd.getUser(two.ForeignId); Ranking.Update(uone, utwo, result); if (result == BattleResult.NumberOneVictory) { ++uone.Wins; ++utwo.Losses; } else { ++utwo.Wins; ++uone.Losses; } UserUtility.bd.saveUser(uone, string.Empty); UserUtility.bd.saveUser(utwo, string.Empty); if (uone.AllianceId > 0 && utwo.AllianceId > 0 && uone.AllianceId != utwo.AllianceId) { AllianceInfo aone = AllianceUtility.Persistance.Get(uone.AllianceId); AllianceInfo atwo = AllianceUtility.Persistance.Get(utwo.AllianceId); Ranking.Update(aone, atwo, result); ++aone.RankingBattles; ++atwo.RankingBattles; AllianceUtility.Persistance.Save(aone); AllianceUtility.Persistance.Save(atwo); } } catch (Exception ex) { ExceptionLog.log(ex); } }
public override int Register(AllianceInfo info) { StringWriter writer = new StringWriter(); writer.Write("insert into Alliance(alliance_id, alliance_name, alliance_tag, alliance_motto, alliance_rank, alliance_rankBattles) values(NULL, "); writer.Write("'{0}', ", info.Name); writer.Write("'{0}', ", info.Tag); writer.Write("'{0}', ", info.Motto); writer.Write("'{0}', ", info.Ranking); writer.Write("'{0}'); select LAST_INSERT_ID()", info.RankingBattles); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = writer.ToString(); object obj = cmd.ExecuteScalar(); Log.log(cmd.CommandText); Log.log("Result: {0}", obj); if (obj != null) { return(int.Parse(obj.ToString())); } else { return(0); } } catch (Exception e) { HttpContext.Current.Trace.Warn("MySQL", e.ToString()); Console.WriteLine("create alliance: " + e.ToString()); } finally { conn.Close(); } return(0); }
public override void setAllianceMembers( AllianceInfo info ) { PostGre.PostGreParam [] param = new PostGreParam[1]; param[0] = new PostGreParam(info.Id,NpgsqlDbType.Integer); DataSet ds = PostGreServerUtility.getFromDB("OrionsBelt_AllianceGetAllianceMembers",param); ArrayList all = PopulateUsers(ds, "user_id"); ArrayList members = new ArrayList(); ArrayList wannabe = new ArrayList(); foreach( User user in all ) { if( user.AllianceId < 0 ) { wannabe.Add(user); } else { members.Add(user); } } info.Members = members; info.Wannabe = wannabe; }
public override int Register( AllianceInfo info ) { StringWriter writer = new StringWriter(); writer.Write("insert into Alliance(alliance_id, alliance_name, alliance_tag, alliance_motto, alliance_rank, alliance_rankBattles) values(NULL, "); writer.Write("'{0}', ", info.Name); writer.Write("'{0}', ", info.Tag); writer.Write("'{0}', ", info.Motto); writer.Write("'{0}', ", info.Ranking); writer.Write("'{0}'); select LAST_INSERT_ID()", info.RankingBattles); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = writer.ToString(); object obj = cmd.ExecuteScalar(); Log.log(cmd.CommandText); Log.log("Result: {0}", obj); if( obj != null ) { return int.Parse(obj.ToString()); } else { return 0; } } catch( Exception e ) { HttpContext.Current.Trace.Warn("MySQL",e.ToString()); Console.WriteLine("create alliance: " + e.ToString()); } finally { conn.Close(); } return 0; }
/// <summary>Pinta o controlo</summary> protected override void Render(HtmlTextWriter writer) { OrionGlobals.RegisterRequest(MessageType.Generic, string.Format("{1} {0}", info.getContent("section_home"), ruler.Name)); writer.WriteLine("<div class='planetInfoZoneTitle'><b>" + Title + "</b></div>"); writer.WriteLine("<table class='planetFrame' style='margin-bottom: 0px; border-bottom:none;'>"); writer.WriteLine("<tr>"); writer.WriteLine("<td class='resource'>{0}</td>", info.getContent("name")); writer.WriteLine("<td class='resourceCell'>{0}</td>", OrionGlobals.getLink(ruler)); writer.WriteLine("</tr>"); writer.WriteLine("<tr>"); writer.WriteLine("<td class='resource'>{0}</td>", info.getContent("stats_alliances")); string allianceText = null; if (ruler.AllianceId == 0) { allianceText = "<i>" + info.getContent("no_alliance") + "</i>"; } else { AllianceInfo allianceInfo = AllianceUtility.Persistance.Get(ruler.AllianceId); if (allianceInfo != null) { allianceText = OrionGlobals.getLink(allianceInfo); } else { allianceText = "<i>" + info.getContent("no_alliance") + "</i>"; } } writer.WriteLine("<td class='resourceCell'>{0}</td>", allianceText); writer.WriteLine("</tr>"); writer.WriteLine("</table>"); writer.WriteLine("<table class='planetFrame' style='margin-top: 0px;'>"); writer.WriteLine("<tr>"); writer.WriteLine("<td class='resource'>{0}</td>", info.getContent("planetas")); writer.WriteLine("<td class='resourceCell'>{0}</td>", ruler.Planets.Length); writer.WriteLine("<td class='resource'>{0}</td>", info.getContent("maxPlanets")); writer.WriteLine("<td class='resourceCell'>{0}</td>", ruler.getResourceCount("maxPlanets")); writer.WriteLine("</tr>"); writer.WriteLine("<tr>"); writer.WriteLine("<td class='resource'>{0}</td>", info.getContent("victories")); writer.WriteLine("<td class='resourceCell'>{0}</td>", ruler.Victories); writer.WriteLine("<td class='resource'>{0}</td>", info.getContent("defeats")); writer.WriteLine("<td class='resourceCell'>{0}</td>", ruler.Defeats); writer.WriteLine("</tr>"); writer.WriteLine("<tr>"); writer.WriteLine("<td class='resource'>{0}</td>", info.getContent("culture")); writer.WriteLine("<td class='resourceCell'>{0}</td>", ruler.getResourceCount("culture")); writer.WriteLine("<td class='resource'>{0}</td>", info.getContent("score")); writer.WriteLine("<td class='resourceCell'>{0}</td>", ruler.getResourceCount("score")); writer.WriteLine("</tr>"); writer.WriteLine("<tr>"); writer.WriteLine("<td class='resource'>{0}</td>", info.getContent("battle_rank")); writer.WriteLine("<td class='resourceCell'>{0}</td>", info.getContent(ruler.Ranking)); writer.WriteLine("<td class='resource'>{0}</td>", info.getContent("battle_rank")); writer.WriteLine("<td class='resourceCell'><b>{0}</b>º</td>", (ruler.Rank == -1?"~":ruler.Rank.ToString())); writer.WriteLine("</tr>"); writer.WriteLine("</table>"); }
public override void Save( AllianceInfo info ) { StringWriter writer = new StringWriter(); writer.Write("UPDATE Alliances SET "); writer.Write("alliance_name='{0}', ", info.Name); writer.Write("alliance_tag='{0}', ", info.Tag); writer.Write("alliance_motto='{0}', ", info.Motto); writer.Write("alliance_rank='{0}', ", info.Ranking); writer.Write("alliance_rankBattles='{0}' ", info.RankingBattles); writer.Write("WHERE alliance_id={0}", info.Id); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = writer.ToString(); cmd.ExecuteNonQuery(); } catch( Exception e ) { HttpContext.Current.Trace.Warn("MySQL",e.ToString()); Console.WriteLine("Update alliance: " + e.ToString()); } finally { conn.Close(); } }
protected ArrayList FromDataSet( DataSet ds ) { ArrayList list = new ArrayList(); foreach( DataRow row in ds.Tables[0].Rows ) { AllianceInfo info = new AllianceInfo(); info.Id = (int) row["alliance_id"]; info.Ranking = (int) row["alliance_rank"]; info.RankingBattles = (int) row["alliance_rankBattles"]; info.Name = (string) row["alliance_name"]; info.Motto = (string) row["alliance_motto"]; info.Tag = (string) row["alliance_tag"]; //info.RegistDate = (DateTime) row["alliance_regist"]; UserUtility.bd.setAllianceMembers( info ); list.Add(info); } return list; }
public abstract void Save( AllianceInfo alliance );
public abstract int Register( AllianceInfo alliance );
public abstract void setAllianceMembers( AllianceInfo info );
public abstract void setAllianceMembers(AllianceInfo info);
public static string getLink(AllianceInfo info) { return(string.Format("<a href='{0}allianceinfo.aspx?id={1}'>{2}</a>", AppPath, info.Id, info.Name )); }
public abstract int Register(AllianceInfo alliance);
public static string getLink( AllianceInfo info ) { return string.Format("<a href='{0}allianceinfo.aspx?id={1}'>{2}</a>", AppPath, info.Id, info.Name ); }
public override void setAllianceMembers(AllianceInfo info) { throw new NotImplementedException("SqlServeruserutility.setAllianceMembers is not implemented!!!"); }
public abstract void Save(AllianceInfo alliance);
public static void Update( AllianceInfo one, AllianceInfo two, BattleResult result ) { Ranking r1 = new Ranking(); r1.EloRanking = one.Ranking; Ranking r2 = new Ranking(); r2.EloRanking = two.Ranking; Update( r1, r2, result ); one.Ranking = r1.EloRanking; two.Ranking = r2.EloRanking; }
public override void setAllianceMembers( AllianceInfo info ) { throw new NotImplementedException("SqlServeruserutility.setAllianceMembers is not implemented!!!"); }
public override void setAllianceMembers( AllianceInfo info ) { string query = string.Format("SELECT * FROM `Users` where abs(user_alliance_id) = {0}", info.Id); DataSet ds = MySqlUtility.getQuery(query); ArrayList all = PopulateUsers(ds, "IDUsers"); ArrayList members = new ArrayList(); ArrayList wannabe = new ArrayList(); foreach( User user in all ) { if( user.AllianceId < 0 ) { wannabe.Add(user); } else { members.Add(user); } } info.Members = members; info.Wannabe = wannabe; }