INSERT INTO `global_reg_value` (`char_id`,`str`,`account_id`,`value`,`type`)
SELECT '0','#SECURITYCODE', `account_id`,CEILING( RAND() * 10000 ),'2'
FROM `login`;
WHERE `account_id`
NOT IN ( SELECT `account_id` FROM `global_reg_value` )
or
- script Sample#main -1,{
OnInit:
query_sql( "SELECT `login`.`account_id` FROM `login` WHERE `account_id` > 1 AND `account_id` NOT IN ( SELECT `global_reg_value`.`account_id` FROM `global_reg_value` WHERE `global_reg_value`.`str` = '#SECURITYCODE' AND `value` > 0 )",.@aid );
.@aid_size = getarraysize( .@aid );
while ( .@aid_size >= 1 ) {
.@aid_size--;
query_sql( "INSERT INTO `global_reg_value` (`str`,`account_id`,`value`,`type`) VALUES ( "+rand( 1000,9999 )+","+.@aid[.@aid_size]+",2 )" );
if ( .@aid_size && .@aid_size % 100 == 0 ) sleep 1;
}
end;
}