[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 (Now on github!) - DeathKing - 02.01.2014

Help please i cant run any plugin above R20 or the once with .pdb files and i don't know what to do... i have Windows 7 x64bit

Re: [REL] MySQL Plugin (Now on github!) - CrossUSAAF - 04.01.2014

Hey there!

Just wondering, what "cache_get" method you should use when changing integer in SELECT query to a string. I Have tried to use "cache_get_field_content();", but this does nothing. No errors or anything in my logs.

Thanks for your reply in advance!

Re: [REL] MySQL Plugin (Now on github!) - Patrick - 04.01.2014

Quote:

Originally Posted by CrossUSAAF

Hey there!

Just wondering, what "cache_get" method you should use when changing integer in SELECT query to a string. I Have tried to use "cache_get_field_content();", but this does nothing. No errors or anything in my logs.

Thanks for your reply in advance!

I don't really get what you mean, but to convert an integer into string you could use valstr and when you want to convert a string into integer you could use strval, but if you use newer version such as MySQL R8+ I think there is a function for it, try searching.

Example

pawn Код:

new temp[ 15 ];
cache_get_row(0, 1, temp); Variable[playerid] = strval(temp); //convert integer into string

pawn Код:

new temp[ 20 ];
cache_get_row(0, 1, temp); Variable[playerid] = valstr(temp, Variable[playerid]); //convert integer into string

PS - I hope I answered your question, took me 3-4 times to read and understand what you meant.

Re: [REL] MySQL Plugin (Now on github!) - Konstantinos - 04.01.2014

https://sampwiki.blast.hk/wiki/MySQL/R33#cache_get_row_int

or

https://sampwiki.blast.hk/wiki/MySQL/R33...ld_content_int

Re: [REL] MySQL Plugin (Now on github!) - CrossUSAAF - 04.01.2014

Quote:

Originally Posted by Konstantinos

https://sampwiki.blast.hk/wiki/MySQL/R33#cache_get_row_int

or

https://sampwiki.blast.hk/wiki/MySQL/R33...ld_content_int

Thanks for your answers, but... Lets say I Have SELECT query where I Change integer value to a string, e.g changing unix time stamp to a human readable string (with MySQL functions!). How can I Get the string, if doing so? I Tried to use "cache_get_field_content", but it says "field not found" in the log, but it does exist. This might be due to that field is made for integers. But this changes integer to a string when doing SQL-query in phpMyAdmin.

Any ideas how to get the string out then?

Re: [REL] MySQL Plugin (Now on github!) - Konstantinos - 04.01.2014

http://dev.mysql.com/doc/refman/5.5/...unix-timestamp
http://dev.mysql.com/doc/refman/5.5/..._from-unixtime

Re: [REL] MySQL Plugin (Now on github!) - CrossUSAAF - 04.01.2014

Quote:

Originally Posted by Konstantinos

http://dev.mysql.com/doc/refman/5.5/...unix-timestamp
http://dev.mysql.com/doc/refman/5.5/..._from-unixtime

I Know, but how to print that out as a string, like it does in phpMyAdmin? Lets say I Have "1339843" as integer and I Change it to a string in SELECT query, how I Get that out, e.g "2014-01-04 00:00"? I Need to store that to variable, but how to?

Re: [REL] MySQL Plugin (Now on github!) - Konstantinos - 04.01.2014

Quote:

Originally Posted by CrossUSAAF

Then use cache_get_row and store it to a temporary or a global variable (array).

Re: [REL] MySQL Plugin (Now on github!) - CrossUSAAF - 04.01.2014

Quote:

Originally Posted by Konstantinos

Then use cache_get_row and store it to a temporary or a global variable (array).

pawn Код:

mysql_format(dbHandle, query, sizeof(query), "SELECT FROM_UNIXTIME(`Unban`, '%%Y-%%m-%%d %%l:%%i %%p') FROM `Bans` WHERE `Nick` = '%e'", params);
                mysql_query(dbHandle, query, true);
                cache_get_data(rows, fields);
                if (rows) {
                    new bannedStamp[20];
                    cache_get_field_content(0, "Unban", bannedStamp);
                    printf("%s", bannedStamp):
                }

Do you now understand, what I Mean? How can I Get the changed result from that query above? This one gives me a warning: "[WARNING] CMySQLResult::GetRowDataByName - field not found ("Unban")". Is this even possible or not?

Thanks for your reply in advance!

Re: [REL] MySQL Plugin (Now on github!) - Johnson_boy - 04.01.2014

Quote:

Originally Posted by CrossUSAAF

pawn Код:

mysql_format(dbHandle, query, sizeof(query), "SELECT FROM_UNIXTIME(`Unban`, '%%Y-%%m-%%d %%l:%%i %%p') FROM `Bans` WHERE `Nick` = '%e'", params);
                mysql_query(dbHandle, query, true);
                cache_get_data(rows, fields);
                if (rows) {
                    new bannedStamp[20];
                    cache_get_field_content(0, "Unban", bannedStamp);
                    printf("%s", bannedStamp):
                }

It's a query issue, not a plugin issue. Scripting discussion would be more appropriate subforum for the question.

Anyways, change "FROM_UNIXTIME(`Unban`, '%%Y-%%m-%%d %%l:%%i %%p')" to "FROM_UNIXTIME(`Unban`, '%%Y-%%m-%%d %%l:%%i %%p') AS `Unban`" and it should work.

Re: [REL] MySQL Plugin (Now on github!) - CrossUSAAF - 04.01.2014

Thank you very much Finnish boy, it worked. The original one worked in phpMyAdmin's query box, but I Did not know it has to be used like this.

I Saw many discussions regarding the plugin and MySQL here, so I Decided to ask in here. Thank you once again!

Re: [REL] MySQL Plugin (Now on github!) - Kar - 05.01.2014

Lol I realized I posted in the wrong topic last time, with the r35 beta. LOL.

Anyway new issue.. The procedure entry point GetLogicalProcessorInformation could not be located in the dynamic link library KERNEL32.dll

any ideas?

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 05.01.2014

Quote:

Originally Posted by Kar

Lol I realized I posted in the wrong topic last time, with the r35 beta. LOL.

hnngh

Quote:

Originally Posted by Kar

Anyway new issue.. The procedure entry point GetLogicalProcessorInformation could not be located in the dynamic link library KERNEL32.dll

any ideas?

I bet you are running Win XP. Have you installed the Service Pack 3?

Re: [REL] MySQL Plugin (Now on github!) - blackwidow18 - 06.01.2014

Trying to run a query like this:

Код:

SELECT blah.id, blah.name, blahblah.number, hey.message FROM blah
LEFT JOIN blahblah ON blah.id = blahblah.id
LEFT JOIN hey ON blah.name = hey.id
WHERE blah.age = 2

(same concept as the actual query I'm running)

The result is:

Quote:

Error: Unknown table 'blah' in field list

The main "from" table is apparently AWOL.

While running the same query in PHPMyadmin it runs fine and fetchs all 8 values correctly. I am using R7. Considering the query works fine otherwise, I don't see what the problem is unless its in the plugin. The connection is active and yes it is to the right database. It can also see/access the table in a simpler query.

Re: [REL] MySQL Plugin (Now on github!) - Kar - 06.01.2014

No I don't have SP3, if you know the true background on SP3, it's not really 'perfect' with some computers. It's not perfect with mine so that's why I've stopped installing it. (I have used it before, this PC has been flashes many times, but SP3 was a reason behind many of those flashes.. flashes = wipe with CD)

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 06.01.2014

Quote:

Originally Posted by Kar

No I don't have SP3, if you know the true background on SP3, it's not really 'perfect' with some computers. It's not perfect with mine so that's why I've stopped installing it. (I have used it before, this PC has been flashes many times, but SP3 was a reason behind many of those flashes.. flashes = wipe with CD)

Does R34 run without any problems?

Re: [REL] MySQL Plugin (Now on github!) - Kar - 06.01.2014

yes, it's smooth

Re: [REL] MySQL Plugin (Now on github!) - Su37Erich - 08.01.2014

Thanks for the plugin.
Now I've a problem, I tried to use it in the host, but I got this error:
[03:38:31] Loading plugin: mysql.so
[03:38:31] Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)
Anyone can help me?
Thanks.

Re: [REL] MySQL Plugin (Now on github!) - IstuntmanI - 09.01.2014

Quote:

Originally Posted by Su37Erich

Thanks for the plugin.
Now I've a problem, I tried to use it in the host, but I got this error:
[03:38:31] Loading plugin: mysql.so
[03:38:31] Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)
Anyone can help me?
Thanks.

Use the static version.

Re: [REL] MySQL Plugin (Now on github!) - ombre - 10.01.2014

Quote:

Originally Posted by BlueG

[*]Linux: (x86 (32-bit) version is cross compatible)

R7: Ubuntu, x86 (compiled on Ubuntu)
R6: CentOS, Debian 5, x86 (compiled on CentOS), x86 (compiled on Debian5)
R5: CentOS, Debian 5, x86
libmysqlclient.so.15 - Getting this error.. 'libmysqlclient.so.15: cannot open shared [..]' ? - Read this[/list

I run on debian 7 64b and R5 mysql plugin I need the plugin for debian 5 or x86 or other?