diff options
Diffstat (limited to 'OpenSim/Data')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLUserProfilesData.cs | 2 | ||||
-rw-r--r-- | OpenSim/Data/PGSQL/PGSQLRegionData.cs | 2 | ||||
-rw-r--r-- | OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | 2 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteUserProfilesData.cs | 2 |
4 files changed, 1 insertions, 7 deletions
diff --git a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs index 4c6c8e3..dc88f94 100644 --- a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs +++ b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs | |||
@@ -736,7 +736,6 @@ namespace OpenSim.Data.MySQL | |||
736 | string query = string.Empty; | 736 | string query = string.Empty; |
737 | 737 | ||
738 | query += "UPDATE userprofile SET "; | 738 | query += "UPDATE userprofile SET "; |
739 | query += "profilePartner=?profilePartner, "; | ||
740 | query += "profileURL=?profileURL, "; | 739 | query += "profileURL=?profileURL, "; |
741 | query += "profileImage=?image, "; | 740 | query += "profileImage=?image, "; |
742 | query += "profileAboutText=?abouttext,"; | 741 | query += "profileAboutText=?abouttext,"; |
@@ -752,7 +751,6 @@ namespace OpenSim.Data.MySQL | |||
752 | using (MySqlCommand cmd = new MySqlCommand(query, dbcon)) | 751 | using (MySqlCommand cmd = new MySqlCommand(query, dbcon)) |
753 | { | 752 | { |
754 | cmd.Parameters.AddWithValue("?profileURL", props.WebUrl); | 753 | cmd.Parameters.AddWithValue("?profileURL", props.WebUrl); |
755 | cmd.Parameters.AddWithValue("?profilePartner", props.PartnerId.ToString()); | ||
756 | cmd.Parameters.AddWithValue("?image", props.ImageId.ToString()); | 754 | cmd.Parameters.AddWithValue("?image", props.ImageId.ToString()); |
757 | cmd.Parameters.AddWithValue("?abouttext", props.AboutText); | 755 | cmd.Parameters.AddWithValue("?abouttext", props.AboutText); |
758 | cmd.Parameters.AddWithValue("?firstlifeimage", props.FirstLifeImageId.ToString()); | 756 | cmd.Parameters.AddWithValue("?firstlifeimage", props.FirstLifeImageId.ToString()); |
diff --git a/OpenSim/Data/PGSQL/PGSQLRegionData.cs b/OpenSim/Data/PGSQL/PGSQLRegionData.cs index f3e4064..b3076f0 100644 --- a/OpenSim/Data/PGSQL/PGSQLRegionData.cs +++ b/OpenSim/Data/PGSQL/PGSQLRegionData.cs | |||
@@ -206,7 +206,7 @@ namespace OpenSim.Data.PGSQL | |||
206 | 206 | ||
207 | DataTable schemaTable = result.GetSchemaTable(); | 207 | DataTable schemaTable = result.GetSchemaTable(); |
208 | foreach (DataRow row in schemaTable.Rows) | 208 | foreach (DataRow row in schemaTable.Rows) |
209 | m_ColumnNames.Add(row["column_name"].ToString()); | 209 | m_ColumnNames.Add(row["ColumnName"].ToString()); |
210 | } | 210 | } |
211 | 211 | ||
212 | foreach (string s in m_ColumnNames) | 212 | foreach (string s in m_ColumnNames) |
diff --git a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs index e3cbf7f..f4e41b4 100644 --- a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs +++ b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | |||
@@ -715,7 +715,6 @@ namespace OpenSim.Data.PGSQL | |||
715 | string query = string.Empty; | 715 | string query = string.Empty; |
716 | 716 | ||
717 | query += "UPDATE userprofile SET "; | 717 | query += "UPDATE userprofile SET "; |
718 | query += "profilePartner=:profilePartner, "; | ||
719 | query += "profileURL=:profileURL, "; | 718 | query += "profileURL=:profileURL, "; |
720 | query += "profileImage=:image, "; | 719 | query += "profileImage=:image, "; |
721 | query += "profileAboutText=:abouttext,"; | 720 | query += "profileAboutText=:abouttext,"; |
@@ -731,7 +730,6 @@ namespace OpenSim.Data.PGSQL | |||
731 | using (NpgsqlCommand cmd = new NpgsqlCommand(query, dbcon)) | 730 | using (NpgsqlCommand cmd = new NpgsqlCommand(query, dbcon)) |
732 | { | 731 | { |
733 | cmd.Parameters.AddWithValue("profileURL", props.WebUrl); | 732 | cmd.Parameters.AddWithValue("profileURL", props.WebUrl); |
734 | cmd.Parameters.AddWithValue("profilePartner", props.PartnerId.ToString()); | ||
735 | cmd.Parameters.AddWithValue("image", props.ImageId.ToString()); | 733 | cmd.Parameters.AddWithValue("image", props.ImageId.ToString()); |
736 | cmd.Parameters.AddWithValue("abouttext", props.AboutText); | 734 | cmd.Parameters.AddWithValue("abouttext", props.AboutText); |
737 | cmd.Parameters.AddWithValue("firstlifeimage", props.FirstLifeImageId.ToString()); | 735 | cmd.Parameters.AddWithValue("firstlifeimage", props.FirstLifeImageId.ToString()); |
diff --git a/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs b/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs index cc1dac1..8c1bcd4 100644 --- a/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs +++ b/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs | |||
@@ -679,7 +679,6 @@ namespace OpenSim.Data.SQLite | |||
679 | string query = string.Empty; | 679 | string query = string.Empty; |
680 | 680 | ||
681 | query += "UPDATE userprofile SET "; | 681 | query += "UPDATE userprofile SET "; |
682 | query += "profilePartner=:profilePartner, "; | ||
683 | query += "profileURL=:profileURL, "; | 682 | query += "profileURL=:profileURL, "; |
684 | query += "profileImage=:image, "; | 683 | query += "profileImage=:image, "; |
685 | query += "profileAboutText=:abouttext,"; | 684 | query += "profileAboutText=:abouttext,"; |
@@ -693,7 +692,6 @@ namespace OpenSim.Data.SQLite | |||
693 | { | 692 | { |
694 | cmd.CommandText = query; | 693 | cmd.CommandText = query; |
695 | cmd.Parameters.AddWithValue(":profileURL", props.WebUrl); | 694 | cmd.Parameters.AddWithValue(":profileURL", props.WebUrl); |
696 | cmd.Parameters.AddWithValue(":profilePartner", props.PartnerId.ToString()); | ||
697 | cmd.Parameters.AddWithValue(":image", props.ImageId.ToString()); | 695 | cmd.Parameters.AddWithValue(":image", props.ImageId.ToString()); |
698 | cmd.Parameters.AddWithValue(":abouttext", props.AboutText); | 696 | cmd.Parameters.AddWithValue(":abouttext", props.AboutText); |
699 | cmd.Parameters.AddWithValue(":firstlifeimage", props.FirstLifeImageId.ToString()); | 697 | cmd.Parameters.AddWithValue(":firstlifeimage", props.FirstLifeImageId.ToString()); |