[Gammix]

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.

[Aerotactics]

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

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

[JR_Junior]

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.

[Max_Andolini]

Version 3.8 released.

PHP Code:

Bugs solved. 


Quote:

Originally Posted by CantBeJohn 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 = -1, MySQL:connectionHandle = MYSQL_DEFAULT_HANDLE) {     new query[SQL_FORM_LENGTH], query2[SQL_FORM_LENGTH], Cache:result, rows;     format(query, sizeof(query), "SELECT * FROM `%s` WHERE `%s`='%e'", table, column_where, row_identifier); // HERE.     if(!isnull(column_where2) && !isnull(row_identifier2) && row_identifier3 == -1)     {         format(query2, sizeof(query2), " AND `%s`='%e'", column_where2, row_identifier2); // HERE AS WELL.         strcat(query, query2);     }     if(!isnull(column_where2) && row_identifier3 != -1 && isnull(row_identifier2))     {         format(query2, sizeof(query2), " AND `%s`='%d'", column_where2, row_identifier3);         strcat(query, query2);     }     strcat(query, " ");     result = mysql_query(connectionHandle, query);     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 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 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.

[JR_Junior]

Quote:

Originally Posted by Max_Andolini 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.

[Stefan_Toretto]

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

[Max_Andolini]

Quote:

Originally Posted by Stefan_Toretto Is there any possibility to add the ability to add table columns to an existing Table?

Yes, there is. Review examples.

[JR_Junior]

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

Thanks!