Ran Private Server Guide for ep3 and ep4

How To Make Your Own Ran Private Server (EP3 & EP4) Taglish Edition by [GM]Light

---

=====================================================
RAN Server Setup Guide - Updated : as of November 14, 2010
EP3 & EP4 Version
=====================================================

Required Programs (Mga kailangan na mga files) :

Quote:

SQL 2005 Express Install .NET Framework 2.0 (dotnetfx.exe) Download Here Install MSSQL 2005 Express Edition Download Here Install MSSQL Management Studio Express Download Here OR Install Microsoft .NET Framework 3.5 Download here (Install this) Install Microsoft® SQL Server® 2008 Express Download here (Install this) Install Microsoft® SQL Server® 2008 Management Studio Express Download here (Install this, If you have a problem Installing SQLserver2005_ssmsee Download msxml6 and Install it) Install Microsoft Core XML Services (MSXML) 6.0 Service Pack 1 Download here ( pagkatapos ng installation, buksan ang SQL server Management Studio Express, server type=(wag palitan), server name= (wag palitan), authentication=SQL server authentication, login=sa, password=1234 click remember password and then click connect when done click x bottton means close) ” you are now finished creating an account on SQL server 2005. This is your default login on SQL server 2005″

Server Files :

"EP3 Server Files "

Quote:

AVAILABLE DATABASE VERSIONS SQL Script Database for using SQL Express 2005 Download Here - updated http://www.ziddu.com/downloadfile/2258339/odbc2k5.rar.html SQL Script Database for using SQL Server 2000 Download Here - updated RAN Server Files [4MB] Download Here RAN Tools and Editors[4MB] Download Here RAN Patch Client [2MB] Download Here Patch for English Glogic, Quest and NPCtalk [1MB] Download Here Kung gusto niyo ng compact files, try niyo gamitin to para sa ep3: http://www.filefactory.com/file/481c19/n/RanServer_rar http://www.ziddu.com/download/2172735/RanServer.rar.html Ran Client http://adf.ly/1NcmQ

=================================================================

"EP4 Server Files"

Quote:

AVAILABLE DATABASE VERSIONS SQL Script Database for using SQL Express 2005 Download Here for SQL 2005 RAN Server Files [14MB] Download Here RAN Client Patch[2MB] Download Here Tungkol nga pala sa Ran Client ep4, hanap na lang kayo ng ibang pwedeng pagkuhanan kasi yung mga dating links wala na... ;-(

1st Database Guide

Quote: Creating new database

For SQL Express 2005 1. click mo ang RanServer folder may makikita kang SQL 2005 folder,,sa loob nito may makikita kang RanGame1_2k5, RanLog1_2k5, RanShop1_2k5, RanUser1_2k5. 2. click mo sila bawat isa a. RanGame1 -then Press Execute[!], wait until analyzing is complete b. RanLog1 -then Press Execute[!], wait until analyzing is complete c. RanShop1 -then Press Execute[!], wait until analyzing is complete d. RanUser1 -then Press Execute[!], wait until analyzing is complete 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 OR Restoring Backup Database (kung may ep3 server na gawa niyo) 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 6. Right click RanGame1, Select Task > Restore > Database 7. Chose From Device , Click Button , Click Add , add the rangame1.bak 8. Check rangame1 then go to Options 9. In Restore Options check the Overwrite existing database 10. click OK 11. Repeat #6, Same on RanUser, RanShop and RanLog

2nd ODBC Settings

Quote:

This is an Automatic Registry Setup for your ODBC. you do not need to configure it manually. Just chose your SQL version, Download it and press right click then Press Merge. for Users using SQL 2005 Express - updated ODBC Settings For SQL 2005 for Users using SQL 2000 -updated ODBC Settings For SQL 2000

3rd How to configure RAN Server Files?

Quote:

1. Buksan ang CFG folder mismo sa Ran na na-install niyo. Example: AtongRan 2. Buksan ang agent.ini, session.ini, field0.ini and login.ini. 3. Palitan ang 127.0.0.1 sa iyong IP Address (example: 192.168.0.1 - LAN IP). Wag mo na palitan yung IP address kung gusto maglaro ng offline 4. Gawin rin ito sa field, login, and session. 5. Meron ka nang RAN server. Yehey!!! Note: odbc_user and odbc_pass can also be empty if it is Windows Authentication

4th How to configure DATA folder of your RAN Server?

Quote:

1. Pumunta sa data folder ng iyong client. 2. Copy this following folder from your client to server data folder (kopyahin lang ang mga sumusunod na file mula sa client na-install mo tapos paste mo siya sa server data folder) Animation Editor Effect Glogic Gui Map Object Piece Skeleton Skin SkinObject (makikita to sa client data folder mo) 3. Siguraduhing tama ang lahat ng settings. 4. Pwede mo na paganahin ang ran server.

5th How to run RAN Server?

Quote:

una punta ka sa folder ng RanServer tapos hanapin ang icon na Session Server click mo xa tapos start ready…. pangalawa ang Login Server click mo xa tapos start ready…. Pangatlo ang Field Server click mo xa tapos start ready…. Pang apat ang Agent Server click mo xa tapos start ready…. Ok reading ready na….

EP3 Game 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: /kickuser [CharID] = allows to disconnect user /charinfo_ci [CharID] = Shows the character information by character ID /charinfo_cn [CharName] = Shows the character information by character name Move Commands: /move2char [CharName] = Move to Online Character /m2c [CharID] /move2gate [0-99] = Move to available map gate /m2g [0-99] /move2pos [##,##,X,Y] = Move to a coordinate /m2p [##,##,X,Y] Other Commands: /fps_limit [on/off] /freepk [on/off] /visible [on/off] /itemhold /visible [on/off] = character visibility /month [1-12] = Set Month in number /time [1-24] = Set Time in 24 hour clock /weather [clear/snow/begin/spore/leave] /dsp /?

EP4 Game Commands for GM

Quote:

Events: /eventexp_begin [1-9999999%] /eventexp_end /eventitem_begin [1-9999999%] /eventitem_end /eventmoney_begin [1-9999999%] /eventmoney_end /event_ex_begin [speed/aspeed/attack] /event_ex_end [speed/aspeed/attack] Fun: /bighead [on / off] = All Online Characters in Bighead /bighand [on / off] = All Online Characters in Big Hands(same as weapons too) Characters Managements: /kickuser [CharID] = allows to disconnect user /charinfo_ci [CharID] = Shows the character information by character ID /charinfo_cn [CharName] = Shows the character information by character name /chatblock_ci [CharID, minute] = block character in minutes by character ID /chatblock_cn [CharName, minute] = block character in minutes by character name /chatblock_ua [uaccount, minute] = block character in minutes by user acount /genchar_ci [charID] /genchar_cn [CharName] Move commands: /move2char_cn [CharName] = Move to Online Character /move2char_ci [CharName] = Move to Online Character /m2c_ci [CharID] /m2c_cn [Charname] /move2gate [0-99] = Move to available map gate /m2g [0-99] /move2pos [##,##,X,Y] = Move to a coordinate /m2p [##,##,X,Y] Note: maps code (#) can be found on maps.list or maps.ini Other Commands: /server [delay/level1/level2/force/shutdown] /weather [clear/snow/begin/spore/leave] /freepk_on /freepk_off /warning_msg [on/off] /profile [on/off] /pk_mode [on/off] /visible [on/off] = character visibility /month [1-12] = Set Month in number /time [1-24] = Set Time in 24 hour clock /itemhold /mob_del_ex /mob_del /mob_gen_ex /mob_gen /where_npc /dsp /for /whois /? = Emote Icons Summoning Mobs: /mob_gen 62,2,14,14 the 62,2 is the mobID that can be found on CrowStrTable.txt while the 14,14 is the coordinates that can be seen on top of screen compass Loading & Unloading Event Maps in Game /lev_new [filename.Lev] = Load Event Map /lev_del = UnLoad Event Map Lev files can be found inside the level.rcc file you can open the file using winrar program

GM Character Edit Settings (GMCharEdit.exe)

Quote:

Buksan ang SQL Manager, pumunta sa RanUser database. Tapos buksan ang ServerGroup table at ilagay ang mga sumusunod sa column: SGNum : 0 or 1 SGName : IaNz Server ( you can put any name u want ) OdbcName : RanGame1 OdbcUserID : sa OdbcPassword : 1234 OdbcLogName : RanLog OdbcLogUserID : sa OdbcLogPassword : 1234 Kung tapos na, buksan ang ServerInfo table sa RanUser database. Ilagay ang lahat ng values. For Windows Authentication user and pass is not needed. SGNum : 0 or 1 SvrNum : 0 or 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 : sa Third field : 1234 Fourth field : 1234 For Windows Authentication user and pass is not needed. Creating an account set UserType = 32 on UserInfo table for GM and UserType = 1 for Users Only on Ep4 database, you notice that the password is code instead of word thats the new changes on Ep4 database you must convert your password to a code known as MD5 Hash ex: Password | MD5 Hash Code 123456 = E10ADC3949BA59ABBE5 test = 098F6BCD4621D373CAD ianz = 0948D2350A28EEB4B3B pdf = BCD1B68617759B1DFCF

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
3. Right click the RanGame1
4. Select New Queries
5. Put this code

Quote:

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- ====================================================== -- Author: [GM]emolista -- Create date: 11/14/2010 -- 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

EXTRA TOOLS FOR EDITING

DOWNLOAD : Download Here

Inside :
Hex Editor , RANFE, DOS Decryptor & Encryptor

ito naman yung guide ng gusto ng magkaroon ng RanofflineControlPanel
download lang nito:

http://www.ziddu.com/download/2242740/tonixRanCP.rar.html

Ang sarap talaga kung maka share ka!!!!!


Siya nga pala may mga nagrereklamo sa paggawa ng Ran. Sabi ng iba nag-restart daw yung pc nila habang nag-install ng MSSQL. Baka naman kasi di updated yung pc niyo kaya ganun. Para i-update ang pc niyo, pumunta sa Control Panel>Security Center>Automatic Updates. Select niyo download file but let me choose. Restart niyo ang pc tapos sa right side ng task bar katabi ng time and date, may makikita kayong dilaw na icon. Yun ang ibig sabihin ng windows update. Hintayin niyo matapos ang download. Pagkatapos sabihin niya ng ready to install, piliin ang custom. Wag isama ang WGA (Windows Genuine Advantage) kung pirated ang gamit niyong OS....hahaha!

Para mas mabilis ang update, download niyo na agad to:

WINDOWS XP UPDATES

Windows XP Service Pack 3 (XP SP3)
Windows XP Service Pack 3 hotfix for AMD processors
Microsoft Malicious Software Removal Tool 2.7 [for XP only]
Windows XP Service Pack 3 empty Device Manager hotfix
Windows Installer 4.5
Visual Basic 6 runtime files
Visual C++ 2008 Runtime files