Datenbankerweiterung !

09/07/2008 11:03 d0xs#1
Ich wäre dafür alles was ihr für eure Datenbank habt
Ich fang mal an
Code:
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
09/07/2008 11:05 Vulcanraven#2
Einfach den Inhalt kopieren und auf eurer Datenbank ein Rechtsklick machen.

Dann sieht man schon "Console"

[Only registered and activated users can see links. Click Here To Register...]

Klickt dort drauf und fügt euren Text wie hier mit STRG + V einfach ein.
[Only registered and activated users can see links. Click Here To Register...]
Sieht da natürlich anders aus :)

Dannach drückt ihr ENTER

#closed