Fix/Update items etc

[ninjistix]

hello good evening, i'm bored as hell and would like to do some work to help contribute to the project,

i would like to re-do and reorganize the items _armor,weapon,mods and maybe even the latents,

i was told that there might be issues with adding the gear 76-99 because the core project's lack of content and that is understandable, even so i would like to do so and with that being said i would like some assistance in learning where some of the values come from

-- ----------------------------
-- Table structure for item_armor
-- ----------------------------

Code: Select all

DROP TABLE IF EXISTS `item_armor`;
CREATE TABLE `item_armor` (
  `itemId` smallint(5) unsigned NOT NULL DEFAULT '0',
  `name` tinytext,
  `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `jobs` int(10) unsigned NOT NULL DEFAULT '0',
  `MId` smallint(3) unsigned NOT NULL DEFAULT '0',
  `shieldSize` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `scriptType` smallint(5) unsigned NOT NULL DEFAULT '0',
  `slot` smallint(5) unsigned NOT NULL DEFAULT '0',
  `rslot` tinyint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`itemId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=37 PACK_KEYS=1 CHECKSUM=1;

Where would i find the Vales for jobs/MId/shieldsize/scripttype/slot/rslot?

-- ----------------------------
-- Table structure for item_weapon
-- ----------------------------

Code: Select all

DROP TABLE IF EXISTS `item_weapon`;
CREATE TABLE `item_weapon` (
  `itemId` smallint(5) unsigned NOT NULL DEFAULT '0',
  `name` text,
  `skill` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `subskill` tinyint(2) NOT NULL DEFAULT '0',
  `dmgType` int(10) unsigned NOT NULL DEFAULT '0',
  `hit` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `delay` int(10) NOT NULL DEFAULT '0',
  `dmg` int(10) unsigned NOT NULL DEFAULT '0',
  `unlock_index` tinyint(1) NOT NULL,
  PRIMARY KEY (`itemId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=54 PACK_KEYS=1 CHECKSUM=1;

where would i find the vales for skill/subskill/dmgtype/hit/unlock_index

and lastly I do not understand the latents, but I'm sure I can have someone help me with that... any sort of help/guidance would be greatly appreciated.

Weapons
Hand to Hand
Daggers
Swords
Great Swords
Axes
Great Axes
Scythes
Polearms
Katana
Great Katana
Clubs
Staves
Ranged
Instruments
Ammo&Misc
Pet Items
Fishing Gear
Ammunition
Grips

Armor
Shields
Head
Neck
Body
Hands
Waist
Legs
Feet
Back
Earrings
Rings
^^^^^ is the template i plan to use to sort and organize the gear in the sql files.

status update 3 (i guess)
Completed Hand to hand, Dagger, Sword, GreatSwords, Axes, Great Axes, Scythes, Polearm, Katana, Great Katana, Clubs, Staves

NOTE: this file is incomplete since it is being done from scratch... it only has my completed progress for item_weapon.sql

[Delaide]

I would recommend going to https://wiki.dspt.info/index.php first. For example, the MId is at https://wiki.dspt.info/index.php/Weapon_mID

[ninjistix]

well i guess now i have more reading to go do, instead of working on something thats gonna take me a long time to finish, thanks


edit: found what i was looking for thanks, now to get to work

edit2: just saw that in the dsp item_weapon.sql they added 3 new values, anyone know where i can find the values for that

`ilvl_skill` smallint(3) NOT NULL DEFAULT '0',
`ilvl_parry` smallint(3) NOT NULL DEFAULT '0',
`ilvl_macc` smallint(3) NOT NULL DEFAULT '0',

[kjLotus]

it's only for weapons that have an item level - it's the "special" weapon skill, parry skill and magic accuracy values on them

[ninjistix]

how is the delay for the weapons calculated? because if its whats listed on the weapon, the values in the sql are wrong? or off... well looking at hand-to-hand.. atm

[Desufire]

how is the delay for the weapons calculated? because if its whats listed on the weapon, the values in the sql are wrong? or off... well looking at hand-to-hand.. atm

H2H doesn't follow other weapon delay rules. H2H takes the characters base delay then adds the +XX to that.

[ninjistix]

how is the delay for the weapons calculated? because if its whats listed on the weapon, the values in the sql are wrong? or off... well looking at hand-to-hand.. atm

H2H doesn't follow other weapon delay rules. H2H takes the characters base delay then adds the +XX to that.

kjLotus explained that h2h is 480+ whatever is on the weapon, that being said some of the vales in the current table are wrong, because no value should be less than 480, but the are quite a few @200-300