document.write('<div class="asp" style="font-family: monospace;"><br />');
document.write('<span style="color: #0000ff; font-weight: bold;">&lt;%</span><br />');
document.write('const TBL_LOGIN&nbsp; = <span style="color: #cc0000;">&quot;users_table_name&quot;</span><br />');
document.write('const FLD_PASS&nbsp; = <span style="color: #cc0000;">&quot;password_field_name&quot;</span><br />');
document.write('const DB_NAME&nbsp; &nbsp;= <span style="color: #cc0000;">&quot;db_name&quot;</span> <br />');
document.write('<br />');
document.write('<span style="color: #990099; font-weight: bold;">Dim</span> dbconnection <br />');
document.write('<span style="color: #990099; font-weight: bold;">Set</span> dbConnection = <span style="color: #990099; font-weight: bold;">server</span>.<span style="color: #330066;">CreateObject</span><span style="color: #006600; font-weight:bold">&#40;</span><span style="color: #cc0000;">&quot;ADODB.Connection&quot;</span><span style="color: #006600; font-weight:bold">&#41;</span> <br />');
document.write('<br />');
document.write('<span style="color: #990099; font-weight: bold;">Dim</span> strConnection<br />');
document.write('strConnection = <span style="color: #cc0000;">&quot;PROVIDER=Microsoft.Jet.OLEDB.4.0;&quot;</span> &amp; _<br />');
document.write('<span style="color: #cc0000;">&quot;Data Source=&quot;</span> &amp; <span style="color: #990099; font-weight: bold;">Server</span>.<span style="color: #330066;">MapPath</span><span style="color: #006600; font-weight:bold">&#40;</span>DB_NAME<span style="color: #006600; font-weight:bold">&#41;</span><br />');
document.write('<br />');
document.write('dbConnection.<span style="color: #9900cc;">ConnectionString</span> = strConnection<br />');
document.write('dbConnection.<span style="color: #330066;">Open</span> <br />');
document.write('<br />');
document.write('<span style="color: #990099; font-weight: bold;">Dim</span> <span style="color: #330066;">RecordSet</span><br />');
document.write('<span style="color: #990099; font-weight: bold;">Set</span> <span style="color: #330066;">RecordSet</span> = <span style="color: #990099; font-weight: bold;">server</span>.<span style="color: #330066;">CreateObject</span><span style="color: #006600; font-weight:bold">&#40;</span><span style="color: #cc0000;">&quot;ADODB.Recordset&quot;</span><span style="color: #006600; font-weight:bold">&#41;</span> <br />');
document.write('<br />');
document.write('<span style="color: #990099; font-weight: bold;">Dim</span> SQL<br />');
document.write('SQL = <span style="color: #cc0000;">&quot;SELECT * FROM &quot;</span> &amp; TBL_LOGIN <br />');
document.write('<br />');
document.write('<span style="color: #330066;">RecordSet</span>.<span style="color: #330066;">open</span> SQL , dbConnection,<span style="color: #800000;">1</span>,<span style="color: #800000;">2</span> <br />');
document.write('<br />');
document.write('total=<span style="color: #800000;">0</span><br />');
document.write('enc=<span style="color: #800000;">0</span><br />');
document.write('doencrypt=<span style="color: #0000ff; font-weight: bold;">false</span><br />');
document.write('<br />');
document.write('<span style="color: #990099; font-weight: bold;">if</span> <span style="color: #990099; font-weight: bold;">Request</span><span style="color: #006600; font-weight:bold">&#40;</span><span style="color: #cc0000;">&quot;do&quot;</span><span style="color: #006600; font-weight:bold">&#41;</span>=<span style="color: #cc0000;">&quot;encrypt&quot;</span> <span style="color: #990099; font-weight: bold;">then</span> doencrypt=<span style="color: #0000ff; font-weight: bold;">true</span> <br />');
document.write('<br />');
document.write('<span style="color: #990099; font-weight: bold;">do</span>&nbsp; until <span style="color: #330066;">RecordSet</span>.<span style="color: #0000ff; font-weight: bold;">eof</span><br />');
document.write('&nbsp; <span style="color: #990099; font-weight: bold;">if</span> doencrypt <span style="color: #990099; font-weight: bold;">then</span><br />');
document.write('&nbsp; &nbsp; total=total<span style="color: #800000;">+1</span><br />');
document.write('&nbsp; <br />');
document.write('&nbsp; &nbsp; <span style="color: #990099; font-weight: bold;">if</span> <span style="color: #990099; font-weight: bold;">not</span> encrypted<span style="color: #006600; font-weight:bold">&#40;</span><span style="color: #330066;">RecordSet</span><span style="color: #006600; font-weight:bold">&#40;</span>FLD_PASS<span style="color: #006600; font-weight:bold">&#41;</span><span style="color: #006600; font-weight:bold">&#41;</span> <span style="color: #990099; font-weight: bold;">then</span><br />');
document.write('&nbsp; &nbsp; &nbsp; <span style="color: #330066;">RecordSet</span><span style="color: #006600; font-weight:bold">&#40;</span>FLD_PASS<span style="color: #006600; font-weight:bold">&#41;</span>=md5<span style="color: #006600; font-weight:bold">&#40;</span><span style="color: #330066;">RecordSet</span><span style="color: #006600; font-weight:bold">&#40;</span>FLD_PASS<span style="color: #006600; font-weight:bold">&#41;</span><span style="color: #006600; font-weight:bold">&#41;</span><br />');
document.write('&nbsp; &nbsp; &nbsp; <span style="color: #330066;">RecordSet</span>.<span style="color: #9900cc;">Update</span><br />');
document.write('&nbsp; &nbsp; <span style="color: #990099; font-weight: bold;">end</span> <span style="color: #990099; font-weight: bold;">if</span><br />');
document.write('&nbsp; <br />');
document.write('&nbsp; &nbsp; enc=enc<span style="color: #800000;">+1</span><br />');
document.write('&nbsp;<br />');
document.write('<span style="color: #990099; font-weight: bold;">else</span><br />');
document.write('&nbsp; total=total<span style="color: #800000;">+1</span><br />');
document.write('&nbsp; <span style="color: #990099; font-weight: bold;">if</span> encrypted<span style="color: #006600; font-weight:bold">&#40;</span><span style="color: #330066;">RecordSet</span><span style="color: #006600; font-weight:bold">&#40;</span>FLD_PASS<span style="color: #006600; font-weight:bold">&#41;</span><span style="color: #006600; font-weight:bold">&#41;</span> <span style="color: #990099; font-weight: bold;">then</span> <br />');
document.write('&nbsp; &nbsp; enc=enc<span style="color: #800000;">+1</span><br />');
document.write('&nbsp; <span style="color: #990099; font-weight: bold;">end</span> <span style="color: #990099; font-weight: bold;">if</span><br />');
document.write('&nbsp;<br />');
document.write('&nbsp; <span style="color: #330066;">RecordSet</span>.<span style="color: #330066;">MoveNext</span><br />');
document.write('<span style="color: #990099; font-weight: bold;">loop</span> <br />');
document.write('<br />');
document.write('<span style="color: #330066;">Recordset</span>.<span style="color: #330066;">Close</span><br />');
document.write('<span style="color: #990099; font-weight: bold;">Set</span> <span style="color: #330066;">Recordset</span>=<span style="color: #0000ff; font-weight: bold;">Nothing</span><br />');
document.write('dbconnection.<span style="color: #330066;">Close</span><br />');
document.write('<span style="color: #990099; font-weight: bold;">Set</span> dbconnection=<span style="color: #0000ff; font-weight: bold;">Nothing</span> <br />');
document.write('<br />');
document.write('<span style="color: #0000ff; font-weight: bold;">function</span> encrypted<span style="color: #006600; font-weight:bold">&#40;</span>str<span style="color: #006600; font-weight:bold">&#41;</span><br />');
document.write('<span style="color: #990099; font-weight: bold;">if</span> <span style="color: #330066;">len</span><span style="color: #006600; font-weight:bold">&#40;</span>str<span style="color: #006600; font-weight:bold">&#41;</span>&lt;&gt;<span style="color: #800000;">32</span> <span style="color: #990099; font-weight: bold;">then</span><br />');
document.write('&nbsp; encrypted=<span style="color: #0000ff; font-weight: bold;">false</span><br />');
document.write('&nbsp; exit <span style="color: #0000ff; font-weight: bold;">function</span><br />');
document.write('&nbsp;<span style="color: #990099; font-weight: bold;">end</span> <span style="color: #990099; font-weight: bold;">if</span><br />');
document.write('&nbsp;<br />');
document.write('&nbsp;<span style="color: #990099; font-weight: bold;">dim</span> i<br />');
document.write('&nbsp;<span style="color: #990099; font-weight: bold;">for</span> i=<span style="color: #800000;">1</span> <span style="color: #990099; font-weight: bold;">to</span> <span style="color: #800000;">32</span><br />');
document.write('&nbsp; &nbsp;c = asc<span style="color: #006600; font-weight:bold">&#40;</span>mid<span style="color: #006600; font-weight:bold">&#40;</span>str,i,<span style="color: #800000;">1</span><span style="color: #006600; font-weight:bold">&#41;</span><span style="color: #006600; font-weight:bold">&#41;</span><br />');
document.write('&nbsp; &nbsp;<span style="color: #990099; font-weight: bold;">if</span> <span style="color: #006600; font-weight:bold">&#40;</span>c&lt;asc<span style="color: #006600; font-weight:bold">&#40;</span><span style="color: #cc0000;">&quot;0&quot;</span><span style="color: #006600; font-weight:bold">&#41;</span> <span style="color: #0000ff; font-weight: bold;">and</span> c&gt;asc<span style="color: #006600; font-weight:bold">&#40;</span><span style="color: #cc0000;">&quot;9&quot;</span><span style="color: #006600; font-weight:bold">&#41;</span><span style="color: #006600; font-weight:bold">&#41;</span> <span style="color: #0000ff; font-weight: bold;">and</span> <span style="color: #006600; font-weight:bold">&#40;</span>c&lt;asc<span style="color: #006600; font-weight:bold">&#40;</span><span style="color: #cc0000;">&quot;a&quot;</span><span style="color: #006600; font-weight:bold">&#41;</span> <span style="color: #0000ff; font-weight: bold;">or</span> c&gt;asc<span style="color: #006600; font-weight:bold">&#40;</span><span style="color: #cc0000;">&quot;f&quot;</span><span style="color: #006600; font-weight:bold">&#41;</span><span style="color: #006600; font-weight:bold">&#41;</span> <span style="color: #990099; font-weight: bold;">then</span><br />');
document.write('&nbsp; &nbsp; &nbsp;encrypted=<span style="color: #0000ff; font-weight: bold;">false</span><br />');
document.write('&nbsp; &nbsp; &nbsp;exit <span style="color: #0000ff; font-weight: bold;">function</span><br />');
document.write('&nbsp; <span style="color: #990099; font-weight: bold;">end</span> <span style="color: #990099; font-weight: bold;">if</span><br />');
document.write('&nbsp;<span style="color: #990099; font-weight: bold;">next</span><br />');
document.write('<br />');
document.write('&nbsp; encrypted=<span style="color: #0000ff; font-weight: bold;">true</span><br />');
document.write('<br />');
document.write('<span style="color: #990099; font-weight: bold;">end</span> <span style="color: #0000ff; font-weight: bold;">function</span><br />');
document.write('<span style="color: #0000ff; font-weight: bold;">%&gt;</span><br />');
document.write('<br />');
document.write('&lt;html&gt;<br />');
document.write('&lt;head&gt;&lt;title&gt;Encrypt passwords&lt;/title&gt;&lt;/head&gt;<br />');
document.write('&lt;body&gt;<br />');
document.write('Total passwords <span style="color: #990099; font-weight: bold;">in</span> the table - <span style="color: #0000ff; font-weight: bold;">&lt;%</span>=total %&gt;&lt;br&gt;<br />');
document.write('<span style="color: #0000ff; font-weight: bold;">&lt;%</span> <span style="color: #990099; font-weight: bold;">if</span> enc=total <span style="color: #0000ff; font-weight: bold;">and</span> total&gt;<span style="color: #800000;">0</span> <span style="color: #990099; font-weight: bold;">then</span> <span style="color: #0000ff; font-weight: bold;">%&gt;</span><br />');
document.write('All passwords are encrypted.<br />');
document.write('<span style="color: #0000ff; font-weight: bold;">&lt;%</span> <span style="color: #990099; font-weight: bold;">elseif</span> total&gt;<span style="color: #800000;">0</span> <span style="color: #990099; font-weight: bold;">then</span> <span style="color: #0000ff; font-weight: bold;">%&gt;</span><br />');
document.write('Unencrypted - <span style="color: #0000ff; font-weight: bold;">&lt;%</span>=<span style="color: #006600; font-weight:bold">&#40;</span>total-enc<span style="color: #006600; font-weight:bold">&#41;</span>%&gt;&lt;br&gt;&lt;br&gt;<br />');
document.write('Click <span style="color: #cc0000;">&quot;GO&quot;</span> <span style="color: #990099; font-weight: bold;">to</span> encrypt <span style="color: #0000ff; font-weight: bold;">&lt;%</span>=<span style="color: #006600; font-weight:bold">&#40;</span>total-enc<span style="color: #006600; font-weight:bold">&#41;</span> <span style="color: #0000ff; font-weight: bold;">%&gt;</span> passwords.&lt;br&gt;<br />');
document.write('WARNING! There will be no way <span style="color: #990099; font-weight: bold;">to</span> decipher the passwords.&lt;br&gt;<br />');
document.write('&lt;input type=button value=<span style="color: #cc0000;">&quot;GO&quot;</span> onclick=<span style="color: #cc0000;">&quot;window.location=\'encrypt.asp?do=encrypt\';&quot;</span>&gt;<br />');
document.write('<span style="color: #0000ff; font-weight: bold;">&lt;%</span> <span style="color: #990099; font-weight: bold;">end</span> <span style="color: #990099; font-weight: bold;">if</span> <span style="color: #0000ff; font-weight: bold;">%&gt;</span><br />');
document.write('&lt;/body&gt;<br />');
document.write('&lt;/html&gt;<br />');
document.write('&nbsp;</div>');
document.write('<br />&nbsp;<br /><div style="font-size: 12px">Brought to you by the community at <a href="http://www.bytemycode.com/snippets/snippet/361/1/" target="_blank">byteMyCode</a>.</div>');
