Menu
▾
▴
phpliteadmin-commits — Automatically generated list of commits to the CVS Repository
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(36) |
Sep
|
Oct
|
Nov
|
Dec
|
|---|
|
From: Eric F. <wg...@us...> - 2004-08-04 21:06:34
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11167/style Modified Files: navbar.xsl Added Files: db_structure.css db_structure.xsl Log Message: Added DB Structure Index: navbar.xsl =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/style/navbar.xsl,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** navbar.xsl 4 Aug 2004 01:53:02 -0000 1.1 --- navbar.xsl 4 Aug 2004 21:06:24 -0000 1.2 *************** *** 2,5 **** --- 2,7 ---- <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> + <xsl:output method="html"/> + <xsl:template match="/"> *************** *** 12,16 **** <ul> <xsl:for-each select="databases/database"> ! <li><xsl:value-of select="@name" /> <ul> <li><xsl:value-of select="table" /></li> --- 14,22 ---- <ul> <xsl:for-each select="databases/database"> ! <li><a> ! <xsl:attribute name="href">./db.php5?db=<xsl:value-of select="@name" /></xsl:attribute> ! <xsl:attribute name="target">main</xsl:attribute> ! <xsl:value-of select="@name" /> ! </a> <ul> <li><xsl:value-of select="table" /></li> --- NEW FILE: db_structure.css --- body { font-family: Verdana, Arial, Helvetica, Tahoma, sans-serif; font-size: 10pt; background: #EEFDEE; color: black; } h1 { font-size: 14pt; font-weight: bold; } #nav { width: 100%; height: 25px; font-size: 80%; text-align: center; } .nav_option { float: left; width: 20%; padding: 5px; margin: 5px; border: 1px #000000 solid; } #tables { width: 100%; text-align: center; } .table_row { width: 100%; height: 20px; border-width: 1px 0px 1px 0px; border-color: #000000; border-style: solid; } .checkbox { float: left; width: 5%; height: 20px; border-width: 0px 1px 0px 1px; border-color: #000000; border-style: solid; } .table { float: left; width: 25%; height: 20px; border-width: 0px 1px 0px 0px; border-color: #000000; border-style: solid; text-align: left; } .structure { float: left; width: 10%; height: 20px; border-width: 0px 1px 0px 0px; border-color: #000000; border-style: solid; text-align: center; } .browse { float: left; width: 10%; height: 20px; border-width: 0px 1px 0px 0px; border-color: #000000; border-style: solid; text-align: center; } .input { float: left; width: 10%; height: 20px; border-width: 0px 1px 0px 0px; border-color: #000000; border-style: solid; text-align: center; } .empty { float: left; width: 10%; height: 20px; border-width: 0px 1px 0px 0px; border-color: #000000; border-style: solid; text-align: center; } .drop { float: left; width: 8%; height: 20px; border-width: 0px 1px 0px 0px; border-color: #000000; border-style: solid; text-align: center; } .records { float: left; width: 10%; height: 20px; border-width: 0px 1px 0px 0px; border-color: #000000; border-style: solid; text-align: right; } .size { float: left; width: 10%; height: 20px; border-width: 0px 1px 0px 0px; border-color: #000000; border-style: solid; text-align: right; } --- NEW FILE: db_structure.xsl --- <?xml version="1.0" encoding="ISO-8859-1" ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html lang="en" dir="ltr"> <head> <title>phpLiteAdmin - Database Structure</title> <link rel="stylesheet" href="style/db_structure.css" type="text/css" /> </head> <body> <h1>Database: <xsl:value-of select="tables/table/db" /></h1> <div id="nav"> <div class="nav_option"> <a><xsl:attribute name="href">db.php5?db=<xsl:value-of select="tables/table/db" /></xsl:attribute>Structure</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">db.php5?mode=sql&db=<xsl:value-of select="tables/table/db" /></xsl:attribute>SQL</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">db.php5?mode=export&db=<xsl:value-of select="tables/table/db" /></xsl:attribute>Export</a> </div> <div class="nav_option"> <a><xsl:attribute name="href">db.php5?mode=drop&db=<xsl:value-of select="tables/table/db" /></xsl:attribute>Drop</a> </div> </div> <br /> <div id="tables"> <xsl:for-each select="tables/table"> <div class="table_row"> <div class="checkbox"><input type="checkbox"><xsl:attribute name="name"><xsl:value-of select="name" /></xsl:attribute></input></div> <div class="table"><b><xsl:value-of select="name" /></b></div> <div class="structure"><a><xsl:attribute name="href">./tbl.php5?mode=structure&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>structure</a></div> <div class="browse"><a><xsl:attribute name="href">./tbl.php5?mode=browse&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>browse</a></div> <div class="input"><a><xsl:attribute name="href">./tbl.php5?mode=input&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>input</a></div> <div class="empty"><a><xsl:attribute name="href">./tbl.php5?mode=empty&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>empty</a></div> <div class="drop"><a><xsl:attribute name="href">./tbl.php5?mode=drop&tbl=<xsl:value-of select="name" />&db=<xsl:value-of select="db" /></xsl:attribute>drop</a></div> <div class="records">records?</div> <div class="size">size?</div> </div> <br /> </xsl:for-each> </div> </body> </html> </xsl:template> </xsl:stylesheet> |
|
From: Eric F. <wg...@us...> - 2004-08-04 21:06:34
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11167 Modified Files: index.php5 navbar.php5 Added Files: db.php5 Log Message: Added DB Structure Index: navbar.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/navbar.php5,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** navbar.php5 4 Aug 2004 01:53:02 -0000 1.1 --- navbar.php5 4 Aug 2004 21:06:24 -0000 1.2 *************** *** 26,30 **** /* var_dump( $Database ); ! $Database->query( 'CREATE TABLE foo (bar varchar(10))' ); $Database->query( "INSERT INTO foo VALUES ('fnord')" ); $result = $Database->query( 'SELECT bar FROM foo' ); --- 26,30 ---- /* var_dump( $Database ); ! $Database->query( 'CREATE TABLE foo3 (bar varchar(10))' ); $Database->query( "INSERT INTO foo VALUES ('fnord')" ); $result = $Database->query( 'SELECT bar FROM foo' ); Index: index.php5 =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/index.php5,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** index.php5 4 Aug 2004 01:53:02 -0000 1.1 --- index.php5 4 Aug 2004 21:06:24 -0000 1.2 *************** *** 20,25 **** </head> <frameset cols="150,*" rows="*"> ! <frame src="navbar.php5" frameborder="1" scrolling="auto" id="navbar" /> ! <frame src="main.php5" frameborder="0" scrolling="auto" id="main" /> </frameset> </html> \ No newline at end of file --- 20,25 ---- </head> <frameset cols="150,*" rows="*"> ! <frame src="navbar.php5" frameborder="1" scrolling="auto" id="navbar" name="navbar" /> ! <frame src="main.php5" frameborder="0" scrolling="auto" id="main" name="main" /> </frameset> </html> \ No newline at end of file --- NEW FILE: db.php5 --- <?php /** * @name phpLiteAdmin * @copyright 2004 phpLiteAdmin Team */ /** * $Id: db.php5,v 1.1 2004/08/04 21:06:24 wgeric Exp $ * Stucture for databases */ if ( isset($_GET['db']) || isset($_POST['db']) ) { $db_path = ( $_GET['db'] ) ? $_GET['db'] : $_POST['db']; if ( !preg_match("/db\//i", $db_path) ) { $db_path = 'db/' . $db_path; } if ( !preg_match("/\.sqlite/i", $db_path) ) { $db_path .= '.sqlite'; } $db_name = preg_replace("/db\/(.*?)\.sqlite/i", "\\1", $db_path); } else { header( 'Location: main.php5' ); exit; } if ( isset($_GET['mode']) || isset($_POST['mode']) ) { $mode = ( $_GET['mode'] ) ? $_GET['mode'] : $_POST['mode']; } else { $mode = ''; } header( 'Content-Type: text/xml; charset=UTF-8' ); include( 'lib/sqlite.php5' ); $Database = new Database( $db_path, 0777, $sqlite_error ); print '<?xml version="1.0" encoding="UTF-8" ?>' . "\n"; print '<?xml-stylesheet href="style/db_structure.xsl" type="text/xsl" ?>' . "\n"; if( $Database->connected ) { switch( $mode ) { // execute a sql query case 'sql': break; // export the database case 'export': break; //drop the database case 'drop': break; // list tables, the db structure default: print "<tables>\n"; $sql = "SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY name ASC"; $result = $Database->query( $sql ); while( $row = $Database->fetch_array( $result ) ) { print "\t<table>" . "\n"; print "\t\t<name>" . $row['name'] . "</name>\n"; print "\t\t<db>" . $db_name . "</db>\n"; print "\t</table>\n"; } print "</tables>\n"; break; } } else { die( $sqlite_error ); } ?> |
|
From: Eric F. <wg...@us...> - 2004-08-04 21:06:32
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11167/db Modified Files: mysqlitedb.sqlite Log Message: Added DB Structure Index: mysqlitedb.sqlite =================================================================== RCS file: /cvsroot/phpliteadmin/phpLiteAdmin/db/mysqlitedb.sqlite,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 Binary files /tmp/cvsJZa8HG and /tmp/cvs4uUgkx differ |
|
From: Eric F. <wg...@us...> - 2004-08-04 01:53:11
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25296/style Added Files: main.css main.xsl navbar.css navbar.xsl Log Message: Initial Commit --- NEW FILE: main.css --- body { font-family: Verdana, Arial, Helvetica, Tahoma, sans-serif; font-size: 10pt; background: #EEFDEE; color: black; } h1 { font-size: 14pt; font-weight: bold; } --- NEW FILE: navbar.xsl --- <?xml version="1.0" encoding="ISO-8859-1" ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html lang="en" dir="ltr"> <head> <title>phpLiteAdmin - Navigation Bar</title> <link rel="stylesheet" href="style/navbar.css" type="text/css" /> </head> <body> <ul> <xsl:for-each select="databases/database"> <li><xsl:value-of select="@name" /> <ul> <li><xsl:value-of select="table" /></li> </ul> </li> </xsl:for-each> </ul> </body> </html> </xsl:template> </xsl:stylesheet> --- NEW FILE: main.xsl --- <?xml version="1.0" encoding="ISO-8859-1" ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html lang="en" dir="ltr"> <head> <title>phpLiteAdmin - Content Page</title> <link rel="stylesheet" href="style/main.css" type="text/css" /> </head> <body> <h1>Welcome to phpLiteAdmin</h1> <strong>SQLite <xsl:value-of select="content/details/version" /></strong> </body> </html> </xsl:template> </xsl:stylesheet> --- NEW FILE: navbar.css --- body { font-family: Verdana, Arial, Helvetica, Tahoma, sans-serif; font-size: 10pt; background: #DDEDFD; color: black; margin: 0px; padding: 0px; } ul li { display: list-item; list-style-type: disc; } ul li ul li { display: list-item; list-style-type: square; } |
|
From: Eric F. <wg...@us...> - 2004-08-04 01:53:11
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/lib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25296/lib Added Files: sqlite.php5 Log Message: Initial Commit --- NEW FILE: sqlite.php5 --- <?php /** * @name phpLiteAdmin * @copyright 2004 phpLiteAdmin Team */ /** * $Id: sqlite.php5,v 1.1 2004/08/04 01:53:02 wgeric Exp $ * Provides wrapper for SQLite database access */ class Database { /** * Constructor * * @param string $database Database name * @param integer $perms File permissions * @param string $error Error message */ function __construct( $database, $perms, $error ) { $this->database = $database; $this->perms = $perms; $this->error = $error; $this->connection = sqlite_open( $this->database, $this->perms, $this->error ); if( $this->connection ) { $this->connected = TRUE; } else { $this->connected = FALSE; } } /** * Public variables */ public $database = ''; public $error = ''; public $connected = FALSE; /** * Protected variables */ protected $perms = 0777; protected $connection = FALSE; /** * Public variables */ private $var; /** * Database query * * @param string $query Database query */ function query( $query ) { if( !( $this->connected ) ) { return FALSE; } return sqlite_query( $this->connection, $query ); } /** * Fetch data from database in an array * * @param resource $result Resource handle from query * @param integer $result_type Type of array data returned * @param boolean $decode_binary Whether or not to decode binary data */ function fetch_array( $result, $result_type = SQLITE_ASSOC, $decode_binary = TRUE ) { if( !( $this->connected ) ) { return FALSE; } return sqlite_fetch_array( $result, $result_type, $decode_binary ); } /** * Destructor */ function __destruct() { if( $this->connected ) { sqlite_close( $this->connection ); $this->connected = FALSE; } } } ?> |
|
From: Eric F. <wg...@us...> - 2004-08-04 01:53:11
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25296 Added Files: index.php5 main.php5 navbar.php5 Log Message: Initial Commit --- NEW FILE: navbar.php5 --- <?php /** * @name phpLiteAdmin * @copyright 2004 phpLiteAdmin Team */ /** * $Id: navbar.php5,v 1.1 2004/08/04 01:53:02 wgeric Exp $ * Side navigation panel */ header( 'Content-Type: text/xml; charset=UTF-8' ); include( 'lib/sqlite.php5' ); $Database = new Database( 'db/mysqlitedb.sqlite', 0777, $sqlite_error ); print '<?xml version="1.0" encoding="UTF-8" ?>' . "\n"; print '<?xml-stylesheet href="style/navbar.xsl" type="text/xsl" ?>' . "\n"; print "<databases>\n"; if( $Database->connected ) { /* var_dump( $Database ); $Database->query( 'CREATE TABLE foo (bar varchar(10))' ); $Database->query( "INSERT INTO foo VALUES ('fnord')" ); $result = $Database->query( 'SELECT bar FROM foo' ); var_dump( $Database->fetch_array( $result ) );*/ $databases = array(); $dir = @opendir( 'db/' ); while( ( $file = @readdir( $dir ) ) !== FALSE ) { if( preg_match( '#(.*?)\.sqlite$#', $file ) ) { $contents = (string) fread( fopen( "db/$file", 'r' ), 50 ); if( preg_match( '#\*\* This file contains an SQLite (\d*\.\d*) database \*\*#', $contents ) ) { $databases[] = $file; } } } // var_dump( $databases ); foreach( $databases as $db ) { print "\t" . '<database name="' . substr( $db, 0, -7 ) . '">' . "\n"; $sql = "SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY name ASC"; $result = $Database->query( $sql ); while( $row = $Database->fetch_array( $result ) ) { print "\t\t<table>" . $row['name'] . "</table>\n"; } print "\t</database>\n"; } } else { die( $sqlite_error ); } print "</databases>\n"; ?> --- NEW FILE: index.php5 --- <?php /** * @name phpLiteAdmin * @copyright 2004 phpLiteAdmin Team */ /** * $Id: index.php5,v 1.1 2004/08/04 01:53:02 wgeric Exp $ * Index file... uh, yeah... */ error_reporting( E_ALL | E_STRICT ); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <title>phpLiteAdmin</title> </head> <frameset cols="150,*" rows="*"> <frame src="navbar.php5" frameborder="1" scrolling="auto" id="navbar" /> <frame src="main.php5" frameborder="0" scrolling="auto" id="main" /> </frameset> </html> --- NEW FILE: main.php5 --- <?php /** * @name phpLiteAdmin * @copyright 2004 phpLiteAdmin Team */ /** * $Id: main.php5,v 1.1 2004/08/04 01:53:02 wgeric Exp $ * Main page content */ header( 'Content-Type: text/xml; charset=UTF-8' ); include( 'lib/sqlite.php5' ); $Database = new Database( 'db/mysqlitedb.sqlite', 0777, $sqlite_error ); print '<?xml version="1.0" encoding="UTF-8" ?>' . "\n"; print '<?xml-stylesheet href="style/main.xsl" type="text/xsl" ?>' . "\n"; print "<content>\n"; print "\t<details>\n"; print "\t\t<version>" . sqlite_libversion() . "</version>\n"; print "\t</details>\n"; print "</content>\n"; ?> |
|
From: Eric F. <wg...@us...> - 2004-08-04 01:53:10
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25296/db Added Files: mysqlitedb.sqlite test.sqlite Log Message: Initial Commit --- NEW FILE: test.sqlite --- (This appears to be a binary file; contents omitted.) --- NEW FILE: mysqlitedb.sqlite --- (This appears to be a binary file; contents omitted.) |
|
From: Eric F. <wg...@us...> - 2004-08-04 01:46:48
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/style In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24531/style Log Message: Directory /cvsroot/phpliteadmin/phpLiteAdmin/style added to the repository |
|
From: Eric F. <wg...@us...> - 2004-08-04 01:46:48
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/lib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24531/lib Log Message: Directory /cvsroot/phpliteadmin/phpLiteAdmin/lib added to the repository |
|
From: Eric F. <wg...@us...> - 2004-08-04 01:46:47
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24531/db Log Message: Directory /cvsroot/phpliteadmin/phpLiteAdmin/db added to the repository |
|
From: Eric F. <wg...@us...> - 2004-08-04 01:46:47
|
Update of /cvsroot/phpliteadmin/phpLiteAdmin/lang In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24531/lang Log Message: Directory /cvsroot/phpliteadmin/phpLiteAdmin/lang added to the repository |
