|
|
المشاركات 563 |
+التقييم 0.23 |
تاريخ التسجيل Mar 2020 |
الاقامة Giza |
نظام التشغيل Windows 10 Pro |
رقم العضوية 3670 |
client.ClientFlag |= Client.ServerFlag.CreateCharacterSucces;
Program.INSERTPlayerFromFileToSql(client);
public static void SaveDBPayers(
public static void SaveDBPayers(Extensions.Time32 clock, GameClient client)
{
if (clock > SaveDBStamp)
{
if (Database.Server.FullLoading && !Program.ServerConfig.IsInterServer)
{
foreach (var user in Database.Server.GamePoll.Values)
{
if (user.OnInterServer)
continue;
if ((user.ClientFlag & Client.ServerFlag.LoginFull) == Client.ServerFlag.LoginFull)
{
user.ClientFlag |= Client.ServerFlag.QueuesSave;
Database.ServerDatabase.LoginQueue.TryEnqueue(user);
}
}
UpdatePlayerFromFileToSql(client);
Database.Server.SaveDatabase();
MyConsole.WriteLine("Database got saved ! ");
}
SaveDBStamp.Value = clock.Value + KernelThread.SaveDatabaseStamp;
}
}
public unsafe static void Game_Disconnect(
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE))
{
cmd.Update("entities").Set("Online", 0).Where("UID", client.Player.UID).Execute();
}
Project_Terror_v2.ServerSockets.LoginController.LoggedIn(client.Socket.RemoteIp);
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE))
{
cmd.Update("entities").Set("Online", 1).Where("UID", client.Player.UID).Execute();
}
public static void UpdatePlayerFromFileToSql(GameClient client)
{
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE))
{
cmd.Update("entities")
.Set("HairStyle",client.Player.Hair)
.Set("Class", client.Player.Class)
.Set("Money", client.Player.Money)
.Set("ConquerPoints", client.Player.ConquerPoints)
.Set("Body", client.Player.Body)
.Set("Face", client.Player.Face)
.Set("Level", client.Player.Level)
.Set("Strength", client.Player.Strength)
.Set("Agility", client.Player.Agility)
.Set("Vitality", client.Player.Vitality)
.Set("Spirit", client.Player.Spirit)
.Set("Atributes", client.Player.Atributes)
.Set("Hitpoints", client.Player.HitPoints)
.Set("Mana", client.Player.Mana)
.Set("MapID", client.Player.Map)
.Set("X", client.Player.X)
.Set("Y", client.Player.Y)
.Set("PKPoints", client.Player.PKPoints)
.Set("Experience", client.Player.Experience)
.Set("QuizPoints", client.Player.QuizPoints)
.Set("Reborn", client.Player.Reborn)
.Set("1stClass", client.Player.FirstClass)
.Set("2ndClass", client.Player.SecoundeClass)
.Set("3rdClass", client.Player.Class)
.Set("Spouse", client.Player.Spouse)
.Set("WarehousePW", client.Player.SecurityPassword)
.Set("MoneySave", client.Player.WHMoney)
.Set("FirstRebornClass", client.Player.FirstClass)
.Set("SecondRebornClass", client.Player.SecoundeClass)
.Set("FirstRebornLevel", client.Player.FirstRebornLevel)
.Set("SecondRebornLevel", client.Player.SecoundeRebornLevel)
.Set("EnlightenPoints", client.Player.Enilghten)
.Set("GuildID", client.Player.GuildID)
.Set("GuildRank", client.Player.GuildRank)
.Set("GuildSilverDonation", client.Player.MyGuild.RankSilversDonations)
.Set("GuildConquerPointDonation", client.Player.MyGuild.RankCPDonations)
.Set("VIPLevel", client.Player.VipLevel)
.Set("ClanId", client.Player.ClanUID)
.Set("ClanDonation", client.Player.MyClan.Donation)
.Set("ClanRank", client.Player.ClanRank)
.Where("UID", client.Player.UID)
.Execute();
}
}
public static void INSERTPlayerFromFileToSql(GameClient client)
{
using (var cmd = new MySqlCommand(MySqlCommandType.INSERT))
{
cmd.Update("entities")
.Insert("HairStyle", client.Player.Hair)
.Insert("Class", client.Player.Class)
.Insert("Money", client.Player.Money)
.Insert("ConquerPoints", client.Player.ConquerPoints)
.Insert("Body", client.Player.Body)
.Insert("Face", client.Player.Face)
.Insert("Level", client.Player.Level)
.Insert("Strength", client.Player.Strength)
.Insert("Agility", client.Player.Agility)
.Insert("Vitality", client.Player.Vitality)
.Insert("Spirit", client.Player.Spirit)
.Insert("Atributes", client.Player.Atributes)
.Insert("Hitpoints", client.Player.HitPoints)
.Insert("Mana", client.Player.Mana)
.Insert("MapID", client.Player.Map)
.Insert("X", client.Player.X)
.Insert("Y", client.Player.Y)
.Insert("PKPoints", client.Player.PKPoints)
.Insert("Experience", client.Player.Experience)
.Insert("QuizPoints", client.Player.QuizPoints)
.Insert("Reborn", client.Player.Reborn)
.Insert("1stClass", client.Player.FirstClass)
.Insert("2ndClass", client.Player.SecoundeClass)
.Insert("3rdClass", client.Player.Class)
.Insert("Spouse", client.Player.Spouse)
.Insert("WarehousePW", client.Player.SecurityPassword)
.Insert("MoneySave", client.Player.WHMoney)
.Insert("FirstRebornClass", client.Player.FirstClass)
.Insert("SecondRebornClass", client.Player.SecoundeClass)
.Insert("FirstRebornLevel", client.Player.FirstRebornLevel)
.Insert("SecondRebornLevel", client.Player.SecoundeRebornLevel)
.Insert("EnlightenPoints", client.Player.Enilghten)
.Insert("VIPLevel", client.Player.VipLevel)
.Where("UID", client.Player.UID)
.Execute();
}
}
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE))
using Project2D.Database;
using COServer.Database;
using MsgServer.Database;
case ActionID.Request:
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE))
{
cmd.Update("entities").Set("Name", Name).Where("UID", user.Player.UID).Execute();
}
| الذين يشاهدون محتوى الموضوع الآن : 1 ( الأعضاء 0 والزوار 1) | |
| أدوات الموضوع | |
|
| الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
| صفحة لسورسات اليكس | Hazem | صفحات التسجيل كونكر اونلاين | 119 | 2026-10-18 02:48 PM |
| يلا صفحه لسورس اليكس انا معدلها عشان تتظبط مع اليكس | midoazoz | صفحات التسجيل كونكر اونلاين | 96 | 2021-09-19 02:21 PM |
| مشكلة في في الاميلات بتلبس حاجات مش بتاعتها | ElSaher | مشكلات السيرفيرات كونكر الشخصيه | 1 | 2020-04-13 05:15 AM |
| سورس اليكس | Hazem | مشكلات السيرفيرات كونكر الشخصيه | 6 | 2019-08-02 04:31 PM |
| خلي الجناح يقبل استونات بعد بلص 12 | Hazem | تطوير سيرفرات كونكر | 0 | 2019-04-23 03:27 PM |