[PROBLEM] Komanda i SQL upit

Problem(error/warning): Pravio sam sistem zadataka za skriptu i uspeo sam sve da napravim to,ali kada zavrsi zadatak i dobije novac na phpmyadmin umesto imena ono ispise %e https://imgur.com/a/OJRpHBR
Deo skripte: https://pastebin.com/Rt2uxdwK

%s

cozmic wrote on October 13, 2024, 2:35 pm:

%s

isto bude onda samo ispise %s

Stavi pod " "

twoblqck.art wrote on October 13, 2024, 3:54 pm:

Stavi pod " "

    new rows;
    cache_get_row_count(rows);
    if(!rows) mysql_tquery(_dbConnector, "INSERT INTO `tutorial` (`ime`) VALUES "%s"", GetName(playerid));
    mysql_format(_dbConnector, "UPDATE `tutorial` SET `tut_Done%d` = '1' WHERE `ime` = "%s" LIMIT 1", broj-1, GetName(playerid) ); ovako ili(ne razumem se najbolje halali)

bendzamin4674 wrote on October 13, 2024, 4:08 pm:

    new rows;
    cache_get_row_count(rows);
    if(!rows) mysql_tquery(_dbConnector, "INSERT INTO `tutorial` (`ime`) VALUES "%s"", GetName(playerid));
    mysql_format(_dbConnector, "UPDATE `tutorial` SET `tut_Done%d` = '1' WHERE `ime` = "%s" LIMIT 1", broj-1, GetName(playerid) ); ovako ili(ne razumem se najbolje halali)

new query;
new rows;
cache_get_row_count(rows);
if(!rows) mysql_tquery(_dbConnector, query, sizeof(query), "INSERT INTO `tutorial` (`ime`) VALUES ('%e')", GetName(playerid));
mysql_format(_dbConnector, query, sizeof(query), "UPDATE `tutorial` SET `tut_Done%d` = '1' WHERE `ime` = "%e" LIMIT 1", broj-1, GetName(playerid) ); 

Pokušaj ovako

moja greska, glup sam

    new query;

    if(!rows)
    {
        mysql_format(_dbConnector, query, sizeof(query), "INSERT INTO `tutorial` (`ime`) VALUES ('%e')", GetName(playerid));
        mysql_tquery(_dbConnector, query);
    }
    mysql_format(_dbConnector, query, sizeof(query), "UPDATE `tutorial` SET `tut_Done%d` = '1' WHERE `ime` = '%e' LIMIT 1", broj-1, GetName(playerid));
    mysql_tquery(_dbConnector, query);

probaj ovako

twoblqck.art wrote on October 13, 2024, 4:35 pm:

moja greska, glup sam

    new query;

    if(!rows)
    {
        mysql_format(_dbConnector, query, sizeof(query), "INSERT INTO `tutorial` (`ime`) VALUES ('%e')", GetName(playerid));
        mysql_tquery(_dbConnector, query);
    }
    mysql_format(_dbConnector, query, sizeof(query), "UPDATE `tutorial` SET `tut_Done%d` = '1' WHERE `ime` = '%e' LIMIT 1", broj-1, GetName(playerid));
    mysql_tquery(_dbConnector, query);

probaj ovako

hvala popravio sam,hvala svima koji su pomogli...

Greska ti je bila u VALUES

Kada insertujes nesto onda mora da bude

mysql_format(SQL, string,sizeof(string), "INSERT INTO `zadatci` (`Username`) VALUES ('%s')", GetName(playerid));