L 02/11/2005 - 20:28:18: [Warcraft 3 Frozen Throne] Error getting handle to game DLL. Natives not available. (file "mp.dll")
L 02/11/2005 - 20:28:18: [AMXX] Module "dbi" required for plugin.  Check modules.ini. (plugin "warcraft3FT.amxx")
L 02/11/2005 - 20:28:18: [AMXX] Plugin uses an unknown function (name "mysql_query") - check your modules.ini. (plugin "admin_log_sql.amxx")

Someone please help me? I first tryid my own setup, then i downloaded the prefixed from war3ft.com for amxmodx and copied and stuff. then i added the mysql_amxx fix for mysql 4.1 that i got at the modules forum..
What is wrong??? PLEASE ASAP

[nightscreem]

so you downloaded the preconfiger download from www.war3ft.com
for mysql there is a guide posted on http://4honor.net/forum/viewtopic.ph...d44221a6002dd4
sry i can't help you with other stuff sry

[manorastroman]

did you enable the right modules?

[L1nuxm4ster]

Can you post your plugins.ini and modules.ini so I we can take a look at it? Also what are you using mysql for? Stats? Admins?

[nightscreem]

i think war3ft stats

; AMX Mod X Modules
; You can specify both linux & win32 modules here
; To enable a module, remove the semi-colon from the line

; ------------------------------
; Fun - provides extra functions
; ------------------------------
fun_amxx_i386.so
fun_amxx.dll
fun_amxx_amd64.so

; ----------------------------------------------------
; Engine - provides engine functions core to Half-Life
; ----------------------------------------------------
engine_amxx_i386.so
engine_amxx.dll
engine_amxx_amd64.so

; ----------------------------------------------------------
; Fakemeta - provides a massive interface into the HL engine
; ----------------------------------------------------------
;fakemeta_amxx_i386.so
;fakemeta_amxx.dll
;fakemeta_amxx_amd64.so

; -------------------------------------------
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
mysql_amxx_i386.so
mysql_amxx.dll
;mysql_amxx_amd64.so
; PostgreSQL
;pgsql_amxx_i386.so
;pgsql_amxx.dll
; Microsoft SQL
;mssql_amxx.dll

; ---------------------------------------------
; GeoIP - determines the country of ip adresses
; ---------------------------------------------
;geoip_amxx_i386.so
;geoip_amxx.dll
;geoip_amxx_amd64.so

; ------------------------------------
; Array - advanced arrays in scripting
; ------------------------------------
;array_amxx_i386.so
;array_amxx.dll
;array_amxx_amd64.so

; --------------------------------
; Sockets - network socket support
; --------------------------------
;sockets_amxx_i386.so
;sockets_amxx.dll
;sockets_amxx_amd64.so

; --------------------------
; Regular Expression support
; --------------------------
;regex_amxx_i386.so
;regex_amxx.dll
;regex_amxx_amd64.so

; ----------------------------------------------------------
; Counter-Strike - adds functions specific to Counter-Strike
; ----------------------------------------------------------
cstrike_amxx_i386.so
cstrike_amxx.dll
cstrike_amxx_amd64.so

; -----------------------------------------------------
; CSX - adds functionality for CS statistics and events
; -----------------------------------------------------
csx_amxx_i386.so
csx_amxx.dll
csx_amxx_amd64.so

; --------------------------------------------------------------
; WAR3FT - adds functions used by war3ft - By Geesu (Pimp Daddy)
; --------------------------------------------------------------
war3ft_amxx_i386.so
war3ft_amxx.dll
war3ft_amxx_amd64.so

and

; 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
adminhelp.amxx		; help command for admin console commands
adminslots.amxx		; slot reservation
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)

; Chat / Messages
adminchat.amxx		; console chat commands
antiflood.amxx		; prevent clients from chat-flooding the server
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

; Configuration
pausecfg.amxx		; allows to pause and unpause some plugins
statscfg.amxx		; allows to manage stats plugins via menu and commands

