Monster spawns refrains AIServer from loading.

[UTengine]

First I run the following script because these make it crash.
SELECT * FROM K_NPCPOS WHERE (zone = 1 AND NpcID IN (351, 1154)) OR (zone = 2 AND NpcID IN (950, 1053));

Then we copy the results into our K_NPCPOS.
CSV file:

1,1154,1,0,0,0,0,1648,1334,1686,1307,1356,1635,1687,1300,5,20,0,NULL
1,1154,1,0,0,0,0,684,1136,722,1109,1158,671,723,1102,5,20,0,NULL
1,1154,1,0,0,0,0,1430,1786,1468,1759,1808,1417,1469,1752,5,20,0,NULL
1,1154,1,0,0,0,0,1703,1318,1741,1291,1340,1690,1742,1284,5,20,0,NULL
1,1154,1,0,0,0,0,721,609,759,582,631,708,760,575,5,20,0,NULL
1,1154,1,0,0,0,0,190,514,228,487,536,177,229,480,5,20,0,NULL
1,1154,1,0,0,0,0,698,1158,736,1131,1180,685,737,1124,5,20,0,NULL
1,1154,1,0,0,0,0,744,110,782,83,132,731,783,76,5,20,0,NULL
1,1154,1,0,0,0,0,1592,1845,1630,1818,1867,1579,1631,1811,5,20,0,NULL
1,1154,1,0,0,0,0,812,516,850,489,538,799,851,482,5,20,0,NULL
1,1154,1,0,0,0,0,170,1437,208,1410,1459,157,209,1403,5,20,0,NULL
1,1154,1,0,0,0,0,1683,1278,1721,1251,1300,1670,1722,1244,5,20,0,NULL
1,1154,1,0,0,0,0,1602,1880,1640,1853,1902,1589,1641,1846,5,20,0,NULL
1,1154,1,0,0,0,0,933,1528,971,1501,1550,920,972,1494,5,20,0,NULL
1,1154,1,0,0,0,0,827,738,865,711,760,814,866,704,5,20,0,NULL
1,1154,1,0,0,0,0,1239,881,1277,854,903,1226,1278,847,5,20,0,NULL
1,1154,1,0,0,0,0,1739,113,1777,86,135,1726,1778,79,5,20,0,NULL
1,1154,1,0,0,0,0,641,1232,679,1205,1254,628,680,1198,5,20,0,NULL
1,1154,1,0,0,0,0,1394,1756,1432,1729,1778,1381,1433,1722,5,20,0,NULL
1,1154,1,0,0,0,0,1669,96,1707,69,118,1656,1708,62,5,20,0,NULL
1,351,1,0,0,0,0,416,1330,446,1310,1344,410,446,1300,5,15,0,NULL
1,351,1,0,0,0,0,1416,743,1446,723,757,1410,1446,713,5,15,0,NULL
1,351,1,0,0,0,0,1563,586,1593,566,600,1557,1593,556,5,15,0,NULL
1,351,1,0,0,0,0,1453,1369,1483,1349,1383,1447,1483,1339,5,15,0,NULL
1,351,1,0,0,0,0,383,1238,413,1218,1252,377,413,1208,5,15,0,NULL
2,950,1,0,0,0,0,853,473,891,446,495,840,892,439,5,15,0,NULL
2,950,1,0,0,0,0,321,633,359,606,655,308,360,599,5,15,0,NULL
2,950,1,0,0,0,0,1026,780,1064,753,802,1013,1065,746,5,15,0,NULL
2,950,1,0,0,0,0,1113,1606,1151,1579,1628,1100,1152,1572,5,15,0,NULL
2,950,1,0,0,0,0,216,637,254,610,659,203,255,603,5,15,0,NULL
2,950,1,0,0,0,0,218,559,256,532,581,205,257,525,10,15,0,NULL
2,950,1,0,0,0,0,1223,341,1261,314,363,1210,1262,307,10,15,0,NULL
2,950,1,0,0,0,0,1059,1663,1097,1636,1685,1046,1098,1629,5,15,0,NULL
2,950,1,0,0,0,0,318,1141,356,1114,1163,305,357,1107,5,15,0,NULL
2,1053,1,0,0,0,0,1183,573,1221,546,595,1170,1222,539,5,15,0,NULL
2,1053,1,0,0,0,0,854,1810,892,1783,1832,841,893,1776,10,15,0,NULL
2,1053,1,0,0,0,0,891,1068,929,1041,1090,878,930,1034,5,15,0,NULL
2,1053,1,0,0,0,0,1702,1722,1740,1695,1744,1689,1741,1688,5,15,0,NULL
2,1053,1,0,0,0,0,621,529,659,502,551,608,660,495,5,15,0,NULL
2,1053,1,0,0,0,0,1365,1479,1403,1452,1501,1352,1404,1445,5,15,0,NULL
2,1053,1,0,0,0,0,623,984,661,957,1006,610,662,950,5,15,0,NULL
2,1053,1,0,0,0,0,1079,375,1117,348,397,1066,1118,341,5,15,0,NULL
2,1053,1,0,0,0,0,1191,368,1229,341,390,1178,1230,334,5,15,0,NULL

