TRADE and COMMAND LOGS

[MikZ 5]

Hello, How can i make new logs in SQL(phpmyadmin) for GM LEVEL 2 and up?

I just wan't to monitor them.. Help me..

Thank you!

[Winterfox 83]

@@MikZ

 

You can define what groups to log separatly in /conf/groups.conf via log_commands.

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

[iCORE 33]

// Enable Logs? (Note 3)// 0x00000 - Don't log at all// 0x00001 - (T) Log trades// 0x00002 - (V) Log vending transactions// 0x00004 - (P) Log items drop/picked by players// 0x00008 - (L) Log items drop/looted by monsters// 0x00010 - (S) Log NPC transactions (buy/sell)// 0x00020 - (N) Log Script transactions (items deleted/acquired through quests)// 0x00040 - (D) Log items stolen from mobs (Steal/Gank)// 0x00080 - © Log player-used items (consumables/pet&hom&merc food/items used for skills&attacks)// 0x00100 - (O) Log produced/ingredient items// 0x00200 - (U) Log MVP prize items// 0x00400 - (A) Log player created/deleted items (through @/# commands)// 0x00800 - ® Log items placed/retrieved from storage.// 0x01000 - (G) Log items placed/retrieved from guild storage.// 0x02000 - (E) Log mail system transactions.// 0x04000 - (I) Log auction system transactions.// 0x08000 - ( Log buying store transactions// 0x20000 - (K) Log account bank transactions// 0x10000 - (X) Log all other transactions (rentals expiring/inserting cards/items removed by item_check///           rings deleted by divorce/pet egg (un)hatching/pet armor (un)equipping/Weapon Refine skill/Remove Trap skill)// Example: Log trades+vending+script items+created items: 1+2+32+1024 = 1059// Please note that moving items from inventory to cart and back is not logged by design.enable_logs: 0xFFFFF

[MikZ 5]

 

@@MikZ

 

You can define what groups to log separatly in /conf/groups.conf via log_commands.

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

 

 

// Enable Logs? (Note 3)// 0x00000 - Don't log at all// 0x00001 - (T) Log trades// 0x00002 - (V) Log vending transactions// 0x00004 - (P) Log items drop/picked by players// 0x00008 - (L) Log items drop/looted by monsters// 0x00010 - (S) Log NPC transactions (buy/sell)// 0x00020 - (N) Log Script transactions (items deleted/acquired through quests)// 0x00040 - (D) Log items stolen from mobs (Steal/Gank)// 0x00080 - © Log player-used items (consumables/pet&hom&merc food/items used for skills&attacks)// 0x00100 - (O) Log produced/ingredient items// 0x00200 - (U) Log MVP prize items// 0x00400 - (A) Log player created/deleted items (through @/# commands)// 0x00800 - ® Log items placed/retrieved from storage.// 0x01000 - (G) Log items placed/retrieved from guild storage.// 0x02000 - (E) Log mail system transactions.// 0x04000 - (I) Log auction system transactions.// 0x08000 - ( Log buying store transactions// 0x20000 - (K) Log account bank transactions// 0x10000 - (X) Log all other transactions (rentals expiring/inserting cards/items removed by item_check///           rings deleted by divorce/pet egg (un)hatching/pet armor (un)equipping/Weapon Refine skill/Remove Trap skill)// Example: Log trades+vending+script items+created items: 1+2+32+1024 = 1059// Please note that moving items from inventory to cart and back is not logged by design.enable_logs: 0xFFFFF

Hmm.. i want to separate players from GM. so i want other logs for GMs only.

So in my sql theres Player logs, and GM logs . or is that what your trying to tell me? sorry Em a bit slow. huehue

 

[Litro 45]

you can use mysql query for it but i can't point out how since i didn't have knowledge about it atm,

 

1st. search account id with group id 2

2nd. list the char of that account (Optional)

3rd. go to atcommandlog and search that account id that listed in 1st step

 

might who with mysql query knowledge about that can help you..

if you wan it via script that i can help you, tell me if you want it i can make it for you

[Winterfox 83]

@@MikZ

 

In SQL you can get the entries of a specific user by using:

SELECT * FROM `atcommandlog` WHERE `account_id` = ( SELECT `account_id` FROM `login` WHERE `userid` = 'USERNAME' )