public void CacheMaps() { MySqlDataReader reader = new ReaderQuery().Execute("SELECT * FROM meh_maps"); while (reader.Read()) { Maps maps = new Maps { FileName = reader.GetString("FileName"), Max = reader.GetInt32("PlayersMax"), Name = reader.GetString("Name"), MonFrame = reader.GetString("monsters_frame"), MonTree = reader.GetString("monsters_tree"), MonInfo = reader.GetString("monsters_info"), Id = reader.GetInt32("id"), Extra = reader.GetString("Extra"), Duel = reader.GetInt32("Duel"), PvP = reader.GetInt32("PvP") }; Maps.Add(maps.Id, maps); } reader.Close(); reader.Dispose(); Console.WriteLine($"Cached {Maps.Count} maps."); }
public void CacheItems() { MySqlDataReader reader = new ReaderQuery().Execute("SELECT * FROM meh_items"); while (reader.Read()) { Items item = new Items { ItemId = reader.GetInt32("id"), bCoins = reader.GetInt32("Coins"), EnhID = reader.GetInt32("EnhID"), bHouse = reader.GetInt32("House"), bStaff = reader.GetInt32("Staff"), bTemp = reader.GetInt32("Temp"), bUpg = reader.GetInt32("Upg"), iCost = reader.GetInt32("Cost"), IDps = reader.GetInt32("DPS"), iLvl = reader.GetInt32("Lvl"), iHrs = -1, iQSIndex = -1, iQSValue = 0, iQty = reader.GetInt32("Qty"), IRng = reader.GetInt32("Rng"), iRty = reader.GetInt32("Rty"), SDesc = reader.GetString("Desc"), iStk = reader.GetInt32("Stk"), SName = reader.GetString("Name"), SFile = reader.GetString("File"), SLink = reader.GetString("Link"), SType = reader.GetString("Type"), SEs = reader.GetString("ES"), sIcon = reader.GetString("Icon"), SElmt = reader.GetString("Elmt"), sMeta = reader.GetString("Meta"), sReqQuests = reader.GetString("ReqQuests"), ClassId = reader.GetInt32("ClassID") }; Items.Add(item.ItemId, item); } reader.Close(); reader.Dispose(); Console.WriteLine($"Cached {Items.Count} items."); }
public void CacheSettings() { MySqlDataReader reader = new ReaderQuery().Execute("SELECT * FROM server_settings WHERE id = 1"); while (reader.Read()) { Settings.Motd = reader.GetString("Message"); Settings.Map = reader.GetString("Map"); Settings.Book = reader.GetString("Book"); Settings.Map = reader.GetString("Map"); Settings.Assets = reader.GetString("Assets"); Settings.Fbc = reader.GetString("Fbc"); Settings.GameMenu = reader.GetString("GameMenu"); Settings.Video = reader.GetString("Video"); Settings.News = reader.GetString("News"); } reader.Close(); reader.Dispose(); Console.WriteLine($"Server settings cached. MOTD: {Settings.Motd}"); }
public void CacheSkills() { MySqlDataReader reader = new ReaderQuery().Execute("SELECT * FROM meh_skills"); while (reader.Read()) { Skills skill = new Skills { id = reader.GetInt32("id"), Ref = reader.GetString("Ref"), anim = reader.GetString("anim"), cd = reader.GetInt32("cd"), desc = reader.GetString("description"), fx = reader.GetString("fx"), icon = reader.GetString("icon"), mp = reader.GetInt32("mp"), nam = reader.GetString("nam"), range = reader.GetInt32("rng"), tgt = reader.GetString("tgt"), tgtMax = reader.GetInt32("tgtMax"), typ = reader.GetString("typ"), strl = reader.GetString("strl"), auto = reader.GetBoolean("auto"), dsrc = reader.GetString("dsrc"), damage = (double)reader.GetDecimal("damage"), tgtMin = reader.GetInt32("tgtMin") }; Skills.Add(skill.id, skill); } reader.Close(); reader.Dispose(); Console.WriteLine($"Cached {Skills.Count} skills."); }
public void Handle(XmlMessage message) { var username = message.Body.SelectSingleNode("//msg/body/login/nick").InnerText.Split(Convert.ToChar("~"))[1].ToLower(); var password = message.Body.SelectSingleNode("/msg/body/login/pword").InnerText; MySqlDataReader reader = new ReaderQuery().Execute( "SELECT * FROM meh_users WHERE Username=@user AND Password=@pass", new Dictionary <string, object>() { { "user", username }, { "pass", password } } ); if (reader.Read()) { PlayerInfo player = new PlayerInfo { UserID = reader.GetInt32("id"), CharID = reader.GetInt32("id"), HairID = reader.GetInt32("HairID"), bPermaMute = false, dCreated = reader.GetString("DateCreated"), dUpgExp = reader.GetString("UpgradeExpire"), iAge = reader.GetInt32("Age"), iBagSlots = reader.GetInt32("BagSlots"), iBankSlots = reader.GetInt32("BankSlots"), iCP = 0, iDailyAds = 0, iFounder = 0, iHouseSlots = reader.GetInt32("HouseSlots"), iUpg = 0, iUpgDays = reader.GetInt32("UpgradeDays"), intAccessLevel = reader.GetInt32("Access"), intActivationFlag = reader.GetInt32("ActivationFlag"), intCoins = reader.GetInt32("Coins"), intGold = reader.GetInt32("Gold"), intColorAccessory = reader.GetInt32("ColorAccessory"), intColorBase = reader.GetInt32("ColorBase"), intColorEye = reader.GetInt32("ColorEye"), intColorHair = reader.GetInt32("ColorHair"), intColorSkin = reader.GetInt32("ColorSkin"), intColorTrim = reader.GetInt32("ColorTrim"), intExp = reader.GetInt32("Exp"), intExpToLevel = 50000, intHP = 1000, intHPMax = 1000, intMP = 100, intMPMax = 100, intHits = 1, intLevel = reader.GetInt32("Level"), strEmail = reader.GetString("Email"), sHouseInfo = new JArray(), strGender = reader.GetString("Gender"), strHairFilename = reader.GetString("HairFile"), strHairName = reader.GetString("HairName"), strUsername = reader.GetString("Username").ToLower(), iBoostCP = 0, iBoostG = 0, iBoostRep = 0, iBoostXP = 0, iDBCP = 0, intDBExp = reader.GetInt32("Exp"), intDBGold = reader.GetInt32("Gold"), sCountry = "xx", strMapName = "battleon", strQuests = "00000000000000000000000000000000000000000000000000000000000000000000000000000000A0000000000000000000", strQuests2 = "00000000000000000000000000000000000000000000000000000000000000000000000000000000A0000000000000000000", strQuests3 = "00000000000000000000000000000000000000000000000000000000000000000000000000000000A0000000000000000000", bitSuccess = 1, lastArea = "battleon-2" }; var d = DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss"); message.Write("%xt%server%-1%Accepting party invites.%"); message.Write("%xt%server%-1%Accepting goto requests.%"); message.Write("%xt%server%-1%Accepting Friend requests.%"); message.Write("%xt%server%-1%Accepting PMs.%"); message.Write("%xt%server%-1%Ability ToolTips will always show on mouseover.%"); message.Write("%xt%server%-1%Accepting duel invites.%"); message.Write("%xt%server%-1%Accepting guild invites.%"); message.Write($"%xt%loginResponse%-1%true%{player.CharID}%{player.strUsername}%{Settings.Motd}%{d}%sNews={Settings.News},sMap={Settings.Map},sBook={Settings.Book},sFBC={Settings.Fbc},sAssets={Settings.Assets},sWTSandbox=false,gMenu={Settings.GameMenu},sVideo=MoviePlayer/MoviePlayer1.swf1r118222%"); } reader.Close(); reader.Dispose(); }