Quote:
Originally Posted by Alex202048
Can you tell me please more about that? How i can set this?
|
--Search for certain maps
select DISTINCT w.text_id,location_type,s.value
from WorldLocation w inner join StringResource_EN s
on text_id = code
where value like '%
katan%'
70060300 2 West of Katan
70060302 2 Katan Champion Field
70060303 2 Katan Champion Field
70060400 2 Katan NW
70070300 2 Katan Field
70070301 1 Katan
70070303 5 Katan Arena
70070307 1 Katan Training Field
70070309 2 Katan Champion Field
70070310 2 Katan Champion Field
70070311 2 Katan Champion Field
70070400 2 Northeast of Katan
--shows all locations like town location_type 1 = town
select DISTINCT text_id,value
from WorldLocation inner join StringResource_EN
on text_id = code
where location_type = 1
70000010 Laksy
70070301 Katan
70070307 Katan Training Field
70070801 Laksy's Anchor
70070806 Laksy's Anchor
70070807 Laksy Training Field
70080601 Rondo
70080607 Rondo Training Field
70090401 Horizon
70090407 Horizon Training Field
70090903 City of Ruins
70100305 Trainee Town
70110200 Navislamia
70110201 Navislamia Wheelhouse
70110202 Navislamia Galley
70110203 Navislamia Grand Cabin
70110204 Navislamia_warehouse
70110205 Port Crew Cabin
70110206 Navislamia_food warehouse
70110207 A Tear In Reality
70110208 Starboard Crew Cabin
70110209 High Priest's Private Lab
70110210 Navislamia_captain's cabin
70130100 Hidden Village
70130101 Hidden Village
70130107 Hidden Village Training Field
70130120 Hidden Village<Renewal>
70130121 Hidden Village<Renewal>
70130122 Hidden Village Training Field<Renewal>
-- location_type 10 = fleamarket available for shops.
update WorldLocation
set location_type = 10
where text_id = 70000010 -- makes katan town like flea market.
goodluck.