Dynamisches Fahrzeug system von dini auf mysql umschreiben

Erstellen speichern alles funktioniert nur beim laden hat er Probleme ich schreibe euch kurz wie ich das im Script vermerkt habe.

Benutze MySQL R41-4

public OnGameModeInit()
{

for(new l=0;l<MAX_CARS;l++)
{
new query[2000];
mysql_format(handle, query, sizeof(query), "SELECT * FROM fracvehicles WHERE ID = '%e'", l);
mysql_pquery(handle, query, "LFC", "d", l);

//LFC(l);
}

stock LFC(autoid)
{
new rows;
cache_get_row_count(rows);
cache_get_value_name_int(0, "ID", autoid);
cache_get_value_name_int(0, "Model", FCInfo[autoid][carvehid]);
cache_get_value_name_float(0, "X", FCInfo[autoid][fcx]);
cache_get_value_name_float(0, "Y", FCInfo[autoid][fcy]);
cache_get_value_name_float(0, "Z", FCInfo[autoid][fcz]);
cache_get_value_name_float(0, "A", FCInfo[autoid][fca]);
cache_get_value_name_int(0, "Fraktion", FCInfo[autoid][Frakid]);
cache_get_value_name_int(0, "Farbe1", FCInfo[autoid][fcc1]);
cache_get_value_name_int(0, "Farbe2", FCInfo[autoid][fcc2]);

cache_get_value_name_int(0, "Opark", FCInfo[autoid][Opark]);
cache_get_value_name_int(0, "Paintjob", FCInfo[autoid][Paintjob]);

cache_get_value_name_int(0, "spoiler", FCInfo[autoid][spoiler]);
cache_get_value_name_int(0, "Wheels", FCInfo[autoid][Wheels]);
cache_get_value_name_int(0, "Nitro", FCInfo[autoid][Nitro]);

cache_get_value_name_int(0, "Roof", FCInfo[autoid][Roof]);
cache_get_value_name_int(0, "Hood", FCInfo[autoid][Hood]);
cache_get_value_name_int(0, "Sideskirt", FCInfo[autoid][Sideskirt]);
cache_get_value_name_int(0, "Lamps", FCInfo[autoid][Lamps]);
cache_get_value_name_int(0, "Exhaust", FCInfo[autoid][Exhaust]);

cache_get_value_name_int(0, "Stereo", FCInfo[autoid][Stereo]);
cache_get_value_name_int(0, "Hydraulics", FCInfo[autoid][Hydraulics]);
cache_get_value_name_int(0, "VentRight", FCInfo[autoid][VentRight]);

cache_get_value_name_int(0, "VentLeft", FCInfo[autoid][VentLeft]);
cache_get_value_name_int(0, "FrontBumper", FCInfo[autoid][FrontBumper]);
cache_get_value_name_int(0, "RearBumper", FCInfo[autoid][RearBumper]);
FCInfo[autoid][open] = 1;
Frakcar[autoid] = CreateVehicle(FCInfo[autoid][carvehid],FCInfo[autoid][fcx],FCInfo[autoid][fcy],FCInfo[autoid][fcz],FCInfo[autoid][fca],FCInfo[autoid][fcc1],FCInfo[autoid][fcc2],-1);
//ab hier errors
if(FCInfo[autoid][Paintjob] >= 0) //zeile 49702
{
ChangeVehiclePaintjob(FCInfo[autoid],FCInfo[autoid][Paintjob]);
}
if(FCInfo[autoid][spoiler] >= 999){ AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][spoiler]); }
if(FCInfo[autoid][Hood] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Hood]); }
if(FCInfo[autoid][Roof] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Roof]); }
if(FCInfo[autoid][Sideskirt] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Sideskirt]); }
if(FCInfo[autoid][Lamps] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Lamps]); }
if(FCInfo[autoid][Nitro] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Nitro]); }
if(FCInfo[autoid][Exhaust] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Exhaust]); }
if(FCInfo[autoid][Wheels] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Wheels]); }
if(FCInfo[autoid][Stereo] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Stereo]); }
if(FCInfo[autoid][Hydraulics] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Hydraulics]); }
if(FCInfo[autoid][FrontBumper] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][FrontBumper]); }
if(FCInfo[autoid][RearBumper] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][RearBumper]); }
if(FCInfo[autoid][VentRight] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][VentRight]); }
if(FCInfo[autoid][VentLeft] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][VentLeft]); }
if(FCInfo[autoid][Frakid] == 1) {SetVehicleNumberPlate(Frakcar[autoid], "LSPD"); }
if(FCInfo[autoid][Frakid] == 2) {SetVehicleNumberPlate(Frakcar[autoid], "FBI"); }
if(FCInfo[autoid][Frakid] == 3) {SetVehicleNumberPlate(Frakcar[autoid], "Medic"); }
if(FCInfo[autoid][Frakid] == 4) {SetVehicleNumberPlate(Frakcar[autoid], "Unknown"); }
if(FCInfo[autoid][Frakid] == 5) {SetVehicleNumberPlate(Frakcar[autoid], "News"); }
if(FCInfo[autoid][Frakid] == 6) {SetVehicleNumberPlate(Frakcar[autoid], "Penner"); }
if(FCInfo[autoid][Frakid] == 7) {SetVehicleNumberPlate(Frakcar[autoid], "Oamt"); }
if(FCInfo[autoid][Frakid] == 8) {SetVehicleNumberPlate(Frakcar[autoid], "Russen"); }
if(FCInfo[autoid][Frakid] == 9) {SetVehicleNumberPlate(Frakcar[autoid], "Yakuza"); }
if(FCInfo[autoid][Frakid] == 10) {SetVehicleNumberPlate(Frakcar[autoid], "Ballas"); }
if(FCInfo[autoid][Frakid] == 11) {SetVehicleNumberPlate(Frakcar[autoid], "Grove"); }
if(FCInfo[autoid][Frakid] == 12) {SetVehicleNumberPlate(Frakcar[autoid], "LCM"); }
if(FCInfo[autoid][Frakid] == 13) {SetVehicleNumberPlate(Frakcar[autoid], "Feuerwehr"); }
if(FCInfo[autoid][Frakid] == 14) {SetVehicleNumberPlate(Frakcar[autoid], "Army"); }
if(FCInfo[autoid][Frakid] == 15) {SetVehicleNumberPlate(Frakcar[autoid], "SWAT"); }
if(FCInfo[autoid][Frakid] == 16) {SetVehicleNumberPlate(Frakcar[autoid], "Biker"); }
if(FCInfo[autoid][Frakid] == 17) {SetVehicleNumberPlate(Frakcar[autoid], "Aztecas"); }
if(FCInfo[autoid][Frakid] == 18) {SetVehicleNumberPlate(Frakcar[autoid], "Vagos"); }
if(FCInfo[autoid][Frakid] == 19) {SetVehicleNumberPlate(Frakcar[autoid], "WestCoast"); }
if(FCInfo[autoid][Frakid] == 20) {SetVehicleNumberPlate(Frakcar[autoid], "2F2F"); }
if(FCInfo[autoid][Frakid] == 21) {SetVehicleNumberPlate(Frakcar[autoid], "Al quaida"); }
return 1;
}

