Attachments share code

Problem(error/warning): ovako uradio sam attachments share code, ali kad kreiram code i ocu da unesem pise da code ne postoji Vaš odgovor
Deo skripte:

CMD:sharecode(playerid, params[]) {
    if(isnull(params)) return SendClientMessage(playerid, NS_YELLOW, "[SHARE CODE] {ffffff}/sharecode [Unesi/Kreiraj]");
    else if(!strcmp(params, "kreiraj", true)) {
        new chars, xLength = random(1) + 8;
        format(chars, sizeof(chars), "");
        Loop(x, xLength) {
            format(chars, sizeof(chars), "%s%s", chars, xCharacters[random(sizeof(xCharacters))]);
        }
        va_SendClientMessage(playerid, NS_YELLOW, "[SHARE CODE] {FFFFFF}Uspesno ste kreirali attachments share code ('%s').", chars);
    }
    else if(!strcmp(params, "unesi", true)) return Dialog_Show(playerid, ShareCode, DIALOG_STYLE_INPUT, "Attachments Share Code", "Unesi Attachments Share Code", "Unesi", "Izlaz");
    return 1;
}

Dialog:ShareCode(playerid, listitem, response, inputtext[])
{
    if(!response) return 1;
    if(response) {
        new query;
        mysql_format(SQL, query, sizeof query, "SELECT * FROM attach WHERE ShareCode = '%s' LIMIT 5", inputtext);
        mysql_tquery(SQL, query, "ShareCode", "i", playerid);
    }
    
    return 1;
}

forward ShareCode(playerid, listitem);
public ShareCode(playerid, listitem) {
    
    if(!cache_num_rows()) return SendClientMessage(playerid, NS_SEL, "* Uneti Share code ne postoji u databazi!");

    for(new i = 0; i < cache_num_rows(); i++)
    {

    cache_get_value_name(i, "CreatorName", oInfo, 24);
    cache_get_value_name(i, "ShareCode", oInfo, 16);
    
    SetPlayerAttachedObject(playerid, inindex, inmodel, i);
    oInfo = inindex;
    oInfo = inmodel;
      oInfo = listitem+1;
    oInfo = true;
    
    va_SendClientMessage(i, NS_YELLOW, "[SHARE CODE] Uneo si share code ciji je kreator '%s'", PlayerName);
    }
    return 1;
}

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):

Vaš odgovor

Slika/video ingame problema(obavezno ako je ingame problem): https://imgur.com/a/ltF8DTg

Kada kreiras kod unesi ga u bazu.
Ne koristi %s u SQL queryjima ukoliko korisnik ima kontrolu nad onim sto unosis. Koristi %e.
Citaj: https://www.w3schools.com/sql/sql_injection.asp

// xunder wrote on July 14, 2023, 9:37 pm:

Kada kreiras kod unesi ga u bazu.
Ne koristi %s u SQL queryjima ukoliko korisnik ima kontrolu nad onim sto unosis. Koristi %e.
Citaj: https://www.w3schools.com/sql/sql_injection.asp

to sam uradio mozes mi reci kako da stavim kad ukuca sharecode da kopira tolko objekata kolko je kreator koda imo i da mu stavi tolko slotova zauzeto

realmynato wrote on July 15, 2023, 5:59 am:

to sam uradio mozes mi reci kako da stavim kad ukuca sharecode da kopira tolko objekata kolko je kreator koda imo i da mu stavi tolko slotova zauzeto

Selektuj iz baze de je sharcode isti sa unesenim i onda samo insertuj to i loadujes mu attach

Neaktivno, lock