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

Quote:
Originally Posted by FanHamMer
Посмотреть сообщение
Where I can get libmysqlclient.so.18?
It is included in the mysql-client-5.5 package. If you get an error like "libmysqlclient.so.18 not found" use the 5.1-version, available in downloads.

Quote:
Originally Posted by DarkSlyder
Посмотреть сообщение
Why does 'mysql_connect' always returns a positive handle with a failed connection? Even 'mysql_errno' doesn't seem to be working.

pawn Код:
//Testing code
printf("%d", mysql_connect(SQL_HOST, SQL_USER, "db1", SQL_PWD)); //Correct db
printf("%d", mysql_errno());
printf("%d", mysql_connect(SQL_HOST, SQL_USER, "123456", SQL_PWD)); //Invalid db
printf("%d", mysql_errno());
printf("%d", mysql_connect(SQL_HOST, SQL_USER, "db2", SQL_PWD)); //Correct db
printf("%d", mysql_errno());
Код:
//Output
1
0
2
0
3
0
1. the connection is always created. If it's actually connected to the database, that's another question.
2. your code is wrong. You are calling mysql_errno always with the same (default) handle.
Reply

Hi Again,
I've got new error with mysql
Server Log:
Код:
[15:35:18] Loading plugin: mysql.so
[15:35:18]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
I'm running CentOS 6 64bit HELLLLLLLLLLLLP
Reply

Quote:
Originally Posted by Aliassassin123456
Посмотреть сообщение
Hi Again,
I've got new error with mysql
Server Log:
Код:
[15:35:18] Loading plugin: mysql.so
[15:35:18]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
I'm running CentOS 6 64bit HELLLLLLLLLLLLP
This should help http://forum.sa-mp.com/showpost.php?...&postcount=553
Reply

Quote:
Originally Posted by zPain
Посмотреть сообщение
Every time I use it, cache_get_field_content returns NULL. Could it be a bug on r33?
Enable the default logging ("mysql_log();"), run your script again and check the mysql_log.txt for any errors.
Reply

I've deleted mysql_log.txt and restarted my samp-server, but the file wasn't created. I suppose there aren't errors.

