FFvii Fortress v14 - Group: Discussion Forums

FFvii Fortress v14 - Group: Discussion Forums http://dystopiapro.com/fortress14/forum?group=1 Simple:Press Forum Version 4.0.4 dystopia on ++ Chapter 1: OOC Thread http://dystopiapro.com/fortress14/forum/general-discussion/chapter-1-ooc-thread/#p872 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/chapter-1-ooc-thread/#p872

Current Battle Information
All damage information is how much damage has been done, and then if known the total HP of the creature. Damage does not represent how much HP the targets have left.
————————————-
›› Wrath Hound Damage: 81 of ???

]]> Thu, 03 Dec 2020 13:11:57 +0000 void on Void's Protospace http://dystopiapro.com/fortress14/forum/general-discussion/voids-protospace/#p847 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/voids-protospace/#p847

Posting Box

“This is a dialog.” A solo posting box for use in certain circumstances.

—
¤ words: 000 ( 0000 )
]]> Mon, 23 Nov 2020 16:52:02 +0000 void on Void's Protospace http://dystopiapro.com/fortress14/forum/general-discussion/voids-protospace/#p845 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/voids-protospace/#p845

Solo Posting Box

“This is a dialog.” A solo post form with Astra in the banner's background that I may or may not end up using.

—
¤ words: 000 ( 0000 )
]]> Sat, 21 Nov 2020 20:53:43 +0000 dystopia on XP and Level UP Info. http://dystopiapro.com/fortress14/forum/general-discussion/xp-and-level-up-info/#p825 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/xp-and-level-up-info/#p825 Now that we have started some combat it's time to detail how gaining XP and AP will work. 1 XP will be awarded for each word and 1 AP will be awarded for every 10 words. Now, XP and AP needed to level up will be custom for this, not based on the info from the game. I'm still working on the complete level up table but below are the first 5 levels. It should be noted we all started at level 10, with 10k XP. Words will not get updated until the END of a thread, however I will update XP for all combat encounters immediately after they are finished, if a level up happens from this it will take effect even mid-chapter.

Level 11:
›› XP Needed: 14000
›› Stat Points Awarded: +10 to distribute between STR, DEX, VIT, MAG, and SPR. LUCK +1
›› HP and MP: (STR + VIT) * 1.5 is the HP formula. (MAG + SPR) / 4 is the MP formula. These round UP to the nearest 1.

Level 12:
›› XP Needed: 18000
›› Stat Points Awarded: +10 to distribute between STR, DEX, VIT, MAG, and SPR. LUCK +1
›› HP and MP: (STR + VIT) * 1.5 is the HP formula. (MAG + SPR) / 4 is the MP formula. These round UP to the nearest 1.

Level 13:
›› XP Needed: 22000
›› Stat Points Awarded: +12 to distribute between STR, DEX, VIT, MAG, and SPR. LUCK +1
›› HP and MP: (STR + VIT) * 1.5 is the HP formula. (MAG + SPR) / 4 is the MP formula. These round UP to the nearest 1.

Level 14:
›› XP Needed: 26000
›› Stat Points Awarded: +12 to distribute between STR, DEX, VIT, MAG, and SPR. LUCK +1
›› HP and MP: (STR + VIT) * 1.5 is the HP formula. (MAG + SPR) / 4 is the MP formula. These round UP to the nearest 1.

Level 15:
›› XP Needed: 30000
›› Stat Points Awarded: +12 to distribute between STR, DEX, VIT, MAG, and SPR. LUCK +1
›› HP and MP: (STR + VIT) * 1.5 is the HP formula. (MAG + SPR) / 4 is the MP formula. These round UP to the nearest 1.

Now some info about AP and how that will work. Just like with XP, AP from words will be awarded after the end of a chapter but extra AP earned in combat will be updated after the combat encounter. The amount of AP needed to level you materia up will not be the same as the game. I'm going to be adding all the materia Void created to the site as pages with updated AP info over the next few days. But expect the AP requiements to be lowered by about half, it'll vary in some cases, I'll tailor them so that they level up at a good rate for our characters.

]]> Wed, 18 Nov 2020 17:19:44 +0000 void on The Database Project http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p809 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p809 Armor

