delete unused images script

[Gruz]

What VM version do you have?

[pierregulpen]

1.1.9 but i have a one page checkout build in and template from a third party.. Maybe there's the problem ?

[Gruz]

When adding the script to the template index.php you must run the web-site at a VM page. If a VM is not at the main page, then the VM class ps_DB is not loaded.

Add the script (from my web-site) and run proper url site.com/?option=com_virtuemart

[pierregulpen]

so instead of :  http://yoursite.com?tmpl=somefile

i should do :  site.com/?option=com_virtuemart

[Gruz]

http://yoursite.com?tmpl=somefile&option=com_virtuemart

The somefile  must be placed in the active Joomla template.

[pierregulpen]

ok, thnx i will try

let you know later if worked

[pierregulpen]

  Works Great !!

Thank you , Total removed files :480 !!  saves me several MB in Webspace :-)

[amorino]

Hello,
this script worked fine for me
thank you very much
Best regards
Amorino

[nunoms]

Hi,

I am using Joomla 2.5 and Virtuemart 2.0.24.

I can not run this script, always gives the error: "Fatal error: Class 'ps_DB' "

I'm putting the following address: "http://localhost/site/?tmpl=script&option=com_virtuemart"


Someone can help me?


Thanks,
Nuno Amaral

[ex3mist]

Hello,
Now I'm also looking for a slution of this issue for VM2. Can anyone help? I've tried what is mentioned for VM1 by changing the path for the images folder, but unfortunately it doesn't work. Any help would be appreciated!

[ocean1]

I've updated my article here:
http://gruz.org.ua/en/about-joomla/34-virtuemart/27-vydalennja-zobrazhen-shcho-ne-vykorystovujutsja-z-virtuemart-11x.html

Some other fixes also.

Hi, great script.
Is it possible that you update it also for VM2 and Joomla 2.5.x?

[d0ublezer0]

For vm2 or vm3:

Code: [Select]

<?php
$type = 'product'; // type of image: "product" or "category"
$imgPath = $_SERVER['DOCUMENT_ROOT']."/images/stories/virtuemart/$type/"; // default path to full-sized images
$resizedPath = $_SERVER['DOCUMENT_ROOT']."/images/stories/virtuemart/$type/resized/"; // default path to thumbnail images
set_time_limit(0); 
require $_SERVER['DOCUMENT_ROOT'].'/configuration.php'; 
$conf = new JConfig; 
$db = new mysqli($conf->host, $conf->user, $conf->password, $conf->db);

$images = array_slice(scandir($imgPath), 2);
$resized = array_slice(scandir($resizedPath), 2);

$query="SELECT 
virtuemart_media_id, 
file_url, 
file_url_thumb 
FROM {$conf->dbprefix}virtuemart_medias
WHERE virtuemart_media_id IN(SELECT DISTINCT virtuemart_media_id FROM {$conf->dbprefix}virtuemart_{$type}_medias)";

$res = $db->query($query);

if (!$res) die("Cannot get database resource!");

while($r = $res->fetch_array()){
    $activeID[] = $r[0];

    $p = pathinfo($r[1]);
    $activeImg[] = $p['basename'];

    $p = pathinfo($r[2]);
    $activeResized[] = $p['basename'];
}       
if (!is_null($activeImg)){
    $notActiveImg = array_diff($images, $activeImg);   
};
if (!is_null($activeResized)){
    $notActiveResized = array_diff($resized, $activeResized);
}

if (!is_null($activeID)){
    $db->query("DELETE FROM {$conf->dbprefix}virtuemart_medias WHERE file_type='$type' AND virtuemart_media_id NOT IN(".implode(',', $activeID).")");
}
$db->close();


$full=0;
$thumb=0;
if (!is_null($activeImg)){

    foreach($notActiveImg as $i){
        if(is_file($imgPath.$i) && $i != 'index.html'){
            if (unlink($imgPath.$i)) $full++; else echo "Cannot delete $imgPath$i<br>";
        } else "File not exists $imgPath.$i<br>";
    }
}
if (!is_null($activeResized)){

    foreach($notActiveResized as $i){
        if(is_file($resizedPath.$i)  && $i != 'index.html'){
            if (unlink($resizedPath.$i)) $thumb++; else echo "Cannot delete $imgPath$i<br>";
        } else "File not exists $imgPath.$i<br>";
    }
}
if ($full>0) echo "Deleted $full full-sized images<br>";
if ($thumb>0) echo "Deleted $thumb thumbnail images<br>";
if ($full==0 && $thumb==0) echo "Nothing to delete";
?>

[ex3mist]

Hello d0ublezer0,

I've just tried your code but for some reason it didn't work. What I do is to create file /templates/YOURTEMPLATE/somefile.php and then execute it by typing this http://yoursite.com?tmpl=somefile in the browser. But nothing happens. Is it what I have to do? Am I missing something or doing anything wrong? Thanks!

[GJC Web Design]

surely http://yoursite.com/templates/yourtemplate/somefile.php in the browser

[ex3mist]

Now it worked! I guess I was doing something wrong... Thanks a lot for the sollution!