[IstuntmanI]

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.

[Kr[A]z]

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.

[Lightning[SV]]

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

[D_Malfoy]

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

[D_Malfoy]

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)

[steki.]

Is there an way to execute stored procedures?

[Kar]

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

[wups]

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.

[Hiddos]

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?

[wups]

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); } 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.

Anyone?

[AndreT]

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.

[steki.]

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

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

[Emmet_]

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

[BrandyPenguin]

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

[Kar]

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

[Anthony ©]

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.

[BlueFire_]

OMG Great myspl in samp. I love it

[denNorske]

Код:

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

What does that mean? i am unfamiliar with mysql.

[tsonn1]

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++;
        }
    }