File /d/am/handlers/bernita_handler.c

Written by Taffyd

Started 8/2/1999.

Includes

Method index

• add_new_customer(int, string)
  This method adds a new customer.
• add_new_purchase(string, string, int, string)
  This method is used to add a new purchase into the customer's save file.
• find_flower_id(int, string)
  This method finds a flower's id.
• find_player_id(int, string)
  This method finds a player's id.
• player_refreshed(mixed, int)
• query_bernita_flowers()
  This returns a mapping of all the flowers in Bernita's database.
• query_total_spent(string)
  This method returns how much has been spent by the player at Bernita's Flower Shop.
• sql_query(int, string)
  This method performs an SQL query.
• top_flower_buyers(int)
• top_selling_flowers(int)

Public Functions

These are functions that everyone can access.

.

add_new_customer

int add_new_customer(int fd,
                     string name)


This method adds a new customer.

• Parameters:
  fd - the database's file description
  name - the customer's name to add
• Returns:
  1 if the customer could be successfully added, 0 if they could not be.

add_new_purchase

int add_new_purchase(string p_name,
                     string flower,
                     int value,
                     string recipient)


This method is used to add a new purchase into the customer's save file.

• Parameters:
  p_name - the player's name
  flower - the type of flower being added
  value - the value of the flower
  recipient - who the flower is being sent to.
• Returns:
  always returns 1.
  player_refreshed

  void player_refreshed(mixed p_name,
                        int total)
  

  query_bernita_flowers

  mapping query_bernita_flowers()
  

  
  This returns a mapping of all the flowers in Bernita's database. It is used by Bernita to do weird and wonderful things.
  
  • Returns:
    a mapping of flowers, where the key is the flower's name and the values are the plural and description.
    query_total_spent

    int query_total_spent(string p_name)
    

    
    This method returns how much has been spent by the player at Bernita's Flower Shop.
    
    • Parameters:
      p_name - the player's name to check
    • Returns:
      the number of brass coins that they have spent in the shop on flowers.
      top_flower_buyers

      varargs mixed * top_flower_buyers(int limit)
      

      top_selling_flowers

      varargs mixed * top_selling_flowers(int limit)
      

      Protected Functions

      These are functions that only objects inheriting the class can access.
      find_flower_id

      int find_flower_id(int fd,
                         string flower_name)
      

      
      This method finds a flower's id.
      
      • Parameters:
        fd - the database's file descriptor
        flower_name - the flower's name
      • Returns:
        the flower's id, -1 if it could not be found
        find_player_id

        int find_player_id(int fd,
                           string player)
        

        
        This method finds a player's id.
        
        • Parameters:
          fd - the database's file descriptor
          player - the player's name
        • Returns:
          the player's id, -1 if they could not be found
          sql_query

          mixed * sql_query(int fd,
                            string query)
          

          
          This method performs an SQL query. It returns the data from the query in a lovely array that you can then interpret however you wish.
          
          • Parameters:
            fd - the database file descriptor
            query - the query to be executed
          • Returns:
            an empty array if the query could not be executed, otherwise the query results.