SQL Script

[Bringer]

can anyone update SQL

 

Capuche

prontera,145,150,5	script	Sample	56,{
	if( BaseLevel == 99 && reward_lvl == 0 && Upper && .count < 100 ){
		if( .count < 3 )
			getitem 714,1;
		if( .count < 100 )
			getitem 7227,1;
		reward_lvl++;
		.count++;
		announce "Congratulations " + strcharinfo(0) + " for receiving the level 99 reward, there are only "+ (100-.count) +" rewards left!",0;
	}
	else if ( reward_lvl ) {
		mes "you already get your reward";
		close;
	}
	else if ( BaseLevel != 99 ) {
		mes "you are not lvl 99";
		close;
	}
	end;
OnInit:
	.count = query_sql( "select `value` from `global_reg_value` where `str`= 'reward_lvl'", .@value );
	if ( .count >99 ) end;
// limit to 127 players online here
	.@size = query_sql( "select `account_id` from `char` where `char_id` not in ( select `char_id` from `global_reg_value` where `str`= 'reward_lvl' ) and `online`=1", .@account_id );
	for ( .@i = 0; .@i < .@size; .@i++ ) {
		attachrid .@account_id[.@i];
		if ( reward_lvl ) {
			.count++;
			if ( .count >99 ) end;
		}
	}
	end;
}

Edited February 26, 2016 by DrewxD

[Emistry]

Please elaborate the problem you currently facing. Provide us with the following or more details if possible:

- Run-time server console errors/warnings (if any).

- Client side errors/warnings (if any).

- Any edits to scripts or source mods (if any).

[Bringer]

Please elaborate the problem you currently facing. Provide us with the following or more details if possible:

- Run-time server console errors/warnings (if any).

- Client side errors/warnings (if any).

- Any edits to scripts or source mods (if any).

global_reg_value not table exist

[Capuche]

izlude,150,155,5 script Sample 56,{

if ( BaseLevel == 99 && reward_lvl == 0 && Upper && .count < 100 ) {

if ( .count < 3 )

getitem 714,1;

if ( .count < 100 )

getitem 7227,1;

reward_lvl++;

.count++;

announce "Congratulations " + strcharinfo(0) + " for receiving the level 99 reward, there are only "+ (100-.count) +" rewards left!",0;

end;

}

if ( reward_lvl )

mes "you already get your reward";

else if ( BaseLevel != 99 )

mes "you are not lvl 99";

else if ( Upper == 0 )

mes "you must be advance or baby class.";

if ( .count < 100 )

mes "there are only "+ (100-.count) +" rewards left!";

else

mes "I already give all my items sorry.";

close;

OnInit:

query_sql( "select count(`value`) from `char_reg_num` where `key` = 'reward_lvl'", .count );

if ( .count > 99 ) end;

addrid 0;

if ( .count > 99 ) end;

if ( reward_lvl )

.count++;

end;

}