public override string GooglePlayLogin(string gId, string email) { string id = string.Empty; MySQLRowsReader reader = ExecuteReader("SELECT id FROM userlogin WHERE username=@username AND password=@password AND authType=@authType LIMIT 1", new MySqlParameter("@username", "g_" + gId), new MySqlParameter("@password", GenericUtils.GetMD5(gId)), new MySqlParameter("@authType", AUTH_TYPE_GOOGLE_PLAY)); if (reader.Read()) { id = reader.GetString("id"); } else { ExecuteNonQuery("INSERT INTO userlogin (id, username, password, email, authType) VALUES (@id, @username, @password, @email, @authType)", new MySqlParameter("@id", GenericUtils.GetUniqueId()), new MySqlParameter("@username", "g_" + gId), new MySqlParameter("@password", GenericUtils.GetMD5(gId)), new MySqlParameter("@email", email), new MySqlParameter("@authType", AUTH_TYPE_GOOGLE_PLAY)); // Read last entry reader = ExecuteReader("SELECT id FROM userlogin WHERE username=@username AND password=@password AND authType=@authType LIMIT 1", new MySqlParameter("@username", "g_" + gId), new MySqlParameter("@password", GenericUtils.GetMD5(gId)), new MySqlParameter("@authType", AUTH_TYPE_GOOGLE_PLAY)); if (reader.Read()) { id = reader.GetString("id"); } } return(id); }
public override PartyData ReadParty(int id) { PartyData result = null; MySQLRowsReader reader = ExecuteReader("SELECT * FROM party WHERE id=@id LIMIT 1", new MySqlParameter("@id", id)); if (reader.Read()) { result = new PartyData(id, reader.GetBoolean("shareExp"), reader.GetBoolean("shareItem"), reader.GetString("leaderId")); reader = ExecuteReader("SELECT id, dataId, characterName, level FROM characters WHERE partyId=@id", new MySqlParameter("@id", id)); SocialCharacterData partyMemberData; while (reader.Read()) { // Get some required data, other data will be set at server side partyMemberData = new SocialCharacterData(); partyMemberData.id = reader.GetString("id"); partyMemberData.characterName = reader.GetString("characterName"); partyMemberData.dataId = reader.GetInt32("dataId"); partyMemberData.level = reader.GetInt16("level"); result.AddMember(partyMemberData); } } return(result); }
public override GuildData ReadGuild(int id, GuildRoleData[] defaultGuildRoles) { GuildData result = null; MySQLRowsReader reader = ExecuteReader("SELECT * FROM guild WHERE id=@id LIMIT 1", new MySqlParameter("@id", id)); if (reader.Read()) { result = new GuildData(id, reader.GetString("guildName"), reader.GetString("leaderId"), defaultGuildRoles); result.level = reader.GetInt16("level"); result.exp = reader.GetInt32("exp"); result.skillPoint = reader.GetInt16("skillPoint"); result.guildMessage = reader.GetString("guildMessage"); result.gold = reader.GetInt32("gold"); reader = ExecuteReader("SELECT * FROM guildrole WHERE guildId=@id", new MySqlParameter("@id", id)); byte guildRole; GuildRoleData guildRoleData; while (reader.Read()) { guildRole = reader.GetByte("guildRole"); guildRoleData = new GuildRoleData(); guildRoleData.roleName = reader.GetString("name"); guildRoleData.canInvite = reader.GetBoolean("canInvite"); guildRoleData.canKick = reader.GetBoolean("canKick"); guildRoleData.shareExpPercentage = reader.GetByte("shareExpPercentage"); result.SetRole(guildRole, guildRoleData); } reader = ExecuteReader("SELECT id, dataId, characterName, level, guildRole FROM characters WHERE guildId=@id", new MySqlParameter("@id", id)); SocialCharacterData guildMemberData; while (reader.Read()) { // Get some required data, other data will be set at server side guildMemberData = new SocialCharacterData(); guildMemberData.id = reader.GetString("id"); guildMemberData.characterName = reader.GetString("characterName"); guildMemberData.dataId = reader.GetInt32("dataId"); guildMemberData.level = reader.GetInt16("level"); result.AddMember(guildMemberData, reader.GetByte("guildRole")); } reader = ExecuteReader("SELECT dataId, level FROM guildskill WHERE guildId=@id", new MySqlParameter("@id", id)); while (reader.Read()) { result.SetSkillLevel(reader.GetInt32("dataId"), reader.GetInt16("level")); } } return(result); }
public override List <SocialCharacterData> ReadFriends(string id1) { List <SocialCharacterData> result = new List <SocialCharacterData>(); MySQLRowsReader reader = ExecuteReader("SELECT characterId2 FROM friend WHERE characterId1=@id1", new MySqlParameter("@id1", id1)); string characterId; SocialCharacterData socialCharacterData; MySQLRowsReader reader2; while (reader.Read()) { characterId = reader.GetString("characterId2"); reader2 = ExecuteReader("SELECT id, dataId, characterName, level FROM characters WHERE BINARY id = @id", new MySqlParameter("@id", characterId)); while (reader2.Read()) { // Get some required data, other data will be set at server side socialCharacterData = new SocialCharacterData(); socialCharacterData.id = reader2.GetString("id"); socialCharacterData.characterName = reader2.GetString("characterName"); socialCharacterData.dataId = reader2.GetInt32("dataId"); socialCharacterData.level = reader2.GetInt16("level"); result.Add(socialCharacterData); } } return(result); }
private bool ReadBuilding(MySQLRowsReader reader, out BuildingSaveData result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new BuildingSaveData(); result.Id = reader.GetString("id"); result.ParentId = reader.GetString("parentId"); result.DataId = reader.GetInt32("dataId"); result.CurrentHp = reader.GetInt32("currentHp"); result.Position = new Vector3(reader.GetFloat("positionX"), reader.GetFloat("positionY"), reader.GetFloat("positionZ")); result.Rotation = Quaternion.Euler(reader.GetFloat("rotationX"), reader.GetFloat("rotationY"), reader.GetFloat("rotationZ")); result.IsLocked = reader.GetBoolean("isLocked"); result.LockPassword = reader.GetString("lockPassword"); result.CreatorId = reader.GetString("creatorId"); result.CreatorName = reader.GetString("creatorName"); return(true); } result = new BuildingSaveData(); return(false); }
public override bool IncreaseGuildExp(int id, int increaseExp, int[] expTree, out short resultLevel, out int resultExp, out short resultSkillPoint) { resultLevel = 1; resultExp = 0; resultSkillPoint = 0; MySQLRowsReader reader = ExecuteReader("UPDATE guild SET exp=exp+@increaseExp WHERE id=@id;" + "SELECT level, exp, skillPoint FROM guild WHERE id=@id LIMIT 1;", new MySqlParameter("@increaseExp", increaseExp), new MySqlParameter("@id", id)); if (reader.Read()) { resultLevel = (short)reader.GetInt32("level"); resultExp = reader.GetInt32("exp"); resultSkillPoint = (short)reader.GetInt32("skillPoint"); // Update when guild level is increase if (SocialSystemSetting.CalculateIncreasedGuildExp(expTree, resultLevel, resultExp, resultSkillPoint, out resultLevel, out resultExp, out resultSkillPoint)) { ExecuteNonQuery("UPDATE guild SET level=@level, exp=@exp, skillPoint=@skillPoint WHERE id=@id", new MySqlParameter("@level", resultLevel), new MySqlParameter("@exp", resultExp), new MySqlParameter("@skillPoint", resultSkillPoint), new MySqlParameter("@id", id)); } // Return true if success return(true); } return(false); }
private bool ReadCharacterItem(MySQLRowsReader reader, out CharacterItem result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new CharacterItem(); result.id = reader.GetString("id"); result.dataId = reader.GetInt32("dataId"); result.level = reader.GetInt16("level"); result.amount = reader.GetInt16("amount"); result.equipSlotIndex = reader.GetByte("equipSlotIndex"); result.durability = reader.GetFloat("durability"); result.exp = reader.GetInt32("exp"); result.lockRemainsDuration = reader.GetFloat("lockRemainsDuration"); result.ammo = reader.GetInt16("ammo"); result.sockets = ReadSockets(reader.GetString("sockets")); return(true); } result = CharacterItem.Empty; return(false); }
public void ReadCharacter_UMA( PlayerCharacterData characterData, bool withEquipWeapons, bool withAttributes, bool withSkills, bool withSkillUsages, bool withBuffs, bool withEquipItems, bool withNonEquipItems, bool withSummons, bool withHotkeys, bool withQuests) { // Read uma data MySQLRowsReader reader = ExecuteReader("SELECT data FROM characterumasaves WHERE id=@id", new MySqlParameter("@id", characterData.Id)); if (reader.Read()) { string data = reader.GetString("data"); string[] splitedData = data.Split(','); List <byte> bytes = new List <byte>(); foreach (string entry in splitedData) { bytes.Add(byte.Parse(entry)); } UmaAvatarData umaAvatarData = new UmaAvatarData(); umaAvatarData.SetBytes(bytes); characterData.UmaAvatarData = umaAvatarData; } }
public override string FacebookLogin(string fbId, string accessToken) { string url = "https://graph.facebook.com/" + fbId + "?access_token=" + accessToken + "&fields=id,name,email"; WebClient webClient = new WebClient(); string json = webClient.DownloadString(url); json = json.Replace(@"\u0040", "@"); string id = string.Empty; Dictionary <string, object> dict = Json.Deserialize(json) as Dictionary <string, object>; if (dict.ContainsKey("id") && dict.ContainsKey("email")) { string email = (string)dict["email"]; MySQLRowsReader reader = ExecuteReader("SELECT id FROM userlogin WHERE username=@username AND password=@password AND authType=@authType LIMIT 1", new MySqlParameter("@username", "fb_" + fbId), new MySqlParameter("@password", GenericUtils.GetMD5(fbId)), new MySqlParameter("@authType", AUTH_TYPE_FACEBOOK)); if (reader.Read()) { id = reader.GetString("id"); } else { ExecuteNonQuery("INSERT INTO userlogin (id, username, password, email, authType) VALUES (@id, @username, @password, @email, @authType)", new MySqlParameter("@id", GenericUtils.GetUniqueId()), new MySqlParameter("@username", "fb_" + fbId), new MySqlParameter("@password", GenericUtils.GetMD5(fbId)), new MySqlParameter("@email", email), new MySqlParameter("@authType", AUTH_TYPE_FACEBOOK)); // Read last entry reader = ExecuteReader("SELECT id FROM userlogin WHERE username=@username AND password=@password AND authType=@authType LIMIT 1", new MySqlParameter("@username", "fb_" + fbId), new MySqlParameter("@password", GenericUtils.GetMD5(fbId)), new MySqlParameter("@authType", AUTH_TYPE_FACEBOOK)); if (reader.Read()) { id = reader.GetString("id"); } } } return(id); }
public override string GooglePlayLogin(string idToken) { string url = "https://www.googleapis.com/oauth2/v3/tokeninfo?id_token=" + idToken; WebClient webClient = new WebClient(); string json = webClient.DownloadString(url); string id = string.Empty; Dictionary <string, object> dict = Json.Deserialize(json) as Dictionary <string, object>; if (dict.ContainsKey("sub") && dict.ContainsKey("email")) { string gId = (string)dict["sub"]; string email = (string)dict["email"]; MySQLRowsReader reader = ExecuteReader("SELECT id FROM userlogin WHERE username=@username AND password=@password AND authType=@authType LIMIT 1", new MySqlParameter("@username", "g_" + gId), new MySqlParameter("@password", GenericUtils.GetMD5(gId)), new MySqlParameter("@authType", AUTH_TYPE_GOOGLE_PLAY)); if (reader.Read()) { id = reader.GetString("id"); } else { ExecuteNonQuery("INSERT INTO userlogin (id, username, password, email, authType) VALUES (@id, @username, @password, @email, @authType)", new MySqlParameter("@id", GenericUtils.GetUniqueId()), new MySqlParameter("@username", "g_" + gId), new MySqlParameter("@password", GenericUtils.GetMD5(gId)), new MySqlParameter("@email", email), new MySqlParameter("@authType", AUTH_TYPE_GOOGLE_PLAY)); // Read last entry reader = ExecuteReader("SELECT id FROM userlogin WHERE username=@username AND password=@password AND authType=@authType LIMIT 1", new MySqlParameter("@username", "g_" + gId), new MySqlParameter("@password", GenericUtils.GetMD5(gId)), new MySqlParameter("@authType", AUTH_TYPE_GOOGLE_PLAY)); if (reader.Read()) { id = reader.GetString("id"); } } } return(id); }
public override List <PlayerCharacterData> ReadCharacters(string userId) { List <PlayerCharacterData> result = new List <PlayerCharacterData>(); MySQLRowsReader reader = ExecuteReader("SELECT id FROM characters WHERE userId=@userId ORDER BY updateAt DESC", new MySqlParameter("@userId", userId)); while (reader.Read()) { string characterId = reader.GetString("id"); result.Add(ReadCharacter(userId, characterId, true, true, true, false, false, true, false, false, false, false)); } return(result); }
public override int GetGold(string userId) { int gold = 0; MySQLRowsReader reader = ExecuteReader("SELECT gold FROM userlogin WHERE id=@id LIMIT 1", new MySqlParameter("@id", userId)); if (reader.Read()) { gold = reader.GetInt32("gold"); } return(gold); }
public override int GetCash(string userId) { int cash = 0; MySQLRowsReader reader = ExecuteReader("SELECT cash FROM userlogin WHERE id=@id LIMIT 1", new MySqlParameter("@id", userId)); if (reader.Read()) { cash = reader.GetInt32("cash"); } return(cash); }
public override int GetGuildGold(int guildId) { int gold = 0; MySQLRowsReader reader = ExecuteReader("SELECT gold FROM guild WHERE id=@id LIMIT 1", new MySqlParameter("@id", guildId)); if (reader.Read()) { gold = reader.GetInt32("gold"); } return(gold); }
public override byte GetUserLevel(string userId) { byte userLevel = 0; MySQLRowsReader reader = ExecuteReader("SELECT userLevel FROM userlogin WHERE id=@id LIMIT 1", new MySqlParameter("@id", userId)); if (reader.Read()) { userLevel = (byte)reader.GetSByte("userLevel"); } return(userLevel); }
public override string ValidateUserLogin(string username, string password) { string id = string.Empty; MySQLRowsReader reader = ExecuteReader("SELECT id FROM userlogin WHERE username=@username AND password=@password AND authType=@authType LIMIT 1", new MySqlParameter("@username", username), new MySqlParameter("@password", GenericUtils.GetMD5(password)), new MySqlParameter("@authType", AUTH_TYPE_NORMAL)); if (reader.Read()) { id = reader.GetString("id"); } return(id); }
private bool ReadCharacterAttribute(MySQLRowsReader reader, out CharacterAttribute result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new CharacterAttribute(); result.dataId = reader.GetInt32("dataId"); result.amount = (short)reader.GetInt32("amount"); return(true); } result = CharacterAttribute.Empty; return(false); }
private bool ReadCharacterSkill(MySQLRowsReader reader, out CharacterSkill result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new CharacterSkill(); result.dataId = reader.GetInt32("dataId"); result.level = (short)reader.GetInt32("level"); return(true); } result = CharacterSkill.Empty; return(false); }
private bool ReadCharacterHotkey(MySQLRowsReader reader, out CharacterHotkey result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new CharacterHotkey(); result.hotkeyId = reader.GetString("hotkeyId"); result.type = (HotkeyType)reader.GetSByte("type"); result.relateId = reader.GetString("relateId"); return(true); } result = CharacterHotkey.Empty; return(false); }
private bool ReadCharacterSkillUsage(MySQLRowsReader reader, out CharacterSkillUsage result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new CharacterSkillUsage(); result.type = (SkillUsageType)reader.GetSByte("type"); result.dataId = reader.GetInt32("dataId"); result.coolDownRemainsDuration = reader.GetFloat("coolDownRemainsDuration"); return(true); } result = CharacterSkillUsage.Empty; return(false); }
private bool ReadCharacterQuest(MySQLRowsReader reader, out CharacterQuest result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new CharacterQuest(); result.dataId = reader.GetInt32("dataId"); result.isComplete = reader.GetBoolean("isComplete"); result.killedMonsters = ReadKillMonsters(reader.GetString("killedMonsters")); return(true); } result = CharacterQuest.Empty; return(false); }
public override List <SocialCharacterData> FindCharacters(string characterName) { List <SocialCharacterData> result = new List <SocialCharacterData>(); MySQLRowsReader reader = ExecuteReader("SELECT id, dataId, characterName, level FROM characters WHERE characterName LIKE @characterName LIMIT 0, 20", new MySqlParameter("@characterName", "%" + characterName + "%")); SocialCharacterData socialCharacterData; while (reader.Read()) { // Get some required data, other data will be set at server side socialCharacterData = new SocialCharacterData(); socialCharacterData.id = reader.GetString("id"); socialCharacterData.characterName = reader.GetString("characterName"); socialCharacterData.dataId = reader.GetInt32("dataId"); socialCharacterData.level = reader.GetInt16("level"); result.Add(socialCharacterData); } return(result); }
private bool ReadCharacterBuff(MySQLRowsReader reader, out CharacterBuff result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new CharacterBuff(); result.type = (BuffType)reader.GetSByte("type"); result.dataId = reader.GetInt32("dataId"); result.level = (short)reader.GetInt32("level"); result.buffRemainsDuration = reader.GetFloat("buffRemainsDuration"); return(true); } result = CharacterBuff.Empty; return(false); }
private bool ReadCharacterItem(MySQLRowsReader reader, out CharacterItem result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new CharacterItem(); result.dataId = reader.GetInt32("dataId"); result.level = (short)reader.GetInt32("level"); result.amount = (short)reader.GetInt32("amount"); result.durability = reader.GetFloat("durability"); return(true); } result = CharacterItem.Empty; return(false); }
public override int CreateGuild(string guildName, string leaderId) { int id = 0; MySQLRowsReader reader = ExecuteReader("INSERT INTO guild (guildName, leaderId) VALUES (@guildName, @leaderId);" + "SELECT LAST_INSERT_ID();", new MySqlParameter("@guildName", guildName), new MySqlParameter("@leaderId", leaderId)); if (reader.Read()) { id = (int)reader.GetUInt64(0); } if (id > 0) { ExecuteNonQuery("UPDATE characters SET guildId=@id WHERE id=@leaderId", new MySqlParameter("@id", id), new MySqlParameter("@leaderId", leaderId)); } return(id); }
private bool ReadCharacter(MySQLRowsReader reader, out PlayerCharacterData result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new PlayerCharacterData(); result.Id = reader.GetString("id"); result.DataId = reader.GetInt32("dataId"); result.EntityId = reader.GetInt32("entityId"); result.FactionId = reader.GetInt32("factionId"); result.CharacterName = reader.GetString("characterName"); result.Level = reader.GetInt16("level"); result.Exp = reader.GetInt32("exp"); result.CurrentHp = reader.GetInt32("currentHp"); result.CurrentMp = reader.GetInt32("currentMp"); result.CurrentStamina = reader.GetInt32("currentStamina"); result.CurrentFood = reader.GetInt32("currentFood"); result.CurrentWater = reader.GetInt32("currentWater"); result.EquipWeaponSet = reader.GetByte("equipWeaponSet"); result.StatPoint = reader.GetInt16("statPoint"); result.SkillPoint = reader.GetInt16("skillPoint"); result.Gold = reader.GetInt32("gold"); result.PartyId = reader.GetInt32("partyId"); result.GuildId = reader.GetInt32("guildId"); result.GuildRole = reader.GetByte("guildRole"); result.SharedGuildExp = reader.GetInt32("sharedGuildExp"); result.CurrentMapName = reader.GetString("currentMapName"); result.CurrentPosition = new Vector3(reader.GetFloat("currentPositionX"), reader.GetFloat("currentPositionY"), reader.GetFloat("currentPositionZ")); result.RespawnMapName = reader.GetString("respawnMapName"); result.RespawnPosition = new Vector3(reader.GetFloat("respawnPositionX"), reader.GetFloat("respawnPositionY"), reader.GetFloat("respawnPositionZ")); result.MountDataId = reader.GetInt32("mountDataId"); result.LastUpdate = (int)(reader.GetDateTime("updateAt").Ticks / System.TimeSpan.TicksPerMillisecond); return(true); } result = null; return(false); }
public override int CreateParty(bool shareExp, bool shareItem, string leaderId) { int id = 0; MySQLRowsReader reader = ExecuteReader("INSERT INTO party (shareExp, shareItem, leaderId) VALUES (@shareExp, @shareItem, @leaderId);" + "SELECT LAST_INSERT_ID();", new MySqlParameter("@shareExp", shareExp), new MySqlParameter("@shareItem", shareItem), new MySqlParameter("@leaderId", leaderId)); if (reader.Read()) { id = (int)reader.GetUInt64(0); } if (id > 0) { ExecuteNonQuery("UPDATE characters SET partyId=@id WHERE id=@leaderId", new MySqlParameter("@id", id), new MySqlParameter("@leaderId", leaderId)); } return(id); }
private bool ReadCharacterSummon(MySQLRowsReader reader, out CharacterSummon result, bool resetReader = true) { if (resetReader) { reader.ResetReader(); } if (reader.Read()) { result = new CharacterSummon(); result.type = (SummonType)reader.GetSByte("type"); result.dataId = reader.GetInt32("dataId"); result.summonRemainsDuration = reader.GetFloat("summonRemainsDuration"); result.level = reader.GetInt16("level"); result.exp = reader.GetInt32("exp"); result.currentHp = reader.GetInt32("currentHp"); result.currentMp = reader.GetInt32("currentMp"); return(true); } result = CharacterSummon.Empty; return(false); }