User:Rupert: Difference between revisions
From The Urban Dead Wiki
Jump to navigationJump to search
(→News) |
|||
| Line 12: | Line 12: | ||
No updates. Stopped playing when The Dead were around because I felt the changes to the game's search odds were a violation of the spirit of the game. Let The Dead win, Kevan, don't change the search odds in an attempt to stop them. I've been playing again lately, as zombies, and it's fun. No searching though. I've been collecting stats on zombie attack rates instead (debarricading, equipment smashing, mauling, biting). If anyone resurrects any of my alts, I'll look into the new drug store search odds. I hope the drastic reduction is true. --[[User:Rupert|Rupert]] 21:24, 16 October 2008 (BST) | No updates. Stopped playing when The Dead were around because I felt the changes to the game's search odds were a violation of the spirit of the game. Let The Dead win, Kevan, don't change the search odds in an attempt to stop them. I've been playing again lately, as zombies, and it's fun. No searching though. I've been collecting stats on zombie attack rates instead (debarricading, equipment smashing, mauling, biting). If anyone resurrects any of my alts, I'll look into the new drug store search odds. I hope the drastic reduction is true. --[[User:Rupert|Rupert]] 21:24, 16 October 2008 (BST) | ||
= Zombie Attack Odds = | = Zombie Attack Odds = | ||
Revision as of 06:25, 15 November 2008
I am a stats junkie. I wrote my own Javascript/PHP page that scrapes search results from the HTML as I play Urban Dead.
News
No updates, most of my alts are dead. --Rupert 06:37, 18 March 2008 (UTC)
Cool! Bargain Hunting doubles your odds of finding something in a mall, even if the mall is ruined! This means the best place to find first aid kits when everything is ruined is still a mall. A ruined mall beats a lit hospital. Ha! --Rupert 04:01, 20 March 2008 (UTC)
Most of my alts are now revived. I'm seeing some strange things with the odds since The Dead have trashed most of Malton. On March 24 all my alts suddenly had an obscene success rate for finding syringes. And what's with the high success rate in dark malls? --Rupert 05:48, 27 March 2008 (UTC)
I continue to find First Aid Kits at an amazing rate. --Rupert 03:08, 28 March 2008 (UTC)
No updates. Stopped playing when The Dead were around because I felt the changes to the game's search odds were a violation of the spirit of the game. Let The Dead win, Kevan, don't change the search odds in an attempt to stop them. I've been playing again lately, as zombies, and it's fun. No searching though. I've been collecting stats on zombie attack rates instead (debarricading, equipment smashing, mauling, biting). If anyone resurrects any of my alts, I'll look into the new drug store search odds. I hope the drastic reduction is true. --Rupert 21:24, 16 October 2008 (BST)
Zombie Attack Odds
Okay, okay, fine. I combined all my samples. I was shocked at how many I had, I guess I've been playing zombies for a while!
maul=6213/12114 = 51 %
bite=312/1131 = 27 %
bash=802/3181 = 25 %
equip=86/194 = 44 %
Latest
These results were collected starting Oct 14, 2008.
By Building
| building_type | cond | lights | searches | item | count | percent | AP |
|---|---|---|---|---|---|---|---|
| church | okay | dark | 59 | nothing | 46 | 77.97% | 1.28 |
| crucifix | 7 | 11.86% | 8.43 | ||||
| bottle of wine | 4 | 6.78% | 14.75 | ||||
| first-aid kit | 2 | 3.39% | 29.50 | ||||
| hospital | okay | lit | 80 | nothing | 61 | 76.25% | 1.31 |
| first-aid kit | 13 | 16.25% | 6.15 | ||||
| newspaper | 6 | 7.50% | 13.33 | ||||
| necrotech | okay | lit | 309 | nothing | 226 | 73.14% | 1.37 |
| syringe | 33 | 10.68% | 9.36 | ||||
| DNA extractor | 29 | 9.39% | 10.66 | ||||
| GPS unit | 21 | 6.80% | 14.71 | ||||
Malls
| building_type | cond | lights | bargain | searches | item | count | percent | AP |
|---|---|---|---|---|---|---|---|---|
| mall_drug_store | okay | lit | bargain | 24 | nothing | 19 | 79.17% | 1.26 |
| first-aid kit | 5 | 20.83% | 4.80 | |||||
| ruined | dark | bargain | 24 | nothing | 20 | 83.33% | 1.20 | |
| first-aid kit | 4 | 16.67% | 6.00 | |||||
Old Data
These results were collected starting Feb 17 2008.
By Building
| building_type | cond | lights | searches | item | count | percent | AP |
|---|---|---|---|---|---|---|---|
| arms | ruined | dark | 97 | nothing | 87 | 89.69% | 1.11 |
| bottle of beer | 3 | 3.09% | 32.33 | ||||
| bottle of wine | 3 | 3.09% | 32.33 | ||||
| newspaper | 3 | 3.09% | 32.33 | ||||
| mobile phone | 1 | 1.03% | 97.00 | ||||
| auto repair | okay | dark | 895 | nothing | 724 | 80.89% | 1.24 |
| spray can | 44 | 4.92% | 20.34 | ||||
| crowbar | 39 | 4.36% | 22.95 | ||||
| fuel can | 38 | 4.25% | 23.55 | ||||
| fire axe | 13 | 1.45% | 68.85 | ||||
| newspaper | 13 | 1.45% | 68.85 | ||||
| bottle of beer | 13 | 1.45% | 68.85 | ||||
| toolbox | 11 | 1.23% | 81.36 | ||||
| lit | 327 | nothing | 247 | 75.54% | 1.32 | ||
| spray can | 24 | 7.34% | 13.63 | ||||
| fuel can | 17 | 5.20% | 19.24 | ||||
| crowbar | 11 | 3.36% | 29.73 | ||||
| bottle of beer | 10 | 3.06% | 32.70 | ||||
| fire axe | 9 | 2.75% | 36.33 | ||||
| toolbox | 5 | 1.53% | 65.40 | ||||
| newspaper | 4 | 1.22% | 81.75 | ||||
| ruined | dark | 17 | nothing | 14 | 82.35% | 1.21 | |
| fuel can | 2 | 11.76% | 8.50 | ||||
| crowbar | 1 | 5.88% | 17.00 | ||||
| church | okay | dark | 735 | nothing | 596 | 81.09% | 1.23 |
| crucifix | 73 | 9.93% | 10.07 | ||||
| first-aid kit | 35 | 4.76% | 21.00 | ||||
| bottle of wine | 31 | 4.22% | 23.71 | ||||
| lit | 460 | nothing | 349 | 75.87% | 1.32 | ||
| crucifix | 45 | 9.78% | 10.22 | ||||
| first-aid kit | 40 | 8.70% | 11.50 | ||||
| bottle of wine | 26 | 5.65% | 17.69 | ||||
| ruined | dark | 41 | nothing | 39 | 95.12% | 1.05 | |
| first-aid kit | 1 | 2.44% | 41.00 | ||||
| crucifix | 1 | 2.44% | 41.00 | ||||
| factory | okay | lit | 1002 | nothing | 734 | 73.25% | 1.37 |
| length of pipe | 68 | 6.79% | 14.74 | ||||
| fuel can | 54 | 5.39% | 18.56 | ||||
| portable generator | 38 | 3.79% | 26.37 | ||||
| toolbox | 38 | 3.79% | 26.37 | ||||
| crowbar | 37 | 3.69% | 27.08 | ||||
| fire axe | 33 | 3.29% | 30.36 | ||||
| fire station | okay | dark | 359 | nothing | 285 | 79.39% | 1.26 |
| fire axe | 40 | 11.14% | 8.98 | ||||
| flare gun | 20 | 5.57% | 17.95 | ||||
| radio | 14 | 3.90% | 25.64 | ||||
| lit | 339 | nothing | 261 | 76.99% | 1.30 | ||
| fire axe | 45 | 13.27% | 7.53 | ||||
| radio | 17 | 5.01% | 19.94 | ||||
| flare gun | 16 | 4.72% | 21.19 | ||||
| hospital | okay | dark | 866 | nothing | 608 | 70.21% | 1.42 |
| first-aid kit | 184 | 21.25% | 4.71 | ||||
| newspaper | 74 | 8.55% | 11.70 | ||||
| lit | 2820 | nothing | 2145 | 76.06% | 1.31 | ||
| first-aid kit | 504 | 17.87% | 5.60 | ||||
| newspaper | 171 | 6.06% | 16.49 | ||||
| ruined | dark | 66 | nothing | 59 | 89.39% | 1.12 | |
| first-aid kit | 5 | 7.58% | 13.20 | ||||
| newspaper | 2 | 3.03% | 33.00 | ||||
| junkyard | okay | dark | 3 | nothing | 2 | 66.67% | 1.50 |
| shotgun shell | 1 | 33.33% | 3.00 | ||||
| lit | 944 | nothing | 704 | 74.58% | 1.34 | ||
| length of pipe | 38 | 4.03% | 24.84 | ||||
| fire axe | 20 | 2.12% | 47.20 | ||||
| book | 19 | 2.01% | 49.68 | ||||
| knife | 18 | 1.91% | 52.44 | ||||
| shotgun shell | 17 | 1.80% | 55.53 | ||||
| crowbar | 16 | 1.69% | 59.00 | ||||
| flak jacket | 15 | 1.59% | 62.93 | ||||
| fuel can | 15 | 1.59% | 62.93 | ||||
| mobile phone | 15 | 1.59% | 62.93 | ||||
| pistol clip | 14 | 1.48% | 67.43 | ||||
| spray can | 13 | 1.38% | 72.62 | ||||
| newspaper | 13 | 1.38% | 72.62 | ||||
| baseball bat | 8 | 0.85% | 118.00 | ||||
| pool cue | 5 | 0.53% | 188.80 | ||||
| cricket bat | 4 | 0.42% | 236.00 | ||||
| ski pole | 4 | 0.42% | 236.00 | ||||
| fencing foil | 2 | 0.21% | 472.00 | ||||
| tennis racket | 2 | 0.21% | 472.00 | ||||
| golf club | 1 | 0.11% | 944.00 | ||||
| hockey stick | 1 | 0.11% | 944.00 | ||||
| mall | okay | lit | 318 | nothing | 242 | 76.10% | 1.31 |
| spray can | 7 | 2.20% | 45.43 | ||||
| portable generator | 6 | 1.89% | 53.00 | ||||
| mobile phone | 6 | 1.89% | 53.00 | ||||
| toolbox | 5 | 1.57% | 63.60 | ||||
| first-aid kit | 5 | 1.57% | 63.60 | ||||
| newspaper | 5 | 1.57% | 63.60 | ||||
| radio transmitter | 4 | 1.26% | 79.50 | ||||
| book | 4 | 1.26% | 79.50 | ||||
| flare gun | 4 | 1.26% | 79.50 | ||||
| bottle of beer | 3 | 0.94% | 106.00 | ||||
| baseball bat | 3 | 0.94% | 106.00 | ||||
| shotgun shell | 3 | 0.94% | 106.00 | ||||
| shotgun | 3 | 0.94% | 106.00 | ||||
| pistol | 2 | 0.63% | 159.00 | ||||
| knife | 2 | 0.63% | 159.00 | ||||
| tennis racket | 2 | 0.63% | 159.00 | ||||
| golf club | 2 | 0.63% | 159.00 | ||||
| pair of binoculars | 2 | 0.63% | 159.00 | ||||
| radio | 2 | 0.63% | 159.00 | ||||
| pistol clip | 2 | 0.63% | 159.00 | ||||
| GPS unit | 1 | 0.31% | 318.00 | ||||
| fencing foil | 1 | 0.31% | 318.00 | ||||
| ski pole | 1 | 0.31% | 318.00 | ||||
| bottle of wine | 1 | 0.31% | 318.00 | ||||
| museum | okay | dark | 53 | nothing | 43 | 81.13% | 1.23 |
| European painting | 7 | 13.21% | 7.57 | ||||
| fire-damaged painting | 3 | 5.66% | 17.67 | ||||
| ransacked | dark | 90 | nothing | 80 | 88.89% | 1.13 | |
| cubist sculpture | 10 | 11.11% | 9.00 | ||||
| necrotech | okay | dark | 1252 | nothing | 919 | 73.40% | 1.36 |
| syringe | 188 | 15.02% | 6.66 | ||||
| DNA extractor | 78 | 6.23% | 16.05 | ||||
| GPS unit | 67 | 5.35% | 18.69 | ||||
| lit | 986 | nothing | 756 | 76.67% | 1.30 | ||
| syringe | 124 | 12.58% | 7.95 | ||||
| GPS unit | 57 | 5.78% | 17.30 | ||||
| DNA extractor | 49 | 4.97% | 20.12 | ||||
| ruined | dark | 371 | nothing | 339 | 91.37% | 1.09 | |
| syringe | 16 | 4.31% | 23.19 | ||||
| GPS unit | 8 | 2.16% | 46.38 | ||||
| DNA extractor | 8 | 2.16% | 46.38 | ||||
| police dept | okay | dark | 1001 | nothing | 797 | 79.62% | 1.26 |
| pistol clip | 62 | 6.19% | 16.15 | ||||
| shotgun shell | 56 | 5.59% | 17.88 | ||||
| flak jacket | 21 | 2.10% | 47.67 | ||||
| flare gun | 20 | 2.00% | 50.05 | ||||
| pistol | 18 | 1.80% | 55.61 | ||||
| shotgun | 16 | 1.60% | 62.56 | ||||
| radio | 11 | 1.10% | 91.00 | ||||
| lit | 10183 | nothing | 7688 | 75.50% | 1.32 | ||
| pistol clip | 756 | 7.42% | 13.47 | ||||
| shotgun shell | 748 | 7.35% | 13.61 | ||||
| flare gun | 209 | 2.05% | 48.72 | ||||
| pistol | 203 | 1.99% | 50.16 | ||||
| shotgun | 200 | 1.96% | 50.92 | ||||
| radio | 192 | 1.89% | 53.04 | ||||
| flak jacket | 187 | 1.84% | 54.45 | ||||
| ruined | dark | 38 | nothing | 35 | 92.11% | 1.09 | |
| shotgun shell | 1 | 2.63% | 38.00 | ||||
| pistol | 1 | 2.63% | 38.00 | ||||
| flak jacket | 1 | 2.63% | 38.00 | ||||
| school | okay | dark | 23 | nothing | 18 | 78.26% | 1.28 |
| book | 3 | 13.04% | 7.67 | ||||
| poetry book | 1 | 4.35% | 23.00 | ||||
| spray can | 1 | 4.35% | 23.00 | ||||
| lit | 691 | nothing | 526 | 76.12% | 1.31 | ||
| spray can | 74 | 10.71% | 9.34 | ||||
| book | 55 | 7.96% | 12.56 | ||||
| knife | 21 | 3.04% | 32.90 | ||||
| poetry book | 15 | 2.17% | 46.07 | ||||
| streets | - | - | 620 | nothing | 589 | 95.00% | 1.05 |
| shotgun shell | 5 | 0.81% | 124.00 | ||||
| newspaper | 5 | 0.81% | 124.00 | ||||
| pistol clip | 4 | 0.65% | 155.00 | ||||
| crowbar | 3 | 0.48% | 206.67 | ||||
| mobile phone | 3 | 0.48% | 206.67 | ||||
| baseball bat | 2 | 0.32% | 310.00 | ||||
| pistol | 2 | 0.32% | 310.00 | ||||
| book | 2 | 0.32% | 310.00 | ||||
| spray can | 1 | 0.16% | 620.00 | ||||
| flak jacket | 1 | 0.16% | 620.00 | ||||
| length of pipe | 1 | 0.16% | 620.00 | ||||
| knife | 1 | 0.16% | 620.00 | ||||
| flare gun | 1 | 0.16% | 620.00 | ||||
| warehouse | okay | dark | 550 | nothing | 435 | 79.09% | 1.26 |
| length of pipe | 48 | 8.73% | 11.46 | ||||
| fuel can | 23 | 4.18% | 23.91 | ||||
| crowbar | 23 | 4.18% | 23.91 | ||||
| fire axe | 21 | 3.82% | 26.19 | ||||
| lit | 182 | nothing | 139 | 76.37% | 1.31 | ||
| length of pipe | 20 | 10.99% | 9.10 | ||||
| crowbar | 9 | 4.95% | 20.22 | ||||
| fire axe | 7 | 3.85% | 26.00 | ||||
| fuel can | 7 | 3.85% | 26.00 | ||||
By Mall Store
| building_type | cond | lights | bargain | searches | item | count | percent | AP |
|---|---|---|---|---|---|---|---|---|
| mall_drug_store | okay | dark | bargain | 278 | first-aid kit | 189 | 67.99% | 1.47 |
| nothing | 89 | 32.01% | 3.12 | |||||
| no bargain | 104 | nothing | 68 | 65.38% | 1.53 | |||
| first-aid kit | 36 | 34.62% | 2.89 | |||||
| lit | bargain | 148 | first-aid kit | 83 | 56.08% | 1.78 | ||
| nothing | 65 | 43.92% | 2.28 | |||||
| no bargain | 83 | nothing | 64 | 77.11% | 1.30 | |||
| first-aid kit | 19 | 22.89% | 4.37 | |||||
| ruined | dark | bargain | 200 | nothing | 144 | 72.00% | 1.39 | |
| first-aid kit | 56 | 28.00% | 3.57 | |||||
| no bargain | 66 | nothing | 50 | 75.76% | 1.32 | |||
| first-aid kit | 16 | 24.24% | 4.13 | |||||
| mall_gun_store | okay | lit | bargain | 172 | nothing | 83 | 48.26% | 2.07 |
| shotgun shell | 30 | 17.44% | 5.73 | |||||
| pistol clip | 25 | 14.53% | 6.88 | |||||
| shotgun | 18 | 10.47% | 9.56 | |||||
| pistol | 16 | 9.30% | 10.75 | |||||
| no bargain | 177 | nothing | 139 | 78.53% | 1.27 | |||
| shotgun shell | 14 | 7.91% | 12.64 | |||||
| pistol clip | 10 | 5.65% | 17.70 | |||||
| shotgun | 7 | 3.95% | 25.29 | |||||
| pistol | 7 | 3.95% | 25.29 | |||||
| mall_hardware_store | okay | dark | bargain | 5 | crowbar | 1 | 20.00% | 5.00 |
| knife | 1 | 20.00% | 5.00 | |||||
| nothing | 1 | 20.00% | 5.00 | |||||
| portable generator | 1 | 20.00% | 5.00 | |||||
| toolbox | 1 | 20.00% | 5.00 | |||||
| lit | bargain | 137 | nothing | 62 | 45.26% | 2.21 | ||
| crowbar | 14 | 10.22% | 9.79 | |||||
| toolbox | 13 | 9.49% | 10.54 | |||||
| flare gun | 12 | 8.76% | 11.42 | |||||
| fire axe | 11 | 8.03% | 12.45 | |||||
| spray can | 9 | 6.57% | 15.22 | |||||
| knife | 9 | 6.57% | 15.22 | |||||
| portable generator | 7 | 5.11% | 19.57 | |||||
| no bargain | 184 | nothing | 136 | 73.91% | 1.35 | |||
| crowbar | 8 | 4.35% | 23.00 | |||||
| fire axe | 8 | 4.35% | 23.00 | |||||
| toolbox | 8 | 4.35% | 23.00 | |||||
| knife | 7 | 3.80% | 26.29 | |||||
| portable generator | 6 | 3.26% | 30.67 | |||||
| flare gun | 6 | 3.26% | 30.67 | |||||
| spray can | 5 | 2.72% | 36.80 | |||||
| ruined | dark | bargain | 46 | nothing | 31 | 67.39% | 1.48 | |
| toolbox | 4 | 8.70% | 11.50 | |||||
| spray can | 3 | 6.52% | 15.33 | |||||
| crowbar | 2 | 4.35% | 23.00 | |||||
| fire axe | 2 | 4.35% | 23.00 | |||||
| portable generator | 2 | 4.35% | 23.00 | |||||
| flare gun | 1 | 2.17% | 46.00 | |||||
| knife | 1 | 2.17% | 46.00 | |||||
| mall_sports_store | okay | lit | bargain | 138 | nothing | 82 | 59.42% | 1.68 |
| pair of binoculars | 16 | 11.59% | 8.63 | |||||
| baseball bat | 14 | 10.14% | 9.86 | |||||
| knife | 9 | 6.52% | 15.33 | |||||
| golf club | 4 | 2.90% | 34.50 | |||||
| fencing foil | 3 | 2.17% | 46.00 | |||||
| cricket bat | 3 | 2.17% | 46.00 | |||||
| pool cue | 3 | 2.17% | 46.00 | |||||
| tennis racket | 2 | 1.45% | 69.00 | |||||
| hockey stick | 2 | 1.45% | 69.00 | |||||
| no bargain | 92 | nothing | 70 | 76.09% | 1.31 | |||
| pair of binoculars | 6 | 6.52% | 15.33 | |||||
| ski pole | 4 | 4.35% | 23.00 | |||||
| pool cue | 3 | 3.26% | 30.67 | |||||
| knife | 3 | 3.26% | 30.67 | |||||
| baseball bat | 3 | 3.26% | 30.67 | |||||
| cricket bat | 1 | 1.09% | 92.00 | |||||
| hockey stick | 1 | 1.09% | 92.00 | |||||
| golf club | 1 | 1.09% | 92.00 | |||||
| mall_tech_store | okay | lit | bargain | 138 | nothing | 68 | 49.28% | 2.03 |
| mobile phone | 30 | 21.74% | 4.60 | |||||
| radio | 16 | 11.59% | 8.63 | |||||
| GPS unit | 14 | 10.14% | 9.86 | |||||
| radio transmitter | 10 | 7.25% | 13.80 | |||||
| no bargain | 92 | nothing | 67 | 72.83% | 1.37 | |||
| radio transmitter | 10 | 10.87% | 9.20 | |||||
| radio | 6 | 6.52% | 15.33 | |||||
| GPS unit | 5 | 5.43% | 18.40 | |||||
| mobile phone | 4 | 4.35% | 23.00 | |||||
By Item
| item | percent | AP | building | inside | cond | lights | shopping | bargain |
|---|---|---|---|---|---|---|---|---|
| baseball bat | 10.14% | 9.86 AP | mall_sports_store | in | okay | lit | shopping | bargain |
| 3.26% | 30.67 AP | mall_sports_store | in | okay | lit | shopping | no bargain | |
| 0.94% | 106.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| 0.85% | 118.00 AP | junkyard | in | okay | lit | - | - | |
| 0.32% | 310.00 AP | streets | out | - | - | - | - | |
| book | 13.04% | 7.67 AP | school | in | okay | dark | - | - |
| 7.96% | 12.56 AP | school | in | okay | lit | - | - | |
| 2.01% | 49.68 AP | junkyard | in | okay | lit | - | - | |
| 1.26% | 79.50 AP | mall | in | okay | lit | no shopping | no bargain | |
| 0.32% | 310.00 AP | streets | out | - | - | - | - | |
| bottle of beer | 3.09% | 32.33 AP | arms | in | ruined | dark | - | - |
| 3.06% | 32.70 AP | auto repair | in | okay | lit | - | - | |
| 1.45% | 68.85 AP | auto repair | in | okay | dark | - | - | |
| 0.94% | 106.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| bottle of wine | 5.65% | 17.69 AP | church | in | okay | lit | - | - |
| 4.22% | 23.71 AP | church | in | okay | dark | - | - | |
| 3.09% | 32.33 AP | arms | in | ruined | dark | - | - | |
| 0.31% | 318.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| cricket bat | 2.17% | 46.00 AP | mall_sports_store | in | okay | lit | shopping | bargain |
| 1.09% | 92.00 AP | mall_sports_store | in | okay | lit | shopping | no bargain | |
| 0.42% | 236.00 AP | junkyard | in | okay | lit | - | - | |
| crowbar | 20.00% | 5.00 AP | mall_hardware_store | in | okay | dark | shopping | bargain |
| 10.22% | 9.79 AP | mall_hardware_store | in | okay | lit | shopping | bargain | |
| 5.88% | 17.00 AP | auto repair | in | ruined | dark | - | - | |
| 4.95% | 20.22 AP | warehouse | in | okay | lit | - | - | |
| 4.36% | 22.95 AP | auto repair | in | okay | dark | - | - | |
| 4.35% | 23.00 AP | mall_hardware_store | in | okay | lit | shopping | no bargain | |
| 4.35% | 23.00 AP | mall_hardware_store | in | ruined | dark | shopping | bargain | |
| 4.18% | 23.91 AP | warehouse | in | okay | dark | - | - | |
| 3.69% | 27.08 AP | factory | in | okay | lit | - | - | |
| 3.36% | 29.73 AP | auto repair | in | okay | lit | - | - | |
| 1.69% | 59.00 AP | junkyard | in | okay | lit | - | - | |
| 0.48% | 206.67 AP | streets | out | - | - | - | - | |
| crucifix | 9.93% | 10.07 AP | church | in | okay | dark | - | - |
| 9.78% | 10.22 AP | church | in | okay | lit | - | - | |
| 2.44% | 41.00 AP | church | in | ruined | dark | - | - | |
| cubist sculpture | 11.11% | 9.00 AP | museum | in | ransacked | dark | - | - |
| DNA extractor | 6.23% | 16.05 AP | necrotech | in | okay | dark | - | - |
| 4.97% | 20.12 AP | necrotech | in | okay | lit | - | - | |
| 2.16% | 46.38 AP | necrotech | in | ruined | dark | - | - | |
| European painting | 13.21% | 7.57 AP | museum | in | okay | dark | - | - |
| fencing foil | 2.17% | 46.00 AP | mall_sports_store | in | okay | lit | shopping | bargain |
| 0.31% | 318.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| 0.21% | 472.00 AP | junkyard | in | okay | lit | - | - | |
| fire axe | 13.27% | 7.53 AP | fire station | in | okay | lit | - | - |
| 11.14% | 8.98 AP | fire station | in | okay | dark | - | - | |
| 8.03% | 12.45 AP | mall_hardware_store | in | okay | lit | shopping | bargain | |
| 4.35% | 23.00 AP | mall_hardware_store | in | okay | lit | shopping | no bargain | |
| 4.35% | 23.00 AP | mall_hardware_store | in | ruined | dark | shopping | bargain | |
| 3.85% | 26.00 AP | warehouse | in | okay | lit | - | - | |
| 3.82% | 26.19 AP | warehouse | in | okay | dark | - | - | |
| 3.29% | 30.36 AP | factory | in | okay | lit | - | - | |
| 2.75% | 36.33 AP | auto repair | in | okay | lit | - | - | |
| 2.12% | 47.20 AP | junkyard | in | okay | lit | - | - | |
| 1.45% | 68.85 AP | auto repair | in | okay | dark | - | - | |
| fire-damaged painting | 5.66% | 17.67 AP | museum | in | okay | dark | - | - |
| first-aid kit | 67.99% | 1.47 AP | mall_drug_store | in | okay | dark | shopping | bargain |
| 56.08% | 1.78 AP | mall_drug_store | in | okay | lit | shopping | bargain | |
| 34.62% | 2.89 AP | mall_drug_store | in | okay | dark | shopping | no bargain | |
| 28.00% | 3.57 AP | mall_drug_store | in | ruined | dark | shopping | bargain | |
| 24.24% | 4.13 AP | mall_drug_store | in | ruined | dark | shopping | no bargain | |
| 22.89% | 4.37 AP | mall_drug_store | in | okay | lit | shopping | no bargain | |
| 21.25% | 4.71 AP | hospital | in | okay | dark | - | - | |
| 17.87% | 5.60 AP | hospital | in | okay | lit | - | - | |
| 8.70% | 11.50 AP | church | in | okay | lit | - | - | |
| 7.58% | 13.20 AP | hospital | in | ruined | dark | - | - | |
| 4.76% | 21.00 AP | church | in | okay | dark | - | - | |
| 2.44% | 41.00 AP | church | in | ruined | dark | - | - | |
| 1.57% | 63.60 AP | mall | in | okay | lit | no shopping | no bargain | |
| flak jacket | 2.63% | 38.00 AP | police dept | in | ruined | dark | - | - |
| 2.10% | 47.67 AP | police dept | in | okay | dark | - | - | |
| 1.84% | 54.45 AP | police dept | in | okay | lit | - | - | |
| 1.59% | 62.93 AP | junkyard | in | okay | lit | - | - | |
| 0.16% | 620.00 AP | streets | out | - | - | - | - | |
| flare gun | 8.76% | 11.42 AP | mall_hardware_store | in | okay | lit | shopping | bargain |
| 5.57% | 17.95 AP | fire station | in | okay | dark | - | - | |
| 4.72% | 21.19 AP | fire station | in | okay | lit | - | - | |
| 3.26% | 30.67 AP | mall_hardware_store | in | okay | lit | shopping | no bargain | |
| 2.17% | 46.00 AP | mall_hardware_store | in | ruined | dark | shopping | bargain | |
| 2.05% | 48.72 AP | police dept | in | okay | lit | - | - | |
| 2.00% | 50.05 AP | police dept | in | okay | dark | - | - | |
| 1.26% | 79.50 AP | mall | in | okay | lit | no shopping | no bargain | |
| 0.16% | 620.00 AP | streets | out | - | - | - | - | |
| fuel can | 11.76% | 8.50 AP | auto repair | in | ruined | dark | - | - |
| 5.39% | 18.56 AP | factory | in | okay | lit | - | - | |
| 5.20% | 19.24 AP | auto repair | in | okay | lit | - | - | |
| 4.25% | 23.55 AP | auto repair | in | okay | dark | - | - | |
| 4.18% | 23.91 AP | warehouse | in | okay | dark | - | - | |
| 3.85% | 26.00 AP | warehouse | in | okay | lit | - | - | |
| 1.59% | 62.93 AP | junkyard | in | okay | lit | - | - | |
| golf club | 2.90% | 34.50 AP | mall_sports_store | in | okay | lit | shopping | bargain |
| 1.09% | 92.00 AP | mall_sports_store | in | okay | lit | shopping | no bargain | |
| 0.63% | 159.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| 0.11% | 944.00 AP | junkyard | in | okay | lit | - | - | |
| GPS unit | 10.14% | 9.86 AP | mall_tech_store | in | okay | lit | shopping | bargain |
| 5.78% | 17.30 AP | necrotech | in | okay | lit | - | - | |
| 5.43% | 18.40 AP | mall_tech_store | in | okay | lit | shopping | no bargain | |
| 5.35% | 18.69 AP | necrotech | in | okay | dark | - | - | |
| 2.16% | 46.38 AP | necrotech | in | ruined | dark | - | - | |
| 0.31% | 318.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| hockey stick | 1.45% | 69.00 AP | mall_sports_store | in | okay | lit | shopping | bargain |
| 1.09% | 92.00 AP | mall_sports_store | in | okay | lit | shopping | no bargain | |
| 0.11% | 944.00 AP | junkyard | in | okay | lit | - | - | |
| knife | 20.00% | 5.00 AP | mall_hardware_store | in | okay | dark | shopping | bargain |
| 6.57% | 15.22 AP | mall_hardware_store | in | okay | lit | shopping | bargain | |
| 6.52% | 15.33 AP | mall_sports_store | in | okay | lit | shopping | bargain | |
| 3.80% | 26.29 AP | mall_hardware_store | in | okay | lit | shopping | no bargain | |
| 3.26% | 30.67 AP | mall_sports_store | in | okay | lit | shopping | no bargain | |
| 3.04% | 32.90 AP | school | in | okay | lit | - | - | |
| 2.17% | 46.00 AP | mall_hardware_store | in | ruined | dark | shopping | bargain | |
| 1.91% | 52.44 AP | junkyard | in | okay | lit | - | - | |
| 0.63% | 159.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| 0.16% | 620.00 AP | streets | out | - | - | - | - | |
| length of pipe | 10.99% | 9.10 AP | warehouse | in | okay | lit | - | - |
| 8.73% | 11.46 AP | warehouse | in | okay | dark | - | - | |
| 6.79% | 14.74 AP | factory | in | okay | lit | - | - | |
| 4.03% | 24.84 AP | junkyard | in | okay | lit | - | - | |
| 0.16% | 620.00 AP | streets | out | - | - | - | - | |
| mobile phone | 21.74% | 4.60 AP | mall_tech_store | in | okay | lit | shopping | bargain |
| 4.35% | 23.00 AP | mall_tech_store | in | okay | lit | shopping | no bargain | |
| 1.89% | 53.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| 1.59% | 62.93 AP | junkyard | in | okay | lit | - | - | |
| 1.03% | 97.00 AP | arms | in | ruined | dark | - | - | |
| 0.48% | 206.67 AP | streets | out | - | - | - | - | |
| newspaper | 8.55% | 11.70 AP | hospital | in | okay | dark | - | - |
| 6.06% | 16.49 AP | hospital | in | okay | lit | - | - | |
| 3.09% | 32.33 AP | arms | in | ruined | dark | - | - | |
| 3.03% | 33.00 AP | hospital | in | ruined | dark | - | - | |
| 1.57% | 63.60 AP | mall | in | okay | lit | no shopping | no bargain | |
| 1.45% | 68.85 AP | auto repair | in | okay | dark | - | - | |
| 1.38% | 72.62 AP | junkyard | in | okay | lit | - | - | |
| 1.22% | 81.75 AP | auto repair | in | okay | lit | - | - | |
| 0.81% | 124.00 AP | streets | out | - | - | - | - | |
| nothing | 95.12% | 1.05 AP | church | in | ruined | dark | - | - |
| 95.00% | 1.05 AP | streets | out | - | - | - | - | |
| 92.11% | 1.09 AP | police dept | in | ruined | dark | - | - | |
| 91.37% | 1.09 AP | necrotech | in | ruined | dark | - | - | |
| 89.69% | 1.11 AP | arms | in | ruined | dark | - | - | |
| 89.39% | 1.12 AP | hospital | in | ruined | dark | - | - | |
| 88.89% | 1.13 AP | museum | in | ransacked | dark | - | - | |
| 82.35% | 1.21 AP | auto repair | in | ruined | dark | - | - | |
| 81.13% | 1.23 AP | museum | in | okay | dark | - | - | |
| 81.09% | 1.23 AP | church | in | okay | dark | - | - | |
| 80.89% | 1.24 AP | auto repair | in | okay | dark | - | - | |
| 79.62% | 1.26 AP | police dept | in | okay | dark | - | - | |
| 79.39% | 1.26 AP | fire station | in | okay | dark | - | - | |
| 79.09% | 1.26 AP | warehouse | in | okay | dark | - | - | |
| 78.53% | 1.27 AP | mall_gun_store | in | okay | lit | shopping | no bargain | |
| 78.26% | 1.28 AP | school | in | okay | dark | - | - | |
| 77.11% | 1.30 AP | mall_drug_store | in | okay | lit | shopping | no bargain | |
| 76.99% | 1.30 AP | fire station | in | okay | lit | - | - | |
| 76.67% | 1.30 AP | necrotech | in | okay | lit | - | - | |
| 76.37% | 1.31 AP | warehouse | in | okay | lit | - | - | |
| 76.12% | 1.31 AP | school | in | okay | lit | - | - | |
| 76.10% | 1.31 AP | mall | in | okay | lit | no shopping | no bargain | |
| 76.09% | 1.31 AP | mall_sports_store | in | okay | lit | shopping | no bargain | |
| 76.06% | 1.31 AP | hospital | in | okay | lit | - | - | |
| 75.87% | 1.32 AP | church | in | okay | lit | - | - | |
| 75.76% | 1.32 AP | mall_drug_store | in | ruined | dark | shopping | no bargain | |
| 75.54% | 1.32 AP | auto repair | in | okay | lit | - | - | |
| 75.50% | 1.32 AP | police dept | in | okay | lit | - | - | |
| 74.58% | 1.34 AP | junkyard | in | okay | lit | - | - | |
| 73.91% | 1.35 AP | mall_hardware_store | in | okay | lit | shopping | no bargain | |
| 73.40% | 1.36 AP | necrotech | in | okay | dark | - | - | |
| 73.25% | 1.37 AP | factory | in | okay | lit | - | - | |
| 72.83% | 1.37 AP | mall_tech_store | in | okay | lit | shopping | no bargain | |
| 72.00% | 1.39 AP | mall_drug_store | in | ruined | dark | shopping | bargain | |
| 70.21% | 1.42 AP | hospital | in | okay | dark | - | - | |
| 67.39% | 1.48 AP | mall_hardware_store | in | ruined | dark | shopping | bargain | |
| 66.67% | 1.50 AP | junkyard | in | okay | dark | - | - | |
| 65.38% | 1.53 AP | mall_drug_store | in | okay | dark | shopping | no bargain | |
| 59.42% | 1.68 AP | mall_sports_store | in | okay | lit | shopping | bargain | |
| 49.28% | 2.03 AP | mall_tech_store | in | okay | lit | shopping | bargain | |
| 48.26% | 2.07 AP | mall_gun_store | in | okay | lit | shopping | bargain | |
| 45.26% | 2.21 AP | mall_hardware_store | in | okay | lit | shopping | bargain | |
| 43.92% | 2.28 AP | mall_drug_store | in | okay | lit | shopping | bargain | |
| 32.01% | 3.12 AP | mall_drug_store | in | okay | dark | shopping | bargain | |
| 20.00% | 5.00 AP | mall_hardware_store | in | okay | dark | shopping | bargain | |
| pair of binoculars | 11.59% | 8.63 AP | mall_sports_store | in | okay | lit | shopping | bargain |
| 6.52% | 15.33 AP | mall_sports_store | in | okay | lit | shopping | no bargain | |
| 0.63% | 159.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| pistol | 9.30% | 10.75 AP | mall_gun_store | in | okay | lit | shopping | bargain |
| 3.95% | 25.29 AP | mall_gun_store | in | okay | lit | shopping | no bargain | |
| 2.63% | 38.00 AP | police dept | in | ruined | dark | - | - | |
| 1.99% | 50.16 AP | police dept | in | okay | lit | - | - | |
| 1.80% | 55.61 AP | police dept | in | okay | dark | - | - | |
| 0.63% | 159.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| 0.32% | 310.00 AP | streets | out | - | - | - | - | |
| pistol clip | 14.53% | 6.88 AP | mall_gun_store | in | okay | lit | shopping | bargain |
| 7.42% | 13.47 AP | police dept | in | okay | lit | - | - | |
| 6.19% | 16.15 AP | police dept | in | okay | dark | - | - | |
| 5.65% | 17.70 AP | mall_gun_store | in | okay | lit | shopping | no bargain | |
| 1.48% | 67.43 AP | junkyard | in | okay | lit | - | - | |
| 0.65% | 155.00 AP | streets | out | - | - | - | - | |
| 0.63% | 159.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| poetry book | 4.35% | 23.00 AP | school | in | okay | dark | - | - |
| 2.17% | 46.07 AP | school | in | okay | lit | - | - | |
| pool cue | 3.26% | 30.67 AP | mall_sports_store | in | okay | lit | shopping | no bargain |
| 2.17% | 46.00 AP | mall_sports_store | in | okay | lit | shopping | bargain | |
| 0.53% | 188.80 AP | junkyard | in | okay | lit | - | - | |
| portable generator | 20.00% | 5.00 AP | mall_hardware_store | in | okay | dark | shopping | bargain |
| 5.11% | 19.57 AP | mall_hardware_store | in | okay | lit | shopping | bargain | |
| 4.35% | 23.00 AP | mall_hardware_store | in | ruined | dark | shopping | bargain | |
| 3.79% | 26.37 AP | factory | in | okay | lit | - | - | |
| 3.26% | 30.67 AP | mall_hardware_store | in | okay | lit | shopping | no bargain | |
| 1.89% | 53.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| radio | 11.59% | 8.63 AP | mall_tech_store | in | okay | lit | shopping | bargain |
| 6.52% | 15.33 AP | mall_tech_store | in | okay | lit | shopping | no bargain | |
| 5.01% | 19.94 AP | fire station | in | okay | lit | - | - | |
| 3.90% | 25.64 AP | fire station | in | okay | dark | - | - | |
| 1.89% | 53.04 AP | police dept | in | okay | lit | - | - | |
| 1.10% | 91.00 AP | police dept | in | okay | dark | - | - | |
| 0.63% | 159.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| radio transmitter | 10.87% | 9.20 AP | mall_tech_store | in | okay | lit | shopping | no bargain |
| 7.25% | 13.80 AP | mall_tech_store | in | okay | lit | shopping | bargain | |
| 1.26% | 79.50 AP | mall | in | okay | lit | no shopping | no bargain | |
| shotgun | 10.47% | 9.56 AP | mall_gun_store | in | okay | lit | shopping | bargain |
| 3.95% | 25.29 AP | mall_gun_store | in | okay | lit | shopping | no bargain | |
| 1.96% | 50.92 AP | police dept | in | okay | lit | - | - | |
| 1.60% | 62.56 AP | police dept | in | okay | dark | - | - | |
| 0.94% | 106.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| shotgun shell | 33.33% | 3.00 AP | junkyard | in | okay | dark | - | - |
| 17.44% | 5.73 AP | mall_gun_store | in | okay | lit | shopping | bargain | |
| 7.91% | 12.64 AP | mall_gun_store | in | okay | lit | shopping | no bargain | |
| 7.35% | 13.61 AP | police dept | in | okay | lit | - | - | |
| 5.59% | 17.88 AP | police dept | in | okay | dark | - | - | |
| 2.63% | 38.00 AP | police dept | in | ruined | dark | - | - | |
| 1.80% | 55.53 AP | junkyard | in | okay | lit | - | - | |
| 0.94% | 106.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| 0.81% | 124.00 AP | streets | out | - | - | - | - | |
| ski pole | 4.35% | 23.00 AP | mall_sports_store | in | okay | lit | shopping | no bargain |
| 0.42% | 236.00 AP | junkyard | in | okay | lit | - | - | |
| 0.31% | 318.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| spray can | 10.71% | 9.34 AP | school | in | okay | lit | - | - |
| 7.34% | 13.63 AP | auto repair | in | okay | lit | - | - | |
| 6.57% | 15.22 AP | mall_hardware_store | in | okay | lit | shopping | bargain | |
| 6.52% | 15.33 AP | mall_hardware_store | in | ruined | dark | shopping | bargain | |
| 4.92% | 20.34 AP | auto repair | in | okay | dark | - | - | |
| 4.35% | 23.00 AP | school | in | okay | dark | - | - | |
| 2.72% | 36.80 AP | mall_hardware_store | in | okay | lit | shopping | no bargain | |
| 2.20% | 45.43 AP | mall | in | okay | lit | no shopping | no bargain | |
| 1.38% | 72.62 AP | junkyard | in | okay | lit | - | - | |
| 0.16% | 620.00 AP | streets | out | - | - | - | - | |
| syringe | 15.02% | 6.66 AP | necrotech | in | okay | dark | - | - |
| 12.58% | 7.95 AP | necrotech | in | okay | lit | - | - | |
| 4.31% | 23.19 AP | necrotech | in | ruined | dark | - | - | |
| tennis racket | 1.45% | 69.00 AP | mall_sports_store | in | okay | lit | shopping | bargain |
| 0.63% | 159.00 AP | mall | in | okay | lit | no shopping | no bargain | |
| 0.21% | 472.00 AP | junkyard | in | okay | lit | - | - | |
| toolbox | 20.00% | 5.00 AP | mall_hardware_store | in | okay | dark | shopping | bargain |
| 9.49% | 10.54 AP | mall_hardware_store | in | okay | lit | shopping | bargain | |
| 8.70% | 11.50 AP | mall_hardware_store | in | ruined | dark | shopping | bargain | |
| 4.35% | 23.00 AP | mall_hardware_store | in | okay | lit | shopping | no bargain | |
| 3.79% | 26.37 AP | factory | in | okay | lit | - | - | |
| 1.57% | 63.60 AP | mall | in | okay | lit | no shopping | no bargain | |
| 1.53% | 65.40 AP | auto repair | in | okay | lit | - | - | |
| 1.23% | 81.36 AP | auto repair | in | okay | dark | - | - |
Ammo
+------------+----------+ | item_found | count(*) | +------------+----------+ | pistol(0) | 34 | | pistol(1) | 40 | | pistol(2) | 15 | | pistol(3) | 38 | | pistol(4) | 43 | | pistol(5) | 31 | | pistol(6) | 18 | +------------+----------+ | shotgun(0) | 80 | | shotgun(1) | 63 | | shotgun(2) | 67 | +------------+----------+
--Rupert 17:25, 9 March 2008 (UTC)
Building Condition
Here are the odds so far of finding something versus nothing using the data that I have and assuming that all buildings in the same condition have the same odds.
+--------+-----------+--------+---------+----------+-----------+-------+---------+ | inside | cond | lights | bargain | searches | result | count | percent | +--------+-----------+--------+---------+----------+-----------+-------+---------+ | in | okay | dark | bargain | 283 | something | 193 | 68.20 | | in | okay | lit | bargain | 733 | something | 373 | 50.89 | | in | ruined | dark | bargain | 246 | something | 71 | 28.86 | | in | okay | lit | - | 18880 | something | 4613 | 24.43 | | in | okay | dark | - | 5841 | something | 1346 | 23.04 | | in | ransacked | dark | - | 90 | something | 10 | 11.11 | | in | ruined | dark | - | 696 | something | 73 | 10.49 | | out | - | - | - | 620 | something | 31 | 5.00 | +--------+-----------+--------+---------+----------+-----------+-------+---------+
Searching a dark mall with Bargain Hunting has a ridiculously high success rate. Is that a bug in Urban Dead? Is that a bug in my code? I don't think it's a bug in my code because I double checked the rows in the database with my character's inventory and they match exactly. I searched a dark drug store 40 times and found 28 first aid kits.
--Rupert 03:03, 28 March 2008 (UTC)
Methods
I play every page of Urban Dead through a Javascript page on my home computer that I coded up using the Prototype Javascript library (awesome) that uses AJAX HttpRequests to a php proxy (super awesome). That's because Javascript can't contact urbandead.com directly due to the security sandbox, but it can contact php on the same machine and php can contact any website it wishes, so it's more of a two-level proxy, sometimes three. I can then over-analyze the HTML with Javascript till my heart's content, extracting all sorts of information, as well as auto-searching (a fire-and-forget time saver). Javascript is surprisingly good at this and fun to program.
Each search result scraped by Javascript is sent via another AJAX request to a similar php page that stores the data in a MySQL table with these columns:
+--------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------------------+------+-----+---------+-------+ | name | char(25) | NO | | | | | date | date | YES | | NULL | | | building_name | char(40) | NO | | | | | building_type | char(20) | NO | | | | | inside | tinyint(3) unsigned | NO | | | | | building_condition | char(10) | NO | | | | | building_light | tinyint(3) unsigned | NO | | | | | has_shopping | tinyint(3) unsigned | NO | | | | | has_bargain | tinyint(3) unsigned | NO | | | | | item_found | char(40) | NO | | | | | has_necro | tinyint(3) unsigned | NO | | 0 | | | has_necro_lab | tinyint(3) unsigned | NO | | 0 | | +--------------------+---------------------+------+-----+---------+-------+
When I'm done playing, I run a SQL script that copies that data into a temporary table, transforming all items named "pistol(*)" to just "pistol" because I don't care about the odds of pistol ammo right now, same for "shotgun(*)". Then I transform "NecroTech syringe" and "revivification syringe" into just "syringe", "rusty knife" and "pocket knife" and "hunting knife" into just "knife". Then I count identical rows. This condenses the table from thousands of rows (one per search) to only hundreds, at which point it looks like this:
+-------------+----+-----------+-------+----------+---------+-------+-----+----------------+-------+ | building | in | condition | light | shopping | bargain | necro | lab | item | count | +-------------+----+-----------+-------+----------+---------+-------+-----+----------------+-------+ | auto repair | 1 | okay | 1 | 0 | 0 | 1 | 1 | bottle of beer | 2 | | auto repair | 1 | okay | 1 | 0 | 0 | 1 | 1 | crowbar | 1 | | auto repair | 1 | okay | 1 | 0 | 0 | 1 | 1 | fire axe | 1 | | auto repair | 1 | okay | 1 | 0 | 0 | 1 | 1 | fuel can | 4 | | auto repair | 1 | okay | 1 | 0 | 0 | 1 | 1 | nothing | 34 | | auto repair | 1 | okay | 1 | 0 | 0 | 1 | 1 | spray can | 3 | | auto repair | 1 | okay | 1 | 1 | 0 | 0 | 0 | bottle of beer | 1 | | auto repair | 1 | okay | 1 | 1 | 0 | 0 | 0 | crowbar | 3 | | auto repair | 1 | okay | 1 | 1 | 0 | 0 | 0 | fire axe | 1 | | auto repair | 1 | okay | 1 | 1 | 0 | 0 | 0 | fuel can | 2 | +-------------+----+-----------+-------+----------+---------+-------+-----+----------------+-------+
Then the script builds up a second temporary table populated by three queries on the first temp table:
- all non-mall and non-necrotech rows grouped by building type, light, and item
- all malls and mall substores further grouped by has_shopping and has_bargain
- all necrotechs grouped by the same as (1) but also by has_necro and has_lab (because the odds appear to be different)
Then I order the table by building and condition to get the "By Building" table, and by item for the "By Item" table. Then I execute a php page to get the html tables to paste into this lovely wiki.
