retrieving data MySQL R39
#2

1) First parameter in cache_get_field_content* functions is rowid. You only retrieve from first row:
Код:
cache_get_field_content_float(0,
2) Wrong loop. It should be "i < rows" where rows are retrieved with cache_get_row_count/cache_num_rows before. Otherwise you will receive "no active cache" error in mysql logs.
3) In OnGameModeInit? If you do not execute a query before or even use mysql_tquery/mysql_pquery (without a callback), you will receive "no active cache" error again. If mysql_query was used, it is bad practice- always use threaded query.
4) Check if there are more rows than the size of hInfo array otherwise run time error 4.
Reply


Messages In This Thread
retrieving data MySQL R39 - by div - 03.07.2018, 13:13
Re: retrieving data MySQL R39 - by Calisthenics - 03.07.2018, 13:47
Re: retrieving data MySQL R39 - by div - 03.07.2018, 14:02
Re: retrieving data MySQL R39 - by Calisthenics - 03.07.2018, 14:04
Re: retrieving data MySQL R39 - by div - 03.07.2018, 14:20
Re: retrieving data MySQL R39 - by CodeStyle175 - 03.07.2018, 14:25
Re: retrieving data MySQL R39 - by div - 03.07.2018, 14:26
Re: retrieving data MySQL R39 - by div - 03.07.2018, 14:39
Re: retrieving data MySQL R39 - by div - 03.07.2018, 16:00
Re: retrieving data MySQL R39 - by Calisthenics - 03.07.2018, 16:37

Forum Jump:


Users browsing this thread: 1 Guest(s)