From: <abe...@us...> - 2013-03-11 22:01:24
|
Revision: 5987 http://astlinux.svn.sourceforge.net/astlinux/?rev=5987&view=rev Author: abelbeck Date: 2013-03-11 22:01:15 +0000 (Mon, 11 Mar 2013) Log Message: ----------- web interface, SQL-Data tab, add support for sqlite3 CDR's if '/mnt/kd/cdr-sqlite3/master.db' exists Modified Paths: -------------- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php Modified: branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php =================================================================== --- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php 2013-03-11 15:12:51 UTC (rev 5986) +++ branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php 2013-03-11 22:01:15 UTC (rev 5987) @@ -63,6 +63,7 @@ //if the above $directory variable is set to false, you must specify the databases manually in an array as the next variable //if any of the databases do not exist as they are referenced by their path, they will be created automatically +//AstLinux// define database files $databases = array ( array @@ -71,6 +72,10 @@ "name"=> "Asterisk" ) ); +if (is_file('/mnt/kd/cdr-sqlite3/master.db')) { + $databases[] = array( "path"=> "/mnt/kd/cdr-sqlite3/master.db", "name"=> "CDR SQLite3" ); +} +//AstLinux// end of define database files //a list of custom functions that can be applied to columns in the databases //make sure to define every function below if it is not a core PHP function This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <abe...@us...> - 2013-03-12 22:11:43
|
Revision: 5989 http://astlinux.svn.sourceforge.net/astlinux/?rev=5989&view=rev Author: abelbeck Date: 2013-03-12 22:11:33 +0000 (Tue, 12 Mar 2013) Log Message: ----------- web interface, phpliteadmin - don't save password cookies Modified Paths: -------------- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php Modified: branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php =================================================================== --- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php 2013-03-12 18:08:36 UTC (rev 5988) +++ branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php 2013-03-12 22:11:33 UTC (rev 5989) @@ -1287,7 +1287,7 @@ $auth = new Authorization(); //create authorization object //AstLinux// Disable authorization, always grant permission. if(! $auth->isAuthorized()) { - $auth->grant(true); + $auth->grant(false); } // //if(isset($_POST['logout'])) //user has attempted to log out This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <abe...@us...> - 2013-10-03 18:41:27
|
Revision: 6214 http://sourceforge.net/p/astlinux/code/6214 Author: abelbeck Date: 2013-10-03 18:41:24 +0000 (Thu, 03 Oct 2013) Log Message: ----------- web interface, SQL-DATA tab, add support the LDAP database '/mnt/kd/ldap-odbc.sqlite3' file if it exists Modified Paths: -------------- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php Modified: branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php =================================================================== --- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php 2013-10-03 01:04:36 UTC (rev 6213) +++ branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php 2013-10-03 18:41:24 UTC (rev 6214) @@ -99,6 +99,9 @@ if (is_file('/mnt/kd/cdr-sqlite3/master.db')) { $databases[] = array( "path"=> "/mnt/kd/cdr-sqlite3/master.db", "name"=> "CDR SQLite3" ); } +if (is_file('/mnt/kd/ldap-odbc.sqlite3')) { + $databases[] = array( "path"=> "/mnt/kd/ldap-odbc.sqlite3", "name"=> "LDAP" ); +} //AstLinux// end of define database files This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <abe...@us...> - 2013-11-27 22:56:28
|
Revision: 6296 http://sourceforge.net/p/astlinux/code/6296 Author: abelbeck Date: 2013-11-27 22:56:25 +0000 (Wed, 27 Nov 2013) Log Message: ----------- web interface, SQL-Data tab, for 'staff' user, disable actions: table_create, view_create, table_drop, view_drop, table_empty Modified Paths: -------------- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php Modified: branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php =================================================================== --- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php 2013-11-20 15:39:00 UTC (rev 6295) +++ branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php 2013-11-27 22:56:25 UTC (rev 6296) @@ -2181,6 +2181,9 @@ //table actions /////////////////////////////////////////////// create table case "table_create": + if ($global_user === 'staff') { //AstLinux// + $completed = "Failed: Insufficient 'staff' user privileges for action: ".$_GET['action']; + } else { $num = intval($_POST['rows']); $name = $_POST['tablename']; $primary_keys = array(); @@ -2236,9 +2239,13 @@ if(!$result) $error = true; $completed = $lang['tbl']." '".htmlencode($_POST['tablename'])."' ".$lang['created'].".<br/><span style='font-size:11px;'>".htmlencode($query)."</span>"; + } break; /////////////////////////////////////////////// empty table case "table_empty": + if ($global_user === 'staff') { //AstLinux// + $completed = "Failed: Insufficient 'staff' user privileges for action: ".$_GET['action']; + } else { $query = "DELETE FROM ".$db->quote_id($_POST['tablename']); $result = $db->query($query); if(!$result) @@ -2248,30 +2255,43 @@ if(!$result) $error = true; $completed = $lang['tbl']." '".htmlencode($_POST['tablename'])."' ".$lang['emptied'].".<br/><span style='font-size:11px;'>".htmlencode($query)."</span>"; + } break; /////////////////////////////////////////////// create view case "view_create": + if ($global_user === 'staff') { //AstLinux// + $completed = "Failed: Insufficient 'staff' user privileges for action: ".$_GET['action']; + } else { $query = "CREATE VIEW ".$db->quote($_POST['viewname'])." AS ".$_POST['select']; $result = $db->query($query); if(!$result) $error = true; $completed = $lang['view']." '".htmlencode($_POST['viewname'])."' ".$lang['created'].".<br/><span style='font-size:11px;'>".htmlencode($query)."</span>"; + } break; /////////////////////////////////////////////// drop table case "table_drop": + if ($global_user === 'staff') { //AstLinux// + $completed = "Failed: Insufficient 'staff' user privileges for action: ".$_GET['action']; + } else { $query = "DROP TABLE ".$db->quote_id($_POST['tablename']); $result=$db->query($query); if(!$result) $error = true; $completed = $lang['tbl']." '".htmlencode($_POST['tablename'])."' ".$lang['dropped']."."; + } break; /////////////////////////////////////////////// drop view case "view_drop": + if ($global_user === 'staff') { //AstLinux// + $completed = "Failed: Insufficient 'staff' user privileges for action: ".$_GET['action']; + } else { $query = "DROP VIEW ".$db->quote_id($_POST['viewname']); $result=$db->query($query); if(!$result) $error = true; $completed = $lang['view']." '".htmlencode($_POST['viewname'])."' ".$lang['dropped']."."; + } break; /////////////////////////////////////////////// rename table case "table_rename": This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <abe...@us...> - 2015-08-06 20:38:48
|
Revision: 7184 http://sourceforge.net/p/astlinux/code/7184 Author: abelbeck Date: 2015-08-06 20:38:46 +0000 (Thu, 06 Aug 2015) Log Message: ----------- web interface, SQL-Data tab, phpliteadmin upstream regression fix Ref: https://bitbucket.org/phpliteadmin/public/commits/b10da53486856961b9c1219168cab412e5855e84?at=master Modified Paths: -------------- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php Modified: branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php =================================================================== --- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php 2015-08-06 15:39:29 UTC (rev 7183) +++ branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php 2015-08-06 20:38:46 UTC (rev 7184) @@ -3204,7 +3204,7 @@ echo "<span style='font-size:11px;'>".htmlencode($master[0]['sql'])."</span>"; echo "</div>"; echo "<br/>"; - if($target_table_type == 'view') + if($target_table_type != 'view') { echo "<br/><hr/><br/>"; //$query = "SELECT * FROM sqlite_master WHERE type='index' AND tbl_name='".$target_table."'"; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |