1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
MySQL not saving please help
yuvraj201
Big Clucker
***
Posts: 72
Threads: 30
Joined: Jan 2013
Reputation: 0
#1

25.01.2014, 22:12
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;
}
Find
Reply
Ranshand
Little Clucker
**
Posts: 25
Threads: 2
Joined: Jan 2014
Reputation: 0
#2

25.01.2014, 22:25
Try this.
Код:
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],
    TerroristSkill[playerid],
    RobSkill[playerid],
    HasPackC4[playerid],
    HasPackRope[playerid],
    HasPackMoney[playerid],
    SavedWantedLevel[playerid],
    SavedJailTime[playerid],
    PlayerName(playerid));
    mysql_query(query);
    return 1;
}
Find
Reply
McBan
Huge Clucker
***
Posts: 237
Threads: 38
Joined: Apr 2012
Reputation: 0
#3

25.01.2014, 22:25
Post your OnPlayerConnect, Maybe its not loading it properly
Find
Reply
yuvraj201
Big Clucker
***
Posts: 72
Threads: 30
Joined: Jan 2013
Reputation: 0
#4

25.01.2014, 22:27
Quote:
Originally Posted by Ranshand
Посмотреть сообщение
Try this.
Код:
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],
    TerroristSkill[playerid],
    RobSkill[playerid],
    HasPackC4[playerid],
    HasPackRope[playerid],
    HasPackMoney[playerid],
    SavedWantedLevel[playerid],
    SavedJailTime[playerid],
    PlayerName(playerid));
    mysql_query(query);
    return 1;
}
You didnt change a shit and no it didnt work.
Find
Reply
Wizz123
Big Clucker
***
Posts: 85
Threads: 10
Joined: Jan 2012
Reputation: 0
#5

25.01.2014, 22:30
* Wizz123 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;
}
Find
Reply
iZN
High-roller
*****
Posts: 2,368
Threads: 27
Joined: Jun 2010
Reputation: 0
#6

25.01.2014, 22:33
Firstly, it is not really important to add ' or `. Just remove them or properly fix them.

pawn Код:
UPDATE `users` SET `Money` = '%d', `Bankcash` = '%d', // .... continue
Simple:
pawn Код:
UPDATE users SET Money=%d, Bankcash=%d, // .... continue
Find
Reply
yuvraj201
Big Clucker
***
Posts: 72
Threads: 30
Joined: Jan 2013
Reputation: 0
#7

25.01.2014, 22:39
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
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help