Remove Trash Items - منع دروب ال Archemy او القمامه من الوحوش

[mrswat]

السلام عليكم و رحمة الله و بركاته

كل عام و انتم بخير يا شباب .. انا بكريت سيرفر حاليا و بتعلم و بستفيد من حاجات كتيره اكتشفتها و لقيتها مش موجوده بشكل منظم فإن شاء الله هجهز موضوع منظم و شرح قوي بفيديوهات و اي مشكله قابلتني و حليتها هقول حليتها ازاي

ندخل في المهم

جبتلكم كويري لطيف مش عارف اذا كان موجود في المنتدي بس دورت ملقيتش المهم وظيفته ان الوحوش متوقعش ال Trash او بنسميها القمامه.

لو معندكش وقت تقرأ ف ال Query اهو .. ادخل نفذه علطول و مش هتلاقي دروب فيه قمامه ان شاء الله

USE SRO_VT_SHARD -----> By-MrSwat <-----
delete from _RefMonster_AssignedItemDrop where RefItemID in (10681,10682,10683,10684,10685,10686,10663,10664,10665,10669,10670,10671,10699,10700,10701,10702,10703,10693,10694,10695,10696,10697,10698,10666,10667,10668,10672,10673,10674,10687,10688,10689,10690,10691,10692,10675,10676,10677,10678,10679,10680,10734,10735,10736,10737,10738,10739,10716,10717,10718,10722,10723,10724,10719,10720,10721,10725,10726,10727,10728,10729,10730,10731,10732,10733,10710,10711,10712,10713,10714,10715,10704,10705,10706,10707,10708,10709,7140,7141,7142,7155,7156,7157,7152,7153,7154,7143,7144,7145,7104,7105,7106,7107,7108,7109,7164,7165,7166,7167,7168,7169,7110,7111,7112,7113,7114,7115,7101,7102,7103,7122,7123,7124,7128,7129,7130,7146,7147,7148,7149,7150,7151,7170,7171,7172,7173,7174,7462,7463,7464,7131,7132,7133,7125,7126,7127,7116,7117,7118,7119,7120,7121,7158,7159,7160,7161,7162,7163,7134,7135,7136,7137,7138,7139,7353,7354,7355,7356,7357,7358,7335,7336,7337,7338,7339,7340,7365,7366,7367,7368,7369,7370,7347,7348,7349,7350,7351,7352,7341,7342,7343,7344,7345,7346,7359,7360,7361,7362,7363,7364,10613,10614,10615,10619,10620,10621,10616,10617,10618,10622,10623,10624,10607,10608,10609,10610,10611,10612,10625,10626,10627,10631,10632,10633,10601,10602,10603,10604,10605,10606,10658,10659,10660,10661,10662,10634,10635,10628,10629,10630,10636,10640,10641,10642,10637,10638,10639,10643,10644,10645,10646,10647,10648,10652,10653,10654,10595,10596,10597,10598,10599,10600,10649,10650,10651,10655,10656,10657,7315,7316,7317,7321,7322,7323,7297,7298,7299,7294,7295,7296,7330,7331,7332,7333,7334,7306,7307,7308,7309,7310,7311,7318,7319,7320,7312,7313,7314,7300,7301,7302,7303,7304,7305,7327,7328,7329,7324,7325,7326,7273,7274,7275,7276,7277,7278,7279,7280,7281,7291,7292,7293,7288,7289,7290,7270,7271,7272,7282,7283,7284,7285,7286,7287,7235,7236,7237,7250,7251,7252,7244,7245,7246,7238,7239,7240,7223,7224,7225,7229,7230,7231,7226,7227,7228,7232,7233,7234,7262,7263,7264,7259,7260,7261,7253,7254,7255,7256,7257,7258,7217,7218,7219,7220,7221,7222,7265,7266,7267,7268,7269,7241,7242,7243,7247,7248,7249,7439,7440,7441,7442,7443,7444,7418,7419,7420,7424,7425,7426,7427,7428,7429,7430,7431,7432,7421,7422,7454,7455,7456,7423,7451,7452,7453,7457,7458,7459,7460,7461,7433,7434,7435,7436,7437,7438,7445,7446,7447,7448,7449,7450,25041,25042,25039,25040,26076,26077,25081,25082,25083,25084,25169,25170,25073,25074,25153,25154,25125,25126,25123,25124,25119,25120,25143,25144,25135,25136,25021,25022,25121,25122,25061,25062,25059,25060,25065,25066,25079,25080,25141,25142,25133,25134,25075,25076,25031,25032,26070,26071,25027,25028,26066,26067,25145,25146,25055,25056,25179,25180,25175,25176,25033,25034,26072,26073,25129,25130,25173,25174,25051,25052,25053,25054,25089,25090,25085,25086,25087,25088,25163,25164,25023,25024,25103,25104,25171,25172,25047,25048,25049,25050,26080,26081,25139,25140,25137,25138,25071,25072,25045,25046,25043,25044,26078,26079,25111,25112,25109,25110,25167,25168,25161,25162,25159,25160,25151,25152,25107,25108,25101,25102,25099,25100,25097,25098,25091,25092,25095,25096,25093,25094,25105,25106,25131,25132,25029,25030,25037,25038,25117,25118,26068,26069,25063,25064,25077,25078,26074,26075,25057,25058,25157,25158,25035,25036,25165,25166,25147,25148,25177,25178,25025,25026,25149,25150,25115,25116,25113,25114,25155,25156,25015,25016,25127,25128,25017,25018,25067,25068,25011,25012,25069,25070,25013,25014,25019,25020,7407,7408,7409,7410,7411,7412,7395,7396,7397,7398,7399,7400,7413,7414,7415,7416,7417,7401,7402,7403,7404,7405,7406,7389,7390,7391,7392,7393,7394,7377,7378,7379,7380,7381,7382,7383,7384,7385,7386,7387,7388,7371,7372,7373,7374,7375,7376,10872,10873,10874,10833,10834,10835,10869,10870,10871,10875,10876,10877,10878,10879,10860,10861,10862,10749,10750,10743,10744,10745,10751,10758,10759,10760,10779,10780,10773,10774,10775,10781,10782,10783,10784,10830,10831,10832,10812,10813,10806,10807,10808,10814,10824,10825,10826,23297,23298,23300,23301,23302,23299,23303,23304,23305,23294,10848,10849,10850,23295,10851,10852,10853,23296,10854,10855,10856,10857,10858,10859,10821,10822,10815,10816,10817,10823,10827,10828,10829,10800,10801,10788,10789,10790,10802,10809,10810,10811,10803,10804,10794,10795,10796,10805,10818,10819,10820,10863,10864,10865,10761,10762,10755,10756,10757,10763,10767,10768,10769,10791,10792,10785,10786,10787,10793,10797,10798,10799,23285,23286,23288,23289,23290,23287,23291,23292,23293,23282,10836,10837,10838,23283,10839,10840,10841,23284,10842,10843,10844,10845,10846,10847,10746,10747,23279,23280,23281,10748,10752,10753,10740,10741,10742,10754,10770,10771,10764,10765,10766,10772,10776,10777,10778,10866,10867,10868,10880,10881,10882,10883,10884,7190,7191,7192,7187,7188,7189,7178,7179,7180,7199,7200,7201,7196,7197,7198,7211,7212,7213,7208,7209,7210,7175,7176,7177,7193,7194,7195,7202,7203,7204,7205,7206,7207,7214,7215,7216,7184,7185,7186,7181,7182,7183)

طيب لو عايز تفهم جبت ده منين هقولك .. كل الايتمز الي ف الجيم موجوده في جدول اسمه _RefObjCommon تمام؟

كل الايتم القمامه بتبدأ ب ITEM_ETC_ARCHEMY_MATERIAL

عشان نجيب الاي دي بتاعها عملنا كويري بسيط اهو

USE SRO_VT_SHARD -----> By-MrSwat <-----
--select ID from _RefObjCommon where CodeName128 like 'ITEM_ETC_ARCHEMY_MATERIAL%'

ملحوظه للي لسه جديد مع SQL .. انا قلتله دورلي في الداتابيز علي ال ID بتاع كل الايتمز الي اسمها بيبدأ ب ITEM_ETC_ARCHEMY_MATERIAL و ال % الي ف الاخر دي يعني عشان ايا كان تكملة الاسم يجيبهالي

و النتيجه جابلي الاي ديهات الي حطيناها في ال Query الاول

آسف علي الإطاله بس حبيت اوضح للناس الي حابه تفهم كل خطوه جات منين مش ناخد Query و نعمله Execute و خلاص من غير ما نفهم