View Single Post
Old 09/07/2019, 08:24 PM   #111
CantBeJohn
Big Clucker
 
CantBeJohn's Avatar
 
Join Date: Oct 2016
Posts: 112
Reputation: 15
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

Quote:
Originally Posted by Max_Andolini View Post
Version 3.7 released.

PHP Code:
Bugs solved.
Added insert options. (EngineCharset etc.)
Added Charset function in SQL::Connect.
Added Null or not null option in AddTableColumn.

SQL::Connect(const host[], const user[], const password[], const database[], const charset[] = "latin5"debugging 0port 3306bool:autoreconnect truepool_size 2);

new 
handle SQL::Open(SQL::CREATE"database""engine default InnoDB", -1"charset default latin5");
SQL::AddTableColumn(handle, const field_name[], SQL::datatypestype SQL_TYPE_INTmaxlength 11bool:null falsebool:auto_increment falsebool:setprimary falsebool:setindex false)
SQL::Close(handle); 
Great. Can we talk about how these still use the "%e" specifier using normal format instead of mysql_format still though?

PHP Code:
SQL::DeleteRowEx2
SQL
::GetStringEntryEx2
SQL
::t_GetStringEntryEx2
SQL
::GetIntEntryEx2
SQL
::GetFloatEntryEx2
SQL
::SetIntEntryEx2
SQL
::SetStringEntry2
SQL
::SetStringEntryEx2
SQL
::SetFloatEntryEx2
SQL
::RowExistsEx2
SQL
::DeleteRow3 
Meanwhile, normal format doesn't support "%e"; as shown here (https://wiki.sa-mp.com/wiki/Format):



The only one it does support is "%q" but that's irrelevant in this case.

Now just look at RowExistsEx2 from the latest version of this library:

PHP Code:
stock SQL::RowExistsEx2(const table[], const column_where[] = "", const row_identifier[], const column_where2[] = "", const row_identifier2[] = ""row_identifier3 = -1MySQL:connectionHandle MYSQL_DEFAULT_HANDLE)
{
    new 
query[SQL_FORM_LENGTH], query2[SQL_FORM_LENGTH], Cache:resultrows;
    
format(querysizeof(query), "SELECT * FROM `%s` WHERE `%s`='%e'"tablecolumn_whererow_identifier); // HERE.
    
if(!isnull(column_where2) && !isnull(row_identifier2) && row_identifier3 == -1)
    {
        
format(query2sizeof(query2), " AND `%s`='%e'"column_where2row_identifier2); // HERE AS WELL.
        
strcat(queryquery2);
    }
    if(!
isnull(column_where2) && row_identifier3 != -&& isnull(row_identifier2))
    {
        
format(query2sizeof(query2), " AND `%s`='%d'"column_where2row_identifier3);
        
strcat(queryquery2);
    }
    
strcat(query" ");
    
result mysql_query(connectionHandlequery);
    if(
mysql_errno() != 0)
    {
        return 
SQL_Warning("Query could not be completed due to error: %s"query);
    }
    
cache_get_row_count(rows);
    
cache_delete(result);
    if(
rows 0)
    {
        return 
rows;
    }
    return 
0;

CantBeJohn is offline   Reply With Quote