Page 1 of 1

contact db

Posted: Sun Sep 11, 2005 5:34 pm
by 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.

Re: contact db

Posted: Sun Sep 11, 2005 6:38 pm
by Greg
Haven't seen one calguy1000. Would be a very useful module!

Re: contact db

Posted: Mon Sep 12, 2005 1:13 am
by 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. :)

Re: contact db

Posted: Mon Sep 12, 2005 3:14 pm
by calguy1000
what would the database schema for something like this (allowing admin's to add fields to a single contact look like?)

Re: contact db

Posted: Mon Sep 12, 2005 4:16 pm
by alby
calguy1000 wrote: 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

Re: contact db

Posted: Mon Sep 12, 2005 5:05 pm
by Greg
A category field would be helpful for targetting groups.

Re: contact db

Posted: Wed Sep 14, 2005 7:16 am
by 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]