how lame that you have to try to hunt down edits :P
2007-09-22 26512, 2007
brianfreud
well, I knew there had to be a VA merge... trying to pull up VA’s edits is both suicidal and error 500, so it took some digging via advanced search to find it
hi folks. is there any machine interface (or otherwise html) for searching on URLs in an advanced relationship field? eg. find the html or xml page for the band who has a MySpace AR = http://www.myspace.com/jarvspace
2007-09-22 26559, 2007
danbri
I don't see such on the search pages...
2007-09-22 26532, 2007
kruq
why encourage them
2007-09-22 26550, 2007
kruq
i know nothing sorry shouldn't have said anything :)
2007-09-22 26511, 2007
dalen joined the channel
2007-09-22 26511, 2007
danbri
for myspace users, it's potentially a nice shorthand for identifying their favourite bands
2007-09-22 26503, 2007
Kerensky97 has left the channel
2007-09-22 26537, 2007
MrQwerty has quit
2007-09-22 26510, 2007
foolip joined the channel
2007-09-22 26514, 2007
brianfreud
danbri, not that I’m aware of
2007-09-22 26516, 2007
foolip
greetings all
2007-09-22 26523, 2007
danbri
thanks
2007-09-22 26530, 2007
danbri rummaging in the sql instead then
2007-09-22 26539, 2007
Igor_666736 has quit
2007-09-22 26539, 2007
foolip
is there a formal time limit for a RFV on MB-Style?
2007-09-22 26543, 2007
brianfreud
wouldn’t simply searching on the artist’s name be simpler?
2007-09-22 26559, 2007
brianfreud
foolip, not really, but it tends to be ~14 days, I think
2007-09-22 26508, 2007
foolip
ok
2007-09-22 26522, 2007
foolip
so I'll just keep waiting
2007-09-22 26532, 2007
danbri
not if i'm starting with a fan's myspace url, which can get me band's myspace urls ... potentially a nice tight join on IDs
2007-09-22 26542, 2007
danbri
rather than a murky string match
2007-09-22 26559, 2007
brianfreud
yes, but the myspace url we would have, if we have it, would be the band’s, not the fan’s
2007-09-22 26539, 2007
danbri
yep - i should've spelled it out ... would also using be Perl WWW::Myspace module or similar (or a web service if they ever get with the 21st century :)
2007-09-22 26555, 2007
brianfreud
:P
2007-09-22 26511, 2007
brianfreud
still sounds much easier to search on the artist’s name :D
2007-09-22 26501, 2007
brianfreud
ok all, I am finding a SERIOUS soundtrack deficiency. ADD MORE SOUNDTRACKS (and save me from having to keep adding more!) LOL
2007-09-22 26529, 2007
danbri
ok an SQL question now --- mb1=# select * from l_artist_url where link_type ='19' AND link0='170817';
i can't see where link1 gets expanded back into myspace URLs
2007-09-22 26510, 2007
danbri
ah doh, url table
2007-09-22 26515, 2007
danbri
thanks for listening ;)
2007-09-22 26542, 2007
danbri
fyi, finished product is select url from l_artist_url,url, artist where artist.id = link0 AND url.id=link1 AND link_type ='19' AND name like 'Jarvis Cocker';
