Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Archlord
You last visited: Today at 00:16

  • Please register to post and access all features, it's quick, easy and FREE!

 

Create your own Private Server Tutorial.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2007
Posts: 325
Received Thanks: 280
Post Create your own Private Server Tutorial.









Notes
- Tested on Windows XP Pro SP.3
- Does not work on Windows 7 or Windows Vista ( Oracle compatibility problems )
- I will not give out my MSN, Or help beyond this Tutorial.

Downloads

Old server files


Celestia Archlord - Server Files Update package


PLSQL_Developer_7.0.1中文版


SQL Files.


Orcale9i Disk 1

Orcale9i Disk 2

Orcale9i Disk 3


Oracle 9i mirror:








Oracle 9i mirror:








Update.

GM Tools, Server files, ECT.:


Other Downloads.


Navicat.



Tutorial





Mike0505 ∞ is offline  
Thanks
69 Users
Old   #2
 
elite*gold: 0
Join Date: Nov 2007
Posts: 325
Received Thanks: 280
[ Reserved ]


Username: system
Password: password
Host: account

create user alef IDENTIFIED BY password;



-- Grant/Revoke role privileges
grant connect to alef;
grant resource to alef;
-- Grant/Revoke system privileges
grant alter session to alef;
grant create cluster to alef;
grant create database link to alef;
grant create sequence to alef;
grant create session to alef;
grant create synonym to alef;
grant create table to alef;
grant create view to alef;
grant dba to alef;


@c:\sql\account.sql;


--------------------------------------------------------------------------
For Tutorial sake, I used a VirtualPC, So I could not run the server, Or even get it to run properly..
So in the tutorial I show how to install Oracle, And use SQL Plus, and set up PLSQL_Developer_7.0.1中文版 and what files to edit..



There is Music, on the video, Make sure you dont blow your system. ( may be loud )

Thank you to Madmaxsrb, Be sure to press thanks button.
Quote:
Originally Posted by madmaxsrb View Post
as I promised here's what still needs to be changed for the server started working:
1: the file:

You must register and activate your account in order to view images.
have to be here
2: go to the folder xxxxxx/INI/DatabaseInit....

You must register and activate your account in order to view images.
3:and edit the Database.ini and DBSERVERINFO.ini as shown on image(those ini files must be first decrypted and again after ecrypted)
You must register and activate your account in order to view images.
You must register and activate your account in order to view images.
and now that the server should start without problems, but not my case I have to turn off my internet connection, and that the server starts without errors .....

Now create acc for the game can login into the game without any problems, can move, mobs here and everything is ok, until im log out of the game, is it my problem occurs when a log out of the game no longer can not login, I get a message "can not access login server"
then have to clean the entire database, i should delete a character from the database, and when the All Clear from the database then can be re-login to server...

ps:
I apologize for my terrible English .. I used Google Translate ^_^
======================

Quote:
Originally Posted by Feldunost

