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

[Plugin] [REL] MySQL Plugin (Now on github!) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128

Re: [REL] MySQL Plugin (R7 released) - IstuntmanI - 08.08.2012

Quote:

Originally Posted by Sanady

Please stop insulting me!

You insulted first, an awesome work.

MySQL R7 is the best released, it is the fastest (cache), but few bugs left, almost all fixed on R7-2. So shut up. If you don't understand something you don't have to say that that thing is shit.

Re: [REL] MySQL Plugin (R7 released) - Kr[A]z - 11.08.2012

Hello. Please a link to the file libmysqlclient.so.16

Quote:

[13:33:54] Loaded.
[13:33:54] Loading plugin: libmysqlclient.so.16
[13:33:54] Failed (plugins/libmysqlclient.so.16: cannot open shared object file: No such file or directory)
[13:33:54] Loaded 2 plugins.

Re: [REL] MySQL Plugin (R7 released) - Lightning[SV] - 11.08.2012

Quote:

Originally Posted by Kr[A]z

Hello. Please a link to the file libmysqlclient.so.16

Debian 6 guide here: http://forum.sa-mp.com/showthread.ph...66#post1741866

Re: [REL] MySQL Plugin (R7 released) - D_Malfoy - 11.08.2012

Sorry of it was stated already,but is it possible to get R7. For centos?

Re: [REL] MySQL Plugin (R7 released) - D_Malfoy - 11.08.2012

Quote:

Originally Posted by D_Malfoy

Sorry of it was stated already,but is it possible to get R7. For centos?

nvm this worked AndreT compiled version - http://www.sf-se.net/dev/mysql-r7_2-zeexfix.so .. (tested on CentOS)

Re: [REL] MySQL Plugin (R7 released) - steki. - 13.08.2012

Is there an way to execute stored procedures?

Re: [REL] MySQL Plugin (R7 released) - Kar - 13.08.2012

On windows I'm getting alot of 'bad heap releases' from the latest crashdetect..

Re: [REL] MySQL Plugin (R7 released) - wups - 13.08.2012

Quote:

[13 16:14:18]Error id 2013: Lost connection to MySQL server during query('SELECT 1 FROM `Account` WHERE `Xp`>0 AND `IP`='SOME_IP_HERE'')

I get a few of this errors everyday.
In R6, I could fix it using this:

pawn Code:

public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
    if(errorid==CR_SERVER_LOST) mysql_query(query);
}

But now, in R7, I can't, because there are additional parameters, that I can't get with this callback(like playerid).
Any ideas on how to fix this?

Note: I have mutex disabled, because I think it caused some random crashes earlier.
Note2: I connect to mysql using the external IP, not 127.0.0.1. That way, I can test my gamemode on my local pc.

Re: [REL] MySQL Plugin (R7 released) - Hiddos - 13.08.2012

So right know I've got this code:

pawn Code:

new str[128];
format(str, sizeof str, "SELECT player_password FROM players WHERE player_name = '%s' LIMIT 1", p_info[playerid][player_name]);
printf("query: %s", str);
mysql_function_query(mysql_conn, str, true, "mysql_logreg", "is", playerid, inputtext);

This query, however, fails for some odd reason. When I check the logs for the printed string, it gives me the correct data:

Code:

query: SELECT player_password FROM players WHERE player_name = 'krispykreme' LIMIT 1

In the MySQL logs, however, it shows me this:

Code:

Passing query SELECT player_password FROM players WHERE player_name = 'krispykreme' LIMIT 1 | is

I have no idea why it does this. So far, I've noticed that the 'is' part directs back to the format parameter in mysql_function_query.

Could anyone help me out on this one?

Re: [REL] MySQL Plugin (R7 released) - wups - 16.08.2012

Quote:

Originally Posted by wups

I get a few of this errors everyday.
In R6, I could fix it using this:

pawn Code:

public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
    if(errorid==CR_SERVER_LOST) mysql_query(query);
}

Anyone?

Re: [REL] MySQL Plugin (R7 released) - AndreT - 04.10.2012

Quote:

Originally Posted by ScriptWriter

Good job, BlueG. But who's faster cache_get_row or cache_get_field?

These functions don't do the same thing. cache_get_field is to get the name of the field with the given index.

However if you meant cache_get_field_content in comparison to cache_get_row, the latter is faster. And the more fields in the result set, the slower cache_get_field_content will get.

cache_get_row operations:
1. get the field value from the specified row from the specified field
2. return it to the PAWN vm

cache_get_field_content operations
1. search among field names in the result set and compare the field name to what the scripter entered
2. get the field value from the found row
3. return it to the PAWN vm

I wrote about it in my tutorial topic a bit as well: click.

Re: [REL] MySQL Plugin (R7 released) - steki. - 09.10.2012

Would it be possible to get this working with procedures/mysql_multi_query?

Re: [REL] MySQL Plugin (R7 released) - Gamer_007 - 14.10.2012

Код:

[11:23:38]   Loaded 3 filterscripts.

[11:23:38]    Error: Function not registered: 'mysql_debug'
[11:23:38]    Error: Function not registered: 'mysql_connect'
[11:23:38]    Error: Function not registered: 'mysql_query'
[11:23:38]    Error: Function not registered: 'mysql_store_result'
[11:23:38]    Error: Function not registered: 'mysql_num_rows'
[11:23:38]    Error: Function not registered: 'mysql_fetch_field_row'
[11:23:38]    Error: Function not registered: 'mysql_free_result'
[11:23:38]    Error: Function not registered: 'mysql_retrieve_row'
[11:23:38]    Error: Function not registered: 'mysql_real_escape_string'
[11:23:38]    Error: Function not registered: 'mysql_fetch_row_format'
[11:23:38] Script[gamemodes/The.amx]: Run time error 19: "File or function is not found"
[11:23:38] Number of vehicle models: 1

How to deal with this??

Re: [REL] MySQL Plugin (R7 released) - Emmet_ - 15.10.2012

Re-download the plugins. Make sure you replace your includes too.

Re: [REL] MySQL Plugin (R7 released) - BrandyPenguin - 15.10.2012

Quote:

Originally Posted by Gamer_007

Код:

[11:23:38]   Loaded 3 filterscripts.

[11:23:38]    Error: Function not registered: 'mysql_debug'
[11:23:38]    Error: Function not registered: 'mysql_connect'
[11:23:38]    Error: Function not registered: 'mysql_query'
[11:23:38]    Error: Function not registered: 'mysql_store_result'
[11:23:38]    Error: Function not registered: 'mysql_num_rows'
[11:23:38]    Error: Function not registered: 'mysql_fetch_field_row'
[11:23:38]    Error: Function not registered: 'mysql_free_result'
[11:23:38]    Error: Function not registered: 'mysql_retrieve_row'
[11:23:38]    Error: Function not registered: 'mysql_real_escape_string'
[11:23:38]    Error: Function not registered: 'mysql_fetch_row_format'
[11:23:38] Script[gamemodes/The.amx]: Run time error 19: "File or function is not found"
[11:23:38] Number of vehicle models: 1

How to deal with this??

plugin version R7? If so you have to make all queryes to threaded queryes

Re: [REL] MySQL Plugin (R7 released) - Kar - 15.10.2012

is anyone willing to work on fixing the crashes associated with this plugin? I mean R7-2 v4 is still bugged and crashes, well apparently theres is a streamer-mysql plugin. IDK if Incognito can fix it, but certainly BlueG doesn't have time and this is affecting alot of servers that use R7+ greatly (well those who didn't make there own edit of the plugin)...

Re: [REL] MySQL Plugin (R7 released) - Anthony © - 16.10.2012

Does anyone know where I can find a guide on how to make a basic usersystem with this? I don't want to use one, but rather-much to look at it and understand how it works. Guides I've searched for are either out-dated or too complex (I have looked at some filterscripts and that's where the complexity is coming from). If you know, send me a PM, cheers.

Re: [REL] MySQL Plugin (R7 released) - BlueFire_ - 17.10.2012

OMG Great myspl in samp. I love it

Re: [REL] MySQL Plugin (R7 released) - denNorske - 18.10.2012

Код:

Failed (plugins/mysql.so: undefined symbol: _Z13stringvprintfPKcPc)

What does that mean? i am unfamiliar with mysql.

Re: [REL] MySQL Plugin (R7 released) - tsonn1 - 19.10.2012

How can I replace mysql_strtok?
I'm a beginner at MySQL.

Anyway, here's the code:

pawn Код:

public OnPlayerLogin(playerid,password[]) // by Luk0r v1.0
{
    MySQLCheckConnection();
    new tmp2[256];
    new string2[64];
    new str[128];
    new
    string[256]
    ;
    new playername2[MAX_PLAYER_NAME];
    new playernamesplit[3][MAX_PLAYER_NAME];
    GetRPName(playerid, playername2, sizeof(playername2));
    split(playername2, playernamesplit, '_');
    MySQLFetchAcctSingle(KasutajaInfo[playerid][pSQLID], "Password", KasutajaInfo[playerid][pKey]);
    if(!strcmp(KasutajaInfo[playerid][pKey],password, true ) )
    {
        new Data[1024];
        new Field[64];
        new rcnt = 1;
        MySQLFetchAcctRecord(KasutajaInfo[playerid][pSQLID], Data);
        mysql_strtok(Field, "|", Data);
        while (mysql_strtok(Field, "|", "")==1)
        {
            if (rcnt == 3) KasutajaInfo[playerid][pLevel] = strval(Field);
            if (rcnt == 4) KasutajaInfo[playerid][pAdmin] = strval(Field);
                        //A couple more lines...
            rcnt++;
        }
    }