wiki plz

Use this forum for title suggestions, bitching at moderators, whining about phpBB, and grand ideas that will solve all of Song Fight's problems.
User avatar
roymond
Beat It
Posts: 5188
Joined: Sat Sep 25, 2004 3:42 pm
Instruments: Guitars, Bass, Vocals, Logic
Recording Method: Logic X, MacBookPro, Focusrite Scarlett 2i2
Submitting as: roymond, Dangerous Croutons, Intentionally Left Bank, Moody Vermin
Pronouns: he/him
Location: brooklyn
Contact:

Re: wiki plz

Post by roymond »

Oh crap. This looks useful. Now we have to go back and edit all the bad things said about the project :)

Nice job!
roymond.com | songfights | covers
"Any more chromaticism and you'll have to change your last name to Wagner!" - Frankie Big Face
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: wiki plz

Post by Manhattan Glutton »

You're cool, Roy. You convinced me to just go do it.

But I have to go vandalize Jon's page now. :twisted:

just kidding
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: wiki plz

Post by fluffy »

So is there a mechanism for producing a collection of related artists under a single meta-artist? Sockpuppet only began a few years ago but I've been entering under a lot of different band names since pretty much the beginning of SongFight. If there's going to be so much obsessive information collected in one spot it had might as well tell the whole story.

Ideally ithere could be pages for individual fighters which list their bands and automatically get the graph showing all of their entries, with both the title and the band name or something.
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: wiki plz

Post by Manhattan Glutton »

Draft a proposal that won't ruin my life.
I already aliased artists, so I wouldn't mind... just doing that and re-importing your stats. But it sounds like you want something more special.

You might just have to create a new page and combine the stuff yourself and make the links. ;)

Another alternative I was mulling was to put the data points in a template so that the above would be more convenient.
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: wiki plz

Post by fluffy »

Yeah, this is a bit different than aliasing. The different band names we're a reflection of diffent phases in my musical philosohy and shouldn't simply be combined together under a single roof. Also it would be helpful for tracking collabs and spinoff groups and whatever. Not to mention how for a while I was in octothoroe but i shouldn't be listed as being a part of all their songs.

Maybe having a "fighter" page where people can just list their entries (title and band name), perhaps with the role they played as well. It doesnt really need to have the graph anyway. Frankly I think that's kind of goofy and doesn't really scale well for pee who have had lots and lots of entries.

Oh and then if the band pages could auto-link back to the fighters that list them under a "participants" section (which maybe lists the titles they participated in or something).

I could do a manual mockup of this on a couple of my collabs when i get home.
Last edited by fluffy on Tue Jul 05, 2011 8:41 am, edited 1 time in total.
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: wiki plz

Post by Manhattan Glutton »

I like the timeline. It just needs a little work to look better.

I like knowing who went on a hiatus.

It sounds like what you want can't be a system change, so I'll defer to The Power Of Collaborative Editing to solve this problem.
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: wiki plz

Post by fluffy »

Maybe if time were on the vertical axis it would work better.
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: wiki plz

Post by fluffy »

Oh, what happens if someone edits a page and then you re-import? Or is the auto-imported data store in a clearly-delineated part of the entry source? I havent looked at your page markup yet.
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: wiki plz

Post by Manhattan Glutton »

http://sfbase.net/wiki/index.php?title= ... ction=edit

Feel free to grab the source and play with it on your User:fluffy page until it looks good. ;)
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: wiki plz

Post by Manhattan Glutton »

fluffy wrote:Oh, what happens if someone edits a page and then you re-import? Or is the auto-imported data store in a clearly-delineated part of the entry source?
Kind of. I haven't worked it all out in my head yet.

I was thinking of intelligently automating adding fight data and leaving the rest - it's mostly delineated easily (for now).

I don't think another full-blown (description/location/image) artist import is necessary. Anyone who submits data to fightmaster can also edit the wiki.
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: wiki plz

Post by Manhattan Glutton »

For your meta-artist inquiry, I think the proper course of action may be to just create a page with your Real Name and add to it what you want.
I plan on making "Mike Kasianowicz" some day and listing all of my endeavors.

You'll notice the artist pages all have (artist) appended to them, and all the default pages redirect to them, but if your real name conflicts, you can take it over. (Obviously, this comment is directed at Fluffy. His mother was a hippie.)

We're all famous on our own wiki.
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
HeuristicsInc
Beat It
Posts: 5297
Joined: Sat Sep 25, 2004 6:14 pm
Instruments: Synths
Recording Method: Windows computer, Acid, Synths etc.
Submitting as: Heuristics Inc. (duh) + collabs
Pronouns: he/him
Location: Maryland USA
Contact:

Re: wiki plz

Post by HeuristicsInc »

Manhattan Glutton wrote:because you have to fix all the mean things people wrote about you.
i guess you're right. my work web filter says it has Potentially Damaging Content.
-bill
152612141617123326211316121416172329292119162316331829382412351416132117152332252921
http://heuristicsinc.com
Liner Notes
SF Lyric Ideas
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: wiki plz

Post by Manhattan Glutton »

I guess it's all those penis photos I put up.

On a serious note, is there anything I can do to help it get unblocked (besides take the penises off)?
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: wiki plz

Post by fluffy »

Don't worry about HeuristicsInc's work filter. It blocks EVERYTHING.
User avatar
king_arthur
Ice Cream Man
Posts: 1752
Joined: Sun Sep 26, 2004 6:56 am
Instruments: guitar, vocals, bass, BIAB, keyboards (synth anything)
Recording Method: Tascam DP-24SD
Submitting as: King Arthur
Pronouns: he/him
Location: Phoenix, AZ
Contact:

