[CantBeJohn]

Quote:

Originally Posted by Max_Andolini Version 3.7 released. PHP Code: Bugs solved. Added insert options. (Engine, Charset 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 = 0, port = 3306, bool:autoreconnect = true, pool_size = 2); new handle = SQL::Open(SQL::CREATE, "database", "engine default InnoDB", -1, "charset default latin5"); SQL::AddTableColumn(handle, const field_name[], SQL::datatypes: type = SQL_TYPE_INT, maxlength = 11, bool:null = false, bool:auto_increment = false, bool:setprimary = false, bool: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://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;
}