Bifrost Yaratıklarını Her Açıdan Düzenleme

'Prosedür & Kod Paylaşımları' forumunda qarizma tarafından 23 Tem 2016 tarihinde açılan konu

Konu etiketleri:
  1. qarizma

    qarizma Yeni Cüce

    Katılım:
    23 Tem 2016
    Mesaj:
    50
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    Bifrost yaratıklarının özelliklerini(damage, HP vb.) orjinal; Bifrost'taki yerlerini de Usko'ya yakın yapmak isteyen arkadaşlar için aşağıdaki code'ları paylaşıyorum.


    Öncelikle Bifrost yaratıklarını orjinal özellikleri ile database'imize ekleyelim.

    Kod:
    Delete from K_MONSTER where ssid = '5801'
Delete from K_MONSTER where ssid = '5851'
Delete from K_MONSTER where ssid = '5901'
Delete from K_MONSTER where ssid = '5951'
Delete from K_MONSTER where ssid = '6001'
Delete from K_MONSTER where ssid = '6051'
Delete from K_MONSTER where ssid = '6101'
Delete from K_MONSTER where ssid = '6151'
Delete from K_MONSTER where ssid = '6201'
Delete from K_MONSTER where ssid = '6251'
Delete from K_MONSTER where ssid = '6301'
Delete from K_MONSTER where ssid = '6351'
Delete from K_MONSTER where ssid = '6401'
Delete from K_MONSTER where ssid = '6451'
Delete from K_MONSTER where ssid = '6501'
Delete from K_MONSTER where ssid = '6551'
Delete from K_MONSTER where ssid = '6601'
Delete from K_MONSTER where ssid = '6651'


