| Author |
 Topic  |
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
 Posted - 10 October 2003 : 11:59:34
|
I have 30 images that I want to use on my site, one for each time I make a post. Now there are two things I need to do
1- add those images to the database
2- find a good way to select one image
As for number 1, I was thinking about using a seperate table in the database, each image would get an image_id, the image's file name, and a one or two word description. One extra number field would be added to the TOPICS table, and then when I make a post, the image's ID would be stored in that new field.
When the topic is pulled from the DB, the image ID stored with the topics would get linked to that in the images table and the image name and description would get retrieved then too.
Am I correct to say that that's the best way to go about it?
Now for number 2... Since there are a lot of images, I was thinking about using two select boxes. But then I wouldn't be able to see the images. How would you solve this? |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 10 October 2003 : 12:59:17
|
Sounds suspiciously like the Message Icons Mod to me ... 
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 10 October 2003 : 13:00:10
|
| Add a field to your images table for a thumbnail filename, then create a popup which displays thumbnails in a pattern similar to the smilies on the post page - a grid/table pattern. Click on one, and it passes your selection back. |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 10 October 2003 : 13:30:02
|
Or, you could display the image next to the select box and use javascript to change it when a visitor selects a different option.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 10 October 2003 : 13:57:03
|
it won't be like the message icons MOD, it'll be to show the mood I'm in I was thinking about changing it site-wide by adding it somewhere on the left side of the pages, but I figure it's more "fun" to show the mood I was in when I posted something.
As for the pop-up, I think that might work (no thumbnails needed as the images should only be approximately 20x20px) but then I might as well do what MeTV said.
Thanks guys  |
|
|
|
LinkinMODE101
Junior Member
116 Posts |
Posted - 10 October 2003 : 15:17:48
|
hey frutzle...it's not letting me e-mail you, but i already changed the little "POWERED BY:" thing, so please unlock my topic now.
www.latearrivalmusic.com/forum/ |
|
|
|
Bookie
Average Member
USA
856 Posts |
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 10 October 2003 : 15:54:04
|
LinkinMODE101, sorry about not unlocking your topic sooner. My host seems to be having quite some problems today so it's possible that I never got your email.
Bookie, that's the other option I was considering. It would cut down on bandwidth if the images don't get loaded each time... I've found those same icons as you're using, but they're a bit too big for my liking, so I think I'll give it a shot and make some myself. |
|
|
| |
Topic |
|
Topic Locked
