[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 - 25/02/12) - TheArcher - 25.02.2012

Quote:

Originally Posted by Calgon

The source code for R7 has been available for a while, it has only just been compiled for Windows and with a bug fix that was reported.

It took too much longer for 1 bug fix don't you think?

Re: [REL] MySQL Plugin (R7 - 25/02/12) - JernejL - 26.02.2012

Quote:

Originally Posted by T0pAz

I cannot show you my way because it's very different and it's untested. But really, I'm not that what you think I am. Again thanks for the example.

Then why even mention you have something better that you don't even wish to share? this my code & concept has been tested and running properly on the server with minimal changes for over 2 years.

Re: [REL] MySQL Plugin (R7 - 25/02/12) - Luis- - 27.02.2012

I'm struggling to get the login and registering working now. I'll try my best to fix it myself!

Re: [REL] MySQL Plugin (R7 - 25/02/12) - qweasd - 29.02.2012

Hello. I have Debian 6 installed. When I start the server, following messages show up:

Quote:

[22:57:12] Error: Function not registered: 'SSCANF_Init'
[22:57:12] Error: Function not registered: 'SSCANF_Join'
[22:57:12] Error: Function not registered: 'SSCANF_Leave'
[22:57:12] Error: Function not registered: 'Streamer_RegisterInterface'
[22:57:12] Error: Function not registered: 'Streamer_AddPlayer'
[22:57:12] Error: Function not registered: 'Streamer_RemovePlayer'
[22:57:12] Error: Function not registered: 'Streamer_VerifyPickup'
[22:57:12] Error: Function not registered: 'Streamer_VerifyCheckpoint'
[22:57:12] Error: Function not registered: 'mysql_debug'
[22:57:12] Error: Function not registered: 'mysql_connect'
[22:57:12] Error: Function not registered: 'mysql_ping'
[22:57:12] Error: Function not registered: 'mysql_query'
[22:57:12] Error: Function not registered: 'mysql_close'
[22:57:12] Error: Function not registered: 'mysql_store_result'
[22:57:12] Error: Function not registered: 'sscanf'
[22:57:12] Error: Function not registered: 'mysql_num_rows'
[22:57:12] Error: Function not registered: 'mysql_fetch_row_format'
[22:57:12] Error: Function not registered: 'mysql_free_result'
[22:57:12] Error: Function not registered: 'mysql_real_escape_string'
[22:57:12] Error: Function not registered: 'mysql_insert_id'
[22:57:12] Error: Function not registered: 'GetGVarFloat'
[22:57:12] Error: Function not registered: 'GetGVarInt'
[22:57:12] Error: Function not registered: 'SetGVarInt'
[22:57:12] Error: Function not registered: 'SetGVarString'
[22:57:12] Error: Function not registered: 'SetGVarFloat'
[22:57:12] Error: Function not registered: 'GetGVarString'
[22:57:12] Error: Function not registered: 'DeleteGVar'
[22:57:12] Error: Function not registered: 'mysql_retrieve_row'
[22:57:12] Error: Function not registered: 'CreateDynamic3DTextLabel'
[22:57:12] Error: Function not registered: 'UpdateDynamic3DTextLabelText'
[22:57:12] Error: Function not registered: 'DestroyDynamic3DTextLabel'
[22:57:12] Error: Function not registered: 'CreateDynamicObject'
[22:57:12] Error: Function not registered: 'GetDynamicObjectPos'
[22:57:12] Error: Function not registered: 'DestroyDynamicObject'
[22:57:12] Error: Function not registered: 'IsValidDynamic3DTextLabel'
[22:57:12] Error: Function not registered: 'CreateDynamicCP'
[22:57:12] Error: Function not registered: 'CreateDynamicMapIcon'

What's wrong? How do I compile the plugin properly?

Re: [REL] MySQL Plugin (R7 - 25/02/12) - AndreT - 29.02.2012

It looks like MySQL plugin is not the only one that doesn't load. In fact there are at least 4.

So open up your server log file and see if any plugins load at all. Also, see if your server.cfg has a valid plugins line (plugins suffixed with .so) and if the plugin files actually exist in the /plugins/ folder.

Re: [REL] MySQL Plugin (R7 - 25/02/12) - qweasd - 29.02.2012

I got all the plugin files in the folder, the plugin string in server.cfg is as follows:

Quote:

plugins nativechecker.so mysql.so streamer.so sscanf.so gvar.so

I tried different plugin versions, none of it works properly though. It seems it depends on Linux distributive heavily.
So how do I compile it for Debian 6 myself?

Thank you.

Re: [REL] MySQL Plugin (R7 - 25/02/12) - AndreT - 01.03.2012

You need to have some dependencies installed on the machine. I think you can do this using apt-get install on Debian.

Quoting the main post:

Quote:

Linux: Install gcc, gpp & mysql-client and type "make" in the source files folder.

Re: [REL] MySQL Plugin (R7 - 25/02/12) - KaSkA3eR - 01.03.2012

Where's "mysql.so" file?
I have got a Windows XP but i want lauch your mysql plugins on linux server.

Re: [REL] MySQL Plugin (R7 - 25/02/12) - Luka P. - 01.03.2012

How to check is server connected to the database?
Even if I enter wrong user/pass, mysql_ping() will work because it's connected to the MySQL server.

Re: [REL] MySQL Plugin (R7 - 25/02/12) - Pooh7 - 01.03.2012

If you enter wrong DB, debug will write this:

Код:

[21:20:43] >> mysql_connect(localhost, root, wrong_db, ******) on port 3306
[21:20:43] CMySQLHandler::CMySQLHandler() - constructor called.
[21:20:43] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "wrong_db" | Username: "root"
[21:20:43] CMySQLHandler::Connect() - Unknown database 'wrong_db' (Error ID: 1049)
[21:20:43] >> mysql_ping( Connection handle: 1 )

If you try to execute a query after failed connection, it will write "Dead connection".
So, you can use mysql_ping() because it isn't connected to a MySQL server.

pawn Код:

if(mysql_ping() == -1) print("Connection failed");

It works for wrong username/pass AND wrong DB.

Re: [REL] MySQL Plugin (R7 released) - Joey^ - 02.03.2012

The download link for R7 version doesn't work. Can you reupload the R7 version?

Re: [REL] MySQL Plugin (R7 released) - Vince - 03.03.2012

Here's something that I wrote yesterday to circumvent this problem. Requires you to have the cache enabled for that particular select query!

pawn Код:

stock mysql_fetch_int(connectionHandle)
{
    new
        rows,
        fields,
        storage[12];
        
    cache_get_data(rows, fields, connectionHandle);
    
    if(!rows)
        return cellmin;
        
    cache_get_row(0, 0, storage, connectionHandle);
    return strval(storage);
}

stock Float:mysql_fetch_float(connectionHandle)
{
    new
        rows,
        fields,
        storage[12];

    cache_get_data(rows, fields, connectionHandle);

    if(!rows)
        return Float:cellmin;

    cache_get_row(0, 0, storage, connectionHandle);
    return floatstr(storage);
}

Not yet tested, so use at your own risk!

Re: [REL] MySQL Plugin (R7 released) - BlackBank - 03.03.2012

Why is mysql_function_query the only function where you need to put in the connectionHandle?
Why not just the same as the other functions, that you can choose if you want to use a connectionHandle?

Re: [REL] MySQL Plugin (R7 released) - Pooh7 - 03.03.2012

Because we have a possibility to use custom function and custom parameters (format), so script can't make sense between parameters and connection handle. That's the reason why is connection handle on first place.

Re: [REL] MySQL Plugin (R7 released) - BlackBank - 03.03.2012

Quote:

Originally Posted by Pooh7

Because we have a possibility to use custom function and custom parameters (format), so script can't make sense between parameters and connection handle. That's the reason why is connection handle on first place.

Ah, i see.
Thanks for the answer.

Re: [REL] MySQL Plugin (R7 released) - System64 - 03.03.2012

Quote:

Originally Posted by kurta999

pawn Код:

mysql_store_result();
    mysql_fetch_row(name);
    iID = strval(name);
    mysql_free_result();

Or use chace.

I just don't understand this

pawn Код:

mysql_fetch_row(name);
    iID = strval(name);

for what use is name, is it name of field or?

AW: [REL] MySQL Plugin (R7 released) - ThomasTailor93 - 03.03.2012

Hello guys. I just have a question: what is a threaded and a non-threaded script?

Re: AW: [REL] MySQL Plugin (R7 released) - System64 - 03.03.2012

Quote:

Originally Posted by ThomasTailor93

Hello guys. I just have a question: what is a threaded and a non-threaded script?

that doesn't exist, only threaded and non-threaded querys, it's basiclly querys with callback

Re: [REL] MySQL Plugin (R7 released) - kurta999 - 03.03.2012

Quote:

Originally Posted by System64

I just don't understand this

pawn Код:

mysql_fetch_row(name);
    iID = strval(name);

for what use is name, is it name of field or?

// After query..
mysql_store_result();
mysql_fetch_row(name); // Fetch the row into the string, which is "name". This currently same as fetch_int(), but this fetch the row into the string and not return with int.

https://sampwiki.blast.hk/wiki/MySQL#mysql_fetch_row_format

Re: [REL] MySQL Plugin (R7 released) - System64 - 03.03.2012

thanks for reply, my friend told me that before

Now I have to fix problem with sscanf and than I'll test code you gave me!