15.11.2010, 23:16
pawn Код:
public SaveAchievements()
{
foreach(Player,i)
{
if(IsLogged[i] == 1)
{
new Escape[1][MAX_PLAYER_NAME];
mysql_real_escape_string(Playername(i), Escape[0]);
format(GlobalQuery1,sizeof(GlobalQuery1),"UPDATE `Accounts` SET `Ach0`=%d,`Ach1=%d`,`Ach2`=%d,`Ach3`=%d,`Ach4`=%d,`Ach5`=%d,`Ach6`=%d,`Ach7`=%d,`Ach8`=%d WHERE Username='%s'",
PlayerInfo[i][pAchievement][0],PlayerInfo[i][pAchievement][1],PlayerInfo[i][pAchievement][2],
PlayerInfo[i][pAchievement][3],PlayerInfo[i][pAchievement][4],PlayerInfo[i][pAchievement][5],
PlayerInfo[i][pAchievement][6],PlayerInfo[i][pAchievement][7],PlayerInfo[i][pAchievement][8],
Escape[0]);
mysql_query(GlobalQuery1);
}
}
return 1;
}
pawn Код:
[16:25:06] [chat] [[MF]Diego_mora]: showre
[16:25:08] [chat] [[MF]Diego_mora]: shower?
[16:25:12] [chat] [[MF]Diego_mora]: lol
[16:25:13] [MySQL] Error (0): Failed to exeute query. 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 '`Ach2`=0,`Ach3`=0,`Ach4`=0,`Ach5`=0,`Ach6`=0,`Ach7`=0,`Ach8`=0 WHERE Username='[' at line 1.
[16:25:13] [MySQL] Error (0): Failed to exeute query. 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 '`Ach2`=0,`Ach3`=0,`Ach4`=0,`Ach5`=0,`Ach6`=0,`Ach7`=0,`Ach8`=0 WHERE Username='B' at line 1.
[16:25:13] [MySQL] Error (0): Failed to exeute query. 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 '`Ach2`=0,`Ach3`=0,`Ach4`=0,`Ach5`=0,`Ach6`=0,`Ach7`=0,`Ach8`=0 WHERE Username='[' at line 1.
[16:25:13] [MySQL] Error (0): Failed to exeute query. 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 '`Ach2`=0,`Ach3`=0,`Ach4`=0,`Ach5`=0,`Ach6`=0,`Ach7`=0,`Ach8`=0 WHERE Username='J' at line 1.
[16:25:13] [MySQL] Error (0): Failed to exeute query. 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 '`Ach2`=0,`Ach3`=0,`Ach4`=0,`Ach5`=0,`Ach6`=0,`Ach7`=0,`Ach8`=0 WHERE Username='K' at line 1.
[16:25:25] [MySQL] Error (0): Failed to exeute query. 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 '`Ach2`=0,`Ach3`=0,`Ach4`=0,`Ach5`=0,`Ach6`=0,`Ach7`=0,`Ach8`=0 WHERE Username='[' at line 1.
[16:25:25] [MySQL] Error (0): Failed to exeute query. 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 '`Ach2`=0,`Ach3`=0,`Ach4`=0,`Ach5`=0,`Ach6`=0,`Ach7`=0,`Ach8`=0 WHERE Username='B' at line 1.
[16:25:25] [MySQL] Error (0): Failed to exeute query. 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 '`Ach2`=0,`Ach3`=0,`Ach4`=0,`Ach5`=0,`Ach6`=0,`Ach7`=0,`Ach8`=0 WHERE Username='[' at line 1.
[16:25:25] [MySQL] Error (0): Failed to exeute query. 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 '`Ach2`=0,`Ach3`=0,`Ach4`=0,`Ach5`=0,`Ach6`=0,`Ach7`=0,`Ach8`=0 WHERE Username='J' at line 1.
[16:25:25] [MySQL] Error (0): Failed to exeute query. 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 '`Ach2`=0,`Ach3`=0,`Ach4`=0,`Ach5`=0,`Ach6`=0,`Ach7`=0,`Ach8`=0 WHERE Username='K' at line 1.