Hey guys today I'll tell you how to edit your SQLite Database using a Firefox Plugin.
First of all get this plugin:
https://addons.mozilla.org/de/firefox/addon/5817/
Then after the Firefox restart go to :
This will open the SQLite Manager so you should see this:
Now go to:
This will open a filebrowser where you have to find your Database. Simply open it with this.
Then it should look like this:
Now go to "Tables" and you will find 3 keys.
1. Players
2. Races
3. Sqlite_sequence
The third is SQLite system thing i think so we dont need this :>
1. Editing the Database with the "Players" key:
Double clicking the "players" key will open the table for players on the right side and it should look like this:
Now you can double click on the desired user (you can easily identify the user by using steamid and name)
This will open a window where you can change the:
a) UserID ( which should not be done!)
b) steamid (bad idea too)
c) currace (this will change the race the player is on, be sure to have an existing racename in there or it will blow up)
d) name (dont change this too!)
e) totallevel (this will change the totallevel of the user, changing this wont blow it up but can lead to complicated situations such as having a race not fitting the total level)
f) lastconnected (dont change this either :>)
2. Editing the Database with the "races" key:
Double clicking the "races" key will open the following window:
Here you can change stuff like a players racelevel, racexp or the skills the race has for a certain user.
In this case its REALY important that you have a look at the Players Table FIRST and find out which ID which User has!
If you have the players ID then you can easily find the desired player by using the Search function :
Just search for the desired userid and it will give you every race that user has ever played.
Double clicking the race you want to change will open a window where you can change the following:
a) RaceID (do not change that or it will blow :>)
b) UserID (again NO CHANGE)
c) name (You shouldnt change that too but if you want to then be sure to have a REAL race in there)
d) skills (here you can change what lvl the player has on what skill for that race)
e) level (this will change the level the player has for the race)
f) xp (this will change the XP the player has for the race)
g) unused (this are the skillpoints the player has left to spend on this race)
I hope I made everything clear but if you have any question left feel free to ask here :>
First of all get this plugin:
https://addons.mozilla.org/de/firefox/addon/5817/
Then after the Firefox restart go to :
Code: [Select]
Extras->SQLite ManagerThis will open the SQLite Manager so you should see this:
(click to show/hide)
Now go to:
Code: [Select]
Database->Connect DatabaseThis will open a filebrowser where you have to find your Database. Simply open it with this.
Then it should look like this:
(click to show/hide)
Now go to "Tables" and you will find 3 keys.
1. Players
2. Races
3. Sqlite_sequence
The third is SQLite system thing i think so we dont need this :>
1. Editing the Database with the "Players" key:
Double clicking the "players" key will open the table for players on the right side and it should look like this:
(click to show/hide)
Now you can double click on the desired user (you can easily identify the user by using steamid and name)
This will open a window where you can change the:
a) UserID ( which should not be done!)
b) steamid (bad idea too)
c) currace (this will change the race the player is on, be sure to have an existing racename in there or it will blow up)
d) name (dont change this too!)
e) totallevel (this will change the totallevel of the user, changing this wont blow it up but can lead to complicated situations such as having a race not fitting the total level)
f) lastconnected (dont change this either :>)
2. Editing the Database with the "races" key:
Double clicking the "races" key will open the following window:
(click to show/hide)
Here you can change stuff like a players racelevel, racexp or the skills the race has for a certain user.
In this case its REALY important that you have a look at the Players Table FIRST and find out which ID which User has!
If you have the players ID then you can easily find the desired player by using the Search function :
(click to show/hide)
Just search for the desired userid and it will give you every race that user has ever played.
Double clicking the race you want to change will open a window where you can change the following:
a) RaceID (do not change that or it will blow :>)
b) UserID (again NO CHANGE)
c) name (You shouldnt change that too but if you want to then be sure to have a REAL race in there)
d) skills (here you can change what lvl the player has on what skill for that race)
e) level (this will change the level the player has for the race)
f) xp (this will change the XP the player has for the race)
g) unused (this are the skillpoints the player has left to spend on this race)
I hope I made everything clear but if you have any question left feel free to ask here :>






