Delete Saves?

[Spudnik Studios]

Heyy, how do u delete saves? like accounts (i need a lot when testing, so i just need to delete them)

[Chronos]

4 hours ago, Raku said:

Get a program that can view/edit database files (.db) like DB Browser for SQLite. Go to the server resources folder and open "intersect.db"  with the program and search for the "users" table and delete the accounts that you want.

This is incomplete, as there's also the bans, characters, char_bank, char_hotbar, char_inventory, char_quests, char_spells, char_switches, char_variables and mutes tables.

 

This query should wipe any and all user data from the database, however:

CREATE TEMP TABLE _Users(id INTEGER);
CREATE TEMP TABLE _Characters(id INTEGER);

INSERT INTO _Users (id) VALUES ((SELECT id FROM users));
INSERT INTO _Characters (id) VALUES ((SELECT id FROM characters));

DELETE FROM users WHERE id IN (SELECT * FROM _Users);
DELETE FROM bans WHERE user IN (SELECT * FROM _Users);
DELETE FROM mutes WHERE user IN (SELECT * FROM _Users);
DELETE FROM characters WHERE id IN (SELECT * FROM _Characters);
DELETE FROM char_bank WHERE char_id IN (SELECT * FROM _Characters);
DELETE FROM char_hotbar WHERE char_id IN (SELECT * FROM _Characters);
DELETE FROM char_inventory WHERE char_id IN (SELECT * FROM _Characters);
DELETE FROM char_quests WHERE char_id IN (SELECT * FROM _Characters);
DELETE FROM char_spells WHERE char_id IN (SELECT * FROM _Characters);
DELETE FROM char_switches WHERE char_id IN (SELECT * FROM _Characters);
DELETE FROM char_variables WHERE char_id IN (SELECT * FROM _Characters);

DROP TABLE _Users;
DROP TABLE _Characters;

 

[Raku]

45 minutes ago, Spudnik Studios said:

Heyy, how do u delete saves? like accounts (i need a lot when testing, so i just need to delete them)

Get a program that can view/edit database files (.db) like DB Browser for SQLite. Go to the server resources folder and open "intersect.db"  with the program and search for the "users" table and delete the accounts that you want.