SAMP-MySQL
Page en Français
SAMP-MySQL is a plugin designed for sa:mp v0.3 wich allows access to a MySQL server.
This plugin is provided freely with sourcecode.
You are free to use it on your own server.
If you are interrested to participate to development or having some suggestions, you can contact the creator directly on the official forum of SA:MP : http://forum.sa-mp.com/index.php?topic=23931.0
Download
This release includes: PAWN .inc file (to be placed in "include" dir in pawno dir) and .pwn example file.
This release includes: Windows .dll file and source.
This release includes: Linux .so file, libmysqlclient.so for Ubuntu and source.
This release includes: Linux .so file, libmysqlclient.so for Centos and source.
Index functions
This function allows you to connect to a database server. This is the first call: it initialize the plugin and etablish the connection.
Entries:
Returns:
Example:
...
samp_mysql_connect("127.0.0.1", "root", "");
...
This function allows you to select the database.
samp_mysql_connect("127.0.0.1", "root", "");
...
Entries:
Returns:
Example:
...
samp_mysql_select_db("test");
...
This function allows you to execute a query: SELECT, INSERT, UPDATE, DELETE, DROP, ALTER,...
samp_mysql_select_db("test");
...
Entries:
Returns:
Example:
...
samp_mysql_query("SELECT * FROM users");
...
This function prepare result to be processed. It must be called only if you made a SELECT query.
samp_mysql_query("SELECT * FROM users");
...
Entries:
Returns
Example:
...
samp_mysql_store_result();
...
This function allows you to get a line of result.
samp_mysql_store_result();
...
Entries:
Returns:
Example:
...
new line[1024];
samp_mysql_fetch_row(line);
...
This function allows you to get a value of a field.
new line[1024];
samp_mysql_fetch_row(line);
...
It must be called after samp_mysql_fetch_row() !
Entries:
Returns:
Example:
...
new line[1024];
new fieldvalue[128];
samp_mysql_fetch_row(line);
samp_mysql_get_field("user_name", field);
printf("%s ", field);
...
This function returns the number of result lines.
new line[1024];
new fieldvalue[128];
samp_mysql_fetch_row(line);
samp_mysql_get_field("user_name", field);
printf("%s ", field);
...
Entries:
Returns:
Example:
...
new num_line;
num_line=samp_mysql_num_rows();
...
This function returns the number of fields in the result.
new num_line;
num_line=samp_mysql_num_rows();
...
Entries:
Returns:
Example:
...
new num_columns;
num_columns=samp_mysql_num_fields();
...
This function allows you to check the connection to the database server and make a re-connection if needed.
new num_columns;
num_columns=samp_mysql_num_fields();
...
Entries:
Returns:
Example:
...
if(samp_mysql_ping()==0)
{
printf("Connection to database is alive ! ");
}
...
if(samp_mysql_ping()==0)
{
printf("Connection to database is alive ! ");
}
...
This function allows you to prepare a string to be passed as a query. This function escapes all special chars to make string suitable to be used by MySQL engine.
Entries:
Returns:
Example:
...
new src[128];
new dest[257];
//put something in src...
samp_mysql_real_escape_string(src, dest);
...
new src[128];
new dest[257];
//put something in src...
samp_mysql_real_escape_string(src, dest);
...
This function allows you to free allocated memory to a query result.
Entries:
Returns:
Example:
...
samp_mysql_free_result();
...
samp_mysql_free_result();
...
This function allows you to split a string as strtok() C function.
Entries:
Returns:
Example:
...
new resultline[1024];
new field[128];
...
samp_mysql_fetch_row(resultline);
samp_mysql_strtok(field, "|", resultline); //first call of strtok MUST contain resultline
printf("%s ", field);
while(samp_mysql_strtok(field, "|", "")==1) //From 2nd call to the end you MUST call strtok without resultline
{
printf("%s ", field);
}
...
new resultline[1024];
new field[128];
...
samp_mysql_fetch_row(resultline);
samp_mysql_strtok(field, "|", resultline); //first call of strtok MUST contain resultline
printf("%s ", field);
while(samp_mysql_strtok(field, "|", "")==1) //From 2nd call to the end you MUST call strtok without resultline
{
printf("%s ", field);
}
...
This function allows you to close the connection to the database server.
Entries:
Returns:
Example:
...
samp_mysql_close();
...
samp_mysql_close();
...