contact db

[calguy1000]

I just had discussions with a client about a new site, and came up with an issue.

The client wants to keep contact information (Name, Phone Number, Email, etc) on the website for authorized people to view. 

This would be a simple enough module, I was wondering if anybody had written anything like this yet?

So little time, so much to do.

[Greg]

Haven't seen one calguy1000. Would be a very useful module!

[iNSiPiD]

I agree. And if someone could create an admin screen that allowed you to add new fields it would be even better!

There I go, not asking for much again.

[calguy1000]

what would the database schema for something like this (allowing admin's to add fields to a single contact look like?)

[alby]

what would the database schema for something like this (allowing admin's to add fields to a single contact look like?)

An example:

TABLE FIELD:
id
name


example:
1  name
2  surname
3  address
4  phone
5  email
6  login
7  pass


TABLE DATA:
id
idNUM
FK__tablefield_id
value

example:
1  1  1  Alberto
2  1  6  alby
3  1  7  ****


Add new property in TABLE FIELD and insert data (only necessary) in TABLE DATA. idNUM is your contact.

Good job

[Greg]

A category field would be helpful for targetting groups.

[kishman155]

I am working on one to manage contact information for produkts,newsletter and so on.
It is very far jet but i have one problem the site get cached everytime the session time runs out and there is
written nocache.
i have dissable cache for sites but it won't work so i have done a workaround with redirect maybe it is helpful for you.
It's not finish jet but i think it's a good start.

at first it is a replacement for protected pages at the second one you could extend it with other features like newsletter  etc.

could anyone help me to prefent the sites get cached?

mfg
Kris

[attachment deleted by admin]