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

Threaded Mode
MYSQL Saving
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#1

29.06.2015, 23:39
PHP код:
///mysql start
forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[500];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `Admin`=%d, `Vip`=%d, `Money`=%d, `Score`=%d, `Deaths`=%d, `Kills`=%d, `HitsCompleted`=%d, `SkinID`=%d, `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d, `StoreRobbed`=%d, `StoreRobbedMoney`=%d, `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d, `Healed`=%d, `Arrest`=%d, `Busted`=%d, `Crimes`=%d, `WantedLevel`=%d, `Drugs`=%d, `Medical`=%d WHERE `ID`=%d AND `user`='%e'",
        pInfo[playerid][pAdmin],
        pInfo[playerid][pVip],
        GetPlayerMoney(playerid),
        GetPlayerScore(playerid),
        pInfo[playerid][pDeaths],
        pInfo[playerid][pKills],
        pInfo[playerid][pHitsCompleted],
        GetPlayerSkin(playerid),
        pInfo[playerid][pRobbed],
        pInfo[playerid][pRobbedMoney],
        pInfo[playerid][pGotRobbed],
        pInfo[playerid][pGotRobbedMoney],
        pInfo[playerid][pStoreRobbed],
        pInfo[playerid][pStoreRobbedMoney],
        pInfo[playerid][pFoodPurchased],
        pInfo[playerid][pFoodPurchasedMoney],
        pInfo[playerid][pWeaponsPurchased],
        pInfo[playerid][pWeaponsPurchasedMoney],
        pInfo[playerid][pHealed],
        pInfo[playerid][pArrest],
        pInfo[playerid][pBusted],
        pInfo[playerid][pCrimes],
        pInfo[playerid][pWantedLevel],
        pInfo[playerid][pDrugs],
        pInfo[playerid][pMedical],
        pInfo[playerid][pID],
        PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        print(query);
    }
    return 1;
} 
PHP код:
5475) : error 075: input line too long (after substitutions) 
Well, I'm sorry. This is my second/thrid threads about it. I'm still stuck at this and not getting and don't know what to do. I have tried many times but still stuck. So, I would be your thankful if you guyz help me and get me out of this problem. Thanks!
Find
Reply
nezo2001
Gangsta
****
Posts: 680
Threads: 143
Joined: Nov 2014
Reputation: 0
#2

29.06.2015, 23:48
Do it on two queries like this
PHP код:
   new update1[300];
    format(update1,sizeof(update1),"UPDATE users SET pMoney='%i', pAdmin='%i', pSkin='%i', pScore='%i', pPolice='%i', pGang='%i', pHorseshoes='%i', pDealer='%i', pWarnings='%i' WHERE pName = '%s'",GetPlayerMoney(playerid), PlayerInfo[playerid][pAdmin], GetPlayerSkin(playerid), GetPlayerScore(playerid), PlayerInfo[playerid][pPolice], PlayerInfo[playerid][pGang], PlayerInfo[playerid][pHorseshoes], PlayerInfo[playerid][pDealer], PlayerInfo[playerid][pWarnings], PlayerName(playerid));
    mysql_query(1, update1);
    new update2[128];
    format(update2, sizeof(update2), "UPDATE users SET pJob='%i', pHouseID='%i' WHERE pName='%s'", PlayerInfo[playerid][pJob], PlayerInfo[playerid][pHouseID], PlayerName(playerid));
    mysql_query(1, update2); 
Find
Reply
kloning1
Huge Clucker
***
Posts: 247
Threads: 70
Joined: Mar 2014
Reputation: 0
#3

30.06.2015, 05:38
[U] maybe will be help you
PHP код:
///mysql start
forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[500];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query,sizeof(query), "UPDATE `players` SET `Admin`=%d, `Vip`=%d, `Money`=%d, `Score`=%d, `Deaths`=%d, `Kills`=%d, `HitsCompleted`=%d, `SkinID`=%d, `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d,`StoreRobbed`=%d, `StoreRobbedMoney`=%d,",
        pInfo[playerid][pAdmin],pInfo[playerid][pVip],GetPlayerMoney(playerid),GetPlayerScore(playerid),pInfo[playerid][pDeaths],pInfo[playerid][pKills],pInfo[playerid][pHitsCompleted],GetPlayerSkin(playerid),pInfo[playerid][pRobbed],pInfo[playerid][pRobbedMoney],pInfo[playerid][pGotRobbed],pInfo[playerid][pGotRobbedMoney],pInfo[playerid][pStoreRobbed],pInfo[playerid][pStoreRobbedMoney]);
        
        format(query,sizeof(query), "%s `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d,`Healed`=%d, `Arrest`=%d, `Busted`=%d, `Crimes`=%d, `WantedLevel`=%d, `Drugs`=%d, `Medical`=%d WHERE `ID`=%d AND `user`='%e'",
        query,pInfo[playerid][pFoodPurchased],pInfo[playerid][pFoodPurchasedMoney],pInfo[playerid][pWeaponsPurchased],pInfo[playerid][pWeaponsPurchasedMoney],pInfo[playerid][pHealed],pInfo[playerid][pArrest],pInfo[playerid][pBusted],pInfo[playerid][pCrimes],pInfo[playerid][pWantedLevel],pInfo[playerid][pDrugs],pInfo[playerid][pMedical],pInfo[playerid][pID],PlayerName(playerid));
        mysql_tquery(MySQLCon, query);
        print(query);
    }
    return 1;
} 
[php]
Find
Reply
Cheesus
Big Clucker
***
Posts: 105
Threads: 15
Joined: Aug 2012
Reputation: 0
#4

