aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2011-06-01Changed Friends table to have 165-sized varchars on PrincipalID and ↵Diva Canto1-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.
2011-05-22More on HG Friends. Added Delete(string, string) across the board. Added ↵Diva Canto1-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.
2011-05-21Fixed permissions bug related to friends in PermissionsModule. Added ↵Diva Canto1-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.
2011-05-19HG Friends working to some extent: friendships offered and accepted ↵Diva Canto1-0/+6
correctly handled. Friends list showing correct foreign names. TODO: GrantRights.
2011-05-19Allow item links to be deleted even when other deletes and purges are disabled.Justin Clark-Casey (justincc)2-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.
2011-05-18Accidentally committed too earlyJustin Clark-Casey (justincc)2-31/+6
Revert "Allow item links to be deleted even when other deletes and purges are disabled." This reverts commit 491279f99afc65860d44765ee7829c7dd5e4e38e.
2011-05-17Allow item links to be deleted even when other deletes and purges are disabled.Justin Clark-Casey (justincc)2-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.
2011-05-06remove further mono compiler warningsJustin Clark-Casey (justincc)5-6/+6
2011-04-11Include code to return more information about the NullReferenceException seen inJustin Clark-Casey (justincc)1-2/+13
http://opensimulator.org/mantis/view.php?id=5403 prior to doing something about it.
2011-04-05Make the "All Estates" option work from the client (this makes chosen ↵Justin Clark-Casey (justincc)1-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!
2011-03-21On initial region registration, if the user chooses the option to make the ↵Justin Clark-Casey (justincc)1-0/+40
region part of an existing estate, then list the existing region names.
2011-03-08Pull up Assembly of the MySQL classes as a protected property, so that it ↵Diva Canto6-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.
2011-01-18Also fix MySQLXInventoryDataMelanie1-1/+1
2011-01-18Prevent activation and deactivation of gestures from clobbering the slamMelanie1-1/+1
bits
2010-12-05Fixed some inconsistency with trailing /. Made debug messages consistent. ↵Diva Canto2-2/+9
Changed the stored region names of HG regions. Increased the size of regionName in DB.
2010-11-21Added creator info across the board -- TaskInventoryItems and InventoryItems ↵Diva Canto3-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).
2010-11-21Global creator information working on MySQL DB and on load/save OARs. ↵Diva Canto2-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.
2010-11-03Add lsClearWindlightScene() to the lightshare module to remove WL settingsMelanie1-0/+15
from a region and allow normal day cycles to be reestablished
2010-11-03When LightShare is enabled, the standard day cycle is bypassed and replaced byMelanie1-0/+1
midday defaults when no specific LightShare profile is set. This prevents LightShare info being send out when the region has no LightShare profile, allowing normal day/night cycles to happen.
2010-10-30Fix logins and avatar appearance. Contains a Migration. May contain nuts.Melanie1-0/+8
This will cause visual params to be persisted along with worn items. With this, alpha and tattoo laters will be saved. Multiple layers MAY work, but not tested because I don't use Viewer 2.
2010-10-18Alphabetize results on region search by prefix matchingMelanie1-0/+2
2010-10-18Bump migration version on LastSeen field so it is actually runMelanie1-1/+1
2010-10-15UPdated the MySql driver to 6.2.4. Also established a much larger ↵Diva Canto1-0/+1
MySqlCommand timeout on fetching prims.
2010-10-13fix build breakJustin Clark-Casey (justincc)1-1/+1
2010-10-13Correctly update the LastSeen fieldMelanie Thielker1-1/+1
2010-10-13Ensure no UUID.Zero region ID is ever written to presence. Add a MigrationMelanie Thielker2-1/+11
to add a LastSeen field of type "Timestamp" to Presence for MySQL
2010-09-16Changed SceneObjectGroup to store parts with the fast and thread-safe ↵John Hurliman1-1/+1
MapAndArray collection
2010-09-12* Added ISimulationDataService and IEstateDataServiceJohn Hurliman2-0/+18
* Removed StorageManager * CONFIG CHANGE: There are no more database settings in OpenSim.ini. Check the config-include configuration files for region store and estate store database settings
2010-09-12Formatting cleanup.Jeff Ames2-12/+12
2010-09-11Fixed the naming mess around data connectors for simulation dataJohn Hurliman1-1/+1
2010-09-11Re-enabled asset last access time logging in MySQLJohn Hurliman1-3/+0
2010-09-07Fix deletion persistence when freshly delinked prims are removedJustin Clark-Casey (justincc)1-0/+2
Previously, Scene.Inventory.DeRezObjects() forced the persistence of prims before deletion. This is necessary so that freshly delinked prims can be deleted (otherwise they remain as parts of their old group and reappear on server restart). However, DeRezObjects() deleted to user inventory, which is not required by llDie() or direct region module unlink and deletion. Therefore, forced persistence has been pushed down into Scene.UnlinkSceneObject() to be more general, this is still on the DeRezObjects() path. Uncommented TestDelinkPersistence() since this now passes. Tests required considerable elaboration of MockRegionDataPlugin to reflect underlying storing of parts.
2010-09-07Fix deletion persistence when freshly delinked prims are removedJustin Clark-Casey (justincc)1-0/+2
Previously, Scene.Inventory.DeRezObjects() forced the persistence of prims before deletion. This is necessary so that freshly delinked prims can be deleted (otherwise they remain as parts of their old group and reappear on server restart). However, DeRezObjects() deleted to user inventory, which is required by llDie() or direct region module unlink and deletion. Therefore, forced persistence has been pushed down into Scene.UnlinkSceneObject() to be more general, this is still on the DeRezObjects() path. Uncommented TestDelinkPersistence() since this now passes. Tests required considerable elaboration of MockRegionDataPlugin to reflect underlying storing of parts.
2010-09-05Remove "Dwell" support from core and replace it with calls to methodsMelanie Thielker1-4/+2
on IDwellModule
2010-08-30Implements parcel media setting persistence and packet / CAPS handlingJonathan Freedman2-4/+32
properly for the new media settings. Signed-off-by: Melanie <melanie@t-data.com>
2010-08-30local commit with parcel media bitsJonathan Freedman2-4/+32
Signed-off-by: Melanie <melanie@t-data.com>
2010-08-26Remove parts locking from data classes since these are using a copy of the ↵Justin Clark-Casey (justincc)1-107/+104
scene object
2010-08-26Improve consistency of locking for SOG.m_parts in order to avoid race ↵Justin Clark-Casey (justincc)1-103/+107
conditions in linking and unlinking
2010-08-19Skip conversion if fields that are null in the database. This mayMelanie Thielker1-0/+4
uncover errors elsewhere.
2010-08-13refactor: Use SOP.Flags rather than SOP.ObjectFlagsJustin Clark-Casey (justincc)1-2/+2
2010-08-10Enforce DB limits on region name to 32 chars, or else (not good). Removed a ↵Diva Canto1-0/+3
piece of code from Hyperlinker that didn't work anyway. Shortened the hyperlink region name.
2010-08-08Thank you, Marck00, for a patch that implemented region distance sortingMelanie Thielker1-2/+4
for fallback regions. Applied with changes.
2010-08-04fix mysql/mssql prim serialization problemJustin Clark-Casey (justincc)1-6/+2
2010-08-03Implement MediaUrl persistence for MySQL and MsSQLJustin Clark-Casey (justincc)1-2/+8
Not sure how I forgot this. This may resolve problems with media textures not persisting over restart for these databases.
2010-08-03get rid of PrimitiveBaseShape.MediaRaw staging postJustin Clark-Casey (justincc)1-3/+5
using an OSD serialization rather than auto forces serialization code to be placed in OpenSim.Framework this makes the media texture raw data staging post in PrimitiveBaseShape redundant, now we just directly call the code in PrimitiveBaseShape.MediaList itself
2010-07-31White space from previous commit.Diva Canto1-25/+25
2010-07-31Implemented console command "show hyperlinks".Marck1-23/+26
2010-07-26add mysql support for media on a primJustin Clark-Casey (justincc)2-3/+14
2010-07-26add mysql support for media on a primJustin Clark-Casey (justincc)2-3/+14
2010-06-27Added checks to XInventory DB layer to truncate names and descriptions.Diva Canto1-1/+9