Oldstone Place

For a full package see Foxserv-3.1 at Sourceforge

MySqlFront is a useful Windows frontend for MySQL http://www.sstienemann.de/mysqlfront/

For users to register in your PHP-Nuke site, you’ll need an smtp server. Theres one in WinXp or you can try http://www.argosoft.com/applications/mailserver/

Requirements

Download the latest versions of the following software.

• Apache (try IIS?) http://www.apache.org/
• MySQL http://www.mysql.com/
• PHP http://www.php.net/
• PhpNuke http://phpnuke.org/

Installation

MySQL

Use WinZip to install MySQL. Install it to the default directory c:\mysql

See the documentation in c:\mysql\docs for configuration info.

Start the MySQL service. Open a DOS window and type

cd \mysql\bin
mysqld-nt –install
net start mysql

Start and stop the MySQL service with these commands:

NET START mysql
NET STOP mysql

If you don’t want to start mysqld-nt as a service, you can start it as follows:

C:> mysqlbinmysqld-nt --standalone

You can test whether or not MySQL is working by executing the following commands:

mysqlshow
mysqlshow -u root
mysql
mysqladmin version status proc
mysql test

The default privileges on Windows give all local users full privileges to all databases without specifying a password. To make MySQL more secure, you should set a password for all users and remove the row in the mysql.user table that has Host='localhost' and User=''.

You should also add a password for the root user. The following example starts by removing the anonymous user that can be used by anyone to access the test database, then sets a root user password:

mysql
DELETE FROM user WHERE Host='localhost' AND User='';
QUIT
mysqladmin reload
mysqladmin -u root password your_passwordAfter you’ve set the password, if you want to take down the mysqld server, you can do so using this command:

mysqladmin --user=root --password=your_password shutdown

PHP

Run the installer, select the web server youre using, and youre done. Try a quick test.php to make sure.

Edit \Windows\php.ini

magic_quotes_gpc = On magic_quotes_gpc = On magic_quotes_gpc = Off ;include_path = “.” include_path = “.;c:\www\” doc_root ;doc_root = extension_dir = extension_dir = “./;c:\www\php precision=12 precision=14 unserialize_callback_func= ;unserialize_callback_func= safe_mode_gid = Off ;safe_mode_gid = Off safe_mode_include_dir = ;safe_mode_include_dir = register_globals = Off register_globals = On pgsql.auto_reset_persistent = Off ; pgsql.auto_reset_persistent = Off

PHP-Nuke

Use WinZip to uncompress PHP-Nuke to a temporary folder. Copy all the files and folders under the html directory to where you want them in your web site, usuall the root folder of your web site since PHP-Nuke will manage your whole site. To create a database for PhpNuke, open a DOS window and enter the following commands, change the directory names as required.

copy \nukedir\sqlnuke.sql \mysql\bin
cd \mysql\bin
mysqladmin create nuke
mysql nuke
mysql -u  -p nuke sqlnuke.sql

Add the following lines at the top of config.php

import_request_variables(’gPc’); 
$PHP_SELF = $_SERVER[”PHP_SELF”];