This SQL string for change 270 NPC Name from China to English
Quote:
UPDATE cq_map SET `name`='NPCCamp' WHERE id=100;
UPDATE cq_map SET `name`='Market' WHERE id=200;
UPDATE cq_map SET `name`='Prison' WHERE id=300;
UPDATE cq_map SET `name`='RepentantForest' WHERE id=310;
UPDATE cq_map SET `name`='GuideCity1' WHERE id=401;
UPDATE cq_map SET `name`='GuildCity2' WHERE id=402;
UPDATE cq_map SET `name`='TrainGround' WHERE id=500;
UPDATE cq_map SET `name`='House-A' WHERE id=501;
UPDATE cq_map SET `name`='House-AA' WHERE id=502;
UPDATE cq_map SET `name`='House-AAA' WHERE id=503;
UPDATE cq_map SET `name`='poills' WHERE id=600;
UPDATE cq_map SET `name`='OfflineTG' WHERE id=601;
UPDATE cq_map SET `name`='CimeliaMap' WHERE id=700;
UPDATE cq_map SET `name`='castle' WHERE id=801;
UPDATE cq_map SET `name`='Cronus' WHERE id=1000;
UPDATE cq_map SET `name`='DragonHill' WHERE id=1010;
UPDATE cq_map SET `name`='ElephantHill' WHERE id=1020;
UPDATE cq_map SET `name`='LegionLand' WHERE id=1100;
UPDATE cq_map SET `name`='RestingPlace' WHERE id=1101;
UPDATE cq_map SET `name`='AshyMine' WHERE id=1500;
UPDATE cq_map SET `name`='AshyMine' WHERE id=1510;
UPDATE cq_map SET `name`='MercenaryLegion' WHERE id=1600;
UPDATE cq_map SET `name`='EvilAltar' WHERE id=1901;
UPDATE cq_map SET `name`='BraveLand' WHERE id=1902;
UPDATE cq_map SET `name`='Maze-A' WHERE id=1903;
UPDATE cq_map SET `name`='Maze-B' WHERE id=1904;
UPDATE cq_map SET `name`='Maze-C' WHERE id=1905;
UPDATE cq_map SET `name`='Maze-D' WHERE id=1906;
UPDATE cq_map SET `name`='NewYearRoom' WHERE id=1914;
UPDATE cq_map SET `name`='VenusGarden' WHERE id=1917;
UPDATE cq_map SET `name`='MarsGarden' WHERE id=1918;
UPDATE cq_map SET `name`='JupiterGarden' WHERE id=1919;
UPDATE cq_map SET `name`='JunoGarden' WHERE id=1920;
UPDATE cq_map SET `name`='JupiterGarden' WHERE id=1921;
UPDATE cq_map SET `name`='DawnPlain' WHERE id=1922;
UPDATE cq_map SET `name`='FoggyDesert' WHERE id=1923;
UPDATE cq_map SET `name`='FlameMarsh' WHERE id=1924;
UPDATE cq_map SET `name`='SnowField' WHERE id=1925;
UPDATE cq_map SET `name`='ApolloGarden' WHERE id=1931;
UPDATE cq_map SET `name`='CoralGarden' WHERE id=1932;
UPDATE cq_map SET `name`='LilyGarden' WHERE id=1933;
UPDATE cq_map SET `name`='TulipGarden' WHERE id=1934;
UPDATE cq_map SET `name`='SunlightGarden' WHERE id=1935;
UPDATE cq_map SET `name`='DragonCave' WHERE id=1940;
UPDATE cq_map SET `name`='CataFort1' WHERE id=1950;
UPDATE cq_map SET `name`='CataFort2' WHERE id=1951;
UPDATE cq_map SET `name`='CataFort3' WHERE id=1952;
UPDATE cq_map SET `name`='CataFort4' WHERE id=1953;
UPDATE cq_map SET `name`='CataFort5' WHERE id=1954;
UPDATE cq_map SET `name`='CataFort6' WHERE id=1955;
UPDATE cq_map SET `name`='AbyssalPalace' WHERE id=1960;
UPDATE cq_map SET `name`='DarkCastle' WHERE id=1980;
UPDATE cq_map SET `name`='DarkCastle' WHERE id=1981;
UPDATE cq_map SET `name`='DarkCastle' WHERE id=1982;
UPDATE cq_map SET `name`='DarkCastle' WHERE id=1983;
UPDATE cq_map SET `name`='DarkCastle' WHERE id=1984;
UPDATE cq_map SET `name`='DarkCastle' WHERE id=1985;
UPDATE cq_map SET `name`='DarkCastle' WHERE id=1986;
UPDATE cq_map SET `name`='DarkCastle' WHERE id=1987;
UPDATE cq_map SET `name`='DarkCastle' WHERE id=1988;
UPDATE cq_map SET `name`='DarkCastle' WHERE id=1989;
UPDATE cq_map SET `name`='BelialCastle' WHERE id=1990;
UPDATE cq_map SET `name`='ElvenCity' WHERE id=2000;
UPDATE cq_map SET `name`='MistyMarsh' WHERE id=2010;
UPDATE cq_map SET `name`='NailoTempleF1' WHERE id=2501;
UPDATE cq_map SET `name`='NailoTempleF2' WHERE id=2502;
UPDATE cq_map SET `name`='NailoTempleF3' WHERE id=2503;
UPDATE cq_map SET `name`='GobiDesert' WHERE id=3000;
UPDATE cq_map SET `name`='DragonWolds' WHERE id=3010;
UPDATE cq_map SET `name`='SaintOLake' WHERE id=3020;
UPDATE cq_map SET `name`='LifeFountain' WHERE id=3030;
UPDATE cq_map SET `name`='DreamyOasis' WHERE id=3040;
UPDATE cq_map SET `name`='IcyLand' WHERE id=4000;
UPDATE cq_map SET `name`='IcyPalaceF1' WHERE id=4010;
UPDATE cq_map SET `name`='IcyPalaceF2' WHERE id=4020;
UPDATE cq_map SET `name`='IcyPalaceF3' WHERE id=4030;
UPDATE cq_map SET `name`='IcyPalaceF4' WHERE id=4040;
UPDATE cq_map SET `name`='Island' WHERE id=5000;
UPDATE cq_map SET `name`='Lostland' WHERE id=5100;
UPDATE cq_map SET `name`='CataMaze' WHERE id=5200;
UPDATE cq_map SET `name`='IceMaze' WHERE id=5400;
UPDATE cq_map SET `name`='IslandMine' WHERE id=5500;
UPDATE cq_map SET `name`='IslandMine' WHERE id=5510;
UPDATE cq_map SET `name`='Volcano' WHERE id=6000;
UPDATE cq_map SET `name`='EvilBeach' WHERE id=6010;
UPDATE cq_map SET `name`='GloryField' WHERE id=6020;
UPDATE cq_map SET `name`='LavaForest' WHERE id=6030;
UPDATE cq_map SET `name`='FireHell' WHERE id=6040;
UPDATE cq_map SET `name`='DarkMarsh' WHERE id=7000;
UPDATE cq_map SET `name`='wildnessMarsh' WHERE id=7050;
UPDATE cq_map SET `name`='QuestMaze1' WHERE id=8001;
UPDATE cq_map SET `name`='QuestMaze2' WHERE id=8002;
UPDATE cq_map SET `name`='QuestMaze3' WHERE id=8003;
UPDATE cq_map SET `name`='QuestMaze4' WHERE id=8004;
UPDATE cq_map SET `name`='QuestMaze5' WHERE id=8005;
UPDATE cq_map SET `name`='QuestMaze6' WHERE id=8006;
UPDATE cq_map SET `name`='QuestMaze7' WHERE id=8007;
UPDATE cq_map SET `name`='QuestMaze8' WHERE id=8008;
UPDATE cq_map SET `name`='QuestMaze9' WHERE id=8009;
UPDATE cq_map SET `name`='QuestMaze10' WHERE id=8010;
UPDATE cq_map SET `name`='QuestMaze11' WHERE id=8011;
UPDATE cq_map SET `name`='QuestMaze12' WHERE id=8012;
UPDATE cq_map SET `name`='QuestMaze13' WHERE id=8013;
UPDATE cq_map SET `name`='QuestMaze14' WHERE id=8014;
UPDATE cq_map SET `name`='QuestMaze15' WHERE id=8015;
UPDATE cq_map SET `name`='HeartLake0' WHERE id=8100;
UPDATE cq_map SET `name`='HeartLake1' WHERE id=8101;
UPDATE cq_map SET `name`='HeartLake2' WHERE id=8102;
UPDATE cq_map SET `name`='HeartLake3' WHERE id=8103;
UPDATE cq_map SET `name`='HeartLake4' WHERE id=8104;
UPDATE cq_map SET `name`='HeartLake5' WHERE id=8105;
UPDATE cq_map SET `name`='HeartLake6' WHERE id=8106;
UPDATE cq_map SET `name`='HeartLake7' WHERE id=8107;
UPDATE cq_map SET `name`='HeartLake8' WHERE id=8108;
UPDATE cq_map SET `name`='HeartLake9' WHERE id=8109;
UPDATE cq_map SET `name`='HeartLake10' WHERE id=8110;
UPDATE cq_map SET `name`='RandomMaze' WHERE id=8200;
UPDATE cq_map SET `name`='MysticalRoom01' WHERE id=8201;
UPDATE cq_map SET `name`='MysticalRoom02' WHERE id=8202;
UPDATE cq_map SET `name`='MysticalRoom03' WHERE id=8203;
UPDATE cq_map SET `name`='MirrorMaze' WHERE id=8300;
UPDATE cq_map SET `name`='MirrorMaze1' WHERE id=8301;
UPDATE cq_map SET `name`='MirrorMaze2' WHERE id=8302;
UPDATE cq_map SET `name`='MirrorMaze3' WHERE id=8303;
UPDATE cq_map SET `name`='MirrorMaze4' WHERE id=8304;
UPDATE cq_map SET `name`='MirrorMaze5' WHERE id=8305;
UPDATE cq_map SET `name`='MirrorMaze6' WHERE id=8306;
UPDATE cq_map SET `name`='MirrorMaze7' WHERE id=8307;
UPDATE cq_map SET `name`='MirrorMaze8' WHERE id=8308;
UPDATE cq_map SET `name`='IllusoryArea1-1' WHERE id=8401;
UPDATE cq_map SET `name`='IllusoryArea1-2' WHERE id=8402;
UPDATE cq_map SET `name`='IllusoryArea1-3' WHERE id=8403;
UPDATE cq_map SET `name`='IllusoryArea1-4' WHERE id=8404;
UPDATE cq_map SET `name`='IllusoryArea1-5' WHERE id=8405;
UPDATE cq_map SET `name`='IllusoryArea1-6' WHERE id=8406;
UPDATE cq_map SET `name`='IllusoryArea1-7' WHERE id=8407;
UPDATE cq_map SET `name`='IllusoryArea1-8' WHERE id=8408;
UPDATE cq_map SET `name`='IllusoryArea1-9' WHERE id=8409;
UPDATE cq_map SET `name`='IllusoryArea1-1' WHERE id=8410;
UPDATE cq_map SET `name`='IllusoryArea1-1' WHERE id=8411;
UPDATE cq_map SET `name`='IllusoryArea2-1' WHERE id=8412;
UPDATE cq_map SET `name`='IllusoryArea2-2' WHERE id=8413;
UPDATE cq_map SET `name`='IllusoryArea2-3' WHERE id=8414;
UPDATE cq_map SET `name`='IllusoryArea2-4' WHERE id=8415;
UPDATE cq_map SET `name`='IllusoryArea2-5' WHERE id=8416;
UPDATE cq_map SET `name`='IllusoryArea2-6' WHERE id=8417;
UPDATE cq_map SET `name`='IllusoryArea2-7' WHERE id=8418;
UPDATE cq_map SET `name`='IllusoryArea2-8' WHERE id=8419;
UPDATE cq_map SET `name`='IllusoryArea2-9' WHERE id=8420;
UPDATE cq_map SET `name`='IllusoryArea2-1' WHERE id=8421;
UPDATE cq_map SET `name`='IllusoryArea2-1' WHERE id=8422;
UPDATE cq_map SET `name`='IllusoryArea3-1' WHERE id=8423;
UPDATE cq_map SET `name`='IllusoryArea3-2' WHERE id=8424;
UPDATE cq_map SET `name`='IllusoryArea3-3' WHERE id=8425;
UPDATE cq_map SET `name`='IllusoryArea3-4' WHERE id=8426;
UPDATE cq_map SET `name`='IllusoryArea3-5' WHERE id=8427;
UPDATE cq_map SET `name`='IllusoryArea3-6' WHERE id=8428;
UPDATE cq_map SET `name`='IllusoryArea3-7' WHERE id=8429;
UPDATE cq_map SET `name`='IllusoryArea3-8' WHERE id=8430;
UPDATE cq_map SET `name`='IllusoryArea3-9' WHERE id=8431;
UPDATE cq_map SET `name`='IllusoryArea3-1' WHERE id=8432;
UPDATE cq_map SET `name`='IllusoryArea3-1' WHERE id=8433;
UPDATE cq_map SET `name`='IllusoryArea4-1' WHERE id=8434;
UPDATE cq_map SET `name`='IllusoryArea4-2' WHERE id=8435;
UPDATE cq_map SET `name`='IllusoryArea4-3' WHERE id=8436;
UPDATE cq_map SET `name`='IllusoryArea4-4' WHERE id=8437;
UPDATE cq_map SET `name`='IllusoryArea4-5' WHERE id=8438;
UPDATE cq_map SET `name`='IllusoryArea4-6' WHERE id=8439;
UPDATE cq_map SET `name`='IllusoryArea4-7' WHERE id=8440;
UPDATE cq_map SET `name`='IllusoryArea4-8' WHERE id=8441;
UPDATE cq_map SET `name`='IllusoryArea4-9' WHERE id=8442;
UPDATE cq_map SET `name`='IllusoryArea4-1' WHERE id=8443;
UPDATE cq_map SET `name`='IllusoryArea4-1' WHERE id=8444;
UPDATE cq_map SET `name`='IllusoryArea5-1' WHERE id=8445;
UPDATE cq_map SET `name`='IllusoryArea5-2' WHERE id=8446;
UPDATE cq_map SET `name`='IllusoryArea5-3' WHERE id=8447;
UPDATE cq_map SET `name`='IllusoryArea5-4' WHERE id=8448;
UPDATE cq_map SET `name`='IllusoryArea5-5' WHERE id=8449;
UPDATE cq_map SET `name`='IllusoryArea5-6' WHERE id=8450;
UPDATE cq_map SET `name`='IllusoryArea5-7' WHERE id=8451;
UPDATE cq_map SET `name`='IllusoryArea5-8' WHERE id=8452;
UPDATE cq_map SET `name`='IllusoryArea5-9' WHERE id=8453;
UPDATE cq_map SET `name`='IllusoryArea5-1' WHERE id=8454;
UPDATE cq_map SET `name`='IllusoryArea5-1' WHERE id=8455;
UPDATE cq_map SET `name`='IllusoryArea6-1' WHERE id=8456;
UPDATE cq_map SET `name`='IllusoryArea6-2' WHERE id=8457;
UPDATE cq_map SET `name`='IllusoryArea6-3' WHERE id=8458;
UPDATE cq_map SET `name`='IllusoryArea6-4' WHERE id=8459;
UPDATE cq_map SET `name`='IllusoryArea6-5' WHERE id=8460;
UPDATE cq_map SET `name`='IllusoryArea6-6' WHERE id=8461;
UPDATE cq_map SET `name`='IllusoryArea6-7' WHERE id=8462;
UPDATE cq_map SET `name`='IllusoryArea6-8' WHERE id=8463;
UPDATE cq_map SET `name`='IllusoryArea6-9' WHERE id=8464;
UPDATE cq_map SET `name`='IllusoryArea6-1' WHERE id=8465;
UPDATE cq_map SET `name`='IllusoryArea6-1' WHERE id=8466;
UPDATE cq_map SET `name`='IllusoryArea7-1' WHERE id=8467;
UPDATE cq_map SET `name`='IllusoryArea7-2' WHERE id=8468;
UPDATE cq_map SET `name`='IllusoryArea7-3' WHERE id=8469;
UPDATE cq_map SET `name`='IllusoryArea7-4' WHERE id=8470;
UPDATE cq_map SET `name`='IllusoryArea7-5' WHERE id=8471;
UPDATE cq_map SET `name`='IllusoryArea7-6' WHERE id=8472;
UPDATE cq_map SET `name`='IllusoryArea7-7' WHERE id=8473;
UPDATE cq_map SET `name`='IllusoryArea7-8' WHERE id=8474;
UPDATE cq_map SET `name`='IllusoryArea7-9' WHERE id=8475;
UPDATE cq_map SET `name`='IllusoryArea7-1' WHERE id=8476;
UPDATE cq_map SET `name`='IllusoryArea7-1' WHERE id=8477;
UPDATE cq_map SET `name`='IllusoryArea8-1' WHERE id=8478;
UPDATE cq_map SET `name`='IllusoryArea8-2' WHERE id=8479;
UPDATE cq_map SET `name`='IllusoryArea8-3' WHERE id=8480;
UPDATE cq_map SET `name`='IllusoryArea8-4' WHERE id=8481;
UPDATE cq_map SET `name`='IllusoryArea8-5' WHERE id=8482;
UPDATE cq_map SET `name`='IllusoryArea8-6' WHERE id=8483;
UPDATE cq_map SET `name`='IllusoryArea8-7' WHERE id=8484;
UPDATE cq_map SET `name`='IllusoryArea8-8' WHERE id=8485;
UPDATE cq_map SET `name`='IllusoryArea8-9' WHERE id=8486;
UPDATE cq_map SET `name`='IllusoryArea8-1' WHERE id=8487;
UPDATE cq_map SET `name`='IllusoryArea8-1' WHERE id=8488;
UPDATE cq_map SET `name`='SaintTemple' WHERE id=8700;
UPDATE cq_map SET `name`='Arena' WHERE id=8701;
UPDATE cq_map SET `name`='TombF1' WHERE id=8703;
UPDATE cq_map SET `name`='TombF2' WHERE id=8704;
UPDATE cq_map SET `name`='Sax\'sCave' WHERE id=8705;
UPDATE cq_map SET `name`='BotJail' WHERE id=8710;
UPDATE cq_map SET `name`='PKPlain' WHERE id=8761;
UPDATE cq_map SET `name`='PKPlain' WHERE id=8762;
UPDATE cq_map SET `name`='PKPlain' WHERE id=8763;
UPDATE cq_map SET `name`='PKPlain' WHERE id=8764;
UPDATE cq_map SET `name`='LargePKField' WHERE id=8765;
UPDATE cq_map SET `name`='LargePKField' WHERE id=8766;
UPDATE cq_map SET `name`='LargePKField' WHERE id=8767;
UPDATE cq_map SET `name`='LargePKField' WHERE id=8768;
UPDATE cq_map SET `name`='LargePKField' WHERE id=8769;
UPDATE cq_map SET `name`='LargePKField' WHERE id=8770;
UPDATE cq_map SET `name`='LargePKField' WHERE id=8771;
UPDATE cq_map SET `name`='LargePKField' WHERE id=8772;
UPDATE cq_map SET `name`='MiniPKField' WHERE id=8773;
UPDATE cq_map SET `name`='MiniPKField' WHERE id=8774;
UPDATE cq_map SET `name`='MiniPKField' WHERE id=8775;
UPDATE cq_map SET `name`='MiniPKField' WHERE id=8776;
UPDATE cq_map SET `name`='FinalPKField' WHERE id=8777;
UPDATE cq_map SET `name`='FinalPKField' WHERE id=8778;
UPDATE cq_map SET `name`='FinalPKField' WHERE id=8779;
UPDATE cq_map SET `name`='FinalPKField' WHERE id=8780;
UPDATE cq_map SET `name`='PKDesert' WHERE id=8781;
UPDATE cq_map SET `name`='PKDesert' WHERE id=8782;
UPDATE cq_map SET `name`='PKDesert' WHERE id=8783;
UPDATE cq_map SET `name`='PKDesert' WHERE id=8784;
UPDATE cq_map SET `name`='Church' WHERE id=8850;
UPDATE cq_map SET `name`='KingLand' WHERE id=8900;
UPDATE cq_map SET `name`='RoseHall' WHERE id=8901;
UPDATE cq_map SET `name`='FlorrieLake' WHERE id=8902;
UPDATE cq_map SET `name`='LoveLake' WHERE id=8903;
UPDATE cq_map SET `name`='VisionMaze' WHERE id=8905;
UPDATE cq_map SET `name`='HalloweanMaze' WHERE id=8906;
UPDATE cq_map SET `name`='HolyCronus' WHERE id=8907;
UPDATE cq_map SET `name`='EvilCronus' WHERE id=8908;
UPDATE cq_map SET `name`='HolyDesert' WHERE id=8909;
UPDATE cq_map SET `name`='EvilDesert' WHERE id=8910;
UPDATE cq_map SET `name`='WindDesert' WHERE id=8911;
UPDATE cq_map SET `name`='WaterDesert' WHERE id=8912;
UPDATE cq_map SET `name`='FireDesert' WHERE id=8913;
UPDATE cq_map SET `name`='EarthDesert' WHERE id=8914;
UPDATE cq_map SET `name`='EarthMarsh' WHERE id=8915;
UPDATE cq_map SET `name`='WindMarsh' WHERE id=8916;
UPDATE cq_map SET `name`='FireMarsh' WHERE id=8917;
UPDATE cq_map SET `name`='WaterMarsh' WHERE id=8918;
UPDATE cq_map SET `name`='ThunderMarsh' WHERE id=8919;
UPDATE cq_map SET `name`='HolyIcyland' WHERE id=8920;
UPDATE cq_map SET `name`='EvilIcyland' WHERE id=8921;
UPDATE cq_map SET `name`='NeutralIcyland' WHERE id=8922;
UPDATE cq_map SET `name`='HolyIsland' WHERE id=8923;
UPDATE cq_map SET `name`='EvilIsland' WHERE id=8924;
UPDATE cq_map SET `name`='HolyPlain' WHERE id=8925;
UPDATE cq_map SET `name`='EvilMaze' WHERE id=8926;
UPDATE cq_map SET `name`='Prison' WHERE id=60000;
|