Yancho

CREATE OR REPLACE FUNCTION update_lastseen()
  RETURNS "trigger" AS
$BODY$
    $new =& $_TD['new'];

    if (isset($new['users_id']) && isset($new['stamp'])) {
        $query = "UPDATE users SET last_seen = '" .$new['stamp'].
                 "' WHERE id = " .$new['users_id'];

        $rv = spi_exec($query);
    }

    return;
$BODY$
  LANGUAGE 'plphp' VOLATILE;
ALTER FUNCTION update_lastseen() OWNER TO yancho;

CREATE TRIGGER after_update_lastseen_users_trigger
    AFTER INSERT ON activity FOR EACH ROW EXECUTE PROCEDURE update_lastseen();


insert into users (username, email) values ('asdfadsfan','32432rompt.com');