[Release] Flexable Database Editor V3!

[Kiev]

Your welcome Maxime. If there is anything you would like added, then please do say!

[chubbs1900]

I believe this is the error everyone is fussing about.



http://soilondown.com/FDE-Error255.jpg

This one occurred when I took an existing item ( Relentless Gladiator's Longblade ) and I gave it id# 80500 and named it Relentless Gladiator's Longbladev2 ..

Any ideas?

[Kiev]

I am aware, and currently doing my best to fix this.

Give me about 2 hours, and i will hopefully do it

[Found]

Huge repost, but since this thing is so damn amazing it makes up for it.

[Kiev]

Update is complete - Error has been fixed and done.

@L0st - Have you seen a updated version? This is my own updated version, taken the source from 2.0.0 version, and made compatible and fixing errors for 3.0, So please, do tell me how its a repost? You obviously skim read and expect this to be the same program from ages ago, thats judging from how you reply to all threads with a sly comment like you dont actually read it. Sorry if im wrong, but you give that impression.

Updated first post with new link.

[Valmere]

There's a problem with adding items with stats to the DB. While it adds the item in smoothly, it doesn't calculate the stat count (how many stats you're adding to the item) and set `itemstatcount` accordingly.

[Kiev]

Could you please explain what you mean? Thanks

[Valmere]

Could you please explain what you mean? Thanks

UPDATE `items` SET `entry` = '70000', `class` = '2', `subclass` = '8', `field4` = '-1', `name1` = 'Test Item', `displayid` = '46609', `quality` = '6', `flags` = '36864', `faction` = '0', `buyprice` = '0', `sellprice` = '0', `inventorytype` = '17', `allowableclass` = '-1', `allowablerace` = '-1', `itemlevel` = '999', `requiredlevel` = '0', `RequiredSkill` = '0', `RequiredSkillRank` = '0', `RequiredSpell` = '0', `RequiredPlayerRank1` = '0', `RequiredPlayerRank2` = '0', `RequiredFaction` = '0', `RequiredFactionStanding` = '0', `Unique` = '1', `maxcount` = '1', `ContainerSlots` = '0', `itemstatscount` = '0', `stat_type1` = '19', `stat_value1` = '1000', `stat_type2` = '28', `stat_value2` = '1000', `stat_type3` = '31', `stat_value3` = '1000', `stat_type4` = '44', `stat_value4` = '1000', `stat_type5` = '37', `stat_value5` = '1000', `stat_type6` = '0', `stat_value6` = '0', `stat_type7` = '0', `stat_value7` = '0', `stat_type8` = '0', `stat_value8` = '0', `stat_type9` = '0', `stat_value9` = '0', `stat_type10` = '0', `stat_value10` = '0', `ScaledStatsDistributionId` = '0', `ScaledStatsDistributionFlags` = '0', `dmg_min1` = '9000', `dmg_max1` = '9002', `dmg_type1` = '0', `dmg_min2` = '0', `dmg_max2` = '0', `dmg_type2` = '0', `armor` = '0', `holy_res` = '1000', `fire_res` = '1000', `nature_res` = '1000', `frost_res` = '1000', `shadow_res` = '1000', `arcane_res` = '1000', `delay` = '1000', `ammo_type` = '0', `range` = '0', `spellid_1` = '42094', `spelltrigger_1` = '1', `spellcharges_1` = '0', `spellcooldown_1` = '-1', `spellcategory_1` = '0', `spellcategorycooldown_1` = '-1', `spellid_2` = '0', `spelltrigger_2` = '1', `spellcharges_2` = '0', `spellcooldown_2` = '-1', `spellcategory_2` = '0', `spellcategorycooldown_2` = '-1', `spellid_3` = '0', `spelltrigger_3` = '1', `spellcharges_3` = '0', `spellcooldown_3` = '-1', `spellcategory_3` = '0', `spellcategorycooldown_3` = '-1', `spellid_4` = '0', `spelltrigger_4` = '0', `spellcharges_4` = '0', `spellcooldown_4` = '-1', `spellcategory_4` = '0', `spellcategorycooldown_4` = '-1', `spellid_5` = '0', `spelltrigger_5` = '0', `spellcharges_5` = '0', `spellcooldown_5` = '-1', `spellcategory_5` = '0', `spellcategorycooldown_5` = '-1', `bonding` = '1', `description` = 'Showing that it doesnt put itemstatcount', `page_id` = '0', `page_language` = '0', `page_material` = '0', `quest_id` = '0', `lock_id` = '0', `lock_material` = '0', `sheathID` = '1', `randomprop` = '0', `randomsuffix` = '0', `block` = '0', `itemset` = '0', `MaxDurability` = '0', `ZoneNameID` = '0', `mapid` = '0', `bagfamily` = '0', `TotemCategory` = '0', `socket_color_1` = '1', `unk201_3` = '0', `socket_color_2` = '1', `unk201_5` = '0', `socket_color_3` = '1', `unk201_7` = '0', `socket_bonus` = '3154', `GemProperties` = '0', `ReqDisenchantSkill` = '-1', `ArmorDamageModifier` = '0', `ExistingDuration` = '0', `ItemLimitCategoryId` = '0', `HolidayId` = '0' WHERE `entry` = 70000 LIMIT 1;

This is a test SQL query for adding an item into an ArcEmu Database exported by the latest version of FDE. The item has 5 different stat types. However, none of them show up on the item in-game because the program doesn't set this part of the query:

`itemstatscount` = '0'

It should read:

`itemstatscount` = '5'

Because the item has 5 different stat types on it.

Hope you can fix this one too

[Kiev]

Ahhh i see now. Thats going to be something quite alot harder to fix... It does seem to show up though, or atleast, did on a week old rev?

[Valmere]

No idea, I've never used this until now. Since there's a max of 10 stat values you can set, couldn't you have it do a check to see how many of the values are set to 0 and subtract that from 10?

Custom item 1 has 6 stat values set greater than or equal to 1. Program looks through the 10 stat values, counts how many are equal to 0 (which would be 4) and subtracts that from 10 and sets the itemstatcount to the number it gets (6).

Or just add a field in so the user can tell the thing what the statcount is :P

[Found]

@kiev I downloaded it ty, just so many posts about FDE

[Kiev]

@Valmere, Im not sure if its even needed to be used, if you could test it and report back telling me if it is nesicarry to add this support? Thanks .

@L0st - There is indeed, most of them died down though, im not going to let this one (:

[Valmere]

The first pic shows an item that has itemstatcount set to 0, and the second pic shows itemstatcount set to the amount of stat modifiers (5) with the same item (just a different ID).

protip: Full Onslaught set + dw Frostmourne models + Tabard of the Void = sexy time

[Kiev]

Aha - Thank you, I will get onto doing a fix for this now.

Thank you for pointing that out to me!

[Kiev]

Applied a update... Not working as i would have liked it to, but its all i can get working for the moment - Check front post!