[Konstantinos]

Quote:

Originally Posted by vannesenn all builds from now on prefer the MariaDB C connector" I don't understand what you want to say.

libmysql.dll is basically replaced with libmariadb.dll (which is a lot smaller in size from what I see).

[MerryDeer]

Can you compile for debian 8 ?

[maddinat0r]

Quote:

Originally Posted by MerryDeer Can you compile for debian 8 ?

Will do that tomorrow.

[RIDE2DAY]

Good job maddinat0r, I love mysql_connect_file and cache_insert_id. By the way, how can multiple SQL statements be sent with this plugin? Adding a semicolon after each statement?

Should cache_get_result_count and cache_get_row_count be used first as a condition always? Why would they fail? I mean, is there any difference between the following two examples?

PHP код:

/* Query */
mysql_pquery(sql_handle, "SELECT `id`, `password` FROM `player_info` WHERE `name`='RIDE2DAY' LIMIT 1", "CheckAccount");
/* CheckAccount Callback */
/* Method #1 */
new results;
if(cache_get_result_count(results))
{
    cache_set_result(0);
    new rows;
    if(cache_get_row_count(rows))
    {
        if(rows)
        {
            // Log In
        }
        else
        {
            
            // Register
        }
    }
}
/* Method #2 */
cache_set_result(0);
new rows;
cache_get_row_count(rows);
if(rows)
{
    // Log In
}
else
{
    
    // Register
} 


[Max_Andolini]

Quote:

Originally Posted by RIDE2DAY Good job maddinat0r, I love mysql_connect_file and cache_insert_id. By the way, how can multiple SQL statements be sent with this plugin? Adding a semicolon after each statement? Should cache_get_result_count and cache_get_row_count be used first as a condition always? Why would they fail? I mean, is there any difference between the following two examples? PHP код: /* Query */ mysql_pquery(sql_handle, "SELECT `id`, `password` FROM `player_info` WHERE `name`='RIDE2DAY' LIMIT 1", "CheckAccount"); /* CheckAccount Callback */ /* Method #1 */ new results; if(cache_get_result_count(results)) {     cache_set_result(0);     new rows;     if(cache_get_row_count(rows))     {         if(rows)         {             // Log In         }         else         {                          // Register         }     } } /* Method #2 */ cache_set_result(0); new rows; cache_get_row_count(rows); if(rows) {     // Log In } else {          // Register }

Код:

/* Query */ 
mysql_pquery(sql_handle, "SELECT `id`, `password` FROM `player_info` WHERE `name`='RIDE2DAY' LIMIT 1", "CheckAccount"); 

/* CheckAccount Callback */ 
/* Method #1 */ 
new results; 
cache_get_result_count(results);
if(results) 
{ 
    new rows; 
    cache_get_row_count(rows);
    if(rows) 
    { 
        // Log In 
    } 
    else 
    { 
        // Register 
    } 
}

Use this.

[Doritoss]

The mysql_log function doesn't work with R41-2.

Код:

error 017: undefined symbol "LOG_ERROR"

[Konstantinos]

Quote:

Originally Posted by Doritoss The mysql_log function doesn't work with R41-2. Код: error 017: undefined symbol "LOG_ERROR"

https://sampwiki.blast.hk/wiki/MySQL/R40#Log_levels
https://sampforum.blast.hk/showthread.php?tid=616103

[ranme15]

Quote:

Originally Posted by Cyber123 Why you didnt make any example script for newer versions, like simple register/login system?

There is actually in the zip package.

[iLearner]

How can we use the LIKE '%...%' clause? since the plugin converts ' into ", while mysql requires ' ' around the %...%

[TommyB]

Quote:

Originally Posted by iLearner How can we use the LIKE '%...%' clause? since the plugin converts ' into ", while mysql requires ' ' around the %...%

Use two percent signs. More info here.

[iLearner]

Quote:

Originally Posted by TommyB Use two percent signs. More info here.

%% arent a problem, the problem is typing ' '

Format: LIKE '%SEARCHEDTERM%'

we cant type ' via pawn, as the plugin will convert it into "

[TommyB]

Quote:

Originally Posted by iLearner %% arent a problem, the problem is typing ' ' Format: LIKE '%SEARCHEDTERM%' we cant type ' via pawn, as the plugin will convert it into "

Really? I don't have that problem. Here's a query that works just fine for me.

PHP Code:

mysql_format(conn, mquery, sizeof(mquery), "SELECT OwnerName,PhoneNumber FROM phones WHERE OwnerName LIKE '%%%e%%' AND ShowPhonebook = 1 LIMIT 25", params); 


[iLearner]

Thanks buddy, have a cookie.

[Kar]

I have a new laptop, it's pretty new.. (kaby lake).

I installed the required packages. MySQL still fails to load on windows. R41-2.

I installed the C connector, and OpenSSL 1.0.2k 32 and 64 bit side to side (since the latest C connector uses 1.0.2 by default now ).

Still not loading

[Jeroen52]

Quote:

Originally Posted by Kar I have a new laptop, it's pretty new.. (kaby lake). I installed the required packages. MySQL still fails to load on windows. R41-2. I installed the C connector, and OpenSSL 1.0.2k 32 and 64 bit side to side (since the latest C connector uses 1.0.2 by default now ). Still not loading

Could you give more information if you are building the plugin from source? And which operating system (and if Linux, which distro and architecture) you are using?

[Kar]

Windows 10 x64, I haven't tried building yet. My Visual Studio is still getting ready. I'm going to try when it's done.

log-core.so and mysql.so (32 bit) (dynamically linked) compiled on Ubuntu Trusty 14.04.

https://www.mediafire.com/?6pizjdu8n...movhmp7x17i60l

[vasyok28]

Hello! After omission of MySQL is disconnected from the server, and restores the connection is not re-encoding.
What solution ?

[Wahyu33]

mysql_escape_string why? how to fix?

[vannesenn]

Quote:

Originally Posted by Wahyu33 mysql_escape_string why? how to fix?

mysql_format and operator %e

[Kar]

I feel like the next version should be tested with 5.6 and 5.7