?

Log in

No account? Create an account
Another time waster - Queue — LiveJournal
May 25th, 2002
07:16 am

[Link]

Previous Entry Share Next Entry
Another time waster
I made a page that loads random userpics. It brings up a different number of them sometimes because of deleted journals or just deleted userpics, and those numbers apparently don't get reassigned. There have been something like 1.7 million lj userpics. I had thoughts about having it check to make sure that the userpic was actually a valid link, but that's just a lot of work for not a lot of return, since I just have it try to load 20, and it ends up loading something like 6-12, which is fine.

Is this nifty enough for lj_nifty? Any suggestions for other things to do with it?

(9 comments | Leave a comment)

Comments
 
[User Picture]
From:bobtfish
Date:May 25th, 2002 06:11 am (UTC)
(Link)
Link the images to people's journal's, and it would be great..
[User Picture]
From:queue
Date:May 25th, 2002 06:15 am (UTC)
(Link)
Well, unfortunately, I don't think they're stored that way. They just get a number based on the order of creation of the image. I suppose I could pick a random journal and then a random pic from that journal, but that wouldn't feel as exciting. Or maybe it would, just not as exciting to write.

Thanks.
[User Picture]
From:slinkr
Date:May 25th, 2002 07:54 am (UTC)
(Link)
The database schema lets you retrieve a user ID based on a userpic ID, so you could retrieve usernames.

What might be more nifty though is to just retrieve one or more the keywords associated with a userpic. That way you get the anonymous picture effect but also some inkling of what the photos are about or associated with. The db schema is here if you haven't been looking at it already (userpic and userpicmap are the relevant tables).
[User Picture]
From:queue
Date:May 25th, 2002 08:03 am (UTC)
(Link)
Aha. I sense much funnage ahead of me. Thanks very much for the link. Someone want to call me around 1:30 so I don't end up missing my own birthday party?
[User Picture]
From:queue
Date:May 27th, 2002 05:57 pm (UTC)
(Link)
Okay, I've been doing some poking around, and either the information is not easily accessible or I am just an idiot. Exactly how do I query the LiveJournal database? I found the client-server protocol page, which tells you how to make clients to post entries and such, but there's nothing in there to let me know how to just grab a table from the database. Any help?
[User Picture]
From:bobtfish
Date:May 25th, 2002 08:25 am (UTC)

Re:

(Link)
Ah, thats fair enough.. And doing a picture -> username lookup I assume isn't possible unless your a livejournal webserver...
[User Picture]
From:queue
Date:May 25th, 2002 08:56 am (UTC)
(Link)
Well, looks like I'll just have to start talking to the LJ sever directly. Found out where all the info is for people who develop clients, so this is definitely doable. Whee.
[User Picture]
From:cthulhia
Date:May 25th, 2002 08:22 am (UTC)

between this and the friendfriend thing, I am skipping your birthday

(Link)
quitting my job AND dropping out of society. you are EVIL,

but here's some kittens:
http://www.livejournal.com/userpic/933404

this is just plain wrong:
http://www.livejournal.com/userpic/1130105

maybe I'll use this one in place of my other fishes
http://www.livejournal.com/userpic/672665

there goes doing that for one of my icons:
http://www.livejournal.com/userpic/1746357

lots of folks I know would like to use this one:
http://www.livejournal.com/userpic/416550

lots of south park, simpsons, dollmakers and way too much anime. and lots of close-ups of one's eyes. (more kittens too)

yes, and the winner is:
http://www.livejournal.com/userpic/1656787

although I've reloaded 100s of times by now and haven't seen a familiar icon yet.

ok, someone I know has a legolas icon, so I suppose I'll count that.

ok!
the winner is moominmolly
http://www.livejournal.com/userpic/1656787
http://www.livejournal.com/allpics.bml?user=moominmolly
[User Picture]
From:pookfreak
Date:May 25th, 2002 03:16 pm (UTC)

Re: between this and the friendfriend thing, I am skipping your birthday

(Link)
Amusingly enough - on my 3rd reload I got your breasts!

Hee!
My Website Powered by LiveJournal.com