// Build PK Rank ranking list [Zephyrus] if( SQL_ERROR == Sql_Query(sql_handle, "SELECT `char_pk`.`char_id`, `char_pk`.`score`, `%s`.`name` FROM `char_pk` LEFT JOIN `%s` ON `%s`.`char_id` = `char_pk`.`char_id` WHERE `char_pk`.`score` > '0' ORDER BY `char_pk`.`score` DESC LIMIT 0,%d", char_db, char_db, char_db, fame_list_size_pvprank) ) Sql_ShowDebug(sql_handle); for( i = 0; i < fame_list_size_pvprank && SQL_SUCCESS == Sql_NextRow(sql_handle); ++i ) { Sql_GetData(sql_handle, 0, &data, NULL); pvprank_fame_list[i].id = atoi(data); Sql_GetData(sql_handle, 1, &data, &len); pvprank_fame_list[i].fame = atoi(data); Sql_GetData(sql_handle, 2, &data, &len); memcpy(pvprank_fame_list[i].name, data, min(len, NAME_LENGTH)); }