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

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

05.07.2015, 10:45
PHP код:
stock SavePlayerData(playerid)
{
    new query[256];
    new tmp[128];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query, sizeof(query), "UPDATE `players` SET " );
        format(tmp, sizeof(tmp), "`Admin`='%d', ", pData[playerid][pAdmin]);
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "`Vip`='%d', ", pData[playerid][pVip]);
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "`Money`='%d' ", GetPlayerCash(playerid));
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`BankCash`='%d' ", pData[playerid][pBankMoney]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Score`='%d' ", GetPlayerScore(playerid));
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "`Deaths`='%d' ", pData[playerid][pDeaths]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Kills`='%d' ", pData[playerid][pKills]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`HitsC`='%d' ", pData[playerid][pHitsCompleted]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Skin`='%d' ", GetPlayerSkin(playerid));
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Rob`='%d' ", pData[playerid][pRobbed]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`RobCash`='%d' ", pData[playerid][pRobbedMoney]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`GotRob`='%d' ", pData[playerid][pGotRobbed]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`GotRobCash`='%d' ", pData[playerid][pGotRobbedMoney]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`StoreRob`='%d' ", pData[playerid][pStoreRobbed]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`StoreRobCash`='%d' ", pData[playerid][pStoreRobbedMoney]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`FoodPur`='%d' ", pData[playerid][pFoodPurchased]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`FoodPurCash`='%d' ", pData[playerid][pFoodPurchasedMoney]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`WeaponsPur`='%d' ", pData[playerid][pWeaponsPurchased]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`WeaponsPurCash`='%d' ", pData[playerid][pWeaponsPurchasedMoney]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Healed`='%d' ", pData[playerid][pHealed]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Arrest`='%d' ", pData[playerid][pArrest]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Busted`='%d' ", pData[playerid][pBusted]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Crimes`='%d' ", pData[playerid][pCrimes]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`WantedL`='%d' ", pData[playerid][pWantedLevel]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Drugs`='%d' ", pData[playerid][pDrugs]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`DrugsB`='%d' ", pData[playerid][pDrugsBought]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`DC`='%d' ", pData[playerid][pDrugsCash]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`DS`='%d' ", pData[playerid][pDrugsSell]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`DSC`='%d' ", pData[playerid][pDrugsSellCash]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Medical`='%d' ", pData[playerid][pMedical]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Min`='%d' ", pData[playerid][pMins]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Hour`='%d' ", pData[playerid][pHours]);
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`vLK`='%d' ", pData[playerid][pLock]);
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "WHERE `ID`= %d AND `Username`= '%e'", pData[playerid][pID],  Name[playerid] );
        strcat(query, tmp);
        mysql_tquery(mysql, query, "", "");
    }
        
    return 1;
}
//let's load player's information
public OnAccountLoad(playerid)
{
    SetPlayerColor(playerid, -1);
    pData[playerid][pAdmin] = cache_get_field_content_int(0, "Admin");
    pData[playerid][pVip] = cache_get_field_content_int(0, "Vip");
    pData[playerid][pMoney] = cache_get_field_content_int(0, "Money");
    pData[playerid][pBankMoney] = cache_get_field_content_int(0, "BankCash");
    pData[playerid][pScore] = cache_get_field_content_int(0, "Score");
    pData[playerid][pDeaths] = cache_get_field_content_int(0, "Deaths");
    pData[playerid][pKills] = cache_get_field_content_int(0, "Kills");
    pData[playerid][pHitsCompleted] = cache_get_field_content_int(0, "HitsC");
    pData[playerid][pSkinID] = cache_get_field_content_int(0, "Skin");
    pData[playerid][pRobbed] = cache_get_field_content_int(0, "Rob");
    pData[playerid][pRobbedMoney] = cache_get_field_content_int(0, "RobCash");
    pData[playerid][pGotRobbed] = cache_get_field_content_int(0, "GotRob");
    pData[playerid][pGotRobbedMoney] = cache_get_field_content_int(0, "GotRobCash");
    pData[playerid][pStoreRobbed] = cache_get_field_content_int(0, "StoreRob");
    pData[playerid][pStoreRobbedMoney] = cache_get_field_content_int(0, "StoreRobCash");
    pData[playerid][pFoodPurchased] = cache_get_field_content_int(0, "FoodPur");
    pData[playerid][pFoodPurchasedMoney] = cache_get_field_content_int(0, "FoodPurCash");
    pData[playerid][pWeaponsPurchased] = cache_get_field_content_int(0, "WeaponsPur");
    pData[playerid][pWeaponsPurchasedMoney] = cache_get_field_content_int(0, "WeaponsPurCash");
    pData[playerid][pHealed] = cache_get_field_content_int(0, "Healed");
    pData[playerid][pArrest] = cache_get_field_content_int(0, "Arrest");
    pData[playerid][pBusted] = cache_get_field_content_int(0, "Busted");
    pData[playerid][pCrimes] = cache_get_field_content_int(0, "Crimes");
    pData[playerid][pWantedLevel] = cache_get_field_content_int(0, "WantedL");
    pData[playerid][pDrugs] = cache_get_field_content_int(0, "Drugs");
    pData[playerid][pDrugsBought] = cache_get_field_content_int(0, "DrugsB");
    pData[playerid][pDrugsCash] = cache_get_field_content_int(0, "DC");
    pData[playerid][pDrugsCash] = cache_get_field_content_int(0, "DS");
    pData[playerid][pDrugsCash] = cache_get_field_content_int(0, "DSC");
    pData[playerid][pMedical] = cache_get_field_content_int(0, "Medical");
    pData[playerid][pMins] = cache_get_field_content_int(0, "Min");
    pData[playerid][pHours] = cache_get_field_content_int(0, "Hour");
    pData[playerid][pLock] = cache_get_field_content_int(0, "vLK");
    SetPlayerCash(playerid, pData[playerid][pMoney]);
    SetPlayerScore(playerid, pData[playerid][pScore]);
    SetPlayerSkin(playerid, pData[playerid][pSkinID]);
    IsLoggedIn[playerid] = 1;
    TogglePlayerSpectating(playerid, 0);
    if(pData[playerid][pAdmin] != 0) SendClientMessage(playerid, COLOR_RED, "You have logged in as an administrator. Use [/acmds] to see your commands.");
    SendClientMessage(playerid, COLOR_CYAN, "You have been logged in, Continue your current life.");
    return 1;
} 
SQL LOG:

http://pastebin.com/xiKtLHYa .

PHP код:
[15:40:26] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[15:40:48] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`='0', `Vip`='0', `Money`='44000' `Ba", callback: "(null)", format: "(null)"
[15:40:48] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[15:40:48] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prиs de '`BankCash`='0' `Score`='0' `Deaths`='1' `Kills`='0' `HitsC`='0' `Skin`='297' `Ro' а la ligne 1
[15:40:48] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[15:40:49] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `players` WHERE `Username` = '%e' LIMIT 1"
[15:40:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `players` WHERE `Username` = 'JerryCo' LIMIT 1", callback: "OnAccountCheck", format: "i" 
I don't see anything. So, i tho let me post here if you guyz can find.
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#2

05.07.2015, 11:12
Updated:

PHP код:

        new query[256];
    new tmp[128];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query, sizeof(query), "UPDATE `players` SET " );
        format(tmp, sizeof(tmp), "`Admin`=%d, ", pData[playerid][pAdmin] );
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "`Vip`=%d, ", pData[playerid][pVip] );
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "`Money`=%d, ", GetPlayerCash(playerid) );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`BankCash`=%d, ", pData[playerid][pBankMoney] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Score`=%d, ", GetPlayerScore(playerid) );
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "`Deaths`=%d, ", pData[playerid][pDeaths] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Kills`=%d, ", pData[playerid][pKills] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`HitsC`=%d, ", pData[playerid][pHitsCompleted] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Skin`=%d, ", GetPlayerSkin(playerid) );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Rob`=%d, ", pData[playerid][pRobbed] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`RobCash`=%d, ", pData[playerid][pRobbedMoney] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`GotRob`=%d, ", pData[playerid][pGotRobbed] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`GotRobCash`=%d, ", pData[playerid][pGotRobbedMoney] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`StoreRob`=%d, ", pData[playerid][pStoreRobbed] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`StoreRobCash`=%d, ", pData[playerid][pStoreRobbedMoney] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`FoodPur`=%d, ", pData[playerid][pFoodPurchased] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`FoodPurCash`=%d, ", pData[playerid][pFoodPurchasedMoney] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`WeaponsPur`=%d, ", pData[playerid][pWeaponsPurchased] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`WeaponsPurCash`=%d, ", pData[playerid][pWeaponsPurchasedMoney] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Healed`=%d, ", pData[playerid][pHealed] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Arrest`=%d, ", pData[playerid][pArrest] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Busted`=%d, ", pData[playerid][pBusted] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Crimes`=%d, ", pData[playerid][pCrimes] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`WantedL`=%d, ", pData[playerid][pWantedLevel] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Drugs`=%d, ", pData[playerid][pDrugs] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`DrugsB`=%d, ", pData[playerid][pDrugsBought] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`DC`=%d, ", pData[playerid][pDrugsCash] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`DS`=%d, ", pData[playerid][pDrugsSell] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`DSC`=%d, ", pData[playerid][pDrugsSellCash] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Medical`=%d, ", pData[playerid][pMedical] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Min`=%d, ", pData[playerid][pMins] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`Hour`=%d, ", pData[playerid][pHours] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`vLK`=%d, ", pData[playerid][pLock] );
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "WHERE `ID`= %d AND `Username`= '%e'", pData[playerid][pID],  Name[playerid] );
        strcat(query, tmp);
        mysql_tquery(mysql, query, "", "");
    }
    return 1;
} 
now this error

