Quote:
Originally Posted by kinshi88
1310-1319 actually, 1320 is a different Npc =P
|
oh yea , my bad
===
i have to say sorry for the thread starter but i ddnt want to make a thread for one small ques,
anyone have exp with mysql , correct that line plz
Code:
MySql.Data.MySqlClient.MySqlCommand Cmd = new MySql.Data.MySqlClient.MySqlCommand("UPDATE `guilds` SET `Wins` = " + TheGuild.Wins + ", `HoldingPole` = " + TheGuild.HoldingPole + ", `Bulletin` = " + TheGuild.GBull + ", `Enemies` = " + AllEnemies + ", `Allies` = " + AllAllies + ", `Fund` = " + TheGuild.GFund + ", `Members` = " + TheGuild.GMems.Count + " WHERE `GuildID` = " + ID, CoEmu_v2_GameServer.Database.DatabaseConnection.NewConnection());
the error i got is
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near Enemies=0,Allies=2,Fund=5000,Members=1, where GuildId=1 Line 1
===
sorry again for the thread starter and if i'm not allowed to ask here just tell me and i'll delete my question and start a thread for it