P3

From VITAL Lab Public Wiki

Jump to: navigation, search

  • The Ohio University P3 team won a Honorable Mention from the 2008 U.S. EPA P3 competition.
  • The Ohio University P3 team won the Best Virtual World Award from GRID.
  • Two project posters

Contents

A National Student Design Competition for Sustainability Focusing on People, Prosperity, & the Planet (P3)

Overview

Ohio University students will design video game to increase public awareness of everyday chemical exposures. Modeled off gaming technology, the computer simulation will bring players into virtual contact with various chemicals and in the process educate them about exposure.

Team Members

Chemical Exposure Awareness Game (Virtual P3)

Theme

Chemicals have been abused in the more and more industrialized world. While the initial intention of applying a chemical sounds harmless, the consequence might turn out to be harmful to human health or the environment. The objectives of the game is to

a. demonstrate the positive and negative impacts of chemicals through the example of zebra mussel control;

b. educate the public on chemical exposure in their daily life;

c. provide information on how to reduce chemical exposure by choosing a different life style.

Initial Schematic of Environmental Monopoly Game

1. Six locations (corresponding to squares in the real monopoly game) on each side, twenty locations totally.

2. Each side includes: two properties (same color), one utility, one chance or community chest.

3. Corner locations are: Go, Jail, Park, and Go to Jail.

4. Utilities include: a conventional electricity company, a green electricity company, a conventional water treatment plant, and a green water treatment plant. Conventional utilities cost less to buy but their rent is lower; green utilities cost more to buy but their rent is higher.

5. Players who own the two properties of same color can start building houses. There are two types of houses available: conventional houses, and green houses (that use renewable energy, etc). Similarly, conventional houses cost less to buy but their rent is lower; green houses cost more to buy but their rent is higher.

6. Players who have built three houses can start building stores/markets. Similarly, stores or markets can be either conventional or green. A green market means it provides natural, healthy, and organic products. Conventional markets cost less to buy but their rent is lower; green markets cost more to buy but their rent is higher.

Game island design 2D.JPG


Property Name Color Sale Price Rent Building Cost
Basic w/ house w/ eco house w/ market w/ eco shop house market eco house eco shop
Mountain View Ave. Green $200 $40 $200 $600 $1320 $1800 $200 $300 $600 $700
Willow Run Ave. Green $190 $38 $190 $570 $1254 $1710 $200 $300 $600 $700
Ocean Breeze Ave. Red $150 $30 $150 $450 $990 $1350 $150 $250 $450 $550
Peach Ridge Ave. Red $140 $28 $140 $420 $924 $1260 $150 $250 $450 $550
Palm Tree Ave. Blue $100 $20 $100 $300 $660 $900 $100 $200 $300 $400
Sunshine Valley Ave. Blue $90 $18 $90 $270 $594 $810 $100 $200 $300 $400
Cloud Gate Ave. Yellow $50 $10 $50 $150 $330 $450 $50 $150 $150 $250
Snow Creek Ave. Yellow $40 $8 $40 $120 $264 $360 $50 $150 $150 $250
Coal-fired Power Plant - $125 $25 - - - - - - - -
Wind Power Plant - $250 $50 - - - - - - - -
Water Treatment Plant - $125 $25 - - - - - - - -
Zebra Mussel Treatment Facility - $250 $50 - - - - - - - -

Equipment

1. A pair of six-sided dice.

2. A 3-D game island with 20 locations, including 8 streets divided into 4 color groups, 6 plants/facilities, 1 Chance Card, and 1 Community Chest.

3. 16 houses and 6 shops.

4. A tile deed for each property, which specifies purchase price, mortgage value, the cost of building houses and markets, and the various rent prices depending on how developed the property is.

5. A deck of 16 Chance cards and a deck of 16 Community Chest cards.

Game Rules

1. Each player begins the game at “GO” and is given $1000.

2. Before the game, each player in turn throws the dice. The player with the highest total starts the play.

3. Once the game begins, each player will be automatically transported to the location corresponding to the points on the dice he or she has just thrown.

4. If a player rolls doubles, he or she will roll again after completing the turn. If a player throws doubles three time in a row, he or she must be transported to jail.

5. Whenever a player lands on an unowned property he or she may buy that property at its printed price. The player receives the title deed showing ownership.

6. If a player lands on a property owned by another player and unmortgaged, he or she must pay the owner the required rent. If the property is mortgaged, no rent can be collected.

7. When a player owns both the properties in a color-group, he or she may construct houses on those properties and pay the required price. Construction must be uniform across a monopoly, which means a second house cannot be built on one property until the other property in the monopoly has one.

8. When a player has three houses on each property of a complete color-group, he or she may build a market on the property, pay the required price, and return the three houses. Only one market may be constructed on any one property.

9. All buildings must be sold before a property can be mortgaged. The player receives money for each mortgaged property, which must be repaid with interest to unmortgaged. No rent can be collected on mortgaged properties or utilities, but rent can be collected on unmortgaged properties in the same color-group.

10. The player who mortgages property retains ownership of it. However, he or she may sell the mortgaged property to another player at any agreed price.


Property Description

1. Mountain View Ave.

Zebra mussel population here is zero around here, which means there is no need for chemical control facilities and hence no environmental impacts posed by these facilities. This property is close to a wind power plant, which produces little environmental impact compared to conventional power plant.

2. Willow Run Ave.

Zebra mussel population here is very small around here, which means there is no need for chemical control facilities and hence no environmental impacts posed by these facilities. This property is next to a wind power plant, which produces little environmental impact compared to conventional power plant. However, leaking lubricating oil or hydraulic fluid may contaminate the surrounding area, in some cases contaminating drinking water.

3. Ocean Breeze Ave.

Zebra mussel population here is small around here, which means there is no need for chemical control facilities and hence no environmental impacts posed by these facilities. This is close to a coal-fired power plant, which causes air pollution from particulate emission, radioactive contamination from radiation output of naturally-occurring radioactive isotopes in coal such as uranium, and mercury contamination from the release of mercury existing in coal.

4. Peach Ridge Ave.

Zebra mussel population here is small around here, which means there is no need for chemical control facilities and hence no environmental impacts posed by these facilities. This is next to a coal-fired power plant, which causes air pollution from particulate emission, radioactive contamination from radiation output of naturally-occurring radioactive isotopes in coal such as uranium, and mercury contamination from the release of mercury existing in coal.

5. Palm Tree Ave.

Zebra mussel population here is large around here, and therefore a chemical control facility nearby is needed. The disadvantage of chemical control is that, chemicals (mostly chlorine) that kill zebra mussels are also toxic to most aquatic species and harmful to the environment. However, a water treatment plant can be used to reduce the negative impact of the zebra mussel facility.

6. Sunshine Valley Ave.

Zebra mussel population here is large around here, and therefore a chemical control facility nearby is needed. The disadvantage of chemical control is that, chemicals (mostly chlorine) that kill zebra mussels are also toxic to most aquatic species and harmful to the environment. However, a water treatment plant can be used to reduce the negative impact of the zebra mussel facility.

7. Cloud Gate Ave.

Zebra mussel population here is very large around here, . Therefore there is a chemical control facility nearby and chemicals are heavily applied. The disadvantage of chemical control is that, chemicals (mostly chlorine) that kill zebra mussels are also toxic to most aquatic species and harmful to the environment. However, a water treatment plant can be used to reduce the negative impact of the zebra mussel facility.

8. Snow Creek Ave.

Zebra mussel population here is very large around here. Therefore there is a chemical control facility nearby and chemicals are heavily applied. The disadvantage of chemical control is that, chemicals (mostly chlorine) that kill zebra mussels are also toxic to most aquatic species and harmful to the environment. However, a water treatment plant can be used to reduce the negative impact of the zebra mussel facility.

9. Coal-fired Power Plant

