#!/usr/bin/perl

use CGI::Carp qw/fatalsToBrowser/;
use strict;
use warnings;

print "Content-type: text/html\n\n";

open(my $fh_titel,"<titel.txt") or die $!;
my @titel=<$fh_titel>;
close($fh_titel);

open(my $fh_url,"<urls.txt") or die $!;
my @urls=<$fh_url>;
close($fh_url);

open (my $fh_sql,">sql.txt") or die $!;

my $subkat = 6;

for my $i(0..scalar(@titel)-1){
 if((length($titel[$i]) > 2)&&(length($urls[$i])>2)){
     my $zahl=substr($titel[$i],0,4);
     if($zahl =~ /^\d+$/){
         if   ($zahl<=500){$subkat=5;}
         elsif ($zahl<=1000){$subkat=4;}
         elsif ($zahl<=1500){$subkat=3;}
         elsif ($zahl<=2000){$subkat=2;}
         elsif ($zahl<=2500){$subkat=1;}
       }
       else{
         $subkat = 8;
       }

       my $romname=$titel[$i];
       $romname =~ s/\n*?$//;
       $romname=~s/'/\\'/g;

       my $romurl=$urls[$i];
       $romurl =~ s/\n*?$//;
       $romurl=~s/'/\\'/g;

       my $romscreen="http://www.rom-stuff.de/screens/".$zahl."b.jpg";
       print $fh_sql "INSERT INTO `files`(`kat_id`,`sub_kat_id`,`filename`,`downloadfile`,`screen`) VALUES (1, $subkat, '$romname', '$romurl', '$romscreen');\n";       
   }
}

close $fh_sql or die $!;

print q~<b>fertig</b>~;