Не берёт данные с БД

Статус
В этой теме нельзя размещать новые ответы.
Сообщения
12
Реакции
-1
Ошибка
L 03/08/2021 - 14:02:24: [MySQL] Invalid database handle: 0
L 03/08/2021 - 14:02:24: [AMXX] Displaying debug trace (plugin "jb_quest_core.amxx", version "1.0")
L 03/08/2021 - 14:02:24: [AMXX] Run time error 10: native error (native "SQL_PrepareQuery")
L 03/08/2021 - 14:02:24: [AMXX] [0] jb_quest_core.sma::func_GetStoreNick (line 6)
ОС
Linux
Amx Mod X
AMX Mod X 1.9.0.5271 (http://www.amxmodx.org)
Authors:
David "BAILOPAN" Anderson, Pavol "PM OnoTo" Marko
Felix "SniperBeamer" Geyer, Jonny "Got His Gun" Bergstrom
Lukasz "SidLuke" Wlasinski, Christian "Basic-Master" Hammacher
Borja "faluco" Ferrer, Scott "DS" Ehlert
Compiled: Jun 24 2020 13:53:30
Built from: https://github.com/alliedmodders/amxmodx/commit/5eea3e5
Build ID: 5271:5eea3e5
Core mode: JIT+ASM32
Билд
Protocol version 48
Exe version 1.1.2.7/Stdio (cstrike)
ReHLDS version: 3.7.0.698-dev
Build date: 10:14:22 Aug 19 2020 (2321)
Build from: https://github.com/dreamstalker/rehlds/commit/376bc15
ReGamedll
ReGameDLL version: 5.18.0.474-dev
Build date: 11:07:34 Jul 16 2020
Build from: https://github.com/s1lentq/ReGameDLL_CS/commit/efb06a7
Версия Metamod
Metamod-r v1.3.0.128, API (5:13)
Metamod-r build: 17:47:54 Aug 24 2018
Metamod-r from: https://github.com/theAsmodai/metamod-r/commit/0cf2f70
Список метамодулей
[ 1] Reunion            RUN   -    reunion_mm_i386.so         v0.1.0.135       ini  Start Never
[ 2] Rechecker RUN - rechecker_mm_i386.so v2.5 ini Chlvl ANY
[ 3] AMX Mod X RUN - amxmodx_mm_i386.so v1.9.0.5271 ini Start ANY
[ 4] Revoice RUN - revoice_mm_i386.so v0.1.0.34 ini Start Never
[ 5] hackdetector RUN - hackdetector_amxx_i386.so v0.15.328.lite pl3 ANY ANY
[ 6] FakeMeta RUN - fakemeta_amxx_i386.so v1.9.0.5271 pl3 ANY ANY
[ 7] MySQL RUN - mysql_amxx_i386.so v1.9.0.5271 pl3 ANY ANY
[ 8] Fun RUN - fun_amxx_i386.so v1.9.0.5271 pl3 ANY ANY
[ 9] Engine RUN - engine_amxx_i386.so v1.9.0.5271 pl3 ANY ANY
[10] Ham Sandwich RUN - hamsandwich_amxx_i386.so v1.9.0.5271 pl3 ANY ANY
[11] ReAPI RUN - reapi_amxx_i386.so v5.15.0.197-dev pl3 ANY Never
[12] CStrike RUN - cstrike_amxx_i386.so v1.9.0.5271 pl3 ANY ANY
[13] FakeServerQueries RUN - fsq_amxx_i386.so v1.0 pl3 ANY ANY
Список плагинов
CenterMsgFix.amxx
fresh_bans.amxx

; AMX Mod X plugins
; Admin Base - Always one has to be activated
admin.amxx ; admin base (required for any admin-related)
;admin_sql.amxx ; admin base - SQL version (comment admin.amxx)

; Basic
admincmd.amxx ; basic admin console commands
multilingual.amxx ; Multi-Lingual management

; Menus
menufront.amxx ; front-end for admin menus
cmdmenu.amxx ; command menu (speech, settings)
plmenu.amxx ; players menu (kick, ban, client cmds.)
;telemenu.amxx ; teleport menu (Fun Module required!)
mapsmenu.amxx ; maps menu (vote, changelevel)
pluginmenu.amxx ; Menus for commands/cvars organized by plugin

scrollmsg.amxx ; displays a scrolling message
imessage.amxx ; displays information messages
adminvote.amxx ; vote commands

; Map related
;nextmap.amxx ; displays next map in mapcycle
;mapchooser.amxx ; allows to vote for next map
;timeleft.amxx ; displays time left on map
mapmanager.amxx debug

; Configuration
pausecfg.amxx ; allows to pause and unpause some plugins


; Custom - Add 3rd party plugins here

jb_quest_core.amxx debug
jb_quest_flowers.amxx debug
jb_quest_girl.amxx debug

jb_mod.amxx debug
jb_nocorps.amxx debug
jb_music.amxx debug
jb_hook.amxx debug
jb_football.amxx debug
jb_3th_cam.amxx debug
jb_shop.amxx debug
jb_hudblock.amxx debug
jb_grab.amxx debug
jb_game_name.amxx debug
jb_gamemode.amxx debug
jb_welcome_sound.amxx debug
jb_knife_kill.amxx debug
jb_vipmenu.amxx debug
jb_rank.amxx debug
jb_demo.amxx debug
jb_advertisment.amxx debug
jb_noclip.amxx debug
jb_roundsound.amxx debug
JailFPS.amxx
potti.amxx debug
jb_hats.amxx debug
jb_chat.amxx debug
fakeonline.amxx
ms_check.amxx
Map_Spawns_Editor.amxx debug
Автор плагина
/7uBko
Версия плагина
1.0
Исходный код
public func_GetStoreNick(pPlayer) {
new bool:AccountError = false
new szName[32]; get_user_name(pPlayer, szName, charsmax(szName))
new Handle:SqlConnection = SQL_Connect(g_SqlTuple, ErrorCode, szSqlError, charsmax(szSqlError))
new szSteamID[32]; get_user_authid(pPlayer, szSteamID, charsmax(szSteamID))
new Handle:Query = SQL_PrepareQuery(SqlConnection, "SELECT `id`, `shilings`, `quest_num`, `quest_progress` FROM `users` WHERE `nick` = '%s';", szName)
if(!SQL_Execute(Query)) {
SQL_QueryError(Query, szSqlError, charsmax(szSqlError))
set_fail_state(szSqlError)
}
if( SQL_NumResults(Query) > 0 ) {
for ( new i = 1; i <= g_bitMaxPlayers; i++ ) {
if ( g_mUserID[i] == SQL_ReadResult(Query, 0) ) {
get_user_name(i, szName, charsmax(szName))
ColorChat(pPlayer, RED, "%s %L", QUEST_PREFIX, pPlayer, "JB_LANG_CHAT_QUEST_ACCOUNT_USE", szName, SQL_ReadResult(Query, 0))
AccountError = true
break
}
}
if ( !AccountError ) {
g_mUserID[pPlayer] = SQL_ReadResult(Query, 0)
g_mUserShilings[pPlayer] = SQL_ReadResult(Query, 1)
g_mUserQuest[pPlayer] = SQL_ReadResult(Query, 2)
func_set_user_quest_progress(pPlayer, SQL_ReadResult(Query, 3))
ColorChat(pPlayer, NORMAL, "%s %L", QUEST_PREFIX, pPlayer, "JB_LANG_CHAT_QUEST_ACCOUNT_ENTER", SQL_ReadResult(Query, 0))
SetBit(g_bitUserEnterAccount, pPlayer)
}
}
else ColorChat(pPlayer, NORMAL, "%s %L", QUEST_PREFIX, pPlayer, "JB_LANG_CHAT_QUEST_ACCOUNT_NOT_FOUND")
SQL_FreeHandle(Query)
SQL_FreeHandle(SqlConnection)
}
На локальном сервере всё работает без проблем, на основном сервере - выдаёт ошибку. Код не менялся, данные для подключения тоже.
8 Мар 2021
Единственная разница - локальный сервер на Windows, основном на Linux
8 Мар 2021
P.s Указал 6-ю строку ошибки, дабы строка соответствовала тому коду, что я приложил
 
Сообщения
2,288
Реакции
1,738
Помог
31 раз(а)
LacosteOne, поля заполнены неверно. Пробуем еще раз используя подсказки
 
Статус
В этой теме нельзя размещать новые ответы.

Пользователи, просматривающие эту тему

Сейчас на форуме нет ни одного пользователя.
Сверху Снизу