aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Bring us up to date.Tom2011-09-141-1/+0
|\
| * Save the default terrain texture UUIDs for a new region instead of leaving ↵Justin Clark-Casey (justincc)2011-09-091-1/+0
| | | | | | | | | | | | | | | | | | | | | | them as UUID.Zero. Leaving them at UUID.Zero meant that when a viewer 2 logged into a region that had been freshly created, it received UUID.Zero for these textures, and hence display the land as plain white. On a simulator restart, the problem would go away since when the database adapators loaded the new region settings, RegionSettings itself has code to use default textures instead of UUID.Zero. This commit resolves the problem by saving the default texture UUIDs instead of Zero. However, we currently have to do this in a roundabout way by resaving once the RegionSettings have been created by the database for the first time. This needless complexity should be addressed. This change will also have the effect of replacing any existing UUID.Zero terrain textures with the default ones. However, this shouldn't have any effect since the UUID.Zeros were already being replaced in memory with those same UUIDs.
* | Resolve merge commits, stage 1Tom2011-09-042-19/+7
|\ \ | |/
| * Remove code which was automatically deleting non-root prims from scene ↵Justin Clark-Casey (justincc)2011-09-011-17/+0
| | | | | | | | | | | | | | objects that had previous been attachments. Looks like this code was accidentally uncommented in e1b5c612 from feb 2010. Appears to resolve the rest of http://opensimulator.org/mantis/view.php?id=5664
| * In the asset service, check that an asset exists before attempting to store it.Justin Clark-Casey (justincc)2011-08-171-2/+7
| |
* | Allow removing users from search and avatar pickerMelanie2011-07-311-2/+2
| |
* | Don't store the default WL profile. This will prevent "valid" from beingMelanie2011-07-051-1/+1
| | | | | | | | set on the default profile and hopefully finally fix day and night
* | Merge branch 'careminster-presence-refactor' of ↵Melanie2011-06-203-0/+37
|\ \ | | | | | | | | | ssh://3dhosting.de/var/git/careminster into careminster-presence-refactor
| * \ Merge branch 'master' into careminster-presence-refactorMelanie2011-06-131-1/+1
| |\ \ | | |/
| | * Switched order of SQL statements in Friends migration -- resulted in the ↵Diva Canto2011-06-111-1/+1
| | | | | | | | | | | | wrong key
| * | Merge branch 'master' into careminster-presence-refactorMelanie2011-06-111-0/+16
| |\ \ | | |/
| | * For MySQL, migrate region tables to the MyISAM storage engine rather than InnoDBJustin Clark-Casey (justincc)2011-06-101-0/+16
| | | | | | | | | | | | | | | | | | | | | | | | Using MyISAM proves vastly faster for persisting scene objects. For instance, a scene object that took 9 seconds to persist before now takes 1. This also improves the experience of loading large OARs. We don't use any of the transactional features of InnoDB. The only thing that may have an impact is that InnoDB does row locking on inserts while MyISAM does table locking. However, field reports say there is no noticeable difference.
| * | Merge branch 'master' into careminster-presence-refactorMelanie2011-06-092-0/+21
| |\ \ | | |/
| | * This is the better solution: make the combined key be only on the first 36 ↵Diva Canto2011-06-011-1/+2
| | | | | | | | | | | | characters of each field -- that's the UUIDs. Thanks coyled. WARNING: Again, people who have gone through this migration and failed need to run it manually.
| | * It looks like there's a better solution for that problem.Diva Canto2011-06-011-2/+1
| | | | | | | | | | | | | | | | | | Revert "Changed Friends table to have 165-sized varchars on PrincipalID and FriendID. The reason for this number is the following: there is a combined key of these 2 fields; apparently MySql can't handle keys larger than 1000 bytes; when the table is created with utf8 encoding, this combined key is bigger than 1000 bytes, and the migration fails. WARNING: this is not a new migration! People who have gone through this migration and failed should update the sizes of these fields manually." This reverts commit 3fa54a156a83e498a7d5d0949a5f848fe82fe86f.
| | * Changed Friends table to have 165-sized varchars on PrincipalID and ↵Diva Canto2011-06-011-1/+2
| | | | | | | | | | | | FriendID. The reason for this number is the following: there is a combined key of these 2 fields; apparently MySql can't handle keys larger than 1000 bytes; when the table is created with utf8 encoding, this combined key is bigger than 1000 bytes, and the migration fails. WARNING: this is not a new migration! People who have gone through this migration and failed should update the sizes of these fields manually.
| | * More on HG Friends. Added Delete(string, string) across the board. Added ↵Diva Canto2011-05-221-4/+13
| | | | | | | | | | | | security to friendship identifiers so that they can safely be deleted across worlds. Had to change Get(string) to use LIKE because the secret in the identifier is not always known -- affects only HG visitors. BOTTOM LINE SO FAR: HG friendships established and deleted safely across grids, local rights working but not (yet?) being transmitted back.
| | * Fixed permissions bug related to friends in PermissionsModule. Added ↵Diva Canto2011-05-211-0/+5
| | | | | | | | | | | | FriendsData[] GetFriends(string principalID) to IFriendsData and FriendInfo[] GetFriends(string PrincipalID) to IFriendsService. Refactored some more in the FriendsModule. Made client get notification of local friends permissions upon HGLogin. HG Friends object permissions work.
| | * Merge branch 'master' of ssh://opensimulator.org/var/git/opensimDiva Canto2011-05-212-6/+31
| | |\
| | * | HG Friends working to some extent: friendships offered and accepted ↵Diva Canto2011-05-191-0/+6
| | | | | | | | | | | | | | | | correctly handled. Friends list showing correct foreign names. TODO: GrantRights.
* | | | Add some flags to control content in search betterMelanie2011-06-201-2/+7
|/ / /
* | | Add a missing virtual keywordMelanie2011-05-201-1/+1
| | |
* | | Make public interface methods in MySQLSimulation data virtual so the CMMelanie2011-05-201-14/+14
| | | | | | | | | | | | data layer can inherit from it
* | | Merge branch 'master' into careminster-presence-refactorMelanie2011-05-202-6/+31
|\ \ \ | | |/ | |/|
| * | Allow item links to be deleted even when other deletes and purges are disabled.Justin Clark-Casey (justincc)2011-05-192-6/+31
| |/ | | | | | | | | | | | | If these links are not deleted, then they will build up in the player's inventory until they can no longer log in. Accidental deletion of links due to bugs or other causes is potentially inconvenient but on a par with items being accidentally moved. When a link is deleted, the target of the link is never touched. This is a general solution that accounts for the use of links anywhere in the user's inventory.
| * Accidentally committed too earlyJustin Clark-Casey (justincc)2011-05-182-31/+6
| | | | | | | | | | | | Revert "Allow item links to be deleted even when other deletes and purges are disabled." This reverts commit 491279f99afc65860d44765ee7829c7dd5e4e38e.
| * Allow item links to be deleted even when other deletes and purges are disabled.Justin Clark-Casey (justincc)2011-05-172-6/+31
| | | | | | | | | | | | | | If these links are not deleted, then they will build up in the player's inventory until they can no longer log in. Accidental deletion of links due to bugs or other causes is potentially inconvenient but on a par with items being accidentally moved. When a link is deleted, the target of the link is never touched. This is a general solution that accounts for the use of links anywhere in the user's inventory.
* | Merge branch 'master' into careminster-presence-refactorMelanie2011-05-085-6/+6
|\ \ | |/
| * remove further mono compiler warningsJustin Clark-Casey (justincc)2011-05-065-6/+6
| |
* | Honor agent limit for region crossings and teleportsMelanie2011-04-211-10/+14
| |
* | Merge branch 'master' into careminster-presence-refactorMelanie2011-04-121-2/+13
|\ \ | |/
| * Include code to return more information about the NullReferenceException seen inJustin Clark-Casey (justincc)2011-04-111-2/+13
| | | | | | | | http://opensimulator.org/mantis/view.php?id=5403 prior to doing something about it.
* | Merge branch 'master' into careminster-presence-refactorMelanie2011-04-061-0/+30
|\ \ | |/
| * Make the "All Estates" option work from the client (this makes chosen ↵Justin Clark-Casey (justincc)2011-04-051-0/+30
| | | | | | | | | | | | | | | | changes to all the estates that the user owns). This applies to adding/removing estate users, groups, managers and bans. This is the application of the AllEstates_0.5.patch from http://opensimulator.org/mantis/view.php?id=5420 Thanks very much, Snoopy!
* | Merge branch 'master' into careminster-presence-refactorMelanie2011-03-271-0/+40
|\ \ | |/
| * On initial region registration, if the user chooses the option to make the ↵Justin Clark-Casey (justincc)2011-03-211-0/+40
| | | | | | | | region part of an existing estate, then list the existing region names.
* | Change avatar picker search to work properly when two name parts are usedMelanie2011-03-121-1/+1
| |
* | Merge branch 'master' into careminster-presence-refactorMelanie2011-03-106-11/+39
|\ \ | |/
| * Pull up Assembly of the MySQL classes as a protected property, so that it ↵Diva Canto2011-03-086-11/+39
| | | | | | | | can be overwritten in subclasses. That way extensions can decide in which assembly migration resources should be looked up. This is just a refactor -- no functional changes whatsoever.
* | Merge branch 'master' into careminster-presence-refactorMelanie2011-01-181-1/+1
|\ \ | |/
| * Also fix MySQLXInventoryDataMelanie2011-01-181-1/+1
| |
| * Prevent activation and deactivation of gestures from clobbering the slamMelanie2011-01-181-1/+1
| | | | | | | | bits
* | Prevent activation and deactivation of gestures from clobbering the slamMelanie2011-01-181-1/+1
| | | | | | | | bits
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-12-062-2/+9
|\ \ | |/
| * Fixed some inconsistency with trailing /. Made debug messages consistent. ↵Diva Canto2010-12-052-2/+9
| | | | | | | | Changed the stored region names of HG regions. Increased the size of regionName in DB.
* | Add the ability for gods to impersonate users. For this, bit 6 needs to beMelanie2010-11-251-0/+15
| | | | | | | | | | | | set in the target's UserFlags and the impersonator must have UserLevel 200 or above. The user can then log in using the target's name and their own password.
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-11-223-4/+21
|\ \ | |/
| * Added creator info across the board -- TaskInventoryItems and InventoryItems ↵Diva Canto2010-11-213-2/+11
| | | | | | | | | | | | themselves. Tested. Seems to be working, main tests pass. Nothing done for IARs or HG transfers yet -- this only works for OARs for the time being. New migration in inventory table in order to make CreatorID varchar(255).
| * Global creator information working on MySQL DB and on load/save OARs. ↵Diva Canto2010-11-212-2/+10
| | | | | | | | | | | | | | Creator name properly shown on the viewer as first.last @authority. New option added to save oar -profile=url. Migration on RegionStore making CreatorID be 255 chars. Moved Handling of user UUID -> name requests to a new module UserManagement/UserManagementModule.
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-11-031-0/+16
|\ \ | |/