How do I make $isprivate true by default on all new and AppendComments?

[Gervase Markham]

Habers, Mark wrote:
> Hi Everyone,

Hi Mark. This sort of support question (and any followup question) is 
generally better asked in the newsgroup :-)

> I need to do 2 things to protect the innocent. First, I would like to 
> globally change every pre-existing comment from isprivate = 0 to 
> isprivate =1(yes) in mySQL, could someone help me with a quick and dirty 
> script to do this? 

UPDATE longdescs SET isprivate = 1;

> Second, I would like to make the ‘Private’ checkbox, 
> seen whenever a user is adding a comment on a new or pre-existing bug, 
> default to selected.

template/en/default/attachment/create.html.tmpl, "isprivate" checkbox, 
add "checked" to the tag.
/usr/src/bugzilla/template/en/default/bug/edit.html.tmpl, around line 
450, "commentprivacy" checkbox, add "checked" to the tag.

Gerv