spletli se, nebo ne ??? mangos 3655_quest_template.sql

[robby 0]

pre tych co tomu nerozumeju:

cudujem sa velmi ze pomazali polia (`RequiredClass`, `RequiredSkill`), ved sa vyuzivali na rozlisenie class kvestov a ucenie novych skill_rankov ako napr treba mat skill 225 na kvest artisana

cele to vypada ako omyl, preotze je to odflaknute aj tym ze zabudli zmazat dalsie pole s `RequiredSkillValue` ktore bolo zavisle na uz zmazanom poli `RequiredSkill`

 

takze pokial niekto tomu rozumie a vie ako sa tieto veci po novom vyhodnocuju, plz pochvalte sa

 

its a mistake or not ??? - mangos 3655_quest_template.sql

mangos make this changes in rev. 3655, but i wonder WHY ???

 

ALTER TABLE `quest_template`
ADD COLUMN `SuggestedPlayers` int(11) unsigned NOT NULL DEFAULT 0 AFTER `RequiredRepValue`,
DROP COLUMN `RequiredClass`,
DROP COLUMN `RequiredSkill`;

 

DROP COLUMN `RequiredClass` (before update are 871 q class req.)

DROP COLUMN `RequiredSkill` (is needed for some type of q like artisan q and even if this field is deleted in table is still RequiredSkillValue)

 

i dont think that these fields (`RequiredClass`, `RequiredSkill`) are no more necessary, if someone know more about this, plz explain, thx

Edited May 22, 2007 by robby

[bLuma 225]

Nespletli. tyto pole se sloučili do pole ZoneOrSort, viz https://svn.mangosproject.org/trac/MaNGOS/changeset/3655

 

A příslušný update před odstraněním polí RequiredClass a RequiredSkill:

UPDATE `quest_template` SET `ZoneOrSort` =  -61 WHERE `ZoneOrSort` = 0  AND `RequiredClass` =  9;
UPDATE `quest_template` SET `ZoneOrSort` =  -81 WHERE `ZoneOrSort` = 0  AND `RequiredClass` =  1;
UPDATE `quest_template` SET `ZoneOrSort` =  -82 WHERE `ZoneOrSort` = 0  AND `RequiredClass` =  7;
UPDATE `quest_template` SET `ZoneOrSort` = -141 WHERE `ZoneOrSort` = 0  AND `RequiredClass` =  2;
UPDATE `quest_template` SET `ZoneOrSort` = -161 WHERE `ZoneOrSort` = 0  AND `RequiredClass` =  8;
UPDATE `quest_template` SET `ZoneOrSort` = -162 WHERE `ZoneOrSort` = 0  AND `RequiredClass` =  4;
UPDATE `quest_template` SET `ZoneOrSort` = -261 WHERE `ZoneOrSort` = 0  AND `RequiredClass` =  3;
UPDATE `quest_template` SET `ZoneOrSort` = -262 WHERE `ZoneOrSort` = 0  AND `RequiredClass` =  5;
UPDATE `quest_template` SET `ZoneOrSort` = -263 WHERE `ZoneOrSort` = 0  AND `RequiredClass` = 11;

UPDATE `quest_template` SET `ZoneOrSort` =  -24 WHERE `ZoneOrSort` = 0  AND `RequiredSkill` = 182;
UPDATE `quest_template` SET `ZoneOrSort` = -101 WHERE `ZoneOrSort` = 0  AND `RequiredSkill` = 356;
UPDATE `quest_template` SET `ZoneOrSort` = -121 WHERE `ZoneOrSort` = 0  AND `RequiredSkill` = 164;
UPDATE `quest_template` SET `ZoneOrSort` = -181 WHERE `ZoneOrSort` = 0  AND `RequiredSkill` = 171;
UPDATE `quest_template` SET `ZoneOrSort` = -182 WHERE `ZoneOrSort` = 0  AND `RequiredSkill` = 165;
UPDATE `quest_template` SET `ZoneOrSort` = -201 WHERE `ZoneOrSort` = 0  AND `RequiredSkill` = 202;
UPDATE `quest_template` SET `ZoneOrSort` = -264 WHERE `ZoneOrSort` = 0  AND `RequiredSkill` = 197;
UPDATE `quest_template` SET `ZoneOrSort` = -304 WHERE `ZoneOrSort` = 0  AND `RequiredSkill` = 185;
UPDATE `quest_template` SET `ZoneOrSort` = -324 WHERE `ZoneOrSort` = 0  AND `RequiredSkill` = 129;

[robby 0]

Nespletli. tyto pole se sloučili do pole ZoneOrSort, viz https://svn.mangosproject.org/trac/MaNGOS/changeset/3655

 

A příslušný update před odstraněním polí RequiredClass a RequiredSkill:

UPDATE `quest_template` SET `ZoneOrSort` =  -61 WHERE `ZoneOrSort` = 0  AND `RequiredClass` =  9;
...
UPDATE `quest_template` SET `ZoneOrSort` = -324 WHERE `ZoneOrSort` = 0  AND `RequiredSkill` = 129;

 

diki, tak mozna exe nefunguju ako maju, pretoze tam kde bol sedy vykricnik sa po zvyseni lvl nezmenil na zlaty ale zmizol uplne a to pri viacej kvestoch ktore predtym isli

inak som pisal dalej

 

http://wow.allakhazam.com/db/quest.html?wquest=6609

 

on lvl 42 -> Quest: I Got Nothin' Left! (Fishing): gray "!" after reached quest lvl 45-> Grimnur Stonebrand: no gray "!", no yellow "!" over his head.

tento kvest dopadol tak ze bol sedy vykricnik na lvl 42 a ked chalan dosiahol kvest lvl 45, tak uz nebol sedy a nebol zlaty, vykricnik aj kvest zmizol uplne, uz sa nezobrazuje ani nenuka

Edited May 22, 2007 by robby