[HELP]Save Bug?

02/11/2009 00:06 hazif39#1
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 =]
02/11/2009 00:13 culo01#2
Quote:
Originally Posted by hazif39 View Post
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
02/11/2009 01:08 PeTe Ninja#3
that did not make any sense.. rephrase.
02/11/2009 03:25 culo01#4
Quote:
Originally Posted by PeTe Ninja View Post
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
02/11/2009 06:56 hazif39#5
Quote:
Originally Posted by culo01 View Post
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
02/11/2009 12:06 yuko#6
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.
02/11/2009 12:53 hazif39#7
Quote:
Originally Posted by yuko View Post
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
02/11/2009 15:48 yuko#8
try and debug

[Only registered and activated users can see links. Click Here To Register...]

check the values
02/11/2009 16:46 hazif39#9
i upload the Client.cs and Character.cs just edit for me please if u can and send me here..
02/11/2009 17:15 Exia13#10
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.