Softwares used and approved : [Windows XP isn't the same way)



Install the following there:

Windows 2003 x86 Enterprise Edition R2 SP2
Oracle9i version
Navicat Premium (Recommended for easiest modifications)
Java JDK (It installs automatically JRE)
Visual C++ redistributable 2008 x86
Visual C++ redistributable 2010 x86
Visual C++ Express 2010 (It will install .NET Framework 4.0)
Download any old server files available with password if told:
Download Celestia Update Server Files





1: Oracle Installation

Available Products
Full installation of the first selection
Installation Type
Select Enterprise
Database Configuration
General election
Mts recovery service configuration
Select the default port 2030
Database ID
Global database name: account
Sid: account
Location of database files
Choose
Database character set
Use the default character set


--- Start the installation
Set sys password and system password
Restart the machine end of the installation




Open SQL Plus in:
All programs => Oracle -OraHome92 => Application Development => SQL Plus

Username: SYSTEM
Password: password
SID: account

Press OK.



Copy SQL files on C:\ (download it at the first post)

Modify RPGWT.sql: change all names rpgwt by RPGWT
Modify SERVERCONFIG.sql: change all names serverconfig by SERVERCONFIG




Write on SQL Plus:
create user alef IDENTIFIED BY password;
grant connect to alef;
grant resource to alef;
grant alter session to alef;
grant create cluster to alef;
grant create database link to alef;
grant create sequence to alef;
grant create session to alef;
grant create synonym to alef;
grant create table to alef;
grant create view to alef;
grant dba to alef;
exit;



Re-open SQL Plus but with:

Username: alef
Password: password
SID: account



Write still on SQL Plus: (Copy theses files before on C:\)

@C:\ACCOUNT.sql;
@C:\RPGWT.sql;
@C:\SERVERCONFIG.sql;
exit;





Use Navicat:
Specify in Tools => Options => OCI => Oci library: C:\oracle\ora92\bin\oci.dll

Create connection with :
Username: alef
Password: password
SID: account



Change thoses attributes for SERVERCONFIG table:
Section 1 and 201, WORLD attribute is Grayheon.
Section 1 and 201 and 401, ADDRESS attribute is not 127.0.0.1 but the ip adress of the server.
Section 1000, ADDRESS attribute is 127.0.0.1:99999

All sections, DBUSER + LOGDBUSER attribute is alef
All sections, DBPWD + LOGDBPWD attribute is password
All sections, DBDSN + LOGDBDSN attribute is account



Change thoses attributes for RPGWT table:
All SERVERID, change it to Grayheon.




Changed that file:
C: \ oracle \ ora92 \ network \ admin \ tnsnames.ora.


# TNSNAMES.ORA Network Configuration File: D: \ oracle \ ora92 \ NETWORK \ ADMIN \ tnsnames.ora
# Generated by Oracle configuration tools.
ACCOUNT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = account)
)
)

DON'T FORGET TO ERASE DEDICATED SERVER LINE ! (Not on Windows XP)

For INST1_HTTP specify host for 127.0.0.1 ! In TNSNAMES.ORA also.



Removed the entire INI folder and replaced INI folder from Update Celestia files.

Changed INI/DatabaseInit/Database.ini (user: alef, password is password, SID is account)
Changed INI/DatabaseInit/DBSERVERINFO.ini (user: alef, password is password, SID is account)



Changed in Configuration panel of windows: Regional and linguistic Options, i added in Languages languages for complex scripts and languages for oriental country.
In advanced options, i changed non-unicode programs language: Chinese Republic popular language. (Can be also Chinese Taiwan)



Account creation: (It can be added manually with Navicat easily)
Connect to SQL Plus with alef user and write the following:

Insert into ALEF.AMT_ACCOUNT (ACCOUNTID,PASSWORD) values ('minera','test');

Insert into ALEF.AMT_MASTER (ACCOUNTID,EMAIL,SOCIALNO,CREATION_DATE,LAST_DATE, MODIFY_DATE,PHONE,MOBILE,ZIPCODE,ADDR1,ADDR2,SMS_Y N,EMAIL_YN,PENALTY_GBN,PAUSE_DATE,IP,LOGINCNT,NOMI NATOR,RPG_LEVEL,LONEY_AGREEYN,LONEY_CHARGEYN,SEX) values ('minera','','18',to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('26/01/11','DD/MM/RR HH24:MI:SSXFF'),null,null,null,null,null,'N','N',' 0',null,null,null,null,null,null,null,null);




Start CAL_LoginServer.exe, wait until it finishes.
Start CAL_RelayServer.exe, wait until it finishes.
Start CAL_WorldServer.exe, wait until it finishes.


Wait 2 minutes after launching in order to allow sockets and communication between them.




Go to archlord folder, in my case it's : C:\Program Files (x86)\F-Archlord
Create text file and add: alefclient.exe /L192.168.1.xxx:11002 (ip adress of the server in LAN)
Rename it in .bat, make shortcut in desktop and launch !




YOU MUST HAVE THE CORRECT CLIENT !





If you need really help, call me
For Windows XP it is almost the same way but i kept on Server 2003 for most stability.


