Reward IP BASE

[balanar12321]

if( query_sql( "SELECT `account_id` FROM `char` WHERE `guild_id`='"+$koegid+"' AND `online`= 1 ",.@AID ) )
for( set .@i,0; .@i < getarraysize( .@AID ); set .@i,.@i + 1 ){
 getitem 600,1,.@AID[.@i];
 getitem 601,1,.@AID[.@i];
 getitem 602,1,.@AID[.@i];
 
 }
end;



CAN SOMEONE make this IP base reward, 1 reward per 1 IP.. thanks

[Ronald]

This might help.

[Neffletics]

if(strcharinfo(2) != $koegid) end; // if the character is not from the guild
goto GetReward;
break;

GetReward:
query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@IP$);
query_sql("SELECT account_id FROM `login` WHERE last_ip = '"+.@IP$+"'", .@AID);

if(getarraysize(.@AID) > 1) end; // If more than 1 account_id shares the same IP
getitem 600,1;
end;

Just make them talk to an NPC with this function. This is the simplest way to do it. I hope it helps. ~

Edited October 3, 2020 by Neffletics