Интересный вопрос всем.
4 ответов136 просмотровСейчас просматривают: 1
· 01.06.2009, 15:14
У меня вопрос.
Допустим у меня сейчас сервер с 50+ онлаине. Я хочу перийти с L2Pheonix допустим на L2Emu-RT. Но через "Export Wizard" или "Dump SQL file" не получится скинуть чарав с L2Pheonix на L2Emu-RT.
SQL L2Emu-RT
Код
CREATE TABLE IF NOT EXISTS `characters` (
`account_name` VARCHAR(45) DEFAULT NULL,
`charId` INT UNSIGNED NOT NULL DEFAULT 0,
`char_name` VARCHAR(35) NOT NULL,
`level` TINYINT UNSIGNED DEFAULT NULL,
`maxHp` MEDIUMINT UNSIGNED DEFAULT NULL,
`curHp` MEDIUMINT UNSIGNED DEFAULT NULL,
`maxCp` MEDIUMINT UNSIGNED DEFAULT NULL,
`curCp` MEDIUMINT UNSIGNED DEFAULT NULL,
`maxMp` MEDIUMINT UNSIGNED DEFAULT NULL,
`curMp` MEDIUMINT UNSIGNED DEFAULT NULL,
`face` TINYINT UNSIGNED DEFAULT NULL,
`hairStyle` TINYINT UNSIGNED DEFAULT NULL,
`hairColor` TINYINT UNSIGNED DEFAULT NULL,
`sex` TINYINT UNSIGNED DEFAULT NULL,
`heading` MEDIUMINT DEFAULT NULL,
`x` MEDIUMINT DEFAULT NULL,
`y` MEDIUMINT DEFAULT NULL,
`z` MEDIUMINT DEFAULT NULL,
`exp` BIGINT UNSIGNED DEFAULT 0,
`expBeforeDeath` BIGINT UNSIGNED DEFAULT 0,
`sp` INT UNSIGNED NOT NULL DEFAULT 0,
`karma` INT UNSIGNED DEFAULT NULL,
`fame` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
`pvpkills` SMALLINT UNSIGNED DEFAULT NULL,
`pkkills` SMALLINT UNSIGNED DEFAULT NULL,
`clanid` INT UNSIGNED DEFAULT NULL,
`race` TINYINT UNSIGNED DEFAULT NULL,
`classid` TINYINT UNSIGNED DEFAULT NULL,
`base_class` TINYINT UNSIGNED DEFAULT NULL,
`transform_id` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
`deletetime` BIGINT DEFAULT NULL,
`cancraft` TINYINT UNSIGNED DEFAULT NULL,
`title` VARCHAR(16) DEFAULT NULL,
`rec_have` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`rec_left` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`accesslevel` MEDIUMINT DEFAULT 0,
`online` TINYINT UNSIGNED DEFAULT NULL,
`onlinetime` INT DEFAULT NULL,
`char_slot` TINYINT UNSIGNED DEFAULT NULL,
`newbie` MEDIUMINT UNSIGNED DEFAULT 1,
`lastAccess` BIGINT UNSIGNED DEFAULT NULL,
`clan_privs` MEDIUMINT UNSIGNED DEFAULT 0,
`wantspeace` TINYINT UNSIGNED DEFAULT 0,
`isin7sdungeon` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`in_jail` TINYINT UNSIGNED DEFAULT 0,
`jail_timer` INT UNSIGNED DEFAULT 0,
`nobless` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`subpledge` SMALLINT NOT NULL DEFAULT 0,
`last_recom_date` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`pledge_rank` MEDIUMINT NOT NULL DEFAULT 0,
`lvl_joined_academy` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`apprentice` INT UNSIGNED NOT NULL DEFAULT 0,
`sponsor` INT UNSIGNED NOT NULL DEFAULT 0,
`varka_ketra_ally` TINYINT NOT NULL DEFAULT 0,
`clan_join_expiry_time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`clan_create_expiry_time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`charViP` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`death_penalty_level` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
`trust_level` INT UNSIGNED NOT NULL DEFAULT 0,
`vitality_points` DOUBLE(7,1) NOT NULL DEFAULT '0.0',
`enterHellbound` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`teleport_slots` INT NOT NULL DEFAULT '0',
PRIMARY KEY (`charId`),
KEY `clanid` (`clanid`)
) DEFAULT CHARSET=utf8;
`account_name` VARCHAR(45) DEFAULT NULL,
`charId` INT UNSIGNED NOT NULL DEFAULT 0,
`char_name` VARCHAR(35) NOT NULL,
`level` TINYINT UNSIGNED DEFAULT NULL,
`maxHp` MEDIUMINT UNSIGNED DEFAULT NULL,
`curHp` MEDIUMINT UNSIGNED DEFAULT NULL,
`maxCp` MEDIUMINT UNSIGNED DEFAULT NULL,
`curCp` MEDIUMINT UNSIGNED DEFAULT NULL,
`maxMp` MEDIUMINT UNSIGNED DEFAULT NULL,
`curMp` MEDIUMINT UNSIGNED DEFAULT NULL,
`face` TINYINT UNSIGNED DEFAULT NULL,
`hairStyle` TINYINT UNSIGNED DEFAULT NULL,
`hairColor` TINYINT UNSIGNED DEFAULT NULL,
`sex` TINYINT UNSIGNED DEFAULT NULL,
`heading` MEDIUMINT DEFAULT NULL,
`x` MEDIUMINT DEFAULT NULL,
`y` MEDIUMINT DEFAULT NULL,
`z` MEDIUMINT DEFAULT NULL,
`exp` BIGINT UNSIGNED DEFAULT 0,
`expBeforeDeath` BIGINT UNSIGNED DEFAULT 0,
`sp` INT UNSIGNED NOT NULL DEFAULT 0,
`karma` INT UNSIGNED DEFAULT NULL,
`fame` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
`pvpkills` SMALLINT UNSIGNED DEFAULT NULL,
`pkkills` SMALLINT UNSIGNED DEFAULT NULL,
`clanid` INT UNSIGNED DEFAULT NULL,
`race` TINYINT UNSIGNED DEFAULT NULL,
`classid` TINYINT UNSIGNED DEFAULT NULL,
`base_class` TINYINT UNSIGNED DEFAULT NULL,
`transform_id` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
`deletetime` BIGINT DEFAULT NULL,
`cancraft` TINYINT UNSIGNED DEFAULT NULL,
`title` VARCHAR(16) DEFAULT NULL,
`rec_have` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`rec_left` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`accesslevel` MEDIUMINT DEFAULT 0,
`online` TINYINT UNSIGNED DEFAULT NULL,
`onlinetime` INT DEFAULT NULL,
`char_slot` TINYINT UNSIGNED DEFAULT NULL,
`newbie` MEDIUMINT UNSIGNED DEFAULT 1,
`lastAccess` BIGINT UNSIGNED DEFAULT NULL,
`clan_privs` MEDIUMINT UNSIGNED DEFAULT 0,
`wantspeace` TINYINT UNSIGNED DEFAULT 0,
`isin7sdungeon` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`in_jail` TINYINT UNSIGNED DEFAULT 0,
`jail_timer` INT UNSIGNED DEFAULT 0,
`nobless` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`subpledge` SMALLINT NOT NULL DEFAULT 0,
`last_recom_date` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`pledge_rank` MEDIUMINT NOT NULL DEFAULT 0,
`lvl_joined_academy` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`apprentice` INT UNSIGNED NOT NULL DEFAULT 0,
`sponsor` INT UNSIGNED NOT NULL DEFAULT 0,
`varka_ketra_ally` TINYINT NOT NULL DEFAULT 0,
`clan_join_expiry_time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`clan_create_expiry_time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`charViP` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`death_penalty_level` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
`trust_level` INT UNSIGNED NOT NULL DEFAULT 0,
`vitality_points` DOUBLE(7,1) NOT NULL DEFAULT '0.0',
`enterHellbound` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`teleport_slots` INT NOT NULL DEFAULT '0',
PRIMARY KEY (`charId`),
KEY `clanid` (`clanid`)
) DEFAULT CHARSET=utf8;
SQl character L2Pheonix
Код
CREATE TABLE IF NOT EXISTS `characters` (
`account_name` VARCHAR(45) NOT NULL DEFAULT '',
`obj_Id` int NOT NULL DEFAULT 0,
`char_name` varchar(35) character set utf8 NOT NULL default '',
`face` tinyint unsigned DEFAULT NULL,
`hairStyle` tinyint unsigned DEFAULT NULL,
`hairColor` tinyint unsigned DEFAULT NULL,
`sex` BOOLEAN DEFAULT NULL,
`heading` mediumint DEFAULT NULL,
`x` mediumint DEFAULT NULL,
`y` mediumint DEFAULT NULL,
`z` mediumint DEFAULT NULL,
`karma` int DEFAULT NULL,
`pvpkills` int DEFAULT NULL,
`pkkills` int DEFAULT NULL,
`clanid` int DEFAULT NULL,
`deletetime` int unsigned NOT NULL DEFAULT 0,
`title` varchar(16) character set utf8 default NULL,
`rec_have` tinyint unsigned NOT NULL DEFAULT 0,
`rec_left` tinyint unsigned NOT NULL DEFAULT 0,
`accesslevel` tinyint DEFAULT NULL,
`online` BOOLEAN DEFAULT NULL,
`onlinetime` int unsigned NOT NULL DEFAULT 0,
`lastAccess` int unsigned NOT NULL DEFAULT 0,
`clan_privs` int DEFAULT 0,
`wantspeace` int DEFAULT 0,
`leaveclan` int unsigned NOT NULL DEFAULT 0,
`deleteclan` int unsigned NOT NULL DEFAULT 0,
`nochannel` int NOT NULL DEFAULT 0, -- not UNSIGNED, negative value means 'forever'
`noble` decimal(2,0) NOT NULL DEFAULT 0,
`ketra` decimal(5,0) NOT NULL DEFAULT 0,
`varka` decimal(5,0) NOT NULL DEFAULT 0,
`ram` decimal(5,0) NOT NULL DEFAULT 0,
`pledge_type` smallint NOT NULL DEFAULT 0,
`pledge_rank` tinyint unsigned NOT NULL DEFAULT 0,
`lvl_joined_academy` tinyint unsigned NOT NULL DEFAULT 0,
`apprentice` int unsigned NOT NULL DEFAULT 0,
`key_bindings` varbinary(8192) default NULL,
`pcBangPoints` int NOT NULL DEFAULT 0,
`vitality` smallint unsigned NOT NULL DEFAULT 10000,
`fame` INT NOT NULL DEFAULT 0,
PRIMARY KEY (obj_Id),
UNIQUE KEY `char_name` (`char_name`),
KEY `account_name` (`account_name`),
KEY `clanid` (`clanid`)
) TYPE=MyISAM;
`account_name` VARCHAR(45) NOT NULL DEFAULT '',
`obj_Id` int NOT NULL DEFAULT 0,
`char_name` varchar(35) character set utf8 NOT NULL default '',
`face` tinyint unsigned DEFAULT NULL,
`hairStyle` tinyint unsigned DEFAULT NULL,
`hairColor` tinyint unsigned DEFAULT NULL,
`sex` BOOLEAN DEFAULT NULL,
`heading` mediumint DEFAULT NULL,
`x` mediumint DEFAULT NULL,
`y` mediumint DEFAULT NULL,
`z` mediumint DEFAULT NULL,
`karma` int DEFAULT NULL,
`pvpkills` int DEFAULT NULL,
`pkkills` int DEFAULT NULL,
`clanid` int DEFAULT NULL,
`deletetime` int unsigned NOT NULL DEFAULT 0,
`title` varchar(16) character set utf8 default NULL,
`rec_have` tinyint unsigned NOT NULL DEFAULT 0,
`rec_left` tinyint unsigned NOT NULL DEFAULT 0,
`accesslevel` tinyint DEFAULT NULL,
`online` BOOLEAN DEFAULT NULL,
`onlinetime` int unsigned NOT NULL DEFAULT 0,
`lastAccess` int unsigned NOT NULL DEFAULT 0,
`clan_privs` int DEFAULT 0,
`wantspeace` int DEFAULT 0,
`leaveclan` int unsigned NOT NULL DEFAULT 0,
`deleteclan` int unsigned NOT NULL DEFAULT 0,
`nochannel` int NOT NULL DEFAULT 0, -- not UNSIGNED, negative value means 'forever'
`noble` decimal(2,0) NOT NULL DEFAULT 0,
`ketra` decimal(5,0) NOT NULL DEFAULT 0,
`varka` decimal(5,0) NOT NULL DEFAULT 0,
`ram` decimal(5,0) NOT NULL DEFAULT 0,
`pledge_type` smallint NOT NULL DEFAULT 0,
`pledge_rank` tinyint unsigned NOT NULL DEFAULT 0,
`lvl_joined_academy` tinyint unsigned NOT NULL DEFAULT 0,
`apprentice` int unsigned NOT NULL DEFAULT 0,
`key_bindings` varbinary(8192) default NULL,
`pcBangPoints` int NOT NULL DEFAULT 0,
`vitality` smallint unsigned NOT NULL DEFAULT 10000,
`fame` INT NOT NULL DEFAULT 0,
PRIMARY KEY (obj_Id),
UNIQUE KEY `char_name` (`char_name`),
KEY `account_name` (`account_name`),
KEY `clanid` (`clanid`)
) TYPE=MyISAM;
Вы видете что в SQL некотырые таблици периставлены местами или есть новые таблицы...
На форуме нашёл
Код
Для етого нам понадобится Navicat
1. Go on Navicat to Tools -> Structure Syncronization
2. Left side -> (your connection name) -> (your new rev db)
3. Right side -> (your connection name) -> (your GS db)
4. Press "Compare" button
а дальше просто - запускаем инсталдб с новой сборки и выбераем упдейт )
проверено ) все работает )
1. Go on Navicat to Tools -> Structure Syncronization
2. Left side -> (your connection name) -> (your new rev db)
3. Right side -> (your connection name) -> (your GS db)
4. Press "Compare" button
а дальше просто - запускаем инсталдб с новой сборки и выбераем упдейт )
проверено ) все работает )
Вот оригинальная сылка _http://la2base.ru/forum/index.php?showtopic=24547&hl=%EF%E5%F0%E5%F5%EE%E4
Вопрос.
Можно ка кто прикинуть чарав с 1 сборки на другую не смотря по структуре таблиц...
— RelaxSoft
0
· 01.06.2009, 15:32
sahas: Вопрос.
Можно ка кто прикинуть чарав с 1 сборки на другую не смотря по структуре таблиц...
Нет нельзя , а теперь удачной тебе ночки так как тебе придеца сейчас писать СQЛ запросы на добавлении // удалении // изменении колумнов в таблицах ( Accounts / Characters / items / cland data/ ally data/olympiad_noblesse/ etc .. )
0
Войдите или зарегистрируйтесь чтобы ответить



