[DeathKing]

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

[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!

[Patrick]

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.

[Konstantinos]

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

or

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

[CrossUSAAF]

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?

[Konstantinos]

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

[CrossUSAAF]

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?

[Konstantinos]

Quote:

Originally Posted by CrossUSAAF 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?

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

[CrossUSAAF]

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!

[Johnson_boy]

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):                 } 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!

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.

[CrossUSAAF]

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!

[Kar]

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?

[maddinat0r]

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?

[blackwidow18]

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.

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

[maddinat0r]

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?

[Kar]

yes, it's smooth

[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.

[IstuntmanI]

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.

[ombre]

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?