MySQL not saving please help
#7

Quote:
Originally Posted by Wizz123
Посмотреть сообщение
* yuvraj201 cries.
Its %d not '%d' and would you mind telling me why you set a / after each parameter?
pawn Код:
public OnPlayerDisconnect(playerid, reason)
{
    new query[1004];
    new otherp[128];
    GetPlayerIp(playerid, otherp, sizeof(otherp));
    format(query, sizeof(query), "UPDATE `users` SET `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],
    otherp,
    TerroristSkill[playerid],
    RobSkill[playerid],
    HasPackC4[playerid],
    HasPackRope[playerid],
    HasPackMoney[playerid],
    SavedWantedLevel[playerid],
    SavedJailTime[playerid],
    Coprank[playerid],
    TotalPlayedTime[playerid][0],
    TotalPlayedTime[playerid][1],
    TotalPlayedTime[playerid][2],
    PlayerName(playerid));
    mysql_query(query);
    return 1;
}
THANKS!! WORKED +REP
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: 2 Guest(s)