tarafından 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
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
