[peaces]

Solution found, not tested

SQL_FieldNameToNum
Returns the number of a named column, or -1 if not found.

native SQL_FieldNameToNum(Handle:query, const name[]);

[Bugsy]

But that's just getting the column number when you give it the column name, not reading the column value.

So a table with columns : a, b, c

SQL_FieldNameToNum( query , "a" ) would return 0 , b = 1 , etc.

[peaces]

Currently reading UTF-8 messages from the database ~ the problem has not been resolved

[Bugsy]

Can you provide expected versus actual output?

[peaces]

Originally Posted by Bugsy Can you provide expected versus actual output?

If the NICK character of the database is UTF-8, it will not be displayed normally

new str[32]
			SQL_ReadResult(query, 0, str, 31)
	
			if(get_pcvar_num(pi_show_who) == 1)
			{
				new players[32], playersnum
				get_players(players, playersnum, "ch")
				for(new i = 0; i < playersnum; i++)
				{
					new player = players[i]
					if(is_user_admin(player))
					{
						if(get_pcvar_num(pi_hudmsg) == 0)
						{
							client_print(player, print_chat, "%L", LANG_PLAYER, "JOIN_MSG", name, str)
						}
						else
						{
							new message[192]
							format(message, 191, "%L", LANG_PLAYER, "JOIN_HUDMSG", name , str)
							set_hudmessage(0, 255, 0, 0.05, 0.30, 0, 6.0, 5.0 , 0.5, 0.15, -1)
							ShowSyncHudMsg(player, MyMsgSync, "%s", message)
						}
					}
				}
			}

[peaces]

Solved after adding this column
UTF-8 characters

new query[512] format(query, 511, "SELECT nick FROM `%s` WHERE `authid` = '%s' ORDER BY uses DESC LIMIT 1", g_table, steamid) new data[1] data[0] = id SQL_SetCharset(g_SqlX, "utf8") SQL_ThreadQuery(g_SqlX, "_join_msg", query, data, 1) return PLUGIN_CONTINUE