[HELP]Save Bug?

[hazif39]

i have a problem with COV2 Source ( 2009 Gift ),

the problem is that it wont save characters or i am making characters wrong, when i make one , i relog when it dcs me like its supposed to but it just takes me back..


( PeTe Ninja tried to help me, and he is working on to help me fix it ) ( this is also him posting this for me )


no flame please =]

[culo01]

Originally Posted by hazif39

i have a problem with COV2 Source ( 2009 Gift ),

the problem is that it wont save characters or i am making characters wrong, when i make one , i relog when it dcs me like its supposed to but it just takes me back..


( PeTe Ninja tried to help me, and he is working on to help me fix it ) ( this is also him posting this for me )


no flame please =]

make sure your database matches your character in msql

[PeTe Ninja]

that did not make any sense.. rephrase.

[culo01]

Originally Posted by PeTe Ninja

that did not make any sense.. rephrase.

look in database.cs " save char " void ..
go down the list:
money
hair
skills
etc..

now go to your phpadmin where you have your mysql den go to character and

make sure the list matches the one in save char void if not add

[hazif39]

Originally Posted by culo01

look in database.cs " save char " void ..
go down the list:
money
hair
skills
etc..

now go to your phpadmin where you have your mysql den go to character and

make sure the list matches the one in save char void if not add

what do u mean?
tell me what i should need to do

[yuko]

he ment that this :
public static void SaveChar(Character Charr)
{
...
...
...
...
...
MySqlCommand Command = 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 + "' WHERE `Account` = '" + Charr.MyClient.Account + "'", Connection);
...
...
...
...
...
}
so the whole MySqlCommand Command has to be the same as mysql database (coproj -> Characters)
if it is not the same you'll have to add the needed stuff. anyway i don't think that this is a solution to your problem.

try this instad

delete the database(mysql)
make new database(mysql) -> coproj
go to import select backup.sql 100%.sql
and try again.

[hazif39]

Originally Posted by yuko

he ment that this :
public static void SaveChar(Character Charr)
{
...
...
...
...
...
MySqlCommand Command = 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 + "' WHERE `Account` = '" + Charr.MyClient.Account + "'", Connection);
...
...
...
...
...
}
so the whole MySqlCommand Command has to be the same as mysql database (coproj -> Characters)
if it is not the same you'll have to add the needed stuff. anyway i don't think that this is a solution to your problem.

try this instad

delete the database(mysql)
make new database(mysql) -> coproj
go to import select backup.sql 100%.sql
and try again.

not work :OOO

[yuko]

try and debug



check the values

[hazif39]

i upload the Client.cs and Character.cs just edit for me please if u can and send me here..

[Exia13]

Im not sure how you can have a problem. I use the same source right now and i've had ABSOLUTELY NO problems with it.