[Вопрос] Не записываются некоторые данные в БД

Не записываются некоторые данные в БД

Не записываются некоторые данные в БД , хотя всё по списку идёт

PHP код:

if(GetPVarInt(playerid, !"Logged") > 0) { new query[128] = "UPDATE "table_account" SET "; format(query, sizeof(query), "%s `Skin` = '%d',", query, PlayerInfo[playerid][pSkin]); format(query, sizeof(query), "%s `Sex` = '%d',", query, PlayerInfo[playerid][pSex]); format(query, sizeof(query), "%s `Cash` = '%d',", query, PlayerInfo[playerid][pCash]); format(query, sizeof(query), "%s `Level` = '%d',", query, PlayerInfo[playerid][pLevel]); format(query, sizeof(query), "%s `Admin` = '%d',", query, PlayerInfo[playerid][pAdmin]); format(query, sizeof(query), "%s `Pohodka` = '%d',", query, PlayerInfo[playerid][pPohodka]); format(query, sizeof(query), "%s `Rasa` = '%d',", query, PlayerInfo[playerid][pRasa]); format(query, sizeof(query), "%s `Yazik` = '%d',", query, PlayerInfo[playerid][pYazik]); format(query, sizeof(query), "%s `Gorod` = '%d',", query, PlayerInfo[playerid][pGorod]); format(query, sizeof(query), "%s WHERE `Name` = '%s'", query, GN(playerid)); mysql_function_query(mysql_connection, query, false, "", ""); } return true;

http://ihost.pro-pawn.ru/image.php?di=AJ8A

Не мало памяти выделено для запроса?

Цитата:

Сообщение от Web

Не мало памяти выделено для запроса?

Да нет даже много

Запятая лишняя перед WHERE есть просто

Цитата:

format(query, sizeof(query), "%s `Gorod` = '%d',", query, PlayerInfo[playerid][pGorod]);

И вряд ли хватит 128 ячеек для запроса. Уже сейчас, даже без информации из переменных, у тебя больше 250 символов в строке

Не сахраняет всё равно

Ну так значит до сих пор есть либо ошибка в запросе, либо массива не хватает.
Убери лишние пробелы между именем столбца и спецификатором("%d"), а после подсчитай нормально размер для запроса.

UPD:

PHP код:

if(GetPVarInt(playerid, !"Logged") > 0) { new query[19+(7+3)+(6+1)+(7+11)+(8+11)+(8+2)+(10+2)+(7+2)+(8+2)+(7+1)+(14+MAX_PLAYER_NAME)+1] = "UPDATE account SET ";//19 format(query, sizeof(query), "%s Skin=%d,", query, PlayerInfo[playerid][pSkin]);//7+3 format(query, sizeof(query), "%s Sex=%d,", query, PlayerInfo[playerid][pSex]);//6+1 format(query, sizeof(query), "%s Cash=%d,", query, PlayerInfo[playerid][pCash]);//7+11 format(query, sizeof(query), "%s Level=%d,", query, PlayerInfo[playerid][pLevel]);//8+11 format(query, sizeof(query), "%s Admin=%d,", query, PlayerInfo[playerid][pAdmin]);//8+2 format(query, sizeof(query), "%s Pohodka=%d,", query, PlayerInfo[playerid][pPohodka]);//10+2 format(query, sizeof(query), "%s Rasa=%d,", query, PlayerInfo[playerid][pRasa]);//7+2 format(query, sizeof(query), "%s Yazik=%d,", query, PlayerInfo[playerid][pYazik]);//8+2 format(query, sizeof(query), "%s Gorod=%d", query, PlayerInfo[playerid][pGorod]);//7+1 format(query, sizeof(query), "%s WHERE Name='%s'", query, GN(playerid));//14+MAX_PLAYER_NAME mysql_function_query(mysql_connection, query, false, "", ""); }

http://ihost.pro-pawn.ru/image.php?di=Y51F
Всё равно так же

Ну так покажи логи MySQL

PHP код:

[23:13:14] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061) [23:13:16] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061) [23:13:16] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061) [14:18:20] [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 '' at line 1 [14:18:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [14:18:29] [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 '' at line 1 [14:25:20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [14:25:20] [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 '' at line 1 [14:27:20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [14:27:20] [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 '' at line 1 [14:31:45] [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 '' at line 1 [15:25:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:25:36] [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 '' at line 1 [15:26:14] [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 '' at line 1 [15:26:20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:26:20] [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 '' at line 1 [15:28:38] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:28:39] [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 '' at line 1 [15:30:33] [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 '' at line 1 [15:30:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:30:39] [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 '' at line 1 [15:59:03] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:59: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 '' at line 1 [15:59:36] [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 '' at line 1 [15:59:43] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [15:59:43] [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 '' at line 1 [16:01:28] [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 '' at line 1 [16:01:35] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [16:01:35] [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 '' at line 1 [16:02:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [16:02:39] [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 '' at line 1 [16:03:02] [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 '' at line 1 [16:03:09] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [16:03:09] [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 '' at line 1 [16:16:44] [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 '' at line 1 [16:16:48] [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 '' at line 1 [16:16:51] [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 '' at line 1 [16:27:04] [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 '' at line 1 [18:52:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [18:52:29] [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 '' at line 1 [18:55:11] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [18:55:11] [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 '' at line 1 [19:02:56] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:02:56] [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 '' at line 1 [19:06:24] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:06:24] [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 '' at line 1 [19:12:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:12: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 '' at line 1 [19:15:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:15:54] [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 '' at line 1 [19:23:46] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:23:46] [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 '' at line 1 [19:29:53] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:29:53] [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 '' at line 1 [19:31:49] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:31:49] [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 '' at line 1 [19:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:32:54] [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 '' at line 1 [19:34:30] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:34: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 '' at line 1 [19:45:48] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [19:45:48] [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 '' at line 1 [19:46:13] [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 '' at line 1 [20:01:27] [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 '' at line 1 [20:03:07] [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 '' at line 1 [20:03:12] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [20:03:12] [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 '' at line 1 [20:03:20] [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 '' at line 1 [20:21:54] [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 '' at line 1 [20:22:56] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [20:22:56] [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 '' at line 1 [20:51:56] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [20:51:56] [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 '' at line 1 [21:21:37] [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 '' at line 1 [22:01:41] [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 '' at line 1 [22:06:36] [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 '' at line 1 [22:08:32] [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 '' at line 1 [17:05:08] [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 '' at line 1 [17:41:19] [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 '' at line 1 [17:41:39] [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 '' at line 1 [17:41:50] [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 '' at line 1 [17:45:18] [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 '' at line 1 [18:05:32] [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 '' at line 1 [18:12:10] [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 '' at line 1 [18:40:04] [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 '' at line 1 [22:12:58] [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 ''9' at line 1 [22:13:04] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [22:13:04] [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 ''9' at line 1 [22:25:46] [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 '' at line 1 [22:25:53] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [22:25:53] [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 '' at line 1 [22:28:48] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ID") [22:28:48] [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 '' at line 1 [22:38:01] [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 '' at line 1 [01:46:33] [ERROR] CMySQLQuery::Execute[] - (error #1136) Column count doesn't match value count at row 1 [01:55:09] [ERROR] CMySQLQuery::Execute[UploadPlayerAccountNumber] - (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 '`Sex` = '0' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '0' ' at line 1 [01:58:33] [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 '`Sex` = '0' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '0' ' at line 1 [01:58:50] [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 '`Sex` = '0' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '0' ' at line 1 [02:02:39] [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 '`Sex` = '2' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '1' ' at line 1 [02:08:24] [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 '`Sex` = '1' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '3' ' at line 1 [02:14:37] [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 '`Sex` = '1' `Cash` = '970' `Level` = '1' `Admin` = '0' `Pohodka` = '3' ' at line 1 [18:20:32] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table '1ns1de.account' doesn't exist [23:25:09] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table '1ns1de.account' doesn't exist [23:26:12] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table '1ns1de.account' doesn't exist [23:47:15] [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 ''Cub_Andersonj' at line 1

Во-первых, ты где-то пытаешься обратиться к столбцу "ID", которого нет (у тебя столбец записан как "id")
Во-вторых, сделай так и скинь логи сервера после выхода с этого самого сервера

PHP код:

if(GetPVarInt(playerid, !"Logged") > 0) { new query[19+(7+3)+(6+1)+(7+11)+(8+11)+(8+2)+(10+2)+(7+2)+(8+2)+(7+1)+(14+MAX_PLAYER_NAME)+1] = "UPDATE account SET ";//19 format(query, sizeof(query), "%s Skin=%d,", query, PlayerInfo[playerid][pSkin]);//7+3 format(query, sizeof(query), "%s Sex=%d,", query, PlayerInfo[playerid][pSex]);//6+1 format(query, sizeof(query), "%s Cash=%d,", query, PlayerInfo[playerid][pCash]);//7+11 format(query, sizeof(query), "%s Level=%d,", query, PlayerInfo[playerid][pLevel]);//8+11 format(query, sizeof(query), "%s Admin=%d,", query, PlayerInfo[playerid][pAdmin]);//8+2 format(query, sizeof(query), "%s Pohodka=%d,", query, PlayerInfo[playerid][pPohodka]);//10+2 format(query, sizeof(query), "%s Rasa=%d,", query, PlayerInfo[playerid][pRasa]);//7+2 format(query, sizeof(query), "%s Yazik=%d,", query, PlayerInfo[playerid][pYazik]);//8+2 format(query, sizeof(query), "%s Gorod=%d", query, PlayerInfo[playerid][pGorod]);//7+1 format(query, sizeof(query), "%s WHERE Name='%s'", query, GN(playerid));//14+MAX_PLAYER_NAME mysql_function_query(mysql_connection, query, false, "", ""); printf("\n\n\n\n|%s|\n\n\n\n", query); }

PHP код:

[20:13:09] [part] Cub_Andersonl has left the server (0:0) [20:13:18] [connection] 127.0.0.1:60441 requests connection cookie. [20:13:19] [connection] incoming connection: 127.0.0.1:60441 id: 0 [20:13:19] [join] Cub_Andersonl has joined the server (0:127.0.0.1) [20:14:08] |UPDATE accounts SET Skin=299, Sex=1, Cash=970, Level=1, Admin=0, Pohodka=4, Rasa=3, Yazik=5, Gorod=1 WHERE Name='Cub_Andersonl'| [20:14:08] [part] Cub_Andersonl has left the server (0:1)

Вот так

В чём дело не пойму

Удали файл с логами MySQL, зайди на сервер, авторизируйся, выйди и после этого скинь содержимое файла логов, что появятся

В логах mysql не чего нету , в обычных так же
Я заметил когда зарегался

То сохраняет только это

PHP код:

publics: OnPlayerRegister(playerid) { static const reg[]= "INSERT INTO `"table_account"` (`Name`, `Password`, `Skin`, `Sex`, `Cash`, `Level`) VALUES ('%s', '%s', '%d', '%d', '%d', '%d')"; new str_reg[sizeof(reg) + MAX_PLAYER_NAME + 80 - 14]; format(str_reg,sizeof(str_reg), reg, GN(playerid), PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pLevel]); mysql_function_query(mysql_connection, str_reg, false, "", ""); SetPVarInt(playerid, !"Logged", 1); /***************************************************************************/ /***************************************************************************/ SetPlayerVirtualWorld(playerid, 0); SpawnPlayer(playerid); return true; }

В логи даёт

PHP код:

| |UPDATE accounts SET Skin=0, Sex=0, Cash=970, Level=1, Admin=0, Pohodka=0, Rasa=0, Yazik=0, Gorod=1 WHERE Name='Cub_Andersont'|

А когда я выхожу срабатывает SavePlayer в OnPlayerDisconnect
И свё слетает вообще щяс скин пол
http://ihost.pro-pawn.ru/image.php?di=YQJ5

Эмм, ну так судя по запросу, всё сейчас сохранилось так, как передалось в этот самый запрос. У тебя во всех переменных, кроме денег, уровня и города, хранятся нули

Да.

Эмм, что?
Запрос-то проходит, получается, и сохраняет то, что в него попадает.

Вот я регистрируюсь всё сахраняется

PHP код:

|UPDATE accounts SET  Skin=0, Sex=0, Cash=970, Level=1, Admin=0, Rasa=0, Gorod=2 WHERE Name='Cub_Andersony'|

Когда перезахожу и не водя пароль снова , выхожу выдаёт

PHP код:

|UPDATE accounts SET  Skin=0, Sex=0, Cash=970, Level=1, Admin=0, Rasa=0, Gorod=2 WHERE Name='Cub_Andersony'|

PHP код:

    PlayerInfo[playerid][pSkin] =                 0;     PlayerInfo[playerid][pPohodka] =             0;     PlayerInfo[playerid][pRasa] =                 0;     PlayerInfo[playerid][pYazik] =                 0;

Так добавь проверку на авторизацию в сохранение аккаунта

PHP код:

if(GetPVarInt(playerid, !"Logged") > 0) { new query[19+(7+3)+(6+1)+(7+11)+(8+11)+(8+2)+(10+2)+(7+2)+(8+2)+(7+1)+(14+MAX_PLAYER_NAME)+1] = "UPDATE account SET ";//19 format(query, sizeof(query), "%s Skin=%d,", query, PlayerInfo[playerid][pSkin]);//7+3 format(query, sizeof(query), "%s Sex=%d,", query, PlayerInfo[playerid][pSex]);//6+1 format(query, sizeof(query), "%s Cash=%d,", query, PlayerInfo[playerid][pCash]);//7+11 format(query, sizeof(query), "%s Level=%d,", query, PlayerInfo[playerid][pLevel]);//8+11 format(query, sizeof(query), "%s Admin=%d,", query, PlayerInfo[playerid][pAdmin]);//8+2 format(query, sizeof(query), "%s Pohodka=%d,", query, PlayerInfo[playerid][pPohodka]);//10+2 format(query, sizeof(query), "%s Rasa=%d,", query, PlayerInfo[playerid][pRasa]);//7+2 format(query, sizeof(query), "%s Yazik=%d,", query, PlayerInfo[playerid][pYazik]);//8+2 format(query, sizeof(query), "%s Gorod=%d", query, PlayerInfo[playerid][pGorod]);//7+1 format(query, sizeof(query), "%s WHERE Name='%s'", query, GN(playerid));//14+MAX_PLAYER_NAME mysql_function_query(mysql_connection, query, false, "", ""); printf("\n\n\n\n|%s|\n\n\n\n", query); }

Так она же есть if(GetPVarInt(playerid, !"Logged") > 0)

Ну раз запрос проходит, значит Logged не равна нулю в момент выхода игрока. Ты точно при устанавливаешь значение для Logged, а не при коннекте?

PHP код:

public OnPlayerDisconnect(playerid, reason) { Logged[playerid] = 0; SavePlayer(playerid); return true; }

Эмм, что это? И почему тут уже переменная, а не pVar? O_o Да ещё и нуль присваивается ей перед сохранением, а не после.

А разве что-то будет если в определённых переменные в других pvar ?

Переменная и pVar - разные вещи. Убирай pVar, ставь на его место переменную и удостоверься, что единица в переменную записывается только при авторизации, а нуль записывается после вызова SavePlayer, а не до

Хотел узнать ещё

PHP код:

new query[19+(7+3)+(6+1)+(7+11)+(8+11)+(8+2)+(10+2)+(7+2)+(8+2)+(7+1)+(14+MAX_PLAYER_NAME)+1] = "UPDATE account SET ";//19

Почему не отнимаешь %d - 2

Потому что я не учитывал их сразу при подсчёте. И все спецсимволы за 1 символ сразу посчитал.
Я делаю расчёт функцией редактора, просто выделяя текст
https://i.imgur.com/SCF3DXZ.png

а что у тебя за редактор ?

Sublime Text 3

Цитата:

Сообщение от DeimoS

Sublime Text 3

http://pro-pawn.ru/showthread.php?14620