12.09.2014, 22:41
That string with the '|' delimiter is not "raw SQL", it was internally (in the plugin) generated in a for-loop with a 'cache_get_row()' like function. Thus it doesn't really make sense generating a string from all fields and then breaking it apart again through a parser (sscanf). 'cache_get_row()' is the only way (of course there are other ways, but they are also calling 'cache_get_row' internally) to retrieve data directly from the cached result set (because the "raw SQL" result is a 2D-string-array; the indices which are needed to access a field are the first two parameters in 'cache_get_row' and that field is directly stored into the third parameter passed to 'cache_get_row').