![[Another Little Release] + Little SQL Guide and Techinques](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/another-little-release-little-sql-guide-techinques_ltr.gif){kind=small}
Allot of people wait this SQL Guide and Techinques why ?
because allot of SQL Beginner dont know so i will share
im sure some SQL PRO Know but i see not alll and so this share will be loved by PRO too not only beginners
!! all these sql query maybe not by me just edited and completed or some ones by me 100% but forget so remove all credits this is only for help beginners
!!! im not SQL PRO im just nothing i learned sql in my free time for silkroad
so if querys can be ameliorated go and share with me and all
Realy sry for my bad english i will try to learn english better too
Fast and PRO Edit Techinque
This is Part 1 part 2 will come latter when have time
-press First Edit All Rows
-press left click some where on the table
-select Pane
-select sql
Gude Pic
U will get like this
write to search u can do what 'where' u want select what u want more simple and this can be edited
[CODEWHERE (dwNestID = 49824)][/CODE]
u will get something like that
!! here is just little utilisation u can find allot usefull if start to use it
here is more usefull
--only one npc or mob by code name
--allot of npc and mobs by code name
here is some 'where' for use with pane sql
some little query that i use i extracted from smc credits goes to joymax with sql profiller very usefull
most simple backup query very usefull
( have c# sofrware with schedule using this sql but dont fild )
sory for this baddd thread its my second post on this forum 
i will edit and correct all little by litttle now i blked alll fast
but latter will be cool
the sql guide not complete no have time no macke part2
-press left click some where on the table
-select Pane
-select sql
Gude Pic
U will get like this
write to search u can do what 'where' u want select what u want more simple and this can be edited
[CODEWHERE (dwNestID = 49824)][/CODE]
u will get something like that
!! here is just little utilisation u can find allot usefull if start to use it
here is more usefull
--only one npc or mob by code name
Code:
WHERE (dwNestID =
(SELECT Nest.dwNestID
FROM Tab_RefNest AS Nest INNER JOIN
Tab_RefTactics AS Tact ON Nest.dwTacticsID = Tact.dwTacticsID INNER JOIN
_RefObjCommon AS Com ON Tact.dwObjID = Com.ID
WHERE (Com.CodeName128 LIKE '%NPC_AR_DAYMISSION%')))
Code:
WHERE (dwNestID IN
(SELECT Nest.dwNestID
FROM Tab_RefNest AS Nest INNER JOIN
Tab_RefTactics AS Tact ON Nest.dwTacticsID = Tact.dwTacticsID INNER JOIN
_RefObjCommon AS Com ON Tact.dwObjID = Com.ID
WHERE (Com.CodeName128 LIKE '%NPC_%_DAYMISSION%')))
Code:
WHERE (ContinentName LIKE 'OTHER_SKYTEMPLE_%') WHERE (wRegionID = '23273') WHERE (GroupCodeName128 LIKE 'GROUP_INS_OTHER_SKYTEMPLE_%') WHERE (CodeName128 LIKE 'STORE%') WHERE (ContinentName LIKE 'OTHER_SKYTEMPLE_A') WHERE (wRegionID = '24027') WHERE (RegionID BETWEEN '24026' AND '24032')
some little query that i use i extracted from smc credits goes to joymax with sql profiller very usefull
Code:
--------Char Trijob Edit or Add by Char Name
exec _SMC_EDIT_TRIJOB 'Char Name', 1, 0, 99, 99, 99
exec _SMC_EDIT_TRIJOB 'Char Name', 1, 0, 99, 99, 99
--------Char TriJob Query (job info)
select JobType, [Level], Exp, Contribution, Reward
from _CharTrijob with (nolock) where CharId = (select CharID from _Char with (nolock) where CharName16 = 'Char Name')
--------Char TimeJob Query
select ID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8
from _timedjob where CharId = (select CharID from _Char with (nolock) where CharName16 = 'Char Name')
--------Get Avatar Inventory Item by Serial
exec _GetAvatarInventoryItemBySerial Serial
exec _GetAvatarInventoryItemBySerial 2120
--------Get Char Avatar Inventory by Char Name
exec _GetAvatarInventoryItem 'Char Name'
--------Get Inventory Item by Serial
exec _GetInventoryItemBySerial Serial
exec _GetInventoryItemBySerial 2120
--------Get Char Inventory by Char Name
exec _GetInventoryItem 'Char Name'
--------Get UserID by Username
use VSRO_ACCOUNT
select JID from TB_User with (nolock) where strUserID = '0'
--------Get all chars by UserID
use VSRO_SHARD
exec _QueryCharName 1
--------Get Char Last Position
select LatestRegion, PosX, PosY, PosZ from _Char with(NOLOCK) where CharName16 = 'Drak'
--------Chenge Char Position by CharName Region X Y Z worldID
exec _ModifyCharPos 'Char Name', Region, X, Y, Z, worldID
exec _ModifyCharPos 'Char Name', 15686, 1115.699951, 118.219307, 80.099976, 4
--------Chenge Cos Pet Lv and Exp By Pet ID
UPDATE _CHARCOS SET Lvl=10,ExpOffset=7302 WHERE ID=(select ID from _CharCOS with (nolock) where CharName = 'Char Name' )
-------Search Guild by CharName
select [Name], lvl, gatheredsp from _guild with (nolock) where _guild.id =(select guildid from _char with (nolock) where charname16 = 'Char Name' )
-------Search Guild By GuildName
select [Name], Lvl, GatheredSP, LastCrestRev, CurCrestRev from _Guild with (nolock) where [Name] = 'Guild Name'
-------Get User By IP
select * from TB_User where reg_ip='192.168.0.15'
----/////////
---------------SMC CHENGE CHAR POSITION
exec _ModifyCharPos 'Drak', 15686, 1115.699951, 118.219307, 80.099976, 4
exec _ADDLOGCHAR 0,199,0,0,'MCP','[Drak], 15686, 1115.699951, 118.219307, 80.099976, 4'
insert _SMCLog values ('1', 22, 'Modifying Char[Drak] Position To [15686, 1115.699951, 118.219307, 80.099976, 4]', default)
--SMC Login
exec _CertifyUser '1','c4ca4238a0b923820dcc509a6f75849b','d41d8cd98f00b204e9800998ecf8427e'
--SMC Logout
insert _SMCLog values ('1', 9, 'Logout : 1', default)
( have c# sofrware with schedule using this sql but dont fild )
Code:
DECLARE @ACCOUNT nvarchar(max) ='C:\Database\BackUp\VSRO_ACCOUNT ' +replace(rtrim(convert(char,getdate())), ':',',')+'.bak'; DECLARE @LOG nvarchar(max) ='C:\Database\BackUp\VSRO_LOG ' +replace(rtrim(convert(char,getdate())), ':',',')+'.bak'; DECLARE @SHARD nvarchar(max) ='C:\Database\BackUp\VSRO_SHARD ' +replace(rtrim(convert(char,getdate())), ':',',')+'.bak'; BACKUP DATABASE VSRO_SHARD TO DISK = @SHARD BACKUP DATABASE VSRO_LOG TO DISK = @LOG BACKUP DATABASE VSRO_ACCOUNT TO DISK = @ACCOUNT Print'Backup Complete'
i will edit and correct all little by litttle now i blked alll fast
but latter will be cool
the sql guide not complete no have time no macke part2
Finaly the part 2 is here
_CharTrijob in this balet u will find all about char job
Here is code for more simpel edit or see by char name (can simple edit if u want by job char name (just ramplace CharName16 by NickName16 ))
Code:
WHERE (CharID =
(SELECT CharID
FROM _Char WITH (nolock)
WHERE (CharName16 = 'Char Name')))
if u want only see u can this query !! not for edit
already post it in part 1
Code:
--------Char TriJob Query (job info) select JobType, [Level], Exp, Contribution, Reward from _CharTrijob with (nolock) where CharId = (select CharID from _Char with (nolock) where CharName16 = 'Char Name')
_Char in this balet u will find all about char...
Search in
Code:
--by char name WHERE (CharName16 = '[GM]Drak') --by job nick WHERE (NickName16 = 'Dark') --by level WHERE (CurLevel = 1) --... and can do like this all :)
Check Map Tablets query's
Lets search sky temple in db
(!! i taked this new map by exemple and for help beginner who want add it these querys can be used for allllllllll maps )
for this no need query (? xD
_RefRegionBindAssocServer
_RefGame_World
result :
_RefGame_World_Config
result :
_RefRegion
result :
now the most hart one
_RefInstance_World_Region
result :
(!! i taked this new map by exemple and for help beginner who want add it these querys can be used for allllllllll maps )
for this no need query (? xD
_RefRegionBindAssocServer
Code:
OTHER_SKYTEMPLE_A 1 OTHER_SKYTEMPLE_B 1 OTHER_SKYTEMPLE_C 1 OTHER_SKYTEMPLE_D 1
_RefGame_World
Code:
WHERE (WorldCodeName128 LIKE '%OTHER_SKYTEMPLE_%')
Code:
103 INS_OTHER_SKYTEMPLE_A 0 1 0 0 0 0 0 0 GROUP_INS_OTHER_SKYTEMPLE_A 104 INS_OTHER_SKYTEMPLE_B 0 1 0 0 0 0 0 0 GROUP_INS_OTHER_SKYTEMPLE_B 105 INS_OTHER_SKYTEMPLE_C 0 1 0 0 0 0 0 0 GROUP_INS_OTHER_SKYTEMPLE_C 106 INS_OTHER_SKYTEMPLE_D 0 1 0 0 0 0 0 0 GROUP_INS_OTHER_SKYTEMPLE_D
_RefGame_World_Config
Code:
WHERE (GroupCodeName128 LIKE '%OTHER_SKYTEMPLE_%')
Code:
1 1023 GROUP_INS_OTHER_SKYTEMPLE_A GAME_WORLD_NORMALIZE_TYPE GAME_WORLD_NORMALIZE_TYPE_A STRING 1 1024 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED ON STRING 0 1025 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_ENTRY NUM_LIMIT STRING 0 1026 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_ENTRY_MAXIMUM_NUM 5 INT32 1 1027 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_PARTY OFF STRING 1 1028 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_LEVEL_MINIMUM_NUM 1 INT32 1 1029 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_LEVEL_MAXIMUM_NUM 120 INT32 1 1030 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_JOB_CLOTHES_PUT_ON OFF STRING 1 1031 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_JOB_CLOTHES_PUT_OFF ON STRING 1 1032 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_RIDE_COS_NOT_RIDING ON STRING 1 1033 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_RIDE_COS_RIDING OFF STRING 1 1034 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_TRADE_COS_NOT_RIDING ON STRING 1 1035 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_TRADE_COS_RIDING OFF STRING 1 1036 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_OFF ON STRING 1 1037 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_ON OFF STRING 1 1038 GROUP_INS_OTHER_SKYTEMPLE_A PARTYMONSTER_SPAWN ON STRING 1 1039 GROUP_INS_OTHER_SKYTEMPLE_A DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL ON STRING 0 1040 GROUP_INS_OTHER_SKYTEMPLE_A GAMEWORLD_ENTRY_UNTOUCHABLE_TIME 5 FLOAT32 0 1041 GROUP_INS_OTHER_SKYTEMPLE_A MAX_SQUAD_MEMBER_COUNT 30 INT32 0 1042 GROUP_INS_OTHER_SKYTEMPLE_A CONTROL_NOTIFY_SPAWN_UNIQUE_MONSTER_MSG ON STRING 0 1043 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_GATE_REGION 55555 INT32 0 1044 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_GATE_X 555 FLOAT32 0 1045 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_GATE_Y 555 FLOAT32 0 1048 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_GATE_TARGAET_X 555 FLOAT32 0 1049 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_GATE_TARGAET_Y 555 FLOAT32 0 1046 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_GATE_Z 555 FLOAT32 0 1047 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_GATE_TARGAET_REGION 55555 INT32 0 1050 GROUP_INS_OTHER_SKYTEMPLE_A ENTER_GATE_TARGAET_Z 55 FLOAT32 0 1051 GROUP_INS_OTHER_SKYTEMPLE_A LEAVE_GATE_REGION 55555 INT32 0 1052 GROUP_INS_OTHER_SKYTEMPLE_A LEAVE_GATE_X 555 FLOAT32 0 1053 GROUP_INS_OTHER_SKYTEMPLE_A LEAVE_GATE_Y 555 FLOAT32 0 1054 GROUP_INS_OTHER_SKYTEMPLE_A LEAVE_GATE_Z 555 FLOAT32 0 1055 GROUP_INS_OTHER_SKYTEMPLE_A LEAVE_GATE_TARGAET_REGION 55555 INT32 0 1056 GROUP_INS_OTHER_SKYTEMPLE_A LEAVE_GATE_TARGAET_X 555 FLOAT32 0 1057 GROUP_INS_OTHER_SKYTEMPLE_A LEAVE_GATE_TARGAET_Y 555 FLOAT32 0 1058 GROUP_INS_OTHER_SKYTEMPLE_A LEAVE_GATE_TARGAET_Z 555 FLOAT32 0 1059 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_SWITCH ON STRING 0 1060 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_GAMEWORLD_THIEF INS_DEFAULT STRING 0 1061 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_REGION_THIEF 55555 INT32 0 1062 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSX_THIEF 555 FLOAT32 0 1063 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSY_THIEF 555 FLOAT32 0 1064 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSZ_THIEF 555 FLOAT32 0 1065 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_GAMEWORLD_MERCHANT_HUNTER INS_DEFAULT STRING 0 1066 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_REGION_MERCHANT_HUNTER 55555 INT32 0 1067 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSX_MERCHANT_HUNTER 555 FLOAT32 0 1068 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSY_MERCHANT_HUNTER 555 FLOAT32 0 1069 GROUP_INS_OTHER_SKYTEMPLE_A FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSZ_MERCHANT_HUNTER 555 FLOAT32 0 1070 GROUP_INS_OTHER_SKYTEMPLE_A REF_REGION_BIND_ASSOC_SERVER FORT_CT_AREA STRING 1 1071 GROUP_INS_OTHER_SKYTEMPLE_B GAME_WORLD_NORMALIZE_TYPE GAME_WORLD_NORMALIZE_TYPE_A STRING 1 1072 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED ON STRING 0 1073 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_ENTRY NUM_LIMIT STRING 0 1074 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_ENTRY_MAXIMUM_NUM 5 INT32 1 1075 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_PARTY OFF STRING 1 1076 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_LEVEL_MINIMUM_NUM 1 INT32 1 1077 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_LEVEL_MAXIMUM_NUM 120 INT32 1 1078 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_JOB_CLOTHES_PUT_ON OFF STRING 1 1079 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_JOB_CLOTHES_PUT_OFF ON STRING 1 1080 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_RIDE_COS_NOT_RIDING ON STRING 1 1081 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_RIDE_COS_RIDING OFF STRING 1 1082 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_TRADE_COS_NOT_RIDING ON STRING 1 1083 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_TRADE_COS_RIDING OFF STRING 1 1084 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_OFF ON STRING 1 1085 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_ON OFF STRING 1 1086 GROUP_INS_OTHER_SKYTEMPLE_B PARTYMONSTER_SPAWN ON STRING 1 1087 GROUP_INS_OTHER_SKYTEMPLE_B DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL ON STRING 0 1088 GROUP_INS_OTHER_SKYTEMPLE_B GAMEWORLD_ENTRY_UNTOUCHABLE_TIME 5 FLOAT32 0 1089 GROUP_INS_OTHER_SKYTEMPLE_B MAX_SQUAD_MEMBER_COUNT 30 INT32 0 1090 GROUP_INS_OTHER_SKYTEMPLE_B CONTROL_NOTIFY_SPAWN_UNIQUE_MONSTER_MSG ON STRING 0 1091 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_GATE_REGION 55555 INT32 0 1092 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_GATE_X 555 FLOAT32 0 1093 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_GATE_Y 555 FLOAT32 0 1094 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_GATE_Z 555 FLOAT32 0 1095 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_GATE_TARGAET_REGION 55555 INT32 0 1096 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_GATE_TARGAET_X 555 FLOAT32 0 1097 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_GATE_TARGAET_Y 555 FLOAT32 0 1098 GROUP_INS_OTHER_SKYTEMPLE_B ENTER_GATE_TARGAET_Z 55 FLOAT32 0 1099 GROUP_INS_OTHER_SKYTEMPLE_B LEAVE_GATE_REGION 55555 INT32 0 1100 GROUP_INS_OTHER_SKYTEMPLE_B LEAVE_GATE_X 555 FLOAT32 0 1101 GROUP_INS_OTHER_SKYTEMPLE_B LEAVE_GATE_Y 555 FLOAT32 0 1102 GROUP_INS_OTHER_SKYTEMPLE_B LEAVE_GATE_Z 555 FLOAT32 0 1103 GROUP_INS_OTHER_SKYTEMPLE_B LEAVE_GATE_TARGAET_REGION 55555 INT32 0 1104 GROUP_INS_OTHER_SKYTEMPLE_B LEAVE_GATE_TARGAET_X 555 FLOAT32 0 1105 GROUP_INS_OTHER_SKYTEMPLE_B LEAVE_GATE_TARGAET_Y 555 FLOAT32 0 1106 GROUP_INS_OTHER_SKYTEMPLE_B LEAVE_GATE_TARGAET_Z 555 FLOAT32 0 1107 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_SWITCH ON STRING 0 1108 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_GAMEWORLD_THIEF INS_DEFAULT STRING 0 1109 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_REGION_THIEF 55555 INT32 0 1110 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSX_THIEF 555 FLOAT32 0 1111 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSY_THIEF 555 FLOAT32 0 1112 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSZ_THIEF 555 FLOAT32 0 1113 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_GAMEWORLD_MERCHANT_HUNTER INS_DEFAULT STRING 0 1114 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_REGION_MERCHANT_HUNTER 55555 INT32 0 1115 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSX_MERCHANT_HUNTER 555 FLOAT32 0 1116 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSY_MERCHANT_HUNTER 555 FLOAT32 0 1117 GROUP_INS_OTHER_SKYTEMPLE_B FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSZ_MERCHANT_HUNTER 555 FLOAT32 0 1118 GROUP_INS_OTHER_SKYTEMPLE_B REF_REGION_BIND_ASSOC_SERVER FORT_CT_AREA STRING 1 1119 GROUP_INS_OTHER_SKYTEMPLE_C GAME_WORLD_NORMALIZE_TYPE GAME_WORLD_NORMALIZE_TYPE_A STRING 1 1120 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED ON STRING 0 1121 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_ENTRY NUM_LIMIT STRING 0 1122 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_ENTRY_MAXIMUM_NUM 5 INT32 1 1123 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_PARTY OFF STRING 1 1124 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_LEVEL_MINIMUM_NUM 1 INT32 1 1125 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_LEVEL_MAXIMUM_NUM 120 INT32 1 1126 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_JOB_CLOTHES_PUT_ON OFF STRING 1 1127 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_JOB_CLOTHES_PUT_OFF ON STRING 1 1128 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_RIDE_COS_NOT_RIDING ON STRING 1 1129 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_RIDE_COS_RIDING OFF STRING 1 1130 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_TRADE_COS_NOT_RIDING ON STRING 1 1131 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_TRADE_COS_RIDING OFF STRING 1 1132 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_OFF ON STRING 1 1133 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_ON OFF STRING 1 1134 GROUP_INS_OTHER_SKYTEMPLE_C PARTYMONSTER_SPAWN ON STRING 1 1135 GROUP_INS_OTHER_SKYTEMPLE_C DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL ON STRING 0 1136 GROUP_INS_OTHER_SKYTEMPLE_C GAMEWORLD_ENTRY_UNTOUCHABLE_TIME 5 FLOAT32 0 1137 GROUP_INS_OTHER_SKYTEMPLE_C MAX_SQUAD_MEMBER_COUNT 30 INT32 0 1138 GROUP_INS_OTHER_SKYTEMPLE_C CONTROL_NOTIFY_SPAWN_UNIQUE_MONSTER_MSG ON STRING 0 1139 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_GATE_REGION 55555 INT32 0 1140 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_GATE_X 555 FLOAT32 0 1141 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_GATE_Y 555 FLOAT32 0 1142 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_GATE_Z 555 FLOAT32 0 1143 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_GATE_TARGAET_REGION 55555 INT32 0 1144 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_GATE_TARGAET_X 555 FLOAT32 0 1145 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_GATE_TARGAET_Y 555 FLOAT32 0 1146 GROUP_INS_OTHER_SKYTEMPLE_C ENTER_GATE_TARGAET_Z 55 FLOAT32 0 1147 GROUP_INS_OTHER_SKYTEMPLE_C LEAVE_GATE_REGION 55555 INT32 0 1148 GROUP_INS_OTHER_SKYTEMPLE_C LEAVE_GATE_X 555 FLOAT32 0 1149 GROUP_INS_OTHER_SKYTEMPLE_C LEAVE_GATE_Y 555 FLOAT32 0 1150 GROUP_INS_OTHER_SKYTEMPLE_C LEAVE_GATE_Z 555 FLOAT32 0 1151 GROUP_INS_OTHER_SKYTEMPLE_C LEAVE_GATE_TARGAET_REGION 55555 INT32 0 1152 GROUP_INS_OTHER_SKYTEMPLE_C LEAVE_GATE_TARGAET_X 555 FLOAT32 0 1153 GROUP_INS_OTHER_SKYTEMPLE_C LEAVE_GATE_TARGAET_Y 555 FLOAT32 0 1154 GROUP_INS_OTHER_SKYTEMPLE_C LEAVE_GATE_TARGAET_Z 555 FLOAT32 0 1155 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_SWITCH ON STRING 0 1156 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_GAMEWORLD_THIEF INS_DEFAULT STRING 0 1157 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_REGION_THIEF 55555 INT32 0 1158 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSX_THIEF 555 FLOAT32 0 1159 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSY_THIEF 555 FLOAT32 0 1160 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSZ_THIEF 555 FLOAT32 0 1161 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_GAMEWORLD_MERCHANT_HUNTER INS_DEFAULT STRING 0 1162 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_REGION_MERCHANT_HUNTER 55555 INT32 0 1163 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSX_MERCHANT_HUNTER 555 FLOAT32 0 1164 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSY_MERCHANT_HUNTER 555 FLOAT32 0 1165 GROUP_INS_OTHER_SKYTEMPLE_C FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSZ_MERCHANT_HUNTER 555 FLOAT32 0 1166 GROUP_INS_OTHER_SKYTEMPLE_C REF_REGION_BIND_ASSOC_SERVER FORT_CT_AREA STRING 1 1167 GROUP_INS_OTHER_SKYTEMPLE_D GAME_WORLD_NORMALIZE_TYPE GAME_WORLD_NORMALIZE_TYPE_A STRING 1 1168 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED ON STRING 0 1169 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_ENTRY NUM_LIMIT STRING 0 1170 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_ENTRY_MAXIMUM_NUM 5 INT32 1 1171 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_PARTY OFF STRING 1 1172 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_LEVEL_MINIMUM_NUM 1 INT32 1 1173 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_LEVEL_MAXIMUM_NUM 120 INT32 1 1174 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_JOB_CLOTHES_PUT_ON OFF STRING 1 1175 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_JOB_CLOTHES_PUT_OFF ON STRING 1 1176 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_RIDE_COS_NOT_RIDING ON STRING 1 1177 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_RIDE_COS_RIDING OFF STRING 1 1178 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_TRADE_COS_NOT_RIDING ON STRING 1 1179 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_TRADE_COS_RIDING OFF STRING 1 1180 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_OFF ON STRING 1 1181 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_ON OFF STRING 1 1182 GROUP_INS_OTHER_SKYTEMPLE_D PARTYMONSTER_SPAWN ON STRING 1 1183 GROUP_INS_OTHER_SKYTEMPLE_D DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL ON STRING 0 1184 GROUP_INS_OTHER_SKYTEMPLE_D GAMEWORLD_ENTRY_UNTOUCHABLE_TIME 5 FLOAT32 0 1185 GROUP_INS_OTHER_SKYTEMPLE_D MAX_SQUAD_MEMBER_COUNT 30 INT32 0 1186 GROUP_INS_OTHER_SKYTEMPLE_D CONTROL_NOTIFY_SPAWN_UNIQUE_MONSTER_MSG ON STRING 0 1187 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_GATE_REGION 55555 INT32 0 1188 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_GATE_X 555 FLOAT32 0 1189 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_GATE_Y 555 FLOAT32 0 1190 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_GATE_Z 555 FLOAT32 0 1191 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_GATE_TARGAET_REGION 55555 INT32 0 1192 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_GATE_TARGAET_X 555 FLOAT32 0 1193 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_GATE_TARGAET_Y 555 FLOAT32 0 1194 GROUP_INS_OTHER_SKYTEMPLE_D ENTER_GATE_TARGAET_Z 55 FLOAT32 0 1195 GROUP_INS_OTHER_SKYTEMPLE_D LEAVE_GATE_REGION 55555 INT32 0 1196 GROUP_INS_OTHER_SKYTEMPLE_D LEAVE_GATE_X 555 FLOAT32 0 1197 GROUP_INS_OTHER_SKYTEMPLE_D LEAVE_GATE_Y 555 FLOAT32 0 1198 GROUP_INS_OTHER_SKYTEMPLE_D LEAVE_GATE_Z 555 FLOAT32 0 1199 GROUP_INS_OTHER_SKYTEMPLE_D LEAVE_GATE_TARGAET_REGION 55555 INT32 0 1200 GROUP_INS_OTHER_SKYTEMPLE_D LEAVE_GATE_TARGAET_X 555 FLOAT32 0 1201 GROUP_INS_OTHER_SKYTEMPLE_D LEAVE_GATE_TARGAET_Y 555 FLOAT32 0 1202 GROUP_INS_OTHER_SKYTEMPLE_D LEAVE_GATE_TARGAET_Z 555 FLOAT32 0 1203 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_SWITCH ON STRING 0 1204 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_GAMEWORLD_THIEF INS_DEFAULT STRING 0 1205 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_REGION_THIEF 55555 INT32 0 1206 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSX_THIEF 555 FLOAT32 0 1207 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSY_THIEF 555 FLOAT32 0 1208 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSZ_THIEF 555 FLOAT32 0 1209 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_GAMEWORLD_MERCHANT_HUNTER INS_DEFAULT STRING 0 1210 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_REGION_MERCHANT_HUNTER 55555 INT32 0 1211 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSX_MERCHANT_HUNTER 555 FLOAT32 0 1212 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSY_MERCHANT_HUNTER 555 FLOAT32 0 1213 GROUP_INS_OTHER_SKYTEMPLE_D FAILED_ENTER_WORLD_TO_SPECIAL_TARGET_POSZ_MERCHANT_HUNTER 555 FLOAT32 0 1214 GROUP_INS_OTHER_SKYTEMPLE_D REF_REGION_BIND_ASSOC_SERVER FORT_CT_AREA STRING
_RefRegion
Code:
WHERE (ContinentName LIKE '%OTHER_SKYTEMPLE_%')
Code:
23769 217 92 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23776 224 92 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24281 217 94 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24541 221 95 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24543 223 95 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24800 224 96 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25049 217 97 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25050 218 97 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25051 219 97 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25052 220 97 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25053 221 97 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25054 222 97 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25055 223 97 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25056 224 97 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25305 217 98 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24544 224 95 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24793 217 96 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24794 218 96 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24795 219 96 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24796 220 96 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24797 221 96 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24798 222 96 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24799 223 96 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25306 218 98 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25820 220 100 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25821 221 100 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25822 222 100 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25823 223 100 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25824 224 100 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23778 226 92 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23779 227 92 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23780 228 92 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23781 229 92 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23782 230 92 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23783 231 92 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23784 232 92 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23785 233 92 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24296 232 94 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24297 233 94 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24546 226 95 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24547 227 95 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24548 228 95 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24549 229 95 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24550 230 95 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24551 231 95 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24552 232 95 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24553 233 95 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24802 226 96 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24803 227 96 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24804 228 96 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24805 229 96 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24806 230 96 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24807 231 96 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24808 232 96 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25059 227 97 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25060 228 97 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25061 229 97 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25062 230 97 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25063 231 97 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25064 232 97 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25065 233 97 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25314 226 98 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25315 227 98 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25316 228 98 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25317 229 98 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25318 230 98 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25319 231 98 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25320 232 98 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25321 233 98 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25570 226 99 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25571 227 99 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25572 228 99 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25573 229 99 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25574 230 99 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25575 231 99 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25576 232 99 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25577 233 99 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25826 226 100 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25827 227 100 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25828 228 100 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25829 229 100 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25564 220 99 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25565 221 99 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25566 222 99 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25567 223 99 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25568 224 99 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25817 217 100 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25818 218 100 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25819 219 100 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24809 233 96 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25058 226 97 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24025 217 93 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24026 218 93 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24027 219 93 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24028 220 93 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24029 221 93 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24030 222 93 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24031 223 93 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24032 224 93 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24282 218 94 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24283 219 94 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24284 220 94 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24285 221 94 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24286 222 94 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24287 223 94 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24288 224 94 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24537 217 95 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24538 218 95 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24539 219 95 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24540 220 95 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23770 218 92 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23771 219 92 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23772 220 92 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23773 221 92 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23774 222 92 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23775 223 92 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24542 222 95 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24034 226 93 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24035 227 93 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24036 228 93 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24037 229 93 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24038 230 93 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24039 231 93 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24040 232 93 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24041 233 93 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24290 226 94 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24291 227 94 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24292 228 94 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24293 229 94 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24294 230 94 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 24295 231 94 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25307 219 98 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25308 220 98 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25309 221 98 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25310 222 98 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25311 223 98 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25312 224 98 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25561 217 99 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25562 218 99 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25563 219 99 OTHER_SKYTEMPLE_A Other_SkyTemple_A 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25830 230 100 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25831 231 100 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25832 232 100 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 25833 233 100 OTHER_SKYTEMPLE_B Other_SkyTemple_B 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21209 217 82 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21210 218 82 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21211 219 82 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21212 220 82 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21213 221 82 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21214 222 82 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21215 223 82 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21216 224 82 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21465 217 83 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21466 218 83 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21467 219 83 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21468 220 83 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21469 221 83 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21470 222 83 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21471 223 83 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21472 224 83 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21721 217 84 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21722 218 84 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21723 219 84 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21724 220 84 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21725 221 84 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21726 222 84 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21727 223 84 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21728 224 84 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21977 217 85 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21978 218 85 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21979 219 85 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21980 220 85 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21981 221 85 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21982 222 85 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21983 223 85 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21984 224 85 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22233 217 86 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22234 218 86 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22235 219 86 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22236 220 86 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22237 221 86 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22238 222 86 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22239 223 86 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22240 224 86 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22489 217 87 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22490 218 87 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22491 219 87 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22492 220 87 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22493 221 87 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22494 222 87 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22495 223 87 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22496 224 87 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22745 217 88 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22746 218 88 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22747 219 88 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22748 220 88 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22749 221 88 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22750 222 88 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22751 223 88 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22752 224 88 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23001 217 89 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23002 218 89 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23003 219 89 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23004 220 89 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23005 221 89 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23006 222 89 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23007 223 89 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23008 224 89 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23257 217 90 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23258 218 90 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23259 219 90 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23260 220 90 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23261 221 90 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23262 222 90 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23263 223 90 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23264 224 90 OTHER_SKYTEMPLE_C Other_SkyTemple_C 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21218 226 82 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21219 227 82 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21220 228 82 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21221 229 82 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21222 230 82 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21223 231 82 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21224 232 82 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21225 233 82 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21474 226 83 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21475 227 83 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21476 228 83 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21477 229 83 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21478 230 83 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21479 231 83 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21480 232 83 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21481 233 83 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21730 226 84 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21731 227 84 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21732 228 84 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21733 229 84 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21734 230 84 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21735 231 84 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21736 232 84 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21737 233 84 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21986 226 85 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21987 227 85 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21988 228 85 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21989 229 85 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21990 230 85 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21991 231 85 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21992 232 85 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 21993 233 85 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22242 226 86 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22243 227 86 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22244 228 86 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22245 229 86 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22246 230 86 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22247 231 86 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22248 232 86 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22249 233 86 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22498 226 87 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22499 227 87 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22500 228 87 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22501 229 87 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22502 230 87 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22503 231 87 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22504 232 87 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22505 233 87 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22754 226 88 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22755 227 88 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22756 228 88 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22757 229 88 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22758 230 88 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22759 231 88 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22760 232 88 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 22761 233 88 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23010 226 89 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23011 227 89 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23012 228 89 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23013 229 89 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23014 230 89 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23015 231 89 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23016 232 89 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23017 233 89 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23266 226 90 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23267 227 90 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23268 228 90 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23269 229 90 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23270 230 90 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23271 231 90 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23272 232 90 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0 23273 233 90 OTHER_SKYTEMPLE_D Other_SkyTemple_D 1 2004 -1 0 0 xxx 0 0 0 0 0 0 0 0 0 0
now the most hart one
_RefInstance_World_Region
Code:
WHERE (RegionID IN
(SELECT wRegionID
FROM _RefRegion
WHERE (ContinentName LIKE '%OTHER_SKYTEMPLE_%')))
Code:
1 23769 1 23770 1 23771 1 23772 1 23773 1 23774 1 23775 1 23776 1 24025 1 24026 1 24027 1 24028 1 24029 1 24030 1 24031 1 24032 1 24281 1 24282 1 24283 1 24284 1 24285 1 24286 1 24287 1 24288 1 24537 1 24538 1 24539 1 24540 1 24541 1 24542 1 24543 1 24544 1 24793 1 24794 1 24795 1 24796 1 24797 1 24798 1 24799 1 24800 1 25049 1 25050 1 25051 1 25052 1 25053 1 25054 1 25055 1 25056 1 25305 1 25306 1 25307 1 25308 1 25309 1 25310 1 25311 1 25312 1 25561 1 25562 1 25563 1 25564 1 25565 1 25566 1 25567 1 25568 1 25817 1 25818 1 25819 1 25820 1 25821 1 25822 1 25823 1 25824 1 23778 1 23779 1 23780 1 23781 1 23782 1 23783 1 23784 1 23785 1 24034 1 24035 1 24036 1 24037 1 24038 1 24039 1 24040 1 24041 1 24290 1 24291 1 24292 1 24293 1 24294 1 24295 1 24296 1 24297 1 24546 1 24547 1 24548 1 24549 1 24550 1 24551 1 24552 1 24553 1 24802 1 24803 1 24804 1 24805 1 24806 1 24807 1 24808 1 24809 1 25058 1 25059 1 25060 1 25061 1 25062 1 25063 1 25064 1 25065 1 25314 1 25315 1 25316 1 25317 1 25318 1 25319 1 25320 1 25321 1 25570 1 25571 1 25572 1 25573 1 25574 1 25575 1 25576 1 25577 1 25826 1 25827 1 25828 1 25829 1 25830 1 25831 1 25832 1 25833 1 21209 1 21210 1 21211 1 21212 1 21213 1 21214 1 21215 1 21216 1 21465 1 21466 1 21467 1 21468 1 21469 1 21470 1 21471 1 21472 1 21721 1 21722 1 21723 1 21724 1 21725 1 21726 1 21727 1 21728 1 21977 1 21978 1 21979 1 21980 1 21981 1 21982 1 21983 1 21984 1 22233 1 22234 1 22235 1 22236 1 22237 1 22238 1 22239 1 22240 1 22489 1 22490 1 22491 1 22492 1 22493 1 22494 1 22495 1 22496 1 22745 1 22746 1 22747 1 22748 1 22749 1 22750 1 22751 1 22752 1 23001 1 23002 1 23003 1 23004 1 23005 1 23006 1 23007 1 23008 1 23257 1 23258 1 23259 1 23260 1 23261 1 23262 1 23263 1 23264 1 21218 1 21219 1 21220 1 21221 1 21222 1 21223 1 21224 1 21225 1 21474 1 21475 1 21476 1 21477 1 21478 1 21479 1 21480 1 21481 1 21730 1 21731 1 21732 1 21733 1 21734 1 21735 1 21736 1 21737 1 21986 1 21987 1 21988 1 21989 1 21990 1 21991 1 21992 1 21993 1 22242 1 22243 1 22244 1 22245 1 22246 1 22247 1 22248 1 22249 1 22498 1 22499 1 22500 1 22501 1 22502 1 22503 1 22504 1 22505 1 22754 1 22755 1 22756 1 22757 1 22758 1 22759 1 22760 1 22761 1 23010 1 23011 1 23012 1 23013 1 23014 1 23015 1 23016 1 23017 1 23266 1 23267 1 23268 1 23269 1 23270 1 23271 1 23272 1 23273
npw lets see Tab_RefNest
for remember
for add spawn npc or mob need these 3 tablets : Tab_RefHive | Tab_RefTactics | Tab_RefNest
but the spawn location are in this so will see with this
Tab_RefNest
with this query u can search easly npc spawn and edit
Code:
WHERE (dwNestID IN
(SELECT Nest.dwNestID
FROM Tab_RefNest AS Nest INNER JOIN
Tab_RefTactics AS Tact ON Nest.dwTacticsID = Tact.dwTacticsID INNER JOIN
_RefObjCommon AS Com ON Tact.dwObjID = Com.ID
WHERE (Com.CodeName128 LIKE '%NPC_JUPITER_%'))) -- here is all jupiter npc by exemple can search by npc too :)
ok now lets see
this tablet is links town to town or custom teleport to ...
_RefTeleLink
i used 1 because 1 = jangan for see all jangan teleport link more easely (this just an exemple u can chenge by what town u want (u will find all teleport in _RefTeleport))
Code:
-- 1 = _RefTeleport ID WHERE (OwnerTeleport = 1) --From owner teleport to others WHERE (TargetTeleport = 1)--From other to owner
i will maybe macke a part 3 if i will find the time
Thanks
