[Release] Fixing SaveVoid (CoEmu v2)

09/22/2009 23:21 12tails#1
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 !
09/22/2009 23:56 $HaDoW#2
umm never had this problem ! O.o
09/23/2009 00:21 12tails#3
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
09/23/2009 00:27 $HaDoW#4
I don't want to be rude but you could post some more info what file and where to replace it :D Cus not everyone will understand what you mean :D
09/23/2009 00:45 Zion~#5
I think he made it quite clear.
SaveVoid :facepalm:
09/23/2009 00:48 $HaDoW#6
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 ^_^
09/23/2009 01:00 12tails#7
haha good night : D

but yes you're ritght...
09/23/2009 02:00 Zion~#8
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();
            }
09/23/2009 02:11 12tails#9
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....
09/23/2009 02:33 ImFlamedCOD#10
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
09/23/2009 03:08 12tails#11
haha.... that will just increase the char id...... but help too : D
09/23/2009 17:23 Basser#12
This isn't a release in my opinion.
09/23/2009 22:13 12tails#13
Quote:
Originally Posted by Smythe94 View Post
This isn't a release in my opinion.
Yes of course..... but for some ppl it is...