[Guide]Quick RANCP Installation

[ianotida]

MSSQL 2005 EXPRESS or MSSQL 2000 must be installed first and these
RanGame1
RanLog
RanShop
RanUser
databases are already attached before you proceed this setup

or in short , Making RAN Server Guide must be completed before you proceed this setup

======================================================
RanWeb Requirements:
======================================================

Install WAMP5 (Php engine is already included)
PHP5 APACHE MYSQL for Windows : install WAMP5

Install WAMP5 ZEND OPTIMIZER ADD ON
SourceForge.net: Downloading ...

Cimed's RANCP
http://ianznet.110mb.com/ran/rancp.zip

CONFIGURING WAMP5

1. After installing, Start WAMP5 server then click the icon on the tray icons
2. go to PHP settings menu > PHP extensions


3. scroll down , click the php_mssql on menu


- now WAMP5 server will automatically restart (not the PC)
- after restart now mssql is now enabled and your DONE



RANCP

Extract your rancp.zip on www folder (usually: C:\wamp\www )


CONFIGURE RANCP

Your config.php must look like this:

for Users using SQL 2005 EXPRESS

<?php
//
$CONFIG['servername'] = "IaNz Ran Online"; //Web Name
$CONFIG['dbaddress'] = "PCNAME\SQLEXPRESS"; //DB IP
$CONFIG['dbuser'] = "sa"; //DB ID
$CONFIG['dbpass'] = "1234"; //DB PASS
$CONFIG['dbdbname'] = "RanUser";
$CONFIG['dbdbname1'] = "RanGame1";
$CONFIG['dbdbname2'] = "RanShop";
$CONFIG['registration'] = "1";
$CONFIG['maxaccounts'] = "0";
$CONFIG['maxemail'] = "1";
$CONFIG['email'] = "0";
$CONFIG['emailaddress'] = "";
$CONFIG['emailsmtp'] = "";
$CONFIG['emailuser'] = "";
$CONFIG['emailpass'] = "";
?>

for Users using SQL 2000 Evaluation or SQL 2000 Enterprise Edition

<?php
//
$CONFIG['servername'] = "IaNz Ran Online"; //Web Name
$CONFIG['dbaddress'] = "PCNAME"; //DB IP
$CONFIG['dbuser'] = "sa"; //DB ID
$CONFIG['dbpass'] = "1234"; //DB PASS
$CONFIG['dbdbname'] = "RanUser";
$CONFIG['dbdbname1'] = "RanGame1";
$CONFIG['dbdbname2'] = "RanShop";
$CONFIG['registration'] = "1";
$CONFIG['maxaccounts'] = "0";
$CONFIG['maxemail'] = "1";
$CONFIG['email'] = "0";
$CONFIG['emailaddress'] = "";
$CONFIG['emailsmtp'] = "";
$CONFIG['emailuser'] = "";
$CONFIG['emailpass'] = "";
?>

After editing config.php, go to Internet explorer or Mozila Firefox
You can type localhost/rancp to see your rancp page

Note: WAMP5 automatically open all public IP available to use, so from IP 127.0.0.1 to public IP 192.xx.xx.xx whatever your IP its all set.

[MentaL]

[keldai]

nothing much diff inside..
just layout and webserver..
but it easy to install..
good job ianz...
:)

[thetsuya]

Thanks Ianz ^_^!!,

[lucian0127]

im using wamp5 too heheh ^_^ bcause it is easy to configure..

[matrixpatch]

thank you

[skyblue]

can you help me with this error:

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: SERVER\SQLEXPRESS in C:\wamp\www\rancp\function.php on line 37

Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:\wamp\www\rancp\function.php on line 38

[lucian0127]

can you help me with this error:

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: SERVER\SQLEXPRESS in C:\wamp\www\rancp\function.php on line 37

Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:\wamp\www\rancp\function.php on line 38

replace mssql_connect() to mysql_connect()

mssql_select_db() to mysql_select_db()

[Zengetsu]

Nice Guide Already Installed The RanCP ^__^ Almost Finished Now!

Thanks Ianotida

[StationLui]

WAMP directory: C:\wamp\www\
RanCP directory: C:\wamp\www\rancp

