MrMak
Ученик
[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 `Name` = ''' at line 1
Вот запросы в которых есть WHERE `NAME`
Помогите найти ошибку, пожалуйста.
Вот запросы в которых есть WHERE `NAME`
Код:
format(mysql_query, sizeof(mysql_query),"SELECT `Name` FROM `accounts` WHERE `Name` = '%s'", PlayerInfo[playerid][pNames]);
mysql_function_query(connects, mysql_query, true, "OnPlayerRegCheck","d", playerid);
Код:
mysql_format(connects,str,sizeof(str),"UPDATE `accounts` SET `pLevel` = '%d', `pMember` = '%d', `pIpReg` = '%s', `pReg` = '%d', `pCash` = '%d', `pSex` WHERE `Name` = '%s' ",
PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pIpReg], PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pCash], PlayerInfo[playerid][pSex],
sendername);
Код:
mysql_format(connects,mysql_query, sizeof(mysql_query),"SELECT * FROM `accounts` WHERE `Name` = '%s' AND `pKey` = '%e'", sendername, password);
mysql_function_query(connects, mysql_query, true, "LoginCallback","ds", playerid, password);
