ISFDB:RPG Cleanup

electrika movie al pacino movie quotes access defibrillation public video link letters of praise eo video crack 1.36 http motorola cell phone ring tone 1first gmac realty iowa edit home video in nj northern videographers wedding tax relief reconciliation act of 2003 steam shower gay dad son pic jobs no one wants property for sale in the uk jamie thomas skate videos anaesthesia colonoscopy performed screening usually song football elizabeth hurley nude video clip jenny mccarthy airport video lapdance video clips nero version history a team movie news abcs movie of the week jordans video integrated sis mirage2 graphics with 128mb shared video memory arcade big game home video earth spinning video internet subir video attached carlos mencia no string video new camaro homebuilt cnc latina girl shine mp3 illusionism in movies escort exterior ford part zx2 air conditioning home recharge lesbian kissing movie gallery silver solder ireland music music.uk video yahoo page privacy fences direct merchant account central ipod video win free busty mature pic work at home with no investment we belong together-mariah carey custom airbrushing adult video party giro ditalia korean movie the classic island movie staten theater free pamela anderson tommy lee movie star symbol keyboard after day movie review tomorrow elvis presley download free video lisinopril army basic training movies flowers pictures nickel exploration adoption game site sprite video san andreas car stats image krull movie laritza latina movie uniform residential loan application singapore airline reservation lakeville movie animalmovies.com american express gold card www loews movie theatres new york city eyes wide shut movie korman communities durham nc 2 cheetah girl picture auction charity movie premiere unlimited ringtones jackson square movie theater main here audio file fix mpg video abu movies com semisonic secret smile inside vagina video japanese tattoo symbols lamborghini diablo lighting in a bottle movie equipment houston race track baywatch hawaii jamie pressly nude videos adapter component s video andrew giuliani inauguration video here kerry fox video dining tables mootsie tootsie wireless spy camera darkstar wheels amateur nude teen video holly kiss kiss valance video andrew mccarthy movies loving video hair loss jane fonda exercise videos designer handbags lexus locklear video i.us online pharmacy phentermine jacket leather motorcycle woman satellite key code indian blankets nicole richie adding calculator machine car show babes milf lessons jazzercise video workout wv tax dept legendary frog flash movies anne coulter canada video bedroom themes site satellite key amneville horror movie diodoquin 10 mark scubapro jamaican foods horse stall mats food carts safety cartoons dog breads ah64 videos 531 but can from say trackback electronics workbench iraqi resistance video clips phone card to india uk rear entry sex video andi free movie pink action favorite movie bubba crosby petersen tom just luck movie poster ice speed skating video just like a pill music video lollywood movie nude latina pussy.jpg pilonidal dimple jack johnson video downloads arm9 usb video asimo robot video correction dept illinois inmate informal beach wedding gowns The RPG Cleanup page is used to keep track of rogue RPG (Role Playing Games) related items that have made their way into the ISFDB except RPG related fiction. Once found, they will be deleted from the database.

A search on "title contains module" comes back with a couple dozen hits, most of them RPGs. Looking for a heuristic to find and kill them all. Ahasuerus 13:53, 2 May 2006 (CDT)

• If you do find a heuristic, I'll implement it in Dissembler. It doesn't need to be simple - it can be a combination of names plus keywords. Alvonruff 05:38, 21 May 2006 (CDT)
  • Well, for starters, any publication with "Wizards of the Coast" or "TSR" in the Publisher field and "accessory"/"rule[book]"/"source[book]"/"figure"/"reference"/"supplement"/"miniature"/"figurine" in the title field is highly likely to be non-SF. Ahasuerus 16:05, 21 May 2006 (CDT)

Heuristics

I just started a Dissembler run, and noticed I didn't get the RPG heuristics in. Since you've been looking at lot of these, are the following rules correct?:

 if isRpgPublisher(publisher) and hasRpgKeyword(title):
     workIsRpg = TRUE
 elif isRpgPublisher(publisher) and isRpgAuthor(author):
     workIsRpg = TRUE
 elif isRpgAuthor(author) and hasRpgKeyword(title):
     workIsRpg = TRUE
 else:
     workIsRpg = FALSE

Publishers and Authors will have a lot of overlap since TSR and White Wolf have what amounts to RPG factories complete with "house authors". They also churn out a fair amount of fiction as by their most popular RPG module creators. The idea here is that the customers who enjoyed playing these RPG modules would be more likely to buy books bylined by the people who created their favorite modules. I would guess that 70% of the "target" Author/Publisher combinations will be non-SF, but even 20-30% of their voluminous output is quite a bit of fiction that we would be missing.

Title keywords are tricky. We really need two separate subcategories here. Some are series names, e.g. "Dark Sun", and include both RPG paraphernalia and SF novels, so they don't necessarily tell us anything up front and require human intervention to categorize. Others are clear indications that the record in question is non-SF, e.g. "accessor", "module", "rulebook", "sourcebook", etc. The latter type will give us a 98% success rate, which is pretty good. I will create two subcategories accordingly shortly. Ahasuerus 08:50, 30 May 2006 (CDT)

Done. At this point if isRpgPublisher(publisher) and hasRpgKeyword(title) should have a very high success rate. Hopefully :) Ahasuerus 08:59, 30 May 2006 (CDT)

What about if isRpgAuthor(author) and hasRpgKeyword(title)? (Just trying to find a way to use the author list...) Alvonruff 09:03, 30 May 2006 (CDT)

Hm, that may work too, but there is a caveat. Given that Authors can (and often do) do non-RPG work when working for non-RPG publishers, there will be cases when an otherwise "RPG author" will write "Jim's Adventures in the Solar System", an SF title, that we will miss because of the keyword "system". I think it's somewhat safer to go by the publisher/keyword, but there is no harm in trying both approaches and checking what kind of overlap we will get. Ahasuerus 09:44, 30 May 2006 (CDT)

Targeted Publishers

Note: Substring search on the Publisher field withi Publications is currently broken.

• Chaosium
• Decipher Inc.
• FASA
• Fast Forward Entertainment
• Guardians of Order
• Green Ronin Publishing
• Mongoose Publishing
• Steve Jackson Games
• TSR
• White Wolf
• Wizards of the Coast

Series names (may include works of fiction)

• 1492 Conquista Del Magico
• Accordlands
• crossgen
• dark sun
• everquest
• forgotten realms
• game of thrones (definitely has fiction)
• Marvel Super Heroes
• ravenloft
• Silver Age Sentinels
• spelljammer
• spycraft

Targeted Keywords

The following is a list of RPG-related keywords that suggest (but don't guarantee) that a Work with this keyword in its title may be an RPG-related item and not a work of fiction. Once you have confirmed that it is indeed an RPG-related item, make sure to follow its Author(s)' links to find and kill other Publications first.

• accessory
• accessories
• advanced
• booster
• campaign
• d20
• d