How i can delete new reverse spots
I have too many reverse spots so how i can delete thats. I must return like originally. How i can do that?
Re: How i can delete new reverse spots
If you want original reverse spot
then run this query
Code:
USE SRO_VT_SHARD
TRUNCATE TABLE _RefOptionalTeleport
Then add this lines :
Code:
| 1 |
1 |
?????? |
SN_ZONE_22004 |
26959 |
1030 |
80 |
512 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
2 |
??? ? |
SN_ZONE_25063 |
27207 |
648 |
-21 |
194 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
3 |
??? ?? |
SN_ZONE_25068 |
25416 |
735 |
0 |
1674 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
4 |
???? |
SN_ZONE_25057 |
26205 |
1091 |
169 |
46 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
5 |
??????? ? |
SN_ZONE_25053 |
25957 |
2 |
272 |
1821 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
6 |
????? |
SN_ZONE_22005 |
27244 |
271 |
180 |
1438 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
7 |
???? |
SN_ZONE_25047 |
26219 |
1884 |
42 |
1900 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
8 |
????? |
SN_ZONE_25046 |
26737 |
705 |
272 |
1466 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
9 |
??? |
SN_ZONE_24013 |
24431 |
1223 |
2034 |
1312 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
10 |
?????? |
SN_ZONE_25039 |
23664 |
1093 |
4206 |
1076 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
11 |
????? |
SN_ZONE_25036 |
23914 |
882 |
2806 |
300 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
12 |
????? |
SN_ZONE_25035 |
22125 |
997 |
2566 |
519 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
13 |
????? |
SN_ZONE_25034 |
23156 |
728 |
2288 |
1593 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
14 |
???? |
SN_ZONE_25027 |
26752 |
1285 |
206 |
176 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
15 |
????? |
SN_ZONE_25024 |
25731 |
664 |
-135 |
1847 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
16 |
????? |
SN_ZONE_25026 |
26503 |
984 |
-469 |
831 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
17 |
?? |
SN_ZONE_22003 |
23687 |
1255 |
245 |
83 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
18 |
??? |
SN_ZONE_25011 |
24713 |
705 |
-13 |
1057 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
19 |
?????? |
SN_ZONE_25018_1 |
22658 |
1504 |
1395 |
794 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
20 |
???? |
SN_ZONE_25019 |
23166 |
1523 |
547 |
445 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
21 |
???? |
SN_ZONE_25020 |
23931 |
1259 |
1913 |
93 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
22 |
?????? |
SN_ZONE_25003 |
23445 |
335 |
197 |
1011 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
23 |
???? |
SN_ZONE_24006 |
24211 |
195 |
1076 |
747 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
24 |
?? |
SN_ZONE_22002 |
26265 |
972 |
-106 |
1421 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
25 |
????? |
SN_ZONE_25015 |
26526 |
772 |
-91 |
934 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
26 |
?? |
SN_ZONE_22001 |
25000 |
995 |
-32 |
1132 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
27 |
???? |
SN_ZONE_25007 |
24490 |
514 |
-20 |
90 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
28 |
????? |
SN_ZONE_25005 |
23712 |
771 |
1390 |
966 |
1 |
-1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
29 |
??????(?????) |
xxx |
27027 |
1814 |
452 |
1834 |
1 |
1 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
30 |
????1? |
SN_ZONE_23002 |
-32767 |
1115 |
0 |
-935 |
1 |
1 |
0 |
50 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
31 |
???? (?? ???) |
xxx |
26284 |
960 |
111 |
1662 |
1 |
2 |
1 |
0 |
0 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
32 |
??2? (2???) |
SN_ZONE_26002 |
-32762 |
-11719 |
-47 |
5742 |
1 |
2 |
0 |
70 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
33 |
??3? (3???) |
SN_ZONE_26003 |
-32763 |
397 |
72 |
55 |
1 |
2 |
0 |
70 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 0 |
34 |
??3? (?? ?) |
SN_ZONE_26003_1 |
-32763 |
15855 |
549 |
-18952 |
1 |
2 |
0 |
70 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 0 |
35 |
??3? (?? ?) |
SN_ZONE_26003_2 |
-32763 |
-15711 |
549 |
19794 |
1 |
2 |
0 |
70 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 0 |
36 |
??3? (?? ?) |
SN_ZONE_26003_3 |
-32763 |
-19110 |
584 |
-16170 |
1 |
2 |
0 |
70 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 0 |
37 |
??3? (?? ?) |
SN_ZONE_26003_4 |
-32763 |
19140 |
549 |
15784 |
1 |
2 |
0 |
70 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
38 |
??4? (????) |
SN_ZONE_26004 |
-32764 |
-1103 |
-32 |
-180 |
1 |
2 |
0 |
70 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
39 |
?????? (?) |
SN_ZONE_21836_15 |
23088 |
663 |
863 |
526 |
1 |
-1 |
1 |
95 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
40 |
?????? (?) |
SN_ZONE_21836_16 |
23603 |
1030 |
80 |
512 |
1 |
-1 |
1 |
95 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
41 |
???? |
SN_ZONE_21833_6 |
19010 |
535 |
-30 |
1875 |
1 |
-1 |
1 |
95 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| 1 |
42 |
???? |
SN_ZONE_21833_8 |
21576 |
1626 |
-81 |
1746 |
1 |
-1 |
1 |
95 |
999 |
-1 |
xxx |
-1 |
xxx |
-1 |
xxx |
| NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|