Let's Create a New Ran Server

Help me put aup a new Ran Private Server ^_^
 
HomePortalFAQSearchRegisterMemberlistUsergroupsLog in

Share | 
 

 [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)

Go down 
AuthorMessage
rihom



Number of posts : 8
Registration date : 2007-09-21

PostSubject: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Mon Oct 15, 2007 8:40 pm

Latest 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


SQL Database : Backup Restore method and Attaching Database method is now replaced with SQL Scripts that will create the New and fresh database. Try to observe the UserNum ^^.
==============================
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

Install MSSQL 2005 Management Studio Express
http://go.microsoft.com/fwlink/?LinkId=65110
Server Files :
Quote:

Package RAN Server Files
ShareBig - Share Big Files Fast

SQL Script Database for using SQL Express 2005 [20kb]
http://ianznet.110mb.com/ran/sql_2k5.zip

SQL Script Database for using SQL Server 2000 [20kb]
http://ianznet.110mb.com/ran/sql_2k.zip


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/RanOnline_1.0.5.1(SP1)_Full(070524)(GBK).exe [Server Available]

Making New Database
Quote:

Creating New Database
For SQL Express 2005
1. on SQL Server Script Open your RanGame1.sql, SQL Management Studio
will open automatically.
2. Press Connect..
3. then Press Execute[!], wait until analyzing is complete.
4. Refresh on database.
5. Same on RanLog.sql, RanShop.sql and RanUser.sql

For SQL Server 2000
1. On Enterprise manager , Open Query Analyzer.
2. Open RanGame1.sql
3. then Press Execute[!] or Play button, wait until analyzing is complete
4. Same on RanLog.sql, RanShop.sql and RanUser.sql

ODBC Settings
Quote:
Download and Merge by opening the file

for Users using SQL 2005 Express
http://ianznet.110mb.com/ran/odbc2k3.reg

for Users using SQL 2000
http://ianznet.110mb.com/ran/odbc2k.reg

How to configure RAN Server?
--------------------------------------
Quote:

1. Open CFG folder inside your ran server (example: D:\ranserver\cfg\)
2. Open agent.ini ,session.ini,field0.ini and login.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 [1-9999999%]
/eventexp_end
/eventitem_begin [1-9999999%]
/eventitem_end
/eventmoney_begin [1-9999999%]
/eventmoney_end

Fun:

/bighead [on / off] = All Online Characters in Bighead
/bighand [on / off] = All Online Characters in Big Hands(same as weapons too)

Characters managements:

/charinfo_cn [character Name] = Shows the character information
/kickuser [character ID] = allows to disconnect user
/charinfo_ci [character ID] = character Information by character ID
/charinfo_cn [character Name] = character Information by character Name
/chatblock_cn [character Name] = block character by character Name
/chatblock_ci [charID] = block character by character ID
/chatblock_ua [UserAccount] = block users account

Move commands:

