public string SaveForumSession(string username, string host, string useragent, string forwardedfor)
{
int forumUserId = 0;
using (NtxfcDbContext db = new NtxfcDbContext())
{
Login login = db.Logins.FirstOrDefault(x => x.Username == username);
if (login != null)
forumUserId = login.ForumUserId;
}
if (forumUserId != 0)
{
Session session = new Session();
session.sessionhash = Guid.NewGuid().ToString("N");
session.userid = forumUserId;
session.host = host;
session.idhash = CalculateMD5Hash(String.Concat(useragent, GetSubIP(GetRealIP(host, forwardedfor))));
TimeSpan ts = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0));
session.lastactivity = Convert.ToInt32(ts.TotalSeconds);
session.location = "/login.php";
session.useragent = useragent;
session.loggedin = 1;
session.apiaccesstoken = string.Empty;
using (ExternalDbContext db = new ExternalDbContext())
{
db.Sessions.Add(session);
db.SaveChanges();
}
return session.sessionhash;
}
return string.Empty;
}
public bool IsExistingForumSession(string sessionhash)
{
using (ExternalDbContext db = new ExternalDbContext())
{
var session = db.Sessions.FirstOrDefault(x => x.sessionhash == sessionhash);
if (session != null)
return true;
}
return false;
}
public User ActivateUser(string username, string activationid)
{
User user;
using (ExternalDbContext db = new ExternalDbContext())
{
user = db.Users.FirstOrDefault(x => x.username == username);
user.usergroupid = 2;
db.Users.Attach(user);
db.Entry(user).Property(u => u.usergroupid).IsModified = true;
db.SaveChanges();
}
if (user != null)
{
using (ExternalDbContext db = new ExternalDbContext())
{
db.Database.ExecuteSqlCommand("DELETE FROM `vb3_useractivation` WHERE userid = @userid AND activationid = @activationid", new MySqlParameter("userid", user.userid), new MySqlParameter("activationid", activationid));
db.SaveChanges();
}
}
return user;
}
public User CreateForumUser(User user, string activationid)
{
using (ExternalDbContext db = new ExternalDbContext())
{
db.Users.Add(user);
db.SaveChanges();
}
using (ExternalDbContext db = new ExternalDbContext())
{
db.Database.ExecuteSqlCommand("INSERT INTO `vb3_userfield` (userid) VALUES(@userid)", new MySqlParameter("userid", user.userid));
db.SaveChanges();
}
using (ExternalDbContext db = new ExternalDbContext())
{
db.Database.ExecuteSqlCommand("INSERT INTO `vb3_useractivation` (userid, activationid) VALUES(@userid,@activationid)", new MySqlParameter("userid", user.userid), new MySqlParameter("activationid", activationid));
db.SaveChanges();
}
return user;
}
public void DeleteForumCpSession(string hash)
{
using (ExternalDbContext db = new ExternalDbContext())
{
var session = db.CpSessions.FirstOrDefault(x => x.hash == hash);
if (session != null)
{
db.CpSessions.Remove(session);
db.SaveChanges();
}
}
}
public void UpdateForumSession(string username, string sessionhash, int loggedin)
{
int forumUserId = 0;
using (NtxfcDbContext db = new NtxfcDbContext())
{
Login login = db.Logins.FirstOrDefault(x => x.Username == username);
if (login != null)
forumUserId = login.ForumUserId;
}
if (forumUserId != 0)
{
using (ExternalDbContext db = new ExternalDbContext())
{
var session = db.Sessions.FirstOrDefault(x => x.sessionhash == sessionhash);
if (session != null)
{
session.loggedin = loggedin;
session.userid = forumUserId;
db.Sessions.Attach(session);
db.Entry(session).Property(u => u.loggedin).IsModified = true;
db.Entry(session).Property(u => u.userid).IsModified = true;
db.SaveChanges();
}
}
}
}
public bool IsValidAuthenticationCode(string username, string activiationId)
{
using (ExternalDbContext db = new ExternalDbContext())
{
var activation = db.Database.SqlQuery<UserActivation>("SELECT vb3_useractivation.* FROM vb3_useractivation, vb3_user WHERE vb3_user.username = @username AND vb3_useractivation.activationid = @activiationId", new MySqlParameter("username", username), new MySqlParameter("activiationId", activiationId));
if (activation.Any())
{
return true;
}
}
return false;
}