insert into [K_MONSTER] values ('5801','Ego','5500','100','0','0','0','5','9','58','0','0','0','110','322128','0','35005','5492','1','2015','489','1218','3835','1500','3','8','4000','300351','0','0','150','150','150','150','150','700','150','200','5','25','45','11436','5801','2','2','0');
insert into [K_MONSTER] values ('5851','Ego','5500','100','0','0','0','5','9','58','0','0','0','110','322128','0','35005','5492','1','2015','489','1218','3835','1500','3','8','4000','300351','0','0','150','150','150','150','150','700','150','200','5','25','45','11436','5851','2','2','0');
insert into [K_MONSTER] values ('5901','Glutton','5501','130','0','0','0','5','0','59','0','0','0','130','541116','0','61775','8550','1','2234','744','1855','5253','1500','3','8','4000','300361','0','0','220','220','220','220','220','750','220','200','5','25','45','14877','5901','2','2','0');
insert into [K_MONSTER] values ('5951','Glutton','5501','130','0','0','0','5','0','59','0','0','0','130','541116','0','61775','8550','1','2234','744','1855','5253','1500','3','8','4000','300361','0','0','220','220','220','220','220','750','220','200','5','25','45','14877','5951','2','2','0');
insert into [K_MONSTER] values ('6001','Wrath','5502','100','0','0','0','1','0','60','0','0','0','145','827613','0','81009','8550','1','2525','984','2455','7055','1500','3','8','4000','0','300371','0','290','290','290','290','290','800','290','200','5','25','45','18947','6001','2','5','0');
insert into [K_MONSTER] values ('6051','Wrath','5502','100','0','0','0','1','0','60','0','0','0','145','827613','0','81009','8550','1','2525','984','2455','7055','1500','3','8','4000','0','300371','0','290','290','290','290','290','800','290','200','5','25','45','18947','6051','2','5','0');
insert into [K_MONSTER] values ('6101','Sloth','5503','240','0','0','0','1','3','61','0','0','0','160','1197063','0','82203','5492','1','3456','1270','3171','13047','1700','2','6','4000','0','300381','0','1200','1200','1200','1200','1200','1200','1200','200','5','25','45','17035','6101','2','5','0');
insert into [K_MONSTER] values ('6151','Sloth','5503','240','0','0','0','1','3','61','0','0','0','160','1197063','0','82203','5492','1','3456','1270','3171','13047','1700','2','6','4000','0','300381','0','1200','1200','1200','1200','1200','1200','1200','200','5','25','45','17035','6151','2','5','0');
insert into [K_MONSTER] values ('6201','Lust','5504','120','0','0','0','1','0','62','0','0','0','175','2391795','0','120533','8550','1','4055','1607','4013','16077','1500','3','8','4000','300391','0','0','1500','1500','1500','1500','1500','1500','1500','200','5','25','45','21037','6201','2','2','0');
insert into [K_MONSTER] values ('6251','Lust','5504','120','0','0','0','1','0','62','0','0','0','175','2391795','0','120533','8550','1','4055','1607','4013','16077','1500','3','8','4000','300391','0','0','1500','1500','1500','1500','1500','1500','1500','200','5','25','45','21037','6251','2','2','0');
insert into [K_MONSTER] values ('6301','Envy','5505','120','0','0','0','1','0','63','0','0','0','190','3393441','0','160355','8550','1','5077','1999','4991','19035','1500','3','8','4000','0','300401','0','1800','1800','1800','1800','1800','1800','1800','200','5','25','45','25067','6301','2','5','0');
insert into [K_MONSTER] values ('6351','Envy','5505','120','0','0','0','1','0','63','0','0','0','190','3393441','0','160355','8550','1','5077','1999','4991','19035','1500','3','8','4000','0','300401','0','1800','1800','1800','1800','1800','1800','1800','200','5','25','45','25067','6351','2','5','0');
insert into [K_MONSTER] values ('6401','Greed','5506','120','0','0','0','1','0','64','0','0','0','210','6700977','0','217755','8550','1','6073','2612','6525','22003','1500','3','8','4000','0','300411','0','2100','2100','2100','2100','2100','2100','2100','200','5','25','45','29078','6401','2','5','0');
insert into [K_MONSTER] values ('6451','Greed','5506','120','0','0','0','1','0','64','0','0','0','210','6700977','0','217755','8550','1','6073','2612','6525','22003','1500','3','8','4000','0','300411','0','2100','2100','2100','2100','2100','2100','2100','200','5','25','45','29078','6451','2','5','0');
insert into [K_MONSTER] values ('6501','Ultima','5508','120','910075231','0','0','6','0','65','0','0','0','250','14197815','0','847452','8550','1','7577','3565','10467','32000','1700','3','8','4000','0','300431','0','3000','3000','3000','3000','3000','3000','3000','300','5','25','45','39007','6501','2','5','0');
insert into [K_MONSTER] values ('6551','Ultima','5508','120','910075231','0','0','6','0','65','0','0','0','250','14197815','0','847452','8550','1','7577','3565','10467','32000','1700','3','8','4000','0','300431','0','3000','3000','3000','3000','3000','3000','3000','300','5','25','45','39007','6551','2','5','0');
insert into [K_MONSTER] values ('6601','Ashiton','5507','100','0','0','0','5','9','66','0','0','0','110','162045','0','21510','5492','1','1350','489','1218','3757','1300','3','9','3000','0','0','0','650','650','650','650','650','650','650','200','5','25','45','7105','6601','0','0','0');
insert into [K_MONSTER] values ('6651','Ashiton','5507','100','0','0','0','5','9','66','0','0','0','110','162045','0','21510','5492','1','1350','489','1218','3757','1300','3','9','3000','0','0','0','650','650','650','650','650','650','650','200','5','25','45','7105','6651','0','0','0');



    Şimdi Bifrost'a özgü yaratıkları Usko'daki doğma yerlerine yaklaşık olarak yerleştirelim.

    Kod:
    ------ Ego ------
insert into [K_NPCPOS] values ('31','5801','1','0','0','0','0','249','739','251','734','242','746','255','731','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5801','1','0','0','0','0','231','777','233','772','224','784','237','769','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5801','1','0','0','0','0','238','758','240','753','231','765','244','750','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5801','1','0','0','0','0','249','762','251','757','242','769','255','754','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5801','1','0','0','0','0','243','781','245','776','236','788','249','773','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5801','1','0','0','0','0','217','790','219','785','210','797','223','782','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5801','1','0','0','0','0','229','766','231','761','222','773','235','758','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5801','1','0','0','0','0','251','773','253','768','244','780','257','765','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5801','1','0','0','0','0','237','744','239','739','230','751','243','739','1','60','0','0','NULL');


