Farbe wird nicht geändert

reaL. · 17. Juli 2015

Hey ich wollte gerade mein Car system erweitern und jetze wird das Car nicht erstellt ?
[18:05:20] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 'INSERT INTO `autos` (`besitzer`,`model`,`x`,`y`,`z`,`r`,`tank`,`Kennzeichen`) VA' at line 1
[18:05:20] [DEBUG] mysql_tquery - connection: 1, query: "( INSERT INTO `autos` (`besitzer`,`model`,`x`,`y`,`z`,`r`,`tank`", callback: "(null)", format: "(null)"
saveCarToDB(playerid,carid)
{
new query[256];
cInfo[carid][Spoiler] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_SPOILER);
cInfo[carid][Hood] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_HOOD);
cInfo[carid][Roof] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_ROOF);
cInfo[carid][Sideskirt] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_SIDESKIRT);
cInfo[carid][Lamps] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_LAMPS);
cInfo[carid][Nitro] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_NITRO);
cInfo[carid][Exhaust] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_EXHAUST);
cInfo[carid][Wheels] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_WHEELS);
cInfo[carid][Stereo] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_STEREO);
cInfo[carid][Hydraulics] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_HYDRAULICS);
cInfo[carid][Front] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_FRONT_BUMPER);
cInfo[carid][Rear] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_REAR_BUMPER);
cInfo[carid][Ventr] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_VENT_RIGHT);
cInfo[carid][Ventl] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_VENT_LEFT);
format(query,sizeof(query),"INSERT INTO `autos` (`besitzer`,`model`,`x`,`y`,`z`,`r`,`tank`,`Kennzeichen`) VALUES ('%i','%i','%f','%f','%f','%f','%d')",
sInfo[playerid][db_id],cInfo[carid][model],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r],cInfo[carid][pctank],cInfo[carid][ckz]);
format(query,sizeof(query),"( %s,`Spoiler`,`Hood`,`Roof`,`Sideskirt`,`Lamps`,`Nitro`,`Exhaust`,`Wheels`,`Stereo`,`Hydraulics`,`Front`,`Rear`,`Ventr`,`Ventl`) VALUES (,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')",
query,cInfo[carid][Spoiler],cInfo[carid][Hood],cInfo[carid][Roof],cInfo[carid][Sideskirt],cInfo[carid][Lamps],cInfo[carid][Nitro],cInfo[carid][Exhaust],cInfo[carid][Wheels],cInfo[carid][Stereo],cInfo[carid][Hydraulics],cInfo[carid][Front],cInfo[carid][Rear],cInfo[carid][Ventr],cInfo[carid][Ventl]);
mysql_function_query(dbhandle,query,true,"carSavedToDB","i",carid);
return 1;
}

Jeffry · 17. Juli 2015

Das Query muss so aussehen:
format(query,sizeof(query),"INSERT INTO `autos` (`besitzer`,`model`,`x`,`y`,`z`,`r`,`tank`,`Kennzeichen`,`Spoiler`,`Hood`,`Roof`,`Sideskirt`,`Lamps`,`Nitro`,`Exhaust`,`Wheels`,`Stereo`,`Hydraulics`,`Front`,`Rear`,`Ventr`,`Ventl`) VALUES ('%i','%i','%f','%f','%f','%f','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')",

Wenn du es in zwei Zeilen trennen willst:
format(query, sizeof(query), "INSERT INTO `autos` (`besitzer`,`model`,`x`,`y`,`z`,`r`,`tank`,`Kennzeichen`,`Spoiler`,`Hood`,`Roof`,`Sideskirt`,`Lamps`,`Nitro`,`Exhaust`,`Wheels`,`Stereo`,`Hydraulics`,`Front`,`Rear`,`Ventr`,`Ventl`) ");
format(query, sizeof(query), "%sVALUES ('%i','%i','%f','%f','%f','%f','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')", query, /*...*/);

reaL. · 17. Juli 2015

[18:27:36] [ERROR] CMySQLQuery::Execute[carSavedToDB] - (error #1064) 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 ''5.31750' at line 1

saveCarToDB(playerid,carid)
{
new query[256];
cInfo[carid][Spoiler] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_SPOILER);
cInfo[carid][Hood] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_HOOD);
cInfo[carid][Roof] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_ROOF);
cInfo[carid][Sideskirt] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_SIDESKIRT);
cInfo[carid][Lamps] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_LAMPS);
cInfo[carid][Nitro] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_NITRO);
cInfo[carid][Exhaust] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_EXHAUST);
cInfo[carid][Wheels] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_WHEELS);
cInfo[carid][Stereo] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_STEREO);
cInfo[carid][Hydraulics] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_HYDRAULICS);
cInfo[carid][Front] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_FRONT_BUMPER);
cInfo[carid][Rear] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_REAR_BUMPER);
cInfo[carid][Ventr] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_VENT_RIGHT);
cInfo[carid][Ventl] = GetVehicleComponentInSlot(GetPlayerVehicleID(playerid), CARMODTYPE_VENT_LEFT);
format(query, sizeof(query), "INSERT INTO `autos` (`besitzer`,`model`,`x`,`y`,`z`,`r`,`tank`,`Kennzeichen`,`Spoiler`,`Hood`,`Roof`,`Sideskirt`,`Lamps`,`Nitro`,`Exhaust`,`Wheels`,`Stereo`,`Hydraulics`,`Front`,`Rear`,`Ventr`,`Ventl`) ");
format(query, sizeof(query), "%sVALUES ('%i','%i','%f','%f','%f','%f','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')", query,
sInfo[playerid][db_id],cInfo[carid][model],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r],cInfo[carid][pctank],cInfo[carid][ckz],
cInfo[carid][Spoiler],cInfo[carid][Hood],cInfo[carid][Roof],cInfo[carid][Sideskirt],cInfo[carid][Lamps],cInfo[carid][Nitro],cInfo[carid][Exhaust],cInfo[carid][Wheels],cInfo[carid][Stereo],cInfo[carid][Hydraulics],cInfo[carid][Front],cInfo[carid][Rear],cInfo[carid][Ventr],cInfo[carid][Ventl]);
mysql_function_query(dbhandle,query,true,"carSavedToDB","i",carid);
return 1;
}

