Welcome to Geeklog, Anonymous Thursday, May 23 2024 @ 11:59 pm EDT

Geeklog Forums

gl_users_extended


Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
DB Map, please take a look see if there is anything to add.

CREATE TABLE `gl_users_extended` (
`uid` mediumint(8) NOT NULL,
`lastname` varchar(25) default NULL,
`firstname` varchar(25) default NULL,
`email` varchar(50) default NULL,
`url_1` varchar(50) default NULL,
`url_2` varchar(50) default NULL,
`phone_1` varchar(50) default NULL,
`phone_2` varchar(50) default NULL,
`ext` varchar(8) default NULL,
`mobile` varchar(50) default NULL,
`title` varchar(50) default NULL,
`addr_1` varchar(25) default NULL,
`addr_2` varchar(25) default NULL,
`addr_3` varchar(50) default NULL,
`addr_4` varchar(50) default NULL,
`addr_5` varchar(50) default NULL,
`addr_6` varchar(50) default NULL,
PRIMARY KEY (`uid`)
) TYPE=MyISAM;
 Quote

Status: offline

samstone

Forum User
Full Member
Registered: 09/29/02
Posts: 820
I do sites for non-profit orgs. Most of the time we need a field for AFFILIATION (for something like "Company" or "Church" or "Denomination.")

And also POSITION, for "Chair Person", "Leader", or "Premium Member" or "guest", etc.

These optional fields will also be helpful. "Hobbies", "Special Talents or Professional Skills", "Birthday," "Marrital Status", "Gender"

Thank you for your enthusiasm!

Sam
 Quote

Status: offline

destr0yr

Forum User
Full Member
Registered: 07/06/02
Posts: 324
age, bday, GMT (similar to phpbb).
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
 Quote

Status: offline

Euan

Forum User
Full Member
Registered: 04/22/02
Posts: 292
How about

user_defined_1_title
user_defined_1_desc
user_defined_2_title
user_defined_2_desc
user_defined_3_title
user_defined_3_desc

but that's messy.

date of birth (and then calculate age as it changes).
GMT? Greenwich mean time?
-- Heather Engineering
-- No job too small
 Quote

Status: offline

destr0yr

Forum User
Full Member
Registered: 07/06/02
Posts: 324
Quote by euan:date of birth (and then calculate age as it changes).
GMT? Greenwich mean time?

Yes, have selectable DOB options, year, month day... shouldn't be too difficult, i did it on GL 1.3.7 but when i did the update forgot to back it up (and it was coded right into the core).
GMT, yah, Greenwich mean time selector for the timezone you're in. -8 Pacific, -7 Mountain, etc etc...
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
 Quote

All times are EDT. The time is now 11:59 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content