ISFDB:RPG Cleanup

ming sia supposed former infatuation junkie anais nin peabody hotel live web cam web animale donna sesso video the wedding singer cast asteroids movies relieving constipation disneyland ticket atl movie release date deck trellis links massage chair ebony free gallery gay movie shower curtain rods exploding head cushman motor scooter kodaly gay asian wwf lita pc pocket theme barnes n noble earth quake movie 10.5 lactating porn videos japanese nurse sex movie and movie gods and rock stars but lady in waiting middle ages greatland tents free personal firewall win xp freezes on startup swimsuits atp synthase movies anna falchi gallery humorist ward animation latest movie magic mountain resort sitemap alien predator movie compressor oil another man movie x king solomons mines 2004 movie review acne treatment jesse james custom bike skateboarding bails video clips intermission movies loaded gun movie index impossible mission movie review care skin american amitriptyline pain clip embrace vampire video aflac video commercials mixed submission wrestling xsao custom texas barbecue pit kennedy tool boxes archive movie petite teenager live mtv2 video ass hole licking john goodman movies here links yasmin personal bank checks seed.net cucumber sea sites best gaming laptop jons movies.com porsche abortion procedure videos goofy movie music trucks for sale clay animation movie discount future broker attacking animal video sharp.com career 2000 lexus 300 bait bucket effects making movie special office depot oscillating fan repair member mark nativity set famous naked people picture robert warren musser anchorage alaska asian chick let the love begin movie pics domain website download free ringtones ju on movie spoiler simalex fados irish pub bar code labeling software harpy eagle amplifier audio line maps israel inside out movie gas scooter part elecard mpeg 2 video old red tech depot coupon monstersofcock emerald forrest movie perforator interview jones king larry star video jihad videos used pa systems japan movie nude bag paper shopping wholesale air jordan mobile phone prepaid virgin leave it to beaver movie lord of the flies movie review on-line marketing services shahrukh khan upcoming movie just lyric ordinary song akihabara cyber in music team video ashlee simpson video pictures krups ice cream maker online seafood store minnesota refinance mortgage loans elizabethtown in ky movie theater latin petite pussy promotional business items anchorman movie script write data solution psp movies latch trophy wife pics motorola phone v180 usb driver internet security video suitcases jism movie download accessory boat carver edonkey movie download picks disease total eclipse of the heart air supply online black jack game 3gp download free nokia player window xp wedding songs lindsay lohan over video cast ohio revised code its hard to kiss video live internet movies one two step ciara includes joker one poker video m d gourmet coffee franchise ming sia supposed former infatuation junkie anais nin peabody hotel live web cam web animale donna sesso video the wedding singer cast asteroids movies relieving constipation disneyland ticket atl movie release date deck trellis links massage chair ebony free gallery gay movie shower curtain rods exploding head cushman motor scooter kodaly gay asian wwf lita pc pocket theme barnes n noble earth quake movie 10.5 lactating porn videos japanese nurse sex movie and movie gods and rock stars but lady in waiting middle ages greatland tents free personal firewall win xp freezes on startup swimsuits atp synthase movies anna falchi gallery humorist ward animation latest movie magic mountain resort sitemap alien predator movie compressor oil another man movie x king solomons mines 2004 movie review acne treatment jesse james custom bike skateboarding bails video clips intermission movies loaded gun movie index impossible mission movie review care skin american amitriptyline pain clip embrace vampire video aflac video commercials mixed submission wrestling xsao custom texas barbecue pit kennedy tool boxes archive movie petite teenager live mtv2 video ass hole licking john goodman movies here links yasmin personal bank checks seed.net cucumber sea sites best gaming laptop jons movies.com porsche abortion procedure videos goofy movie music trucks for sale clay animation movie discount future broker attacking animal video sharp.com career 2000 lexus 300 bait bucket effects making movie special office depot oscillating fan repair member mark nativity set famous naked people picture robert warren musser anchorage alaska asian chick let the love begin movie pics domain website download free ringtones ju on movie spoiler simalex fados irish pub bar code labeling software harpy eagle amplifier audio line maps israel inside out movie gas scooter part elecard mpeg 2 video old red tech depot coupon monstersofcock emerald forrest movie perforator interview jones king larry star video jihad videos used pa systems japan movie nude bag paper shopping wholesale air jordan mobile phone prepaid virgin leave it to beaver movie lord of the flies movie review on-line marketing services shahrukh khan upcoming movie just lyric ordinary song akihabara cyber in music team video ashlee simpson video pictures krups ice cream maker online seafood store minnesota refinance mortgage loans elizabethtown in ky movie theater latin petite pussy promotional business items anchorman movie script write data solution psp movies latch trophy wife pics motorola phone v180 usb driver internet security video suitcases jism movie download accessory boat carver edonkey movie download picks disease total eclipse of the heart air supply online black jack game 3gp download free nokia player window xp wedding songs lindsay lohan over video cast ohio revised code its hard to kiss video live internet movies one two step ciara includes joker one poker video m d gourmet coffee franchise 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