ParSalian Posted February 26, 2013 Group: Members Topic Count: 6 Topics Per Day: 0.00 Content Count: 35 Reputation: 1 Joined: 02/04/13 Last Seen: May 20, 2014 Share Posted February 26, 2013 Why the charlog_db is missing again in the sql files . I know there is a post marked as solved ,http://rathena.org/board/topic/71045-how-to-fix-this-missing-char-log-sql/ but is missing in the current SVN. Is somebody still use the DB to record any character creation and deletion or I am the only one ? Quote Link to comment Share on other sites More sharing options...
Brian Posted February 26, 2013 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted February 26, 2013 The `charlog` table is part of the "ragnarok" database. (reasoning was: so the char server does not have to make a 2nd MySQL connection to the "logs" database) The `charlog` table will be created when you import trunk/sql-files/main.sql -- -- Table structure for table `charlog` -- CREATE TABLE IF NOT EXISTS `charlog` ( `time` datetime NOT NULL default '0000-00-00 00:00:00', `char_msg` varchar(255) NOT NULL default 'char select', `account_id` int(11) NOT NULL default '0', `char_num` tinyint(4) NOT NULL default '0', `name` varchar(23) NOT NULL default '', `str` int(11) unsigned NOT NULL default '0', `agi` int(11) unsigned NOT NULL default '0', `vit` int(11) unsigned NOT NULL default '0', `int` int(11) unsigned NOT NULL default '0', `dex` int(11) unsigned NOT NULL default '0', `luk` int(11) unsigned NOT NULL default '0', `hair` tinyint(4) NOT NULL default '0', `hair_color` int(11) NOT NULL default '0' ) ENGINE=MyISAM; Quote Link to comment Share on other sites More sharing options...
ParSalian Posted February 26, 2013 Group: Members Topic Count: 6 Topics Per Day: 0.00 Content Count: 35 Reputation: 1 Joined: 02/04/13 Last Seen: May 20, 2014 Author Share Posted February 26, 2013 Thanks for the answer Quote Link to comment Share on other sites More sharing options...
Question
ParSalian
Why the charlog_db is missing again in the sql files . I know there is a post marked as solved ,http://rathena.org/board/topic/71045-how-to-fix-this-missing-char-log-sql/
but is missing in the current SVN. Is somebody still use the DB to record any character creation and deletion or I am the only one ?
Link to comment
Share on other sites
2 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.