/move2gate [0-99] = Move to available map gate
/m2g [0-99]
/move2pos [##,##,X,Y] = Move to a coordinate
/m2p [##,##,X,Y]
/move2char [character name] = Move to Online Character
/m2c [character name]

Note: maps code (#) can be found on maps.list or maps.ini

Other Commands:

/freepk [on / off]
/visible [on / off]
/m2c [character Name]
/move2char [character Name]
/itemhold
/month [1-12]
/time [1-24]
/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.


Load New Map on a particular Map Field

/lev_new w_Total_suryun_01.Lev
/lev_del
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 (Optional )
=============

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


Last edited by rihom on Mon Feb 25, 2008 10:53 am; edited 1 time in total
Back to top Go down
View user profile
shezzo08

avatar

Number of posts : 2
Registration date : 2007-10-25

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Fri Oct 26, 2007 3:51 am

Quote :
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!



this part is confusing....
Exclamation
can someone discuss this part clear...? Question
Back to top Go down
View user profile
buldog123



Number of posts : 2
Registration date : 2007-10-31

PostSubject: waaaa   Wed Oct 31, 2007 7:07 pm

san ko makita yung Open MSSQL Management Studio 2005
Back to top Go down
View user profile
Xiao

avatar

Number of posts : 28
Age : 30
Localisation : Heaven
Registration date : 2007-06-28

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Sat Dec 01, 2007 1:17 pm

cool thanks ^.~ lol!

_________________
Back to top Go down
View user profile http://www.friendster.com/xiaomecute
rihom



Number of posts : 8
Registration date : 2007-09-21

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Mon Feb 25, 2008 10:56 am

For those who have experience an errors...
pls go to this site:
http://newranservercreation.forumotion.com/server-creation-f2/common-errors-t54.htm
Back to top Go down
View user profile
nielzpetre



Number of posts : 2
Registration date : 2008-03-29

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Sat Mar 29, 2008 8:43 pm

bt kinopy paste mu galing sa ragezone forums??
Back to top Go down
View user profile
xXxDarkLorDxXx



Number of posts : 18
Registration date : 2008-04-06

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Mon Apr 07, 2008 2:00 pm

rihom wrote:
Latest 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


SQL Database : Backup Restore method and Attaching Database method is now replaced with SQL Scripts that will create the New and fresh database. Try to observe the UserNum ^^.
==============================
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

Install MSSQL 2005 Management Studio Express
http://go.microsoft.com/fwlink/?LinkId=65110
Server Files :
Quote:

Package RAN Server Files
ShareBig - Share Big Files Fast

SQL Script Database for using SQL Express 2005 [20kb]
http://ianznet.110mb.com/ran/sql_2k5.zip

SQL Script Database for using SQL Server 2000 [20kb]
http://ianznet.110mb.com/ran/sql_2k.zip


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/RanOnline_1.0.5.1(SP1)_Full(070524)(GBK).exe [Server Available]

Making New Database
Quote:

Creating New Database
For SQL Express 2005
1. on SQL Server Script Open your RanGame1.sql, SQL Management Studio
will open automatically.
2. Press Connect..
3. then Press Execute[!], wait until analyzing is complete.
4. Refresh on database.
5. Same on RanLog.sql, RanShop.sql and RanUser.sql

For SQL Server 2000
1. On Enterprise manager , Open Query Analyzer.
2. Open RanGame1.sql
3. then Press Execute[!] or Play button, wait until analyzing is complete
4. Same on RanLog.sql, RanShop.sql and RanUser.sql

ODBC Settings
Quote:
Download and Merge by opening the file

for Users using SQL 2005 Express
http://ianznet.110mb.com/ran/odbc2k3.reg

for Users using SQL 2000
http://ianznet.110mb.com/ran/odbc2k.reg

How to configure RAN Server?
--------------------------------------
Quote:

1. Open CFG folder inside your ran server (example: D:\ranserver\cfg\)
2. Open agent.ini ,session.ini,field0.ini and login.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 [1-9999999%]
/eventexp_end
/eventitem_begin [1-9999999%]
/eventitem_end
/eventmoney_begin [1-9999999%]
/eventmoney_end

Fun:

/bighead [on / off] = All Online Characters in Bighead
/bighand [on / off] = All Online Characters in Big Hands(same as weapons too)

Characters managements:

/charinfo_cn [character Name] = Shows the character information
/kickuser [character ID] = allows to disconnect user
/charinfo_ci [character ID] = character Information by character ID
/charinfo_cn [character Name] = character Information by character Name
/chatblock_cn [character Name] = block character by character Name
/chatblock_ci [charID] = block character by character ID
/chatblock_ua [UserAccount] = block users account

Move commands:

/move2gate [0-99] = Move to available map gate
/m2g [0-99]
/move2pos [##,##,X,Y] = Move to a coordinate
/m2p [##,##,X,Y]
/move2char [character name] = Move to Online Character
/m2c [character name]

Note: maps code (#) can be found on maps.list or maps.ini

Other Commands:

/freepk [on / off]
/visible [on / off]
/m2c [character Name]
/move2char [character Name]
/itemhold
/month [1-12]
/time [1-24]
/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.


Load New Map on a particular Map Field

/lev_new w_Total_suryun_01.Lev
/lev_del
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 (Optional )
=============

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
where willi put this:
Events:

/eventexp_begin [1-9999999%]
/eventexp_end
/eventitem_begin [1-9999999%]
/eventitem_end
/eventmoney_begin [1-9999999%]
/eventmoney_end

Fun:

/bighead [on / off] = All Online Characters in Bighead
/bighand [on / off] = All Online Characters in Big Hands(same as weapons too)

Characters managements:

/charinfo_cn [character Name] = Shows the character information
/kickuser [character ID] = allows to disconnect user
/charinfo_ci [character ID] = character Information by character ID
/charinfo_cn [character Name] = character Information by character Name
/chatblock_cn [character Name] = block character by character Name
/chatblock_ci [charID] = block character by character ID
/chatblock_ua [UserAccount] = block users account

Move commands:

/move2gate [0-99] = Move to available map gate
/m2g [0-99]
/move2pos [##,##,X,Y] = Move to a coordinate
/m2p [##,##,X,Y]
/move2char [character name] = Move to Online Character
/m2c [character name]

Note: maps code (#) can be found on maps.list or maps.ini

Other Commands:

/freepk [on / off]
/visible [on / off]
/m2c [character Name]
/move2char [character Name]
/itemhold
/month [1-12]
/time [1-24]
/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.


Load New Map on a particular Map Field

/lev_new w_Total_suryun_01.Lev
/lev_del
and the others command
Back to top Go down
View user profile
xXxDarkLorDxXx



Number of posts : 18
Registration date : 2008-04-06

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Mon Apr 07, 2008 2:13 pm

rihom wrote:
Latest 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


SQL Database : Backup Restore method and Attaching Database method is now replaced with SQL Scripts that will create the New and fresh database. Try to observe the UserNum ^^.
==============================
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

Install MSSQL 2005 Management Studio Express
http://go.microsoft.com/fwlink/?LinkId=65110
Server Files :
Quote:

Package RAN Server Files
ShareBig - Share Big Files Fast

SQL Script Database for using SQL Express 2005 [20kb]
http://ianznet.110mb.com/ran/sql_2k5.zip

SQL Script Database for using SQL Server 2000 [20kb]
http://ianznet.110mb.com/ran/sql_2k.zip


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/RanOnline_1.0.5.1(SP1)_Full(070524)(GBK).exe [Server Available]

Making New Database
Quote:

Creating New Database
For SQL Express 2005
1. on SQL Server Script Open your RanGame1.sql, SQL Management Studio
will open automatically.
2. Press Connect..
3. then Press Execute[!], wait until analyzing is complete.
4. Refresh on database.
5. Same on RanLog.sql, RanShop.sql and RanUser.sql

For SQL Server 2000
1. On Enterprise manager , Open Query Analyzer.
2. Open RanGame1.sql
3. then Press Execute[!] or Play button, wait until analyzing is complete
4. Same on RanLog.sql, RanShop.sql and RanUser.sql

ODBC Settings
Quote:
Download and Merge by opening the file

for Users using SQL 2005 Express
http://ianznet.110mb.com/ran/odbc2k3.reg

for Users using SQL 2000
http://ianznet.110mb.com/ran/odbc2k.reg

How to configure RAN Server?
--------------------------------------
Quote:

1. Open CFG folder inside your ran server (example: D:\ranserver\cfg\)
2. Open agent.ini ,session.ini,field0.ini and login.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:
where will i put this ---->>>
Events:

/eventexp_begin [1-9999999%]
/eventexp_end
/eventitem_begin [1-9999999%]
/eventitem_end
/eventmoney_begin [1-9999999%]
/eventmoney_end

Fun:

/bighead [on / off] = All Online Characters in Bighead
/bighand [on / off] = All Online Characters in Big Hands(same as weapons too)

Characters managements:

/charinfo_cn [character Name] = Shows the character information
/kickuser [character ID] = allows to disconnect user
/charinfo_ci [character ID] = character Information by character ID
/charinfo_cn [character Name] = character Information by character Name
/chatblock_cn [character Name] = block character by character Name
/chatblock_ci [charID] = block character by character ID
/chatblock_ua [UserAccount] = block users account

Move commands:

/move2gate [0-99] = Move to available map gate
/m2g [0-99]
/move2pos [##,##,X,Y] = Move to a coordinate
/m2p [##,##,X,Y]
/move2char [character name] = Move to Online Character
/m2c [character name]

Note: maps code (#) can be found on maps.list or maps.ini

Other Commands:

/freepk [on / off]
/visible [on / off]
/m2c [character Name]
/move2char [character Name]
/itemhold
/month [1-12]
/time [1-24]
/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.


Load New Map on a particular Map Field

/lev_new w_Total_suryun_01.Lev
/lev_del
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 (Optional )
=============

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
[b]
Back to top Go down
View user profile
xXxDarkLorDxXx



Number of posts : 18
Registration date : 2008-04-06

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Mon Apr 07, 2008 5:12 pm

shezzo08 wrote:
Quote :
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 :

I CANT FIND IT
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!



this part is confusing....
Exclamation
can someone discuss this part clear...? Question
Back to top Go down
View user profile
kornydeathnote



Number of posts : 1
Registration date : 2009-01-08

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Thu Jan 08, 2009 9:52 pm

where i will put that>?
Back to top Go down
View user profile
creator667



Number of posts : 2
Registration date : 2009-03-07

PostSubject: elow uhmm...   Sat Mar 07, 2009 12:21 pm

please send a complete details; or download nalang namen

pati ung laman pls ^^


e2 nalang problem ko ung ODBC





Back to top Go down
View user profile
dav1988



Number of posts : 1
Registration date : 2009-04-13

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Mon Apr 13, 2009 6:54 pm

i wanna ask tat if i download all the things...so i follow the instruction...it is might be work to having my own ranserver and play on LAN?
Back to top Go down
View user profile
terrorista_01



Number of posts : 1
Registration date : 2009-06-02

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Tue Jun 02, 2009 8:55 pm

can you teLL me why this:
Install MSSQL 2005 Management Studio Express
http://go.microsoft.com/fwlink/?LinkId=65110

make my pc restart automaticaLy??!... thnxz
Back to top Go down
View user profile
huxuan



Number of posts : 1
Registration date : 2009-06-04

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Thu Jun 04, 2009 10:14 am

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

can you discuss this clearly....

TY
Back to top Go down
View user profile
ize3n

avatar

Number of posts : 13
Registration date : 2009-06-09

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Tue Jun 09, 2009 10:40 pm

well so may things to be discuss.. better kung

::Paid server Developer::
:::contact me at: ize3n@yahoo.com (YM)
:::hope i can help a little bit::
Back to top Go down
View user profile
toinker19



Number of posts : 11
Registration date : 2010-05-25

PostSubject: New Website   Tue May 25, 2010 1:33 pm

Maybe this site Can Help You

http://createranonline.forumotion.com
Back to top Go down
View user profile
achron

avatar

Number of posts : 8
Localisation : In Ur HearT
Registration date : 2012-04-14

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Sun Apr 15, 2012 9:28 am

creator667 wrote:
please send a complete details; or download nalang namen

pati ung laman pls ^^


e2 nalang problem ko ung ODBC







double check ur CFG files, or rename your server files contained folder to Server Files
Back to top Go down
View user profile
ho0l19an09



Number of posts : 1
Registration date : 2012-09-08

PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   Sat Sep 08, 2012 1:53 pm

SIR, WALA NA PO KAMI MA DOWNLOAD NA CLIENT.... PWEDE PO BA NA MAG COPY NALANG? KUNG PWEDE PO, PAANO? THANKS

Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question
Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question
Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question
Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question
Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question
Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question
Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question
Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question Question
Back to top Go down
View user profile
Sponsored content




PostSubject: Re: [GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)   

Back to top Go down
 
[GUIDE] HOW TO MAKE YOUR OWN SERVER.........(UPDATED)
Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
Let's Create a New Ran Server :: Server Creation-
Jump to: