Skin doesn't load from MySQL?
#4

Quote:
Originally Posted by Rufio
Посмотреть сообщение
Can you show us your MySQL error log as well as yoır saving functions?
This is the OnPlayerDisconnect query:

pawn Код:
mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `PLAYERS` SET `SCORE` = %d, `CASH` = %d, `KILLS` = %d, `DEATHS` = %d, `ADMIN` = %d, `SKIN` = %d, `DONATOR` = %d, `NAMECHANGES` = %d, `HEADSHOTS` WHERE `ID` = %d LIMIT 1",
    pInfo[playerid][Score], pInfo[playerid][Cash], pInfo[playerid][Kills], pInfo[playerid][Deaths], pInfo[playerid][Admin], pInfo[playerid][Skin], pInfo[playerid][Donator], pInfo[playerid][Namechanges], pInfo[playerid][Headshots], pInfo[playerid][ID]);
during login..

pawn Код:
cache_get_value_int(0, "SKIN", pInfo[playerid][Skin]);
--

Quote:
Originally Posted by Jyothiranand
Посмотреть сообщение
Change the number 0 to any other number.The skin ID you want. On the setspawninfo line
pawn Код:
(playerid, team, skin, Float:x, Float:y, Float:z, Float:rotation, weapon1, weapon1_ammo, weapon2, weapon2_ammo, weapon3, weapon3_ammo)
that would be incorrect, refer to the SA:MP wiki
Reply


Messages In This Thread
Skin doesn't load from MySQL? - by Jing_Chan - 30.07.2018, 09:51
Re: Skin doesn't load from MySQL? - by Rufio - 30.07.2018, 09:56
Re: Skin doesn't load from MySQL? - by Jyothiranand - 30.07.2018, 10:22
Re: Skin doesn't load from MySQL? - by Jing_Chan - 30.07.2018, 10:24
Re: Skin doesn't load from MySQL? - by jlalt - 30.07.2018, 10:30
Re: Skin doesn't load from MySQL? - by Jing_Chan - 30.07.2018, 10:32
Re: Skin doesn't load from MySQL? - by jlalt - 30.07.2018, 10:41
Re: Skin doesn't load from MySQL? - by Jing_Chan - 30.07.2018, 11:12
Re: Skin doesn't load from MySQL? - by Jing_Chan - 30.07.2018, 11:35
Re: Skin doesn't load from MySQL? - by Rufio - 30.07.2018, 12:36

Forum Jump:


Users browsing this thread: 1 Guest(s)