Wenn mir jemand helfen könnte wäre mega nett danke

Mit Freundlichen Grüßen

Steven

Meinst du die schleife mit den maxcars enfernen ich bin recht neu in mysql?

Nach dem einloggen crasht das game ich zeig euch mal alles wie von fraktions system ausfgebaut ist.

enum fcinfo
{
v_t_ID,
carvehid,
Float:fcx,
Float:fcy,
Float:fcz,
Float:fca,
fcc1,
fcc2,
Frakid,
open,
Opark,
Paintjob,
spoiler,
Wheels,
Nitro,
Roof,
Hood,
Sideskirt,
Lamps,
Exhaust,
Stereo,
Hydraulics,
VentRight,
VentLeft,
FrontBumper,
RearBumper,
}
new FCInfo[MAX_CARS][fcinfo];
new Frakcar[MAX_CARS];

mysql_pquery(handle, "SELECT * FROM `fracvehicles`;", "LFC", "");

stock CFC(model,Float:fx,Float:fy,Float:fz,Float:fa,farbe1,farbe2,frak) //erstelle fraktions autos
{
//new SDatei[64];
//new m = model;
for(new carid=1;carid<MAX_CARS;carid++)
{
new query[256];
mysql_format(handle, query, sizeof(query), "INSERT INTO fracvehicles (ID, Model, X, Y, Z, A, Farbe1, Farbe2, Fraktion) VALUES ('%d','%d','%f','%f','%f','%d','%d','%d','%d')",carid,model,fx,fy,fz,fa,farbe1,farbe2,frak);

//Das Query wird abgesendet und die playerid an OnUserRegister übergeben
mysql_pquery(handle, query, "CFC1", "d", carid);
Frakcar[carid] = CreateVehicle(model,fx,fy,fz,fa,farbe1,farbe2,-1);

FCInfo[carid][carvehid] = model;
FCInfo[carid][fcx] = fx;
FCInfo[carid][fcy] = fy;
FCInfo[carid][fcz] = fz;
FCInfo[carid][fca] = fa;
FCInfo[carid][Frakid] = frak;
FCInfo[carid][fcc1] = farbe1;
FCInfo[carid][fcc2] = farbe2;
FCInfo[carid][open] = 0;
FCInfo[carid][Opark] = 0;

/* dini_IntSet(SDatei,"Opark",FCInfo[carid][Opark]);
dini_IntSet(SDatei,"Paintjob",FCInfo[carid][Paintjob]);
dini_IntSet(SDatei,"spoiler",GetVehicleComponentInSlot(Frakcar[carid],0));
dini_IntSet(SDatei,"Hood",GetVehicleComponentInSlot(Frakcar[carid],1));
dini_IntSet(SDatei,"Roof",GetVehicleComponentInSlot(Frakcar[carid],2));
dini_IntSet(SDatei,"Sideskirt",GetVehicleComponentInSlot(Frakcar[carid],3));
dini_IntSet(SDatei,"Lamps",GetVehicleComponentInSlot(Frakcar[carid],4));
dini_IntSet(SDatei,"Nitro",GetVehicleComponentInSlot(Frakcar[carid],5));
dini_IntSet(SDatei,"Exhaust",GetVehicleComponentInSlot(Frakcar[carid],6));
dini_IntSet(SDatei,"Wheels",GetVehicleComponentInSlot(Frakcar[carid],7));
dini_IntSet(SDatei,"Stereo",GetVehicleComponentInSlot(Frakcar[carid],8));
dini_IntSet(SDatei,"Hydraulics",GetVehicleComponentInSlot(Frakcar[carid],9));
dini_IntSet(SDatei,"FrontBumper",GetVehicleComponentInSlot(Frakcar[carid],10));
dini_IntSet(SDatei,"RearBumper",GetVehicleComponentInSlot(Frakcar[carid],11));
dini_IntSet(SDatei,"VentRight",GetVehicleComponentInSlot(Frakcar[carid],12));
dini_IntSet(SDatei,"VentLeft",GetVehicleComponentInSlot(Frakcar[carid],13));*/
return 1;
}
return 1;
}