------- Glutton ------
insert into [K_NPCPOS] values ('31','5901','1','0','0','0','0','772','766','774','761','765','773','778','761','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5901','1','0','0','0','0','824','765','826','760','817','772','830','760','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5901','1','0','0','0','0','799','759','801','754','792','766','805','754','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5901','1','0','0','0','0','759','793','761','788','752','800','765','788','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5901','1','0','0','0','0','812','775','814','770','805','782','818','770','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5901','1','0','0','0','0','825','792','827','787','818','799','831','787','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5901','1','0','0','0','0','805','809','807','804','798','816','811','804','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5901','1','0','0','0','0','841','790','843','785','834','797','847','785','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','5901','1','0','0','0','0','790','791','792','786','783','798','796','786','1','60','0','0','NULL');


------- Wrath ------
insert into [K_NPCPOS] values ('31','6001','1','0','0','0','0','634','393','636','388','627','400','640','388','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6001','1','0','0','0','0','643','399','645','394','636','406','649','394','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6001','1','0','0','0','0','656','393','658','388','649','400','662','388','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6001','1','0','0','0','0','651','378','653','373','644','385','657','373','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6001','1','0','0','0','0','642','374','644','369','635','381','648','369','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6001','1','0','0','0','0','629','377','631','372','622','384','635','372','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6001','1','0','0','0','0','641','387','643','382','634','394','647','382','1','60','0','0','NULL');


------- Sloth -------
insert into [K_NPCPOS] values ('31','6101','1','0','0','0','0','489','480','491','475','482','487','495','475','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6101','1','0','0','0','0','477','431','479','426','470','438','483','426','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6101','1','0','0','0','0','432','466','434','461','425','473','438','461','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6101','1','0','0','0','0','386','492','388','487','379','499','392','487','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6101','1','0','0','0','0','416','534','418','529','409','541','422','529','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6101','1','0','0','0','0','448','508','450','503','441','515','454','503','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6101','1','0','0','0','0','417','446','419','441','410','453','423','441','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6101','1','0','0','0','0','412','492','414','487','405','499','418','487','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6101','1','0','0','0','0','398','524','400','519','391','531','404','519','1','60','0','0','NULL');


------ Lust ------
insert into [K_NPCPOS] values ('31','6201','1','0','0','0','0','127','164','129','159','120','171','133','159','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6201','1','0','0','0','0','139','167','141','162','132','174','145','162','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6201','1','0','0','0','0','145','148','147','143','138','155','151','143','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6201','1','0','0','0','0','129','142','131','137','122','149','135','137','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6201','1','0','0','0','0','141','158','143','153','134','165','147','153','1','60','0','0','NULL');


------ Envy --------
insert into [K_NPCPOS] values ('31','6301','1','0','0','0','0','497','208','499','203','492','203','494','213','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6301','1','0','0','0','0','545','209','547','204','540','204','542','214','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6301','1','0','0','0','0','546','163','548','158','541','158','543','168','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6301','1','0','0','0','0','499','162','501','157','494','157','496','167','1','60','0','0','NULL');


------ Greed ------
insert into [K_NPCPOS] values ('31','6401','1','0','0','0','0','788','190','790','185','781','197','794','185','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6401','1','0','0','0','0','802','191','804','186','795','198','808','186','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6401','1','0','0','0','0','816','190','818','185','809','197','822','185','1','60','0','0','NULL');


----- Ultima ------
insert into [K_NPCPOS] values ('31','6501','1','0','0','0','0','953','183','955','178','948','178','950','188','1','30','0','0','NULL');


