Tuesday, March 22, 2011

[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.

*Update: You can use the latest version of XAMPP. For SQL, I recommend the 2014 version.


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


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 here


2. After the downloads are finished, install the Xampp 1.6.6 or 1.6.7. After the installation, 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.
____
some screenies in my attachment
+++++

Credits:
bk2483
ImmortalCooL
Eureka7
Bianx