Проблема Проблема с MySQL

[Alonso 82]

В общем, структура бд огромная, а при сохранении всего ~5 столбцов используются

 

 

 

 

 

 

 

 

[#Rips 210]

Покажите как вы сохраняете

[Alonso 82]

public SavePlayer(playerid)
{
	new plip[64], year, month, day, strstre[50], strstre2[50];
	GetPlayerIp(playerid,plip,sizeof(plip));
	getdate(year, month, day);
	format(strstre,sizeof(strstre), "%d/%d/%d",day,month,year);
	format(strstre2,sizeof(strstre2), "%s",plip);
    new query_string[555] = "UPDATE `accounts` SET";
    format(query_string, sizeof(query_string), "%s `Admin` = '%d',", query_string, PlayerInfo[playerid][pAdmin]);
    format(query_string, sizeof(query_string), "%s `IP` = '%d',", query_string, strstre2);
    format(query_string, sizeof(query_string), "%s `mail` = '%s',", query_string, PlayerInfo[playerid][pMail]);
    format(query_string, sizeof(query_string), "%s `Cash` = '%d',", query_string, PlayerInfo[playerid][pCash]);
    format(query_string, sizeof(query_string), "%s `Bank` = '500000',", query_string);
    format(query_string, sizeof(query_string), "%s `Mobile` = '%d',", query_string, PlayerInfo[playerid][pMobile]);
    format(query_string, sizeof(query_string), "%s `Member` = '%d',", query_string, PlayerInfo[playerid][pMember]);
    format(query_string, sizeof(query_string), "%s `Rank` = '%d',", query_string, PlayerInfo[playerid][pRank]);
    format(query_string, sizeof(query_string), "%s `House` = '%d',", query_string, PlayerInfo[playerid][pHouse]);
    format(query_string, sizeof(query_string), "%s `Fuelcar` = '%f',", query_string, PlayerInfo[playerid][pFuelcar]);
    format(query_string, sizeof(query_string), "%s `Car` = '%d',", query_string, PlayerInfo[playerid][pCar]);
    format(query_string, sizeof(query_string), "%s `Color1` = '%d',", query_string, PlayerInfo[playerid][pColor][0]);
    format(query_string, sizeof(query_string), "%s `Color2` = '%d',", query_string, PlayerInfo[playerid][pColor][1]);
    format(query_string, sizeof(query_string), "%s `Char` = '14',", query_string);
    format(query_string, sizeof(query_string), "%s `Wheels` = '%d',", query_string, PlayerInfo[playerid][pWheels]);
    format(query_string, sizeof(query_string), "%s `PaintJob` = '%d',", query_string, PlayerInfo[playerid][pPaintJob]);
    format(query_string, sizeof(query_string), "%s `Spoiler` = '%d',", query_string, PlayerInfo[playerid][pSpoiler]);
    format(query_string, sizeof(query_string), "%s `Bumper1` = '%d',", query_string, PlayerInfo[playerid][pBumper1]);
    format(query_string, sizeof(query_string), "%s `Bumper2` = '%d',", query_string, PlayerInfo[playerid][pBumper2]);
    format(query_string, sizeof(query_string), "%s `Nitro` = '%d',", query_string, PlayerInfo[playerid][pNitro]);
    format(query_string, sizeof(query_string), "%s `Hydrawlic` = '%d',", query_string, PlayerInfo[playerid][pHydrawlic]);
    format(query_string, sizeof(query_string), "%s `Vixlop` = '%d',", query_string, PlayerInfo[playerid][pVixlop]);
    format(query_string, sizeof(query_string), "%s `VozZab` = '%d',", query_string, PlayerInfo[playerid][pVozZab]);
    format(query_string, sizeof(query_string), "%s `Yubka1` = '%d',", query_string, PlayerInfo[playerid][pYubka1]);
    format(query_string, sizeof(query_string), "%s `Yubka2` = '%d',", query_string, PlayerInfo[playerid][pYubka2]);
    format(query_string, sizeof(query_string), "%s `Date` = '%s' ", query_string, strstre);
    format(query_string, sizeof(query_string), "%s WHERE `Namea` = '%s'", query_string, PlayerInfo[playerid][pName]);
    mysql_tquery(mysql_connect_id, query_string, !"", !"");
    printf("%s сохранен.", PlayerInfo[playerid][pName]);
	return 1;
}

На счет Bank и Char - сделал спецом для проверки только что

Исправил баг - удалил бд, и создал по новой.