FW: Bunch of diffs

Following an irc conversation with Helgi, re-thinking of a couple of those table fields seemed in order. We now have: CREATE TABLE zendinfo ( handle varchar(20) NOT NULL default '', birthdate date default NULL, locale varchar(30) default NULL, timezone varchar(20) default NULL, occupation varchar(255) default NULL, currentjob varchar(255) default NULL, available tinyint(1) default NULL, certified enum('no', 'PHP 4','PHP 5') NOT NULL default 'no', otherquals text, spokenlangs text, programlangs text, otherphpnet text, otheross text, otherhobbies text, spare text, PRIMARY KEY (handle), ) TYPE=MyISAM; -----Original Message----- From: Steph [mailto:steph@zend.com] Sent: 08 September 2004 11:18 To: PEAR Webmasters Subject: Bunch of diffs Hi all, As promised some days ago on irc - a new table structure, a couple of new functions for /include/pear-database.php that deal with uploading and retrieving data from the new table, a total rewrite of the existing zendWhoIsWho function, a form intended for /public_html dir, and a link to that form from /public_html/account_edit.php This is all completely untested and I'm renowned for missing brackets etc, so if you spot anything that has a touch of 'queasy-feely-doom' about it please feel free to argue with me or fix it. If it involves adding extra fields to the table, I need to know about it please! We can go live with this as soon as the new functions have been tested. Thanks for all your patience! - Steph DevZone Editor www.zend.com