[Important] Guides-Client-Server-CP's-MOD-Files.

[smarkies]

You can find all the important and helpful threads regarding RAN Server Dev Here.
If I missed out any important threads, Just post them here and I'll add it in for you.

EP4 Client / Server Files/Guides (Not recommended for New Starters)
06-20-2008 [Share]Fixed Full Ep4 Client
06-14-2008 [Share]Editable ExpBinFiles and Default.charclass
06-11-2008 [Share]database RanGame1, Haircolor & Hairstyle fixed..
06-08-2008 [Share]Patch for 123Ran Bugs
06-07-2008 [Info]Gender Selection Unlock
06-07-2008 [Development]EP4_Client
06-06-2008 [GUIDE]How to run just only 1 field server in our EP4 project
06-05-2008 [Development] Ep4 Server Almost Complete ^_^
06-04-2008 [SHARE] working glogic Ep4 with mix char scrolls and items
05-31-2008 [Development] Ep4 Server


EP3 mixed EP4 Client / Server Files/Guides (Recommended for New Starters)
06-18-2008 [SHARE] New link EP3 MIX EP 4 Client
05-21-2008 [SHARE] DeathRan EP3 mix EP4 Client and Server Files
04-20-2008 [Share]Near perfect Client of URO Network ^_^
03-11-2008 [Share]Ran Ocean Server Ep3 Mix EP4
03-02-2008 [Server/Client Files] Ran EP3 Server Files & Client
02-18-2008 [Server Files] Premodified EP4 Server Files: Mini Edition
02-17-2008 [Client Files] English Mini Maps.
12-23-2007 [Guide]Tutorial Making Ran Offline with video, ranserver & ranclient ep4
09-26-2007 [Client File] EP3 MIX EP4 Client Sharring
08-18-2007 [Release]Ran Server
05-22-2007 [Server Files] Ran Glogic.rcc and Editors
08-31-2006 [Guide]Install Ran Online or Offline[Allmost Complete]
06-07-2006 [Guide]How to Install Ran Server[Mixed Mode]
06-01-2006 [Guide] Howto: Install RAN Online With Pictures.
03-26-2006 [Guide] Howto: Install RAN Online Server
03-24-2006 [RAN Online Control Panel] Discussion and Support Topic.
03-15-2006 [REPACK] Personified Repack & Support Topic


Ran Control Panel Files/Guides
05-28-2008 [Share] BlackPearl-CP
05-26-2008 [Share] New Way to Register an Account! (Php Script)
05-10-2008 [SHARE]School System
05-03-2008 [Share] RanCP Registration Security Code Add-On
04-24-2008 [Share] Php script for counting Characters Online
03-17-2008 [Share] Reborn for RanCP (100% Working)
03-14-2008 [SHARE] ePoints Code Generator
03-13-2008 [Share]code generator for Rancp TopUp
02-23-2008 [Guide] RANCP using NO-IP w/ pictures
02-04-2008 [Share] HairStyle & Bright pts. Reset
01-24-2008 [Share] Top up section for ran CP
11-17-2007 [Share] School CHanger (php)
11-11-2007 [Guide]Quick RANCP Installation
10-22-2007 [RANCP ADDON]For those who has error with OBLI E
11-08-2007 [Share] Display/Add/Del Item to ShopItemMap
10-28-2007 [RAN CP] Status Page on Bling!!!
08-23-2007 [Server File] status.php
05-03-2007 [Guide] RanCP installation errors fixes


Modified Files/Guides
06-02-2008 [Share] dds skin tattoo for your character
05-17-2008 [share] The Flaming Set
04-21-2008 [SHARE!] Sigma Pride: Blade Dancer
04-19-2008 [SHARE]300 skills w/ no game.exe error
04-15-2008 [SHARE]modified weapons
04-01-2008 [Share-Re-Edited]1-30 Spiritual Sphere Trading
03-30-2008 [SHARE] New EP4 Lobi Screen with Swordie & Fighter BG
03-30-2008 [SHARE] The Missing char in the 2046 City Login Lobi
03-19-2008 [SHARE]Create,Modify,Design your New Armor from old
03-05-2008 [Share] 237~300 skil, and new GM skills
03-04-2008 [Share]Modified EP3 infinity Armors
01-24-2008 [Shared] Re-Decrypted E4 Elemental Inifinity Weapons
11-15-2007 [SHARE]Server Select Screen RELOADED
10-25-2007 [Share]Edited Server Select Screen
10-24-2007 [Share]250~277 skills
10-14-2007 [share]EP4 quigong (Shaman) Weapon
08-25-2007 [Fun Guide] How to play as mob in Ran ^.~
10-16-2007 [Release] Sharing the complete "I Love soccer shirts"
10-16-2007 [Release] Ep4 Eleml Weapons Ep3, Ep4 Armor
07-28-2007 [server files]Fix RH, Saint B1 quest n Skill 227


Tools Files/Guides
05-04-2008 [SHARE].x file viewer (for newbies)
04-19-2008 [Tools] DDS Converter 2
04-09-2008 [Tools] File Decryptor and Encryptor (English)
04-05-2008 [Tools] Encrypting your Client Files
11-19-2007 [share]installer creator
10-06-2007 [Tools] Infranview for DDS Viewing
09-28-2007 [Tools] Lets go to the next level!: 3D Exploring
05-22-2007 [Server Files] Ran Glogic.rcc and Editors



MSSQL Files/Guides
05-11-2008 [Guide] Auto Reborn Script
10-11-2007 [Server Files] SQL Trigger Scripts Collections
08-14-2007 [Guide] AutoReborn Scripts for SQL 2005
06-15-2006 [Guide] Set Starting Default Level (SQL Trigger)


