MYSQL QUESTION
#10

Pls stop using so long arrays for so small querys.
And ID must be auto increcement
PHP код:
public SavePlayerData(playerid

    if(
IsLoggedIn[playerid] && IsPlayerConnected(playerid) && !IsPlayerNPC(playerid)) 
    { 
        new 
query[200];
        
mysql_format(mysql,query,sizeof(query),"UPDATE users SET Admin='%d',Donator='%d',RegularPlayer='%d',Money='%d',BankMoney='%d',\
        Score='%d',Deaths='%d',Kills='%d' WHERE ID ='%d'"
,pData[playerid][pAdmin],pData[playerid][pDonator],pData[playerid][pRegularPlayer],
        
GetPlayerCash(playerid),pData[playerid][pBankMoney],GetPlayerScore(playerid),pData[playerid][pDeaths],pData[playerid][pKills],pData[playerid][pID]);
        
mysql_tquery(mysqlquery); 
    } 
    return 
1

Reply


Messages In This Thread
MYSQL QUESTION - by STONEGOLD - 09.07.2015, 22:18
Re: URGENT MYSQL QUESTION - by Sime30 - 09.07.2015, 22:25
Re: URGENT MYSQL QUESTION - by ExTaZZ69 - 09.07.2015, 22:26
Re: URGENT MYSQL QUESTION - by STONEGOLD - 09.07.2015, 22:26
Re: URGENT MYSQL QUESTION - by STONEGOLD - 09.07.2015, 23:06
Re: URGENT MYSQL QUESTION - by STONEGOLD - 09.07.2015, 23:10
Re: URGENT MYSQL QUESTION - by STONEGOLD - 10.07.2015, 00:09
Re: URGENT MYSQL QUESTION - by STONEGOLD - 10.07.2015, 09:31
Re: URGENT MYSQL QUESTION - by STONEGOLD - 10.07.2015, 10:21
Re: URGENT MYSQL QUESTION - by CodeStyle175 - 10.07.2015, 10:32
Re: URGENT MYSQL QUESTION - by STONEGOLD - 10.07.2015, 10:54
Re: URGENT MYSQL QUESTION - by STONEGOLD - 10.07.2015, 12:33
Re: URGENT MYSQL QUESTION - by CodeStyle175 - 10.07.2015, 12:39
Re: URGENT MYSQL QUESTION - by !damo!spiderman - 10.07.2015, 12:42
Re: URGENT MYSQL QUESTION - by ev0lution - 10.07.2015, 12:44
Re: URGENT MYSQL QUESTION - by woot - 10.07.2015, 13:18
Re: MYSQL QUESTION - by STONEGOLD - 10.07.2015, 13:28
Re: MYSQL QUESTION - by CodeStyle175 - 10.07.2015, 13:32
Re: MYSQL QUESTION - by STONEGOLD - 10.07.2015, 14:24
Re: MYSQL QUESTION - by STONEGOLD - 10.07.2015, 15:53
Re: MYSQL QUESTION - by woot - 10.07.2015, 16:52
[No subject] - by STONEGOLD - 10.07.2015, 18:32
Re: MYSQL QUESTION - by STONEGOLD - 10.07.2015, 21:22
Re: MYSQL QUESTION - by STONEGOLD - 10.07.2015, 23:55

Forum Jump:


Users browsing this thread: 6 Guest(s)