The default WAMP site works fine. http://192.168.0.114/ but when go to this http://192.168.0.114/rancp this is the result

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: SERVER\SQLEXPRESS in C:\wamp\www\rancp\function.php on line 37

Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:\wamp\www\rancp\function.php on line 38

replace mssql_connect() to mysql_connect()
mssql_select_db() to mysql_select_db()

function connectdb($db, $dbaddress, $dbuser, $dbpass) {
$dbconnect = mysql_connect ($dbaddress, $dbuser, $dbpass);
mysql_select_db ($db, $dbconnect) or die (mysql_error());
}

Result:

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'SERVER\SQLEXPRESS' (11004) in C:\wamp\www\rancp\function.php on line 37

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\wamp\www\rancp\function.php on line 38
Unknown MySQL server host 'SERVER\SQLEXPRESS' (11004)


I need a clear and working guide. This isnt only for pro, make it userfriendly and newbie friendly guide.

[lucian0127]

WAMP directory: C:\wamp\www\
RanCP directory: C:\wamp\www\rancp

The default WAMP site works fine. http://192.168.0.114/ but when go to this http://192.168.0.114/rancp this is the result

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: SERVER\SQLEXPRESS in C:\wamp\www\rancp\function.php on line 37

Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:\wamp\www\rancp\function.php on line 38




function connectdb($db, $dbaddress, $dbuser, $dbpass) {
$dbconnect = mysql_connect ($dbaddress, $dbuser, $dbpass);
mysql_select_db ($db, $dbconnect) or die (mysql_error());
}

Result:

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'SERVER\SQLEXPRESS' (11004) in C:\wamp\www\rancp\function.php on line 37

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\wamp\www\rancp\function.php on line 38
Unknown MySQL server host 'SERVER\SQLEXPRESS' (11004)


I need a clear and working guide. This isnt only for pro, make it userfriendly and newbie friendly guide.

try to change SERVER\SQLEXPRESS to localhost..

[rej50n]

I have this error,

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: ATHLON4800X2\SQLEXPRESS in C:\wamp\www\ran\function.php on line 37

Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:\wamp\www\ran\function.php on line 38

[StationLui]

try to change SERVER\SQLEXPRESS to localhost..

huh? Local Host? are you sure?

This is what's on the guide.

$CONFIG['servername'] = "Ran-Shop"; //Web Name
$CONFIG['dbaddress'] = "SERVER\SQLEXPRESS"; //DB IP
$CONFIG['dbuser'] = "sa"; //DB ID
$CONFIG['dbpass'] = "1234"; //DB PASS

You want me to replace it with LocalHost?? SURE??????


Result of your GUESS:

$CONFIG['servername'] = "Ran-Shop"; //Web Name
$CONFIG['dbaddress'] = "LocalHost"; //DB IP
$CONFIG['dbuser'] = "sa"; //DB ID
$CONFIG['dbpass'] = "1234"; //DB PASS

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: LocalHost in C:\wamp\www\rancp\function.php on line 37

Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:\wamp\www\rancp\function.php on line 38


Your just making a guess right?

[programmer27]

pass also the port on ur dbaddress.
localhost,mssql port using if ur using mssql to connect

using mysql to connect just leave it as localhost it will do

[lucian0127]

huh? Local Host? are you sure?

This is what's on the guide.

$CONFIG['servername'] = "Ran-Shop"; //Web Name
$CONFIG['dbaddress'] = "SERVER\SQLEXPRESS"; //DB IP
$CONFIG['dbuser'] = "sa"; //DB ID
$CONFIG['dbpass'] = "1234"; //DB PASS

You want me to replace it with LocalHost?? SURE??????


Result of your GUESS:

$CONFIG['servername'] = "Ran-Shop"; //Web Name
$CONFIG['dbaddress'] = "LocalHost"; //DB IP
$CONFIG['dbuser'] = "sa"; //DB ID
$CONFIG['dbpass'] = "1234"; //DB PASS

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: LocalHost in C:\wamp\www\rancp\function.php on line 37

Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:\wamp\www\rancp\function.php on line 38


Your just making a guess right?

you're not using mssql server so use this
$conn = mysql_connect("localhost","root","pass");
$db = mysql_select_db("database");

While localhost is the "ServerName" and root is the dbUsername, pass is the dbPassword and database is the dbName
because wamp has mysql server not mssql server

[onatzzz]

sir ian, what if im using smartbro? is there no problem with this?