help with F Ticket AddVip wanted to integrate it with the npc I have

[sonyk2]

Good morning sorry for the inconvenience

I wanted your help if possible kk

I tried to edit but I'm noob

// ------------------------------------------------ -------------------------------------------------- ------------

script de função F_TicketAddVip5 {
    query_sql "SELECT` days` FROM` viptable` WHERE` vipacc_id` = '" + getcharid (3) + "'",. @ checkDays;
    if (. @ checkDays> 0) {
        set. @ setDays, (. @ checkDays + 5);
        query_sql "UPDATE` viptable` set` days` = '" +. @ setDays + "'? WHERE` vipacc_id` ='" + getcharid (3) + "'";
        query_sql "SELECT` group_id` FROM` login` WHERE` account_id` = '" + getcharid (3) + "'",. @ nível de usuário;
        if (. @ userLevel <1) 
            query_sql "

    else {
        query_sql" UPDATE` login` set `group_id` = '1' WHERE` account_id` = '" + getcharid (3) + "
        query_sql "SELECT` userid` FROM` login` ONDE` account_id` = '" + getcharid (3) + "'",. @ userID $;
        query_sql "SELECT` email` FROM` login` ONDE` account_id` = '" + getcharid (3) + "'",. @ userEmail $;
        query_sql "INSERT INTO` viptable` (` vipacc_id`, `vip_id`,` days`, `email`) VALUES ('" + getcharid (3) + "', '" +. @ userID $ + "', '5 ',' "+. @ accEmail $ +" ') ";
    }
    atcommand "@reloadpcdb";
    dispbottom "Você erigido 5 dias de conta VIP, parabéns!";
    specialeffect 338;
    fim;
Retorna;
}

wanted to use with this npc

View attachment 6655

 

[Caspian]

First you need to type in english, here is an international community.

If you want support in your mother language, you should have opened a topic in the portuguese support section.

 

[sonyk2]

First you need to type in english, here is an international community.

If you want support in your mother language, you should have opened a topic in the portuguese support section.

sorry I was very tired when I posted