[Release] Fixing SaveVoid (CoEmu v2)

12tails · 09/22/2009, 23:21

Extremely easy to fix:

go to Database.cs and serach for SaveCharacter them just change this:

Code:

" WHERE `CharID` = " + Client.ID

to this:

Code:

" WHERE `CharID` = " + Client.ID + ""

I tested it for 24hours and doesn't give me any error(Before my server was getting down every 1 minute :X)!

If someone got any error please post.... everyone (i know who help and who don't help) will help for sure and thanks for everyone who have helped me with some codes....

Gratefull !

$HaDoW · 09/22/2009, 23:56

umm never had this problem ! O.o

12tails · 09/23/2009, 00:21

yes... you will only got this when some ppl get into your server... and this happens after some time.... but for who have this ... it's very helpfull : D

$HaDoW · 09/23/2009, 00:27

I don't want to be rude but you could post some more info what file and where to replace it

Cus not everyone will understand what you mean

Zion~ · 09/23/2009, 00:45

I think he made it quite clear.
SaveVoid

$HaDoW · 09/23/2009, 00:48

meh sorry :P I was working on a music video for 8 hours ! my eyes are hurting like hell cant see normal -_- I better go to bed now ^_^

12tails · 09/23/2009, 01:00

haha good night : D

but yes you're ritght...

Zion~ · 09/23/2009, 02:00

Well here's mine

Code:

lock (DatabaseConnection.Connection)
            {
                MySqlCommand Cmd = new MySqlCommand("UPDATE `characters` SET `GDonation` = " + Client.GuildDonation + ", `VPoints` = " + Client.VirtuePoints + ", `Model` = " + Client.Model + ", `ExpPotionTime` = " + Client.ExpPotion.AvailableFor + ", `ExpPotionRate` = " + Client.ExpPotion.Rate + ", `PreviousMap` = " + Client.PreviousMap + ", `Level` = " + Client.Level + ", `WHMoney` = " + Client.WHMoney + ", `PkPoints` = " + Client.PkPoints + ", `xCord` = " + Client.X + ", `yCord` = " + Client.Y + ", `Map` = " + (int)Client.Map + ", `CPoints` = " + Client.CPs + ", `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 + ", `Spouse` = '" + Client.Spouse + "' WHERE `CharID` = " + Client.ID, DatabaseConnection.Connection);

                Cmd.ExecuteNonQuery();
            }

12tails · 09/23/2009, 02:11

yes yes.... there is the problem ( for who have this )

Code:

"' WHERE `CharID` = " + Client.ID

somethimes it try to save for example an ID 1100001 with 1100001'

them it give error and get the GameServer down....

ImFlamedCOD · 09/23/2009, 02:33

Then just do Client.ID++ then it will add 1 to he xD. I think its like 5 am and I'm a little tired

12tails · 09/23/2009, 03:08

haha.... that will just increase the char id...... but help too : D

Basser · 09/23/2009, 17:23

This isn't a release in my opinion.

12tails · 09/23/2009, 22:13

Quote:

Originally Posted by Smythe94

This isn't a release in my opinion.

Yes of course..... but for some ppl it is...