Jump to content
The forums will be going offline for an extended maintenance period at 1400hrs GMT on 19th June 2025. The number of hours for this downtime is intentionally not advertised due to the nature of these upgrades. ×
  • 0

2 Server n' 1 Login Guide

chatterboy

Asked by chatterboy,

 Share

Question

chatterboy Santa Poring

chatterboy

Posted
  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  309
  • Reputation:   27
  • Joined:  11/26/12
  • Last Seen:  
Posted (edited)

[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 by chatterboy
Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Erba Poring

Erba

Posted
  • Group:  Members
  • Topic Count:  84
  • Topics Per Day:  0.02
  • Content Count:  550
  • Reputation:   9
  • Joined:  11/06/12
  • Last Seen:  
Posted

can you explain to me what this do specifically?

Link to comment
Share on other sites
chatterboy Santa Poring

chatterboy

Posted
  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  309
  • Reputation:   27
  • Joined:  11/26/12
  • Last Seen:  
  • Author
Posted

you can run 2 server application in 1 PC.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing
×
×
  • Create New...