Mike0505 ∞ is offline  
Thanks
26 Users
Old   #3
 
elite*gold: 0
Join Date: Jan 2008
Posts: 160
Received Thanks: 126
nice guide ^^
archknup is offline  
Thanks
1 User
Old   #4
 
elite*gold: 0
Join Date: Nov 2007
Posts: 325
Received Thanks: 280
Quote:
Originally Posted by archknup View Post
Original Guide:

Code:
[B]1: Oracle Installation [/B]
文件定位 File Location 

Select all the available products to install the first 

Enterprise Edition installation type selection 

General database configuration options 

Mts recovery service configuration options default port 2030 

global database name [B]account[/B]
 
Sid [B]account[/B] 

Database file location of your choice 

Database character set to use the default character set 

Start the installation 

Set sys password and system password 

Restart the machine end of the installation 

[B]Open [url]http://127.0.0.1/isqlplus/[/url] [/B]


[B]2.Start SQLPLUS, enter the following command [/B]

Create User:
 
create user alef IDENTIFIED BY password; 

Set role permissions 

-- Grant/Revoke role privileges -  
grant connect to alef;  
grant resource to alef;  
-- Grant/Revoke system privileges  
grant alter session to alef; 
grant create cluster to alef;  
grant create database link to alef;  
grant create sequence to alef;  
grant create session to alef;  
grant create synonym to alef;  
grant create table to alef;  
grant create view to alef;  
grant dba to alef;  

[B]
Import Database[/B] 

SQLPLUS to run 

@D:\sql\account.sql; \ \ path to your right can be a SQL 


[B]Database Guide[/B] 
modify SERVERCONFIG table after the server name, password. IP address for your server IP! 

客户端安装Oracle 9i 客户端,选管理员那个。 Oracle 9i client installation client, the election administrator that. 装完后把下面内容放到数据库安装目录和客户端安装目录下文件,路径是D:\oracle\ora92\network\admin\tnsnames.ora ,改成以下内容! Bahrain the following content into the database and the client installation directory under the installation directory file path is D: \ oracle \ ora92 \ network \ admin \ tnsnames.ora, change the following! 


# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora # TNSNAMES.ORA Network Configuration File: D: \ oracle \ ora92 \ NETWORK \ ADMIN \ tnsnames.ora 
# Generated by Oracle configuration tools. # Generated by Oracle configuration tools. 

ACCOUNT = ACCOUNT = 
(DESCRIPTION = (DESCRIPTION = 
(ADDRESS_LIST = (ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.88)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.88) (PORT = 1521)) 
) ) 
(CONNECT_DATA = (CONNECT_DATA = 
(SERVICE_NAME = account) (SERVICE_NAME = account) 
) ) 
) ) 


启动服务端即可。 You can start the server.
Create New shortcut to the client, start the parameter bit [B]/L192.168.1.200: 11002 [/B]
As you see the original guide is a bit confusing, im stuck at Server step 2 intiate this server from the game server running process

Please if anyone can help me to run this server will be appreciated

I have the database propely installed and the oracle client is running, i have tried this in a Windows Xp Pro x86 and a Windows Server 2008 x64 and same results with both systems.

Im ok sharnig my files to anyone which want to help me to make this running.

Thanks for reading
Step 2 Is you open SQL Plus,Log in with alef, password, account, And Do the commands :

Create user alef IDENTIFIED BY passowrd;

ETC.



Where did you get this tut?
its not Complete.


Mike0505 ∞ is offline  
Thanks
2 Users
Old   #5
 
elite*gold: 0
Join Date: Jul 2010
Posts: 141
Received Thanks: 14
Lol good thing you pointed that out i was about to follow it
Mustlord59 is offline  
Old   #6
 
elite*gold: 0
Join Date: Jan 2008
Posts: 160
Received Thanks: 126
i dont mean to step 2 of the guide, i mean when you run the gameserver process the console say step 4 complete step 3 complete and step 2 (crash) thats my point.

Screen:

You must register and activate your account in order to view images.

I have copy/paste the full guide so i dont know why you say its not full.

