كل عام و انتم بخير يا شباب .. انا بكريت سيرفر حاليا و بتعلم و بستفيد من حاجات كتيره اكتشفتها و لقيتها مش موجوده بشكل منظم فإن شاء الله هجهز موضوع منظم و شرح قوي بفيديوهات و اي مشكله قابلتني و حليتها هقول حليتها ازاي
جبتلكم كويري لطيف مش عارف اذا كان موجود في المنتدي بس دورت ملقيتش المهم وظيفته ان الوحوش متوقعش ال 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)
طيب لو عايز تفهم جبت ده منين هقولك .. كل الايتمز الي ف الجيم موجوده في جدول اسمه
ملحوظه للي لسه جديد مع SQL .. انا قلتله دورلي في الداتابيز علي ال ID بتاع كل الايتمز الي اسمها بيبدأ ب ITEM_ETC_ARCHEMY_MATERIAL و ال % الي ف الاخر دي يعني عشان ايا كان تكملة الاسم يجيبهالي
آسف علي الإطاله بس حبيت اوضح للناس الي حابه تفهم كل خطوه جات منين مش ناخد Query و نعمله Execute و خلاص من غير ما نفهم