This power plant potentially causes air pollution from particulate emission, radioactive contamination from radiation output of naturally-occurring radioactive isotopes in coal such as uranium, and mercury contamination from the release of mercury existing in coal.

10. Wind Power Plant

This power plant has little potential of environmental pollution except for leaking lubricating oil or hydraulic fluid of the turbine which may contaminate the surrounding area, in some cases contaminating drinking water.

11. Water Treatment Plant

Chlorination is the main disinfection method used in this facility. Chlorine is a strong oxidant that can rapidly kill many harmful micro-organisms. However, it reacts with natural organic compounds in the water and forms potentially harmful chemical by-products trihalomethanes (THMs) and haloacetic acids (HAAs), both of which are carcinogenic in large quantities.

12. Zebra Mussel Control Facility

Chlorine is the main chemical used in this facility to control zebra mussel population. Chlorine released from the facility is also toxic to most aquatic species and harmful to the environment.

13. Eco Houses

Eco houses are built and furnished with natural nontoxic materials, such as

Chance Cards

1. Which chemical in tap water should you be specifically concerned about when you are exposed to it during showers? (b)

a. Fluorine b. Chlorine c. Lead d. Mercury

Follow-up Info

Your skin readily absorbs chlorine, a possible carcinogen, when you shower. The chlorine levels in most tap water can be so high that your exposure during a shower may equal as much as drinking 2 liters of chlorinated water, particularly because warm water open your pores and increase absorption. Chlorine in shower water can strip protein from hair and skin, causing irritated eyes, dry skin, and dandruff. Additionally, your lungs absorb toxic fumes from gaseous chlorine products that are released in a steamy shower.

A filter on the shower faucet head can significantly remove chlorine and its byproduct from shower water.

Information Source:

Archer, John. "The Water You Drink: How Safe Is It?" Pure Water Press, 1996.

Weisel, C.P. & Chen, W.J. (1994). "Exposure to chlorination byproducts from hot water uses." Risk Analysis, 14(1): 101-106.

Weisel, C.P. & Jo, W.K. (1996). "Ingestion, inhalation, and dermal exposures to chloroform and trichloroethane from tap water." Environmental Health Perspectives. 104(1): 48-51.


2. What is the common carcinogen found in pressure-treated wooden outdoor fixtures? (a)

a. Arsenic b. Lead c. PBDEs (flame retardant) d. Chlorine

Follow-up Info

Approximately 90 percent of industrial arsenic in the US is currently used as a wood preservative in the form of CCA. CCA (Chromated Copper Arsenate) is a chemical mixture consisting of three pesticidal compounds (arsenic, chromium, and copper) registered for wood preservative uses. Arsenic is a known human carcinogen. Human exposure to arsenic has been linked to cancer of the bladder, lungs, skin, kidneys, nasal passages, liver and prostate.

Treated wood should never be burned in open fires, stoves, or fireplaces. Wash hands thoroughly after contact with any wood, especially prior to eating or drinking. Alternatives to CCA-treated wood includes: wood using safe preservatives, untreated wood (cedar and redwood), and nonwood alternatives. In 2002 EPA announced a voluntary decision by industry to move away from consumer use of CCA treated lumber by December 31, 2003, in favor of new alternative wood preservatives.

Information source:

http://www.epa.gov/oppad001/reregistration/cca/cca_qa.htm

http://www.epa.gov/oppad001/reregistration/cca/cca_transition.htm#sense

http://www.epa.gov/safewater/arsenic/basicinformation.html


3. Which of following is the most common cause of lead contamination in drinking water? (c)

a. From malfunctioning water treatment facilities b. From by-products of water treatment process c. Via old pipes d. Via old faucets

Follow-up info

Lead is commonly used in household plumbing materials and water service lines. Although the greatest exposure to lead is swallowing or breathing in lead paint chips and dust, lead can also enter tap water through corrosion of plumbing materials. Homes built before 1986 are more likely to have lead pipes, fixtures, and solder. If you live in an older house, you may have lead in your water, either from the old pipes themselves or from the lead solder that was used on pipes in the past.

Lead exposure can result in delayed physical and mental development in children, along with slight deficits in attention span and learning abilities. In adults, it can cause high blood pressure and kidney problems. Installing a home water-filtration system may be effective to minimize lead exposure from tap water.

Information source:

http://www.epa.gov/safewater/lead/


4. Why do “fragrance-free” items among commercial cleaning products may have lower toxicity in general? (c)

a. Because “fragrance-free” means less ingredients. b. Because fragrance itself is toxic. c. Because fragrance is usually used to mask the smell of harsh chemicals. d. Because “fragrance-free” means “natural”.

Follow-up Info

Americans each use an average of 25 gallons of hazardous chemical products per year, most of which are in household cleaning products. These chemicals can lead to headaches, skin rashes, eye irritation, coughing, and wheezing, among other health issues. Fragrance itself can be a potential allergen to many people.

Cleaning products are not required to list ingredients. An easy way to detect a toxic product is to use your sense of smell. If a cleaner has a strong odor, it may be releasing toxins. If it has fragrance, the fragrance is there to mask the chemical smell. Products without fragrance are less likely to be toxic.

Choose all-natural, biodegradable or fragrance-free cleaning products. If you want a fragrance, use an essential oil instead.

Information source:

http://www.epa.gov/garbage/hhw-list.htm


5. Which contaminant found in drinking water is mainly from rocket fuel manufacturing? (d)

a. Perfluorinated compounds

b. Radon

c. Phthalates

d. Perchlorate

Follow-up info

Perchlorate is both a naturally occurring and man-made chemical. Most of the perchlorate manufactured in the US is used as the major ingredient of solid rocket propellant. Wastes from the manufacture and improper disposal of perchlorate-containing chemicals are increasingly being discovered in soil and water. As of September 2004, environmental perchlorate contamination had been reported in 35 states. It is estimated that more than 11 million people have perchlorate in their public drinking water supplies at levels of at least 4 parts per billion.

Ingestion of sufficient amounts of perchlorate from contaminated food or water may interfere with the production of thyroid hormones because perchlorate can compete with the uptake of iodine into thyroid gland, and iodide is a necessary component of thyroid hormones.

Filtration systems using reverse osmosis method can effectively remove perchlorate. Some grocery stores or markets supply filtered water that is treated by these systems.

Information sources:

http://www.epa.gov/safewater/ccl/perchlorate/perchlorate.html

http://www.epa.gov/iris/subst/1007.htm

Committee to Assess the Health Implications of Perchlorate Ingestion, National Research Council (2005). Health Implications of Perchlorate Ingestion. The National Academies Press.


6. What is currently the #1 source of dioxins and dioxin-like compounds in the US? (b)

a. Municipal waste combustion

b. Backyard waste combustion

c. Diesel heavy duty trucks

d. Coal-fired Utility boilers

Follow-up Info

Dioxin is a group of super-toxic chemicals, the chlorinated dioxins and furans, formed as a by-product of the manufacture or burning of organic chemicals and plastics that contain chlorine. It is one of the most toxic and environmentally stable pollutants. Short-term dioxin exposure can cause liver damage, weight loss, and compromised immunity; long-term exposure has the potential to cause cancer and various reproductive effects from reduced fertility to birth defects.

Burning of residential wastes in backyard burn barrels emerged as the largest source of dioxin emissions to the US environment.

Information source:

http://cfpub.epa.gov/ncea/cfm/recordisplay.cfm?deid=159286

Community Chest

1. You support local organic farmers by often shopping at farmers market. Collect $20.

Follow-up Info:

Organic agriculture is an ecological production management system that promotes and enhances biodiversity, biological cycles and soil biological activity. It is based on minimal use of off-farm inputs and on management practices that restore, maintain, and enhance ecological harmony. “Organically grown” food is food grown and processed using no synthetic fertilizers, pesticides, herbicides, or antibiotics.

