private void GetCookies() { const string cookieSalt = "3MKiSbAbgNBzhcdoYy4pxOPwhE"; int userID; string dbPass; using (var context = new VBulletinUserDataModel()) { userID = (from u in context.Users where u.userid == _bbUserID select u.userid).FirstOrDefault(); if (userID == 0) { return; } dbPass = (from u in context.Users where u.userid == _bbUserID select u.password).FirstOrDefault(); } string hash = Util.CalculateMD5Hash(dbPass + cookieSalt).ToLower(); if (hash == _bbPassword) { _forumId = userID; return; } _forumId = null; }
private void UpdateActivity() { using (var userDb = new VBulletinUserDataModel()) { var user = (from u in userDb.Users where u.userid == _forumId select u).First(); user.lastactivity = _lastActive; user.ipaddress = _ipAddress; if (Util.UnixTime() - _lastActive > 900) { user.lastvisit = _lastActive; } userDb.SaveChanges(); } }
private void GetUserDetails() { VBulletinUser user; using (var userDb = new VBulletinUserDataModel()) user = (from u in userDb.Users where u.userid == _forumId select u).First(); _usergroupid = Convert.ToInt32(user.usergroupid); _username = user.username; _email = user.email; _usertitle = user.usertitle; var groups = user.membergroupids; if (!String.IsNullOrWhiteSpace(groups)) { var strings = groups.Split(new[] { ',' }); _membergroupids = strings.Select(int.Parse).ToArray(); } }