Help me Please =(

[Yoona]

Its all about this script:

 

prontera,168,184,3 script Freebies 479,{
mes .NPC$;
mes "Wanna get the freebies " +strcharinfo(0)+ "?";
if (select("Yes:No") - 1) close;
mes .NPC$;
mes "Let me check if you are really a new member";
next;
query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@lastip$);
query_sql("SELECT last_ip FROM `freebies`", .@freebiesip$);
if (.@lastip$ == .@freebiesip$) {
mes .NPC$;
mes "You already got the freebies " +strcharinfo(0);
close;
}
query_sql("INSERT INTO `freebies` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + .@lastip$ + "')");
for ( set .@x,0; .@x < getarraysize(.freebie_item); set .@x,.@x + 1 ) {
getitem .freebie_item[.@x], .quantity[.@x];
}

close;

OnInit:
set .NPC$, "[ " +strnpcinfo(1)+ " ]";
setarray .freebie_item[0],30316,30315,30314,30027,30028,30029,30030,4302,4403,7227,30499,671,2629,2630,4140;
setarray .quantity[0],1,1,1,1,1,1,1,1,1,1000,1,1000,2,2,4;
waitingroom "Freebies Here",0;
}

 

 

and on mysql

 

CREATE TABLE IF NOT EXISTS `freebies` (
`id` int(11) NOT NULL auto_increment,
`account_id` int(11) NOT NULL default '0',
`name` varchar(23) NOT NULL default '',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`),
KEY (`id`)
) ENGINE=MyISAM;

 

 

it keeps giving items, and here's a picture of SQL error's

 

 

Bump =( Please

Edited July 12, 2013 by Yoona

[eboni001]

Its all about this script:

 

prontera,168,184,3 script Freebies 479,{

mes .NPC$;

mes "Wanna get the freebies " +strcharinfo(0)+ "?";

if (select("Yes:No") - 1) close;

mes .NPC$;

mes "Let me check if you are really a new member";

next;

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

query_sql("SELECT last_ip FROM `freebies`", .@freebiesip$);

if (.@lastip$ == .@freebiesip$) {

mes .NPC$;

mes "You already got the freebies " +strcharinfo(0);

close;

}

query_sql("INSERT INTO `freebies` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + .@lastip$ + "')");

for ( set .@x,0; .@x < getarraysize(.freebie_item); set .@x,.@x + 1 ) {

getitem .freebie_item[.@x], .quantity[.@x];

}

close;

OnInit:

set .NPC$, "[ " +strnpcinfo(1)+ " ]";

setarray .freebie_item[0],30316,30315,30314,30027,30028,30029,30030,4302,4403,7227,30499,671,2629,2630,4140;

setarray .quantity[0],1,1,1,1,1,1,1,1,1,1000,1,1000,2,2,4;

waitingroom "Freebies Here",0;

}

 

 

and on mysql

 

CREATE TABLE IF NOT EXISTS `freebies` (

`id` int(11) NOT NULL auto_increment,

`account_id` int(11) NOT NULL default '0',

`name` varchar(23) NOT NULL default '',

`last_ip` varchar(100) NOT NULL default '',

PRIMARY KEY (`account_id`),

KEY (`id`)

) ENGINE=MyISAM;

 

 

it keeps giving items, and here's a picture of SQL error's

 

 

error.jpg

Bump =( Please

try this one, easy to edit, properly working and it will give freebies only once per account:

//============================================
//= Npc that gives freebies to the new
//============================================
//= Rewritten by SkittleNugget (rAthena.org)
//============================================
prontera,146,161,6	script	Novice Support	893,{

    if( #PlayerRecievedFreebies )
	{
		mes "[Lisa]";
		emotion	e_swt2;
		mes "You already claimed your free items or you are not a novice anymore, Remember that i'll give you some free stuffs only once per account!";
		close;
	}
		else if ( Class < 1 )
	{
		mes "[Lisa]";
		emotion	e_ho;
		mes "Hello young adventurer and welcome to Kyojin RO";
		mes "I can give you some free items to help you grown fast";
		mes "Do you want it?";
		next;
		if ( select("You're so kind. Thank you!:Nah~ Im too pro for this!")==2)
		{
			mes "[Lisa]";
			emotion	e_ag;
			mes "Such a arrogant person.";
			mes "^ff0000@kill "+ strcharinfo(0) +"^000000";
			next;
			mes "[Lisa]";
			emotion	e_omg;
			mes "Why my command not work?!";
			mes "Maybe you're lucky!";
			close;
		}
		mes "[Lisa]";
		emotion	e_kis;
		mes "Please take this item and have a nice day~";
		next;
		getitem	504,30;	//White Potion
		getitem	645,25;	//Concentration potion
		getitem	14533,4;	//Field Manual
		getitem	14232,10;	//ygg berry box(10)
		getitem	4142,1;	//Doppelganger Card
		set #PlayerRecievedFreebies, 1;
		mes "See you soon~";
		close;
	}
}