[QUESTION]

09/13/2011 07:29 [DEV]xXDASHXx#1

is there already a tabel or section in the db that stores gm comands such as /kick /mmake and so on b4 it gets executed for futcher refrence on what gm used what command and made what items?? im wanting ta make a tabel the keeps track of EVERY command a gm uses as a refrence on who is doing there job corectly and if any1 is useing there powers in the wrong way ( slowly /makeing gear /lapis and storing on other account or giveing to friends and or /huraseing players by /kick and summon stuff like that)

09/13/2011 07:58 DEvolver#2

well idk about a table for GM commands but u can check the chat log for that info

09/13/2011 08:34 viper4513#3

Chat log doesnt show commands used, just chat.. hence the name "chat log"
Check out the Action log table in your database

Code:

USE PS_Gamelog
SELECT * FROM ActionLog

Can add a WHERE clause at the end of that aswell to specify which GM you wanna check, or for which command you wanna check.

Code:

WHERE CharName = BadGM

There is also a query in Ariez release of guides that brings up GM commands that have been used, called Naughty GM i think.

But then again, why have a GM that you dont trust and that you have to check up on to make sure they are being good little boys and girls?

09/13/2011 08:55 RebeccaBlack#4

Edit usp_Insert_Action_Log_E

Add something like:

Code:

IF @ActionType = 180
BEGIN
-- Insert to your custom made table here
END