dang thumbnails...help

acirilo

can't get thumbs to be produced....this is the script....pleassssssssssseeeeeeeeeeee help.

<?php php_track_vars?>
<?php

include "config.inc";
include "misc.inc";

if(!isAdmin())
{
    die("Must be admin!");
}

if(!isset($Caption)      ||
   !isset($Comment)      ||
   !isset($Groups )      ||
   !isset($File)
)
{
    die("Need 'You must fill all fields' parameters");
}

if(!isset($ShotAtDay   ) ||
   !isset($ShotAtMonth ) ||
   !isset($ShotAtYear  ) ||
   $ShotAtDay      == '' ||
   $ShotAtMonth    == '' ||
   $ShotAtYear     == '')
{
        // Date not set - null
        $shot_at = "NULL";
} else
{
        if($ShotAtYear<1900)
        {
                die("Year must be full 4 digits");
        }
        $shot_at      = addslashes("$ShotAtYear-$ShotAtMonth-$ShotAtDay");
}

include "config.inc";
include "php-dbi.inc";
include "connect.inc";

$res=dbi_query("SELECT MAX(ID)+1 FROM Images");
if($res) 
{
        if($row = dbi_fetch_row( $res )) 
        {
                if($row[0] != null)
                {
                        $newid = $row[0];
                } else
                {
                        $newid = 0;
                }
        } else
        {       

                // no records yet
                $newid = 0;
        }
        dbi_free_result ( $res );

    // Format: yyyy-mm-dd hh:mm:ss.fffffffff
    $published_at = strftime("%Y-%m-%d %T.000000000");

    // get contents of a file into a string
    $fd = fopen( $File, "r");
    $data = addslashes(fread($fd, filesize($File)));
    fclose($fd);

    $size=getimagesize($File); 

    $Comment = addslashes($Comment);
    $Caption = addslashes($Caption);

    //produce thumbnail
    if($File_type=="image/jpeg" || $File_type=="image/pjpeg")
    {
            system("djpeg -pnm $File | pnmscale -xscale $xscale -yscale $yscale | cjpeg > $File.tmb");
            $fd = fopen( "$File.tmb", "r");
            $tmb = addslashes(fread($fd, filesize("$File.tmb")));
            fclose($fd);
            unlink("$File.tmb");
    }

    $sql   = "INSERT INTO Images (ID, Views, Bytes, Format, Caption, Comment, ShotAt, PublishedAt, Width, Height, Image, Thumbnail) VALUES ($newid, 0, $File_size, '$File_type', '$Caption', '$Comment', '$shot_at', '$published_at', $size[0], $size[1], '$data', '$tmb')";

    if(!dbi_query($sql)){
            $error = dbi_error ();
    } else {
            // Image added, not let us add it to groups
            $i=0;
            while($i < count($Groups)) 
            {
                    $g  = addslashes($Groups[$i]);
                    $sql="INSERT INTO ImageGroups (ImageID, GroupID) VALUES ($newid, $g)";
                    if(!dbi_query($sql))
                    {
                            $error = dbi_error ();
                            break;
                    }  
                    $i++;
            }
            echo "<HTML><HEAD><TITLE>Upload successful</TITLE>";
            include "styles.inc";
            echo "</HEAD><BODY CLASS=body><H1 CLASS=title>Upload successful</H1>";
            echo "<p>Your image was sucessfully uploaded to the archive.";
            echo "You can see it <a href=\"image_detail.php?Id=$newid\">here</a>.";
            include "footer.inc";
            return;
    }
} else
{
        $error = dbi_error ();
}

?>

<HTML>
<HEAD>
<TITLE>Error</TITLE>
<?php include "styles.inc"; ?>
</HEAD>
<BODY CLASS=body>

<H1>Error</H1>

<BLOCKQUOTE class="error">
<?php
echo $error;
echo "</BLOCKQUOTE>";
include "footer.inc";
?>

pnoeric

dude, you gotta be kidding ;-)

may I suggest taking your script and isolating individual parts so you can test each piece and see if it's doing what you think it should.

for example, all the code at the top is there to check your access level before the rest of the script can run. does that work properly? to test it, remove the BOTTOM part of the script and run this just to see if it correctly lets you through when it should.

if that part of the code does work, then REMOVE IT entirely (since you know it works) and then go back to the rest of the code and work on the next chunk.

get it?

