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`intunsigned NOT NULL default'0',`count2`intunsigned NOT NULL default'0',`count3`intunsigned NOT NULL default'0',`count4`intunsigned NOT NULL default'0',`count5`intunsigned NOT NULL default'0',`count6`intunsigned NOT NULL default'0',`count7`intunsigned NOT NULL default'0',`count8`intunsigned NOT NULL default'0',`count9`intunsigned NOT NULL default'0',`count10`intunsigned 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;--------------------------------Recordsof 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;--------------------------------Recordsof 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 default0,
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;
Question
redv1per
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
this is my map_athena.conf
and this is my main.sql
Edited by redv1perLink to comment
Share on other sites
13 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.