phpsqliteadmin-devel — phpSQLiteAdmin developer mailing list

[Phpsqliteadmin-devel] phpsqliteadmin leftframe.php,1.1.1.1,1.2

[Felipe L. <fel...@us...>]

Update of /cvsroot/phpsqliteadmin/phpsqliteadmin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4396

Modified Files:
	leftframe.php 
Log Message:

added the logoff link


Index: leftframe.php
===================================================================
RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/leftframe.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- leftframe.php	11 May 2004 18:23:21 -0000	1.1.1.1
+++ leftframe.php	21 May 2004 17:26:26 -0000	1.2
@@ -17,7 +17,10 @@
 <a href="index.php" target="_top">Main</a>
 <br>
 <a href="dbconfig.php">Alias configuration</a>
-<br><br>
+<br>
+<a href="login.php?logoff=1" target="_top">Logoff</a>
+<br>
+<br>
 EOT;
 
 print "<div class=\"list\">\n";
@@ -43,4 +46,4 @@
 print "</html>\n";
 
 
-?>
\ No newline at end of file
+?>

[Phpsqliteadmin-devel] phpsqliteadmin login.class.php,NONE,1.1

[Felipe L. <fel...@us...>]

Update of /cvsroot/phpsqliteadmin/phpsqliteadmin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3777

Added Files:
	login.class.php 
Log Message:

method colection to login system


--- NEW FILE: login.class.php ---
<?php

include_once("SPSQLite.class.php");

class login extends SPSQLite
{
    var $_user;
    var $_pass;
    
    // {{{ function login()
    
    function login($user, $pass)
    {
        $this->_user = $user;
        $this->_pass = md5($pass);
    }

    // }}}

    // {{{ function checkLogin()

    function checkLogin()
    {        
        $query = "SELECT * FROM users WHERE login = '$this->_user'";
        $this->query($query);

        if ($this->numRows() == 1) {
            while ($row = $this->fetchArray("assoc")) {
                if (($row['login'] == $this->_user) && ($row['password'] == $this->_pass)) {
                    $this->sessionStart();
                    $_SESSION['auth'] = "ok";
                    return true;
                } else {
                    return false;
                }
            }
        } else {
            return false;
        }
    }

    // }}}

    // {{{ function register()

    function register($realname, $email)
    {
        $query = "INSERT INTO users (login, password, realname, email) VALUES ('$this->_user', '$this->_pass', '$realname', '$email')";
        $this->query($query);
    }

    // }}}

    // {{{ function updateLogin()

    function updateLogin($pass)
    {
        $this->_pass = md5($pass);
        
        $query = "UPDATE users SET password = '$this->pass' WHERE login = '$this->user'";
        $this->query($query);
    }

    // }}}

    // {{{ function isEmpty()

    function isEmpty()
    {
        $query = "SELECT * FROM users";
        $this->query($query);
        
        if ($this->numRows() == 0) {
            return true;
        } else {
            return false;
        }
    }

    // }}}

    // {{{ function isLogged()

    function isLogged()
    {
        $this->sessionStart();
        if ((isset($_SESSION['auth']))  && ($_SESSION['auth'] == "ok")) {
            return true;
        } else {
            return false;
        }
    }

    // }}}

    // {{{ function logOff()

    function logOff()
    {
        $this->sessionStart();
        unset($_SESSION['auth']);
    }

    // }}}

    // {{{ function sessionStart()

    function sessionStart()
    {
        session_start();
    }

    // }}}
}

?>

[Phpsqliteadmin-devel] phpsqliteadmin login.php,NONE,1.1

[Felipe L. <fel...@us...>]

Update of /cvsroot/phpsqliteadmin/phpsqliteadmin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2660

Added Files:
	login.php 
Log Message:

 login page


--- NEW FILE: login.php ---
<?php

include_once("login.class.php");

$obj =& new login($_POST['user'], $_POST['pass']);
$obj->SPSQLite("phpsla.sqlite");

if ((isset($_GET['logoff'])) && ($_GET['logoff'] == 1)) {
    $obj->logOff();
}

if (isset($_POST['empty'])) {
    $obj->register($_POST['realname'], $_POST['email']);
} elseif (isset($_POST['notempty'])) {
    if ($obj->checkLogin()) {
        header("Location: index.php");
    }
}

?>
<html>
<head>
<title>phpSQLiteAdmin - Login</title>
</head>
<body>
<form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<table>
<tr>
<td>
User:
</td>
<td>
<input type="text" name="user">
</td>
</tr>
<tr>
<td>
Pass:
</td>
<td>
<input type="password" name="pass">
<?php

