hlmod.hu
https://hlmod.hu/

MySQL Hiba.
https://hlmod.hu/viewtopic.php?f=9&t=23662		 Oldal: 1 / 1
Szerző:  V!RUSHĐ [2016.01.24. 16:53 ]
Hozzászólás témája:  MySQL Hiba.
Valaki javítaná?

Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. public Save(id) {
  2.     new Query[1024];
  3.     new Len;
  4.    
  5.     Len += formatex(Query[Len], charsmax(Query), "INSERT INTO oneshot_pb` ");
  6.     Len += formatex(Query[Len], charsmax(Query)-Len, "(`username`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ");
  7.     Len += formatex(Query[Len], charsmax(Query)-Len, "`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ");
  8.     Len += formatex(Query[Len], charsmax(Query)-Len, "`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, %s`) ");
  9.     Len += formatex(Query[Len], charsmax(Query)-Len, "VALUES (^"%s^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^, ");
  10.     Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ");
  11.     Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ");
  12.     Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^");", TABLENAMES[0], TABLENAMES[1], TABLENAMES[3], TABLENAMES[4], TABLENAMES[5], TABLENAMES[6], TABLENAMES[7], TABLENAMES[8], TABLENAMES[9], TABLENAMES[10], TABLENAMES[11], TABLENAMES[12], TABLENAMES[13], TABLENAMES[14], TABLENAMES[15], TABLENAMES[16], TABLENAMES[17], TABLENAMES[18], TABLENAMES[19], TABLENAMES[20], TABLENAMES[21], TABLENAMES[22], Name[id])");
  13.    
  14.     SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
  15. }
GeSHi © Codebox Plus


Welcome to the AMX Mod X 1.8.1-300 Compiler.
Copyright (c) 1997-2013 ITB CompuPhase, AMX Mod X Team

Error: Invalid character constant on line 1019
Error: Invalid character constant on line 1019
Error: Invalid string (possibly non-terminated string) on line 1022
Warning: Expression has no effect on line 1022
Error: Expected token: ";", but found "-identifier-" on line 1024

4 Errors.
Could not locate output file C:\Documents and Settings\Norbert\Asztal\PaintballMenu.amx (compile failed).
Szerző:  JohanCorn [2016.01.24. 20:04 ]
Hozzászólás témája:  Re: MySQL Hiba.
Szerintem ennyi volt a baj.

Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. public Save(id) {
  2.     new Query[1024];
  3.     new Len;
  4.    
  5.     Len += formatex(Query[Len], charsmax(Query), "INSERT INTO oneshot_pb` ");
  6.     Len += formatex(Query[Len], charsmax(Query)-Len, "(`username`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ");
  7.     Len += formatex(Query[Len], charsmax(Query)-Len, "`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ");
  8.     Len += formatex(Query[Len], charsmax(Query)-Len, "`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, %s`) ");
  9.     Len += formatex(Query[Len], charsmax(Query)-Len, "VALUES (^"%s^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ");
  10.     Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ");
  11.     Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ");
  12.     Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^");", TABLENAMES[0], TABLENAMES[1], TABLENAMES[3], TABLENAMES[4], TABLENAMES[5], TABLENAMES[6], TABLENAMES[7], TABLENAMES[8], TABLENAMES[9], TABLENAMES[10], TABLENAMES[11], TABLENAMES[12], TABLENAMES[13], TABLENAMES[14], TABLENAMES[15], TABLENAMES[16], TABLENAMES[17], TABLENAMES[18], TABLENAMES[19], TABLENAMES[20], TABLENAMES[21], TABLENAMES[22], Name[id])");
  13.  
  14.    SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
  15. }
GeSHi © Codebox Plus
Szerző:  V!RUSHĐ [2016.01.24. 20:18 ]
Hozzászólás témája:  Re: MySQL Hiba.
Most meg ez.

Welcome to the AMX Mod X 1.8.1-300 Compiler.
Copyright (c) 1997-2013 ITB CompuPhase, AMX Mod X Team

Error: Invalid string (possibly non-terminated string) on line 1022
Warning: Expression has no effect on line 1022
Error: Expected token: ";", but found "-identifier-" on line 1024
Warning: Loose indentation on line 1024

2 Errors.
Could not locate output file C:\Documents and Settings\Norbert\Asztal\PaintballMenu.amx (compile failed).
Szerző:  Metal [2016.01.25. 09:19 ]
Hozzászólás témája:  Re: MySQL Hiba.
Ha már magad csinálod, akkor elvárható lenne, hogy az ilyen kis hibákat ki tudd javítani.
Egy felesleges " van a fenti kódban.

