SQL Function

[Saruman]

I've made this function in order to have a 24h VIP Ticket(I've put 40 seconds to test), but it's not working. Can someone see what's wrong ?

 

function script vip1 {
 
set $nivelVip, 1;
 
query_sql "UPDATE `login` SET `group_id` = "+$nivelVip+" WHERE `group_id` = 0 AND `account_id` = "+getcharid(3);
 
dispbottom "Conta VIP inserida com sucesso! Relogue seu personagem para ativá-la.";
addtimer 40000, "vip1::OnTempo2";
end;
    
OnTempo2:
dispbottom "Período VIP terminado."; 
query_sql "UPDATE `login` SET `group_id` = 0 WHERE `group_id` = 1 AND `account_id` = "+getcharid(3);
    end;
 
} 

 

[Emistry]

change your script from "FUNCTION" become a "NPC"

[Saruman]

change your script from "FUNCTION" become a "NPC"

 

But it's a function for this item:

 

20682,Ticket_Vip,Ticket VIP #1,0,10000,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc "vip1"; },{},{}

[Emistry]

you can use doevent , the addtimer need you to attach the script to an event label that appeared in a NPC, not FUNCTION.