Ok im trying to save "x" amount of times some one uses a exp ball
What i have so far
In Character.cs
up and it does add every time i use a expball
Next i have
In my DataBase
It does not add it to the database and the game stops saving every thing
What i have so far
In Character.cs
Quote:
public uint ExpBallCount = 0;
ok so far it all works i made a /expused command to see if it was even addingQuote:
ExpBallCount++
up and it does add every time i use a expball
Next i have
In my DataBase
Database.csQuote:
Field=ExpBallCount
Type=INT
Attributes=UNSIGNED
Null=No
Default=0
Database.csQuote:
Charr.ExpBallCount = (uint)DR["ExpBallCount"];
Now once i add the "',`ExpBallCount` = " + Charr.ExpBallCountQuote:
ExternalDatabase.DatabaseQueue.Enqueue(new MySqlCommand("UPDATE `Characters` SET `CharName` = '" + Charr.Name + "', `Level` = " + Charr.Level + ",`Exp` = " + Charr.Exp + ",`GuildDonation` = " + Charr.GuildDonation + ",`Strength` = " + Charr.Str + ",`Agility` = " + Charr.Agi + ",`Vitality` = " + Charr.Vit + ",`Spirit` = " + Charr.Spi + ",`Job` = " + Charr.Job + ",`Model` = " + Charr.RealModel + ",`Money` = " + Charr.Silvers + ",`CPs` = " + Charr.CPs + ",`CurrentHP` = " + Charr.CurHP + ",`StatPoints` = " + Charr.StatP + ",`MyGuild` = " + Charr.GuildID + ",`GuildPos` = " + Charr.GuildPosition + ",`LocationMap` = " + Charr.LocMap + ",`LocationX` = " + Charr.LocX + ",`LocationY` = " + Charr.LocY + ",`Hair` = " + Charr.Hair + ",`Equipment` = '" + Charr.PackedEquips + "',`Inventory` = '" + Charr.PackedInventory + "',`PKPoints` = " + Charr.PKPoints + ",`PrevMap` = " + Charr.PrevMap + ", `Skills` = '" + Charr.PackedSkills + "', `Profs` = '" + Charr.PackedProfs + "',`RBCount` = " + Charr.RBCount + ",`Avatar` = " + Charr.Avatar + ",`WHMoney` = " + Charr.WHSilvers + ",`VP` = " + Charr.VP + ",`Warehouses` = '" + Charr.PackedWHs + "',`Friends` = '" + Charr.PackedFriends + "',`Enemies` = '" + Charr.PackedEnemies + "',`QuestMob` = '" + Charr.QuestMob + "',`QuestKO` = " + Charr.QuestKO +"',`ExpBallCount` = " + Charr.ExpBallCount + " WHERE `Account` = '" + Charr.MyClient.Account + "'", ExternalDatabase.Connection));
It does not add it to the database and the game stops saving every thing