chatterboy

Go to your RO folder delete folder name SaveData then run the SETUP.EXE and set your VGA settings... ^^, At your Service GM 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

Why 2012-04-10 always close if wrong password and cant delete character if i want to delete?

the 2.4 version not good error on patching

naka lagay naman sya. d kaya d pede sa mysql 5.5.2.4 ? 3ceam nga pede e... nakuh bug yata ene!