$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();