Profile - Revision history

Kcozens: Updated the name of the external addon profile module

2017-08-06T19:57:50Z

Updated the name of the external addon profile module

Djphil: /* STEP 1: profile.sql */

2017-04-15T09:53:07Z

‎STEP 1: profile.sql

Djphil: /* STEP 1: profile.sql */

2017-04-15T09:47:57Z

‎STEP 1: profile.sql

Aiaustin: full stop added only

2013-11-28T14:42:40Z

full stop added only

Aiaustin: Corrected link to new 0.7.6 onwards UserProfiles page

2013-11-28T14:42:15Z

Corrected link to new 0.7.6 onwards UserProfiles page

Aiaustin: Added note that from 0.7.6 an inbuilt mechanism exists.

2013-11-28T14:41:10Z

Added note that from 0.7.6 an inbuilt mechanism exists.

Aiaustin: corrected wording of mysqli version sentence

2013-05-07T19:55:05Z

corrected wording of mysqli version sentence

Richardus Raymaker at 13:03, 27 March 2013

2013-03-27T13:03:16Z

Allen Kerensky: fixed some stuff to say profile.sql and tables rather than offline_ims where I copy and paste those steps from another page

2013-02-11T17:37:35Z

fixed some stuff to say profile.sql and tables rather than offline_ims where I copy and paste those steps from another page

Allen Kerensky: Undo revision 31596 by Allen Kerensky (talk)

2013-01-17T14:26:01Z

Undo revision 31596 by Allen Kerensky (talk)

@@ Line 4: / Line 4: @@
 OpenSimulator 0.7.6 and onwards ships with built-in user profiles support. See [[UserProfiles]].
-Earlier, an add-on module called "OpenProfileModule" made it possible to create an avatar profile and see other avatar's profiles as well.
+Earlier, an add-on module called "OpenSimProfile" made it possible to create an avatar profile and see other avatar's profiles as well.
 You can find a newer script that uses mysqli and that replaces the deprecated mysql commands with PHP 5.5.0
@@ Line 13: / Line 13: @@
 OpenSimulator takes no responsibility for these modules.</b>
-=== OpenProfileModule Configuration Steps ===
+=== OpenSimProfile Configuration Steps ===
-The OpenProfileModule is already compiled and ready for use in current versions of OpenSimulator.
+The OpenSimProfile 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.
+However, you will need to setup the "back-end" database and PHP connector scripts to support the OpenSimProfile.
 # Upload the profile.sql (below) to your database server
 # Upload the profile.php (below) to your web server
-# Enable the OpenProfileModule in your OpenSim.ini file
+# Enable the OpenSimProfile in your OpenSim.ini file
 === STEP 1: profile.sql ===
@@ Line 781: / Line 781: @@
 </source >
-=== STEP 3: OpenProfileModule ===
+=== STEP 3: OpenSimProfile ===
 Shutdown your simulator.
@@ Line 789: / Line 789: @@
   <source lang="ini">
 [Profile]
-     Module = "OpenProfileModule"
+     Module = "OpenSimProfile"
      ProfileURL = "http://yourwebserverdomainname/pathto/profile.php"
 </source>
@@ Line 795: / Line 795: @@
 Once the edits are made, save your OpenSim.ini and restart your simulator.
-=== Using the OpenProfileModule ===
+=== Using the OpenSimProfile module ===
 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.
+P.D: OpenSimProfile only works while you are on your home grid, not when you are connected to other grids over hypergrid.
 === Troubleshooting ===

@@ Line 73: / Line 73: @@
      `useruuid` varchar(36) NOT NULL,
      `profilePartner` varchar(36) NOT NULL,
-     `profileAllowPublish` BINARY(1) NOT NULL,
+     `profileAllowPublish` binary(1) NOT NULL,
-     `profileMaturePublish` BINARY(1) NOT NULL,
+     `profileMaturePublish` binary(1) NOT NULL,
      `profileURL` varchar(255) NOT NULL,
      `profileWantToMask` int(3) NOT NULL,
@@ Line 87: / Line 87: @@
      PRIMARY KEY (`useruuid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-−
-−
 CREATE TABLE IF NOT EXISTS `profile_settings` (
      `useruuid` varchar(36) NOT NULL,

@@ Line 25: / Line 25: @@
 Save these SQL commands to a profile.sql file on your MySQL database server.
- <source lang="sql">
+<source lang="sql">
-−
 CREATE TABLE IF NOT EXISTS `profile_classifieds`
+(
+    `classifieduuid` char(36) NOT NULL,
-`classifieduuid` char(36) NOT NULL,
+    `creatoruuid` char(36) NOT NULL,
-  `creatoruuid` char(36) NOT NULL,
+    `creationdate` int(20) NOT NULL,
+    `expirationdate` int(20) NOT NULL,
-`creationdate` int(20) NOT NULL,
+    `category` varchar(20) NOT NULL,
-  `expirationdate` int(20) NOT NULL,
+    `name` varchar(255) NOT NULL,
+    `description` text NOT NULL,
-`category` varchar(20) NOT NULL,
+    `parceluuid` char(36) NOT NULL,
-  `name` varchar(255) NOT NULL,
+    `parentestate` int(11) NOT NULL,
+    `snapshotuuid` char(36) NOT NULL,
-`description` text NOT NULL,
+    `simname` varchar(255) NOT NULL,
-  `parceluuid` char(36) NOT NULL,
+    `posglobal` varchar(255) NOT NULL,
+    `parcelname` varchar(255) NOT NULL,
-`parentestate` int(11) NOT NULL,
+    `classifiedflags` int(8) NOT NULL,
-  `snapshotuuid` char(36) NOT NULL,
+    `priceforlisting` int(5) NOT NULL,
+    PRIMARY KEY (`classifieduuid`)
 `simname` varchar(255) NOT NULL,
-  `posglobal` varchar(255) NOT NULL,
-−
 `parcelname` varchar(255) NOT NULL,
-  `classifiedflags` int(8) NOT NULL,
-−
 `priceforlisting` int(5) NOT NULL,
-  PRIMARY KEY (`classifieduuid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 CREATE TABLE IF NOT EXISTS `profile_notes` (
+    `useruuid` varchar(36) NOT NULL,
-`useruuid` varchar(36) NOT NULL,
+    `targetuuid` varchar(36) NOT NULL,
+    `notes` text NOT NULL,
-`targetuuid` varchar(36) NOT NULL,
+    UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 `notes` text NOT NULL,
-  UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`)
-−
- ENGINE=MyISAM DEFAULT CHARSET=latin1;
-−
-−
 CREATE TABLE IF NOT EXISTS `profile_picks` (
+    `pickuuid` varchar(36) NOT NULL,
-`pickuuid` varchar(36) NOT NULL,
+    `creatoruuid` varchar(36) NOT NULL,
-  `creatoruuid` varchar(36) NOT NULL,
+    `toppick` enum('true','false') NOT NULL,
+    `parceluuid` varchar(36) NOT NULL,
-`toppick` enum('true','false') NOT NULL,
+    `name` varchar(255) NOT NULL,
-  `parceluuid` varchar(36) NOT NULL,
+    `description` text NOT NULL,
+    `snapshotuuid` varchar(36) NOT NULL,
-`name` varchar(255) NOT NULL,
+    `user` varchar(255) NOT NULL,
+    `originalname` varchar(255) NOT NULL,
-`description` text NOT NULL,
+    `simname` varchar(255) NOT NULL,
+    `posglobal` varchar(255) NOT NULL,
-`snapshotuuid` varchar(36) NOT NULL,
+    `sortorder` int(2) NOT NULL,
+    `enabled` enum('true','false') NOT NULL,
-`user` varchar(255) NOT NULL,
+    PRIMARY KEY (`pickuuid`)
-−
 `originalname` varchar(255) NOT NULL,
-−
 `simname` varchar(255) NOT NULL,
-−
 `posglobal` varchar(255) NOT NULL,
-−
 `sortorder` int(2) NOT NULL,
-−
 `enabled` enum('true','false') NOT NULL,
-  PRIMARY KEY (`pickuuid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 CREATE TABLE IF NOT EXISTS `profile` (
+    `useruuid` varchar(36) NOT NULL,
-`useruuid` varchar(36) NOT NULL,
+    `profilePartner` varchar(36) NOT NULL,
+    `profileAllowPublish` BINARY(1) NOT NULL,
-`profilePartner` varchar(36) NOT NULL,
+    `profileMaturePublish` BINARY(1) NOT NULL,
+    `profileURL` varchar(255) NOT NULL,
-`profileAllowPublish` binary(1) NOT NULL,
+    `profileWantToMask` int(3) NOT NULL,
+    `profileWantToText` text NOT NULL,
-`profileMaturePublish` binary(1) NOT NULL,
+    `profileSkillsMask` int(3) NOT NULL,
+    `profileSkillsText` text NOT NULL,
-`profileURL` varchar(255) NOT NULL,
+    `profileLanguages` text NOT NULL,
+    `profileImage` varchar(36) NOT NULL,
-`profileWantToMask` int(3) NOT NULL,
+    `profileAboutText` text NOT NULL,
+    `profileFirstImage` varchar(36) NOT NULL,
-`profileWantToText` text NOT NULL,
+    `profileFirstText` text NOT NULL,
+    PRIMARY KEY (`useruuid`)
-`profileSkillsMask` int(3) NOT NULL,
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-−
 `profileSkillsText` text NOT NULL,
-−
 `profileLanguages` text NOT NULL,
-−
 `profileImage` varchar(36) NOT NULL,
-−
 `profileAboutText` text NOT NULL,
-−
 `profileFirstImage` varchar(36) NOT NULL,
-−
 `profileFirstText` text NOT NULL,
-  PRIMARY KEY (`useruuid`)
-−
 ENGINE=MyISAM DEFAULT CHARSET=latin1;
-−
-−
 CREATE TABLE IF NOT EXISTS `profile_settings` (
+    `useruuid` varchar(36) NOT NULL,
-`useruuid` varchar(36) NOT NULL,
+    `imviaemail` enum('true','false') NOT NULL,
+    `visible` enum('true','false') NOT NULL,
-`imviaemail` enum('true','false') NOT NULL,
+    `email` varchar(254) NOT NULL,
+    PRIMARY KEY (`useruuid`)
 `visible` enum('true','false') NOT NULL,
-−
 `email` varchar(254) NOT NULL,
-  PRIMARY KEY (`useruuid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 </source >

@@ Line 2: / Line 2: @@
 {{Quicklinks}}
-OpenSimulator 0.7.6 and onwards ships with built-in user profiles support. See [[UserProfiles]]
+OpenSimulator 0.7.6 and onwards ships with built-in user profiles support. See [[UserProfiles]].
 Earlier, an add-on module called "OpenProfileModule" made it possible to create an avatar profile and see other avatar's profiles as well.

@@ Line 2: / Line 2: @@
 {{Quicklinks}}
-OpenSimulator 0.7.6 and onwards ships with built-in user profiles support. See [[Userprofiles]]
+OpenSimulator 0.7.6 and onwards ships with built-in user profiles support. See [[UserProfiles]]
 Earlier, an add-on module called "OpenProfileModule" made it possible to create an avatar profile and see other avatar's profiles as well.

@@ Line 4: / Line 4: @@
 The OpenProfileModule makes it possible to create your own Profile and see other peoples' Profiles as well.
-You can find a newer script thats useing mysqli that replace the deprecated mysql commands with PHP 5.5.0
+You can find a newer script that uses mysqli and that replaces the deprecated mysql commands with PHP 5.5.0
 [http://opensimulator.org/wiki/Profile_based_on_mysqli here]

← Older revision		Revision as of 13:03, 27 March 2013
Line 3:		Line 3:

	The OpenProfileModule makes it possible to create your own Profile and see other peoples' Profiles as well.		The OpenProfileModule makes it possible to create your own Profile and see other peoples' Profiles as well.
		+
		+	You can find a newer script thats useing mysqli that replace the deprecated mysql commands with PHP 5.5.0
		+	[http://opensimulator.org/wiki/Profile_based_on_mysqli here]

	=== Disclaimer ===		=== Disclaimer ===

@@ Line 149: / Line 149: @@
 Replace $mysqluser, $mysqlpassword, and $databasename with your specific configuration.
-At the mysql prompt, source the Offline_IM.sql file to configure your database to hold offline IMs:
+At the mysql prompt, source the profile.sql file to configure your database to hold additional profile information:
 <pre>
 mysql> source profile.sql