SQL language is like talking to a dabatase, this will be the basic for GunZ database editing, I will start this how I learned it, I was given some examples and I learned through them adapting those queries and using them with other database tables. You should have account registration scripts, search for them in this website, otherwise if you need to manually create accounts, let's go with the first example. To create account manually you will have two insert values into two tables, which are ACCOUNT and LOGIN. ACCOUNT has your account information, the id number (AID), the name, the ingame status (255 admin 254 gamemaster 253 banned 252 hiddenpowers 104 muted), date of registration, email, etc.. LOGIN contains the name, the AID, password, last connection date and the last ip used. So to create an account you will need two queries: INSERT INTO ACCOUNT (UserID, Ugradeid, PgradeID, RegDate, name, email) VALUES ('shadowking', '0', '1' ,'2007-07-30', 'shadowking', 'firstname.lastname@example.org') This account will generate an AID, which you will need for the login table query, in this case the AID will be 1337. Then with the AID 1337 in hand let's go for the second query: INSERT INTO LOGIN (USerID, AID, password) values ('shadowking', '1337', 'shadowking123') You just created account number 1337, called shadowking, with shadowking123 as password and email@example.com as registered email. Sequentially, registered emails are used for password recovery, but if you don't have an account recovery system and you need to change a password then you will write the following query: UPDATE LOGIN SET PASSWORD = 'shadowking456' WHERE AID = '1337' And the password on the account 1337 is now shadowking456. Now let's take advantadge of this query to go directly into character editing, you can create characters manually, but it's far easier to create them ingame, but first you need to search the character name with the search query: SELECT * FROM CHARACTER WHERE NAME = 'shadowking' And it will give you a CID, a character identification number, which you will use to change the sex like this: UPDATE CHARACTER SET SEX = '1' WHERE CID = '69' On the GunZ database, male sex = 0 and female sex = 1, so you just changed the character named shadowking whose CID is 69 to female. Note that you can use just the NAME to change any character table value, I used the CID so I could explain already the SELECT - search query, which brings us to another query, giving items, and for that query you definetely need the CID. So let's say someone won an event and you want to give that person an item. First you need to find the CID of that person, using the query above again: SELECT * FROM CHARACTER WHERE NAME = 'shadowking' That will give us CID number 69, that we will now use like this: INSERT INTO CHARACTERITEM (CID, ITEMID) VALUES ('69', '8044') And this way, item 8044 on the zitem was given to the character number 69. Now let's go to the delete query using the same example, but be carefull with the delete query thought, always use with a "where Table = "/destination, unless you want to wipe an entire table. For example, if you want to delete the whole inventory table, just write the query with no "where"/destination, like this: DELETE from Characteritem And all inventories are wiped. If you want to delete only one character's inventory you add its information as a destination: DELETE from Characteritem where CID = '69' Only Character 69's inventory is deleted. If you want to delete a specific item from a specific character then you add not only the character information but also the item id number both as destination of the query: DELETE from Characteritem where CID = '69' and itemid = '8044' Only item 8044 is deleted from character 69. Now I will try to explain the meaning and usage of these basic GunZ SQL database commands, I will use 3 queries and explain them. 1 - Search query -> SELECT * FROM CHARACTER WHERE NAME = 'shadowking' SELECT - means search, what will be searchED * - means all the values from the table FROM - where the info comes from CHARACTER - it's the table being searched, you can write here any other table name, like account, login, clan, etc.. WHERE - gives the query a destination NAME - the column being searched, you can write here other column names like sex, level, CID, AID, etc.. = - equals 'shadowking' - the value being searched on the character table. 2 - Update query -> UPDATE CHARACTER SET NAME = 'NEO' WHERE NAME = 'shadowking' UPDATE - means update or change CHARACTER - it's the table on which you will make changes, you can write here any other table name, like account, login, clan, etc.. SET - tells the database to set a new value NAME - the column being changed, you can write here other column names like sex, level, CID, AID, etc.. = - equals 'NEO' - the new name/value WHERE - gives the query a destination NAME '- the column used to find the original name/value = - equals 'shadowking' - the old name 3 - Insert query -> INSERT INTO CHARACTERITEM (CID, ITEMID) VALUES ('69', '8044') INSERT - insert or give INTO - to what table it goes CHARACTERITEM - it's the table where the values are being added, you can write any other table name, like account, login, clan, etc.. Between the ( ) and separated by commas , should be the columns to where you're going to add any values VALUES - needs to be between the specified columns and the values being entered into them. Between the ( ) separated by commas , and inside '' are the values that are going to be entered into the database table. 4 - Delete Query - DELETE from Characteritem where CID = '69' and itemid = '8044' DELETE - The delete command from - from what table Characteritem - table being deleted where - first destination for deletion CID - character id = - equals '69' - location of first destination and - and itemid - second destination for deletion = equals '8044' - location of the second destination Note: Always keep the values between ' ' in all queries. Also, important, you can always edit the tables by double clicking on the table and choosing "edit", but using queries is far more faster and efficient. To open an whole table for editing go to Menu - View - Object Explorer - open it and connect it, then open the GunZ database - right click on the table you want to edit. This is not much and I'm no SQL expert, what I've learned was as I stated above was through some examples and I know the minimum needed to fully administrate a GunZ database, I hope this can help someone at least to get started with your own server. Remember, this is the mininal knowledge you need to run a GunZ database, it's not a full SQL tutorial, I made this in little time and just to try to explain the basics of GunZ SQL, so save the flaming and spamming about it please. Thanks, sticky perhaps?