-len += formatex(query[len],charsmax(query) - len,") FROM `%s` as `a` WHERE `id` IN(",tbl_name)
+len += formatex(query[len],charsmax(query) - len,"FROM `%s` as `a` WHERE `id` IN(",tbl_name)
[ 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 'FROM `csstats_players` as `a` WHERE `id` IN('656','3772','4019','4053','387','34' at line 1
[ SQL ] SELECT `id`,(SELECT COUNT(*) FROM csstats_players WHERE (frags)>=(a.frags)), (SELECT COUNT(*) FROM csstats_players WHERE (skill)>=(a.skill)FROM `csstats_players` as `a` WHERE `id` IN('656','3772','4019','4053','387','346','407'
Код:[ SQL ] SELECT `id`,(SELECT COUNT(*) FROM csstats_players WHERE (frags)>=(a.frags)), (SELECT COUNT(*) FROM csstats_players WHERE (skill)>=(a.skill)FROM `csstats_players` as `a` WHERE `id` IN('656','3772','4019','4053','387','346','407'
SELECT `id`,(SELECT COUNT(*) FROM csstats_players WHERE (frags)>=(a.frags)), (SELECT COUNT(*) FROM csstats_players WHERE (skill)>=(a.skill)FROM
SELECT id,(SELECT COUNT(*) FROM csstats_players WHERE (frags)>=(a.frags)), (SELECT COUNT(*) FROM csstats_players WHERE (skill)>=(a.skill)) FROM csstats_players as a WHERE id IN ('656','3772','4019','4053','387','346','407','8','463','761','439','4055','1287','4056','270','568','323','358','3775','3203','345','412','380','578','3454')
len += formatex(query[len],charsmax(query) - len,") FROM `%s` as `a` WHERE `id` IN(",tbl_name)
А где?
- В архиве присутствуют готовые плагины с поддержкой потоковых запросов (csxmysql_amxx_statsx.zip)
csstats
SET shots
= shots
+ 8,hits
= hits
+ 3,dmg
= dmg
+ 79,h_2
= h_2
+ '1',h_4
= h_4
+ '1',h_5
= h_5
+ '1',connects
= connects
+ '1',roundt
= roundt
+ '1',wint
= wint
+ '1',connection_time
= connection_time
+ 55,last_join
= CURRENT_TIMESTAMP,steamid
= 'STEAM_0:1:530404002',csstats_sql_typeбд обновил?Кто нибудь в курсе почему стата не пишется? в БД только ники и нули
https://dev-cs.ru/data/attachments/28/28823-d3d879851fcdea50fe818e0bbfd29662.jpg
[csstatsx_sql.amxx] SQL query failed
L 09/25/2021 - 00:20:49: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 09/25/2021 - 00:20:49: [csstatsx_sql.amxx] [ SQL ] UPDATEcsstats
SETshots
=shots
+ 8,hits
=hits
+ 3,dmg
=dmg
+ 79,h_2
=h_2
+ '1',h_4
=h_4
+ '1',h_5
=h_5
+ '1',connects
=connects
+ '1',roundt
=roundt
+ '1',wint
=wint
+ '1',connection_time
=connection_time
+ 55,last_join
= CURRENT_TIMESTAMP,steamid
= 'STEAM_0:1:530404002',csstats_sql_type
какую из? по инструкции csstats обновил по очереди как написано. Потом допилил mapsбд обновил?