SQL Updaty [updates; in developing]

[kupkoid 288]

SQL updaty pro DB MaNGOSu. Díky ApoCovi za jeho trpělivost.

 

17.8.2007

Updaty na pastebinu mají místo creature_template různé tabulky. Upravte si je před nahrávním!

 

crash fixy:

update creature_template set maxhealth = minhealth where maxhealth=0 and minhealth > 0;
update creature_template set mindmg = maxdmg where maxdmg=0 and mindmg > 0;
update creature_template set baseattacktime=1600 where baseattacktime=0;

Botanica:

http://pastebin.ca/661725

Deadmines:

http://pastebin.ca/661727

Ramparts:

http://pastebin.ca/661728

Mágové:

http://pastebin.ca/661731

Naxx:

http://pastebin.ca/661732

Steamvault:

http://pastebin.ca/661737

Warloci:

http://pastebin.ca/661739

Záchodky:

http://pastebin.ca/661740

 

19.8.2007

Všehochuť:

update creature_template set spell1=20170, spell2=15793, spell3=0 where family=4;
update creature_template set spell1=20170, spell2=0, spell3=0 where family=5;
update creature_template set spell1=36839, spell2=0, maxhealth=floor(maxhealth * (2/3)), minhealth=floor(minhealth * (2/3)) where family=24;

Kočky:

http://pastebin.ca/663409

 

20.8.2007

update creature_template set spell1=13482 where name='Crazed Dragonhawk';
update creature_template set minhealth=280, maxhealth=310, mindmg=45, maxdmg=54 where name='Risen Hungerer';
update creature_template set minhealth=1000, maxhealth=1200, mindmg=44, maxdmg=68 where name='Steelsnap';

 

23.8.2007

update creature_template set mingold=500000, maxgold=1000000 where minlevel < 70 and rank=3;
update creature_template set mingold=1000000, maxgold=2000000 where minlevel >= 70 and rank=3;

 

24.8.2007

update npc_trainer set spellcost=8000000 where spell=34092;
update creature_loot_template set ChanceOrRef=0.2 where item=7554 and ChanceOrRef > 0.2;

 

27.8.2007

insert into creature_loot_template (entry, item, ChanceOrRef, QuestChanceOrGroup, maxcount, quest_freeforall) values (20514, 22574, 26, 0, 2, 0);

 

29.8.2007

Black Temple (spelly, dmg, není hotov):

http://pastebin.ca/674643 - v0.1

 

30.8.2007

UPDATE `creature_template` SET `mindmg`='4000',`maxdmg`='5000',`baseattacktime`='1500' WHERE (`entry`='18832');
UPDATE `creature_template` SET `mindmg`='4000',`maxdmg`='5000',`baseattacktime`='1500' WHERE (`entry`='18834');
UPDATE `creature_template` SET `mindmg`='3000',`maxdmg`='4000',`baseattacktime`='1500' WHERE (`entry`='18835');
UPDATE `creature_template` SET `mindmg`='4000',`maxdmg`='5000',`baseattacktime`='1500' WHERE (`entry`='18836');
update creature_template set minlevel=73, maxlevel=73 where minlevel >= 70 and rank=3;
update creature_template set minlevel=63, maxlevel=63 where (minlevel between 60 and 69) and (rank=3);
update creature_template set mingold=(minlevel*7), maxgold=(minlevel*13) where mingold=0 and type=7;
update creature_template set mingold=(minlevel*7), maxgold=(minlevel*13) where mingold > maxgold;

 

31.8.2007

update creature_template set minlevel=(maxlevel-1) where minlevel=0 and maxlevel > 1;
update creature_template set minlevel=1, maxlevel=1 where minlevel=0;
update creature_template set mindmg=maxdmg where mindmg=0 and maxdmg > 0;
update creature_template set mindmg=1, maxdmg=1 where mindmg=0;
update creature_template set baseattacktime=1500 where baseattacktime=0;

 

4.9.2007

update creature_template set maxlevel=floor(minlevel*1.2) where minlevel > maxlevel;
update creature_template set minhealth=(minlevel*100), maxhealth=floor(maxlevel*105) where minhealth =< 1 and minlevel > 10;

 

15.9.2007

update npc_vendor set maxcount=10, incrtime=3600 where item=2771;
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28555,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28576,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28574,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28759,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28560,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28561,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28577,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28758,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28559,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28761,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28760,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28575,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28557,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,28556,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,32947,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19773,32948,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28555,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28576,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28574,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28759,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28560,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28561,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28577,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28758,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28559,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28761,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28760,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28575,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28557,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,28556,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,32947,0,0);
insert into npc_vendor (entry, item, maxcount, incrtime) values (19772,32948,0,0);
insert into npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) values (18802,39642,30000,171,320,50);
insert into npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) values (16588,39642,30000,171,320,50);
insert into npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) values (19052,39642,30000,171,320,50);
update creature_template set npcflag=2 where entry=18218;
update quest_template where entry=2521 set RewItemId1=10752;
update quest_template set SpecialFlags=8, ReqCreatureOrGOId1=5229, ReqCreatureOrGOCount1=20 where entry=11096;

 

18.9.2007

update creature_template set mindmg=13, maxdmg=18 where entry=17524;
update npc_trainer set reqlevel=42 where spell=19837;
update creature_template set mindmg=102, maxdmg=156 where entry=8527;
insert into npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) values (4212, 10508, 2700, 165, 205, 0);

 

22.9.2007

(Velké díky ApoCovi za osvětlení inner joinu)

-- elity 
update creature_template ct inner join creature cr on ct.entry = cr.id set ct.mindmg = floor((ct.minlevel * (ct.minlevel + (rand() * (ct.minlevel/5)))) * 0.3), ct.maxdmg = floor((ct.maxlevel * (ct.maxlevel + (rand() * (ct.maxlevel/5)))) * 0.4) where ct.rank = 1;
-- trash mobs
update creature_template ct inner join creature cr on ct.entry = cr.id set ct.mindmg = floor((ct.minlevel * (ct.minlevel + (rand() * (ct.minlevel/5)))) * 0.05), ct.maxdmg = floor((ct.maxlevel * (ct.maxlevel + (rand() * (ct.maxlevel/5)))) * 0.07) where ct.rank = 0 and ct.minlevel > 10;
-- kontrola mindmg > maxdmg
update creature_template set maxdmg = floor(mindmg*1.4) where mindmg > maxdmg;

Edited September 23, 2007 by kupkoid

[charlie 13]

Pred tim nez ty UpDate pouziiju bych se chtel zeptat jestli jsou oficialni nebo je delal nekdo z mangosproject fora nebo jestli je delal kupokoid nebo nekdo z OG teamu.. diky

[kupkoid 288]

Dělal jsem je já, v žádném případě oficiální nejsou a k použití... Black Temple tam radši ještě nedávej. Jinak všechny příkazy update opravují nějaké chyby, na pastebinu jsou pak většinou spelly a podobné věci.

[charlie 13]

Ok GJ, muzes to treba napsat na sdb forum.. treba to zaradi do changesetu. Robby tam taky neco takovyho postl a ma to myslim v chgnst 206

[charlie 13]

update creature_template set maxhealth = minheath where maxhealth=0 and minhealth > 0;

 

chyba - ma byt minhealth a ne minheat - zrejme preklep. jen upozornuju

 

a u tech pastebinu me to hlasilo vzdy duplicate. Zkousel sem 3

Edited August 31, 2007 by charlie

[kupkoid 288]

update creature_template set maxhealth = minheath where maxhealth=0 and minhealth > 0;

 

chyba - ma byt minhealth a ne minheat - zrejme preklep. jen upozornuju

 

a u tech pastebinu me to hlasilo vzdy duplicate. Zkousel sem 3

Dík za upozornění. Jinak ty z pastebinu - potřebuješ ty záznamy nejdříve smazat a pak tam nahrát moje. (insert into, ne update ). Na druhou stranu tady delete příkazy nehodlám psát, protože updaty jsou primárně určeny k jiným účelům.

[kupkoid 288]

Přidán dotaz na globální přenastavení DMG elit. Nevím, zda je to exact bl!zzlike, mě se zdají výsledné hodnoty v pořádku. V dotazu je implementována "funkce" na mírné rozlišení dmg na jednotlivých levelech. Dotaz může být poměrně náročný na provedení. Vychází ze vzorce dmg=lvl^2. Velikost DMG lze jednoduše upravit změnou koeficientu (nastaven na 0.6 - 0.8x).

 

-- elity 
update creature_template ct inner join creature cr on ct.entry = cr.id set ct.mindmg = floor((ct.minlevel * (ct.minlevel + (rand() * (ct.minlevel/5)))) * 0.3), ct.maxdmg = floor((ct.maxlevel * (ct.maxlevel + (rand() * (ct.maxlevel/5)))) * 0.4) where ct.rank = 1;
-- trash mobs
update creature_template ct inner join creature cr on ct.entry = cr.id set ct.mindmg = floor((ct.minlevel * (ct.minlevel + (rand() * (ct.minlevel/5)))) * 0.05), ct.maxdmg = floor((ct.maxlevel * (ct.maxlevel + (rand() * (ct.maxlevel/5)))) * 0.07) where ct.rank = 0 and ct.minlevel > 10;
-- kontrola mindmg > maxdmg
update creature_template set maxdmg = floor(mindmg*1.4) where mindmg > maxdmg;

Edited September 23, 2007 by kupkoid

[charlie 13]

Takze s SDB fungovaly vyborne, ale s novejsima revizema, UDB nebo UWDB to dela strasnej bordel predevsim v DMG.. rekl bych ze to strojnasobi DMG vsem mobum..

 

Ten posledni.. rozhodne neni blizzlike a premstni mobum jejich DMG

Edited October 14, 2007 by charlie

[kupkoid 288]

Myslím, že topic by mohl být odstraněn z vyvěšených. Je již hodně zastaralý. Jen jej prosím neodstraňujte úplně, občas zde čerpám inspiraci.