<?php
    $username = "root";
    $password = "77applebed1250";
    $hostname = "localhost";

    //connection to the database
    $dbhandle = mysql_connect($hostname, $username, $password)
    or die("Unable to connect to server MySQL");
    echo "Connected to MySQL<br>";

    //select a database to work with
    $selected = mysql_select_db("forum2",$dbhandle)
    or die("Could not select db forum2");

    //execute the SQL query and return records
    $result = mysql_query("SELECT dw.id as id,sec.evento as evento,dw.file as file FROM mkp_download as dw,mkp_download_sections as sec WHERE (sec.id=dw.idcategoria)");

    echo "<script language='JavaScript'>
    newwindow=window.open('','risultato','height=500,width=500');
    </script>";

    //fetch tha data from the database


    // Open a known directory, and proceed to read its contents
    $dir = "/var/www/virtual/unibosca.com/htdocs/public/mkportal/modules/downloads/file";
    if (is_dir($dir)) {
        if ($dh = opendir($dir)) {
            while (($file = readdir($dh)) !== false) {
                while ($row= mysql_fetch_array($result))
                {

                    $basefilename = preg_replace("/(.*)\.([^.]+)$/","\\1", $file);

                    $filename = preg_replace("/(.*)\.([^.]+)$/","\\1", $row['file']);
                    if (preg_match('/'.$row['file'].'/i',$basefilename)) salva_file($file,$row['file'],$row['evento']);
                }
            }
            closedir($dh);
        }
    }

    function salva_file($originale,$nuovo,$categoria)
    {
        if (!is_dir($dir.'/riorganizzato/'.$categoria)) mkdir ($dir.'/riorganizzato/'.$categoria,0777,true);
        copy($originale,$dir.'/riorganizzato/'.$categoria.'/'.$nuovo);
        echo $originale." copiano in /".$categoria."/".$nuovo;
        return true;
    }
    //close the connection
    mysql_close($dbhandle);
?>