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

Threaded Mode
My Sql Saving (URGENT) Thank you!
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#1

14.06.2015, 04:36
I know, it's wrong cuz it doesn't save. But when i compile it's fine. Anyone help me. I need to make it in double way

PHP код:
forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[500];
    pInfo[playerid][pSkinID] = GetPlayerSkin(playerid);
    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, `BankMoney`=%d, `Score`=%d, `Deaths`=%d, `Kills`=%d, `SkinID`=%d, `WantedLevel`=%d, `Bounty`=%d, `BountyHour`=%d, `BountyMinute`=%d, `BountyPlacedOn`=%d, `BountyPlacedBy`=%d WHERE `ID`=%d AND `user`='%e'",
        pInfo[playerid][pAdmin],
        pInfo[playerid][pVip],
        GetPlayerMoney(playerid),
        pInfo[playerid][pBankMoney],
        GetPlayerScore(playerid),
        pInfo[playerid][pDeaths],
        pInfo[playerid][pKills],
        GetPlayerSkin(playerid),
        pInfo[playerid][pWantedLevel],
        pInfo[playerid][pBounty],
        pInfo[playerid][pBountyHour],
        pInfo[playerid][pBountyMinute],
        pInfo[playerid][pBountyPlacedOn],
        pInfo[playerid][pBountyPlacedBy],
        pInfo[playerid][pID],
        PlayerName(playerid));
        mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d, `StoreRobbed`=%d, `StoreRobbedMoney`=%d, `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d WHERE `ID`=%d AND `user`='%e'",
        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][pID],
        PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        print(query); 
Find
Reply
FplayerGR
Big Clucker
***
Posts: 83
Threads: 7
Joined: May 2015
Reputation: 0
#2

14.06.2015, 05:06
this?

Код:
forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[500];
    pInfo[playerid][pSkinID] = GetPlayerSkin(playerid);
    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, `BankMoney`=%d, `Score`=%d, `Deaths`=%d, `Kills`=%d, `SkinID`=%d, `WantedLevel`=%d, `Bounty`=%d, `BountyHour`=%d, `BountyMinute`=%d, `BountyPlacedOn`=%d, `BountyPlacedBy`=%d WHERE `ID`=%d AND `user`='%e'",
        pInfo[playerid][pAdmin],
        pInfo[playerid][pVip],
        GetPlayerMoney(playerid),
        pInfo[playerid][pBankMoney],
        GetPlayerScore(playerid),
        pInfo[playerid][pDeaths],
        pInfo[playerid][pKills],
        GetPlayerSkin(playerid),
        pInfo[playerid][pWantedLevel],
        pInfo[playerid][pBounty],
        pInfo[playerid][pBountyHour],
        pInfo[playerid][pBountyMinute],
        pInfo[playerid][pBountyPlacedOn],
        pInfo[playerid][pBountyPlacedBy],
        pInfo[playerid][pID],
        PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d, `StoreRobbed`=%d, `StoreRobbedMoney`=%d, `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d WHERE `ID`=%d AND `user`='%e'",
        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][pID],
        PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        print(query);
	}
}
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#3

14.06.2015, 05:14
im getting an error about the line is too big. what if i change new query[500]; size? would be fine? i want make it in 1 line.

i mean, i want make this in 1 line.

