xampp problem

[Mimimiguel]

hello!

well, I have sreached over the whole web and I still can't make my mysql database work for mta, I have xampp installed, with the apache and the mysql servers running and the mta module loaded.

so I don't know what to do, have I to insert anything in the meta.xml file or something like that?

thanks

EDIT: also configured the mtaserver.conf

DEBUGSCRIPT ->error: attempt to call global 'mysql_connect' (a nil value)

attempt to call global 'mysql_query' (a nil value) x2

Edited April 25, 2011 by Guest

[bandi94]

you want to make a MTA server ?

[Mimimiguel]

Yes

[Zango]

Please post the contents of mtaserver.conf

[Mimimiguel]

<!-- This parameter specifies the name the server will be visible as in the ingame server browser  
         and on Game-Monitor. It is a required parameter. --> 
    <servername>its name</servername> 
     
    <!-- ONLY USE THIS PARAMETER IF YOU ARE SURE OF WHAT YOU ARE DOING - it is generally only 
         needed for professional servers and should be left blank otherwise. 
         This parameter specifies the IP to use for servers that have multiple IP addresses. If left 
         blank, it will default to server's standard local IP address. --> 
    <serverip></serverip> 
     
    <!-- This parameter specifies the Maximum Transmission Unit or maximum packet size that the server 
         will use. This will depend on the nature of your clients, as well as the network medium your 
         server is connected to. --> 
    <mtusize>1264</mtusize> 
  
    <!-- This parameter specifies the UDP port on which the server will be accepting incoming player 
         connections; default value: 22003. It is a required parameter. --> 
    <serverport>22003</serverport>  
     
    <!-- This parameter specifies the number of maximum player slots available on the server; default 
         value: 32. It is a required parameter. --> 
    <maxplayers>6</maxplayers> 
     
    <!-- This parameter specifies whether the builtin http server will be used. 
         Values: 0 - disabled , 1 - enabled ; default value: 1. Optional parameter. --> 
    <httpserver>1</httpserver> 
     
    <!-- This parameter specifies the TCP port on which the server will be accepting incoming http 
         connections. It can be set to the same value as <serverport> 
 
. It is a required parameter 
         if <httpserver> is set to 1. --> 
    <httpport>22005</httpport> 
     
    <!-- If set, this parameter specifies the external URL from which clients will be able to download 
         needed resources ingame. Otherwise they will download them directly from the server. --> 
    <httpdownloadurl></httpdownloadurl> 
  
    <!-- This parameter specifies whether the client files for hosting on an external web server should be 
         automatically copied into mods/deathmatch/resource-cache/http-client-files/ 
         Only relevant if <httpdownloadurl> 
 
 is set. 
         Values: 0 - disabled , 1 - enabled ; default value: 1. Optional parameter. --> 
    <httpautoclientfiles>1</httpautoclientfiles> 
     
    <!-- This parameter limits the number of http connections each client can make. If you are using 
         an external Apache web server, a lower figure such as 8 may be required to avoid download timeouts. 
         A streamlined web server such as lighttpd, would benefit from the maximum setting of 32. 
         (Note: If set to less than 32, pre 1.0.3 clients will be diverted to use MTA's inbuilt web server) 
         Available range: 2 to 32. --> 
    <httpconnectionsperclient>32</httpconnectionsperclient> 
  
    <!-- This parameter specifies what types of checks the clients should make to ensure there has 
         been no tampering with certain settings. 
         Values: 0 - disabled , -1 - everything. default value: -1. --> 
    <verifyclientsettings>-1</verifyclientsettings> 
  
    <!-- Comma seperated list of disabled anti-cheats. 
         e.g. To disable anti-cheat #2 and #3, use: 2,3 --> 
    <disableac></disableac> 
  
    <!-- Minimum client version. Clients with a lower version will not be allowed to connect. After 
         disconnection, clients will be given an opportunity to download an update (if their client 
         supports auto-update). 
         If left blank, this setting is disabled and there are no restrictions on who can connect. 
         Version numbers look like this: 1.0.4-9.01746.0 --> 
    <minclientversion></minclientversion> 
  
    <!-- Recommended client version. When connecting, if clients have a lower version, they will be given 
         the option to download an update (if their client supports auto-update). 
         If left blank, this setting is disabled. --> 
    <recommendedclientversion></recommendedclientversion> 
  
    <!-- This parameter can be used to make the server report to Game-Monitor master servers, allowing it to 
         be visible in the ingame server browser. An additional UDP port needs to be available for this to 
         work (value from <serverport> 
 
 + 123 , so on a default <serverport> value 22003 the right port 
         will be 22126 ). Available values: 0 - disabled , 1 - enabled. Optional parameter, defaults to 0. --> 
    <ase>1</ase> 
  
    <!-- This parameter allows you to disable LAN broadcasting. -->  
    <donotbroadcastlan>0</donotbroadcastlan> 
  
    <!-- If set, players will have to provide a password specified below, before they can connect to the 
         server. If left blank, server doesn't require a password from them. --> 
    <password>******</password>  
     
    <!-- Specifies the location and name of the main server log file. If left blank, server won't be saving this file. --> 
    <logfile>logs/server.log</logfile> 
  
    <!-- As well as the main log file, login successes and failures are logged here for easy reviewing of security issues. 
         If left blank, this file is not used --> 
    <authfile>logs/server_auth.log</authfile> 
     
    <!-- This parameter specifies the location and name of the Access Control List settings file. If left 
         blank, server will use acl.xml file, located in the same folder as this configuration file. --> 
    <acl>acl.xml</acl>  
  
    <!-- Specifies the location and name of the debugscript log file. If left blank, server won't be saving this file. --> 
    <scriptdebuglogfile>logs/scripts.log</scriptdebuglogfile>  
     
    <!-- Specifies the level of the debugscript log file. Available values: 0, 1, 2, 3. When not set, defaults to 0. --> 
    <scriptdebugloglevel>0</scriptdebugloglevel> 
     
    <!-- Specifies the level of the html debug. Available values: 0, 1, 2, 3. When not set, defaults to 0. --> 
    <htmldebuglevel>0</htmldebuglevel> 
  
    <!-- Specifies the server frames limit. Minimum value: 25, default: 36. --> 
    <fpslimit>45</fpslimit> 
  
    <!-- Specifies the module(s) which are loaded with the server. To load several modules, add more <module> 
 
  
         parameter(s). Optional parameter. --> 
         <module src="mta_mysql.dll" /> 
    <!-- <module src="sample_win32.dll"/> 
 
 --> 
    <!-- <module src="sample_linux.so"/> 
 
 --> 
     
    <!-- Specifies resources that are loaded when the server starts and/or which are protected from being stopped. 
         To specify several resources, add more <resource> 
 
 parameter(s). --> 
  
    <resource src="admin" startup="1" protected="0"/> 
    <resource src="helpmanager" startup="1" protected="0"/> 
    <resource src="joinquit" startup="1" protected="0"/> 
    <resource src="defaultstats" startup="1" protected="0"/> 
    <resource src="mapcycler" startup="1" protected="0"/> 
    <resource src="mapmanager" startup="1" protected="0"/> 
    <resource src="parachute" startup="1" protected="0"/> 
    <resource src="resourcebrowser" startup="1" protected="1" default="true"/> 
    <resource src="resourcemanager" startup="1" protected="1"/> 
    <resource src="scoreboard" startup="1" protected="0"/> 
    <resource src="spawnmanager" startup="1" protected="0"/> 
    <resource src="votemanager" startup="1" protected="0"/> 
    <resource src="webadmin" startup="1" protected="0"/> 
     
     
    <!-- play is the default freeroam gamemode. Remove the following line to prevent it from starting. -->        
    <resource src="race" startup="1" protected="0"/> 

[bandi94]

search on youtube mta serer tutorial are 1000 of tutorials the hardes part is if you have a router you need to port forward your modem and router if you don"t have a router port forward only the modem (not need in every case) you don't need mysql database its only hardes to work whit mysql database you can test your router and modem port when you start the mta server in the black (like a cmd) window write openports and after 30 sec you will see 3 ports and need to write port... open if are closed other players cant connect to your serer another port cant download and 3 port cant browse your server on server browser (they will not see your server)

[Zango]

I believe you need the libmysql.dll module for mta_mysql.dll to work (place it in modules and add it onto mtaserver.conf)

[Cadu12]

https://wiki.multitheftauto.com/wiki/Mod ... QL#Windows

I did read at all, you need create one folder "modules" in your deathmatch(server)

Im agree Zango, needed libmysql.dll

[Mimimiguel]

Ok i'll look at it, thanks