Launcher Files/Guides
05-18-2008 [SHARE] Launcher w/ Auto Patch Source Code
12-19-2007 [NEW RELEASE]Ran Patcher Support No-ip and Resume
12-08-2007 [NEW RELEASE] AutoPatch Launcher With Download Progress and Option
10-23-2007 [Share] Customizable Ran Patcher now v2
10-05-2007 [Source]autoit For Launcher Patch Auto
08-14-2007 [Server Files] New RanLauncher with AutoPatch (Now Online.!!!!)
12-05-2006 [File] Try my RAN Launcher. Costumizable ^^


Miscellaneous Files/Guides
06-05-2008 [GUIDE] .crowsale of brawler,swords,archer,shaman,grocery, and college
04-07-2008 [Guide] Editing GUI using Adobe Photoshop CS2
04-04-2008 [Guide]changing first items of char
04-30-2008 [Guide] Fix for "unable to ride the buss due to common eror"
04-18-2008 [Share] How To Use GMCharEdit
04-10-2008 [SHARE] Additional Saint Map
03-17-2008 [Help] different item
02-15-2008 [Share] EP4 ServerFiles Unrestricted CFG
02-17-2008 [Guide] GM Command List
01-25-2008 [SHARE] npctalk enable 147-287 Spiritual Trading
05-03-2008 [SHARE] Server Status Script with Announcement
03-02-2008 [File]Character get tired quickly (SP Problem)
03-08-2008 [Info]The SQL Injection Attack
02-16-2008 [Guide] How to edit Copyright
02-29-2008 [Share]New Lvl 300 Skill with NEW EFFECTS and Icon
09-11-2007 [Tutorial] Making Custom Items Saleable In ItemShop
09-08-2007 [Tutorial] Making a custom scrolls w/ Pictures
09-02-2007 [Development] Project EP 1/4
08-17-2007 [Guide]Ran File Editor (Edit Glogic)


Hosting Guide
03-25-2008 [Guide] Ran Local Area Networking (LAN).
04-11-2008 [Video TUT]Hosting Ran Without Hamachi
02-07-2008 [Guide] Server Connection Failed Totally Solved For People Behind Router
12-28-2007 [Share] Connecting Remotely To RanData on SQL2K5
12-27-2007 [Share]How Split Server?
11-06-2007 [GUIDE] 2/3/4/5/6/7/8/9 Field Server with Pictures
09-22-2007 [GUIDE] Making 2 Channel in 1 Server [100% Working]
09-19-2007 [GUIDE] [Philippines Only] For smartBRO ranserver hosting...
09-18-2007 [Guide]latest guide in hosting ran using router witout HAMACHI(windowsXP)

 

[shizzle08]

Re: [Important Threads] Tutorial Guides, Client, Server, CP's and etc.

` this is vERy helpful thread

 

[vinthalie]

Re: [Important Threads] Tutorial Guides, Client, Server, CP's and etc.

are there prizes for the most contributors? lol hehehehe

 

[alsyundawy]

Re: [Important Threads] Tutorial Guides, Client, Server, CP's and etc.

thx smarkies

 

[jambrong]

Re: [Important Threads] Tutorial Guides, Client, Server, CP's and etc.

thx for making my thread to the stickies ^_^

 

[Vision]

Re: [Important] Tutorial Guides, Client, Server, CP's and etc.

Great. There's already titles.

Thank you so much.

 

[AutoKill]

Wow Nice Sir, Easy For Noob....

 

[TITAN XD]

Thanks For Fixing Now It Is Easy To Find..
Thanks Again Sir Smarkies..

 

[Ultimate Ran]

nice arrangement by topic and by uses.. tnx for this..

 

[jeyci]

is the Admin CP removed>?<

 

[danish]

Nice Smark..very usefull....you're the man....haha..tq anyway...

 

[netcheck]

guys.. you can refer to this thread before making a new thread... dont forget the rules..

***Read stickies first!!*** ^^

 

[roycl]

@smarkies

could you add a guide on how to extend mssql 2000 trial period or any other method?

 

[clever]

This thread could really help a lot of ragezoner, that want to learn more
and trying to develop their selves to become PRO making RAN server game


thanks a lot Smarkies
its my pleasure to always visit this thread

nice one oster_ssoster_ssoster_ss

 

[justineompoc]

Running connectivity tests...

Attempting connection
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

TESTS FAILED!

 

[Ultimate Ran]

mr smarkies pls where are you

 

[Ilfirin]

justin, in the which sql server do you want to connect to? you have to write:

name-of-your-server\SQLEXPRESS otherwise it won't work

 

[akatsuki17]

INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
Service Provider:IANZ SERVER
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:SQLConnect Failed
ERROR:User DB Open Error
Stop IOCP
Stop Message Queue
Stop DataBase
Stop CFG
=======================================================
Server Stop OK
=======================================================
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK



thats my problems...can anyone help me???

 

[Abry]

did u make already ur sql databases?

 

[akatsuki17]

ok na pla ang session server ko saka login server ....sa field server nalang po ako may problems....

Service Provider:IANZ SERVER
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
User DB Open OK
ERROR:SQLConnect Failed
ERROR:Game DB Open Error
== Please wait until server stop
== Update Thread stopped.
== Client Manager closed
== Message Manager closed
== Database Manager closed
=======================================================
Server Stop OK
=======================================================
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK


yan po ang sinasabi ng field server ko....help nmn po....