best
eric

acirilo

haha i agree... yea.. all other functions work...access, headers,footers,etc

I'll just try to figure out if the "image functions" will get me what i desire... i'm not much of a programmer..just edit/hack others that they make public.. so i have a photo uploaded into the database..then the script is supposed to take that $file and resize it and put a copy in the "thumbnail" column of the database.. sounds simple enough.. //produce thumbnail don't work 🙁

// get contents of a file into a string
        $fd = fopen( $File, "r");
        $data = addslashes(fread($fd, filesize($File)));
        fclose($fd);

    $size=getimagesize($File); 

    $Comment = addslashes($Comment);
    $Caption = addslashes($Caption);

    //produce thumbnail
    if($File_type=="image/jpeg" || $File_type=="image/pjpeg")
    {
            system("djpeg -pnm $File | pnmscale -xscale 0.1 -yscale 0.1 | cjpeg > $File.tmb");
            $fd = fopen( "$File.tmb", "r");
            $tmb = addslashes(fread($fd, filesize("$File.tmb")));
            fclose($fd);
            unlink("$File.tmb");
    }

but thanks for your reply.

pnoeric

yeah, that produce thumbnail bit doesn't look good. there's a nice resizing routine (to make thumbnails) I found on one of the php.net notes, here it is:

// from [email]rze@counter-strike.net[/email] of 21-Apr-2002 03:12 at [url]http://www.php.net/manual/en/function.imagecopyresized.php[/url]
/*
port to PHP by John Jensen July 10 2001 -- original code (in C, for the
PHP GD Module) by [email]jernberg@fairytale.se[/email]
*/

// todo - move this fn into image handler library
function ImageCopyResampleBicubic($dst_img, $src_img, $dst_x, $dst_y, $src_x, $src_y, $dst_w, $dst_h, $src_w, $src_h)
{
	$palsize = ImageColorsTotal ($src_img);
	for ($i = 0; $i < $palsize; $i++) {  // get palette.
		$colors = ImageColorsForIndex ($src_img, $i);
		ImageColorAllocate ($dst_img, $colors['red'], $colors['green'], $colors['blue']);
	}

$scaleX = ($src_w - 1) / $dst_w;
$scaleY = ($src_h - 1) / $dst_h;

$scaleX2 = (int) ($scaleX / 2);
$scaleY2 = (int) ($scaleY / 2);

for ($j = $src_y; $j < $dst_h; $j++) {
	$sY = (int) ($j * $scaleY);
	$y13 = $sY + $scaleY2;

	for ($i = $src_x; $i < $dst_w; $i++) {
		$sX = (int) ($i * $scaleX);
		$x34 = $sX + $scaleX2;

		$color1 = ImageColorsForIndex ($src_img, ImageColorAt ($src_img, $sX, $y13));
		$color2 = ImageColorsForIndex ($src_img, ImageColorAt ($src_img, $sX, $sY));
		$color3 = ImageColorsForIndex ($src_img, ImageColorAt ($src_img, $x34, $y13));
		$color4 = ImageColorsForIndex ($src_img, ImageColorAt ($src_img, $x34, $sY));

		$red = ($color1['red'] + $color2['red'] + $color3['red'] + $color4['red']) / 4;
		$green = ($color1['green'] + $color2['green'] + $color3['green'] + $color4['green']) / 4;
		$blue = ($color1['blue'] + $color2['blue'] + $color3['blue'] + $color4['blue']) / 4;

		ImageSetPixel ($dst_img, $i + $dst_x - $src_x, $j + $dst_y - $src_y, ImageColorClosest ($dst_img, $red, $green, $blue)); 
	}
}
}

hope that helps

to make thumbnails with it, check out the notes on imagecopyresized.

best
Eric

acirilo

much thanks...i'm not hosting on my own box...so i can't configure the server...they are running GD 1.6 so i get errors like this..

Warning: imagecreatetruecolor(): requires GD 2.0 or later
Warning: imagecopyresampled(): requires GD 2.0 or later
so i guess i'll look around for ..
if you know of a good hosting company... i would be much in debt to know.

pnoeric

hmm I've always had good luck with http://hostway.com
but really, finding someone with up-to-date PHP shouldn't be hard
ther'es also http://onedollarhosting.com
and http://hostsave.com

I've used them all (directly or for one of my clients) and all are fine.

best
Eric