[DiscordArchive] For its work, does the server use the spell_dbc from sql table and not the dbc file? if I want to co
[DiscordArchive] For its work, does the server use the spell_dbc from sql table and not the dbc file? if I want to co
Original source
o shi
rektbyfaith
01-15-2025, 10:07 PM #11Archived author: Whomadeit • Posted: 2025-01-15T22:07:15.063000+00:00
Original source
o shi
Original source
why not something like:
```cpp
bool AccountMgr::CheckPassword(uint32 accountId, std:
tring password){
// Validate password length and complexity
if (password.length() < MIN_PASSWORD_LENGTH || password.length() > MAX_PASSWORD_LENGTH)
{
return false;
}
std:
tring username;if (!GetName(accountId, username))
return false;
// Only convert username to uppercase (optional, depending on your requirements)
Utf8ToUpperOnlyLatin(username);
LoginDatabasePreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_SEL_CHECK_PASSWORD);
stmt->setUInt32(0, accountId);
if (PreparedQueryResult result = LoginDatabase.Query(stmt))
{
Trinity::Crypto::SRP6::Salt salt = (*result)[0].GetBinary<Trinity::Crypto::SRP6::SALT_LENGTH>();
Trinity::Crypto::SRP6::Verifier verifier = (*result)[1].GetBinary<Trinity::Crypto::SRP6::VERIFIER_LENGTH>();
if (Trinity::Crypto::SRP6::CheckLogin(username, password, salt, verifier))
{
// Reset failed login attempts on successful login
ResetFailedLoginAttempts(accountId);
return true;
}
}
// Increment failed login attempts
IncrementFailedLoginAttempts(accountId);
return false;
}```
rektbyfaith
01-15-2025, 10:09 PM #12Archived author: Whomadeit • Posted: 2025-01-15T22:09:28.149000+00:00
Original source
why not something like:
```cpp
bool AccountMgr::CheckPassword(uint32 accountId, std:tring password)
{
// Validate password length and complexity
if (password.length() < MIN_PASSWORD_LENGTH || password.length() > MAX_PASSWORD_LENGTH)
{
return false;
}
std:tring username;
if (!GetName(accountId, username))
return false;
// Only convert username to uppercase (optional, depending on your requirements)
Utf8ToUpperOnlyLatin(username);
LoginDatabasePreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_SEL_CHECK_PASSWORD);
stmt->setUInt32(0, accountId);
if (PreparedQueryResult result = LoginDatabase.Query(stmt))
{
Trinity::Crypto::SRP6::Salt salt = (*result)[0].GetBinary<Trinity::Crypto::SRP6::SALT_LENGTH>();
Trinity::Crypto::SRP6::Verifier verifier = (*result)[1].GetBinary<Trinity::Crypto::SRP6::VERIFIER_LENGTH>();
if (Trinity::Crypto::SRP6::CheckLogin(username, password, salt, verifier))
{
// Reset failed login attempts on successful login
ResetFailedLoginAttempts(accountId);
return true;
}
}
// Increment failed login attempts
IncrementFailedLoginAttempts(accountId);
return false;
}```
Original source
obviously because then login would fail
rektbyfaith
01-15-2025, 10:14 PM #13Archived author: Tea • Posted: 2025-01-15T22:14:00.030000+00:00
Original source
obviously because then login would fail
Original source
AccountMgr::CheckPassword is not used during login, thats only for gm commands
rektbyfaith
01-15-2025, 10:14 PM #14Archived author: Tea • Posted: 2025-01-15T22:14:15.279000+00:00
Original source
AccountMgr::CheckPassword is not used during login, thats only for gm commands
Original source
i repeat, YOU CANNOT REMOVE CASE INSENSITIVITY BECAUSE CLIENT DOES IT INTERNALLY
rektbyfaith
01-15-2025, 10:14 PM #15Archived author: Tea • Posted: 2025-01-15T22:14:57.553000+00:00
Original source
i repeat, YOU CANNOT REMOVE CASE INSENSITIVITY BECAUSE CLIENT DOES IT INTERNALLY
Original source
OkAyYyY
rektbyfaith
01-15-2025, 10:18 PM #16Archived author: Whomadeit • Posted: 2025-01-15T22:18:15.374000+00:00
Original source
OkAyYyY
Original source
unless you mod the client, which more and more people are doing these days
rektbyfaith
01-15-2025, 10:23 PM #17Archived author: stoneharry • Posted: 2025-01-15T22:23:54.488000+00:00
Original source
unless you mod the client, which more and more people are doing these days
1 Guest(s)
1 Guest(s)