GreenS
Новичок
Не добавляются аккаунты в бд Mysql
Вместо имени и пароля остается пустое место:
Вот сама регистрация:
Вот лог Mysql:
Пожалуйста помогите
Вместо имени и пароля остается пустое место:
Вот сама регистрация:
PHP:
stock OnPlayerRegister(playerid, password[])
{
if(IsPlayerConnected(playerid))
{
static query_mysql[160];
new string[160],keystring[31];
format(string,strlen(string),"INSERT INTO 'users' (`Имя`) VALUES ('%d')",PlayerInfo[playerid][pName]);
format(string,strlen(string),"INSERT INTO 'users' (`Пароль`) VALUES ('%d')",keystring);
format(query_mysql,strlen(query_mysql),"%d",string );
if(!strcmp(keystring, password, true))
{
PHP:
[17:04:49] ProcessQueryThread(s) - Query was successful. (UPDATE `users` SET `Бизнес` = '9999')
[17:04:49] ProcessQueryThread(s) - Data caching enabled.
[17:04:49] CMySQLHandler::StoreResult() - No data to store.
[17:04:49] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:04:49] Unloading Plugin
[17:04:49] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[17:04:49] CMySQLHandler::FreeResult() - The result is already empty.
[17:04:49] CMySQLHandler::Disconnect() - Connection was closed.
[17:05:08] >> mysql_connect(localhost, root, grand, ******) on port 3306
[17:05:08] CMySQLHandler::CMySQLHandler() - constructor called.
[17:05:08] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "grand" | Username: "root"
[17:05:08] CMySQLHandler::Connect() - Connection was successful.
[17:05:08] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[17:05:08] >> mysql_set_charset( Connection handle: 1 )
[17:05:08] >> mysql_query_callback( Connection handle: 1 )
[17:05:08] >> mysql_query_callback( Connection handle: 1 )
[17:05:08] >> mysql_ping( Connection handle: 1 )
[17:05:08] CMySQLHandler::Ping() - Connection is still alive.
[17:05:08] Passing query SET NAMES 'utf8' |
[17:05:08] ProcessQueryThread() - Query was successful. (SET NAMES 'utf8')
[17:05:08] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:05:08] Passing query SET CHARACTER SET 'cp1251' |
[17:05:08] ProcessQueryThread() - Query was successful. (SET CHARACTER SET 'cp1251')
[17:05:08] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:05:35] >> mysql_query_callback( Connection handle: 1 )
[17:05:35] Passing query | s
[17:05:35] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[17:25:49] >> mysql_query_callback( Connection handle: 1 )
[17:25:49] Passing query UPDATE `users` SET `Бизнес` = '9999' | d
[17:25:49] ProcessQueryThread(s) - Query was successful. (UPDATE `users` SET `Бизнес` = '9999')
[17:25:49] ProcessQueryThread(s) - Data caching enabled.
[17:25:49] CMySQLHandler::StoreResult() - No data to store.
[17:25:49] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] Passing query UPDATE `users` SET `Бизнес` = '9999' | d
[17:25:56] ProcessQueryThread(s) - Query was successful. (UPDATE `users` SET `Бизнес` = '9999')
[17:25:56] ProcessQueryThread(s) - Data caching enabled.
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] CMySQLHandler::StoreResult() - No data to store.
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] >> mysql_query_callback( Connection handle: 1 )
[17:25:56] Unloading Plugin
[17:25:56] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[17:25:56] CMySQLHandler::FreeResult() - The result is already empty.
[17:25:56] CMySQLHandler::Disconnect() - Connection was closed.
