[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.