Encountered error in Spell Editor

[Zcoretri]

John,
Playing with the spell editor this morning I got this when trying to add a new tier

Code: Select all

Error Code: 0

INSERT INTO spell_tiers (`spell_id`, `tier`, `hp_req`, `hp_req_percent`, `hp_upkeep`, `power_req`, `power_req_percent`, `power_upkeep`, `savagery_req`, `savagery_req_percent`, `savagery_upkeep`, `dissonance_req`, `dissonance_req_percent`, `dissonance_upkeep`, `req_concentration`, `cast_time`, `recovery`, `recast`, `radius`, `max_aoe_targets`, `min_range`, `range`, `duration1`, `duration2`, `resistibility`, `hit_bonus`, `call_frequency`, `unknown9`) select `spell_id`, `4`, `hp_req`, `hp_req_percent`, `hp_upkeep`, `power_req`, `power_req_percent`, `power_upkeep`, `savagery_req`, `savagery_req_percent`, `savagery_upkeep`, `dissonance_req`, `dissonance_req_percent`, `dissonance_upkeep`, `req_concentration`, `cast_time`, `recovery`, `recast`, `radius`, `max_aoe_targets`, `min_range`, `range`, `duration1`, `duration2`, `resistibility`, `hit_bonus`, `call_frequency`, `unknown9` FROM spell_tiers WHERE id = 40224;

[John Adams]

Fixed. Mistakenly used the wrong tick marks on the new tier value:

Code: Select all

select `spell_id`, `4`, ...

Back-ticks are column names. Should have been '4' (single quote).

I thought we weren't going to add data missing from SOE API?

[Zcoretri]

Fixed. Mistakenly used the wrong tick marks on the new tier value:

Code: Select all

select `spell_id`, `4`, ...

Back-ticks are column names. Should have been '4' (single quote).

I thought we weren't going to add data missing from SOE API?

We are not, I finally realized that this spell is only one tier after encountering the error.

[John Adams]

Ahh, you can always use the icon to see the SOE JML, when in doubt. So far though, aside from mis-classifications, I have found nothing missing from SOE API data and our local spells.