XenaNyx Posted February 24, 2012 Posted February 24, 2012 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 Quote
Wynn_ Posted February 24, 2012 Posted February 24, 2012 (edited) 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_ 1 Quote
XenaNyx Posted February 24, 2012 Author Posted February 24, 2012 (edited) 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 problemmust change atlog_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 1 Quote
jharick Posted July 8, 2012 Posted July 8, 2012 how about a complete account information. such as account id, character id, and character name Quote
Question
XenaNyx
now log update only
i want to insert account_id, when player delete character i can follow form account_id
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.