Kral Forum



rel="publisher"

    Sorunsuz Ardream Monster Eklemek

    Paylaş
    avatar
    uÄŸur
    Admin
    Admin

    Mesaj Sayısı : 2372
    Karizma Puanı : 7113
    Kayıt tarihi : 02/04/10

    Sorunsuz Ardream Monster Eklemek

    Mesaj tarafından uÄŸur Bir Cuma Mayıs 21, 2010 8:07 am

    Ardreama Monster eklemekte sorunmu yaşıyorsunuz işte tam size göre
    Hiçbiyerde bu kadarı yok.
    Gözlerim şaşı olana kadar uğraştım.Ve hiçbiyeri alıntı değildir.
    Hemde Query hiç uğraşmanıza gerek kalmadı.
    Query analizerde üstten database inizi seçip alt boşluğa bu kodları yapıştırdıktan sonra F5 tuşuna basmanız işi bitirecektir.

    Kod:

    INSERT INTO [K_NPCPOS] Values (202,1690,1,0,0,0,0,610,395,630,412,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1690,1,0,0,0,0,588,401,610,426,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1691,1,0,0,0,0,559,349,575,365,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1691,1,0,0,0,0,530,369,549,382,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,742,278,742,278,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,542,195,542,195,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,334,858,334,858,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,491,932,500,945,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,890,809,915,828,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1401,1,0,0,0,0,860,590,860,590,0,0,0,0,1,16000,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1312,1,0,0,0,0,925,746,935,759,0,0,0,0,4,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1312,1,0,0,0,0,939,787,956,792,0,0,0,0,4,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1312,1,0,0,0,0,907,787,927,810,0,0,0,0,4,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1312,1,0,0,0,0,201,252,225,268,0,0,0,0,4,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1312,1,0,0,0,0,217,272,239,298,0,0,0,0,4,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,2023,1,0,0,0,0,369,489,489,509,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,2021,1,0,0,0,0,527,644,538,679,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,2021,1,0,0,0,0,504,619,524,639,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1821,1,0,0,0,0,590,721,610,742,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1821,1,0,0,0,0,606,688,626,710,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1901,1,0,0,0,0,633,659,653,679,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1901,1,0,0,0,0,632,620,649,639,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1901,1,0,0,0,0,618,630,638,650,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1823,1,0,0,0,0,580,621,599,642,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1743,1,0,0,0,0,384,726,410,742,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1743,1,0,0,0,0,414,700,436,721,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1743,1,0,0,0,0,439,729,461,749,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1742,1,0,0,0,0,315,646,335,666,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1742,1,0,0,0,0,359,640,372,662,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1742,1,0,0,0,0,375,669,389,681,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1695,1,0,0,0,0,561,454,571,474,0,0,0,0,4,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1695,1,0,0,0,0,562,425,579,442,0,0,0,0,4,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,840,418,840,418,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,762,552,762,562,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,569,393,572,415,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1821,1,0,0,0,0,575,689,589,710,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,456,393,475,400,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,415,676,415,676,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,188,483,188,483,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1402,1,0,0,0,0,209,262,209,262,0,0,0,0,1,2500,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1823,1,0,0,0,0,603,606,628,626,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1696,1,0,0,0,0,437,571,451,591,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1696,1,0,0,0,0,410,570,426,592,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1696,1,0,0,0,0,401,597,412,619,0,0,0,0,3,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1744,1,0,0,0,0,427,628,442,643,0,0,0,0,5,40,0,2,NULL)
    INSERT INTO [K_NPCPOS] Values (202,1744,1,0,0,0,0,486,652,512,673,0,0,0,0,5,40,0,2,NULL)



    İşte Buda Bonus

    Herhangi Bir itemi silmek istiyorsun ama item kodu falan zorluyormu seni.
    İşte bu kodla sadece silmek istediğin itemi bilmen yetiyor

    Mesela amulet of curse veya belt of curse (birçok serverda sorun yaratıyorlar)


    Kod:

    delete from item where strname like '%amulet of curse%'


    Bu kodun avantajlarından diğeri ise %li aralıklara yazdığınız kelimenin geçtiği tüm itemleri siliyor +5 +6 fln farketmeden hepsini.
    Umarım İşinize Yarar

      Forum Saati Cuma Ara. 15, 2017 11:30 pm