vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Image Status Checker / Dead Image Finder (https://vborg.vbsupport.ru/showthread.php?t=124113)

bairy 08-17-2006 06:32 PM

Updated to 1.01 to clear up the early bugs and improve a few things:

- Misc: Install code creates empty db table
- Misc: Corrected silly oversight to reduce db errors (escaping image urls)
- Scanner: Added options to maintenance section
- Scanner: Rewrote quite a bit of the code to work with the new options
- Browser: Added "you haven't scanned yet" warning if the table is missing (unlikely but best to be handled)
- Browser: isc_no_results template wasn't included in the 1.00 product for some reason. It is now and is used when there are no results
- Browser: Added a perpage, lower limit 5, upper limit 100. Outside these and it defaults to 30

Reupload imagestatuscheck.php. Reimport the product xml with overwrite set to yes.

Snatch 08-18-2006 05:17 AM

If I click on "search/Filter" it blinks an than it shows me the startscreen of imagestatuscheck.php but no resulst.

What is wrong?

GreeTz
Snatch

bairy 08-18-2006 07:21 AM

Have you run a scan first?
If so, how many images did it scan?

Snatch 08-18-2006 07:43 AM

LoL sorry, my fault.

GreeTz
Snatch

Snatch 08-18-2006 07:50 AM

2 more questions.

1:
now i runed the process for find death images.
But when I go to the .php File i get this Error
Code:

Datenbankfehler in vBulletin 3.6.0:

Invalid SQL:

        SELECT
        i.id AS iid, i.postid, i.userid, i.imageurl, i.status,
        u.username,
        t.forumid, t.title AS threadtitle,
        f.title AS forumtitle
        FROM imagestatus i
        LEFT JOIN user u ON (i.userid = u.userid)
        LEFT JOIN post p ON (i.postid = p.postid)
        LEFT JOIN thread t ON (p.threadid = t.threadid)
        LEFT JOIN forum f ON (t.forumid = f.forumid)
        WHERE i.`status` IN (401,402,403,404,405,406,407,409,410,411,412,413,414,415,416,417,000,0,100,101,201,202,203,204,205,300,301,303,305,400,408,500,501,502,503,504,505)
        AND t.forumid NOT IN (0)
       
        ORDER BY u.username asc
        LIMIT 0, 30;

MySQL-Fehler : Got error 28 from storage engine
Fehler-Nr.  : 1030
Datum        : Friday, August 18th 2006 @ 10:48:58 AM
Skript      : http://www.celebritymarkt.de/imagestatuscheck.php
Referrer    :
IP-Adresse  :
Benutzername :
Klassenname  : vb_database

Or is it so, that I can only use the php file if the search are finisched ?
562,783 images remaining Muhahaha

2:
What means the text "duplicate / dealt with" behind the ImageUrl?
Show Attach!
The first 2 Pages are o.k. but then only "duplicate / dealt with"

GreeTz
Snatch

bairy 08-18-2006 09:54 AM

Error code 28 means no more space left. Either the hard drive ran out of space or your allowed disk space maxed itself.
If you really have 562k images, and I believe you do, then that's not really a surprise as the script creates a new table with all the images in it. I have 1300 images and takes up about 170k. So multiplying it up there's probably a table size of 70mb or so.

However it obviously managed to get some images in at least.

The duplicate/dealt with message comes up because:
Lets say you have one image and it's been linked in 2 posts. There's no point scanning the same image twice since one scan will tell us if it's valid. Therefore it's scanned once and if the image comes up again it's counted as 'duplicate' or 'dealt with' (they mean the same thing in this case).
Another reason is if you resume a scan (not restart it). As it will already have scanned some of the images and they'll be classed as "dealt with".
If you have a lot of images saying that then it could be because you're doing another scan but not from the start, or it could be related to the error 28, depending what got inserted and what didn't.

osso12 10-26-2006 04:04 AM

Does this work with VB 3.6.2?
If so, everytime I run a scanner, and then run statuscheck.php,
I get:
You haven't run the scanner yet. You will find it in the Admin Control Panel under Maintainance -> Update Counters, at the bottom.
Non-admins don't see this message.
Tried a hundred times, but keeps doing the same thing.:down:

image status checker in vb options: 5,6,7
I need to get this to work.
Please someone help.

bchertov 12-18-2006 03:32 PM

{I first posted my query in the URL checker thread}

Hi,

I have a custom HTML Daily Digest that includes Images that are inserted using {IMG} tags. I want to prevent images from forcing the Digest to be too wide because they are over 750 pixels wide. I can resize it in the digest if I know the image is too wide. So I'm looking for some code that will tell my how wide an {IMG} is. Can this hack help me? Can you help me?

Thanks!
Barry

bairy 12-18-2006 04:47 PM

Ahhh now I see.

I've just realised that basically, no.
I think that in order to get the dimensions of an image, the server would have to fully download it and then analyse it as the information isn't included in the http headers. That would drain the destination server's bandwidth and take a lot longer.

My only real suggestion is to load up the images you want to include in a web browser, right click them and click properties, and see the dimensions there.

bchertov 12-19-2006 03:18 PM

Quote:

Originally Posted by bairy (Post 1141065)
My only real suggestion is to load up the images you want to include in a web browser, right click them and click properties, and see the dimensions there.

Thanks, but I was trying to find some automated way of doing this. I guess I'll check the image resizing hacks to see how they do it. Thanks anyway.


All times are GMT. The time now is 03:22 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01660 seconds
  • Memory Usage 1,741KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete