email_image::update_private_p (public)

 email_image::update_private_p -user_id user_id -level level

Defined in packages/acs-subsite/tcl/email-image-procs.tcl

Changes the priv_email field from the users table

Switches:

-user_id

(required)

-level

(required)

Change to this level

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    db_transaction {
        db_dml update_users {}
    }

Generic XQL file:

<fullquery name="email_image::update_private_p.update_users">
    <querytext>
        update users
        set priv_email = :level
        where user_id = :user_id
  </querytext>
</fullquery>

packages/acs-subsite/tcl/email-image-procs.xql

PostgreSQL XQL file:

packages/acs-subsite/tcl/email-image-procs-postgresql.xql

Oracle XQL file:

packages/acs-subsite/tcl/email-image-procs-oracle.xql