Datenbankerweiterung !

[d0xs]

Ich wäre dafür alles was ihr für eure Datenbank habt
Ich fang mal an

INSERT INTO `data_item` (`id`, `name`, `price`, `atkspeed`, `type3`, `abilitymin`, `abilitymax`, `limitlevel1`, `endurance`, `handed`, `job`, `gender`, `destParam1`, `adjParamLevel1`, `adjParamValue1`, `destParam2`, `adjParamLevel2`, `adjParamValue2`, `packMax`, `atkRange`, `sfxObj`, `sfxObj2`, `sfxObj3`, `sfxObj4`, `sfxObj5`, `chgParamValue1`, `chgParamValue2`, `useable`, `linkKind`, `skillTime`, `circleTime`, `textFile`, `destParam3`, `adjParamValue3`, `chgParamValue3`, `referStat1`, `fuelRe`, `activeSkill`, `activeSkillLvl`, `activeSkillPer`, `skillReadyType`, `skillReady`, `type1`, `type2`, `parts`, `partSub`, `itemLvl`, `itemRare`, `flightspeed`, `referTarget1`, `referValue1`, `referTarget2`, `referValue2`, `useMotion`, `skillRange`, `flyff_version`) VALUES
(22427, 'Noctis Suit (M)', 0, 0, 18, 1, 100, 120, 100, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11),
(22426, 'Noctis Helmet (M)', 0, 0, 17, 1, 100, 120, 100, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11),
(22372, 'Ultimate Bloody Sword', 0, 100, 2, 1, 100, 120, 100, 1, 7, 2, 999, 999, 999, 999, 999, 999, 999, 999999, 1, 2, 3, 1, 2, 1, 1, 0, 0, 0, 0, 0, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 999, 999, 999, 999, 0, 0, 11),
(22428, 'Noctis Gauntlet (M)', 0, 0, 19, 1, 100, 120, 100, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11),
(22429, 'Noctis Boots (M)', 0, 0, 20, 1, 100, 120, 100, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11),
(16324, 'Snowman Shoes (M)', 0, 0, 23, 1, 100, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11),
(16323, 'Snowman Gloves (M)', 0, 0, 58, 1, 100, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11),
(16322, 'Snowman Suit (M)', 0, 0, 57, 1, 100, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11),
(26354, 'Cactus Hair (M) Silver', 0, 0, 21, 1, 100, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11),
(4436, 'Sunglasses (White)', 0, 0, 22, 1, 100, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11),
(26593, 'Meteo Bike(Green)', 0, 0, 40, 0, 0, 30, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 0, 0, 0, 0, 11),
(26592, 'Meteo Bike(Red)', 0, 0, 40, 0, 0, 30, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 0, 0, 0, 0, 11),
(26591, 'Meteo Bike(Yellow)', 0, 0, 40, 0, 0, 30, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 0, 0, 0, 0, 11),
(30114, 'Riding Cloud (Orange)', 0, 0, 40, 0, 0, 30, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 0, 0, 0, 0, 11),
(30502, 'Tamed Meteonyker', 0, 0, 40, 0, 0, 30, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 0, 0, 0, 0, 11),
(30120, 'Tiger Board S', 0, 0, 40, 0, 0, 30, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 0, 0, 0, 0, 11);

INSERT INTO `data_itemsets` (`id`, `itemid1`, `itemid2`, `itemid3`, `itemid4`, `abilityType1`, `abilityValue1`, `partCount1`, `abilityType2`, `abilityValue2`, `partCount2`, `abilityType3`, `abilityValue3`, `partCount3`, `abilityType4`, `abilityValue4`, `partCount4`, `abilityType5`, `abilityValue5`, `partCount5`, `abilityType6`, `abilityValue6`, `partCount6`, `abilityType7`, `abilityValue7`, `partCount7`) VALUES
(1, 22426, 22427, 22428, 22429, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(2, 22450, 22451, 22452, 22453, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Das einzige was Funktioniert ist Ultimate Bloody Sword !

credits an schrumpfnudel

[Vulcanraven]

Einfach den Inhalt kopieren und auf eurer Datenbank ein Rechtsklick machen.

Dann sieht man schon "Console"



Klickt dort drauf und fügt euren Text wie hier mit STRG + V einfach ein.

Sieht da natürlich anders aus

Dannach drückt ihr ENTER

#closed