[Admigo]

Quote:

Originally Posted by Stylock Can you provide relevant table and column names? It's not clear to me whether you're storing the data in one or multiple tables.

Sure.

pawn Код:

stock GetClanMembers(clan[])
{
        new clanquery[200];
        format(clanquery, sizeof(clanquery), "SELECT * FROM a_clans_members WHERE clanname = '%s'", clan);
        mysql_query(clanquery, _THREAD_GET_CLAN_MEMBERS, -1, gSQL);
        return 1;
}

pawn Код:

clanname|playername

Server log:

pawn Код:

15:29:29] >> mysql_query_callback(Connection handle: 1)
[15:29:29] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM a_clans_members WHERE clanname = 'acnr'...
[15:29:29] ProcessQueryThread(OnQueryFinish) - Query was successful.
[15:29:29] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick().
[15:29:29] OnQueryFinish(siii) - Callback is being called...
[15:29:29] >> mysql_store_result(Connection handle: 1)
[15:29:29] CMySQLHandler::StoreResult() - Result was stored.
[15:29:29] >> mysql_num_rows(Connection handle: 1)
[15:29:29] CMySQLHandler::NumRows() - Returned 2 row(s).
[15:29:29] >> mysql_fetch_row_format(Connection handle: 1)
[15:29:29] CMySQLHandler::FetchRow() - Return: 7|acnr|Admigo|10|1|1.
[15:29:29] >> mysql_fetch_field_row(Connection handle: 1)
[15:29:29] CMySQLHandler::FetchField(playername) - You cannot call this function now (no result).
[15:29:29] >> mysql_fetch_row_format(Connection handle: 1)
[15:29:29] CMySQLHandler::FetchRow() - Return: 7|acnr|Andy|1|1|2.
[15:29:29] >> mysql_fetch_field_row(Connection handle: 1)
[15:29:29] CMySQLHandler::FetchField(playername) - You cannot call this function now (no result).
[15:29:29] >> mysql_fetch_row_format(Connection handle: 1)
[15:29:29] >> mysql_free_result(Connection handle: 1)
[15:29:29] CMySQLHandler::FreeResult() - Result was successfully freed.