This seems like a workaround... which still didn't fix the problem for me. (I had tried this already).This has been around for a long time in dol (years), it has to do with the Spells IconID being correct, but EffectID being wrong, best bet is to just set the EffectID as the same value as the IconID
Fix : Song Internal ID trouble using a custom properties in spells Param.
Update : Any Spell DB object can now contains a "JSON" formated dictionary of string containing list of string
This can be used through spell : T GetParamValue<T>(string key), IList<T> GetParamValues<T>(string key)
The default first usage is :
public ushort InternalIconID
{
get
{
return GetParamValue<ushort>("InternalIconID");
}
}
Type T can be anything numeric or string (any object that can be converted to string using .ToString(), and loaded through Convert.ChangeType()...)
Needed MYSQL update for those using LIVE Song Id's !!
UPDATE spell SET `Params` = CONCAT_WS(`Icon`, '{"InternalIconID":["', '"]}'), `Icon` = `ClientEffect` WHERE `InstrumentRequirement` > 0 AND `Params` IS NULL;
public ushort Icon
{
get
{
if (m_handler != null && m_handler.Spell != null)
return m_handler.Spell.ClientEffect;
else
return 0;
}
}
public ushort Icon
{
get
{
if (m_handler != null && m_handler.Spell != null)
return m_handler.Spell.Icon;
else
return 0;
}
}
CREATE TABLE IF NOT EXISTS `spellxcustomvalues` (
`SpellXCustomValuesID` int(11) NOT NULL AUTO_INCREMENT,
`KeyName` varchar(100) NOT NULL,
`Value` varchar(255) DEFAULT NULL,
`LastTimeRowUpdated` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`SpellID` int(11) NOT NULL,
PRIMARY KEY (`SpellXCustomValuesID`),
KEY `KeyName` (`KeyName`),
KEY `SpellID` (`SpellID`)
);
--
-- Content
--
REPLACE INTO `spellxcustomvalues` (`SpellXCustomValuesID`, `KeyName`, `Value`, `LastTimeRowUpdated`, `SpellID`) VALUES
(1, 'InternalIconID', '1374', '2000-01-01 00:00:00', 1118),
(2, 'InternalIconID', '929', '2000-01-01 00:00:00', 1175),
(3, 'InternalIconID', '1372', '2000-01-01 00:00:00', 1116),
(4, 'InternalIconID', '1461', '2000-01-01 00:00:00', 5172),
(5, 'InternalIconID', '1461', '2000-01-01 00:00:00', 1122),
(6, 'InternalIconID', '827', '2000-01-01 00:00:00', 4973),
(7, 'InternalIconID', '1541', '2000-01-01 00:00:00', 5162),
(8, 'InternalIconID', '925', '2000-01-01 00:00:00', 1171),
(9, 'InternalIconID', '322', '2000-01-01 00:00:00', 5153),
(10, 'InternalIconID', '1462', '2000-01-01 00:00:00', 5173),
(11, 'InternalIconID', '1373', '2000-01-01 00:00:00', 1117),
(12, 'InternalIconID', '1371', '2000-01-01 00:00:00', 1115),
(13, 'InternalIconID', '322', '2000-01-01 00:00:00', 1103),
(14, 'InternalIconID', '1463', '2000-01-01 00:00:00', 5174),
(15, 'InternalIconID', '324', '2000-01-01 00:00:00', 1105),
(16, 'InternalIconID', '321', '2000-01-01 00:00:00', 1102),
(17, 'InternalIconID', '1370', '2000-01-01 00:00:00', 1113),
(18, 'InternalIconID', '323', '2000-01-01 00:00:00', 1104),
(19, 'InternalIconID', '1464', '2000-01-01 00:00:00', 5175),
(20, 'InternalIconID', '1464', '2000-01-01 00:00:00', 1125),
(21, 'InternalIconID', '926', '2000-01-01 00:00:00', 1172),
(22, 'InternalIconID', '928', '2000-01-01 00:00:00', 1174),
(23, 'InternalIconID', '1460', '2000-01-01 00:00:00', 5171),
(24, 'InternalIconID', '826', '2000-01-01 00:00:00', 4972),
(25, 'InternalIconID', '828', '2000-01-01 00:00:00', 4974),
(26, 'InternalIconID', '323', '2000-01-01 00:00:00', 5154),
(27, 'InternalIconID', '1370', '2000-01-01 00:00:00', 1112),
(28, 'InternalIconID', '321', '2000-01-01 00:00:00', 5152),
(29, 'InternalIconID', '1462', '2000-01-01 00:00:00', 1123),
(30, 'InternalIconID', '324', '2000-01-01 00:00:00', 5155),
(31, 'InternalIconID', '320', '2000-01-01 00:00:00', 1101),
(32, 'InternalIconID', '1370', '2000-01-01 00:00:00', 1111),
(33, 'InternalIconID', '1371', '2000-01-01 00:00:00', 1114),
(34, 'InternalIconID', '927', '2000-01-01 00:00:00', 1173),
(35, 'InternalIconID', '1460', '2000-01-01 00:00:00', 1121),
(36, 'InternalIconID', '1542', '2000-01-01 00:00:00', 5163),
(37, 'InternalIconID', '1463', '2000-01-01 00:00:00', 1124),
(38, 'InternalIconID', '320', '2000-01-01 00:00:00', 5151),
(39, 'InternalIconID', '825', '2000-01-01 00:00:00', 4971),
(40, 'InternalIconID', '1544', '2000-01-01 00:00:00', 5165),
(41, 'InternalIconID', '829', '2000-01-01 00:00:00', 4975),
(42, 'InternalIconID', '1540', '2000-01-01 00:00:00', 5161),
(43, 'InternalIconID', '1543', '2000-01-01 00:00:00', 5164);
Users browsing this forum: No registered users and 1 guest