Fix Issues Image Cron Script

Fix issues image cron script

We have an image cron script made in PHP which saves images from image-urls in the MySQLdatabase. There are some issues which I would like to have solved asap. Here is what the script does exactly:

1. Download the images of all products from table ‘affiliSt_products1′, column ‘prodImageURL’. An image can be in GIF or in JPEG format.
1a. If the image already exists, don’t download it -> Go to point 5 (Change the old URLs…)
1b. If the image doesn’t exist, download it -> Go to point 2 (Save them…)

2. Save them in the directory ‘/afbeeldingen/origineel’ and use the productname (column ‘prodName’) + productID of the merchant (column ‘merchantProdID’) as filename. Recplace spaces in the filename with ‘+‘ and the last space before the productID with ‘-‘. So for example a filename could be Van+der+valk+hotel+Assen-12345.jpg.

3. Resize the images in 2 formats, one which has a width of 180px and one which has a width of 250px. The image size is adjustable.

4. Save the 180px images in the directory ‘/afbeeldingen/klein’ , save the 250px images in the directory ‘/afbeeldingen/groot’. This size is also adjustable.

5. Change the old URLs of the images in the database to the new ones. Update the URLs of the 250px images in column ‘prodImageURL’ and the 180px images in ‘prodImageSmall’.

The script works almost fine, however there are a few issues that need to be solved:

1. On a local server the script works, on my new server online (CentOS, PHP 5.2.3) it gives this error: “Notice: Undefined index: TOTAL_IMAGES in xxxx/includes/get_image.php on line 58”

2. When I start the script with empty local image folders, it should download all images. However the script says that 39 images are already saved and it skips them. There are 39 products of the merchant ‘Fletcher’ in the database. I assume something goes wrong here.

3. If there’s a ‘strange’ character in the productname like “é,â,ä,à,å,ç,ë, etc..” the image is saved with a name like this D%FCsseldorf… and then the image can’t be loaded on the webpage. This should be solved.

4. There are some GIF images which are 375 bytes in sizes and black. I think this is caused by point 3 (strange characters) but am not sure.

5. Every night the products are refreshed in the database. So all the image-urls are set back and this image script has to run again. In this case the images already exist (they’re downloaded before). The script then detects the images already exist but it doesn’t set the image-urls to the new urls. (point 1a, it should go to point 5).

I hope this is clear, if not please let me know.

Fix Issues Image Cron Script

Fix issues image cron script

We have an image cron script made in PHP which saves images from image-urls in the MySQLdatabase. There are some issues which I would like to have solved asap. Here is what the script does exactly:

1. Download the images of all products from table ‘affiliSt_products1′, column ‘prodImageURL’. An image can be in GIF or in JPEG format.
1a. If the image already exists, don’t download it -> Go to point 5 (Change the old URLs…)
1b. If the image doesn’t exist, download it -> Go to point 2 (Save them…)

2. Save them in the directory ‘/afbeeldingen/origineel’ and use the productname (column ‘prodName’) + productID of the merchant (column ‘merchantProdID’) as filename. Recplace spaces in the filename with ‘+‘ and the last space before the productID with ‘-‘. So for example a filename could be Van+der+valk+hotel+Assen-12345.jpg.

3. Resize the images in 2 formats, one which has a width of 180px and one which has a width of 250px. The image size is adjustable.

4. Save the 180px images in the directory ‘/afbeeldingen/klein’ , save the 250px images in the directory ‘/afbeeldingen/groot’. This size is also adjustable.

5. Change the old URLs of the images in the database to the new ones. Update the URLs of the 250px images in column ‘prodImageURL’ and the 180px images in ‘prodImageSmall’.

The script works almost fine, however there are a few issues that need to be solved:

1. On a local server the script works, on my new server online (CentOS, PHP 5.2.3) it gives this error: “Notice: Undefined index: TOTAL_IMAGES in xxxx/includes/get_image.php on line 58”

2. When I start the script with empty local image folders, it should download all images. However the script says that 39 images are already saved and it skips them. There are 39 products of the merchant ‘Fletcher’ in the database. I assume something goes wrong here.

