#musicbrainz

LotR: in itself trusting your identity to a third party is something you should consider _very_ carefully.

Muzzz: bye!

warp: oh, definitely. but that goes for any such system

warp: but you *can* run your own openid server.. (which is possibly less secure, depending on how good you are at sysadmin stuff :)

LotR: but you have to trust the third party only regarding the service they provide

with openid you have to trust them much more

how do you @ SIG @ a line to claim it in the recent 'adding wiki pages to artists that dont have them' drive?

I think the whole idea of using an URL for identity is just silly

anyone know?

i did like the idea of allowing a third party to handle your data, but not having to trust them: http://www.clipperz.com/users/marco/blog/2008/0...

dankine: not sure if I understand the question :) but isn't it just @SIG@?

it says it on this page http://wiki.musicbrainz.org/MBWikipediaARs it may well just be @SIG@ but where do you put it

dankine: @SIG@ will just add your name and the current time there

so you put it where you want to put your name

dankine: when you're editting a wiki document, you can use @SIG@ anywhere in that document.

ah okay

so i edit that page and stikc sig there

thanks

@SIG@

hello peoples!

also :O http://uk.youtube.com/watch?v=KzmFMOS8Qtg

chefkoch is now known as chefkoch_AW

chefkoch is now known as chefkoch_AW

chefkoch is now known as chefkoch_AW

genghis khan :)

* warp finishes a three day game of civ4.

eh?

genghis khan! koi no dance site!

:o

was? http://www.last.fm/user/Nasasie/journal/2007/10...!

koi no dance site \o/

koi no dance site \o/

:)

chefkoch is now known as chefkoch_AW

this request password feature on the wiki sure is useful

it sent me an email without a password

Cool!

maybe my password is an empty string

I think it's probably PONIES.

ah, think maybe I used the wrong email

but then why would it send me one if it wasn't registered

Wizzcat: decrypting the password from the email /is/ the security feature

if you can decode it, you have proved your identity

Hell Yeah!

Pimp the System

do anyone know if it is possible to remove play count for some artists at last.fm?

my ex girlfriend messed up my statistics :P for example there's 5860 play count of an artist I dont even listen to

you can delete stuff from your library in the beta

ohhhhh. thank you

no worries :)

hmm only wipe the entire listening data?

no, if you go to user/niklas/library, and you hover over an artist image, an (x) icon appears. that lets you remove that artist from your library

awesome. thanks alot

finally Im getting relevant recommendations

hehe

Yes love for http://musicbrainz.org/show/edit/?editid=9057770 ?

couldn't you just change the url?

when adding a release... bonus tracks should not be suffixed (bonus track) or similar?

pbryan: you might have been running into http://bugs.musicbrainz.org/ticket/3574

niklas: ping

hello

hi

I've just noticed this in commit logs:

my $clearQuery="DELETE FROM collection_discography_artist_join WHERE collection_info=". $this->{collectionId};

please don't do this :)

oh. how should I do it?

"... WHERE collection_info = ?"

ah alright

and then pass the argument separately to $sql->Do

Im on it :)

sql injections are BAD :)

true

luks: do you have any idea why the collection webservice is VERY slow? is that normal? e.g. ace.csbnet.se/ws/1/collection?addalbums=49bc0156-912e-46ed-97f0-acc3e3122030 takes quite some seconds to load

(dont mind the output)

pbryan: http://musicbrainz.org/edit/url/edit.html?urlid... was the page you want I believe

run into that problem myself loads of times

only problem is if the asin is attached to other releases you can't really change

Wizzcat, that url didn't work for me but I can guess what it's for; I've seen that too

*guess what it shows

eh..

niklas: $sqlro->SelectSingleValue("SELECT id FROM moderator WHERE name='". $r->user ."'"); reminds me of one xkcd strip :)

in cgi-bin/MusicBrainz/Server/Handlers/WS/1/Collection.pm

hehe ok :) I've replaced the SQL queries in Collection.pm to pass values using ? instead now

really, check all your sql changes and convert them to placeholders

hehe, little bobby tables

8)

hm

niklas: well, first thing: for queries like "SELECT * FROM collection_info WHERE moderator='$userId'" you definitely need an index on collection_info.moderator

(and again sql injection :))

hmm need an index on collection_info.moderator?

I think I've created an index for it

not sure if its on moderator though

you have an index for collection_info.id

which helps you for "WHERE id = ?"

ah. how do I know which field to set index on?

but you are doing "WHERE moderator = ?", which currently scans the whole table

ah

I think I see

the fields you are querying on

Crazee_Canuck: heh yeah, the asin was just nuked

most tables in MB are huge, so you need indexes for almost any query

ok. I'll add more

also, I've found one bug

here are you getting collectionId, but if the collection id doesn't exist, you create a new one but don't get ID of the new collection

but... when I do $rosql->SelectSingleValue("SELECT id FROM album WHERE gid = '?'", $mbid); I get the error: DBD::Pg::st execute failed: called with 1 bind variables when 0 are needed at /home/mbserver/svn/mb_server/cgi-bin/Sql.pm line 378

but it works when I do "... gid = $mbid"

niklas: did I said "WHERE name = '?'" or "WHERE name = ?"?

s/name/id/

ah so ? adds single quotes around the value?

well, technically no