Hello

My dadadev topic of the day: Help customizing Dada Mail for your own internal needs

I started to brood over a multiple fields solution for dada Just trying to get an idea about multiple fields

Part I: Defining fields / db stuff

Additional module that manages the fields per list Functions for adding, removing, editing fields E g :

Table: dada_mfields mfield_id, mfields_label, mfields_status, PRIMARY KEY(mfields_id)

e g mfields_label: "Telefone:"

Then the n:m relation between dada_subscribers and dada_mfield Breaking apart the n:m relation in two 1:n relations (table dada_subscribers_to_mfields) e g form dada_subscribers, to dada_subscribers_to_mfields, to dada_mfields The mfield_text field in dada_subscribers_to_mfields contains the value form the subscription form

Building a relation between subscribers and fields:

Table: dada_subscribers_to_mfields dada_subscribers_email_id (foreign key from subscribers table) dada_mfield_id (foreign key from mfield table) mfield_text (text for the current field)

e g mfield_text contains the value from the subscription form

Implementation:

New package DADA::MailingList::Fields Implementaion of basic sql related routines: DADA::MailingList::Fields::baseSQL (+ MySQL specific stuff if needed)

New routines: add_field, remove_field, set_field, get_all_fields

New list admin page plugin/extension for managing the multiple fields Add/edit/remove fields All fields should have different labels So these labels can be used to build a personalized newslettters

Part II: Extended subscription form

Change generation of the subscription form (add output of available fields)

Part III: Newsletter content

List of available fields (from table dada_mfields): e g [lastname] [telefone]

Assign parts of every generated newsletter mail e g to a field value e g different list topics

Generation of the newsletter comprises a common newsletter text + texts for the different topics (defined by the fields) (Filter for field values)

BTW Are there problems with YaBB? Some threads produce error messages (300 : txt No such file or directory)

Cheers,

Markus