if i recall correctly, there might be a trick for it. but i am not sure how good/true are the outcome.
mobile users i think cant use the gepard shield right?
last time they did a compare with the info like unique_id from gepard shield to check they are from mobile or pc.
mobile users seem like doesnt have this unique_id thing, gepard not compatible with mobile user i guess.
but i dont know if this trick still possible or even correct in the first place, you may try tho if you did have gepard installed in pc and not for mobile.
perhaps you can try save timestamp (total seconds until vip expired) and not days.
on char login, check if the timestamp exceed the stored value, if exceed then cancel the vip
else attach a timer with the remaining seconds and cancel the vip upon timeout.
these query should be executed during the char isn't online ...preferable during shutdown/maintenance of server.
its useless to execute this query when the char is online, the server will simply re-insert the exact same data into the server when the char relog
which is why its not provided as a npc script in the first place.
store the GID to a variable upon summon it ....attach each monster with their own event to trigger upon death.
what you gonna do with the GID as the monster already died....
npc/scripts_athena.conf#L194
I wonder how many time shall we spoonfeed you with the same kind of question to add/remove npc? Perhaps starting trying or search first before ask any similar questions?