Sorry for my english (if that's wrong)
Reply

Quote:
Originally Posted by zPain
Посмотреть сообщение
I've deleted mysql_log.txt and restarted my samp-server, but the file wasn't created. I suppose there aren't errors.

Sorry for my english (if that's wrong)
Maybe there really aren't any values in the table? Look, if there would be a problem with cache_get_field_content always returning NULL, this topic would be flooded with such problems.
You can try cache_get_row, if this also returns NULL, there is probably a problem with the query you send or the table really hasn't any values.
Reply

Hi, thanks for your plugin but i have a question

I used R5 version now i want to upgrade my GM on R33 on non threaded query cached, but your plugin is faster than R5/R6?

I try to check if is faster i see is same or other check i see R6 is faster, i'm probably wrong.

Example i try this query x 5 k on loop

PHP код:
GetIpCountry_mysql(IpInfo[])
{
    new 
query[256];
    if(!
strcmp("127.0.0.1"IpInfotrue))
    {
        
query "Localhost";
    }
    else
    {
        new 
DataSetting[4][10];
        if(
sscanf(IpInfo"p<.>s[10]s[10]s[10]s[10]"DataSetting[0], DataSetting[1], DataSetting[2], DataSetting[3])) query "Invalid IP";
        else
        {
            
format(querysizeof query"\
            SELECT `Country`\
            FROM `countrydetected`\
            WHERE `Ip_From` <= ((16777216*%d) + (65536*%d) + (256*%d) + %d)\
            AND `Ip_to` >= ((16777216*%d) + (65536*%d) + (256*%d) + %d) LIMIT 1"
,
            
strval(DataSetting[0]), strval(DataSetting[1]), strval(DataSetting[2]), strval(DataSetting[3]),
            
strval(DataSetting[0]), strval(DataSetting[1]), strval(DataSetting[2]), strval(DataSetting[3]));
            new 
Cache:vquery mysql_query(ConnexionBDD,query);
            if(
cache_get_row_count())
            {
                
mysql_fetch_row(query);
            }
            else 
query "Unknown";
            
cache_delete(vquery);
        }
    }
    return 
query;

But i have a problem with the fetch i don't know if is good.
Reply

Quote:
Originally Posted by Kyra
Посмотреть сообщение
Hi, thanks for your plugin but i have a question

I used R5 version now i want to upgrade my GM on R33 on non threaded query cached, but your plugin is faster than R5/R6?

I try to check if is faster i see is same or other check i see R6 is faster, i'm probably wrong.

Example i try this query x 5 k on loop

PHP код:
[...] 
But i have a problem with the fetch i don't know if is good.
Your speed results are probably correct, the unthreaded queries in R33 can be slower than those in R6. Why? Because the R33-queries are still cached (they take the whole result from the MySQL server), but the R6-queries are not (you decide what data you need).

Your code looks generally not very good. Why do you store the sub-numbers of the IP at first in strings and then convert them back into numbers? Why don't you just use "p<.>dddd"?
Reply

It's not my function ^^ i just test with this https://sampforum.blast.hk/showthread.php?tid=131554

But thanks for your response ! And just for know, why my store result works 1 time and other time returning "NULL" mysql_fetch_row(query); is bad with cache query? What is the similar function with cache function?
Reply

I've tested my script with r20 and got the same problem. I believe that's my mistake...


EDIT: Fixed

I've changed:
pawn Код:
cache_get_field_content(index, "zone_name", zoneArray[id][zone_name], mysql_database);
for:
pawn Код:
cache_get_field_content(index, "zone_name", zoneArray[id][zone_name], mysql_database, 32);
But I thought the length parameter was not necessary.
Reply

Good job
Reply

Quote:
Originally Posted by Kyra
Посмотреть сообщение
[...]
But thanks for your response ! And just for know, why my store result works 1 time and other time returning "NULL" mysql_fetch_row(query); is bad with cache query? What is the similar function with cache function?
mysql_fetch_row is in fact just a normal PAWN function which can be found in the MySQL plugin include. It just gets the data in a loop and concatenates it as a string. You really shouldn't use this function, fetch the data with the standard cache_* natives like cache_get_row or cache_get_field_content.

Quote:
Originally Posted by zPain
Посмотреть сообщение
[...]
But I thought the length parameter was not necessary.
That's the well-known problem with enum-arrays. Take a look at this post, it explains the problem in detail.
Reply

When i trying to get mask name if players name longer than 16, name is not showing. And stplayername not working. Why? What is the best way of get string?


new temp[MAX_PLAYER_NAME];
cache_get_field_content(0, "maskname", temp);

strmid(Player[playerid][pMask], temp, 0, strlen(temp), 255);

or

memcpy(Player[playerid][pMask], temp, strlen(Player[playerid][pMask]) * 4, temp * 4, sizeof Player[playerid][pMask]);

or

memcpy(Player[playerid][pMask], temp, 0, 64+8, 64+8 ); //worked but i guess its not good

or

strmid(Player[playerid][pMask], temp, MAX_PLAYER_NAME*4, MAX_PLAYER_NAME*4);
Reply

Quote:
Originally Posted by maddinat0r
Посмотреть сообщение
Okay, again, very easy: Don't use unthreaded queries if you can use threaded ones instead. Your problem is happening because you are using threaded and unthreaded queries wrong.
This is a bug..
Sorry my English
Reply

Quote:
Originally Posted by Den_Bellik
Посмотреть сообщение
This is a bug..
Sorry my English
Okay, I know now where the mistake is, but still, use threaded queries.
The problem is that R33 uses now 2 connections and you only set the character set for one connection. Another solution would be to set the character set once and for ever directly in the table (ALTER TABLE ... SET CHARSET ...).
Reply

maddinat0r, I need an answer ; I want to create a Top Players with some fields ( level, money, crimes, etc. ). The database is actually big enough ( + 500.000 accounts ). Do I have to make 3 threaded queries for all of this?

For example:
pawn Код:
// CMD:top(playerid, params)
mysql_tquery(SQL, "SELECT level FROM accounts ORDER BY level DESC LIMIT 5", "TopLevel", "d", playerid);
mysql_tquery(SQL, "SELECT money FROM accounts ORDER BY money DESC LIMIT 5", "TopMoney", "d", playerid);
mysql_tquery(SQL, "SELECT crime FROM accounts ORDER BY crime DESC LIMIT 5", "TopCrime", "d", playerid);
pawn Код:
forward TopLevel(const playerid);
public TopLevel(const playerid)
{
    if(!IsPlayerConnected(playerid))
        return 1;


    // My Top Level Code .............
    strcat(largeString, editedString);
    // ......................................
    return 1;
}

forward TopMoney(const playerid);
public TopMoney(const playerid)
{
    if(!IsPlayerConnected(playerid))
        return 1;


    // My Top Money Code ........................
    strcat(largeString, editedString);
    // ......................................

    return 1;
}

forward TopCrime(const playerid);
public TopCrime(const playerid)
{
    if(!IsPlayerConnected(playerid))
        return 1;


    // My Top Crime Code .......................
    strcat(largeString, editedString);
    // ......................................

    ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "Top Players", largeString, "OK", "");
    return 1;
}
Reply

Quote:
Originally Posted by saamp
Посмотреть сообщение
maddinat0r, I need an answer ; I want to create a Top Players with some fields ( level, money, crimes, etc. ). The database is actually big enough ( + 500.000 accounts ). Do I have to make 3 threaded queries for all of this?

For example:
pawn Код:
// CMD:top(playerid, params)
mysql_tquery(SQL, "SELECT level FROM accounts ORDER BY level DESC LIMIT 5", "TopLevel", "d", playerid);
mysql_tquery(SQL, "SELECT money FROM accounts ORDER BY money DESC LIMIT 5", "TopMoney", "d", playerid);
mysql_tquery(SQL, "SELECT crime FROM accounts ORDER BY crime DESC LIMIT 5", "TopCrime", "d", playerid);
pawn Код:
forward TopLevel(const playerid);
public TopLevel(const playerid)
{
    if(!IsPlayerConnected(playerid))
        return 1;


    // My Top Level Code .............
    strcat(largeString, editedString);
    // ......................................
    return 1;
}

forward TopMoney(const playerid);
public TopMoney(const playerid)
{
    if(!IsPlayerConnected(playerid))
        return 1;


    // My Top Money Code ........................
    strcat(largeString, editedString);
    // ......................................

    return 1;
}

forward TopCrime(const playerid);
public TopCrime(const playerid)
{
    if(!IsPlayerConnected(playerid))
        return 1;


    // My Top Crime Code .......................
    strcat(largeString, editedString);
    // ......................................

    ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "Top Players", largeString, "OK", "");
    return 1;
}
Yes, but you should use LIMIT. For example if you want top 30 put "LIMIT 30" at the end of the query.
Reply

Quote:
Originally Posted by saamp
Посмотреть сообщение
maddinat0r, I need an answer ; I want to create a Top Players with some fields ( level, money, crimes, etc. ). The database is actually big enough ( + 500.000 accounts ). Do I have to make 3 threaded queries for all of this?

For example:
pawn Код:
// CMD:top(playerid, params)
mysql_tquery(SQL, "SELECT level FROM accounts ORDER BY level DESC LIMIT 5", "TopLevel", "d", playerid);
mysql_tquery(SQL, "SELECT money FROM accounts ORDER BY money DESC LIMIT 5", "TopMoney", "d", playerid);
mysql_tquery(SQL, "SELECT crime FROM accounts ORDER BY crime DESC LIMIT 5", "TopCrime", "d", playerid);
pawn Код:
forward TopLevel(const playerid);
public TopLevel(const playerid)
{
    if(!IsPlayerConnected(playerid))
        return 1;


    // My Top Level Code .............
    strcat(largeString, editedString);
    // ......................................
    return 1;
}

forward TopMoney(const playerid);
public TopMoney(const playerid)
{
    if(!IsPlayerConnected(playerid))
        return 1;


    // My Top Money Code ........................
    strcat(largeString, editedString);
    // ......................................

    return 1;
}

forward TopCrime(const playerid);
public TopCrime(const playerid)
{
    if(!IsPlayerConnected(playerid))
        return 1;


    // My Top Crime Code .......................
    strcat(largeString, editedString);
    // ......................................

    ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "Top Players", largeString, "OK", "");
    return 1;
}
What exactly do you wish to show? If you want to show their name together with their (for example, level) then you must select the name in the SELECT part and order them as (for example, level) as you've done correctly. LIMIT will help you select only the top X (5 in this case) players so that's correct too. And yes, you'd have to make 3 different queries to do this.
Reply

Thanks guys.

Why cache_get_row_count() returns 1 here, when in my bans table I don't have any record?

pawn Код:
mysql_query(databaseConnection, "SELECT COUNT(*) FROM bans WHERE BanIP = '127.0.0.1'");
    printf("Count: %d | Int: %d", cache_get_row_count(), cache_get_row_int(0, 0));
Count: 1 | Int: 0
Reply

Quote:
Originally Posted by saamp
Посмотреть сообщение
Thanks guys.

Why cache_get_row_count() returns 1 here, when in my bans table I don't have any record?

pawn Код:
mysql_query(databaseConnection, "SELECT COUNT(*) FROM bans WHERE BanIP = '127.0.0.1'");
    printf("Count: %d | Int: %d", cache_get_row_count(), cache_get_row_int(0, 0));
Count: 1 | Int: 0
You are retrieving the amount of rows per query, so your query returns a value: the number of rows. Because the number itself is in a row, cache_get_row_count returns 1.
Reply


Forum Jump:


Users browsing this thread: 16 Guest(s)