Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > Full screen slideshows (SQL database?)

Full screen slideshows (SQL database?)
Thread Tools
Junior Member
Join Date: Dec 2006
Status: Offline
Reply With Quote
May 18, 2007, 07:56 PM
 
Hello...

I'm looking to display images (ads, really) as a full screen slidesho with assorted effects. Preferrably it'd fetch from a SQL database. If not SQL then I'd need a way to easily send slideshows to multiple remote locations.

Any suggestions?
     
Mac Elite
Join Date: Oct 2000
Location: Seattle
Status: Offline
Reply With Quote
May 19, 2007, 07:18 AM
 
I can't think of anything off the shelf but you may be able to applescript iPhoto or even trigger a the screen saver with images downloaded to a particular folder.

Someone could whip up a custom application in Real Basic. That can handle the Quicktime interface for image display and transitions, as well as database connections.
You can take the dude out of So Cal, but you can't take the dude outta the dude, dude!
     
Professional Poster
Join Date: Jan 2001
Location: Manchester,UK
Status: Offline
Reply With Quote
May 19, 2007, 01:10 PM
 
You could possibly use the inbuilt Apache web server, and use some sort of html,Flash, javascript or PHP based solution. I think I came across a few when I wanted something to do a slideshow on a web-site.
     
opus_az  (op)
Junior Member
Join Date: Dec 2006
Status: Offline
Reply With Quote
May 19, 2007, 04:27 PM
 
Originally Posted by Mediaman_12 View Post
You could possibly use the inbuilt Apache web server, and use some sort of html,Flash, javascript or PHP based solution. I think I came across a few when I wanted something to do a slideshow on a web-site.
Yeah, I'm finding those too. Problem is I'd still have the browser bar visible. This is more for a kiosk application
     
Professional Poster
Join Date: Jan 2001
Location: Manchester,UK
Status: Offline
Reply With Quote
May 20, 2007, 11:50 AM
 
look for Web Kiosk on MacUpdate There are various Safari/webkit kiosk apps. including this Free one.
     
opus_az  (op)
Junior Member
Join Date: Dec 2006
Status: Offline
Reply With Quote
May 21, 2007, 09:18 PM
 
Originally Posted by Mediaman_12 View Post
look for Web Kiosk on MacUpdate There are various Safari/webkit kiosk apps. including this Free one.
Thanks!
     
Professional Poster
Join Date: Oct 1999
Location: :ИOITAↃO⅃
Status: Offline
Reply With Quote
May 21, 2007, 10:15 PM
 
Another option would be using a Quartz Composer screen saver and an RSS feed for the images. I think that'd work rather well, actually.

Here's a quick example of a screensaver that grabs image URLs from a configurable RSS feed -- I have it preset to show some random rafting photos of mine. You could have it do something tamer, of course, if you're not into the rotating cube thing. Unzip and put it in ~/Library/Screen Savers/ to try it out.

RSS Slide Show.qtz.zip

I use Feeder to generate the RSS feed, but you can make it by hand with a text editor easily enough. Here's the first bit of the feed:
[codex]
<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
<channel>
<title>Photos</title>
<link>http://harnly.net</link>
<description>Some photos</description>
<generator>Feeder 1.4 http://reinventedsoftware.com/feeder/</generator>
<docs>http://blogs.law.harvard.edu/tech/rss</docs>
<language>en</language>
<pubDate>Tue, 22 May 2007 01:53:01 -0400</pubDate>
<lastBuildDate>Tue, 22 May 2007 01:53:01 -0400</lastBuildDate>

<item>
<title>Photo 1</title>
<link>http://www1.cs.columbia.edu/~aaron/travel/colorado/photos/high/IMG_0612.jpg</link>
<pubDate>Tue, 22 May 2007 00:25:06 -0400</pubDate>
<guid isPermaLink="false">photo-1</guid>
</item>

<item>
<title>Photo 2</title> <link>http://www1.cs.columbia.edu/~aaron/travel/colorado/photos/high/IMG_0614.jpg</link>
<pubDate>Tue, 22 May 2007 00:26:07 -0400</pubDate>
<guid isPermaLink="false">photo-2</guid>
</item>
<item>
(etc)
</channel>
</rss>

[/codex]
(Last edited by Mithras; May 22, 2007 at 01:55 PM. )
     
Professional Poster
Join Date: Oct 1999
Location: :ИOITAↃO⅃
Status: Offline
Reply With Quote
May 22, 2007, 01:56 PM
 
I tweaked the screensaver to use a 4:3 aspect ratio. Anything else will look squished or stretched, though. Here's a screenshot:

     
   
Thread Tools
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 06:55 AM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2