Code:
#region Badge Login by Bjork
using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
{
{
dbClient.runQuery("UPDATE users SET logins = logins + 1 WHERE id = '" + userID + "'");
int logins = dbClient.getInt("SELECT logins FROM users WHERE id = '" + userID + "'");
if (logins == 1)
{
dbClient.runQuery("INSERT INTO users_badges (badgeid, userid, slotid, iscurrent) VALUES ('ACH_Login1','" + userID + "','0','1')");
refreshBadges();
this.sendData("BK" + "Good Game! 1 login, you receive a new badge!!");
}
else if (logins == 50)
{
dbClient.runQuery("INSERT INTO users_badges (badgeid, userid, slotid, iscurrent) VALUES ('ACH_Login2','" + userID + "','0','1')");
dbClient.runQuery("DELETE FROM users_badges WHERE badgeid = 'ACH_Login1' AND userid = '" + userID + "'");
refreshBadges();
this.sendData("BK" + "Good Game! 50 logins, you receive a new badge!!");
}
else if (logins == 80)
{
dbClient.runQuery("INSERT INTO users_badges (badgeid, userid, slotid, iscurrent) VALUES ('ACH_Login3','" + userID + "','0','1')");
dbClient.runQuery("DELETE FROM users_badges WHERE badgeid = 'ACH_Login2' AND userid = '" + userID + "'");
refreshBadges();
this.sendData("BK" + "Good Game! 80 logins, you receive a new badge!!");
}
else if (logins == 120)
{
dbClient.runQuery("INSERT INTO users_badges (badgeid, userid, slotid, iscurrent) VALUES ('ACH_Login4','" + userID + "','0','1')");
dbClient.runQuery("DELETE FROM users_badges WHERE badgeid = 'ACH_Login3' AND userid = '" + userID + "'");
refreshBadges();
this.sendData("BK" + "Good Game! 120 logins, you receive a new badge!!");
}
else if (logins == 170)
{
dbClient.runQuery("INSERT INTO users_badges (badgeid, userid, slotid, iscurrent) VALUES ('ACH_Login5','" + userID + "','0','1')");
dbClient.runQuery("DELETE FROM users_badges WHERE badgeid = 'ACH_Login4' AND userid = '" + userID + "'");
refreshBadges();
this.sendData("BK" + "Good Game! 170 logins, you receive a new badge!!");
}
else if (logins == 230)
{
dbClient.runQuery("INSERT INTO users_badges (badgeid, userid, slotid, iscurrent) VALUES ('ACH_Login6','" + userID + "','0','1')");
dbClient.runQuery("DELETE FROM users_badges WHERE badgeid = 'ACH_Login5' AND userid = '" + userID + "'");
refreshBadges();
this.sendData("BK" + "Good Game! 230 logins, you receive a new badge!!");
}
else if (logins == 300)
{
dbClient.runQuery("INSERT INTO users_badges (badgeid, userid, slotid, iscurrent) VALUES ('ACH_Login7','" + userID + "','0','1')");
dbClient.runQuery("DELETE FROM users_badges WHERE badgeid = 'ACH_Login6' AND userid = '" + userID + "'");
refreshBadges();
this.sendData("BK" + "Good Game! 300 logins, you receive a new badge!!");
}
else if (logins == 380)
{
dbClient.runQuery("INSERT INTO users_badges (badgeid, userid, slotid, iscurrent) VALUES ('ACH_Login8','" + userID + "','0','1')");
dbClient.runQuery("DELETE FROM users_badges WHERE badgeid = 'ACH_Login7' AND userid = '" + userID + "'");
refreshBadges();
this.sendData("BK" + "Good Game! 380 logins, you receive a new badge!!");
}
else if (logins == 470)
{
dbClient.runQuery("INSERT INTO users_badges (badgeid, userid, slotid, iscurrent) VALUES ('ACH_Login9','" + userID + "','0','1')");
dbClient.runQuery("DELETE FROM users_badges WHERE badgeid = 'ACH_Login8' AND userid = '" + userID + "'");
refreshBadges();
this.sendData("BK" + "Good Game! 470 logins, you receive a new badge!!");
}
else if (logins == 570)
{
dbClient.runQuery("INSERT INTO users_badges (badgeid, userid, slotid, iscurrent) VALUES ('ACH_Login10','" + userID + "','0','1')");
dbClient.runQuery("DELETE FROM users_badges WHERE badgeid = 'ACH_Login9' AND userid = '" + userID + "'");
refreshBadges();
this.sendData("BK" + "Good Game! 570, you receive a new badge!!");
}
}
}
#endregion
You can change the numbers of logins, badges... if you want ;)