ER diagram

Technical discussion for developers and service providers

ER diagram

Postby lex » 9:41am, Mon 04 Jun, 2007

Hi guys.

I'm integrating out system with PHPlist. Our basic approach is to manipulate the PHPlist tables directly from our system. The bulk of the processing will be left of phplist. What I need to be able to do is.

i) Add users (mail recipients) to the PHPlist tables.
ii) Add those users to mailing lists.
iii) Add messages to be mailed out.

I've been trying to find an ER diagram for the PHPlist database. Does anybody know where I might find one, or alternatively a description of how the tables fit together. Looking at it it all seems fairly intuitive, but I don't want to miss anything.

Lex.
lex
phpList newbie
 
Posts: 4
Joined: 9:30am, Mon 04 Jun, 2007

Postby H2B2 » 2:48am, Wed 06 Jun, 2007

Though I can't help you with the diagrams, this might possibly be useful in your project:
Phplist class - http://forums.phplist.com/viewtopic.php?t=5009
A set of functions which provide a simple way to interact with phpList in your own programs (eg: adding a user who just purchased something from your website to a mailing list). It takes a list id, an email address, and optionally some attributes, and subscribes the user to that list. If the user already exists, the existing account will be subscribed. If it's a new user, they'll be added first. Users added in this way are pre-confirmed (they will not be sent a confirmation email).

source: http://docs.phplist.com/PhplistHacks
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

ERD for phplist Database (Not exhaustive)

Postby Guest » 1:50pm, Wed 20 Aug, 2008

ERD of phplist(Shows relationships for only the major tables)
I left out those those tables that were not relevant to me at this point and/or those where I could not figure out the usage/intention.
I tried adding the attachment here but with no success.
write to me at shwetavagarwal at the rate of gmail
Guest
 

Re: ERD for phplist Database (Not exhaustive)

Postby H2B2 » 11:44pm, Tue 30 Sep, 2008

shwetavagarwal wrote:ERD of phplist (Shows relationships for only the major tables)
Thanks for making this ERD available!

For those interested, shwetavagarwal's ER diagram (pdf file) can be downloaded here

Ref: http://mantis.phplist.com/view.php?id=15181
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

Re: ER diagram

Postby judgej » 12:27pm, Fri 13 Feb, 2009

I have posted an ERD on the 'concilience blog' that you may find useful. I'm afraid you will have to use Google to find it, as these lovely forums won't let me post anything that looks even slightly like a URL.

A clue: consil.co.uk blog

-- Jason

Moderator edit: Please see http://www.consil.co.uk/blog/2009/02/13 ... p-diagram/
judgej
phpLister
 
Posts: 8
Joined: 12:08am, Sun 16 Mar, 2008


Return to Developers Space

Who is online

Users browsing this forum: No registered users and 1 guest