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

Thank you, but I know.

But I can see only the source download.

Screenshot:

http://image.noelshack.com/fichiers/...7-download.png
Reply

The download was removed due to critical bugs.
Please wait for R36.
Reply

Okay, thank you !

Should I go back to R34 ? Cause I've the R35 files but I need mysql_static.so
Reply

Yes, you should use R34 until R36 is available. I think R36 will be ready within a week.
Reply

Is the connectionhandle needed in R34? or do you need one. Just switched from R6 to this.
Reply

Thank you so much maddinat0r. Updating to R36 right away.
Reply

I had many problems and errors with libmysqlclient but this here is very new to me:

Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)

BTW: I just wanted to compile it on my own but there is no boost library so the compiling failed.
Edit: Nevermind on boost library, I read the instructions on github.
Reply

EDIT: I had wrong configuration (for VPS instead of localhost) and GameModeExit function made the server "freeze".

Thanks for the update, I'll test it on the VPS (Linux) tomorrow!
Reply

Quote:

I'm sure this release is much stabler than R36 (mainly because it was successfully tested by half a dozen people before releasing it).

than R35* :P

Quote:
Originally Posted by ThomasTailor93
Посмотреть сообщение
I had many problems and errors with libmysqlclient but this here is very new to me:

Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)

BTW: I just wanted to compile it on my own but there is no boost library so the compiling failed.
Edit: Nevermind on boost library, I read the instructions on github.
Just try to use the static version.

Another great release, thanks !
Reply

I'm updating some old gamemode, and I have situation like this:
pawn Код:
new
    LevelOfMudkipLikeness[MAX_PLAYERS char] = { 0, ... };

public OnPlayerConnect(playerid)
{
    inline DatHandler()
    {
        if(cache_num_rows()) {
            LevelOfMudkipLikeness{playerid} = cache_get_row_int(0, 0, handle);
        }
    }
    mysql_tquery_inline(handle, "SELECT mudkipzlove FROM foobar WHERE 1 = 1", using inline DatHandler, "");
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    if(LevelOfMudkipLikeness{playerid} > 69) {
        //do something
    }
    return 1;
}
I can't do anything about the callback structure. I must have the variable ready in OPRC. Now, often the query isn't finished before OnPlayerRequestClass, so the condition fails, even though player likes mudkipz. How can I make sure that the query was executed? I have few propositions:
1. Unthreaded query. Though, I'm afraid of server choking on that
2. While loop in OPRC, waiting for some another variable like "queryfinished" - again, server choking hazard
3. mysql_unprocessed_queries, but the information is too vague, and some other query might be running

Suggestions are very welcome

@down: ah, that's what I meant to write in 1, thanks
Reply

@Misiur
What about sending a unthreaded query using mysql_query?
Reply

orm_select in R36 don't work fine when MySQL returned an empty result!

Quote:

[08/02/2014 12:28:46] [debug] Server crashed due to an unknown error
[08/02/2014 12:28:50] [debug] Native backtrace:
[08/02/2014 12:28:50] [debug] #0 100019bc in ?? () from plugins\mysql.dll
[08/02/2014 12:28:50] [debug] #1 004690a6 in ?? () from samp-server.exe


--------------------------

SA-MP Server: 0.3x-R2



Exception At Address: 0xFF006AEC Module: (Unknown)



Registers:

EAX: 0x00000000 EBX: 0x0015CE60 ECX: 0x00158F80 EDX: 0x00000000

ESI: 0xFFFFFFFF EDI: 0x02A09858 EBP: 0x8B55FF8B ESP: 0x7C80244E

EFLAGS: 0x00010246



Stack:

+0000: 0x4BE80875 0x5DFFFFFF 0x900004C2 0x90909090

+0010: 0xFFFF9090 0x0000FFFF 0x24360000 0x90907C80

+0020: 0x90909090 0x90909090 0x90909090 0x90909090

+0030: 0xFF8B9090 0x8BEC8B55 0xF8830C45 0xFB840FFF

+0040: 0xB900006E 0x00002710 0x4D8BE1F7 0xF7018908

+0050: 0x045189D8 0xF700D283 0x890189DA 0xC18B0451

+0060: 0x0008C25D 0x90909090 0x55FF8B90 0x006AEC8B

+0070: 0xFF0875FF 0x8014BC15 0x0FC0857C 0x01089A8C

+0080: 0x40C03300 0x0004C25D 0x839A9068 0x00A1647C

+0090: 0x50000000 0x1024448B 0x10246C89 0x10246C8D

+00A0: 0x5653E02B 0xF8458B57 0x50E86589 0xC7FC458B

+00B0: 0xFFFFFC45 0x4589FFFF 0xF0458DF8 0x0000A364

+00C0: 0x8BC30000 0x8964F04D 0x0000000D 0x5E5F5900

+00D0: 0xC351C95B 0x90909090 0x90909090 0x90909090

+00E0: 0xFF8B9090 0x6AEC8B55 0x0C75FF00 0xE80875FF

+00F0: 0x0000000E 0x0008C25D 0x90909090 0x90909090

+0100: 0x346A9090 0x80260868 0xFF7AE87C 0x45C7FFFF

+0110: 0x000014BC 0xC045C700 0x00000001 0x7D8DC033

+0120: 0xABABABC4 0x8D57FF33 0xFF50BC45 0x80124815

+0130: 0xFC7D897C 0x0018A164 0x45890000 0x30408BDC

Reply

Quote:
Originally Posted by CKA3KuH
Посмотреть сообщение
orm_select in R36 don't work fine when MySQL returned an empty result!
Thanks for reporting, I made a pretty simple and stupid mistake. I released R36-2 with an fix.
Reply

Is R36 stable? I heard somewhere that the latest stable version is R33.
Reply

r36 and r34 are stable, don't use r35. r35 should be scrapped as a release tbh.
Reply

Quote:
Originally Posted by Mandrakke
Посмотреть сообщение
Is R36 stable? I heard somewhere that the latest stable version is R33.
We tested it and we thing that it is stable, give it a try !
Reply

Quote:
Originally Posted by Kar
Посмотреть сообщение
[...]r35 should be scrapped as a release tbh.
The only reason I haven't done this is because of the confusion. People would start wondering why there is a missing revision (R31 -> R32 -> R33 -> R34 -> R36; where's R35?!). I also reacted too slow, so I only removed the download links to the compiled binaries.
Reply

Quote:
Originally Posted by maddinat0r
Посмотреть сообщение
The only reason I haven't done this is because of the confusion. People would start wondering why there is a missing revision (R31 -> R32 -> R33 -> R34 -> R36; where's R35?!). I also reacted too slow, so I only removed the download links to the compiled binaries.
Doesn't matter, R35's changelog should be linked with r36 or something or redirected with an explaination
Reply

Quote:
Originally Posted by Kar
Посмотреть сообщение
Doesn't matter, R35's changelog should be linked with r36 or something or redirected with an explaination
There's no need for this, you can just see R35's and R36's changelog here: https://github.com/pBlueG/SA-MP-MySQL/releases
Reply

Tried prebuilt R37, and now hand compiled master branch, so R37 + 1 commit.
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)