[RELEASE] Resinate's fixes MASSIVE

[resinate]

UPDATE creature_proto SET npcflags=2 WHERE npcflags=7;
UPDATE creature_proto SET npcflags=2 WHERE npcflags=3;
UPDATE creature_proto SET combat_reach=scale;
UPDATE creature_proto SET bounding_radius=1;
UPDATE creature_proto SET combat_reach=1 where combat_reach<1;
UPDATE creature_proto SET npcflags=19 WHERE npcflags=16;
UPDATE creature_proto SET npcflags=19 WHERE npcflags=23;
UPDATE creature_proto SET npcflags=19 WHERE npcflags=17;
UPDATE creature_proto SET npcflags=19 WHERE npcflags=18;
UPDATE creature_proto SET health=4000 WHERE level=70 and health<4000;
UPDATE creature_proto SET health=3900 WHERE level=69 and health<3900;
UPDATE creature_proto SET health=3800 WHERE level=68 and health<3800;
UPDATE creature_proto SET health=3700 WHERE level=67 and health<3700;
UPDATE creature_proto SET health=3600 WHERE level=66 and health<3600;
UPDATE creature_proto SET health=3500 WHERE level=65 and health<3500;
UPDATE creature_proto SET health=3400 WHERE level=64 and health<3400;
UPDATE creature_proto SET health=3300 WHERE level=63 and health<3300;
UPDATE creature_proto SET health=3200 WHERE level=62 and health<3200;
UPDATE creature_proto SET health=3100 WHERE level=61 and health<3100;
UPDATE creature_proto SET health=3000 WHERE level=60 and health<3000;
UPDATE creature_proto SET mindamage=150 WHERE level=70 and mindamage<150;
UPDATE creature_proto SET mindamage=145 WHERE level=69 and mindamage<145;
UPDATE creature_proto SET mindamage=140 WHERE level=68 and mindamage<140;
UPDATE creature_proto SET mindamage=135 WHERE level=67 and mindamage<135;
UPDATE creature_proto SET mindamage=130 WHERE level=66 and mindamage<130;
UPDATE creature_proto SET mindamage=125 WHERE level=65 and mindamage<125;
UPDATE creature_proto SET mindamage=120 WHERE level=64 and mindamage<120;
UPDATE creature_proto SET mindamage=115 WHERE level=63 and mindamage<115;
UPDATE creature_proto SET mindamage=110 WHERE level=62 and mindamage<110;
UPDATE creature_proto SET mindamage=105 WHERE level=61 and mindamage<105;
UPDATE creature_proto SET mindamage=100 WHERE level=60 and mindamage<100;
UPDATE creature_proto SET maxdamage=350 WHERE level=70 and maxdamage<350;
UPDATE creature_proto SET maxdamage=340 WHERE level=69 and maxdamage<340;
UPDATE creature_proto SET maxdamage=330 WHERE level=68 and maxdamage<330;
UPDATE creature_proto SET maxdamage=320 WHERE level=67 and maxdamage<320;
UPDATE creature_proto SET maxdamage=310 WHERE level=66 and maxdamage<310;
UPDATE creature_proto SET maxdamage=300 WHERE level=65 and maxdamage<300;
UPDATE creature_proto SET maxdamage=290 WHERE level=64 and maxdamage<290;
UPDATE creature_proto SET maxdamage=280 WHERE level=63 and maxdamage<280;
UPDATE creature_proto SET maxdamage=270 WHERE level=62 and maxdamage<270;
UPDATE creature_proto SET maxdamage=260 WHERE level=61 and maxdamage<260;
UPDATE creature_proto SET maxdamage=250 WHERE level=60 and maxdamage<250;
UPDATE creature_proto SET attacktime=2000 WHERE attacktime<1500;
UPDATE creature_proto SET npcflags=4 WHERE entry=3362;
UPDATE creature_proto SET npcflags=4 WHERE entry=3685;
UPDATE creature_proto SET npcflags=4 WHERE entry=384;
UPDATE creature_proto SET npcflags=4 WHERE entry=14885;
UPDATE creature_proto SET npcflags=16391 WHERE entry=8403;
UPDATE creature_proto SET npcflags=16391 WHERE npcflags=16388;
UPDATE creature_proto SET npcflags=16391 WHERE npcflags=16390;
UPDATE creature_proto SET npcflags=16391 WHERE npcflags=16389;
UPDATE creature_proto SET npcflags=16391 WHERE npcflags=4;
UPDATE items SET sellprice=0 WHERE buyprice=0;

Good luck proving i stole them. these r my blizz like fixes. i will not release my custom.

use navicat "console" command to run these.

this is for acsent

[MentaL]

[resinate]

i know many of u guys r using these, why not leave any comments =(

[Masaki94]

We will always love you ressy. No matter what you do.

[resinate]

those fixes is what u was rudly bragging about. lol. apply them to any db and u got a hella nice db. i have more commands but those r priv XD

im only releasing stuff thats old that i made. when wow 3.0 comes out im releasing my full 2.3 db.

[n4ru70h4x0r]

@resinate: So basically when 3.0 is out you want to keep us behind you? You want us to stay @ 2.3 and you will be w/lich king? Not gonna f'kin happen. No one is going to use old sh1t. They will use others fixes from ppl who are generous and not selfish. ou the latest fixes... no one needs old fixes...

[n4ru70h4x0r]

Oh and you didn't even say what DB this is for... >:(

[resinate]

i plan on doing the 3.0 work when beta is out. not what full 3.0 is out. cuz in beta they release bits by bits. and that helps me to update fast. if ppl r willing to team up and help then great itll get done faster, which means a faster release.

plus when 3.0 hits beta lol ppl will be still working on 2.3 lol. yes ppl on the dbs project r that slow. i alrdy have 2.2 mostly done. i think these fixes is generous enough. for now

UPDATE creature_proto SET attacktime=2000 WHERE attacktime<1500;

fixed sry about that

[Julian_X]

These fixes are not Blizzlike, does this look Blizzlike:
UPDATE creature_proto SET npcflags=2 WHERE npcflags=7;
UPDATE creature_proto SET npcflags=2 WHERE npcflags=3;
UPDATE creature_proto SET combat_reach=scale;
or,
UPDATE items SET buyprice=sellprice*2 WHERE buyprice=0;
and a ton other.

[channel_49]

Blizz standard is 5x buyprice to sellprice ratio. Any item not in a vendor list should not even have a buyprice.

Queries like these will only give custom content, just generalized "fix" without putting in consideration of other aspects:
UPDATE creature_proto SET npcflags=2 WHERE npcflags=7;
UPDATE creature_proto SET npcflags=2 WHERE npcflags=3;
UPDATE creature_proto SET combat_reach=scale;
UPDATE creature_proto SET bounding_radius=1;
UPDATE creature_proto SET combat_reach=1 where combat_reach<1;

I won't even go into anymore details why those damage fixes arnt blizzlike.


What can I say, noobs can only make noob fixes, without full knowledge of how everything works.

[resinate]

cry more pls u guys cant do crap about it

[Julian_X]

Resinate if you say Blizzlike make it BLIZZLIKE don't give these crap fixes to n00bs that don't know about it 100%. Or just rename this Resinate's fixes (blizz/non-blizz)

[resinate]

happy

[Julian_X]

Very :D

[channel_49]

Yea, don't get people's hopes up when you cant deliver.