INSERT INTO `ff7equip` VALUES('160', 'Bronze Bangle', 'ar', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('161', 'Iron Bangle', 'ar', '0', '0', '0', '0', '10', '0', '2', '0', '0', '1');
INSERT INTO `ff7equip` VALUES('162', 'Titan Bangle', 'ar', '0', '0', '0', '0', '14', '0', '4', '0', '0', '2');
INSERT INTO `ff7equip` VALUES('163', 'Mythril Armlet', 'ar', '0', '0', '0', '0', '18', '0', '8', '0', '1', '0');
INSERT INTO `ff7equip` VALUES('164', 'Carbon Bangle', 'ar', '0', '0', '0', '0', '27', '0', '14', '0', '1', '1');
INSERT INTO `ff7equip` VALUES('165', 'Silver Armlet', 'ar', '0', '0', '0', '0', '34', '0', '22', '0', '1', '2');
INSERT INTO `ff7equip` VALUES('166', 'Gold Armlet', 'ar', '0', '0', '0', '0', '46', '0', '28', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('167', 'Diamond Bangle', 'ar', '0', '0', '0', '0', '57', '0', '37', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('168', 'Crystal Bangle', 'ar', '0', '0', '0', '0', '70', '0', '45', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('169', 'Platinum Bangle', 'ar', '0', '0', '0', '0', '20', '0', '12', '0', '0', '2');
INSERT INTO `ff7equip` VALUES('170', 'Rune Armlet', 'ar', '0', '0', '0', '0', '43', '0', '24', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('171', 'Edincoat', 'ar', '0', '0', '0', '0', '50', '5', '33', '0', '0', '7');
INSERT INTO `ff7equip` VALUES('172', 'Wizard Bracelet', 'ar', '0', '0', '0', '0', '6', '20', '85', '0', '4', '0');
INSERT INTO `ff7equip` VALUES('173', 'Adaman Bangle', 'ar', '0', '0', '0', '0', '93', '0', '23', '0', '1', '0');
INSERT INTO `ff7equip` VALUES('174', 'Gigas Armlet', 'ar', '0', '0', '30', '0', '59', '0', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('175', 'Imperial Guard', 'ar', '0', '0', '0', '0', '82', '0', '74', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('176', 'Aegis Bracelet', 'ar', '0', '0', '0', '0', '55', '0', '86', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('177', 'Fourth Bracelet', 'ar', '0', '0', '0', '0', '74', '20', '100', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('178', 'Warrior Bangle', 'ar', '0', '0', '20', '0', '96', '0', '21', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('179', 'Shinra Beta', 'ar', '0', '0', '0', '0', '30', '0', '0', '0', '1', '2');
INSERT INTO `ff7equip` VALUES('180', 'Shinra Alpha', 'ar', '0', '0', '0', '0', '77', '0', '34', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('181', 'Four Slot', 'ar', '0', '0', '0', '0', '12', '0', '10', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('182', 'Fire Armlet', 'ar', '0', '0', '0', '0', '72', '0', '52', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('183', 'Aurora Armlet', 'ar', '0', '0', '0', '0', '76', '0', '54', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('184', 'Bolt Armlet', 'ar', '0', '0', '0', '0', '74', '0', '55', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('185', 'Dragon Armlet', 'ar', '0', '0', '0', '0', '58', '0', '47', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('186', 'Minerva Band', 'ar', '0', '0', '0', '0', '60', '0', '57', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('187', 'Escort Guard', 'ar', '0', '0', '0', '0', '62', '0', '55', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('188', 'Mythril', 'ar', '0', '0', '0', '0', '65', '0', '72', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('189', 'Ziedrich', 'ar', '0', '0', '20', '0', '100', '20', '98', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('190', 'Precious Watch', 'ar', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8');
INSERT INTO `ff7equip` VALUES('191', 'Chocobracelet', 'ar', '0', '0', '0', '30', '35', '0', '38', '20', '0', '4');
]]> Wed, 04 Nov 2020 20:37:19 +0000 void on The Database Project http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p808 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p808 Megaphones, guns, and spears. Also Masamune.

INSERT INTO `ff7equip` VALUES('119', 'Yellow M-Phone', 'w', '0', '0', '36', '0', '0', '8', '0', '0', '1', '2');
INSERT INTO `ff7equip` VALUES('120', 'Green M-Phone', 'w', '0', '0', '41', '0', '0', '9', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('121', 'Blue M-Phone', 'w', '0', '0', '48', '0', '0', '10', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('122', 'Red M-Phone', 'w', '0', '0', '60', '0', '0', '15', '0', '0', '2', '2');
INSERT INTO `ff7equip` VALUES('123', 'Crystal M-Phone', 'w', '0', '0', '74', '0', '0', '20', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('124', 'White M-Phone', 'w', '0', '0', '35', '0', '0', '8', '0', '0', '0', '3');
INSERT INTO `ff7equip` VALUES('125', 'Black M-Phone', 'w', '0', '0', '31', '0', '0', '10', '0', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('126', 'Silver M-Phone', 'w', '0', '0', '28', '0', '0', '14', '0', '0', '0', '8');
INSERT INTO `ff7equip` VALUES('127', 'Trumpet Shell', 'w', '0', '0', '68', '0', '0', '2', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('128', 'Gold M-Phone', 'w', '0', '0', '58', '0', '0', '28', '0', '0', '4', '0');
INSERT INTO `ff7equip` VALUES('129', 'Battle Trumpet', 'w', '0', '0', '95', '0', '0', '0', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('130', 'Starlight Phone', 'w', '0', '0', '88', '0', '0', '31', '0', '0', '4', '0');
INSERT INTO `ff7equip` VALUES('131', 'Marvelous Cheer', 'w', '0', '0', '95', '0', '0', '44', '0', '0', '4', '0');

INSERT INTO `ff7equip` VALUES('132', 'Quicksilver', 'w', '0', '0', '36', '0', '0', '10', '0', '0', '1', '2');
INSERT INTO `ff7equip` VALUES('133', 'SPAS', 'w', '0', '0', '48', '0', '0', '12', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('134', 'Randall', 'w', '0', '0', '51', '0', '0', '14', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('135', 'Riot', 'w', '0', '0', '64', '0', '0', '16', '0', '0', '2', '2');
INSERT INTO `ff7equip` VALUES('136', 'Winchester', 'w', '0', '0', '73', '0', '0', '18', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('137', 'Peacemaker', 'w', '0', '0', '38', '0', '0', '8', '0', '0', '1', '1');
INSERT INTO `ff7equip` VALUES('138', 'Buntline', 'w', '0', '0', '48', '0', '0', '18', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('139', 'Long Barrel R', 'w', '0', '0', '66', '0', '0', '14', '0', '0', '4', '0');
INSERT INTO `ff7equip` VALUES('140', 'Silver Bullet Gun', 'w', '0', '0', '62', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('141', 'Sniper CR', 'w', '0', '0', '42', '0', '0', '7', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('142', 'Highbrow ST', 'w', '0', '0', '97', '0', '0', '52', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('143', 'Outsider', 'w', '0', '0', '80', '0', '0', '48', '0', '0', '2', '4');
INSERT INTO `ff7equip` VALUES('144', 'Death Penalty', 'w', '0', '0', '99', '0', '0', '34', '0', '0', '4', '0');

INSERT INTO `ff7equip` VALUES('145', 'Spear', 'w', '0', '0', '44', '0', '0', '8', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('146', 'Slash Pike', 'w', '0', '0', '56', '0', '0', '10', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('147', 'Trident', 'w', '0', '0', '60', '0', '0', '12', '0', '0', '0', '6');
INSERT INTO `ff7equip` VALUES('148', 'Pole Axe', 'w', '0', '0', '64', '0', '0', '15', '0', '0', '2', '2');
INSERT INTO `ff7equip` VALUES('149', 'Partisan', 'w', '0', '0', '78', '0', '0', '17', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('150', 'Viper Halberd', 'w', '0', '0', '58', '0', '0', '13', '0', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('151', 'Javelin', 'w', '0', '0', '62', '0', '0', '12', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('152', 'Glow Lance', 'w', '0', '0', '78', '0', '0', '31', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('153', 'Mop', 'w', '0', '0', '68', '0', '0', '3', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('154', 'Dragoon Lance', 'w', '0', '0', '66', '0', '0', '7', '0', '0', '0', '8');
INSERT INTO `ff7equip` VALUES('155', 'Scimitar', 'w', '0', '0', '86', '0', '0', '20', '0', '0', '1', '0');
INSERT INTO `ff7equip` VALUES('156', 'Flayer', 'w', '0', '0', '100', '0', '0', '20', '0', '0', '0', '6');
INSERT INTO `ff7equip` VALUES('157', 'Spirit Lance', 'w', '0', '0', '92', '0', '0', '43', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('158', 'Venus Gospel', 'w', '0', '0', '97', '0', '0', '42', '0', '0', '4', '0');

INSERT INTO `ff7equip` VALUES('159', 'Masamune', 'w', '0', '0', '99', '0', '0', '0', '0', '0', '3', '0');
]]> Tue, 03 Nov 2020 22:51:44 +0000 dystopia on The Database Project http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p806 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p806 Accessories are done.

INSERT INTO `ff7equip` VALUES('88', 'Protect Vest', 'ac', '0', '0', '0', '0', '10', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('89', 'Talisman', 'ac', '0', '0', '0', '0', '0', '0', '10', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('90', 'Power Wrist', 'ac', '0', '0', '10', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('91', 'Earring', 'ac', '0', '0', '0', '0', '0', '10', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('92', 'Choco Feather', 'ac', '0', '0', '0', '10', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('93', 'Amulet', 'ac', '0', '0', '0', '0', '0', '0', '0', '10', '0', '0');
INSERT INTO `ff7equip` VALUES('94', 'Champion Belt', 'ac', '0', '0', '30', '0', '30', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('95', 'Circlet', 'ac', '0', '0', '0', '0', '0', '30', '30', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('96', 'Tough Ring', 'ac', '0', '0', '0', '0', '50', '0', '50', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('97', 'Curse Ring', 'ac', '0', '0', '35', '15', '15', '35', '15', '10', '0', '0');
INSERT INTO `ff7equip` VALUES('98', 'Sprint Shoes', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('99', 'Fury Ring', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('100', 'Protect Ring', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('101', 'Reflect Ring', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('102', 'Sneak Glove', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('103', 'HypnoCrown', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('104', 'Silver Glasses', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('105', 'Headband', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('106', 'Star Pendant', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('107', 'Fairy Ring', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('108', 'Jem Ring', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('109', 'Peace RIng', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('110', 'Safety Bit', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('111', 'Ribbon', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('112', 'Fire Ring', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('113', 'Ice Ring', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('114', 'Bolt Ring', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('115', 'Water Ring', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('116', 'Poison Ring', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('117', 'Tetra Elemental', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('118', 'Cats Bell', 'ac', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

]]> Tue, 03 Nov 2020 12:41:11 +0000 void on The Database Project http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p805 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p805 Gun arms, knuckles, headresses, and boomerangs are all done.

INSERT INTO `ff7equip` VALUES('28', 'Gatling Gun', 'w', '0', '0', '14', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `ff7equip` VALUES('29', 'Assault Gun', 'w', '0', '0', '17', '0', '0', '1', '0', '0', '1', '0');
INSERT INTO `ff7equip` VALUES('30', 'Cannon Ball', 'w', '0', '0', '23', '0', '0', '2', '0', '0', '1', '1');
INSERT INTO `ff7equip` VALUES('31', 'Atomic Scissors', 'w', '0', '0', '32', '0', '0', '4', '0', '0', '1', '2');
INSERT INTO `ff7equip` VALUES('32', 'Heavy Vulcan', 'w', '0', '0', '39', '0', '0', '8', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('33', 'Chainsaw', 'w', '0', '0', '52', '0', '0', '10', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('34', 'Microlaser', 'w', '0', '0', '63', '0', '0', '13', '0', '0', '2', '2');
INSERT INTO `ff7equip` VALUES('35', 'AM Cannon', 'w', '0', '0', '77', '0', '0', '16', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('36', 'W Machine Gun', 'w', '0', '0', '30', '0', '0', '3', '0', '0', '0', '3');
INSERT INTO `ff7equip` VALUES('37', 'Drill Arm', 'w', '0', '0', '37', '0', '0', '0', '0', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('38', 'Solid Bazooka', 'w', '0', '0', '61', '0', '0', '15', '0', '0', '4', '0');
INSERT INTO `ff7equip` VALUES('39', 'Rocket Punch', 'w', '0', '0', '62', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('40', 'Enemy Launcher', 'w', '0', '0', '35', '0', '0', '7', '0', '0', '1', '3');
INSERT INTO `ff7equip` VALUES('41', 'Pile Bunker', 'w', '0', '0', '90', '0', '0', '0', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('42', 'Max Ray', 'w', '0', '0', '97', '0', '0', '30', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('43', 'Missing Score', 'w', '0', '0', '98', '0', '0', '49', '0', '0', '4', '0');

INSERT INTO `ff7equip` VALUES('44', 'Leather Glove', 'w', '0', '0', '13', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `ff7equip` VALUES('45', 'Metal Knuckle', 'w', '0', '0', '18', '0', '0', '1', '0', '0', '1', '0');
INSERT INTO `ff7equip` VALUES('46', 'Mythril Claw', 'w', '0', '0', '24', '0', '0', '3', '0', '0', '1', '1');
INSERT INTO `ff7equip` VALUES('47', 'Grand Glove', 'w', '0', '0', '31', '0', '0', '6', '0', '0', '1', '2');
INSERT INTO `ff7equip` VALUES('48', 'Tiger Fang', 'w', '0', '0', '38', '0', '0', '8', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('49', 'Diamond Knuckle', 'w', '0', '0', '51', '0', '0', '10', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('50', 'Dragon Claw', 'w', '0', '0', '62', '0', '0', '13', '0', '0', '2', '2');
INSERT INTO `ff7equip` VALUES('51', 'Crystal Glove', 'w', '0', '0', '75', '0', '0', '16', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('52', 'Motor Drive', 'w', '0', '0', '27', '0', '0', '6', '0', '0', '0', '3');
INSERT INTO `ff7equip` VALUES('53', 'Platinum Fist', 'w', '0', '0', '30', '0', '0', '7', '0', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('54', 'Kaiser Knuckle', 'w', '0', '0', '44', '0', '0', '13', '0', '0', '1', '6');
INSERT INTO `ff7equip` VALUES('55', 'Work Glove', 'w', '0', '0', '68', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('56', 'Powersoul', 'w', '0', '0', '28', '0', '0', '7', '0', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('57', 'Master Fist', 'w', '0', '0', '38', '0', '0', '0', '0', '0', '0', '6');
INSERT INTO `ff7equip` VALUES('58', 'God Hand', 'w', '0', '0', '86', '0', '0', '34', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('59', 'Premium Heart', 'w', '0', '0', '99', '0', '0', '32', '0', '0', '4', '0');

INSERT INTO `ff7equip` VALUES('60', 'Mythril Clip', 'w', '0', '0', '24', '0', '0', '6', '0', '0', '1', '1');
INSERT INTO `ff7equip` VALUES('61', 'Diamond Pin', 'w', '0', '0', '33', '0', '0', '8', '0', '0', '1', '2');
INSERT INTO `ff7equip` VALUES('62', 'Silver Barrette', 'w', '0', '0', '40', '0', '0', '10', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('63', 'Gold Barrette', 'w', '0', '0', '50', '0', '0', '13', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('64', 'Adaman Clip', 'w', '0', '0', '60', '0', '0', '15', '0', '0', '2', '2');
INSERT INTO `ff7equip` VALUES('65', 'Crystal Comb', 'w', '0', '0', '76', '0', '0', '20', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('66', 'Magic Comb', 'w', '0', '0', '37', '0', '0', '4', '0', '0', '0', '3');
INSERT INTO `ff7equip` VALUES('67', 'Platinum Barrette', 'w', '0', '0', '39', '0', '0', '12', '0', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('68', 'Centclip', 'w', '0', '0', '58', '0', '0', '22', '0', '0', '0', '8');
INSERT INTO `ff7equip` VALUES('69', 'Hairpin', 'w', '0', '0', '57', '0', '0', '15', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('70', 'Seraph Comb', 'w', '0', '0', '68', '0', '0', '14', '0', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('71', 'Behemoth Horn', 'w', '0', '0', '91', '0', '0', '26', '0', '0', '0', '6');
INSERT INTO `ff7equip` VALUES('72', 'Spriggan Clip', 'w', '0', '0', '87', '0', '0', '55', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('73', 'Limited Moon', 'w', '0', '0', '93', '0', '0', '31', '0', '0', '4', '0');

INSERT INTO `ff7equip` VALUES('74', '4-Point Shuriken', 'w', '0', '0', '23', '0', '0', '6', '0', '0', '1', '1');
INSERT INTO `ff7equip` VALUES('75', 'Boomerang', 'w', '0', '0', '30', '0', '0', '7', '0', '0', '1', '2');
INSERT INTO `ff7equip` VALUES('76', 'Pinwheel', 'w', '0', '0', '37', '0', '0', '9', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('77', 'Razor Ring', 'w', '0', '0', '49', '0', '0', '12', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('78', 'Hawkeye', 'w', '0', '0', '61', '0', '0', '14', '0', '0', '2', '2');
INSERT INTO `ff7equip` VALUES('79', 'Crystal Cross', 'w', '0', '0', '74', '0', '0', '18', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('80', 'Wind Slash', 'w', '0', '0', '30', '0', '0', '7', '0', '0', '0', '3');
INSERT INTO `ff7equip` VALUES('81', 'Twin Viper', 'w', '0', '0', '36', '0', '0', '8', '0', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('82', 'Spiral Shuriken', 'w', '0', '0', '68', '0', '0', '18', '0', '0', '1', '6');
INSERT INTO `ff7equip` VALUES('83', 'Super Ball', 'w', '0', '0', '68', '0', '0', '10', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('84', 'Fuma Shuriken', 'w', '0', '0', '64', '0', '0', '0', '0', '0', '0', '3');
INSERT INTO `ff7equip` VALUES('85', 'Rising Sun', 'w', '0', '0', '68', '0', '0', '16', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('86', 'Orizuru', 'w', '0', '0', '90', '0', '0', '38', '0', '0', '2', '4');
INSERT INTO `ff7equip` VALUES('87', 'Conformer', 'w', '0', '0', '96', '0', '0', '42', '0', '0', '4', '0');

Still got megaphones, guns, and spears to do.
]]> Tue, 03 Nov 2020 06:54:02 +0000 void on The Database Project http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p804 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p804 Blue Support, Purple Independent, Yellow Command

INSERT INTO `ff7materia` VALUES('39', 'Added Cut', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('40', 'Added Effect', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('41', 'All', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('42', 'Counter', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('43', 'Elemental', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('44', 'Final Attack', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('45', 'HP Absorb', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('46', 'Magic Counter', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('47', 'MP Absorb', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('48', 'MP Turbo', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('49', 'Quadra Magic', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('50', 'Sneak Attack', 'b', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('51', 'Steal As Well', 'b', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `ff7materia` VALUES('52', 'Chocobo Lure', 'p', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `ff7materia` VALUES('53', 'Counter Attack', 'p', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('54', 'Cover', 'p', '0', '0', '0', '0', '1', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('55', 'Enemy Away', 'p', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `ff7materia` VALUES('56', 'Enemy Lure', 'p', '0', '0', '0', '0', '0', '0', '0', '-1');
INSERT INTO `ff7materia` VALUES('57', 'EXP Plus', 'p', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `ff7materia` VALUES('58', 'Gil Plus', 'p', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `ff7materia` VALUES('59', 'HP Plus', 'p', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('60', 'HP <-> MP', 'p', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('61', 'Long Range', 'p', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('62', 'Luck Plus', 'p', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('63', 'Mega All', 'p', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('64', 'MP Plus', 'p', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('65', 'Pre-Emptive', 'p', '0', '0', '0', '2', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('66', 'Speed Plus', 'p', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('67', 'Underwater', 'p', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `ff7materia` VALUES('68', 'Deathblow', 'y', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `ff7materia` VALUES('69', 'Double Cut', 'y', '0', '1', '0', '2', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('70', 'Enemy Skill', 'y', '0', '1', '0', '0', '1', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('71', 'Manipulate', 'y', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('72', 'Master Command', 'y', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('73', 'Mime', 'y', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('74', 'Morph', 'y', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('75', 'Sense', 'y', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('76', 'Slash-All', 'y', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('77', 'Steal', 'y', '0', '0', '0', '2', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('78', 'Throw', 'y', '0', '0', '0', '0', '1', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('79', 'W-Item', 'y', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('80', 'W-Magic', 'y', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('81', 'W-Summon', 'y', '0', '0', '0', '0', '0', '0', '0', '0');
]]> Sun, 01 Nov 2020 21:05:30 +0000 dystopia on The Database Project http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p803 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p803 I've finished all the swords. SQL for reference and ID count.
[EDIT] And Staves too now!

INSERT INTO `ff7equip` VALUES('1', 'Buster Sword', 'w', '0', '0', '18', '0', '0', '2', '0', '0', '1', '0');
INSERT INTO `ff7equip` VALUES('2', 'Mythril Saber', 'w', '0', '0', '23', '0', '0', '4', '0', '0', '1', '1');
INSERT INTO `ff7equip` VALUES('3', 'Hardedge', 'w', '0', '0', '32', '0', '0', '6', '0', '0', '1', '2');
INSERT INTO `ff7equip` VALUES('4', 'Butterfly Edge', 'w', '0', '0', '39', '0', '0', '8', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('5', 'Enhance Sword', 'w', '0', '0', '43', '0', '0', '16', '0', '0', '4', '0');
INSERT INTO `ff7equip` VALUES('6', 'Organics', 'w', '0', '0', '62', '0', '0', '15', '0', '0', '2', '2');
INSERT INTO `ff7equip` VALUES('7', 'Crystal Sword', 'w', '0', '0', '76', '0', '0', '19', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('8', 'Force Stealer', 'w', '0', '0', '36', '0', '0', '7', '0', '0', '0', '3');
INSERT INTO `ff7equip` VALUES('9', 'Rune Blade', 'w', '0', '0', '40', '0', '0', '9', '0', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('10', 'Murasame', 'w', '0', '0', '51', '0', '0', '12', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('11', 'Nail Bat', 'w', '0', '0', '70', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('12', 'Yoshiyuki', 'w', '0', '0', '56', '0', '0', '9', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('13', 'Apocalypse', 'w', '0', '0', '88', '0', '0', '43', '0', '0', '0', '3');
INSERT INTO `ff7equip` VALUES('14', 'Heavens Cloud', 'w', '0', '0', '93', '0', '0', '31', '0', '0', '0', '6');
INSERT INTO `ff7equip` VALUES('15', 'Ragnarok', 'w', '0', '0', '97', '0', '0', '43', '0', '0', '3', '0');
INSERT INTO `ff7equip` VALUES('16', 'Ultima Weapon', 'w', '0', '0', '100', '0', '0', '51', '0', '0', '4', '0');

INSERT INTO `ff7equip` VALUES('17', 'Guard Stick', 'w', '0', '0', '12', '0', '1', '2', '4', '0', '0', '1');
INSERT INTO `ff7equip` VALUES('18', 'Mythril Rod', 'w', '0', '0', '16', '0', '0', '3', '0', '0', '0', '1');
INSERT INTO `ff7equip` VALUES('19', 'Full Metal Staff', 'w', '0', '0', '22', '0', '0', '4', '0', '0', '1', '1');
INSERT INTO `ff7equip` VALUES('20', 'Striking Staff', 'w', '0', '0', '32', '0', '0', '7', '0', '0', '1', '2');
INSERT INTO `ff7equip` VALUES('21', 'Prism Staff', 'w', '0', '0', '40', '0', '0', '10', '0', '0', '2', '0');
INSERT INTO `ff7equip` VALUES('22', 'Aurora Rod', 'w', '0', '0', '51', '0', '0', '14', '0', '0', '2', '1');
INSERT INTO `ff7equip` VALUES('23', 'Wizard Staff', 'w', '0', '0', '28', '0', '0', '6', '0', '0', '0', '3');
INSERT INTO `ff7equip` VALUES('24', 'Wizer Staff', 'w', '0', '0', '33', '0', '0', '7', '0', '0', '0', '4');
INSERT INTO `ff7equip` VALUES('25', 'Fairy Tale', 'w', '0', '0', '37', '0', '0', '8', '0', '0', '0', '7');
INSERT INTO `ff7equip` VALUES('26', 'Umbrella', 'w', '0', '0', '58', '0', '20', '10', '0', '0', '0', '0');
INSERT INTO `ff7equip` VALUES('27', 'Princess Guard', 'w', '0', '0', '52', '0', '12', '22', '20', '0', '3', '1');

]]> Sun, 01 Nov 2020 14:55:12 +0000 void on The Database Project http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p802 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p802 Red Summon Materia

INSERT INTO `ff7materia` VALUES('22', 'Alexander', 'r', '-5', '5', '0', '0', '0', '1', '1', '0');
INSERT INTO `ff7materia` VALUES('23', 'Bahamut', 'r', '-5', '5', '0', '0', '0', '1', '1', '0');
INSERT INTO `ff7materia` VALUES('24', 'Bahamut ZERO', 'r', '-10', '15', '0', '0', '0', '4', '4', '0');
INSERT INTO `ff7materia` VALUES('25', 'Choco & Mog', 'r', '-2', '2', '0', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('26', 'Hades', 'r', '-10', '15', '0', '0', '0', '4', '4', '0');
INSERT INTO `ff7materia` VALUES('27', 'Ifrit', 'r', '-2', '2', '0', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('28', 'Kjata', 'r', '-5', '5', '0', '0', '0', '1', '1', '0');
INSERT INTO `ff7materia` VALUES('29', 'Knights of the Round', 'r', '-20', '25', '0', '0', '0', '8', '8', '0');
INSERT INTO `ff7materia` VALUES('30', 'Leviathan', 'r', '-5', '5', '0', '0', '0', '1', '1', '0');
INSERT INTO `ff7materia` VALUES('31', 'Master Summon', 'r', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('32', 'Neo Bahamut', 'r', '-10', '10', '0', '0', '0', '2', '2', '0');
INSERT INTO `ff7materia` VALUES('33', 'Odin', 'r', '-5', '5', '0', '0', '0', '1', '1', '0');
INSERT INTO `ff7materia` VALUES('34', 'Phoenix', 'r', '-10', '10', '0', '0', '0', '2', '2', '0');
INSERT INTO `ff7materia` VALUES('35', 'Ramuh', 'r', '-2', '2', '0', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('36', 'Shiva', 'r', '-2', '2', '0', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('37', 'Titan', 'r', '-2', '2', '0', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('38', 'Typhoon', 'r', '-10', '10', '0', '0', '0', '4', '4', '0');

]]> Sun, 01 Nov 2020 14:53:27 +0000 void on The Database Project http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p801 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p801 Green Magic Materia

INSERT INTO `ff7materia` VALUES('1', 'Barrier', 'g', '-5', '5', '-2', '0', '-1', '2', '1', '0');
INSERT INTO `ff7materia` VALUES('2', 'Comet', 'g', '-5', '5', '-2', '0', '-1', '2', '1', '0');
INSERT INTO `ff7materia` VALUES('3', 'Contain', 'g', '-10', '10', '-4', '0', '-2', '4', '2', '0');
INSERT INTO `ff7materia` VALUES('4', 'Earth', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('5', 'Exit', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('6', 'Fire', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('7', 'Full Cure', 'g', '-10', '10', '-4', '0', '-2', '4', '2', '0');
INSERT INTO `ff7materia` VALUES('8', 'Gravity', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('9', 'Heal', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('10', 'Ice', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('11', 'Lightning', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('12', 'Master Magic', 'g', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `ff7materia` VALUES('13', 'Mystify', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('14', 'Poison', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('15', 'Restore', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('16', 'Revive', 'g', '-5', '5', '-2', '0', '-1', '2', '1', '0');
INSERT INTO `ff7materia` VALUES('17', 'Seal', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('18', 'Shield', 'g', '-10', '10', '-4', '0', '-2', '4', '2', '0');
INSERT INTO `ff7materia` VALUES('19', 'Time', 'g', '-5', '5', '-2', '0', '-1', '2', '1', '0');
INSERT INTO `ff7materia` VALUES('20', 'Transform', 'g', '-2', '2', '-1', '0', '0', '1', '0', '0');
INSERT INTO `ff7materia` VALUES('21', 'Ultima', 'g', '-10', '10', '-4', '0', '-2', '4', '2', '0');
]]> Sun, 01 Nov 2020 14:13:33 +0000 dystopia on Profile Project http://dystopiapro.com/fortress14/forum/general-discussion/profile-project/#p800 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/profile-project/#p800 This is mainly a todo list for myself to list and keep track of all the parts that need to be finished for the profiles, and a way to track progress of this for everyone else.

Visual Profile:
———————————–
›› Create template design for profile.
›››› Create images for each player.
›› Slice and prepare visual design for coding
›› Create container to allow choice of profile to view. (On hold for now)
›› Create database structure for materia and equipment information
›› Create database structure for individual players inventory (materia and equipment)
›››› Figure out how to keep track of materia growth in this, and how to render that visually in the inventory box.
›› Code profile and connect it to the profile database.
›› Design and plan badges or awards to go on profiles after chapter completions.
›› Add free stat points(SP) to the design somewhere in the statistics area.

Chimera Engine Migration:
———————————–
›› Finish materia and equipment databases.
›› Integrate the javascript and ajax code for realtime connection to the database into the header.
›› Equipment dialog and parser.
›› Materia dialog and parser.
›››› Figure out how to visualize this dialog, is it drop downs for each slot? How to tag a materia as already equipped so it doesn't appear in the drop downs again in realtime.
›› Inventory dialog and parser.
›› Gil transfer dialog and parser.
›› Dialog and parser for assigning free stat points after a level up.

Chimera Engine Backend UI:
———————————–
›› Migrate existing backend UI to FF7F.
›› Create database table with experience levels.
›› Create database with level up rewards (HP, MP, SP)
›› Build admin tool sets.
›››› Add Item Tool: Inserts chosen item from dropdown menu built from the item database into the player inventory database.
›››› Add Equipment Tool: Same as item tool, except for equipment.
›››› Add Materia Tool: Again, similar tool, just puts the materia in your available database.
›››› New Item Tool: A tool for me to add new items into the item database without having to use SQL.
›››› New Equipment Tool: Same as new item tool, except for equipment.
›››› New Materia Tool: Same as new item and equipment tools but for materia.
›››› Edit Stats Tool: A tool that loads in a players complete stats for me to edit if need be.
›››› Change Equipment Tool: This will be the same as the frontend tool except styled differently and I can edit anyone's equipment.
›››› Change Materia Tool: Same as frontend materia tool, except I can select and user.
›››› Global Options: Toggles for allowing a user to edit their profile or to turn off editing to everyone, invidual toggles for every toolset like to turn off transfers globally or individually, etc. Protections to turn the system on and off if need be.

]]> Sun, 01 Nov 2020 09:17:23 +0000 dystopia on The Database Project http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p799 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/the-database-project/#p799 Alright, so for our profiles to be fully scripted out so that everyone can edit them and see real time stat reflection we're going to need to build up the database for materia and equipment. These are two seperate databases but the SQL code is mostly the same for both in format. We'll need to keep track of the individual IDs for each as they need to be unique and increase by one with each line. I think the best way to do this is for anyone helping just to ignore that integer and leave it blank or at 1 and I'll edit those as I put them in the database. So here's the code. If anyone wants to help, just post how ever many get done and we'll keep going until both databases are finished.

First is materia, the top line being what each of the values are in the database for reference and the block below is some examples.
INSERT INTO `ff7materia` VALUES('id', 'name', 'type', 'hp', 'mp', 'str', 'dex', 'vit', 'mag', 'spr', 'luck');
Type can be: g (green), r (red), b (blue), y (yellow), p (purple)
Stats get no % added to this, that is done when the math in put in place, so just integer or negative integer, as only HP and MP do %

INSERT INTO `ff7materia` VALUES('1', 'Barrier', 'g', '-5', '5', '-2', '0', '-1', '2', '1', '0');
INSERT INTO `ff7materia` VALUES('2', 'Comet', 'g', '-5', '5', '-2', '0', '-1', '2', '1', '0');
--------------------------------------------------------------------------------------------------------------------------

This is for equipment, notice it has two extra values, link and slot at the end.

INSERT INTO `ff7equip` VALUES('id', 'name', 'type', 'hp', 'mp', 'str', 'dex', 'vit', 'mag', 'spr', 'luck', 'link', 'slot');
Type can be: w (weapon), ar (armor), ac (accessory)
Stats get no % added to this, that is done when the math in put in place, so just integer or negative integer, as only HP and MP do %
Link is how many linked Materia slots
Slot is how many single Materia slots

INSERT INTO `ff7equip` VALUES('1', 'Buster Sword', 'w', '0', '0', '18', '0', '0', '2', '0', '0', '1', '0');
INSERT INTO `ff7equip` VALUES('2', Hardedge', 'w', '0', '0', '32', '0', '0', 6', '0', '0', '1', '2');

]]> Sun, 01 Nov 2020 08:47:16 +0000 griff on Table Code http://dystopiapro.com/fortress14/forum/general-discussion/table-code/#p782 General Discussion http://dystopiapro.com/fortress14/forum/general-discussion/table-code/#p782 <tbody>
<tr>
<td style=”background-color: #000000” colspan=”3″><img src=”/wp-content/uploads/2018/11/griff-1.jpg” [In quotes put the banner here] alt=”” /></td>
</tr>
<tr>
<td style=”background-color: #000000” width=”10″> </td>
<td style=”background-color: #000000” width=”520″ align=”center”>Journey Into The Past</td>
<td style=”background-color: #000000” width=”10″> </td>
</tr>
<tr>
<td style=”background-color: #000000” width=”10″>    </td>
<td style=”background-color: #000000” width=”520″ align=”left”> That bullet that hit Alucard's card ricochet off his kevlar pad. Alucard barely flinched as bullet hit the bad, the sides of his grin reaching near his ears, “That almost itched.” Alucard moved his jackal towards the bounty hunter and paused before shooting four bullets towards him. 
<table style=”color: #ffffff;” border=”0″ cellspacing=”0″ cellpadding=”0″ align=”center”>
<tbody>
<tr>
<td style=”background-color: #000000” width=”520″ align=”left”> </td>
</tr>
</tbody>
</table>
 </td>
<td style=”background-color: #000000” width=”10″> </td>
</tr>
<tr>
<td style=”background-color: #000000″ width=”10″> </td>
<td style=”background-color: #000000″ width=”520″ align=”center”>OOC: HP: 103/105 TP: 100/100  Weapon: Katar (2) Jackal (0) Grader (8) Action: Hits: 6 (23; vitals), 5 (14; right arm), 9, 13  Damage: 15 + 6 = 21 Items/Ammo Used: -1 Flash Bang, -8 .45 <a style=”color: #ffffff;” href=”/trigunprojectseeds/forum/general-discussion/map-thread-chapter-vii/” target=”_blank”>Map</a></td>
<td style=”background-color: #000000″ width=”10″> </td>
</tr>
<tr>
<td style=”background-color: #000000″ colspan=”3″ height=”8″> </td>
</tr>
</tbody>
</table>
]]> Wed, 20 May 2020 17:08:53 +0000