#musicbrainz

or other bodily parts

>_>

female bodily parts, maybe

perhaps

i'm thinking something similar to the msn messenger icon, as a blackened out silhouette

Jugdish: I'd like that.

:)

brianfreud: re inappropriate tags... I think we'll burn that bridge when we get there.

s/bridge/editor/

;p;

Well, one thing I don't see - and I admit, I've not looked hard for it - is a "remove tag" option

good point, that is not obvious.

go to tag and empty the box and hit submit.

perhaps it oughtn't to be... so long as there is one, so we can clean out such tags if they are added

programmers UI!

I'm thinking more like "Nazi", etc - something that could be just blanently intended as offensive, rather than just disagreeable

You mean, like Muz_likes_this?

"nazi" for the hitler listing would be appropriate, but "Nazi" say on the Churchill listing

Moose?

* FauxFaux wonders if lastfm has a "had sex to" tag.

No, but I can make it

No. Joke.

Awesome. Just awesome.

Well, that killed the channel

brianfreud: is this more clear?

it's a little confusing still, to me - it's not clear if by entering a blank form I clear all tags, or only my own

"To clear your tags"

what would you suggest I do to make that more clear?

but I get it - and it looks, then, like there would be no way for me to remove "mipe" is it were something offensive, say, "memberofNAMBLA"

*s/is/if

that's correct. :)

well, let's say I personally had tagged it "food" and "love". If I wanted to add a third tag, would I need to enter "food love great" in the blank to avoid clearing the old two tags when adding "great", or would I just have to enter "great" to add it?

or is it only a completely empty form that removes tags?

doesn't the fact that your old tags get loaded give you enough of a clue?

(comma separated tags I hope)

ah, ok, I see what you mean

just kind of, for me, non-intuitive

I can see that.

fortunately its a nice system once you clue in.

also, what is a "word characters"?

getting people clued in right away will be the challenge.

alpha numberic.

-b

suggestion for a better word?

do you really have to say that?

"alpha numeric characters"?

just say any character except commas

or except commas, periods and...

Letters and numbers.

faux ftw!

"Letters, numbers and spaces" (I push for comma separated tags ;) )

gioele: did you even read the link?

Anyone who gets "word characters" has done /far/ too much perl. :p

only thing I don't like about "alpha numeric" is it implies that 青木麻由子 wouldn't be valid, and it is

FauxFaux: you can't do too much Perl

ruaok: yes, but often implementors slip on what the specs say ;)

I guess the question more is, what characters are *not* valid?

ok, everyone read what it says now!

LotR: My implication was that everyone who gets it has seen at least some perl, which is, by definition, far too much. :P

I think it's clear enough now - the rest can be figured out when people have questions

\ö/

thx everyone.

ok, perl is done :)

the import you mean?

yup

starting apache now

ruaok: I'm not getting my confirmation email. Is mailinator.com blocked?

not my mail config is borked.

no

pmesg my the mail you're trying to confirm

cool :) http://brianfreud.no-ip.biz up and running

though artist mbids don't seem to actually be found...

any sql experts in the house? i need some help on a left join.

[silence]

IS NULL is not the same as = NULL

grr. I keep forgetting that.

hmmm, I'm not getting my own verification email :D

select m.name, mp.name, mp.value from moderator as m left join moderator_preference as mp on m.id = mp.moderator where mp.name is null or (mp.name = 'tags_public' and mp.value = '1');

is what I wanted.

brianfreud: your email isn't setup either I see. :)

you mean apart from providing it during registration?

Nooo!

FauxFaux smelled an open relay?

umm, ok - what command starts that?

apt-get install exim4

but I've always had issues with that.

hmmm, "exim4 is already the latest version"

*s/newest/latest

case in point. :0

lol, have to find it kind of funny that I can't verify myself to myself

cd admin

./psql READWRITE

select id from moderator.

s/./l/g

;

feh.

update moderator set email='foo [at bar.com]', emailconfirmdate = now() where id = <id from listing>;

log out and back in.

\q

to get back to the shell

ok, did that, now it doesn't like my password

redo the first select and double check your password

select * from moderator where id = <rowid>;

it just takes me back to a psql prompt when I try that

musicbrainz_db->

You need to put ; at the end

Otherwise it won't execute

oh, I see

that's why the email thing failed too

thanks

np

np

I may be drunk

But I can do stuff!

Muzzz: we haven't done this in nearly 7 years, but still:

ruaok: !

Omg

I know someone that would LOVE that

I could dig out old problem sets

Hahh

«Every time you compile the program and it fails to compile without errors or warnings: one drink»

«fails to compile without errors»

und der groschen fällt

:-)

-s

I must be asleep... how can a program fail to compile *without* errors or warnings?

dude, the guy who wrote that was drunk. (me)

hmm, ok, it won't let me log in via the web - I've even tried manually resetting the password in the terminal, and I can see that it is correctly updated in the terminal...

do you expect to not have errors? :-)

brianfreud: cd admin

./SetSequences.pl