[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4770: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3887)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4772: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3887)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4773: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3887)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4774: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3887)
The Climbing Club • View topic - User profiles

The Climbing Club

at the University of Washington
It is currently Sat Sep 21, 2019 1:23 pm

All times are UTC - 8 hours [ DST ]




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: User profiles
PostPosted: Fri Sep 06, 2002 1:21 pm 
Offline
An Old Geezer
User avatar

Joined: Wed Sep 04, 2002 2:27 pm
Posts: 1182


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 06, 2002 1:53 pm 
Offline
The Fleb
User avatar

Joined: Wed Sep 04, 2002 1:22 pm
Posts: 365


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 06, 2002 2:16 pm 
Offline
An Old Geezer
User avatar

Joined: Wed Sep 04, 2002 2:27 pm
Posts: 1182


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 06, 2002 2:17 pm 
Offline
An Old Geezer
User avatar

Joined: Wed Sep 04, 2002 2:27 pm
Posts: 1182


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 09, 2002 4:49 pm 
Offline
The Fleb
User avatar

Joined: Wed Sep 04, 2002 1:22 pm
Posts: 365


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 09, 2002 5:25 pm 
Offline
An Old Geezer
User avatar

Joined: Wed Sep 04, 2002 2:27 pm
Posts: 1182


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 09, 2002 8:18 pm 
Offline
The Fleb
User avatar

Joined: Wed Sep 04, 2002 1:22 pm
Posts: 365
OK, bear with me people, I'm geeking out a bit. There will probably be interesting posts about profile contents below but this is all database crap...

Here's how I'm planning to modify the database.

The table containing the user profile data is called phpbb_users. I'm not changing any other tables. I'm not removing or modifying any existing fields (although we may choose to not use some of the existing fields).

I'm adding the following fields.

The first fields provide granularity in configuring notifications of new posts:
- notify_trip_planning (boolean)
- notify_club_events (boolean)
- notify_know_how (boolean)
- notify_for_sale (boolean)
- notify_trip_reports (boolean)
- notify_club_admin (boolean)

I'm adding a couple of contact information fields:
- phone_number (varchar[255])
- street_address (varchar[255])

One field for tracking membership levels. We may or may not use this.
- membership_type (tinyint[4])

Many fields to describe activities of interest, as follows:
- scrambling (boolean)
- multi-day (boolean)
- cragging (tinyint[4])
- mountaineering (tinyint[4])
- ski_touring (tinyint[4])
- resume (varchar[255])
- tick_list (varchar[255])

Level of skill/interest/training and available gear:
- sport_leading (tinyint[4])
- trad_leading (tinyint[4])
- aid_leading (tinyint[4])
- ice_leading (tinyint[4])
- alpine (tinyint[4])
- crevasse_rescue (boolean)
- avalanche_savvy (boolean)
- snow_camping (boolean)

Car or not?
- car (boolean)


Top
 Profile  
 
 Post subject:
PostPosted: Thu Sep 19, 2002 9:43 pm 
Offline
An Old Geezer
User avatar

Joined: Wed Sep 04, 2002 2:27 pm
Posts: 1182


Top
 Profile  
 
 Post subject:
PostPosted: Thu Sep 19, 2002 10:07 pm 
Offline
The Fleb
User avatar

Joined: Wed Sep 04, 2002 1:22 pm
Posts: 365


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 20, 2002 1:40 pm 
Offline
The Fleb
User avatar

Joined: Wed Sep 04, 2002 1:22 pm
Posts: 365
Your location didn't make any sense to me :D


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group