Ez elvileg menni fog:
Kód:
public Save(id) {
    new Query[1024];
    new Len;
   
    Len += formatex(Query[Len], charsmax(Query), "INSERT INTO oneshot_pb` ");
    Len += formatex(Query[Len], charsmax(Query)-Len, "(`username`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ");
    Len += formatex(Query[Len], charsmax(Query)-Len, "`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ");
    Len += formatex(Query[Len], charsmax(Query)-Len, "`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, %s`) ");
    Len += formatex(Query[Len], charsmax(Query)-Len, "VALUES (^"%s^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ");
    Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ");
    Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ");
    Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^");", TABLENAMES[0], TABLENAMES[1], TABLENAMES[3], TABLENAMES[4], TABLENAMES[5], TABLENAMES[6], TABLENAMES[7], TABLENAMES[8], TABLENAMES[9], TABLENAMES[10], TABLENAMES[11], TABLENAMES[12], TABLENAMES[13], TABLENAMES[14], TABLENAMES[15], TABLENAMES[16], TABLENAMES[17], TABLENAMES[18], TABLENAMES[19], TABLENAMES[20], TABLENAMES[21], TABLENAMES[22], Name[id]));
 
   SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
Szerző:  V!RUSHĐ [2016.01.25. 13:47 ]
Hozzászólás témája:  Re: MySQL Hiba.
Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^");", TABLENAMES[0], TABLENAMES[1], TABLENAMES[3], TABLENAMES[4], TABLENAMES[5], TABLENAMES[6], TABLENAMES[7], TABLENAMES[8], TABLENAMES[9], TABLENAMES[10], TABLENAMES[11], TABLENAMES[12], TABLENAMES[13], TABLENAMES[14], TABLENAMES[15], TABLENAMES[16], TABLENAMES[17], TABLENAMES[18], TABLENAMES[19], TABLENAMES[20], TABLENAMES[21], TABLENAMES[22], Name[id]));
GeSHi © Codebox Plus

Ez nem volt jó.

Ez jó:
Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"0^");", TABLENAMES[0], TABLENAMES[1], TABLENAMES[3], TABLENAMES[4], TABLENAMES[5], TABLENAMES[6], TABLENAMES[7], TABLENAMES[8], TABLENAMES[9], TABLENAMES[10], TABLENAMES[11], TABLENAMES[12], TABLENAMES[13], TABLENAMES[14], TABLENAMES[15], TABLENAMES[16], TABLENAMES[17], TABLENAMES[18], TABLENAMES[19], TABLENAMES[20], TABLENAMES[21], TABLENAMES[22], Name[id]);
GeSHi © Codebox Plus


Edit:
Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. public Update(id) {
  2.     new Query[1024];
  3.     new Len;
  4.    
  5.     Len += formatex(Query[Len], charsmax(Query)-Len, "UPDATE `oneshot_pb` SET %s = ^"%i^", %s = ^"%i^", ");
  6.     Len += formatex(Query[Len], charsmax(Query)-Len, "%s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ");
  7.     Len += formatex(Query[Len], charsmax(Query)-Len, "%s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ");
  8.     Len += formatex(Query[Len], charsmax(Query)-Len, "%s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ");
  9.     Len += formatex(Query[Len], charsmax(Query)-Len, "%s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ");
  10.     Len += formatex(Query[Len], charsmax(Query)-Len, "%s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ");
  11.     Len += formatex(Query[Len], charsmax(Query)-Len, "%s = ^"%i^" WHERE username = ^"%s^";", TABLENAMES[0], Gold[id], TABLENAMES[1], LvL[id], TABLENAMES[2], ExP[id], TABLENAESM[3], Knifes[1][id], TABLENAMES[4], Knifes[2][id], TABLENAMES[5], Knifes[3][id], TABLENAMES[6], Knifes[4][id], TABLENAMES[7], Knifes[5][id], TABLENAMES[8], Knifes[6][id], TABLENAMES[9], Knifes[7][id], TABLENAMES[10], Knifes[8][id], TABLENAMES[11], Knifes[9][id], TABLENAMES[12], Knifes[10][id], TABLENAMES[13], Knifes[11][id], TABLENAMES[14], Knifes[12][id], TABLENAMES[15], Knifes[13][id], TABLENAMES[16], Knifes[14][id], TABLENAMES[17], Knifes[15][id], TABLENAMES[18], Knifes[16][id], TABLENAMES[19], Knifes[17]id], TABLENAMES[20], Knifes[18][id], TABLENAMES[21], Knifes[19][id], TABLENAMES[22], Knifes[20][id], Name[id]);
  12.    
  13.     SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
  14. }
GeSHi © Codebox Plus

Ezt nagyon el rontottam?Próbálnám fordítani és kifagy a fordító.
Oldal: 1 / 1 Minden időpont UTC+02:00 időzóna szerinti
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/