Fetching a data from mySQL
#8

Err, I'll look up for explanation about tquery, cleaning cache ... later on!

I'm not sure if I get this good, but it should work like this?
Код:
  new query[70];
    new _tempskin;
    mysql_format(g_SQL, query, sizeof query, "SELECT `skin` FROM `players` WHERE `id` = %d LIMIT 1", Player[playerid][ID]);
    if(cache_num_rows())
    {
        cache_get_value_int(0, "skin", Player[playerid][Skin]);
    }
    SetPlayerSkin(playerid, _tempskin);
I've tried to put SetPlayerSkin in chache_num_rows too. And yes I'm 100% sure script fatches player's skin. I've checked it.
Reply


Messages In This Thread
Fetching a data from mySQL - by Fratello - 27.09.2017, 14:37
Re: Fetching a data from mySQL - by AndreiWow - 27.09.2017, 14:48
Re: Fetching a data from mySQL - by jlalt - 27.09.2017, 14:50
Re: Fetching a data from mySQL - by Fratello - 27.09.2017, 14:56
Re: Fetching a data from mySQL - by jlalt - 27.09.2017, 15:00
Re: Fetching a data from mySQL - by raydx - 27.09.2017, 15:05
Re: Fetching a data from mySQL - by whadez - 27.09.2017, 15:21
Re: Fetching a data from mySQL - by Fratello - 27.09.2017, 16:24
Re: Fetching a data from mySQL - by oMa37 - 27.09.2017, 16:28
Re: Fetching a data from mySQL - by Fratello - 27.09.2017, 16:32

Forum Jump:


Users browsing this thread: 2 Guest(s)