summaryrefslogtreecommitdiff
path: root/www/asterisk-stat/files
diff options
context:
space:
mode:
Diffstat (limited to 'www/asterisk-stat/files')
-rw-r--r--www/asterisk-stat/files/cdr_mysql.tbl24
-rw-r--r--www/asterisk-stat/files/cdr_pgsql.tbl23
-rw-r--r--www/asterisk-stat/files/mysql__patch-cdr.php11
-rw-r--r--www/asterisk-stat/files/mysql__patch-defines.php27
-rw-r--r--www/asterisk-stat/files/patch-export_pdf.php11
-rw-r--r--www/asterisk-stat/files/pgsql__patch-call.log.php9
-rw-r--r--www/asterisk-stat/files/pgsql__patch-cdr.php11
-rw-r--r--www/asterisk-stat/files/pgsql__patch-defines.php23
-rw-r--r--www/asterisk-stat/files/pkg-message.in5
9 files changed, 0 insertions, 144 deletions
diff --git a/www/asterisk-stat/files/cdr_mysql.tbl b/www/asterisk-stat/files/cdr_mysql.tbl
deleted file mode 100644
index 78a5f2021e54..000000000000
--- a/www/asterisk-stat/files/cdr_mysql.tbl
+++ /dev/null
@@ -1,24 +0,0 @@
-USE asterisk;
-
-CREATE TABLE cdr (
- calldate datetime NOT NULL default '0000-00-00 00:00:00',
- clid varchar(80) NOT NULL default '',
- src varchar(80) NOT NULL default '',
- dst varchar(80) NOT NULL default '',
- dcontext varchar(80) NOT NULL default '',
- channel varchar(80) NOT NULL default '',
- dstchannel varchar(80) NOT NULL default '',
- lastapp varchar(80) NOT NULL default '',
- lastdata varchar(80) NOT NULL default '',
- duration int(11) NOT NULL default '0',
- billsec int(11) NOT NULL default '0',
- disposition varchar(45) NOT NULL default '',
- amaflags int(11) NOT NULL default '0',
- accountcode varchar(20) NOT NULL default '',
- uniqueid varchar(32) NOT NULL default '',
- userfield varchar(255) NOT NULL default ''
-);
-
-ALTER TABLE `cdr` ADD INDEX ( `calldate` );
-ALTER TABLE `cdr` ADD INDEX ( `dst` );
-ALTER TABLE `cdr` ADD INDEX ( `accountcode` );
diff --git a/www/asterisk-stat/files/cdr_pgsql.tbl b/www/asterisk-stat/files/cdr_pgsql.tbl
deleted file mode 100644
index b845badb4e99..000000000000
--- a/www/asterisk-stat/files/cdr_pgsql.tbl
+++ /dev/null
@@ -1,23 +0,0 @@
-
-CREATE TABLE cdr (
- calldate timestamp with time zone DEFAULT now() NOT NULL,
- clid varchar(80) NOT NULL default '',
- src varchar(80) NOT NULL default '',
- dst varchar(80) NOT NULL default '',
- dcontext varchar(80) NOT NULL default '',
- channel varchar(80) NOT NULL default '',
- dstchannel varchar(80) NOT NULL default '',
- lastapp varchar(80) NOT NULL default '',
- lastdata varchar(80) NOT NULL default '',
- duration bigint NOT NULL default '0',
- billsec bigint NOT NULL default '0',
- disposition varchar(45) NOT NULL default '',
- amaflags bigint NOT NULL default '0',
- accountcode varchar(20) NOT NULL default '',
- uniqueid varchar(32) NOT NULL default '',
- userfield varchar(255) NOT NULL default ''
-);
-
-CREATE INDEX calldate_ind ON cdr USING btree (calldate);
-CREATE INDEX dst_ind ON cdr USING btree (dst);
-CREATE INDEX accountcode_ind ON cdr USING btree (accountcode);
diff --git a/www/asterisk-stat/files/mysql__patch-cdr.php b/www/asterisk-stat/files/mysql__patch-cdr.php
deleted file mode 100644
index 339406825991..000000000000
--- a/www/asterisk-stat/files/mysql__patch-cdr.php
+++ /dev/null
@@ -1,11 +0,0 @@
---- cdr.php.orig Mon Mar 7 19:20:48 2005
-+++ cdr.php Thu Jul 20 23:47:46 2006
-@@ -36,7 +36,7 @@
- <head>
- <title>Asterisk CDR</title>
- <meta http-equiv="Content-Type" content="text/html">
-- <link rel="stylesheet" type="text/css" media="print" href="/css/print.css">
-+ <link rel="stylesheet" type="text/css" media="print" href="css/print.css">
- <SCRIPT LANGUAGE="JavaScript" SRC="./encrypt.js"></SCRIPT>
- <style type="text/css" media="screen">
- @import url("css/layout.css");
diff --git a/www/asterisk-stat/files/mysql__patch-defines.php b/www/asterisk-stat/files/mysql__patch-defines.php
deleted file mode 100644
index 3a90bfc5be4e..000000000000
--- a/www/asterisk-stat/files/mysql__patch-defines.php
+++ /dev/null
@@ -1,27 +0,0 @@
---- lib/defines.php.orig Tue Mar 8 04:07:23 2005
-+++ lib/defines.php Thu Jul 20 21:51:35 2006
-@@ -1,7 +1,7 @@
- <?php
-
- define ("WEBROOT", "http://domainname.com/asterisk-stat/");
--define ("FSROOT", "/var/www/html/HTTP2/Asterisk/asterisk-stat-v2/");
-+define ("FSROOT", "/usr/local/www/asterisk-stat/");
-
-
-
-@@ -9,11 +9,11 @@
-
-
- define ("HOST", "localhost");
--define ("PORT", "5432");
--define ("USER", "postgres");
-+define ("PORT", "3306");
-+define ("USER", "asterisk");
- define ("PASS", "");
--define ("DBNAME", "cdrasterisk");
--define ("DB_TYPE", "postgres"); // mysql or postgres
-+define ("DBNAME", "asterisk");
-+define ("DB_TYPE", "mysql"); // mysql or postgres
-
-
- define ("DB_TABLENAME", "cdr");
diff --git a/www/asterisk-stat/files/patch-export_pdf.php b/www/asterisk-stat/files/patch-export_pdf.php
deleted file mode 100644
index b40656fedf02..000000000000
--- a/www/asterisk-stat/files/patch-export_pdf.php
+++ /dev/null
@@ -1,11 +0,0 @@
---- export_pdf.php.orig Thu Mar 3 00:11:32 2005
-+++ export_pdf.php Thu Jul 20 23:50:45 2006
-@@ -2,7 +2,7 @@
- include_once(dirname(__FILE__) . "/lib/defines.php");
- include_once(dirname(__FILE__) . "/lib/Class.Table.php");
- define(FPDF_FONTPATH,dirname(__FILE__).'/lib/font/');
--include_once(dirname(__FILE__) . "/lib/fpdf.php');
-+include_once(dirname(__FILE__) . "/lib/fpdf.php");
-
- session_start();
-
diff --git a/www/asterisk-stat/files/pgsql__patch-call.log.php b/www/asterisk-stat/files/pgsql__patch-call.log.php
deleted file mode 100644
index 32dee4bf9ba0..000000000000
--- a/www/asterisk-stat/files/pgsql__patch-call.log.php
+++ /dev/null
@@ -1,9 +0,0 @@
---- call-log.php.orig 2012-04-05 10:48:18.000000000 +0300
-+++ call-log.php 2012-04-05 10:48:29.000000000 +0300
-@@ -229,7 +229,7 @@
-
-
- /************************/
-- $QUERY = "SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(calldate,1,10)"; //extract(DAY from calldate)
-+ $QUERY = "SELECT cast(calldate as date) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY cast(calldate as date) order by 1 desc"; //extract(DAY from calldate)
- //echo "$QUERY";
diff --git a/www/asterisk-stat/files/pgsql__patch-cdr.php b/www/asterisk-stat/files/pgsql__patch-cdr.php
deleted file mode 100644
index 339406825991..000000000000
--- a/www/asterisk-stat/files/pgsql__patch-cdr.php
+++ /dev/null
@@ -1,11 +0,0 @@
---- cdr.php.orig Mon Mar 7 19:20:48 2005
-+++ cdr.php Thu Jul 20 23:47:46 2006
-@@ -36,7 +36,7 @@
- <head>
- <title>Asterisk CDR</title>
- <meta http-equiv="Content-Type" content="text/html">
-- <link rel="stylesheet" type="text/css" media="print" href="/css/print.css">
-+ <link rel="stylesheet" type="text/css" media="print" href="css/print.css">
- <SCRIPT LANGUAGE="JavaScript" SRC="./encrypt.js"></SCRIPT>
- <style type="text/css" media="screen">
- @import url("css/layout.css");
diff --git a/www/asterisk-stat/files/pgsql__patch-defines.php b/www/asterisk-stat/files/pgsql__patch-defines.php
deleted file mode 100644
index af94b2f5e686..000000000000
--- a/www/asterisk-stat/files/pgsql__patch-defines.php
+++ /dev/null
@@ -1,23 +0,0 @@
---- lib/defines.php.orig Tue Mar 8 04:07:23 2005
-+++ lib/defines.php Sat Jun 23 07:26:44 2007
-@@ -1,7 +1,7 @@
- <?php
-
- define ("WEBROOT", "http://domainname.com/asterisk-stat/");
--define ("FSROOT", "/var/www/html/HTTP2/Asterisk/asterisk-stat-v2/");
-+define ("FSROOT", "/usr/local/www/asterisk-stat/");
-
-
-
-@@ -10,9 +10,9 @@
-
- define ("HOST", "localhost");
- define ("PORT", "5432");
--define ("USER", "postgres");
-+define ("USER", "asterisk");
- define ("PASS", "");
--define ("DBNAME", "cdrasterisk");
-+define ("DBNAME", "asterisk");
- define ("DB_TYPE", "postgres"); // mysql or postgres
-
-
diff --git a/www/asterisk-stat/files/pkg-message.in b/www/asterisk-stat/files/pkg-message.in
deleted file mode 100644
index 761a90bcb51e..000000000000
--- a/www/asterisk-stat/files/pkg-message.in
+++ /dev/null
@@ -1,5 +0,0 @@
-===> asterisk-stat:
-
- **** NOTE ****
- Before the first use of Asterisk-stat, copy defines.php-dist to defines.php
- in %%ASTERISKDIR%%
generated by cgit v1.2.3 (git 2.25.1) at 2025-11-10 17:16:59 +0000