1886 Lunar var Bugu için ufak bi güncelleme SQL kodu

UPDATE EVENT SET ZoneNum = 61 WHERE ZoneNum = 101

UPDATE EVENT SET ZoneNum = 62 WHERE ZoneNum = 102

UPDATE EVENT SET ZoneNum = 63 WHERE ZoneNum = 103

UPDATE EVENT SET ZoneNum = 69 WHERE ZoneNum = 111

UPDATE EVENT SET ZoneNum = 71 WHERE ZoneNum = 201

UPDATE EVENT SET ZoneNum = 72 WHERE ZoneNum = 202

UPDATE EVENT SET ZoneNum = 73 WHERE ZoneNum = 203



UPDATE EVENT SET Exec1 = 61 WHERE Exec1 = 101

UPDATE EVENT SET Exec1 = 62 WHERE Exec1 = 102

UPDATE EVENT SET Exec1 = 63 WHERE Exec1 = 103

UPDATE EVENT SET Exec1 = 69 WHERE Exec1 = 111



UPDATE K_NPCPOS SET ZoneID = 61 WHERE ZoneID = 101

UPDATE K_NPCPOS SET ZoneID = 62 WHERE ZoneID = 102

UPDATE K_NPCPOS SET ZoneID = 63 WHERE ZoneID = 103

UPDATE K_NPCPOS SET ZoneID = 69 WHERE ZoneID = 111



UPDATE ZONE_INFO SET ZoneNo = 61, RoomEvent = 61 WHERE ZoneNo = 101

UPDATE ZONE_INFO SET ZoneNo = 62, RoomEvent = 62 WHERE ZoneNo = 102

UPDATE ZONE_INFO SET ZoneNo = 63, RoomEvent = 63 WHERE ZoneNo = 103

UPDATE ZONE_INFO SET ZoneNo = 69 WHERE ZoneNo = 111