$twitter = get_http_var('twitter');
$twitter = preg_replace("/^@+/", "", $twitter);
// address
db_do("DELETE FROM journo_address WHERE journo_id=?", $this->journo['id']);
if ($address) {
db_do("INSERT INTO journo_address (journo_id,address) VALUES (?,?)", $this->journo['id'], $address);
}
// phone
db_do("DELETE FROM journo_phone WHERE journo_id=?", $this->journo['id']);
if ($phone) {
db_do("INSERT INTO journo_phone (journo_id,phone_number) VALUES (?,?)", $this->journo['id'], $phone);
}
// email
db_do("DELETE FROM journo_email WHERE journo_id=? AND srctype=''", $this->journo['id']);
if ($email) {
db_do("INSERT INTO journo_email (journo_id,email,srctype,srcurl,approved) VALUES (?,?,?,?,?)", $this->journo['id'], $email, '', '', TRUE);
}
// twitter
db_do("DELETE FROM journo_weblink WHERE journo_id=? AND kind='twitter'", $this->journo['id']);
if ($twitter) {
$twitter_url = 'http://twitter.com/' . $twitter;
$twitter_desc = $this->journo['prettyname'] . ' on Twitter';
db_do("INSERT INTO journo_weblink (journo_id,url,description,approved,kind) VALUES (?,?,?,true,'twitter')", $this->journo['id'], $twitter_url, $twitter_desc);
}
db_commit();
eventlog_Add('modify-contact', $this->journo['id']);
}
}
$page = new ContactPage();
$page->run();
