CarlVEVO
Умник
Привет пользователям P-I. У меня такая ошибка при регистрации: (mysql_log):
Вот в моде где ошибка:
Вот весь stock saveaccount:
Пожалуйста, помогите!! Неделя мучаюсь, никак не могу исправить 
.
PHP:
[18:46:30] [ERROR] mysql_format - no value for specifier "%d" available
[18:46:30] [ERROR] mysql_format - no value for specifier "%d" available
[18:46:30] [ERROR] mysql_format - no value for specifier "%d" available
[18:46:30] [ERROR] mysql_format - no value for specifier "%d" available
[18:46:30] [ERROR] mysql_format - no value for specifier "%d" available
[18:46:30] [ERROR] mysql_format - no value for specifier "%d" available
[18:46:30] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '82 `Name` = '', WHERE `ID` = ''' at line 1
PHP:
mysql_format(SQL,query,sizeof(query),"%d \
`Name` = '%s', WHERE `ID` = '%d'", PlayerInfo[playerid][pName],PlayerInfo[playerid][pID]);
mysql_function_query(SQL, query, false, "", "");
PHP:
stock SaveAccount(playerid)
{
//new scr[2048];
new time = GetTickCount();
if(GetPVarInt(playerid, "LOGGED") == 1)
{
new a = PlayerInfo[playerid][pLic][0],
b = PlayerInfo[playerid][pLic][1],
c = PlayerInfo[playerid][pLic][2];
mysql_format(SQL,query,sizeof(query),"UPDATE `"TABLE_ACCOUNT"` SET `Level` = '%d',\
`Sex` = '%d',`Char` = '%d',`Drug` = '%d',`AdminLevel` = '%d',`Money` = '%d',`Exp` = '%d',\
`Skin` = '%d',`Car` = '%d',`Leader` = '%d',`Member` = '%d',`Rang` = '%d'б\
`House` = '%d',`Reg` = '%d',`Lica` = '%d',`Licb` = '%d',`Licc` = '%d',`Email` = '%d',",
PlayerInfo[playerid][pID], PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pChar],PlayerInfo[playerid][pDrug],
PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pMoney],PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pCar],PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRang],PlayerInfo[playerid][pHouse],
PlayerInfo[playerid][pReg],a,b,c,PlayerInfo[playerid][pEmail]);
new dd = PlayerInfo[playerid][pMet],
bbb = PlayerInfo[playerid][pDrugs],
cff = PlayerInfo[playerid][pPatr],
d = PlayerInfo[playerid][pWarn],
e = PlayerInfo[playerid][pMuted],
f = PlayerInfo[playerid][pPhone],
ss = PlayerInfo[playerid][pBank];
mysql_format(SQL,query,sizeof(query),"%d \
`Jail` = '%d',`JailTime` = '%d',`Zvezd` = '%d',`Key` = '%d',`Met` = '%d',\
`Drugs` = '%d',`Patr` = '%d',`Warn` = '%d',`Mute` = '%d',`pNumber` = '%d',\
`Phone` = '%d',`pBank` = '%d',`Job` = '%d',`Ip` = '%d',`RegData` = '%d',",
PlayerInfo[playerid][pJail], PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pZvezd],PlayerInfo[playerid][pKey],dd,bbb,cff,d,e,
PlayerInfo[playerid][pNumber],f,ss, PlayerInfo[playerid][pJob],PlayerInfo[playerid][pIp],
PlayerInfo[playerid][pRegData]);
mysql_format(SQL,query,sizeof(query),"%d \
`Zakon` = '%d',`Donat` = '%d' ,`Uluch` = '%d',`Health` = '%f',`Armor` = '%f',\
`Block` = '%d',`BlockKey` = '%d',`ZashKod` = '%d',",
PlayerInfo[playerid][pZakon], PlayerInfo[playerid][pDonat],
PlayerInfo[playerid][pUluch], PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pArmor], PlayerInfo[playerid][pBlock],
PlayerInfo[playerid][pBlockKey],PlayerInfo[playerid][pZashKod]);
mysql_format(SQL,query,sizeof(query),"%d \
`CarColor1` = '%d',`CarColor2` = '%d',`Text` = '%d',`pNumberMny` = '%d',\
`PhoneListPhone1` = '%d',`PhoneListPhone2` = '%d',`PhoneListPhone3` = '%d',`PhoneListPhone4` = '%d',\
`PhoneListPhone5` = '%d',`PhoneListPhone6` = '%d',`PhoneListPhone7` = '%d',`PhoneListPhone8` = '%d',\
`PhoneListPhone9` = '%d',`PhoneListPhone10` = '%d',`Ban` = '%d',",
PlayerInfo[playerid][pCarColor1], PlayerInfo[playerid][pCarColor2],
PlayerInfo[playerid][pText], PlayerInfo[playerid][pNumberMny],
PlayerInfo[playerid][pPhoneListPhone][0],PlayerInfo[playerid][pPhoneListPhone][1],
PlayerInfo[playerid][pPhoneListPhone][2],PlayerInfo[playerid][pPhoneListPhone][3],
PlayerInfo[playerid][pPhoneListPhone][4],PlayerInfo[playerid][pPhoneListPhone][5],
PlayerInfo[playerid][pPhoneListPhone][6],PlayerInfo[playerid][pPhoneListPhone][7],
PlayerInfo[playerid][pPhoneListPhone][8],PlayerInfo[playerid][pPhoneListPhone][9],
PlayerInfo[playerid][pBan]);
new options[32];
format(PlayerInfo[playerid][pModels], 50, "%i, %i, %i, %i, %i", PlayerInfo[playerid][pModel][0],
PlayerInfo[playerid][pModel][1], PlayerInfo[playerid][pModel][2], PlayerInfo[playerid][pModel][3], PlayerInfo[playerid][pModel][4]);
mysql_format(SQL,query,40,"`pModels` = '%s',",PlayerInfo[playerid][pModels]);
format(options, sizeof(options), "%d, %d", PlayerInfo[playerid][pOptions][0], PlayerInfo[playerid][pOptions][1]);
mysql_format(SQL, query,40,"`Options` = '%s',",options);
format(options, sizeof(options), "%d, %d, %d, %d, %d, %d", PlayerInfo[playerid][pGunSkill][0], PlayerInfo[playerid][pGunSkill][1], PlayerInfo[playerid][pGunSkill][2], PlayerInfo[playerid][pGunSkill][3],
PlayerInfo[playerid][pGunSkill][4], PlayerInfo[playerid][pGunSkill][5]);
mysql_format(SQL, query, 40,"`GunSkill` = '%s',", options);
mysql_format(SQL,query,sizeof(query),"%d \
`PhoneList1` = '%s',`PhoneList2` = '%s',`PhoneList3` = '%s',`PhoneList4` = '%s',\
`PhoneList5` = '%s',`PhoneList6` = '%s',`PhoneList7` = '%s',`PhoneList8` = '%s',\
`PhoneList9` = '%s',`PhoneList10` = '%s',`Bizz` = '%d',",
PhoneList[playerid][0], PhoneList[playerid][1], PhoneList[playerid][2],PhoneList[playerid][3],
PhoneList[playerid][4],PhoneList[playerid][5], PhoneList[playerid][6],PhoneList[playerid][7],
PhoneList[playerid][8],PhoneList[playerid][9], PlayerInfo[playerid][pBizz]);
mysql_format(SQL,query,sizeof(query),"%d \
`Year` = '%d',`Month` = '%d',`Day` = '%d',`BanDay` = '%d',`UnWarns` = '%d',`BankNumber` = '%d',",
PlayerInfo[playerid][pYear], PlayerInfo[playerid][pMonth], PlayerInfo[playerid][pDay],
PlayerInfo[playerid][pBanDay], PlayerInfo[playerid][pUnWarns], PlayerInfo[playerid][pBankNumber]);
mysql_format(SQL,query,sizeof(query),"%d \
`Name` = '%s', WHERE `ID` = '%d'", PlayerInfo[playerid][pName],PlayerInfo[playerid][pID]);
mysql_function_query(SQL, query, false, "", "");
printf("Account %s was successfuly saved.(%i)",PlayerInfo[playerid][pName],GetTickCount() - time);
}
return 1;
}