Menu
▾
▴
phpsqliteadmin-devel — phpSQLiteAdmin developer mailing list
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
(12) |
Apr
(1) |
May
(19) |
Jun
(5) |
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
(26) |
Dec
(3) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(12) |
Feb
|
Mar
(26) |
Apr
(11) |
May
(8) |
Jun
|
Jul
(20) |
Aug
(13) |
Sep
(23) |
Oct
(2) |
Nov
|
Dec
|
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(3) |
Dec
|
| 2008 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
(22) |
Aug
(4) |
Sep
(3) |
Oct
(4) |
Nov
(1) |
Dec
(1) |
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(6) |
Dec
(2) |
| 2010 |
Jan
(3) |
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
(2) |
Dec
(1) |
| 2011 |
Jan
(3) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2012 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Yves G. <yg...@mi...> - 2008-10-12 18:43:00
|
On Sun 12 Oct 2008, Felipe Lopes wrote: > Hi there Yves! Hi Felipe, > There is a typo on the first line of the front page. It's written > "aplha1-release" instead of "alpha1-release". oh you are right... stupid me :-P I fixed it right now! Best regards! Yves |
|
From: Yves G. <yg...@mi...> - 2008-10-12 13:00:25
|
Hello, First, sorry for the first uncomplete mail... Second, I want to as Chris for an apology since I took much more time to announce his work on th website, but now it's done! I would be happy if you would take a look and change the wording and/or add content, you have full access to the shell. For future releases you are free to updated the site as you need! :-) You can login by sftp with slythfox,php...@we... The website is located in the htdocs folder. I found the howto of sf.net about website editing, it's here: http://alexandria.wiki.sourceforge.net/Project+Web,+Shell, +VHOST+and+Database+Services Especially this section: http://alexandria.wiki.sourceforge.net/Project+Web,+Shell, +VHOST+and+Database+Services#tocProject%20Web,%20Shell, %20VHOST%20and%20Database%20Services3 Thank you again for your contribution! Yves |
|
From: Yves G. <yg...@mi...> - 2008-10-12 13:00:25
|
Hello, First, I want to as Chris for an apology since I took more time to announce his work on th website, but now it's done! I would be happy if you would take a look and change the wording and/or add content, you have full access to the shell. You can login by sftp with slythfox,php...@we... The website is located in the htdocs folder. |
|
From: <yg...@us...> - 2008-10-12 12:53:35
|
Revision: 50
http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=50&view=rev
Author: yglodt
Date: 2008-10-12 12:53:29 +0000 (Sun, 12 Oct 2008)
Log Message:
-----------
add date and update version#
Modified Paths:
--------------
trunk/phpsqliteadmin2/changelog.txt
Modified: trunk/phpsqliteadmin2/changelog.txt
===================================================================
--- trunk/phpsqliteadmin2/changelog.txt 2008-09-17 02:04:22 UTC (rev 49)
+++ trunk/phpsqliteadmin2/changelog.txt 2008-10-12 12:53:29 UTC (rev 50)
@@ -1,6 +1,6 @@
phpSQLiteAdmin changelog ( see http://phpsqliteadmin.sourceforge.net/ for more details)
-0.3 (xx.xx.2008)
+0.3-alpha1 (17.09.2008)
- Icons have been added (no longer embedded). (chale)
- An error will be returned if the alias name or path is not specified. (chale)
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: Yves G. <yg...@mi...> - 2008-09-17 06:48:46
|
On Wednesday 17 September 2008, Chris Hale wrote: > I finally went ahead and released what was in the svn (including my > changes, of course) as an alpha 1 release. Hello, this is great news! :-) > I have no clue how to edit the phpSQLiteAdmin website to reflect this > release. IIRC it has to be done via the ssh shell of sf.net. I did not touch it since 3 years so I am not sure if that's still valid though. I am on vacations until the 21, with limited access to the net. I will take a look early next week when we're back home. Best regards, Yves > - C Hale |
|
From: Chris H. <sly...@gm...> - 2008-09-17 02:18:02
|
I finally went ahead and released what was in the svn (including my changes, of course) as an alpha 1 release. I have no clue how to edit the phpSQLiteAdmin website to reflect this release. - C Hale |
|
From: <sly...@us...> - 2008-09-17 02:04:14
|
Revision: 49
http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=49&view=rev
Author: slythfox
Date: 2008-09-17 02:04:22 +0000 (Wed, 17 Sep 2008)
Log Message:
-----------
Modified Paths:
--------------
trunk/phpsqliteadmin2/readme.txt
Modified: trunk/phpsqliteadmin2/readme.txt
===================================================================
--- trunk/phpsqliteadmin2/readme.txt 2008-08-11 06:44:32 UTC (rev 48)
+++ trunk/phpsqliteadmin2/readme.txt 2008-09-17 02:04:22 UTC (rev 49)
@@ -1,6 +1,10 @@
phpSQLiteAdmin is being developed under the GNU GPL license.
See the file copying.txt for license details.
+How to use:
+phpSQLiteAdmin makes use of a simple user system. The default information is listed below:
+Default username: root
+Default password: root
phpSQLiteAdmin makes use of the "Simple Power SQLite class",
see http://www.php-power.it/SPSQLiteClass.php
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: Yves G. <yg...@mi...> - 2008-08-15 16:30:37
|
On Monday 11 August 2008, Slythfox wrote: > We should probably think about releasing a new version. Like 0.3 > alpha 1. Obviously there's more work that needs to be done at some > point, but there hasn't been an update for quite some time. I know > Xampp includes phpsqliteadmin in their web server software bundle. > > Anyway, what do you think? I think this is a good idea. You have "release-tech"-grants so you should be able to make the release on this page: https://sourceforge.net/project/admin/newrelease.php?group_id=101528&package_id=110074 Could you make a small update to the website to announce the release? Regards! Yves > -- C Hale |
|
From: Slythfox <sly...@gm...> - 2008-08-11 06:50:44
|
We should probably think about releasing a new version. Like 0.3 alpha 1. Obviously there's more work that needs to be done at some point, but there hasn't been an update for quite some time. I know Xampp includes phpsqliteadmin in their web server software bundle. Anyway, what do you think? -- C Hale |
|
From: <sly...@us...> - 2008-08-11 06:44:23
|
Revision: 48
http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=48&view=rev
Author: slythfox
Date: 2008-08-11 06:44:32 +0000 (Mon, 11 Aug 2008)
Log Message:
-----------
Bug fix. And images no longer embedded.
Modified Paths:
--------------
trunk/phpsqliteadmin2/changelog.txt
trunk/phpsqliteadmin2/editdb.php
trunk/phpsqliteadmin2/include.php
trunk/phpsqliteadmin2/leftframe.php
trunk/phpsqliteadmin2/table_browse.php
Added Paths:
-----------
trunk/phpsqliteadmin2/images/
trunk/phpsqliteadmin2/images/database.png
trunk/phpsqliteadmin2/images/delete.png
trunk/phpsqliteadmin2/images/edit.png
trunk/phpsqliteadmin2/images/export.png
trunk/phpsqliteadmin2/images/query.png
trunk/phpsqliteadmin2/images/row_insert.png
trunk/phpsqliteadmin2/images/table_browse.png
trunk/phpsqliteadmin2/images/table_drop.png
trunk/phpsqliteadmin2/images/table_empty.png
trunk/phpsqliteadmin2/images/table_structure.png
Modified: trunk/phpsqliteadmin2/changelog.txt
===================================================================
--- trunk/phpsqliteadmin2/changelog.txt 2008-08-11 06:05:54 UTC (rev 47)
+++ trunk/phpsqliteadmin2/changelog.txt 2008-08-11 06:44:32 UTC (rev 48)
@@ -2,9 +2,9 @@
0.3 (xx.xx.2008)
+- Icons have been added (no longer embedded). (chale)
- An error will be returned if the alias name or path is not specified. (chale)
- An error will be returned when trying to delete the phpsla.sqlite alias. (chale)
-- Icons have been (temporarily?) embedded into the includes file. (chale)
- Added really basic multiquery support with the query page. This allows one to copy&paste a sql file and execute it in one go. (chale)
- The query page now displays "x rows affected/returned". Before there was not sort of confirmation when doing non SELECT queries. (chale)
- Fixed query page's inconsistency in that it was not using htmlspecialchars. (chale)
Modified: trunk/phpsqliteadmin2/editdb.php
===================================================================
--- trunk/phpsqliteadmin2/editdb.php 2008-08-11 06:05:54 UTC (rev 47)
+++ trunk/phpsqliteadmin2/editdb.php 2008-08-11 06:44:32 UTC (rev 48)
@@ -15,11 +15,11 @@
if (isset($_POST['insert'])) {
// create the new db is case it does not exist
- if ($alias->alias = "") {
+ if ($alias->alias == "") {
print "An alias name needs to be provided.";
exit();
}
- if ($alias->path = "") {
+ if ($alias->path == "") {
print "The path to the database needs to be provided.";
exit();
}
@@ -53,7 +53,7 @@
if (isset($_POST['delete'])) {
- if ($alias->alias = "phpsla.sqlite") {
+ if ($alias->alias == "phpsla.sqlite") {
print "The configuration table phpsla.sqlite cannot be removed.";
exit();
}
Property changes on: trunk/phpsqliteadmin2/images/database.png
___________________________________________________________________
Added: svn:executable
+ *
Added: svn:mime-type
+ application/octet-stream
Property changes on: trunk/phpsqliteadmin2/images/delete.png
___________________________________________________________________
Added: svn:executable
+ *
Added: svn:mime-type
+ application/octet-stream
Property changes on: trunk/phpsqliteadmin2/images/edit.png
___________________________________________________________________
Added: svn:executable
+ *
Added: svn:mime-type
+ application/octet-stream
Property changes on: trunk/phpsqliteadmin2/images/export.png
___________________________________________________________________
Added: svn:executable
+ *
Added: svn:mime-type
+ application/octet-stream
Property changes on: trunk/phpsqliteadmin2/images/query.png
___________________________________________________________________
Added: svn:executable
+ *
Added: svn:mime-type
+ application/octet-stream
Property changes on: trunk/phpsqliteadmin2/images/row_insert.png
___________________________________________________________________
Added: svn:executable
+ *
Added: svn:mime-type
+ application/octet-stream
Property changes on: trunk/phpsqliteadmin2/images/table_browse.png
___________________________________________________________________
Added: svn:executable
+ *
Added: svn:mime-type
+ application/octet-stream
Property changes on: trunk/phpsqliteadmin2/images/table_drop.png
___________________________________________________________________
Added: svn:executable
+ *
Added: svn:mime-type
+ application/octet-stream
Property changes on: trunk/phpsqliteadmin2/images/table_empty.png
___________________________________________________________________
Added: svn:executable
+ *
Added: svn:mime-type
+ application/octet-stream
Property changes on: trunk/phpsqliteadmin2/images/table_structure.png
___________________________________________________________________
Added: svn:executable
+ *
Added: svn:mime-type
+ application/octet-stream
Modified: trunk/phpsqliteadmin2/include.php
===================================================================
--- trunk/phpsqliteadmin2/include.php 2008-08-11 06:05:54 UTC (rev 47)
+++ trunk/phpsqliteadmin2/include.php 2008-08-11 06:44:32 UTC (rev 48)
@@ -12,57 +12,6 @@
$_SESSION['phpSQLiteAdmin_currentdb'] = $_POST['sessionvalue'];
}
-// Embedded Images
-/*
-Embed images using this function:
-function encode_img($img)
-{
- $fd = fopen ($img, 'rb');
- $size=filesize ($img);
- $cont = fread ($fd, $size);
- fclose ($fd);
- $encimg = base64_encode($cont);
- return $encimg;
-}
-*/
-if (isset($_GET['imgid'])) {
- switch ($_GET['imgid']) {
- case "database.png":
- $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAFVJREFUKFNj/P//PwN+AFQBBCcO9iyb64+MgCIQKQa49LVz2f//J0MQkA1UDVEEUgHkIEsjKyJaxcGdtWjGQGwBiqOYgeZSiCKoCmqYAQkMfL7FH2IAUp7xCV2zSGMAAAAASUVORK5CYII=";
- break;
- case "edit.png":
- $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAGxJREFUKFN1kMENwCAIRdnVY5dwFBbosWv0wKHr0K9YikSJiSbvRT6QbqoSGRlX0homMmlhVFQ3TMoGqGp57gMMR0Qmw/F1FryBJ2OJ/xw7PIyOFb3j5z5dy2EGM3vvOPww2oRftLSb9cai9ALjByf/vas8pQAAAABJRU5ErkJggg==";
- break;
- case "delete.png":
- $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAFhJREFUKFOVUEEOwDAIcu/0x/5gr7E12hVM02SeFAiij7vLvabiFXHV2VCpBm4mgeaAog8pRRMBHRm28yLKzywpUKDTon954O5DDobourylRavs9I/+LJoHDOj+ebMh9FoAAAAASUVORK5CYII=";
- break;
- case "export.png":
- $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAElJREFUKFNj+I8KGhoa0EQYkPlAaQhAFkSogEujKUIxA818CJcBTSsmF6TiAG4AlCXODKzWQwShZgBZEHuAjKVIAEUFLmOIcgcANi4S5K6eGuUAAAAASUVORK5CYII=";
- break;
- case "query.png":
- $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAFBJREFUKFNj/P//PwN+AFRx4MCBBmwAKA7SD8RAWSCJCSDiIBVwM9YjAaA0wgyIbjST4FyQGUSpwGUA1B14rED4BdmNQDbc76T7Fi3YIL4FANr9DcnCLQhKAAAAAElFTkSuQmCC";
- break;
- case "row_insert.png";
- $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAEVJREFUKFNj/P//PwMGaGxsdHBwgAoDVWCChoaGAzDAQJQKoA64OiAbDYDMgAhBFAEZz1ABQgVEET4VBMwg4A5q+Ba/GQA8fBNm+WP9jwAAAABJRU5ErkJggg==";
- break;
- case "table_browse.png";
- $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAADBJREFUKFNjbGhoYMAPgCoO4AYg/UCMH4BU/McNoGYAFSyFATQ2QgUuUwaZGfjDAwABxvgJEsmisgAAAABJRU5ErkJggg==";
- break;
- case "table_drop.png";
- $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAE5JREFUKFNjbGhoYMAPgCoO4AYg/UCMH4BU/McNoGaAFDAw/EdWCmQDRf4DxcC2gFRAhCDq4AwUFRCLINJIhpFkBqY7wCYhmYHDO0SFBwAgBuY3U4A6ewAAAABJRU5ErkJggg==";
- break;
- case "table_empty.png";
- $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAE5JREFUKFNjbGhoYMAPgCr+4wYg/XAV169fB7IhAMiG6EJRgaYUoghFBdwquEk4zYBIoNuCrA/Z3QhbIM5EdiAWlxL2C9ZAgdoCdwRWBgCNfACU8GKOGgAAAABJRU5ErkJggg==";
- break;
- case "table_structure.png";
- $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAACtJREFUKFNjbGhoYMAPgCr+4wYg/RAVB8AAyFiKBIBchApcpgxDM4BewgMAWDAIViqqPeEAAAAASUVORK5CYII=";
- break;
- }
-
- header('Content-type: image/png');
- echo base64_decode($imgcode);
- exit();
-}
function check_db() {
global $current_db;
@@ -110,27 +59,27 @@
<div id="currentdb">Database: {$_SESSION['phpSQLiteAdmin_currentdb']}</div>
<p class="sqliteversion">SQLite version: $sqliteversion</p>
<br />
-<a href="mainframe.php" target="mainframe"><img src="include.php?imgid=database.png" alt="" /> Database Info</a> |
-<a href="table_structure.php?object=$current_table" target="mainframe"><img src="include.php?imgid=table_structure.png" alt="" /> Structure</a> |
-<a href="table_browse.php?object=$current_table" target="mainframe"><img src="include.php?imgid=table_browse.png" alt="" /> Browse</a> |
-<a href="query.php?object=$current_table" target="mainframe"><img src="include.php?imgid=query.png" alt="" /> Query</a> |
-<a href="row_edit.php?object=$current_table" target="mainframe"><img src="include.php?imgid=row_insert.png" alt=\"\" /> Insert</a> |
-<a href="export.php?object=$current_table" target="mainframe"><img src="include.php?imgid=export.png" alt=\"\" /> Export</a> |
-<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();"><img src="include.php?imgid=table_empty.png" alt=\"\" /> Empty</a> |
-<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();"><img src="include.php?imgid=table_drop.png" alt=\"\" /> Drop</a>
+<a href="mainframe.php" target="mainframe"><img src="images/database.png" alt="" /> Database Info</a> |
+<a href="table_structure.php?object=$current_table" target="mainframe"><img src="images/table_structure.png" alt="" /> Structure</a> |
+<a href="table_browse.php?object=$current_table" target="mainframe"><img src="images/table_browse.png" alt="" /> Browse</a> |
+<a href="query.php?object=$current_table" target="mainframe"><img src="images/query.png" alt="" /> Query</a> |
+<a href="row_edit.php?object=$current_table" target="mainframe"><img src="images/row_insert.png" alt=\"\" /> Insert</a> |
+<a href="export.php?object=$current_table" target="mainframe"><img src="images/export.png" alt=\"\" /> Export</a> |
+<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();"><img src="images/table_empty.png" alt=\"\" /> Empty</a> |
+<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();"><img src="images/table_drop.png" alt=\"\" /> Drop</a>
EOT;
}
function print_table_action_links($current_table) {
echo<<<EOT
-<a href="table_structure.php?object=$current_table" target="mainframe"><img src="include.php?imgid=table_structure.png" alt="" /> Structure</a> |
-<a href="table_browse.php?object=$current_table" target="mainframe"><img src="include.php?imgid=table_browse.png" alt="" /> Browse</a> |
-<a href="query.php?object=$current_table" target="mainframe"><img src="include.php?imgid=query.png" alt="" /> Query</a> |
-<a href="row_edit.php?object=$current_table" target="mainframe"><img src="include.php?imgid=row_insert.png" alt=\"\" /> Insert</a> |
-<a href="export.php?object=$current_table" target="mainframe"><img src="include.php?imgid=export.png" alt=\"\" /> Export</a> |
-<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();"><img src="include.php?imgid=table_empty.png" alt="" /> Empty</a> |
-<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();"><img src="include.php?imgid=table_drop.png" alt="" /> Drop</a>
+<a href="table_structure.php?object=$current_table" target="mainframe"><img src="images/table_structure.png" alt="" /> Structure</a> |
+<a href="table_browse.php?object=$current_table" target="mainframe"><img src="images/table_browse.png" alt="" /> Browse</a> |
+<a href="query.php?object=$current_table" target="mainframe"><img src="images/query.png" alt="" /> Query</a> |
+<a href="row_edit.php?object=$current_table" target="mainframe"><img src="images/row_insert.png" alt=\"\" /> Insert</a> |
+<a href="export.php?object=$current_table" target="mainframe"><img src="images/export.png" alt=\"\" /> Export</a> |
+<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();"><img src="images/table_empty.png" alt="" /> Empty</a> |
+<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();"><img src="images/table_drop.png" alt="" /> Drop</a>
EOT;
}
Modified: trunk/phpsqliteadmin2/leftframe.php
===================================================================
--- trunk/phpsqliteadmin2/leftframe.php 2008-08-11 06:05:54 UTC (rev 47)
+++ trunk/phpsqliteadmin2/leftframe.php 2008-08-11 06:44:32 UTC (rev 48)
@@ -38,7 +38,7 @@
print "<li class=\"list_title\" title=\"Tables in database $current_db\">Tables</li>\n";
$userdbh->query("select name,upper(name) from SQLITE_MASTER where type = 'table' order by 2");
while($row = $userdbh->fetchArray()) {
- print "<li><a href=\"table_browse.php?object=".$row[0]."\"><img src=\"include.php?imgid=table_browse.png\" alt=\"Browse table\" title=\"Browse table\" /></a> <a href=\"table_structure.php?object=".$row[0]."\">$row[0]</a></li>\n";
+ print "<li><a href=\"table_browse.php?object=".$row[0]."\"><img src=\"images/table_browse.png\" alt=\"Browse\" title=\"Browse table\" /></a> <a href=\"table_structure.php?object=".$row[0]."\">$row[0]</a></li>\n";
}
print "</ul>\n</div>\n";
}
Modified: trunk/phpsqliteadmin2/table_browse.php
===================================================================
--- trunk/phpsqliteadmin2/table_browse.php 2008-08-11 06:05:54 UTC (rev 47)
+++ trunk/phpsqliteadmin2/table_browse.php 2008-08-11 06:44:32 UTC (rev 48)
@@ -48,8 +48,8 @@
//$rows = $userdbh->returnRows('num');
//$table->print_header();
print "<tr>\n";
- print "<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "\"><img src=\"include.php?imgid=edit.png\" alt=\"Edit\" title=\"Edit\" /></a></td>
-<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "&type=delete\" onclick=\"return confirm_delete_row();\"><img src=\"include.php?imgid=delete.png\" alt=\"Delete\" title=\"Delete\" /></a></td>\n";
+ print "<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "\"><img src=\"images/edit.png\" alt=\"Edit\" title=\"Edit\" /></a></td>
+<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "&type=delete\" onclick=\"return confirm_delete_row();\"><img src=\"images/delete.png\" alt=\"Delete\" title=\"Delete\" /></a></td>\n";
for ($i=0; $i<$nr_fields; $i++) {
if (strlen($row[$i]) > 50) {
print '<td>'.substr(htmlentities($row[$i],ENT_QUOTES,$encoding),0,50)."...</td>\n";
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <sly...@us...> - 2008-08-11 06:05:44
|
Revision: 47
http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=47&view=rev
Author: slythfox
Date: 2008-08-11 06:05:54 +0000 (Mon, 11 Aug 2008)
Log Message:
-----------
Fixed phpsla db alias bugs.
Modified Paths:
--------------
trunk/phpsqliteadmin2/changelog.txt
trunk/phpsqliteadmin2/editdb.php
trunk/phpsqliteadmin2/todo.txt
Modified: trunk/phpsqliteadmin2/changelog.txt
===================================================================
--- trunk/phpsqliteadmin2/changelog.txt 2008-07-13 18:12:55 UTC (rev 46)
+++ trunk/phpsqliteadmin2/changelog.txt 2008-08-11 06:05:54 UTC (rev 47)
@@ -2,6 +2,8 @@
0.3 (xx.xx.2008)
+- An error will be returned if the alias name or path is not specified. (chale)
+- An error will be returned when trying to delete the phpsla.sqlite alias. (chale)
- Icons have been (temporarily?) embedded into the includes file. (chale)
- Added really basic multiquery support with the query page. This allows one to copy&paste a sql file and execute it in one go. (chale)
- The query page now displays "x rows affected/returned". Before there was not sort of confirmation when doing non SELECT queries. (chale)
Modified: trunk/phpsqliteadmin2/editdb.php
===================================================================
--- trunk/phpsqliteadmin2/editdb.php 2008-07-13 18:12:55 UTC (rev 46)
+++ trunk/phpsqliteadmin2/editdb.php 2008-08-11 06:05:54 UTC (rev 47)
@@ -15,6 +15,14 @@
if (isset($_POST['insert'])) {
// create the new db is case it does not exist
+ if ($alias->alias = "") {
+ print "An alias name needs to be provided.";
+ exit();
+ }
+ if ($alias->path = "") {
+ print "The path to the database needs to be provided.";
+ exit();
+ }
if (!file_exists($alias->path)) $newdb =& new SPSQLite($alias->path);
$sysdbh->query("insert into databases (user,alias,path,description) values ({$alias->user},'{$alias->alias}','{$alias->path}','{$alias->description}')");
// do we really want this?
@@ -45,8 +53,12 @@
if (isset($_POST['delete'])) {
- $sysdbh->query("delete from databases where user = {$alias->user} and alias = '{$alias->alias}'");
- //unlink($alias->path); nooooooo don't do that...
+ if ($alias->alias = "phpsla.sqlite") {
+ print "The configuration table phpsla.sqlite cannot be removed.";
+ exit();
+ }
+ $sysdbh->query("delete from databases where user = '{$alias->user}' and alias = '{$alias->alias}'");
+ //unlink($alias->path); nooooooo don't do that... No, that wouldn't be good.
$_SESSION['phpSQLiteAdmin_currentdb'] = '';
header("Location: dbconfig.php");
exit;
@@ -85,7 +97,7 @@
echo<<<EOT
<br /><br /><br /><br /><br />
<form name="delete" action="editdb.php" method="post" onsubmit="">
-<input type="hidden" name="use"r value="{$current_user}" />
+<input type="hidden" name="user" value="{$current_user}" />
<input type="hidden" name="alias" value="{$_GET[alias]}" />
<input type="submit" name="delete" value="Remove this alias" />
</form>
@@ -96,4 +108,4 @@
print "</body>\n";
print "</html>\n";
-?>
\ No newline at end of file
+?>
Modified: trunk/phpsqliteadmin2/todo.txt
===================================================================
--- trunk/phpsqliteadmin2/todo.txt 2008-07-13 18:12:55 UTC (rev 46)
+++ trunk/phpsqliteadmin2/todo.txt 2008-08-11 06:05:54 UTC (rev 47)
@@ -1,10 +1,8 @@
-Revised Todo (July, 10, 2008):
-
- - Don't allow the removal of the phpsla.sqlite alias.
+Revised Todo (July 25, 2008):
- Error checking for adding database aliases. How should general error handling work?
- - Add row adding/editing/deleting. (I have a basic implimentation. -chale)
+ - Add row adding/editing/deleting. (We have a basic implimentation currently.)
- When displaying the phpsqliteadmin version, it should display the number within the configuration table of the phpsla.sqlite database.
@@ -17,12 +15,9 @@
- Feel free to add more. I was unsure of a few of entries in the old todo's.
- Privilege checks for databases?
-
+
Old Todo:
-- you can add an alias database w/out the alias filled, which is bad...
-- you can remove phpsla.sqlite alias, which is bad as well
-
- "browse" should have navigation buttons
- display of indexes fails sometimes
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: Yves G. <yg...@mi...> - 2008-07-13 20:26:34
|
On Sunday 13 July 2008, Slythfox wrote: > Cool. > The one thing I couldn't get working was adding directories. It > returned a strange error... however, I think I now know what I didn't > do. Anyway, I finally updated all of my changes to date. SVN is > easier to work with. :) yes for sure. I usualy do either "mkdir dir" then "svn add dir", but IIRC you can also do "svn mkdir dir". > One thing, though. When committing, how do you individually log the > revision changes for each file? You can e.g. commit them one by one then and so give a separate commitmessage for each file. > I tried svn commit, then in the nano > prompt, added -m "changes" to all of the lines. When nano comes up, type your commitmessage in nano, but above the: "--This line, and those below, will be ignored--" , followed by CTRL-X, Y and then Enter, then your message will be logged. regards! > - C Hale |
|
From: Slythfox <sly...@gm...> - 2008-07-13 18:20:39
|
Cool. The one thing I couldn't get working was adding directories. It returned a strange error... however, I think I now know what I didn't do. Anyway, I finally updated all of my changes to date. SVN is easier to work with. :) One thing, though. When committing, how do you individually log the revision changes for each file? I tried svn commit, then in the nano prompt, added -m "changes" to all of the lines. - C Hale On Sun, Jul 13, 2008 at 9:57 AM, Yves Glodt <yg...@mi...> wrote: > Hi, > > On Sun, 2008-07-13 at 04:54 +0000, Slythfox wrote: > > Yeah: > > $ cvs -z3 > > -d:ext:sly...@ph...:/cvsroot/phpsqliteadmin > add phpsqliteadmin2/row_edit.php -m "Initial import" > > cvs add: in directory .: > > cvs [add aborted]: there is no version here; do 'cvs checkout' first > > Hmm, I am clueless about this... but wait > > > As for svn, I'm not sure how you got it to work, because it seems to > > me that svn isn't set up for the phpsqliteadmin project. > > True, I wanted to say that I use svn for my other projects, but never > converted phpsla to it, but.... :-) I did it now, by dumping the CVS > from about 1 hour ago (11:00 AM here at GMT+1) and importing it into SVN > > http://phpsqliteadmin.svn.sourceforge.net/viewvc/phpsqliteadmin/trunk/ > > I suggest that we check it out all, and forget about the CVS repo, and > only work in the svn from now on, what do you think about that? > > Regards, > Yves > > > (And sourceforge's documentation on using svn with SF projects is > > worse...) > > > > On the bright side, I'm happy to say I got a simple table exporter to > > work for phpSQLiteadmin. > > Wow that's nice to hear, I will check it out > > > - C Hale > > > > On Sun, Jul 13, 2008 at 12:12 AM, Yves Glodt <yg...@mi...> wrote: > > On Sunday 13 July 2008, Slythfox wrote: > > > Wow, sorry for all the separate dev list emails for these > > revisions! > > > > > > I suppose there's a way to simple update everything at the > > same time? > > > > > > I use svn mainly, and a simple "svn commit" in the root-folder > > of the > > project does that. I do not remember much about cvs at all... > > just > > remember svn is quite similar to it... sorry > > > > > I have to figure out how to add files now. When I try to add > > files, > > > it outputs this: cvs [add aborted]: there is no version > > here; do 'cvs > > > checkout' first > > > > > > To cite the svn-equivalent, did you try "cvs add > > filename.php"? > > > > regards, > > Yves > > > > > The problem is, it won't let me checkout a non-existent > > file. > > > > > ------------------------------------------------------------------------- > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > _______________________________________________ > Phpsqliteadmin-devel mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel > |
|
From: <sly...@us...> - 2008-07-13 18:12:51
|
Revision: 46
http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=46&view=rev
Author: slythfox
Date: 2008-07-13 11:12:55 -0700 (Sun, 13 Jul 2008)
Log Message:
-----------
Modified Paths:
--------------
trunk/phpsqliteadmin2/changelog.txt
trunk/phpsqliteadmin2/include.php
trunk/phpsqliteadmin2/leftframe.php
trunk/phpsqliteadmin2/row_edit.php
trunk/phpsqliteadmin2/table_browse.php
Modified: trunk/phpsqliteadmin2/changelog.txt
===================================================================
--- trunk/phpsqliteadmin2/changelog.txt 2008-07-13 17:12:41 UTC (rev 45)
+++ trunk/phpsqliteadmin2/changelog.txt 2008-07-13 18:12:55 UTC (rev 46)
@@ -2,6 +2,7 @@
0.3 (xx.xx.2008)
+- Icons have been (temporarily?) embedded into the includes file. (chale)
- Added really basic multiquery support with the query page. This allows one to copy&paste a sql file and execute it in one go. (chale)
- The query page now displays "x rows affected/returned". Before there was not sort of confirmation when doing non SELECT queries. (chale)
- Fixed query page's inconsistency in that it was not using htmlspecialchars. (chale)
Modified: trunk/phpsqliteadmin2/include.php
===================================================================
--- trunk/phpsqliteadmin2/include.php 2008-07-13 17:12:41 UTC (rev 45)
+++ trunk/phpsqliteadmin2/include.php 2008-07-13 18:12:55 UTC (rev 46)
@@ -12,6 +12,57 @@
$_SESSION['phpSQLiteAdmin_currentdb'] = $_POST['sessionvalue'];
}
+// Embedded Images
+/*
+Embed images using this function:
+function encode_img($img)
+{
+ $fd = fopen ($img, 'rb');
+ $size=filesize ($img);
+ $cont = fread ($fd, $size);
+ fclose ($fd);
+ $encimg = base64_encode($cont);
+ return $encimg;
+}
+*/
+if (isset($_GET['imgid'])) {
+ switch ($_GET['imgid']) {
+ case "database.png":
+ $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAFVJREFUKFNj/P//PwN+AFQBBCcO9iyb64+MgCIQKQa49LVz2f//J0MQkA1UDVEEUgHkIEsjKyJaxcGdtWjGQGwBiqOYgeZSiCKoCmqYAQkMfL7FH2IAUp7xCV2zSGMAAAAASUVORK5CYII=";
+ break;
+ case "edit.png":
+ $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAGxJREFUKFN1kMENwCAIRdnVY5dwFBbosWv0wKHr0K9YikSJiSbvRT6QbqoSGRlX0homMmlhVFQ3TMoGqGp57gMMR0Qmw/F1FryBJ2OJ/xw7PIyOFb3j5z5dy2EGM3vvOPww2oRftLSb9cai9ALjByf/vas8pQAAAABJRU5ErkJggg==";
+ break;
+ case "delete.png":
+ $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAFhJREFUKFOVUEEOwDAIcu/0x/5gr7E12hVM02SeFAiij7vLvabiFXHV2VCpBm4mgeaAog8pRRMBHRm28yLKzywpUKDTon954O5DDobourylRavs9I/+LJoHDOj+ebMh9FoAAAAASUVORK5CYII=";
+ break;
+ case "export.png":
+ $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAElJREFUKFNj+I8KGhoa0EQYkPlAaQhAFkSogEujKUIxA818CJcBTSsmF6TiAG4AlCXODKzWQwShZgBZEHuAjKVIAEUFLmOIcgcANi4S5K6eGuUAAAAASUVORK5CYII=";
+ break;
+ case "query.png":
+ $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAFBJREFUKFNj/P//PwN+AFRx4MCBBmwAKA7SD8RAWSCJCSDiIBVwM9YjAaA0wgyIbjST4FyQGUSpwGUA1B14rED4BdmNQDbc76T7Fi3YIL4FANr9DcnCLQhKAAAAAElFTkSuQmCC";
+ break;
+ case "row_insert.png";
+ $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAEVJREFUKFNj/P//PwMGaGxsdHBwgAoDVWCChoaGAzDAQJQKoA64OiAbDYDMgAhBFAEZz1ABQgVEET4VBMwg4A5q+Ba/GQA8fBNm+WP9jwAAAABJRU5ErkJggg==";
+ break;
+ case "table_browse.png";
+ $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAADBJREFUKFNjbGhoYMAPgCoO4AYg/UCMH4BU/McNoGYAFSyFATQ2QgUuUwaZGfjDAwABxvgJEsmisgAAAABJRU5ErkJggg==";
+ break;
+ case "table_drop.png";
+ $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAE5JREFUKFNjbGhoYMAPgCoO4AYg/UCMH4BU/McNoGaAFDAw/EdWCmQDRf4DxcC2gFRAhCDq4AwUFRCLINJIhpFkBqY7wCYhmYHDO0SFBwAgBuY3U4A6ewAAAABJRU5ErkJggg==";
+ break;
+ case "table_empty.png";
+ $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAAE5JREFUKFNjbGhoYMAPgCr+4wYg/XAV169fB7IhAMiG6EJRgaYUoghFBdwquEk4zYBIoNuCrA/Z3QhbIM5EdiAWlxL2C9ZAgdoCdwRWBgCNfACU8GKOGgAAAABJRU5ErkJggg==";
+ break;
+ case "table_structure.png";
+ $imgcode = "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAIAAAAmzuBxAAAABGdBTUEAALGPC/xhBQAAACtJREFUKFNjbGhoYMAPgCr+4wYg/RAVB8AAyFiKBIBchApcpgxDM4BewgMAWDAIViqqPeEAAAAASUVORK5CYII=";
+ break;
+ }
+
+ header('Content-type: image/png');
+ echo base64_decode($imgcode);
+ exit();
+}
function check_db() {
global $current_db;
@@ -59,27 +110,27 @@
<div id="currentdb">Database: {$_SESSION['phpSQLiteAdmin_currentdb']}</div>
<p class="sqliteversion">SQLite version: $sqliteversion</p>
<br />
-<a href="mainframe.php" target="mainframe"><img src="images/database.png" alt="" /> Database Info</a> |
-<a href="table_structure.php?object=$current_table" target="mainframe"><img src="images/table_structure.png" alt="" /> Structure</a> |
-<a href="table_browse.php?object=$current_table" target="mainframe"><img src="images/table_browse.png" alt="" /> Browse</a> |
-<a href="query.php?object=$current_table" target="mainframe"><img src="images/query.png" alt="" /> Query</a> |
-<a href="row_edit.php?object=$current_table" target="mainframe"><img src="images/row_insert.png" alt=\"\" /> Insert</a> |
-<a href="export.php?object=$current_table" target="mainframe"><img src="images/export.png" alt=\"\" /> Export</a> |
-<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();"><img src="images/table_empty.png" alt=\"\" /> Empty</a> |
-<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();"><img src="images/table_drop.png" alt=\"\" /> Drop</a>
+<a href="mainframe.php" target="mainframe"><img src="include.php?imgid=database.png" alt="" /> Database Info</a> |
+<a href="table_structure.php?object=$current_table" target="mainframe"><img src="include.php?imgid=table_structure.png" alt="" /> Structure</a> |
+<a href="table_browse.php?object=$current_table" target="mainframe"><img src="include.php?imgid=table_browse.png" alt="" /> Browse</a> |
+<a href="query.php?object=$current_table" target="mainframe"><img src="include.php?imgid=query.png" alt="" /> Query</a> |
+<a href="row_edit.php?object=$current_table" target="mainframe"><img src="include.php?imgid=row_insert.png" alt=\"\" /> Insert</a> |
+<a href="export.php?object=$current_table" target="mainframe"><img src="include.php?imgid=export.png" alt=\"\" /> Export</a> |
+<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();"><img src="include.php?imgid=table_empty.png" alt=\"\" /> Empty</a> |
+<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();"><img src="include.php?imgid=table_drop.png" alt=\"\" /> Drop</a>
EOT;
}
function print_table_action_links($current_table) {
echo<<<EOT
-<a href="table_structure.php?object=$current_table" target="mainframe"><img src="images/table_structure.png" alt="" /> Structure</a> |
-<a href="table_browse.php?object=$current_table" target="mainframe"><img src="images/table_browse.png" alt="" /> Browse</a> |
-<a href="query.php?object=$current_table" target="mainframe"><img src="images/query.png" alt="" /> Query</a> |
-<a href="row_edit.php?object=$current_table" target="mainframe"><img src="images/row_insert.png" alt=\"\" /> Insert</a> |
-<a href="export.php?object=$current_table" target="mainframe"><img src="images/export.png" alt=\"\" /> Export</a> |
-<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();"><img src="images/table_empty.png" alt="" /> Empty</a> |
-<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();"><img src="images/table_drop.png" alt="" /> Drop</a>
+<a href="table_structure.php?object=$current_table" target="mainframe"><img src="include.php?imgid=table_structure.png" alt="" /> Structure</a> |
+<a href="table_browse.php?object=$current_table" target="mainframe"><img src="include.php?imgid=table_browse.png" alt="" /> Browse</a> |
+<a href="query.php?object=$current_table" target="mainframe"><img src="include.php?imgid=query.png" alt="" /> Query</a> |
+<a href="row_edit.php?object=$current_table" target="mainframe"><img src="include.php?imgid=row_insert.png" alt=\"\" /> Insert</a> |
+<a href="export.php?object=$current_table" target="mainframe"><img src="include.php?imgid=export.png" alt=\"\" /> Export</a> |
+<a href="dbaction.php?action=empty_table&object=$current_table" target="_top" onclick="return confirm_empty_table();"><img src="include.php?imgid=table_empty.png" alt="" /> Empty</a> |
+<a href="dbaction.php?action=drop_table&object=$current_table" target="_top" onclick="return confirm_drop_table();"><img src="include.php?imgid=table_drop.png" alt="" /> Drop</a>
EOT;
}
Modified: trunk/phpsqliteadmin2/leftframe.php
===================================================================
--- trunk/phpsqliteadmin2/leftframe.php 2008-07-13 17:12:41 UTC (rev 45)
+++ trunk/phpsqliteadmin2/leftframe.php 2008-07-13 18:12:55 UTC (rev 46)
@@ -38,7 +38,7 @@
print "<li class=\"list_title\" title=\"Tables in database $current_db\">Tables</li>\n";
$userdbh->query("select name,upper(name) from SQLITE_MASTER where type = 'table' order by 2");
while($row = $userdbh->fetchArray()) {
- print "<li><a href=\"table_browse.php?object=".$row[0]."\"><img src=\"images/table_browse.png\" alt=\"Browse table\" title=\"Browse table\" /></a> <a href=\"table_structure.php?object=".$row[0]."\">$row[0]</a></li>\n";
+ print "<li><a href=\"table_browse.php?object=".$row[0]."\"><img src=\"include.php?imgid=table_browse.png\" alt=\"Browse table\" title=\"Browse table\" /></a> <a href=\"table_structure.php?object=".$row[0]."\">$row[0]</a></li>\n";
}
print "</ul>\n</div>\n";
}
Modified: trunk/phpsqliteadmin2/row_edit.php
===================================================================
--- trunk/phpsqliteadmin2/row_edit.php 2008-07-13 17:12:41 UTC (rev 45)
+++ trunk/phpsqliteadmin2/row_edit.php 2008-07-13 18:12:55 UTC (rev 46)
@@ -153,13 +153,14 @@
print "</tr>\n";
}
}
-print "</table>\n";
+print "<tr>\n<th></th>\n<th></th>\n<th>";
print "<input type=\"hidden\" name=\"row\" value=\"" .$_GET['row']. "\" />\n";
print "<input type=\"hidden\" name=\"primary_key\" value=\"" .$_GET['primary_key']. "\" />\n";
print "<input type=\"hidden\" name=\"object\" value=\"" .$_GET['object']. "\" />\n";
print "<input type=\"hidden\" name=\"type\" value=\"" .$type. "\" />\n";
print "<input type=\"submit\" name=\"\" value=\"Save\" />\n";
print "<input type=button value=\"Cancel\" onclick=\"history.back();\">";
+print "</th>\n</table>\n";
print "</form>";
/*
Modified: trunk/phpsqliteadmin2/table_browse.php
===================================================================
--- trunk/phpsqliteadmin2/table_browse.php 2008-07-13 17:12:41 UTC (rev 45)
+++ trunk/phpsqliteadmin2/table_browse.php 2008-07-13 18:12:55 UTC (rev 46)
@@ -48,8 +48,8 @@
//$rows = $userdbh->returnRows('num');
//$table->print_header();
print "<tr>\n";
- print "<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "\"><img src=\"images/edit.png\" alt=\"Edit\" title=\"Edit\" /></a></td>
-<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "&type=delete\" onclick=\"return confirm_delete_row();\"><img src=\"images/delete.png\" alt=\"Delete\" title=\"Delete\" /></a></td>\n";
+ print "<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "\"><img src=\"include.php?imgid=edit.png\" alt=\"Edit\" title=\"Edit\" /></a></td>
+<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "&type=delete\" onclick=\"return confirm_delete_row();\"><img src=\"include.php?imgid=delete.png\" alt=\"Delete\" title=\"Delete\" /></a></td>\n";
for ($i=0; $i<$nr_fields; $i++) {
if (strlen($row[$i]) > 50) {
print '<td>'.substr(htmlentities($row[$i],ENT_QUOTES,$encoding),0,50)."...</td>\n";
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <sly...@us...> - 2008-07-13 17:12:31
|
Revision: 45
http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=45&view=rev
Author: slythfox
Date: 2008-07-13 10:12:41 -0700 (Sun, 13 Jul 2008)
Log Message:
-----------
Modified Paths:
--------------
trunk/phpsqliteadmin2/javascript.txt
Added Paths:
-----------
trunk/phpsqliteadmin2/export.php
trunk/phpsqliteadmin2/row_edit.php
Added: trunk/phpsqliteadmin2/export.php
===================================================================
--- trunk/phpsqliteadmin2/export.php (rev 0)
+++ trunk/phpsqliteadmin2/export.php 2008-07-13 17:12:41 UTC (rev 45)
@@ -0,0 +1,75 @@
+<?php
+
+require_once('include.php');
+
+?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml">
+<head>
+ <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" />
+ <link href="phpsla.css" rel="stylesheet" type="text/css" />
+ <title>phpSQLiteAdmin</title>
+ <meta http-equiv="expires" content="0" />
+ <meta http-equiv="pragma" content="no-cache" />
+ <meta http-equiv="cache-control" content="no-cache" />
+ <script language="Javascript" src="javascript.txt" type="text/javascript"></script>
+</head>
+<body class="right">
+<?php
+
+print_top_links($_GET['object']);
+
+//$sth = sqlite_query($link,"select * from '{$table->name}' limit 30");
+//$sth = sqlite_query($link,"select * from '{$table->name}'");
+
+print "<h3>Export Table '".$_GET['object']."'</h3>\n";
+
+// Get table schema
+$table_schema = "";
+$userdbh->query('select sql from sqlite_master');
+while($row = $userdbh->fetchArray()) {
+ if (strpos($row[0], "table " .$_GET['object'])) {
+ $table_schema = "/*\nTable structure for table '" .$_GET['object']. "'\n*/\n";
+ $table_schema .= $row[0]. ";\n\n";
+ }
+}
+
+// Get columns
+$userdbh->query('select * from '.$_GET['object']);
+
+for ($i=0; $i<$userdbh->numFields(); $i++) {
+ $column[$i] = $userdbh->fieldName($i);
+}
+$columns = implode(", ", $column);
+
+// Get row values
+while($row = $userdbh->fetchArray()) {
+ $nr_fields = count($row);
+ /*
+ for ($i=0; $i<$nr_fields; $i++) {
+ //$value = htmlentities($row[$i],ENT_QUOTES,$encoding);
+ $value[$i] = $row[$i];
+ }
+ print_r($value);
+ */
+ $values = implode("', '", $row);
+ $values = "'" .$values. "'";
+ $queries .= "INSERT INTO " .$_GET['object']. " (" .$columns. ") VALUES
+(" .$values. ");\n";
+}
+
+$queries = "/*\nSQL data dump for table '" .$_GET['object']. "'\n*/\n" .$queries;
+
+// Generation information
+$generated_by = "/*\nphpSQLiteAdmin SQL Export
+-- Generated On " .date("D, j M Y H:i:s T"). "
+-- SQLite Version " .$sqliteversion. "
+-- PHP Version " .$sqliteversion. "\n*/\n\n";
+// Show export
+print "<textarea name=\"sql\" rows=\"16\" cols=\"80\">" .$generated_by. "" .$table_schema. "" .$queries. "</textarea>";
+
+print "</body>\n";
+print "</html>\n";
+
+
+?>
Modified: trunk/phpsqliteadmin2/javascript.txt
===================================================================
--- trunk/phpsqliteadmin2/javascript.txt 2008-07-13 10:03:11 UTC (rev 44)
+++ trunk/phpsqliteadmin2/javascript.txt 2008-07-13 17:12:41 UTC (rev 45)
@@ -17,6 +17,14 @@
}
}
+function confirm_delete_row() {
+ Check = confirm("Delete this row ?");
+ if (Check == true) {
+ return true;
+ } else {
+ return false;
+ }
+}
function confirm_drop_index() {
Check = confirm("Drop this index ?");
Added: trunk/phpsqliteadmin2/row_edit.php
===================================================================
--- trunk/phpsqliteadmin2/row_edit.php (rev 0)
+++ trunk/phpsqliteadmin2/row_edit.php 2008-07-13 17:12:41 UTC (rev 45)
@@ -0,0 +1,182 @@
+<?php
+
+require_once('include.php');
+
+// Query (form submitted) portion
+if ($_POST['type'] == "edit") {
+
+ if (!$_GET['primary_key']) {
+ print "Table needs a primary key identifier.";
+ exit();
+ }
+
+ //print "<h3>Edit Row</h3>";
+
+ foreach (array_keys($_POST) as $column) {
+ // Only do columns, not $_POST['type'] and so on...
+ if (strstr($column, "column__") !== false) {
+ $columns .= ", " .str_replace("column__", "", $column). " = '" .$_POST[$column]. "'";
+ }
+ //echo $column. "<br>";
+
+ }
+ // Clean up columns:
+ $columns = "randomkeytoberemoved" .$columns;
+ $columns = str_replace("randomkeytoberemoved, ", "", $columns);
+ //print $columns;
+
+ $userdbh->query("UPDATE " .$_POST['object']. " SET " .$columns. " WHERE " .$_POST['primary_key']. " = '" .$_POST['row']. "'");
+ $_SESSION['phpSQLiteAdmin_currentdb'] = '';
+ header("Location: table_browse.php?object=" .$_POST['object']. "");
+ exit();
+
+} else if ($_POST['type'] == "add") {
+
+ //print "<h3>Add Row</h3>";
+
+ foreach (array_keys($_POST) as $column) {
+ // Only do columns, not $_POST['type'] and so on...
+ if (strstr($column, "column__") !== false) {
+ $columns .= str_replace("column__", "", $column). ", ";
+ $values .= "'" .$_POST[$column]. "', ";
+ }
+ //echo $column. "<br>";
+
+ }
+ // Clean up columns/values:
+ $columns = $columns. "randomkeytoberemoved";
+ $columns = str_replace(", randomkeytoberemoved", "", $columns);
+ $values = $values. "randomkeytoberemoved";
+ $values = str_replace(", randomkeytoberemoved", "", $values);
+ //print $columns. "<br>";
+ //print $values;
+
+ $userdbh->query("INSERT INTO " .$_POST['object']. "(" .$columns. ") VALUES(" .$values. ")");
+ header("Location: table_browse.php?object=" .$_POST['object']. "");
+ exit();
+
+}
+if ($_GET['type'] == "delete") {
+ if (!$_GET['primary_key']) {
+ print "Table needs a primary key identifier.";
+ exit();
+ }
+
+ $userdbh->query("delete from ".$_GET['object']. " where " .$_GET['primary_key']. " = '" .$_GET['row']. "'");
+ header("Location: table_browse.php?object=" .$_GET['object']. "");
+ exit();
+}
+
+?>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">
+<html>
+<head>
+ <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
+ <title>phpSQLiteAdmin</title>
+ <meta http-equiv="expires" content="0">
+ <script language="Javascript" src="javascript.txt" type="text/javascript"></script>
+ <link href="phpsla.css" rel="stylesheet" type="text/css">
+</head>
+<body class="right">
+<?php
+
+print_top_links($_GET['object']);
+
+// Show main content: add or edit a row form.
+if (!$_GET['row']) {
+ $type = "add";
+} else {
+ $type = "edit";
+}
+
+if (!$_GET['object']) {
+ print "Error: No table selected.";
+}
+
+if ($type == "edit") {
+ print "<h3>Edit Row from Table '{$_GET['object']}'</h3>\n";
+} else {
+ print "<h3>Add Row to Table '{$_GET['object']}'</h3>\n";
+}
+
+print "<form action=\"row_edit.php\" method=\"post\">";
+print "<table border=\"1\">\n";
+print "<tr><th>Column</th><th>Type</th><th>Value</th></tr>\n";
+$userdbh->_setTableInfo($_GET['object']);
+$cols = $userdbh->getColsType();
+$k = 0;
+while (list($key,$value) = each($cols)) {
+ $col_name[$k] = $key;
+ $col_value[$k] = strtolower($value);
+
+ // Clean up col_value to only display databtype.
+ if ($col_value[$k] == "") { $col_value[$k] = "typeless"; }
+ //if (strpos(strtolower(" " .$col_value[$k]. " "), "text")) { $col_value[$k] = "text"; }
+ $col_value[$k] = str_replace("not null", "", $col_value[$k]);
+ $col_value[$k] = str_replace("null", "", $col_value[$k]);
+ $col_value[$k] = str_replace("primary key", "", $col_value[$k]);
+ $col_value[$k] = str_replace("default", "", $col_value[$k]);
+ $col_value[$k] = preg_replace("/\'[^>]*\'/iU", "", $col_value[$k]);
+ $col_value[$k] = preg_replace("/\"[^>]*\"/iU", "", $col_value[$k]);
+
+ $k++;
+}
+
+if ($type == "edit") {
+ $userdbh->query("select * from ".$_GET['object']. " where " .$_GET['primary_key']. " = '" .$_GET['row']. "'");
+ //$userdbh->query('select * from '.$_GET['object']);
+ while($row = $userdbh->fetchArray()) {
+ $nr_fields = count($row);
+ for ($i=0; $i<$nr_fields; $i++) {
+ print "<tr>\n";
+ print "<td>" .$col_name[$i]. "</td>\n";
+ print "<td>" .$col_value[$i]. "</td>\n";
+ if (strpos(" " .$col_value[$i]. " ", "text")) {
+ print "<td><textarea name=\"column__" .$col_name[$i]. "\">" .$row[$i]. "</textarea></td>\n";
+ } else {
+ print "<td><input type=\"text\" name=\"column__" .$col_name[$i]. "\" value=\"" .$row[$i]. "\" /></td>\n";
+ }
+ print "</tr>\n";
+ }
+ }
+} else {
+ $nr_fields = count($col_name);
+ for ($i=0; $i<$nr_fields; $i++) {
+ print "<tr>\n";
+ print "<td>" .$col_name[$i]. "</td>\n";
+ print "<td>" .$col_value[$i]. "</td>\n";
+ if (strpos(" " .$col_value[$i]. " ", "text")) {
+ print "<td><textarea name=\"column__" .$col_name[$i]. "\"></textarea></td>\n";
+ } else {
+ print "<td><input type=\"text\" name=\"column__" .$col_name[$i]. "\" value=\"\" /></td>\n";
+ }
+ print "</tr>\n";
+ }
+}
+print "</table>\n";
+print "<input type=\"hidden\" name=\"row\" value=\"" .$_GET['row']. "\" />\n";
+print "<input type=\"hidden\" name=\"primary_key\" value=\"" .$_GET['primary_key']. "\" />\n";
+print "<input type=\"hidden\" name=\"object\" value=\"" .$_GET['object']. "\" />\n";
+print "<input type=\"hidden\" name=\"type\" value=\"" .$type. "\" />\n";
+print "<input type=\"submit\" name=\"\" value=\"Save\" />\n";
+print "<input type=button value=\"Cancel\" onclick=\"history.back();\">";
+print "</form>";
+
+/*
+print "<table border=1>\n";
+print "<tr><th>Column</th><th>Type</th></tr>\n";
+$userdbh->_setTableInfo($_GET['object']);
+$cols = $userdbh->getColsType();
+while (list($key,$value) = each($cols)) {
+ print "<tr><td>$key</td><td>$value</td></tr>\n";
+}
+print "</table>\n";
+
+print "<p>Rows in table: ".$userdbh->numRows($_GET['object'])."</p>\n";
+*/
+
+print "</body>\n";
+print "</html>\n";
+
+
+?>
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <yg...@us...> - 2008-07-13 10:03:02
|
Revision: 44
http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=44&view=rev
Author: yglodt
Date: 2008-07-13 03:03:11 -0700 (Sun, 13 Jul 2008)
Log Message:
-----------
remove testing line, svn seems to work, yay!
Modified Paths:
--------------
trunk/phpsqliteadmin2/todo.txt
Modified: trunk/phpsqliteadmin2/todo.txt
===================================================================
--- trunk/phpsqliteadmin2/todo.txt 2008-07-13 10:02:28 UTC (rev 43)
+++ trunk/phpsqliteadmin2/todo.txt 2008-07-13 10:03:11 UTC (rev 44)
@@ -18,8 +18,6 @@
- Privilege checks for databases?
- - test
-
Old Todo:
- you can add an alias database w/out the alias filled, which is bad...
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <yg...@us...> - 2008-07-13 10:02:20
|
Revision: 43
http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=43&view=rev
Author: yglodt
Date: 2008-07-13 03:02:28 -0700 (Sun, 13 Jul 2008)
Log Message:
-----------
test of svn repo
Modified Paths:
--------------
trunk/phpsqliteadmin2/todo.txt
Modified: trunk/phpsqliteadmin2/todo.txt
===================================================================
--- trunk/phpsqliteadmin2/todo.txt 2008-07-12 23:37:07 UTC (rev 42)
+++ trunk/phpsqliteadmin2/todo.txt 2008-07-13 10:02:28 UTC (rev 43)
@@ -17,6 +17,8 @@
- Feel free to add more. I was unsure of a few of entries in the old todo's.
- Privilege checks for databases?
+
+ - test
Old Todo:
- you can add an alias database w/out the alias filled, which is bad...
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: Yves G. <yg...@mi...> - 2008-07-13 09:57:48
|
Hi, On Sun, 2008-07-13 at 04:54 +0000, Slythfox wrote: > Yeah: > $ cvs -z3 > -d:ext:sly...@ph...:/cvsroot/phpsqliteadmin add phpsqliteadmin2/row_edit.php -m "Initial import" > cvs add: in directory .: > cvs [add aborted]: there is no version here; do 'cvs checkout' first Hmm, I am clueless about this... but wait > As for svn, I'm not sure how you got it to work, because it seems to > me that svn isn't set up for the phpsqliteadmin project. True, I wanted to say that I use svn for my other projects, but never converted phpsla to it, but.... :-) I did it now, by dumping the CVS from about 1 hour ago (11:00 AM here at GMT+1) and importing it into SVN http://phpsqliteadmin.svn.sourceforge.net/viewvc/phpsqliteadmin/trunk/ I suggest that we check it out all, and forget about the CVS repo, and only work in the svn from now on, what do you think about that? Regards, Yves > (And sourceforge's documentation on using svn with SF projects is > worse...) > > On the bright side, I'm happy to say I got a simple table exporter to > work for phpSQLiteadmin. Wow that's nice to hear, I will check it out > - C Hale > > On Sun, Jul 13, 2008 at 12:12 AM, Yves Glodt <yg...@mi...> wrote: > On Sunday 13 July 2008, Slythfox wrote: > > Wow, sorry for all the separate dev list emails for these > revisions! > > > > I suppose there's a way to simple update everything at the > same time? > > > I use svn mainly, and a simple "svn commit" in the root-folder > of the > project does that. I do not remember much about cvs at all... > just > remember svn is quite similar to it... sorry > > > I have to figure out how to add files now. When I try to add > files, > > it outputs this: cvs [add aborted]: there is no version > here; do 'cvs > > checkout' first > > > To cite the svn-equivalent, did you try "cvs add > filename.php"? > > regards, > Yves > > > The problem is, it won't let me checkout a non-existent > file. |
|
From: Slythfox <sly...@gm...> - 2008-07-13 04:54:45
|
Yeah: $ cvs -z3 -d:ext:sly...@ph...:/cvsroot/phpsqliteadmin add phpsqliteadmin2/row_edit.php -m "Initial import" cvs add: in directory .: cvs [add aborted]: there is no version here; do 'cvs checkout' first As for svn, I'm not sure how you got it to work, because it seems to me that svn isn't set up for the phpsqliteadmin project. (And sourceforge's documentation on using svn with SF projects is worse...) On the bright side, I'm happy to say I got a simple table exporter to work for phpSQLiteadmin. - C Hale On Sun, Jul 13, 2008 at 12:12 AM, Yves Glodt <yg...@mi...> wrote: > On Sunday 13 July 2008, Slythfox wrote: > > Wow, sorry for all the separate dev list emails for these revisions! > > > > I suppose there's a way to simple update everything at the same time? > > I use svn mainly, and a simple "svn commit" in the root-folder of the > project does that. I do not remember much about cvs at all... just > remember svn is quite similar to it... sorry > > > I have to figure out how to add files now. When I try to add files, > > it outputs this: cvs [add aborted]: there is no version here; do 'cvs > > checkout' first > > To cite the svn-equivalent, did you try "cvs add filename.php"? > > regards, > Yves > > > The problem is, it won't let me checkout a non-existent file. > > > ------------------------------------------------------------------------- > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > _______________________________________________ > Phpsqliteadmin-devel mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel > |
|
From: Yves G. <yg...@mi...> - 2008-07-13 00:12:34
|
On Sunday 13 July 2008, Slythfox wrote: > Wow, sorry for all the separate dev list emails for these revisions! > > I suppose there's a way to simple update everything at the same time? I use svn mainly, and a simple "svn commit" in the root-folder of the project does that. I do not remember much about cvs at all... just remember svn is quite similar to it... sorry > I have to figure out how to add files now. When I try to add files, > it outputs this: cvs [add aborted]: there is no version here; do 'cvs > checkout' first To cite the svn-equivalent, did you try "cvs add filename.php"? regards, Yves > The problem is, it won't let me checkout a non-existent file. |
|
From: Slythfox <sly...@gm...> - 2008-07-12 23:59:43
|
Wow, sorry for all the separate dev list emails for these revisions! I suppose there's a way to simple update everything at the same time? I have to figure out how to add files now. When I try to add files, it outputs this: cvs [add aborted]: there is no version here; do 'cvs checkout' first The problem is, it won't let me checkout a non-existent file. On Sat, Jul 12, 2008 at 10:43 PM, Yves Glodt <yg...@mi...> wrote: > On Friday 11 July 2008, Slythfox wrote: > > I'm new to CVS. I'm able to login. But I'm having some trouble > > committing to CVS. > > Except it won't commit because of no specified CVSROOT. I tried > > messing around with CVSROOT and couldn't get anything to work. > > Did you try to make a new checkout as described here: > http://sourceforge.net/cvs/?group_id=101528 ("Developer CVS Access via > SSH") > > hth, > > Yves > > > I saw that someone had created a phpsqliteadmin website layout and > > logo. It'd be nice to at least have the logo to put in to > > phpsqliteadmin. > > > > On Fri, Jul 11, 2008 at 4:35 AM, Felipe Lopes <ff...@gm...> wrote: > > > Welcome to the team, Hale! > > > > > > On Thu, Jul 10, 2008 at 5:27 PM, Yves Glodt <yg...@mi...> wrote: > > > > On Thursday 10 July 2008, Slythfox wrote: > > > >> Hey, I'm here to help start up phpSQLiteAdmin again. I started > > > >> using it recently and realized there were some lacking features. > > > > > > > > This is great news, welcome in our small team! > > > > > > > >> The first problem was the magic quotes issue with queries... > > > >> which it seems I've fixed. > > > >> I also wanted the ability to see the column names when browsing > > > >> tables. > > > >> And probably most useful, the ability to easily add and edit > > > >> table rows, although it doesn't work perfectly. > > > >> I'm sure there's more that needs to be done, too. > > > > > > > > well for sure... :-) > > > > > > > >> Apparently the code in the CVS is newer than I code I used to > > > >> modify it, so I'll have to look at that. > > > > > > > > There were some commits done after the 0.2 release... on the road > > > > to 0.3 > > > > > > > > The changelog has them actually: > > > > > > http://phpsqliteadmin.cvs.sourceforge.net/phpsqliteadmin/phpsqlitea > > >dmin/changelog.txt?view=log > > > > > > > Also, tell me if you are able to commit. Hopefully I set up > > > > everything correctly in sf.net for your user > > > > > > > > Yves > > > > > > > >> - C Hale > > > > > > > > ----------------------------------------------------------------- > > > >-------- Sponsored by: SourceForge.net Community Choice Awards: > > > > VOTE NOW! Studies have shown that voting for your favorite open > > > > source project, along with a healthy diet, reduces your potential > > > > for chronic lameness and boredom. Vote Now at > > > > http://www.sourceforge.net/community/cca08 > > > > _______________________________________________ > > > > Phpsqliteadmin-devel mailing list > > > > Php...@li... > > > > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel > > > > > > ------------------------------------------------------------------- > > >------ Sponsored by: SourceForge.net Community Choice Awards: VOTE > > > NOW! Studies have shown that voting for your favorite open source > > > project, along with a healthy diet, reduces your potential for > > > chronic lameness and boredom. Vote Now at > > > http://www.sourceforge.net/community/cca08 > > > _______________________________________________ > > > Phpsqliteadmin-devel mailing list > > > Php...@li... > > > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel > > > ------------------------------------------------------------------------- > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > _______________________________________________ > Phpsqliteadmin-devel mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel > > |
|
From: Slythfox <sly...@us...> - 2008-07-12 23:36:59
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin2 In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30548/phpsqliteadmin2 Modified Files: phpsla.css Log Message: images have no border by default Index: phpsla.css =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin2/phpsla.css,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- phpsla.css 24 Jul 2005 12:59:39 -0000 1.1.1.1 +++ phpsla.css 12 Jul 2008 23:37:07 -0000 1.2 @@ -1,11 +1,14 @@ -body,td,th,p,a,li,select,input { +body,td,th,p,a,li,select,input,textarea { font-family:Verdana,Arial,sans-serif; font-size:11px; } +img { + border : 0; +} body.left { - background-color:#effeff; + background-color:#eef1f4; } @@ -18,10 +21,9 @@ margin:1px; } - h1,h2,h3,h4,h5,h6 { font-family:Verdana,Arial,sans-serif; - text-decoration:underline; + text-decoration:none; } |
|
From: Slythfox <sly...@us...> - 2008-07-12 23:35:52
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin2 In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29832/phpsqliteadmin2 Modified Files: table_browse.php Log Message: Added edit/delete icons. Index: table_browse.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin2/table_browse.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- table_browse.php 24 Jul 2005 12:59:38 -0000 1.1.1.1 +++ table_browse.php 12 Jul 2008 23:36:00 -0000 1.2 @@ -25,12 +25,20 @@ print "<h3>Table '".$_GET['object']."'</h3>\n"; print "<table>\n"; +// Get table columns. +$userdbh->_setTableInfo($_GET['object']); +$cols = $userdbh->getColsType(); + $userdbh->query('select * from '.$_GET['object']); -print "<tr>\n"; +print "<tr>\n<th></th>\n<th></th>\n"; for ($i=0; $i<$userdbh->numFields(); $i++) { print "<th>" . $userdbh->fieldName($i) . "</th>\n"; + if (strpos(strtolower($cols[$userdbh->fieldName($i)]), "primary")) { + $primary_key = $userdbh->fieldName($i); // The field name of the primary key. + $primary_key_order = $i; // The "order" of the primary key (to be used to fetch the field's value for a given row). + } } print "</tr>\n"; @@ -40,6 +48,8 @@ //$rows = $userdbh->returnRows('num'); //$table->print_header(); print "<tr>\n"; + print "<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "\"><img src=\"images/edit.png\" alt=\"Edit\" title=\"Edit\" /></a></td> +<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "&type=delete\" onclick=\"return confirm_delete_row();\"><img src=\"images/delete.png\" alt=\"Delete\" title=\"Delete\" /></a></td>\n"; for ($i=0; $i<$nr_fields; $i++) { if (strlen($row[$i]) > 50) { print '<td>'.substr(htmlentities($row[$i],ENT_QUOTES,$encoding),0,50)."...</td>\n"; @@ -56,4 +66,4 @@ print "</html>\n"; -?> \ No newline at end of file +?> |
|
From: Slythfox <sly...@us...> - 2008-07-12 23:35:23
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin2 In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29816/phpsqliteadmin2 Modified Files: todo.txt Log Message: Updated todo with more recent entries Index: todo.txt =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin2/todo.txt,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- todo.txt 24 Jul 2005 12:59:38 -0000 1.1.1.1 +++ todo.txt 12 Jul 2008 23:35:31 -0000 1.2 @@ -1,3 +1,24 @@ +Revised Todo (July, 10, 2008): + + - Don't allow the removal of the phpsla.sqlite alias. + + - Error checking for adding database aliases. How should general error handling work? + + - Add row adding/editing/deleting. (I have a basic implimentation. -chale) + + - When displaying the phpsqliteadmin version, it should display the number within the configuration table of the phpsla.sqlite database. + + - (?) Reorganization of the main page: Main area should display phpsqliteadmin version, sqlite version, list all of the databases, have a database creation form/alias configuration links. + + - Newer layout... use something like $pg['content'] .= "content" to update content rather than using print. That way we only need one layout file, and a layout inclusion at the end of every page. The sidebar should have that phpsqliteadmin logo as well. + + - Better icons! + + - Feel free to add more. I was unsure of a few of entries in the old todo's. + + - Privilege checks for databases? + +Old Todo: - you can add an alias database w/out the alias filled, which is bad... - you can remove phpsla.sqlite alias, which is bad as well |
|
From: Slythfox <sly...@us...> - 2008-07-12 23:34:13
|
Update of /cvsroot/phpsqliteadmin/phpsqliteadmin2 In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29418/phpsqliteadmin2 Modified Files: leftframe.php Log Message: Added browse table img Index: leftframe.php =================================================================== RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin2/leftframe.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- leftframe.php 24 Jul 2005 12:59:34 -0000 1.1.1.1 +++ leftframe.php 12 Jul 2008 23:34:21 -0000 1.2 @@ -38,7 +38,7 @@ print "<li class=\"list_title\" title=\"Tables in database $current_db\">Tables</li>\n"; $userdbh->query("select name,upper(name) from SQLITE_MASTER where type = 'table' order by 2"); while($row = $userdbh->fetchArray()) { - print '<li><a href="table_structure.php?object='.$row[0]."\">$row[0]</a></li>\n"; + print "<li><a href=\"table_browse.php?object=".$row[0]."\"><img src=\"images/table_browse.png\" alt=\"Browse table\" title=\"Browse table\" /></a> <a href=\"table_structure.php?object=".$row[0]."\">$row[0]</a></li>\n"; } print "</ul>\n</div>\n"; } @@ -48,4 +48,4 @@ print "</html>\n"; -?> \ No newline at end of file +?> |
2 messages has been excluded from this view by a project administrator.