[APTEM]

And it is possible to write though how with this function to work? And that new functions at all for me.

[agusfn20]

Where can i download the a_mysql.inc with those funcions?

[Sergei]

Quote:

Originally Posted by agusfn20 Where can i download the a_mysql.inc with those funcions?

Bottom of the first post, you have all download links published there.

[agusfn20]

I cant see the download link of a_mysql.inc, please put the url in the reply

[Sergei]

Quote:

Originally Posted by agusfn20 I cant see the download link of a_mysql.inc, please put the url in the reply

You download a package and you get a_mysql.inc inside. What can you do without plugin and only with inc anyway?

[agusfn20]

This function is not defined samp_mysql_select_db

[Sergei]

Quote:

Originally Posted by agusfn20 This function is not defined samp_mysql_select_db

Please, bother to look at functions list ... this plugin has functions like mysql_* not samp_mysql_*.

[APTEM]

I something and shall not understand as from sql to read the information. Write please ready code.

Код:

		new Data[1024];
		new Field[64];
		new rcnt = 1; 
		MySQLFetchAcctRecord(PlayerInfo[playerid][pSQLID], Data);
		samp_mysql_strtok(Field, "|", Data);
		while (samp_mysql_strtok(Field, "|", "")==1)
		{

[Sergei]

Quote:

Originally Posted by APTEM I something and shall not understand as from sql to read the information. Write please ready code. Код: new Data[1024]; new Field[64]; new rcnt = 1; MySQLFetchAcctRecord(PlayerInfo[playerid][pSQLID], Data); samp_mysql_strtok(Field, "|", Data); while (samp_mysql_strtok(Field, "|", "")==1) {

You aren't asking about this plugin, so use right topic which is http://forum.sa-mp.com/index.php?topic=23931.0.

[DaLgakiran]

My website is in different server. How can i connect the database?

[whooper]

Type in the ip of your website or i think you can do domains not sure..

[Sergei]

If mysql server is on the other server than gameserver you can feel nice lag.
And for connection just put a domain which points on that server ot its IP.

[Programie]

I tried to load the plugin but it fails.
My Server is a VPS (Virtual Private Server) with Windows Server 2003 Standard x64 Edition and .NET Framework 2.0 + 3.0.

What can I do?

[silvan]

hi peaple, i tried to work myself on it.. but the problem is that its loading the plugin... but its giving me an error on " File or function is not found. "

please help me


this is my config:

echo Executing Server Config...
plugins mysql
lanmode 0
rcon_password -----
maxplayers 32
port 7777
hostname Malta Role Play
gamemode0 mrp 1
filterscripts adminspec vactions
announce 1
query 1
weburl www.sa-mp.com
anticheat 0
password ----


This is my DB details:

( At the begining of the GM )
#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS "----"
#define MYSQL_DB "sampserver"

( Under OnGameModeInt )
samp_mysql_connect("MYSQL_HOST","MYSQL_USER","MYSQ L_PASS");
samp_mysql_select_db("MYSQL_DB");

please note that fields marked with " ---- " is done that by purpose... ( because can't risk a hack ) tghou thanks for help

This is my server log:
SA:MP Dedicated Server
----------------------
v0.2X, ©2005-2008 SA:MP Team

[00:23:52]
[00:23:52] Server Plugins
[00:23:52] --------------
[00:23:52] Loading plugin: mysql
[00:23:52]

-------------------------------------
MySQL plugin has been loaded
Version: 1.0.3
Initialized on SA:MP Windows 0.2X
-------------------------------------

[00:23:52] Loaded.
[00:23:52] Loaded 1 plugins.

[00:23:52]
[00:23:52] Filter Scripts
[00:23:52] ---------------
[00:23:52] Loading filter script 'adminspec.amx'...
[00:23:52] Loading filter script 'vactions.amx'...
[00:23:52] Loaded 2 filter scripts.

[00:23:52] Script[gamemodes/mrp.amx]: Run time error 19: "File or function is not found"
[00:24:02] --- Server Shutting Down.
[00:24:02]

-------------------------------------
MySQL plugin unloaded
-------------------------------------

[Programie]

I think you have to write variables without quotes.
I mean that:

Код:

samp_mysql_connect("MYSQL_HOST","MYSQL_USER","MYSQL_PASS");
samp_mysql_select_db("MYSQL_DB");

Try that:

Код:

samp_mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS);
samp_mysql_select_db(MYSQL_DB);

Or you have to append .dll to the plugin name in your server.cfg:
plugins mysql.dll


But I'm not shure.

[silvan]

the plugin is readable from the server... so the server.cfg is fine... tghou i removed the " " it still gave me error...

[Balon]

Programie, you're wrong.

Код:

mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS);
mysql_select_db(MYSQL_DB);

[silvan]

then what needs to be?

[Sergei]

It's this function:

Код:

mysql_connect(const host[],const user[],const database[],const password[])

Don't mix this plugin with other one

[Programie]

Oh yes, that was another plugin.
I'm currently using the plugin with "samp_..." (samp_mysql_connect(), ...) cause of it works and this one doesn't work. But I don't know why.
Don't understand it negatively!