› forum.index « FFvii Fortress v14

Affiliates

( Chapter I: Connections ) ~ Discussion about the RP can be found ( Here ) ~ Battle Tools ( Here ) ~ Our Discord ( Chat )

Current User: Guest	Login Register
Please consider registering

Home Forums General Discussion The Database Project

The Database Project

Add a New Topic

Reply to Post

Page: 1

User

Post

8:47 am
November 1, 2020

dystopia

Admin

posts 180

Quote and Reply

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');

2:13 pm
November 1, 2020

void

Member

posts 105

Quote and Reply

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');

2:53 pm
November 1, 2020

void

Member

posts 105

Quote and Reply

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');

2:55 pm
November 1, 2020

dystopia

Admin

posts 180

Quote and Reply

Post edited 10:08 pm – November 1, 2020 by dystopia

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');

9:05 pm
November 1, 2020

void

Member

posts 105

Quote and Reply

Post edited 4:41 am – November 2, 2020 by void

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');

6:54 am
November 3, 2020

void

Member

posts 105

Quote and Reply

Post edited 1:54 pm – November 3, 2020 by void

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.

12:41 pm
November 3, 2020

dystopia

Admin

posts 180

Quote and Reply

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');

10:51 pm
November 3, 2020

void

Member

posts 105

Quote and Reply

Post edited 6:00 am – November 4, 2020 by void

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');

8:37 pm
November 4, 2020

void

Member

posts 105

Quote and Reply

Post edited 3:40 am – November 5, 2020 by void

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');

Page: 1

Reply to Post

Reply to Topic: The Database Project

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Topic Reply: