[ Guide ] Hamachi / Non-hamachi server making and SQL 2000 guide

Step One:The Installation of Microsoft SQL Server 2000


To start off you will need Microsoft Sql Server 2000:
[You must be registered and logged in to see this link.]


1- Execute SQLEVAL.exe.
2- Go to the directory where you installed the files.
3- Open AutoRun.exe.
4- Chose SQL Server 2000 Components.
5- Then Install Database Server:
- After a few seconds, you should see a window. Click Next to continue.
- Make sure Local Computer is selected and click Next.
- Make sure Create a new instance of SQL Server, or install Client Tools is selected, then click Next.
- In this screen, you can type anything you want in those fields, as it's not really important, it's just for registering the software.
- Just click Yes.
- On this screen, make sure to select Server and Client Tools and click Next.
- Make sure Default is selected and click Next.
- Click Typical and click Next (you could change where it installs to).
- Click Use the same account for each service, Auto start SQL Server Service. and then select Use the Local System accountand click Next.
- In this screen, Select Mixed Mode (Windows Authentication and SQL Server Authentication) then enter a password in both the boxes below,and click Next
- In this screen, just click Next. This will start the installation.
- Click Finish and restart your computer.
6- Congratulations! You have installed Microsoft SQL Server 2000.

Step One:Done!

Step Two:The Server files:


Download those server files and extract them(wherever you want):
[u=http://sharebee.com/1f68a2bc]The Server Files[/u]


A- Editing the server files

1-AccountServer.cfg
- Open it,chose Select the program from a list,and then chose notepad.
- WHEREVER you see this 12.0.0.1 IP,replace it with your own Hamachi IP/Global IP(for Non-Hamachi Server).
- And erase everything else that says ERASE THIS! (Those are Usernames and Passwords).

Code:

//؛£µءحُشعدكسخد·AccountServerإنضأخؤ¼‏

[net]
listen_port = 1978
listen_ip = 12.0.0.1 //¼àج‎IPµطض·£¬سأسع½ستـGroupServerµؤء¬بë

[db]
dbserver = 12.0.0.1
db = AccountServer
userid = ERASE THIS!
passwd = ERASE THIS!


[bill]
enable_bill = 0
enable_passport= 0 //تا·ٌئôسأbillingدµح³µؤpassport
enable_kickuser = 0

bill_server1 =12.0.0.1:7243
bill_server2 =12.0.0.1:7243

[tom]
enable_tom = 0

[gs]
GroupServerAndor = GroupServerAndor // ×¢²لµؤGroupServerصث؛إ£¨¸ٌت½خھ£؛،°صث؛إأû،± = ،°أـآë،±£
GroupServerAndor1 = GroupServerAndor1 // ×¢²لµؤGroupServerصث؛إ£¨¸ٌت½خھ£؛،°صث؛إأû،± = ،°أـآë،±£
GroupServerAndor2 = GroupServerAndor2 // ×¢²لµؤGroupServerصث؛إ£¨¸ٌت½خھ£؛،°صث؛إأû،± = ،°أـآë،±£
GroupServerAndor5 = GroupServerAndor5 // ×¢²لµؤGroupServerصث؛إ£¨¸ٌت½خھ£؛،°صث؛إأû،± = ،°أـآë،±£
GroupServerAndor6 = GroupServerAndor6 // ×¢²لµؤGroupServerصث؛إ£¨¸ٌت½خھ£؛،°صث؛إأû،± = ،°أـآë،±£
enable_ping = 1 // سëGroupServerتا·ٌئôسأ "Keep Alive"

AccountServer Done!

2- GameServer.cfg
- Open it,chose Select the program from a list,and then chose notepad.
- WHEREVER you see this 12.0.0.1 IP,replace it with your own Hamachi IP/Global IP(for Non-Hamachi Server).
- And erase everything else that says ERASE THIS! (Those are Usernames and Passwords).

Code:

map = eastgoaf // Under Water Tunnel, BD Lair, Silver Mine, Abandon Mine
//map = darkblue // Deep Blue
//map = binglang2 // Icicle Mirage
//map = magicsea // Magical Ocean
//map = shalan2 // Shaitan Mirage
//map = abandonedcity // Forsaken City Map 1
//map = abandonedcity2 // Forsaken City Map 2
//map = abandonedcity3 // Forsaken City Map 3
//map = darkswamp // Dark Swamp
//map = jialebi // Treasure Gulf, Naval Base, Skeletar Island, Abaddon 1-4
//map = hell // Abaddon 5-8
//map = hell2 // Abaddon 9
//map = hell3 // Abaddon 10-11
//map = hell4 // Abaddon 12
//map = hell5 // Eternal Abaddon
//map = secretgarden // Guild War
//map = guildwar // Sacred War
//map = guildwar2 // Mini Sacred War
map = teampk // PvP Arena
//map = yschurch
//map = prisonisland
//map = 07xmas
//map = 07xmas2
//map = sdBoss

[OII،PEy?Y?a] // O،M?،LEy?YA??ODAI¢F
db_ip = 12.0.0.1 // Ey?Y?a،PtInA،زip£gOO،P
db_usr = ERASE THIS // ?oEeEy?Y?a£gAOEoA
db_pass = ERASE THIS// ?oEeEy?Y?a£gAAUAe, ،¦EAUAeEC،ر،LAA1??s?OAUORoo£gA?a1u

[Socket]
keep_alive = 120

[ID?uEy] // ،PtInA،زIa?CE?،POAaID£gA?uEy, A?،Mo£gOI?server??2?I?
BaseID = 0x50000000

[E£gIaEyA?] // O¢XIiAU،¦aO?OA
max_ply = 500 // Ia?OEyA?
max_cha = 15000 // 1OIiEyA?
max_item = 30000 // £gA?sEyA?
max_tnpc = 300 // ?O?¢XNPCEyA?

[1??a،رi،¦o3EO،سEy]
guild_num = 80

[1??a،رi،¦o،¦yAu3EO،سEy]
guild_try_num = 80

[£gA?s]
item_show_time = 60 // £gA?s،¦aOUE،س?a¢G،LAe¢Gc
item_prot_time = 30 // £gA?s،س¢G??E،س?a¢G،LAe¢Gc

[o¢X?¢X?a،Mo]
say_interval = 3 // Ae

[LOG?a1O]
log_cha = 0
log_cal = 0
log_ai = 0
log_mission = 0

[£g،زEOO،MAi?a1O] // £g،زEOOA, ،PCGMO،MAi
supercmd = 1

[،رEO،¦A?A?]
res_dir = ./resource
log_dir = log\\log

//[،¦o£gOI??a1O]
db_mapmask = 1

GameServer Done!

3- GateServer.cfg
- Open it,chose Select the program from a list,and then chose notepad.
- WHEREVER you see this 12.0.0.1 IP,replace it with your own Hamachi IP/Global IP(for Non-Hamachi Server).
- And erase everything else that says ERASE THIS! (Those are Usernames and Passwords).

Code:

;GateServer³ُت¼»¯ذإد¢خؤ¼‏

[Main]
Name = MoMo_Gate //±¾GateServerµاآ¼µ½GroupServerةدµؤخ¨ز»أû×ض
Version =135 //±¾GateServerرéض¤؟ح»§¶ثµؤ°و±¾؛إ£¬بç1.01°و£½£½101

[GroupServer]
IP = 12.0.0.1 //ء¬½سµؤGroupServerصىج‎GateServerء¬½سµؤصىج‎IPµطض·
Port = 1975 //ء¬½سµؤGroupServerصىج‎GateServerء¬½سµؤصىج‎TCP¶ث؟ع
EnablePing = 1800 //GateServerµ½GroupServerµؤSocketء¬½سµؤKeepAliveضµ

[ToClient]
IP = 12.0.0.1 //GateServerصىج‎سخد·؟ح»§¶ثء¬½سµؤصىج‎IPµطض·
Port = 1973 //GateServerصىج‎سخد·؟ح»§¶ثء¬½سµؤصىج‎TCP¶ث؟ع
CommEncrypt = 1 //µ½؟ح»§¶ثµؤSocketء¬½ستا·ٌ´ٍ؟ھ¼سأـح¨ذإ
EnablePing = 60 //GateServerµ½سخد·؟ح»§¶ثµؤSocketء¬½سµؤKeepAliveضµ
³ُت¼×î´َء¬½س =1000

[ToGameServer]
IP = 12.0.0.1 // س¦جîخھؤعحّipµطض· £¬GateServerصىج‎GameServerء¬½سµؤصىج‎IPµطض·
Port = 1971 //GateServerصىج‎GameServerء¬½سµؤصىج‎TCP¶ث؟ع
EnablePing = 180 //GateServerµ½GameServerµؤSocketء¬½سµؤKeepAliveضµ

[ShowRange]
ShowMin = 500 // ذ،سعµبسعShowMinت±دشت¾ص‎³£
ShowMax = 800 // ´َسعShowMin²¢ازذ،سعµبسعShowMaxدشت¾·±أ¦£¬´َسعShowMaxدشت¾آْ
IsUse=0 // تا·ٌئôسأ¸؛؛ة×´ج¬دشت¾¹¦ؤـ£¬1ت¹سأ£¬0²»ت¹سأ

GateServer Done!

4-GroupServer.cfg
- Open it,chose Select the program from a list,and then chose notepad.
- WHEREVER you see this 12.0.0.1 IP,replace it with your own Hamachi IP/Global IP(for Non-Hamachi Server).
- And erase everything else that says ERASE THIS! (Those are Usernames and Passwords).

Code:

;؛£µءحُشعدكسخد··‏خٌئ÷×éGroupServerإنضأخؤ¼‏
;GroupServerئô¶¯ت±»ل¼ى²éت‎¾ف؟âµؤsystemسأ»§±ي(´ث±يض»ؤـسذز»جُ¼اآ¼)µؤgroup_startupءذ£¬بç¹û´ثءذخھ0£¬±يت¾µ±ا°أ»سذGroupServerشعشثذذ£¬±¾GroupServer»لص‎³£ئô¶¯£¬·ٌشٍ±¾GroupServer»لء¢¼´حث³ِزشأâضط¸´ئô¶¯
;GroupServerشعexitأüءîدآحث³ِ»ل×ش¶¯اه³‎´ث±êض¾زش±»دآ´خص‎³£ئô¶¯،£
[Main]
Name =GroupServerAndor1 //±¾GroupServerµاآ¼AccountServerµؤخ¨ز»أû³ئ
Listen_Port =1975 //GroupServerصىج‎GateServerء¬½سµؤTCP¶ث؟ع
Listen_IP =12.0.0.1 //GroupServerصىج‎GateServerء¬½سµؤIPµطض·£¬ز»°مس¦خھؤعحّIPµطض·
KeepAlive =1800 //بç¹ûSocket؛ـ¾أأ»سذت‎¾ف´«تن£¬GroupServerبدخھSocket´¦سع»î¶¯×´ج¬µؤت±¼ن£¬³¬¹‎´ثت±¼نأ»سذت‎¾ف¼´بدخھSocketزرثہ
Version =103 //؟طضئء¬½سGateServer°و±¾µؤ°و±¾؛إ£¬ض»سذ°و±¾؛إتôسع´ثت‎×ضµؤGateServer.exe²إؤـء¬½س±¾GroupServer

[AccountServer]
AcctEnable =1 //0:¹ط±صAccountServerء¬½س£»1:´ٍ؟ھAccountServerء¬½س
Password =GroupServerAndor1 //µاآ¼AccountServerثùت¹سأ؟عءî
IP =12.0.0.1 //AccountServerصىج‎±¾GroupServerء¬½سµؤIPµطض·
Port =1978 //AccountServerصىج‎±¾GroupServerء¬½سµؤTCP¶ث؟ع

[Database]
IP =12.0.0.1 //ت‎¾ف؟âثùشع·‏خٌئ÷IPµطض·
DB =GameDB //ت‎¾ف؟âأû×ض
Login =ERASE THIS! //ء¬½ست‎¾ف؟âثùسأµؤسأ»§أû
Password =ERASE THIS! //¼سأـ؛َµؤء¬½ست‎¾ف؟â؟عءî
MaxVal =2000000000 //ز»¸ِتôذش³£ء؟£¬تôذش´َسع´ث²»؟ةؤـضµ»ل±»×èض¹½ّبëسخد·µطح¼£¬ةèخھ´ث¹ج¶¨ضµ

[½اة«]
أ؟صت؛إ×î´َ½اة«ت‎ =3 //أ؟صت؛إؤـ´´½¨µؤ×î´َ½اة«ت‎
¸ِذش»¯ح¼±êµؤ×î´َضµ =30 //¸ِذش»¯ح¼±êµؤ×î´َضµ£¬تسسخد·°و±¾¶ّ¶¨£¬´ثضµتا·‏خٌئ÷¼ى²éحو¼زشعةèضأت±؛ٍµؤ·¶خ§¼ى²éضµ
×î´َµاآ¼بثت‎ =3000 //±¾·‏خٌئ÷×é×î´َµاآ¼بثت‎

[؛أسر]
×î¶à±»رûاëت‎ =5 //´ثضµخق×î´َضµدقضئ
خ´¾ِرûا볬ت± =30 //µ¥خ»(أë)
أ؟½اة«×î¶à؛أسرت‎ =50 //×î´َضµ90
أ؟½اة«µؤ×شضئ؛أسر·ض×éت‎ =10 //×î´َضµ10

[×é¶س]
×î¶à±»رûاëت‎ =5 //´ثضµخق×î´َضµدقضئ
خ´¾ِرûا볬ت± =30 //µ¥خ»(أë)
أ؟×é¶س×î¶à³ةش±ت‎ =5 //´ثضµخق×î´َضµدقضئ

[ءؤجى]
أ؟حو¼ز×î¶à»ل»°ت‎ =3 //´ثضµ×î´َ؟ةزشةèµ½30
أ؟»ل»°×î¶àحو¼زت‎ =30 //´ثضµ×î´َ؟ةزشةèضأµ½100
تہ½çئµµہثµ»°¼ن¸ô =3 //µ¥خ»(أë£
½»ز×ئµµہثµ»°¼ن¸ô =3 //µ¥خ»(أë)
ث½ءؤئµµہثµ»°¼ن¸ô =5 //µ¥خ»(أë)

[³ِةْµط] //´ث´¦±طذë؛حGameServerإنضأµؤ³ِةْµطذإد¢ز»ضآ
Argent City = garner
Shaitan City = magicsea
Icicle Castle = darkblue

GroupServer Done!

Step Two:A Done!

B- Attaching the server files

1- Click Start then All Programs then Microsoft SQL Server then select EnterpriseManager.
2- You will now see a window. Click the + symbol next to Microsoft SQL Servers.
3- Click the + next to SQL Server Group.
4- Click the + symbol next to (local) (Windows NT) (it might say something other than Windows NT, depending on your OS).
5- Click the + symbol next to Databases.
6- Now, right click on Database and select All Tasks then Attach Database...
7- Go to your Server Files,then Databases then gamedb_Data.mdf.
- In the field Attach AsType:GameDB.
- In the field Db Owner Select: sa.
- Then select Ok.
8- Again, right click on Database and select All Tasks then Attach Database...
9- Go to your Server Files,then Databases then accountserver_Data.mdf.
- In the field Attach AsType:AccountServer.
- In the field Db Owner Select: sa.
- Then select Ok.

Step Two: B Done!
Step Two Done!

Step Three: The Patch

You will need a patch to be able to run your private server.
I am currently using Frozen-Phoenix Patch
[You must be registered and logged in to see this link.]
After downloading it,extract it where you installed the client you downloaded from the official ToP/PKO website.

Step Three Done!

Step Four: IP Changer

You will need to download the IP Changer and put it in the same directory as the client you downloaded from the official ToP/PKO website.

IP Changer : [You must be registered and logged in to see this link.]

Step Four Done!

Finally you're ready to play on YOUR OWN PRIVATE SERVER!

Step Five:PLAYING!

1- Go to you server files directory.
2- Open Server Launcher.exe
3- a- Launch AccountServer.
b- Launch GameServer.
c- Launch GateServer.
d- Launch GroupServer.
4- Go to the directory where the client you downloaded from the official ToP/PKO website is and open IP Changer.(You Will See three brackets)
- 1st bracket ( Type here what the primary server is called)
- 2nd bracket ( Type here what the secondary server is called)
- 3rd bracket ( Type here your hamachi IP/Global IP,the one we used on the .cfg files earlier)
5- FINALLY!the step you've been waiting for...go to the ToP/PKO client directory and launch Frozen Phoenix.bat and you should be on your own private server.

Step Five Done!

Credits go to all the people who made all the guides and videos I've seen.
Please be kind enough to tell me if there's ANYTHING I missed.

~~MC