Making On9 Game

FIle Updates

Quote:

inside Glogic Update Both Server, Client and Editors
itemstrtable.ini
skillstrtable.ini
crowstrtable.ini
busstation.ini
maps.ini
comment.ini

For Game.exe in Client
param.ini

==============================
NEW RAN Server Setup Guide
==============================

Required Programs :

Quote:

Install .NET Framework 2.0 (dotnetfx.exe)
Download details: .NET Framework Version 2.0 Redistributable Package (x86)

Install MSSQL 2005 Express Edition
http://go.microsoft.com/fwlink/?LinkId=65212

MSSQL Management Studio Express
http://go.microsoft.com/fwlink/?LinkId=65110

Server Files :

Quote:

Package RAN Server Files
ShareBig - Share Big Files Fast

or

RAN Server Files with RANSTART [4MB]
http://ianznet.110mb.com/ran/svr_files.zip

RAN EDIT Tools [4MB]
http://ianznet.110mb.com/ran/svr_edit.zip

RAN SQL BACKUP Database [700kb]
http://ianznet.110mb.com/ran/svr_sql.zip

RAN Client Patch [2MB]
http://ianznet.110mb.com/ran/svr_client.zip

Patch for English Glogic,Quest and NPCtalk [1MB]
http://ianznet.110mb.com/ran/patch.zip

Chose your client to Download (use as client and data on server) [500MB or greater ]

http://down.sgho.net/SghoRanfullClient.rar [Server Down]
http://ran.sgho.net/SghoRanfullClient.rar [Server Down]
http://down.moyuran.com/moyuran.rar [Server Available]
http://down4.ranonline.com.cn/RanOnl…0524)(GBK).exe [Server Available]

Server files Packed:

Quote:

Ran Data files for MSQL Manager.
randata.rar - FileFront.com

http://forum.ragezone.com/f248/release-ran-server-291561/

Files Inside:

Ranserver
Ran ODBC
RanLink
RanStart
GMCharEditor
php.ini (use for appserv)

RanShop.back
RanShop.rar - FileFront.com

New link for the Ran Server files and Ran data:

Quote:

Server_SetUp.rar - FileFront.com

For Ran Client

http://down4.ranonline.com.cn/RanOnline_1.0.5.1(SP1)_Full(070524)(GBK).exe

How to Attach SQL Database?
————————————–

Quote:

1. Open MSSQL Management Studio 2005
2. Login using Windows Authentication
3. Right click Database, Select New Database
4. Create New Database from this name’s RanShop, RanLog, RanUser
5. Create New Datavase for RanGame1 and
Set Logical name RanGame1P_Data, RanGame1_log and
Click Add and Set it to RanGame1S_Data , click OK

5. Right click RanGame1, Select Task > Restore > Database
6. Chose From Device , Click Button , Click Add , add the rangame1.bak
7. Check rangame1 then go to Options
8. In Restore Options check the Overwrite existing database
9. click OK
10. Do the same until RanUser

How to configure RAN Server?
————————————–

Quote:

1. Open CFG folder inside your ran server (D:\ranserver\cfg\)
2. Open agent.ini with notepad.
3. Change 127.0.0.1 to your IP Address (example: 192.168.0.1 - LAN IP)
4. Dont change 127.0.0.1 if you have to play offline
5. Change user_odbc_user and user_odbc_pass to your windows login account
6. Change user from
database settting
game database setting
log database
shop database

7. Do it the same procedure to field, login, and session.
8. You have now your RAN server config success.

How to configure DATA folder of your RAN Server?
———————————————–

Quote:

1. Go to Data folder of your client. (Usually it is in C:\Program files\e-games\RAN\data\)
2. Copy this following folder from your client to server data folder

glogic
object
skinobject
gui
skin,
effect
map
skeleton
editor
animation
piece

(this folders are found in your client data folder)

3. Double check your settings.
4. You are now ready to run the ran server.

How to run RAN Server?
———————-
1. Session Server
2. Login Server
3. Field Server
4. Agent Server

Commands for GM
————————————–

Quote:

Events

/eventexp_begin + percentage (9999999)max
/eventexp_end
/eventitem_begin + percentage (9999999)max
/eventitem_end
/eventmoney_begin + percentage (9999999)max
/eventmoney_end

