Bonsoir à tous,
Voilà ma dernière contribution de l'année 2009 :
Un petit patch SQL pour vider Dalaran
Ca peut paraître stupide, mais j'en ai eu besoin, alors je l'ai mis sous patch sql et je vous le partage.
[code=sql]
/* Nettoyage de Dalaran */
/* Suppression des Pnj ( Hors Event Mondiaux ) */
/* Par MacWarrior */
/* Compatible UNIQUEMENT avec Ytdb - Rev.525 */
Delete from creature where guid=98347;
Delete from creature where guid=98346;
Delete from creature where guid=98345;
Delete from creature where guid=98348;
Delete from creature where guid=95157;
Delete from creature where guid=98342;
Delete from creature where guid=98341;
Delete from creature where guid=98203;
Delete from creature where guid=101279;
Delete from creature where guid=101278;
Delete from creature where guid=98204;
Delete from creature where guid=98259;
Delete from creature where guid=98343;
Delete from creature where guid=98345;
Delete from creature where guid=87325;
Delete from creature where guid=87296;
Delete from creature where guid=112587;
Delete from creature where guid=98344;
Delete from creature where guid=87334;
Delete from creature where guid=98238;
Delete from creature where guid=112503;
Delete from creature where guid=98184;
Delete from creature where guid=98237;
Delete from creature where guid=96003;
Delete from creature where guid=95114;
Delete from creature where guid=95112;
Delete from creature where guid=95113;
Delete from creature where guid=88645;
Delete from creature where guid=88634;
Delete from creature where guid=88637;
Delete from creature where guid=98249;
Delete from creature where guid=96007;
Delete from creature where guid=96011;
Delete from creature where guid=98250;
Delete from creature where guid=98248;
Delete from creature where guid=96004;
Delete from creature where guid=98247;
Delete from creature where guid=98241;
Delete from creature where guid=96016;
Delete from creature where guid=87269;
Delete from creature where guid=112224;
Delete from creature where guid=87268;
Delete from creature where guid=112225;
Delete from creature where guid=98240;
Delete from creature where guid=96017;
Delete from creature where guid=95096;
Delete from creature where guid=95099;
Delete from creature where guid=95100;
Delete from creature where guid=95101;
Delete from creature where guid=98176;
Delete from creature where guid=131378;
Delete from creature where guid=96015;
Delete from creature where guid=131381;
Delete from creature where guid=95116;
Delete from creature where guid=95115;
Delete from creature where guid=88480;
Delete from creature where guid=88636;
Delete from creature where guid=54531;
Delete from creature where guid=109031;
Delete from creature where guid=109035;
Delete from creature where guid=109036;
Delete from creature where guid=109033;
Delete from creature where guid=109030;
Delete from creature where guid=101827;
Delete from creature where guid=88636;
Delete from creature where guid=98202;
Delete from creature where guid=98173;
Delete from creature where guid=95121;
Delete from creature where guid=87376;
Delete from creature where guid=95120;
Delete from creature where guid=95156;
Delete from creature where guid=98174;
Delete from creature where guid=98199;
Delete from creature where guid=98349;
Delete from creature where guid=98200;
Delete from creature where guid=98201;
Delete from creature where guid=101821;
Delete from creature where guid=98198;
Delete from creature where guid=98197;
Delete from creature where guid=108974;
Delete from creature where guid=95153;
Delete from creature where guid=95154;
Delete from creature where guid=112209;
Delete from creature where guid=131375;
Delete from creature where guid=94660;
Delete from creature where guid=108934;
Delete from creature where guid=131380;
Delete from creature where guid=95152;
Delete from creature where guid=95151;
Delete from creature where guid=83380;
Delete from creature where guid=98193;
Delete from creature where guid=98192;
Delete from creature where guid=112355;
Delete from creature where guid=136681;
Delete from creature where guid=98191;
Delete from creature where guid=98194;
Delete from creature where guid=98195;
Delete from creature where guid=98196;
Delete from creature where guid=95149;
Delete from creature where guid=95150;
Delete from creature where guid=95098;
Delete from creature where guid=95134;
Delete from creature where guid=87405;
Delete from creature where guid=96020;
Delete from creature where guid=95148;
Delete from creature where guid=130807;
Delete from creature where guid=98350;
Delete from creature where guid=98351;
Delete from creature where guid=112407;
Delete from creature where guid=88639;
Delete from creature where guid=109001;
Delete from creature where guid=87277;
Delete from creature where guid=87276;
Delete from creature where guid=112405;
Delete from creature where guid=98375;
Delete from creature where guid=98376;
Delete from creature where guid=128279;
Delete from creature where guid=108995;
Delete from creature where guid=108997;
Delete from creature where guid=108996;
Delete from creature where guid=98182;
Delete from creature where guid=98175;
Delete from creature where guid=98181;
Delete from creature where guid=96026;
Delete from creature where guid=98254;
Delete from creature where guid=98255;
Delete from creature where guid=130808;
Delete from creature where guid=96029;
Delete from creature where guid=131377;
Delete from creature where guid=96028;
Delete from creature where guid=96031;
Delete from creature where guid=17088;
Delete from creature where guid=96036;
Delete from creature where guid=96033;
Delete from creature where guid=101826;
Delete from creature where guid=112412;
Delete from creature where guid=98373;
Delete from creature where guid=98372;
Delete from creature where guid=95122;
Delete from creature where guid=96000;
Delete from creature where guid=95999;
Delete from creature where guid=87402;
Delete from creature where guid=87302;
Delete from creature where guid=108936;
Delete from creature where guid=98172;
Delete from creature where guid=108999;
Delete from creature where guid=88644;
Delete from creature where guid=112487;
Delete from creature where guid=112411;
Delete from creature where guid=95125;
Delete from creature where guid=112248;
Delete from creature where guid=112390;
Delete from creature where guid=112322;
Delete from creature where guid=112354;
Delete from creature where guid=112356;
Delete from creature where guid=112389;
Delete from creature where guid=87457;
Delete from creature where guid=112357;
Delete from creature where guid=112343;
Delete from creature where guid=112247;
Delete from creature where guid=112404;
Delete from creature where guid=112342;
Delete from creature where guid=112344;
Delete from creature where guid=87458;
Delete from creature where guid=112346;
Delete from creature where guid=112326;
Delete from creature where guid=112276;
Delete from creature where guid=108943;
Delete from creature where guid=95124;
Delete from creature where guid=112277;
Delete from creature where guid=112279;
Delete from creature where guid=112275;
Delete from creature where guid=112278;
Delete from creature where guid=108944;
Delete from creature where guid=95126;
Delete from creature where guid=95127;
Delete from creature where guid=95990;
Delete from creature where guid=98243;
Delete from creature where guid=95991;
Delete from creature where guid=109028;
Delete from creature where guid=95131;
Delete from creature where guid=109029;
Delete from creature where guid=95133;
Delete from creature where guid=95132;
Delete from creature where guid=136679;
Delete from creature where guid=95989;
Delete from creature where guid=88643;
Delete from creature where guid=101828;
Delete from creature where guid=98244;
Delete from creature where guid=98239;
Delete from creature where guid=88642;
Delete from creature where guid=130810;
Delete from creature where guid=130809;
Delete from creature where guid=95985;
Delete from creature where guid=95224;
Delete from creature where guid=95142;
Delete from creature where guid=98082;
Delete from creature where guid=95141;
Delete from creature where guid=109000;
Delete from creature where guid=112406;
Delete from creature where guid=131379;
Delete from creature where guid=95140;
Delete from creature where guid=95139;
Delete from creature where guid=94662;
Delete from creature where guid=95913;
Delete from creature where guid=95138;
Delete from creature where guid=95135;
Delete from creature where guid=95136;
Delete from creature where guid=88641;
Delete from creature where guid=88640;
Delete from creature where guid=87400;
Delete from creature where guid=95144;
Delete from creature where guid=95143;
Delete from creature where guid=112369;
Delete from creature where guid=112371;
Delete from creature where guid=112372;
Delete from creature where guid=112373;
Delete from creature where guid=112376;
Delete from creature where guid=112378;
Delete from creature where guid=112370;
Delete from creature where guid=112367;
Delete from creature where guid=112382;
Delete from creature where guid=112383;
Delete from creature where guid=112385;
Delete from creature where guid=112386;
Delete from creature where guid=112374;
Delete from creature where guid=112364;
Delete from creature where guid=112381;
Delete from creature where guid=112375;
Delete from creature where guid=112380;
Delete from creature where guid=112388;
Delete from creature where guid=112363;
Delete from creature where guid=112362;
Delete from creature where guid=112368;
Delete from creature where guid=112360;
Delete from creature where guid=112366;
Delete from creature where guid=112359;
Delete from creature where guid=112361;
Delete from creature where guid=112384;
Delete from creature where guid=112379;
Delete from creature where guid=112387;
Delete from creature where guid=112377;
Delete from creature where guid=112365;
Delete from creature where guid=112358;
Delete from creature where guid=96055;
Delete from creature where guid=95912;
Delete from creature where guid=95914;
Delete from creature where guid=96050;
Delete from creature where guid=95105;
Delete from creature where guid=95104;
Delete from creature where guid=136677;
Delete from creature where guid=95103;
Delete from creature where guid=95102;
Delete from creature where guid=123511;
Delete from creature where guid=98335;
Delete from creature where guid=98187;
Delete from creature where guid=98189;
Delete from creature where guid=95107;
Delete from creature where guid=95106;
Delete from creature where guid=96045;
Delete from creature where guid=96048;
Delete from creature where guid=96049;
Delete from creature where guid=95108;
Delete from creature where guid=96042;
Delete from creature where guid=96041;
Delete from creature where guid=96043;
Delete from creature where guid=96046;
Delete from creature where guid=96044;
Delete from creature where guid=95109;
Delete from creature where guid=98253;
Delete from creature where guid=98258;
Delete from creature where guid=95110;
Delete from creature where guid=98252;
Delete from creature where guid=98171;
Delete from creature where guid=95111;
Delete from creature where guid=96058;
Delete from creature where guid=98190;
Delete from creature where guid=96052;
Delete from creature where guid=98333;
Delete from creature where guid=98334;
Delete from creature where guid=95117;
Delete from creature where guid=95118;
Delete from creature where guid=99742;
Delete from creature where guid=95119;
Delete from creature where guid=95146;
Delete from creature where guid=98242;
Delete from creature where guid=95145;
Delete from creature where guid=108998;
Delete from creature where guid=54553;
Delete from creature where guid=95128;
Delete from creature where guid=101824;
Delete from creature where guid=112422;
Delete from creature where guid=109007;
Delete from creature where guid=95130;
Delete from creature where guid=95129;
Delete from creature where guid=95995;
Delete from creature where guid=109034;
Delete from creature where guid=108937;
Delete from creature where guid=109032;
Delete from creature where guid=109024;
Delete from creature where guid=109023;
Delete from creature where guid=108973;
Delete from creature where guid=108972;
Delete from creature where guid=108963;
Delete from creature where guid=109026;
Delete from creature where guid=109027;
Delete from creature where guid=95997;
Delete from creature where guid=108942;
Delete from creature where guid=109025;
Delete from creature where guid=96067;
Delete from creature where guid=96062;
Delete from creature where guid=108933;
Delete from creature where guid=131376;
Delete from creature where guid=108932;
Delete from creature where guid=94659;
Delete from creature where guid=131382;
Delete from creature where guid=131144;
Delete from creature where guid=83376;
Delete from creature where guid=109020;
Delete from creature where guid=108990;
Delete from creature where guid=98374;
Delete from creature where guid=108981;
Delete from creature where guid=108986;
Delete from creature where guid=108984;
Delete from creature where guid=112353;
Delete from creature where guid=136682;
Delete from creature where guid=87286;
Delete from creature where guid=98273;
Delete from creature where guid=98274;
Delete from creature where guid=87289;
Delete from creature where guid=95998;
Delete from creature where guid=98268;
Delete from creature where guid=98183;
Delete from creature where guid=98269;
Delete from creature where guid=98271;
Delete from creature where guid=98270;
Delete from creature where guid=98272;
Delete from creature where guid=98340;
Delete from creature where guid=98337;
Delete from creature where guid=98339;
Delete from creature where guid=98338;
Delete from creature where guid=98180;
Delete from creature where guid=136683;
Delete from creature where guid=95093;
Delete from creature where guid=101820;
Delete from creature where guid=101823;
Delete from creature where guid=87291;
Delete from creature where guid=87279;
Delete from creature where guid=87284;
Delete from creature where guid=87288;
Delete from creature where guid=87378;
Delete from creature where guid=98369;
Delete from creature where guid=98370;
Delete from creature where guid=108992;
Delete from creature where guid=112400;
Delete from creature where guid=112409;
Delete from creature where guid=112398;
Delete from creature where guid=108991;
Delete from creature where guid=98236;
Delete from creature where guid=109003;
Delete from creature where guid=109005;
Delete from creature where guid=98230;
Delete from creature where guid=98221;
Delete from creature where guid=98222;
Delete from creature where guid=108975;
Delete from creature where guid=98220;
Delete from creature where guid=98246;
Delete from creature where guid=98224;
Delete from creature where guid=98223;
Delete from creature where guid=98226;
Delete from creature where guid=98357;
Delete from creature where guid=112416;
Delete from creature where guid=98229;
Delete from creature where guid=98358;
Delete from creature where guid=98368;
Delete from creature where guid=98364;
Delete from creature where guid=98365;
Delete from creature where guid=98366;
Delete from creature where guid=98367;
Delete from creature where guid=109008;
Delete from creature where guid=112417;
Delete from creature where guid=98227;
Delete from creature where guid=98228;
Delete from creature where guid=98359;
Delete from creature where guid=94684;
Delete from creature where guid=94629;
Delete from creature where guid=94685;
Delete from creature where guid=98361;
Delete from creature where guid=98360;
Delete from creature where guid=78112;
Delete from creature where guid=98362;
Delete from creature where guid=98363;
Delete from creature where guid=109021;
Delete from creature where guid=112432;
Delete from creature where guid=112429;
Delete from creature where guid=112428;
Delete from creature where guid=112431;
Delete from creature where guid=112433;
Delete from creature where guid=112430;
Delete from creature where guid=112434;
Delete from creature where guid=112425;
Delete from creature where guid=112426;
Delete from creature where guid=112424;
Delete from creature where guid=112427;
Delete from creature where guid=108923;
Delete from creature where guid=109013;
Delete from creature where guid=109016;
Delete from creature where guid=109012;
Delete from creature where guid=109011;
Delete from creature where guid=108922;
Delete from creature where guid=109014;
Delete from creature where guid=109015;
Delete from creature where guid=109006;
Delete from creature where guid=109004;
Delete from creature where guid=98356;
Delete from creature where guid=98355;
Delete from creature where guid=112352;
Delete from creature where guid=98354;
Delete from creature where guid=98257;
Delete from creature where guid=98256;
Delete from creature where guid=109010;
Delete from creature where guid=98219;
Delete from creature where guid=131383;
Delete from creature where guid=98218;
Delete from creature where guid=98217;
Delete from creature where guid=98216;
Delete from creature where guid=98215;
Delete from creature where guid=98214;
Delete from creature where guid=127648;
Delete from creature where guid=98260;
Delete from creature where guid=98371;
Delete from creature where guid=88648;
Delete from creature where guid=87283;
Delete from creature where guid=128284;
Delete from creature where guid=108940;
Delete from creature where guid=112399;
Delete from creature where guid=108993;
Delete from creature where guid=108935;
Delete from creature where guid=108939;
Delete from creature where guid=128286;
Delete from creature where guid=108938;
Delete from creature where guid=108941;
Delete from creature where guid=101822;
Delete from creature where guid=89877;
Delete from creature where guid=108988;
Delete from creature where guid=87446;
Delete from creature where guid=87447;
Delete from creature where guid=108987;
Delete from creature where guid=108924;
Delete from creature where guid=128282;
Delete from creature where guid=128281;
Delete from creature where guid=108989;
Delete from creature where guid=117023;
Delete from creature where guid=136675;
Delete from creature where guid=136676;
Delete from creature where guid=108980;
Delete from creature where guid=98235;
Delete from creature where guid=98231;
Delete from creature where guid=98233;
Delete from creature where guid=98232;
Delete from creature where guid=98225;
Delete from creature where guid=98234;
Delete from creature where guid=98352;
Delete from creature where guid=96037;
Delete from creature where guid=108983;
Delete from creature where guid=108925;
Delete from creature where guid=112207;
Delete from creature where guid=98353;
Delete from creature where guid=112213;
Delete from creature where guid=98251;
Delete from creature where guid=87281;
Delete from creature where guid=112222;
Delete from creature where guid=87282;
Delete from creature where guid=112217;
Delete from creature where guid=112218;
Delete from creature where guid=112214;
Delete from creature where guid=112215;
Delete from creature where guid=112211;
Delete from creature where guid=112216;
Delete from creature where guid=112210;
Delete from creature where guid=112212;
Delete from creature where guid=136716;
Delete from creature where guid=112194;
Delete from creature where guid=136678;
Delete from creature where guid=54462;
Delete from creature where guid=112345;
Delete from creature where guid=54527;[/code]
Have Fun !
Cordialement,
MacWarrior.