mrswat
13-05-2020, 11:15 PM
السلام عليكم و رحمة الله و بركاته
كل عام و انتم بخير يا شباب .. انا بكريت سيرفر حاليا و بتعلم و بستفيد من حاجات كتيره اكتشفتها و لقيتها مش موجوده بشكل منظم فإن شاء الله هجهز موضوع منظم و شرح قوي بفيديوهات و اي مشكله قابلتني و حليتها هقول حليتها ازاي
ندخل في المهم
جبتلكم كويري لطيف مش عارف اذا كان موجود في المنتدي بس دورت ملقيتش المهم وظيفته ان الوحوش متوقعش ال Trash او بنسميها القمامه.
لو معندكش وقت تقرأ ف ال Query اهو .. ادخل نفذه علطول و مش هتلاقي دروب فيه قمامه ان شاء الله
USE SRO_VT_SHARD -----> By-MrSwat <-----
delete from _RefMonster_AssignedItemDrop where RefItemID in (10681,10682,10683,10684,10685,10686,10663,10664,1 0665,10669,10670,10671,10699,10700,10701,10702,107 03,10693,10694,10695,10696,10697,10698,10666,10667 ,10668,10672,10673,10674,10687,10688,10689,10690,1 0691,10692,10675,10676,10677,10678,10679,10680,107 34,10735,10736,10737,10738,10739,10716,10717,10718 ,10722,10723,10724,10719,10720,10721,10725,10726,1 0727,10728,10729,10730,10731,10732,10733,10710,107 11,10712,10713,10714,10715,10704,10705,10706,10707 ,10708,10709,7140,7141,7142,7155,7156,7157,7152,71 53,7154,7143,7144,7145,7104,7105,7106,7107,7108,71 09,7164,7165,7166,7167,7168,7169,7110,7111,7112,71 13,7114,7115,7101,7102,7103,7122,7123,7124,7128,71 29,7130,7146,7147,7148,7149,7150,7151,7170,7171,71 72,7173,7174,7462,7463,7464,7131,7132,7133,7125,71 26,7127,7116,7117,7118,7119,7120,7121,7158,7159,71 60,7161,7162,7163,7134,7135,7136,7137,7138,7139,73 53,7354,7355,7356,7357,7358,7335,7336,7337,7338,73 39,7340,7365,7366,7367,7368,7369,7370,7347,7348,73 49,7350,7351,7352,7341,7342,7343,7344,7345,7346,73 59,7360,7361,7362,7363,7364,10613,10614,10615,1061 9,10620,10621,10616,10617,10618,10622,10623,10624, 10607,10608,10609,10610,10611,10612,10625,10626,10 627,10631,10632,10633,10601,10602,10603,10604,1060 5,10606,10658,10659,10660,10661,10662,10634,10635, 10628,10629,10630,10636,10640,10641,10642,10637,10 638,10639,10643,10644,10645,10646,10647,10648,1065 2,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,2504 1,25042,25039,25040,26076,26077,25081,25082,25083, 25084,25169,25170,25073,25074,25153,25154,25125,25 126,25123,25124,25119,25120,25143,25144,25135,2513 6,25021,25022,25121,25122,25061,25062,25059,25060, 25065,25066,25079,25080,25141,25142,25133,25134,25 075,25076,25031,25032,26070,26071,25027,25028,2606 6,26067,25145,25146,25055,25056,25179,25180,25175, 25176,25033,25034,26072,26073,25129,25130,25173,25 174,25051,25052,25053,25054,25089,25090,25085,2508 6,25087,25088,25163,25164,25023,25024,25103,25104, 25171,25172,25047,25048,25049,25050,26080,26081,25 139,25140,25137,25138,25071,25072,25045,25046,2504 3,25044,26078,26079,25111,25112,25109,25110,25167, 25168,25161,25162,25159,25160,25151,25152,25107,25 108,25101,25102,25099,25100,25097,25098,25091,2509 2,25095,25096,25093,25094,25105,25106,25131,25132, 25029,25030,25037,25038,25117,25118,26068,26069,25 063,25064,25077,25078,26074,26075,25057,25058,2515 7,25158,25035,25036,25165,25166,25147,25148,25177, 25178,25025,25026,25149,25150,25115,25116,25113,25 114,25155,25156,25015,25016,25127,25128,25017,2501 8,25067,25068,25011,25012,25069,25070,25013,25014, 25019,25020,7407,7408,7409,7410,7411,7412,7395,739 6,7397,7398,7399,7400,7413,7414,7415,7416,7417,740 1,7402,7403,7404,7405,7406,7389,7390,7391,7392,739 3,7394,7377,7378,7379,7380,7381,7382,7383,7384,738 5,7386,7387,7388,7371,7372,7373,7374,7375,7376,108 72,10873,10874,10833,10834,10835,10869,10870,10871 ,10875,10876,10877,10878,10879,10860,10861,10862,1 0749,10750,10743,10744,10745,10751,10758,10759,107 60,10779,10780,10773,10774,10775,10781,10782,10783 ,10784,10830,10831,10832,10812,10813,10806,10807,1 0808,10814,10824,10825,10826,23297,23298,23300,233 01,23302,23299,23303,23304,23305,23294,10848,10849 ,10850,23295,10851,10852,10853,23296,10854,10855,1 0856,10857,10858,10859,10821,10822,10815,10816,108 17,10823,10827,10828,10829,10800,10801,10788,10789 ,10790,10802,10809,10810,10811,10803,10804,10794,1 0795,10796,10805,10818,10819,10820,10863,10864,108 65,10761,10762,10755,10756,10757,10763,10767,10768 ,10769,10791,10792,10785,10786,10787,10793,10797,1 0798,10799,23285,23286,23288,23289,23290,23287,232 91,23292,23293,23282,10836,10837,10838,23283,10839 ,10840,10841,23284,10842,10843,10844,10845,10846,1 0847,10746,10747,23279,23280,23281,10748,10752,107 53,10740,10741,10742,10754,10770,10771,10764,10765 ,10766,10772,10776,10777,10778,10866,10867,10868,1 0880,10881,10882,10883,10884,7190,7191,7192,7187,7 188,7189,7178,7179,7180,7199,7200,7201,7196,7197,7 198,7211,7212,7213,7208,7209,7210,7175,7176,7177,7 193,7194,7195,7202,7203,7204,7205,7206,7207,7214,7 215,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 و خلاص من غير ما نفهم :Emoji7::Emoji4:
كل عام و انتم بخير يا شباب .. انا بكريت سيرفر حاليا و بتعلم و بستفيد من حاجات كتيره اكتشفتها و لقيتها مش موجوده بشكل منظم فإن شاء الله هجهز موضوع منظم و شرح قوي بفيديوهات و اي مشكله قابلتني و حليتها هقول حليتها ازاي
ندخل في المهم
جبتلكم كويري لطيف مش عارف اذا كان موجود في المنتدي بس دورت ملقيتش المهم وظيفته ان الوحوش متوقعش ال Trash او بنسميها القمامه.
لو معندكش وقت تقرأ ف ال Query اهو .. ادخل نفذه علطول و مش هتلاقي دروب فيه قمامه ان شاء الله
USE SRO_VT_SHARD -----> By-MrSwat <-----
delete from _RefMonster_AssignedItemDrop where RefItemID in (10681,10682,10683,10684,10685,10686,10663,10664,1 0665,10669,10670,10671,10699,10700,10701,10702,107 03,10693,10694,10695,10696,10697,10698,10666,10667 ,10668,10672,10673,10674,10687,10688,10689,10690,1 0691,10692,10675,10676,10677,10678,10679,10680,107 34,10735,10736,10737,10738,10739,10716,10717,10718 ,10722,10723,10724,10719,10720,10721,10725,10726,1 0727,10728,10729,10730,10731,10732,10733,10710,107 11,10712,10713,10714,10715,10704,10705,10706,10707 ,10708,10709,7140,7141,7142,7155,7156,7157,7152,71 53,7154,7143,7144,7145,7104,7105,7106,7107,7108,71 09,7164,7165,7166,7167,7168,7169,7110,7111,7112,71 13,7114,7115,7101,7102,7103,7122,7123,7124,7128,71 29,7130,7146,7147,7148,7149,7150,7151,7170,7171,71 72,7173,7174,7462,7463,7464,7131,7132,7133,7125,71 26,7127,7116,7117,7118,7119,7120,7121,7158,7159,71 60,7161,7162,7163,7134,7135,7136,7137,7138,7139,73 53,7354,7355,7356,7357,7358,7335,7336,7337,7338,73 39,7340,7365,7366,7367,7368,7369,7370,7347,7348,73 49,7350,7351,7352,7341,7342,7343,7344,7345,7346,73 59,7360,7361,7362,7363,7364,10613,10614,10615,1061 9,10620,10621,10616,10617,10618,10622,10623,10624, 10607,10608,10609,10610,10611,10612,10625,10626,10 627,10631,10632,10633,10601,10602,10603,10604,1060 5,10606,10658,10659,10660,10661,10662,10634,10635, 10628,10629,10630,10636,10640,10641,10642,10637,10 638,10639,10643,10644,10645,10646,10647,10648,1065 2,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,2504 1,25042,25039,25040,26076,26077,25081,25082,25083, 25084,25169,25170,25073,25074,25153,25154,25125,25 126,25123,25124,25119,25120,25143,25144,25135,2513 6,25021,25022,25121,25122,25061,25062,25059,25060, 25065,25066,25079,25080,25141,25142,25133,25134,25 075,25076,25031,25032,26070,26071,25027,25028,2606 6,26067,25145,25146,25055,25056,25179,25180,25175, 25176,25033,25034,26072,26073,25129,25130,25173,25 174,25051,25052,25053,25054,25089,25090,25085,2508 6,25087,25088,25163,25164,25023,25024,25103,25104, 25171,25172,25047,25048,25049,25050,26080,26081,25 139,25140,25137,25138,25071,25072,25045,25046,2504 3,25044,26078,26079,25111,25112,25109,25110,25167, 25168,25161,25162,25159,25160,25151,25152,25107,25 108,25101,25102,25099,25100,25097,25098,25091,2509 2,25095,25096,25093,25094,25105,25106,25131,25132, 25029,25030,25037,25038,25117,25118,26068,26069,25 063,25064,25077,25078,26074,26075,25057,25058,2515 7,25158,25035,25036,25165,25166,25147,25148,25177, 25178,25025,25026,25149,25150,25115,25116,25113,25 114,25155,25156,25015,25016,25127,25128,25017,2501 8,25067,25068,25011,25012,25069,25070,25013,25014, 25019,25020,7407,7408,7409,7410,7411,7412,7395,739 6,7397,7398,7399,7400,7413,7414,7415,7416,7417,740 1,7402,7403,7404,7405,7406,7389,7390,7391,7392,739 3,7394,7377,7378,7379,7380,7381,7382,7383,7384,738 5,7386,7387,7388,7371,7372,7373,7374,7375,7376,108 72,10873,10874,10833,10834,10835,10869,10870,10871 ,10875,10876,10877,10878,10879,10860,10861,10862,1 0749,10750,10743,10744,10745,10751,10758,10759,107 60,10779,10780,10773,10774,10775,10781,10782,10783 ,10784,10830,10831,10832,10812,10813,10806,10807,1 0808,10814,10824,10825,10826,23297,23298,23300,233 01,23302,23299,23303,23304,23305,23294,10848,10849 ,10850,23295,10851,10852,10853,23296,10854,10855,1 0856,10857,10858,10859,10821,10822,10815,10816,108 17,10823,10827,10828,10829,10800,10801,10788,10789 ,10790,10802,10809,10810,10811,10803,10804,10794,1 0795,10796,10805,10818,10819,10820,10863,10864,108 65,10761,10762,10755,10756,10757,10763,10767,10768 ,10769,10791,10792,10785,10786,10787,10793,10797,1 0798,10799,23285,23286,23288,23289,23290,23287,232 91,23292,23293,23282,10836,10837,10838,23283,10839 ,10840,10841,23284,10842,10843,10844,10845,10846,1 0847,10746,10747,23279,23280,23281,10748,10752,107 53,10740,10741,10742,10754,10770,10771,10764,10765 ,10766,10772,10776,10777,10778,10866,10867,10868,1 0880,10881,10882,10883,10884,7190,7191,7192,7187,7 188,7189,7178,7179,7180,7199,7200,7201,7196,7197,7 198,7211,7212,7213,7208,7209,7210,7175,7176,7177,7 193,7194,7195,7202,7203,7204,7205,7206,7207,7214,7 215,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 و خلاص من غير ما نفهم :Emoji7::Emoji4: