MySQL not saving please help
#1

When a player disconnects it dosent save his stuff why??

pawn Код:
public OnPlayerDisconnect(playerid, reason)
{
    new query[1004];
    format(query, sizeof(query), "UPDATE users SET \
    new otherp[128];
    GetPlayerIp(playerid, otherp, sizeof(otherp));
    Money = '%d', \
    Bankcash = '%d',\
    Cash = '%d',\
    Score = '%d',\
    Adminlevel = '%d',\
    Army = '%d',\
    CIA = '%d',\
    RegularPlayer = '%d',\
    DrugHouseOwner = '%d',\
    OttoOwner = '%d',\
    TSkill = '%d',\
    RobSkill = '%d' ,\
    HasPackC4 = '%d',\
    HasPackRope = '%d',\
    HasPackMoney = '%d', \
    SavedWantedLevel = '%d' ,\
    SavedJailTime = '%d',\
    Coprank = '%d',\
    HoursPlayed = '%d',\
    MinutesPlayed = '%d',\
    SecondsPlayed = '%d',\
    IpAdress = '%s'\
    WHERE Username = '%s'"
,
    GetPlayerMoney(playerid),
    BankCash[playerid],
    GetPlayerMoney(playerid),
    GetPlayerScore(playerid),
    AdminLevel[playerid],
    CanUseArmy[playerid],
    CanUseCIA[playerid],
    IsRegularPlayer[playerid],
    DrugHouseOwner[playerid],
    OttoOwner[playerid],
    TerroristSkill[playerid],
    RobSkill[playerid],
    HasPackC4[playerid],
    HasPackRope[playerid],
    HasPackMoney[playerid],
    SavedWantedLevel[playerid],
    SavedJailTime[playerid],
    PlayerName(playerid));
    mysql_query(query);
    return 1;
}
Reply


Messages In This Thread
MySQL not saving please help - by yuvraj201 - 25.01.2014, 22:12
Re: MySQL not saving please help - by Ranshand - 25.01.2014, 22:25
Re: MySQL not saving please help - by McBan - 25.01.2014, 22:25
Re: MySQL not saving please help - by yuvraj201 - 25.01.2014, 22:27
Re: MySQL not saving please help - by Wizz123 - 25.01.2014, 22:30
Re: MySQL not saving please help - by iZN - 25.01.2014, 22:33
Re: MySQL not saving please help - by yuvraj201 - 25.01.2014, 22:39

Forum Jump:


Users browsing this thread: 1 Guest(s)