¸Á°í½º ´Ü°èº° ¼³Ä¡¹æ¹ý
ascent / mangos :: ascent :: ¼¹ö ¼³Ä¡
ÆäÀÌÁö 1 Áß 1
¸Á°í½º ´Ü°èº° ¼³Ä¡¹æ¹ý
¼³¸í¼ÀÇ »ç¿ëµÈ ¹öÀüÀº ¾Æ·¡¿Í °°½À´Ï´Ù.
MaNGOS rev.6471
ScripDev2 rev.586
UDB rev.359
NCDB rev.3
1. SVNÀ¸·Î ´Ù¿î¹ÞÀº ¼Ò½º °æ·Î´Â ¾Æ·¡¿Í °°½À´Ï´Ù.
MaNGOS : E:\MaNGOS_SRC
ScriptDev2 : E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2
NCDB : E:\NCDB
UDB : E:\UDB
RWAPM À¥°æ·Î : E:\RWAPM\www
°¢ SVN ¼Ò½º ´Ù¿î·Îµå Á¤º¸´Â MaNGOS°Ô½ÃÆÇ¿¡ SVN Information ¿¡ ÀÖ½À´Ï´Ù.
## ¸Á°í½º ¼Ò½º ÄÄÆÄÀÏ ´Ü°èÀÔ´Ï´Ù.
2. ¸ÕÀú ÄÄÆÄÀÏÀü¿¡ ¾Æ·¡ 4°³ÀÇ ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±âÇÏ¿© (UTF8)À¸·Î ÀÎÄÚµùÇÏ¿© ÀúÀåÇÕ´Ï´Ù.
E:\MaNGOS_SRC\trunk\dep\include\g3dlite\G3D\Matrix3.h
E:\MaNGOS_SRC\trunk\src\game\ObjectMgr.h
E:\MaNGOS_SRC\trunk\src\game\GameObject.cpp
E:\MaNGOS_SRC\trunk\src\game\SpellEffects.cpp
3. ¸Á°í½º ¼Ò½º¸¦ ÄÄÆÄÀÏÇϱâÀ§ÇØ E:\MaNGOS_SRC\trunk\win\mangosdVC90.sln À» ½ÇÇàÇÕ´Ï´Ù.
4. Visual C++ 2008 ¿¡¼ ¼Ö·ç¼Ç±¸¼ºÇ׸ñÀ» ' Release ' ·Î ¼±ÅÃÇÕ´Ï´Ù.
5. ¸Þ´º¿¡¼ ºôµå > ¼Ö·ç¼Ç ºôµå ¸¦ Ŭ¸¯ÇÏ¿© ÄÄÆÄÀÏ ÇÕ´Ï´Ù.
´ÙÀ½Àº MaNGOS rev.6471 ÃÖÁ¾ ºôµå °á°úÀÔ´Ï´Ù.
========== ºôµå: ¼º°ø 11, ½ÇÆÐ 0, ÃֽŠ0, »ý·« 0 ==========
6. MaNGOS ¼Ò½º ÄÄÆÄÀÏÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù. VC âÀ» Á¾·áÇÕ´Ï´Ù.
7. ´ÙÀ½Àº ½ºÅ©¸³Æ® ¼Ò½º¸¦ ÄÄÆÄÀÏÇϱâÀ§ÇØ E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\scriptVC90.sln À» ½ÇÇàÇÕ´Ï´Ù.
8. ¸¶Âù°¡Áö·Î Visual C++ 2008 ¿¡¼ ¼Ö·ç¼Ç±¸¼ºÇ׸ñÀ» ' Release ' ·Î ¼±ÅÃÇÑÈÄ, ¸Þ´º¿¡¼ ºôµå > ¼Ö·ç¼Ç ºôµå ¸¦ Ŭ¸¯ÇÏ¿© ÄÄÆÄÀÏ ÇÕ´Ï´Ù.
´ÙÀ½Àº ScriptDev2 rev.586 ÃÖÁ¾ ºôµå °á°úÀÔ´Ï´Ù.
========== ºôµå: ¼º°ø 2, ½ÇÆÐ 0, ÃֽŠ0, »ý·« 0 ==========
9. ScriptDev2 ½ºÅ©¸³Æ® ÄÄÆÄÀÏÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù. VC âÀ» Á¾·áÇÕ´Ï´Ù.
10. E:\MaNGOS_SRC\trunk\bin\Win32_Release Æú´õ¾ÈÀÇ ¾Æ·¡ ÆÄÀÏÀ» E:\MaNGOS Æú´õ¾ÈÀ¸·Î º¹»çÇÕ´Ï´Ù.
mangosd.exe , realmd.exe , dbghelp.dll , libeay32.dll , libmySQL.dll , MaNGOSScript.dll
11. E:\MaNGOS_SRC\trunk\src\mangosd\mangosd.conf.in ÆÄÀÏÀ» E:\MaNGOS Æú´õ¾ÈÀ¸·Î º¹»çÇÑÈÄ, ' mangosd.conf ' À¸·Î À̸§¹Ù²Ù±âÇÕ´Ï´Ù.
12. E:\MaNGOS_SRC\trunk\src\realmd\realmd.conf.in ÆÄÀÏÀ» E:\MaNGOS Æú´õ¾ÈÀ¸·Î º¹»çÇÑÈÄ, ' realmd.conf ' À¸·Î À̸§¹Ù²Ù±âÇÕ´Ï´Ù.
13. E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\scriptdev2.conf ÆÄÀÏÀ» E:\MaNGOS Æú´õ¾ÈÀ¸·Î º¹»çÇÕ´Ï´Ù.
## ´ÙÀ½Àº ȯ°æ¼³Á¤ ´Ü°èÀÔ´Ï´Ù.
14. E:\MaNGOS\mangosd.conf ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±â ÇÕ´Ï´Ù.
15. 48-50¹ø° ¶óÀÎÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÑÈÄ ÀúÀåÇÕ´Ï´Ù
LoginDatabaseInfo = "127.0.0.1;3306;root;7777;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;7777;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;7777;characters"
16. E:\MaNGOS\realmd.conf ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±â ÇÕ´Ï´Ù.
17. 99¹ø° ¶óÀÎÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÑÈÄ ÀúÀåÇÕ´Ï´Ù
LoginDatabaseInfo = "127.0.0.1;3306;root;7777;realmd"
18. E:\MaNGOS\scriptdev2.conf ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±â ÇÕ´Ï´Ù.
19. 11¹ø° ¶óÀÎÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÑÈÄ ÀúÀåÇÕ´Ï´Ù
ScriptDev2DatabaseInfo = "127.0.0.1;3306;root;7777;scriptdev2"
## ´ÙÀ½Àº DB ¸¦ ¼³Ä¡ÇÒ Â÷·ÊÀÔ´Ï´Ù.
## UDB ¼³Ä¡¹æ¹ý
[ÆÄÀϼ³¸í]
UDB_0.10.3_Core_6240_SD2_473.rar
0.10.3 : UDB ¹öÀüÀÌ 0.10.3 ÀÓÀ» ÀǹÌÇÕ´Ï´Ù.
Core_6240 : MaNOGS ¼Ò½º¹öÀüÀÌ 6240 º¸´Ù »óÀ§¹öÀü¿¡¼ »ç¿ëÇÒ ¼ö ÀÖÀ½À» ÀǹÌÇÕ´Ï´Ù.
SD2_473 : ¸Á°í½º ½ºÅ©¸³Æ®ÀÎ ScriptDev2 ¹öÀüÀÌ 473 º¸´Ù »óÀ§¹öÀü¿¡¼ »ç¿ëÇÒ ¼ö ÀÖÀ½À» ÀǹÌÇÕ´Ï´Ù.
[UDB ¾÷µ¥ÀÌÆ® ¼³¸í]
UDB´Â ' E:\UDB\trunk\Updates\0.10.3_additions ' Æú´õ¾È¿¡ corepatch ÆÄÀÏÀÌ ÀÖÀ¸¸é ³·Àº¹øÈ£¿¡¼ ³ôÀº¹øÈ£ ¼ø¼´ë·Î ¾÷µ¥ÀÌÆ®ÇØ¾ß ÇÕ´Ï´Ù.
[ÆÄÀϼ³¸í]
358_corepatch_mangos_6241_to_6346.sql
358_corepatch : 358 ´Â ÆÐÄ¡¹øÈ£(³·Àº¹øÈ£¿¡¼ ³ôÀº¹øÈ£ ¼ø¼´ë·Î ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù)
mangos_6241_to_6346 : MaNGOS ¼Ò½º¹öÀüÀÌ 6241-6346±îÁö Àû¿ëµÈÆÄÀÏ·Î mangos DB¿¡ ¾÷µ¥ÀÌÆ® ÇÕ´Ï´Ù.
realmd_6347_to_6439 : MaNGOS ¼Ò½º¹öÀüÀÌ 6347-6439±îÁö Àû¿ëµÈÆÄÀÏ·Î realmd DB¿¡ ¾÷µ¥ÀÌÆ® ÇÕ´Ï´Ù.
20. E:\UDB\trunk\Full_DB Æú´õ¾ÈÀÇ UDB_0.10.3_Core_6240_SD2_473.rar À» ¾ËÁýÀ» ÀÌ¿ëÇÏ¿© ' ÇöÀçÆú´õ¿¡ ¾ÐÃàÇ®±â 'ÇÕ´Ï´Ù.
21. SQLyog¸¦ ½ÇÇàÇÕ´Ï´Ù. user name = root , password = 7777 Á¢¼ÓÇÕ´Ï´Ù.
22. ¾Æ·¡ Äõ¸®¹® 4°³¸¦ ¿ìÃøÀÇ Query â¿¡ º¹»çÇÏ¿© ºÙ¿©³Ö±â ÇÕ´Ï´Ù.
CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
23. ¸Þ´º¿¡¼ Edit > Execute Query > Execute All Queries ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
24. ¸Þ´º¿¡¼ Edit > Refresh Object Browser ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
25. ¿ÞÂÊÆгÎÀÇ ' mangos ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
26. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, À§¿¡¼ ¾ÐÃàÇØÁ¦ÇÑ E:\UDB\trunk\Full_DB Æú´õ¾ÈÀÇ ' UDB_0.10.3_Core_6240_SD2_473.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
27. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© mangos DB¿¡ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
28. ´Ù½Ã ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\UDB\trunk\Updates\0.10.3_additions Æú´õ¾È¿¡¼ corepatch_mangos ¶ó´Â ÆÄÀÏÀÌ ÀÖ´Ù¸é ³·Àº¹øÈ£¿¡¼ ³ôÀº¹øÈ£ ¼ø¼´ë·Î ¾÷µ¥ÀÌÆ®ÇØ¾ß ÇÕ´Ï´Ù.
ÇöÀç 358_corepatch_mangos_6241_to_6346.sql , 358_corepatch_mangos.sql , 359_corepatch_mangos_6347_to_6439.sql , 359_corepatch_mangos.sql µî 4°³ÀÇ ÆÄÀÏÀÌ ÀÖ½À´Ï´Ù.
29. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© 4°³ÀÇ ÆÄÀÏÀ» ¼ø¼´ë·Î mangos DB¸¦ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
** Ãß°¡µÈ ÆÄÀÏÀÌ ÀÖ´Ù¸é ¸ðµÎ ¹øÈ£ ¼ø¼´ë·Î ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
** Âü°í·Î, corepatch_characters ÆÄÀÏ°ú corepatch_realmd ÆÄÀÏÀº ¼³Ä¡¾ÈÇصµ µË´Ï´Ù. MaNGOS ¼Ò½º ÃֽŹöÀü¿¡ ÃÖÀûÈµÈ characters°ú realmd DB ÆÄÀÏÀ» E:\MaNGOS_SRC\trunk\sql ¿¡¼ ¾÷µ¥ÀÌÆ®Çϱ⠶§¹®ÀÔ´Ï´Ù.
** ¸¶Áö¸· ÄÚ¾îÆÐÄ¡ ÆÄÀÏ ' 359_corepatch_mangos_6347_to_6439.sql 'Àº MaNGOS ¼Ò½º ¹öÀüÀÌ 6439 ±îÁö Àû¿ëµÈ ÆÄÀÏÀÔ´Ï´Ù.
30. µû¶ó¼ E:\MaNGOS_SRC\trunk\sql\updates Æú´õ¾ÈÀÇ ' 6439 ' º¸´Ù ³ôÀº¹øÈ£ÀÇ ÆÄÀÏ(xxxx_mangos...sql)ÀÌ ÀÖ´Ù¸é ¼ø¼´ë·Î mangos DB¿¡ ¾÷µ¥ÀÌÆ® ÇÕ´Ï´Ù.
** Âü°í·Î ÆÄÀÏÀ̸§Áß¿¡ xxxx_realmd...sql ÆÄÀÏÀÌ ÀÖ´Ù¸é realms DB¿¡ ¾÷µ¥ÀÌÆ®ÇÏ´Â ÆÄÀÏÀÔ´Ï´Ù. Áö±ÝÀº xxxx_realmd...sql ÆÄÀÏÀº ¾÷µ¥ÀÌÆ®ÇÏÁö ¾Ê½À´Ï´Ù.
¸ðµç UDB, MaNGOS ¼Ò½º DB¾÷µ¥ÀÌÆ®¸¦ ¸¶ÃÆ´Ù¸é ½ºÅ©¸³Æ® DB¸¦ mangos DB¿¡ ¾÷µ¥ÀÌÆ®ÇØ¾ß ÇÕ´Ï´Ù.
31. ´Ù½Ã ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\sql Æú´õ¾ÈÀÇ ' mangos_full_scripts.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
32. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© mangos_full_scripts.sql¸¦ mangos DB¿¡ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
33. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© mangos DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
34. ¿ÞÂÊÆгÎÀÇ ' scriptdev2 ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
35. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\sql Æú´õ¾ÈÀÇ ' scriptdev2_structure.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
36. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© scriptdev2_structure.sql¸¦ scriptdev2 DB¿¡ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
37. ¿ÞÂÊÆгÎÀÇ ' realmd ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
38. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\sql Æú´õ¾ÈÀÇ ' realmd.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
39. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© realmd DB¸¦ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
40. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© realmd DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
41. ¿ÞÂÊÆгÎÀÇ ' characters ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
42. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\sql Æú´õ¾ÈÀÇ ' characters.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
43. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© characters DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
44. ¸ðµç DB ¾÷µ¥ÀÌÆ®¸¦ ¸¶ÃƽÀ´Ï´Ù. SQLyogâÀ» Á¾·áÇÕ´Ï´Ù.
## ´ÙÀ½Àº ¸ÊÆÄÀÏ°ú DBC¸¦ ÃßÃâÇÏ´Â ´Ü°èÀÔ´Ï´Ù.
45. E:\MaNGOS_SRC\trunk\contrib\extractor\ad.exe ÆÄÀÏÀ» ¿Í¿ì Ŭ¶ó(World of Warcraft) Æú´õ¾ÈÀ¸·Î º¹»çÇÕ´Ï´Ù.
46. ad.exe ¸¦ ½ÇÇàÇÏ¿© ¸Ê°ú dbc ÆÄÀÏÀ» ÃßÃâÇÕ´Ï´Ù. ½Ã½ºÅÛÀÇ ±âÁ¾ÀÇ µû¶ó 30ºÐÀÌ»óÀÇ ½Ã°£ÀÌ ¼Ò¿äµË´Ï´Ù.
47. ÃßÃâÀÌ ¿Ï·áµÇ¸é ¿Í¿ì Ŭ¶ó(World of Warcraft)¾ÈÀÇ dbc , maps Æú´õ¸¦ E:\MaNGOS Æú´õ¾ÈÀ¸·Î º¹»ç ¶Ç´Â À̵¿ÇÕ´Ï´Ù.
## ¼¹ö ½ÇÇà ´Ü°èÀÔ´Ï´Ù.
48. E:\MaNGOS Æú´õ¾ÈÀÇ realmd.exe ¿Í mangosd.exeÀ» ½ÇÇàÇÕ´Ï´Ù.
49. º¸¾È°æ°í âÀÌ ¶ß¸é Â÷´ÜÇØÁ¦¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
50. °èÁ¤»ý¼ºÀº mangos.exe âÀÇ mangos> ¿¡¼ ' create USERID PASSWORD ' ¸¦ ÀÔ·ÂÇÏ¸é µË´Ï´Ù.
** À¥°èÁ¤ »ý¼ºÆäÀÌÁö´Â µ¿¿µ»ó ¼³Ä¡¹æ¹ýÀ» Âü°íÇϼ¼¿ä.
## [Âü°í] NCDB ¼³Ä¡¹æ¹ý
1. SQLyog ¸¦ ½ÇÇàÇÕ´Ï´Ù.
2. user name = root , password = 7777 Á¢¼ÓÇÕ´Ï´Ù.
3. ¾Æ·¡ Äõ¸®¹® 5°³¸¦ ¿ìÃøÀÇ Query â¿¡ º¹»çÇÏ¿© ºÙ¿©³Ö±â ÇÕ´Ï´Ù.
CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `ncdb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
4. ¸Þ´º¿¡¼ Edit > Execute Query > Execute All Queries ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
5. Sqlyog ¸¦ Á¾·áÇÕ´Ï´Ù.
6. E:\NCDB\trunk\sql\win-install.bat ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±â ÇÕ´Ï´Ù.
7. 13-15¹ø° ¶óÀÎÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÑÈÄ ÀúÀåÇÕ´Ï´Ù
set user=root
set pass=7777
set wdb=ncdb
8. ¼öÁ¤µÈ E:\NCDB\trunk\sql\win-install.bat ÆÄÀÏÀ» ½ÇÇàÇÕ´Ï´Ù.
9. ¸ÞÀΠȸ鿡¼ i Å°¸¦ ´·¯ DB ¾÷µ¥ÀÌÆ® ÇÕ´Ï´Ù.
10. Finished ¸Þ¼¼Áö°¡ ³ª¿À¸é ¾Æ¹«Å°³ª ´©¸¥ÈÄ x Å°¸¦ ´·¯ âÀ» Á¾·áÇÕ´Ï´Ù.
11. E:\NCDB\trunk Æú´õ¾ÈÀÇ ' web installer ' Æú´õ¸¦ º¹»çÇÏ¿©, À¥Æú´õ ' E:\RWAPM\www ' Æú´õ¾È¿¡ ºÙ¿©³Ö±âÇÕ´Ï´Ù.
12. E:\RWAPM\www\web installer\include\config.inc.php ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±â ÇÕ´Ï´Ù.
13. 3-12¹ø° ¶óÀÎÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÑÈÄ ÀúÀåÇÕ´Ï´Ù
// Base Database
$dbhost = "localhost"; // Base Table host
$dbuname = "root"; // Base Table login
$dbupass = "7777"; // Base Table login password
$dbname = "ncdb"; // Base table name
// Destination Database
$dbhost_destination="localhost"; // Destination Table host
$dbuname_destination="root"; // Destination Table login
$dbupass_destination="7777"; // Destination Table login password
$dbname_destination="mangos"; // Destination Table name
14. À¥ºê¶ó¿ìÀú ÁÖ¼Òâ¿¡ http://localhost/web installer/ À» ÀÔ·ÂÇÏ¿© NCDB À¥¼³Ä¡¸¦ ÁøÇàÇÕ´Ï´Ù.
15. Mangos 6456 and newer. À» Ŭ¸¯ÇÕ´Ï´Ù.
MaNGOS ¼Ò½º ¹öÀüÀÌ ' 6465 'º¸´Ù »óÀ§¹öÀü¿¡¼ »ç¿ëÇÒ ¼ö ÀÖÀ½À» ÀǹÌÇÕ´Ï´Ù.
16. 'Start converting ' ¹öÆ°À» Ŭ¸¯ÇÏ¿© NCDB¸¦ MaNGOS DB·Î ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
½Ã½ºÅÛ È¯°æ¿¡µû¶ó 10¿©ºÐÀÇ ½Ã°£ÀÌ ¼Ò¿äµË´Ï´Ù.
[ÁÖÀÇ] Àý´ë·Î âÀ» Á¾·áÇϰųª ÆäÀÌÁö¸¦ À̵¿ÇÏÁö ¸¶¼¼¿ä.
À¥ºê¶ó¿ìÀú ÁÖ¼Òâ¿¡ http://localhost/web installer/mangos/finished.php ¶ó°í º¸À̸é NCDB À¥¼³Ä¡°¡ ³¡³°ÍÀÔ´Ï´Ù.
## DB ¾÷µ¥ÀÌÆ® ´Ü°èÀÔ´Ï´Ù.
17. SQLyog¸¦ ½ÇÇàÇÕ´Ï´Ù. user name = root , password = 7777 Á¢¼ÓÇÕ´Ï´Ù.
18. ¿ÞÂÊÆгÎÀÇ ' mangos ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
19. Execute Query(s) From A File â¿¡¼ ã¾Æº¸±â(...)¹öÆ°À» Ŭ¸¯ÇÕ´Ï´Ù.
20. E:\MaNGOS_SRC\trunk\sql\updates Æú´õ¾È¿¡¼ NCDBÀÇ ¸Á°í½º Áö¿ø¹öÀüÀÎ 6465 º¸´Ù ³ôÀº ÆÄÀÏÀÌ ÀÖÀ¸¸é ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
21. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© MaNGOS DB¸¦ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
ÇöÀç MaNGOS rev.6471¿¡¼´Â 6465º¸´Ù ³ôÀº ÆÄÀÏÀÌ ¾ø±â¶§¹®¿¡ âÀ» Á¾·áÇÏ¿´½À´Ï´Ù.
22. ¿ÞÂÊÆгÎÀÇ ' mangos ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
23. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\sql Æú´õ¾ÈÀÇ ' mangos_full_scripts.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
24. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© mangos_full_scripts.sql¸¦ MaNGOS DB¿¡ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
25. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© mangos DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
26. ¿ÞÂÊÆгÎÀÇ ' scriptdev2 ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
27. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\sql Æú´õ¾ÈÀÇ ' scriptdev2_structure.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
28. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© scriptdev2_structure.sql¸¦ scriptdev2 DB¿¡ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
29. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© scriptdev2 DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
30. ¿ÞÂÊÆгÎÀÇ ' realmd ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
31. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\sql Æú´õ¾ÈÀÇ ' realmd.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
32. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© realmd DB¸¦ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
33. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© realmd DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
34. ¿ÞÂÊÆгÎÀÇ ' characters ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
35. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\sql Æú´õ¾ÈÀÇ ' characters.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
36. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© characters DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
37. ¸ðµç DB ¾÷µ¥ÀÌÆ®¸¦ ¸¶ÃƽÀ´Ï´Ù. SQLyogâÀ» Á¾·áÇÕ´Ï´Ù.
MaNGOS rev.6471
ScripDev2 rev.586
UDB rev.359
NCDB rev.3
1. SVNÀ¸·Î ´Ù¿î¹ÞÀº ¼Ò½º °æ·Î´Â ¾Æ·¡¿Í °°½À´Ï´Ù.
MaNGOS : E:\MaNGOS_SRC
ScriptDev2 : E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2
NCDB : E:\NCDB
UDB : E:\UDB
RWAPM À¥°æ·Î : E:\RWAPM\www
°¢ SVN ¼Ò½º ´Ù¿î·Îµå Á¤º¸´Â MaNGOS°Ô½ÃÆÇ¿¡ SVN Information ¿¡ ÀÖ½À´Ï´Ù.
## ¸Á°í½º ¼Ò½º ÄÄÆÄÀÏ ´Ü°èÀÔ´Ï´Ù.
2. ¸ÕÀú ÄÄÆÄÀÏÀü¿¡ ¾Æ·¡ 4°³ÀÇ ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±âÇÏ¿© (UTF8)À¸·Î ÀÎÄÚµùÇÏ¿© ÀúÀåÇÕ´Ï´Ù.
E:\MaNGOS_SRC\trunk\dep\include\g3dlite\G3D\Matrix3.h
E:\MaNGOS_SRC\trunk\src\game\ObjectMgr.h
E:\MaNGOS_SRC\trunk\src\game\GameObject.cpp
E:\MaNGOS_SRC\trunk\src\game\SpellEffects.cpp
3. ¸Á°í½º ¼Ò½º¸¦ ÄÄÆÄÀÏÇϱâÀ§ÇØ E:\MaNGOS_SRC\trunk\win\mangosdVC90.sln À» ½ÇÇàÇÕ´Ï´Ù.
4. Visual C++ 2008 ¿¡¼ ¼Ö·ç¼Ç±¸¼ºÇ׸ñÀ» ' Release ' ·Î ¼±ÅÃÇÕ´Ï´Ù.
5. ¸Þ´º¿¡¼ ºôµå > ¼Ö·ç¼Ç ºôµå ¸¦ Ŭ¸¯ÇÏ¿© ÄÄÆÄÀÏ ÇÕ´Ï´Ù.
´ÙÀ½Àº MaNGOS rev.6471 ÃÖÁ¾ ºôµå °á°úÀÔ´Ï´Ù.
========== ºôµå: ¼º°ø 11, ½ÇÆÐ 0, ÃֽŠ0, »ý·« 0 ==========
6. MaNGOS ¼Ò½º ÄÄÆÄÀÏÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù. VC âÀ» Á¾·áÇÕ´Ï´Ù.
7. ´ÙÀ½Àº ½ºÅ©¸³Æ® ¼Ò½º¸¦ ÄÄÆÄÀÏÇϱâÀ§ÇØ E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\scriptVC90.sln À» ½ÇÇàÇÕ´Ï´Ù.
8. ¸¶Âù°¡Áö·Î Visual C++ 2008 ¿¡¼ ¼Ö·ç¼Ç±¸¼ºÇ׸ñÀ» ' Release ' ·Î ¼±ÅÃÇÑÈÄ, ¸Þ´º¿¡¼ ºôµå > ¼Ö·ç¼Ç ºôµå ¸¦ Ŭ¸¯ÇÏ¿© ÄÄÆÄÀÏ ÇÕ´Ï´Ù.
´ÙÀ½Àº ScriptDev2 rev.586 ÃÖÁ¾ ºôµå °á°úÀÔ´Ï´Ù.
========== ºôµå: ¼º°ø 2, ½ÇÆÐ 0, ÃֽŠ0, »ý·« 0 ==========
9. ScriptDev2 ½ºÅ©¸³Æ® ÄÄÆÄÀÏÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù. VC âÀ» Á¾·áÇÕ´Ï´Ù.
10. E:\MaNGOS_SRC\trunk\bin\Win32_Release Æú´õ¾ÈÀÇ ¾Æ·¡ ÆÄÀÏÀ» E:\MaNGOS Æú´õ¾ÈÀ¸·Î º¹»çÇÕ´Ï´Ù.
mangosd.exe , realmd.exe , dbghelp.dll , libeay32.dll , libmySQL.dll , MaNGOSScript.dll
11. E:\MaNGOS_SRC\trunk\src\mangosd\mangosd.conf.in ÆÄÀÏÀ» E:\MaNGOS Æú´õ¾ÈÀ¸·Î º¹»çÇÑÈÄ, ' mangosd.conf ' À¸·Î À̸§¹Ù²Ù±âÇÕ´Ï´Ù.
12. E:\MaNGOS_SRC\trunk\src\realmd\realmd.conf.in ÆÄÀÏÀ» E:\MaNGOS Æú´õ¾ÈÀ¸·Î º¹»çÇÑÈÄ, ' realmd.conf ' À¸·Î À̸§¹Ù²Ù±âÇÕ´Ï´Ù.
13. E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\scriptdev2.conf ÆÄÀÏÀ» E:\MaNGOS Æú´õ¾ÈÀ¸·Î º¹»çÇÕ´Ï´Ù.
## ´ÙÀ½Àº ȯ°æ¼³Á¤ ´Ü°èÀÔ´Ï´Ù.
14. E:\MaNGOS\mangosd.conf ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±â ÇÕ´Ï´Ù.
15. 48-50¹ø° ¶óÀÎÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÑÈÄ ÀúÀåÇÕ´Ï´Ù
LoginDatabaseInfo = "127.0.0.1;3306;root;7777;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;7777;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;7777;characters"
16. E:\MaNGOS\realmd.conf ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±â ÇÕ´Ï´Ù.
17. 99¹ø° ¶óÀÎÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÑÈÄ ÀúÀåÇÕ´Ï´Ù
LoginDatabaseInfo = "127.0.0.1;3306;root;7777;realmd"
18. E:\MaNGOS\scriptdev2.conf ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±â ÇÕ´Ï´Ù.
19. 11¹ø° ¶óÀÎÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÑÈÄ ÀúÀåÇÕ´Ï´Ù
ScriptDev2DatabaseInfo = "127.0.0.1;3306;root;7777;scriptdev2"
## ´ÙÀ½Àº DB ¸¦ ¼³Ä¡ÇÒ Â÷·ÊÀÔ´Ï´Ù.
## UDB ¼³Ä¡¹æ¹ý
[ÆÄÀϼ³¸í]
UDB_0.10.3_Core_6240_SD2_473.rar
0.10.3 : UDB ¹öÀüÀÌ 0.10.3 ÀÓÀ» ÀǹÌÇÕ´Ï´Ù.
Core_6240 : MaNOGS ¼Ò½º¹öÀüÀÌ 6240 º¸´Ù »óÀ§¹öÀü¿¡¼ »ç¿ëÇÒ ¼ö ÀÖÀ½À» ÀǹÌÇÕ´Ï´Ù.
SD2_473 : ¸Á°í½º ½ºÅ©¸³Æ®ÀÎ ScriptDev2 ¹öÀüÀÌ 473 º¸´Ù »óÀ§¹öÀü¿¡¼ »ç¿ëÇÒ ¼ö ÀÖÀ½À» ÀǹÌÇÕ´Ï´Ù.
[UDB ¾÷µ¥ÀÌÆ® ¼³¸í]
UDB´Â ' E:\UDB\trunk\Updates\0.10.3_additions ' Æú´õ¾È¿¡ corepatch ÆÄÀÏÀÌ ÀÖÀ¸¸é ³·Àº¹øÈ£¿¡¼ ³ôÀº¹øÈ£ ¼ø¼´ë·Î ¾÷µ¥ÀÌÆ®ÇØ¾ß ÇÕ´Ï´Ù.
[ÆÄÀϼ³¸í]
358_corepatch_mangos_6241_to_6346.sql
358_corepatch : 358 ´Â ÆÐÄ¡¹øÈ£(³·Àº¹øÈ£¿¡¼ ³ôÀº¹øÈ£ ¼ø¼´ë·Î ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù)
mangos_6241_to_6346 : MaNGOS ¼Ò½º¹öÀüÀÌ 6241-6346±îÁö Àû¿ëµÈÆÄÀÏ·Î mangos DB¿¡ ¾÷µ¥ÀÌÆ® ÇÕ´Ï´Ù.
realmd_6347_to_6439 : MaNGOS ¼Ò½º¹öÀüÀÌ 6347-6439±îÁö Àû¿ëµÈÆÄÀÏ·Î realmd DB¿¡ ¾÷µ¥ÀÌÆ® ÇÕ´Ï´Ù.
20. E:\UDB\trunk\Full_DB Æú´õ¾ÈÀÇ UDB_0.10.3_Core_6240_SD2_473.rar À» ¾ËÁýÀ» ÀÌ¿ëÇÏ¿© ' ÇöÀçÆú´õ¿¡ ¾ÐÃàÇ®±â 'ÇÕ´Ï´Ù.
21. SQLyog¸¦ ½ÇÇàÇÕ´Ï´Ù. user name = root , password = 7777 Á¢¼ÓÇÕ´Ï´Ù.
22. ¾Æ·¡ Äõ¸®¹® 4°³¸¦ ¿ìÃøÀÇ Query â¿¡ º¹»çÇÏ¿© ºÙ¿©³Ö±â ÇÕ´Ï´Ù.
CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
23. ¸Þ´º¿¡¼ Edit > Execute Query > Execute All Queries ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
24. ¸Þ´º¿¡¼ Edit > Refresh Object Browser ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
25. ¿ÞÂÊÆгÎÀÇ ' mangos ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
26. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, À§¿¡¼ ¾ÐÃàÇØÁ¦ÇÑ E:\UDB\trunk\Full_DB Æú´õ¾ÈÀÇ ' UDB_0.10.3_Core_6240_SD2_473.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
27. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© mangos DB¿¡ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
28. ´Ù½Ã ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\UDB\trunk\Updates\0.10.3_additions Æú´õ¾È¿¡¼ corepatch_mangos ¶ó´Â ÆÄÀÏÀÌ ÀÖ´Ù¸é ³·Àº¹øÈ£¿¡¼ ³ôÀº¹øÈ£ ¼ø¼´ë·Î ¾÷µ¥ÀÌÆ®ÇØ¾ß ÇÕ´Ï´Ù.
ÇöÀç 358_corepatch_mangos_6241_to_6346.sql , 358_corepatch_mangos.sql , 359_corepatch_mangos_6347_to_6439.sql , 359_corepatch_mangos.sql µî 4°³ÀÇ ÆÄÀÏÀÌ ÀÖ½À´Ï´Ù.
29. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© 4°³ÀÇ ÆÄÀÏÀ» ¼ø¼´ë·Î mangos DB¸¦ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
** Ãß°¡µÈ ÆÄÀÏÀÌ ÀÖ´Ù¸é ¸ðµÎ ¹øÈ£ ¼ø¼´ë·Î ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
** Âü°í·Î, corepatch_characters ÆÄÀÏ°ú corepatch_realmd ÆÄÀÏÀº ¼³Ä¡¾ÈÇصµ µË´Ï´Ù. MaNGOS ¼Ò½º ÃֽŹöÀü¿¡ ÃÖÀûÈµÈ characters°ú realmd DB ÆÄÀÏÀ» E:\MaNGOS_SRC\trunk\sql ¿¡¼ ¾÷µ¥ÀÌÆ®Çϱ⠶§¹®ÀÔ´Ï´Ù.
** ¸¶Áö¸· ÄÚ¾îÆÐÄ¡ ÆÄÀÏ ' 359_corepatch_mangos_6347_to_6439.sql 'Àº MaNGOS ¼Ò½º ¹öÀüÀÌ 6439 ±îÁö Àû¿ëµÈ ÆÄÀÏÀÔ´Ï´Ù.
30. µû¶ó¼ E:\MaNGOS_SRC\trunk\sql\updates Æú´õ¾ÈÀÇ ' 6439 ' º¸´Ù ³ôÀº¹øÈ£ÀÇ ÆÄÀÏ(xxxx_mangos...sql)ÀÌ ÀÖ´Ù¸é ¼ø¼´ë·Î mangos DB¿¡ ¾÷µ¥ÀÌÆ® ÇÕ´Ï´Ù.
** Âü°í·Î ÆÄÀÏÀ̸§Áß¿¡ xxxx_realmd...sql ÆÄÀÏÀÌ ÀÖ´Ù¸é realms DB¿¡ ¾÷µ¥ÀÌÆ®ÇÏ´Â ÆÄÀÏÀÔ´Ï´Ù. Áö±ÝÀº xxxx_realmd...sql ÆÄÀÏÀº ¾÷µ¥ÀÌÆ®ÇÏÁö ¾Ê½À´Ï´Ù.
¸ðµç UDB, MaNGOS ¼Ò½º DB¾÷µ¥ÀÌÆ®¸¦ ¸¶ÃÆ´Ù¸é ½ºÅ©¸³Æ® DB¸¦ mangos DB¿¡ ¾÷µ¥ÀÌÆ®ÇØ¾ß ÇÕ´Ï´Ù.
31. ´Ù½Ã ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\sql Æú´õ¾ÈÀÇ ' mangos_full_scripts.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
32. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© mangos_full_scripts.sql¸¦ mangos DB¿¡ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
33. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© mangos DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
34. ¿ÞÂÊÆгÎÀÇ ' scriptdev2 ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
35. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\sql Æú´õ¾ÈÀÇ ' scriptdev2_structure.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
36. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© scriptdev2_structure.sql¸¦ scriptdev2 DB¿¡ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
37. ¿ÞÂÊÆгÎÀÇ ' realmd ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
38. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\sql Æú´õ¾ÈÀÇ ' realmd.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
39. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© realmd DB¸¦ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
40. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© realmd DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
41. ¿ÞÂÊÆгÎÀÇ ' characters ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
42. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\sql Æú´õ¾ÈÀÇ ' characters.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
43. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© characters DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
44. ¸ðµç DB ¾÷µ¥ÀÌÆ®¸¦ ¸¶ÃƽÀ´Ï´Ù. SQLyogâÀ» Á¾·áÇÕ´Ï´Ù.
## ´ÙÀ½Àº ¸ÊÆÄÀÏ°ú DBC¸¦ ÃßÃâÇÏ´Â ´Ü°èÀÔ´Ï´Ù.
45. E:\MaNGOS_SRC\trunk\contrib\extractor\ad.exe ÆÄÀÏÀ» ¿Í¿ì Ŭ¶ó(World of Warcraft) Æú´õ¾ÈÀ¸·Î º¹»çÇÕ´Ï´Ù.
46. ad.exe ¸¦ ½ÇÇàÇÏ¿© ¸Ê°ú dbc ÆÄÀÏÀ» ÃßÃâÇÕ´Ï´Ù. ½Ã½ºÅÛÀÇ ±âÁ¾ÀÇ µû¶ó 30ºÐÀÌ»óÀÇ ½Ã°£ÀÌ ¼Ò¿äµË´Ï´Ù.
47. ÃßÃâÀÌ ¿Ï·áµÇ¸é ¿Í¿ì Ŭ¶ó(World of Warcraft)¾ÈÀÇ dbc , maps Æú´õ¸¦ E:\MaNGOS Æú´õ¾ÈÀ¸·Î º¹»ç ¶Ç´Â À̵¿ÇÕ´Ï´Ù.
## ¼¹ö ½ÇÇà ´Ü°èÀÔ´Ï´Ù.
48. E:\MaNGOS Æú´õ¾ÈÀÇ realmd.exe ¿Í mangosd.exeÀ» ½ÇÇàÇÕ´Ï´Ù.
49. º¸¾È°æ°í âÀÌ ¶ß¸é Â÷´ÜÇØÁ¦¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
50. °èÁ¤»ý¼ºÀº mangos.exe âÀÇ mangos> ¿¡¼ ' create USERID PASSWORD ' ¸¦ ÀÔ·ÂÇÏ¸é µË´Ï´Ù.
** À¥°èÁ¤ »ý¼ºÆäÀÌÁö´Â µ¿¿µ»ó ¼³Ä¡¹æ¹ýÀ» Âü°íÇϼ¼¿ä.
## [Âü°í] NCDB ¼³Ä¡¹æ¹ý
1. SQLyog ¸¦ ½ÇÇàÇÕ´Ï´Ù.
2. user name = root , password = 7777 Á¢¼ÓÇÕ´Ï´Ù.
3. ¾Æ·¡ Äõ¸®¹® 5°³¸¦ ¿ìÃøÀÇ Query â¿¡ º¹»çÇÏ¿© ºÙ¿©³Ö±â ÇÕ´Ï´Ù.
CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `ncdb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
4. ¸Þ´º¿¡¼ Edit > Execute Query > Execute All Queries ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
5. Sqlyog ¸¦ Á¾·áÇÕ´Ï´Ù.
6. E:\NCDB\trunk\sql\win-install.bat ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±â ÇÕ´Ï´Ù.
7. 13-15¹ø° ¶óÀÎÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÑÈÄ ÀúÀåÇÕ´Ï´Ù
set user=root
set pass=7777
set wdb=ncdb
8. ¼öÁ¤µÈ E:\NCDB\trunk\sql\win-install.bat ÆÄÀÏÀ» ½ÇÇàÇÕ´Ï´Ù.
9. ¸ÞÀΠȸ鿡¼ i Å°¸¦ ´·¯ DB ¾÷µ¥ÀÌÆ® ÇÕ´Ï´Ù.
10. Finished ¸Þ¼¼Áö°¡ ³ª¿À¸é ¾Æ¹«Å°³ª ´©¸¥ÈÄ x Å°¸¦ ´·¯ âÀ» Á¾·áÇÕ´Ï´Ù.
11. E:\NCDB\trunk Æú´õ¾ÈÀÇ ' web installer ' Æú´õ¸¦ º¹»çÇÏ¿©, À¥Æú´õ ' E:\RWAPM\www ' Æú´õ¾È¿¡ ºÙ¿©³Ö±âÇÕ´Ï´Ù.
12. E:\RWAPM\www\web installer\include\config.inc.php ÆÄÀÏÀ» EditPlus ·Î ºÒ·¯¿À±â ÇÕ´Ï´Ù.
13. 3-12¹ø° ¶óÀÎÀ» ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÑÈÄ ÀúÀåÇÕ´Ï´Ù
// Base Database
$dbhost = "localhost"; // Base Table host
$dbuname = "root"; // Base Table login
$dbupass = "7777"; // Base Table login password
$dbname = "ncdb"; // Base table name
// Destination Database
$dbhost_destination="localhost"; // Destination Table host
$dbuname_destination="root"; // Destination Table login
$dbupass_destination="7777"; // Destination Table login password
$dbname_destination="mangos"; // Destination Table name
14. À¥ºê¶ó¿ìÀú ÁÖ¼Òâ¿¡ http://localhost/web installer/ À» ÀÔ·ÂÇÏ¿© NCDB À¥¼³Ä¡¸¦ ÁøÇàÇÕ´Ï´Ù.
15. Mangos 6456 and newer. À» Ŭ¸¯ÇÕ´Ï´Ù.
MaNGOS ¼Ò½º ¹öÀüÀÌ ' 6465 'º¸´Ù »óÀ§¹öÀü¿¡¼ »ç¿ëÇÒ ¼ö ÀÖÀ½À» ÀǹÌÇÕ´Ï´Ù.
16. 'Start converting ' ¹öÆ°À» Ŭ¸¯ÇÏ¿© NCDB¸¦ MaNGOS DB·Î ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
½Ã½ºÅÛ È¯°æ¿¡µû¶ó 10¿©ºÐÀÇ ½Ã°£ÀÌ ¼Ò¿äµË´Ï´Ù.
[ÁÖÀÇ] Àý´ë·Î âÀ» Á¾·áÇϰųª ÆäÀÌÁö¸¦ À̵¿ÇÏÁö ¸¶¼¼¿ä.
À¥ºê¶ó¿ìÀú ÁÖ¼Òâ¿¡ http://localhost/web installer/mangos/finished.php ¶ó°í º¸À̸é NCDB À¥¼³Ä¡°¡ ³¡³°ÍÀÔ´Ï´Ù.
## DB ¾÷µ¥ÀÌÆ® ´Ü°èÀÔ´Ï´Ù.
17. SQLyog¸¦ ½ÇÇàÇÕ´Ï´Ù. user name = root , password = 7777 Á¢¼ÓÇÕ´Ï´Ù.
18. ¿ÞÂÊÆгÎÀÇ ' mangos ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
19. Execute Query(s) From A File â¿¡¼ ã¾Æº¸±â(...)¹öÆ°À» Ŭ¸¯ÇÕ´Ï´Ù.
20. E:\MaNGOS_SRC\trunk\sql\updates Æú´õ¾È¿¡¼ NCDBÀÇ ¸Á°í½º Áö¿ø¹öÀüÀÎ 6465 º¸´Ù ³ôÀº ÆÄÀÏÀÌ ÀÖÀ¸¸é ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
21. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© MaNGOS DB¸¦ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
ÇöÀç MaNGOS rev.6471¿¡¼´Â 6465º¸´Ù ³ôÀº ÆÄÀÏÀÌ ¾ø±â¶§¹®¿¡ âÀ» Á¾·áÇÏ¿´½À´Ï´Ù.
22. ¿ÞÂÊÆгÎÀÇ ' mangos ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
23. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\sql Æú´õ¾ÈÀÇ ' mangos_full_scripts.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
24. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© mangos_full_scripts.sql¸¦ MaNGOS DB¿¡ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
25. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© mangos DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
26. ¿ÞÂÊÆгÎÀÇ ' scriptdev2 ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
27. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\src\bindings\ScriptDev2\sql Æú´õ¾ÈÀÇ ' scriptdev2_structure.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
28. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© scriptdev2_structure.sql¸¦ scriptdev2 DB¿¡ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
29. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© scriptdev2 DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
30. ¿ÞÂÊÆгÎÀÇ ' realmd ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
31. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\sql Æú´õ¾ÈÀÇ ' realmd.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
32. Execute ¹öÆ°À» Ŭ¸¯ÇÏ¿© realmd DB¸¦ ¾÷µ¥ÀÌÆ®ÇÕ´Ï´Ù.
33. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© realmd DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
34. ¿ÞÂÊÆгÎÀÇ ' characters ' DB ¸¦ ¼±ÅÃÇÑÈÄ, ¸¶¿ì½º ¿ìŬ¸¯ÇÏ¿©, Restore From SQL Dump ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
35. ' ã¾Æº¸±â '¹öÆ°À» Ŭ¸¯ÇÑÈÄ, E:\MaNGOS_SRC\trunk\sql Æú´õ¾ÈÀÇ ' characters.sql ' ÆÄÀÏÀ» ¼±ÅÃÇÑÈÄ ¿±âÇÕ´Ï´Ù.
36. Done ¹öÆ°À» Ŭ¸¯ÇÏ¿© characters DB ¾÷µ¥ÀÌƮâÀ» Á¾·áÇÕ´Ï´Ù.
37. ¸ðµç DB ¾÷µ¥ÀÌÆ®¸¦ ¸¶ÃƽÀ´Ï´Ù. SQLyogâÀ» Á¾·áÇÕ´Ï´Ù.
ascent / mangos :: ascent :: ¼¹ö ¼³Ä¡
ÆäÀÌÁö 1 Áß 1
Permissions in this forum:
´ä±ÛÀ» ¿Ã¸± ¼ö ¾ø½À´Ï´Ù
|
|