[maverape]

I got a error, don't really know how to get over of this shit

Код:

mysql_format(pms, query, "UPDATE playeracc SET playername=%s WHERE id=%d", pNome(playerid), userid[playerid]);
mysql_function_query(pms, query, false, "MySQL_Return", "");

error

Код:

[19:17:46] ProcessQueryThread(MySQL_Return) - Executing query UPDATE playeracc SET playername=Rodolf_Pasqueto WHERE id=1...
[19:17:46] ProcessQueryThread(MySQL_Return) - Error will be triggered to OnQueryError().

I'm pretty sure that I have the playeracc table.

[Reboma]

Quote:

Originally Posted by TheArcher Can you explain me the difference between static and non-static, please? :/

The static version include the libmysqlclient file, ideal for shared hosted servers.

[Hiddos]

Does this plugin still wonderfully crash the entire server when doing a GMX? I liked that function a lot

Edit: Seems it works normal again now

[Mellnik]

I'm providing compiled versions of the latest mysql revisions:
linux, linux-static and windows: http://mellnik.com right side

[kamilot73]

What's wrong with it? -

PHP код:

new mq[64];
   format(mq,sizeof(mq),"SELECT * FROM SRR_usr");
   mysql_function_query(g_ConnectionHandle,mq,false,"","");
   mysql_store_result();
   vsegoplayer = mysql_num_rows();
   mysql_free_result();
  printf("There are - %d players",vsegoplayer); 


[IstuntmanI]

Quote:

Originally Posted by kamilot73 What's wrong with it? - PHP код: new mq[64];    format(mq,sizeof(mq),"SELECT * FROM SRR_usr");    mysql_function_query(g_ConnectionHandle,mq,false,"","");    mysql_store_result();    vsegoplayer = mysql_num_rows();    mysql_free_result();   printf("There are - %d players",vsegoplayer);

From R7 MySQL removed the support for non-threaded queries.

[kamilot73]

Quote:

Originally Posted by costel_nistor96 From R7 MySQL removed the support for non-threaded queries.

Can you help me, I don't know how relise it correctly.

[Lorenc_]

Quote:

Originally Posted by kamilot73 Can you help me, I don't know how relise it correctly.

With the mysql_function_query, you are to do the work in the callback you specify.

pawn Код:

mysql_function_query( dbHandle, Query, true, "OnPlayerSampleSQL", "i", playerid );

forward OnPlayerSampleSQL( playerid ); public OnPlayerSampleSQL( playerid ) {
{
    new
        rows, fields, Field[ 50 ]
    ;
    cache_get_data( rows, fields );
    if( rows )
    {
        cache_get_field_content( 0, "POTATO", Field );
    }
    return 1;
}

Usage of cache, I stole it from an old version of my gamemode with cache. Of course it won't work, just study the functions and make correct usage of them and it should. That is an example!

________________________

Do we have to escape strings in R7 and up?

[steki.]

Quote:

Originally Posted by Lorenc_ Do we have to escape strings in R7 and up?

What do you mean? You always do.

[Falcon.]

when i open the server using MySQL r15 for Windows...

"Could not locate the procedure entry point __ crtCreateSymbolicLinkW in dynamic link library MSVCR110.dll"

some solution ?

[Faskis]

Quote:

Originally Posted by [Y]Falcon when i open the server using MySQL r15 for Windows... "Could not locate the procedure entry point __ crtCreateSymbolicLinkW in dynamic link library MSVCR110.dll" some solution ?

Quote:

Originally Posted by Brendan_Thomson Quote: Originally Posted by Brendan_Thomson I'm getting an error asking for MSVCP110.dll.. I'm running windows 8 which supposedly has the latest .NET framework.. is there something I'm missing? I downloaded the c++ redistrubutable thing also.. spent an hour or two last night googling around trying to find a solution.. to no avail FYI for anyone getting this - download this. http://www.microsoft.com/en-us/downl....aspx?id=30679

Was posted two pages back.

[Maxips2]

Okay I just tested it with different strings, and I think the issue might be with enumerators only.
because this:

pawn Code:

cache_get_row(0, 0, gServerInfo[serverHostname]);

returs null.

However this:

pawn Code:

new 
    str[64];
cache_get_row(0, 0, str);

returns the right string.

Can someone confirm this?

[AndreT]

Maxips2, there's a bug with the sizeof operator and enums used together.

pawn Code:

enum e_TOP_TEN 
{
    FINISH_MS,
    PLAYER_REGID,
    PLAYER_NAME[MAX_PLAYER_NAME]
}
new raceTopTen[10][e_TOP_TEN];

Using this example enumeration, you would expect

pawn Code:

sizeof(raceTopTen[0][PLAYER_NAME])

to return something it is not going to return.

So you'll have to explicitly (as of plugin R8 or something like that) specify the 4th and 5th parameters (connection and sizeof destination) in your cache_get_row_line.

pawn Code:

cache_get_row(0, 0, gServerInfo[serverHostname], 1, 64);
// or...
cache_get_row(0, 0, gServerInfo[serverHostname], .max_len=64);

Source

I was actually thinking of releasing a plugin myself, perhaps called "Simple MySQL plugin" or something due to its stripped down nature (everything except for the cache-related and required functions are removed). Also never have I had to face a crash due to the plugin.

[Maxips2]

Ahh I see... thanks, its finally working properly

[Mellnik]

Problems like this wouldn't occur if they finally release an update for MD arrays ...

[Sgt.TheDarkness]

Anybody have a D/L link to the R8 plugin & includes, For some reason the domain won't resolve for me

Cheers!

[shaPP]

I've just got a problem with MySQL Plugin. It says that i miss some ".dll" files from win32 so i downloaded them and place on system32 folder and now i get this error: "The procedure entry point _crtCreateSymbolicLinkW could not be located in the dynamic link library MSVCR110.dll"
What may i do?

[coolguy]

uhh.. Looks like a nice error over here...

Code:

[05:08:32]   Loaded.
[05:08:32]  Loading plugin: mysql.so
[05:08:32]   Failed (plugins/mysql.so: symbol _ZNSdD2Ev, version GLIBCXX_3.4 not defined in file libstdc++.so.6 with link time reference)
[05:08:32]  Loaded 5 plugins.

[ZackBoolaro]

Dude your links are down.

[Djole1337]

Solved.~~~~~~~~~~