; Counter-Strike
;restmenu.amxx		; restrict weapons menu
;statsx.amxx		; stats on death or round end (CSX Module required!)
;miscstats.amxx		; bunch of events announcement for Counter-Strike
;stats_logging.amxx	; weapons stats logging (CSX Module required!)


; Custom - Add 3rd party plugins here
warcraft3FT.amxx
Donate.amxx
play_the_piano.amxx
amx_bank.amxx
admin_log_sql.amxx
admin_restartround.amxx
admin_slap_2.amxx
admin_slay_2.amxx
admin_weapon.amxx
amx_blind.amxx

I have fixed the admin_sql.amxx in plugins.ini.. so drop that

now it says this.

L 02/12/2005 - 09:09:08: [Warcraft 3 Frozen Throne] Error getting handle to game DLL. Natives not available. (file "mp.dll")
L 02/12/2005 - 09:09:08: [AMXX] Module "DBI" required for plugin.  Check modules.ini. (plugin "admin_sql.amxx")
L 02/12/2005 - 09:09:08: [AMXX] Module "dbi" required for plugin.  Check modules.ini. (plugin "warcraft3FT.amxx")
L 02/12/2005 - 09:09:08: [AMXX] Plugin uses an unknown function (name "mysql_query") - check your modules.ini. (plugin "admin_log_sql.amxx")

[nightscreem]

what version of warcraft3ft are you using

[L1nuxm4ster]

Ok here is what my modules.ini looks like.

------------------------------
; Fun - provides extra functions
; ------------------------------
fun_amxx_i386.so
fun_amxx.dll
fun_amxx_amd64.so

; ----------------------------------------------------
; Engine - provides engine functions core to Half-Life
; ----------------------------------------------------
engine_amxx_i386.so
;engine_amxx.dll
;engine_amxx_amd64.so

; ----------------------------------------------------------
; Fakemeta - provides a massive interface into the HL engine
; ----------------------------------------------------------
fakemeta_amxx_i386.so
;fakemeta_amxx.dll
;fakemeta_amxx_amd64.so

; -------------------------------------------
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
mysql_amxx_i386.so
;mysql_amxx.dll
;mysql_amxx_amd64.so
; PostgreSQL
;pgsql_amxx_i386.so
;pgsql_amxx.dll
; Microsoft SQL
;mssql_amxx.dll

; ---------------------------------------------
; GeoIP - determines the country of ip adresses
; ---------------------------------------------
;geoip_amxx_i386.so
;geoip_amxx.dll
;geoip_amxx_amd64.so

; ------------------------------------
; Array - advanced arrays in scripting
; ------------------------------------
array_amxx_i386.so
;array_amxx.dll
;array_amxx_amd64.so

; --------------------------------
; Sockets - network socket support
; --------------------------------
;sockets_amxx_i386.so
;sockets_amxx.dll
;sockets_amxx_amd64.so

; --------------------------
; Regular Expression support
; --------------------------
regex_amxx_i386.so
;regex_amxx.dll
;regex_amxx_amd64.so

; ----------------------------------------------------------
; Counter-Strike - adds functions specific to Counter-Strike
; ----------------------------------------------------------
cstrike_amxx_i386.so
;cstrike_amxx.dll
;cstrike_amxx_amd64.so

; -----------------------------------------------------
; CSX - adds functionality for CS statistics and events
; -----------------------------------------------------
csx_amxx_i386.so
;csx_amxx.dll
;csx_amxx_amd64.so
war3ft_amxx.dll


You need to have only one of the mysql_amxx modules loaded. Use the .dll for windows and .so for linux. You can probably use my modules.ini and just add your 3rd party plugins at the end as long as you're using linux. Also make sure that you have the right database name, hostname, username and password on both the sql.cfg and war3ft.cfg files.

Another way to check if it is communicating with your SQL server is to check if the tables have been created in the database.

im using the newest one from their website. im using windows. and there is no tables made( i haven't made a single table if i should do it, but the account has full access it can get to the amx database )