|
|
Requirements:
Oracle9i version
Navicat Premium (Recommended)
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)
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)
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:\SQL\ACCOUNT.sql;
@C:\SQL\RPGWT.sql;
@C:\SQL\SERVERCONFIG.sql;
exit;
go to start/run/and write cmd.... write in ipconfig
you need have lan (internet with cable connection) to work.
copy the ip adress from lan connection
its something like 192.168.116.xxx
copy that to document notepad @THE IP ADRESS@
Next
Use Navicat: and go to
Tools => Options => OCI => Oci library: C:\oracle\ora92\bin\oci.dll
Create connection with :
global database name: what you want
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 the ip adress of the server.
Section 1000, ADDRESS attribute is yourip:xxxxx
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 name of server.
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 = YOURIP) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = account)
)
)
For INST1_HTTP specify host for @your ip@ ! In TNSNAMES.ORA also.
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) / @TO ENTER IN GAME <)@
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','[Only registered and activated users can see links. ]','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,N,N,null);
go show hide folder in server files
turn down firewall
go to windowsupdate and see if you need update something BECAUSE YOU NEED UPDATE YOUR PC
TO THE NEXT STEP
next go to server files and
first go / Start CAL_LoginServer.exe, wait until it finishes.
second go / Start CAL_RelayServer.exe, wait until it finishes.
last go / Start CAL_WorldServer.exe, wait until it finishes.
(IF GIVES YOU ERROR, YOU NEED SEE THE REQUIREMENTS AGAIN, TO SEE IF ANY THING IS MISSING)
Go to archlord folder, in my case it's : C:\Program Files\Archlord Celestia
Create text file and add: alefclient.exe /Lyourip:11002 (ip adress of the server in LAN)
Rename it in .bat, make shortcut in desktop and launch !
YOU MUST HAVE THE CORRECT CLIENT !
have fun >D
visit [Only registered and activated users can see links. Click Here To Register...]
so ty for watching and go play >D
Orcale9i
cd1 : [Only registered and activated users can see links. Click Here To Register...]
cd2 : [Only registered and activated users can see links. Click Here To Register...]
cd3 : [Only registered and activated users can see links. Click Here To Register...]
MUSIC LIST
0:00 - 4:38 - Mt Eden Dubstep - Still Alive -->http://www.youtube.com/watch?v=FDYIdBZUl2Y<--
4:39 - 8:17 - Mt Eden Dubstep - Beautiful Lies -->http://www.youtube.com/watch?v=uZnpikoHNWw&feature=related<--
8:18 - 11:52 - Mt Eden Dubstep - Madonna: Frozen -->http://www.youtube.com/watch?v=JoBRbtAnbVM&feature=related<--
11:53 - 16:00 - Mt Eden Dubstep - Chicane -->http://www.youtube.com/watch?v=V_OTPV5o954<--
16:01 - 20:30 - Emalkay - When I Look At You -->http://www.youtube.com/watch?v=_mwL6R-Z1e4<--
20:31 -23:45 - Burial - Mt Eden Dubstep -->http://www.youtube.com/watch?v=8VZG1ANKeGs<--
23:46 - 28:31 - Mt Eden Dubstep - Sarah McLachlan: Silence -->http://www.youtube.com/watch?v=Nymjfq2kXnI&feature=related<--
28:32 - 31:42 - Mt Eden Dubstep - Sierra Leone -->http://www.youtube.com/watch?v=16bRiH5zfOY&feature=related<--
ALL IN YOUTUBE :D