[PHP-DB] Random Password Generation/MSSQL

[Ryan Marrs]

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

[Mark Roedel]

 -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]