GTA:BLKN
PRIJAVA REGISTRACIJA

[PROBLEM] Komanda i SQL upit

bendzamin4674 Započeo bendzamin4674
pre 1 godinu
1,591
pregleda
9
postova
Ova tema je zaključana. Samo moderatori i administratori mogu odgovarati.
bendzamin4674
bendzamin4674
Wheel Man
pre 1 godinu
#1
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
Vedad.pwn
cozmic
Made Man
pre 1 godinu
#2
%s
bendzamin4674
bendzamin4674
Wheel Man
pre 1 godinu
#3
cozmic wrote on October 13, 2024, 2:35 pm:
%s
isto bude onda samo ispise %s
Emo
twoblqck.art
Kingpin
pre 1 godinu
#4
Stavi pod " "

graph designer

bendzamin4674
bendzamin4674
Wheel Man
pre 1 godinu
#5
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)
ivanboskic1
ivodev54
Underboss
pre 1 godinu
#6
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

Ja sam Ivo Dev, bager koji razgrće sve oko skripti – poznat i kao Zbager

Emo
twoblqck.art
Kingpin
pre 1 godinu
#7
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

graph designer

bendzamin4674
bendzamin4674
Wheel Man
pre 1 godinu
#8
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...
Fergosonn
Fergosonn
Made Man
pre 1 godinu
#9
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));

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava