H> newbie package

[patr3k]

Can someone help me wtih this script? I want an account base not an ip base.

amatsu,116,146,3 script Seyra 90,{

set .@n$, "[seyra]";
setarray .@rwd[0],2115,1,2357,1,2421,1,2524,1; // Rewards: <item id>,<item amount>

query_sql ("SELECT `last_ip` FROM `login` WHERE `account_id`=" + getcharid(3) + "", .@lip$);

if ( getd("$" + .@lip$ + "_NG") > 0 || #NewbieGift > 0)
{
mes .@n$;
mes "I'm sorry, the rewards are exclusively for new players.";
close;
}

mes .@n$;
mes "Welcome! Here are some free gifts";
mes "for newcomers:";

for ( set .@i, 0; .@i < getarraysize(.@rwd); set .@i, .@i + 2 )
mes .@rwd[.@i+1] + " x " + getitemname(.@rwd[.@i]);

close2;
set #NewbieGift, 1;
setd "$" + .@lip$ + "_NG", getd("$" + .@lip$ + "_NG") + 1;

for ( set .@i, 0; .@i < getarraysize(.@rwd); set .@i, .@i + 2 )
getitem .@rwd[.@i], .@rwd[.@i+1];

end;

OnInit:

waitingroom "Newbie Gift!",0;
end;

}

[Emistry]

it is account based also ....

#NewbieGift

[Euphy]

Storing a permanent global list of IPs is a terrible idea, despite appearing otherwise, for reasons Annie stated here: http://www.eathena.ws/board/index.php?showtopic=181741&view=findpost&p=1478950

A separate SQL table must be used for things like this.

As for a non-IP-based script, there are literally dozens floating around, please use the search button.

[patr3k]

This script was edited by Kisuka for me. Can you guys edit this for me again please? Account base only not an ip base please please

Edited August 10, 2012 by patr3k

[Euphy]

http://rathena.org/board/topic/63858-script-request/#entry102504

[Emistry]

there are alot Newbie / Freebies script out there...

either Account Based / Character Based...all are there already.

search for it.

* Ops...didnt saw Euphy's Link *

[EvilPuncker]

Account base only not an ip base please please

here it is:

http://pastebin.com/raw.php?i=gzqdbkTV