3. If there’s a ‘strange’ character in the productname like “é,â,ä,à,å,ç,ë, etc..” the image is saved with a name like this D%FCsseldorf… and then the image can’t be loaded on the webpage. This should be solved.

4. There are some GIF images which are 375 bytes in sizes and black. I think this is caused by point 3 (strange characters) but am not sure.

5. Every night the products are refreshed in the database. So all the image-urls are set back and this image script has to run again. In this case the images already exist (they’re downloaded before). The script then detects the images already exist but it doesn’t set the image-urls to the new urls. (point 1a, it should go to point 5).

I hope this is clear, if not please let me know.

Rugged Rambler Makes Lugging Loads Fair and Balanced

Product: Rambler Backpack

Manufacturer: Mission Workshop

Wired Rating: 9

We technophilic, city-livin’ free radicals love our bags. Owning a stylish over-the-shoulder number that can comfortably cradle a MacBook Pro, a DVD box set of The Wire and a 12-pack of Pabst is of absolute importance.

The Rambler, little brother to Mission Workshop’s SUV-sized Vandal, is the perfect backpack for tooling around the city, whether by sidewalk, bike lane, subway or Vespa. Bike messengers and cargo-crazy commuters will probably prefer the freakishly huge Vandal, but the Rambler, with its more populist dimensions (it fits under the seat in front of you on an airplane) is big enough for the rest of us.

The bag has three large compartments — the main cargo area, a roll-top pocket that runs down the length of the bag on the inside, and a slim zipper pocket on the outside. The cargo compartment is where all the magic happens. It’s big enough to hold a laptop, your lunch, a hoodie and a set of headphones with room to spare. But the cargo area can also expand to twice its own size. Unzip the bag all the way and the front swings out to reveal an interior “basket.” Inside, there’s a second waterproof urethane-coated zipper to close in snug around your payload, and two buckle straps to keep bigger loads secure. The roll-top can also be unfurled into a flap and buckled down over the top for extra protection against the elements. There are enough configurations hidden in the Rambler’s design to keep everything secure and dry.

Even fully expanded and stuffed to the gills, the Rambler still earns crazy high marks for comfort. The straps and back are well-padded, and an internal frame keeps the back rigid. There are also load-balancing straps on the shoulders and a chest strap to keep those Franzia boxes from tipping you over. A padded waist belt is an optional extra.

Besides taking the Rambler on my daily 7-mile bike commute every day for two months, I also used it to haul a fat stack of records to a half-dozen DJ gigs. Normally, riding my bike with 35 or 40 LPs on my back is a genuine suffer-fest, but stuffed and strapped into the Rambler, the load was comfy and well-balanced. The bag endured a rainstorm in New Orleans, keeping my change of clothes inside bone dry. The versatility of that expanding cargo basket was put to the test on countless grocery shopping trips and wine-sipping picnics in the park.

The only bummer is the lack of accessory pockets. There’s a small zipper pouch on the outside of the Rambler that’s just big enough for your wallet, or an iPhone and a set of earbuds. But any other loose objects — sunglasses, pens, USB sticks, your patch kit, a change of socks — will have to ride with the rest of your cargo in the three big pockets.

The Rambler does have a cool Easter egg, though: If you carry a U-lock, you can secure it on the outside of the bag where it won’t smoosh your sandwich. Pull the elastic buckle strap down through its cloth housing to make a small loop at the bottom. Thread the lock through the loop and lock it, then snap the buckle closed on top of it.

WIRED The most comfortable light cargo backpack on the market. Super versatile (5- gallon capacity, expands to 10 gallons). Fully waterproof — urethane-coated zippers and tight stitching are impenetrable to the elements. Comfortable, even under heavy loads. Handsome good looks. Handmade by real fixie-riding San Francisco hipsters.

TIRED No accessory pockets. Roll-top compartment isn’t secured inside the bag, so it hangs down inside the cargo area where it can get in the way.

product image

Rugged Rambler Makes Lugging Loads Fair and Balanced

Product: Rambler Backpack

Manufacturer: Mission Workshop

Wired Rating: 9

We technophilic, city-livin’ free radicals love our bags. Owning a stylish over-the-shoulder number that can comfortably cradle a MacBook Pro, a DVD box set of The Wire and a 12-pack of Pabst is of absolute importance.

