UberDrift
Ученик
Код:
new tele_name[25];
for(new i; i<MAX_TELES; i++)
{
mysql_escape_string(TELES[playerid][i][d_name], tele_name, 25);
format(string, sizeof(string), "%s, `name%d`='%s', `x%d`=%f, `y%d`=%f, `z%d`=%f, `a%d`=%f, `int%d`=%d",
string, i+1,
tele_name, i+1,
TELES[playerid][i][d_x], i+1,
TELES[playerid][i][d_y], i+1,
TELES[playerid][i][d_z], i+1,
TELES[playerid][i][d_a], i+1,
TELES[playerid][i][d_interior]);
}
format(string, sizeof(string), "%s WHERE `name`='%s' LIMIT 1", string, PlayerName(playerid));
mysql_tquery(connection, string, "", "");
if(PlayerInfo[playerid][pVehModel2] != 0)
{
format(string, sizeof(string), "UPDATE `accounts` SET `comp1_2`=%d,`comp2_2`=%d,`comp3_2`=%d,`comp4_2`=%d,`comp5_2`=%d,`comp6_2`=%d,`comp7_2`=%d,`comp8_2`=%d,`comp9_2`=%d,",
PlayerInfo[playerid][pV2Comp1],
PlayerInfo[playerid][pV2Comp2],
PlayerInfo[playerid][pV2Comp3],
PlayerInfo[playerid][pV2Comp4],
PlayerInfo[playerid][pV2Comp5],
PlayerInfo[playerid][pV2Comp6],
PlayerInfo[playerid][pV2Comp7],
PlayerInfo[playerid][pV2Comp8],
PlayerInfo[playerid][pV2Comp9]);
format(string, sizeof(string), "%s `comp10_2`=%d,`comp11_2`=%d,`comp12_2`=%d,`comp13_2`=%d,`comp14_2`=%d,`comp15_2`=%d,`comp16_2`=%d,",string,
PlayerInfo[playerid][pV2Comp10],
PlayerInfo[playerid][pV2Comp11],
PlayerInfo[playerid][pV2Comp12],
PlayerInfo[playerid][pV2Comp13],
PlayerInfo[playerid][pV2Comp14],
PlayerInfo[playerid][pV2Comp15],
PlayerInfo[playerid][pV2Comp16]);
format(string, sizeof(string), "%s `comp17_2`=%d,`comp18_2`=%d,`color1_2`=%d,`color2_2`=%d,`pjob2`=%d,",string,
PlayerInfo[playerid][pV2Comp17],
PlayerInfo[playerid][pV2Comp18],
PlayerInfo[playerid][pV2Col1],
PlayerInfo[playerid][pV2Col2],
PlayerInfo[playerid][pV2Pjob]);
format(string, sizeof(string), "%s `vfuel_2`=%d,`v_fuel2_100`=%d, `v_motor2`=%d, `motoronoff2`=%d, `snego2`=%d, `snego2ofno`=%d WHERE `name`='%s' LIMIT 1",string,
PlayerInfo[playerid][vFuel2],
PlayerInfo[playerid][v_fuel2_100],
PlayerInfo[playerid][v_motor2],
PlayerInfo[playerid][motoronoff2],
PlayerInfo[playerid][snego2],
PlayerInfo[playerid][snego2ofno],
PlayerName(playerid));
mysql_tquery(connection, string, "", "");
}
if(PlayerInfo[playerid][pVehModel3] != 0)
{
format(string, sizeof(string), "UPDATE `accounts` SET `comp1_3`=%d,`comp2_3`=%d,`comp3_3`=%d,`comp4_3`=%d,`comp5_3`=%d,`comp6_3`=%d,`comp7_3`=%d,`comp8_3`=%d,`comp9_3`=%d,",
PlayerInfo[playerid][pV3Comp1],
PlayerInfo[playerid][pV3Comp2],
PlayerInfo[playerid][pV3Comp3],
PlayerInfo[playerid][pV3Comp4],
PlayerInfo[playerid][pV3Comp5],
PlayerInfo[playerid][pV3Comp6],
PlayerInfo[playerid][pV3Comp7],
PlayerInfo[playerid][pV3Comp8],
PlayerInfo[playerid][pV3Comp9]);
format(string, sizeof(string), "%s `comp10_3`=%d,`comp11_3`=%d,`comp12_3`=%d,`comp13_3`=%d,`comp14_3`=%d,`comp15_3`=%d,`comp16_3`=%d,",string,
PlayerInfo[playerid][pV3Comp10],
PlayerInfo[playerid][pV3Comp11],
PlayerInfo[playerid][pV3Comp12],
PlayerInfo[playerid][pV3Comp13],
PlayerInfo[playerid][pV3Comp14],
PlayerInfo[playerid][pV3Comp15],
PlayerInfo[playerid][pV3Comp16]);
format(string, sizeof(string), "%s `comp17_3`=%d,`comp18_3`=%d,`color1_3`=%d,`color2_3`=%d,`pjob3`=%d,",string,
PlayerInfo[playerid][pV3Comp17],
PlayerInfo[playerid][pV3Comp18],
PlayerInfo[playerid][pV3Col1],
PlayerInfo[playerid][pV3Col2],
PlayerInfo[playerid][pV3Pjob]);
format(string, sizeof(string), "%s `vfuel_3`=%d,`v_fuel3_100`=%d, `v_motor3`=%d, `motoronoff3`=%d, `snego3`=%d, `snego3ofno`=%d WHERE `name`='%s' LIMIT 1",string,
PlayerInfo[playerid][vFuel3],
PlayerInfo[playerid][v_fuel3_100],
PlayerInfo[playerid][v_motor3],
PlayerInfo[playerid][motoronoff3],
PlayerInfo[playerid][snego3],
PlayerInfo[playerid][snego3ofno],
PlayerName(playerid));
mysql_tquery(connection, string, "", "");
}
if(PlayerInfo[playerid][pVehModel4] != 0)
{
format(string, sizeof(string), "UPDATE `accounts` SET `comp1_4`=%d,`comp2_4`=%d,`comp3_4`=%d,`comp4_4`=%d,`comp5_4`=%d,`comp6_4`=%d,`comp7_4`=%d,`comp8_4`=%d,`comp9_4`=%d,",
PlayerInfo[playerid][pV4Comp1],
PlayerInfo[playerid][pV4Comp2],
PlayerInfo[playerid][pV4Comp3],
PlayerInfo[playerid][pV4Comp4],
PlayerInfo[playerid][pV4Comp5],
PlayerInfo[playerid][pV4Comp6],
PlayerInfo[playerid][pV4Comp7],
PlayerInfo[playerid][pV4Comp8],
PlayerInfo[playerid][pV4Comp9]);
format(string, sizeof(string), "%s `comp10_4`=%d,`comp11_4`=%d,`comp12_4`=%d,`comp13_4`=%d,`comp14_4`=%d,`comp15_4`=%d,`comp16_4`=%d,",string,
PlayerInfo[playerid][pV4Comp10],
PlayerInfo[playerid][pV4Comp11],
PlayerInfo[playerid][pV4Comp12],
PlayerInfo[playerid][pV4Comp13],
PlayerInfo[playerid][pV4Comp14],
PlayerInfo[playerid][pV4Comp15],
PlayerInfo[playerid][pV4Comp16]);
format(string, sizeof(string), "%s `comp17_4`=%d,`comp18_4`=%d,`color1_4`=%d,`color2_4`=%d,`pjob4`=%d,",string,
PlayerInfo[playerid][pV4Comp17],
PlayerInfo[playerid][pV4Comp18],
PlayerInfo[playerid][pV4Col1],
PlayerInfo[playerid][pV4Col2],
PlayerInfo[playerid][pV4Pjob]);
format(string, sizeof(string), "%s `vfuel_4`=%d,`v_fuel4_100`=%d, `v_motor4`=%d, `motoronoff4`=%d, `snego4`=%d, `snego4ofno`=%d WHERE `name`='%s' LIMIT 1",string,
PlayerInfo[playerid][vFuel4],
PlayerInfo[playerid][v_fuel4_100],
PlayerInfo[playerid][v_motor4],
PlayerInfo[playerid][motoronoff4],
PlayerInfo[playerid][snego4],
PlayerInfo[playerid][snego4ofno],
PlayerName(playerid));
mysql_tquery(connection, string, "", "");
}Логи:
Код:
[23/10/2020 | 13:49:12] [ErrorID: 1064]
[Error: 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 ' `name1`='', `x1`=0.000000, `y1`=0.000000, `z1`=0.000000, `a1`=0.000000, `int1`=' at line 1]
[Query: UPDATE `accounts` SET `comp1`=0,`comp2`=0,`comp3`=0,`comp4`=0,`comp5`=0,`comp6`=0,`comp7`=0,`comp8`=0,`comp9`=0, `comp10`=0,`comp11`=0,`comp12`=0,`comp13`=0,`comp14`=0,`comp15`=0,`comp16`=0, `comp17`=0,`comp18`=0,`color1`=0,`color2`=0,`pjob`=0, `vfuel_1`=0,`v_fuel1_100`=0, `v_motor1`=0, `motoronoff1`=0, `snego1`=0, `snego1ofno`=0 WHERE `name`='Muvik' LIMIT 1, `name1`='', `x1`=0.000000, `y1`=0.000000, `z1`=0.000000, `a1`=0.000000, `int1`=0, `name2`='', `x2`=0.000000, `y2`=0.000000, `z2`=0.000000, `a2`=0.000000, `int2`=0, `name3`='', `x3`=0.000000, `y3`=0.000000, `z3`=0.000000, `a3`=0.000000, `int3`=0, `name4`='', `x4`=0.000000, `y4`=0.000000, `z4`=0.000000, `a4`=0.000000, `int4`=0, `name5`='', `x5`=0.000000, `y5`=0.000000, `z5`=0.000000, `a5`=0.000000, `int5`=0, `name6`='', `x6`=0.000000, `y6`=0.000000, `z6`=0.000000, `a6`=0.000000, `int6`=0, `name7`='', `x7`=0.000000, `y7`=0.000000, `z7`=0.000000, `a7`=0.000000, `int7`=0, `