Hey, awhile back I made a query to grab stuff from PEQ's (or any EQ db I guess) spells_new table and shove it into spells so that browser thing can use them, since I couldn't get the spells_us.txt importer thing to work. Probably would have been easier to rewrite the PHP, but eh. Might come in useful for you.
Quote:
insert into spells (spellid, name, castonyou, castonother, fading, `range`, aoerange, mana, casttime, recoverytime, recasttime, buffformula, buffduration, aoeduration, targettype, resist, resist_adjust, skill, buff1, buff2, buff3, buff4, buff5, buff6, buff7, buff8, buff9, buff10, buff11, buff12, buff1val, buff2val, buff3val, buff4val, buff5val, buff6val, buff7val, buff8val, buff9val, buff10val, buff11val, buff12val, buff1form, buff2form, buff3form, buff4form, buff5form, buff6form, buff7form, buff8form, buff9form, buff10form, buff11form, buff12form, buff1max, buff2max, buff3max, buff4max, buff5max, buff6max, buff7max, buff8max, buff9max, buff10max, buff11max, buff12max, level1, level2, level3, level4, level5, level6, level7, level8, level9, level10, level11, level12, level13, level14, level15, level16, regent1_id, regent2_id, regent3_id, regent4_id, regent1_count, regent2_count, regent3_count, regent4_count, timeofday)
select spells_new.id, spells_new.name, spells_new.cast_on_you, spells_new.cast_on_other, spells_new.spell_fades, spells_new.`range`, spells_new.aoerange, spells_new.mana, spells_new.cast_time, spells_new.recovery_time, spells_new.recast_time, spells_new.buffdurationformula, spells_new.buffduration, spells_new.AEDuration, spells_new.targettype, spells_new.resisttype, spells_new.ResistDiff, spells_new.skill, spells_new.effectid1, spells_new.effectid2, spells_new.effectid3, spells_new.effectid4, spells_new.effectid5, spells_new.effectid6, spells_new.effectid7, spells_new.effectid8, spells_new.effectid9, spells_new.effectid10, spells_new.effectid11, spells_new.effectid12, spells_new.effect_base_value1, spells_new.effect_base_value2, spells_new.effect_base_value3, spells_new.effect_base_value4, spells_new.effect_base_value5, spells_new.effect_base_value6, spells_new.effect_base_value7, spells_new.effect_base_value8, spells_new.effect_base_value9, spells_new.effect_base_value10, spells_new.effect_base_value11, spells_new.effect_base_value12, spells_new.formula1, spells_new.formula2, spells_new.formula3, spells_new.formula4, spells_new.formula5, spells_new.formula6, spells_new.formula7, spells_new.formula8, spells_new.formula9, spells_new.formula10, spells_new.formula11, spells_new.formula12, spells_new.max1, spells_new.max2, spells_new.max3, spells_new.max4, spells_new.max5, spells_new.max6, spells_new.max7, spells_new.max8, spells_new.max9, spells_new.max10, spells_new.max11, spells_new.max12, spells_new.classes1, spells_new.classes2, spells_new.classes3, spells_new.classes4, spells_new.classes5, spells_new.classes6, spells_new.classes7, spells_new.classes8, spells_new.classes9, spells_new.classes10, spells_new.classes11, spells_new.classes12, spells_new.classes13, spells_new.classes14, spells_new.classes15, spells_new.classes16, spells_new.components1, spells_new.components2, spells_new.components3, spells_new.components4, spells_new.component_counts1, spells_new.component_counts2, spells_new.component_counts3, spells_new.component_counts4, spells_new.TimeOfDay
from spells_new;
update spells, spells_new set spells.petname = spells_new.teleport_zone where spells.spellid = spells_new.id and exists (select * from pets where pets.type = spells_new.teleport_zone);
|
And sorry for table breaking, dear god that is a long query.
Last edited by trevius; 02-06-2012 at 05:02 AM..
|
Threaded Mode
