02.03.2014, 15:26
Hy guys, I'm having some problems with a script which is supposed to load the cars from db .. but it only loads the car with vID number 1.
Any ideas .. thanks!
Код:
stock LoadPVehicles()
{
new
Query[1024],
vModel2,
vC[2],
vPrice2,
vOwner2[MAX_PLAYER_NAME],
Float:Pos[4],
vID,
PlateNum[32],
vPaint_Job,
vModsToLoad[12],
vLock;
format(Query, sizeof(Query), "SELECT * FROM privateveh WHERE `vID` < "#MAX_BUYABLE_VEH" ORDER BY vID");
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows() > 0)
{
while(mysql_fetch_row_format(Query))
{
print("\n==============================================================\n");
new savingstring[256];
mysql_fetch_field_row(savingstring, "vID"); vID = strval(savingstring);
mysql_fetch_field_row(savingstring, "vModel"); vModel2 = strval(savingstring);
mysql_fetch_field_row(savingstring, "vOwner"); format(vOwner2, 24, "%s", savingstring);
mysql_fetch_field_row(savingstring, "vPrice"); vPrice2 = strval(savingstring);
mysql_fetch_field_row(savingstring, "vColor1"); vC[0] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vColor2"); vC[1] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vPosX"); Pos[0] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vPosY"); Pos[1] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vPosZ"); Pos[2] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vPosA"); Pos[3] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vPlate"); format(PlateNum, 32, "%s", savingstring);
mysql_fetch_field_row(savingstring, "vPaintJ"); vPaint_Job = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod1"); vModsToLoad[0] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod2"); vModsToLoad[1] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod3"); vModsToLoad[2] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod4"); vModsToLoad[3] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod5"); vModsToLoad[4] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod6"); vModsToLoad[5] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod7"); vModsToLoad[6] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod8"); vModsToLoad[7] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod9"); vModsToLoad[8] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod10"); vModsToLoad[9] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod11"); vModsToLoad[10] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vMod12"); vModsToLoad[11] = strval(savingstring);
mysql_fetch_field_row(savingstring, "vLocked"); vLock = strval(savingstring);
mysql_free_result();
printf("VID:\t\t%i", vID);
vInfo[vID][vModel] = vModel2; printf("Model:\t\t%i", vModel2);
vInfo[vID][vColor1] = vC[0]; printf("Color 1:\t%i", vC[0]);
vInfo[vID][vColor2] = vC[1]; printf("Color 2:\t%i", vC[1]);
vInfo[vID][vPrice] = vPrice2; printf("Price:\t\t$%i", vPrice2);
strmid(vInfo[vID][vOwner], vOwner2, 0, 24, 24); printf("Owner:\t\t%s", vOwner2);
vInfo[vID][vPosX] = Pos[0]; printf("Spawn X:\t%f", Pos[0]);
vInfo[vID][vPosY] = Pos[1]; printf("Spawn Y:\t%f", Pos[1]);
vInfo[vID][vPosZ] = Pos[2]; printf("Spawn Z:\t%f", Pos[2]);
vInfo[vID][vPosA] = Pos[3]; printf("Spawn A:\t%f", Pos[3]);
strmid(vInfo[vID][vPlate], PlateNum, 0, 32, 32); printf("Plate:\t\t%s", PlateNum);
vInfo[vID][vPaintJ] = vPaint_Job; printf("PaintJ:\t\t%i", vPaint_Job);
vInfo[vID][vLocked] = vLock; printf("Locked:\t\t%i", vLock);
vMods[vID][0] = vModsToLoad[0]; printf("Mod 1:\t\t%i", vModsToLoad[0]);
vMods[vID][1] = vModsToLoad[1]; printf("Mod 2:\t\t%i", vModsToLoad[1]);
vMods[vID][2] = vModsToLoad[2]; printf("Mod 3:\t\t%i", vModsToLoad[2]);
vMods[vID][3] = vModsToLoad[3]; printf("Mod 4:\t\t%i", vModsToLoad[3]);
vMods[vID][4] = vModsToLoad[4]; printf("Mod 5:\t\t%i", vModsToLoad[4]);
vMods[vID][5] = vModsToLoad[5]; printf("Mod 6:\t\t%i", vModsToLoad[5]);
vMods[vID][6] = vModsToLoad[6]; printf("Mod 7:\t\t%i", vModsToLoad[6]);
vMods[vID][7] = vModsToLoad[7]; printf("Mod 8:\t\t%i", vModsToLoad[7]);
vMods[vID][8] = vModsToLoad[8]; printf("Mod 9:\t\t%i", vModsToLoad[8]);
vMods[vID][9] = vModsToLoad[9]; printf("Mod 10:\t\t%i", vModsToLoad[9]);
vMods[vID][10] = vModsToLoad[10]; printf("Mod 11:\t\t%i", vModsToLoad[10]);
vMods[vID][11] = vModsToLoad[11]; printf("Mod 12:\t\t%i", vModsToLoad[11]);
print("\n==============================================================\n");
new
vCarID = CreateVehicle(vInfo[vID][vModel], vInfo[vID][vPosX], vInfo[vID][vPosY], vInfo[vID][vPosZ], vInfo[vID][vPosA], vInfo[vID][vColor1], vInfo[vID][vColor2], 50000);
SetVehicleNumberPlate(vCarID, vInfo[vID][vPlate]);
ChangeVehiclePaintjob(vCarID, vInfo[vID][vPaintJ]);
for(new iMod = 0; iMod < MAX_VEH_MODS; ++iMod)
{
if(vMods[vCarID][iMod] > 0)
{
AddVehicleComponent(vCarID, vMods[vCarID][iMod]);
}
}
OwnedVeh(vCarID) = vID;
++ Total_Veh_Created;
}
}
printf("** A total of: \"%i\" vehicle(s) were loaded!", Total_Veh_Created);
print("\n==============================================================");
print("Dynamic Vehicle Ownership By: [U]214 - MySQL Version Loaded...");
print("==============================================================\n");
return Total_Veh_Created;
