So I have a script that checks for party members IP, but I'd like to also have it check their Unique_id(to prevent using a different PC without VPN and to prevent using same PC with VPN) I've been knocking my head on the table for an hour now trying to figure it out. I'm using SQL because I'm having the table get TRUNCATED at OnClock0000(couldn't find any other way to remove everyones variable).
//===== rAthena Script =======================================
//= MVP Ladder Game
//=====
You can just re-use the check since you're already attaching the party members
.gui = get_unique_id();
.@nb = query_sql("SELECT `bloodybranch` FROM `bloody_branch` WHERE `unique_id` = "+.gui+" LIMIT 1", .@bbq);
if (.@nb) .@dupli = 1;
There's a simpler way, instead of the checking the IPs and unique ID, you can also save their account ids.