sql command

[Anime s2]

can  someone create sql command to set #SECURITYCODE variable for all inactive accounts on the server that has not yet have this variable?.


The value has to be a random number of 4 characters (between 1000 and 9999), must be stored in global_reg_value table

http://postimg.org/image/4i032qzf3/

sorry for my bad english.

Edited October 28, 2015 by Anime s2

[Anime s2]

up

[prokopio]

i can help you but i don't really understand what you really want

[Emistry]

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;

}