[Include] Easy MySQL - Simplifying the usage of MySQL queries!
#61

I like the efforts put in this library but there's a reason why i deleted my EasyDB library(it was built for SQLite with the same purpose as this, before easy_mysql was even released), year(s) ago, because you don't really achieve any advantage using such a syntax, over speed. The biggest reason being you are not using threaded queries and not to mention you limit results because we don't have dynamic memory in default pawn so reading data is limited.

So I won't recommend anyone use this unless you don't care about speed and/or learning SQL.
Reply
#62

I'm getting errors when using this include. Please look at this thread.

https://sampforum.blast.hk/showthread.php?tid=668001
Reply
#63

Im trying to use the DATETIME field type but I don't know to use DATE_FORMAT lo convert yyyy-mm-dd to dd-mm-yy with this include.
Reply
#64

Version 3.8 released.

PHP Code:
Bugs solved
Quote:
Originally Posted by CantBeJohn
View Post
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://sampwiki.blast.hk/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;

Thanks, fixed.

Quote:
Originally Posted by Aerotactics
View Post
I'm getting errors when using this include. Please look at this thread.

https://sampforum.blast.hk/showthread.php?tid=668001
Thanks, fixed.

Quote:
Originally Posted by JR_Junior
View Post
Im trying to use the DATETIME field type but I don't know to use DATE_FORMAT lo convert yyyy-mm-dd to dd-mm-yy with this include.
It doesn't support getting DATETIME. You can use String as a time.
Reply
#65

Quote:
Originally Posted by Max_Andolini
View Post
It doesn't support getting DATETIME. You can use String as a time.
Thank you, I'm saving the date and time as string and works fine.
Reply
#66

Is there any possibility to add the ability to add table columns to an existing Table?
Reply
#67

Quote:
Originally Posted by Stefan_Toretto
View Post
Is there any possibility to add the ability to add table columns to an existing Table?
Yes, there is. Review examples.
Reply
#68

What brings about a better performance?
A long handle, with multiple read / write lines?
Or multiple handles with few lines?

Thanks!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)