reduce picklog database size

[ubeyou]

Hi bros,

 

The Picklog database getting bigger & bigger each day. (10GB after 2 months)

 

I wanted to keep track of players trading history, but at the same time minimize the picklog size.

 

What is the best setting for picklog?

[Jaburak]

trunk/conf/log_athena.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
// 0x10000 - (X) Log all other transcations (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)
// 0x20000 - ($) Log cash transactions
// 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

Removed other logs like picked items, looted items or whatever you want.

[ubeyou]

hi i realised the type M wasn't inside, is there anything wrong?

[Jaburak]

hi i realised the type M wasn't inside, is there anything wrong?

I think it's because you're using eAthena SVN.

 

// Enable Logs?
// 1 - Log all events.
// Or, determine what to log by adding up the different events:
// 0002 - (T) Log trades
// 0004 - (V) Log vending transactions
// 0008 - (P) Log items drop/picked by players
// 0016 - (L) Log items drop/looted by monsters
// 0032 - (S) Log NPC transactions (buy/sell)
// 0064 - (N) Log Script transactions (items deleted/acquired through quests)
// 0128 - (M) Log items stolen from mobs (Steal/Gank)
// 0256 - © Log player-used items
// 0512 - (M) Log MVP prize items
// 1024 - (A) Log player created/deleted items (through @/# commands)
// 2048 - ® Log items placed/retrieved from storage.
// 4096 - (G) Log items placed/retrieved from guild storage.
// 8192 - (E) Log mail system transactions.
// Example: Log trades+vending+script items+created items: 2+4+64+1024 = 1094
enable_logs: 0

[LatSo]

What if I empty my picklog, what will happen?