/// <summary>Actualiza a data do ltimo login</summary>
public override void updateLastLogin( string userMail )
{
MySqlUtility.executeNonQuery(
string.Format("update Users set user_lastLogin = NOW() where user_mail = '{0}'",
userMail
)
);
}
/// <summary>Modifica a password de um utilizador</summary>
public override bool resetPassword( string userMail, string newPassword )
{
if( !checkUser(userMail) ) {
return false;
}
MySqlUtility.executeNonQuery(
string.Format("update Users set user_pass = '******' where user_mail = '{1}'",
newPassword, userMail
)
);
return true;
}
/// <summary>Regista um scan</summary>
public override void Register(Scan scan)
{
string script = string.Format("INSERT INTO Scans VALUES('', {0}, '{1}', {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}, {11}, {12}, {13}, {14} )",
scan.SourcePlanetId, scan.Target.ToString(), scan.ScanLevel,
scan.Intercepted?1:0, scan.Success?1:0,
scan.Turn,
scan.Culture, scan.HasCommsSatellite, scan.HasGate,
scan.HasStarGate, scan.HasStarPort, scan.InBattle, scan.NumberOfFleets,
scan.TargetPlanetOwner,
scan.TotalShips
);
Chronos.Utils.Log.log(script);
MySqlUtility.executeNonQuery(script);
}
/// <summary>Regista uma nova notÃcia</summary>
protected override void Register(Entry entry)
{
/*CREATE TABLE News (
* Id int NOT NULL auto_increment,
* Title varchar(100) NOT NULL,
* Content mediumtext NOT NULL,
* Date datetime NOT NULL default '0000-00-00 00:00:00',
* PRIMARY KEY (Id)
* ) TYPE=MyISAM;
*/
string query = string.Format("INSERT INTO News(Title, Content, Date) VALUES('{0}', '{1}', NOW())",
entry.Title,
entry.Content
);
MySqlUtility.executeNonQuery(query);
}
/// <summary>
/// remove todas as excepes
/// </summary>
public override void removeAll()
{
MySqlUtility.executeNonQuery("DELETE FROM `Exceptions`");
}
/// <summary>Obtm a quantidade de utilizadores registados</summary>
public override int getUserCount()
{
return MySqlUtility.executeNonQuery("select count(*) from Users");
}