Profile based on mysqli

The OpenProfileModule makes it possible to create your own Profile and see other peoples' Profiles as well. This script is useing mysqli that replace the deprecated mysql commands with PHP 5.5.0

Disclaimer
Please note that these are third party modules which you use at your own risk!

OpenSimulator takes no responsibility for these modules.

OpenProfileModule Configuration Steps
The OpenProfileModule is already compiled and ready for use in current versions of OpenSimulator.

However, you will need to setup the "back-end" database and PHP connector scripts to support the OpenProfileModule.


 * 1) Upload the profile.sql (below) to your database server
 * 2) Upload the profile.php (below) to your web server
 * 3) Enable the OpenProfileModule in your OpenSim.ini file

STEP 1: profile.sql
Save these SQL commands to a profile.sql file on your MySQL database server.

Connect to your MySQL (Linux commands shown): $ mysql --user=$mysqluser --password=$mysqlpassword $databasename Replace $mysqluser, $mysqlpassword, and $databasename with your specific configuration.

At the mysql prompt, source the profile.sql file to configure your database to hold additional profile information: mysql> source profile.sql ... ensure no error messages appear here ... mysql> quit

STEP 2: profile.php
Copy this PHP script to a file called profile.php and edit the following parameters in the script. C_DB_HOST, C_DB_DATABASE, C_DB_USER, C_DB_PASS, Add the required data between the ""

STEP 3: OpenProfileModule
Shutdown your simulator.

Edit the OpenSim.ini [Profile] block.

An example configuration is shown below:

Once the edits are made, save your OpenSim.ini and restart your simulator.

Using the OpenProfileModule
Login to your simulator and try to create your profile.

Check the database profile table to verify whether or not profile.php has written a record there.

P.D: OpenProfileModule only works while you are on your home grid, not when you are connected to other grids over hypergrid.

Troubleshooting
Error shown in Apache error_log:  PHP Fatal error: Call to undefined function xmlrpc_server_create in /var/www/html/opensim/profile.php

Cause: Many Linux distributions may not ship with PHP XML RPC extensions.

Steps to Fix:
 * Fedora 17:
 * 1) yum install php-xmlrpc