30.06.2015, 08:33
or use strcat
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#5

30.06.2015, 09:25
i tried to use stract but it doesn't update. Maybe i did wrong. Can you explain with codes?
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#6

30.06.2015, 10:15
Well, I'm test this if it works or what.

PHP код:
  new query[500];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query,sizeof(query), "UPDATE `players` SET `Money`=%d, `Score`=%d",
        GetPlayerMoney(playerid),GetPlayerScore(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        format(query,sizeof(query), "`Medical`=%d WHERE `user`='%e'",
        pInfo[playerid][pMedical],PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        print(query);
    } 
it only update MONEY and SCORE. It doesn't update medical. What's wrng? Im trying to split it in two lines . Anyone can tell me how can i do that with stract?
Find
Reply
Suicidal.Banana
Big Clucker
***
Posts: 138
Threads: 1
Joined: Jul 2007
Reputation: 0
#7

30.06.2015, 10:32
Your missing a comma after
Код:
`Score`=%d
and before
Код:
`Medical`=%d
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#8

30.06.2015, 10:37
Isn't they are find and same? I can't see i am missing. Can you post code ?

`Score`=%d"
"`Medical`=%d

Where i am missing?

anyways, I updated into stract but it doesn't save.

PHP код:
public OnPlayerSave(playerid)
{
    new query[500];
    new tmp[64];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query, sizeof(query), "UPDATE `players` SET " );
       
        format(tmp, sizeof(tmp), "`Money`=%d, ", GetPlayerMoney(playerid) );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Score`=%d, ", GetPlayerScore(playerid) );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Medical`=%d, ", pInfo[playerid][pMedical] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "WHERE `ID`= %d AND `user`= '%e'", pInfo[playerid][pID], PlayerName(playerid) );
        strcat(query, tmp);
        mysql_tquery(MySQLCon, query, "", "");
    }
    return 1;
} 
What's wrong with it. It doesn't saving.
Find
Reply
Suicidal.Banana
Big Clucker
***
Posts: 138
Threads: 1
Joined: Jul 2007
Reputation: 0
#9

30.06.2015, 11:08
Your previous version was missing a comma, your current version has to much comma's

Try this:
Код:
public OnPlayerSave(playerid)
{
    new query[500];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query, sizeof(query), 
		"UPDATE `players` SET `Money`='%d', `Score`='%d', `Medical`='%d' WHERE `ID`='%d' AND `user`= '%e'", 
		GetPlayerMoney(playerid), 
		GetPlayerScore(playerid), 
		pInfo[playerid][pMedical],
		pInfo[playerid][pID],
		PlayerName(playerid)
	);
        mysql_tquery(MySQLCon, query, "", "");
    }
    return 1;
}
Comments:
- Not sure what mysql_tquery must be, but pretty sure its a typo, and it should be mysql_query instead.
- "Money" "Score" "Medical" and "ID" columns might not have any capitals, like "user"? double-check the column names if the above doesnt work

Alternatively, you may just want the code you pasted fixed, see the below for that:
Код:
public OnPlayerSave(playerid)
{
    new query[500];
    new tmp[64];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query, sizeof(query), "UPDATE `players` SET " );
       
        format(tmp, sizeof(tmp), "`Money`='%d', ", GetPlayerMoney(playerid) );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Score`='%d', ", GetPlayerScore(playerid) );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Medical`='%d' ", pInfo[playerid][pMedical] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "WHERE `ID`= %d AND `user`= '%e'", pInfo[playerid][pID], PlayerName(playerid) );
        strcat(query, tmp);
        mysql_tquery(MySQLCon, query, "", "");
    }
    return 1;
}
Compare the "Money", "Score" and "Medical" lines with the ones from your example, ive added single-quotation marks (') and removed the comma you added too the end of "Medical"
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#10

30.06.2015, 11:11
Dude, I was using this ^^ what you posted but when i add more stats then in the end i get this;

: error 075: input line too long (after substitutions)

That's the reason i want to change it into stract because i can add much as i want.
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