if ($obj->isEmpty()) {
    echo "</td></tr>";
    echo "<tr><td>Realname:</td><td><input type=\"text\" name=\"realname\"></td></tr>\n";
    echo "<tr><td>Email:</td><td><input type=\"text\" name=\"email\">\n";
    echo "<input type=\"hidden\" name=\"empty\">\n";
} else {
    echo "<input type=\"hidden\" name=\"notempty\">\n";
}

?>
<input type="submit" value="login" >
</td>
</tr>
</table>
</form>
</body>
</html>

[Phpsqliteadmin-devel] phpsqliteadmin check_login.php,NONE,1.1

[Felipe L. <fel...@us...>]

Update of /cvsroot/phpsqliteadmin/phpsqliteadmin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1828

Added Files:
	check_login.php 
Log Message:

file to be included on pages to be protected w/ login


--- NEW FILE: check_login.php ---
<?php

require_once("login.class.php");

$obj =& new login($_SESSION['user'], $_SESSION['pass']);
$obj->SPSQLite("phpsla.sqlite");

if (!$obj->isLogged()) {
    header("Location: login.php");
}

?>

[Phpsqliteadmin-devel] phpsqliteadmin index.php,1.1.1.1,1.2

[Felipe L. <fel...@us...>]

Update of /cvsroot/phpsqliteadmin/phpsqliteadmin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32248

Modified Files:
	index.php 
Log Message:

added code to check login


Index: index.php
===================================================================
RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/index.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- index.php	11 May 2004 18:23:21 -0000	1.1.1.1
+++ index.php	21 May 2004 17:05:03 -0000	1.2
@@ -1,5 +1,6 @@
 <?php
 
+include_once("check_login.php");
 require_once('include.php');
 
 ?>

[Phpsqliteadmin-devel] phpsqliteadmin todo.txt,1.2,1.3

[Yves G. <yg...@us...>]

Update of /cvsroot/phpsqliteadmin/phpsqliteadmin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3222

Modified Files:
	todo.txt 
Log Message:


added remark about hoster-mode + fixed a typo



Index: todo.txt
===================================================================
RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin/todo.txt,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** todo.txt	13 May 2004 20:06:18 -0000	1.2
--- todo.txt	13 May 2004 20:18:14 -0000	1.3
***************
*** 21,24 ****
  - add a warning if magic_quotes_gpc is ON
  
! - some kind of login, to prevent acces to everybody. Make it play nicely with hm.
    Maybe this needs a user table. well I guess it needs one. Felipe works in it.
--- 21,27 ----
  - add a warning if magic_quotes_gpc is ON
  
! - add some kind of login, to prevent acces to everybody. Make it play nicely with hm.
    Maybe this needs a user table. well I guess it needs one. Felipe works in it.
+ 
+ - finish "hoster-mode", which must play nicely with login
+ 

Re: [Phpsqliteadmin-devel] hey

[Steve D. <sd...@ne...>]

> >I kind of hit a snag in wondering how  
> > to display rows, and then an edit option.  The question is how to
> > index those rows if there is no index, etc.
> 
> This is tricky... I have not even thought about it.
> maybe use all the rows for the "where" clause? it's ugly, but at first
> thought it should work...

The other thought that occurred to me, was to pass the same query to 
the edit_row.php (or whatever the filename is) and then index on the 
row # from the table_browse.php.  So, for instance, if you're doing 
select * from my_table order by blah offset 30 limit 10;, and you 
want to edit the 5th row down, you would just pass that same query to 
the edit page, and then either jump to the 5th row in a loop, or add 
5 to the offset or something...

Sounds like it'd work in theory.  I'd have to actually try it to see.

Steve

Re: [Phpsqliteadmin-devel] hey

[Yves G. <yg...@mi...>]

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 31 March 2004 05:46, Steve Dibb wrote:
> > Hi Steve!
> >
> > any news so far :-) ?
> > I have to admit I did no changes so far... I am busy on something
> > else right now...
>
> Hey, I've been a bit busy too..

:-)

>I kind of hit a snag in wondering how =20
> to display rows, and then an edit option.  The question is how to
> index those rows if there is no index, etc.

This is tricky... I have not even thought about it.
maybe use all the rows for the "where" clause? it's ugly, but at first=20
thought it should work...


> I've been borrowing principles from phpMyAdmin a bit, but man .. that
> is some tight code.  I'm still tweaking a bit, nothing really
> presentable to say the least. :)

:-) cu!

Yves

> Steve
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dcli=
ck
> _______________________________________________
> Phpsqliteadmin-devel mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel

=2D --=20
Linux 2.4.25 #2 Tue Mar 9 19:24:24 CET 2004 i686
 22:04:48 up  1:11,  1 user,  load average: 0.00, 0.00, 0.00
=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAayWsfmxiTOp0sQYRAjUyAJ4peBe9yzkAHmKpu8Bw8kgBNEElUwCfe33O
OVsYJ879JFb4vSM/Su6KoEs=3D
=3D8/Q0
=2D----END PGP SIGNATURE-----

Re: [Phpsqliteadmin-devel] hey

[Steve D. <sd...@ne...>]

> Hi Steve!
> 
> any news so far :-) ?
> I have to admit I did no changes so far... I am busy on something else
> right now...

Hey, I've been a bit busy too.. I kind of hit a snag in wondering how 
to display rows, and then an edit option.  The question is how to 
index those rows if there is no index, etc.

I've been borrowing principles from phpMyAdmin a bit, but man .. that 
is some tight code.  I'm still tweaking a bit, nothing really 
presentable to say the least. :)

Steve

Re: [Phpsqliteadmin-devel] hey

[Yves G. <yg...@mi...>]

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 25 March 2004 09:42, Steve Dibb wrote:
> > > BTW, do you guys have a roadmap for what you want in the next
> > > versions?
> >
> > well not really a roadmap, but you can take a look at the todo.txt
> > file
>
> Okay, I didn't see that before ... thanks. :)
>
> One thing I've fixed already is that table_browse.php has a row
> displaying the column names, using sqlite_field_name.  Also working
> on a way to edit / drop rows as well.

Hi Steve!

any news so far :-) ?
I have to admit I did no changes so far... I am busy on something else=20
right now...

hope to hear from you,
Yves

> Steve
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dcli=
ck
> _______________________________________________
> Phpsqliteadmin-devel mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel

=2D --=20
Linux 2.4.25 #2 Tue Mar 9 19:24:24 CET 2004 i686
 20:19:55 up  2:59,  1 user,  load average: 0.30, 0.25, 0.21
=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAabrifmxiTOp0sQYRAlr0AJ4xtxcEDlUdtSh7nPVLe0la1GhrNwCfVQwd
UEtBVo80pqFt5N5AVtS7RJk=3D
=3D6n1U
=2D----END PGP SIGNATURE-----

[Phpsqliteadmin-devel] null values

[Steve D. <sd...@ne...>]

Okay, scratch the whole null values thing.  I realized I was doing it 
wrong.

This works:

	if($arr['5'] === '')
		echo "blank";

	if($arr['5'] === null)
		echo "null";

Steve

Re: [Phpsqliteadmin-devel] hey

[Yves G. <yg...@mi...>]

>> > BTW, do you guys have a roadmap for what you want in the next
>> > versions?
>>
>> well not really a roadmap, but you can take a look at the todo.txt
>> file
>
> Okay, I didn't see that before ... thanks. :)
>
> One thing I've fixed already is that table_browse.php has a row
> displaying the column names, using sqlite_field_name.  Also working  on
> a way to edit / drop rows as well.

hey Steve you rock!

Other question, are you familiar with cvs?
Maybe we should use it at sf...
I gotta go now since I'm at the job and a little busy...
cu later


> Steve
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Phpsqliteadmin-devel mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel

Re: [Phpsqliteadmin-devel] hey

[Steve D. <sd...@ne...>]

> > BTW, do you guys have a roadmap for what you want in the next
> > versions?
> 
> well not really a roadmap, but you can take a look at the todo.txt
> file

Okay, I didn't see that before ... thanks. :)

One thing I've fixed already is that table_browse.php has a row 
displaying the column names, using sqlite_field_name.  Also working 
on a way to edit / drop rows as well.

Steve

Re: [Phpsqliteadmin-devel] hey

[Steve D. <sd...@ne...>]

> if ($var == '') checks for an empty string (which is e.g.an empty 
form
> variable)
> 
> if ($var == NULL) checks for NULL, check this
> http://php.oregonstate.edu/manual/en/language.types.null.php

I was afraid you were going to say that ... in both cases, it's 
returning true, even though when I go in the database and manually 
set the field to NULL or '' and then select on that same criteria, it 
pulls it up okay.  As far as I can tell, when pulling any field out 
of sqlite that is NULL, php sets the variable to ''

Ill have to try it on another database and see if that's the case 
there as well.

$db = sqlite_open('steve.sqlite', 0666, $sqliteerror) or 
die($sqliteerror);
$sql = "SELECT * FROM table WHERE some_field = NULL";
$res = sqlite_query($db, $sql);

	and

