MrMak
Ученик
Код:
[11:31:55] [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 '`pReg` = '1',`pSex` = '0',`pModel` = '26',`pIpReg` = '127.0.0.1',`pMember` = '0'' at line 1
Код:
mysql_format(connects,str,sizeof(str),"UPDATE `accounts` SET `pLevel` = '%d',`pExp` = '%d',`pAdminka` = '%d',`pMoney` = '%d',`pTut` = '%d',`pSchetBank` = '%d',`pChar` = '%d' ",
PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pAdminka],PlayerInfo[playerid][pMoney],
PlayerInfo[playerid][pTut],PlayerInfo[playerid][pSchetBank],
PlayerInfo[playerid][pChar]); // ïî 11-10øò. â ñòðîêå
mysql_format(connects,str,sizeof(str),"%s `pReg` = '%d',`pSex` = '%d',`pModel` = '%d',`pIpReg` = '%s',`pMember` = '%d' WHERE `Name` = '%s'",str,
PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pModel],PlayerInfo[playerid][pIpReg],
PlayerInfo[playerid][pMember],sendername);
mysql_function_query(connects, str, false, "", "");
