Administrative and Maintenance Tools - Import External Images

This vBulletin 4 product imports external images in your posts from external servers or paths into a specific path, normally your forum's image folder.

Differently than the previous product Image Cache for vBulletin 3.x., it parses the posts at regular intervals for new images and replaces the external references in the background. Also, instead of using only a single folder, it creates folders for years and months, making it much easier to handle large quantities of images. The source and destination image URL's are stored into database, too, avoiding unnecessary duplicates.

It moves and optionally converts images from one place to another. It is a handy tool in order to keep your images local to your forums.

Version 1.0.4 is temporarily in BETA stage until the users have confirmed the newly requested features.
Version 1.0.5 is still in BETA stage. It adds a new bunch of additional features, one of which allows you to test your mathematical understanding ... and a few other to fine-tune CURL and socket timeouts, and resizing on the fly of too large images. If you don't know what these options do, please leave them at their default values.

[sticky]

Originally Posted by y2ksw

You may change the task code (query) in order to limit it to certain forum sections. I believe I never will add an option for selecting forum ID's since to my opinion it does not make much sense to import only images for a few sections.

Please add this option, it would be huge for me in particular

[vortodox]

Originally Posted by y2ksw

You may change the task code (query) in order to limit it to certain forum sections. I believe I never will add an option for selecting forum ID's since to my opinion it does not make much sense to import only images for a few sections.

Actually it has allot sense, in my case there are some SPAM forumus in which members post many humoristic picts which I don't whish on my server, but on the other hand there are review with pictures which i really wish to have on my server.

Anyway, how do I change task code? /noob here :erm:

Originally Posted by sticky

Please add this option, it would be huge for me in particular

Seconded.

[BirdOPrey5]

Just for the info of those who may need this feature, I made this edit for it to not import images from 2 specific forums... I am releasing this for info only, I don't recommend you make this change nor will I support it.

In ie_cron.php file I changed:

"SELECT postid, dateline, pagetext, forumid 
    FROM " . TABLE_PREFIX . "post join " . TABLE_PREFIX . "thread on (post.threadid = thread.threadid
    WHERE iei_parsed=0
        AND pagetext LIKE '%[/IMG]%'
    ORDER BY postid";

to:

$SQL = "SELECT postid, " . TABLE_PREFIX . "post.dateline, pagetext, forumid 
    FROM " . TABLE_PREFIX . "post join " . TABLE_PREFIX . "thread on (" . TABLE_PREFIX . "post.threadid = " . TABLE_PREFIX . "thread.threadid)
    WHERE iei_parsed = 0
        AND pagetext LIKE '%[/IMG]%' AND forumid != 2 AND forumid != 4
    ORDER BY postid";

This would import images from all forums EXCEPT forum id 2 and forum id 4 which were my off-topic and a private forum on my setup.

[BadgerDog]

Originally Posted by BirdOPrey5

Just for the info of those who may need this feature, I made this edit for it to not import images from 2 specific forums... I am releasing this for info only, I don't recommend you make this change nor will I support it.

Thanks, but I think you need to clarify which version you're using?

I'm using the current 1.0.2 and my ie_cron.php file shown below does not have the additional ", forumid" on end of the $SQL string to search for?

$SQL = "SELECT postid, dateline, pagetext
FROM " . TABLE_PREFIX . "post
WHERE iei_parsed=0
AND pagetext LIKE '%[/IMG]%'
ORDER BY postid";

Regards,
Doug

[BirdOPrey5]

Originally Posted by BadgerDog

Thanks, but I think you need to clarify which version you're using?

I'm using the current 1.0.2 and my ie_cron.php file shown below does not have the additional ", forumid" on end of the $SQL string to search for?



Regards,
Doug

I'm using the current version, whatever it is, I just downloaded it recently. I know there is no forumid in the ORIGINAL code (which I specified in my post) I ADDED the forumids and a JOIN statement in my code which is the second block of code in my post.

My point is to change the original code to the new code I specified.

[BadgerDog]

Originally Posted by BirdOPrey5

I'm using the current version, whatever it is, I just downloaded it recently. I know there is no forumid in the ORIGINAL code (which I specified in my post) I ADDED the forumids and a JOIN statement in my code which is the second block of code in my post.

My point is to change the original code to the new code I specified.

Thanks...

I'll ignore you find part of the code search and just use the replace part .. :up:

If I use a ForumID that has sub-forums, does that mean ALL sub-forums will be ignored too?

Appreciate your efforts...

Regards,
Doug

[BirdOPrey5]

No it doesn't cover subforums, each forumid must be entered manually. You can add more ANDs or consult a mysql manual for a better query.

[y2ksw]

Originally Posted by BirdOPrey5

No it doesn't cover subforums, each forumid must be entered manually. You can add more ANDs or consult a mysql manual for a better query.

Better query

$SQL = "SELECT postid, " . TABLE_PREFIX . "post.dateline, pagetext, forumid 
    FROM " . TABLE_PREFIX . "post join " . TABLE_PREFIX . "thread on (" . TABLE_PREFIX . "post.threadid = " . TABLE_PREFIX . "thread.threadid)
    WHERE iei_parsed = 0
        AND pagetext LIKE '%[/IMG]%' 
        AND NOT forumid IN (1, 2, 3)
    ORDER BY postid";

The IN clause holds all forums to exclude. Contrarily:

$SQL = "SELECT postid, " . TABLE_PREFIX . "post.dateline, pagetext, forumid 
    FROM " . TABLE_PREFIX . "post join " . TABLE_PREFIX . "thread on (" . TABLE_PREFIX . "post.threadid = " . TABLE_PREFIX . "thread.threadid)
    WHERE iei_parsed = 0
        AND pagetext LIKE '%[/IMG]%' 
        AND forumid IN (4, 5, 6)
    ORDER BY postid";

The IN clause holds all forums to include.

As always, please try first in a sandbox

[BirdOPrey5]

I want to suggest one more change I've used successfully on my test forum that may be of use to people with established forums.

In that query change ORDER BY postid to ORDER BY postid DESC so that the newest threads are processed first since it might take days or weeks to process a large existing forum.

[BadgerDog]

Originally Posted by BirdOPrey5

I want to suggest one more change I've used successfully on my test forum that may be of use to people with established forums.

In that query change ORDER BY postid to ORDER BY postid DESC so that the newest threads are processed first since it might take days or weeks to process a large existing forum.

Wouldn't it be better to process the oldest threads first, simply because users who fail to renew their off-site storage, or their free 30 day trials run out, would get those pics moved internally first so there's less chance of ending up with missing pics when that happens?

By the way, thanks for the tips ..

Regards,
Doug