problem with sql car spawning. - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (
https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: problem with sql car spawning. (
/showthread.php?tid=187766)
problem with sql car spawning. -
Gabb0411 - 04.11.2010
Hello guys , i want to make a MYSQL Car System and i want to add cars from MySQL without modify any thing in the code.
I have 2 tables : Servervehicles and Personalcars.
The Servervehicles are spawning first and personalcars are spawning second.
The problem is with Personalcars.
Код:
public LoadSQLCars()
{
new car[37][64];
new sql[80];
new row[1024];
format(sql, sizeof(sql), "SELECT COUNT(*) FROM personalcars");
samp_mysql_query(sql);
samp_mysql_store_result();
samp_mysql_fetch_row(row);
totalcars = strval(row);
for(new idx = 500; idx < MAX_CARS; idx++)
{
format(sql,sizeof(sql), "SELECT * FROM personalcars WHERE id=%d", idx);
samp_mysql_query(sql);
samp_mysql_store_result();
if (samp_mysql_num_rows() > 0)
{
samp_mysql_fetch_row(row);
split(row, car, '|');
CarInfo[idx][cSQLID] = strval(car[0]);
CarInfo[idx][cModel] = strval(car[1]);
CarInfo[idx][cLocationx] = floatstr(car[2]);
CarInfo[idx][cLocationy] = floatstr(car[3]);
CarInfo[idx][cLocationz] = floatstr(car[4]);
CarInfo[idx][cAngle] = floatstr(car[5]);
CarInfo[idx][cColorOne] = strval(car[6]);
CarInfo[idx][cColorTwo] = strval(car[7]);
strmid(CarInfo[idx][cOwner], car[8], 0, strlen(car[8]), 255);
strmid(CarInfo[idx][cDescription], car[9], 0, strlen(car[9]), 255);
CarInfo[idx][cValue] = strval(car[10]);
CarInfo[idx][cOwned] = strval(car[11]);
CarInfo[idx][cLock] = strval(car[12]);
CarInfo[idx][cMod1] = strval(car[13]);
CarInfo[idx][cMod2] = strval(car[14]);
CarInfo[idx][cMod3] = strval(car[15]);
CarInfo[idx][cMod4] = strval(car[16]);
CarInfo[idx][cMod5] = strval(car[17]);
CarInfo[idx][cMod6] = strval(car[18]);
CarInfo[idx][cMod7] = strval(car[19]);
CarInfo[idx][cMod8] = strval(car[20]);
CarInfo[idx][cMod9] = strval(car[21]);
CarInfo[idx][cMod10] = strval(car[22]);
CarInfo[idx][cMod11] = strval(car[23]);
CarInfo[idx][cMod12] = strval(car[24]);
CarInfo[idx][cMod13] = strval(car[25]);
CarInfo[idx][cMod14] = strval(car[26]);
CarInfo[idx][cMod15] = strval(car[27]);
CarInfo[idx][cMod16] = strval(car[28]);
CarInfo[idx][cMod17] = strval(car[29]);
CarInfo[idx][cPaintjob] = strval(car[30]);
CarInfo[idx][cInsurer] = strval(car[31]);
CarInfo[idx][cPanels] = strval(car[32]);
CarInfo[idx][cDoors] = strval(car[33]);
CarInfo[idx][cLights] = strval(car[34]);
CarInfo[idx][cTires] = strval(car[35]);
CarInfo[idx][cHealth] = strval(car[36]);
idx++;
idx = AddStaticVehicleEx(strval(car[1]), floatstr(car[2]), floatstr(car[3]), floatstr(car[4]), floatstr(car[5]), strval(car[6]), strval(car[7]), 60000);
}
}
printf("%d cars loaded from database", totalcars);
//samp_mysql_free_result();
return 1;
}
In PersonalCars table from MySQL , i've put the ID's from 500. ( this is the reason why i put for(new idx = 500...)
I open the server and my gamemode is spawning 500 vehicles at same coordinates
( He is spawning 500 times the first car from PersonalCars table. ).
How can i fix this? I want to add cars in my server without modify any code in .pwn.
Re: problem with sql car spawning. -
Razvan95 - 04.11.2010
That's what I do and I, any solution?