Форум администраторов игровых серверов

Ребят вопросы: Ответте плиз!!!

1) Скачиваю патч у меня открывает:

Зырь:

Index: data/static_data/spawns/Monsters/400010000.xml ================================================== ================= --- data/static_data/spawns/Monsters/400010000.xml (revision 2305) +++ data/static_data/spawns/Monsters/400010000.xml (working copy) @@ -825,88 +825,6 @@ <object x="2097.37" y="1905.71" z="2339.239" h="45"/> <object x="2083.41" y="1933.56" z="2340.3416" h="16"/> <object x="2201.81" y="1945.23" z="2502.0813" h="79"/> - <object x="3206.76" y="2668.06" z="1479.5413" h="18"/> - <object x="3192.68" y="2669.77" z="1480.13" h="23"/> - <object x="3205.18" y="2681.02" z="1480.1296" h="45"/> - <object x="3183.56" y="2680.39" z="1480.1332" h="11"/> - <object x="3195.68" y="2691.52" z="1480.1342" h="74"/> - <object x="3173.7" y="2703.57" z="1479.0452" h="84"/> - <object x="2795.2" y="2556.22" z="1522.0659" h="53"/> - <object x="2786.01" y="2555.44" z="1522.0796" h="50"/> - <object x="2746.0" y="2581.23" z="1516.1166" h="40"/> - <object x="2811.22" y="2565.45" z="1533.4379" h="84"/> - <object x="2727.75" y="2603.33" z="1516.0526" h="25"/> - <object x="2776.19" y="2619.07" z="1556.5587" h="5"/> - <object x="2833.15" y="2582.82" z="1516.7633" h="107"/> - <object x="2810.03" y="2622.19" z="1554.6915" h="5"/> - <object x="2806.08" y="2639.04" z="1554.6915" h="55"/> - <object x="2730.65" y="2620.85" z="1516.0594" h="89"/> - <object x="2760.66" y="2647.27" z="1520.663" h="91"/> - <object x="2738.04" y="2665.15" z="1456.7654" h="99"/> - <object x="2727.4" y="2614.99" z="1516.0509" h="25"/> - <object x="2776.54" y="2659.57" z="1521.7291" h="56"/> - <object x="2759.09" y="2643.63" z="1461.6362" h="105"/> - <object x="2805.54" y="2611.39" z="1456.6506" h="100"/> - <object x="2809.19" y="2663.72" z="1512.6382" h="49"/> - <object x="2816.81" y="2625.47" z="1456.3955" h="55"/> - <object x="2826.21" y="2663.04" z="1512.6382" h="42"/> - <object x="2849.37" y="2614.87" z="1516.0524" h="30"/> - <object x="2825.98" y="2662.88" z="1512.6382" h="97"/> - <object x="2804.25" y="3226.0" z="1471.4623" h="65"/> - <object x="2815.38" y="3193.38" z="1470.3768" h="65"/> - <object x="2809.88" y="3202.75" z="1471.0573" h="75"/> - <object x="2791.62" y="3229.75" z="1470.9506" h="10"/> - <object x="2812.12" y="3214.88" z="1471.4601" h="86"/> - <object x="2800.5" y="3216.5" z="1472.3594" h="31"/> - <object x="2786.0" y="3239.38" z="1470.3767" h="6"/> - <object x="2554.59" y="2864.24" z="1524.5323" h="33"/> - <object x="2571.59" y="2813.78" z="1518.5621" h="116"/> - <object x="2565.01" y="2828.63" z="1523.0732" h="39"/> - <object x="2590.36" y="2791.92" z="1518.5037" h="78"/> - <object x="2602.05" y="2790.65" z="1518.5038" h="43"/> - <object x="2575.8" y="2887.2" z="1523.323" h="44"/> - <object x="2607.13" y="2851.55" z="1529.4946" h="39"/> - <object x="2586.75" y="2899.12" z="1505.9313" h="25"/> - <object x="2604.37" y="2871.98" z="1459.2157" h="25"/> - <object x="2638.4" y="2816.72" z="1523.0815" h="51"/> - <object x="2613.11" y="2878.51" z="1459.2157" h="74"/> - <object x="2623.25" y="2910.83" z="1518.1158" h="29"/> - <object x="2657.65" y="2799.33" z="1479.6104" h="83"/> - <object x="2661.85" y="2799.36" z="1479.3792" h="71"/> - <object x="2649.74" y="2819.0" z="1481.5363" h="72"/> - <object x="2659.87" y="2839.69" z="1524.541" h="9"/> - <object x="2627.19" y="2804.1" z="1518.5647" h="5"/> - <object x="2642.19" y="2889.54" z="1504.0155" h="18"/> - <object x="1330.55" y="1147.02" z="1526.651" h="29"/> - <object x="1375.23" y="1139.3" z="1531.2358" h="48"/> - <object x="1358.31" y="1138.73" z="1526.7109" h="70"/> - <object x="1411.91" y="1143.97" z="1532.6943" h="34"/> - <object x="1324.26" y="1156.2" z="1526.6516" h="101"/> - <object x="1399.01" y="1156.22" z="1531.7091" h="108"/> - <object x="1397.64" y="1234.72" z="1527.3636" h="63"/> - <object x="1432.0" y="1217.08" z="1526.652" h="46"/> - <object x="1421.64" y="1216.97" z="1528.2596" h="0"/> - <object x="1425.54" y="1226.17" z="1526.652" h="30"/> - <object x="1371.45" y="1234.75" z="1531.5085" h="19"/> - <object x="1430.08" y="1188.19" z="1512.3293" h="78"/> - <object x="1350.05" y="1233.05" z="1532.6907" h="118"/> - <object x="1401.87" y="1201.34" z="1467.3636" h="37"/> - <object x="1392.33" y="1203.21" z="1467.3636" h="29"/> - <object x="1375.77" y="1184.82" z="1536.0299" h="106"/> - <object x="1332.87" y="1201.23" z="1531.252" h="15"/> - <object x="1357.14" y="1217.72" z="1531.7638" h="68"/> - <object x="1326.35" y="1185.4" z="1526.7083" h="73"/> - <object x="1293.6" y="1192.73" z="1480.3392" h="73"/> - <object x="1303.36" y="1219.58" z="1446.4296" h="83"/> - <object x="1307.09" y="1227.04" z="1446.4294" h="102"/> - <object x="1309.04" y="1214.42" z="1446.4296" h="11"/> - <object x="1302.21" y="1186.25" z="1461.8333" h="47"/> - <object x="1338.73" y="1211.6" z="1497.7865" h="99"/> - <object x="1322.1" y="1197.48" z="1488.0873" h="32"/> - <object x="1314.9" y="1225.53" z="1446.4296" h="82"/> - <object x="1297.88" y="1174.33" z="1461.8334" h="47"/> - <object x="1308.17" y="1178.36" z="1481.7734" h="100"/> - <object x="1295.97" y="1182.22" z="1461.8333" h="52"/> <object x="2568.12" y="722.67" z="2891.9844" h="101"/> <object x="2577.3" y="734.29" z="2892.3496" h="26"/> <object x="2585.98" y="749.42" z="2894.8328" h="88"/> @@ -2034,21 +1952,6 @@ <object x="2142.866" y="1954.763" z="2307.9946" h="40"/> <object x="2137.599" y="1808.898" z="2307.3428" h="31"/> <object x="2137.871" y="1885.694" z="2321.5852" h="14"/> - <object x="2789.212" y="2586.848" z="1503.7496" h="97"/> - <object x="2758.296" y="2609.01" z="1503.6855" h="43"/> - <object x="2729.672" y="2609.277" z="1502.2645" h="70"/> - <object x="2789.001" y="2631.803" z="1503.7496" h="30"/> - <object x="2849.807" y="2609.281" z="1502.216" h="48"/> - <object x="2838.374" y="2609.346" z="1502.9432" h="107"/> - <object x="2739.822" y="2609.111" z="1502.9056" h="39"/> - <object x="2618.254" y="2919.653" z="1503.1815" h="27"/> - <object x="2601.95" y="2853.598" z="1499.2722" h="9"/> - <object x="2585.021" y="2857.342" z="1506.201" h="36"/> - <object x="2601.66" y="2821.668" z="1506.142" h="114"/> - <object x="2594.743" y="2784.224" z="1503.8159" h="3"/> - <object x="2596.508" y="2791.643" z="1504.5941" h="112"/> - <object x="2617.697" y="2912.514" z="1504.218" h="23"/> - <object x="1362.5197" y="1218.1344" z="1495.0896" h="26"/> <object x="2834.665" y="817.9756" z="2869.9075" h="74"/> <object x="2732.605" y="822.1308" z="2872.0632" h="23"/> <object x="2835.244" y="811.1823" z="2869.9075" h="76"/> @@ -2340,64 +2243,6 @@ <object x="2165.967" y="1887.6" z="2335.0864" h="11"/> <object x="2110.967" y="1885.559" z="2274.7688" h="80"/> <object x="2178.935" y="1906.475" z="2339.3687" h="96"/> - <object x="2982.0" y="2616.0" z="1487.9949" h="7"/> - <object x="3193.625" y="2681.125" z="1480.7878" h="91"/> - <object x="3174.25" y="2703.875" z="1479.0452" h="115"/> - <object x="2994.625" y="2584.375" z="1489.7595" h="55"/> - <object x="2759.087" y="2643.634" z="1461.6357" h="95"/> - <object x="2738.041" y="2665.147" z="1456.7654" h="79"/> - <object x="2989.875" y="2571.375" z="1488.4891" h="22"/> - <object x="2986.375" y="2589.125" z="1489.9775" h="18"/> - <object x="3204.875" y="2681.25" z="1480.1266" h="97"/> - <object x="2983.25" y="2606.5" z="1488.4498" h="75"/> - <object x="2977.25" y="2595.0" z="1489.0889" h="61"/> - <object x="2993.25" y="2597.25" z="1489.0837" h="92"/> - <object x="2979.75" y="2581.625" z="1489.0706" h="56"/> - <object x="3183.75" y="2680.0" z="1480.1296" h="44"/> - <object x="3207.125" y="2668.0" z="1479.5159" h="41"/> - <object x="3180.375" y="2697.0" z="1479.1775" h="40"/> - <object x="3192.25" y="2670.875" z="1480.1207" h="92"/> - <object x="3195.75" y="2690.5" z="1480.1274" h="91"/> - <object x="2809.75" y="3202.625" z="1471.0603" h="75"/> - <object x="2657.648" y="2799.329" z="1479.6105" h="48"/> - <object x="2651.102" y="3075.726" z="1482.2152" h="11"/> - <object x="2655.453" y="3054.056" z="1482.2136" h="43"/> - <object x="2644.219" y="3059.741" z="1482.2155" h="25"/> - <object x="2642.875" y="2845.625" z="1523.3267" h="82"/> - <object x="2570.0" y="2858.0" z="1523.3267" h="49"/> - <object x="2667.874" y="3058.581" z="1481.8063" h="24"/> - <object x="2791.375" y="3230.25" z="1470.8999" h="74"/> - <object x="2790.75" y="3216.75" z="1471.4598" h="113"/> - <object x="2661.85" y="2799.361" z="1479.3793" h="57"/> - <object x="2662.879" y="3069.71" z="1482.2183" h="91"/> - <object x="2800.75" y="3216.25" z="1472.3594" h="116"/> - <object x="2678.851" y="3053.654" z="1481.1342" h="15"/> - <object x="2597.75" y="2800.5" z="1520.1714" h="59"/> - <object x="2811.625" y="3215.5" z="1471.4535" h="28"/> - <object x="2815.25" y="3193.5" z="1470.3768" h="20"/> - <object x="2627.704" y="3077.591" z="1480.894" h="94"/> - <object x="2656.173" y="3070.122" z="1483.1167" h="110"/> - <object x="2797.5" y="3206.0" z="1471.4556" h="12"/> - <object x="2786.25" y="3239.375" z="1470.3767" h="52"/> - <object x="2804.25" y="3225.875" z="1471.4613" h="79"/> - <object x="1411.928" y="1144.083" z="1532.6925" h="62"/> - <object x="1324.377" y="1156.217" z="1526.6514" h="99"/> - <object x="1401.865" y="1201.339" z="1467.3636" h="108"/> - <object x="1397.765" y="1234.968" z="1527.3636" h="76"/> - <object x="1349.68" y="1233.172" z="1532.6979" h="90"/> - <object x="1333.122" y="1200.982" z="1531.2493" h="109"/> - <object x="1425.927" y="1226.157" z="1526.6509" h="74"/> - <object x="1429.806" y="1188.332" z="1527.3636" h="101"/> - <object x="1371.821" y="1234.88" z="1531.5022" h="32"/> - <object x="1326.605" y="1185.24" z="1526.7136" h="16"/> - <object x="1330.657" y="1146.998" z="1526.6514" h="93"/> - <object x="1421.26" y="1216.725" z="1528.2587" h="7"/> - <object x="1398.885" y="1156.725" z="1531.6672" h="99"/> - <object x="1358.302" y="1139.33" z="1526.7219" h="15"/> - <object x="1432.103" y="1217.191" z="1526.6519" h="13"/> - <object x="1375.218" y="1139.178" z="1531.235" h="41"/> - <object x="1422.941" y="1173.047" z="1531.4713" h="33"/> - <object x="1357.01" y="1217.6" z="1531.7617" h="6"/> <object x="2568.166" y="722.4508" z="2891.9844" h="81"/> <object x="2675.15" y="787.5762" z="2884.364" h="113"/> <object x="2730.555" y="855.1218" z="2890.4126" h="120"/> @@ -2569,10 +2414,6 @@ <object x="2522.75" y="2186.75" z="2996.5278" h="100"/> <object x="2637.0" y="2111.25" z="3001.627" h="74"/> </spawn> -  - <spawn map="400010000" npcid="264769" pool="1" interval="295"> - <object x="1354.06" y="1170.359" z="1507.4271" h="56"/> - </spawn>  <spawn map="400010000" npcid="275421" pool="3" interval="300"> <object x="1364.4" y="1249.05" z="1512.2489" h="89"/> @@ -3024,10 +2865,6 @@ <object x="1317.75" y="1253.74" z="1512.8203" h="72"/> <object x="1324.08" y="1258.89" z="1512.0542" h="14"/> </spawn> -  - <spawn map="400010000" npcid="264719" pool="1" interval="300"> - <object x="1383.39" y="1220.97" z="1514.6681" h="93"/> - </spawn>  <spawn map="400010000" npcid="255154" pool="1" interval="295"> <object x="2414.642" y="1708.775" z="2879.7202" h="41"/> @@ -4888,7 +4725,6 @@ </spawn>  <spawn map="400010000" npcid="263011" pool="1" interval="21600"> - <object x="2789.92" y="2608.72" z="1503.3386" h="76"/> <object x="2621.61" y="2857.77" z="1460.7179" h="107"/> <object x="2678.07" y="807.03" z="2826.58" h="46"/> <object x="1772.25" y="2268.53" z="2903.7485" h="33"/> @@ -5770,54 +5606,6 @@ <object x="2161.044" y="1890.17" z="2468.973" h="54"/> <object x="2140.078" y="1962.148" z="2556.2168" h="49"/> <object x="2066.316" y="1985.552" z="2489.3643" h="96"/> - <object x="3180.182" y="2696.516" z="1479.1976" h="93"/> - <object x="3192.682" y="2669.766" z="1480.1301" h="69"/> - <object x="3205.182" y="2681.016" z="1480.1298" h="44"/> - <object x="3195.682" y="2691.516" z="1480.1342" h="10"/> - <object x="2983.178" y="2606.083" z="1488.4895" h="68"/> - <object x="2993.428" y="2597.333" z="1489.0841" h="52"/> - <object x="2976.928" y="2593.833" z="1489.0797" h="43"/> - <object x="2982.052" y="2615.757" z="1487.9949" h="76"/> - <object x="3206.764" y="2668.062" z="1479.5411" h="73"/> - <object x="3183.557" y="2680.391" z="1480.1332" h="64"/> - <object x="3173.698" y="2703.573" z="1479.0452" h="83"/> - <object x="2996.178" y="2583.833" z="1489.0758" h="7"/> - <object x="2990.083" y="2570.599" z="1488.4167" h="37"/> - <object x="2979.178" y="2580.958" z="1489.0752" h="81"/> - <object x="3192.807" y="2681.141" z="1481.0278" h="88"/> - <object x="2815.375" y="3193.375" z="1470.3768" h="100"/> - <object x="2655.944" y="3070.394" z="1483.1167" h="77"/> - <object x="2812.125" y="3214.875" z="1471.4602" h="7"/> - <object x="2575.8" y="2887.205" z="1523.323" h="80"/> - <object x="2663.723" y="3070.201" z="1482.2231" h="110"/> - <object x="2668.024" y="3058.26" z="1481.7909" h="117"/> - <object x="2791.625" y="3229.75" z="1470.9507" h="77"/> - <object x="2627.629" y="3077.751" z="1481.134" h="65"/> - <object x="2602.053" y="2790.65" z="1518.5038" h="91"/> - <object x="2804.25" y="3226.0" z="1471.4623" h="28"/> - <object x="2790.125" y="3216.125" z="1471.4584" h="73"/> - <object x="2643.909" y="3058.524" z="1482.2139" h="60"/> - <object x="2637.399" y="3072.067" z="1481.6415" h="62"/> - <object x="2797.125" y="3204.875" z="1471.4618" h="43"/> - <object x="2678.68" y="3053.184" z="1481.1342" h="40"/> - <object x="2659.871" y="2839.686" z="1524.541" h="36"/> - <object x="2590.356" y="2791.916" z="1518.5037" h="53"/> - <object x="2565.006" y="2828.629" z="1523.0732" h="101"/> - <object x="2655.677" y="3053.576" z="1482.2169" h="44"/> - <object x="2651.23" y="3076.079" z="1482.2153" h="11"/> - <object x="2638.404" y="2816.722" z="1523.0818" h="79"/> - <object x="2586.75" y="2899.125" z="1519.2228" h="79"/> - <object x="2648.385" y="2874.407" z="1523.3228" h="94"/> - <object x="2604.371" y="2871.977" z="1459.2157" h="53"/> - <object x="2786.0" y="3239.375" z="1470.3767" h="5"/> - <object x="2809.875" y="3202.75" z="1471.0576" h="53"/> - <object x="2627.193" y="2804.099" z="1518.5646" h="95"/> - <object x="2623.253" y="2910.833" z="1518.1146" h="68"/> - <object x="2612.044" y="2913.125" z="1517.9325" h="61"/> - <object x="2571.592" y="2813.782" z="1518.5621" h="101"/> - <object x="2642.192" y="2889.545" z="1519.2229" h="62"/> - <object x="2554.593" y="2864.242" z="1524.5323" h="105"/> - <object x="2800.5" y="3216.5" z="1472.3594" h="44"/> <object x="737.6614" y="2932.976" z="2768.3037" h="18"/> <object x="734.9113" y="2991.017" z="2771.121" h="14"/> <object x="797.52167" y="3017.636" z="2734.175" h="86"/> Index: src/com/aionemu/gameserver/utils/InfluenceManager.java ================================================== ================= --- src/com/aionemu/gameserver/utils/InfluenceManager.java (revision 0) +++ src/com/aionemu/gameserver/utils/InfluenceManager.java (revision 0) @@ -0,0 +1,102 @@ +package com.aionemu.gameserver.utils; + +import java.util.ArrayList; +import java.util.Iterator; + +import org.apache.log4j.Logger; + +import com.aionemu.commons.database.dao.DAOManager; +import com.aionemu.gameserver.dao.FortressDAO; +import com.aionemu.gameserver.model.Race; +import com.aionemu.gameserver.model.gameobjects.player.Pl ayer; +import com.aionemu.gameserver.network.aion.serverpackets. SM_INFLUENCE_RATIO; +import com.aionemu.gameserver.services.FortressService; +import com.aionemu.gameserver.world.World; +import com.google.inject.Inject; +import com.google.inject.Injector; +import com.sun.tools.javac.util.Log; + +public class InfluenceManager +{ + + private static final Logger log = Logger.getLogger(InfluenceManager.class); + + private static float elyosRatio; + private static float asmodiansRatio; + private static float balaursRatio; + + private static float fortressCount = 3; + + @Inject + private static World world; + + public static void initialize(World world) + { + InfluenceManager.world = world; + ThreadPoolManager.getInstance().scheduleAtFixedRat e(new Runnable() { + @Override + public void run() { + // TODO Auto-generated method stub + recalculateInfluenceRatio(false); + } + }, 0, 300000); + } + + public static void recalculateInfluenceRatio(boolean sendPackets) + { + log.info("Starting influence ratios recalculation"); + ArrayList<Race> currentFortressHolders = new ArrayList<Race>(); + for(int i=0; i < fortressCount; i++) + { + currentFortressHolders.add(DAOManager.getDAO(Fortr essDAO.class).getCurrentFortressOwnerFaction(i+1)) ; + } + float elyosCount = 0; + float asmodiansCount = 0; + float balaursCount = 0; + for(Race r : currentFortressHolders) + { + if(r == Race.ELYOS) + { + elyosCount++; + } + else if(r == Race.ASMODIANS) + { + asmodiansCount++; + } + else + { + balaursCount++; + } + } + elyosRatio = Math.round((elyosCount / fortressCount) * 100); + asmodiansRatio = Math.round((asmodiansCount / fortressCount) * 100); + balaursRatio = Math.round((balaursCount / fortressCount) * 100); + log.info("Influence ratios were recalculated :: ELYOS " + elyosRatio + "% - ASMODIANS " + asmodiansRatio + "% - BALAURS " + balaursRatio + "%"); + if(sendPackets) + { + Iterator<Player> players = InfluenceManager.world.getPlayersIterator(); + while(players.hasNext()) + { + Player p = players.next(); + PacketSendUtility.sendPacket(p, new SM_INFLUENCE_RATIO()); + } + } + } + + public static float getElyosRatio() + { + return elyosRatio; + } + + public static float getAsmodiansRatio() + { + return asmodiansRatio; + } + + public static float getBalaursRatio() + { + return balaursRatio; + } + +} + Index: src/com/aionemu/gameserver/services/FortressService.java ================================================== ================= --- src/com/aionemu/gameserver/services/FortressService.java (revision 0) +++ src/com/aionemu/gameserver/services/FortressService.java (revision 0) @@ -0,0 +1,330 @@ +package com.aionemu.gameserver.services; + +import java.util.ArrayList; +import java.util.Collection; +import java.util.HashMap; +import java.util.Iterator; +import java.util.Map; +import java.util.Random; + +import org.apache.log4j.Logger; + +import com.aionemu.commons.database.dao.DAO; +import com.aionemu.commons.database.dao.DAOManager; +import com.aionemu.commons.utils.Rnd; +import com.aionemu.gameserver.ai.desires.impl.AggressionD esire; +import com.aionemu.gameserver.ai.npcai.AggressiveAi; +import com.aionemu.gameserver.ai.state.AIState; +import com.aionemu.gameserver.dao.FortressDAO; +import com.aionemu.gameserver.dataholders.DataManager; +import com.aionemu.gameserver.dataholders.TribeRelationsD ata; +import com.aionemu.gameserver.model.Race; +import com.aionemu.gameserver.model.gameobjects.AionObjec t; +import com.aionemu.gameserver.model.gameobjects.Creature; +import com.aionemu.gameserver.model.gameobjects.FortressG eneral; +import com.aionemu.gameserver.model.gameobjects.Item; +import com.aionemu.gameserver.model.gameobjects.Npc; +import com.aionemu.gameserver.model.gameobjects.Monster; +import com.aionemu.gameserver.model.gameobjects.VisibleOb ject; +import com.aionemu.gameserver.model.gameobjects.player.Pl ayer; +import com.aionemu.gameserver.model.group.PlayerGroup; +import com.aionemu.gameserver.model.templates.spawn.NpcSp awnTemplate; +import com.aionemu.gameserver.model.templates.spawn.Spawn Template; +import com.aionemu.gameserver.model.templates.tribe.Aggro Relations; +import com.aionemu.gameserver.model.templates.tribe.Hosti leRelations; +import com.aionemu.gameserver.model.templates.tribe.Tribe ; +import com.aionemu.gameserver.network.aion.serverpackets. SM_MESSAGE; +import com.aionemu.gameserver.spawnengine.SpawnEngine; +import com.aionemu.gameserver.utils.InfluenceManager; +import com.aionemu.gameserver.utils.PacketSendUtility; +import com.aionemu.gameserver.utils.ThreadPoolManager; +import com.aionemu.gameserver.world.World; +import com.aionemu.gameserver.world.WorldPosition; +import com.google.inject.Inject; + +/* + * @author Xitanium + */ + +public class FortressService +{ + private static final Logger log = Logger.getLogger(FortressService.class); + @Inject + private SpawnEngine spawnEngine; + @Inject + private World world; + @Inject + private TeleportService teleportService; + @Inject + private GroupService groupService; + @Inject + private ItemService itemService; + + /* + * balaurAssaultChance + * probability percentage, if 100 balaur will assault every hour, if 0 will never (value is the chance balaurs have to assault the fortress) + */ + private static final int balaurAssaultChance = 20; + + private static final int balaurAssaultInterval = 3600; //value in seconds + + private static Map<Integer,ArrayList<PlayerGroup>> registeredRewardableGroups = new HashMap<Integer, ArrayList<PlayerGroup>>(); + + public void initialize() + { + // initialize container and AI + for(int i=0; i < 9; i++) + { + registeredRewardableGroups.put(i+1, new ArrayList<PlayerGroup>()); + } + // spawn individual fortresses + // 1: Archipel de Soufre + spawnFortress(1, DAOManager.getDAO(FortressDAO.class).getCurrentFor tressOwnerFaction(1), true); + // 2: Archipel des Ailes de Siel UP + spawnFortress(2, DAOManager.getDAO(FortressDAO.class).getCurrentFor tressOwnerFaction(2), true); + // 3: Archipel des Ailes de Siel DOWN + spawnFortress(3, DAOManager.getDAO(FortressDAO.class).getCurrentFor tressOwnerFaction(3), true); + // 4: Oeil de Reshanta + spawnFortress(4, DAOManager.getDAO(FortressDAO.class).getCurrentFor tressOwnerFaction(4), true); + // 5: Lac Asteria + /*spawnFortress(5, DAOManager.getDAO(FortressDAO.class).getCurrentFor tressOwnerFaction(5)); + // 6: Eclat oriental de Latesran + spawnFortress(6, DAOManager.getDAO(FortressDAO.class).getCurrentFor tressOwnerFaction(6)); + // 7: Ile de Kysis + spawnFortress(7, DAOManager.getDAO(FortressDAO.class).getCurrentFor tressOwnerFaction(7)); + // 8: Rocher de Krotan + spawnFortress(8, DAOManager.getDAO(FortressDAO.class).getCurrentFor tressOwnerFaction(8)); + // 9: Ruines de Roah + spawnFortress(9, DAOManager.getDAO(FortressDAO.class).getCurrentFor tressOwnerFaction(9));*/ + initializeBalaurAI(); + log.info("FortressService successfully initialized!"); + } + + public void registerRewardableGroup(PlayerGroup group, int fortressId) + { + if(!registeredRewardableGroups.get(fortressId).con tains(group)) + { + registeredRewardableGroups.get(fortressId).add(gro up); + } + } + + public Race getCurrentFortressOwner(int fortressId) + { + return DAOManager.getDAO(FortressDAO.class).getCurrentFor tressOwnerFaction(fortressId); + } + + private String getFortressName(int fortressId) + { + switch(fortressId) + { + case 1: return "Серного дерева"; + case 2: return "Западная крепость Сиэли"; + case 3: return "Восточная крепость Сиэли"; + case 4: return "Святости"; + case 5: return "Астерии"; + case 6: return "Ра-Мирэн"; + case 7: return "Ткисас"; + case 8: return "Кротан"; + case 9: return "древнего города Ру"; + default: return "Крепость"; + } + } + + public void spawnFortress(int fortressId, Race ownerFaction, boolean killedSelfFaction) + { + log.info("Starting fortress (re)spawn #" + fortressId); + // remove all spawns from the current fortress instance + clearFortress(fortressId); + // get all spawns from DB templates + ArrayList<NpcSpawnTemplate> spawnTemplates = DAOManager.getDAO(FortressDAO.class).getAllTemplat es(fortressId, ownerFaction); + // spawns npc using the specified race + int spawnedCounter = 0; + for(NpcSpawnTemplate tpl : spawnTemplates) + { + SpawnTemplate template = spawnEngine.addNewSpawn(tpl.getMap(), 1, tpl.getNpcTemplateId(), tpl.getX(), tpl.getY(), tpl.getZ(), tpl.getHeading(), 0, 0, true, true); + VisibleObject obj = spawnEngine.spawnObject(template, 1); + if(obj == null) + { + log.error("No template for fortress npc id #" + tpl.getNpcTemplateId()); + } + else + { + spawnedCounter++; + DAOManager.getDAO(FortressDAO.class).insertCache(f ortressId, obj.getObjectId()); + } + } + log.info("Successfully spawned " + spawnedCounter + " " + ownerFaction.name() + " npc for fortress #" + fortressId); + spawnFortressGeneral(fortressId, ownerFaction); + // send message to world : "Fortress XXXX is now available to attack for Asmodians" + if(!killedSelfFaction) + { + sendWorldMessage(getFortressName(fortressId), ownerFaction); + } + } + + private void sendWorldMessage(String fortressName, Race ownedBy) + { + Iterator<Player> players = world.getPlayersIterator(); + while(players.hasNext()) + { + Player dest = players.next(); + if(dest.getCommonData().getRace() != ownedBy) + { + String message = "Крепость "; + message += fortressName; + message += " захвачена "; + if(ownedBy == Race.ELYOS) + { + message += "Элийцами"; + } + else + { + message += "Асмодианами"; + } + message += ". Вы можете атаковать эту крепость."; + PacketSendUtility.sendMessage(dest, message); + } + else + { + String message = "Крепость "; + message += fortressName; + message += " захвачена вашей расой."; + message += ". Вы должны защищать эту позицию от атак вражеской расы."; + PacketSendUtility.sendMessage(dest, message); + } + } + } + + private void sendPlayersMessage(ArrayList<Player> players, String message) + { + for(Player p : players) + { + PacketSendUtility.sendMessage(p, message); + } + } + + public void clearFortress(int fortressId) + { + ArrayList<Integer> spawnedCreatures = DAOManager.getDAO(FortressDAO.class).loadCache(for tressId); + for(Integer creature : spawnedCreatures) + { + AionObject obj = world.findAionObject(creature); + if(obj instanceof Creature) + { + Creature c = (Creature)obj; + c.getController().delete(); + } + } + DAOManager.getDAO(FortressDAO.class).clearCache(fo rtressId); + if(registeredRewardableGroups.get(fortressId) == null) + { + registeredRewardableGroups.put(fortressId, new ArrayList<PlayerGroup>()); + } + else + { + registeredRewardableGroups.get(fortressId).clear() ; + } + log.info("Successfully cleared cache for fortress #" + fortressId); + } + + public void spawnFortressGeneral(int fortressId, Race race) + { + NpcSpawnTemplate generalTemplate = DAOManager.getDAO(FortressDAO.class).getGeneralSpa wnTemplate(fortressId, race); + SpawnTemplate tpl = spawnEngine.addNewSpawn(generalTemplate.getMap(), 1, generalTemplate.getNpcTemplateId(), generalTemplate.getX(), generalTemplate.getY(), generalTemplate.getZ(), generalTemplate.getHeading(), 0, 0, true, true); + FortressGeneral general = spawnEngine.spawnFortressGeneral(tpl, fortressId); + } + + public void triggerGeneralKilled(final int fortressId, Creature lastAttacker) + { + final ArrayList<Player> players = new ArrayList<Player>(); + if(registeredRewardableGroups.get(fortressId).size () == 0) + { + players.add((Player)lastAttacker); + } + else + { + for(PlayerGroup grp : registeredRewardableGroups.get(fortressId)) + { + Collection<Player> grpPlayers = grp.getMembers(); + for(Player p : grpPlayers) + { + players.add(p); + } + } + } + sendPlayersMessage(players, "Вы только что захватили крепость " + getFortressName(fortressId) + ". Вы будуте телепортированы ко входу через 5 секунд ..."); + ThreadPoolManager.getInstance().schedule(new Runnable() { + @Override + public void run() { + // TODO Auto-generated method stub + // get group members of lastAttacker + + //TODO: set correct exit point location + portPlayersToExit(players); + doPlayerMedalReward(players); + Race newRace; + if(getCurrentFortressOwner(fortressId) == Race.ELYOS) + { + newRace = Race.ASMODIANS; + } + else + { + newRace = Race.ELYOS; + } + DAOManager.getDAO(FortressDAO.class).setFortressOw ner(fortressId, newRace); + InfluenceManager.recalculateInfluenceRatio(true); + spawnFortress(fortressId, newRace, false); + } + }, 5000); + } + + public void doPlayerMedalReward(ArrayList<Player> players) + { + for(Player p : players) + { + itemService.addItem(p, 186000030, 3); + } + } + + public void portPlayersToExit(ArrayList<Player> players) + { + for(Player p : players) + { + teleportService.teleportTo(p, 400010000, (float)1300.8483, (float)1088.8396, (float)1508.2749, 0); + } + } + + /* + * Balaur pseudo-AI + */ + + public void initializeBalaurAI() + { + for(int i=0; i < 9; i++) + { + final int currentFortressId = i+1; + ThreadPoolManager.getInstance().scheduleAtFixedRat e(new Runnable() { + + @Override + public void run() { + // TODO Auto-generated method stub + int randomInt = Rnd.get(100); + if(randomInt < balaurAssaultChance) + { + launchBalaurAssault(currentFortressId); + } + } + }, balaurAssaultInterval*1000, balaurAssaultInterval*1000); + } + } + + public void launchBalaurAssault(int fortressId) + { + // get balaur spawnlist for specified fortressId + // spawn mobs + // update tribe to make balaur attack the current fortress holder faction + // notify players that balaur are attacking fortress + } + +} + Index: sql/Update/rev2255-Forteresse.sql ================================================== ================= --- sql/Update/rev2255-Forteresse.sql (revision 0) +++ sql/Update/rev2255-Forteresse.sql (revision 0) @@ -0,0 +1,245 @@ +/* +Navicat MySQL Data Transfer + +Source Server : Aion Dream +Source Server Version : 50051 +Source Host : esx01-1.aion-dream.net:3306 +Source Database : aion_world_dev_xitanium + +Target Server Type : MYSQL +Target Server Version : 50051 +File Encoding : 65001 + +Date: 2010-06-09 15:33:38 +*/ + +SET FOREIGN_KEY_CHECKS=0; +-- ---------------------------- +-- Table structure for `fortress_generals` +-- ---------------------------- +DROP TABLE IF EXISTS `fortress_generals`; +CREATE TABLE `fortress_generals` ( + `fortress_id` int(11) NOT NULL, + `general_template_id` bigint(20) NOT NULL, + `map` bigint(20) NOT NULL, + `pos_x` float NOT NULL, + `pos_y` float NOT NULL, + `pos_z` float NOT NULL, + `heading` tinyint(4) NOT NULL, + `race` varchar(255) NOT NULL +) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Records of fortress_generals +-- ---------------------------- +INSERT INTO `fortress_generals` VALUES ('1', '264507', '400010000', '1391.7', '1179.25', '1468.87', '28', 'ASMODIANS'); +INSERT INTO `fortress_generals` VALUES ('1', '264501', '400010000', '1391.51', '1179.63', '1468.87', '21', 'ELYOS'); +INSERT INTO `fortress_generals` VALUES ('2', '264507', '400010000', '2621.5364', '2858.5696', '1460.7179', '41', 'ASMODIANS'); +INSERT INTO `fortress_generals` VALUES ('2', '264501', '400010000', '2621.5364', '2858.5696', '1460.7179', '41', 'ELYOS'); +INSERT INTO `fortress_generals` VALUES ('3', '264507', '400010000', '2819.4636', '2614.564', '1456.5623', '1', 'ASMODIANS'); +INSERT INTO `fortress_generals` VALUES ('3', '264501', '400010000', '2819.4636', '2614.564', '1456.5623', '1', 'ELYOS'); + +-- ---------------------------- +-- Table structure for `fortress_owners` +-- ---------------------------- +DROP TABLE IF EXISTS `fortress_owners`; +CREATE TABLE `fortress_owners` ( + `fortress_id` int(11) NOT NULL, + `owner_faction` varchar(255) NOT NULL, + PRIMARY KEY (`fortress_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Records of fortress_owners +-- ---------------------------- +INSERT INTO `fortress_owners` VALUES ('1', 'ELYOS'); +INSERT INTO `fortress_owners` VALUES ('2', 'ELYOS'); +INSERT INTO `fortress_owners` VALUES ('3', 'ELYOS'); + +-- ---------------------------- +-- Table structure for `fortress_spawn_cache` +-- ---------------------------- +DROP TABLE IF EXISTS `fortress_spawn_cache`; +CREATE TABLE `fortress_spawn_cache` ( + `fortress_id` int(11) NOT NULL, + `unique_objectid` bigint(20) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Records of fortress_spawn_cache +-- ---------------------------- + +-- ---------------------------- +-- Table structure for `fortress_spawn_template` +-- ---------------------------- +DROP TABLE IF EXISTS `fortress_spawn_template`; +CREATE TABLE `fortress_spawn_template` ( + `fortress_id` int(11) NOT NULL, + `npc_template_id` bigint(20) NOT NULL, + `map` bigint(20) NOT NULL, + `pos_x` float NOT NULL, + `pos_y` float NOT NULL, + `pos_z` float NOT NULL, + `heading` tinyint(4) NOT NULL, + `race` varchar(255) NOT NULL +) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Records of fortress_spawn_template +-- ---------------------------- +INSERT INTO `fortress_spawn_template` VALUES ('1', '257090', '400010000', '1355.48', '1167.41', '1514.3', '72', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270154', '400010000', '1432.7', '1232.25', '1512.08', '9', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270157', '400010000', '1449.89', '1274.57', '1509.58', '0', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '269260', '400010000', '1475.74', '1246.45', '1509.73', '0', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1325.44', '1161.63', '1526.67', '95', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1335.77', '1145.24', '1526.66', '76', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1355.57', '1141.08', '1526.76', '88', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1400.62', '1139.5', '1532.64', '97', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1412.83', '1147.85', '1532.64', '114', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1428.76', '1189.28', '1527.36', '8', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1430.45', '1211.98', '1526.67', '15', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1419.85', '1228.09', '1526.67', '15', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1399.3', '1231.83', '1527.36', '23', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1355.42', '1233.25', '1532.63', '35', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1343.1', '1225.27', '1532.64', '53', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1328.97', '1183.21', '1526.77', '62', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1376.58', '1140.6', '1531.25', '85', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260256', '400010000', '1358.76', '1262.45', '1511.46', '88', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260256', '400010000', '1441.76', '1065.27', '1515.16', '91', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260256', '400010000', '1356.48', '1264.65', '1511.33', '19', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260256', '400010000', '1328.86', '1238.85', '1511.64', '70', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260259', '400010000', '1457.1', '1149.27', '1512.08', '118', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260253', '400010000', '1312.46', '1183.41', '1511.33', '31', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260256', '400010000', '1406.89', '1084.09', '1516.09', '47', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260253', '400010000', '1316.72', '1153.96', '1511.63', '101', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260253', '400010000', '1324.21', '1143.58', '1511.7', '101', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260259', '400010000', '1381.36', '1108.24', '1515.6', '115', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260259', '400010000', '1315.41', '1109.41', '1509.2', '76', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260259', '400010000', '1300.31', '1133.56', '1509.36', '74', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260253', '400010000', '1346.17', '1122.15', '1510.95', '107', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260256', '400010000', '1432.79', '1150.47', '1512.93', '10', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257097', '400010000', '1379.58', '1102.05', '1515.68', '56', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257097', '400010000', '1380.11', '1102.91', '1515.68', '47', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257688', '400010000', '1380.96', '1252.59', '1511.68', '7', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260253', '400010000', '1445.9', '1200.56', '1512.62', '26', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1367.28', '1186.91', '1507.42', '100', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1373.7', '1177.83', '1507.42', '101', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257088', '400010000', '1408', '1203.33', '1514.26', '8', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257088', '400010000', '1406.57', '1202.78', '1514.28', '55', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257088', '400010000', '1407.55', '1203.05', '1514.27', '12', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257088', '400010000', '1405', '1204.12', '1514.28', '8', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257073', '400010000', '1404.06', '1203.9', '1514.29', '7', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257088', '400010000', '1404.06', '1203.9', '1514.29', '7', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257073', '400010000', '1404.06', '1203.9', '1514.29', '7', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257073', '400010000', '1404.06', '1203.9', '1514.29', '7', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264767', '400010000', '1370.95', '1151.89', '1514.67', '41', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264723', '400010000', '1343.04', '1192.99', '1514.67', '101', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264717', '400010000', '1412.33', '1177.71', '1514.67', '42', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264720', '400010000', '1381.58', '1223.39', '1514.67', '99', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264769', '400010000', '1353.18', '1170.57', '1507.43', '12', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264718', '400010000', '1331.46', '1241.58', '1496.96', '100', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264798', '400010000', '1343.74', '1239.28', '1496.58', '69', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1338.96', '1212.14', '1497.76', '11', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1402.56', '1199.27', '1467.36', '25', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1391.75', '1201.89', '1467.36', '34', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257088', '400010000', '1359.26', '1212.47', '1497.43', '76', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1361', '1214.2', '1496.72', '76', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1391.1', '1236.15', '1486.33', '68', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1434.19', '1218.77', '1473.46', '46', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1405.54', '1183.09', '1468.99', '12', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1395.65', '1190.98', '1469.07', '25', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1382.62', '1189.71', '1469.12', '34', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1386.17', '1229.27', '1466.12', '108', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1380.54', '1211.63', '1466.12', '6', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1416.54', '1224.84', '1466.12', '80', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1421.45', '1203.2', '1466.12', '68', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1402.56', '1203.72', '1514.3', '11', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1353.24', '1169.68', '1514.29', '72', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1364.98', '1206.49', '1514.35', '101', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1392.29', '1166.51', '1514.35', '38', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1388.82', '1171.53', '1535', '102', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270997', '400010000', '1367.43', '1201.84', '1534.96', '42', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1401', '1154.5', '1531.93', '103', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1356.03', '1218.05', '1531.84', '42', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270154', '400010000', '1440.53', '1219.53', '1512.46', '12', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1334.67', '1202.96', '1531.32', '58', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1422.26', '1173.37', '1531.47', '5', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1381.9', '1233.36', '1531.47', '27', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1378.3', '1185.87', '1536.03', '29', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1322.18', '1194.3', '1487.08', '82', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1310.66', '1175.88', '1481.98', '55', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1292.02', '1190.11', '1480.4', '51', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '260199', '400010000', '1293.48', '1192.7', '1480.32', '51', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '12950', '400010000', '1396.22', '1170.6', '1514.35', '42', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264719', '400010000', '1381.49', '1222.06', '1514.67', '102', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257087', '400010000', '1403.96', '1204.39', '1514.28', '11', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264766', '400010000', '1373.25', '1150.49', '1514.67', '41', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264715', '400010000', '1413.66', '1176.43', '1514.67', '39', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257087', '400010000', '1403.96', '1204.39', '1514.28', '11', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257087', '400010000', '1403.96', '1204.39', '1514.28', '11', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264722', '400010000', '1342.76', '1192.97', '1514.67', '101', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270996', '400010000', '1403.18', '1204.11', '1514.29', '12', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '12933', '400010000', '1363.61', '1206.43', '1514.35', '102', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270996', '400010000', '1364.27', '1205.6', '1514.35', '102', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '271061', '400010000', '1472.93', '1241.81', '1509.99', '16', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257093', '400010000', '1381.81', '1229.61', '1530.83', '11', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '12933', '400010000', '1363.61', '1206.43', '1514.35', '102', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '257093', '400010000', '1370.73', '1178.14', '1507.42', '11', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266558', '400010000', '1436.61', '1073.22', '1516.04', '94', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1364.25', '1205.28', '1514.35', '104', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1394.28', '1168.29', '1514.35', '43', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1389.7', '1170.9', '1534.67', '100', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1368.44', '1199.91', '1535.68', '41', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1363.2', '1216.04', '1495.79', '74', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1393.39', '1237.38', '1485.8', '67', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1370.73', '1177.71', '1507.42', '9', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1432.51', '1222.59', '1474.67', '49', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1406.92', '1185.37', '1469.19', '12', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1395.47', '1193.08', '1469.19', '26', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1378.17', '1211.62', '1466.12', '113', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1380.86', '1190.84', '1469.19', '34', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1421.82', '1202.04', '1466.12', '55', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1418.03', '1224.19', '1466.12', '59', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1387.99', '1228.89', '1466.12', '108', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1368.36', '1182.71', '1507.42', '5', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1310.89', '1175.54', '1481.98', '61', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1337.95', '1212.84', '1497.79', '66', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1322.36', '1189.34', '1485.65', '78', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1294.46', '1192.2', '1480.58', '50', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1292.42', '1189.79', '1480.55', '50', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1404.97', '1198.91', '1467.36', '23', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1392.75', '1202.46', '1467.36', '30', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1422.98', '1174.11', '1531.47', '101', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1431.52', '1214.13', '1526.66', '16', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1398.52', '1233.88', '1527.36', '16', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1422.37', '1227.88', '1526.66', '16', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1327.02', '1181.95', '1526.74', '56', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1429.58', '1191.57', '1527.36', '117', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1414.42', '1148.45', '1532.65', '106', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264768', '400010000', '1354.88', '1170.59', '1507.43', '11', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1324.54', '1158.5', '1526.66', '72', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1399.81', '1156.45', '1531.73', '101', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1401.14', '1140.26', '1532.63', '95', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1376.77', '1140.83', '1531.25', '88', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1358.25', '1141.31', '1526.76', '79', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1334.88', '1145.53', '1526.66', '73', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1382.83', '1230.58', '1530.94', '25', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1334.25', '1199.62', '1531.17', '63', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1377.74', '1188.36', '1536.03', '81', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1355.45', '1233.42', '1532.63', '36', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264797', '400010000', '1344.29', '1240.92', '1496.58', '69', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1357.13', '1216.83', '1531.7', '41', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266499', '400010000', '1341.79', '1225.44', '1532.66', '50', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '264716', '400010000', '1331.62', '1241.67', '1496.96', '100', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266555', '400010000', '1439.72', '1221.1', '1512.4', '13', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266555', '400010000', '1432.47', '1231.77', '1512.08', '16', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266555', '400010000', '1324.69', '1141.6', '1511.58', '71', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266555', '400010000', '1317.17', '1152.44', '1511.58', '75', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '271061', '400010000', '1458.24', '1150.35', '1511.85', '114', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1350.49', '1166.74', '1514.26', '74', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1406.69', '1206.34', '1514.26', '10', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266555', '400010000', '1440.69', '1219.88', '1512.47', '6', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '271061', '400010000', '1291.75', '1144.04', '1509.09', '53', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266558', '400010000', '1288.1', '1166.25', '1508.56', '53', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '271061', '400010000', '1309.88', '1174.35', '1511.47', '62', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266558', '400010000', '1317.21', '1208.07', '1511.32', '49', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '270096', '400010000', '1333.82', '1236.36', '1511.92', '13', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266558', '400010000', '1368.25', '1249.66', '1512.14', '6', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '271061', '400010000', '1398.38', '1259.2', '1511.8', '12', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '266558', '400010000', '1440.32', '1270.19', '1510.35', '20', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '271061', '400010000', '1399.28', '1097.44', '1516.1', '66', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('1', '271061', '400010000', '1318.7', '1110.47', '1509.3', '76', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2983.178', '2606.083', '1488.4895', '68', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2993.428', '2597.333', '1489.0841', '52', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2976.928', '2593.833', '1489.0797', '43', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2982.052', '2615.757', '1487.9949', '76', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2996.178', '2583.833', '1489.0758', '7', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2990.083', '2570.599', '1488.4167', '37', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2979.178', '2580.958', '1489.0752', '81', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '3192.807', '2681.141', '1481.0278', '88', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2815.375', '3193.375', '1470.3768', '100', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2655.944', '3070.394', '1483.1167', '77', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2812.125', '3214.875', '1471.4602', '7', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2575.8', '2887.205', '1523.323', '80', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2663.723', '3070.201', '1482.2231', '110', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2668.024', '3058.26', '1481.7909', '117', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2791.625', '3229.75', '1470.9507', '77', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2627.629', '3077.751', '1481.134', '65', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2602.053', '2790.65', '1518.5038', '91', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2804.25', '3226.0', '1471.4623', '28', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2790.125', '3216.125', '1471.4584', '73', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2643.909', '3058.524', '1482.2139', '60', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2637.399', '3072.067', '1481.6415', '62', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2797.125', '3204.875', '1471.4618', '43', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2678.68', '3053.184', '1481.1342', '40', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2659.871', '2839.686', '1524.541', '36', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2590.356', '2791.916', '1518.5037', '53', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2565.006', '2828.629', '1523.0732', '101', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2655.677', '3053.576', '1482.2169', '44', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2651.23', '3076.079', '1482.2153', '11', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2638.404', '2816.722', '1523.0818', '79', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2586.75', '2899.125', '1519.2228', '79', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2648.385', '2874.407', '1523.3228', '94', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2604.371', '2871.977', '1459.2157', '53', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2786.0', '3239.375', '1470.3767', '5', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2809.875', '3202.75', '1471.0576', '53', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2627.193', '2804.099', '1518.5646', '95', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2623.253', '2910.833', '1518.1146', '68', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2612.044', '2913.125', '1517.9325', '61', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2571.592', '2813.782', '1518.5621', '101', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2642.192', '2889.545', '1519.2229', '62', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2554.593', '2864.242', '1524.5323', '105', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '257090', '400010000', '2800.5', '3216.5', '1472.3594', '44', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270997', '400010000', '2789.212', '2586.848', '1503.7496', '97', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270997', '400010000', '2618.254', '2919.653', '1503.1815', '27', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270997', '400010000', '2601.95', '2853.598', '1499.2722', '9', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270997', '400010000', '2585.021', '2857.342', '1506.201', '36', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270997', '400010000', '2601.66', '2821.668', '1506.142', '114', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270997', '400010000', '2594.743', '2784.224', '1503.8159', '3', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270997', '400010000', '2596.508', '2791.643', '1504.5941', '112', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270997', '400010000', '2617.697', '2912.514', '1504.218', '23', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270997', '400010000', '1362.5197', '1218.1344', '1495.0896', '26', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2983.178', '2606.083', '1488.4895', '68', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2993.428', '2597.333', '1489.0841', '52', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2976.928', '2593.833', '1489.0797', '43', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2982.052', '2615.757', '1487.9949', '76', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '3206.764', '2668.062', '1479.5411', '73', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2996.178', '2583.833', '1489.0758', '7', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2990.083', '2570.599', '1488.4167', '37', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2979.178', '2580.958', '1489.0752', '81', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '3192.807', '2681.141', '1481.0278', '88', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2815.375', '3193.375', '1470.3768', '100', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2655.944', '3070.394', '1483.1167', '77', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2812.125', '3214.875', '1471.4602', '7', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2575.8', '2887.205', '1523.323', '80', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2663.723', '3070.201', '1482.2231', '110', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2668.024', '3058.26', '1481.7909', '117', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2791.625', '3229.75', '1470.9507', '77', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2627.629', '3077.751', '1481.134', '65', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2602.053', '2790.65', '1518.5038', '91', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2804.25', '3226.0', '1471.4623', '28', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2790.125', '3216.125', '1471.4584', '73', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2643.909', '3058.524', '1482.2139', '60', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2637.399', '3072.067', '1481.6415', '62', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2797.125', '3204.875', '1471.4618', '43', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2678.68', '3053.184', '1481.1342', '40', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2659.871', '2839.686', '1524.541', '36', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2590.356', '2791.916', '1518.5037', '53', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2565.006', '2828.629', '1523.0732', '101', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2655.677', '3053.576', '1482.2169', '44', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2651.23', '3076.079', '1482.2153', '11', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2638.404', '2816.722', '1523.0818', '79', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2586.75', '2899.125', '1519.2228', '79', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2648.385', '2874.407', '1523.3228', '94', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2604.371', '2871.977', '1459.2157', '53', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2786.0', '3239.375', '1470.3767', '5', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2809.875', '3202.75', '1471.0576', '53', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2627.193', '2804.099', '1518.5646', '95', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2623.253', '2910.833', '1518.1146', '68', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2612.044', '2913.125', '1517.9325', '61', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2571.592', '2813.782', '1518.5621', '101', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2642.192', '2889.545', '1519.2229', '62', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2554.593', '2864.242', '1524.5323', '105', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2800.5', '3216.5', '1472.3594', '44', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '266499', '400010000', '2789.212', '2586.848', '1503.7496', '97', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270096', '400010000', '2618.254', '2919.653', '1503.1815', '27', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270096', '400010000', '2601.95', '2853.598', '1499.2722', '9', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270096', '400010000', '2585.021', '2857.342', '1506.201', '36', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270096', '400010000', '2601.66', '2821.668', '1506.142', '114', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270096', '400010000', '2594.743', '2784.224', '1503.8159', '3', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270096', '400010000', '2596.508', '2791.643', '1504.5941', '112', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270096', '400010000', '2617.697', '2912.514', '1504.218', '23', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('2', '270096', '400010000', '1362.5197', '1218.1344', '1495.0896', '26', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2795.2', '2556.22', '1522.0659', '53', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2786.01', '2555.44', '1522.0796', '50', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2746.0', '2581.23', '1516.1166', '40', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2811.22', '2565.45', '1533.4379', '84', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2727.75', '2603.33', '1516.0526', '25', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2776.19', '2619.07', '1556.5587', '5', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2833.15', '2582.82', '1516.7633', '107', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2810.03', '2622.19', '1554.6915', '5', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2806.08', '2639.04', '1554.6915', '55', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2730.65', '2620.85', '1516.0594', '89', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2760.66', '2647.27', '1520.663', '91', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2738.04', '2665.15', '1456.7654', '99', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2727.4', '2614.99', '1516.0509', '25', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2776.54', '2659.57', '1521.7291', '56', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2759.09', '2643.63', '1461.6362', '105', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2805.54', '2611.39', '1456.6506', '100', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2809.19', '2663.72', '1512.6382', '49', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2816.81', '2625.47', '1456.3955', '55', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2826.21', '2663.04', '1512.6382', '42', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2849.37', '2614.87', '1516.0524', '30', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2825.98', '2662.88', '1512.6382', '97', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2804.25', '3226.0', '1471.4623', '65', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2815.38', '3193.38', '1470.3768', '65', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2809.88', '3202.75', '1471.0573', '75', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2791.62', '3229.75', '1470.9506', '10', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2812.12', '3214.88', '1471.4601', '86', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2800.5', '3216.5', '1472.3594', '31', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2786.0', '3239.38', '1470.3767', '6', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2554.59', '2864.24', '1524.5323', '33', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2571.59', '2813.78', '1518.5621', '116', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2565.01', '2828.63', '1523.0732', '39', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2590.36', '2791.92', '1518.5037', '78', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2602.05', '2790.65', '1518.5038', '43', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2575.8', '2887.2', '1523.323', '44', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2607.13', '2851.55', '1529.4946', '39', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2586.75', '2899.12', '1505.9313', '25', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2604.37', '2871.98', '1459.2157', '25', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2638.4', '2816.72', '1523.0815', '51', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2613.11', '2878.51', '1459.2157', '74', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2623.25', '2910.83', '1518.1158', '29', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2657.65', '2799.33', '1479.6104', '83', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2661.85', '2799.36', '1479.3792', '71', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2649.74', '2819.0', '1481.5363', '72', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2659.87', '2839.69', '1524.541', '9', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2627.19', '2804.1', '1518.5647', '5', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '257090', '400010000', '2642.19', '2889.54', '1504.0155', '18', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270997', '400010000', '2758.296', '2609.01', '1503.6855', '43', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270997', '400010000', '2729.672', '2609.277', '1502.2645', '70', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270997', '400010000', '2789.001', '2631.803', '1503.7496', '30', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270997', '400010000', '2849.807', '2609.281', '1502.216', '48', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270997', '400010000', '2838.374', '2609.346', '1502.9432', '107', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270997', '400010000', '2739.822', '2609.111', '1502.9056', '39', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '799806', '400010000', '2789.92', '2608.72', '1503.3386', '76', 'ASMODIANS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2795.2', '2556.22', '1522.0659', '53', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2786.01', '2555.44', '1522.0796', '50', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2746.0', '2581.23', '1516.1166', '40', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2811.22', '2565.45', '1533.4379', '84', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2727.75', '2603.33', '1516.0526', '25', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2776.19', '2619.07', '1556.5587', '5', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2833.15', '2582.82', '1516.7633', '107', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2810.03', '2622.19', '1554.6915', '5', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2806.08', '2639.04', '1554.6915', '55', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2730.65', '2620.85', '1516.0594', '89', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2760.66', '2647.27', '1520.663', '91', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2738.04', '2665.15', '1456.7654', '99', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2727.4', '2614.99', '1516.0509', '25', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2776.54', '2659.57', '1521.7291', '56', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2759.09', '2643.63', '1461.6362', '105', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2805.54', '2611.39', '1456.6506', '100', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2809.19', '2663.72', '1512.6382', '49', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2816.81', '2625.47', '1456.3955', '55', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2826.21', '2663.04', '1512.6382', '42', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2849.37', '2614.87', '1516.0524', '30', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2825.98', '2662.88', '1512.6382', '97', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2804.25', '3226.0', '1471.4623', '65', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2815.38', '3193.38', '1470.3768', '65', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2809.88', '3202.75', '1471.0573', '75', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2791.62', '3229.75', '1470.9506', '10', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2812.12', '3214.88', '1471.4601', '86', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2800.5', '3216.5', '1472.3594', '31', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2786.0', '3239.38', '1470.3767', '6', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2554.59', '2864.24', '1524.5323', '33', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2571.59', '2813.78', '1518.5621', '116', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2565.01', '2828.63', '1523.0732', '39', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2590.36', '2791.92', '1518.5037', '78', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2602.05', '2790.65', '1518.5038', '43', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2575.8', '2887.2', '1523.323', '44', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2607.13', '2851.55', '1529.4946', '39', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2586.75', '2899.12', '1505.9313', '25', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2604.37', '2871.98', '1459.2157', '25', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2638.4', '2816.72', '1523.0815', '51', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2613.11', '2878.51', '1459.2157', '74', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2623.25', '2910.83', '1518.1158', '29', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2657.65', '2799.33', '1479.6104', '83', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2661.85', '2799.36', '1479.3792', '71', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2649.74', '2819.0', '1481.5363', '72', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2659.87', '2839.69', '1524.541', '9', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2627.19', '2804.1', '1518.5647', '5', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '266499', '400010000', '2642.19', '2889.54', '1504.0155', '18', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270096', '400010000', '2758.296', '2609.01', '1503.6855', '43', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270096', '400010000', '2729.672', '2609.277', '1502.2645', '70', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270096', '400010000', '2789.001', '2631.803', '1503.7496', '30', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270096', '400010000', '2849.807', '2609.281', '1502.216', '48', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270096', '400010000', '2838.374', '2609.346', '1502.9432', '107', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '270096', '400010000', '2739.822', '2609.111', '1502.9056', '39', 'ELYOS'); +INSERT INTO `fortress_spawn_template` VALUES ('3', '799806', '400010000', '2789.92', '2608.72', '1503.3386', '76', 'ELYOS');

Развернуть ↓

Куда его сувать!?
обьясните!
и 2) Как запустить осаду либо изменить время запуска?