public static ChatMessage OnAddChatHistory(string senderUsername, string targetUsername, string type, string content, string head) { var time = ApiDateTime.SecondsFromBegin(); var cm = new ChatMessage(); cm.s = senderUsername; cm.t = targetUsername; cm.tp = typeParser.intParse(type); cm.c = content; cm.tm = time; cm.h = typeParser.intParse(head); AWebServices.Avatar.dbavatar.UpdateOneData(TableChat , ADBAccessor.filter_eq(InfoNameDefs.SenderName, cm.s) & ADBAccessor.filter_eq(InfoNameDefs.TargetName, cm.t) & ADBAccessor.filter_eq(InfoNameDefs.SendTime, cm.tm) & ADBAccessor.filter_eq(InfoNameDefs.SendContent, cm.c) , ADBAccessor.updates_build( ADBAccessor.update(InfoNameDefs.SendTime, cm.tm) , ADBAccessor.update(InfoNameDefs.SenderName, cm.s) , ADBAccessor.update(InfoNameDefs.TargetName, cm.t) , ADBAccessor.update(InfoNameDefs.ChatType, cm.tp) , ADBAccessor.update(InfoNameDefs.SendTime, cm.tm) , ADBAccessor.update(InfoNameDefs.SendContent, cm.c) ) , true); return(cm); }
protected override bool Init() { var bCached = base.Init(); bInited = true; if (!IsMulti) { if (!bCached) { var filter = ADBAccessor.filter_eq(ParamNameDefs.CollectionID, ObjectId.Parse(id)); var res = ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname) .FindOneData(cakeType , filter); if (res == null) { var ct = ApiDateTime.SecondsFromBegin(); ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname) .UpdateOneData(cakeType, filter , ADBAccessor.update(ParamNameDefs.CreateTime, ct), true); } else { foreach (var item in res.Names) { if (item == ParamNameDefs.CollectionID) { continue; } SetValue(item, res[item].ToString()); } } } return(bCached); } else if (string.IsNullOrEmpty(iid)) { if (!bCached) { var filter = ADBAccessor.filter_eq(ParamNameDefs.OwnerID, id); var res = ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname) .FindManyData(cakeType, filter); foreach (var r in res) { var cid = r[ParamNameDefs.ContentID].ToString(); var cakes = new CakeServer(cakeType, id); var cake = cakes.GetSingleItem(cid); foreach (var item in r.Names) { if (item == ParamNameDefs.CollectionID) { continue; } cake.SetValue(item, r[item].ToString()); } subCakes.Add(cid, cake); } } } return(bCached); }
public CakeServer(string cakeType, string id, string iid = "") : base(cakeType, id, iid) { var bCached = Init(); if (!bCached) { var res = ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname) .FindOneData(cakeType , ADBAccessor.filter_eq(ParamNameDefs.CollectionID, string.IsNullOrEmpty(iid) ? ObjectId.Parse(id) : ObjectId.Parse(iid))); if (res == null) { var ct = ApiDateTime.SecondsFromBegin(); ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname) .UpdateOneData(cakeType , ADBAccessor.filter_eq(ParamNameDefs.CollectionID, string.IsNullOrEmpty(iid) ? ObjectId.Parse(id) : ObjectId.Parse(iid)) , ADBAccessor.update(ParamNameDefs.CreateTime, ct), true); SetValue(ParamNameDefs.CreateTime, ct.ToString()); } else { foreach (var item in res.Names) { SetValue(item, res[item].ToString()); } } } bInited = true; }
public void accountregister(string username, string password, string mail) { if (!mail.Contains("@") || !mail.Contains(".") || mail.IndexOf("@") > mail.IndexOf(".")) { SendError(ErrorDefs.InvalidEmailAddress); return; } var result = dbaccount.FindOneData(tUserData, ADBAccessor.filter_eq(InfoNameDefs.Username, username), null); if (result != null) { SendError(ErrorDefs.DuplicateUsername); } else { var fdresult = dbaccount.UpdateOneData(tUserData, ADBAccessor.filter_eq(InfoNameDefs.Username, username) , ADBAccessor.updates_build( ADBAccessor.update(InfoNameDefs.UserPassword, MD5String.Hash32(password)) , ADBAccessor.update(InfoNameDefs.UserMail, mail) , ADBAccessor.update(InfoNameDefs.Username, username) ), true); if (fdresult) { SendError(Context.Response, "username", username); } else { SendDBError(); } } }
private void DoSaveFriend(string f1, string f2, string requester = "") { ADatabaseConfigsManager.avatarDB.UpdateOneData(TableName , (ADBAccessor.filter_eq(InfoNameDefs.Friend1, f1) & ADBAccessor.filter_eq(InfoNameDefs.Friend2, f2)) | (ADBAccessor.filter_eq(InfoNameDefs.Friend1, f2) & ADBAccessor.filter_eq(InfoNameDefs.Friend2, f1)) , ADBAccessor.updates_build(ADBAccessor.update(InfoNameDefs.Friend1, f1) , ADBAccessor.update(InfoNameDefs.Friend2, f2) , (string.IsNullOrEmpty(requester) ? ADBAccessor.update_unset(InfoNameDefs.FriendRequester) : ADBAccessor.update(InfoNameDefs.FriendRequester, requester))), true); }
public override void OnSave() { if (lDirtyParams.Count == 0) { return; } var u = new List <UpdateDefinition <BsonDocument> >(); foreach (var v in lDirtyParams) { if (!dParams.ContainsKey(v)) { AOutput.LogError("Cannot find param " + v); return; } var aparam = dParams[v]; switch (aparam.eParamType) { case EParamType.String: u.Add(ADBAccessor.update(v, aparam.sParamValue)); break; case EParamType.Double: u.Add(ADBAccessor.update(v, aparam.dParamValue)); break; case EParamType.Int: u.Add(ADBAccessor.update(v, aparam.iParamValue)); break; case EParamType.Long: u.Add(ADBAccessor.update(v, aparam.lParamValue)); break; } } ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname).UpdateOneData(ParamNameDefs.TableAvatar , ADBAccessor.filter_eq(ParamNameDefs.CollectionID, ownerServer.objectId), Builders <BsonDocument> .Update.Combine(u)); AOutput.Log("avatar " + owner.OnGetStringParamValue(ParamNameDefs.AvatarName) + " saved " + lDirtyParams.Count + " params"); var update = new LibPacket.PktParamUpdate(); foreach (var dp in lDirtyParams) { var info = new LibPacket.ParamInfo(); info.paramName = dp; info.paramValue = OnGetStringParamValue(dp); update.lInfos.Add(info); } ownerServer.OnSendToClient(update); lDirtyParams.Clear(); }
public void wikiadd(string subject, string content) { var id = ++totalcount; var t = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); adb.UpdateOneData(TableName , ADBAccessor.filter_eq("i", id) , ADBAccessor.updates_build( ADBAccessor.update("i", id) , ADBAccessor.update("s", subject) , ADBAccessor.update("c", content) , ADBAccessor.update("t", t) ) , true); SendError("s", subject, "c", content, "t", t); }
public void OnAddItem(int itemID, int count) { DoAddItem(itemID, count); if (dItems[itemID] <= 0) { dItems.Remove(itemID); ADatabaseConfigsManager.avatarDB.UpdateOneData(tableName, ADBAccessor.filter_eq(InfoNameDefs.AvatarName, owner.OnGetStringParamValue(InfoNameDefs.AvatarName)), ADBAccessor.updates_build(ADBAccessor.update(InfoNameDefs.BagSlotPre + itemID, 0, false))); } else { ADatabaseConfigsManager.avatarDB.UpdateOneData(tableName, ADBAccessor.filter_eq(InfoNameDefs.AvatarName, owner.OnGetStringParamValue(InfoNameDefs.AvatarName)), ADBAccessor.updates_build(ADBAccessor.update(InfoNameDefs.BagSlotPre + itemID, dItems[itemID])), true); } }
public static UpdateDefinition <BsonDocument> GetUpdate(this AParam param) { switch (param.eParamType) { case EParamType.Double: return(ADBAccessor.update(param.paramName, param.dParamValue)); case EParamType.Int: return(ADBAccessor.update(param.paramName, param.iParamValue)); case EParamType.Long: return(ADBAccessor.update(param.paramName, param.lParamValue)); case EParamType.String: return(ADBAccessor.update(param.paramName, param.sParamValue)); } return(ADBAccessor.update(param.paramName, param.paramValue)); }
internal AAvatar OnCreateAvatar(string username, string avatarname, int isex) { var updateRes = ADatabaseConfigsManager.avatarDB.UpdateOneData(ADatabaseConfigsManager.tAvatarData, ADBAccessor.filter_eq(InfoNameDefs.Username, username) , ADBAccessor.updates_build( ADBAccessor.update(InfoNameDefs.AvatarName, avatarname) ) , true); if (updateRes) { var a = new AAvatar(username, avatarname, null); OnAddAvatar(a); a.OnSetParamValue(InfoNameDefs.AvatarName, avatarname); a.OnSetParamValue(InfoNameDefs.AvatarSex, isex); return(a); } return(null); }
public virtual void OnSave() { if (lDirtyParams.Count == 0) { return; } var u = new List <UpdateDefinition <BsonDocument> >(); foreach (var v in lDirtyParams) { if (!dParams.ContainsKey(v)) { AOutput.LogError("Cannot find param " + v); return; } var aparam = dParams[v]; switch (aparam.eParamType) { case EParamType.String: u.Add(ADBAccessor.update(v, aparam.sParamValue)); break; case EParamType.Double: u.Add(ADBAccessor.update(v, aparam.dParamValue)); break; case EParamType.Int: u.Add(ADBAccessor.update(v, aparam.iParamValue)); break; case EParamType.Long: u.Add(ADBAccessor.update(v, aparam.lParamValue)); break; } } AWebServices.Avatar.dbavatar.UpdateOneData(AWebServices.Avatar.TableName , ADBAccessor.filter_eq(InfoNameDefs.AvatarName, owner.OnGetStringParamValue(InfoNameDefs.AvatarName)), Builders <BsonDocument> .Update.Combine(u)); AOutput.Log("avatar " + owner.OnGetStringParamValue(InfoNameDefs.AvatarName) + " saved " + lDirtyParams.Count + " params"); lDirtyParams.Clear(); }
public void wikimodify(string id, string content) { AWikiCell cell = OnLoadWikiCellWithoutContent(id); if (cell == null) { SendError("1"); return; } cell.content = content; var t = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); adb.UpdateOneData(TableName , ADBAccessor.filter_eq("i", cell.id) , ADBAccessor.updates_build( ADBAccessor.update("c", content) , ADBAccessor.update("lt", t) )); SendError(cell.ToArray()); }
public HttpResponseMessage Register(string username, string password, string mail) { if (!mail.Contains("@") || !mail.Contains(".") || mail.IndexOf("@") > mail.IndexOf(".")) { return(ResultToJson.GetErrorJsonResponse("Invalid mail address.")); } if (username.Length < 4) { return(ResultToJson.GetErrorJsonResponse("Too short username.")); } if (username.Length > 16) { return(ResultToJson.GetErrorJsonResponse("Too long username.")); } var res = ADatabaseConfigsManager.userDB.FindOneData(ADatabaseConfigsManager.tUserData, ADBAccessor.filter_eq(InfoNameDefs.Username, username)); if (res != null) { return(ResultToJson.GetErrorJsonResponse("Username registered.")); } var token = AWebServerUtils.GetEncryptCode(12); var ures = ADatabaseConfigsManager.userDB.UpdateOneData(ADatabaseConfigsManager.tUserData, ADBAccessor.filter_eq(InfoNameDefs.Username, username) , ADBAccessor.updates_build( ADBAccessor.update(InfoNameDefs.UserToken, token) , ADBAccessor.update(InfoNameDefs.Username, username) , ADBAccessor.update(InfoNameDefs.UserMail, mail) , ADBAccessor.update(InfoNameDefs.UserPassword, MD5String.Hash32(password)) ) , true); if (!ures) { return(ResultToJson.GetErrorJsonResponse(ErrorDefs.DBError)); } ATokenManager.Instance.OnSetToken(username, token); return(ResultToJson.GetJsonResponse(InfoNameDefs.Username, username, InfoNameDefs.UserToken, token)); }
public override void InitComponent() { var result = Avatar.dbavatar.FindOneData(tableName, ADBAccessor.filter_eq(InfoNameDefs.AvatarName, owner.OnGetStringParamValue(InfoNameDefs.AvatarName)), null); if (result != null && result.Contains(InfoNameDefs.AvatarName)) { foreach (var r in result) { if (r.Name.StartsWith(InfoNameDefs.BagSlotPre)) { var itemID = r.Name.Substring(InfoNameDefs.BagSlotPre.Length); var itemNum = r.Value.AsInt32; DoAddItem(typeParser.intParse(itemID), itemNum); } } } else { Avatar.dbavatar.UpdateOneData(tableName, ADBAccessor.filter_eq(InfoNameDefs.AvatarName, owner.OnGetStringParamValue(InfoNameDefs.AvatarName)) , ADBAccessor.updates_build(ADBAccessor.update(InfoNameDefs.AvatarName, owner.OnGetStringParamValue(InfoNameDefs.AvatarName))), true); } }
public HttpResponseMessage Login(string username, string password) { var res = ADatabaseConfigsManager.userDB.FindOneData(ADatabaseConfigsManager.tUserData, ADBAccessor.filter_eq(InfoNameDefs.Username, username) & ADBAccessor.filter_eq(InfoNameDefs.UserPassword, MD5String.Hash32(password))); if (res == null) { return(ResultToJson.GetErrorJsonResponse("Username and password mismatch.")); } var token = ""; if (res.Contains(InfoNameDefs.UserToken)) { token = res[InfoNameDefs.UserToken].ToString(); } else { token = AWebServerUtils.GetEncryptCode(12); ADatabaseConfigsManager.userDB.UpdateOneData(ADatabaseConfigsManager.tUserData, ADBAccessor.filter_eq(InfoNameDefs.Username, username), ADBAccessor.update(InfoNameDefs.UserToken, token)); } return(ResultToJson.GetJsonResponse(InfoNameDefs.UserToken, res[InfoNameDefs.UserToken].ToString())); }
public AAvatarServer OnCreateAvatar(EPartnerID ePartnerID, string uid, string avatarName, int sex, Player player) { var oid = ObjectId.GenerateNewId(); var inst = ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname).UpdateOneData(ParamNameDefs.TableAvatar , ADBAccessor.filter_eq(ParamNameDefs.UID, uid) & ADBAccessor.filter_eq(ParamNameDefs.PartnerID, (int)ePartnerID) & ADBAccessor.filter_eq(ParamNameDefs.AvatarName, avatarName) , ADBAccessor.updates_build(ADBAccessor.update(ParamNameDefs.AvatarSex, sex), ADBAccessor.update(ParamNameDefs.CollectionID, oid)), true); var a = new AAvatarServer(uid, null, oid, player); OnAddAvatar(a, player); return(a); }
public override void OnAddItem(int itemID, int count) { base.OnAddItem(itemID, count); if (dItems.ContainsKey(itemID)) { ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname).UpdateOneData(tableName, ADBAccessor.filter_eq(ParamNameDefs.CollectionID, ownerServer.objectId), ADBAccessor.updates_build(ADBAccessor.update(ParamNameDefs.BagSlotPre + itemID, dItems[itemID])), true); } else { ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname).UpdateOneData(tableName, ADBAccessor.filter_eq(ParamNameDefs.CollectionID, ownerServer.objectId), ADBAccessor.updates_build(ADBAccessor.update_unset(ParamNameDefs.BagSlotPre + itemID))); } }
public static void Tick() { if (CakeCache.dIDDirtyParams.Count > 0) { foreach (var idk in CakeCache.dIDDirtyParams) { var filter = ADBAccessor.filter_eq(ParamNameDefs.CollectionID, ObjectId.Parse(idk.Key)); foreach (var cakeTypek in idk.Value) { var lupdate = new List <UpdateDefinition <BsonDocument> >(); var vs = cakeTypek.Value.Values.ToArray(); foreach (var pv in vs) { lupdate.Add(pv.GetUpdate()); } ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname).UpdateOneData(cakeTypek.Key, filter , Builders <BsonDocument> .Update.Combine(lupdate)); } if (!dAccessTimes.ContainsKey(idk.Key)) { dAccessTimes.Add(idk.Key, DateTime.Now); } else { dAccessTimes[idk.Key] = DateTime.Now; } } CakeCache.dIDDirtyParams.Clear(); } if (CakeCache.dIIDDirtyParams.Count > 0) { foreach (var idk in CakeCache.dIIDDirtyParams) { var ll = idk.Value.ToArray(); foreach (var iidk in ll) { var filter = ADBAccessor.filter_eq(ParamNameDefs.OwnerID, idk.Key) & ADBAccessor.filter_eq(ParamNameDefs.ContentID, iidk.Key); var lll = iidk.Value.ToArray(); foreach (var cakeTypek in lll) { var lupdate = new List <UpdateDefinition <BsonDocument> >(); var llll = cakeTypek.Value.ToArray(); foreach (var pv in llll) { lupdate.Add(pv.Value.GetUpdate()); } lupdate.Add(ADBAccessor.update(ParamNameDefs.ContentID, iidk.Key)); lupdate.Add(ADBAccessor.update(ParamNameDefs.OwnerID, idk.Key)); ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname).UpdateOneData(cakeTypek.Key, filter , Builders <BsonDocument> .Update.Combine(lupdate), true); } } if (!dAccessTimes.ContainsKey(idk.Key)) { dAccessTimes.Add(idk.Key, DateTime.Now); } else { dAccessTimes[idk.Key] = DateTime.Now; } } CakeCache.dIIDDirtyParams.Clear(); } var remove = new List <string>(); foreach (var dk in dAccessTimes) { if (APlayerManager.Instance.IsOnline(dk.Key)) { continue; } if ((DateTime.Now - dk.Value).TotalSeconds > 30) { remove.Add(dk.Key); } } foreach (var r in remove) { dAccessTimes.Remove(r); if (CakeCache.dIDDirtyParams.ContainsKey(r)) { CakeCache.dIDDirtyParams.Remove(r); } if (CakeCache.dIIDDirtyParams.ContainsKey(r)) { CakeCache.dIIDDirtyParams.Remove(r); } } }
public void avatarcreate(string username, string token, string avatarname, string sex) { avatarname = filtername(avatarname); var len = CommonUtil.GetStringLength(avatarname); if (len <= 2 || len > 12) { SendError(ErrorDefs.AvatarNameInvalidLength); return; } var isex = typeParser.intParse(sex); if (isex != 0 && isex != 1) { SendError(ErrorDefs.InvalidSex); return; } var check = CheckToken(username, token); if (!check) { SendError(ErrorDefs.InvalidToken); return; } { var a = AAvatarManager.Instance.OnGetAvatar(username); if (a != null) { SendError(ErrorDefs.AlreadyHasAvatar); return; } } var findRes = dbavatar.FindOneData(TableName, ADBAccessor.filter_eq(InfoNameDefs.AvatarName, avatarname)); if (findRes != null && findRes.Contains(InfoNameDefs.AvatarName)) { SendError(ErrorDefs.DuplicateAvatarName); } else { var updateRes = dbavatar.UpdateOneData(TableName, ADBAccessor.filter_eq(InfoNameDefs.Username, username) , ADBAccessor.updates_build( ADBAccessor.update(InfoNameDefs.AvatarName, avatarname) ) , true); if (updateRes) { var a = new AAvatar(username, avatarname, null); AAvatarManager.Instance.OnAddAvatar(a); a.OnSetParamValue(InfoNameDefs.AvatarName, avatarname); a.OnSetParamValue(InfoNameDefs.AvatarSex, isex); a.OnSetParamValue(InfoNameDefs.AvatarMoney, 1000); a.OnSetParamValue(InfoNameDefs.AvatarGold, 1000); SendError(InfoNameDefs.AvatarName, avatarname); } else { SendDBError(); } } }
public void accountlogin(string username, string password) { if (username == "fs" && password == "111") { if (!dUserTokens.ContainsKey(username)) { dUserTokens.Add(username, "1"); } SendError("token", "1"); return; } var result = dbaccount.FindOneData(tUserData , ADBAccessor.filter_eq(InfoNameDefs.Username, username) & ADBAccessor.filter_eq(InfoNameDefs.UserPassword, MD5String.Hash32(password)) , null); if (result != null) { if (result.Contains(InfoNameDefs.Username)) { var token = ""; if (result.Contains(InfoNameDefs.UserToken)) { token = result[InfoNameDefs.UserToken].AsString; } else { token = AWebServerUtils.GetEncryptCode(); var updateRes = dbaccount.UpdateOneData(tUserData, ADBAccessor.filter_eq(InfoNameDefs.Username, username) , ADBAccessor.updates_build(ADBAccessor.update(InfoNameDefs.UserToken, token)), false); if (!updateRes) { SendDBError(); return; } } if (!dUserTokens.ContainsKey(username)) { dUserTokens.Add(username, token); } SendError(InfoNameDefs.Username, username, InfoNameDefs.UserToken, dUserTokens[username]); } else { SendError(ErrorDefs.UsernamePasswordMismatch); } } else { SendError(ErrorDefs.UsernamePasswordMismatch); } }
private void SetOneParam(string paramname, string value) { ADatabaseConfigsManager.avatarDB.UpdateOneData(ADatabaseConfigsManager.tAvatarData , ADBAccessor.filter_eq(InfoNameDefs.Username, username), ADBAccessor.update(paramname, value)); }
public void accountlogout(string username, string token) { var result = dbaccount.FindOneData(tUserData, ADBAccessor.filter_eq(InfoNameDefs.Username, username) & ADBAccessor.filter_eq(InfoNameDefs.UserToken, token), null); if (result != null) { if (result.Contains(InfoNameDefs.UserToken)) { var updateRes = dbaccount.UpdateOneData(tUserData, ADBAccessor.filter_eq(InfoNameDefs.Username, username) , ADBAccessor.updates_build(ADBAccessor.update(InfoNameDefs.UserToken, token, false)), false); if (updateRes) { SendError(); } else { SendDBError(); } } else { SendError(ErrorDefs.InvalidToken); } } else { SendError(ErrorDefs.InvalidToken); } }
public override void InitComponent() { var result = ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname) .FindOneData(tableName, ADBAccessor.filter_eq(ParamNameDefs.CollectionID, ownerServer.objectId), null); if (result != null) { foreach (var r in result) { if (r.Name.StartsWith(ParamNameDefs.BagSlotPre)) { var itemID = r.Name.Substring(ParamNameDefs.BagSlotPre.Length); var itemNum = r.Value.AsInt32; DoAddItem(typeParser.intParse(itemID), itemNum); } } } else { ADBManager.Get(InitValueDefs.dbconnect, InitValueDefs.dbname).UpdateOneData(tableName, ADBAccessor.filter_eq(ParamNameDefs.CollectionID, ownerServer.objectId) , ADBAccessor.updates_build(ADBAccessor.update(ParamNameDefs.AvatarName, owner.OnGetStringParamValue(ParamNameDefs.AvatarName))), true); } }