aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/PGSQLRegionData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2017-01-05Massive tab and trailing space cleanupMelanie Thielker1-7/+7
2016-12-01 fix a typo in dbs region rangeUbitUmarov1-1/+1
2016-07-15PGSQL: Update simulation data with a number of missing fields for parcels. ↵Geir Nøklebye1-4/+2
Some of the fields should probably be migrated to type Boolean to avoid the hairy casting in the query. In addition the overall server code relies in the Replace in SQL statement that is proprietary to MySQL, so the PGSQL code is rather unsafe as it is. Should probably set a transaction on the whole operation so that if something goes wrong the database record is not zapped as it is now. PostgreSQL 9.5 has the upsert functionality which would bring the code closer to the MySQL version. This commit also has an update to PGSQLRegionData Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2016-01-10Fix region data range selection in the PGSQL backend.TomDataworks1-11/+53
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2013-12-06Reversing back to the row["ColumnName"] case field name. ↵Fernando Oliveira1-1/+1
http://opensimulator.org/mantis/view.php?id=6868
2013-11-25Corrected case to get columns from Regions table from PostgreSQL ↵Fernando Oliveira1-2/+2
http://opensimulator.org/mantis/view.php?id=6865 Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2013-10-12Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.Fernando Oliveira1-74/+114
* Added PostGreSQL support * Added MySQL/MySQLXGroupData.cs * PostgreSQL data access implementation * PostgreSQL dll binarie and RegionStore.migrations * Migrations Scripts from MSSQL to POSTGRES * Postgres SQL Type fixes * Postgres SQL Connection string * Data type issues * more fixes * tests and +tests * UUID x string - FIGHT! * Fixed PG types to internal csharp types * More data type fix (PostgreSQL fields are case sensitive) :( * more field case sensitive fixes * changed the migration files to be case sensitive for fields. * fixed fields case * finished converting, now search for hidden bugs. * some more fixes * bool type fixed * more case fixes; * creatorID case fixed * case fields fixed * fixed default now() for TMStamp fields with don't allow nulls. * fix case sensitve for Region name and Estate name * fixed case for names for search * fix class name Error * Bug fixed on select and migrations * Un-Reverting my change due to Postgres issue with the ILIKE function * Fixed some issued for Diva Distro * Fixes for integration with Diva Distro * Added System.Core to prebuild.xml for PG project * Configured to make DIff for Push to OpenSim Project * Diffs only to PostgreSQL mods.
2013-09-02Allow one to specify a DefaultHGRegion flag in [GridService] in order to ↵Justin Clark-Casey (justincc)1-0/+5
allow different default regions for HG and direct grid logins. This requires a new GridService.GetDefaultHypergridRegions() so ROBUST services require updating but not simulators. This method still returns regions flagged with just DefaultRegion after any DefaultHGRegions, so if no DefaultHGRegions are specified then existing configured defaults will still work. Immediate use is for conference where we need to be able to specify different defaults However, this is also generally useful to send experienced HG users to one default location and local users whose specified region fails (e.g. no "home" or "last") to another.
2012-11-15Revert "Merge master into teravuswork", it should have been avination, not ↵teravus1-1/+0
master. This reverts commit dfac269032300872c4d0dc507f4f9062d102b0f4, reversing changes made to 619c39e5144f15aca129d6d999bcc5c34133ee64.
2012-10-09Move OpenSim.Data.RegionFlags -> OpenSim.Framework.RegionFlags to make it ↵Justin Clark-Casey (justincc)1-0/+1
easier for other code to use (e.g. LSL_Api) without having to reference OpenSim.Data just for this.
2011-06-01Updates to MSSQL to most recent compatibility, also included Windlight ↵Chris Hart1-0/+1
support. Needs plenty of testing but clean install and migration from 0.6.9 have been tested and work, a few indexes still need to be added for performance.
2010-08-08Thank you, Marck00, for a patch that implemented region distance sortingMelanie Thielker1-2/+5
for fallback regions. Applied with changes.
2010-08-08Thank you, Marck00, for a patch that implemented region distance sortingMelanie Thielker1-2/+5
for fallback regions. Applied with changes.
2010-07-31White space from previous commit.Diva Canto1-27/+27
2010-07-31Implemented console command "show hyperlinks".Marck1-28/+27
2010-02-24MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride1-6/+28
works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
2010-01-09Preliminary work on the new default region setting mechanismMelanie1-0/+10
2009-10-19Formatting cleanup.Jeff Ames1-3/+3
2009-10-05MSSQL changes for Grid server in ROBUST plus some code tweaks 'n tidy upunknown1-1418/+198
2009-10-05MSSQL changes for Grid server in ROBUST plus some code tweaks 'n tidy upunknown1-1418/+198
2009-10-02- cleaning up LandData/ILandObject capitalization issuesdr scofield (aka dirk husemann)1-4/+4
- adding LandDataSerializer to OAR mechanics
2009-10-01Formatting cleanup.Jeff Ames1-1/+1
2009-09-03MSSQL Minor tweak to recent patch for region loading (Thanks Grumly57 for ↵Chris Hart1-0/+1
spotting it!)
2009-09-02MSSQL patch to mirror mantis 4077 for MySQL to improve region load timesChris Hart1-24/+38
2009-08-07* Remove hard coded 256 limitations from various places. There's no more ↵Teravus Ovares (Dan Olivares)1-6/+6
256m limitation within the OpenSimulator framework, however, the LLClient ClientView does not support regions larger then 256 meters so, if you try and make your region larger by setting Constants.RegionSize = 512; in OpenSim.Framework.Constants.cs, the terrain will not display on clients using the LLUDP protocol
2009-07-25* Updates libOMV to version 0.7.0Teravus Ovares1-2/+2
* Uses mantis #3811 as a base (thanks jhuliman) with changes. * E-mail regarding interface changes sent to the opensim-dev list * Archive: https://lists.berlios.de/pipermail/opensim-dev/2009-July/007219.html
2009-07-09Thank you, StrawberryFride, for a patch to fix MSSQL parameter naming.Melanie Thielker1-2/+2
2009-06-29From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague1-14/+5
Attached is a patch that changes the oar file saving of creation date/time to an integer instead of a string. I did this after justincc emailed me saying there is a problem with internationalisation doing it the old way and I said I'd fix it. Its been tested with MySQL and I've made the changes for MSSQL but that hasn't been well tested.
2009-06-22Formatting cleanup, ignore some generated files.Jeff Ames1-1/+1
2009-06-14Fixes Mantis #3793 . Committing thomax/Snoopy's patch to allow deeding of ↵Melanie Thielker1-7/+31
objects, with changes: - Set OwnerID = GroupID for deeded objects. - Close a security loophole that would have allowed a user with deed rights in a group to deed ANY object to that group, even if it's not owned by them and/or not set to that group - Set LastOwnerID correctly. Handle objects vs. prims correctly.
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-02-25* Refactored SOP.FolderID weirdness by removing calls to empty setter. YEs, ↵lbsa711-4/+1
I do realize the setter has to be there for legacy reasons, but since the calls will never acually DO anyhting, I'm removing them. * So, SOP.FolderID is actually a cruft field that should be removed.
2009-02-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey1-51/+54
* Changes varchar(36) columns to UUID type in MSSQL - this will be much more efficient * ===As always, please, please backup your database before applying this patch=== * Thanks Ruud Lathrop (for the patch) and StrawberryFride (for the review)
2009-02-12* optimized usings.lbsa711-1/+1
2009-02-06This changeset is the step 1 of 2 in refactoringDr Scofield1-2/+2
OpenSim.Region.Environment into a "framework" part and a modules only part. This first changeset refactors OpenSim.Region.Environment.Scenes, OpenSim.Region.Environment.Interfaces, and OpenSim.Region.Interfaces into OpenSim.Region.Framework.{Interfaces,Scenes} leaving only region modules in OpenSim.Region.Environment. The next step will be to move region modules up from OpenSim.Region.Environment.Modules to OpenSim.Region.CoreModules and then sort out which modules are really core modules and which should move out to forge. I've been very careful to NOT BREAK anything. i hope i've succeeded. as this is the work of a whole week i hope i managed to keep track with the applied patches of the last week --- could any of you that did check in stuff have a look at whether it survived? thx!
2009-01-29* If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey1-12/+21
is no prim where UUID = SceneGroupID), then force one prim to have UUID = SceneGroupID. * A warning is posted about this on startup giving the location of the object * This should allow one class of persistently undeletable prims to be removed * This change should not cause any issues, but I still suggest that you backup your database beforehand * If this doesn't work for previously linked objects, then you could also try the workaround in http://opensimulator.org/mantis/view.php?id=3059 * This change has been made to mysql and mssql, but sqlite appears to work in a different way
2009-01-19* Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey1-2/+0
* Since this is a db change, as always I strongly recommend that you backup your database before updating to this revision * Haven't touched MSSQL in case I get it wrong - looking for some kind soul to take care of this.
2009-01-12* Apply http://opensimulator.org/mantis/view.php?id=2965Justin Clarke Casey1-0/+1
* Adds first version of MsSql2005Dialect support for NHibernate * Thanks mpallari
2009-01-07Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-628/+573
Solves the problem of unable to load prim items on region start in MSSQL. The error was in the MSSQLRegionData code that loads objects from the database, due to reliance on the ParentID field that is not used.
2009-01-05* Stop bothering to populate and retrieve the parent local ids for MSSQL, as ↵Justin Clarke Casey1-2/+0
was done for SQLite and MySQL in r7586 * This may resolve http://opensimulator.org/mantis/view.php?id=2939
2008-12-20Mantis#2881. Thank you kindly, SirKimba for a patch that:Charles Krinke1-5/+5
Solves inserting Wolrdparameters in SQL Database with OpenSim.Data.MSSQL.dll always crash cause there were missing some fields in the Insert-String
2008-12-01Mantis#2730. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-2/+2
MSSQL Fix to accommodate random ParentIDs. uint values now cleanly converted to ints and vice versa to hopefully prevent outofrange exceptions on prim storage.
2008-11-21* refactor: Rip out SOP inventory from the partial into a separate classJustin Clarke Casey1-1/+1
* SceneObjectPartInventory.cs isn't a particularly good name but it's probably not got a long life * A proper inventory interface to follow * Parallel changes for other inventory partial classes to follow at a later date
2008-11-19Mantis#2658. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-0/+6
Keeping up with MySQL and SQLite. Small code changes and another resource file to add.
2008-11-19Mantis#2657. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-52/+30
Added access_time and create_time, plus the new sun position data to MSSQL code.
2008-11-15Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz1-1/+1
2008-11-15Mantis#2552: Thanks idb, for a patch that fixes persistence of physical prims.Homer Horwitz1-2/+1
(added a fix for the broken build from last commit, too)
2008-11-10* refactor: Expose SOG.SetRootPart for outsiders to use rather than setting ↵Justin Clarke Casey1-2/+2
RootPart and adding the part separately * Make RootPart read only
2008-10-27Thank you kindly, Ruud Lathrop for a patch that solves:Charles Krinke1-156/+181
Primary Key violation when just linked a lot of prims using MSSQL.
2008-10-18Thank you, Strawberry Fride, for a patch that brings MSSQL even with MySQLMelanie Thielker1-31/+35
generated by cgit v1.1 at 2024-12-20 16:02:54 +0000