Pomoc

[bendzamin4674]

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
Kod: https://pastebin.com/Rt2uxdwK

[cozmic]

%s

[bendzamin4674]

%s

isto bude onda samo ispise %s

[twoblqck.art]

Stavi pod " "

[bendzamin4674]

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)

[ivodev45]

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)

Kod [Izaberi] Proširi

new query[256];
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

[twoblqck.art]

moja greska, glup sam

Kod [Izaberi] Proširi

    new query[128];

    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

[bendzamin4674]

moja greska, glup sam

Kod [Izaberi] Proširi

    new query[128];

    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...

[Fergosonn]

Greska ti je bila u VALUES

Kada insertujes nesto onda mora da bude

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