raw SQL Copy:

1	1154	1	0	0	0	0	1648	1334	1686	1307	1356	1635	1687	1300	5	20	0	NULL
1	1154	1	0	0	0	0	684	1136	722	1109	1158	671	723	1102	5	20	0	NULL
1	1154	1	0	0	0	0	1430	1786	1468	1759	1808	1417	1469	1752	5	20	0	NULL
1	1154	1	0	0	0	0	1703	1318	1741	1291	1340	1690	1742	1284	5	20	0	NULL
1	1154	1	0	0	0	0	721	609	759	582	631	708	760	575	5	20	0	NULL
1	1154	1	0	0	0	0	190	514	228	487	536	177	229	480	5	20	0	NULL
1	1154	1	0	0	0	0	698	1158	736	1131	1180	685	737	1124	5	20	0	NULL
1	1154	1	0	0	0	0	744	110	782	83	132	731	783	76	5	20	0	NULL
1	1154	1	0	0	0	0	1592	1845	1630	1818	1867	1579	1631	1811	5	20	0	NULL
1	1154	1	0	0	0	0	812	516	850	489	538	799	851	482	5	20	0	NULL
1	1154	1	0	0	0	0	170	1437	208	1410	1459	157	209	1403	5	20	0	NULL
1	1154	1	0	0	0	0	1683	1278	1721	1251	1300	1670	1722	1244	5	20	0	NULL
1	1154	1	0	0	0	0	1602	1880	1640	1853	1902	1589	1641	1846	5	20	0	NULL
1	1154	1	0	0	0	0	933	1528	971	1501	1550	920	972	1494	5	20	0	NULL
1	1154	1	0	0	0	0	827	738	865	711	760	814	866	704	5	20	0	NULL
1	1154	1	0	0	0	0	1239	881	1277	854	903	1226	1278	847	5	20	0	NULL
1	1154	1	0	0	0	0	1739	113	1777	86	135	1726	1778	79	5	20	0	NULL
1	1154	1	0	0	0	0	641	1232	679	1205	1254	628	680	1198	5	20	0	NULL
1	1154	1	0	0	0	0	1394	1756	1432	1729	1778	1381	1433	1722	5	20	0	NULL
1	1154	1	0	0	0	0	1669	96	1707	69	118	1656	1708	62	5	20	0	NULL
1	351	1	0	0	0	0	416	1330	446	1310	1344	410	446	1300	5	15	0	NULL
1	351	1	0	0	0	0	1416	743	1446	723	757	1410	1446	713	5	15	0	NULL
1	351	1	0	0	0	0	1563	586	1593	566	600	1557	1593	556	5	15	0	NULL
1	351	1	0	0	0	0	1453	1369	1483	1349	1383	1447	1483	1339	5	15	0	NULL
1	351	1	0	0	0	0	383	1238	413	1218	1252	377	413	1208	5	15	0	NULL
2	950	1	0	0	0	0	853	473	891	446	495	840	892	439	5	15	0	NULL
2	950	1	0	0	0	0	321	633	359	606	655	308	360	599	5	15	0	NULL
2	950	1	0	0	0	0	1026	780	1064	753	802	1013	1065	746	5	15	0	NULL
2	950	1	0	0	0	0	1113	1606	1151	1579	1628	1100	1152	1572	5	15	0	NULL
2	950	1	0	0	0	0	216	637	254	610	659	203	255	603	5	15	0	NULL
2	950	1	0	0	0	0	218	559	256	532	581	205	257	525	10	15	0	NULL
2	950	1	0	0	0	0	1223	341	1261	314	363	1210	1262	307	10	15	0	NULL
2	950	1	0	0	0	0	1059	1663	1097	1636	1685	1046	1098	1629	5	15	0	NULL
2	950	1	0	0	0	0	318	1141	356	1114	1163	305	357	1107	5	15	0	NULL
2	1053	1	0	0	0	0	1183	573	1221	546	595	1170	1222	539	5	15	0	NULL
2	1053	1	0	0	0	0	854	1810	892	1783	1832	841	893	1776	10	15	0	NULL
2	1053	1	0	0	0	0	891	1068	929	1041	1090	878	930	1034	5	15	0	NULL
2	1053	1	0	0	0	0	1702	1722	1740	1695	1744	1689	1741	1688	5	15	0	NULL
2	1053	1	0	0	0	0	621	529	659	502	551	608	660	495	5	15	0	NULL
2	1053	1	0	0	0	0	1365	1479	1403	1452	1501	1352	1404	1445	5	15	0	NULL
2	1053	1	0	0	0	0	623	984	661	957	1006	610	662	950	5	15	0	NULL
2	1053	1	0	0	0	0	1079	375	1117	348	397	1066	1118	341	5	15	0	NULL
2	1053	1	0	0	0	0	1191	368	1229	341	390	1178	1230	334	5	15	0	NULL

