Dima_Tushin
Компетентный
MYSQL_LOG
Сохранение:
Что тут не так помогите!
PHP:
[17:31:03] [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 'WHERE `pName` = 'Dima_Tushin'' at line 1
[17:31:03] [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 'WHERE `pName` = 'Dima_Tushin'' at line 1
[17:31:05] [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 'WHERE `pName` = 'Dima_Tushin'' at line 1
HTML:
publics: OnPlayerUpdateRL(playerid)
{
new str[1000];
if(IsPlayerConnected(playerid))
{
if(gPlayerLogged[playerid] == true)
{
mysql_format(MYSQL,str,sizeof(str),"UPDATE `akk` SET `pEmail` = '%s',`pLevel` = '%d',`pSkin` = '%d',`pReg` = '%d',\
`pTut` = '%d',`pSex` = '%d',`pDrug` = '%s',`pHP` = '%d',`pText` = '%d',`pPBiskey` = '%d',",
PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pSkin],
PlayerInfo[playerid][pReg], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pDrug], PlayerInfo[playerid][pHP], PlayerInfo[playerid][pText], PlayerInfo[playerid][pPBiskey]);
format(str,sizeof(str),"%s `pMember` = '%d',`pBank` = '%d',`pAvtomas` = '%d',`pJob` = '%d',\
`pInt` = '%d',`pModel` = '%d',`pZvezdi` = '%d',`pRank` = '%d',`pLeader` = '%d',`pCash` = '%d',", str, PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pBank], PlayerInfo[playerid][pAvtomas], PlayerInfo[playerid][pJob], PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pModel], PlayerInfo[playerid][pZvezdi], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pCash]);
format(str,sizeof(str),"%s `pAdmin` = '%d',`pHealth` = '%f',`pSHealth` = '%f',`pExp` = '%d',\
`pPayCheck` = '%d',`pSatiety` = '%d',`pPayDay` = '%d', `pMestoJail` = '%d', `pJailed` = '%d', `pJailTime` = '%d', WHERE `pName` = '%s'", str, PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pSHealth], PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pSatiety], PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pMestoJail],
PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], Name(playerid));
mysql_function_query(MYSQL, str, false, "", "");
}
return true;
}
return true;
}
Последнее редактирование:
