Marco_Gabana
Новичок
Здравствуйте Ув. форумчани, помогите пожалуйста исправить баг
Заключается он в том что не сохраняются в базу личные машины, мод самп-рп v11
Вот еще таблица
Заключается он в том что не сохраняются в базу личные машины, мод самп-рп v11
PHP:
#define TABLE_CARS "cars"
PHP:
enum carInfo
{
carID[5],
carModel[5],
carColor_one[5],
carColor_two[5],
carPercent[5],
Float:carFuel[5],
carVehcom_1[5],
carVehcom_2[5],
carVehcom_3[5],
carVehcom_4[5],
carVehcom_5[5],
carVehcom_6[5],
carVehcom_7[5],
carVehcom_8[5],
carVehcom_9[5],
carVehcom_10[5],
carVehcom_11[5],
carVehcom_12[5],
carVehcom_13[5],
carVehcom_14[5]
};
new CarInfo[MAX_PLAYERS][carInfo];
PHP:
mysql_format(DATABASE,QUERY,256,"SELECT * FROM `"TABLE_CARS"` WHERE `owner` = '%s'",PlayerInfo[playerid][pName]), mysql_function_query(DATABASE,QUERY,true,"OnMySQL_QUERY","iis",33,playerid,"");
PHP:
case 10:
{
mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_CARS"` SET ");
format(temp,sizeof(temp),"`owner`= '%s',",CarInfo[i][carModel][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`model`= '%i',",CarInfo[i][carModel][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`color_one`= '%i',",CarInfo[i][carColor_one][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`color_two`= '%i',",CarInfo[i][carColor_two][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`percent`= '%i',",CarInfo[i][carPercent][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`fuel`= '%f',",CarInfo[i][carFuel][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_1`= '%i',",CarInfo[i][carVehcom_1][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_2`= '%i',",CarInfo[i][carVehcom_2][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_3`= '%i',",CarInfo[i][carVehcom_3][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_4`= '%i',",CarInfo[i][carVehcom_4][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_5`= '%i',",CarInfo[i][carVehcom_5][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_6`= '%i',",CarInfo[i][carVehcom_6][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_7`= '%i',",CarInfo[i][carVehcom_7][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_8`= '%i',",CarInfo[i][carVehcom_8][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_9`= '%i',",CarInfo[i][carVehcom_9][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_10`= '%i',",CarInfo[i][carVehcom_10][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_11`= '%i',",CarInfo[i][carVehcom_11][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_12`= '%i',",CarInfo[i][carVehcom_12][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_13`= '%i',",CarInfo[i][carVehcom_13][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_14`= '%i'",CarInfo[i][carVehcom_14][0]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp)," WHERE id = '%i'",CarInfo[i][carID][0]), strcat(QUERY,temp,sizeof(QUERY));
mysql_function_query(DATABASE, QUERY, true, "", "");
}
