Skin doesn't load from MySQL?
#5

seems like your updating data query has an issue.
PHP код:
`HEADSHOTSWHERE `ID` = %d LIMIT 1 
has to be:
PHP код:
`HEADSHOTS` = %d WHERE `ID` = %d LIMIT 1 
so ->
PHP код:
    mysql_format(DatabaseDB_Querysizeof(DB_Query), "UPDATE `PLAYERS` SET `SCORE` = %d, `CASH` = %d, `KILLS` = %d, `DEATHS` = %d, `ADMIN` = %d, `SKIN` = %d, `DONATOR` = %d, `NAMECHANGES` = %d, `HEADSHOTS`= %d 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]); 
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)