VIDEO TUTORIAL:

VIDEO TUTORIAL:

VIDEO LINK: CLICK ME

1. Installing SQL SERVER
2. Installing SQL Management Studio
3. Creating and Restoring Database
4. Setting Up ODBC
5. Configuring Ran Server
6. Port Forwarding
7. Setting Up GMC
8. Creating New User
9. Configuring Client

[Guide]Ran Control Panel Installation Using XAMMP ApacheFriends

Good morning, guys! I just want to share my knowledge to everyone. Here's the simplified guide on how to create your Ran Control Panel. But before that, you should do the following:


*Database FIX(For 1st time rancp installation)
1. Open your MSSQL2005
2. Login you MSSQL2005 account.
3. Expand the 'Databases'.
4. Expand your RanUser database
5. Expand the 'Tables'.
6. Right click on UserInfo then click 'Design'
7. Scroll down, add column namely 'UserEmail with data type 'varchar,50' . Check the box 'allow nulls'
8. Add column again namely 'UserPoint' with data type 'int,4' . Check the box 'allow nulls'
9. Close and save the design table.


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


So, now let's start to install and modify your own Ran CP


1. Download and install the following:


Xampp ver. 1.6.7: Click here
ntwdblib.rar: Click here
GzBkcp.rar: Click hereRan online web: Click here
Blue ran cp: Click here
Babyran cp: Click here
Bossran cp: Click here



2. After the downloads are finished, install the Xampp 1.6.7. After you installed the Xampp, do not run.


3. Extract the ntwdblib and overwrite the following:




Quote:
C:\xampp\apache\bin\
C:\xampp\php
C:\windows\system32
----------------------------------------------------------------------------------------------------------------------------


4. Extract the GzBkcp inside your htdocs, it will look like this: C:\xampp\htdocs\rancp\). Run your Apache and MySQL via Xampp Control Panel. Then, go to http://127.0.0.1/rancp/install/install.php


1. Step 1 - Choose Mssql or ODBC (Choose Mssql, ODBC is not configured yet)
2. Step 2 - Now put the correct info. And example shown below.



Local Host : 127.0.0.1 (Leave As it is)
*SQL Server Host : COMPUTERNAME\SQLEXPRESS (Change COMPUTERNAME to yous)
Database User : sa
Database Password : 1234 (Change to your pass)
*Ran Online Database : RanUser (Leave As it is)


1. Step 3 - Enter the Infos
2. Step 4 - Enter the infos

Once your done installing it then go here http://192.168.2.1/rancp/

Then You Done. Remember to use Xampp.