----- Ashiton ------
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','731','519','733','514','724','526','737','514','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','218','180','220','175','211','187','224','175','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','234','183','236','178','227','190','240','178','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','928','184','930','179','921','191','934','179','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','101','209','103','204','94','216','107','204','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','118','232','120','227','111','239','124','227','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','118','260','120','255','111','267','124','255','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','140','289','142','284','133','296','146','284','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','137','322','139','317','130','329','143','317','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','319','558','321','553','312','565','325','553','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','737','603','739','598','730','610','743','598','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','729','559','731','554','722','566','735','554','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','744','478','746','473','737','485','750','473','1','60','0','0','NULL');
insert into [K_NPCPOS] values ('31','6601','1','0','0','0','0','783','406','785','401','776','413','789','401','1','60','0','0','NULL');


-------------- Messenger of the God Pathos ------------------------
insert into [K_NPCPOS] values ('31','5201','1','0','0','0','0','945','194','947','189','940','189','942','199','1','30','0','0','NULL');
insert into [K_NPCPOS] values ('31','5201','1','0','0','0','0','961','195','963','190','956','190','958','200','1','30','0','0','NULL');
insert into [K_NPCPOS] values ('31','5201','1','0','0','0','0','962','172','964','167','957','167','959','177','1','30','0','0','NULL');
insert into [K_NPCPOS] values ('31','5201','1','0','0','0','0','946','173','948','168','941','168','943','178','1','30','0','0','NULL');
insert into [K_NPCPOS] values ('31','5201','1','0','0','0','0','941','183','943','178','936','178','938','188','1','30','0','0','NULL');


    Arkadaşlar bildiğimiz gibi Usko'da Bifrost'ta sadece Bifrost'a özgü yaratıklar bulunmamaktadır. O yaratıkları database'imize ekleyelim.

    Kod:
    ------------ Ape ------------
insert into [K_MONSTER] values ('4231','Ape','4000','110','0','0','0','1','0','42','0','0','0','42','462375','0','3255','2685','0','412','54','134','203','1500','5','7','5000','0','0','0','105','105','105','105','105','105','105','100','10','15','50','668','4231','0','0','0');

--------- Lamiros ----------
insert into [K_MONSTER] values ('2031','Lamiros','2000','100','0','0','0','1','0','20','0','0','0','70','1012500','0','5389','5492','1','567','165','86','1259','800','2','6','3000','300142','0','0','300','300','300','300','300','300','300','300','5','10','45','1309','2031','0','2','0');

-------- Harpy ---------
insert into [K_MONSTER] values ('2231','Harpy','2200','100','0','0','0','5','0','22','0','0','0','70','2914200','0','16167','5492','1','504','165','252','1180','1500','2','6','3000','300134','0','0','100','100','100','100','100','100','154','250','5','15','45','2621','2231','0','2','0');


    Şimdi Ape, Lamiros ve Harpy'i Bifrost'taki bulundukları yerlere yaklaşık olarak yerleştirelim.

    Kod:
    ------------ Ape ------------
insert into [K_NPCPOS] values ('31','4231','1','0','0','0','0','816','195','818','190','811','190','813','200','1','5','0','0','NULL');
insert into [K_NPCPOS] values ('31','4231','1','0','0','0','0','817','183','819','178','812','178','814','188','1','5','0','0','NULL');
insert into [K_NPCPOS] values ('31','4231','1','0','0','0','0','804','182','806','177','799','177','801','187','1','5','0','0','NULL');
insert into [K_NPCPOS] values ('31','4231','1','0','0','0','0','794','187','796','182','789','182','791','192','1','5','0','0','NULL');


--------- Lamiros ----------
insert into [K_NPCPOS] values ('31','2031','1','0','0','0','0','521','159','523','154','516','154','518','164','1','5','0','0','NULL');
insert into [K_NPCPOS] values ('31','2031','1','0','0','0','0','497','184','499','179','492','179','494','189','1','5','0','0','NULL');
insert into [K_NPCPOS] values ('31','2031','1','0','0','0','0','521','206','523','201','516','201','518','211','1','5','0','0','NULL');
insert into [K_NPCPOS] values ('31','2031','1','0','0','0','0','545','184','547','179','540','179','542','189','1','5','0','0','NULL');


