[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 (****** Project) - maverape - 15.02.2013

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.

Re: [REL] MySQL Plugin (****** Project) - Reboma - 17.02.2013

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.

Re: [REL] MySQL Plugin (****** Project) - Hiddos - 17.02.2013

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

AW: [REL] MySQL Plugin (****** Project) - Mellnik - 17.02.2013

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

Re: [REL] MySQL Plugin (****** Project) - kamilot73 - 17.02.2013

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

Re: [REL] MySQL Plugin (****** Project) - IstuntmanI - 17.02.2013

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.

Re: [REL] MySQL Plugin (****** Project) - kamilot73 - 17.02.2013

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.

Re: [REL] MySQL Plugin (****** Project) - Lorenc_ - 18.02.2013

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?

Re: [REL] MySQL Plugin (****** Project) - steki. - 18.02.2013

Quote:

Originally Posted by Lorenc_

Do we have to escape strings in R7 and up?

What do you mean? You always do.

Re: [REL] MySQL Plugin (****** Project) - Falcon. - 18.02.2013

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 ?

Re: [REL] MySQL Plugin (****** Project) - Faskis - 20.02.2013

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.

Re: [REL] MySQL Plugin (****** Project) - Maxips2 - 03.03.2013

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?

Re: [REL] MySQL Plugin (****** Project) - AndreT - 03.03.2013

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.

Re: [REL] MySQL Plugin (****** Project) - Maxips2 - 03.03.2013

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

AW: [REL] MySQL Plugin (****** Project) - Mellnik - 03.03.2013

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

Re: [REL] MySQL Plugin (****** Project) - Sgt.TheDarkness - 03.03.2013

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

Cheers!

Re: [REL] MySQL Plugin (****** Project) - shaPP - 04.03.2013

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?

Re: [REL] MySQL Plugin (****** Project) - coolguy - 05.03.2013

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.

Re: [REL] MySQL Plugin (****** Project) - ZackBoolaro - 05.03.2013

Dude your links are down.

Re: [REL] MySQL Plugin (****** Project) - Djole1337 - 05.03.2013

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