CombeL
Wiek: 29 Na forum: 3747 dni Posty: 6
Nick w MP: CombeL
Witam. Mam taki problem. Nie wczytuje mi z bazy mysql kolumny Opony i Oponyp. Wie kto? co mo?e by? nie tak? Kod wczytywania:
Kod:
stock LoadVehicles() // You might want to make this an public so you could call it on an timer.
{
new Query[800], id,i=0;
format(Query, sizeof(Query), "SELECT `id`,`owner`,`model`,`price`,`x`,`y`,`z`,`a`,`sell`,`team`,`color1`,`color2`,`Paliwo`,`Przebieg`,`Ubezpieczenie1`,`Przeglad1`,`Plomba`,`PlombaNick`,`Oponyp`,`Opony` FROM `vehicles`");
mysql_query(Query);
mysql_store_result();
new num = mysql_num_rows();
while(mysql_fetch_row(Query,"|"))
{
if(num != 0)
{
LoadedInfo[Vehicles]++;
id = LoadedInfo[Vehicles];
new idcheck;
sscanf(Query, "p<|>ds[25]ddffffdddddfddfd",idcheck,VehicleInfo[id][Owner],VehicleInfo[id][Model],VehicleInfo[id][Price],VehicleInfo[id][Pos][xa],VehicleInfo[id][Pos][ya],VehicleInfo[id][Pos][za],VehicleInfo[id][Pos][aa],VehicleInfo[id][sell],VehicleInfo[id][TeamCar],VehicleInfo[id][Color1],VehicleInfo[id][Color2],VehicleInfo[id][Paliwo],VehicleInfo[id][Przebieg],VehicleInfo[id][Ubezpieczenie1],VehicleInfo[id][Przeglad1],VehicleInfo[id][Oponyp],VehicleInfo[id][Opony]);
new Co1 = VehicleInfo[id][Color1];
new Co2 = VehicleInfo[id][Color2];
new idcreate;
idcreate = AddStaticVehicleEx(VehicleInfo[id][Model],VehicleInfo[id][Pos][xa],VehicleInfo[id][Pos][ya],VehicleInfo[id][Pos][za],VehicleInfo[id][Pos][aa],Co1,Co2, 60*10000);
VehicleInfo[idcreate][UID] = idcheck;
//format(Query, sizeof(Query), "SELECT `id` FROM `vehicles` WHERE id='%d'",idcheck);
//mysql_query(Query);
//mysql_store_result();
//mysql_fetch_row(Query,"|");
//sscanf(Query, "p<|>d",VehicleInfo[idcreate][UID]);
//mysql_free_result();
if(strcmp(VehicleInfo[id][Owner],"Brak",false))
{
SetVehicleNumberPlate(idcreate, VehicleInfo[id][Owner]);
}
else if(!strcmp(VehicleInfo[id][Owner],"Brak",false) && VehicleInfo[id][TeamCar] == 0)
{
SetVehicleNumberPlate(idcreate, "Publiczny");
}
}
i++;
}
mysql_free_result();
//TU ZMIENI?EM najlepiej w ten spos?b ....
VehicleInfo[id + 1][Ubezpieczenie1] = -1;
return printf("[AUTOMAT] Wczytano %d pojazdow!!!",i);
}
Prosz? o szybk? pomoc.