Misc Events:

/bighead on(on/off) = All Online Characters change in Bighead
/bighand on(on/off) = Big Hands on all Online chars(same as weapons too):

Characters managements:

/charinfo_cn +character name = Shows the character information
/kickuser +chaid = allows to disconnect user

Move commands:

/move2gate +gatecode (quick spelling is :/m2g) = Move to a gate
/m2g
/move2pos +mapindex+0+X+Y (quick spelling:/m2p) = Move to a coordinate
/m2p
/move2char +charname(quick spelling:/m2c) = Character trace
/m2c

Other Commands:

/freepk [on / off]
/charinfo_ci
/charinfo_cn
/chatblock_cn
/chatblock_ci
/chatblock_ua
/kickuser [charname]
/visible [on / off]
/m2c [charname]
/move2char [charname]
/itemhold
/month
/time
/weather clear and off clear none leave spore snow begin rain
/fps_limit [on / off]
/where_npc
/dsp

Summoning Monsters:

/mob_gen 62,2,14,14

the 62,2 is the mob id while the 14,14 is the coordinates.

/lev_new w_Total_suryun_01.Lev
/lev_del

Load New Group of Monster on a particular Field

GM Character Edit (GMCharEdit.exe)
———————————————–

Quote:

Open up your SQL Manager, whatever it is that you use and head to the RanUser database.
Now, open the ServerGroup table. Below are the values you need to fill in:-

SGNum : 1
SGName : Whatever you want your server name
OdbcName : RanGame1
OdbcUserID :
OdbcPassword :
OdbcLogName : RanLog
OdbcLogUserID :
OdbcLogPassword :

Once done, open up the ServerInfo table in the RanUser database.
Then put in these values.

SGNum : 1
SvrNum : 1
SvrType : 4

Now, run the GMCharEdit. If this is your first time running it
you’ll see 4 fields to input information.

First field : RanUser
Second field : your windows username
Third field : your windows password
Fourth field : your windows password

Now all you need is a GM account make an account with UserType 30 in the UserInfo table, Full

control of GMCharEdit.exe..
Just key that in and watch as it automatically connects!

Trigger Codes
=============

Here’s the Trigger Code for Starting Character Level,Stats,Skill Points,Money and etc…

HERE ARE THE STEPS…

1. Open/Login you SQL Server Management Studio
2. Expand the Databases Group
3. Expand the RanGame1 Database
4. Select New Query from the toolbar
5. From the New Query window on the right pane, copy and paste this SQL Trigger Code…

Put this code direct to the SQL Query
Open ur SQL Queries then put this code Choose the RanGame1 table
for SQL2005 right click the RanGame1 ,select New Queries

Quote:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

– ================================================== ====
– Author: IaNz
– Create date: –,–,–
– Description: Starting Character Level,Skill and Stat Points
– Dex,Pow,Int,Vit,Stm and Money
– Note : If you have existing trigger replace CREATE TRIGGER
– to ALTER TRIGGER
– ================================================== ====

CREATE TRIGGER [dbo].[NewChar_Level] ON [dbo].[ChaInfo]
after update
as
BEGIN

Update [ChaInfo] set [ChaInfo].ChaLevel=100
From Inserted
Where Inserted.ChaLevel = 1 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaSkillPoint=1500
From Inserted
Where Inserted.ChaSkillPoint = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaStRemain=1500
From Inserted
Where Inserted.ChaStRemain = 3 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaMoney=1000000
From Inserted
Where Inserted.ChaMoney = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

END

ODBC Settings

Quote:

1. Go to Control Panel > Administrative tools
2. Open Data Sources (ODBC)
3. On UserDSN tab, Click Add
4. Select SQL Native and Press Finish

5. Window “Create a New Data Source to SQL Server ” appears
On Name : RanUser
On Server : IANZ-PC\SQLEXPRESS

6. Press NEXT
7. Then Press NEXT Again
8. Check then ‘change default database to’
9. set it to RanUser

same procedure for RanShop,RanLog and RanUser………….

END!!!

ScreenShot of the game:

ran200709090348001nz0.jpg