As a consumer the direct benefit of buying organic produce is a maximum consumption of nutrition resulted from healthy soils, and a minimal exposure to synthetic agrochemicals that are associated with health consequences. By supporting organic farming we are also protecting our environment and habitats of other species.

Information source:

http://www.nal.usda.gov/afsic/pubs/ofp/ofp.shtml

http://www.ota.com/organic/benefits.html


2. You use organophosphate pesticides for your home garden and the residues contaminate a nearby creek. Pay $300.

Follow-up Information:

Pesticides are designed to kill pests and can also pose risks to people. The health effects of pesticides depend on the type of pesticide. Some of them, such as the organophosphates, affect the nervous system, while others can be carcinogens or endocrine disruptors. Excessive use of pesticides can destroy the health of ecosystem as well.

Pesticides are not the only solution to control pests. The most effective strategy for controlling pests may be to combine methods in an approach known as Integrated pest Management that emphasizes preventing pest damage and minimizes the possible hazard to people, property, and the environment.

Information source:

http://www.epa.gov/pesticides/health/human.htm

http://www.epa.gov/pesticides/controlling/garden.htm


3. You have opened a restaurant serving organic and vegetarian food to local community. Collect $100.

Follow-up Info:

Organic agriculture is an ecological production management system that promotes and enhances biodiversity, biological cycles and soil biological activity. It is based on minimal use of off-farm inputs and on management practices that restore, maintain, and enhance ecological harmony. “Organically grown” food is food grown and processed using no synthetic fertilizers, pesticides, herbicides, or antibiotics.

As a consumer the direct benefit of buying organic produce is a maximum consumption of nutrition resulted from healthy soils, and a minimal exposure to synthetic agrochemicals that are associated with health consequences. By supporting organic farming we are also protecting our environment and habitats of other species.

Information source:

http://www.nal.usda.gov/afsic/pubs/ofp/ofp.shtml

http://www.ota.com/organic/benefits.html


4. You dispose leftover transmission fluid with regular garbage. Pay $50.

Follow-up Info:

Leftover household products that contain corrosive, toxic, ignitable, or reactive ingredients are considered to be household hazardous wastes, which include paints, cleaners, oils, batteries, and pesticides. Improper disposal of household hazardous wastes can include pouring them down the drain or on the ground, or disposing them with regular garbage. The improper disposal of these wastes can pollute the environment and pose a threat to human health.

To avoid the potential risks associated with household hazardous wastes, it is important to use, store, and dispose related products with special care. Many communities in the US offer a variety of options for safely handling household hazardous wastes as well.

Information source:

http://www.epa.gov/garbage/hhw-list.htm

http://www.epa.gov/garbage/hhw.htm


5. You have bought a sippy cup made of #7 plastic for your 2-year old niece. Pay $20.

Follow-up Info:

No.7 plastics are polycarbonate plastics used for making products such as refillable beverage containers, protective linings in food cans, and plastic dinnerware. Bisphenol A (BPA) is one of the components that can leach from polycarbonate plastics. In laboratory animal testing, BPA have been shown to have hormone-like effects on the reproductive system. At high doses, BPA has estrogen-like effects on the uterus and prostate glands of experimental animals.

In 2007, the Centers for Disease Control and Prevention published results of its analyses of urine samples obtained from 2,517 people, which showed BPA was detected in 93% of the people tested and children had the highest levels. Scientists continue to debate whether effects could possibly occur in people who are exposed to BPA. However, since infants and children are most vulnerable, they should not be using plastic products containing BPA. #1, 2, and 5 plastics are safer to use. Never heat plastic products.

Information source:

http://www.cdc.gov/exposurereport/pdf/factsheet_bisphenol.pdf


6. You accidentally break it when you dispose a fluorescent bulb. Pay $20.

Follow-up Info:

Fluorescent lights are super efficient compared to incandescent bulbs. However, they have to be disposed properly once they burn out because they contain mercury. Every time a fluorescent bulb is tossed into the regular trash, a small amount of mercury is released into the environment. And the amount can add up fast. Once being released into the environment, mercury will cycle through water, air, and soil, and be consumed by and stored in fat tissues of living organisms including human beings.

Always search for recycling programs available in your community. Certain recycling systems can capture up to 99% of the mercury in fluorescent bulbs and the mercury can be reused in new bulbs. Other types of light bulbs, such as neon, mercury vapor, high pressure sodium, and metal halide lamps, can also contain mercury, lead, and cadmium.

Information source:

http://yosemite.epa.gov/opa/admpress.nsf/d0cf6618525a9efb85257359003fb69d/424069fb632d6bb58525742d005c5ec0!OpenDocument


7. You always watch out for mercury and other contaminants in the seafood and make the best choice for your family. Collect $20.

Follow-up Info:

Seafood can play an important role in a balanced diet and is generally a healthy choice. However, in some cases we can risk exposure to harmful levels of toxins when certain types of seafood are eaten frequently. These toxins include methylmercury, PCB, and dioxins. Studies have found that, in adults, exposure to mercury can lead to memory loss, tremors, and other problems. Exposure to dioxins and PCBs can lead to higher risks for cancer. But the most vulnerable populations are children and women who are pregnant or are planning to get pregnant.

Be aware of the importance of buying seafood from healthy and sustainable sources. Use certain programs, such as Seafood Watch, to help with seafood choice.

Information source:

www.mbayaq.org/cr/seafoodwatch.asp

http://www.mbayaq.org/cr/cr_seafoodwatch/download.asp


8. You choose natural instead of phthalates-containing body care products for your family. Collect $20.

9. You use cleaning products that contain harsh chemicals for household cleaning. Pay $30.

10. You have stopped your sister from using a nail polish that contains formaldehyde. Collect $20.

Follow-up Info:

The main toxic ingredients used in most conventional nail polishes are phthalates, toluene, and formaldehyde. Short-term exposure to formaldehyde can cause allergy-like symptoms, such as watery eyes and skin rashes, and respiratory problems. Long-term exposure has been linked to a rare form of nasopharyngeal cancer and may also be linked to cancer of the nose and throat in human.

Always choose natural, non-toxic cosmetic products. (Remember absorption through skin is also an important route of chemical exposure.)

Information Source:

http://www.checnet.org/HealtheHouse/chemicals/chemicals-detail-print.asp?Main_ID=346

http://www.cpsc.gov/cpscpub/pubs/725.html


11. You have bought a radon home testing kit because you are very concerned about the radon level in your house. Collect $30.

Follow-up Info:

Radon is a naturally occurring radioactive gas found in soils, rocks, and water throughout the US. Radon causes lung cancer, and is a threat to health because it tends to collect in homes, schools, and office buildings, sometimes to very high concentration. It is the largest source of exposure to naturally occurring radiation. EPA estimates that about 1 in 15 homes nationwide have levels at or above the level at which EPA recommends taking action to reduce concentrations (4 pCi/l).

The best way of assess exposure to radon is by measuring concentration of radon in the indoor air. There are several proven methods to reduce radon in your home, but the one primarily used is a vent pipe system and fan, which pulls radon from beneath the house and vents it to the outside.

Information source:

http://www.epa.gov/radon/pubs/citguide.html#lower

http://www.epa.gov/radiation/radionuclides/radon.html#contact


12. You cook meals in a non-stick pan. Pay $20.

Follow-up Info:

Non-stick cookware is made from fluoropolymers that use PFOA (Perfluorooctanoic Acid) as a processing aid. PFOA is sometimes called “C8”, and does not occur naturally in the environment. It is very persistent in the environment and also appears to remain in human body for a long time.

Because human health effects are unknown, more research is needed to understand how PFOA affect human health. However, animal studies show that PFOA can cause tumors, damage to the liver and other organs, and developmental and reproductive effects. According to a study of the Centers for Disease Control and Prevention in 2007, PFOA was detected in 98% of the target population, which confirmed widespread PFOA exposure in the US.

US EPA has announced an initiative to phase out 95% of the uses of PFOA by 2010 and entirely by 2015. If you prefer non-stick cookware, never use them at high temperature (greater than 350F).

Information source:

http://www.cdc.gov/exposurereport/pdf/factsheet_pfc.pdf

http://www.epa.gov/oppt/pfoa/pubs/pfoarisk.pdf

http://www.cancer.ca/ccs/internet/standard/0,3182,3172_1295614293__langId-en,00.html


13. Instead of buying a natural jute rug suggested by your partner, you furnish your house with a synthetic carpet that contains high-level PBDEs. Pay $20.

Follow-up Info

PBDEs are a class of toxic chemicals in wide use as flame retardants. They can be found in many products in homes, from carpets, beds, to foam pillows or television screen. PBDEs are persistent in the environment and bioaccumulate in the food chain. Although their impacts on human health are not fully researched, rodent studies have suggested that low-level exposure to PBDEs during the neonatal period may adversely affect behavior, learning, and memory. There is also evidence that these chemicals may cause liver toxicity and thyroid toxicity.

The form of PBDEs most commonly used in foam furniture was withdrawn from the US market in 2005. Newly manufactured mattresses, couches, and foam pillows do not likely contain PBDEs. However, the form of PBDEs used in computer and television monitors, as well as other electronic products, is not subject to any use restrictions.

Information resource

http://www.epa.gov/oppt/pbde/pubs/qanda.htm

http://www.epa.gov/oppt/pbde/

http://www.epa.gov/oppt/pbde/pubs/proj-plan32906a.pdf


14. You use a vacuum with a HEPA(High Efficiency Particulate Arresting) filter to clean carpets. Collect $20.

Objects needed for the game

  • Wind power plant
  • Coal power plant
  • Water treatment plant
  • Eco houses
  • Regular houses
  • Eco shops
  • Regular shops
  • Plastic baby bottles

Database design

For the synchronization purpose, some tables are needed for the data sharing between clients. The tables are divided into two types: permanent and temporary.

Permanent tables contain the data that will be kept even the game server is restart or shutdown.

Temporary tables only keep data that needed in the process of game. When the game is finished, the tables will be clear.

Permanent tables

Table name: Property_Info_Table

Table description: This table is used to store the data of all properties, i.e. the objects on the island or the objects that will be created on the island, including land, house, store, plant, etc.

Column Name Column Type Comments
UUID VARCHAR Primary key of this table, Property's UUID
Name VARCHAR Property's name
Type TINYINT Property's type: 0-land; 1-house; 2-store; 3-plant …
PriceForSale INT How much the avatar should pay if s/he want to buy it or create it
PriceForRent INT How much other avatar should pay for the owner when passing it
Color TINYINT Land color: 0-red; 1-blue; 2-green; 3-yellow
Parent varchar If this property is a house or a store, parent is the UUID of the land; if this property is a land, parent is 0


Table name: History_Info_Table

Table description: This table is used to store history game info for every avatar who played this game.

Column Name Column Type Comments
ID VARCHAR Primary key of this table
UUID VARCHAR Avatar's UUID
FirstName VARCHAR Avatar's first name
LastName VARCHAR Avatar's last name
Time DATETIME The date and time the avatar played this game
Score INT The score the avatar get at this time
Temporary tables

Table name: Game_Table

Table description: This table is used to store the status of the p3 game.

Column Name Column Type Comments
id INTEGER Primary key of this table
GameName VARCHAR(64) Game's name
GameStatus TINYINT(1) 0-not started; 1-started


Table name: Game_Avatar_Table

Table description: This table is used to store the avatar list for the game when the game is running. When an avatar joins the game, the basic info of this avatar, UUID and name, will be insert into this table.