The Rambler, little brother to Mission Workshop’s SUV-sized Vandal, is the perfect backpack for tooling around the city, whether by sidewalk, bike lane, subway or Vespa. Bike messengers and cargo-crazy commuters will probably prefer the freakishly huge Vandal, but the Rambler, with its more populist dimensions (it fits under the seat in front of you on an airplane) is big enough for the rest of us.

The bag has three large compartments — the main cargo area, a roll-top pocket that runs down the length of the bag on the inside, and a slim zipper pocket on the outside. The cargo compartment is where all the magic happens. It’s big enough to hold a laptop, your lunch, a hoodie and a set of headphones with room to spare. But the cargo area can also expand to twice its own size. Unzip the bag all the way and the front swings out to reveal an interior “basket.” Inside, there’s a second waterproof urethane-coated zipper to close in snug around your payload, and two buckle straps to keep bigger loads secure. The roll-top can also be unfurled into a flap and buckled down over the top for extra protection against the elements. There are enough configurations hidden in the Rambler’s design to keep everything secure and dry.

Even fully expanded and stuffed to the gills, the Rambler still earns crazy high marks for comfort. The straps and back are well-padded, and an internal frame keeps the back rigid. There are also load-balancing straps on the shoulders and a chest strap to keep those Franzia boxes from tipping you over. A padded waist belt is an optional extra.

Besides taking the Rambler on my daily 7-mile bike commute every day for two months, I also used it to haul a fat stack of records to a half-dozen DJ gigs. Normally, riding my bike with 35 or 40 LPs on my back is a genuine suffer-fest, but stuffed and strapped into the Rambler, the load was comfy and well-balanced. The bag endured a rainstorm in New Orleans, keeping my change of clothes inside bone dry. The versatility of that expanding cargo basket was put to the test on countless grocery shopping trips and wine-sipping picnics in the park.

The only bummer is the lack of accessory pockets. There’s a small zipper pouch on the outside of the Rambler that’s just big enough for your wallet, or an iPhone and a set of earbuds. But any other loose objects — sunglasses, pens, USB sticks, your patch kit, a change of socks — will have to ride with the rest of your cargo in the three big pockets.

The Rambler does have a cool Easter egg, though: If you carry a U-lock, you can secure it on the outside of the bag where it won’t smoosh your sandwich. Pull the elastic buckle strap down through its cloth housing to make a small loop at the bottom. Thread the lock through the loop and lock it, then snap the buckle closed on top of it.

WIRED The most comfortable light cargo backpack on the market. Super versatile (5- gallon capacity, expands to 10 gallons). Fully waterproof — urethane-coated zippers and tight stitching are impenetrable to the elements. Comfortable, even under heavy loads. Handsome good looks. Handmade by real fixie-riding San Francisco hipsters.

TIRED No accessory pockets. Roll-top compartment isn’t secured inside the bag, so it hangs down inside the cargo area where it can get in the way.

product image

Wdw.com

New Project
Front End Developer to create a “Storyboard”, to outline in detail the function of a planed website. Timeframe 5-7 days.
Requirement: 3 professional years of experience, including 2 years of user experience design/interaction design.
Proficient in:
PHP HTML, CSS, XHTML, XML Javascript,Joomla
NOTE: after “Storyboard” work, web design + various apps are considered.

Wdw.com

New Project
Front End Developer to create a “Storyboard”, to outline in detail the function of a planed website. Timeframe 5-7 days.
Requirement: 3 professional years of experience, including 2 years of user experience design/interaction design.
Proficient in:
PHP HTML, CSS, XHTML, XML Javascript,Joomla
NOTE: after “Storyboard” work, web design + various apps are considered.

Need Link Directory Script

This has to be a combination of link and article directory.
Here are the details of what I want
1. need to be able to put multiple links under 1 name (as parts)
2. need to be able to use like an article page without link
3. need to be have multi level categories
4. need to be able to associate icons with categories
5. users should be able to submit links/articles (I should be able to approve)
6. Admin area with ability to add multiple links at a time

For any more details please contact me