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 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();
}
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.");
}
