20.08.2015, 02:33
(
Последний раз редактировалось JordanZaundd; 05.09.2016 в 06:47.
)
I'll give you the mySQL table too just incase you need it. Thank you for your help so far.
Here is an image of the mysql table

And The information that is default filled in the table when an account is created.

2. Short version gave me warnings when compiling and gave me errors when trying to load my character.
PHP код:
format(query, sizeof(query), "SELECT * FROM `uservehicles` WHERE `id` = %d LIMIT 1;", charid);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(MySQLData, "|");
split2(MySQLData, MySQLField, '|');
for(new v = 0; v < MAX_PLAYERVEHICLES; v++)
{ // 0, 1 useless cuz its the ID & username
PlayerVehicleInfo[playerid][v][pvPosX] = floatstr(MySQLField[v*39+2]); // This formula is to calculate WHICH car to load from
PlayerVehicleInfo[playerid][v][pvPosY] = floatstr(MySQLField[v*39+3]); // The first car is MySQLField 2 here but if its the 2nd Car its MySQLField 12
PlayerVehicleInfo[playerid][v][pvPosZ] = floatstr(MySQLField[v*39+4]);
PlayerVehicleInfo[playerid][v][pvPosAngle] = floatstr(MySQLField[v*39+5]);
PlayerVehicleInfo[playerid][v][pvModelId] = strval(MySQLField[v*39+6]);
PlayerVehicleInfo[playerid][v][pvLock] = strval(MySQLField[v*39+7]);
PlayerVehicleInfo[playerid][v][pvLocked] = strval(MySQLField[v*39+8]);
PlayerVehicleInfo[playerid][v][pvPaintJob] = strval(MySQLField[v*39+9]);
PlayerVehicleInfo[playerid][v][pvColor1] = strval(MySQLField[v*39+10]);
PlayerVehicleInfo[playerid][v][pvColor2] = strval(MySQLField[v*39+11]);
for(new m = 0; m < MAX_MODS; m++)
{
PlayerVehicleInfo[playerid][v][pvMods][m] = strval(MySQLField[ v*37+1+11+m ]); // same as above but fits to the Mod Loop
}
PlayerVehicleInfo[playerid][v][pvDamage] = floatstr(MySQLField[v*39+13+13]); // 25
PlayerVehicleInfo[playerid][v][pvDamageStatus][0] = strval(MySQLField[v*39+13+14]); //
PlayerVehicleInfo[playerid][v][pvDamageStatus][1] = strval(MySQLField[v*39+13+15]); //
PlayerVehicleInfo[playerid][v][pvDamageStatus][2] = strval(MySQLField[v*39+13+16]); //
PlayerVehicleInfo[playerid][v][pvDamageStatus][3] = strval(MySQLField[v*39+13+17]); //
PlayerVehicleInfo[playerid][v][pvNeon] = strval(MySQLField[v*39+13+18]); //
PlayerVehicleInfo[playerid][v][pvFuel] = strval(MySQLField[v*39+13+19]); //
format(PlayerVehicleInfo[playerid][v][pvPlate], 33, "%s", MySQLField[v*39+13+20]); //
PlayerVehicleInfo[playerid][v][pvInInsurance] = strval(MySQLField[v*39+13+26]);
PlayerVehicleInfo[playerid][v][pvLockType] = strval(MySQLField[v*39+13+27]);
// Gotta spawn the car early so the trunk can load into it
if(PlayerVehicleInfo[playerid][v][pvModelId] != 0 && PlayerVehicleInfo[playerid][v][pvInInsurance] == 0)
{
new carcreated = CreateVehicleEx(PlayerVehicleInfo[playerid][v][pvModelId], PlayerVehicleInfo[playerid][v][pvPosX], PlayerVehicleInfo[playerid][v][pvPosY], PlayerVehicleInfo[playerid][v][pvPosZ], PlayerVehicleInfo[playerid][v][pvPosAngle],1, 1, -1);
PlayerVehicleInfo[playerid][v][pvId] = carcreated;
VehOwner[carcreated] = playerid;
if(PlayerVehicleInfo[playerid][v][pvLocked] > 0)
{
LockCar(carcreated);
}
new tmpstore[4][31];
for(new t = 0; t<MAX_TRUNK_SLOTS; t++)
{
split2(MySQLField[v*39+13+21+t], tmpstore, '-');
TrunkInfo[PlayerVehicleInfo[playerid][v][pvId]][t][tItemType] = strval(tmpstore[0]);
TrunkInfo[PlayerVehicleInfo[playerid][v][pvId]][t][tItemID] = strval(tmpstore[1]);
TrunkItnfo[PlayerVehicleInfo[playerid][v][pvId]][t][tItemAmount] = strval(tmpstore[2]);
format(TrunkInfo[PlayerVehicleInfo[playerid][v][pvId]][t][tItemTitle], 30, "%s", tmpstore[3]);
}
}
}

And The information that is default filled in the table when an account is created.

2. Short version gave me warnings when compiling and gave me errors when trying to load my character.