2 Server n' 1 Login Guide

[chatterboy]

[step1]

- Download Server files --> https://rathena.svn..../rathena/trunk/

[step2]

- Download a WAMP Webserver (Hope you know how to use this application. If you dont use MySQL ^^,)

[step3]

- Now make a two folder of rAthena Server files. [Note:Those 2 folder has a same files inside.]

- On server1 leave all setting on default setup.

[step4]

- Open the main.sql on Server2 folder [\rAthena\sql-files]

replace you main.sql script this:

--
-- Table structure for table `auction`
--

CREATE TABLE IF NOT EXISTS `auction2` (
 `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(11) 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` smallint(11) NOT NULL default '0',
 `card1` smallint(11) NOT NULL default '0',
 `card2` smallint(11) NOT NULL default '0',
 `card3` smallint(11) NOT NULL default '0',
 `unique_id` bigint(20) unsigned NOT NULL default '0',
 PRIMARY KEY  (`auction_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `cart_inventory`
--

CREATE TABLE IF NOT EXISTS `cart_inventory2` (
 `id` int(11) NOT NULL auto_increment,
 `char_id` int(11) NOT NULL default '0',
 `nameid` int(11) NOT NULL default '0',
 `amount` int(11) NOT NULL default '0',
 `equip` mediumint(8) 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` smallint(11) NOT NULL default '0',
 `card1` smallint(11) NOT NULL default '0',
 `card2` smallint(11) NOT NULL default '0',
 `card3` smallint(11) NOT NULL default '0',
 `expire_time` int(11) unsigned NOT NULL default '0',
 `unique_id` bigint(20) 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 `char2` (
 `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',
 `max_hp` mediumint(8) unsigned NOT NULL default '0',
 `hp` mediumint(8) unsigned NOT NULL default '0',
 `max_sp` mediumint(6) unsigned NOT NULL default '0',
 `sp` mediumint(6) unsigned NOT NULL default '0',
 `status_point` int(11) unsigned NOT NULL default '0',
 `skill_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',
 `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',
 `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',
 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 `name` (`name`),
 KEY `online` (`online`)
) ENGINE=MyISAM AUTO_INCREMENT=150000;

--
-- Table structure for table `charlog`
--

CREATE TABLE IF NOT EXISTS `charlog2` (
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `char_msg` varchar(255) NOT NULL default 'char select',
 `account_id` int(11) NOT NULL default '0',
 `char_num` tinyint(4) NOT NULL default '0',
 `name` varchar(23) NOT NULL default '',
 `str` int(11) unsigned NOT NULL default '0',
 `agi` int(11) unsigned NOT NULL default '0',
 `vit` int(11) unsigned NOT NULL default '0',
 `int` int(11) unsigned NOT NULL default '0',
 `dex` int(11) unsigned NOT NULL default '0',
 `luk` int(11) unsigned NOT NULL default '0',
 `hair` tinyint(4) NOT NULL default '0',
 `hair_color` int(11) NOT NULL default '0'
) ENGINE=MyISAM;

--
-- Table structure for table `elemental`
--

CREATE TABLE IF NOT EXISTS `elemental2` (
 `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(12) NOT NULL default '1',
 `sp` int(12) NOT NULL default '1',
 `max_hp` mediumint(8) unsigned NOT NULL default '0',
 `max_sp` mediumint(6) 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` int(11) NOT NULL default '0',
 PRIMARY KEY  (`ele_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `friends`
--

CREATE TABLE IF NOT EXISTS `friends2` (
 `char_id` int(11) NOT NULL default '0',
 `friend_account` int(11) NOT NULL default '0',
 `friend_id` int(11) NOT NULL default '0',
 KEY  `char_id` (`char_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `hotkey`
--

CREATE TABLE IF NOT EXISTS `hotkey2` (
`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`),
INDEX (`char_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `global_reg_value`
--

CREATE TABLE IF NOT EXISTS `global_reg_value2` (
 `char_id` int(11) unsigned NOT NULL default '0',
 `str` varchar(255) NOT NULL default '',
 `value` varchar(255) NOT NULL default '0',
 `type` tinyint(1) NOT NULL default '3',
 `account_id` int(11) unsigned NOT NULL default '0',
 PRIMARY KEY  (`char_id`,`str`,`account_id`),
 KEY `account_id` (`account_id`),
 KEY `char_id` (`char_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `guild`
--

CREATE TABLE IF NOT EXISTS `guild2` (
 `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` int(11) 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,
 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_alliance2` (
 `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_castle2` (
 `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_expulsion2` (
 `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 '',
 PRIMARY KEY  (`guild_id`,`name`)
) ENGINE=MyISAM;

--
-- Table structure for table `guild_member`
--

CREATE TABLE IF NOT EXISTS `guild_member2` (
 `guild_id` int(11) unsigned NOT NULL default '0',
 `account_id` int(11) unsigned NOT NULL default '0',
 `char_id` int(11) unsigned NOT NULL default '0',
 `hair` tinyint(6) unsigned NOT NULL default '0',
 `hair_color` smallint(6) unsigned NOT NULL default '0',
 `gender` tinyint(6) unsigned NOT NULL default '0',
 `class` smallint(6) unsigned NOT NULL default '0',
 `lv` smallint(6) unsigned NOT NULL default '0',
 `exp` bigint(20) unsigned NOT NULL default '0',
 `exp_payper` tinyint(11) unsigned NOT NULL default '0',
 `online` tinyint(4) unsigned NOT NULL default '0',
 `position` tinyint(6) unsigned NOT NULL default '0',
 `name` varchar(24) NOT NULL default '',
 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_position2` (
 `guild_id` int(9) unsigned NOT NULL default '0',
 `position` tinyint(6) unsigned NOT NULL default '0',
 `name` varchar(24) NOT NULL default '',
 `mode` tinyint(11) unsigned NOT NULL default '0',
 `exp_mode` tinyint(11) unsigned NOT NULL default '0',
 PRIMARY KEY  (`guild_id`,`position`),
 KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `guild_skill`
--

CREATE TABLE IF NOT EXISTS `guild_skill2` (
 `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_storage2` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `guild_id` int(11) unsigned NOT NULL default '0',
 `nameid` int(11) unsigned NOT NULL default '0',
 `amount` int(11) unsigned NOT NULL default '0',
 `equip` mediumint(8) 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` smallint(11) NOT NULL default '0',
 `card1` smallint(11) NOT NULL default '0',
 `card2` smallint(11) NOT NULL default '0',
 `card3` smallint(11) NOT NULL default '0',
 `expire_time` int(11) unsigned NOT NULL default '0',
 `unique_id` bigint(20) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `homunculus`
--

CREATE TABLE IF NOT EXISTS `homunculus2` (
 `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` int(12) 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(12) NOT NULL default '1',
 `max_hp` int(12) NOT NULL default '1',
 `sp` int(12) NOT NULL default '1',
 `max_sp` int(12) NOT NULL default '1',
 `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',
 PRIMARY KEY  (`homun_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `interlog`
--

CREATE TABLE IF NOT EXISTS `interlog2` (
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `log` varchar(255) NOT NULL default ''
) ENGINE=MyISAM;

--
-- Table structure for table `inventory`
--

CREATE TABLE IF NOT EXISTS `inventory2` (
 `id` int(11) unsigned NOT NULL auto_increment,
 `char_id` int(11) unsigned NOT NULL default '0',
 `nameid` int(11) unsigned NOT NULL default '0',
 `amount` int(11) unsigned NOT NULL default '0',
 `equip` mediumint(8) 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` smallint(11) NOT NULL default '0',
 `card1` smallint(11) NOT NULL default '0',
 `card2` smallint(11) NOT NULL default '0',
 `card3` smallint(11) NOT NULL default '0',
 `expire_time` int(11) unsigned NOT NULL default '0',
 `favorite` tinyint(3) unsigned NOT NULL default '0',
 `unique_id` bigint(20) 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 `ipbanlist2` (
 `list` varchar(255) NOT NULL default '',
 `btime` datetime NOT NULL default '0000-00-00 00:00:00',
 `rtime` datetime NOT NULL default '0000-00-00 00:00:00',
 `reason` varchar(255) NOT NULL default '',
 KEY (`list`)
) 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 NOT NULL default '0000-00-00 00:00:00',
 `last_ip` varchar(100) NOT NULL default '',
 `birthdate` DATE NOT NULL DEFAULT '0000-00-00',
 PRIMARY KEY  (`account_id`),
 KEY `name` (`userid`)
) 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 ('2', 's2', 'p2', 'S','[email protected]');

--
-- Table structure for table `mapreg`
--

CREATE TABLE IF NOT EXISTS `mapreg2` (
 `varname` varchar(32) NOT NULL,
 `index` int(11) unsigned NOT NULL default '0',
 `value` varchar(255) NOT NULL,
 KEY `varname` (`varname`),
 KEY `index` (`index`)
) ENGINE=MyISAM;

--
-- Table structure for table `sc_data`
--

CREATE TABLE IF NOT EXISTS `sc_data2` (
 `account_id` int(11) unsigned NOT NULL,
 `char_id` int(11) unsigned NOT NULL,
 `type` smallint(11) unsigned NOT NULL,
 `tick` int(11) 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',
 KEY (`account_id`),
 KEY (`char_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `mail`
--

CREATE TABLE IF NOT EXISTS `mail2` (
 `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(255) 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',
 `nameid` int(11) 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` smallint(11) NOT NULL default '0',
 `card1` smallint(11) NOT NULL default '0',
 `card2` smallint(11) NOT NULL default '0',
 `card3` smallint(11) NOT NULL default '0',
 `unique_id` bigint(20) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

--
-- Table structure for table `memo`
--

CREATE TABLE IF NOT EXISTS `memo2` (
 `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 `mercenary2` (
 `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(12) NOT NULL default '1',
 `sp` int(12) NOT NULL default '1',
 `kill_counter` int(11) NOT NULL,
 `life_time` int(11) NOT NULL default '0',
 PRIMARY KEY  (`mer_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `mercenary_owner`
--

CREATE TABLE IF NOT EXISTS `mercenary_owner2` (
 `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 table `party`
--

CREATE TABLE IF NOT EXISTS `party2` (
 `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 `pet`
--

CREATE TABLE IF NOT EXISTS `pet2` (
 `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` smallint(11) unsigned NOT NULL default '0',
 `equip` mediumint(8) 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',
 `incuvate` int(11) unsigned NOT NULL default '0',
 PRIMARY KEY  (`pet_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `quest`
--

CREATE TABLE IF NOT EXISTS `quest2` (
 `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 `ragsrvinfo`
--

CREATE TABLE IF NOT EXISTS `ragsrvinfo2` (
 `index` int(11) NOT NULL default '0',
 `name` varchar(255) NOT NULL default '',
 `exp` int(11) unsigned NOT NULL default '0',
 `jexp` int(11) unsigned NOT NULL default '0',
 `drop` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM;

--
-- Table structure for table `skill`
--

CREATE TABLE IF NOT EXISTS `skill2` (
 `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',
 PRIMARY KEY  (`char_id`,`id`),
 KEY `char_id` (`char_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `skill_homunculus`
--

CREATE TABLE IF NOT EXISTS `skill_homunculus2` (
 `homun_id` int(11) NOT NULL,
 `id` int(11) NOT NULL,
 `lv` smallint(6) NOT NULL,
 PRIMARY KEY  (`homun_id`,`id`),
 KEY `homun_id` (`homun_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `sstatus`
--

CREATE TABLE IF NOT EXISTS `sstatus2` (
 `index` tinyint(4) unsigned NOT NULL default '0',
 `name` varchar(255) NOT NULL default '',
 `user` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM;

--
-- Table structure for table `storage`
--

CREATE TABLE IF NOT EXISTS `storage2` (
 `id` int(11) unsigned NOT NULL auto_increment,
 `account_id` int(11) unsigned NOT NULL default '0',
 `nameid` int(11) unsigned NOT NULL default '0',
 `amount` smallint(11) unsigned NOT NULL default '0',
 `equip` mediumint(8) 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` smallint(11) NOT NULL default '0',
 `card1` smallint(11) NOT NULL default '0',
 `card2` smallint(11) NOT NULL default '0',
 `card3` smallint(11) NOT NULL default '0',
 `expire_time` int(11) unsigned NOT NULL default '0',
 `unique_id` bigint(20) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `interreg2` (
 `varname` varchar(11) NOT NULL,
 `value` varchar(20) NOT NULL,
  PRIMARY KEY (`varname`)
) ENGINE=InnoDB;
INSERT INTO `interreg2` (`varname`, `value`) VALUES
('unique_id', '0');

[step5]

- On server2 open the CONF folder and open the char_athena.conf

* Change the server name [Any name u want]

* Change the char_port: 6121 to 6122

[step6]

- Open the map_athena.conf

* Change the char_port: 6121 to 6122

* Change the map_port: 5121 to 5122

[step7]

- Open the inter_athena.conf

*change all listed below:

// ALL MySQL Database Table names

// Char Database Tables
char_db: char2
hotkey_db: hotkey2
scdata_db: sc_data2
cart_db: cart_inventory2
inventory_db: inventory2
charlog_db: charlog2
storage_db: storage2
reg_db: global_reg_value2
skill_db: skill2
interlog_db: interlog2
memo_db: memo2
guild_db: guild2
guild_alliance_db: guild_alliance2
guild_castle_db: guild_castle2
guild_expulsion_db: guild_expulsion2
guild_member_db: guild_member2
guild_skill_db: guild_skill2
guild_position_db: guild_position2
guild_storage_db: guild_storage2
party_db: party2
pet_db: pet2
friend_db: friends2
mail_db: mail2
auction_db: auction2
quest_db: quest2
homunculus_db: homunculus2
skill_homunculus_db: skill_homunculus2
mercenary_db: mercenary2
mercenary_owner_db: mercenary_owner2
ragsrvinfo_db: ragsrvinfo2

[DONE!]

If any error or miss config please let me know to update this guide. And this guide is summarized from the start.

i never find like this guide that i made to other sites. Hope this will help you all...

At your Service

GM Chatterboy

Edited February 7, 2013 by chatterboy

[Erba]

can you explain to me what this do specifically?

[chatterboy]

you can run 2 server application in 1 PC.