PHP код:
[16:30:21] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=0, `Vip`=0, `Money`=50000, `BankCas", callback: "(null)", format: "(null)"
[16:30:21] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[16:30:21] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prиs de '' а la ligne 1
[16:30:21] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError 
Find
Reply
dusk
High-roller
*****
Posts: 1,113
Threads: 127
Joined: Jul 2008
Reputation: 0
#3

05.07.2015, 11:35
pawn Код:
format(tmp, sizeof(tmp), "`vLK`=%d ", pData[playerid][pLock] ); 
strcat(query, tmp); 

format(tmp, sizeof(tmp), "WHERE `ID`= %d AND `Username`= '%e'", pData[playerid][pID],  Name[playerid] ); 
strcat(query, tmp);
You do not need ',' before the WHERE clause.
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#4

05.07.2015, 11:40
After doing this ^^

PHP код:
[16:39:52] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:40:00] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=0, `Vip`=0, `Money`=50000, `BankCas", callback: "(null)", format: "(null)"
[16:40:00] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[16:40:00] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prиs de '' а la ligne 1
[16:40:00] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError 
PHP код:
    new query[256];
    new tmp[128];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query, sizeof(query), "UPDATE `players` SET " );

        format(tmp, sizeof(tmp), "`Admin`=%d, ", pData[playerid][pAdmin] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Vip`=%d, ", pData[playerid][pVip] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Money`=%d, ", GetPlayerCash(playerid) );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`BankCash`=%d, ", pData[playerid][pBankMoney] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Score`=%d, ", GetPlayerScore(playerid) );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Deaths`=%d, ", pData[playerid][pDeaths] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Kills`=%d, ", pData[playerid][pKills] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`HitsC`=%d, ", pData[playerid][pHitsCompleted] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Skin`=%d, ", GetPlayerSkin(playerid) );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Rob`=%d, ", pData[playerid][pRobbed] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`RobCash`=%d, ", pData[playerid][pRobbedMoney] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`GotRob`=%d, ", pData[playerid][pGotRobbed] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`GotRobCash`=%d, ", pData[playerid][pGotRobbedMoney] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`StoreRob`=%d, ", pData[playerid][pStoreRobbed] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`StoreRobCash`=%d, ", pData[playerid][pStoreRobbedMoney] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`FoodPur`=%d, ", pData[playerid][pFoodPurchased] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`FoodPurCash`=%d, ", pData[playerid][pFoodPurchasedMoney] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`WeaponsPur`=%d, ", pData[playerid][pWeaponsPurchased] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`WeaponsPurCash`=%d, ", pData[playerid][pWeaponsPurchasedMoney] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Healed`=%d, ", pData[playerid][pHealed] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Arrest`=%d, ", pData[playerid][pArrest] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Busted`=%d, ", pData[playerid][pBusted] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Crimes`=%d, ", pData[playerid][pCrimes] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`WantedL`=%d, ", pData[playerid][pWantedLevel] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Drugs`=%d, ", pData[playerid][pDrugs] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`DrugsB`=%d, ", pData[playerid][pDrugsBought] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`DC`=%d, ", pData[playerid][pDrugsCash] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`DS`=%d, ", pData[playerid][pDrugsSell] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`DSC`=%d, ", pData[playerid][pDrugsSellCash] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Medical`=%d, ", pData[playerid][pMedical] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Min`=%d, ", pData[playerid][pMins] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`Hour`=%d, ", pData[playerid][pHours] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "`vLK`=%d ", pData[playerid][pLock] );
        strcat(query, tmp);

        format(tmp, sizeof(tmp), "WHERE `ID`= %d AND `Username`= '%e'", pData[playerid][pID],  Name[playerid] );
        strcat(query, tmp);
        mysql_tquery(mysql, query, "", "");
    }
    return 1;
} 
Find
Reply
dusk
High-roller
*****
Posts: 1,113
Threads: 127
Joined: Jul 2008
Reputation: 0
#5

05.07.2015, 11:53
Another thing is that query array is too small. Besides that, can't see anything else wrong :/
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#6

05.07.2015, 11:59
Changed query size but its not updating/saving databse. What's wrong here.

PHP код:
[16:58:03] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:58:13] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=0, `Vip`=0, `Money`=50000, `BankCas", callback: "(null)", format: "(null)"
[16:58:13] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[16:58:13] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.365 milliseconds
[16:58:13] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving 
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#7

05.07.2015, 12:38
Anyone?
Find
Reply
dusk
High-roller
*****
Posts: 1,113
Threads: 127
Joined: Jul 2008
Reputation: 0
#8

05.07.2015, 12:44
First of all, don't bump threads unless 24 hours have passed.

Second, so the query finishes successfully now? That's great. What do you mean its not updating/saving? Are you aware of the fact that UPDATE queries only update existing entries and does not create new ones?

Also check pData[playerid][pID] and Name[playerid]. Print them out to see if their values are what you expect them to be.
Find
Reply
STONEGOLD
Huge Clucker
****
Posts: 312
Threads: 83
Joined: Feb 2012
Reputation: 0
#9

05.07.2015, 12:53
Well, I don't like to bum thread but actually, i need it so bad because i want to script many things but im stuck because of this. So.

It says query successfully but it doesn't updating i mean when you discount your game so it should save your money/score/deaths blah blah but it doesn't saving. I checked Columns . They are fine.
Find
Reply
dusk
High-roller
*****
Posts: 1,113
Threads: 127
Joined: Jul 2008
Reputation: 0
#10

05.07.2015, 15:48
Does the row atleast exist in your database?
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