Remove outdated IPZilla scripts
Change-Id: I95c5329a3108892394d3f2f9bc432600afa8f881
diff --git a/export/cq_stats.csv.php b/export/cq_stats.csv.php
deleted file mode 100644
index 74fd6cf..0000000
--- a/export/cq_stats.csv.php
+++ /dev/null
@@ -1,58 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2014 Eclipse Foundation and others.
-* All rights reserved. This program and the accompanying materials
-* are made available under the terms of the Eclipse Public License v1.0
-* which accompanies this distribution, and is available at
-* http://www.eclipse.org/legal/epl-v10.html
-*
-* Contributors:
-* Wayne Beaton (Eclipse Foundation)- initial API and implementation
-*******************************************************************************/
-
-/*
- * Export committer information from the Foundation database. The information
- * includes the name, committer id, email addresses, and project affiliations.
- *
- * e.g. http://www.eclipse.org/projects/export/cq_stats.csv.php
- *
- * INTERNAL USE ONLY: restricted to callers within the Eclipse Foundation.
- */
-require_once(dirname(__FILE__) . "/../../eclipse.org-common/system/app.class.php");
-$App = new App();
-require_once(dirname(__FILE__) . "/../classes/common.php");
-require_once(dirname(__FILE__) . "/../classes/debug.php");
-
-mustBeEclipseFoundationCaller();
-
-$sql = "select
- b.bug_id,
- p.name as tlp,
- c.name as project,
- b.short_desc as summary,
- if(b.short_desc regexp '\((Orbit|PB( Orbit)?)\s*\d*\)', 'piggyback', kd.name) as type,
- b.bug_severity as state,
- b.bug_status as status,
- b.resolution as resolution,
- date(b.creation_ts) as created,
- max(date(pmc.bug_when)) as pmc,
- max(date(checkin.bug_when)) as checkin,
- max(date(approved.bug_when)) as approved
- from bugs as b
- join products as p on b.product_id=p.id
- join components as c on b.component_id=c.id
- join keywords as k on b.bug_id=k.bug_id
- join keyworddefs as kd on k.keywordid=kd.id and kd.name in ('thirdparty', 'projectcode')
- left join bugs_activity as pmc on b.bug_id=pmc.bug_id and pmc.added in ('PMC_Approved+')
- left join bugs_activity as checkin on b.bug_id=checkin.bug_id and checkin.added in ('checkin', 'checkintocvs')
- left join bugs_activity as approved on b.bug_id=approved.bug_id and approved.added in ('approved', 'approved_all_projects')
- group by b.bug_id
- order by tlp, checkin desc";
-
-$result = $App->ipzilla_sql($sql);
-
-$fp = fopen('php://output', 'w');
-while ($row=mysql_fetch_assoc($result)) fputcsv($fp, $row);
-fclose($fp);
-
-?>
\ No newline at end of file
diff --git a/export/cq_summary.json.php b/export/cq_summary.json.php
deleted file mode 100644
index 77e187c..0000000
--- a/export/cq_summary.json.php
+++ /dev/null
@@ -1,69 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2014 Eclipse Foundation and others.
-* All rights reserved. This program and the accompanying materials
-* are made available under the terms of the Eclipse Public License v1.0
-* which accompanies this distribution, and is available at
-* http://www.eclipse.org/legal/epl-v10.html
-*
-* Contributors:
-* Wayne Beaton (Eclipse Foundation)- initial API and implementation
-*******************************************************************************/
-
-/*
- * Export committer information from the Foundation database. The information
- * includes the name, committer id, email addresses, and project affiliations.
- *
- * e.g. http://www.eclipse.org/projects/export/cq_stats.csv.php
- *
- * INTERNAL USE ONLY: restricted to callers within the Eclipse Foundation.
- */
-require_once(dirname(__FILE__) . "/../../eclipse.org-common/system/app.class.php");
-$App = new App();
-require_once(dirname(__FILE__) . "/../classes/common.php");
-require_once(dirname(__FILE__) . "/../classes/debug.php");
-
-mustBeEclipseFoundationCaller();
-
-$sql = "select
- name,
- type, count(*) as count,
- avg(datediff(approved, start)) as avg_approval,
- stddev(datediff(approved, start)) as stdev_approval,
- max(datediff(approved, start)) as max_approval,
- min(datediff(approved, start)) as min_approval,
- avg(datediff(checkin, start)) as avg_checkin,
- stddev(datediff(checkin, start)) as stdev_checkin,
- max(datediff(checkin, start)) as max_checkin,
- min(datediff(checkin, start)) as min_checkin
-from
- (select
- p.name,
- b.bug_id,
- if(b.short_desc regexp '\((Orbit|PB( Orbit)?)\s*\d*\)', 'piggyback', kd.name) as type,
- date(b.creation_ts) as created,
- if (max(date(pmc.bug_when)) is null, date(b.creation_ts), max(date(pmc.bug_when))) as start,
- max(date(pmc.bug_when)) as pmc,
- max(date(checkin.bug_when)) as checkin,
- max(date(approved.bug_when)) as approved
- from bugs as b
- join products as p on b.product_id = p.id
- join keywords as k on b.bug_id=k.bug_id
- join keyworddefs as kd on k.keywordid=kd.id and kd.name in ('thirdparty', 'projectcode')
- left join bugs_activity as pmc on b.bug_id=pmc.bug_id and pmc.added in ('PMC_Approved+')
- left join bugs_activity as checkin on b.bug_id=checkin.bug_id and checkin.added in ('checkin', 'checkintocvs')
- left join bugs_activity as approved on b.bug_id=approved.bug_id and approved.added in ('approved', 'approved_all_projects')
- group by p.id, b.bug_id) as stats
-#where approved > DATE_SUB(now(), INTERVAL 3 MONTH)
-group by name, type";
-
-$result = $App->ipzilla_sql($sql);
-
-$data = array();
-
-while ($row=mysql_fetch_assoc($result)) {
- $data[$row['name']][$row['type']] = $row;
-}
-
-echo json_encode($data);
-?>
\ No newline at end of file
diff --git a/export/cqs.csv.php b/export/cqs.csv.php
deleted file mode 100644
index 13c2d02..0000000
--- a/export/cqs.csv.php
+++ /dev/null
@@ -1,72 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2017 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *******************************************************************************/
-
-/*
- * Export CQ information from IPZilla in CSV format.
- *
- * e.g. http://www.eclipse.org/projects/export/cqs.csv.php
- *
- * INTERNAL USE ONLY: restricted to callers within the Eclipse Foundation.
- */
-require_once(dirname(__FILE__) . "/../../eclipse.org-common/system/app.class.php");
-$App = new App();
-require_once(dirname(__FILE__) . "/../classes/database.inc");
-require_once(dirname(__FILE__) . "/../classes/common.php");
-require_once(dirname(__FILE__) . "/../classes/debug.php");
-
-mustBeEclipseFoundationCaller();
-
-$sql = "
- select
- b.bug_id as id,
- c.name as project,
- b.short_desc as description,
- b.cf_type as type,
- date(b.creation_ts) as created,
- b.bug_status as status,
- b.resolution as resolution,
- b.bug_severity as state,
- b.cf_license as license,
- group_concat(kd.name) as keywords,
- l.thetext as comment
- from bugs as b
- join components as c on b.component_id = c.id
- join (
- select
- bug_id, min(comment_id) as comment_id
- from longdescs group by bug_id
- ) as s on b.bug_id=s.bug_id
- join longdescs as l on s.bug_id=l.bug_id and s.comment_id=l.comment_id
- join keywords as k on b.bug_id=k.bug_id
- join keyworddefs as kd on k.keywordid=kd.id
- group by b.bug_id";
-
-$columns = array('id','project','description','type','created','status','resolution','state','licenses','keywords','projecturl','sourceurl');
-
-$fp = fopen('php://output', 'w');
-fputcsv($fp, $columns);
-
-query('ipzilla', $sql, array(), function($row) use (&$fp, &$columns) {
- // Grab the 'comment' row and use it to compute some
- // other values and remove it from the array to avoid it being included
- // in the output.
- $comment = $row['comment'];
- unset($row['comment']);
-
- // The "Project URL" and "Source URL" values are represented in
- // the text of the first comment on a CQ.
- $row['projecturl'] = (preg_match('/^Project URL:\s*(\S+)$/m', $comment, $matches)) ? trim($matches[1]) : '';
- $row['sourceurl'] = (preg_match('/^Source URL:\s*(\S+)$/m', $comment, $matches)) ? trim($matches[1]) : '';
-
- fputcsv($fp, $row);
-});
-
-fclose($fp);
-
-?>
\ No newline at end of file