public LFC() //lade fraktions autos
{
new rows;
cache_get_row_count(rows);
for(new autoid; autoid < rows; autoid++) {
cache_get_value_name_int(autoid, "ID",FCInfo[autoid][v_t_ID]);
cache_get_value_name_int(autoid, "Model", FCInfo[autoid][carvehid]/*das dürfte auch nicht ganz stimmen, oder?*/);
cache_get_value_name_float(autoid, "X", FCInfo[autoid][fcx]);
cache_get_value_name_float(autoid, "Y", FCInfo[autoid][fcy]);
cache_get_value_name_float(autoid, "Z", FCInfo[autoid][fcz]);
cache_get_value_name_float(autoid, "A", FCInfo[autoid][fca]);
cache_get_value_name_int(autoid, "Fraktion", FCInfo[autoid][Frakid]);
cache_get_value_name_int(autoid, "Farbe1", FCInfo[autoid][fcc1]);
cache_get_value_name_int(autoid, "Farbe2", FCInfo[autoid][fcc2]);
cache_get_value_name_int(autoid, "Opark", FCInfo[autoid][Opark]);
cache_get_value_name_int(autoid, "Paintjob", FCInfo[autoid][Paintjob]);
cache_get_value_name_int(autoid, "spoiler", FCInfo[autoid][spoiler]);
cache_get_value_name_int(autoid, "Wheels", FCInfo[autoid][Wheels]);
cache_get_value_name_int(autoid, "Nitro", FCInfo[autoid][Nitro]);
cache_get_value_name_int(autoid, "Roof", FCInfo[autoid][Roof]);
cache_get_value_name_int(autoid, "Hood", FCInfo[autoid][Hood]);
cache_get_value_name_int(autoid, "Sideskirt", FCInfo[autoid][Sideskirt]);
cache_get_value_name_int(autoid, "Lamps", FCInfo[autoid][Lamps]);
cache_get_value_name_int(autoid, "Exhaust", FCInfo[autoid][Exhaust]);
cache_get_value_name_int(autoid, "Stereo", FCInfo[autoid][Stereo]);
cache_get_value_name_int(autoid, "Hydraulics", FCInfo[autoid][Hydraulics]);
cache_get_value_name_int(autoid, "VentRight", FCInfo[autoid][VentRight]);
cache_get_value_name_int(autoid, "VentLeft", FCInfo[autoid][VentLeft]);
cache_get_value_name_int(autoid, "FrontBumper", FCInfo[autoid][FrontBumper]);
cache_get_value_name_int(autoid, "RearBumper", FCInfo[autoid][RearBumper]);
FCInfo[autoid][open] = 1;
Frakcar[autoid] = CreateVehicle(FCInfo[autoid][carvehid],FCInfo[autoid][fcx],FCInfo[autoid][fcy],FCInfo[autoid][fcz],FCInfo[autoid][fca],FCInfo[autoid][fcc1],FCInfo[autoid][fcc2],-1);
//ab hier errors
if(FCInfo[autoid][Paintjob] >= 0) //zeile 49702
{
ChangeVehiclePaintjob(FCInfo[autoid][v_t_ID],FCInfo[autoid][Paintjob]);
}
if(FCInfo[autoid][spoiler] >= 999){ AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][spoiler]); }
if(FCInfo[autoid][Hood] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Hood]); }
if(FCInfo[autoid][Roof] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Roof]); }
if(FCInfo[autoid][Sideskirt] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Sideskirt]); }
if(FCInfo[autoid][Lamps] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Lamps]); }
if(FCInfo[autoid][Nitro] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Nitro]); }
if(FCInfo[autoid][Exhaust] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Exhaust]); }
if(FCInfo[autoid][Wheels] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Wheels]); }
if(FCInfo[autoid][Stereo] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Stereo]); }
if(FCInfo[autoid][Hydraulics] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][Hydraulics]); }
if(FCInfo[autoid][FrontBumper] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][FrontBumper]); }
if(FCInfo[autoid][RearBumper] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][RearBumper]); }
if(FCInfo[autoid][VentRight] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][VentRight]); }
if(FCInfo[autoid][VentLeft] >= 999) { AddVehicleComponent(Frakcar[autoid],FCInfo[autoid][VentLeft]); }
if(FCInfo[autoid][Frakid] == 1) {SetVehicleNumberPlate(Frakcar[autoid], "LSPD"); }
if(FCInfo[autoid][Frakid] == 2) {SetVehicleNumberPlate(Frakcar[autoid], "FBI"); }
if(FCInfo[autoid][Frakid] == 3) {SetVehicleNumberPlate(Frakcar[autoid], "Medic"); }
if(FCInfo[autoid][Frakid] == 4) {SetVehicleNumberPlate(Frakcar[autoid], "Unknown"); }
if(FCInfo[autoid][Frakid] == 5) {SetVehicleNumberPlate(Frakcar[autoid], "News"); }
if(FCInfo[autoid][Frakid] == 6) {SetVehicleNumberPlate(Frakcar[autoid], "Penner"); }
if(FCInfo[autoid][Frakid] == 7) {SetVehicleNumberPlate(Frakcar[autoid], "Oamt"); }
if(FCInfo[autoid][Frakid] == 8) {SetVehicleNumberPlate(Frakcar[autoid], "Russen"); }
if(FCInfo[autoid][Frakid] == 9) {SetVehicleNumberPlate(Frakcar[autoid], "Yakuza"); }
if(FCInfo[autoid][Frakid] == 10) {SetVehicleNumberPlate(Frakcar[autoid], "Ballas"); }
if(FCInfo[autoid][Frakid] == 11) {SetVehicleNumberPlate(Frakcar[autoid], "Grove"); }
if(FCInfo[autoid][Frakid] == 12) {SetVehicleNumberPlate(Frakcar[autoid], "LCM"); }
if(FCInfo[autoid][Frakid] == 13) {SetVehicleNumberPlate(Frakcar[autoid], "Feuerwehr"); }
if(FCInfo[autoid][Frakid] == 14) {SetVehicleNumberPlate(Frakcar[autoid], "Army"); }
if(FCInfo[autoid][Frakid] == 15) {SetVehicleNumberPlate(Frakcar[autoid], "SWAT"); }
if(FCInfo[autoid][Frakid] == 16) {SetVehicleNumberPlate(Frakcar[autoid], "Biker"); }
if(FCInfo[autoid][Frakid] == 17) {SetVehicleNumberPlate(Frakcar[autoid], "Aztecas"); }
if(FCInfo[autoid][Frakid] == 18) {SetVehicleNumberPlate(Frakcar[autoid], "Vagos"); }
if(FCInfo[autoid][Frakid] == 19) {SetVehicleNumberPlate(Frakcar[autoid], "WestCoast"); }
if(FCInfo[autoid][Frakid] == 20) {SetVehicleNumberPlate(Frakcar[autoid], "2F2F"); }
if(FCInfo[autoid][Frakid] == 21) {SetVehicleNumberPlate(Frakcar[autoid], "Al quaida"); }
}
return 1;
}