Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function AddPlayerVehicle(playerid) {
- new szQuery2[256];
- mysql_format(SQL, szQuery2, sizeof(szQuery2), "INSERT INTO pvehicles (`Model`, `Owner`,`Name`) VALUES ('%d', '%s', '%s')", DSModel[playerid], PlayerInfo[playerid][pName], aVehicleNames[DSModel[playerid] - 400]);
- mysql_tquery(SQL, szQuery2);
- new szQuery[256], i = pvehs+1;
- if(PlayerInfo[playerid][pCarKey][0] == 0) {
- PlayerInfo[playerid][pCarKey][0] = i;
- mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE `users` SET `CarKey` = '%d' WHERE `Name` = '%s'", i, getName(playerid));
- mysql_tquery(SQL, szQuery);
- PlayerVehicle[PlayerInfo[playerid][pCarKey][0]][pSQLID] = PlayerInfo[playerid][pSQLID];
- mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE `pvehicles` SET `SQLID` = '%d', `CarColor1` = '1', `CarColor2` = '1', `PosX` = '2147.6511', `PosY` = '-1170.8748',`PosZ` = '23.4453',`ZAngle` = '270.2680' WHERE `ID` = '%d'", PlayerInfo[playerid][pSQLID], PlayerInfo[playerid][pCarKey][0]);
- mysql_tquery(SQL, szQuery);
- }
- else if(PlayerInfo[playerid][pCarKey][1] == 0) {
- PlayerInfo[playerid][pCarKey][1] = i;
- mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE `users` SET `CarKey1` = '%d' WHERE `Name` = '%s'", i, getName(playerid));
- mysql_tquery(SQL, szQuery);
- PlayerVehicle[PlayerInfo[playerid][pCarKey][1]][pSQLID] = PlayerInfo[playerid][pSQLID];
- mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE `pvehicles` SET `SQLID` = '%d', `CarColor1` = '1', `CarColor2` = '1', `PosX` = '2147.6511', `PosY` = '-1170.8748',`PosZ` = '23.4453',`ZAngle` = '270.2680' WHERE `ID` = '%d'", PlayerInfo[playerid][pSQLID], PlayerInfo[playerid][pCarKey][1]);
- mysql_tquery(SQL, szQuery);
- }
- else if(PlayerInfo[playerid][pCarKey][2] == 0) {
- PlayerInfo[playerid][pCarKey][2] = i;
- mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE `users` SET `CarKey2` = '%d' WHERE `Name` = '%s'", i, getName(playerid));
- mysql_tquery(SQL, szQuery);
- PlayerVehicle[PlayerInfo[playerid][pCarKey][2]][pSQLID] = PlayerInfo[playerid][pSQLID];
- mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE `pvehicles` SET `SQLID` = '%d', `CarColor1` = '1', `CarColor2` = '1', `PosX` = '2147.6511', `PosY` = '-1170.8748',`PosZ` = '23.4453',`ZAngle` = '270.2680' WHERE `ID` = '%d'", PlayerInfo[playerid][pSQLID], PlayerInfo[playerid][pCarKey][2]);
- mysql_tquery(SQL, szQuery);
- }
- else if(PlayerInfo[playerid][pCarKey][3] == 0) {
- PlayerInfo[playerid][pCarKey][3] = i;
- mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE `users` SET `CarKey3` = '%d' WHERE `Name` = '%s'", i, getName(playerid));
- mysql_tquery(SQL, szQuery);
- PlayerVehicle[PlayerInfo[playerid][pCarKey][3]][pSQLID] = PlayerInfo[playerid][pSQLID];
- mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE `pvehicles` SET `SQLID` = '%d', `CarColor1` = '1', `CarColor2` = '1', `PosX` = '2147.6511', `PosY` = '-1170.8748',`PosZ` = '23.4453',`ZAngle` = '270.2680' WHERE `ID` = '%d'", PlayerInfo[playerid][pSQLID], PlayerInfo[playerid][pCarKey][3]);
- mysql_tquery(SQL, szQuery);
- }
- else if(PlayerInfo[playerid][pCarKey][4] == 0) {
- PlayerInfo[playerid][pCarKey][4] = i;
- PlayerVehicle[PlayerInfo[playerid][pCarKey][4]][pSQLID] = PlayerInfo[playerid][pSQLID];
- mysql_format(SQL, szQuery, sizeof(szQuery), "UPDATE `pvehicles` SET `SQLID` = '%d', `CarColor1` = '1', `CarColor2` = '1', `PosX` = '2147.6511', `PosY` = '-1170.8748',`PosZ` = '23.4453',`ZAngle` = '270.2680' WHERE `ID` = '%d'", PlayerInfo[playerid][pSQLID], PlayerInfo[playerid][pCarKey][4]);
- mysql_tquery(SQL, szQuery);
- }
- new query[256];
- mysql_format(SQL, query, sizeof(query), "SELECT * FROM pvehicles");
- mysql_tquery(SQL, query, "LoadPVehicles", "");
- LoadPVehicles();
- return 1; }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement