Character Name Update HELP

[nasagnilac]

query_sql( "select `name` from `char` order by char_id asc", .@name$);
query_sql "UPDATE (*) FROM `char SET `name` = 'name' + v2 ";

OnDoChar:
freeloop(1);
for( set .@k, 0; .@k < 26; set .@k, .@k + 1 ){
query_sql( "select `name` from `char` order by char_id asc limit 127", .@name$);

	for( set .@i, 0; .@i < getarraysize(.@name$); set .@i, .@i + 1 ){
		query_sql "UPDATE `char` SET `name` = '"+(.@name$[.@i] + v2)+"'  WHERE `name` = '"+.@name$[.@i]+"'";
	}
}
freeloop(0);
end;

I need your help. I want all names in the char table will be extended by v2. But I dont know if this one works. Can you please help me how I can add v2 in all names using script.

I dont know where the 000000000000 numbers came from.

Edited May 9, 2015 by gmprestige