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.
Attila'yı K_MONSTER tablosuna ekliyoruz.
Attila'yı K_NPCPOS tablosuna ekliyoruz.
Artık Attila aynı koordinatlarda doğmayacaktır. Kendi bölgesindeki beş farklı noktadan birinde doğacaktır.
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.