shape1
shape2
shape3
shape4
shape7
shape8

Баг с деньгами

M

MrTailsFox

Новичок
Пользователь
07.09.2017
2
0
0
Игрок
Спойлер




Добрый день. Как исправить баг. Покупаю что-то на сервере и когда перезахожу то деньги возвращаются обратно на баланс.

 
Последнее редактирование модератором:
Jaliba_Baron

Jaliba_Baron

Руководитель
Пользователь
24.09.2015
648
2
929
0
21
pawno-crmp.ru
Скриптер
Попробуй купить дом или бизнес и перезайти.
На данный момент я только могу склоняться к варианту, что в базе данных данные не были обновлены.

 
Myrka

Myrka

Освоившийся
Пользователь
07.04.2016
336
80
0
25
Желательно бы логи (server_log.txt, mysql_log.txt). Может быть проблема с базой данных. Или сделай сохранение аккаунта в паблик OnPlayerDisconnect

 
M

MrTailsFox

Новичок
Пользователь
07.09.2017
2
0
0
Игрок
server_log.txt
 


Спойлер
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3e, (C)2005-2012 SA-MP Team

[07:14:19] filterscripts = "" (string)
[07:14:19]
[07:14:19] Server Plugins
[07:14:19] --------------
[07:14:19] Loading plugin: mysql.so
[07:14:19] >> plugin.mysql: R39-6 successfully loaded.
[07:14:19] Loaded.
[07:14:19] Loading plugin: mysql_static.so
[07:14:19] >> plugin.mysql: R39-6 successfully loaded.
[07:14:19] Loaded.
[07:14:19] Loading plugin: streamer.so
[07:14:19]

*** Streamer Plugin v2.8.2 by Incognito loaded ***

[07:14:19] Loaded.
[07:14:19] Loading plugin: sscanf.so
[07:14:19]

[07:14:19] ===============================

[07:14:19] sscanf plugin loaded.

[07:14:19] Version: 2.8.2

[07:14:19] (c) 2012 Alex "Y_Less" Cole

[07:14:19] ===============================

[07:14:19] Loaded.
[07:14:19] Loading plugin: regex.so
[07:14:19]

[07:14:19] ______________________________________

[07:14:19] Regular Expression Plugin v0.2.1 loaded
[07:14:19] ______________________________________

[07:14:19] By: Fro (c) Copyright <TBG> 2009-2011
[07:14:19] ______________________________________

[07:14:19] Loaded.
[07:14:19] Loaded 5 plugins.

[07:14:19]
[07:14:19] Filterscripts
[07:14:19] ---------------
[07:14:19] Loaded 0 filterscripts.

[07:14:19] MySQL connection: TRUE

[07:14:19] -> Динамических объектов: 25592
[07:14:19] -> Статических объектов: 0
[07:14:19] -> Видимых объектов (стример): 1000
[07:14:19] -> Количество транспорта: 285
[07:14:19] _______________________________________________________
[07:14:19] development fashion: #Nick
[07:14:19] AltaironceRP project © 2018-2018, inc. all rights reserved.
[07:14:19] _______________________________________________________
[07:14:19] Number of vehicle models: 74
[07:14:19] [Загружено бизнесов]: <41>. Потрачено: <2 ms>.
[07:14:19] [Загружено домов]: <280>. Потрачено: <13 ms>.
[07:14:19] [Загружены склады мафий]: Потрачено: <0 ms>.
[07:14:19] [Загружены склады банд]: Потрачено: <0 ms>.
[07:14:19] [Загружено гангзон]: <0>. Потрачено: <0 ms>.
[07:14:19] [Загружено банкоматов]: <20>. Потрачено: <0 ms>.
[07:14:19] [Загружено остальное]: Потрачено: <1 ms>.
[07:14:19] [Загружено семей]: <1>. Потрачено: <0 ms>.
[07:14:57] Incoming connection: 192.168.1.1:64832
[07:14:58] [join] Makson_Patison has joined the server (0:192.168.1.1)
[07:16:20] [part] Makson_Patison has left the server (0:1)
[07:16:44] Incoming connection: 192.168.1.1:49239
[07:16:45] [join] Makson_Patison has joined the server (0:192.168.1.1)
[07:17:04] [part] Makson_Patison has left the server (0:1)





mysql_log.txt


Спойлер
Код: 
[07:14:19 08/24/20] [ERROR] CMySQLQuery::Execute[@LoadMaps] - (error #1146) Table 'crmp.maps' doesn't exist (Query: "SELECT * FROM `maps`")
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('117') (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_row_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('120') (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('121') (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_row_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("veh_reg_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cModel_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cClass_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cFuel_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_float - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cMileage_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_float - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cColor1_1") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cColor2_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cCost_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cVehcom_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("pVehicleBuy1") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("pVehicleBuy") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cDirt_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:15:10 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("SpawnCarInfo") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:15:10 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:16:08 08/24/20] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('32') (Query: "SELECT * FROM admin WHERE name = 'Makson_Patison' AND password = '1'")
[07:16:08 08/24/20] [ERROR] cache_get_row_int - invalid datatype
[07:16:08 08/24/20] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('33') (Query: "SELECT * FROM admin WHERE name = 'Makson_Patison' AND password = '1'")
[07:16:20 08/24/20] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'cDirt' in 'field list' (Query: "UPDATE accounts SET `ip` = '192.168.1.1', `level` = '1', `age` = '0', `cash` = '44900', `bank` = '0', `warn` = '0', `exp` = '0', `news` = '0', `thour` = '63', `drugs` = '0', `patron` = '0', `gunamount` = '0', `heal` = '100.000000', `married` = '0', `whomarried` = 'None', `paycheck` = '0', `vip` = '0', `viptime` = '0', `robhouse` = '0', `time` = '0', `fstyle` = '0', `spawnchange` = '0', `sdpistol` = '0', `deserteagle` = '0', `shotgun` = '0', `mp5` = '0', `ak47` = '0', `m4` = '0', `pistol` = '0', `microuzi` = '0', `hunger` = '0', `sportexp` = '0', `city` = '0', `phonebalance` = '100', `truckskill` = '0', `cModel` = '0', `cFuel` = '0', `cMileage` = '0', `cClass` = '0', `cColor1` = '0', `cColor2` = '0', `cCost` = '0', `cVehcom` = '0,0,0,0,0,0,0,0,0,0,0,0,0,0', `cPaintjob` = '3', `repcar` = '0, 0', `improves` = '0, 0, 0, ', `phonenumber` = '0', `phnumber1` = '0', `phnumber2` = '0', `phnumber3` = '0', `phnumber4` = '0', `phnumber5` = '0', `phnumber6` = '0', `phnumber7` = '0', `phnumber8` = '0', `licenses` = '1', `timewarn` = '0', `house` = '1', `biz` = '0', `gun` = '', `cDirt` = '0', `cModel_2` = '0', `cFuel_2` = '0', `cMileage_2` = '0', `cClass_2` = '0', `cColor1_2` = '0', `cColor2_2` = '0', `cCost_2` = '0', `cVehcom_2` = 'NULL', `cPaintjob_2` = '0', `pVehicleBuy1` = '0', `pVehicleBuy` = '0', `SpawnCarInfo` = '0', `cDirt_2` = '0' WHERE `id` = '138'")
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('117') (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_row_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('120') (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('121') (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_row_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("veh_reg_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cModel_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cClass_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cFuel_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_float - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cMileage_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_float - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cColor1_1") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cColor2_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cCost_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cVehcom_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("pVehicleBuy1") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("pVehicleBuy") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("cDirt_2") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:16:57 08/24/20] [WARNING] CMySQLResult::GetRowDataByName - field not found ("SpawnCarInfo") (Query: "SELECT * FROM accounts WHERE name = 'Makson_Patison'")
[07:16:57 08/24/20] [ERROR] cache_get_field_content_int - invalid datatype
[07:17:04 08/24/20] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'cDirt' in 'field list' (Query: "UPDATE accounts SET `ip` = '192.168.1.1', `level` = '1', `age` = '0', `cash` = '5000', `bank` = '0', `warn` = '0', `exp` = '0', `news` = '0', `thour` = '6', `drugs` = '0', `patron` = '0', `gunamount` = '0', `heal` = '100.000000', `married` = '0', `whomarried` = 'None', `paycheck` = '0', `vip` = '0', `viptime` = '0', `robhouse` = '0', `time` = '0', `fstyle` = '0', `spawnchange` = '0', `sdpistol` = '0', `deserteagle` = '0', `shotgun` = '0', `mp5` = '0', `ak47` = '0', `m4` = '0', `pistol` = '0', `microuzi` = '0', `hunger` = '0', `sportexp` = '0', `city` = '0', `phonebalance` = '100', `truckskill` = '0', `cModel` = '0', `cFuel` = '0', `cMileage` = '0', `cClass` = '0', `cColor1` = '0', `cColor2` = '0', `cCost` = '0', `cVehcom` = '0,0,0,0,0,0,0,0,0,0,0,0,0,0', `cPaintjob` = '3', `repcar` = '0, 0', `improves` = '0, 0, 0, ', `phonenumber` = '0', `phnumber1` = '0', `phnumber2` = '0', `phnumber3` = '0', `phnumber4` = '0', `phnumber5` = '0', `phnumber6` = '0', `phnumber7` = '0', `phnumber8` = '0', `licenses` = '1', `timewarn` = '0', `house` = '1', `biz` = '0', `gun` = '', `cDirt` = '0', `cModel_2` = '0', `cFuel_2` = '0', `cMileage_2` = '0', `cClass_2` = '0', `cColor1_2` = '0', `cColor2_2` = '0', `cCost_2` = '0', `cVehcom_2` = 'NULL', `cPaintjob_2` = '0', `pVehicleBuy1` = '0', `pVehicleBuy` = '0', `SpawnCarInfo` = '0', `cDirt_2` = '0' WHERE `id` = '138'")



 
Последнее редактирование модератором:
Вам необходимо войти или зарегистрироваться, чтобы здесь отвечать.
Верх Низ