-------- Harpy ---------
insert into [K_NPCPOS] values ('31','2231','1','0','0','0','0','181','177','183','172','176','172','178','182','1','5','0','0','NULL');
insert into [K_NPCPOS] values ('31','2231','1','0','0','0','0','178','185','180','180','173','180','175','190','1','5','0','0','NULL');
insert into [K_NPCPOS] values ('31','2231','1','0','0','0','0','185','188','187','183','180','183','182','193','1','5','0','0','NULL');

    İyi günler.
     
    qarizma, 23 Tem 2016
    #1
  2. 75e8r

    75e8r Yeni Cüce

    Katılım:
    26 Tem 2016
    Mesaj:
    9
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    Her şey her şey htrthtr
     
    75e8r, 26 Tem 2016
    #2
  3. beyFenDy

    beyFenDy Yeni Cüce

    Katılım:
    23 Eyl 2016
    Mesaj:
    7
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    emeğine sağlık
     
    beyFenDy, 23 Eyl 2016
    #3
  4. ahmet71

    ahmet71 Yeni Cüce

    Katılım:
    26 Eyl 2016
    Mesaj:
    8
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    bune len ne işe yarıyo :D
     
    ahmet71, 26 Eyl 2016
    #4
  5. lafadam

    lafadam Yeni Cüce

    Katılım:
    29 Kas 2016
    Mesaj:
    19
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    çok y[I[/I]
     
    lafadam, 14 Ara 2016
    #5
  6. aöma

    aöma Yeni Cüce

    Katılım:
    23 Ara 2016
    Mesaj:
    11
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    tamamdır brotamamdır bro
     
    aöma, 23 Ara 2016
    #6
  7. dene

    dene Yeni Cüce

    Katılım:
    2 Oca 2017
    Mesaj:
    9
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    helal olsun broooo
     
    dene, 2 Oca 2017
    #7
  8. coss

    coss Yeni Cüce

    Katılım:
    29 Ara 2016
    Mesaj:
    17
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    sadece insert kullanılabilir mi? kullanılirse ne işe yarar
     
    coss, 5 Oca 2017
    #8
  9. muraat

    muraat Yeni Cüce

    Katılım:
    15 Oca 2017
    Mesaj:
    7
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    iyi güzel şeyler öğreniyoruz

    ---------- Post added at 11:19 PM ---------- Previous post was at 11:18 PM ----------

    hadi hepinize bol şans
     
    muraat, 15 Oca 2017
    #9
  10. okan19

    okan19 Yeni Cüce

    Katılım:
    22 Oca 2017
    Mesaj:
    6
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    aaaaaaaaaaaaaa
     
    okan19, 22 Oca 2017
    #10
  11. nagi

    nagi Yeni Cüce

    Katılım:
    23 Oca 2017
    Mesaj:
    5
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    tesekkur ederim harika
     
    nagi, 23 Oca 2017
    #11
  12. den

    den Yeni Cüce

    Katılım:
    25 Oca 2017
    Mesaj:
    11
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    emeğine sağlık arkadaşım
     
    den, 25 Oca 2017
    #12
  13. ceksonnn

    ceksonnn Yeni Cüce

    Katılım:
    27 Oca 2017
    Mesaj:
    5
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    Selam`

    hayrili aksamlar
     
    ceksonnn, 27 Oca 2017
    #13
  14. abc123

    abc123 Yeni Cüce

    Katılım:
    29 Oca 2017
    Mesaj:
    9
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    teşekkürler
     
    abc123, 29 Oca 2017
    #14
  15. halkasızsaturn

    halkasızsaturn Yeni Cüce

    Katılım:
    7 Şub 2017
    Mesaj:
    10
    Alınan Beğeniler:
    0
    Ödül Puanları:
    0
    aüüüüsppeeerrrrr
     
    halkasızsaturn, 7 Şub 2017
    #15

Bu Sayfayı Paylaş