hiroman Posted November 11, 2017 Posted November 11, 2017 How to delete accounts from server's database?
1 Cheshire Posted November 11, 2017 Posted November 11, 2017 It's a little involved, but the easiest way would be to get something that can read SQLite databases (such as: http://sqlitebrowser.org/) and execute the query from the following post to completely wipe ALL USERS: Â
0 RandemGamor Posted November 14, 2017 Posted November 14, 2017 On 11/11/2017 at 12:46 PM, mrhiroman said: How to delete accounts from server's database? I use DB Browser for SQLitehttp://sqlitebrowser.org/ Then right click your servers database It's in Server > Resources > intersect.db Open With ... (Choose Default Program) Browse - point to DB Browser for SQLite Easiest way to then just double click the .db file to open anytime ! Once the database is open in the program. At the top there's 4 tabs; "Database Structure, Browse Data, etc..." Goto "Browse Data." Then under there you'll see "Table" with a drop down box. All the way to the bottom of that list will be "users" Simply select the user by clicking the number to the far left (Not the one under ID) Then there's a "Delete Record" option Then goto; "File > Write Changes" Job Done There's other things you can edit / delete in here too. Just have a browse. Enjoy ! RG \o> Â
0 Cheshire Posted November 14, 2017 Posted November 14, 2017 @RandemGamor That does not delete all the data associated with the user though, and leaves characters and such behind.
Question
hiroman
How to delete accounts from server's database?
3 answers to this question
Recommended Posts