Vidage de Dalaran

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.

Fort intéressant Ça évite de faire balader ses cousins avec des comptes MJ et une maccro .npc del pendant des heures
Merci bien =D

Merci c'est utile pour un serveur fun .

Merci mais on en fait quoi du code svp ?

Merci très utile mais à ne pas mettre entre des mains inexpérimentées

Précise la DB et la version, tu delete les GUID, choses qui varient selon la DB, si tu as YTDB et qu'un utilisateur UDB l'utilise il risque d'avoir de mauvaises surprises :')

(16-05-2010 14:38)Mograine a écrit :  Précise la DB et la version, tu delete les GUID, choses qui varient selon la DB, si tu as YTDB et qu'un utilisateur UDB l'utilise il risque d'avoir de mauvaises surprises :')

Citation :/* Compatible UNIQUEMENT avec Ytdb - Rev.525 */

Je sais pas... Ahhh ! Si ! Voilà la réponse !
=D