09.03.2013, 17:33
(
Последний раз редактировалось Ectazy; 10.03.2013 в 08:33.
)
Hi all, I have a problem with mysql cars loading (saving okay), loading right here, cars not loading:
Thanks for the HELP!
Код:
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;