Freetime

introduces the Genie.

He is to be found in the Dusty Old Lamp. He has violet skin and wears a waistcoat. His full name in The Sims 2 is Genie Midlock, but when hovering the cursor on him, he will simply be identified as 'Genie".

He can be summoned by children or older Sims in the household. Any Sim in the household can make a wish, even if a different Sim rubbed the lamp to summon him.

He grants three wishes altogether -- not per Sim.

Wishes can go wrong, but generally do not.

After the Genie has been summoned once, the lamp can no longer be sold, but the lamp can be given as a gift even after the Genie has been summoned and wishes have been made. There is no time limit on the lamp; wishes can be made at any time until all three have been made.

Until three wishes have been made, he can be sent back into the lamp by selecting the Dismiss option, or he will go back on his own if he is not interacted with for a while. Once three wishes are made, he will state that Genie Law requires him to leave, and return to the lamp, which will then levitate and disappear.

Sims in a household with a lamp may roll the 1500 point want to make a wish.

Wishes:

• Wealth:
  • Success: Over time, money bags with a total value of §23,000 will fall from the sky. The order of the bags' value is §10,000; §7,000; §5,000; and §1,000. However, the household has a higher chance of getting a burglar over the next few days.
  • Failure: No money falls from the sky, but the household still has a higher chance of getting a burglar over the next few days.
    
• Resurrect: Success: Resurrects a selected dead Sim or pet. As with the Resurrect-O-Nomitron, only Sims and pets the wisher is considered to know can be resurrected, and the resurrection may be imperfect.
  Failure: Resurrects a selected dead Sim, but as a zombie.
  Unlike the Resurrect-O-Nomitron, the wish will never completely fail to bring the Sim back in some manner, but the player has no control over which outcome will occur.
• Beauty:
  • Success: It acts as a love potion — the Sim is more attractive to others. The wisher's attraction points will be set to 100 for four days, which will give him or her strong chemistry with all Sims of the appropriate age(s) and gender. However, NPCs ring the Sim's doorbell at all times.
  • Failure: NPCs will still ring the Sim's doorbell at all times. (There is a mod at ModTheSims which will prevent them from coming by between 10 pm and 8 am.)
    Do not attempt to move out Sims whose wish for beauty is still in effect. Doing so will cause the attraction boost to be permanent.[1]
• Give Me A Long Life

  Success: Extends the Sim's life by 4 days.
  Failure: Shortens the Sim's life by 3 hours.
  Will not be available if the wisher is a young adult.
  This wish is available to children.

• Give Me Power To Cheat Death

  Success: This allows the Sim who made the wish to cheat death by pleading for his or her own life. At first, this will be successful. However, after each successful plea with the Grim Reaper, the chance of success is decreased by 10%. Note that pleading with Death while dying of old age will only prolong the Sim's life for another day.
  Failure: The Sim will be unable to plead for his or her own life.
  There does not appear to be any immediate indication of whether the wish succeeded or failed. That may remain unknown until the Sim is in a position to plead for his or her own life.

• Peace of Mind is perma platinum mood - the most powerful one as that clearly allows generation of multiple bottles of Elixir of Life, and therefore more or less immortality.
• Success: Gives the Sim permanent Platinum mood.
  Failure: Appliances, plumbing, and electronics will break all the time.
  This wish will not appear if the Sim has already achieved perma-platinum status.
  This wish is available to children.
  Sims who successfully make this wish will also be given credit for reaching the Lifetime Aspiration milestone of maximizing a business, even if they do not -- or have never -- owned one. They do not, however, receive the associated memory.