Re: wiki plz

Post by king_arthur »

I added some notes to one of my song entries:

http://sfbase.net/wiki/Hello_My_Old_Hea ... ur_song%29

I'm actually going to be going through the KA catalog and making notes for my own purposes, so this is a cool excuse to work on that at the same time. I guess I'll assume that this stuff could all get wiped out at any moment and keep copies for myself.

What's your file upload disk space situation like? Would you be willing to consider letting artists upload a few songs that they did for SF but didn't submit (not ready in time, didn't like it at the time, etc.?)

Oh, yeah - if I go to my "King Arthur With Pictuers" page (the one that has all the links to entries) and add some content of my own, is that going to get wiped out when you update for the next fight? If there are certain pages that are going to be automatically updated, it might be nice to put a little note at the top, "this page is created automatically, please do not add updates here." Or make it uneditable by members or something.

Charles (KA)
"...one does not write in dactylic hexameter purely by accident..." - poetic designs
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: wiki plz

Post by Manhattan Glutton »

Supposedly I have "unlimited" space, so go hog wild. The only thing I ask is that you keep things organized and explicit. Long article names, long file names. Pretty much wikipedia rules.

I don't plan on going anywhere, but I'll make data exports available.
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
king_arthur
Ice Cream Man
Posts: 1752
Joined: Sun Sep 26, 2004 6:56 am
Instruments: guitar, vocals, bass, BIAB, keyboards (synth anything)
Recording Method: Tascam DP-24SD
Submitting as: King Arthur
Pronouns: he/him
Location: Phoenix, AZ
Contact:

Re: wiki plz

Post by king_arthur »

Okay, you may have to do something to allow us to upload .mp3 files, I think right now it only allows .gif and .jpg and a couple other image formats.

The scanned in song original pages I added I just uploaded as HMOH-1.jpg and HMOH-2.jpg. I guess I should have done king_arthur_HOMH-1.jpg or something? Do all the images wind up in a common pool or are my images kept separate from everyone else's? I can prefix anything I upload with "king_arthur_" if that helps...

Charles (KA)
"...one does not write in dactylic hexameter purely by accident..." - poetic designs
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: wiki plz

Post by Manhattan Glutton »

Yeah, they all end up in a common pool, unfortunately, so we all need to play nice. :) I'll look into the MP3 thing.
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: wiki plz

Post by fluffy »

I think the biggest possible issue right now with what I want to do is terminology; right now all of the bands are called "artists" (I realize that's the case in the SF archive itself too) but really it seems like we should have "artists" being individual people and "bands" being the groups of one or more artists.

Or maybe we can keep it how it is (to be consistent with the site) and have individuals be called "participants" or "members" or something.

So for example, in my situation I (fluffy) am a participant who has entered as or been a part of songs by (as a partial list)
  • fluffy porcupine
  • Sockpuppet
  • entropic pincushion
  • Frontalittle Squad
  • Octothorpe
  • So<kpupp3t
and so on. It seems like there would be a lot of space to add structured data into a database that would allow all sorts of useful pivoting. For example, with this quasi-schema:

// stuff about artists/bands
BAND - name, website, bio, picture
PARTICIPANT - name, website, bio, picture
BAND_MEMBER - BAND_id, PARTICIPANT_id, date_from, date_to // for non-guest members of the band

// stuff about entries
FIGHT - name, date_from, date_to, result_blurb
FIGHT_ENTRY - FIGHT_id, BAND_id, vote_count, winner_flag

// stuff about individual contributions to entries
ENTRY_PARTICIPANT - FIGHT_ENTRY_id, PARTICIPANT_id, role

It seems like that sort of structured data is what we really want for an informational archive, and if we could embed that into the wiki (via custom plugins or the like), all the better.
User avatar
JonPorobil
Beat It
Posts: 5682
Joined: Sat Sep 25, 2004 11:45 am
Instruments: Piano, Guitar, Harmonica, Mandolin, Accordion, Bass, lots of VSTs
Recording Method: Cubase 10.5
Submitting as: Jon Eric, Jon Porobil, others
Pronouns: He/Him
Location: Pittsburgh, PA
Contact:

Re: wiki plz

Post by JonPorobil »

fluffy wrote:I think the biggest possible issue right now with what I want to do is terminology; right now all of the bands are called "artists" (I realize that's the case in the SF archive itself too) but really it seems like we should have "artists" being individual people and "bands" being the groups of one or more artists.

Or maybe we can keep it how it is (to be consistent with the site) and have individuals be called "participants" or "members" or something.
This is a purely semantic issue that plagues any music sorting system. Most systems that store a whole bunch of people who make music are going to require one catch-all table name for all the entered data points. If you say "artists" it will misleadingly imply that there are no bands; if you say "bands" it will misleadingly imply that there are no solo artists. You could cop out and use terms such as "entrants" or "participants," but these sound too clinical. It's up to the taste of whoever designs the database, pretty much.

Beyond that you can set up different search keys specificall for solo artists and individual members of bands (no bands), and another for bands (no individual artists or members), for ease of reference.
"Warren Zevon would be proud." -Reve Mosquito

Stages, an album of about dealing with loss, anxiety, and grieving a difficult year, now available on Bandcamp and all streaming platforms! https://jonporobil.bandcamp.com/album/stages
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: wiki plz

Post by fluffy »

Ooh, thought of another table that would be useful for normalization/pivoting:

BAND_ALTER_EGO - BAND_id, other_BAND_id

(This entire schema so far is just intended for people who know how normalized databases work. I could make some examples though.)
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: wiki plz

Post by fluffy »

No listing for <3? Not even in the individual fight pages? :(
Post Reply