Jeffry · 17. Juli 2015

new query[256];
zu:
new query[512];

Möglicherweise ist es einfach zu kurz.

reaL. · 17. Juli 2015

wenn ich das Ausklammere dann geht es bis Wird aufgerufen 2
Jeffry:
Kaliber:

savePlayercar(carid)
{
printf("Wird aufgerufen");
new query[1024];
/*cInfo[carid][Spoiler] = GetVehicleComponentInSlot(carid, CARMODTYPE_SPOILER);
cInfo[carid][Hood] = GetVehicleComponentInSlot(carid, CARMODTYPE_HOOD);
cInfo[carid][Roof] = GetVehicleComponentInSlot(carid, CARMODTYPE_ROOF);
cInfo[carid][Sideskirt] = GetVehicleComponentInSlot(carid, CARMODTYPE_SIDESKIRT);
cInfo[carid][Lamps] = GetVehicleComponentInSlot(carid, CARMODTYPE_LAMPS);
cInfo[carid][Nitro] = GetVehicleComponentInSlot(carid, CARMODTYPE_NITRO);
cInfo[carid][Exhaust] = GetVehicleComponentInSlot(carid, CARMODTYPE_EXHAUST);
cInfo[carid][Wheels] = GetVehicleComponentInSlot(carid, CARMODTYPE_WHEELS);
cInfo[carid][Stereo] = GetVehicleComponentInSlot(carid, CARMODTYPE_STEREO);
cInfo[carid][Hydraulics] = GetVehicleComponentInSlot(carid, CARMODTYPE_HYDRAULICS);
cInfo[carid][Front] = GetVehicleComponentInSlot(carid, CARMODTYPE_FRONT_BUMPER);
cInfo[carid][Rear] = GetVehicleComponentInSlot(carid, CARMODTYPE_REAR_BUMPER);
cInfo[carid][Ventr] = GetVehicleComponentInSlot(carid, CARMODTYPE_VENT_RIGHT);
cInfo[carid][Ventl] = GetVehicleComponentInSlot(carid, CARMODTYPE_VENT_LEFT);*/
printf("Wird aufgerufen2");
format(query,sizeof query,"UPDATE autos SET model='%d',x='%f',y='%f',z='%f',r='%f',tank='%d',Kennzeichen='%d',Spoiler='%d',Hood='%d',Roof='%d',Sideskirt='%d',Lamps='%d',Nitro='%d',Exhaust='%d',Wheels='%d',Stereo='%d',",
cInfo[carid][model],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r],cInfo[carid][pctank],cInfo[carid][ckz],cInfo[carid][Spoiler],cInfo[carid][Hood],cInfo[carid][Roof],cInfo[carid][Sideskirt],cInfo[carid][Lamps],cInfo[carid][Nitro],cInfo[carid][Exhaust],cInfo[carid][Wheels],cInfo[carid][Stereo]);
printf("Aufrufen 3");
format(query,sizeof query,"%sHydraulics='%d',Front='%d',Rear='%d',Ventr='%d',Ventl='%d' WHERE id='%d'",query,
cInfo[carid][Hydraulics],cInfo[carid][Front],cInfo[carid][Rear],cInfo[carid][Ventr],cInfo[carid][Ventl],cInfo[carid][db_id]);
printf("Aufrufen 4");
printf(query);
mysql_function_query(dbhandle,query,false,"","");
return 1;
}

Jeffry · 18. Juli 2015

Möglicherweise sprengst du mit der carid das cInfo Array. Lass dir die carid mal mit dem Print ausgeben, und schaue ob die vielleicht größer ist, als das Maximum von cInfo.

reaL. · 18. Juli 2015

wieso wird meine Color nicht gepseichert ?
das wird geprintet

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
for(new i=0; i<sizeof(cInfo); i++)
{
if(cInfo[i][id_x]!=0)continue;
cInfo[vehicleid][Paintjob] = paintjobid;
savePlayercar(i);
}
return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
for(new i=0; i<sizeof(cInfo); i++)
{
if(cInfo[i][id_x]!=0)continue;
cInfo[i][pcolor1] = color1;
cInfo[i][pcolor2] = color2;
printf("%d %d",color1,color2);
savePlayercar(i);
}
return 1;
}

Jeffry · 18. Juli 2015

if(cInfo[i][id_x]!=0)continue;
zu:
if(cInfo[i][id_x]!=vehicleid)continue;

cInfo[vehicleid][Paintjob] = paintjobid;
zu:
cInfo[i][Paintjob] = paintjobid;

Farbe wird nicht geändert

Beitrag von reaL. (17. Juli 2015)

Beitrag von reaL. (17. Juli 2015)

Beitrag von reaL. (18. Juli 2015)

Beitrag von reaL. (18. Juli 2015)

breadfish.de 12. März 2022