[PHP-DB] Random Password Generation/MSSQL
Having an issue with this script, the generator works if I just echo out the password, however when I attempt to update the table, it times-out in IIS. I've bumped the IIS Timeout up to over 20 minutes, and it still times out. This is on a database with approximately 29,000 entries. Any ideas? Ryan function rand_pass() { $array = array( a,b,c,d,e,f,g,h,i,j,k,l, m,n,o,p,q,r,s,t,u,v,w,x,y, z,1,2,3,4,5,6,7,8,9 ); $num_letters = 10; $uppercased = 3; mt_srand ((double)microtime()*100); for($i=0; $i$num_letters; $i++) $pass .= $array[mt_rand(0, (count($array) - 1))]; for($i=1; $istrlen($pass); $i++) { if(substr($pass, $i, 1) == substr($pass, $i-1, 1)) $pass = substr($pass, 0, $i) . substr($pass, $i+1); } for($i=0; $istrlen($pass); $i++) { if(mt_rand(0, $uppercased) == 0) $pass = substr($pass,0,$i) . strtoupper(substr($pass, $i,1)) . substr($pass, $i+1); } $pass = substr($pass, 0, $num_letters); return($pass); } MSSQL_CONNECT(XXX,XX,X); MSSQL_SELECT_DB(X); $query=SELECT * FROM TABLE; $return=MSSQL_QUERY($query); $count=MSSQL_NUM_ROWS($return); $insertquery=UPDATE TABLE SET FIELD='$password' WHERE DUNSNumber='$DUNSNumber'; $row=MSSQL_FETCH_OBJECT($return); for($i=1;$i=$count;$i++){ $DUNSNumber=$row-DUNSNumber; echo rand_pass().br; MSSQL_QUERY($insertquery); } MSSQL_CLOSE(); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Random Password Generation/MSSQL
-Original Message- From: Ryan Marrs [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 1:54 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Random Password Generation/MSSQL Having an issue with this script, the generator works if I just echo out the password, however when I attempt to update the table, it times-out in IIS. I've bumped the IIS Timeout up to over 20 minutes, and it still times out. This is on a database with approximately 29,000 entries. Any ideas? [snip] for($i=1;$i=$count;$i++){ $DUNSNumber=$row-DUNSNumber; echo rand_pass().br; I bet if you echo $insertquery right here, you won't see what you were expecting to. (Hint: $password and $DUNSNumber aren't set when you give $insertquery its value; neither is the string updated for each iteration of this loop.) MSSQL_QUERY($insertquery); } Perhaps that's not the entire problem, but it can't be helping...if nothing else, once that's corrected maybe you can start looking at doing those updates in smaller batches. 20 minutes does seem a bit extreme, but then it's hard to make much of a judgment on that without knowing more about the machine in question, what else it's being used for besides sql services, how heavily it's being utilized, etc. --- Mark Roedel | Nothing in life is so bad that it cannot be Systems Programmer| made much, much worse by the addition of LeTourneau University |lots of spikes and razors. Longview, Texas, USA |-- Sean Kozma -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]