granting gm privileges

[kristani]

i'm not finding how to make my server so that characters can use GM commands, also is there a way to make it so my server is private and only people I want on there can join...it's for friends/family

[hayward6]

There's a database table called commands. In that table is all of the commands available to the server and you can change the required access level to use each command. If you want everyone to be able to use #zone simply make the required access level for that command 0. It's easy to do if you use MySQL query browser or some other editor to look at it.

if you only want certain people to join you should check out seting up a minilogin server from the wiki.

[kristani]

that's what I was asking, how do I change access levels

[hayward6]

Well to change a users access level you can change it in the account table of the database, or you can change the default starting level in the variables tab. You change the number in the commands table by simply editing it with a sql editing tool. I hope that clears it up a bit... it's easy to understand when you know how to do it :)

Maybe knowing what you use to edit the database will help me to understand what your seeing. Poking around in the database with an editor will help you learn a lot about how it works.

Let me know if you need anymore help, and good luck!

[kristani]

i don't know which program it is, i have activeperl, mysql, navicat and wincvs that I downloaded per the guide.

[hayward6]

Ok, Navicat is your database editor. You should be able to go into each of the tables we're talking about and find the settings. Do you have Navicat setup and can connect to the database with it?

[kristani]

I have it open, but nothing is on the screen

[hayward6]

Is Navicat something you're familiar with? It might be hard to explain if you're new to using it... You selected the eqemu database right? it should open up and you'll see all the different tables. I use MySQL Admin and query browser so I can't say for sure what it will look like :(

[kristani]

first time using it, i don't see how to open the database, says connection, manage users, table, view, function, others, query, report, backup, schedule up top

[kristani]

under host name/ip address am I supposed to put in my ip of my computer?

under port the guide said use 3306 is that correct?

for username is that root as stated in the guide?

[hayward6]

yes, username and password is what you set when you installed mysql, and you want it pointed to the ip of the server box... so if thats the pc you're on you can use that IP or "localhost" and that port is the one you should have setup in the installation.

[kristani]

i get an error "received invalid response to SSL negotiation: A" when I use that

[kristani]

ok I got the database open now

[kristani]

Ok I have mysql open and there 17 choices now for example: columns_priv, db, func, host, proc, procs_priv, tables_priv and so on

What's the next step?

[hayward6]

I haven't ever used Navicat and I don't suggest it because it costs money after the trial. I like using Mysql tools since they are free... The best I can tell you now is to just keep poking around at it until you find something that makes sense. Hopefully someone with more Navicat experience will pop in.

You can also make the changes to the database by using the built in web editor, but you have to set a password for it in the database first. Keep looking at the wiki and practice with the tools, you'll get there. If I can get some time away from the family I'll look at it some more as well :).

[kristani]

ok i'm downloading mysql tools to use instead of navicat, I only got that one cause the guide said to use it.

[hayward6]

Mysql query browser is pretty easy to use, you simply point it to the machine where the database is hosted and you choose the database you want to look at. Once the database is loaded up in the browser you'll see the different tables on the right side. You can double click those to show the different lines in each table. At the bottom of the window there's a small edit button, you have to click edit and then you can alter fields. Just make sure to save the changes you make.

Good idea to back up the database first since your new to editing... mysql admin is good for backing up.

[kristani]

is there a listing of what does what, this is like being given a book in a foreign language and asked to read aloud

[hayward6]

Mostly it's self explanatory, or theres a short description to the right... It would help if it was alphabetical, but it's not :)