mysql_format(MySQLCon, query, sizeof(query), "UPDATe
Find
Reply
FplayerGR
Big Clucker
***
Posts: 83
Threads: 7
Joined: May 2015
Reputation: 0
#4

14.06.2015, 05:22
you can use '/' for new line.
this?

Код:
forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[500];
    pInfo[playerid][pSkinID] = GetPlayerSkin(playerid);
    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, `BankMoney`=%d, `Score`=%d, `Deaths`=%d, `Kills`=%d, `SkinID`=%d, `WantedLevel`=%d, `Bounty`=%d, `BountyHour`=%d, `BountyMinute`=%d, `BountyPlacedOn`=%d, `BountyPlacedBy`=%d WHERE `ID`=%d AND `user`='%e'", \
        pInfo[playerid][pAdmin], \
        pInfo[playerid][pVip], \
        GetPlayerMoney(playerid), \
        pInfo[playerid][pBankMoney], \
        GetPlayerScore(playerid), \
        pInfo[playerid][pDeaths], \
        pInfo[playerid][pKills], \
        GetPlayerSkin(playerid), \
        pInfo[playerid][pWantedLevel], \
        pInfo[playerid][pBounty], \
        pInfo[playerid][pBountyHour], \
        pInfo[playerid][pBountyMinute], \
        pInfo[playerid][pBountyPlacedOn], \
        pInfo[playerid][pBountyPlacedBy], \
        pInfo[playerid][pID], \
        PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d, `StoreRobbed`=%d, `StoreRobbedMoney`=%d, `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d WHERE `ID`=%d AND `user`='%e'", \
        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][pID], \
        PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        print(query);
	}
}
Find
Reply
]Rafaellos[
Gangsta
****
Posts: 731
Threads: 29
Joined: Feb 2012
Reputation: 0
#5

14.06.2015, 05:26
You have to use strcat.
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#6

14.06.2015, 05:45
I don't want to use new line. Actually, I mean, it should be like this.

PHP код:
forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[500];
    pInfo[playerid][pSkinID] = GetPlayerSkin(playerid);
    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, `BankMoney`=%d, `Score`=%d, `Deaths`=%d, `Kills`=%d, `SkinID`=%d, `WantedLevel`=%d, `Bounty`=%d, `BountyHour`=%d, `BountyMinute`=%d, `BountyPlacedOn`=%d, `BountyPlacedBy`=%d WHERE `ID`=%d AND `user`='%e'", 
        mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d, `StoreRobbed`=%d, `StoreRobbedMoney`=%d, `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d WHERE `ID`=%d AND `user`='%e'", 
        pInfo[playerid][pAdmin], 
        pInfo[playerid][pVip], 
        GetPlayerMoney(playerid), 
        pInfo[playerid][pBankMoney], 
        GetPlayerScore(playerid), 
        pInfo[playerid][pDeaths], 
        pInfo[playerid][pKills], 
        GetPlayerSkin(playerid), 
        pInfo[playerid][pWantedLevel], 
        pInfo[playerid][pBounty], 
        pInfo[playerid][pBountyHour], 
        pInfo[playerid][pBountyMinute], 
        pInfo[playerid][pBountyPlacedOn], 
        pInfo[playerid][pBountyPlacedBy], 
        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][pID], 
        PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        print(query);
    }
} 
But i know this is wrong format. I want to know how to make double line together like this.

PHP код:
 mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `Admin`=%d, `Vip`=%d, `Money`=%d, `BankMoney`=%d, `Score`=%d, `Deaths`=%d, `Kills`=%d, `SkinID`=%d, `WantedLevel`=%d, `Bounty`=%d, `BountyHour`=%d, `BountyMinute`=%d, `BountyPlacedOn`=%d, `BountyPlacedBy`=%d WHERE `ID`=%d AND `user`='%e'", 
mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d, `StoreRobbed`=%d, `StoreRobbedMoney`=%d, `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d WHERE `ID`=%d AND `user`='%e'", 
If i change

PHP код:
new query[500]; 
500 to 1500. So can i add these 2 line mysql_format in one line.?
Find
Reply
FplayerGR
Big Clucker
***
Posts: 83
Threads: 7
Joined: May 2015
Reputation: 0
#7

14.06.2015, 06:05
this?

Код:
forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[1000];
    pInfo[playerid][pSkinID] = GetPlayerSkin(playerid);
    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, `BankMoney`=%d, `Score`=%d, `Deaths`=%d, `Kills`=%d, `SkinID`=%d, `WantedLevel`=%d, `Bounty`=%d, `BountyHour`=%d, `BountyMinute`=%d, `BountyPlacedOn`=%d, `BountyPlacedBy`=%d, \
        `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d, `StoreRobbed`=%d, `StoreRobbedMoney`=%d, `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d \
		 WHERE `ID`=%d AND `user`='%e'", \
        pInfo[playerid][pAdmin], \
        pInfo[playerid][pVip], \
        GetPlayerMoney(playerid), \
        pInfo[playerid][pBankMoney], \
        GetPlayerScore(playerid), \
        pInfo[playerid][pDeaths], \
        pInfo[playerid][pKills], \
        GetPlayerSkin(playerid), \
        pInfo[playerid][pWantedLevel], \
        pInfo[playerid][pBounty], \
        pInfo[playerid][pBountyHour], \
        pInfo[playerid][pBountyMinute], \
        pInfo[playerid][pBountyPlacedOn], \
        pInfo[playerid][pBountyPlacedBy], \
        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][pID], \
        PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        print(query);
    }
}
'So can i add these 2 line mysql_format in one line.?'

no the only result that will churn is enforceable only

Код:
mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d, `StoreRobbed`=%d, `StoreRobbedMoney`=%d, `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d WHERE `ID`=%d AND `user`='%e'",
To run two formats must send one after the other.

end if you have string counter set new query[to your count]; For best performance.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


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