<pre>
------ Transfer Images ------
<?PHP
ini_set ('max_execution_time', 60);

// Include the config
require_once('../include/config.inc.php');
//includes
require_once('classes/ebuild.php');
require_once('classes/package.php');
require_once('classes/category.php');
require_once('classes/keywords.php');
// insert the images
$sql = "TRUNCATE package_image";
mysql_query($sql) or die(mysql_error());

$sql = "SELECT * FROM `gentoo-portage`.`program_image`, `gentoo-portage`.`program`, `gentoo-portage`.`catagory` WHERE program_p = program_f AND catagory_f = catagory_p ORDER BY program_image_p";
$results = mysql_query($sql) or die(mysql_error());

$x=0;
while($row = mysql_fetch_assoc($results)){
    $category = new category($row['catagory_title']);
    $package = new package($category->id, $row['gentoo_title']);
    $file = false;

    if(is_file('/var/www/gentoo-portage.com/htdocs/uploadimg/full/'.$row['program_image_p'].'.jpg')){
        $file = '/var/www/gentoo-portage.com/htdocs/uploadimg/full/'.$row['program_image_p'].'.jpg';
        $ext = 'jpg';
    }elseif(is_file('/var/www/gentoo-portage.com/htdocs/uploadimg/full/'.$row['program_image_p'].'.png')){
        $file = '/var/www/gentoo-portage.com/htdocs/uploadimg/full/'.$row['program_image_p'].'.png';
        $ext = 'png';
    }
    
    if($category->id != 0 && $package->id != 0 && $file){
        $package->add_image($file, $ext, $row['caption'], $row['login_f'], false);
    }
    
    $x++;
    if(round($x/100) == $x/100)
        echo "$x Copied \n";
}

?>
</pre>