Pick Log with account_id

[XenaNyx]

now log update only

`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`

i want to insert account_id, when player delete character i can follow form account_id

[Wynn_]

Add an account_id column to your database, it isn't necessary if you're using txt logs.

ALTER TABLE `picklog` ADD `account_id` int( 11 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `char_id`;

And apply this diff:

http://pastebin.com/PcmXwVSZ

Edited February 24, 2012 by Wynn_

[XenaNyx]

i try this but have error

: DB error - Incorrect table name 'log/picklog.log'

[Debug]: at log.c:185 - INSERT DELAYED INTO `log/picklog.log` (`time`, `char_id`, `account_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`) VALUES (NOW(), '150001', '2000001', 'A', '984', '3', '0', '0', '0', '0', '0', 'payon')

i know problem

must change at

log_athena.conf

// Logging tables/files

// Following settings specify where to log to. If 'sql_logs' is

// enabled, SQL tables are assumed, otherwise flat files.

Edited February 24, 2012 by ROZEN

[jharick]

how about a complete account information.

such as

account id, character id, and character name