[Dancev96]

Quote:

Originally Posted by Ramoboss here it is i think pawn Код: format(makepl, sizeof(makepl), "INSERT INTO `players`(`ime`, `lozinka`,`email`,`health`, `level`, `gmlevel`, `godini`, `kes`, `banka`, `lider`, `clen`, `model`,`data`) VALUES ('%s','%s','%.1f','%d','%d','%d','%d','%d','%d','%d','%d','%s', NOW())", this NOW()) doesn't have his place, he does not do anything (unless fuck up your script)

I removed it but still doesn't work
Here is my new code:

pawn Код:

stock Zacuvajigrac(playerid)
{
    //  Zacuvajigrac
            new playername3[MAX_PLAYER_NAME],query[300],makepl[500];
            new year, month,day;
            GetPlayerName(playerid, playername3, sizeof(playername3));
            format(query, sizeof(query), "SELECT * FROM `players` WHERE `ime` = '%s'",playername3);
            mysql_query(g_Handle, query);
            if (cache_get_row_count()==0){
            format(makepl, sizeof(makepl), "INSERT INTO `players`(`ime`, `lozinka`,`email`,`health`, `level`, `gmlevel`, `godini`, `kes`, `banka`, `lider`, `clen`, `model`,`data`) VALUES ('%s','%s','%.1f','%d','%d','%d','%d','%d','%d','%d','%d','%d/%d/%04d')",
            playername3,
            PlayerInfo[playerid][pKey],
            PlayerInfo[playerid][pEmail],
            PlayerInfo[playerid][pHealth],
            PlayerInfo[playerid][pLevel],
            PlayerInfo[playerid][pGameMaster],
            PlayerInfo[playerid][pAge],
            PlayerInfo[playerid][pCash],
            PlayerInfo[playerid][pAccount],
            PlayerInfo[playerid][pLeader],
            PlayerInfo[playerid][pMember],
            PlayerInfo[playerid][pModel],
            year,month,day);
            mysql_query(g_Handle, makepl);
            }else{
            format(query, sizeof(query), "UPDATE `players` SET `lozinka`='%s',`email`='%s',`health`='%.1f',`level`='%d',`donatorrank`='%d',`gmlevel`='%d',`godini`='%d',`kes`='%d',`banka`='%d',`lider`='%d',`clen`='%d',`model`='%d',`data`='%d/%d/%04d' WHERE `ime`=''",
            PlayerInfo[playerid][pKey],
            PlayerInfo[playerid][pEmail],
            PlayerInfo[playerid][pHealth],
            PlayerInfo[playerid][pLevel],
            PlayerInfo[playerid][pDonateRank],
            PlayerInfo[playerid][pGameMaster],
            PlayerInfo[playerid][pAge],
            PlayerInfo[playerid][pCash],
            PlayerInfo[playerid][pAccount],
            PlayerInfo[playerid][pLeader],
            PlayerInfo[playerid][pMember],
            PlayerInfo[playerid][pModel],
            year,month,day,
            playername3);
            mysql_query(g_Handle, query);
            }
    return 1;
}