private void ItemsList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("medics").Where("Id", ItemsList.SelectedItem.ToString()).And("Name", SearchBox.Text).Execute();
MySqlReader r = new MySqlReader(cmd);
Clear();
if (r.Read())
{
ItemId = r.ReadInt64("Id");
MName.Text = r.ReadString("Name");
MSS.Text = r.ReadString("ScientificName");
MSUP.Text = r.ReadString("Supplier");
Ptype = r.ReadByte("Type");
MExist.Text = r.ReadDecimal("Total").ToString();
MPrice.Text = r.ReadDecimal("SPrice").ToString();
MEX.Text = r.ReadString("ExpirationDate");
MNotes.Text = r.ReadString("Notes");
SearchBox.Foreground = Brushes.Green;
if (Convert.ToDecimal(MExist.Text) < 1)
{
MExist.Foreground = Brushes.Red;
Console.WriteLine("You have no - " + MName.Text + " - I believe that you should get new ones");
}
if (Convert.ToDateTime(MEX.Text) <= DateTime.Now.Date)
{
MEX.Background = Brushes.Red;
MEX.Foreground = Brushes.OrangeRed;
Console.WriteLine("Exy exy - " + MName.Text + " - I believe that you should get rid of that");
}
MTypeFromToNo();
Console.WriteLine("Searched for - " + MName.Text + " -");
}
}
public static Patient LoadPatient(uint PatientId)
{
Patient patient = null;
using (var cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("patient").Where("PatientId", PatientId))
using (var reader = new MySqlReader(cmd))
{
if (reader.Read())
{
patient = new Patient(reader.ReadInt32("PatientId"),
reader.ReadInt32("Age"),
(Gender)reader.ReadByte("Gender"),
reader.ReadString("PatientName"),
reader.ReadString("PhoneNumber"),
reader.ReadString("Address"));
}
}
if (patient != null)
{
using (var cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("history").Where("PatientId", PatientId))
using (var reader = new MySqlReader(cmd))
{
while (reader.Read())
{
patient.insertNewHistory($"[{DateTime.FromBinary(reader.ReadInt64("Date"))}] ==> {reader.ReadString("History")}");
}
}
}
return(patient);
}
private void SearchB_Click(object sender, EventArgs e)
{
clear();
try
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("medics").Where("Name", SearchT.Text).Execute();
MySqlReader r = new MySqlReader(cmd);
if (r.Read())
{
PName.Text = r.ReadString("Name");
PSubS.Text = r.ReadString("Substance");
Ptype = r.ReadByte("Type");
PTottal.Text = r.ReadUInt32("Count").ToString();
PCost.Text = r.ReadString("Price");
PEXP.Text = r.ReadString("Expiry");
Pnote.Text = r.ReadString("Note");
ptype();
FP.ForeColor = Color.Green;
FP.Text = "وجد الدواء";
FP.Visible = true;
}
else
{
FP.ForeColor = Color.Red;
FP.Text = "لم يعثر على شئ";
FP.Visible = true;
}
}
catch (Exception ef)
{
Program.SaveException(ef);
}
}
public static void Save()
{
try
{
using (var conn = Database.DataHolder.MySqlConnection)
{
conn.Open();
foreach (Client.GameClient client in Kernel.GamePool.Values)
{
client.Account.Save(client);
Database.EntityTable.SaveEntity(client, conn);
Database.DailyQuestTable.Save(client);
Database.SkillTable.SaveProficiencies(client, conn);
Database.ActivenessTable.Save(client);
Database.ChiTable.Save(client);
Database.SkillTable.SaveSpells(client, conn);
Database.MailboxTable.Save(client);
Database.ArenaTable.SaveArenaStatistics(client.ArenaStatistic, client.CP, conn);
Database.TeamArenaTable.SaveArenaStatistics(client.TeamArenaStatistic, conn);
}
}
Conquord.Database.JiangHu.SaveJiangHu();
AuctionBase.Save();
Database.Flowers.LoadFlowers();
Database.InnerPowerTable.Save();
Database.EntityVariableTable.Save(0, Vars);
using (MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT))
{
cmd.Select("configuration");
using (MySqlReader r = new MySqlReader(cmd))
{
if (r.Read())
{
new Database.MySqlCommand(Database.MySqlCommandType.UPDATE).Update("configuration").Set("ServerKingdom", Kernel.ServerKingdom).Set("ItemUID", Network.GamePackets.ConquerItem.ItemUID.Now).Set("GuildID", Game.ConquerStructures.Society.Guild.GuildCounter.Now).Set("UnionID", Union.UnionCounter.Now).Execute();
if (r.ReadByte("LastDailySignReset") != DateTime.Now.Month)
{
MsgSignIn.Reset();
}
}
}
}
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE).Update("configuration"))
cmd.Set("LastDailySignReset", DateTime.Now.Month).Execute();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
private void UNList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Label1.Visibility = Visibility.Hidden;
MySqlCommand cmd1 = new MySqlCommand(MySqlCommandType.SELECT);
cmd1.Select("accounts").Where("Username", UNList.SelectedItem.ToString()).Execute();
MySqlReader r = new MySqlReader(cmd1);
if (r.Read())
{
try
{
byte state;
state = r.ReadByte("State");
switch (state)
{
case 2:
RUState.Text = "مدير";
break;
case 1:
RUState.Text = "موظف";
break;
case 0:
RUState.Text = "مجهول";
break;
}
RUState.SelectedItem = RUState.Text;
PHN.Text = r.ReadString("Phone");
}
catch (Exception ex)
{
Kernel.Core.SaveException(ex);
}
}
}
private void SearchButton_Click(object sender, RoutedEventArgs e)
{
Clear();
try
{
if (ByBarCode.IsChecked == true)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("medics").Where("Barcode", SearchBox.Text).Execute();
MySqlReader r = new MySqlReader(cmd);
if (r.Read())
{
ItemId = r.ReadInt64("Id");
MName.Text = r.ReadString("Name");
MSS.Text = r.ReadString("ScientificName");
MSUP.Text = r.ReadString("Supplier");
Ptype = r.ReadByte("Type");
MExist.Text = r.ReadDecimal("Total").ToString();
MPrice.Text = r.ReadDecimal("SPrice").ToString();
MEX.Text = r.ReadString("ExpirationDate");
MNotes.Text = r.ReadString("Notes");
SearchBox.Foreground = Brushes.Green;
if (Convert.ToDecimal(MExist.Text) < 1)
{
MExist.Foreground = Brushes.Red;
Console.WriteLine("You have no - " + MName.Text + " - " + ItemId + " - I believe that you should get new ones");
}
if (Convert.ToDateTime(MEX.Text) <= DateTime.Now.Date)
{
MEX.Background = Brushes.Red;
MEX.Foreground = Brushes.OrangeRed;
Console.WriteLine("bad deadpool - " + MName.Text + " - " + ItemId + " - you should get rid of that");
}
Console.WriteLine("Searched for - " + MName.Text + " - " + ItemId + " -");
}
else
{
SearchBox.Foreground = Brushes.Red;
Console.WriteLine("Searched for - " + SearchBox.Text + " - with no luck");
}
r.Close();
ItemsList.Items.Clear();
while (r.Read())
{
ItemsList.Items.Add(r.ReadInt64("Id"));
}
if (ItemsList.Items.Count < 1)
{
ItemsList.Items.Clear();
ItemsList.Items.Add("لا يوجد شئ اخر");
}
r.Close();
}
else if (ByBarCode.IsChecked == false)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("medics").Where("Name", SearchBox.Text).Execute();
MySqlReader r = new MySqlReader(cmd);
if (r.Read())
{
ItemId = r.ReadInt64("Id");
MName.Text = r.ReadString("Name");
MSS.Text = r.ReadString("ScientificName");
MSUP.Text = r.ReadString("Supplier");
Ptype = r.ReadByte("Type");
MExist.Text = r.ReadDecimal("Total").ToString();
MPrice.Text = r.ReadDecimal("SPrice").ToString();
MEX.Text = r.ReadString("ExpirationDate");
MNotes.Text = r.ReadString("Notes");
SearchBox.Foreground = Brushes.Green;
if (Convert.ToDecimal(MExist.Text) < 1)
{
MExist.Foreground = Brushes.Red;
Console.WriteLine("You have no - " + MName.Text + " - I believe that you should get new ones");
}
if (Convert.ToDateTime(MEX.Text) <= DateTime.Now.Date)
{
MEX.Background = Brushes.Red;
MEX.Foreground = Brushes.OrangeRed;
Console.WriteLine("Red Alert - " + MName.Text + " - you should get rid of that");
}
Console.WriteLine("Searched for - " + MName.Text + " -");
}
else
{
SearchBox.Foreground = Brushes.Red;
Console.WriteLine("Searched for - " + SearchBox.Text + " - with no luck");
}
ItemsList.Items.Clear();
while (r.Read())
{
ItemsList.Items.Add(r.ReadInt64("Id"));
}
if (ItemsList.Items.Count < 1)
{
ItemsList.Items.Clear();
ItemsList.Items.Add("لا يوجد شئ اخر");
}
r.Close();
}
MTypeFromToNo();
}
catch (Exception ex)
{
Core.SaveException(ex);
}
SearchBox.Items.Refresh();
}
public static void LoadServer(bool KnowConfig)
{
Time32 Start = Time32.Now;
RandomSeed = Convert.ToInt32(DateTime.Now.Ticks.ToString().Remove(DateTime.Now.Ticks.ToString().Length / 2));
Console.Title = "Conquord Is Loading...";
Kernel.Random = new FastRandom(RandomSeed);
if (!KnowConfig)
{
ConquordDBName = "test";
ConquordDBPass = "******";
ConquordIP = "149.202.128.35";
}
System.Console.ForegroundColor = ConsoleColor.DarkGray;
IntPtr hWnd = FindWindow(null, Console.Title);
System.Console.WriteLine(@" ` ______ __ ` ` ");
System.Console.WriteLine(@" / ____/___ ____ ____ ___ ______ _________/ / ");
System.Console.WriteLine(@" ` / / / __ \/ __ \/ __ `/ / / / __ \/ ___/ __ / ` ` _ ");
System.Console.WriteLine(@" _/ /___/ /_/ / / / / /_/ / /_/ / /_/ / / / /_/ / | | ");
System.Console.WriteLine(@" ` \____/\____/_/ /_/\__, /\__,_/\____/_/ \__,_/ ` ___| | ");
System.Console.WriteLine(@" ` /_/ ` ` ( .' ");
System.Console.WriteLine(@" __ ... _____ Michael Nashaat _____ ... __ ) ( ");
System.Console.WriteLine();
System.Console.WriteLine(@" Copyright (c) Conquord Project 2015-2016. ");
Console.BackgroundColor = ConsoleColor.Black;
System.Console.ForegroundColor = ConsoleColor.DarkGray;
Database.DataHolder.CreateConnection(ConquordDBName, ConquordDBPass);
Database.EntityTable.EntityUID = new Counter(0);
new MySqlCommand(MySqlCommandType.UPDATE).Update("entities").Set("Online", 0).Execute();
using (MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT))
{
cmd.Select("configuration");
using (MySqlReader r = new MySqlReader(cmd))
{
if (r.Read())
{
if (!KnowConfig)
{
ConquordIP = r.ReadString("ConquordIP");
GamePort = 5816;
AuthPort = r.ReadUInt16("ConquordPort");
}
Database.EntityTable.EntityUID = new Counter(r.ReadUInt32("EntityID"));
if (Database.EntityTable.EntityUID.Now == 0)
{
Database.EntityTable.EntityUID.Now = 1;
}
Union.UnionCounter = new Counter(r.ReadUInt32("UnionID"));
Kernel.ServerKingdom = (r.ReadUInt32("ServerKingdom"));
if (r.ReadByte("LastDailySignReset") != DateTime.Now.Month)
{
MsgSignIn.Reset();
}
Game.ConquerStructures.Society.Guild.GuildCounter = new Conquord.Counter(r.ReadUInt32("GuildID"));
Network.GamePackets.ConquerItem.ItemUID = new Conquord.Counter(r.ReadUInt32("ItemUID"));
Constants.ExtraExperienceRate = r.ReadUInt32("ExperienceRate");
Constants.ExtraSpellRate = r.ReadUInt32("SpellExperienceRate");
Constants.ExtraProficiencyRate = r.ReadUInt32("ProficiencyExperienceRate");
Constants.MoneyDropRate = r.ReadUInt32("MoneyDropRate");
Constants.ConquerPointsDropRate = r.ReadUInt32("ConquerPointsDropRate");
Constants.ItemDropRate = r.ReadUInt32("ItemDropRate");
Constants.ItemDropQualityRates = r.ReadString("ItemDropQualityString").Split('~');
Database.EntityVariableTable.Load(0, out Vars);
}
}
}
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE).Update("configuration"))
cmd.Set("LastDailySignReset", DateTime.Now.Month).Execute();
Database.JiangHu.LoadStatus();
Database.JiangHu.LoadJiangHu();
Console.WriteLine("JiangHu Loaded.");
Way2Heroes.Load();
QuestInfo.Load();
AuctionBase.Load();
Database.DataHolder.ReadStats();
Conquord.Soul.SoulProtection.Load();
Database.PerfectionTable.Load();
Console.WriteLine("Perfection Loaded.");
Database.LotteryTable.Load();
Database.ConquerItemTable.ClearNulledItems();
Database.ConquerItemInformation.Load();
Console.WriteLine("Items Loaded.");
Database.GameUpdetess.LoadRates();
Database.MonsterInformation.Load();
Database.IPBan.Load();
Database.SpellTable.Load();
Database.ShopFile.Load();
Database.HonorShop.Load();
Database.RacePointShop.Load();
Database.ChampionShop.Load();
Database.EShopFile.Load();
Database.EShopV2File.Load();
Console.WriteLine("Shops Loaded.");
Database.MapsTable.Load();
Database.Flowers.LoadFlowers();
Database.Flowers.SaveFlowers();
Console.WriteLine("Flowers Systems Loaded.");
Database.NobilityTable.Load();
Database.ArenaTable.Load();
Database.TeamArenaTable.Load();
Database.GuildTable.Load();
Database.ChiTable.LoadAllChi();
Console.WriteLine("Social Systems Loaded.");
Refinery.LoadItems();
StorageManager.Load();
UnionTable.Load();
Console.WriteLine("Union Loaded.");
World = new World();
World.Init();
Database.Statue.Load();
Console.WriteLine("Tops And Quests Loaded.");
Database.PoketTables.LoadTables();
Database.InnerPowerTable.LoadDBInformation();
Database.InnerPowerTable.Load();
Console.WriteLine("InnerPower Loaded.");
Map.CreateTimerFactories();
Database.SignInTable.Load();
Database.DMaps.Load();
Console.WriteLine("Maps Loaded.");
Game.Screen.CreateTimerFactories();
World.CreateTournaments();
Game.GuildWar.Initiate();
Game.ClanWar.Initiate();
Game.Tournaments.SkillTournament.LoadSkillTop8();
Game.Tournaments.TeamTournament.LoadTeamTop8();
Clan.LoadClans();
Game.EliteGuildWar.EliteGwint();
Console.WriteLine("Guilds and Clans loaded.");
Booths.Load();
Console.WriteLine("Booths Loaded.");
Database.FloorItemTable.Load();
Database.ReincarnationTable.Load();
new MsgUserAbilityScore().GetRankingList();
new MsgEquipRefineRank().UpdateRanking();
PrestigeRank.LoadRanking();
Console.WriteLine("Ranks Loaded.");
BruteForceProtection.CreatePoll();
Console.WriteLine("Protection System On.");
{
Client.GameClient gc = new Client.GameClient(new ClientWrapper());
gc.Account = new AccountTable("NONE");
gc.Socket.Alive = false;
gc.Entity = new Entity(EntityFlag.Player, false)
{
Name = "NONE"
};
Npcs.GetDialog(new NpcRequest(), gc, true);
}
#region OpenSocket
Network.Cryptography.AuthCryptography.PrepareAuthCryptography();
AuthServer = new ServerSocket();
AuthServer.OnClientConnect += AuthServer_OnClientConnect;
AuthServer.OnClientReceive += AuthServer_OnClientReceive;
AuthServer.OnClientDisconnect += AuthServer_OnClientDisconnect;
AuthServer.Enable(AuthPort, "0.0.0.0");
GameServer = new ServerSocket();
GameServer.OnClientConnect += GameServer_OnClientConnect;
GameServer.OnClientReceive += GameServer_OnClientReceive;
GameServer.OnClientDisconnect += GameServer_OnClientDisconnect;
GameServer.Enable(GamePort, "0.0.0.0");
#endregion
Console.WriteLine("Server loaded iN : " + (Time32.Now - Start) + " MilliSeconds.");
ConquordHandler += ConquordConsole_CloseEvent;
Native.SetConsoleCtrlHandler(ConquordHandler, true);
GC.Collect();
WorkConsole();
}
