<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi Everyone,</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I have what are probably 2 really simple questions based on
the knowledge most of you have. I am running BugZilla 2.17.4 on Windows with an
IIS front end (my apologies in advance). Our project loves the tool and I have
used it for many years with previous companies on UNIX variants. Getting to the
point, we are going to open up BugZilla for all of our users (8000+ of them)
and we want them to be able to see the issues, and add new ones, but not be
able to see what some would consider to be our offensive comments on these
issues. The natural assumption on my part is that we need to start using the insidergroup,
give our team members membership to that group and and then start marking our
non-politically correct comments as private. The problem is that our developers
will forget to do this first of all, and second, I have thousands of issues
containing these offensive comments.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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? 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. This way
our developers, and myself for that matter can choose which comments we want made
public in the future (if any) without worrying about all of the garbage we
currently cannot let our users, managers and executive officers see.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks in Advance</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Mark Habers</span></font></p>
</div>
</body>
</html>