İlk olarak Kmonster:
Alıntı:
PHP- Kodu:
insert into K_Monster values (9998 , '[Queen]Bandicoot' , 800 , 160 , 0 , 0 , 0 , 1 , 0 , 8 , 0 , 0 , 0 , 10 , 1000 , 0 , 120 , 99 , 0 , 26 , 2 , 3 , 8 , 1700 , 3 , 4 , 1500 , 801 , 0 , 0 , 0 , 16 , 16 , 16 , 12 , 16 , 16 , 16 , 85 , 5 , 3 , 100 , 60 , 0 , 0 , 0)
insert into K_Monster values ( 9997 , '[ Worm Queen] hideous' , 700 , 155 , 0 , 0 , 0 , 1 , 0 , 7 , 0 , 0 , 0 , 10 , 500 , 0 , 100 , 25 , 0 , 10 , 1 , 1 , 20 , 2000 , 1 , 3 , 1000 , 750 , 0 , 0 , 0 , 9 , 9 , 9 , 8 , 9 , 9 , 9 , 75 , 5 , 3 , 80 , 13 , 0 , 0 , 0)
insert into K_Monster values (9996 , '[Queen]Scolar' , 1200 , 190 , 0 , 0 , 0 , 6 , 0 , 12 , 0 , 0 , 0 , 70 , 110000 , 0 , 9000 , 3268 , 0 , 331 , 66 , 162 , 500 , 1500 , 2 , 8 , 5000 , 1200 , 300103 , 0 , 0 , 76 , 66 , 66 , 46 , 66 , 66 , 66 , 100 , 25 , 7 , 120 , 772 , 1 , 2 , 0)
insert into K_Monster values (9995 , '[Queen]Kongau' , 1300 , 190 , 131510000 , 0 , 0 , 5 , 0 , 13 , 0 , 0 , 0 , 70 , 140000 , 0 , 8000 , 3754 , 0 , 650 , 75 , 186 , 1000 , 2500 , 2 , 8 , 5000 , 1300 , 0 , 0 , 0 , 69 , 69 , 69 , 49 , 69 , 69 , 69 , 200 , 5 , 10 , 120 , 855 , 0 , 0 , 0)
insert into K_Monster values ( 9994 , '[Queen]Death knight' , 6600 , 200 , 0 , 0 , 0 , 1 , 0 , 22 , 0 , 0 , 0 , 70 , 20000 , 0 , 10000 , 12000 , 1 , 300 , 124 , 124 , 1000 , 1500 , 2 , 8 , 5000 , 8758 , 0 , 0 , 0 , 55 , 55 , 55 , 55 , 55 , 55 , 55 , 55 , 5 , 15 , 100 , 18412 , 0 , 0 , 0)
insert into K_Monster values ( 9993 , '[Queen]Uruk Hai' , 1636 , 200 , 170150000 , 120350000 , 0 , 5 , 0 , 16 , 0 , 0 , 0 , 70 , 220000 , 0 , 15000 , 5491 , 0 , 500 , 226 , 200 , 1200 , 1500 , 2 , 7 , 5000 , 1692 , 0 , 0 , 0 , 154 , 154 , 154 , 154 , 154 , 154 , 154 , 250 , 5 , 10 , 90 , 1023 , 0 , 0 , 0)
insert into K_Monster values ( 9992 , '[Queen]Lamia' , 2000 , 140 , 0 , 0 , 0 , 5 , 0 , 20 , 0 , 0 , 0 , 70 , 300000 , 0 , 6000 , 5492 , 1 , 500 , 117 , 55 , 1000 , 800 , 2 , 6 , 3000 , 2001 , 300141 , 0 , 0 , 200 , 200 , 200 , 200 , 200 , 200 , 200 , 200 , 5 , 10 , 90 , 1023 , 0 , 2 , 0)
insert into K_Monster values (9991 , '[Queen]Dragon Tooth Skeleton' , 1102 , 200 , 0 , 0 , 0 , 5 , 0 , 22 , 0 , 0 , 0 , 70 , 500000 , 0 , 20000 , 9000 , 1 , 600 , 124 , 124 , 2000 , 1400 , 2 , 8 , 5000 , 8010 , 0 , 0 , 0 , 120 , 120 , 120 , 120 , 120 , 120 , 120 , 200 , 5 , 15 , 20 , 1315 , 0 , 0 , 0)
insert into K_Monster values ( 9990 , '[Queen]Treant' , 5200 , 200 , 0 , 0 , 0 , 5 , 0 , 54 , 0 , 0 , 0 , 70 , 460684 , 0 , 30000 , 5991 , 0 , 405 , 115 , 155 , 1500 , 2000 , 2 , 7 , 5000 , 5451 , 300322 , 0 , 0 , 85 , 160 , 120 , 120 , 120 , 120 , 120 , 200 , 12 , 15 , 90 , 654 , 2 , 2 , 0)
2.Olarak Monsterlarımızı Uskodaki Le 1/1 aynı Yerlere Dizelim.
Alıntı:
PHP- Kodu:
insert into K_Npcpos values (1 , 9996 , 1 , 0 , 0 , 0 , 0 , 541 , 504 , 541 , 504 , 541 , 504 , 541 , 504 , 1 , 9000 , 0 , 0 ,Null )
insert into K_Npcpos values (1 , 9995 , 1 , 0 , 0 , 0 , 0 , 1443 , 1453 , 1443 , 1453 , 1443 , 1453 , 1443 , 1453 , 1 , 9000 , 0 , 0 ,Null )
insert into K_Npcpos values (1 , 9993 , 1 , 0 , 0 , 0 , 0 , 1754 , 681 , 1754 , 681 , 1754 , 681 , 1754 , 681 , 1 , 9000 , 0 , 0 ,Null )
insert into K_Npcpos values (1 , 9992 , 1 , 0 , 0 , 0 , 0 , 956 , 470 , 956 , 470 , 956 , 470 , 956 , 470 , 1 , 9000 , 0 , 0 ,Null )
insert into K_Npcpos values (1 , 9991 , 1 , 0 , 0 , 0 , 0 , 965 , 515 , 965 , 515 , 965 , 515 , 965 , 515 , 1 , 9000 , 0 , 0 , Null )
insert into K_Npcpos values (1 , 9990 , 1 , 0 , 0 , 0 , 0 , 1170 , 170 , 1170 , 170 , 1170 , 170 , 1170 , 170 , 1 , 9000 , 0 , 0 , Null)
insert into K_Npcpos values (21 , 9998 , 1 , 0 , 0 , 0 , 0 , 617 , 475 , 617 , 475 , 617 , 475 , 617 , 475 , 1 , 9000 , 0 , 0 ,Null )
insert into K_Npcpos values (21 , 9997 , 1 , 0 , 0 , 0 , 0 , 642 , 403 , 642 , 403 , 642 , 403 , 642 , 403 , 1 , 9000 , 0 , 0 ,Null )
insert into K_Npcpos values (2 , 9996 , 1 , 0 , 0 , 0 , 0 , 1480 , 1488 , 1480 , 1488 , 1480 , 1488 , 1480 , 1488 , 1 , 9000 , 0 , 0 ,Null )
insert into K_Npcpos values (2 , 9995 , 1 , 0 , 0 , 0 , 0 , 655 , 285 , 655 , 285 , 655 , 285 , 655 , 285 , 1 , 9000 , 0 , 0 ,Null )
insert into K_Npcpos values (2 , 9993 , 1 , 0 , 0 , 0 , 0 , 366 , 1615 , 366 , 1615 , 366 , 1615 , 366 , 1615 , 1 , 9000 , 0 , 0 ,Null )
insert into K_Npcpos values (2 , 9992 , 1 , 0 , 0 , 0 , 0 , 1246 , 1584 , 1246 , 1584 , 1246 , 1584 , 1246 , 1584 , 1 , 9000 , 0 , 0 ,Null )
insert into K_Npcpos values (2 , 9991 , 1 , 0 , 0 , 0 , 0 , 1255 , 1492 , 1255 , 1492 , 1255 , 1492 , 1255 , 1492 , 1 , 9000 , 0 , 0 , Null )
insert into K_Npcpos values (2 , 9990 , 1 , 0 , 0 , 0 , 0 , 1015 , 1709 , 1015 , 1709 , 1015 , 1709 , 1015 , 1709 , 1 , 9000 , 0 , 0 ,Null )
3.Olarak Bosslarımızın içinden çıkan itemleri Ekliyelim Databaseye:
Alıntı:
PHP- Kodu:
insert into [ITEM] Values (910153000,'Mage Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99 ,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,4,0,0,3,10,40,5,5,5,5,5,5)
insert into [ITEM] Values (910154000,'Mercenary Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99 ,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,4,3,0,0,0,40,0,3,3,3,3,3,3)
insert into [ITEM] Values (910155000,'Assassin Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99 ,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,3,4,0,0,30,10,7,7,7,7,7,7)
insert into [ITEM] Values (910156000,'Priest Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99 ,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,4,0,3,0,25,20,3,3,3,3,3,3)
insert into [ITEM] Values (910164000,'Priest Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0 ,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,5,0,0,4,0,45,40,3,3,3,3,3,3)
insert into [ITEM] Values (910163000,'Assassin Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0 ,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,4,5,0,0,50,30,4,4,4,4,4,4)
insert into [ITEM] Values (910161000,'Messenger Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0 ,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,5,0,0,4,35,50,3,3,3,3,3,3)
insert into [ITEM] Values (910162000,'Mercenary Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0 ,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,5,4,0,0,0,70,0,2,2,2,2,2,2)
insert into [ITEM] Values (910157000,'Mercenary Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99, 0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0 ,0,4,3,4,0,0,80,20,0,0,0,0,0,0)
insert into [ITEM] Values (910158000,'Messenger Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99, 0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0 ,0,0,4,0,3,3,60,40,3,3,3,3,3,3)
insert into [ITEM] Values (910159000,'Cleric Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99, 0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0 ,0,3,4,0,3,0,50,50,2,2,2,2,2,2)
insert into [ITEM] Values (910160000,'Body Belt',94,14,0,0,0,100,0,0,1,640,0,0,0,0,0,1,99,0,0 ,0,0,0,0,0,0,4,10,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,6,0,0,0,50,0,0,0,0,0,0,0)
4.olarak:İtemlerimizi Ekledikten sona bosslarımızdan cıkmasını sağlıyalım:
Alıntı:
PHP- Kodu:
insert into K_MONSTER_ITEM values ( 9993 , 1993 , 7000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0)
insert into K_MONSTER_ITEM values ( 9992 , 1993 , 7000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0)
insert into K_MONSTER_ITEM values ( 9995 , 1993 , 7000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0)
insert into K_MONSTER_ITEM values ( 9996 , 1993 , 7000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0)
insert into K_MONSTER_ITEM values (9991 , 1993 , 7000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0)
insert into K_MONSTER_ITEM values ( 9997 , 1993 , 7000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0)
insert into K_MONSTER_ITEM values (9994 , 1993 , 7000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0)
insert into K_MONSTER_ITEM values ( 9998 , 1993 , 7000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0)
insert into K_MONSTER_ITEM values ( 9990 , 1993 , 7000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0)
Evt ARkadaşlar Bu kadar İşh işinizi yarar.iyi kulanmalar.iyi forumlar.
PHP- Kodu:
insert into MAKE_ITEM_GROUP values (1993 , 910156000 , 910153000 , 910154000 , 910155000 , 910157000 , 910158000 , 910156000 , 910153000 , 910154000 , 910162000 , 910159000 , 910164000 , 910163000 , 910160000 , 910155000 , 910161000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0)