Deprecated Darkstar fourms

Code: Select all

ALTER TABLE `char_inventory` ADD `locked` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `quantity`;
ALTER TABLE `char_inventory` ADD `col` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER `locked`;
ALTER TABLE `char_inventory` ADD `row` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER `col`;
ALTER TABLE `char_inventory` ADD `level` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER `row`;
ALTER TABLE `char_inventory` ADD `rotation` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER `level`;
ALTER TABLE `char_inventory` CHANGE `location` `location` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `char_inventory` CHANGE `slot` `slot` tinyint(2) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `char_inventory` CHANGE `itemId` `itemId` smallint(5) unsigned NOT NULL DEFAULT '65535';

UPDATE `char_inventory`, `char_furnishings` SET
`char_inventory`.`locked` = `char_furnishings`.`locked`,
`char_inventory`.`col` = `char_furnishings`.`col`,
`char_inventory`.`row` = `char_furnishings`.`row`,
`char_inventory`.`level` = `char_furnishings`.`level`,
`char_inventory`.`rotation` = `char_furnishings`.`rotation`
WHERE `char_inventory`.`charid` = `char_furnishings`.`charid` AND `char_inventory`.`location` = 1 AND `char_inventory`.`slot` = `char_furnishings`.`slot`;

DROP TABLE IF EXISTS `char_furnishings`;

DROP TABLE IF EXISTS `char_profile`;
CREATE TABLE IF NOT EXISTS `char_profile` (
`charid` int(10) unsigned NOT NULL,
`rank_points` int(10) unsigned NOT NULL DEFAULT '0',
`rank_sandoria` tinyint(2) unsigned NOT NULL DEFAULT '1',
`rank_bastok` tinyint(2) unsigned NOT NULL DEFAULT '1',
`rank_windurst` tinyint(2) unsigned NOT NULL DEFAULT '1',
`fame_sandoria` smallint(5) unsigned NOT NULL DEFAULT '0',
`fame_bastok` smallint(5) unsigned NOT NULL DEFAULT '0',
`fame_windurst` smallint(5) unsigned NOT NULL DEFAULT '0',
`fame_norg` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`charid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `char_profile`
(`charid`,`rank_points`,`rank_sandoria`,`rank_bastok`,`rank_windurst`,`fame_sandoria`,`fame_bastok`,`fame_windurst`,`fame_norg`) 
SELECT 
`chars`.`charid`,
`chars`.`rankPoints`,
`chars`.`rankSandoria`,
`chars`.`rankBastok`,
`chars`.`rankWindurst`,
`chars`.`fameSandoria`,
`chars`.`fameBastok`,
`chars`.`fameWindurst`,
`chars`.`fameNorg` 
FROM
`chars`;

ALTER TABLE `chars` DROP `rankPoints`;
ALTER TABLE `chars` DROP `rankSandoria`;
ALTER TABLE `chars` DROP `rankBastok`;
ALTER TABLE `chars` DROP `rankWindurst`;
ALTER TABLE `chars` DROP `fameSandoria`;
ALTER TABLE `chars` DROP `fameBastok`;
ALTER TABLE `chars` DROP `fameWindurst`;
ALTER TABLE `chars` DROP `fameNorg`;

DROP TABLE IF EXISTS `char_storage`;
CREATE TABLE IF NOT EXISTS `char_storage` (
`charid` int(10) unsigned NOT NULL,
`inventory` tinyint(2) unsigned NOT NULL DEFAULT '30',
`safe` tinyint(2) unsigned NOT NULL DEFAULT '50',
`locker` tinyint(2) unsigned NOT NULL DEFAULT '0',
`satchel` tinyint(2) unsigned NOT NULL DEFAULT '30',
`sack` tinyint(2) unsigned NOT NULL DEFAULT '30',
PRIMARY KEY (`charid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `char_storage`
(`charid`,`inventory`,`safe`,`locker`,`satchel`,`sack`) 
SELECT 
`chars`.`charid`,
`chars`.`inventory`,
`chars`.`safe`,
`chars`.`locker`,
`chars`.`satchel`,
`chars`.`sack`
FROM
`chars`;

ALTER TABLE `chars` DROP `inventory`;
ALTER TABLE `chars` DROP `safe`;
ALTER TABLE `chars` DROP `locker`;
ALTER TABLE `chars` DROP `satchel`;
ALTER TABLE `chars` DROP `sack`;

ALTER TABLE `chars` ADD `playtime` int(10) unsigned NOT NULL DEFAULT '0' AFTER `zones`;

ALTER TABLE `char_stats` CHANGE `hp` `hp` smallint(4) unsigned NOT NULL DEFAULT '50';
ALTER TABLE `char_stats` CHANGE `mp` `mp` smallint(4) unsigned NOT NULL DEFAULT '50';