Windows > Third Party Plug-ins, Programs, and Skins

Photo Albums

<< < (3/8) > >>

nila:
Wobbley,
It sounds REALLY good :)

Pity your doing it with IIS as I'm not gonna switch the whole setup I have :(

I'd love to test it out.

Maybe after you do it send me your pages and I'll try make a php version??

I found one php script that'll read your dir's and stuff directly and make a db, it was quite a good one, just lacked a few features that I wanted.

nila:
Hey wobbley,

How's it going for you?

U having much progress on it?

I made a script that'll parse the XML but it takes a while to execute on my library (it's 50 megs and it takes approximately 4 minutes to parse it all :( - thats a bit long).

The other big problem is, fair enough it takes 4 minutes to parse it, I shouldn't be having to do that tooo often hopefully.
The problem is though there is no way to then get the information back into MC if we update it on the website via visitors.

:(

nila:
Yo,
have a look at how I did it for the parsing if u want and tell me if u can see any ways I could speed it up a lot if u dont mind :)


http://www.britcrew.com/temp/ss.php?a=index.phps

All comments welcomed :)

That gets it into the db, now I gotta write something to manage it and to sort it into more appropriate tables.

I was thinking about making it present the user with a list of all the fields with 3 check boxes: audio, video, image

and they have to check whichever boxes they want to use for each file format.
I'd then seperate the data into 3 tables for each type, then maybe try make the music relational for albums?

nila:
Well it now shows the user all the fields and lets them choose with media type each field should belong to.

After they select the fields per media type it then parses the XML, creates three tables for each media type and inserts each file into the appropriate table.

At that point it's in mySQL seperated into the types.

Next step is creating some soft of pages to browse and query the db.

I can even get php to resize the images from your originals and create the thumbs etc but the problem is php is SLOW for this type of stuff.


U having any luck with yours Wobbley?
How's it going? Is it fast?

I'm thinking about just trying to build a plugin for MC that would either act directly as a server and let it do the queries directly to it, or would automate the process of building the website to either static pages or to database driven ones.

I'd make the .css for the pages external so it can be easily modified to tweak the look of all the pages quickly.

I just gotta see how hard it is to make the plugin. I haven't looked at VB in years.


Any particular features anyone would want?

Snarglefarg:

--- Quote ---I'm thinking about just trying to build a plugin for MC that would either act directly as a server and let it do the queries directly to it, or would automate the process of building the website to either static pages or to database driven ones.
--- End quote ---

Gee, that sounds familiar. ;)

For me, dynamic pages are much more appealing than static ones since the desire to get away from static pages is what prompted me to think about Photo Albums.

Ultimately, I'd like to be able to do two things.  I'd like to be able to perform queries (either a freeform keyword field, or you could use categories using built-in dropdown menus which present the same info that would be displayed by a "column type."

Then, similar to Playlists for music files, I'd like to have my "Photo Albums" which contain a specific list of photos.

This list can either be dymanic:
- Top 10 viewed photos
- Photo's viewed today

My rating for a photo
- All 4 star photos

Rated by the user
- All 4 star photos as rated by web visitors (your ability to send results back to the database would come in handy here)

Pre-fabricated albums
- My trip to Disney World
- Family Reunion 2003

A global control would be handy which would be a "live" or "published" field. Setting this field for images in the database would decide whether this particular picture is available (or suitable) for publication on the web.  

There's a lot of potential here, and if you think of all the ways you can slice and dice music files, I think a lot of that could apply to photos.

Thanks for all of yours (and Wobbley's) hard word on this.

Navigation

[0] Message Index

[#] Next page

[*] Previous page