Archived copy of warcraft-source.com, the Warcraft: Source (WCS) forum (2007–2011), rebuilt from the Internet Archive by wc3mods.net. This page was captured on 2011-05-10 (original capture). Home · Forum · All archived topics · Downloads

Author Topic: [Tutorial] SQLite Database editing with Firefox Plugin  (Read 703 times)

iMak

  • Moderator
  • Level 7 Expert
  • Posts: 469
  • Pokemon Master!
[Tutorial] SQLite Database editing with Firefox Plugin
« on: January 13, 2011, 02:59:49 AM »
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 :

Code: [Select]
Extras->SQLite Manager
This will open the SQLite Manager so you should see this:
(click to show/hide)

Now go to:

Code: [Select]
Database->Connect Database
This 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 :>


$Diablo$

  • Level 7 Expert
  • Posts: 444
Mmm interesting, thanks for info kami



La Muerte

  • Administrator
  • Level 7 Expert
  • Posts: 1246
  • 85.234.148.14:27025
Nice.

DABASS

  • Level 7 Expert
  • Posts: 380
Hi how can i delete one player from database?

Lukas320

  • Level 7 Expert
  • Posts: 261
  • <3 WCS :)
http://sourceforge.net/projects/sqlitebrowser/

You could also use this free program.
I use it and it works very well :D

desmer45

  • Level 0 Beginner
  • Posts: 11
  • <3 WCS :) !!
Hi

I cant change the levels on players then the server is online :S Anyone know why??? because i am tired of that i have to shut down the server when someone bought levels...!

Desmer45

La Muerte

  • Administrator
  • Level 7 Expert
  • Posts: 1246
  • 85.234.148.14:27025
You can't change the levels in the database while server is online, because while you are editing database the database is already getting newer data saved to it. You don't have to restart the server to give someone levels, you can just do it trough admin menu or trough a remote console.

desmer45

  • Level 0 Beginner
  • Posts: 11
  • <3 WCS :) !!
What do you mean with remote console???

La Muerte

  • Administrator
  • Level 7 Expert
  • Posts: 1246
  • 85.234.148.14:27025
rcon, or a tool like HSDL or whats it called?
I personally don't need tools because I can do things trough my SourceBans site.

deathkilla5656

  • Level 4 Intermediate
  • Posts: 96
called :HLSW


you need rcon pw to use it
I <3 WCS


 


* Ads