MikZ 5 Posted October 25, 2015 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! Quote Share this post Link to post Share on other sites
0 Winterfox 83 Posted October 25, 2015 @@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'. Quote Share this post Link to post Share on other sites
0 iCORE 33 Posted October 25, 2015 // 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 Quote Share this post Link to post Share on other sites
0 MikZ 5 Posted October 26, 2015 @@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 Quote Share this post Link to post Share on other sites
0 Litro 45 Posted October 26, 2015 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 Quote Share this post Link to post Share on other sites
0 Winterfox 83 Posted October 26, 2015 @@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' ) Quote Share this post Link to post Share on other sites
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!
Share this post
Link to post
Share on other sites