team-spirit-productions / lazuli Goto Github PK

View Code? Open in Web Editor NEW

9.0 9.0 2.0 871 KB

A Python-based tool for interacting with AzureMSv316-based databases

Home Page: https://team-spirit-productions.github.io/Lazuli/

License: GNU Affero General Public License v3.0

Python 97.49% Batchfile 2.51%

azurems maple maplestory private python server

lazuli's People

Contributors

Stargazers

Watchers

Forkers

rucchiz gvsolgryn

lazuli's Issues

Inconsistent Backtick for Prepared Statements

Describe the bug
Not technically a but yet, but the source code is not consistent with backticks. It would be good to apply them to all column and table names for prepared statements.

To Reproduce
NIL

Expected behavior
See description.

SQL Collison Possibilities

Describe the bug
Currently the setter methods for username (in accounts) and name (in characters) allow changes without collision checks.

To Reproduce
Steps to reproduce the behavior:

Change the Account(account_info, database_config).username or Character(char_stats, database_config).name to an existing name
See DB throwing errors for account name (key) clashes on console, but not for user. Notice that DB allows collisions for character names (non-key).

Expected behavior
Consider making such collisions raise an exception that can be carried forward using try-catch

Screenshots
Notice name collision in character IGNs: