2020-04-10 18:32:19 http://localhost:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2020-04-10 18:32:19 http://localhost:8080/BugTracker/default.aspx sql=
select count(1) from users
2020-04-10 18:32:21 http://localhost:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2020-04-10 18:32:21 http://localhost:8080/BugTracker/default.aspx sql=
select count(1) from users
2020-04-10 18:32:35 http://localhost:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2020-04-10 18:32:35 http://localhost:8080/BugTracker/default.aspx sql=
select count(1) from users
2020-04-10 18:32:35 http://localhost:8080/BugTracker/default.aspx sql=
select us_username, us_id, us_password, isnull(us_salt,0) us_salt, us_active
from users
where us_username = N'interno.egestao'
2020-04-10 18:32:35 http://localhost:8080/BugTracker/default.aspx sql=
update users set us_most_recent_login_datetime = getdate() where us_id = 536
2020-04-10 18:32:35 http://localhost:8080/BugTracker/default.aspx sql=
select us_id from users where us_username = N'interno.egestao'
2020-04-10 18:32:35 http://localhost:8080/BugTracker/default.aspx guid=c07784a7-0a41-43c5-bb64-7a33cfac78eb
2020-04-10 18:32:35 http://localhost:8080/BugTracker/default.aspx sql=
insert into sessions (se_id, se_user) values('c07784a7-0a41-43c5-bb64-7a33cfac78eb', 536)
2020-04-10 18:32:35 http://localhost:8080/BugTracker/default.aspx AppPath:/BugTracker
2020-04-10 18:32:35 http://localhost:8080/BugTracker/bugs.aspx url=/BugTracker/bugs.aspx
2020-04-10 18:32:35 http://localhost:8080/BugTracker/bugs.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:32:35 http://localhost:8080/BugTracker/bugs.aspx sql=
declare @us_org int
select @us_org = us_org from users where us_id = 536
select qu_id, qu_desc
from queries
where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
or isnull(qu_user,0) = 536
or isnull(qu_org,0) = @us_org
order by qu_desc
2020-04-10 18:32:36 http://localhost:8080/BugTracker/bugs.aspx sql=
select qu_id, qu_sql from queries where qu_id in
(select us_default_query from users where us_id = 536)
2020-04-10 18:32:36 http://localhost:8080/BugTracker/bugs.aspx 1181 868 1022
2020-04-10 18:32:36 http://localhost:8080/BugTracker/bugs.aspx sql=
select isnull(pr_background_color,'#ffffff') [color], bg_id [id],
bg_short_desc [desc],
bg_reported_date [reported on],
isnull(rpt.us_username,'') [reported by],
isnull(pj_name,'') [project],
isnull(og_name,'') [organization],
isnull(ct_name,'') [category],
isnull(pr_name,'') [priority],
isnull(asg.us_username,'') [assigned to],
isnull(st_name,'') [status],
isnull([Modulo],'') [Modulo],
isnull([Prioridade Cliente],'') [Prioridade Cliente],
isnull([Tempo Gasto],'') [Tempo Gasto]
from bugs
left outer join users rpt on rpt.us_id = bg_reported_user
left outer join users asg on asg.us_id = bg_assigned_to_user
left outer join projects on pj_id = bg_project
left outer join orgs on og_id = bg_org
left outer join categories on ct_id = bg_category
left outer join priorities on pr_id = bg_priority
left outer join statuses on st_id = bg_status
where /* altered - both */ ( bg_project in (4)
and bg_category in (0,1,3,4,6,7,8,9,25)
and bg_status in (0,1,2,4,6,9,10)
and bg_org <> 2
and Modulo <> '98.Equipamentos'
) AND ( (bg_project not in (
select pu_project
from project_user_xref
where pu_user = 536
and pu_permission_level = 0)) ) order by isnull([Modulo],'99'), og_excecao DESC, og_indice_prioridade, og_indice_criticidade desc, og_adimplente DESC, og_contrato DESC, bg_reported_date desc
2020-04-10 18:32:37 http://localhost:8080/BugTracker/bugs.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:32:42 http://localhost:8080/BugTracker/ajax.aspx?bugid=84033 url=/BugTracker/ajax.aspx?bugid=84033
2020-04-10 18:32:42 http://localhost:8080/BugTracker/ajax.aspx?bugid=84033 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:32:42 http://localhost:8080/BugTracker/ajax.aspx?bugid=84033 sql=
declare @bg_org int
select isnull(pu_permission_level,2),
bg_org
from bugs
left outer join project_user_xref
on pu_project = bg_project
and pu_user = 536
where bg_id = 84033
2020-04-10 18:32:42 http://localhost:8080/BugTracker/ajax.aspx?bugid=84033 sql=
select top 1 substring(bp_comment,0,400), isnull(bp_content_type,'') [bp_content_type] from bug_posts
where bp_bug = 84033
and bp_type in ('received','comment')
and bp_hidden_from_external_users = 0
order by bp_date
2020-04-10 18:32:43 http://localhost:8080/BugTracker/ajax.aspx?bugid=84033 sql=
select top 1 substring(bp_comment,0,400), isnull(bp_content_type,'') [bp_content_type] from bug_posts
where bp_bug = 84033
and bp_type in ('received','comment')
and bp_hidden_from_external_users = 0
order by bp_date
2020-04-10 18:32:43 http://localhost:8080/BugTracker/ajax.aspx?bugid=84033 url=/BugTracker/ajax.aspx?bugid=84033
2020-04-10 18:32:43 http://localhost:8080/BugTracker/ajax.aspx?bugid=84033 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:32:43 http://localhost:8080/BugTracker/ajax.aspx?bugid=84033 sql=
declare @bg_org int
select isnull(pu_permission_level,2),
bg_org
from bugs
left outer join project_user_xref
on pu_project = bg_project
and pu_user = 536
where bg_id = 84033
2020-04-10 18:32:43 http://localhost:8080/BugTracker/ajax.aspx?bugid=84033 sql=
select top 1 substring(bp_comment,0,400), isnull(bp_content_type,'') [bp_content_type] from bug_posts
where bp_bug = 84033
and bp_type in ('received','comment')
and bp_hidden_from_external_users = 0
order by bp_date
2020-04-10 18:32:43 http://localhost:8080/BugTracker/ajax.aspx?bugid=84033 sql=
select top 1 substring(bp_comment,0,400), isnull(bp_content_type,'') [bp_content_type] from bug_posts
where bp_bug = 84033
and bp_type in ('received','comment')
and bp_hidden_from_external_users = 0
order by bp_date
2020-04-10 18:32:43 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 url=/BugTracker/edit_bug.aspx?id=84033
2020-04-10 18:32:43 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:32:43 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:32:43 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* get_bug_datarow */
declare @revision int
set @revision = 0
declare @related int;
select @related = count(1)
from bug_relationships
where re_bug1 = 84033;
select bg_id [id],
bg_short_desc [short_desc],
isnull(ru.us_username,'[deleted user]') [reporter],
isnull(ru.us_email,'') [reporter_email],
case rtrim(ru.us_firstname)
when null then isnull(ru.us_lastname, '')
when '' then isnull(ru.us_lastname, '')
else isnull(ru.us_lastname + ', ' + ru.us_firstname,'')
end [reporter_fullname],
bg_reported_date [reported_date],
datediff(d,bg_reported_date,getdate()) [days_ago],
isnull(lu.us_username,'') [last_updated_user],
case rtrim(lu.us_firstname)
when null then isnull(lu.us_lastname, '')
when '' then isnull(lu.us_lastname, '')
else isnull(lu.us_lastname + ', ' + lu.us_firstname,'')
end [last_updated_fullname],
bg_last_updated_date [last_updated_date],
isnull(bg_project,0) [project],
isnull(pj_name,'[no project]') [current_project],
isnull(bg_org,0) [organization],
isnull(bugorg.og_name,'') [og_name],
isnull(bg_category,0) [category],
isnull(ct_name,'') [category_name],
isnull(bg_priority,0) [priority],
isnull(pr_name,'') [priority_name],
isnull(bg_status,0) [status],
isnull(st_name,'') [status_name],
isnull(bg_user_defined_attribute,0) [udf],
isnull(udf_name,'') [udf_name],
isnull(bg_assigned_to_user,0) [assigned_to_user],
isnull(asg.us_username,'[not assigned]') [assigned_to_username],
case rtrim(asg.us_firstname)
when null then isnull(asg.us_lastname, '[not assigned]')
when '' then isnull(asg.us_lastname, '[not assigned]')
else isnull(asg.us_lastname + ', ' + asg.us_firstname,'[not assigned]')
end [assigned_to_fullname],
isnull(bs_id,0) [subscribed],
case
when
2 <> bg_org
and userorg.og_other_orgs_permission_level < 2
and userorg.og_other_orgs_permission_level < isnull(pu_permission_level,2)
then userorg.og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end [pu_permission_level],
isnull(bg_project_custom_dropdown_value1,'') [bg_project_custom_dropdown_value1],
isnull(bg_project_custom_dropdown_value2,'') [bg_project_custom_dropdown_value2],
isnull(bg_project_custom_dropdown_value3,'') [bg_project_custom_dropdown_value3],
@related [relationship_cnt],
@revision [revision_cnt],
getdate() [snapshot_timestamp]
,[Modulo],[Prioridade Cliente],[Prioridade do Implantador],[Descricao],[Tempo Gasto],[Atendimento],
CASE
WHEN (datediff(d,bg_last_updated_date,getdate()) > 3 AND isnull(bg_status,0) = 5) OR isnull(bg_status,0) = 7 THEN
0
ELSE
1
END AS [AbertoEdicao]
from bugs
inner join users this_user on us_id = 536
inner join orgs userorg on this_user.us_org = userorg.og_id
left outer join user_defined_attribute on bg_user_defined_attribute = udf_id
left outer join projects on bg_project = pj_id
left outer join orgs bugorg on bg_org = bugorg.og_id
left outer join categories on bg_category = ct_id
left outer join priorities on bg_priority = pr_id
left outer join statuses on bg_status = st_id
left outer join users asg on bg_assigned_to_user = asg.us_id
left outer join users ru on bg_reported_user = ru.us_id
left outer join users lu on bg_last_updated_user = lu.us_id
left outer join bug_subscriptions on bs_bug = bg_id and bs_user = 536
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where bg_id = 84033
2020-04-10 18:32:43 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* drop downs */ select pj_id, pj_name
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where pj_active = 1
and isnull(pu_permission_level,2) not in (0, 1)
order by pj_name;
select og_id, og_name from orgs order by og_name;
select ct_id, ct_name from categories order by ct_sort_seq, ct_name;
select pr_id, pr_name from priorities order by pr_sort_seq, pr_name;
select st_id, st_name from statuses order by st_sort_seq, st_name;
select udf_id, udf_name from user_defined_attribute order by udf_sort_seq, udf_name;
2020-04-10 18:32:43 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:32:43 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:32:43 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:32:43 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84033
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:33:26 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 url=/BugTracker/edit_bug.aspx?id=84033
2020-04-10 18:33:26 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:33:26 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:33:26 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
declare @permission_level int
set @permission_level = -1
select @permission_level = isnull(pu_permission_level,2)
from project_user_xref
where pu_project = 4
and pu_user = 536
if @permission_level = -1 set @permission_level = 2
select @permission_level
2020-04-10 18:33:26 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:33:26 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:33:26 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
declare @now datetime
declare @last_updated datetime
select @last_updated = bg_last_updated_date from bugs where bg_id = 84033
if @last_updated > '20200410 18:32:43:680'
begin
-- signal that we did NOT do the update
set @now = '20200410 18:32:43:680'
end
else
begin
-- signal that we DID do the update
set @now = getdate()
update bugs set
bg_short_desc = N'erro no cadastro cliente',
bg_project = 4,
bg_org = 220,
bg_category = 25,
bg_priority = 1,
bg_assigned_to_user = 0,
bg_status = 1,
bg_last_updated_user = 536,
bg_last_updated_date = @now,
bg_user_defined_attribute = 0,
bg_project_custom_dropdown_value1 = N'',
bg_project_custom_dropdown_value2 = N'',
bg_project_custom_dropdown_value3 = N''
,[Modulo] = N'10.Cadastros',[Prioridade Cliente] = N'2',[Prioridade do Implantador] = N'10',[Descricao] = N'A Gabriela esta tentando cadastrar um cliente e não esta conseguindo esta dando erro. O erro esta em anexo.',[Tempo Gasto] = N'0',[Atendimento] = N'2o. Nivel'
where bg_id = 84033
end
select @now
2020-04-10 18:33:26 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
declare @pj int
select @pj = bg_project from bugs where bg_id = 84033
delete from bug_subscriptions
where bs_bug = 84033
and bs_user in
(select x.pu_user
from projects
left outer join project_user_xref x on pu_project = pj_id
where pu_project = @pj
and isnull(pu_permission_level,2) = 0)
delete from bug_subscriptions
where bs_bug = 84033
and bs_user in
(select us_id from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84033
where og_other_orgs_permission_level = 0
and bg_org <> og_id)
insert into bug_subscriptions (bs_bug, bs_user)
select 84033, us_id
from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84033
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where us_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84033)
insert into bug_subscriptions (bs_bug, bs_user)
select 84033, pj_default_user
from projects
inner join users on pj_default_user = us_id
where pj_id = @pj
and pj_default_user <> 0
and pj_auto_subscribe_default_user = 1
and us_active = 1
and pj_default_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84033)
insert into bug_subscriptions (bs_bug, bs_user)
select 84033, pu_user from project_user_xref
inner join users on pu_user = us_id
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84033
where pu_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and pu_project = @pj
and pu_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84033)
insert into bug_subscriptions (bs_bug, bs_user)
select 84033, us_id
from users
inner join bugs on bg_id = 84033
inner join orgs on us_org = og_id
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where ((us_auto_subscribe_own_bugs = 1 and bg_assigned_to_user = us_id)
or
(us_auto_subscribe_reported_bugs = 1 and bg_reported_user = us_id))
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84033)
2020-04-10 18:33:26 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
declare @now datetime
set @now = getdate()
insert into bug_posts
(bp_bug, bp_user, bp_date, bp_comment, bp_comment_search, bp_email_from, bp_type, bp_content_type,
bp_hidden_from_external_users)
values(
84033,
536,
@now,
N'213123123123',
N'213123123123',
null,
N'comment',
N'text/plain',
0)
select scope_identity();
2020-04-10 18:33:27 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:33:27 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84033
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:33:31 http://localhost:8080/BugTracker/bugs.aspx url=/BugTracker/bugs.aspx
2020-04-10 18:33:31 http://localhost:8080/BugTracker/bugs.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:33:31 http://localhost:8080/BugTracker/bugs.aspx sql=
declare @us_org int
select @us_org = us_org from users where us_id = 536
select qu_id, qu_desc
from queries
where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
or isnull(qu_user,0) = 536
or isnull(qu_org,0) = @us_org
order by qu_desc
2020-04-10 18:33:31 http://localhost:8080/BugTracker/bugs.aspx sql=
select qu_id, qu_sql from queries where qu_id in
(select us_default_query from users where us_id = 536)
2020-04-10 18:33:31 http://localhost:8080/BugTracker/bugs.aspx 1181 868 1022
2020-04-10 18:33:31 http://localhost:8080/BugTracker/bugs.aspx sql=
select isnull(pr_background_color,'#ffffff') [color], bg_id [id],
bg_short_desc [desc],
bg_reported_date [reported on],
isnull(rpt.us_username,'') [reported by],
isnull(pj_name,'') [project],
isnull(og_name,'') [organization],
isnull(ct_name,'') [category],
isnull(pr_name,'') [priority],
isnull(asg.us_username,'') [assigned to],
isnull(st_name,'') [status],
isnull([Modulo],'') [Modulo],
isnull([Prioridade Cliente],'') [Prioridade Cliente],
isnull([Tempo Gasto],'') [Tempo Gasto]
from bugs
left outer join users rpt on rpt.us_id = bg_reported_user
left outer join users asg on asg.us_id = bg_assigned_to_user
left outer join projects on pj_id = bg_project
left outer join orgs on og_id = bg_org
left outer join categories on ct_id = bg_category
left outer join priorities on pr_id = bg_priority
left outer join statuses on st_id = bg_status
where /* altered - both */ ( bg_project in (4)
and bg_category in (0,1,3,4,6,7,8,9,25)
and bg_status in (0,1,2,4,6,9,10)
and bg_org <> 2
and Modulo <> '98.Equipamentos'
) AND ( (bg_project not in (
select pu_project
from project_user_xref
where pu_user = 536
and pu_permission_level = 0)) ) order by isnull([Modulo],'99'), og_excecao DESC, og_indice_prioridade, og_indice_criticidade desc, og_adimplente DESC, og_contrato DESC, bg_reported_date desc
2020-04-10 18:33:31 http://localhost:8080/BugTracker/bugs.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:33:34 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 url=/BugTracker/edit_bug.aspx?id=84033
2020-04-10 18:33:34 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:33:34 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:33:34 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* get_bug_datarow */
declare @revision int
set @revision = 0
declare @related int;
select @related = count(1)
from bug_relationships
where re_bug1 = 84033;
select bg_id [id],
bg_short_desc [short_desc],
isnull(ru.us_username,'[deleted user]') [reporter],
isnull(ru.us_email,'') [reporter_email],
case rtrim(ru.us_firstname)
when null then isnull(ru.us_lastname, '')
when '' then isnull(ru.us_lastname, '')
else isnull(ru.us_lastname + ', ' + ru.us_firstname,'')
end [reporter_fullname],
bg_reported_date [reported_date],
datediff(d,bg_reported_date,getdate()) [days_ago],
isnull(lu.us_username,'') [last_updated_user],
case rtrim(lu.us_firstname)
when null then isnull(lu.us_lastname, '')
when '' then isnull(lu.us_lastname, '')
else isnull(lu.us_lastname + ', ' + lu.us_firstname,'')
end [last_updated_fullname],
bg_last_updated_date [last_updated_date],
isnull(bg_project,0) [project],
isnull(pj_name,'[no project]') [current_project],
isnull(bg_org,0) [organization],
isnull(bugorg.og_name,'') [og_name],
isnull(bg_category,0) [category],
isnull(ct_name,'') [category_name],
isnull(bg_priority,0) [priority],
isnull(pr_name,'') [priority_name],
isnull(bg_status,0) [status],
isnull(st_name,'') [status_name],
isnull(bg_user_defined_attribute,0) [udf],
isnull(udf_name,'') [udf_name],
isnull(bg_assigned_to_user,0) [assigned_to_user],
isnull(asg.us_username,'[not assigned]') [assigned_to_username],
case rtrim(asg.us_firstname)
when null then isnull(asg.us_lastname, '[not assigned]')
when '' then isnull(asg.us_lastname, '[not assigned]')
else isnull(asg.us_lastname + ', ' + asg.us_firstname,'[not assigned]')
end [assigned_to_fullname],
isnull(bs_id,0) [subscribed],
case
when
2 <> bg_org
and userorg.og_other_orgs_permission_level < 2
and userorg.og_other_orgs_permission_level < isnull(pu_permission_level,2)
then userorg.og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end [pu_permission_level],
isnull(bg_project_custom_dropdown_value1,'') [bg_project_custom_dropdown_value1],
isnull(bg_project_custom_dropdown_value2,'') [bg_project_custom_dropdown_value2],
isnull(bg_project_custom_dropdown_value3,'') [bg_project_custom_dropdown_value3],
@related [relationship_cnt],
@revision [revision_cnt],
getdate() [snapshot_timestamp]
,[Modulo],[Prioridade Cliente],[Prioridade do Implantador],[Descricao],[Tempo Gasto],[Atendimento],
CASE
WHEN (datediff(d,bg_last_updated_date,getdate()) > 3 AND isnull(bg_status,0) = 5) OR isnull(bg_status,0) = 7 THEN
0
ELSE
1
END AS [AbertoEdicao]
from bugs
inner join users this_user on us_id = 536
inner join orgs userorg on this_user.us_org = userorg.og_id
left outer join user_defined_attribute on bg_user_defined_attribute = udf_id
left outer join projects on bg_project = pj_id
left outer join orgs bugorg on bg_org = bugorg.og_id
left outer join categories on bg_category = ct_id
left outer join priorities on bg_priority = pr_id
left outer join statuses on bg_status = st_id
left outer join users asg on bg_assigned_to_user = asg.us_id
left outer join users ru on bg_reported_user = ru.us_id
left outer join users lu on bg_last_updated_user = lu.us_id
left outer join bug_subscriptions on bs_bug = bg_id and bs_user = 536
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where bg_id = 84033
2020-04-10 18:33:34 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* drop downs */ select pj_id, pj_name
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where pj_active = 1
and isnull(pu_permission_level,2) not in (0, 1)
order by pj_name;
select og_id, og_name from orgs order by og_name;
select ct_id, ct_name from categories order by ct_sort_seq, ct_name;
select pr_id, pr_name from priorities order by pr_sort_seq, pr_name;
select st_id, st_name from statuses order by st_sort_seq, st_name;
select udf_id, udf_name from user_defined_attribute order by udf_sort_seq, udf_name;
2020-04-10 18:33:34 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:33:34 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:33:34 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:33:34 http://localhost:8080/BugTracker/edit_bug.aspx?id=84033 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84033
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 url=/BugTracker/edit_bug.aspx?id=0
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
/* drop downs */ select pj_id, pj_name
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where pj_active = 1
and isnull(pu_permission_level,2) not in (0, 1)
order by pj_name;
select og_id, og_name from orgs order by og_name;
select ct_id, ct_name from categories order by ct_sort_seq, ct_name;
select pr_id, pr_name from priorities order by pr_sort_seq, pr_name;
select st_id, st_name from statuses order by st_sort_seq, st_name;
select udf_id, udf_name from user_defined_attribute order by udf_sort_seq, udf_name;
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
select top 1 pj_id from projects where pj_default = 1 order by pj_name;
select top 1 ct_id from categories where ct_default = 1 order by ct_name;
select top 1 pr_id from priorities where pr_default = 1 order by pr_name;
select top 1 st_id from statuses where st_default = 1 order by st_name;
select top 1 udf_id from user_defined_attribute where udf_default = 1 order by udf_name;
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
select (10)
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
select (10)
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
select (0)
2020-04-10 18:33:41 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 url=/BugTracker/edit_bug.aspx?id=0
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
insert into bugs
(bg_short_desc,
bg_reported_user,
bg_last_updated_user,
bg_reported_date,
bg_last_updated_date,
bg_project,
bg_org,
bg_category,
bg_priority,
bg_status,
bg_assigned_to_user,
bg_user_defined_attribute,
bg_project_custom_dropdown_value1,
bg_project_custom_dropdown_value2,
bg_project_custom_dropdown_value3
,[Modulo],[Tempo Gasto],[Prioridade Cliente],[Prioridade do Implantador],[Descricao],[Atendimento])
values (N'131313123', 536, 536, getdate(), getdate(),
4, 2,
4, 0, 1, 0, 0,
N'',N'',N'' ,N'12.Outros',N'0',N'10',N'10', null,N'1o. Nivel')
select scope_identity()
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
declare @now datetime
set @now = getdate()
insert into bug_posts
(bp_bug, bp_user, bp_date, bp_comment, bp_comment_search, bp_email_from, bp_type, bp_content_type,
bp_hidden_from_external_users)
values(
84214,
536,
@now,
N'123123123123',
N'123123123123',
null,
N'comment',
N'text/plain',
0)
select scope_identity();
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=0 sql=
declare @pj int
select @pj = bg_project from bugs where bg_id = 84214
delete from bug_subscriptions
where bs_bug = 84214
and bs_user in
(select x.pu_user
from projects
left outer join project_user_xref x on pu_project = pj_id
where pu_project = @pj
and isnull(pu_permission_level,2) = 0)
delete from bug_subscriptions
where bs_bug = 84214
and bs_user in
(select us_id from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84214
where og_other_orgs_permission_level = 0
and bg_org <> og_id)
insert into bug_subscriptions (bs_bug, bs_user)
select 84214, us_id
from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84214
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where us_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84214)
insert into bug_subscriptions (bs_bug, bs_user)
select 84214, pj_default_user
from projects
inner join users on pj_default_user = us_id
where pj_id = @pj
and pj_default_user <> 0
and pj_auto_subscribe_default_user = 1
and us_active = 1
and pj_default_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84214)
insert into bug_subscriptions (bs_bug, bs_user)
select 84214, pu_user from project_user_xref
inner join users on pu_user = us_id
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84214
where pu_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and pu_project = @pj
and pu_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84214)
insert into bug_subscriptions (bs_bug, bs_user)
select 84214, us_id
from users
inner join bugs on bg_id = 84214
inner join orgs on us_org = og_id
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where ((us_auto_subscribe_own_bugs = 1 and bg_assigned_to_user = us_id)
or
(us_auto_subscribe_reported_bugs = 1 and bg_reported_user = us_id))
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84214)
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 url=/BugTracker/edit_bug.aspx?id=84214
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
/* get_bug_datarow */
declare @revision int
set @revision = 0
declare @related int;
select @related = count(1)
from bug_relationships
where re_bug1 = 84214;
select bg_id [id],
bg_short_desc [short_desc],
isnull(ru.us_username,'[deleted user]') [reporter],
isnull(ru.us_email,'') [reporter_email],
case rtrim(ru.us_firstname)
when null then isnull(ru.us_lastname, '')
when '' then isnull(ru.us_lastname, '')
else isnull(ru.us_lastname + ', ' + ru.us_firstname,'')
end [reporter_fullname],
bg_reported_date [reported_date],
datediff(d,bg_reported_date,getdate()) [days_ago],
isnull(lu.us_username,'') [last_updated_user],
case rtrim(lu.us_firstname)
when null then isnull(lu.us_lastname, '')
when '' then isnull(lu.us_lastname, '')
else isnull(lu.us_lastname + ', ' + lu.us_firstname,'')
end [last_updated_fullname],
bg_last_updated_date [last_updated_date],
isnull(bg_project,0) [project],
isnull(pj_name,'[no project]') [current_project],
isnull(bg_org,0) [organization],
isnull(bugorg.og_name,'') [og_name],
isnull(bg_category,0) [category],
isnull(ct_name,'') [category_name],
isnull(bg_priority,0) [priority],
isnull(pr_name,'') [priority_name],
isnull(bg_status,0) [status],
isnull(st_name,'') [status_name],
isnull(bg_user_defined_attribute,0) [udf],
isnull(udf_name,'') [udf_name],
isnull(bg_assigned_to_user,0) [assigned_to_user],
isnull(asg.us_username,'[not assigned]') [assigned_to_username],
case rtrim(asg.us_firstname)
when null then isnull(asg.us_lastname, '[not assigned]')
when '' then isnull(asg.us_lastname, '[not assigned]')
else isnull(asg.us_lastname + ', ' + asg.us_firstname,'[not assigned]')
end [assigned_to_fullname],
isnull(bs_id,0) [subscribed],
case
when
2 <> bg_org
and userorg.og_other_orgs_permission_level < 2
and userorg.og_other_orgs_permission_level < isnull(pu_permission_level,2)
then userorg.og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end [pu_permission_level],
isnull(bg_project_custom_dropdown_value1,'') [bg_project_custom_dropdown_value1],
isnull(bg_project_custom_dropdown_value2,'') [bg_project_custom_dropdown_value2],
isnull(bg_project_custom_dropdown_value3,'') [bg_project_custom_dropdown_value3],
@related [relationship_cnt],
@revision [revision_cnt],
getdate() [snapshot_timestamp]
,[Modulo],[Prioridade Cliente],[Prioridade do Implantador],[Descricao],[Tempo Gasto],[Atendimento],
CASE
WHEN (datediff(d,bg_last_updated_date,getdate()) > 3 AND isnull(bg_status,0) = 5) OR isnull(bg_status,0) = 7 THEN
0
ELSE
1
END AS [AbertoEdicao]
from bugs
inner join users this_user on us_id = 536
inner join orgs userorg on this_user.us_org = userorg.og_id
left outer join user_defined_attribute on bg_user_defined_attribute = udf_id
left outer join projects on bg_project = pj_id
left outer join orgs bugorg on bg_org = bugorg.og_id
left outer join categories on bg_category = ct_id
left outer join priorities on bg_priority = pr_id
left outer join statuses on bg_status = st_id
left outer join users asg on bg_assigned_to_user = asg.us_id
left outer join users ru on bg_reported_user = ru.us_id
left outer join users lu on bg_last_updated_user = lu.us_id
left outer join bug_subscriptions on bs_bug = bg_id and bs_user = 536
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where bg_id = 84214
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
/* drop downs */ select pj_id, pj_name
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where pj_active = 1
and isnull(pu_permission_level,2) not in (0, 1)
order by pj_name;
select og_id, og_name from orgs order by og_name;
select ct_id, ct_name from categories order by ct_sort_seq, ct_name;
select pr_id, pr_name from priorities order by pr_sort_seq, pr_name;
select st_id, st_name from statuses order by st_sort_seq, st_name;
select udf_id, udf_name from user_defined_attribute order by udf_sort_seq, udf_name;
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:33:51 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84214
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 url=/BugTracker/edit_bug.aspx?id=84214
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
declare @permission_level int
set @permission_level = -1
select @permission_level = isnull(pu_permission_level,2)
from project_user_xref
where pu_project = 4
and pu_user = 536
if @permission_level = -1 set @permission_level = 2
select @permission_level
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
declare @now datetime
declare @last_updated datetime
select @last_updated = bg_last_updated_date from bugs where bg_id = 84214
if @last_updated > '20200410 18:33:51:460'
begin
-- signal that we did NOT do the update
set @now = '20200410 18:33:51:460'
end
else
begin
-- signal that we DID do the update
set @now = getdate()
update bugs set
bg_short_desc = N'131313123',
bg_project = 4,
bg_org = 2,
bg_category = 4,
bg_priority = 0,
bg_assigned_to_user = 0,
bg_status = 1,
bg_last_updated_user = 536,
bg_last_updated_date = @now,
bg_user_defined_attribute = 0,
bg_project_custom_dropdown_value1 = N'',
bg_project_custom_dropdown_value2 = N'',
bg_project_custom_dropdown_value3 = N''
,[Modulo] = N'12.Outros',[Prioridade Cliente] = N'10',[Prioridade do Implantador] = N'10',[Descricao] = null,[Tempo Gasto] = N'0',[Atendimento] = N'1o. Nivel'
where bg_id = 84214
end
select @now
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
declare @pj int
select @pj = bg_project from bugs where bg_id = 84214
delete from bug_subscriptions
where bs_bug = 84214
and bs_user in
(select x.pu_user
from projects
left outer join project_user_xref x on pu_project = pj_id
where pu_project = @pj
and isnull(pu_permission_level,2) = 0)
delete from bug_subscriptions
where bs_bug = 84214
and bs_user in
(select us_id from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84214
where og_other_orgs_permission_level = 0
and bg_org <> og_id)
insert into bug_subscriptions (bs_bug, bs_user)
select 84214, us_id
from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84214
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where us_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84214)
insert into bug_subscriptions (bs_bug, bs_user)
select 84214, pj_default_user
from projects
inner join users on pj_default_user = us_id
where pj_id = @pj
and pj_default_user <> 0
and pj_auto_subscribe_default_user = 1
and us_active = 1
and pj_default_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84214)
insert into bug_subscriptions (bs_bug, bs_user)
select 84214, pu_user from project_user_xref
inner join users on pu_user = us_id
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84214
where pu_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and pu_project = @pj
and pu_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84214)
insert into bug_subscriptions (bs_bug, bs_user)
select 84214, us_id
from users
inner join bugs on bg_id = 84214
inner join orgs on us_org = og_id
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where ((us_auto_subscribe_own_bugs = 1 and bg_assigned_to_user = us_id)
or
(us_auto_subscribe_reported_bugs = 1 and bg_reported_user = us_id))
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84214)
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
declare @now datetime
set @now = getdate()
insert into bug_posts
(bp_bug, bp_user, bp_date, bp_comment, bp_comment_search, bp_email_from, bp_type, bp_content_type,
bp_hidden_from_external_users)
values(
84214,
536,
@now,
N'231231',
N'231231',
null,
N'comment',
N'text/plain',
0)
select scope_identity();
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:34:00 http://localhost:8080/BugTracker/edit_bug.aspx?id=84214 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84214
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:34:02 http://localhost:8080/BugTracker/admin.aspx url=/BugTracker/admin.aspx
2020-04-10 18:34:02 http://localhost:8080/BugTracker/admin.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:34:04 http://localhost:8080/BugTracker/users.aspx url=/BugTracker/users.aspx
2020-04-10 18:34:04 http://localhost:8080/BugTracker/users.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:34:04 http://localhost:8080/BugTracker/users.aspx sql=
select distinct pu_user
into #t
from
project_user_xref
where pu_admin = 1;
select u.us_id [id],
'edit' [$no_sort_edit],
'copy' [$no_sort_add
like
this],
'delete' [$no_sort_delete],
u.us_username [username],
isnull(u.us_firstname,'') + ' ' + isnull(u.us_lastname,'') [name],
'' + og_name + '' [org],
case when u.us_admin = 1 then 'Y' else 'N' end [admin],
case when pu_user is null then 'N' else 'Y' end [project
admin],
case when u.us_active = 1 then 'Y' else 'N' end [active],
case when og_external_user = 1 then 'Y' else 'N' end [external],
isnull(pj_name,'') [forced
project],
isnull(qu_desc,'') [default query],
case when u.us_enable_notifications = 1 then 'Y' else 'N' end [notif-
ications],
u2.us_username [created
by]
from users u
inner join orgs on u.us_org = og_id
left outer join queries on u.us_default_query = qu_id
left outer join projects on u.us_forced_project = pj_id
left outer join users u2 on u.us_created_user = u2.us_id
left outer join #t on u.us_id = pu_user
where u.us_active in (1 ,0)
order by u.us_username;
drop table #t
2020-04-10 18:34:08 http://localhost:8080/BugTracker/delete_user.aspx?id=347 url=/BugTracker/delete_user.aspx?id=347
2020-04-10 18:34:08 http://localhost:8080/BugTracker/delete_user.aspx?id=347 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:34:08 http://localhost:8080/BugTracker/delete_user.aspx?id=347 sql=
declare @cnt int
select @cnt = count(1) from bugs where bg_reported_user = 347 or bg_assigned_to_user = 347
if @cnt = 0
begin
select @cnt = count(1) from bug_posts where bp_user = 347
end
select us_username, @cnt [cnt] from users where us_id = 347
2020-04-10 18:34:20 http://localhost:8080/BugTracker/delete_user.aspx?id=660 url=/BugTracker/delete_user.aspx?id=660
2020-04-10 18:34:20 http://localhost:8080/BugTracker/delete_user.aspx?id=660 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:34:20 http://localhost:8080/BugTracker/delete_user.aspx?id=660 sql=
declare @cnt int
select @cnt = count(1) from bugs where bg_reported_user = 660 or bg_assigned_to_user = 660
if @cnt = 0
begin
select @cnt = count(1) from bug_posts where bp_user = 660
end
select us_username, @cnt [cnt] from users where us_id = 660
2020-04-10 18:34:26 http://localhost:8080/BugTracker/delete_user.aspx?id=133 url=/BugTracker/delete_user.aspx?id=133
2020-04-10 18:34:26 http://localhost:8080/BugTracker/delete_user.aspx?id=133 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:34:26 http://localhost:8080/BugTracker/delete_user.aspx?id=133 sql=
declare @cnt int
select @cnt = count(1) from bugs where bg_reported_user = 133 or bg_assigned_to_user = 133
if @cnt = 0
begin
select @cnt = count(1) from bug_posts where bp_user = 133
end
select us_username, @cnt [cnt] from users where us_id = 133
2020-04-10 18:34:32 http://localhost:8080/BugTracker/edit_user.aspx url=/BugTracker/edit_user.aspx
2020-04-10 18:34:32 http://localhost:8080/BugTracker/edit_user.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:34:32 http://localhost:8080/BugTracker/edit_user.aspx sql=
select pj_id, pj_name,
isnull(pu_permission_level,2) [pu_permission_level],
isnull(pu_auto_subscribe,0) [pu_auto_subscribe],
isnull(pu_admin,0) [pu_admin]
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 0
WHERE projects.pj_active = 1
order by pj_name;/* populate query dropdown */
declare @org int
set @org = null
select @org = us_org from users where us_id = 0
select qu_id, qu_desc
from queries
where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
or isnull(qu_user,0) = 0
or isnull(qu_org,0) = isnull(@org,-1)
order by qu_desc;/* populate org dropdown */
select og_id, og_name
from orgs
where og_non_admins_can_use = 1
or 1 = 1
order by og_name;
2020-04-10 18:34:57 http://localhost:8080/BugTracker/edit_user.aspx url=/BugTracker/edit_user.aspx
2020-04-10 18:34:57 http://localhost:8080/BugTracker/edit_user.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:34:57 http://localhost:8080/BugTracker/edit_user.aspx sql=
select count(1) from users where us_username = N'teste1'
2020-04-10 18:34:57 http://localhost:8080/BugTracker/edit_user.aspx sql=
insert into users
(us_username, us_password,
us_firstname, us_lastname,
us_bugs_per_page,
us_use_fckeditor,
us_enable_bug_list_popups,
us_email,
us_active, us_admin,
us_enable_notifications,
us_send_notifications_to_self,
us_reported_notifications,
us_assigned_notifications,
us_subscribed_notifications,
us_auto_subscribe,
us_auto_subscribe_own_bugs,
us_auto_subscribe_reported_bugs,
us_default_query,
us_org,
us_signature,
us_forced_project,
us_created_user)
values (
N'teste1', N'333249235', N'tss', N'',
10, 0, 1, N'',
1, 0, 1, 0,
4, 4, 4, 0,
1, 1, 89, 2, N'',
4,
536
);
select scope_identity()
2020-04-10 18:34:57 http://localhost:8080/BugTracker/edit_user.aspx sql=
update users set us_password = N'2B71184A232459607EB1E5A0F78AA882', us_salt = 99239 where us_id = 1045
2020-04-10 18:34:57 http://localhost:8080/BugTracker/edit_user.aspx sql=
insert into project_user_xref (pu_project, pu_user, pu_auto_subscribe)
select pj_id, 1045, 0
from projects
where pj_id in (4)
and pj_id not in (select pu_project from project_user_xref where pu_user = 1045);
update project_user_xref
set pu_auto_subscribe = 0,
pu_admin = 0,
pu_permission_level = 2
where pu_user = 1045;
update project_user_xref
set pu_permission_level = 3
where pu_user = 1045
and pu_project in (4);
2020-04-10 18:34:57 http://localhost:8080/BugTracker/edit_user.aspx url=/BugTracker/edit_user.aspx
2020-04-10 18:34:57 http://localhost:8080/BugTracker/edit_user.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:34:57 http://localhost:8080/BugTracker/edit_user.aspx sql=
select distinct pu_user
into #t
from
project_user_xref
where pu_admin = 1;
select u.us_id [id],
'edit' [$no_sort_edit],
'copy' [$no_sort_add
like
this],
'delete' [$no_sort_delete],
u.us_username [username],
isnull(u.us_firstname,'') + ' ' + isnull(u.us_lastname,'') [name],
'' + og_name + '' [org],
case when u.us_admin = 1 then 'Y' else 'N' end [admin],
case when pu_user is null then 'N' else 'Y' end [project
admin],
case when u.us_active = 1 then 'Y' else 'N' end [active],
case when og_external_user = 1 then 'Y' else 'N' end [external],
isnull(pj_name,'') [forced
project],
isnull(qu_desc,'') [default query],
case when u.us_enable_notifications = 1 then 'Y' else 'N' end [notif-
ications],
u2.us_username [created
by]
from users u
inner join orgs on u.us_org = og_id
left outer join queries on u.us_default_query = qu_id
left outer join projects on u.us_forced_project = pj_id
left outer join users u2 on u.us_created_user = u2.us_id
left outer join #t on u.us_id = pu_user
where u.us_active in (1 ,0)
order by u.us_username;
drop table #t
2020-04-10 18:35:04 http://localhost:8080/BugTracker/delete_user.aspx?id=1045 url=/BugTracker/delete_user.aspx?id=1045
2020-04-10 18:35:04 http://localhost:8080/BugTracker/delete_user.aspx?id=1045 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:35:04 http://localhost:8080/BugTracker/delete_user.aspx?id=1045 sql=
declare @cnt int
select @cnt = count(1) from bugs where bg_reported_user = 1045 or bg_assigned_to_user = 1045
if @cnt = 0
begin
select @cnt = count(1) from bug_posts where bp_user = 1045
end
select us_username, @cnt [cnt] from users where us_id = 1045
2020-04-10 18:35:06 http://localhost:8080/BugTracker/delete_user.aspx?id=1045 url=/BugTracker/delete_user.aspx?id=1045
2020-04-10 18:35:06 http://localhost:8080/BugTracker/delete_user.aspx?id=1045 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:35:06 http://localhost:8080/BugTracker/delete_user.aspx?id=1045 sql=
delete users where us_id = 1045
delete project_user_xref where pu_user = 1045
delete bug_subscriptions where bs_user = 1045
delete bug_user_flags where fl_user = 1045
delete queries where qu_user = 1045
delete queued_notifications where qn_user = 1045
delete dashboard_items where ds_user = 1045
2020-04-10 18:35:06 http://localhost:8080/BugTracker/delete_user.aspx?id=1045 url=/BugTracker/delete_user.aspx?id=1045
2020-04-10 18:35:06 http://localhost:8080/BugTracker/delete_user.aspx?id=1045 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:35:06 http://localhost:8080/BugTracker/delete_user.aspx?id=1045 sql=
select distinct pu_user
into #t
from
project_user_xref
where pu_admin = 1;
select u.us_id [id],
'edit' [$no_sort_edit],
'copy' [$no_sort_add
like
this],
'delete' [$no_sort_delete],
u.us_username [username],
isnull(u.us_firstname,'') + ' ' + isnull(u.us_lastname,'') [name],
'' + og_name + '' [org],
case when u.us_admin = 1 then 'Y' else 'N' end [admin],
case when pu_user is null then 'N' else 'Y' end [project
admin],
case when u.us_active = 1 then 'Y' else 'N' end [active],
case when og_external_user = 1 then 'Y' else 'N' end [external],
isnull(pj_name,'') [forced
project],
isnull(qu_desc,'') [default query],
case when u.us_enable_notifications = 1 then 'Y' else 'N' end [notif-
ications],
u2.us_username [created
by]
from users u
inner join orgs on u.us_org = og_id
left outer join queries on u.us_default_query = qu_id
left outer join projects on u.us_forced_project = pj_id
left outer join users u2 on u.us_created_user = u2.us_id
left outer join #t on u.us_id = pu_user
where u.us_active in (1 ,0)
order by u.us_username;
drop table #t
2020-04-10 18:35:12 http://localhost:8080/BugTracker/users.aspx?id=1045 url=/BugTracker/users.aspx?id=1045
2020-04-10 18:35:12 http://localhost:8080/BugTracker/users.aspx?id=1045 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:35:12 http://localhost:8080/BugTracker/users.aspx?id=1045 sql=
select distinct pu_user
into #t
from
project_user_xref
where pu_admin = 1;
select u.us_id [id],
'edit' [$no_sort_edit],
'copy' [$no_sort_add
like
this],
'delete' [$no_sort_delete],
u.us_username [username],
isnull(u.us_firstname,'') + ' ' + isnull(u.us_lastname,'') [name],
'' + og_name + '' [org],
case when u.us_admin = 1 then 'Y' else 'N' end [admin],
case when pu_user is null then 'N' else 'Y' end [project
admin],
case when u.us_active = 1 then 'Y' else 'N' end [active],
case when og_external_user = 1 then 'Y' else 'N' end [external],
isnull(pj_name,'') [forced
project],
isnull(qu_desc,'') [default query],
case when u.us_enable_notifications = 1 then 'Y' else 'N' end [notif-
ications],
u2.us_username [created
by]
from users u
inner join orgs on u.us_org = og_id
left outer join queries on u.us_default_query = qu_id
left outer join projects on u.us_forced_project = pj_id
left outer join users u2 on u.us_created_user = u2.us_id
left outer join #t on u.us_id = pu_user
where u.us_active in (1 ,0)
and u.us_username like 'tes%'
order by u.us_username;
drop table #t
2020-04-10 18:35:15 http://localhost:8080/BugTracker/delete_user.aspx?id=19 url=/BugTracker/delete_user.aspx?id=19
2020-04-10 18:35:15 http://localhost:8080/BugTracker/delete_user.aspx?id=19 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
and us_active = 1
2020-04-10 18:35:15 http://localhost:8080/BugTracker/delete_user.aspx?id=19 sql=
declare @cnt int
select @cnt = count(1) from bugs where bg_reported_user = 19 or bg_assigned_to_user = 19
if @cnt = 0
begin
select @cnt = count(1) from bug_posts where bp_user = 19
end
select us_username, @cnt [cnt] from users where us_id = 19
2020-04-10 18:35:19 http://localhost:8080/BugTracker/delete_user.aspx?id=19 sql=
delete from sessions
where se_id = N'c07784a7-0a41-43c5-bb64-7a33cfac78eb'
or datediff(d, se_date, getdate()) > 2
2020-04-10 18:35:19 http://localhost:8080/BugTracker/default.aspx?msg=logged+off url=/BugTracker/default.aspx?msg=logged+off
2020-04-10 18:35:19 http://localhost:8080/BugTracker/default.aspx?msg=logged+off sql=
select count(1) from users
2020-04-10 18:36:21 http://localhost:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2020-04-10 18:36:21 http://localhost:8080/BugTracker/default.aspx sql=
select count(1) from users
2020-04-10 18:36:25 http://localhost:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2020-04-10 18:36:25 http://localhost:8080/BugTracker/default.aspx sql=
select count(1) from users
2020-04-10 18:36:25 http://localhost:8080/BugTracker/default.aspx sql=
select us_username, us_id, us_password, isnull(us_salt,0) us_salt, us_active
from users
where us_username = N'interno.egestao'
2020-04-10 18:36:25 http://localhost:8080/BugTracker/default.aspx sql=
update users set us_most_recent_login_datetime = getdate() where us_id = 536
2020-04-10 18:36:25 http://localhost:8080/BugTracker/default.aspx sql=
select us_id from users where us_username = N'interno.egestao'
2020-04-10 18:36:25 http://localhost:8080/BugTracker/default.aspx guid=fde4ed6b-e755-4d09-96dd-4d682127266c
2020-04-10 18:36:25 http://localhost:8080/BugTracker/default.aspx sql=
insert into sessions (se_id, se_user) values('fde4ed6b-e755-4d09-96dd-4d682127266c', 536)
2020-04-10 18:36:25 http://localhost:8080/BugTracker/default.aspx AppPath:/BugTracker
2020-04-10 18:36:25 http://localhost:8080/BugTracker/bugs.aspx url=/BugTracker/bugs.aspx
2020-04-10 18:36:25 http://localhost:8080/BugTracker/bugs.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:36:25 http://localhost:8080/BugTracker/bugs.aspx sql=
declare @us_org int
select @us_org = us_org from users where us_id = 536
select qu_id, qu_desc
from queries
where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
or isnull(qu_user,0) = 536
or isnull(qu_org,0) = @us_org
order by qu_desc
2020-04-10 18:36:25 http://localhost:8080/BugTracker/bugs.aspx sql=
select qu_id, qu_sql from queries where qu_id in
(select us_default_query from users where us_id = 536)
2020-04-10 18:36:25 http://localhost:8080/BugTracker/bugs.aspx 1181 868 1022
2020-04-10 18:36:25 http://localhost:8080/BugTracker/bugs.aspx sql=
select isnull(pr_background_color,'#ffffff') [color], bg_id [id],
bg_short_desc [desc],
bg_reported_date [reported on],
isnull(rpt.us_username,'') [reported by],
isnull(pj_name,'') [project],
isnull(og_name,'') [organization],
isnull(ct_name,'') [category],
isnull(pr_name,'') [priority],
isnull(asg.us_username,'') [assigned to],
isnull(st_name,'') [status],
isnull([Modulo],'') [Modulo],
isnull([Prioridade Cliente],'') [Prioridade Cliente],
isnull([Tempo Gasto],'') [Tempo Gasto]
from bugs
left outer join users rpt on rpt.us_id = bg_reported_user
left outer join users asg on asg.us_id = bg_assigned_to_user
left outer join projects on pj_id = bg_project
left outer join orgs on og_id = bg_org
left outer join categories on ct_id = bg_category
left outer join priorities on pr_id = bg_priority
left outer join statuses on st_id = bg_status
where /* altered - both */ ( bg_project in (4)
and bg_category in (0,1,3,4,6,7,8,9,25)
and bg_status in (0,1,2,4,6,9,10)
and bg_org <> 2
and Modulo <> '98.Equipamentos'
) AND ( (bg_project not in (
select pu_project
from project_user_xref
where pu_user = 536
and pu_permission_level = 0)) ) order by isnull([Modulo],'99'), og_excecao DESC, og_indice_prioridade, og_indice_criticidade desc, og_adimplente DESC, og_contrato DESC, bg_reported_date desc
2020-04-10 18:36:25 http://localhost:8080/BugTracker/bugs.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:36:26 http://localhost:8080/BugTracker/ajax.aspx?bugid=83383 url=/BugTracker/ajax.aspx?bugid=83383
2020-04-10 18:36:26 http://localhost:8080/BugTracker/ajax.aspx?bugid=83383 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:36:26 http://localhost:8080/BugTracker/ajax.aspx?bugid=83383 sql=
declare @bg_org int
select isnull(pu_permission_level,2),
bg_org
from bugs
left outer join project_user_xref
on pu_project = bg_project
and pu_user = 536
where bg_id = 83383
2020-04-10 18:36:26 http://localhost:8080/BugTracker/ajax.aspx?bugid=83383 sql=
select top 1 substring(bp_comment,0,400), isnull(bp_content_type,'') [bp_content_type] from bug_posts
where bp_bug = 83383
and bp_type in ('received','comment')
and bp_hidden_from_external_users = 0
order by bp_date
2020-04-10 18:36:26 http://localhost:8080/BugTracker/ajax.aspx?bugid=83383 sql=
select top 1 substring(bp_comment,0,400), isnull(bp_content_type,'') [bp_content_type] from bug_posts
where bp_bug = 83383
and bp_type in ('received','comment')
and bp_hidden_from_external_users = 0
order by bp_date
2020-04-10 18:36:27 http://localhost:8080/BugTracker/edit_bug.aspx url=/BugTracker/edit_bug.aspx
2020-04-10 18:36:27 http://localhost:8080/BugTracker/edit_bug.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:36:27 http://localhost:8080/BugTracker/edit_bug.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:36:27 http://localhost:8080/BugTracker/edit_bug.aspx sql=
/* drop downs */ select pj_id, pj_name
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where pj_active = 1
and isnull(pu_permission_level,2) not in (0, 1)
order by pj_name;
select og_id, og_name from orgs order by og_name;
select ct_id, ct_name from categories order by ct_sort_seq, ct_name;
select pr_id, pr_name from priorities order by pr_sort_seq, pr_name;
select st_id, st_name from statuses order by st_sort_seq, st_name;
select udf_id, udf_name from user_defined_attribute order by udf_sort_seq, udf_name;
2020-04-10 18:36:27 http://localhost:8080/BugTracker/edit_bug.aspx sql=
select top 1 pj_id from projects where pj_default = 1 order by pj_name;
select top 1 ct_id from categories where ct_default = 1 order by ct_name;
select top 1 pr_id from priorities where pr_default = 1 order by pr_name;
select top 1 st_id from statuses where st_default = 1 order by st_name;
select top 1 udf_id from user_defined_attribute where udf_default = 1 order by udf_name;
2020-04-10 18:36:27 http://localhost:8080/BugTracker/edit_bug.aspx sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:36:27 http://localhost:8080/BugTracker/edit_bug.aspx sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:36:27 http://localhost:8080/BugTracker/edit_bug.aspx sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx url=/BugTracker/edit_bug.aspx
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx sql=
insert into bugs
(bg_short_desc,
bg_reported_user,
bg_last_updated_user,
bg_reported_date,
bg_last_updated_date,
bg_project,
bg_org,
bg_category,
bg_priority,
bg_status,
bg_assigned_to_user,
bg_user_defined_attribute,
bg_project_custom_dropdown_value1,
bg_project_custom_dropdown_value2,
bg_project_custom_dropdown_value3
,[Modulo],[Tempo Gasto],[Prioridade Cliente],[Prioridade do Implantador],[Descricao],[Atendimento])
values (N'ggggggg', 536, 536, getdate(), getdate(),
4, 2,
4, 0, 1, 0, 0,
N'',N'',N'' ,N'12.Outros', null,N'10',N'10', null,N'1o. Nivel')
select scope_identity()
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx sql=
declare @now datetime
set @now = getdate()
insert into bug_posts
(bp_bug, bp_user, bp_date, bp_comment, bp_comment_search, bp_email_from, bp_type, bp_content_type,
bp_hidden_from_external_users)
values(
84215,
536,
@now,
N'dasdasdasd',
N'dasdasdasd',
null,
N'comment',
N'text/plain',
0)
select scope_identity();
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx sql=
declare @pj int
select @pj = bg_project from bugs where bg_id = 84215
delete from bug_subscriptions
where bs_bug = 84215
and bs_user in
(select x.pu_user
from projects
left outer join project_user_xref x on pu_project = pj_id
where pu_project = @pj
and isnull(pu_permission_level,2) = 0)
delete from bug_subscriptions
where bs_bug = 84215
and bs_user in
(select us_id from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84215
where og_other_orgs_permission_level = 0
and bg_org <> og_id)
insert into bug_subscriptions (bs_bug, bs_user)
select 84215, us_id
from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84215
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where us_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84215)
insert into bug_subscriptions (bs_bug, bs_user)
select 84215, pj_default_user
from projects
inner join users on pj_default_user = us_id
where pj_id = @pj
and pj_default_user <> 0
and pj_auto_subscribe_default_user = 1
and us_active = 1
and pj_default_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84215)
insert into bug_subscriptions (bs_bug, bs_user)
select 84215, pu_user from project_user_xref
inner join users on pu_user = us_id
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84215
where pu_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and pu_project = @pj
and pu_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84215)
insert into bug_subscriptions (bs_bug, bs_user)
select 84215, us_id
from users
inner join bugs on bg_id = 84215
inner join orgs on us_org = og_id
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where ((us_auto_subscribe_own_bugs = 1 and bg_assigned_to_user = us_id)
or
(us_auto_subscribe_reported_bugs = 1 and bg_reported_user = us_id))
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84215)
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 url=/BugTracker/edit_bug.aspx?id=84215
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
/* get_bug_datarow */
declare @revision int
set @revision = 0
declare @related int;
select @related = count(1)
from bug_relationships
where re_bug1 = 84215;
select bg_id [id],
bg_short_desc [short_desc],
isnull(ru.us_username,'[deleted user]') [reporter],
isnull(ru.us_email,'') [reporter_email],
case rtrim(ru.us_firstname)
when null then isnull(ru.us_lastname, '')
when '' then isnull(ru.us_lastname, '')
else isnull(ru.us_lastname + ', ' + ru.us_firstname,'')
end [reporter_fullname],
bg_reported_date [reported_date],
datediff(d,bg_reported_date,getdate()) [days_ago],
isnull(lu.us_username,'') [last_updated_user],
case rtrim(lu.us_firstname)
when null then isnull(lu.us_lastname, '')
when '' then isnull(lu.us_lastname, '')
else isnull(lu.us_lastname + ', ' + lu.us_firstname,'')
end [last_updated_fullname],
bg_last_updated_date [last_updated_date],
isnull(bg_project,0) [project],
isnull(pj_name,'[no project]') [current_project],
isnull(bg_org,0) [organization],
isnull(bugorg.og_name,'') [og_name],
isnull(bg_category,0) [category],
isnull(ct_name,'') [category_name],
isnull(bg_priority,0) [priority],
isnull(pr_name,'') [priority_name],
isnull(bg_status,0) [status],
isnull(st_name,'') [status_name],
isnull(bg_user_defined_attribute,0) [udf],
isnull(udf_name,'') [udf_name],
isnull(bg_assigned_to_user,0) [assigned_to_user],
isnull(asg.us_username,'[not assigned]') [assigned_to_username],
case rtrim(asg.us_firstname)
when null then isnull(asg.us_lastname, '[not assigned]')
when '' then isnull(asg.us_lastname, '[not assigned]')
else isnull(asg.us_lastname + ', ' + asg.us_firstname,'[not assigned]')
end [assigned_to_fullname],
isnull(bs_id,0) [subscribed],
case
when
2 <> bg_org
and userorg.og_other_orgs_permission_level < 2
and userorg.og_other_orgs_permission_level < isnull(pu_permission_level,2)
then userorg.og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end [pu_permission_level],
isnull(bg_project_custom_dropdown_value1,'') [bg_project_custom_dropdown_value1],
isnull(bg_project_custom_dropdown_value2,'') [bg_project_custom_dropdown_value2],
isnull(bg_project_custom_dropdown_value3,'') [bg_project_custom_dropdown_value3],
@related [relationship_cnt],
@revision [revision_cnt],
getdate() [snapshot_timestamp]
,[Modulo],[Prioridade Cliente],[Prioridade do Implantador],[Descricao],[Tempo Gasto],[Atendimento],
CASE
WHEN (datediff(d,bg_last_updated_date,getdate()) > 3 AND isnull(bg_status,0) = 5) OR isnull(bg_status,0) = 7 THEN
0
ELSE
1
END AS [AbertoEdicao]
from bugs
inner join users this_user on us_id = 536
inner join orgs userorg on this_user.us_org = userorg.og_id
left outer join user_defined_attribute on bg_user_defined_attribute = udf_id
left outer join projects on bg_project = pj_id
left outer join orgs bugorg on bg_org = bugorg.og_id
left outer join categories on bg_category = ct_id
left outer join priorities on bg_priority = pr_id
left outer join statuses on bg_status = st_id
left outer join users asg on bg_assigned_to_user = asg.us_id
left outer join users ru on bg_reported_user = ru.us_id
left outer join users lu on bg_last_updated_user = lu.us_id
left outer join bug_subscriptions on bs_bug = bg_id and bs_user = 536
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where bg_id = 84215
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
/* drop downs */ select pj_id, pj_name
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where pj_active = 1
and isnull(pu_permission_level,2) not in (0, 1)
order by pj_name;
select og_id, og_name from orgs order by og_name;
select ct_id, ct_name from categories order by ct_sort_seq, ct_name;
select pr_id, pr_name from priorities order by pr_sort_seq, pr_name;
select st_id, st_name from statuses order by st_sort_seq, st_name;
select udf_id, udf_name from user_defined_attribute order by udf_sort_seq, udf_name;
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:36:37 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84215
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 url=/BugTracker/edit_bug.aspx?id=84215
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
declare @permission_level int
set @permission_level = -1
select @permission_level = isnull(pu_permission_level,2)
from project_user_xref
where pu_project = 4
and pu_user = 536
if @permission_level = -1 set @permission_level = 2
select @permission_level
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
declare @now datetime
declare @last_updated datetime
select @last_updated = bg_last_updated_date from bugs where bg_id = 84215
if @last_updated > '20200410 18:36:37:323'
begin
-- signal that we did NOT do the update
set @now = '20200410 18:36:37:323'
end
else
begin
-- signal that we DID do the update
set @now = getdate()
update bugs set
bg_short_desc = N'ggggggg',
bg_project = 4,
bg_org = 2,
bg_category = 4,
bg_priority = 0,
bg_assigned_to_user = 0,
bg_status = 1,
bg_last_updated_user = 536,
bg_last_updated_date = @now,
bg_user_defined_attribute = 0,
bg_project_custom_dropdown_value1 = N'',
bg_project_custom_dropdown_value2 = N'',
bg_project_custom_dropdown_value3 = N''
,[Modulo] = N'12.Outros',[Prioridade Cliente] = N'10',[Prioridade do Implantador] = N'10',[Descricao] = N'213123123',[Tempo Gasto] = null,[Atendimento] = N'1o. Nivel'
where bg_id = 84215
end
select @now
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
declare @pj int
select @pj = bg_project from bugs where bg_id = 84215
delete from bug_subscriptions
where bs_bug = 84215
and bs_user in
(select x.pu_user
from projects
left outer join project_user_xref x on pu_project = pj_id
where pu_project = @pj
and isnull(pu_permission_level,2) = 0)
delete from bug_subscriptions
where bs_bug = 84215
and bs_user in
(select us_id from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84215
where og_other_orgs_permission_level = 0
and bg_org <> og_id)
insert into bug_subscriptions (bs_bug, bs_user)
select 84215, us_id
from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84215
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where us_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84215)
insert into bug_subscriptions (bs_bug, bs_user)
select 84215, pj_default_user
from projects
inner join users on pj_default_user = us_id
where pj_id = @pj
and pj_default_user <> 0
and pj_auto_subscribe_default_user = 1
and us_active = 1
and pj_default_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84215)
insert into bug_subscriptions (bs_bug, bs_user)
select 84215, pu_user from project_user_xref
inner join users on pu_user = us_id
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84215
where pu_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and pu_project = @pj
and pu_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84215)
insert into bug_subscriptions (bs_bug, bs_user)
select 84215, us_id
from users
inner join bugs on bg_id = 84215
inner join orgs on us_org = og_id
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where ((us_auto_subscribe_own_bugs = 1 and bg_assigned_to_user = us_id)
or
(us_auto_subscribe_reported_bugs = 1 and bg_reported_user = us_id))
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84215)
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
insert into bug_posts
(bp_bug, bp_user, bp_date, bp_comment, bp_type)
values(84215, 536, getdate(), N'alterado Descricao de "" para "213123123"', 'update')
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
declare @now datetime
set @now = getdate()
insert into bug_posts
(bp_bug, bp_user, bp_date, bp_comment, bp_comment_search, bp_email_from, bp_type, bp_content_type,
bp_hidden_from_external_users)
values(
84215,
536,
@now,
N'123123123',
N'123123123',
null,
N'comment',
N'text/plain',
0)
select scope_identity();
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:36:47 http://localhost:8080/BugTracker/edit_bug.aspx?id=84215 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84215
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:36:53 http://localhost:8080/BugTracker/bugs.aspx url=/BugTracker/bugs.aspx
2020-04-10 18:36:53 http://localhost:8080/BugTracker/bugs.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:36:53 http://localhost:8080/BugTracker/bugs.aspx sql=
declare @us_org int
select @us_org = us_org from users where us_id = 536
select qu_id, qu_desc
from queries
where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
or isnull(qu_user,0) = 536
or isnull(qu_org,0) = @us_org
order by qu_desc
2020-04-10 18:36:53 http://localhost:8080/BugTracker/bugs.aspx sql=
select qu_sql from queries where qu_id = 62
2020-04-10 18:36:53 http://localhost:8080/BugTracker/bugs.aspx 1181 868 1022
2020-04-10 18:36:53 http://localhost:8080/BugTracker/bugs.aspx sql=
select isnull(pr_background_color,'#ffffff') [color], bg_id [id],
bg_short_desc [desc],
bg_reported_date [reported on],
isnull(rpt.us_username,'') [reported by],
isnull(pj_name,'') [project],
isnull(og_name,'') [organization],
isnull(ct_name,'') [category],
isnull(pr_name,'') [priority],
isnull(asg.us_username,'') [assigned to],
isnull(st_name,'') [status],
isnull([Modulo],'') [Modulo],
isnull([Prioridade Cliente],'') [Prioridade Cliente],
isnull([Tempo Gasto],'') [Tempo Gasto]
from bugs
left outer join users rpt on rpt.us_id = bg_reported_user
left outer join users asg on asg.us_id = bg_assigned_to_user
left outer join projects on pj_id = bg_project
left outer join orgs on og_id = bg_org
left outer join categories on ct_id = bg_category
left outer join priorities on pr_id = bg_priority
left outer join statuses on st_id = bg_status
where /* altered - both */ ( bg_project in (4)
and bg_category in (0,1,3,4,6,7,8,9,25)
and bg_status in (0,1,2,4,6,9,10)
and bg_org <> 2
and Modulo <> '98.Equipamentos'
) AND ( (bg_project not in (
select pu_project
from project_user_xref
where pu_user = 536
and pu_permission_level = 0)) ) order by isnull([Modulo],'99'), og_excecao DESC, og_indice_prioridade, og_indice_criticidade desc, og_adimplente DESC, og_contrato DESC, bg_reported_date desc
2020-04-10 18:36:53 http://localhost:8080/BugTracker/bugs.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:36:54 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 url=/BugTracker/edit_bug.aspx?id=84196
2020-04-10 18:36:54 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:36:54 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:36:54 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* get_bug_datarow */
declare @revision int
set @revision = 0
declare @related int;
select @related = count(1)
from bug_relationships
where re_bug1 = 84196;
select bg_id [id],
bg_short_desc [short_desc],
isnull(ru.us_username,'[deleted user]') [reporter],
isnull(ru.us_email,'') [reporter_email],
case rtrim(ru.us_firstname)
when null then isnull(ru.us_lastname, '')
when '' then isnull(ru.us_lastname, '')
else isnull(ru.us_lastname + ', ' + ru.us_firstname,'')
end [reporter_fullname],
bg_reported_date [reported_date],
datediff(d,bg_reported_date,getdate()) [days_ago],
isnull(lu.us_username,'') [last_updated_user],
case rtrim(lu.us_firstname)
when null then isnull(lu.us_lastname, '')
when '' then isnull(lu.us_lastname, '')
else isnull(lu.us_lastname + ', ' + lu.us_firstname,'')
end [last_updated_fullname],
bg_last_updated_date [last_updated_date],
isnull(bg_project,0) [project],
isnull(pj_name,'[no project]') [current_project],
isnull(bg_org,0) [organization],
isnull(bugorg.og_name,'') [og_name],
isnull(bg_category,0) [category],
isnull(ct_name,'') [category_name],
isnull(bg_priority,0) [priority],
isnull(pr_name,'') [priority_name],
isnull(bg_status,0) [status],
isnull(st_name,'') [status_name],
isnull(bg_user_defined_attribute,0) [udf],
isnull(udf_name,'') [udf_name],
isnull(bg_assigned_to_user,0) [assigned_to_user],
isnull(asg.us_username,'[not assigned]') [assigned_to_username],
case rtrim(asg.us_firstname)
when null then isnull(asg.us_lastname, '[not assigned]')
when '' then isnull(asg.us_lastname, '[not assigned]')
else isnull(asg.us_lastname + ', ' + asg.us_firstname,'[not assigned]')
end [assigned_to_fullname],
isnull(bs_id,0) [subscribed],
case
when
2 <> bg_org
and userorg.og_other_orgs_permission_level < 2
and userorg.og_other_orgs_permission_level < isnull(pu_permission_level,2)
then userorg.og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end [pu_permission_level],
isnull(bg_project_custom_dropdown_value1,'') [bg_project_custom_dropdown_value1],
isnull(bg_project_custom_dropdown_value2,'') [bg_project_custom_dropdown_value2],
isnull(bg_project_custom_dropdown_value3,'') [bg_project_custom_dropdown_value3],
@related [relationship_cnt],
@revision [revision_cnt],
getdate() [snapshot_timestamp]
,[Modulo],[Prioridade Cliente],[Prioridade do Implantador],[Descricao],[Tempo Gasto],[Atendimento],
CASE
WHEN (datediff(d,bg_last_updated_date,getdate()) > 3 AND isnull(bg_status,0) = 5) OR isnull(bg_status,0) = 7 THEN
0
ELSE
1
END AS [AbertoEdicao]
from bugs
inner join users this_user on us_id = 536
inner join orgs userorg on this_user.us_org = userorg.og_id
left outer join user_defined_attribute on bg_user_defined_attribute = udf_id
left outer join projects on bg_project = pj_id
left outer join orgs bugorg on bg_org = bugorg.og_id
left outer join categories on bg_category = ct_id
left outer join priorities on bg_priority = pr_id
left outer join statuses on bg_status = st_id
left outer join users asg on bg_assigned_to_user = asg.us_id
left outer join users ru on bg_reported_user = ru.us_id
left outer join users lu on bg_last_updated_user = lu.us_id
left outer join bug_subscriptions on bs_bug = bg_id and bs_user = 536
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where bg_id = 84196
2020-04-10 18:36:54 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* drop downs */ select pj_id, pj_name
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where pj_active = 1
and isnull(pu_permission_level,2) not in (0, 1)
order by pj_name;
select og_id, og_name from orgs order by og_name;
select ct_id, ct_name from categories order by ct_sort_seq, ct_name;
select pr_id, pr_name from priorities order by pr_sort_seq, pr_name;
select st_id, st_name from statuses order by st_sort_seq, st_name;
select udf_id, udf_name from user_defined_attribute order by udf_sort_seq, udf_name;
2020-04-10 18:36:54 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:36:54 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:36:54 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84196
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:36:57 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 url=/BugTracker/edit_bug.aspx?id=84196
2020-04-10 18:36:57 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:36:57 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:36:57 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
declare @permission_level int
set @permission_level = -1
select @permission_level = isnull(pu_permission_level,2)
from project_user_xref
where pu_project = 4
and pu_user = 536
if @permission_level = -1 set @permission_level = 2
select @permission_level
2020-04-10 18:36:57 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:36:57 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
declare @now datetime
declare @last_updated datetime
select @last_updated = bg_last_updated_date from bugs where bg_id = 84196
if @last_updated > '20200410 18:36:54:523'
begin
-- signal that we did NOT do the update
set @now = '20200410 18:36:54:523'
end
else
begin
-- signal that we DID do the update
set @now = getdate()
update bugs set
bg_short_desc = N'DERMOSENSE',
bg_project = 4,
bg_org = 319,
bg_category = 4,
bg_priority = 1,
bg_assigned_to_user = 868,
bg_status = 1,
bg_last_updated_user = 536,
bg_last_updated_date = @now,
bg_user_defined_attribute = 0,
bg_project_custom_dropdown_value1 = N'',
bg_project_custom_dropdown_value2 = N'',
bg_project_custom_dropdown_value3 = N''
,[Modulo] = N'01.Faturamento',[Prioridade Cliente] = N'1',[Prioridade do Implantador] = N'10',[Descricao] = N'NOTA DE DEVOLUÇÃO',[Tempo Gasto] = N'0',[Atendimento] = N'2o. Nivel'
where bg_id = 84196
end
select @now
2020-04-10 18:36:57 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
declare @pj int
select @pj = bg_project from bugs where bg_id = 84196
delete from bug_subscriptions
where bs_bug = 84196
and bs_user in
(select x.pu_user
from projects
left outer join project_user_xref x on pu_project = pj_id
where pu_project = @pj
and isnull(pu_permission_level,2) = 0)
delete from bug_subscriptions
where bs_bug = 84196
and bs_user in
(select us_id from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84196
where og_other_orgs_permission_level = 0
and bg_org <> og_id)
insert into bug_subscriptions (bs_bug, bs_user)
select 84196, us_id
from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84196
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where us_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84196)
insert into bug_subscriptions (bs_bug, bs_user)
select 84196, pj_default_user
from projects
inner join users on pj_default_user = us_id
where pj_id = @pj
and pj_default_user <> 0
and pj_auto_subscribe_default_user = 1
and us_active = 1
and pj_default_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84196)
insert into bug_subscriptions (bs_bug, bs_user)
select 84196, pu_user from project_user_xref
inner join users on pu_user = us_id
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84196
where pu_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and pu_project = @pj
and pu_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84196)
insert into bug_subscriptions (bs_bug, bs_user)
select 84196, us_id
from users
inner join bugs on bg_id = 84196
inner join orgs on us_org = og_id
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where ((us_auto_subscribe_own_bugs = 1 and bg_assigned_to_user = us_id)
or
(us_auto_subscribe_reported_bugs = 1 and bg_reported_user = us_id))
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84196)
2020-04-10 18:36:57 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
declare @now datetime
set @now = getdate()
insert into bug_posts
(bp_bug, bp_user, bp_date, bp_comment, bp_comment_search, bp_email_from, bp_type, bp_content_type,
bp_hidden_from_external_users)
values(
84196,
536,
@now,
N'123 3123123123',
N'123 3123123123',
null,
N'comment',
N'text/plain',
0)
select scope_identity();
2020-04-10 18:36:57 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:36:57 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84196
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:36:58 http://localhost:8080/BugTracker/bugs.aspx url=/BugTracker/bugs.aspx
2020-04-10 18:36:58 http://localhost:8080/BugTracker/bugs.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:36:58 http://localhost:8080/BugTracker/bugs.aspx sql=
declare @us_org int
select @us_org = us_org from users where us_id = 536
select qu_id, qu_desc
from queries
where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
or isnull(qu_user,0) = 536
or isnull(qu_org,0) = @us_org
order by qu_desc
2020-04-10 18:36:58 http://localhost:8080/BugTracker/bugs.aspx sql=
select qu_sql from queries where qu_id = 62
2020-04-10 18:36:58 http://localhost:8080/BugTracker/bugs.aspx 1181 868 1022
2020-04-10 18:36:58 http://localhost:8080/BugTracker/bugs.aspx sql=
select isnull(pr_background_color,'#ffffff') [color], bg_id [id],
bg_short_desc [desc],
bg_reported_date [reported on],
isnull(rpt.us_username,'') [reported by],
isnull(pj_name,'') [project],
isnull(og_name,'') [organization],
isnull(ct_name,'') [category],
isnull(pr_name,'') [priority],
isnull(asg.us_username,'') [assigned to],
isnull(st_name,'') [status],
isnull([Modulo],'') [Modulo],
isnull([Prioridade Cliente],'') [Prioridade Cliente],
isnull([Tempo Gasto],'') [Tempo Gasto]
from bugs
left outer join users rpt on rpt.us_id = bg_reported_user
left outer join users asg on asg.us_id = bg_assigned_to_user
left outer join projects on pj_id = bg_project
left outer join orgs on og_id = bg_org
left outer join categories on ct_id = bg_category
left outer join priorities on pr_id = bg_priority
left outer join statuses on st_id = bg_status
where /* altered - both */ ( bg_project in (4)
and bg_category in (0,1,3,4,6,7,8,9,25)
and bg_status in (0,1,2,4,6,9,10)
and bg_org <> 2
and Modulo <> '98.Equipamentos'
) AND ( (bg_project not in (
select pu_project
from project_user_xref
where pu_user = 536
and pu_permission_level = 0)) ) order by isnull([Modulo],'99'), og_excecao DESC, og_indice_prioridade, og_indice_criticidade desc, og_adimplente DESC, og_contrato DESC, bg_reported_date desc
2020-04-10 18:36:58 http://localhost:8080/BugTracker/bugs.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:37:01 http://localhost:8080/BugTracker/admin.aspx url=/BugTracker/admin.aspx
2020-04-10 18:37:01 http://localhost:8080/BugTracker/admin.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:03 http://localhost:8080/BugTracker/users.aspx url=/BugTracker/users.aspx
2020-04-10 18:37:03 http://localhost:8080/BugTracker/users.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:03 http://localhost:8080/BugTracker/users.aspx sql=
select distinct pu_user
into #t
from
project_user_xref
where pu_admin = 1;
select u.us_id [id],
'edit' [$no_sort_edit],
'copy' [$no_sort_add
like
this],
'delete' [$no_sort_delete],
u.us_username [username],
isnull(u.us_firstname,'') + ' ' + isnull(u.us_lastname,'') [name],
'' + og_name + '' [org],
case when u.us_admin = 1 then 'Y' else 'N' end [admin],
case when pu_user is null then 'N' else 'Y' end [project
admin],
case when u.us_active = 1 then 'Y' else 'N' end [active],
case when og_external_user = 1 then 'Y' else 'N' end [external],
isnull(pj_name,'') [forced
project],
isnull(qu_desc,'') [default query],
case when u.us_enable_notifications = 1 then 'Y' else 'N' end [notif-
ications],
u2.us_username [created
by]
from users u
inner join orgs on u.us_org = og_id
left outer join queries on u.us_default_query = qu_id
left outer join projects on u.us_forced_project = pj_id
left outer join users u2 on u.us_created_user = u2.us_id
left outer join #t on u.us_id = pu_user
where u.us_active in (1 ,0)
and u.us_username like 'tes%'
order by u.us_username;
drop table #t
2020-04-10 18:37:04 http://localhost:8080/BugTracker/edit_user.aspx url=/BugTracker/edit_user.aspx
2020-04-10 18:37:04 http://localhost:8080/BugTracker/edit_user.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:04 http://localhost:8080/BugTracker/edit_user.aspx sql=
select pj_id, pj_name,
isnull(pu_permission_level,2) [pu_permission_level],
isnull(pu_auto_subscribe,0) [pu_auto_subscribe],
isnull(pu_admin,0) [pu_admin]
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 0
WHERE projects.pj_active = 1
order by pj_name;/* populate query dropdown */
declare @org int
set @org = null
select @org = us_org from users where us_id = 0
select qu_id, qu_desc
from queries
where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
or isnull(qu_user,0) = 0
or isnull(qu_org,0) = isnull(@org,-1)
order by qu_desc;/* populate org dropdown */
select og_id, og_name
from orgs
where og_non_admins_can_use = 1
or 1 = 1
order by og_name;
2020-04-10 18:37:21 http://localhost:8080/BugTracker/edit_user.aspx url=/BugTracker/edit_user.aspx
2020-04-10 18:37:21 http://localhost:8080/BugTracker/edit_user.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:21 http://localhost:8080/BugTracker/edit_user.aspx sql=
select count(1) from users where us_username = N'teste1'
2020-04-10 18:37:21 http://localhost:8080/BugTracker/edit_user.aspx sql=
insert into users
(us_username, us_password,
us_firstname, us_lastname,
us_bugs_per_page,
us_use_fckeditor,
us_enable_bug_list_popups,
us_email,
us_active, us_admin,
us_enable_notifications,
us_send_notifications_to_self,
us_reported_notifications,
us_assigned_notifications,
us_subscribed_notifications,
us_auto_subscribe,
us_auto_subscribe_own_bugs,
us_auto_subscribe_reported_bugs,
us_default_query,
us_org,
us_signature,
us_forced_project,
us_created_user)
values (
N'teste1', N'433658102', N'teste', N'',
10, 0, 1, N'',
1, 0, 1, 0,
4, 4, 4, 0,
1, 1, 89, 2, N'',
4,
536
);
select scope_identity()
2020-04-10 18:37:21 http://localhost:8080/BugTracker/edit_user.aspx sql=
update users set us_password = N'9E87D7D29E2C003114650965EA161481', us_salt = 28174 where us_id = 1046
2020-04-10 18:37:21 http://localhost:8080/BugTracker/edit_user.aspx sql=
insert into project_user_xref (pu_project, pu_user, pu_auto_subscribe)
select pj_id, 1046, 0
from projects
where pj_id in (4)
and pj_id not in (select pu_project from project_user_xref where pu_user = 1046);
update project_user_xref
set pu_auto_subscribe = 0,
pu_admin = 0,
pu_permission_level = 2
where pu_user = 1046;
update project_user_xref
set pu_permission_level = 3
where pu_user = 1046
and pu_project in (4);
2020-04-10 18:37:21 http://localhost:8080/BugTracker/edit_user.aspx url=/BugTracker/edit_user.aspx
2020-04-10 18:37:21 http://localhost:8080/BugTracker/edit_user.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:21 http://localhost:8080/BugTracker/edit_user.aspx sql=
select distinct pu_user
into #t
from
project_user_xref
where pu_admin = 1;
select u.us_id [id],
'edit' [$no_sort_edit],
'copy' [$no_sort_add
like
this],
'delete' [$no_sort_delete],
u.us_username [username],
isnull(u.us_firstname,'') + ' ' + isnull(u.us_lastname,'') [name],
'' + og_name + '' [org],
case when u.us_admin = 1 then 'Y' else 'N' end [admin],
case when pu_user is null then 'N' else 'Y' end [project
admin],
case when u.us_active = 1 then 'Y' else 'N' end [active],
case when og_external_user = 1 then 'Y' else 'N' end [external],
isnull(pj_name,'') [forced
project],
isnull(qu_desc,'') [default query],
case when u.us_enable_notifications = 1 then 'Y' else 'N' end [notif-
ications],
u2.us_username [created
by]
from users u
inner join orgs on u.us_org = og_id
left outer join queries on u.us_default_query = qu_id
left outer join projects on u.us_forced_project = pj_id
left outer join users u2 on u.us_created_user = u2.us_id
left outer join #t on u.us_id = pu_user
where u.us_active in (1 ,0)
and u.us_username like 'tes%'
order by u.us_username;
drop table #t
2020-04-10 18:37:25 http://localhost:8080/BugTracker/delete_user.aspx?id=1046 url=/BugTracker/delete_user.aspx?id=1046
2020-04-10 18:37:25 http://localhost:8080/BugTracker/delete_user.aspx?id=1046 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:25 http://localhost:8080/BugTracker/delete_user.aspx?id=1046 sql=
declare @cnt int
select @cnt = count(1) from bugs where bg_reported_user = 1046 or bg_assigned_to_user = 1046
if @cnt = 0
begin
select @cnt = count(1) from bug_posts where bp_user = 1046
end
select us_username, @cnt [cnt] from users where us_id = 1046
2020-04-10 18:37:27 http://localhost:8080/BugTracker/delete_user.aspx?id=1046 url=/BugTracker/delete_user.aspx?id=1046
2020-04-10 18:37:27 http://localhost:8080/BugTracker/delete_user.aspx?id=1046 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:27 http://localhost:8080/BugTracker/delete_user.aspx?id=1046 sql=
delete users where us_id = 1046
delete project_user_xref where pu_user = 1046
delete bug_subscriptions where bs_user = 1046
delete bug_user_flags where fl_user = 1046
delete queries where qu_user = 1046
delete queued_notifications where qn_user = 1046
delete dashboard_items where ds_user = 1046
2020-04-10 18:37:27 http://localhost:8080/BugTracker/delete_user.aspx?id=1046 url=/BugTracker/delete_user.aspx?id=1046
2020-04-10 18:37:27 http://localhost:8080/BugTracker/delete_user.aspx?id=1046 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:27 http://localhost:8080/BugTracker/delete_user.aspx?id=1046 sql=
select distinct pu_user
into #t
from
project_user_xref
where pu_admin = 1;
select u.us_id [id],
'edit' [$no_sort_edit],
'copy' [$no_sort_add
like
this],
'delete' [$no_sort_delete],
u.us_username [username],
isnull(u.us_firstname,'') + ' ' + isnull(u.us_lastname,'') [name],
'' + og_name + '' [org],
case when u.us_admin = 1 then 'Y' else 'N' end [admin],
case when pu_user is null then 'N' else 'Y' end [project
admin],
case when u.us_active = 1 then 'Y' else 'N' end [active],
case when og_external_user = 1 then 'Y' else 'N' end [external],
isnull(pj_name,'') [forced
project],
isnull(qu_desc,'') [default query],
case when u.us_enable_notifications = 1 then 'Y' else 'N' end [notif-
ications],
u2.us_username [created
by]
from users u
inner join orgs on u.us_org = og_id
left outer join queries on u.us_default_query = qu_id
left outer join projects on u.us_forced_project = pj_id
left outer join users u2 on u.us_created_user = u2.us_id
left outer join #t on u.us_id = pu_user
where u.us_active in (1 ,0)
and u.us_username like 'tes%'
order by u.us_username;
drop table #t
2020-04-10 18:37:27 http://localhost:8080/BugTracker/edit_user.aspx?id=19 url=/BugTracker/edit_user.aspx?id=19
2020-04-10 18:37:27 http://localhost:8080/BugTracker/edit_user.aspx?id=19 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:27 http://localhost:8080/BugTracker/edit_user.aspx?id=19 sql=
select pj_id, pj_name,
isnull(pu_permission_level,2) [pu_permission_level],
isnull(pu_auto_subscribe,0) [pu_auto_subscribe],
isnull(pu_admin,0) [pu_admin]
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 19
WHERE projects.pj_active = 1
order by pj_name;/* populate query dropdown */
declare @org int
set @org = null
select @org = us_org from users where us_id = 19
select qu_id, qu_desc
from queries
where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
or isnull(qu_user,0) = 19
or isnull(qu_org,0) = isnull(@org,-1)
order by qu_desc;/* populate org dropdown */
select og_id, og_name
from orgs
where og_non_admins_can_use = 1
or 1 = 1
order by og_name;select
us_username,
isnull(us_firstname,'') [us_firstname],
isnull(us_lastname,'') [us_lastname],
isnull(us_bugs_per_page,10) [us_bugs_per_page],
us_use_fckeditor,
us_enable_bug_list_popups,
isnull(us_email,'') [us_email],
us_active,
us_admin,
us_enable_notifications,
us_send_notifications_to_self,
us_reported_notifications,
us_assigned_notifications,
us_subscribed_notifications,
us_auto_subscribe,
us_auto_subscribe_own_bugs,
us_auto_subscribe_reported_bugs,
us_default_query,
us_org,
isnull(us_signature,'') [us_signature],
isnull(us_forced_project,0) [us_forced_project],
us_created_user
from users
where us_id = 19
2020-04-10 18:37:29 http://localhost:8080/BugTracker/bugs.aspx url=/BugTracker/bugs.aspx
2020-04-10 18:37:29 http://localhost:8080/BugTracker/bugs.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:29 http://localhost:8080/BugTracker/bugs.aspx sql=
declare @us_org int
select @us_org = us_org from users where us_id = 536
select qu_id, qu_desc
from queries
where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
or isnull(qu_user,0) = 536
or isnull(qu_org,0) = @us_org
order by qu_desc
2020-04-10 18:37:29 http://localhost:8080/BugTracker/bugs.aspx sql=
select qu_sql from queries where qu_id = 62
2020-04-10 18:37:29 http://localhost:8080/BugTracker/bugs.aspx 1181 868 1022
2020-04-10 18:37:29 http://localhost:8080/BugTracker/bugs.aspx sql=
select isnull(pr_background_color,'#ffffff') [color], bg_id [id],
bg_short_desc [desc],
bg_reported_date [reported on],
isnull(rpt.us_username,'') [reported by],
isnull(pj_name,'') [project],
isnull(og_name,'') [organization],
isnull(ct_name,'') [category],
isnull(pr_name,'') [priority],
isnull(asg.us_username,'') [assigned to],
isnull(st_name,'') [status],
isnull([Modulo],'') [Modulo],
isnull([Prioridade Cliente],'') [Prioridade Cliente],
isnull([Tempo Gasto],'') [Tempo Gasto]
from bugs
left outer join users rpt on rpt.us_id = bg_reported_user
left outer join users asg on asg.us_id = bg_assigned_to_user
left outer join projects on pj_id = bg_project
left outer join orgs on og_id = bg_org
left outer join categories on ct_id = bg_category
left outer join priorities on pr_id = bg_priority
left outer join statuses on st_id = bg_status
where /* altered - both */ ( bg_project in (4)
and bg_category in (0,1,3,4,6,7,8,9,25)
and bg_status in (0,1,2,4,6,9,10)
and bg_org <> 2
and Modulo <> '98.Equipamentos'
) AND ( (bg_project not in (
select pu_project
from project_user_xref
where pu_user = 536
and pu_permission_level = 0)) ) order by isnull([Modulo],'99'), og_excecao DESC, og_indice_prioridade, og_indice_criticidade desc, og_adimplente DESC, og_contrato DESC, bg_reported_date desc
2020-04-10 18:37:29 http://localhost:8080/BugTracker/bugs.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:37:34 http://localhost:8080/BugTracker/ajax.aspx?bugid=84153 url=/BugTracker/ajax.aspx?bugid=84153
2020-04-10 18:37:34 http://localhost:8080/BugTracker/ajax.aspx?bugid=84153 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:34 http://localhost:8080/BugTracker/ajax.aspx?bugid=84153 sql=
declare @bg_org int
select isnull(pu_permission_level,2),
bg_org
from bugs
left outer join project_user_xref
on pu_project = bg_project
and pu_user = 536
where bg_id = 84153
2020-04-10 18:37:34 http://localhost:8080/BugTracker/ajax.aspx?bugid=84153 sql=
select top 1 substring(bp_comment,0,400), isnull(bp_content_type,'') [bp_content_type] from bug_posts
where bp_bug = 84153
and bp_type in ('received','comment')
and bp_hidden_from_external_users = 0
order by bp_date
2020-04-10 18:37:34 http://localhost:8080/BugTracker/ajax.aspx?bugid=84153 sql=
select top 1 substring(bp_comment,0,400), isnull(bp_content_type,'') [bp_content_type] from bug_posts
where bp_bug = 84153
and bp_type in ('received','comment')
and bp_hidden_from_external_users = 0
order by bp_date
2020-04-10 18:37:35 http://localhost:8080/BugTracker/edit_bug.aspx?id=84153 url=/BugTracker/edit_bug.aspx?id=84153
2020-04-10 18:37:35 http://localhost:8080/BugTracker/edit_bug.aspx?id=84153 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:35 http://localhost:8080/BugTracker/edit_bug.aspx?id=84153 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:37:35 http://localhost:8080/BugTracker/edit_bug.aspx?id=84153 sql=
/* get_bug_datarow */
declare @revision int
set @revision = 0
declare @related int;
select @related = count(1)
from bug_relationships
where re_bug1 = 84153;
select bg_id [id],
bg_short_desc [short_desc],
isnull(ru.us_username,'[deleted user]') [reporter],
isnull(ru.us_email,'') [reporter_email],
case rtrim(ru.us_firstname)
when null then isnull(ru.us_lastname, '')
when '' then isnull(ru.us_lastname, '')
else isnull(ru.us_lastname + ', ' + ru.us_firstname,'')
end [reporter_fullname],
bg_reported_date [reported_date],
datediff(d,bg_reported_date,getdate()) [days_ago],
isnull(lu.us_username,'') [last_updated_user],
case rtrim(lu.us_firstname)
when null then isnull(lu.us_lastname, '')
when '' then isnull(lu.us_lastname, '')
else isnull(lu.us_lastname + ', ' + lu.us_firstname,'')
end [last_updated_fullname],
bg_last_updated_date [last_updated_date],
isnull(bg_project,0) [project],
isnull(pj_name,'[no project]') [current_project],
isnull(bg_org,0) [organization],
isnull(bugorg.og_name,'') [og_name],
isnull(bg_category,0) [category],
isnull(ct_name,'') [category_name],
isnull(bg_priority,0) [priority],
isnull(pr_name,'') [priority_name],
isnull(bg_status,0) [status],
isnull(st_name,'') [status_name],
isnull(bg_user_defined_attribute,0) [udf],
isnull(udf_name,'') [udf_name],
isnull(bg_assigned_to_user,0) [assigned_to_user],
isnull(asg.us_username,'[not assigned]') [assigned_to_username],
case rtrim(asg.us_firstname)
when null then isnull(asg.us_lastname, '[not assigned]')
when '' then isnull(asg.us_lastname, '[not assigned]')
else isnull(asg.us_lastname + ', ' + asg.us_firstname,'[not assigned]')
end [assigned_to_fullname],
isnull(bs_id,0) [subscribed],
case
when
2 <> bg_org
and userorg.og_other_orgs_permission_level < 2
and userorg.og_other_orgs_permission_level < isnull(pu_permission_level,2)
then userorg.og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end [pu_permission_level],
isnull(bg_project_custom_dropdown_value1,'') [bg_project_custom_dropdown_value1],
isnull(bg_project_custom_dropdown_value2,'') [bg_project_custom_dropdown_value2],
isnull(bg_project_custom_dropdown_value3,'') [bg_project_custom_dropdown_value3],
@related [relationship_cnt],
@revision [revision_cnt],
getdate() [snapshot_timestamp]
,[Modulo],[Prioridade Cliente],[Prioridade do Implantador],[Descricao],[Tempo Gasto],[Atendimento],
CASE
WHEN (datediff(d,bg_last_updated_date,getdate()) > 3 AND isnull(bg_status,0) = 5) OR isnull(bg_status,0) = 7 THEN
0
ELSE
1
END AS [AbertoEdicao]
from bugs
inner join users this_user on us_id = 536
inner join orgs userorg on this_user.us_org = userorg.og_id
left outer join user_defined_attribute on bg_user_defined_attribute = udf_id
left outer join projects on bg_project = pj_id
left outer join orgs bugorg on bg_org = bugorg.og_id
left outer join categories on bg_category = ct_id
left outer join priorities on bg_priority = pr_id
left outer join statuses on bg_status = st_id
left outer join users asg on bg_assigned_to_user = asg.us_id
left outer join users ru on bg_reported_user = ru.us_id
left outer join users lu on bg_last_updated_user = lu.us_id
left outer join bug_subscriptions on bs_bug = bg_id and bs_user = 536
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where bg_id = 84153
2020-04-10 18:37:35 http://localhost:8080/BugTracker/edit_bug.aspx?id=84153 sql=
/* drop downs */ select pj_id, pj_name
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where pj_active = 1
and isnull(pu_permission_level,2) not in (0, 1)
order by pj_name;
select og_id, og_name from orgs order by og_name;
select ct_id, ct_name from categories order by ct_sort_seq, ct_name;
select pr_id, pr_name from priorities order by pr_sort_seq, pr_name;
select st_id, st_name from statuses order by st_sort_seq, st_name;
select udf_id, udf_name from user_defined_attribute order by udf_sort_seq, udf_name;
2020-04-10 18:37:35 http://localhost:8080/BugTracker/edit_bug.aspx?id=84153 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:37:35 http://localhost:8080/BugTracker/edit_bug.aspx?id=84153 sql=
select isnull(pj_default_user,0)
from projects
where pj_id = 4
2020-04-10 18:37:35 http://localhost:8080/BugTracker/edit_bug.aspx?id=84153 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:37:35 http://localhost:8080/BugTracker/edit_bug.aspx?id=84153 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84153
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:37:35 http://localhost:8080/BugTracker/ajax.aspx?bugid=84153 url=/BugTracker/ajax.aspx?bugid=84153
2020-04-10 18:37:35 http://localhost:8080/BugTracker/ajax.aspx?bugid=84153 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:35 http://localhost:8080/BugTracker/ajax.aspx?bugid=84153 sql=
declare @bg_org int
select isnull(pu_permission_level,2),
bg_org
from bugs
left outer join project_user_xref
on pu_project = bg_project
and pu_user = 536
where bg_id = 84153
2020-04-10 18:37:35 http://localhost:8080/BugTracker/ajax.aspx?bugid=84153 sql=
select top 1 substring(bp_comment,0,400), isnull(bp_content_type,'') [bp_content_type] from bug_posts
where bp_bug = 84153
and bp_type in ('received','comment')
and bp_hidden_from_external_users = 0
order by bp_date
2020-04-10 18:37:35 http://localhost:8080/BugTracker/ajax.aspx?bugid=84153 sql=
select top 1 substring(bp_comment,0,400), isnull(bp_content_type,'') [bp_content_type] from bug_posts
where bp_bug = 84153
and bp_type in ('received','comment')
and bp_hidden_from_external_users = 0
order by bp_date
2020-04-10 18:37:39 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673295&bug_id=84153 url=/BugTracker/view_attachment.aspx?download=0&id=673295&bug_id=84153
2020-04-10 18:37:39 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673295&bug_id=84153 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:39 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673295&bug_id=84153 sql=
declare @bg_org int
select isnull(pu_permission_level,2),
bg_org
from bugs
left outer join project_user_xref
on pu_project = bg_project
and pu_user = 536
where bg_id = 84153
2020-04-10 18:37:39 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673295&bug_id=84153 sql=
select bp_file, isnull(bp_content_type,'') [bp_content_type] from bug_posts where bp_id = 673295
2020-04-10 18:37:39 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673295&bug_id=84153 sql=
select bpa_content
from bug_post_attachments
where bpa_post = @bp
@bp="673295"
2020-04-10 18:37:48 http://localhost:8080/BugTracker/add_attachment.aspx?id=84153 url=/BugTracker/add_attachment.aspx?id=84153
2020-04-10 18:37:48 http://localhost:8080/BugTracker/add_attachment.aspx?id=84153 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:48 http://localhost:8080/BugTracker/add_attachment.aspx?id=84153 sql=
declare @bg_org int
select isnull(pu_permission_level,2),
bg_org
from bugs
left outer join project_user_xref
on pu_project = bg_project
and pu_user = 536
where bg_id = 84153
2020-04-10 18:37:56 http://localhost:8080/BugTracker/add_attachment.aspx url=/BugTracker/add_attachment.aspx
2020-04-10 18:37:56 http://localhost:8080/BugTracker/add_attachment.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:56 http://localhost:8080/BugTracker/add_attachment.aspx sql=
declare @bg_org int
select isnull(pu_permission_level,2),
bg_org
from bugs
left outer join project_user_xref
on pu_project = bg_project
and pu_user = 536
where bg_id = 84153
2020-04-10 18:37:56 http://localhost:8080/BugTracker/add_attachment.aspx sql=
declare @now datetime
set @now = getdate()
update bugs
set bg_last_updated_date = @now,
bg_last_updated_user = 536
where bg_id = 84153
insert into bug_posts
(bp_type, bp_bug, bp_file, bp_comment, bp_size, bp_date, bp_user, bp_content_type, bp_parent, bp_hidden_from_external_users)
values ('file', 84153, N'CN03030A.RET', N'2342342', 2010, @now, 536, N'text/plain', null, 0)
select scope_identity()
2020-04-10 18:37:56 http://localhost:8080/BugTracker/add_attachment.aspx sql=
insert into bug_post_attachments
(bpa_post, bpa_content)
values (@bp, @bc)
@bp="673629"
@bc=...
2020-04-10 18:37:56 http://localhost:8080/BugTracker/write_posts.aspx?images_inline=null&history_inline=null&id=84153 url=/BugTracker/write_posts.aspx?images_inline=null&history_inline=null&id=84153
2020-04-10 18:37:56 http://localhost:8080/BugTracker/write_posts.aspx?images_inline=null&history_inline=null&id=84153 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:37:56 http://localhost:8080/BugTracker/write_posts.aspx?images_inline=null&history_inline=null&id=84153 sql=
declare @bg_org int
select isnull(pu_permission_level,2),
bg_org
from bugs
left outer join project_user_xref
on pu_project = bg_project
and pu_user = 536
where bg_id = 84153
2020-04-10 18:37:56 http://localhost:8080/BugTracker/write_posts.aspx?images_inline=null&history_inline=null&id=84153 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84153
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:38:05 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673629&bug_id=84153 url=/BugTracker/view_attachment.aspx?download=0&id=673629&bug_id=84153
2020-04-10 18:38:05 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673629&bug_id=84153 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = 'fde4ed6b-e755-4d09-96dd-4d682127266c'
and us_active = 1
2020-04-10 18:38:05 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673629&bug_id=84153 sql=
declare @bg_org int
select isnull(pu_permission_level,2),
bg_org
from bugs
left outer join project_user_xref
on pu_project = bg_project
and pu_user = 536
where bg_id = 84153
2020-04-10 18:38:05 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673629&bug_id=84153 sql=
select bp_file, isnull(bp_content_type,'') [bp_content_type] from bug_posts where bp_id = 673629
2020-04-10 18:38:05 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673629&bug_id=84153 sql=
select bpa_content
from bug_post_attachments
where bpa_post = @bp
@bp="673629"
2020-04-10 18:38:11 http://localhost:8080/BugTracker/view_attachment.aspx?download=0&id=673629&bug_id=84153 sql=
delete from sessions
where se_id = N'fde4ed6b-e755-4d09-96dd-4d682127266c'
or datediff(d, se_date, getdate()) > 2
2020-04-10 18:38:11 http://localhost:8080/BugTracker/default.aspx?msg=logged+off url=/BugTracker/default.aspx?msg=logged+off
2020-04-10 18:38:11 http://localhost:8080/BugTracker/default.aspx?msg=logged+off sql=
select count(1) from users
2020-04-10 18:39:51 http://localhost:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2020-04-10 18:39:51 http://localhost:8080/BugTracker/default.aspx sql=
select count(1) from users
2020-04-10 18:40:10 http://localhost:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2020-04-10 18:40:10 http://localhost:8080/BugTracker/default.aspx sql=
select count(1) from users
2020-04-10 18:40:10 http://localhost:8080/BugTracker/default.aspx sql=
select us_username, us_id, us_password, isnull(us_salt,0) us_salt, us_active
from users
where us_username = N'interno.egestao'
2020-04-10 18:40:10 http://localhost:8080/BugTracker/default.aspx sql=
update users set us_most_recent_login_datetime = getdate() where us_id = 536
2020-04-10 18:40:10 http://localhost:8080/BugTracker/default.aspx sql=
select us_id from users where us_username = N'interno.egestao'
2020-04-10 18:40:10 http://localhost:8080/BugTracker/default.aspx guid=5b913b81-0b9d-42db-bf4b-c39e6056e0fe
2020-04-10 18:40:10 http://localhost:8080/BugTracker/default.aspx sql=
insert into sessions (se_id, se_user) values('5b913b81-0b9d-42db-bf4b-c39e6056e0fe', 536)
2020-04-10 18:40:10 http://localhost:8080/BugTracker/default.aspx AppPath:/BugTracker
2020-04-10 18:40:10 http://localhost:8080/BugTracker/bugs.aspx url=/BugTracker/bugs.aspx
2020-04-10 18:40:10 http://localhost:8080/BugTracker/bugs.aspx sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = '5b913b81-0b9d-42db-bf4b-c39e6056e0fe';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = '5b913b81-0b9d-42db-bf4b-c39e6056e0fe'
and us_active = 1
2020-04-10 18:40:10 http://localhost:8080/BugTracker/bugs.aspx sql=
declare @us_org int
select @us_org = us_org from users where us_id = 536
select qu_id, qu_desc
from queries
where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
or isnull(qu_user,0) = 536
or isnull(qu_org,0) = @us_org
order by qu_desc
2020-04-10 18:40:10 http://localhost:8080/BugTracker/bugs.aspx sql=
select qu_id, qu_sql from queries where qu_id in
(select us_default_query from users where us_id = 536)
2020-04-10 18:40:10 http://localhost:8080/BugTracker/bugs.aspx 1181 868 1022
2020-04-10 18:40:10 http://localhost:8080/BugTracker/bugs.aspx sql=
select isnull(pr_background_color,'#ffffff') [color], bg_id [id],
bg_short_desc [desc],
bg_reported_date [reported on],
isnull(rpt.us_username,'') [reported by],
isnull(pj_name,'') [project],
isnull(og_name,'') [organization],
isnull(ct_name,'') [category],
isnull(pr_name,'') [priority],
isnull(asg.us_username,'') [assigned to],
isnull(st_name,'') [status],
isnull([Modulo],'') [Modulo],
isnull([Prioridade Cliente],'') [Prioridade Cliente],
isnull([Tempo Gasto],'') [Tempo Gasto]
from bugs
left outer join users rpt on rpt.us_id = bg_reported_user
left outer join users asg on asg.us_id = bg_assigned_to_user
left outer join projects on pj_id = bg_project
left outer join orgs on og_id = bg_org
left outer join categories on ct_id = bg_category
left outer join priorities on pr_id = bg_priority
left outer join statuses on st_id = bg_status
where /* altered - both */ ( bg_project in (4)
and bg_category in (0,1,3,4,6,7,8,9,25)
and bg_status in (0,1,2,4,6,9,10)
and bg_org <> 2
and Modulo <> '98.Equipamentos'
) AND ( (bg_project not in (
select pu_project
from project_user_xref
where pu_user = 536
and pu_permission_level = 0)) ) order by isnull([Modulo],'99'), og_excecao DESC, og_indice_prioridade, og_indice_criticidade desc, og_adimplente DESC, og_contrato DESC, bg_reported_date desc
2020-04-10 18:40:10 http://localhost:8080/BugTracker/bugs.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:40:12 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 url=/BugTracker/edit_bug.aspx?id=84196
2020-04-10 18:40:12 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = '5b913b81-0b9d-42db-bf4b-c39e6056e0fe';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = '5b913b81-0b9d-42db-bf4b-c39e6056e0fe'
and us_active = 1
2020-04-10 18:40:12 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:40:12 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* get_bug_datarow */
declare @revision int
set @revision = 0
declare @related int;
select @related = count(1)
from bug_relationships
where re_bug1 = 84196;
select bg_id [id],
bg_short_desc [short_desc],
isnull(ru.us_username,'[deleted user]') [reporter],
isnull(ru.us_email,'') [reporter_email],
case rtrim(ru.us_firstname)
when null then isnull(ru.us_lastname, '')
when '' then isnull(ru.us_lastname, '')
else isnull(ru.us_lastname + ', ' + ru.us_firstname,'')
end [reporter_fullname],
bg_reported_date [reported_date],
datediff(d,bg_reported_date,getdate()) [days_ago],
isnull(lu.us_username,'') [last_updated_user],
case rtrim(lu.us_firstname)
when null then isnull(lu.us_lastname, '')
when '' then isnull(lu.us_lastname, '')
else isnull(lu.us_lastname + ', ' + lu.us_firstname,'')
end [last_updated_fullname],
bg_last_updated_date [last_updated_date],
isnull(bg_project,0) [project],
isnull(pj_name,'[no project]') [current_project],
isnull(bg_org,0) [organization],
isnull(bugorg.og_name,'') [og_name],
isnull(bg_category,0) [category],
isnull(ct_name,'') [category_name],
isnull(bg_priority,0) [priority],
isnull(pr_name,'') [priority_name],
isnull(bg_status,0) [status],
isnull(st_name,'') [status_name],
isnull(bg_user_defined_attribute,0) [udf],
isnull(udf_name,'') [udf_name],
isnull(bg_assigned_to_user,0) [assigned_to_user],
isnull(asg.us_username,'[not assigned]') [assigned_to_username],
case rtrim(asg.us_firstname)
when null then isnull(asg.us_lastname, '[not assigned]')
when '' then isnull(asg.us_lastname, '[not assigned]')
else isnull(asg.us_lastname + ', ' + asg.us_firstname,'[not assigned]')
end [assigned_to_fullname],
isnull(bs_id,0) [subscribed],
case
when
2 <> bg_org
and userorg.og_other_orgs_permission_level < 2
and userorg.og_other_orgs_permission_level < isnull(pu_permission_level,2)
then userorg.og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end [pu_permission_level],
isnull(bg_project_custom_dropdown_value1,'') [bg_project_custom_dropdown_value1],
isnull(bg_project_custom_dropdown_value2,'') [bg_project_custom_dropdown_value2],
isnull(bg_project_custom_dropdown_value3,'') [bg_project_custom_dropdown_value3],
@related [relationship_cnt],
@revision [revision_cnt],
getdate() [snapshot_timestamp]
,[Modulo],[Prioridade Cliente],[Prioridade do Implantador],[Descricao],[Tempo Gasto],[Atendimento],
CASE
WHEN (datediff(d,bg_last_updated_date,getdate()) > 3 AND isnull(bg_status,0) = 5) OR isnull(bg_status,0) = 7 THEN
0
ELSE
1
END AS [AbertoEdicao]
from bugs
inner join users this_user on us_id = 536
inner join orgs userorg on this_user.us_org = userorg.og_id
left outer join user_defined_attribute on bg_user_defined_attribute = udf_id
left outer join projects on bg_project = pj_id
left outer join orgs bugorg on bg_org = bugorg.og_id
left outer join categories on bg_category = ct_id
left outer join priorities on bg_priority = pr_id
left outer join statuses on bg_status = st_id
left outer join users asg on bg_assigned_to_user = asg.us_id
left outer join users ru on bg_reported_user = ru.us_id
left outer join users lu on bg_last_updated_user = lu.us_id
left outer join bug_subscriptions on bs_bug = bg_id and bs_user = 536
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where bg_id = 84196
2020-04-10 18:40:12 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* drop downs */ select pj_id, pj_name
from projects
left outer join project_user_xref on pj_id = pu_project
and pu_user = 536
where pj_active = 1
and isnull(pu_permission_level,2) not in (0, 1)
order by pj_name;
select og_id, og_name from orgs order by og_name;
select ct_id, ct_name from categories order by ct_sort_seq, ct_name;
select pr_id, pr_name from priorities order by pr_sort_seq, pr_name;
select st_id, st_name from statuses order by st_sort_seq, st_name;
select udf_id, udf_name from user_defined_attribute order by udf_sort_seq, udf_name;
2020-04-10 18:40:12 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:40:12 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:40:12 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84196
and a.bp_parent is null
order by a.bp_date desc
2020-04-10 18:40:23 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 url=/BugTracker/edit_bug.aspx?id=84196
2020-04-10 18:40:23 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* check session */
declare @project_admin int
select @project_admin = count(1)
from sessions
inner join project_user_xref on pu_user = se_user
and pu_admin = 1
where se_id = '5b913b81-0b9d-42db-bf4b-c39e6056e0fe';
select us_id, us_admin,
us_username, us_firstname, us_lastname,
isnull(us_email,'') us_email,
isnull(us_bugs_per_page,10) us_bugs_per_page,
isnull(us_forced_project,0) us_forced_project,
us_use_fckeditor,
us_enable_bug_list_popups,
og.*,
isnull(us_forced_project, 0 ) us_forced_project,
isnull(pu_permission_level, 2) pu_permission_level,
@project_admin [project_admin]
from sessions
inner join users on se_user = us_id
inner join orgs og on us_org = og_id
left outer join project_user_xref
on pu_project = us_forced_project
and pu_user = us_id
where se_id = '5b913b81-0b9d-42db-bf4b-c39e6056e0fe'
and us_active = 1
2020-04-10 18:40:23 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
mm.text [default value],
isnull(ccm_dropdown_type,'') [dropdown type],
isnull(ccm_dropdown_vals,'') [vals],
isnull(ccm_sort_seq, sc.colorder) [column order],
sc.colorder
from syscolumns sc
inner join systypes st on st.xusertype = sc.xusertype
inner join sysobjects so on sc.id = so.id
left outer join syscomments mm on sc.cdefault = mm.id
left outer join custom_col_metadata on ccm_colorder = sc.colorder
where so.name = 'bugs'
and st.[name] <> 'sysname'
and sc.name not in ('rowguid',
'bg_id',
'bg_short_desc',
'bg_reported_user',
'bg_reported_date',
'bg_project',
'bg_org',
'bg_category',
'bg_priority',
'bg_status',
'bg_assigned_to_user',
'bg_last_updated_user',
'bg_last_updated_date',
'bg_user_defined_attribute',
'bg_project_custom_dropdown_value1',
'bg_project_custom_dropdown_value2',
'bg_project_custom_dropdown_value3')
order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2020-04-10 18:40:23 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
declare @permission_level int
set @permission_level = -1
select @permission_level = isnull(pu_permission_level,2)
from project_user_xref
where pu_project = 4
and pu_user = 536
if @permission_level = -1 set @permission_level = 2
select @permission_level
2020-04-10 18:40:23 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* users this project */ select us_id, case when 0 = 1 then us_lastname + ', ' + us_firstname else us_username end us_username
from users
inner join orgs on us_org = og_id
where us_active = 1
and og_can_be_assigned_to = 1
and us_id not in
(select pu_user from project_user_xref
where pu_project = 4
and pu_permission_level = 0)
order by us_username;
2020-04-10 18:40:23 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
declare @now datetime
declare @last_updated datetime
select @last_updated = bg_last_updated_date from bugs where bg_id = 84196
if @last_updated > '20200410 18:40:12:083'
begin
-- signal that we did NOT do the update
set @now = '20200410 18:40:12:083'
end
else
begin
-- signal that we DID do the update
set @now = getdate()
update bugs set
bg_short_desc = N'DERMOSENSE',
bg_project = 4,
bg_org = 319,
bg_category = 4,
bg_priority = 1,
bg_assigned_to_user = 868,
bg_status = 1,
bg_last_updated_user = 536,
bg_last_updated_date = @now,
bg_user_defined_attribute = 0,
bg_project_custom_dropdown_value1 = N'',
bg_project_custom_dropdown_value2 = N'',
bg_project_custom_dropdown_value3 = N''
,[Modulo] = N'01.Faturamento',[Prioridade Cliente] = N'1',[Prioridade do Implantador] = N'10',[Descricao] = N'NOTA DE DEVOLUÇÃO',[Tempo Gasto] = N'0',[Atendimento] = N'2o. Nivel'
where bg_id = 84196
end
select @now
2020-04-10 18:40:23 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
declare @pj int
select @pj = bg_project from bugs where bg_id = 84196
delete from bug_subscriptions
where bs_bug = 84196
and bs_user in
(select x.pu_user
from projects
left outer join project_user_xref x on pu_project = pj_id
where pu_project = @pj
and isnull(pu_permission_level,2) = 0)
delete from bug_subscriptions
where bs_bug = 84196
and bs_user in
(select us_id from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84196
where og_other_orgs_permission_level = 0
and bg_org <> og_id)
insert into bug_subscriptions (bs_bug, bs_user)
select 84196, us_id
from users
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84196
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where us_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84196)
insert into bug_subscriptions (bs_bug, bs_user)
select 84196, pj_default_user
from projects
inner join users on pj_default_user = us_id
where pj_id = @pj
and pj_default_user <> 0
and pj_auto_subscribe_default_user = 1
and us_active = 1
and pj_default_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84196)
insert into bug_subscriptions (bs_bug, bs_user)
select 84196, pu_user from project_user_xref
inner join users on pu_user = us_id
inner join orgs on us_org = og_id
inner join bugs on bg_id = 84196
where pu_auto_subscribe = 1
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and pu_project = @pj
and pu_user not in
(select bs_user from bug_subscriptions
where bs_bug = 84196)
insert into bug_subscriptions (bs_bug, bs_user)
select 84196, us_id
from users
inner join bugs on bg_id = 84196
inner join orgs on us_org = og_id
left outer join project_user_xref on pu_project = @pj and pu_user = us_id
where ((us_auto_subscribe_own_bugs = 1 and bg_assigned_to_user = us_id)
or
(us_auto_subscribe_reported_bugs = 1 and bg_reported_user = us_id))
and
case
when
us_org <> bg_org
and og_other_orgs_permission_level < 2
and og_other_orgs_permission_level < isnull(pu_permission_level,2)
then og_other_orgs_permission_level
else
isnull(pu_permission_level,2)
end <> 0
and us_active = 1
and us_id not in
(select bs_user from bug_subscriptions
where bs_bug = 84196)
2020-04-10 18:40:23 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
declare @now datetime
set @now = getdate()
insert into bug_posts
(bp_bug, bp_user, bp_date, bp_comment, bp_comment_search, bp_email_from, bp_type, bp_content_type,
bp_hidden_from_external_users)
values(
84196,
536,
@now,
N'qweqweqweq',
N'qweqweqweq',
null,
N'comment',
N'text/plain',
0)
select scope_identity();
2020-04-10 18:40:23 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
select
isnull(pj_enable_custom_dropdown1,0) [pj_enable_custom_dropdown1],
isnull(pj_enable_custom_dropdown2,0) [pj_enable_custom_dropdown2],
isnull(pj_enable_custom_dropdown3,0) [pj_enable_custom_dropdown3],
isnull(pj_custom_dropdown_label1,'') [pj_custom_dropdown_label1],
isnull(pj_custom_dropdown_label2,'') [pj_custom_dropdown_label2],
isnull(pj_custom_dropdown_label3,'') [pj_custom_dropdown_label3],
isnull(pj_custom_dropdown_values1,'') [pj_custom_dropdown_values1],
isnull(pj_custom_dropdown_values2,'') [pj_custom_dropdown_values2],
isnull(pj_custom_dropdown_values3,'') [pj_custom_dropdown_values3]
from projects where pj_id = 4
2020-04-10 18:40:23 http://localhost:8080/BugTracker/edit_bug.aspx?id=84196 sql=
/* get_bug_posts */
select
a.bp_bug,
a.bp_comment,
isnull(us_username,'') [us_username],
case rtrim(us_firstname)
when null then isnull(us_lastname, '')
when '' then isnull(us_lastname, '')
else isnull(us_lastname + ', ' + us_firstname,'')
end [us_fullname],
isnull(us_email,'') [us_email],
a.bp_date,
datediff(d,a.bp_date,getdate()) [days_ago],
a.bp_id,
a.bp_type,
isnull(a.bp_email_from,'') bp_email_from,
isnull(a.bp_email_to,'') bp_email_to,
isnull(a.bp_file,'') bp_file,
isnull(a.bp_size,0) bp_size,
isnull(a.bp_content_type,'') bp_content_type,
a.bp_hidden_from_external_users,
isnull(ba.bp_file,'') ba_file, -- intentionally ba
isnull(ba.bp_id,'') ba_id, -- intentionally ba
isnull(ba.bp_size,'') ba_size, -- intentionally ba
isnull(ba.bp_content_type,'') ba_content_type -- intentionally ba
from bug_posts a
left outer join users on us_id = a.bp_user
left outer join bug_posts ba on ba.bp_parent = a.bp_id and ba.bp_bug = a.bp_bug
where a.bp_bug = 84196
and a.bp_parent is null
order by a.bp_date desc