Ошибка с [ZP] Buy Menu + Level System от t3rkecorejz

VolodyaMEGAlodon

Пользователь
Регистрация
3 Янв 2021
Сообщения
9
Симпатии
1
OS
Linux
Amx Mod X
AMXX 1.9.0
Билд
3.8.0.703-dev-mpatch
ReGamedll
5.20.0.492-dev
Metamod
Metamod v1.21p37
Meta модули
Код:
[ 1] Reunion RUN - reunion_mm_i386. v0.1.0.1 ini Start Never
[ 2] Revoice RUN - revoice_mm_i386. v0.1.0.3 ini Start Never
[ 3] AMX Mod X RUN - amxmodx_mm_i386. v1.9.0.5 ini Start ANY
[ 4] Ultimate Unprec RUN - unprecacher_i386 vBeta 2. ini Chlvl Chlvl
[ 5] Ham Sandwich RUN - hamsandwich_amxx v1.9.0.5 pl3 ANY ANY
[ 6] CSX RUN - csx_amxx_i386.so v1.9.0.5 pl3 ANY ANY
[ 7] SxGeo RUN - sxgeo_amxx_i386. v2.2 pl3 ANY Never
[ 8] Engine RUN - engine_amxx_i386 v1.9.0.5 pl3 ANY ANY
[ 9] FakeMeta RUN - fakemeta_amxx_i3 v1.9.0.5 pl3 ANY ANY
[10] CStrike RUN - cstrike_amxx_i38 v1.9.0.5 pl3 ANY ANY
[11] Fun RUN - fun_amxx_i386.so v1.9.0.5 pl3 ANY ANY
[12] MySQL RUN - mysql_amxx_i386. v1.9.0.5 pl3 ANY ANY
[13] ReAPI RUN - reapi_amxx_i386. v5.19.0. pl3 ANY Never
Плагины
Код:
[ 1] Admin Base 1.9.0.5262 AMXX Dev Team admin.amxx running
[ 2] Admin Commands 1.9.0.5262 AMXX Dev Team admincmd.amxx running
[ 3] Admin Help 1.9.0.5262 AMXX Dev Team adminhelp.amxx running
[ 4] Slots Reservation 1.9.0.5262 AMXX Dev Team adminslots.amxx running
[ 5] Multi-Lingual System 1.9.0.5262 AMXX Dev Team multilingual.am running
[ 6] Menus Front-End 1.9.0.5262 AMXX Dev Team menufront.amxx running
[ 7] Commands Menu 1.9.0.5262 AMXX Dev Team cmdmenu.amxx running
[ 8] Players Menu 1.9.0.5262 AMXX Dev Team plmenu.amxx running
[ 9] Maps Menu 1.9.0.5262 AMXX Dev Team mapsmenu.amxx running
[ 10] Plugin Menu 1.9.0.5262 AMXX Dev Team pluginmenu.amxx running
[ 11] Admin Chat 1.9.0.5262 AMXX Dev Team adminchat.amxx running
[ 12] Anti Flood 1.9.0.5262 AMXX Dev Team antiflood.amxx running
[ 13] Scrolling Message 1.9.0.5262 AMXX Dev Team scrollmsg.amxx running
[ 14] Info. Messages 1.9.0.5262 AMXX Dev Team imessage.amxx running
[ 15] Admin Votes 1.9.0.5262 AMXX Dev Team adminvote.amxx running
[ 16] NextMap 1.9.0.5262 AMXX Dev Team nextmap.amxx running
[ 17] Nextmap Chooser 1.9.0.5262 AMXX Dev Team mapchooser.amxx running
[ 18] TimeLeft 1.9.0.5262 AMXX Dev Team timeleft.amxx running
[ 19] Pause Plugins 1.9.0.5262 AMXX Dev Team pausecfg.amxx running
[ 20] Stats Configuration 1.9.0.5262 AMXX Dev Team statscfg.amxx running
[ 21] StatsX 1.9.0.5262 AMXX Dev Team statsx.amxx running
[ 22] [SxGeo] Connect Info 1.0 s1lent sxgeo_connect_i running
[ 23] Obscura Cam 0.7 Nani (SkumTomteN ObscuraCam_0.7. running
[ 24] Potti 1.40 p3tsin potti.amxx running
[ 25] Меню потти Only Locky pottimenu.amxx running
[ 26] [AMXX] Settings API 1.0 MeRcyLeZZ amx_settings_ap debug
[ 27] \r[Z]\wombie \r[P]\wla 4.4 MeRcyLeZZ | @bdu zombie_plague_s debug
[ 28] [ZP] Assassin vs Snipe 1.2 @bdul! | [P]erfe zp_game_mode_as debug
[ 29] [ZP] Nightmare Mode 1.1 @bdul! | [P]erfe zp_game_mode_ni debug
[ 30] [ZP] Remix Mode 1.2 @bdul! | [P]erfe zpsp_game_mode_ debug
[ 31] [ZP] Buy Menu + Level 1.1 t3rkecorejz zp_buymenu_leve debug
[ 32] [ZP] Default Zombie Cl 4.3 Fix5 MeRcyLeZZ zpsp_zombie_cla debug
[ 33] [RE:ZCore] ZClass: Ban 1.0 xUnicorn zp_zclass_bansh debug
[ 34] [ZP] Class: Stamper 2020 | 1.0 xUnicorn (t3rkec zp_zclass_stamp debug
[ 35] [ZP] Class: x-Voodoo 2019 | 1.0 xUnicorn (t3rkec zp_zclass_voodo debug
[ 36] [ZP | AMXX] Sting Fing 0/0/2 m0rt3m zp_zclass_sting debug
[ 37] [ZP] Class: Venom Guar 1.0.1 xUnicorn (t3rkec zp_zclass_venom debug
[ 38] unknown unknown unknown zp_lasermine_pe bad load
[ 39] [ZP] Knife: Dread Nova 1.0 | 2019 xUnicorn (t3rkec zp_knife_dreadn debug
[ 40] [ZP] Knife: Warhammer 1.1 | 2019 xUnicorn zp_knife_stormg debug
[ 41] [ZP] Knife: Blade Rune 1.0 | 2019 xUnicorn zp_knife_runebl debug
[ 42] [ZP] Grenade: Holy Bom 1.0 | 2019 xUnicorn (t3rkec zp_grenade_holy debug
[ 43] [ZP] Weapon: Lightning 1.1 xUnicorn (t3rkec zp_weapon_jetgu debug
( 38) Load fails: Plugin file open error (plugin "zp_lasermine_perfect.amxx")
43 plugins, 42 running
Amxx Модули
Код:
Ham Sandwich 1.9.0.5262 AMX Mod X Dev Team running
CSX 1.9.0.5262 AMX Mod X Dev Team running
SxGeo 2.2 s1lent running
Engine 1.9.0.5262 AMX Mod X Dev Team running
FakeMeta 1.9.0.5262 AMX Mod X Dev Team running
CStrike 1.9.0.5262 AMX Mod X Dev Team running
Fun 1.9.0.5262 AMX Mod X Dev Team running
MySQL 1.9.0.5262 AMX Mod X Dev Team running
ReAPI 5.19.0.210 Asmodai & s1lent running
Ошибка
Код:
[zp_buymenu_level.amxx] SQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `bm_level_system`.`SteamID` = 'STEAM_5:0:67******'' at line 1)
/DELETE
 
Последнее редактирование:

cpCTRL

bruh
Скриптер
Постоялец
Регистрация
20 Фев 2018
Сообщения
263
Симпатии
65
Пол
Мужской
Код:
    formatex( g_szQuery, charsmax( g_szQuery ), "UPDATE `%s` SET `Level` = '%d', `Exp` = '%d' WHERE `%s`.`SteamID` = '%s';", g_iUserData[ iPlayer ][ Level ], g_iUserData[ iPlayer ][ Exp ], SQL_TABLENAME, g_szUserSteamID[ iPlayer ] );
    SQL_ThreadQuery( g_hDBTuple, "SQL_ThreadQueryHandler", g_szQuery );
в первом аргументе должно быть название БД, код из client_disconnected.
Посмотри в EV_RoundStart
 

VolodyaMEGAlodon

Пользователь
Регистрация
3 Янв 2021
Сообщения
9
Симпатии
1
Код:
    formatex( g_szQuery, charsmax( g_szQuery ), "UPDATE `%s` SET `Level` = '%d', `Exp` = '%d' WHERE `%s`.`SteamID` = '%s';", g_iUserData[ iPlayer ][ Level ], g_iUserData[ iPlayer ][ Exp ], SQL_TABLENAME, g_szUserSteamID[ iPlayer ] );
    SQL_ThreadQuery( g_hDBTuple, "SQL_ThreadQueryHandler", g_szQuery );
в первом аргументе должно быть название БД, код из client_disconnected.
Посмотри в EV_RoundStart
Я просто совсем не секу в этом, не понимаю куда что вписывать(
Код:
    formatex( g_szQuery, charsmax( g_szQuery ), "UPDATE `%s` SET `Level` = '%d', `Exp` = '%d' WHERE `%s`.`SteamID` = '%s';", g_iUserData[ iPlayer ][ Level ], g_iUserData[ iPlayer ][ Exp ], SQL_TABLENAME, g_szUserSteamID[ iPlayer ] );
    SQL_ThreadQuery( g_hDBTuple, "SQL_ThreadQueryHandler", g_szQuery );
в первом аргументе должно быть название БД, код из client_disconnected.
Посмотри в EV_RoundStart
Можешь немного подробнее описать что и куда?
 
Последнее редактирование:

VolodyaMEGAlodon

Пользователь
Регистрация
3 Янв 2021
Сообщения
9
Симпатии
1
Код:
    formatex( g_szQuery, charsmax( g_szQuery ), "UPDATE `%s` SET `Level` = '%d', `Exp` = '%d' WHERE `%s`.`SteamID` = '%s';", g_iUserData[ iPlayer ][ Level ], g_iUserData[ iPlayer ][ Exp ], SQL_TABLENAME, g_szUserSteamID[ iPlayer ] );
    SQL_ThreadQuery( g_hDBTuple, "SQL_ThreadQueryHandler", g_szQuery );
в первом аргументе должно быть название БД, код из client_disconnected.
Посмотри в EV_RoundStart
Так?)
Код:
formatex( SQL_DATABASE, charsmax( g_szQuery ), "UPDATE `%s` SET `Level` = '%d', `Exp` = '%d' WHERE `%s`.`SteamID` = '%s';", g_iUserData[ iPlayer ][ Level ], g_iUserData[ iPlayer ][ Exp ], SQL_TABLENAME, g_szUserSteamID[ iPlayer ] );
SQL_ThreadQuery( g_hDBTuple, "SQL_ThreadQueryHandler", g_szQuery );
 

VolodyaMEGAlodon

Пользователь
Регистрация
3 Янв 2021
Сообщения
9
Симпатии
1
Все равно ошибки вылезают:
  • [zp_buymenu_level.amxx] SQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `bm_level_system`.`SteamID` = 'STEAM_5:0:676820627'' at line 1)

  • [MySQL] Function not found: 06270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270627062706270L 01/06/2021 - 14:23:07: [AMXX] Displaying debug trace (plugin "zp_buymenu_level.amxx", version "1.1")
    L 01/06/2021 - 14:23:07: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
    L 01/06/2021 - 14:23:07: [AMXX] [0] zp_buymenu_level.sma::client_disconnected (line 367)
вот так сделал
 

Вложения

cpCTRL

bruh
Скриптер
Постоялец
Регистрация
20 Фев 2018
Сообщения
263
Симпатии
65
Пол
Мужской
VolodyaMEGAlodon,
Код:
formatex(g_szQuery, charsmax( g_szQuery ), "UPDATE `%s` SET `Level` = '%d', `Exp` = '%d' WHERE `%s`.`SteamID` = '%s';", SQL_TABLENAME, g_iUserData[ iPlayer ][ Level ], g_iUserData[ iPlayer ][ Exp ], SQL_TABLENAME, g_szUserSteamID[ iPlayer ] );
 
Сверху Снизу