Split atcommandlog MySQL Table

[Relzz]

There is a way... to split the Normal Users and GM Players atcommmandlog MySQL database? this is because finding what a GM did in a day takes to much.. i mean i know how to use Querys but.. i think would be better if these db were splited

Baad english ..

[Brian]

You could only log GM @commands and not player @commands.

trunk/conf/groups.conf

<log_commands>
Boolean value. If true then all commands used by the group will be logged to 
atcommandlog. If setting is omitted in a group definition, false is assumed.
Requires 'log_commands' to be enabled in 'conf/log_athena.conf'.

Set log_commands: false for groups which you don't want @commands to be logged.

[Relzz]

Okay, thanks!

where i can find all the permisions(?)

i fount it:

see: doc/permissions.txt

thanks xD

Edited November 18, 2012 by M45T3R

[Lemongrass]

SELECT
atcommandlog.atcommand_date,
atcommandlog.atcommand_id,
atcommandlog.account_id,
atcommandlog.char_id,
atcommandlog.char_name,
atcommandlog.command,
atcommandlog.map
FROM atcommandlog
LEFT JOIN login ON( atcommandlog.account_id = login.account_id )
WHERE login.group_id > '<insert group id here>';

Should solve your problem.