[REL] Save char cps thingy^^

06/21/2009 10:45 xellios#1
Find this
Code:
MySqlCommand Cmd = new MySqlCommand("UPDATE `characters` SET `Level` = " + Client.Level + ", `WHMoney` = " + Client.WHMoney + ", `PkPoints` = " + Client.PkPoints + ", `xCord` = " + Client.X + ", `yCord` = " + Client.Y + ", `Map` = " + (int)Client.Map + ", `HairStyle` = " + Client.Hair + ", `Class` = " + (int)Client.Class + ", `Exp` = " + Client.Exp + ", `Money` = " + Client.Money +", `Str` = " + Client.Strength + ",`Vit` = " + Client.Vitality + ", `Spi` = " + Client.Spirit + ", `Dex` = " + Client.Dexterity + ", `StatPoints` = " + Client.StatPoints + ", `FirstLog` = " + 1 + ", `Reborn` = " + Client.Reborn + ", `HP` = " + Client.CurrentHP + ", `MP` = " + Client.CurrentMP + " WHERE `CharID` = " + Client.ID, DatabaseConnection.NewConnection());
Replace it with this
Code:
			MySqlCommand Cmd = new MySqlCommand("UPDATE `characters` SET `Level` = " + Client.Level + ", `WHMoney` = " + Client.WHMoney + ", `CPs` = " + Client.CPs + "`PKPoints` = " + Client.PKPoints+", `xCord` = " + Client.X + ", `yCord` = " + Client.Y + ", `Map` = " + (int)Client.Map + ", `HairStyle` = " + Client.Hair + ", `Class` = " + (int)Client.Class + ", `Exp` = " + Client.Exp + ", `Money` = " + Client.Money +",`Str` = " + Client.Strength + ",`Vit` = " + Client.Vitality + ", `Spi` = " + Client.Spirit + ", `Dex` = " + Client.Dexterity + ", `StatPoints` = " + Client.StatPoints + ", `FirstLog` = " + 1 + ", `Reborn` = " + Client.Reborn + ", `HP` = " + Client.CurrentHP + ", `MP` = " + Client.CurrentMP + " WHERE `CharID` = " + Client.ID, DatabaseConnection.NewConnection());
Say thanks if it helped:cool:
06/23/2009 06:09 Illustria#2
Bit more information... which file is that command located in?
06/23/2009 07:35 Akarama#3
cud u add how to save items as well?
06/24/2009 04:40 WHITELIONX#4
Great but it is PkPoints and not PKPoints :P
06/24/2009 18:01 xellios#5
WHITELIONX;2427896]Great but it is PkPoints and not PKPoints :P
Well i hope theyre not that dumb that they cant change it? anyway its like that by me so i didnt know it was different untill my buddy tested it
07/03/2009 16:15 darkmanx1#6
Quote:
Originally Posted by Illustria View Post
Bit more information... which file is that command located in?
Database.cs

to search it hit ctrl+f and copy paste that line then in the box below it click down arrow and select entire solution.