ULX

Author Topic: Converting users.txt to SQL Data  (Read 2558 times)

0 Members and 1 Guest are viewing this topic.

Offline CodeLight

  • Newbie
  • *
  • Posts: 1
  • Karma: 0
Converting users.txt to SQL Data
« on: January 07, 2018, 02:41:53 AM »
Hi ya'll.

I've recently taken interest in MrPresident's ULib MySQL Authentication method which overrides the save and load functions which instead of loading and saving users to the users.txt file, it will save and load them from an external database.

Original post by MrPresident can be found here: https://forums.ulyssesmod.net/index.php?topic=8377.0

I own a large community which has a users.txt file filled with over 50,000 lines. When a user connects to the server, is promoted to a rank or demoted from a rank the server experiences a second or two of lag. I am interested to find out if it would be possible to convert all the user data located in the users.txt file to the external database which my server is loading and saving player data to and from as I cannot afford to re-promote all the users which have connected to the server to their staff ranks and donation ranks again.

Anyone which may be able to assist, feel free to place a comment.

Edit: Issue resolved, discard.

Thanks,
CodeLight

Discord: CodeLight#5678
Steam: http://steamcommunity.com/id/codelightaus/
« Last Edit: January 07, 2018, 04:01:04 AM by CodeLight »