ExcelTip.Net留存知识帖 ---【注：附件之前被网盘供应商清空后，现已修复-现已修复-现已修复为本地下载！】
现在位置：首页 > 我的酷贴 > Excel VBA > VBA登录使用MD5密令，从此告别弱口令

VBA登录使用MD5密令，从此告别弱口令

作者：绿色风 分类： 时间：2022-08-18 浏览：95
楼主
G_avin		 很多朋友不论用VB6还是VBA做工程都会汲及到登录这一环节
在登录时很多基本信息一方面属于个人私隐信息，一方面弱口令对于数据安全的防范不够严谨容易导致信息外漏等
其实这个问题的解决我们可以引入MD5的密钥生成技术，把重要数据进行加密存放（比如用户IP或用户密码等信息）在登录时通过密钥较对的方法进行判断用户是否合法，密码是否正确
在这种密钥的保护下，所有用户信息都是一种不可逆的长密令，不易被穷举破译（当然，市面上有MD5的解密技术其实也是用穷举的方法较对结果的，但我们可以把MD5按自己的方法进行修改，做成一个只有通过自己的MD5代码产生的密钥才能正确较对的程序）

以下是一段修改过的MD5生成代码，可以生成32位或16位的密钥
使用方法
MD5(sMessage, stype)
sMessage 为原值
stype为MD5的位值 可以为32或16
例
md5(123,32)  结果为 124bc4b29b66d910516be1bb1229bd1f
md5("C11067",32)  结果为 f90f7b4ae421da591d4701c6f07abafd
  1. Option Explicit

  3. Private Const BITS_TO_A_BYTE = 8
  4. Private Const BYTES_TO_A_WORD = 4
  5. Private Const BITS_TO_A_WORD = 32

  7. Private m_lOnBits(30)
  8. Private m_l2Power(30)

  10. Private Function LShift(lValue, iShiftBits)
  11. If iShiftBits = 0 Then
  12. LShift = lValue
  13. Exit Function
  14. ElseIf iShiftBits = 31 Then
  15. If lValue And 1 Then
  16. LShift = &H80000000
  17. Else
  18. LShift = 0
  19. End If
  20. Exit Function
  21. ElseIf iShiftBits < 0 Or iShiftBits > 31 Then
  22. Err.Raise 6
  23. End If

  25. If (lValue And m_l2Power(31 - iShiftBits)) Then
  26. LShift = ((lValue And m_lOnBits(31 - (iShiftBits + 1))) * m_l2Power(iShiftBits)) Or &H80000000
  27. Else
  28. LShift = ((lValue And m_lOnBits(31 - iShiftBits)) * m_l2Power(iShiftBits))
  29. End If
  30. End Function

  32. Private Function RShift(lValue, iShiftBits)
  33. If iShiftBits = 0 Then
  34. RShift = lValue
  35. Exit Function
  36. ElseIf iShiftBits = 31 Then
  37. If lValue And &H80000000 Then
  38. RShift = 1
  39. Else
  40. RShift = 0
  41. End If
  42. Exit Function
  43. ElseIf iShiftBits < 0 Or iShiftBits > 31 Then
  44. Err.Raise 6
  45. End If

  47. RShift = (lValue And &H7FFFFFFE) \ m_l2Power(iShiftBits)

  49. If (lValue And &H80000000) Then
  50. RShift = (RShift Or (&H40000000 \ m_l2Power(iShiftBits - 1)))
  51. End If
  52. End Function

  54. Private Function RotateLeft(lValue, iShiftBits)
  55. RotateLeft = LShift(lValue, iShiftBits) Or RShift(lValue, (32 - iShiftBits))
  56. End Function

  58. Private Function AddUnsigned(lX, lY)
  59. Dim lX4
  60. Dim lY4
  61. Dim lX8
  62. Dim lY8
  63. Dim lResult

  65. lX8 = lX And &H80000000
  66. lY8 = lY And &H80000000
  67. lX4 = lX And &H40000000
  68. lY4 = lY And &H40000000

  70. lResult = (lX And &H3FFFFFFF) + (lY And &H3FFFFFFF)

  72. If lX4 And lY4 Then
  73. lResult = lResult Xor &H80000000 Xor lX8 Xor lY8
  74. ElseIf lX4 Or lY4 Then
  75. If lResult And &H40000000 Then
  76. lResult = lResult Xor &HC0000000 Xor lX8 Xor lY8
  77. Else
  78. lResult = lResult Xor &H40000000 Xor lX8 Xor lY8
  79. End If
  80. Else
  81. lResult = lResult Xor lX8 Xor lY8
  82. End If

  84. AddUnsigned = lResult
  85. End Function

  87. Private Function md5_F(X, Y, z)
  88. md5_F = (X And Y) Or ((Not X) And z)
  89. End Function

  91. Private Function md5_G(X, Y, z)
  92. md5_G = (X And z) Or (Y And (Not z))
  93. End Function

  95. Private Function md5_H(X, Y, z)
  96. md5_H = (X Xor Y Xor z)
  97. End Function

  99. Private Function md5_I(X, Y, z)
  100. md5_I = (Y Xor (X Or (Not z)))
  101. End Function

  103. Private Sub md5_FF(a, b, c, d, X, s, ac)
  104. a = AddUnsigned(a, AddUnsigned(AddUnsigned(md5_F(b, c, d), X), ac))
  105. a = RotateLeft(a, s)
  106. a = AddUnsigned(a, b)
  107. End Sub

  109. Private Sub md5_GG(a, b, c, d, X, s, ac)
  110. a = AddUnsigned(a, AddUnsigned(AddUnsigned(md5_G(b, c, d), X), ac))
  111. a = RotateLeft(a, s)
  112. a = AddUnsigned(a, b)
  113. End Sub

  115. Private Sub md5_HH(a, b, c, d, X, s, ac)
  116. a = AddUnsigned(a, AddUnsigned(AddUnsigned(md5_H(b, c, d), X), ac))
  117. a = RotateLeft(a, s)
  118. a = AddUnsigned(a, b)
  119. End Sub

  121. Private Sub md5_II(a, b, c, d, X, s, ac)
  122. a = AddUnsigned(a, AddUnsigned(AddUnsigned(md5_I(b, c, d), X), ac))
  123. a = RotateLeft(a, s)
  124. a = AddUnsigned(a, b)
  125. End Sub

  127. Private Function ConvertToWordArray(sMessage)
  128. Dim lMessageLength
  129. Dim lNumberOfWords
  130. Dim lWordArray()
  131. Dim lBytePosition
  132. Dim lByteCount
  133. Dim lWordCount

  135. Const MODULUS_BITS = 512
  136. Const CONGRUENT_BITS = 448

  138. lMessageLength = Len(sMessage)

  140. lNumberOfWords = (((lMessageLength + ((MODULUS_BITS - CONGRUENT_BITS) \ BITS_TO_A_BYTE)) \ (MODULUS_BITS \ BITS_TO_A_BYTE)) + 1) * (MODULUS_BITS \ BITS_TO_A_WORD)
  141. ReDim lWordArray(lNumberOfWords - 1)

  143. lBytePosition = 0
  144. lByteCount = 0
  145. Do Until lByteCount >= lMessageLength
  146. lWordCount = lByteCount \ BYTES_TO_A_WORD
  147. lBytePosition = (lByteCount Mod BYTES_TO_A_WORD) * BITS_TO_A_BYTE
  148. lWordArray(lWordCount) = lWordArray(lWordCount) Or LShift(Asc(Mid(sMessage, lByteCount + 1, 1)), lBytePosition)
  149. lByteCount = lByteCount + 1
  150. Loop

  152. lWordCount = lByteCount \ BYTES_TO_A_WORD
  153. lBytePosition = (lByteCount Mod BYTES_TO_A_WORD) * BITS_TO_A_BYTE

  155. lWordArray(lWordCount) = lWordArray(lWordCount) Or LShift(&H80, lBytePosition)

  157. lWordArray(lNumberOfWords - 2) = LShift(lMessageLength, 3)
  158. lWordArray(lNumberOfWords - 1) = RShift(lMessageLength, 29)

  160. ConvertToWordArray = lWordArray
  161. End Function

  163. Private Function WordToHex(lValue)
  164. Dim lByte
  165. Dim lCount

  167. For lCount = 0 To 3
  168. lByte = RShift(lValue, lCount * BITS_TO_A_BYTE) And m_lOnBits(BITS_TO_A_BYTE - 1)
  169. WordToHex = WordToHex & Right("0" & Hex(lByte), 2)
  170. Next
  171. End Function

  173. Public Function MD5(sMessage, stype)
  174. sMessage = sMessage & "Admin_istrator"
  175. m_lOnBits(0) = CLng(1)
  176. m_lOnBits(1) = CLng(3)
  177. m_lOnBits(2) = CLng(7)
  178. m_lOnBits(3) = CLng(15)
  179. m_lOnBits(4) = CLng(31)
  180. m_lOnBits(5) = CLng(63)
  181. m_lOnBits(6) = CLng(127)
  182. m_lOnBits(7) = CLng(255)
  183. m_lOnBits(8) = CLng(511)
  184. m_lOnBits(9) = CLng(1023)
  185. m_lOnBits(10) = CLng(2047)
  186. m_lOnBits(11) = CLng(4095)
  187. m_lOnBits(12) = CLng(8191)
  188. m_lOnBits(13) = CLng(16383)
  189. m_lOnBits(14) = CLng(32767)
  190. m_lOnBits(15) = CLng(65535)
  191. m_lOnBits(16) = CLng(131071)
  192. m_lOnBits(17) = CLng(262143)
  193. m_lOnBits(18) = CLng(524287)
  194. m_lOnBits(19) = CLng(1048575)
  195. m_lOnBits(20) = CLng(2097151)
  196. m_lOnBits(21) = CLng(4194303)
  197. m_lOnBits(22) = CLng(8388607)
  198. m_lOnBits(23) = CLng(16777215)
  199. m_lOnBits(24) = CLng(33554431)
  200. m_lOnBits(25) = CLng(67108863)
  201. m_lOnBits(26) = CLng(134217727)
  202. m_lOnBits(27) = CLng(268435455)
  203. m_lOnBits(28) = CLng(536870911)
  204. m_lOnBits(29) = CLng(1073741823)
  205. m_lOnBits(30) = CLng(2147483647)

  207. m_l2Power(0) = CLng(1)
  208. m_l2Power(1) = CLng(2)
  209. m_l2Power(2) = CLng(4)
  210. m_l2Power(3) = CLng(8)
  211. m_l2Power(4) = CLng(16)
  212. m_l2Power(5) = CLng(32)
  213. m_l2Power(6) = CLng(64)
  214. m_l2Power(7) = CLng(128)
  215. m_l2Power(8) = CLng(256)
  216. m_l2Power(9) = CLng(512)
  217. m_l2Power(10) = CLng(1024)
  218. m_l2Power(11) = CLng(2048)
  219. m_l2Power(12) = CLng(4096)
  220. m_l2Power(13) = CLng(8192)
  221. m_l2Power(14) = CLng(16384)
  222. m_l2Power(15) = CLng(32768)
  223. m_l2Power(16) = CLng(65536)
  224. m_l2Power(17) = CLng(131072)
  225. m_l2Power(18) = CLng(262144)
  226. m_l2Power(19) = CLng(524288)
  227. m_l2Power(20) = CLng(1048576)
  228. m_l2Power(21) = CLng(2097152)
  229. m_l2Power(22) = CLng(4194304)
  230. m_l2Power(23) = CLng(8388608)
  231. m_l2Power(24) = CLng(16777216)
  232. m_l2Power(25) = CLng(33554432)
  233. m_l2Power(26) = CLng(67108864)
  234. m_l2Power(27) = CLng(134217728)
  235. m_l2Power(28) = CLng(268435456)
  236. m_l2Power(29) = CLng(536870912)
  237. m_l2Power(30) = CLng(1073741824)


  240. Dim X
  241. Dim k
  242. Dim AA
  243. Dim BB
  244. Dim CC
  245. Dim DD
  246. Dim a
  247. Dim b
  248. Dim c
  249. Dim d

  251. Const S11 = 7
  252. Const S12 = 12
  253. Const S13 = 17
  254. Const S14 = 22
  255. Const S21 = 5
  256. Const S22 = 9
  257. Const S23 = 14
  258. Const S24 = 20
  259. Const S31 = 4
  260. Const S32 = 11
  261. Const S33 = 16
  262. Const S34 = 23
  263. Const S41 = 6
  264. Const S42 = 10
  265. Const S43 = 15
  266. Const S44 = 21

  268. X = ConvertToWordArray(sMessage)

  270. a = &H67452301
  271. b = &HEFCDAB89
  272. c = &H98BADCFE
  273. d = &H10325476

  275. For k = 0 To UBound(X) Step 16
  276. AA = a
  277. BB = b
  278. CC = c
  279. DD = d

  281. md5_FF a, b, c, d, X(k + 0), S11, &HD76AA478
  282. md5_FF d, a, b, c, X(k + 1), S12, &HE8C7B756
  283. md5_FF c, d, a, b, X(k + 2), S13, &H242070DB
  284. md5_FF b, c, d, a, X(k + 3), S14, &HC1BDCEEE
  285. md5_FF a, b, c, d, X(k + 4), S11, &HF57C0FAF
  286. md5_FF d, a, b, c, X(k + 5), S12, &H4787C62A
  287. md5_FF c, d, a, b, X(k + 6), S13, &HA8304613
  288. md5_FF b, c, d, a, X(k + 7), S14, &HFD469501
  289. md5_FF a, b, c, d, X(k + 8), S11, &H698098D8
  290. md5_FF d, a, b, c, X(k + 9), S12, &H8B44F7AF
  291. md5_FF c, d, a, b, X(k + 10), S13, &HFFFF5BB1
  292. md5_FF b, c, d, a, X(k + 11), S14, &H895CD7BE
  293. md5_FF a, b, c, d, X(k + 12), S11, &H6B901122
  294. md5_FF d, a, b, c, X(k + 13), S12, &HFD987193
  295. md5_FF c, d, a, b, X(k + 14), S13, &HA679438E
  296. md5_FF b, c, d, a, X(k + 15), S14, &H49B40821

  298. md5_GG a, b, c, d, X(k + 1), S21, &HF61E2562
  299. md5_GG d, a, b, c, X(k + 6), S22, &HC040B340
  300. md5_GG c, d, a, b, X(k + 11), S23, &H265E5A51
  301. md5_GG b, c, d, a, X(k + 0), S24, &HE9B6C7AA
  302. md5_GG a, b, c, d, X(k + 5), S21, &HD62F105D
  303. md5_GG d, a, b, c, X(k + 10), S22, &H2441453
  304. md5_GG c, d, a, b, X(k + 15), S23, &HD8A1E681
  305. md5_GG b, c, d, a, X(k + 4), S24, &HE7D3FBC8
  306. md5_GG a, b, c, d, X(k + 9), S21, &H21E1CDE6
  307. md5_GG d, a, b, c, X(k + 14), S22, &HC33707D6
  308. md5_GG c, d, a, b, X(k + 3), S23, &HF4D50D87
  309. md5_GG b, c, d, a, X(k + 8), S24, &H455A14ED
  310. md5_GG a, b, c, d, X(k + 13), S21, &HA9E3E905
  311. md5_GG d, a, b, c, X(k + 2), S22, &HFCEFA3F8
  312. md5_GG c, d, a, b, X(k + 7), S23, &H676F02D9
  313. md5_GG b, c, d, a, X(k + 12), S24, &H8D2A4C8A

  315. md5_HH a, b, c, d, X(k + 5), S31, &HFFFA3942
  316. md5_HH d, a, b, c, X(k + 8), S32, &H8771F681
  317. md5_HH c, d, a, b, X(k + 11), S33, &H6D9D6122
  318. md5_HH b, c, d, a, X(k + 14), S34, &HFDE5380C
  319. md5_HH a, b, c, d, X(k + 1), S31, &HA4BEEA44
  320. md5_HH d, a, b, c, X(k + 4), S32, &H4BDECFA9
  321. md5_HH c, d, a, b, X(k + 7), S33, &HF6BB4B60
  322. md5_HH b, c, d, a, X(k + 10), S34, &HBEBFBC70
  323. md5_HH a, b, c, d, X(k + 13), S31, &H289B7EC6
  324. md5_HH d, a, b, c, X(k + 0), S32, &HEAA127FA
  325. md5_HH c, d, a, b, X(k + 3), S33, &HD4EF3085
  326. md5_HH b, c, d, a, X(k + 6), S34, &H4881D05
  327. md5_HH a, b, c, d, X(k + 9), S31, &HD9D4D039
  328. md5_HH d, a, b, c, X(k + 12), S32, &HE6DB99E5
  329. md5_HH c, d, a, b, X(k + 15), S33, &H1FA27CF8
  330. md5_HH b, c, d, a, X(k + 2), S34, &HC4AC5665

  332. md5_II a, b, c, d, X(k + 0), S41, &HF4292244
  333. md5_II d, a, b, c, X(k + 7), S42, &H432AFF97
  334. md5_II c, d, a, b, X(k + 14), S43, &HAB9423A7
  335. md5_II b, c, d, a, X(k + 5), S44, &HFC93A039
  336. md5_II a, b, c, d, X(k + 12), S41, &H655B59C3
  337. md5_II d, a, b, c, X(k + 3), S42, &H8F0CCC92
  338. md5_II c, d, a, b, X(k + 10), S43, &HFFEFF47D
  339. md5_II b, c, d, a, X(k + 1), S44, &H85845DD1
  340. md5_II a, b, c, d, X(k + 8), S41, &H6FA87E4F
  341. md5_II d, a, b, c, X(k + 15), S42, &HFE2CE6E0
  342. md5_II c, d, a, b, X(k + 6), S43, &HA3014314
  343. md5_II b, c, d, a, X(k + 13), S44, &H4E0811A1
  344. md5_II a, b, c, d, X(k + 4), S41, &HF7537E82
  345. md5_II d, a, b, c, X(k + 11), S42, &HBD3AF235
  346. md5_II c, d, a, b, X(k + 2), S43, &H2AD7D2BB
  347. md5_II b, c, d, a, X(k + 9), S44, &HEB86D391

  349. a = AddUnsigned(a, AA)
  350. b = AddUnsigned(b, BB)
  351. c = AddUnsigned(c, CC)
  352. d = AddUnsigned(d, DD)
  353. Next

  355. If stype = 32 Then
  356. MD5 = LCase(WordToHex(a) & WordToHex(b) & WordToHex(c) & WordToHex(d))
  357. Else
  358. MD5 = LCase(WordToHex(b) & WordToHex(c)) 'I crop this to fit 16byte database password :D
  359. End If
  360. End Function




2楼
い卋玑┾宝珼		 围观学习ing

免责声明

有感于原ExcelTip.Net留存知识的价值及部分知识具有的时间限定性因素， 经与ExcelTip.Net站长Apolloh商议并征得其同意， 现将原属ExcelTip.Net的知识帖采集资料于本站点进行展示， 供有需要的人士查询使用，也慰缅曾经的论坛时代。 所示各个帖子的原作者如对版权有异议， 可与本人沟通提出，或于本站点留言，我们会尽快处理。 在此，感谢ExcelTip.Net站长Apolloh的支持，感谢本站点所有人**绿色风（QQ:79664738)**的支持与奉献，特此鸣谢！
------本人网名**KevinChengCW（QQ:1210618015)**原ExcelTip.Net总版主之一

猜您喜欢
评论列表
搜索

鄂ICP备2021011689号-2

powered by emlog pro Theme By 蓝叶

sitemap