Transporto krovimas [MySQL]

['Eko]

Sveiki, problemą turiu, kad nesukūria tr.priemonės žaidime.

 

Kodas:

 

OnPlayerConnect:

GetPlayerName(playerid,VehicleInfo[playerid][Savininkas],24);
VehicleInfo[playerid][CAR_ID] = orm_create("transportas",DbHandle);
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][ID],"ID");
orm_addvar_string(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][Savininkas],24,"Savininkas");
orm_addvar_string(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][Plate],129,"Plate");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][Model],"Model");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][Price],"Price");
orm_addvar_float(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][Degalai],"Degalai");
orm_addvar_float(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][CarX],"CarX");
orm_addvar_float(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][CarY],"CarY");
orm_addvar_float(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][CarZ],"CarZ");
orm_addvar_float(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][CarRot],"CarRot");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][Locked],"Locked");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod1],"mod1");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod2],"mod2");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod3],"mod3");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod4],"mod4");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod5],"mod5");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod6],"mod6");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod7],"mod7");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod8],"mod8");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod9],"mod9");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod10],"mod10");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod11],"mod11");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod12],"mod12");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod13],"mod13");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod14],"mod14");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod15],"mod15");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod16],"mod16");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][mod17],"mod17");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][paintjob],"paintjob");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][colora],"colora");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][colorb],"colorb");
orm_addvar_float(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][HP],"HP");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][cPanels],"cPanels");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][cDoors],"cDoors");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][cLights],"cLights");
orm_addvar_int(VehicleInfo[playerid][CAR_ID],VehicleInfo[playerid][cTires],"cTires");
orm_setkey(VehicleInfo[playerid][CAR_ID], "Savininkas");
// orm_select(VehicleInfo[playerid][CAR_ID], "", "d", playerid);
orm_load(VehicleInfo[playerid][CAR_ID],"","d",playerid);

 

Kūrimui:

if(pInfo[playerid][Transportas] == 1)
{
   new name[MAX_PLAYER_NAME];
   GetPlayerName(playerid,name,sizeof(name));
   mysql_tquery(DbHandle,"SELECT * FROM `transportas` WHERE `Savininkas` = '%s'","","d",name);
   orm_load(VehicleInfo[playerid][CAR_ID],"","d",playerid);
Vehicle[playerid] = CreateVehicle(VehicleInfo[playerid][Model], VehicleInfo[playerid][CarX], VehicleInfo[playerid][CarY], VehicleInfo[playerid][CarZ], VehicleInfo[playerid][CarRot], -1, -1, 3600000);
     if(VehicleInfo[playerid][mod1]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod1]); }
if(VehicleInfo[playerid][mod2]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod2]); }
if(VehicleInfo[playerid][mod3]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod3]); }
if(VehicleInfo[playerid][mod4]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod4]); }
if(VehicleInfo[playerid][mod5]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod5]); }
if(VehicleInfo[playerid][mod6]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod6]); }
if(VehicleInfo[playerid][mod7]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod7]); }
if(VehicleInfo[playerid][mod8]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod8]); }
if(VehicleInfo[playerid][mod9]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod9]); }
if(VehicleInfo[playerid][mod10]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod10]); }
if(VehicleInfo[playerid][mod11]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod11]); }
if(VehicleInfo[playerid][mod12]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod12]); }
if(VehicleInfo[playerid][mod13]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod13]); }
if(VehicleInfo[playerid][mod14]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod14]); }
if(VehicleInfo[playerid][mod15]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod15]); }
if(VehicleInfo[playerid][mod16]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod16]); }
if(VehicleInfo[playerid][mod17]!=0) { AddVehicleComponent(Vehicle[playerid],VehicleInfo[playerid][mod17]); }
if(VehicleInfo[playerid][colora]!=0 || VehicleInfo[playerid][colorb]!=0)
{
ChangeVehicleColor(Vehicle[playerid],VehicleInfo[playerid][colora],VehicleInfo[playerid][colorb]);
}
if(VehicleInfo[playerid][paintjob]!=0)
{
   ChangeVehiclePaintjob(Vehicle[playerid],VehicleInfo[playerid][paintjob]);
   }
// new tmp[256]; tmp = ;
VehOwned[Vehicle[playerid]] = 1;
OwnerID[Vehicle[playerid]] = playerid;
SetVehicleParamsForPlayer(Vehicle[playerid], playerid, 0, VehicleInfo[playerid][Locked]);
gVehLocked[Vehicle[playerid]] = VehicleInfo[playerid][Locked];
SetVehicleNumberPlate(Vehicle[playerid], VehicleInfo[playerid][Plate]);
// VehPlate[Vehicle[playerid]] = VehicleInfo[playerid][Plate];
SetVehicleHealth(Vehicle[playerid],VehicleInfo[playerid][HP]);
UpdateVehicleDamageStatus(Vehicle[playerid], VehicleInfo[playerid][cPanels], VehicleInfo[playerid][cDoors], VehicleInfo[playerid][cLights], VehicleInfo[playerid][cTires]);
}