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

25 comments:

  1. error nmn po skin :( ....

    Connection with SQL Server failed! Error #119

    ReplyDelete
  2. ayaw gumana saaikn n2 http://127.0.0.1/ran/install/install.php open naman yung xamppe ko

    ReplyDelete
    Replies
    1. ganto po dapat http://127.0.0.1/rancp/install.php

      Delete
  3. Mag download kau ng GzBkcp.rar: Tapos Lagay nyu po un sa Xamppe nyu

    ReplyDelete
  4. Lagay nyo sa HTTDOC sa XAMPP folder.! Para gumana. Para sa error with SQL Please modified the config.php. just put the database host in config.php

    ReplyDelete
  5. This control panel working on Ran EP6 S2/S3?

    ReplyDelete
  6. This is a guide on how to make a admin control panel...this is compatible to ep6 and ep7 server developments. If the links are dead, kindly text me up. Thank you....^_^

    ReplyDelete
    Replies
    1. Sir Anopo Number mO Tatawagan kapo namin..:D

      Delete
  7. Gawa na po ung CP.. kulang na lng po ee kung pano mag register .. un lng po salamat.. pag nag register lalabas

    Notice: The statement has been terminated. in C:\xampp\htdocs\lib\logic\Referrer.php on line 101

    ReplyDelete
  8. panu tong error na to ?

    Fatal error: Call to a member function fetchrow() on a non-object in C:\xampp\htdocs\rancp\includes\web.php on line 45

    ReplyDelete
  9. ser normal lang po ba naCHARACTER FAILED TO PROCESS ksi nka localhost pa lng nmn xia??? normal lng ba yan ???

    bhosxmhark15@yahoo.com pakisagot na lng p0 ..

    ReplyDelete
  10. nkakapasok na p0 ako sa launcher then nakakapag login na p0 ako .. kaso CHARACTER FAILED TO BE PROCESSED panu po yun???? nka xampp palng p0 ako ..

    ReplyDelete
  11. same lng din ba gagawin kapag yung Bossran CP or ibang Control panel ang gagamitin ?

    ReplyDelete
  12. pa tulong naman po please...
    ginawa ko naman tong tut mo

    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)

    pero bakit ganto lumalabas?

    http://i300.photobucket.com/albums/nn27/acenomore/345345_zpsmps5wflr.png

    ReplyDelete
  13. Kuya paano gumawa ng Ran online kung kasakali na Admin ka doon ...paano po kung hindi sayu yung computer
    need ko help mo
    Call me 09229088186

    ReplyDelete
  14. kuya panu i fixed sa ung client d sya maka connect sa server side pero ung server side ko start ok po lahat wala po error pag nirun ko po ung client internet conection error agusan ep10 po

    ReplyDelete
  15. Error #122Loading php_gd2.dll Falied!
    Please Enable php_gd2.dll in ur php.ini");} if (extension_loaded('mssql')) {echo("");} else{Die("
    Error #123
    Loading php_mssql.dll Falied!
    Please Enable php_mssql.dll in ur php.ini");} } ?>

    ';} elseif($_POST['connection'] == 'mssql'){ echo '

    pano po i fix to pa help plss

    ReplyDelete
  16. Error #122Loading php_gd2.dll Falied!
    Please Enable php_gd2.dll in ur php.ini");} if (extension_loaded('mssql')) {echo("");} else{Die("
    Error #123
    Loading php_mssql.dll Falied!
    Please Enable php_mssql.dll in ur php.ini");} } ?>

    ';} elseif($_POST['connection'] == 'mssql'){ echo '

    pano po i fix to pa help plss

    ReplyDelete