[Trinity RoSPORA V1.4.4.1] GM level on account creation?

[Tomatsuppen]

Hello MMowned,

As my thread name says.

Im running an public wow server based on the latest Trinity Core & TDB REV's.

I'm using RoSPORA V1.4.4.1 Account creation page and was wondering if anyone could tell me how it would be possible to mod the account page, so all account creations would be set at "gm level 2" ?

+Rep for any help

Thanks for reading.

[myran2]

If you could give me the download link to the site you got, I'll take a try at it

[Tomatsuppen]

myran2, That would be nice if you would give it a try.

[Trinity RoSPORA V1.4.4.1]
http://www.fileden.com/files/2007/10/25/1539458/RoSPORA%20V1.4.4.1.rar

[Kiev]

if($realm_db->query("INSERT INTO `account` (`username`,`sha_pass_hash`,`email`,`last_ip`,`locked`,`expansion`) VALUES (UPPER('".$username."'),SHA1(CONCAT(UPPER('".$username."'),':',UPPER('".$passw."'))),'".$email."','".$ip."','".$lock_acc."','".$expansion."')"))

This line is where you put the account into the database, if you take a look at the column names of the "account" table, you will notice the one for GM, in this SQL query you need to position into the query after where it is in the columns, E.G:

if($realm_db->query("INSERT INTO `account` (`username`,`sha_pass_hash`,`GM`,`email`,`last_ip`,`locked`,`expansion`) VALUES (UPPER('".$username."'),SHA1(CONCAT(UPPER('".$username."'),':',UPPER('".$passw."'))),'3','".$email."','".$ip."','".$lock_acc."','".$expansion."')"))

Now this itself wont work, as i dont know the column name for GM in Trinity, but just change the "GM" to the column name and it SHOULD work fine.

[myran2]

Actually, since the changes to account_access I don't think changing GMlevel on account create will work without a major rewrite.

What you CAN try is going to the 'command' table in your world database and changing the permissions for each individual command, that will give you more control over what players can and cannot do and will also be a lot less work for you in the long run

[Tomatsuppen]

Kiev & Myran2,

Thank you for the help, trying to solve my question, I'll try what both of you told me, thanks

+REP to both of you


I did follow myran2's reply about editing the command table, thats what I needed, big thanks again

[myran2]

No problem, I'm happy to help

[revaq]

No problem, I'm happy to help

Hey can anyone help me, i got my first trinity core, i was used to ArcEmu with the 1-6 gm levels,
But i want to know which is the lowest gm account level you can set and what is highest, someone also explain what that level can do and a name like 'GM' 'Admin' 'Owner'

i.e.

Gm level 1: Can do .morph etc..

[myran2]

Hey can anyone help me, i got my first trinity core, i was used to ArcEmu with the 1-6 gm levels,
But i want to know which is the lowest gm account level you can set and what is highest, someone also explain what that level can do and a name like 'GM' 'Admin' 'Owner'

i.e.

Gm level 1: Can do .morph etc..

First off, It would be better if you would make a new topic with your question in it next time. Instead of bumping an older thread.

I guess I'll try to help you anyway.

TrinityCore has 4 GM levels;
0 - Player (Lowest)
1 - Moderator
2 - Gamemaster
3 - Admin (Highest IN-GAME RANK)
4 - Console (NEVER SET YOUR ACCOUNT RANK TO THIS, ITS ONLY FOR THE SERVER CONSOLE)

You can modify the commands in the 'command' table in your world database, like what was previously stated.