Do you have an expensive guide than this?

If yes would be great to share it with us please

Note that this is not my guide and my intention its to help not to confuse anyone
archknup is offline  
Old   #7
 
elite*gold: 0
Join Date: Nov 2007
Posts: 325
Received Thanks: 280
yeah, I have my own Guide..
I'm going off memory..
But This guide is not Full..
Mike0505 ∞ is offline  
Thanks
1 User
Old   #8
 
elite*gold: 0
Join Date: Jul 2010
Posts: 141
Received Thanks: 14
First you have to run Cal_loginserver Cal_relayserver and Cal_worldserver and you had to delete all obj and obs files in the ini folder, and if that does not work Mike said its not complete so there are missing components of the server just wait till next week

And mike the first part of your tutorial should be how to install the database so we can have a foundation to work with
Mustlord59 is offline  
Old   #9
 
elite*gold: 0
Join Date: Nov 2007
Posts: 325
Received Thanks: 280
If its Crashing Use The Celestia Archlord - Server Files Update package
Mike0505 ∞ is offline  
Thanks
1 User
Old   #10
 
elite*gold: 0
Join Date: Jan 2008
Posts: 160
Received Thanks: 126
I used both of it same results :P

I removed the obs and obj files when using celestia and same result

Also i edited the dbserverinfo.ini and database.ini with my data and encrypted again

Any ideas? :P
archknup is offline  
Old   #11
 
elite*gold: 0
Join Date: Nov 2007
Posts: 325
Received Thanks: 280
Wait for my Guide..
I'm not sure where you went wrong sorry.

Heading out to visit my mother.
be back in a few hours guys.
Mike0505 ∞ is offline  
Old   #12
 
elite*gold: 0
Join Date: Apr 2010
Posts: 106
Received Thanks: 4
omg FAIL


HIS TUTORIAL DONT WORK

SO GOOD LUCK WITH WINDOWS XP NEVER CAN RUN ON IT


HAHAHA
.Monster! is offline  
Old   #13
 
elite*gold: 0
Join Date: Jan 2008
Posts: 61
Received Thanks: 5
Quote:
Originally Posted by Bigbears View Post
omg FAIL


HIS TUTORIAL DONT WORK

SO GOOD LUCK WITH WINDOWS XP NEVER CAN RUN ON IT


HAHAHA
fail...

all files is exe or bat: windows extensions
darkneika is offline  
Old   #14
 
elite*gold: 0
Join Date: Dec 2008
Posts: 213
Received Thanks: 62
Quote:
Originally Posted by Bigbears View Post
omg FAIL


HIS TUTORIAL DONT WORK

SO GOOD LUCK WITH WINDOWS XP NEVER CAN RUN ON IT


HAHAHA
Go back to your Nlgames server ******.
xnvidia is offline  
Thanks
2 Users
Old   #15
 
elite*gold: 0
Join Date: Oct 2008
Posts: 722
Received Thanks: 159
Quote:
Originally Posted by Bigbears View Post
omg FAIL


HIS TUTORIAL DONT WORK

SO GOOD LUCK WITH WINDOWS XP NEVER CAN RUN ON IT


HAHAHA
can i request a ban for this idiot
reason: for being an idiot lol


Ne(da) is offline  
Thanks
2 Users
Reply



« Previous Thread | Next Thread »

Similar Threads
Server Files and Tutorial to create your server in local
Hi, In this link there are the files and the tutorials to create your private server ace online !!!!!!!!!! h t t p : / / f o r u m . r a g e...
3 Replies - Ace Online / AirRivals
[Tutorial]Create your own COD Emulation Server
After all this downtime with the official AlterIW Net Server, are you tired of just sitting there all day? Once you're done with this tutorial,...
0 Replies - General Gaming Discussion
[Help] Need help to create private server
Well, I would need some help, and could someone tell me what I shall use for coding like C++, C# etc... for beginners. PM me if u are a nice coder...
3 Replies - CO2 PServer - Discussions / Questions



All times are GMT +1. The time now is 00:16.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.