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); }
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(); } } }
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); } }
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 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); } }
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); } }
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 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 = ADatabaseConfigsManager.avatarDB.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 { ADatabaseConfigsManager.avatarDB.UpdateOneData(tableName, ADBAccessor.filter_eq(InfoNameDefs.AvatarName, owner.OnGetStringParamValue(InfoNameDefs.AvatarName)) , ADBAccessor.updates_build(ADBAccessor.update(InfoNameDefs.AvatarName, owner.OnGetStringParamValue(InfoNameDefs.AvatarName))), true); } }
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 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 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 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); } }