Chapter 15: E-campaign System 517 (Web host 4 life) getEcampaignListInfo() This method
Chapter 15: E-campaign System 517 getEcampaignListInfo() This method returns all the information about a given list. Information is returned as a standard row object. If no information is found about a list, null is returned. addNewEcampaignList() This method adds a new list to the database. modEcampaignList() This method updates an existing list. addMapping() This method stores standard personalization fields (FIRST, LAST, EMAIL, and so on) mapping information that is used to identify which customer database field matches with which standard personalization fields. getAvailableLists() This method returns a list of available lists. The method returns an associative array where LIST_ID is the key and NAME is the value. deleteList() This method deletes an existing list. prepareLocalList() This method creates a local copy of the list data necessary to execute a campaign. It does the following: . Determines the list of mapped fields. . Makes a SQL statement to get the mapped field data from the customer database table. . Queries the customer database with the prepared statement. . Inserts the data in the assembly table. . Removes the customers who have previously unsubscribed from this list. . Returns the total number of records inserted in the assembly table. pushMappedFields() This is a utility method that pushes a field name into an array if the field name is not null. map() This is a utility method that returns the field name for a given standard contact field name.