print_r($row1=sqlite_fetch_array($res));

	or

while($row = sqlite_fetch_array($res)) {
	$nr_fields = count($row);
	for ($i=0; $i<$num_fields; $i++) {
		if($row[$i] == NULL && $row[$i] != '') {
			print "<i>NULL</i>\n";
		} elseif($row[$i] == '') {
			print "empty\n";
		} else {
			print "$row[$i]\n";
		}
	}
}


Steve

Re: [Phpsqliteadmin-devel] hey

[Yves G. <yg...@mi...>]

> Hey guys, hows it going.
>
> I got a quick question I can't seem to find the answer to.  How can  you
> tell if a field value is NULL using php?

if ($var == '') checks for an empty string (which is e.g.an empty form
variable)

if ($var == NULL) checks for NULL, check this
http://php.oregonstate.edu/manual/en/language.types.null.php

> I suppose you could use
> sqlite_fetch_single for each field, but that seems like overkill.
>
> BTW, do you guys have a roadmap for what you want in the next
> versions?

well not really a roadmap, but you can take a look at the todo.txt file

> I just barely started picking up on sqlite and I must say
> this little db is very cool.  I'd like to hack on the script a bit,  but
> so far I'm already making it exclusive to php5 and up.
>
> Anyway, Ive got a few ideas of my own, and I'll be submitting some
> patches here pretty soon, but just wanted to see what you got in
> mind. :)

ok go ahead!

> Steve
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Phpsqliteadmin-devel mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel

[Phpsqliteadmin-devel] hey

[Steve D. <sd...@ne...>]

Hey guys, hows it going.

I got a quick question I can't seem to find the answer to.  How can 
you tell if a field value is NULL using php?  I suppose you could use 
sqlite_fetch_single for each field, but that seems like overkill.

BTW, do you guys have a roadmap for what you want in the next 
versions?  I just barely started picking up on sqlite and I must say 
this little db is very cool.  I'd like to hack on the script a bit, 
but so far I'm already making it exclusive to php5 and up.

Anyway, Ive got a few ideas of my own, and I'll be submitting some 
patches here pretty soon, but just wanted to see what you got in 
mind. :)

Steve

[Phpsqliteadmin-devel] Re: latest dev release

[Yves G. <yg...@mi...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 24 March 2004 21:17, you wrote:
> Hey there,

hi!

> I started using sqlite and phpsqliteadmin today.  Pretty
>
> sweet stuff.  I'd like to hack on the php scripts a bit, but

that's nice to hear!

> was wondering if you had a more recent developer's version
>
> that I could work on.

I attach what I call "0.3-dev", but there have been no significant
changes (if changes at all) since 0.2.
(It's a bzip2 since sf.net seems to block zip-attachments)


Let us (Felipe and me) know that you think about,

regards,
Yves


p.s.
If you feel like, you can subscribe to the ML:
http://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel

> Thanks man
>
>
>
> Steve

- --
Linux 2.4.25 #2 Tue Mar 9 19:24:24 CET 2004 i686
 21:41:53 up 44 min,  1 user,  load average: 0.05, 0.06, 0.07


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAYfaafmxiTOp0sQYRAsfxAJ0fmX4y2a0f+d5N840pH6/hC2/4bwCcDzGt
ifVnFMNjuUlzVCy7rdz1+G4=
=FOCi
-----END PGP SIGNATURE-----

[Phpsqliteadmin-devel] 0.2 Released

[Yves G. <yg...@mi...>]

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


=46or those who haven't noticed, phpSQLiteAdmin 0.2 is out, see all=20
information at it's new website: http://phpsqliteadmin.sourceforge.net

regards,
Yves


the mailinglist ph...@mi... is soon to be removed, the new list will=20
be: http://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel

=2D --=20
Linux 2.4.25 #1 Wed Feb 18 18:48:18 CET 2004 i686
 22:12:02 up  1:13,  1 user,  load average: 0.22, 0.22, 0.17
=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFATOJDfmxiTOp0sQYRAprsAJ0bSjhQuyBG2GPnrrD0CamrEQHoAQCeMpbR
U4bQF0sd6IBWy4tNGZm+GEA=3D
=3DkGtA
=2D----END PGP SIGNATURE-----

[Phpsqliteadmin-devel] test

[Yves G. <yg...@mi...>]

-- 
Linux 2.4.25 #1 Wed Feb 18 18:48:18 CET 2004 i686
 22:59:25 up  5:20,  1 user,  load average: 1.07, 0.52, 0.46