Modules/MTA-MySQL: Difference between revisions
m (<module src="mta_mysql.dll" /> FIXED INTO: <module src="../mta_mysql.dll" />) |
m (The mistake is in another part. Maybe the directory for mta_mysql.dll should be in server/modules) |
||
| Line 18: | Line 18: | ||
Then, add the following line in mtaserver.conf: | Then, add the following line in mtaserver.conf: | ||
<syntaxhighlight lang="xml"> | <syntaxhighlight lang="xml"> | ||
<module src=" | <module src="mta_mysql.dll" /> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| Line 26: | Line 26: | ||
Then, add the following line in mtaserver.conf: | Then, add the following line in mtaserver.conf: | ||
<syntaxhighlight lang="xml"> | <syntaxhighlight lang="xml"> | ||
<module src=" | <module src="mta_mysql.so" /> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 17:51, 13 January 2010
| Module info | |
| Name | MTA MySQL |
| Version | 0.41 |
| Author | Alberto Alonso (ryden) |
| Module website | Not available |
| Download link | Here |
| License | BSD |
| Written in | {{{written_in}}} |
| Operating system | {{{operating_system}}} |
| Compatible with | {{{compatible_with}}} |
MTA MySQL is an alternative to the default ml_mysql module provided by the MTA team. It is available for Windows and GNU/Linux and provides the source code.
Note: From version 0.4 it supports both DP2.3 and 1.0 servers.
Installation
Windows
Uncompress the file mta_mysql.dll into your C:\Program files\MTA San Andreas\server\mods\deathmatch\modules\ directory and the file libmysql.dll into your C:\Program files\MTA San Andreas\server\ directory.
Then, add the following line in mtaserver.conf:
<module src="mta_mysql.dll" />
GNU/Linux
Uncompress the file mta_mysql.so in the mods/deathmatch/modules/ directory.
Then, add the following line in mtaserver.conf:
<module src="mta_mysql.so" />
If you experience an error on Unix systems: Try to add port and socket parameters to your mysql_connect.
Linux 1.0.3+ servers
It appears that the current version does not work with the 1.0.3 linux servers, a recompiled MTA-MySQL.so is available for download here: http://forum.multitheftauto.com/download/file.php?id=217
Handler functions
- mysql_connect
- mysql_close
- mysql_errno
- mysql_error
- mysql_ping
- mysql_select_db
- mysql_escape_string
- mysql_affected_rows
- mysql_change_user
- mysql_get_character_set_info
- mysql_get_client_info
- mysql_get_client_version
- mysql_get_host_info
- mysql_get_proto_info
- mysql_get_server_info
- mysql_get_server_version
- mysql_hex_string
- mysql_info
- mysql_insert_id
- mysql_query
- mysql_unbuffered_query
- mysql_set_character_set
- mysql_stat
- mysql_warning_count