source: temp/test-xoops.ec-cube.net/html/uploads/make_sql.php @ 405

#!/usr/local/bin/php
<?

for( $i = 1 ; $i <= 60 ; $i ++ ) {
    $formatted_i = sprintf("%03d",$i) ;
    $weight = $i + 1000 ;
    echo "INSERT INTO xoops_avatar SET avatar_mimetype='image/gif',avatar_created=NOW(),avatar_display='1',avatar_weight='$weight',avatar_type='S',avatar_name='Face-a$formatted_i',avatar_file='savt2a{$formatted_i}.gif';\n" ;
}

for( $i = 1 ; $i <= 40 ; $i ++ ) {
    $formatted_i = sprintf("%03d",$i) ;
    $weight = $i + 1300 ;
    echo "INSERT INTO xoops_avatar SET avatar_mimetype='image/gif',avatar_created=NOW(),avatar_display='1',avatar_weight='$weight',avatar_type='S',avatar_name='Face-d$formatted_i',avatar_file='savt2d{$formatted_i}.gif';\n" ;
}

?>