Problem with MySQL - Printable Version

Problem with MySQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Problem with MySQL (/showthread.php?tid=472640)

Problem with MySQL - AA9 - 29.10.2013

Somehow mysql wont save my infromation, when i disconnect.

Debug says that -

pawn Code:

CMySQLHandler::Query(UPDATE playerdata SET score=0, money=7000, skin=299, posx=-1899.979248, posy=212.204940, posz=37.849018, adminlvl=3434, auaste=0, grupeering=0, virtworld=0, interior=0, firmavхti=0, majavхti=0, ajail=109, ajailtime=0, rahapangas=0, atmkey=0  WHERE user='') - Successfully executed.

Can just somebody help me, i have tried to fix this a couple of hours.

Disconnect code

pawn Code:

public OnPlayerDisconnect(playerid, reason)
{
        if(Logged[playerid] == 1)
        {
        //If the player disconnects before registering,
        //we want to make sure it doesn't try update
        //so we check if the player is logged in.
        new score = GetPlayerScore(playerid); //Gets players score
        new money = GetPlayerMoney(playerid); //Gets players money
        new skin = GetPlayerSkin(playerid);
        new Float:x, Float:y, Float:z;
        GetPlayerPos(playerid, x, y, z);
        new auaste = PlayerInfo[playerid][pRank];
        new grupeering = PlayerInfo[playerid][pMember];
        new adminlvl = PlayerInfo[playerid][pAdmin];
        new virtw = GetPlayerVirtualWorld(playerid);
        new inter = GetPlayerInterior(playerid);
        new firv6ti = PlayerInfo[playerid][pFirmav6ti];
        new majav6ti = PlayerInfo[playerid][pMajav6ti];
        new ajail = PlayerInfo[playerid][pAjail];
        new ajailtime = PlayerInfo[playerid][pAjailtime];
        new rahapangas = PlayerInfo[playerid][pRahapangas];
        new atmkey = PlayerInfo[playerid][pAtmpass];
        new query[700], pname[24]; //Creates the variables
        GetPlayerName(playerid, pname, 24); //Gets the players name.
        format(query, sizeof(query), "UPDATE playerdata SET score=%d, money=%d, skin=%d, posx=%f, posy=%f, posz=%f, adminlvl=%d, auaste=%d, grupeering=%d, virtworld=%d, interior=%d, firmavхti=%d, majavхti=%d, ajail=%d, ajailtime=%d, rahapangas=%d, atmkey=%d  WHERE user='%s'", score, money,skin, x, y, z, adminlvl,auaste, grupeering, virtw, inter,firv6ti,majav6ti, pname, ajail, ajailtime, rahapangas, atmkey);
        mysql_query(query);
        //No need to store a result for a update string
        }
        return 1;
}

Re: Problem with MySQL - -Prodigy- - 29.10.2013

pawn Code:

format(query, sizeof(query), "UPDATE playerdata SET score=%d, money=%d, skin=%d, posx=%f, posy=%f, posz=%f, adminlvl=%d, auaste=%d, grupeering=%d, virtworld=%d, interior=%d, firmavхti=%d, majavхti=%d, ajail=%d, ajailtime=%d, rahapangas=%d, atmkey=%d  WHERE user='%s'", score, money,skin, x, y, z, adminlvl,auaste, grupeering, virtw, inter,firv6ti,majav6ti, pname, ajail, ajailtime, rahapangas, atmkey, pname);

You forgot to store the player's name in the string. Try that ^

Re: Problem with MySQL - AA9 - 29.10.2013

pawn Code:

CMySQLHandler::Query(UPDATE playerdata SET score=0, money=7000, skin=299, posx=-1899.979248, posy=212.204940, posz=37.849018, adminlvl=3434, auaste=0, grupeering=0, virtworld=0, interior=0, firmavхti=0, majavхti=0, ajail=109, ajailtime=0, rahapangas=0, atmkey=0  WHERE user='')

Problem is WHERE user = ", but i dont know, how to fix it.

Re: Problem with MySQL - Aprezt - 29.10.2013

Probleem on selles ka, et queryis ei tohi olla tдpitдhti. Muuda need firmavхtmed ja asjad дra. Tee inglise keelseks prolly siis tццtab. Lisaks peab sul olema ka seal lхpus pname, et ta tuvastaks ka selle nime дra.

Re: Problem with MySQL - AA9 - 29.10.2013

Ei ole, mul oli nime muutuja keskel, aga pidi viimasel kohal olema. Lihtsalt loll viga, mis jдi kahesilma vahele.

Re: Problem with MySQL - Konstantinos - 29.10.2013

Quote:

Originally Posted by Aprezt

Probleem on selles ka, et queryis ei tohi olla tдpitдhti. Muuda need firmavхtmed ja asjad дra. Tee inglise keelseks prolly siis tццtab. Lisaks peab sul olema ka seal lхpus pname, et ta tuvastaks ka selle nime дra.

Quote:

Originally Posted by AA9

Ei ole, mul oli nime muutuja keskel, aga pidi viimasel kohal olema. Lihtsalt loll viga, mis jдi kahesilma vahele.

Only English here.

Quote:

Originally Posted by AA9

pawn Code:

CMySQLHandler::Query(UPDATE playerdata SET score=0, money=7000, skin=299, posx=-1899.979248, posy=212.204940, posz=37.849018, adminlvl=3434, auaste=0, grupeering=0, virtworld=0, interior=0, firmavхti=0, majavхti=0, ajail=109, ajailtime=0, rahapangas=0, atmkey=0  WHERE user='')

Problem is WHERE user = ", but i dont know, how to fix it.

-Prodigy- told you.

By replacing:

pawn Code:

format(query, sizeof(query), "UPDATE playerdata SET score=%d, money=%d, skin=%d, posx=%f, posy=%f, posz=%f, adminlvl=%d, auaste=%d, grupeering=%d, virtworld=%d, interior=%d, firmavхti=%d, majavхti=%d, ajail=%d, ajailtime=%d, rahapangas=%d, atmkey=%d  WHERE user='%s'", score, money,skin, x, y, z, adminlvl,auaste, grupeering, virtw, inter,firv6ti,majav6ti, pname, ajail, ajailtime, rahapangas, atmkey);

with:

pawn Code:

format(query, sizeof(query), "UPDATE playerdata SET score=%d, money=%d, skin=%d, posx=%f, posy=%f, posz=%f, adminlvl=%d, auaste=%d, grupeering=%d, virtworld=%d, interior=%d, firmavхti=%d, majavхti=%d, ajail=%d, ajailtime=%d, rahapangas=%d, atmkey=%d  WHERE user='%s'", score, money,skin, x, y, z, adminlvl,auaste, grupeering, virtw, inter,firv6ti,majav6ti, pname, ajail, ajailtime, rahapangas, atmkey, pname);

You forgot to pass the pname as an arguement (so the last argument was atmkey; therebefore user would be NULL in the query).

Re: Problem with MySQL - AA9 - 29.10.2013

Yes i know, i didnt see your change, but thanks for helping.

Re: Problem with MySQL - Jefff - 29.10.2013

you got "pname" in wrong place in format, must be at the end