Aleks
asked on
ASP/VB script page - SP help
I am using ASP/VB script and MS SQL 2008
There is a SP in my page that inserts data in my DB.
---
Dim SPInsertPassword__Password
SPInsertPassword__Password = "0"
if(EncrytPswd("demo") <> "") then SPInsertPassword__Password = EncrytPswd("demo")
----
The above will insert the word "demo" into a database field, when it is inserted it is also enctrypted. That is what the "Encrypt" part is for, so far so good.
I have to replace the word "demo" for a random password. I already have the script below to generate a random password. What I need help with is to save the random password in a variable and then use it to insert it instead of the word 'demo' using the code above.
This is my script:
<script language="vbscript" runat="server">
Sub StrRandomize(strSeed)
Dim i, nSeed
nSeed = CLng(0)
For i = 1 To Len(strSeed)
nSeed = nSeed Xor ((256 * ((i - 1) Mod 4) * AscB(Mid(strSeed, i, 1))))
Next
'Randomiser
Randomize nSeed
End Sub
'--GeneratePassword(nLengt h)
'--Generates friendly passwords for remembering and pronounciation
Function GeneratePassword(nLength)
Dim i, bMadeConsonant, c, nRnd
'You may adjust the below constants to include local,
'eg. scandinavian characters. This way your passwords
'will not be limited to latin characters.
Const strDoubleConsonants = "bdfglmnpst"
Const strConsonants = "bcdfghklmnpqrstv"
Const strVocal = "aeiou"
GeneratePassword = ""
bMadeConsonant = False
For i = 0 To nLength
'Get a random number number between 0 and 1
nRnd = Rnd
'Simple or double consonant, or a new vocal?
'Does not start with a double consonant
'15% or less chance for the next letter being a double consonant
If GeneratePassword <> "" AND (bMadeConsonant <> True) AND (nRnd < 0.15) Then
'double consonant
c = Mid(strDoubleConsonants, Int(Len(strDoubleConsonant s) * Rnd + 1), 1)
'response.write int(Len(strDoubleConsonant s) * Rnd + 1)
'response.write "<br>"
c = c & c
i = i + 1
bMadeConsonant = True
Else
'80% or less chance for the next letter being a consonant,
'depending on wether the last letter was a consonant or not.
If (bMadeConsonant <> True) And (nRnd < 0.95) Then
'Simple consonant
c = Mid(strConsonants, Int(Len(strConsonants) * Rnd + 1), 1)
bMadeConsonant = True
'5% or more chance for the next letter being a vocal. 100% if last
'letter was a consonant - theoreticaly speaking...
Else
'If last one was a consonant, make vocal
c = Mid(strVocal,Int(Len(strVo cal) * Rnd + 1), 1)
bMadeConsonant = False
End If
End If
'Add letter
GeneratePassword = GeneratePassword & c
Next
'Is the password long enough, or perhaps too long?
If Len(GeneratePassword) > nLength Then
GeneratePassword = Left(GeneratePassword, nLength)
End If
End Function
StrRandomize CStr(Now) & CStr(Rnd)
</script>
There is a SP in my page that inserts data in my DB.
---
Dim SPInsertPassword__Password
SPInsertPassword__Password
if(EncrytPswd("demo") <> "") then SPInsertPassword__Password
----
The above will insert the word "demo" into a database field, when it is inserted it is also enctrypted. That is what the "Encrypt" part is for, so far so good.
I have to replace the word "demo" for a random password. I already have the script below to generate a random password. What I need help with is to save the random password in a variable and then use it to insert it instead of the word 'demo' using the code above.
This is my script:
<script language="vbscript" runat="server">
Sub StrRandomize(strSeed)
Dim i, nSeed
nSeed = CLng(0)
For i = 1 To Len(strSeed)
nSeed = nSeed Xor ((256 * ((i - 1) Mod 4) * AscB(Mid(strSeed, i, 1))))
Next
'Randomiser
Randomize nSeed
End Sub
'--GeneratePassword(nLengt
'--Generates friendly passwords for remembering and pronounciation
Function GeneratePassword(nLength)
Dim i, bMadeConsonant, c, nRnd
'You may adjust the below constants to include local,
'eg. scandinavian characters. This way your passwords
'will not be limited to latin characters.
Const strDoubleConsonants = "bdfglmnpst"
Const strConsonants = "bcdfghklmnpqrstv"
Const strVocal = "aeiou"
GeneratePassword = ""
bMadeConsonant = False
For i = 0 To nLength
'Get a random number number between 0 and 1
nRnd = Rnd
'Simple or double consonant, or a new vocal?
'Does not start with a double consonant
'15% or less chance for the next letter being a double consonant
If GeneratePassword <> "" AND (bMadeConsonant <> True) AND (nRnd < 0.15) Then
'double consonant
c = Mid(strDoubleConsonants, Int(Len(strDoubleConsonant
'response.write int(Len(strDoubleConsonant
'response.write "<br>"
c = c & c
i = i + 1
bMadeConsonant = True
Else
'80% or less chance for the next letter being a consonant,
'depending on wether the last letter was a consonant or not.
If (bMadeConsonant <> True) And (nRnd < 0.95) Then
'Simple consonant
c = Mid(strConsonants, Int(Len(strConsonants) * Rnd + 1), 1)
bMadeConsonant = True
'5% or more chance for the next letter being a vocal. 100% if last
'letter was a consonant - theoreticaly speaking...
Else
'If last one was a consonant, make vocal
c = Mid(strVocal,Int(Len(strVo
bMadeConsonant = False
End If
End If
'Add letter
GeneratePassword = GeneratePassword & c
Next
'Is the password long enough, or perhaps too long?
If Len(GeneratePassword) > nLength Then
GeneratePassword = Left(GeneratePassword, nLength)
End If
End Function
StrRandomize CStr(Now) & CStr(Rnd)
</script>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great, thanks !
ASKER
:)
ASKER