UID216207
帖子
精華
主題
積分73791
現金
積極性
威望
違規
熱心
推廣次數
閱讀權限40
註冊時間2009-11-27
在線時間 小時
最後登錄1970-1-1
TA的每日心情 | 開心 2024-5-2 03:39 PM |
---|
簽到天數: 1323 天 連續簽到: 1 天 [LV.10]以壇為家III
|
發表於 2013-8-21 01:50:07
|
顯示全部樓層
本帖最後由 sinya 於 2013-8-21 07:51 PM 編輯
bubu1216 發表於 2013-8-21 12:43 AM
SINYA 大大我也想問一下
我3CEAM 換 SEAR 的也能用這的方法保存玩家資料嗎
可以吧 大概 我也沒轉過
1先備份資料庫
2 做這些更新 存成.sql 載入更新 - CREATE TABLE IF NOT EXISTS `wanted_reward` (
- `id` bigint(20) unsigned NOT NULL auto_increment,
- `wanter_name` varchar(30) NOT NULL default '',
- `wanted_id` int(11) unsigned NOT NULL default '0',
- `wanted_refine` tinyint(3) unsigned NOT NULL default '0',
- `wanted_amount` int(11) unsigned NOT NULL default '0',
- `reward_type` smallint(6) NOT NULL default '0',
- `reward_id` int(11) unsigned NOT NULL default '0',
- `reward_refine` tinyint(3) unsigned NOT NULL default '0',
- `reward_amount` int(11) unsigned NOT NULL default '0',
- `expire_time` int(11) unsigned NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM;
- ALTER TABLE `inventory` CHANGE `expire_time` `expiration_time` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
- ALTER TABLE `inventory` ADD COLUMN `max_dur` smallint(4) UNSIGNED NOT NULL default '0' AFTER `expiration_time`;
- ALTER TABLE `cart_inventory` ADD COLUMN `max_dur` smallint(4) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `storage` ADD COLUMN `max_dur` smallint(4) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `guild_storage` ADD COLUMN `max_dur` smallint(4) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `auction` ADD COLUMN `max_dur` smallint(4) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `mail` ADD COLUMN `max_dur` smallint(4) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `inventory` ADD COLUMN `durability` smallint(4) UNSIGNED NOT NULL default '0' AFTER `expiration_time`;
- ALTER TABLE `cart_inventory` ADD COLUMN `durability` smallint(4) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `storage` ADD COLUMN `durability` smallint(4) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `guild_storage` ADD COLUMN `durability` smallint(4) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `auction` ADD COLUMN `durability` smallint(4) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `mail` ADD COLUMN `durability` smallint(4) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `inventory` ADD COLUMN `available_time` int(11) UNSIGNED NOT NULL default '0' AFTER `expiration_time`;
- ALTER TABLE `cart_inventory` ADD COLUMN `available_time` int(11) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `storage` ADD COLUMN `available_time` int(11) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `guild_storage` ADD COLUMN `available_time` int(11) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `auction` ADD COLUMN `available_time` int(11) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `mail` ADD COLUMN `available_time` int(11) UNSIGNED NOT NULL default '0' AFTER `card3`;
- ALTER TABLE `pet` ADD COLUMN `exp` int(12) NOT NULL default '0' AFTER `incuvate`;
- UPDATE `login` SET `account_id` = '0' WHERE `account_id` = '1' AND `sex` = 'S';
複製代碼 3.然後更新這些
upgrade_r1.6.62.sql
upgrade_r1.7.00.sql
upgrade_r1.7.05.sql
upgrade_r1.7.161.sql
upgrade_r1.7.221.sql
upgrade_r1.8.06.sql
|
|