| 1 | #PickLog types (M)onsters Drop, (P)layers Drop/Take, Mobs Drop (L)oot Drop/Take, |
|---|
| 2 | # Players (T)rade Give/Take, Players (V)ending Sell/Take, (S)hop Sell/Take, (N)PC Give/Take, |
|---|
| 3 | # (C)onsumable Items, (A)dministrators Create/Delete, Sto(R)age, (G)uild Storage, |
|---|
| 4 | # (E)mail attachment |
|---|
| 5 | |
|---|
| 6 | #Database: log |
|---|
| 7 | #Table: picklog |
|---|
| 8 | CREATE TABLE `picklog` ( |
|---|
| 9 | `id` int(11) NOT NULL auto_increment, |
|---|
| 10 | `time` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 11 | `char_id` int(11) NOT NULL default '0', |
|---|
| 12 | `type` enum('M','P','L','T','V','S','N','C','A','R','G','E') NOT NULL default 'P', |
|---|
| 13 | `nameid` int(11) NOT NULL default '0', |
|---|
| 14 | `amount` int(11) NOT NULL default '1', |
|---|
| 15 | `refine` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 16 | `card0` int(11) NOT NULL default '0', |
|---|
| 17 | `card1` int(11) NOT NULL default '0', |
|---|
| 18 | `card2` int(11) NOT NULL default '0', |
|---|
| 19 | `card3` int(11) NOT NULL default '0', |
|---|
| 20 | `map` varchar(11) NOT NULL default '', |
|---|
| 21 | PRIMARY KEY (`id`), |
|---|
| 22 | INDEX (`type`) |
|---|
| 23 | ) ENGINE=MyISAM AUTO_INCREMENT=1 ; |
|---|
| 24 | |
|---|
| 25 | #ZenyLog types (M)onsters,(T)rade,(V)ending Sell/Buy,(S)hop Sell/Buy,(N)PC Change amount,(A)dministrators |
|---|
| 26 | #Database: log |
|---|
| 27 | #Table: zenylog |
|---|
| 28 | CREATE TABLE `zenylog` ( |
|---|
| 29 | `id` int(11) NOT NULL auto_increment, |
|---|
| 30 | `time` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 31 | `char_id` int(11) NOT NULL default '0', |
|---|
| 32 | `src_id` int(11) NOT NULL default '0', |
|---|
| 33 | `type` enum('M','T','V','S','N','A') NOT NULL default 'S', |
|---|
| 34 | `amount` int(11) NOT NULL default '0', |
|---|
| 35 | `map` varchar(11) NOT NULL default '', |
|---|
| 36 | PRIMARY KEY (`id`), |
|---|
| 37 | INDEX (`type`) |
|---|
| 38 | ) ENGINE=MyISAM AUTO_INCREMENT=1 ; |
|---|
| 39 | |
|---|
| 40 | #Database: log |
|---|
| 41 | #Table: branchlog |
|---|
| 42 | CREATE TABLE `branchlog` ( |
|---|
| 43 | `branch_id` mediumint(9) unsigned NOT NULL auto_increment, |
|---|
| 44 | `branch_date` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 45 | `account_id` int(11) NOT NULL default '0', |
|---|
| 46 | `char_id` int(11) NOT NULL default '0', |
|---|
| 47 | `char_name` varchar(25) NOT NULL default '', |
|---|
| 48 | `map` varchar(11) NOT NULL default '', |
|---|
| 49 | PRIMARY KEY (`branch_id`), |
|---|
| 50 | INDEX (`account_id`), |
|---|
| 51 | INDEX (`char_id`) |
|---|
| 52 | ) ENGINE=MyISAM AUTO_INCREMENT=1 ; |
|---|
| 53 | |
|---|
| 54 | #Database: log |
|---|
| 55 | #Table: mvplog |
|---|
| 56 | CREATE TABLE `mvplog` ( |
|---|
| 57 | `mvp_id` mediumint(9) unsigned NOT NULL auto_increment, |
|---|
| 58 | `mvp_date` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 59 | `kill_char_id` int(11) NOT NULL default '0', |
|---|
| 60 | `monster_id` smallint(6) NOT NULL default '0', |
|---|
| 61 | `prize` int(11) NOT NULL default '0', |
|---|
| 62 | `mvpexp` mediumint(9) NOT NULL default '0', |
|---|
| 63 | `map` varchar(11) NOT NULL default '', |
|---|
| 64 | PRIMARY KEY (`mvp_id`) |
|---|
| 65 | ) ENGINE=MyISAM AUTO_INCREMENT=1 ; |
|---|
| 66 | |
|---|
| 67 | #Database: log |
|---|
| 68 | #Table: atcommandlog |
|---|
| 69 | CREATE TABLE `atcommandlog` ( |
|---|
| 70 | `atcommand_id` mediumint(9) unsigned NOT NULL auto_increment, |
|---|
| 71 | `atcommand_date` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 72 | `account_id` int(11) unsigned NOT NULL default '0', |
|---|
| 73 | `char_id` int(11) unsigned NOT NULL default '0', |
|---|
| 74 | `char_name` varchar(25) NOT NULL default '', |
|---|
| 75 | `map` varchar(11) NOT NULL default '', |
|---|
| 76 | `command` varchar(255) NOT NULL default '', |
|---|
| 77 | PRIMARY KEY (`atcommand_id`), |
|---|
| 78 | INDEX (`account_id`), |
|---|
| 79 | INDEX (`char_id`) |
|---|
| 80 | ) ENGINE=MyISAM AUTO_INCREMENT=1 ; |
|---|
| 81 | |
|---|
| 82 | #Database: log |
|---|
| 83 | #Table: npclog |
|---|
| 84 | CREATE TABLE `npclog` ( |
|---|
| 85 | `npc_id` mediumint(9) unsigned NOT NULL auto_increment, |
|---|
| 86 | `npc_date` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 87 | `account_id` int(11) unsigned NOT NULL default '0', |
|---|
| 88 | `char_id` int(11) unsigned NOT NULL default '0', |
|---|
| 89 | `char_name` varchar(25) NOT NULL default '', |
|---|
| 90 | `map` varchar(11) NOT NULL default '', |
|---|
| 91 | `mes` varchar(255) NOT NULL default '', |
|---|
| 92 | PRIMARY KEY (`npc_id`), |
|---|
| 93 | INDEX (`account_id`), |
|---|
| 94 | INDEX (`char_id`) |
|---|
| 95 | ) ENGINE=MyISAM AUTO_INCREMENT=1 ; |
|---|
| 96 | |
|---|
| 97 | #ChatLog types Gl(O)bal,(W)hisper,(P)arty,(G)uild,(M)ain chat |
|---|
| 98 | #Database: log |
|---|
| 99 | #Table: chatlog |
|---|
| 100 | CREATE TABLE `chatlog` ( |
|---|
| 101 | `id` bigint(20) NOT NULL auto_increment, |
|---|
| 102 | `time` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 103 | `type` enum('O','W','P','G','M') NOT NULL default 'O', |
|---|
| 104 | `type_id` int(11) NOT NULL default '0', |
|---|
| 105 | `src_charid` int(11) NOT NULL default '0', |
|---|
| 106 | `src_accountid` int(11) NOT NULL default '0', |
|---|
| 107 | `src_map` varchar(11) NOT NULL default '', |
|---|
| 108 | `src_map_x` smallint(4) NOT NULL default '0', |
|---|
| 109 | `src_map_y` smallint(4) NOT NULL default '0', |
|---|
| 110 | `dst_charname` varchar(25) NOT NULL default '', |
|---|
| 111 | `message` varchar(150) NOT NULL default '', |
|---|
| 112 | PRIMARY KEY (`id`), |
|---|
| 113 | INDEX (`src_accountid`), |
|---|
| 114 | INDEX (`src_charid`) |
|---|
| 115 | ) ENGINE=MyISAM AUTO_INCREMENT=1 ; |
|---|