Column Name Column Type Comments
UUID VARCHAR(36) Primary key of this table, Avatar's UUID
FirstName VARCHAR(16) Avatar's first name
LastName VARCHAR(16) Avatar's last name
PositionX FLOAT X value of avatar's current position
PositionY FLOAT Y value of avatar's current position
PositionZ FLOAT Z value of avatar's current position
Score INTEGER The score the avatar get
JoinTime DATETIME When the avatar join the game
Status TINYINT(1) 0-wait; 1-roll dice
SquareIndex TINYINT(2) Which square the avatar is


Table name: Avatar_Property_Table

Table description: This table is used to store the avatar's properties when the game is running. When an avatar choose to buy a land, or build a house, a new record will be inserted into this table to maintain the relations between avatar and property.

Column Name Column Type Comments
AUUID VARCHAR Foreign key, Avatar's UUID
PUUID VARCHAR Foreign key, Property's UUID
PositionX FLOAT X value of Property's current position
PositionY FLOAT Y value of Property's current position
PositionZ FLOAT Z value of Property's current position


Table name: Transaction_Info_Table

Table description: This table is used to store the avatar's properties when the game is running. When an avatar choose to buy a land, or build a house, a new record will be inserted into this table to maintain the relations between avatar and property.

Column Name Column Type Comments
TransID VARCHAR Primary key
FromUUID VARCHAR Foreign key, Who pays for this transaction (Avatar UUID or 0 for the game)
ToUUID VARCHAR Foreign key, Who receive this transaction (Avatar UUID or 0 for the game)
Time DATETIME Transaction time
TransType TINYINT 0-buy land; 1-build house; 2-build store; 3-pay rent; 4-awards; 5-penalty
TransAmount INT
Comments VARCHAR A brief description of this transaction

OpenSim Server

-loginuri http://132.235.38.52:9000

Mac

  • On Mac, run this:
/Applications/Second\ Life.app/Contents/MacOS/Second\ Life -loginuri http://132.235.38.52:9000/

Windows XP

Command line

Goto command line window (Start->Run...->cmd), run below command line:

   "[Secondlife_install_path]\secondlife.exe" -loginuri http://132.235.38.52:9000


Shortcut

Create a new short cut of secondlife.exe on desktop

  • Right click desktop, select New->Shortcut from popup menu;
  • Click Browse... button, select secondlife.exe in Create Shortcut dialog window
  • Add -loginuri http://132.235.38.52:9000 to the end, then the text in the text editor before the Browse.. button should look like:
        "C:\Program Files\SecondLife\SecondLife.exe" -loginuri http://132.235.38.52:9000
  • Click Next button and type a name for this shortcut and finish.


Multimedia

Screen shots

Installation

System Requirement

Client:

  • Windows XP
  • Second Life Viewer 1.18

Server:

  • Windows XP
  • OpenSim 0.5.1

OpenSim server configuration

At the moment of writing this document, the OpenSim server can only be configured on one laptop. This should be updated in the future if we get time to do so.

The OpenSim server is a VC# project under F:\Ying\Work\Vital_Lab\Projects\OpenSim\Server\SVN\0.5.1. To run it, simply run bin\OpenSim.exe. Or you can run it from Visual C# 2008 IDE if you install one. (I deleted the VC# 2008 so right now I can just run the OpenSim.exe). A console window will show up and will keep alive along the running of OpenSim server. When you see

[STARTUP]: Startup complete, serving 1 region(s)

This means the server starts successfully. You will also find one line says:

[SERVER]: Listening on port 9000

You need to connect OpenSim server from SL viewer using port 9000.

P3 game client configuration

Mini games

Wash dishes

After a wonderful meal, the player needs to wash the dishes. Because it is possible that some dish washers contains poisons, the player should be careful to choose the dish washers before they begin to wash dishes. Otherwise they will be hurt by the toxins in the dish washers and they will lose some healthy values. During the process of washing the dishes, the player can player the Hanoi Tower Game to put the dishes in order. The player may get bonus if he plays well in the game.

Links

Personal tools