[Plugin] [REL] MySQL Plugin (Now on github!)

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

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

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.
Reply

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

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?
Reply

This function is not defined samp_mysql_select_db
Reply

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_*.
Reply

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)
		{
Reply

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.
Reply

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

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

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.
Reply

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?
Reply

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
-------------------------------------

Reply

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.
Reply

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

Reply

Programie, you're wrong.

Код:
mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS);
mysql_select_db(MYSQL_DB);
Reply

then what needs to be?
Reply

It's this function:
Код:
mysql_connect(const host[],const user[],const database[],const password[])
Don't mix this plugin with other one
Reply

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!
Reply


Forum Jump:


Users browsing this thread: 16 Guest(s)