script not updating DATABASE

[Nihongo^]

Hello iam trying to add gems on my script

ok to save gems stats my friend use savestats function which mean if the player left the server, script store his info ( gems ) into database

function SaveStatus( player )
{
   QuerySQL(db, "UPDATE Accounts SET Gems = '"+status[ player.ID ].Gems+"', GemsRange = '"+status[ player.ID ].GemsRange+ "' WHERE Name = '"+ player.Name +"'");
   print( "saved status of player: "+player.Name+"." );
}

but i remove the savestats function and add this

function IncGems( player )
{
   
        local Calc = PlayerGems( player ) + 1;
        local query1 = format( "UPDATE Account SET Gems=%i WHERE Name='" + player.Name +"'", Calc );
        QuerySQL( db, query1 );
   
}
function PlayerGems( player )
{
    local name = player.Name;
    local Answer = QuerySQL( db, "SELECT Kills, Deaths, Joins, Gems FROM Account WHERE Name='" + player.Name +"' COLLATE NOCASE" );
    local Gems = GetSQLColumnData( Answer, 0 );
    if ( !Gems ) return 0;
    else return Gems;
    FreeSQLQuery( Answer );
}

But the script is not updating the gems value in db also what is the use of this value

local Gems = GetSQLColumnData( Answer, 0 );

why we put the 0 ?. I saw on my cash function it was 2

[Nihongo^]

Rip this forum man nobodys helping me

[Mohamed Boubekri]

What u Man, i Don't Understand Anything.
Man just Use The Fuzzie Account System, Its very Good.
P.S Your English RAPED.
Good Luck.

[Mohamed Boubekri]

Try To Add it For function OnPlayerJoin & OnPlayerPart.

Code Select Expand

SaveStatus( player );GL.

[Nihongo^]

P.S Your English RAPED.

Like You did master in inglish

[Mohamed Boubekri]

Fast Go School And Learn how to talk English
Good Luck.

[Xmair]

Fast Go School And Learn how to talk English
Good Luck.

I suggest you to do the same.

[Mohamed Boubekri]

Fast Go School And Learn how to talk English
Good Luck.

I suggest you to do the same.

Nah, i Already Learned
i Suggest You To Do the Same.

[!]

Fast Go School And Learn how to talk English
Good Luck.

I suggest you to do the same.

Nah, i Already Learned
i Suggest You To Do the Same.

Lol and what was the reason of suggesting him Fuzzie Account System if you don't even know what he needs.

What u Man, i Don't Understand Anything.
Man just Use The Fuzzie Account System, Its very Good.
P.S Your English RAPED.
Good Luck.

Now we all know who needs to go to school.

@Nihongo^ try this

Code Select Expand

function IncGems( player )
{
   local Calc = PlayerGems( player ) + 1;
   QuerySQL( db, "UPDATE Account SET Gems='"+Calc+"' WHERE Name='"+player.Name+"'" );
}
function PlayerGems( player )
{
   local query = QuerySQL( db, "SELECT Gems FROM Account WHERE Name='"+player.Name+"'" );

   if ( !query ) return 0;

   local Gems = GetSQLColumnData( query, 0 );
   FreeSQLQuery( query );

   return Gems.tointeger();
}