[DiscordArchive] I have 16 000 accounts. Is that possible to auto detect them? Maybe length or smh else?
[DiscordArchive] I have 16 000 accounts. Is that possible to auto detect them? Maybe length or smh else?
Original source
I have 16 000 accounts. Is that possible to auto detect them? Maybe length or smh else?
rektbyfaith
06-10-2024, 09:42 AM #1Archived author: Whatifeel • Posted: 2024-06-10T09:42:17.899000+00:00
Original source
I have 16 000 accounts. Is that possible to auto detect them? Maybe length or smh else?
Original source
yes
rektbyfaith
06-10-2024, 09:43 AM #2Archived author: Tea • Posted: 2024-06-10T09:43:00.985000+00:00
Original source
yes
Original source
`SELECT * FROM battlenet_accounts WHERE MOD(LENGTH(sha_pass_hash), 2) = 1`
rektbyfaith
06-10-2024, 09:43 AM #3Archived author: Tea • Posted: 2024-06-10T09:43:22.571000+00:00
Original source
`SELECT * FROM battlenet_accounts WHERE MOD(LENGTH(sha_pass_hash), 2) = 1`
Original source
This query return "Empty Set"
But with `SELECT MOD(LENGTH(sha_pass_hash), 2) FROM battlenet_accounts;` is working
rektbyfaith
06-10-2024, 09:47 AM #4Archived author: Whatifeel • Posted: 2024-06-10T09:47:33.299000+00:00
Original source
This query return "Empty Set"
But with `SELECT MOD(LENGTH(sha_pass_hash), 2) FROM battlenet_accounts;` is working
Original source
![[Image: image.png?ex=690c6ec0&is=690b1d40&hm=058...69bfa982d&]](https://cdn.discordapp.com/attachments/376457124726702080/1249661271574446100/image.png?ex=690c6ec0&is=690b1d40&hm=0585c13cc15798486de9cd2915a2f1757475c4093c9be68f9746f5269bfa982d&)
rektbyfaith
06-10-2024, 09:47 AM #5Archived author: Whatifeel • Posted: 2024-06-10T09:47:44.729000+00:00
Original source
Original source
0 is the correct value
rektbyfaith
06-10-2024, 09:47 AM #6Archived author: Tea • Posted: 2024-06-10T09:47:55.897000+00:00
Original source
0 is the correct value
Original source
lets change that to something else
rektbyfaith
06-10-2024, 09:48 AM #7Archived author: Tea • Posted: 2024-06-10T09:48:36.455000+00:00
Original source
lets change that to something else
Original source
All 0 values?
rektbyfaith
06-10-2024, 09:48 AM #8Archived author: Whatifeel • Posted: 2024-06-10T09:48:50.926000+00:00
Original source
All 0 values?
Original source
SELECT * FROM battlenet_accounts WHERE LENGTH(sha_pass_hash) != 64
rektbyfaith
06-10-2024, 09:49 AM #9Archived author: Tea • Posted: 2024-06-10T09:49:56.516000+00:00
Original source
SELECT * FROM battlenet_accounts WHERE LENGTH(sha_pass_hash) != 64
Original source
5004 rows in set (13.82 sec)
rektbyfaith
06-10-2024, 09:51 AM #10Archived author: Whatifeel • Posted: 2024-06-10T09:51:24.118000+00:00
Original source
5004 rows in set (13.82 sec)