newbie give item

[kangfredy]

guys can i request newbie reward?

this is my schema for this script

1stly

someone make new account.

and then

make new characther...

in starting zone..

this is i need script for newbie giver (only one char in one ID).....

and this npc check in database login in sql.........

if IP new ID = IP in login database

not give reward

and if IP new ID different

give reward.......

[Capuche]

Something like this ?

prontera,155,159,5	script	infamy	56,{

// Check if already log in
// -----------------------
query_sql "SELECT `logincount` FROM `login` WHERE `account_id` = '"+ getcharid(3) +"'", .@logincount;
if( .@logincount > 1 ) end;

// Count account with the same ip xx.xx.xx.*
// -----------------------------------------
sscanf( getcharip(), "%d.%d.%d.%d", .@a, .@b, .@c, .@d );
query_sql( "SELECT COUNT(`account_id`) FROM `login` WHERE `last_ip` LIKE '%"+ .@a +"."+ .@b +"."+ .@c +".%'", .@count );

if( .@count == 1 ) {
	dispbottom "Here a reward for newbie.";
	getitem 501, 1;
}
query_sql "UPDATE `login` SET `logincount` = '2' WHERE `account_id` = '"+ getcharid(3) +"'";

end;

}

Edited February 3, 2013 by Capuche

[kangfredy]

yes...tq guys.......