redv1per

ah, i see. thank you so much

yes, i will do it later. by the way, everytime after editing script, eg: edit npc location, change drop/exp rate or add npc, do i need to recompile the rathena again? or just do ./athena-start restart?

its now Fixed, im using default rAthena configuration withouth change char_athena.conf and map_athena.conf files. I only add GM user at MySQL database. now my server are up

ok, i will try to reinstall all. hope this will work

you mean this? INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('2000000', 'ragnarok', 'ragnarok', 'M','[email protected]'); i change it to M. should i change it back to original?

its empty all files inside /conf/import/ are empty

all username and password are match. latest i think? because i clone it from github just yesterday. now im trying to change user and pass, both on files.conf and main.sql

Hello, im facing this problem when running ./char-server and i already change that s1/p1 to my own user and pass. (im looking everywhere in rAthena folder, and these is no s1/p1). but that error always said invalid communication password this is from ./athena-start start i hope someone can answer or help here is my char_athena.conf // Athena Character configuration file. // Note: "Comments" are all text on the right side of a double slash "//" // Whatever text is commented will not be parsed by the servers, and serves // only as information/reference. // Server Communication username and password. userid: myuser passwd: mypass // Server name, use alternative character such as ASCII 160 for spaces. // NOTE: Do not use spaces or any of these characters which are not allowed in // Windows filenames \/:*?"<>| // ... or else guild emblems won't work client-side! server_name: ragnarok // Wisp name for server: used to send wisp from server to players (between 4 to 23 characters) wisp_server_name: ragnarok // Login Server IP // The character server connects to the login server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. login_ip: 127.0.0.1 // The character server listens on the interface with this IP address. // NOTE: This allows you to run multiple servers on multiple interfaces // while using the same ports for each server. bind_ip: 127.0.0.1 // Login Server Port login_port: 6900 // Character Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. char_ip: my_public_ip // Character Server Port char_port: 6121 //Time-stamp format which will be printed before all messages. //Can at most be 20 characters long. //Common formats: // %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format) // %H:%M:%S (hour:minute:second, 24 hour format) // %d/%b/%Y (day/Month/year) //For full format information, consult the strftime() manual. //timestamp_format: [%d/%b %H:%M] //If redirected output contains escape sequences (color codes) stdout_with_ansisequence: no //Makes server log selected message types to a file in the /log/ folder //1: Log Warning Messages //2: Log Error and SQL Error messages. //4: Log Debug Messages //Example: "console_msg_log: 7" logs all 3 kinds //Messages logged by this overrides console_silent setting console_msg_log: 0 // File path to store the console messages above console_log_filepath: ./log/char-msg_log.log //Makes server output more silent by ommitting certain types of messages: //1: Hide Information messages //2: Hide Status messages //4: Hide Notice Messages //8: Hide Warning Messages //16: Hide Error and SQL Error messages. //32: Hide Debug Messages //Example: "console_silent: 7" Hides information, status and notice messages (1+2+4) console_silent: 0 // Console Commands // Allow for console commands to be used on/off // This prevents usage of >& log.file console: off // Type of server. // No functional side effects at the moment. // Displayed next to the server name in the client. // 0=normal, 1=maintenance, 2=over 18, 3=paying, 4=P2P char_maintenance: 0 // Enable or disable creation of new characters. // Now it is actually supported [Kevin] char_new: yes // Display (New) in the server list. char_new_display: 0 // Maximum users able to connect to the server. // Set to 0 to disable users to log-in. (-1 means unlimited) max_connect_user: -1 // Group ID that is allowed to bypass the server limit of users. // Or to connect when the char is in maintenance mode (groupid >= allow) // Default: -1 = nobody (there are no groups with ID < 0) // See: conf/groups.conf gm_allow_group: 99 // How often should the server save guild infos? (In seconds) // (character save interval is defined on the map config (autosave_time)) autosave_time: 60 // Display information on the console whenever characters/guilds/parties/pets are loaded/saved? save_log: yes // Starting point for new characters // Format: <map_name>,<x>,<y>{:<map_name>,<x>,<y>...} // Max number of start points is MAX_STARTPOINT in char.hpp (default 5) // Location is randomly picked on character creation. // NOTE: For Doram, this requires client 20151001 or newer. start_point: iz_int,18,26:iz_int01,18,26:iz_int02,18,26:iz_int03,18,26:iz_int04,18,26 start_point_pre: new_1-1,53,111:new_2-1,53,111:new_3-1,53,111:new_4-1,53,111:new_5-1,53,111 start_point_doram: lasa_fild01,48,297 // Starting items for new characters // Max number of items is MAX_STARTITEM in char.cpp (default 32) // Format: <id>,<amount>,<position>{:<id>,<amount>,<position>...} // To auto-equip an item, include the position where it will be equipped; otherwise, use zero. // NOTE: For Doram, this requires client 20151001 or newer. start_items: 1201,1,2:2301,1,16:23484,1,0 start_items_pre: 1201,1,2:2301,1,16 start_items_doram: 1681,1,2:2301,1,16 // Starting zeny for new characters start_zeny: 1000000 // Size for the fame-lists fame_list_alchemist: 10 fame_list_blacksmith: 10 fame_list_taekwon: 10 // Guild earned exp modifier. // Adjusts taxed exp before adding it to the guild's exp. For example, if set // to 200, the guild receives double the player's taxed exp. guild_exp_rate: 100 // Name used for unknown characters unknown_char_name: Unknown // To log the character server? log_char: yes // Minimum length for a character name. // Must be set to '4' unless your client uses the 'Remove 4/6 letter Character Name limit' diff patch. char_name_min_length: 4 // Allow or not identical name for characters but with a different case (upper/lower): // example: Test-test-TEST-TesT; Value: 0 not allowed (default), 1 allowed name_ignoring_case: no // Manage possible letters/symbol in the name of charater. Control character (0x00-0x1f) are never accepted. Possible values are: // NOTE: Applies to character, party and guild names. // 0: no restriction (default) // 1: only letters/symbols in 'char_name_letters' option. // 2: Letters/symbols in 'char_name_letters' option are forbidden. All others are possibles. char_name_option: 1 // Set the letters/symbols that you want use with the 'char_name_option' option. // Note: Don't add spaces unless you mean to add 'space' to the list. char_name_letters: abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890 // Restrict character deletion by BaseLevel // 0: no restriction (players can delete characters of any level) // -X: you can't delete chars with BaseLevel <= X // Y: you can't delete chars with BaseLevel >= Y // e.g. char_del_level: 80 (players can't delete characters with 80+ BaseLevel) char_del_level: 0 // Amount of time in seconds by which the character deletion is delayed. // Default: 86400 (24 hours) // NOTE: Requires client 2010-08-03aragexeRE or newer. char_del_delay: 86400 // Restrict character deletion by email address or birthdate. // This restricts players from changing the langtype and deleting characters. // Defaults based on client date. // 1: Email address // 2: Birthdate // 3: Email address or Birthdate // IMPORTANT! // - This config only works for clients that send 0x0068 or 0x01fb for delete request. // - Use langtype 1 for newer clients (2013+), to use 0x01fb. // - Clients that are not using 0x0068 or 0x01fb, only use birthdate (YYMMDD) as default. char_del_option: 3 // Restrict character deletion as long as he is still in a party or guild // 0: No restriction is applied // 1: Character cannot be deleted as long as he remains in a party // 2: Character cannot be deleted as long as he remains in a guild // 3: Character cannot be deleted as long as he remains in a party or guild(default) char_del_restriction: 3 // Restrict certain class from being created. (Only functional on 20151001aRagexe or later) // 0: No character creation is allowed // 1: Only novice is allowed to be created (pre-renewal default) // 2: Only summoner is allowed to be created // 3: Both novice and summoner can be created (renewal default) // Uncomment to customize the restriction //allowed_job_flag: 3 // Should parties that don't have any members be cleared from the party_db table at start up? clear_parties: no // Folder that contains the database files. db_path: db //=================================== // Pincode system //=================================== // NOTE: Requires client 2011-03-09aragexeRE or newer. // A window is opened before you can select your character and you will have to enter a pincode by using only your mouse. // Default: yes pincode_enabled: yes // How often does a user have to change his pincode? // 0: never (default) // X: every X days pincode_changetime: 0 // How often can a user enter the wrong pincode? // Default: 3 (client maximum) pincode_maxtry: 3 // Are users forced to use a pincode when the system is enabled? // Default: yes pincode_force: yes // Are repeated numbers allowed? // Default: no pincode_allow_repeated: no // Are sequential numbers allowed? // Default: no pincode_allow_sequential: no //=================================== // Addon system //=================================== // Character moving // NOTE: Requires client 2011-09-28aragexeRE or newer. // Allows users to move their characters between slots. // Default: yes char_move_enabled: yes // Allow users to move a character to a used slot? // If enabled the characters are exchanged. // Default: yes char_movetoused: yes // Allow users to move characters as often as they like? char_moves_unlimited: no // Character renaming // Allow users to rename a character while being in a party? // Default: no char_rename_party: no // Allow users to rename a character while being in a guild? // Default: no char_rename_guild: no // Should we check if sql-tables are correct on server startup ? char_checkdb: yes // Default map if character is in not-existing map when loaded. default_map: prontera default_map_x: 156 default_map_y: 191 // After how many days should inactive clan members be removed from their clan? // 0: never remove them // X: remove clan members if they did not log in for X days // Default: 14 clan_remove_inactive_days: 14 //=================================== // RODEX //=================================== // After how many days should mails be returned to their sender? // 0: never return them // X: return them after X days // Default: 15 mail_return_days: 15 // How many days after a mail was returned to it's sender should it be deleted completely? // 0: never delete them // X: delete them X days after they were returned // Default: 15 mail_delete_days: 15 // Does the Retrieve All button ignore unread mail status? // no: Only return attachments from read mail // yes: Return attachments from all mail // Default: yes mail_retrieve: yes // Should mails without any attachments be returned to their sender? // Default: yes mail_return_empty: yes import: conf/import/char_conf.txt this is my map_athena.conf //-------------------------------------------------------------- //rAthena Map-Server Configuration File //-------------------------------------------------------------- // Note: "Comments" are all text on the right side of a double slash "//" // Whatever text is commented will not be parsed by the servers, and serves // only as information/reference. //-------------------------------------------------------------- // Configuration Info //-------------------------------------------------------------- // Interserver communication passwords, set in account.txt (or equiv.) userid: myuser passwd: mypass // Character Server IP // The map server connects to the character server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. char_ip: 127.0.0.1 // The map server listens on the interface with this IP address. // NOTE: This allows you to run multiple servers on multiple interfaces // while using the same ports for each server. bind_ip: 127.0.0.1 // Character Server Port char_port: 6121 // Map Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. map_ip: my_public_ip // Map Server Port map_port: 5121 //Time-stamp format which will be printed before all messages. //Can at most be 20 characters long. //Common formats: // %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format) // %H:%M:%S (hour:minute:second, 24 hour format) // %d/%b/%Y (day/Month/year) //For full format information, consult the strftime() manual. //timestamp_format: [%d/%b %H:%M] //If redirected output contains escape sequences (color codes) stdout_with_ansisequence: no //Makes server log selected message types to a file in the /log/ folder //1: Log Warning Messages //2: Log Error and SQL Error messages. //4: Log Debug Messages //Example: "console_msg_log: 7" logs all 3 kinds //Messages logged by this overrides console_silent setting console_msg_log: 0 // File path to store the console messages above console_log_filepath: ./log/map-msg_log.log //Makes server output more silent by omitting certain types of messages: //1: Hide Information messages //2: Hide Status messages //4: Hide Notice Messages //8: Hide Warning Messages //16: Hide Error and SQL Error messages. //32: Hide Debug Messages //Example: "console_silent: 7" Hides information, status and notice messages (1+2+4) console_silent: 0 //Where should all database data be read from? db_path: db // Enable the @guildspy and @partyspy at commands? // Note that enabling them decreases packet sending performance. enable_spy: no // Read map data from GATs and RSWs in GRF files or a data directory // as referenced by grf-files.txt rather than from the mapcache? use_grf: no // Console Commands // Allow for console commands to be used on/off // This prevents usage of >& log.file console: off // Database autosave time // All characters are saved on this time in seconds (example: // autosave of 60 secs with 60 characters online -> one char is saved every // second) autosave_time: 300 // Min database save intervals (in ms) // Prevent saving characters faster than at this rate (prevents char-server // save-load getting too high as character-count increases) minsave_time: 100 // Apart from the autosave_time, players will also get saved when involved // in the following (add as needed): // 1: after every successful trade // 2: after opening vending/every vending transaction // 4: after closing storage/guild storage. // 8: After hatching/returning to egg a pet. // 16: After successfully sending a mail with attachment // 32: After successfully submitting an item for auction // 64: After successfully get/delete/complete a quest // 128: After every bank transaction (deposit/withdraw) // 256: After every attendance reward // 4095: Always // NOTE: These settings decrease the chance of dupes/lost items when there's a // server crash at the expense of increasing the map/char server lag. If your // server rarely crashes, but experiences interserver lag, you may want to set // these off. save_settings: 4095 // Message of the day file, when a character logs on, this message is displayed. motd_txt: conf/motd.txt // When @help or @h is typed when you are a gm, this is displayed for helping new gms understand gm commands. charhelp_txt: conf/charhelp.txt // Load channel config from channel_conf: conf/channels.conf // Maps: import: conf/maps_athena.conf import: conf/import/map_conf.txt and this is my main.sql -- -- Table structure for table `acc_reg_num` -- CREATE TABLE IF NOT EXISTS `acc_reg_num` ( `account_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` bigint(11) NOT NULL default '0', PRIMARY KEY (`account_id`,`key`,`index`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `acc_reg_str` -- CREATE TABLE IF NOT EXISTS `acc_reg_str` ( `account_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` varchar(254) NOT NULL default '0', PRIMARY KEY (`account_id`,`key`,`index`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `achievement` -- CREATE TABLE IF NOT EXISTS `achievement` ( `char_id` int(11) unsigned NOT NULL default '0', `id` bigint(11) unsigned NOT NULL, `count1` int unsigned NOT NULL default '0', `count2` int unsigned NOT NULL default '0', `count3` int unsigned NOT NULL default '0', `count4` int unsigned NOT NULL default '0', `count5` int unsigned NOT NULL default '0', `count6` int unsigned NOT NULL default '0', `count7` int unsigned NOT NULL default '0', `count8` int unsigned NOT NULL default '0', `count9` int unsigned NOT NULL default '0', `count10` int unsigned NOT NULL default '0', `completed` datetime, `rewarded` datetime, PRIMARY KEY (`char_id`,`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `auction` -- CREATE TABLE IF NOT EXISTS `auction` ( `auction_id` bigint(20) unsigned NOT NULL auto_increment, `seller_id` int(11) unsigned NOT NULL default '0', `seller_name` varchar(30) NOT NULL default '', `buyer_id` int(11) unsigned NOT NULL default '0', `buyer_name` varchar(30) NOT NULL default '', `price` int(11) unsigned NOT NULL default '0', `buynow` int(11) unsigned NOT NULL default '0', `hours` smallint(6) NOT NULL default '0', `timestamp` int(11) unsigned NOT NULL default '0', `nameid` int(10) unsigned NOT NULL default '0', `item_name` varchar(50) NOT NULL default '', `type` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`auction_id`) ) ENGINE=MyISAM; -- -- Table `barter` for barter shop persistency -- CREATE TABLE IF NOT EXISTS `barter` ( `name` varchar(50) NOT NULL DEFAULT '', `index` SMALLINT(5) UNSIGNED NOT NULL, `amount` SMALLINT(5) UNSIGNED NOT NULL, PRIMARY KEY (`name`,`index`) ) ENGINE=MyISAM; -- -- Table structure for `db_roulette` -- CREATE TABLE IF NOT EXISTS `db_roulette` ( `index` int(11) NOT NULL default '0', `level` smallint(5) unsigned NOT NULL, `item_id` int(10) unsigned NOT NULL, `amount` smallint(5) unsigned NOT NULL DEFAULT '1', `flag` smallint(5) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`index`) ) ENGINE=MyISAM; -- -- Table structure for table `bonus_script` -- CREATE TABLE IF NOT EXISTS `bonus_script` ( `char_id` INT(11) UNSIGNED NOT NULL, `script` TEXT NOT NULL, `tick` BIGINT(20) NOT NULL DEFAULT '0', `flag` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `icon` SMALLINT(3) NOT NULL DEFAULT '-1', KEY `char_id` (`char_id`) ) ENGINE=InnoDB; -- -- Table structure for table `buyingstore_items` -- CREATE TABLE IF NOT EXISTS `buyingstore_items` ( `buyingstore_id` int(10) unsigned NOT NULL, `index` smallint(5) unsigned NOT NULL, `item_id` int(10) unsigned NOT NULL, `amount` smallint(5) unsigned NOT NULL, `price` int(10) unsigned NOT NULL, PRIMARY KEY (`buyingstore_id`, `index`) ) ENGINE=MyISAM; -- -- Table structure for table `buyingstores` -- CREATE TABLE IF NOT EXISTS `buyingstores` ( `id` int(10) unsigned NOT NULL, `account_id` int(11) unsigned NOT NULL, `char_id` int(10) unsigned NOT NULL, `sex` enum('F','M') NOT NULL DEFAULT 'M', `map` varchar(20) NOT NULL, `x` smallint(5) unsigned NOT NULL, `y` smallint(5) unsigned NOT NULL, `title` varchar(80) NOT NULL, `limit` int(10) unsigned NOT NULL, `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4', `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0', `sit` CHAR( 1 ) NOT NULL DEFAULT '1', `autotrade` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- -- Table structure for table `cart_inventory` -- CREATE TABLE IF NOT EXISTS `cart_inventory` ( `id` int(11) NOT NULL auto_increment, `char_id` int(11) NOT NULL default '0', `nameid` int(10) unsigned NOT NULL default '0', `amount` int(11) NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) NOT NULL default '0', `card0` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `char` -- CREATE TABLE IF NOT EXISTS `char` ( `char_id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `char_num` tinyint(1) NOT NULL default '0', `name` varchar(30) NOT NULL DEFAULT '', `class` smallint(6) unsigned NOT NULL default '0', `base_level` smallint(6) unsigned NOT NULL default '1', `job_level` smallint(6) unsigned NOT NULL default '1', `base_exp` bigint(20) unsigned NOT NULL default '0', `job_exp` bigint(20) unsigned NOT NULL default '0', `zeny` int(11) unsigned NOT NULL default '0', `str` smallint(4) unsigned NOT NULL default '0', `agi` smallint(4) unsigned NOT NULL default '0', `vit` smallint(4) unsigned NOT NULL default '0', `int` smallint(4) unsigned NOT NULL default '0', `dex` smallint(4) unsigned NOT NULL default '0', `luk` smallint(4) unsigned NOT NULL default '0', `pow` smallint(4) unsigned NOT NULL default '0', `sta` smallint(4) unsigned NOT NULL default '0', `wis` smallint(4) unsigned NOT NULL default '0', `spl` smallint(4) unsigned NOT NULL default '0', `con` smallint(4) unsigned NOT NULL default '0', `crt` smallint(4) unsigned NOT NULL default '0', `max_hp` int(11) unsigned NOT NULL default '0', `hp` int(11) unsigned NOT NULL default '0', `max_sp` int(11) unsigned NOT NULL default '0', `sp` int(11) unsigned NOT NULL default '0', `max_ap` int(11) unsigned NOT NULL default '0', `ap` int(11) unsigned NOT NULL default '0', `status_point` int(11) unsigned NOT NULL default '0', `skill_point` int(11) unsigned NOT NULL default '0', `trait_point` int(11) unsigned NOT NULL default '0', `option` int(11) NOT NULL default '0', `karma` tinyint(3) NOT NULL default '0', `manner` smallint(6) NOT NULL default '0', `party_id` int(11) unsigned NOT NULL default '0', `guild_id` int(11) unsigned NOT NULL default '0', `pet_id` int(11) unsigned NOT NULL default '0', `homun_id` int(11) unsigned NOT NULL default '0', `elemental_id` int(11) unsigned NOT NULL default '0', `hair` tinyint(4) unsigned NOT NULL default '0', `hair_color` smallint(5) unsigned NOT NULL default '0', `clothes_color` smallint(5) unsigned NOT NULL default '0', `body` smallint(5) unsigned NOT NULL default '0', `weapon` smallint(6) unsigned NOT NULL default '0', `shield` smallint(6) unsigned NOT NULL default '0', `head_top` smallint(6) unsigned NOT NULL default '0', `head_mid` smallint(6) unsigned NOT NULL default '0', `head_bottom` smallint(6) unsigned NOT NULL default '0', `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', `last_map` varchar(11) NOT NULL default '', `last_x` smallint(4) unsigned NOT NULL default '53', `last_y` smallint(4) unsigned NOT NULL default '111', `last_instanceid` int(11) unsigned NOT NULL default '0', `save_map` varchar(11) NOT NULL default '', `save_x` smallint(4) unsigned NOT NULL default '53', `save_y` smallint(4) unsigned NOT NULL default '111', `partner_id` int(11) unsigned NOT NULL default '0', `online` tinyint(2) NOT NULL default '0', `father` int(11) unsigned NOT NULL default '0', `mother` int(11) unsigned NOT NULL default '0', `child` int(11) unsigned NOT NULL default '0', `fame` int(11) unsigned NOT NULL default '0', `rename` SMALLINT(3) unsigned NOT NULL default '0', `delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0', `moves` int(11) unsigned NOT NULL DEFAULT '0', `unban_time` int(11) unsigned NOT NULL default '0', `font` tinyint(3) unsigned NOT NULL default '0', `uniqueitem_counter` int(11) unsigned NOT NULL default '0', `sex` ENUM('M','F') NOT NULL, `hotkey_rowshift` tinyint(3) unsigned NOT NULL default '0', `hotkey_rowshift2` tinyint(3) unsigned NOT NULL default '0', `clan_id` int(11) unsigned NOT NULL default '0', `last_login` datetime DEFAULT NULL, `title_id` INT(11) unsigned NOT NULL default '0', `show_equip` tinyint(3) unsigned NOT NULL default '0', `inventory_slots` smallint(6) NOT NULL default '100', `body_direction` tinyint(1) unsigned NOT NULL default '0', `disable_call` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`char_id`), UNIQUE KEY `name_key` (`name`), KEY `account_id` (`account_id`), KEY `party_id` (`party_id`), KEY `guild_id` (`guild_id`), KEY `online` (`online`) ) ENGINE=MyISAM AUTO_INCREMENT=150000; -- -- Table structure for table `char_reg_num` -- CREATE TABLE IF NOT EXISTS `char_reg_num` ( `char_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` bigint(11) NOT NULL default '0', PRIMARY KEY (`char_id`,`key`,`index`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `char_reg_str` -- CREATE TABLE IF NOT EXISTS `char_reg_str` ( `char_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` varchar(254) NOT NULL default '0', PRIMARY KEY (`char_id`,`key`,`index`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `charlog` -- CREATE TABLE IF NOT EXISTS `charlog` ( `id` bigint(20) unsigned NOT NULL auto_increment, `time` datetime NOT NULL, `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', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `clan` -- CREATE TABLE IF NOT EXISTS `clan` ( `clan_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(24) NOT NULL DEFAULT '', `master` varchar(24) NOT NULL DEFAULT '', `mapname` varchar(24) NOT NULL DEFAULT '', `max_member` smallint(6) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`clan_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5; -- ---------------------------- -- Records of clan -- ---------------------------- INSERT INTO `clan` VALUES ('1', 'Swordman Clan', 'Raffam Oranpere', 'prontera', '500'); INSERT INTO `clan` VALUES ('2', 'Arcwand Clan', 'Devon Aire', 'geffen', '500'); INSERT INTO `clan` VALUES ('3', 'Golden Mace Clan', 'Berman Aire', 'prontera', '500'); INSERT INTO `clan` VALUES ('4', 'Crossbow Clan', 'Shaam Rumi', 'payon', '500'); -- -- Table structure for `clan_alliance` -- CREATE TABLE IF NOT EXISTS `clan_alliance` ( `clan_id` int(11) unsigned NOT NULL DEFAULT '0', `opposition` int(11) unsigned NOT NULL DEFAULT '0', `alliance_id` int(11) unsigned NOT NULL DEFAULT '0', `name` varchar(24) NOT NULL DEFAULT '', PRIMARY KEY (`clan_id`,`alliance_id`), KEY `alliance_id` (`alliance_id`) ) ENGINE=MyISAM; -- ---------------------------- -- Records of clan_alliance -- ---------------------------- INSERT INTO `clan_alliance` VALUES ('1', '0', '3', 'Golden Mace Clan'); INSERT INTO `clan_alliance` VALUES ('2', '0', '3', 'Golden Mace Clan'); INSERT INTO `clan_alliance` VALUES ('2', '1', '4', 'Crossbow Clan'); INSERT INTO `clan_alliance` VALUES ('3', '0', '1', 'Swordman Clan'); INSERT INTO `clan_alliance` VALUES ('3', '0', '2', 'Arcwand Clan'); INSERT INTO `clan_alliance` VALUES ('3', '0', '4', 'Crossbow Clan'); INSERT INTO `clan_alliance` VALUES ('4', '0', '3', 'Golden Mace Clan'); INSERT INTO `clan_alliance` VALUES ('4', '1', '2', 'Arcwand Clan'); -- -- Table structure for table `elemental` -- CREATE TABLE IF NOT EXISTS `elemental` ( `ele_id` int(11) unsigned NOT NULL auto_increment, `char_id` int(11) NOT NULL, `class` mediumint(9) unsigned NOT NULL default '0', `mode` int(11) unsigned NOT NULL default '1', `hp` int(11) unsigned NOT NULL default '0', `sp` int(11) unsigned NOT NULL default '0', `max_hp` int(11) unsigned NOT NULL default '0', `max_sp` int(11) unsigned NOT NULL default '0', `atk1` MEDIUMINT(6) unsigned NOT NULL default '0', `atk2` MEDIUMINT(6) unsigned NOT NULL default '0', `matk` MEDIUMINT(6) unsigned NOT NULL default '0', `aspd` smallint(4) unsigned NOT NULL default '0', `def` smallint(4) unsigned NOT NULL default '0', `mdef` smallint(4) unsigned NOT NULL default '0', `flee` smallint(4) unsigned NOT NULL default '0', `hit` smallint(4) unsigned NOT NULL default '0', `life_time` bigint(20) NOT NULL default '0', PRIMARY KEY (`ele_id`) ) ENGINE=MyISAM; -- -- Table structure for table `friends` -- CREATE TABLE IF NOT EXISTS `friends` ( `char_id` int(11) NOT NULL default '0', `friend_id` int(11) NOT NULL default '0', PRIMARY KEY (`char_id`, `friend_id`) ) ENGINE=MyISAM; -- -- Table structure for table `global_acc_reg_num` -- CREATE TABLE IF NOT EXISTS `global_acc_reg_num` ( `account_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` bigint(11) NOT NULL default '0', PRIMARY KEY (`account_id`,`key`,`index`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `global_acc_reg_str` -- CREATE TABLE IF NOT EXISTS `global_acc_reg_str` ( `account_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` varchar(254) NOT NULL default '0', PRIMARY KEY (`account_id`,`key`,`index`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild` -- CREATE TABLE IF NOT EXISTS `guild` ( `guild_id` int(11) unsigned NOT NULL auto_increment, `name` varchar(24) NOT NULL default '', `char_id` int(11) unsigned NOT NULL default '0', `master` varchar(24) NOT NULL default '', `guild_lv` tinyint(6) unsigned NOT NULL default '0', `connect_member` tinyint(6) unsigned NOT NULL default '0', `max_member` tinyint(6) unsigned NOT NULL default '0', `average_lv` smallint(6) unsigned NOT NULL default '1', `exp` bigint(20) unsigned NOT NULL default '0', `next_exp` bigint(20) unsigned NOT NULL default '0', `skill_point` tinyint(11) unsigned NOT NULL default '0', `mes1` varchar(60) NOT NULL default '', `mes2` varchar(120) NOT NULL default '', `emblem_len` int(11) unsigned NOT NULL default '0', `emblem_id` int(11) unsigned NOT NULL default '0', `emblem_data` blob, `last_master_change` datetime, PRIMARY KEY (`guild_id`,`char_id`), UNIQUE KEY `guild_id` (`guild_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_alliance` -- CREATE TABLE IF NOT EXISTS `guild_alliance` ( `guild_id` int(11) unsigned NOT NULL default '0', `opposition` int(11) unsigned NOT NULL default '0', `alliance_id` int(11) unsigned NOT NULL default '0', `name` varchar(24) NOT NULL default '', PRIMARY KEY (`guild_id`,`alliance_id`), KEY `alliance_id` (`alliance_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_castle` -- CREATE TABLE IF NOT EXISTS `guild_castle` ( `castle_id` int(11) unsigned NOT NULL default '0', `guild_id` int(11) unsigned NOT NULL default '0', `economy` int(11) unsigned NOT NULL default '0', `defense` int(11) unsigned NOT NULL default '0', `triggerE` int(11) unsigned NOT NULL default '0', `triggerD` int(11) unsigned NOT NULL default '0', `nextTime` int(11) unsigned NOT NULL default '0', `payTime` int(11) unsigned NOT NULL default '0', `createTime` int(11) unsigned NOT NULL default '0', `visibleC` int(11) unsigned NOT NULL default '0', `visibleG0` int(11) unsigned NOT NULL default '0', `visibleG1` int(11) unsigned NOT NULL default '0', `visibleG2` int(11) unsigned NOT NULL default '0', `visibleG3` int(11) unsigned NOT NULL default '0', `visibleG4` int(11) unsigned NOT NULL default '0', `visibleG5` int(11) unsigned NOT NULL default '0', `visibleG6` int(11) unsigned NOT NULL default '0', `visibleG7` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`castle_id`), KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_expulsion` -- CREATE TABLE IF NOT EXISTS `guild_expulsion` ( `guild_id` int(11) unsigned NOT NULL default '0', `account_id` int(11) unsigned NOT NULL default '0', `name` varchar(24) NOT NULL default '', `mes` varchar(40) NOT NULL default '', `char_id` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`guild_id`,`name`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_member` -- CREATE TABLE IF NOT EXISTS `guild_member` ( `guild_id` int(11) unsigned NOT NULL default '0', `char_id` int(11) unsigned NOT NULL default '0', `exp` bigint(20) unsigned NOT NULL default '0', `position` tinyint(6) unsigned NOT NULL default '0', PRIMARY KEY (`guild_id`,`char_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_position` -- CREATE TABLE IF NOT EXISTS `guild_position` ( `guild_id` int(9) unsigned NOT NULL default '0', `position` tinyint(6) unsigned NOT NULL default '0', `name` varchar(24) NOT NULL default '', `mode` smallint(11) unsigned NOT NULL default '0', `exp_mode` tinyint(11) unsigned NOT NULL default '0', PRIMARY KEY (`guild_id`,`position`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_skill` -- CREATE TABLE IF NOT EXISTS `guild_skill` ( `guild_id` int(11) unsigned NOT NULL default '0', `id` smallint(11) unsigned NOT NULL default '0', `lv` tinyint(11) unsigned NOT NULL default '0', PRIMARY KEY (`guild_id`,`id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_storage` -- CREATE TABLE IF NOT EXISTS `guild_storage` ( `id` int(10) unsigned NOT NULL auto_increment, `guild_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) unsigned NOT NULL default '0', `amount` int(11) unsigned NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) unsigned NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_storage_log` -- CREATE TABLE IF NOT EXISTS `guild_storage_log` ( `id` int(11) NOT NULL auto_increment, `guild_id` int(11) unsigned NOT NULL default '0', `time` datetime NOT NULL, `char_id` int(11) NOT NULL default '0', `name` varchar(24) NOT NULL default '', `nameid` int(10) unsigned NOT NULL default '0', `amount` int(11) NOT NULL default '1', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', `bound` tinyint(1) unsigned NOT NULL default '0', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), INDEX (`guild_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1; -- -- Table structure for table `homunculus` -- CREATE TABLE IF NOT EXISTS `homunculus` ( `homun_id` int(11) NOT NULL auto_increment, `char_id` int(11) NOT NULL, `class` mediumint(9) unsigned NOT NULL default '0', `prev_class` mediumint(9) NOT NULL default '0', `name` varchar(24) NOT NULL default '', `level` smallint(4) NOT NULL default '0', `exp` bigint(20) unsigned NOT NULL default '0', `intimacy` int(12) NOT NULL default '0', `hunger` smallint(4) NOT NULL default '0', `str` smallint(4) unsigned NOT NULL default '0', `agi` smallint(4) unsigned NOT NULL default '0', `vit` smallint(4) unsigned NOT NULL default '0', `int` smallint(4) unsigned NOT NULL default '0', `dex` smallint(4) unsigned NOT NULL default '0', `luk` smallint(4) unsigned NOT NULL default '0', `hp` int(11) unsigned NOT NULL default '0', `max_hp` int(11) unsigned NOT NULL default '0', `sp` int(11) NOT NULL default '0', `max_sp` int(11) NOT NULL default '0', `skill_point` smallint(4) unsigned NOT NULL default '0', `alive` tinyint(2) NOT NULL default '1', `rename_flag` tinyint(2) NOT NULL default '0', `vaporize` tinyint(2) NOT NULL default '0', `autofeed` tinyint(2) NOT NULL default '0', PRIMARY KEY (`homun_id`) ) ENGINE=MyISAM; -- -- Table structure for table `hotkey` -- CREATE TABLE IF NOT EXISTS `hotkey` ( `char_id` INT(11) NOT NULL, `hotkey` TINYINT(2) unsigned NOT NULL, `type` TINYINT(1) unsigned NOT NULL default '0', `itemskill_id` INT(11) unsigned NOT NULL default '0', `skill_lvl` TINYINT(4) unsigned NOT NULL default '0', PRIMARY KEY (`char_id`,`hotkey`) ) ENGINE=MyISAM; -- -- Table structure for table `interlog` -- CREATE TABLE IF NOT EXISTS `interlog` ( `id` INT NOT NULL AUTO_INCREMENT, `time` datetime NOT NULL, `log` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), INDEX `time` (`time`) ) ENGINE=MyISAM; -- -- Table structure for table `inventory` -- CREATE TABLE IF NOT EXISTS `inventory` ( `id` int(11) unsigned NOT NULL auto_increment, `char_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) unsigned NOT NULL default '0', `amount` int(11) unsigned NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `favorite` tinyint(3) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', `equip_switch` int(11) unsigned NOT NULL default '0', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `ipbanlist` -- CREATE TABLE IF NOT EXISTS `ipbanlist` ( `list` varchar(15) NOT NULL default '', `btime` datetime NOT NULL, `rtime` datetime NOT NULL, `reason` varchar(255) NOT NULL default '', PRIMARY KEY (`list`, `btime`) ) ENGINE=MyISAM; -- -- Table structure for table `login` -- CREATE TABLE IF NOT EXISTS `login` ( `account_id` int(11) unsigned NOT NULL auto_increment, `userid` varchar(23) NOT NULL default '', `user_pass` varchar(32) NOT NULL default '', `sex` enum('M','F','S') NOT NULL default 'M', `email` varchar(39) NOT NULL default '', `group_id` tinyint(3) NOT NULL default '0', `state` int(11) unsigned NOT NULL default '0', `unban_time` int(11) unsigned NOT NULL default '0', `expiration_time` int(11) unsigned NOT NULL default '0', `logincount` mediumint(9) unsigned NOT NULL default '0', `lastlogin` datetime, `last_ip` varchar(100) NOT NULL default '', `birthdate` DATE, `character_slots` tinyint(3) unsigned NOT NULL default '0', `pincode` varchar(4) NOT NULL DEFAULT '', `pincode_change` int(11) unsigned NOT NULL DEFAULT '0', `vip_time` int(11) unsigned NOT NULL default '0', `old_group` tinyint(3) NOT NULL default '0', `web_auth_token` varchar(17) null, `web_auth_token_enabled` tinyint(2) NOT NULL default '0', PRIMARY KEY (`account_id`), KEY `name` (`userid`), UNIQUE KEY `web_auth_token_key` (`web_auth_token`) ) ENGINE=MyISAM AUTO_INCREMENT=2000000; -- added standard accounts for servers, VERY INSECURE!!! -- inserted into the table called login which is above INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('2000000', 'ragnarok', 'ragnarok', 'M','[email protected]'); -- -- Table structure for table `mail` -- CREATE TABLE IF NOT EXISTS `mail` ( `id` bigint(20) unsigned NOT NULL auto_increment, `send_name` varchar(30) NOT NULL default '', `send_id` int(11) unsigned NOT NULL default '0', `dest_name` varchar(30) NOT NULL default '', `dest_id` int(11) unsigned NOT NULL default '0', `title` varchar(45) NOT NULL default '', `message` varchar(500) NOT NULL default '', `time` int(11) unsigned NOT NULL default '0', `status` tinyint(2) NOT NULL default '0', `zeny` int(11) unsigned NOT NULL default '0', `type` smallint(5) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- ---------------------------- -- Table structure for `mail_attachments` -- ---------------------------- CREATE TABLE IF NOT EXISTS `mail_attachments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `index` smallint(5) unsigned NOT NULL DEFAULT '0', `nameid` int(10) unsigned NOT NULL DEFAULT '0', `amount` int(11) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) NOT NULL DEFAULT '0', `card0` int(10) unsigned NOT NULL DEFAULT '0', `card1` int(10) unsigned NOT NULL DEFAULT '0', `card2` int(10) unsigned NOT NULL DEFAULT '0', `card3` int(10) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', `bound` tinyint(1) unsigned NOT NULL DEFAULT '0', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`,`index`) ) ENGINE=MyISAM; -- -- Table structure for table `mapreg` -- CREATE TABLE IF NOT EXISTS `mapreg` ( `varname` varchar(32) binary NOT NULL, `index` int(11) unsigned NOT NULL default '0', `value` varchar(255) NOT NULL, PRIMARY KEY (`varname`,`index`) ) ENGINE=MyISAM; -- -- Table `market` for market shop persistency -- CREATE TABLE IF NOT EXISTS `market` ( `name` varchar(50) NOT NULL DEFAULT '', `nameid` int(10) UNSIGNED NOT NULL, `price` INT(11) UNSIGNED NOT NULL, `amount` INT(11) NOT NULL, `flag` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`name`,`nameid`) ) ENGINE = MyISAM; -- -- Table structure for table `memo` -- CREATE TABLE IF NOT EXISTS `memo` ( `memo_id` int(11) unsigned NOT NULL auto_increment, `char_id` int(11) unsigned NOT NULL default '0', `map` varchar(11) NOT NULL default '', `x` smallint(4) unsigned NOT NULL default '0', `y` smallint(4) unsigned NOT NULL default '0', PRIMARY KEY (`memo_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `mercenary` -- CREATE TABLE IF NOT EXISTS `mercenary` ( `mer_id` int(11) unsigned NOT NULL auto_increment, `char_id` int(11) NOT NULL, `class` mediumint(9) unsigned NOT NULL default '0', `hp` int(11) unsigned NOT NULL default '0', `sp` int(11) unsigned NOT NULL default '0', `kill_counter` int(11) NOT NULL, `life_time` bigint(20) NOT NULL default '0', PRIMARY KEY (`mer_id`) ) ENGINE=MyISAM; -- -- Table structure for table `mercenary_owner` -- CREATE TABLE IF NOT EXISTS `mercenary_owner` ( `char_id` int(11) NOT NULL, `merc_id` int(11) NOT NULL default '0', `arch_calls` int(11) NOT NULL default '0', `arch_faith` int(11) NOT NULL default '0', `spear_calls` int(11) NOT NULL default '0', `spear_faith` int(11) NOT NULL default '0', `sword_calls` int(11) NOT NULL default '0', `sword_faith` int(11) NOT NULL default '0', PRIMARY KEY (`char_id`) ) ENGINE=MyISAM; -- ---------------------------- -- Table structure for `sales` -- ---------------------------- CREATE TABLE IF NOT EXISTS `sales` ( `nameid` int(10) unsigned NOT NULL, `start` datetime NOT NULL, `end` datetime NOT NULL, `amount` int(11) NOT NULL, PRIMARY KEY (`nameid`) ) ENGINE=MyISAM; -- -- Table structure for table `sc_data` -- CREATE TABLE IF NOT EXISTS `sc_data` ( `account_id` int(11) unsigned NOT NULL, `char_id` int(11) unsigned NOT NULL, `type` smallint(11) unsigned NOT NULL, `tick` bigint(20) NOT NULL, `val1` int(11) NOT NULL default '0', `val2` int(11) NOT NULL default '0', `val3` int(11) NOT NULL default '0', `val4` int(11) NOT NULL default '0', PRIMARY KEY (`char_id`, `type`) ) ENGINE=MyISAM; -- -- Table structure for table `skillcooldown` -- CREATE TABLE IF NOT EXISTS `skillcooldown` ( `account_id` int(11) unsigned NOT NULL, `char_id` int(11) unsigned NOT NULL, `skill` smallint(11) unsigned NOT NULL DEFAULT '0', `tick` bigint(20) NOT NULL, PRIMARY KEY (`char_id`, `skill`) ) ENGINE=MyISAM; -- -- Table structure for table `party` -- CREATE TABLE IF NOT EXISTS `party` ( `party_id` int(11) unsigned NOT NULL auto_increment, `name` varchar(24) NOT NULL default '', `exp` tinyint(11) unsigned NOT NULL default '0', `item` tinyint(11) unsigned NOT NULL default '0', `leader_id` int(11) unsigned NOT NULL default '0', `leader_char` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`party_id`) ) ENGINE=MyISAM; -- -- Table structure for table `party_bookings` -- CREATE TABLE IF NOT EXISTS `party_bookings` ( `world_name` varchar(32) NOT NULL, `account_id` int(11) unsigned NOT NULL, `char_id` int(11) unsigned NOT NULL, `char_name` varchar(23) NOT NULL, `purpose` smallint(5) unsigned NOT NULL DEFAULT '0', `assist` tinyint(3) unsigned NOT NULL DEFAULT '0', `damagedealer` tinyint(3) unsigned NOT NULL DEFAULT '0', `healer` tinyint(3) unsigned NOT NULL DEFAULT '0', `tanker` tinyint(3) unsigned NOT NULL DEFAULT '0', `minimum_level` smallint(5) unsigned NOT NULL, `maximum_level` smallint(5) unsigned NOT NULL, `comment` varchar(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`world_name`, `account_id`, `char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `pet` -- CREATE TABLE IF NOT EXISTS `pet` ( `pet_id` int(11) unsigned NOT NULL auto_increment, `class` mediumint(9) unsigned NOT NULL default '0', `name` varchar(24) NOT NULL default '', `account_id` int(11) unsigned NOT NULL default '0', `char_id` int(11) unsigned NOT NULL default '0', `level` smallint(4) unsigned NOT NULL default '0', `egg_id` int(10) unsigned NOT NULL default '0', `equip` int(10) unsigned NOT NULL default '0', `intimate` smallint(9) unsigned NOT NULL default '0', `hungry` smallint(9) unsigned NOT NULL default '0', `rename_flag` tinyint(4) unsigned NOT NULL default '0', `incubate` int(11) unsigned NOT NULL default '0', `autofeed` tinyint(2) NOT NULL default '0', PRIMARY KEY (`pet_id`) ) ENGINE=MyISAM; -- -- Table structure for table `quest` -- CREATE TABLE IF NOT EXISTS `quest` ( `char_id` int(11) unsigned NOT NULL default '0', `quest_id` int(10) unsigned NOT NULL, `state` enum('0','1','2') NOT NULL default '0', `time` int(11) unsigned NOT NULL default '0', `count1` mediumint(8) unsigned NOT NULL default '0', `count2` mediumint(8) unsigned NOT NULL default '0', `count3` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`char_id`,`quest_id`) ) ENGINE=MyISAM; -- -- Table structure for table `skill` -- CREATE TABLE IF NOT EXISTS `skill` ( `char_id` int(11) unsigned NOT NULL default '0', `id` smallint(11) unsigned NOT NULL default '0', `lv` tinyint(4) unsigned NOT NULL default '0', `flag` TINYINT(1) UNSIGNED NOT NULL default 0, PRIMARY KEY (`char_id`,`id`) ) ENGINE=MyISAM; -- -- Table structure for table `skill_homunculus` -- CREATE TABLE IF NOT EXISTS `skill_homunculus` ( `homun_id` int(11) NOT NULL, `id` int(11) NOT NULL, `lv` smallint(6) NOT NULL, PRIMARY KEY (`homun_id`,`id`) ) ENGINE=MyISAM; -- -- Table structure for table `storage` -- CREATE TABLE IF NOT EXISTS `storage` ( `id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `nameid` int(10) unsigned NOT NULL default '0', `amount` smallint(11) unsigned NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) unsigned NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` int(10) unsigned NOT NULL default '0', `card1` int(10) unsigned NOT NULL default '0', `card2` int(10) unsigned NOT NULL default '0', `card3` int(10) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', `enchantgrade` tinyint unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `vending_items` -- CREATE TABLE IF NOT EXISTS `vending_items` ( `vending_id` int(10) unsigned NOT NULL, `index` smallint(5) unsigned NOT NULL, `cartinventory_id` int(10) unsigned NOT NULL, `amount` smallint(5) unsigned NOT NULL, `price` int(10) unsigned NOT NULL, PRIMARY KEY (`vending_id`, `index`) ) ENGINE=MyISAM; -- -- Table structure for table `vendings` -- CREATE TABLE IF NOT EXISTS `vendings` ( `id` int(10) unsigned NOT NULL, `account_id` int(11) unsigned NOT NULL, `char_id` int(10) unsigned NOT NULL, `sex` enum('F','M') NOT NULL DEFAULT 'M', `map` varchar(20) NOT NULL, `x` smallint(5) unsigned NOT NULL, `y` smallint(5) unsigned NOT NULL, `title` varchar(80) NOT NULL, `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4', `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0', `sit` CHAR( 1 ) NOT NULL DEFAULT '1', `autotrade` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM;

can you share your error here?

So, i cant turn this grf to gray?. okay, thank you Tokei.

i have problem here, only 1 map is error like in pict. And when finished, maps.grf output size is 1kb. any suggest? im using grf editor 1.8.2.4