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

[VolodyaMEGAlodon]

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 модули

Спойлер: 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 Модули

Спойлер: 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]

    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]

    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]

    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]

Все равно ошибки вылезают:

• [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]

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 ] );