Then we launch AIServer you will notice that monster all init success isnt showing

If we launch ebenezer it will say failed to connect to AIServer
Furthermore we observe the following in the trace debug output:

C:\GitHub\ko4life\ko\src\server\AIServer\Npc.cpp(966) : atlTraceGeneral - ### fail : sid = 950, nid = 12090, zone=2, loop = 500 나 설ìž�리가 ì�´ìƒ�í•´... ê³ ì³�줘... x = 1249, y = 336
C:\GitHub\ko4life\ko\src\server\AIServer\Npc.cpp(966) : atlTraceGeneral - ### fail : sid = 950, nid = 12091, zone=2, loop = 500 나 설ìž�리가 ì�´ìƒ�í•´... ê³ ì³�줘... x = 1241, y = 316
C:\GitHub\ko4life\ko\src\server\AIServer\Npc.cpp(966) : atlTraceGeneral - ### fail : sid = 950, nid = 12092, zone=2, loop = 500 나 설ìž�리가 ì�´ìƒ�í•´... ê³ ì³�줘... x = 1246, y = 338
C:\GitHub\ko4life\ko\src\server\AIServer\Npc.cpp(966) : atlTraceGeneral - ### fail : sid = 950, nid = 12093, zone=2, loop = 500 나 설ìž�리가 ì�´ìƒ�í•´... ê³ ì³�줘... x = 1257, y = 339

These are the steps to reproduce
The following is the fix:
https://github.com/ko4life-net/ko/files/12185114/servermapsv2.zip
We replace the smd's we rename them accordingly in zone_info database

1	1	karus_1212.smd	37120	157300	38500	1	1
1	2	elmorad_1212.smd	163700	41800	38500	1	2
1	21	moradon_1021.smd	31200	40200	0	2	21

and then we update the ebenezer gamedefine source to contain sNation:

ko/src/server/Ebenezer/GameDefine.h

Line 546 in f7b210b

short sNation;

Now we have working smd's and spawns and translated warp entries that fully work:

If we want to fix moradon 1264 client file or any moradon to warp out back we replace the following:
We replace this BYTE with a SHORT (credits openko)

ko/src/game/GameProcMain.cpp

Line 4176 in f7b210b

CAPISocket::MP_AddShort(byBuff, iOffset, WI.iID); // 워프 아이디 보내기...

The result: