anyone update this script

[Bringer]

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;
}

can anyone update the sql i got error in

global_reg_value

Edited February 15, 2016 by Emistry
codebox

[PandaLovesHamster]

query_sql "select FROM `main`.`char_reg_num` WHERE `key`='reward_lvl'";

No idea if that works, but give it a try.