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