Mysql cars loading - 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)
+--- Thread: Mysql cars loading (/showthread.php?tid=421482)
+- 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)
+--- Thread: Mysql cars loading (/showthread.php?tid=421482)
Mysql cars loading - Ectazy - 09.03.2013
Hi all, I have a problem with mysql cars loading (saving okay), loading right here, cars not loading:
Код:
new Table = 0;
for(new v; v < MAX_VEHICLES; v++)
{
format(query, 1024,"SELECT * FROM "SQL_CARTABLE" WHERE ID = '%d'", v);
mysql_query(query);
mysql_store_result();
if(Table == 0)
{
if(mysql_num_rows() != 0)
{
Table = 1;
}
else
{
Table = 2;
}
}
}
if(Table == 1)
{
for(new v; v < MAX_VEHICLES; v++)
{
format(query, 1024,"SELECT * FROM "SQL_CARTABLE" WHERE ID = '%d'", v);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() != 0)
{
new model, vehicle, Float:CarFloat[5], tune[13];
mysql_fetch_field("Owner", sql);
format(vInfo[v][Owner], MAX_PLAYER_NAME, "%s", sql);
mysql_fetch_field("Model", sql); model = strval(sql);
mysql_fetch_field("X", sql); CarFloat[0] = floatstr(sql);
mysql_fetch_field("Y", sql); CarFloat[1] = floatstr(sql);
mysql_fetch_field("Z", sql); CarFloat[2] = floatstr(sql);
mysql_fetch_field("Angle", sql); CarFloat[3] = floatstr(sql);
mysql_fetch_field("HP", sql); CarFloat[4] = floatstr(sql);
mysql_fetch_field("Fuel", vInfo[v][Fuel]);
mysql_fetch_field("Color1", vInfo[v][Color1]);
mysql_fetch_field("Color2", vInfo[v][Color2]);
mysql_fetch_field("Lock", sql);
if(strval(sql) == 1)
{
vInfo[v][Lock] = true;
}
else
{
vInfo[v][Lock] = false;
}
if(model > 399)
{
if(model == 599 || model == 598 || model == 523 || model == 416 ||
model == 438 || model == 420 || model == 403 || model == 456 ||
model == 498 || model == 591 || model == 584 || model == 587 ||
model == 521 || model == 578 || model == 493 || model == 512 ||
model == 525 || model == 448 || model == 519 || model == 472 ||
model == 408 || model == 431 || model == 437)
{
vehicle = CreateVehicle(model, CarFloat[0], CarFloat[1], CarFloat[2], CarFloat[3], vInfo[v][Color1], vInfo[v][Color2], 60*30);
}
else
{
vehicle = CreateVehicle(model, CarFloat[0], CarFloat[1], CarFloat[2], CarFloat[3], vInfo[v][Color1], vInfo[v][Color2], -1);
}
mysql_fetch_field("Paintjob", sql); if(strval(sql) > 0) ChangeVehiclePaintjob(vehicle, strval(sql)-1);
mysql_fetch_field("Interior", sql); vInfo[vehicle][Interior] = strval(sql); LinkVehicleToInterior(vehicle, strval(sql));
mysql_fetch_field("Tune0", sql); tune[0] = strval(sql);
mysql_fetch_field("Tune1", sql); tune[1] = strval(sql);
mysql_fetch_field("Tune2", sql); tune[2] = strval(sql);
mysql_fetch_field("Tune3", sql); tune[3] = strval(sql);
mysql_fetch_field("Tune4", sql); tune[4] = strval(sql);
mysql_fetch_field("Tune5", sql); tune[5] = strval(sql);
mysql_fetch_field("Tune6", sql); tune[6] = strval(sql);
mysql_fetch_field("Tune7", sql); tune[7] = strval(sql);
mysql_fetch_field("Tune8", sql); tune[8] = strval(sql);
mysql_fetch_field("Tune9", sql); tune[9] = strval(sql);
mysql_fetch_field("Tune10", sql); tune[10] = strval(sql);
mysql_fetch_field("Tune11", sql); tune[11] = strval(sql);
mysql_fetch_field("Tune12", sql); tune[12] = strval(sql);
AddVehicleComponent(vehicle, tune[0]);
AddVehicleComponent(vehicle, tune[1]);
AddVehicleComponent(vehicle, tune[2]);
AddVehicleComponent(vehicle, tune[3]);
AddVehicleComponent(vehicle, tune[4]);
AddVehicleComponent(vehicle, tune[5]);
AddVehicleComponent(vehicle, tune[6]);
AddVehicleComponent(vehicle, tune[7]);
AddVehicleComponent(vehicle, tune[8]);
AddVehicleComponent(vehicle, tune[9]);
AddVehicleComponent(vehicle, tune[10]);
AddVehicleComponent(vehicle, tune[11]);
AddVehicleComponent(vehicle, tune[12]);
}
format(query, 1024, "DELETE FROM "SQL_CARTABLE" WHERE ID = '%d'", vehicle);
mysql_query(query);
mysql_free_result();
SaveVehicle(vehicle);
}
}
}
else if(Table == 2)
{
new vehicle;
/* Job cars */
vehicle = CreateVehicle(599,-1400.697,2659.695,56.073,90.0,-1,-1,60*30); //Police Ranger
SaveVehicle(vehicle);
vehicle = CreateVehicle(599,-1400.697,2653.398,56.073,89.0,-1,-1,60*30); //Police Ranger
SaveVehicle(vehicle);
vehicle = CreateVehicle(598,-1400.697,2647.201,56.073,89.0,-1,-1,60*30); //LVPD
SaveVehicle(vehicle);
vehicle = CreateVehicle(598,-1400.667,2640.842,56.073,89.0,-1,-1,60*30); //LVPD
SaveVehicle(vehicle);
}
for(new i=0;i<MAX_VEHICLES;i++) vInfo[i][Fuel] = 100;
Re: Mysql cars loading - Ectazy - 10.03.2013
Up..
Re: Mysql cars loading - Smally - 10.03.2013
I take it compiles fine? Have you defined SQL_CARTABLE? Although I have a feeling that might be causing the problem, if you've done all these try adding some prints in so you can check the command line.
Re: Mysql cars loading - Ectazy - 10.03.2013
Yes, it compiles fine. SQL_CARTABLE are defined. I try add print there:
Код:
new Table;
for(new v; v < MAX_VEHICLES; v++)
{
Table = 0;
format(query, 1024,"SELECT * FROM "SQL_CARTABLE" WHERE ID = '%d'", v);
mysql_query(query);
mysql_store_result();
if(Table == 0)
{
if(mysql_num_rows() != 0)
{
Table = 1;
print("Table 1);
}
else
{
Table = 2;
print("Table 2");
}
}
}
Код:
[16:56:32] Table 2 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 2 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 1 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2 [16:56:32] Table 2
Re: Mysql cars loading - Ectazy - 11.03.2013
Up..
Re: Mysql cars loading - Knappen - 11.03.2013
Give me a minute, and I'll see what I can do.
EDIT:
pawn Код:
new Table = 0;
format(query, 1024,"SELECT * FROM "SQL_CARTABLE"");
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() != 0)
{
if(Table == 0)
{
Table = 1;
}
else
{
Table = 2;
}
}
if(Table == 1)
{
while(mysql_retrieve_row())
{
new model, vehicle, locked, Float:CarFloat[5], tune[13];
// Vehicle
mysql_get_field("Owner", vInfo[vehicle][Owner]);
mysql_get_field("Model", sql); model = strval(sql);
mysql_get_field("X", sql); CarFloat[0] = floatstr(sql);
mysql_get_field("Y", sql); CarFloat[1] = floatstr(sql);
mysql_get_field("Z", sql); CarFloat[2] = floatstr(sql);
mysql_get_field("Angle", sql); CarFloat[3] = floatstr(sql);
mysql_get_field("HP", sql); CarFloat[4] = floatstr(sql);
mysql_get_field("Fuel", sql); vInfo[vehicle][Fuel] = strval(sql);
mysql_get_field("Color1", sql); vInfo[vehicle][Color1] = strval(sql);
mysql_get_field("Color2", sql); vInfo[vehicle][Color2] = strval(sql);
mysql_get_field("Lock", sql); locked = strval(sql);
if(locked == 1)
{
vInfo[vehicle][Lock] = true;
}
else
{
vInfo[vehicle][Lock] = false;
}
if(model > 399)
{
if(model == 599 || model == 598 || model == 523 || model == 416 ||
model == 438 || model == 420 || model == 403 || model == 456 ||
model == 498 || model == 591 || model == 584 || model == 587 ||
model == 521 || model == 578 || model == 493 || model == 512 ||
model == 525 || model == 448 || model == 519 || model == 472 ||
model == 408 || model == 431 || model == 437)
{
vehicle = CreateVehicle(model, CarFloat[0], CarFloat[1], CarFloat[2], CarFloat[3], vInfo[v][Color1], vInfo[v][Color2], 60*30);
}
else
{
vehicle = CreateVehicle(model, CarFloat[0], CarFloat[1], CarFloat[2], CarFloat[3], vInfo[v][Color1], vInfo[v][Color2], -1);
}
}
// Components
mysql_get_field("Paintjob", sql); if(strval(sql) > 0) ChangeVehiclePaintjob(vehicle, strval(sql)-1);
mysql_get_field("Interior", sql); vInfo[vehicle][Interior] = strval(sql); LinkVehicleToInterior(vehicle, strval(sql));
mysql_get_field("Tune0", sql); tune[0] = strval(sql);
mysql_get_field("Tune1", sql); tune[1] = strval(sql);
mysql_get_field("Tune2", sql); tune[2] = strval(sql);
mysql_get_field("Tune3", sql); tune[3] = strval(sql);
mysql_get_field("Tune4", sql); tune[4] = strval(sql);
mysql_get_field("Tune5", sql); tune[5] = strval(sql);
mysql_get_field("Tune6", sql); tune[6] = strval(sql);
mysql_get_field("Tune7", sql); tune[7] = strval(sql);
mysql_get_field("Tune8", sql); tune[8] = strval(sql);
mysql_get_field("Tune9", sql); tune[9] = strval(sql);
mysql_get_field("Tune10", sql); tune[10] = strval(sql);
mysql_get_field("Tune11", sql); tune[11] = strval(sql);
mysql_get_field("Tune12", sql); tune[12] = strval(sql);
AddVehicleComponent(vehicle, tune[0]);
AddVehicleComponent(vehicle, tune[1]);
AddVehicleComponent(vehicle, tune[2]);
AddVehicleComponent(vehicle, tune[3]);
AddVehicleComponent(vehicle, tune[4]);
AddVehicleComponent(vehicle, tune[5]);
AddVehicleComponent(vehicle, tune[6]);
AddVehicleComponent(vehicle, tune[7]);
AddVehicleComponent(vehicle, tune[8]);
AddVehicleComponent(vehicle, tune[9]);
AddVehicleComponent(vehicle, tune[10]);
AddVehicleComponent(vehicle, tune[11]);
AddVehicleComponent(vehicle, tune[12]);
vehicle++;
}
mysql_free_result();
}
else if(Table == 2)
{
new vehicle;
/* Job cars */
vehicle = CreateVehicle(599,-1400.697,2659.695,56.073,90.0,-1,-1,60*30); //Police Ranger
SaveVehicle(vehicle);
vehicle = CreateVehicle(599,-1400.697,2653.398,56.073,89.0,-1,-1,60*30); //Police Ranger
SaveVehicle(vehicle);
vehicle = CreateVehicle(598,-1400.697,2647.201,56.073,89.0,-1,-1,60*30); //LVPD
SaveVehicle(vehicle);
vehicle = CreateVehicle(598,-1400.667,2640.842,56.073,89.0,-1,-1,60*30); //LVPD
SaveVehicle(vehicle);
}
for(new i=0;i<MAX_VEHICLES;i++) vInfo[i][Fuel] = 100;
Re: Mysql cars loading - Ectazy - 11.03.2013
Thanks, but I get many errors:
undefined symbol "mysql_get_field" and undefined symbol "mysql_retrieve_row".
Re: Mysql cars loading - Ectazy - 07.04.2013
/\
l
l
l
l
Re: Mysql cars loading - Ectazy - 08.04.2013
UP..