?

Log in

No account? Create an account

Previous Entry | Next Entry

playing with the dvdlist

I have been working on my dvdlist for the past couple hours. It started as a simple project to do some math with the amount of money I have spent (see the bottom of the page) and has turned into a much bigger project. what i did was I added another column to the movie database called imdb. what it does is it saves the link to the imdb entry for that movie. but in order to have this work, i had to edit the list script a bit and i also has to make a script that would allow for easy editing of the database. moved some things around and now have just been inputing the imdb links. it's going to take a long time for all the links to be there, but oh well. it's something to do, i suppose.

I'll keep doing this for a while.

Comments

( 14 comments — Leave a comment )
bradfitz
Mar. 27th, 2001 11:57 pm (UTC)
you should write a script to automatically find the links.... that'd be fun. :-)
seadawg
Mar. 28th, 2001 12:04 am (UTC)
If you link to it like http://us.imdb.com/Title?Usual+Suspects,+The it works. Although, if there are multiple possibilities, it will act as a search results page. A quick and ugly hack would just be to wrap the titles into that format, and moving "The" and "A"s to the end.
patrick
Mar. 28th, 2001 12:34 am (UTC)
yea, I was thinking about it, but i don't want it to point to the search result. I would rather get the number.

The biggest problem with this isn't inputing the film, it's more a problem with my internet connection. anything that is physically located in seattle i have routing problems with. it's the same with livejournal, except imdb is worse. I am always getting connection time-outs and 'no route to host' errors with imdb. @home makes me cross.
(Deleted comment)
patrick
Mar. 28th, 2001 01:12 am (UTC)
Re: More interesting.
Ok, done. Should I include the average with the gifts at all?
(Deleted comment)
patrick
Mar. 28th, 2001 02:26 am (UTC)
Re: Hmmm...
yea, me too.
tydel
Mar. 28th, 2001 01:03 am (UTC)
So, I'm not the only one that's got mysql fever :P I did that a couple days ago with my MP3 collection (puny, I know). It's at mp3.net-addicts.net ... I did my script to sorta get familiar with mysql though, because I'd never used it before :)
patrick
Mar. 28th, 2001 01:16 am (UTC)
Well, I actually wrote this a while back. In november, i think. This is more of a "i don't have a car and am really bored so i'll work on it more" sort of thing.

It's interesting, though. good way to learn the basics of SQL databases. :)
(Deleted comment)
patrick
Mar. 28th, 2001 06:08 pm (UTC)
Re: Ahem.
Well played.... clerks.
cozmo
Mar. 28th, 2001 10:00 am (UTC)
Me too
I have been working on one of those myself, except I didn't do it to see how much money I spent, I did it to see how many movies I have and how long they are. Check out mine It has genres/groups too. The coolest part is that the genre lists (like the dropdown on the main page and the add form) are generated from the columns in the db so I can add and remove groups without changing any code. It isn't finished, and the movie details page doesn't show the genres. I want to do some more work to the sort orders and I don't have a modify page yet so I can't fix all those stupid errors introduced by human data input (unless I want to do it(sql) by hand) ;)

Database currently contains 91 movies Totalling: 171.30 hours
If you sat on your ass constantly watching movies it would take you 7.1 days to see them all
patrick
Mar. 28th, 2001 12:12 pm (UTC)
Re: Me too
I like your list. I was thinking about making data pages for each movie instead of linking to imdb, but that was alot more work to get the metadata for each film.
cozmo
Mar. 28th, 2001 12:48 pm (UTC)
Re: Me too
I only have to put the info in there once, and since I rarely get more than 3 movies at a time, it isn't very hard to put the data in myself. It did take me a few hours worth of work to put all the movies I already had in there, but it wasn't bad. It was actually kinda fun to go back through my movies and look at them. It made me want to watch a lot of them again.
The cool thing about the way I did it is that you can search for people, years, or even screen formats. I'm starting to wish I had a field for price so I could have a running total of money I've spent.. I think it is too late for that though.
lizzimonster
Mar. 28th, 2001 06:04 pm (UTC)
Which version of Lolita is that?
patrick
Mar. 28th, 2001 06:06 pm (UTC)
why, it's the super cool stanley kunbrick version of lolita. :)

I have yet to see the newer version of that story.
lizzimonster
Mar. 28th, 2001 09:14 pm (UTC)
Re:
Stanley Kubrick is super cool in general. I didn't know that version was on DVD. I had to implore my stepsister, Blockbuster manager extraordinaire, to order it for me. But we've already discussed the quality of video rental stores in the greater Dover, NH area.

I liked the newer version as well, you should check it out sometime. While the Kubrick is more affecting, I also found the newer version interesting... Jeremy Irons and Melanie Griffith are good, and Dominique Swain was really good. it's interesting to see the contrast in what's considered risque, then and now.
( 14 comments — Leave a comment )

Profile

villain
patrick
The Greatest Fucking Genius of All Time

Latest Month

June 2010
S M T W T F S
  12345
6789101112
13141516171819
20212223242526
27282930   

Tags

Powered by LiveJournal.com