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

V

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

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
 
V

VolodyaMEGAlodon

Пользователь
Регистрация
3 Янв 2021
Сообщения
9
Симпатии
1
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
Нажмите для раскрытия...
Я просто совсем не секу в этом, не понимаю куда что вписывать(
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
Нажмите для раскрытия...
Можешь немного подробнее описать что и куда?
 
Последнее редактирование:
V

VolodyaMEGAlodon

Пользователь
Регистрация
3 Янв 2021
Сообщения
9
Симпатии
1
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
Нажмите для раскрытия...
Так?)
Код: 
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 );
 
V

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

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 ] );
 
Войдите или зарегистрируйтесь для ответа.
Сверху Снизу