İletişim: [email protected]

MYKO Server'lar için ATTİLA Koordinatlarını Düzenlemek

'Prosedür & Query Kod Paylaşımları' forumunda Fatih42 tarafından 29 Ocak 2014 tarihinde açılan konu

  1. Fatih42

    Fatih42 New Member

    Katılım:
    29 Ocak 2014
    Mesaj:
    27
    Beğeniler:
    0
    Ödül Puanları:
    1
    MYKO Server'lar İçin ATTİLA Koordinatlarını Düzenlemek



    Aşağıdaki code'lar ile Attila'yı K_MONSTER ve K_NPCPOS tablosundan temizliyoruz.



    Kod:
    Delete from K_MONSTER where sSid = '1400'
    
    Delete from K_MONSTER where sSid = '1403'
    
    Delete from K_MONSTER where sSid = '1404'
    
    Delete from K_MONSTER where sSid = '1450'
    
    Delete from K_NPCPOS where NpcID = '1400'
    
    Delete from K_NPCPOS where NpcID = '1450'




    Attila'yı K_MONSTER tablosuna ekliyoruz.



    Kod:
    insert into [K_MONSTER] values ('1400','Attila','1400','100','0','0','0','5','0','14','0','0','0','85','430770','0','89650','13651','1','1224','261','649','2129','2000','2','9','5000','300104','300105','0','500','500','500','500','500','500','500','500','30','10','60','1940','1400','2','5','0');
    
    insert into [K_MONSTER] values ('1450','Attila','1400','100','0','0','0','5','0','14','0','0','0','85','430770','0','89650','13651','1','1224','261','649','2129','2000','2','9','5000','300104','300105','0','500','500','500','500','500','500','500','500','30','10','60','1940','1450','2','5','0');




    Attila'yı K_NPCPOS tablosuna ekliyoruz.



    Kod:
    insert into [K_NPCPOS] values ('2','1400','1','0','0','7','3','1706','725','1852','697','1707','728','1854','694','1','32000','0','0','NULL');
    
    insert into [K_NPCPOS] values ('2','1400','1','0','0','7','4','1320','972','1411','844','1320','976','1412','841','1','32000','0','0','NULL');
    
    insert into [K_NPCPOS] values ('2','1400','1','0','0','7','5','592','1132','651','894','592','1134','653','889','1','32000','0','0','NULL');
    
    insert into [K_NPCPOS] values ('2','1400','1','0','0','7','1','896','1658','996','1523','893','1659','1001','1519','1','32000','0','0','NULL');
    
    insert into [K_NPCPOS] values ('2','1400','1','0','0','7','2','328','826','477','708','324','833','475','702','1','32000','0','0','NULL');
    
    insert into [K_NPCPOS] values ('1','1450','1','0','0','7','1','993','1449','1040','1404','993','1451','1040','1402','1','32000','0','0','NULL');
    
    insert into [K_NPCPOS] values ('1','1450','1','0','0','7','2','1394','1198','1443','1123','1391','1199','1446','1122','1','32000','0','0','NULL');
    
    insert into [K_NPCPOS] values ('1','1450','1','0','0','7','3','824','557','957','447','822','558','963','445','1','32000','0','0','NULL');
    
    insert into [K_NPCPOS] values ('1','1450','1','0','0','7','4','1478','937','1521','799','1477','943','1523','796','1','32000','0','0','NULL');
    
    insert into [K_NPCPOS] values ('1','1450','1','0','0','7','5','1592','1175','1674','1128','1592','1177','1675','1127','1','32000','0','0','NULL');


    Artık Attila aynı koordinatlarda doğmayacaktır. Kendi bölgesindeki beş farklı noktadan birinde doğacaktır.
     

Bu Sayfayı Paylaş