Our website is made possible by displaying online advertisements to our visitors.
Please consider supporting us by disabling your ad blocker.
Please consider supporting us by disabling your ad blocker.
OpenSimWorld is the directory of 3D Virtual Worlds based on OpenSimulator and connected through the HyperGrid. Learn More
New Members
MaxMax, Palkovnikx, Cullen_Bohannon, MG_VAWD, 27535, TaliaStargarden, Edward10, Luna_Skye, Alvial, Emision1, Online Custom Gaming, BlancaRosa, Surpriisee, AvaCeleste, Annasweet, RebelNebula, Ghostmachinesing, AurrieLynne, Xmatttezx, EmiraBloomLikes
Remove objects from your inventory that have the same name, keeping the object with the last date.
Delete Duplicates in opensim database
DELETE ii1
FROM
inventoryitems ii1
INNER JOIN (
SELECT
inventoryName,
MAX(creationDate) AS max_creation_date
FROM
inventoryitems
GROUP BY
inventoryName
) ii2 ON ii1.inventoryName = ii2.inventoryName AND ii1.creationDate < ii2.max_creation_date;
Please backup your inventory first!!! Just in case you are not happy with the results. It really will do what it says. However, there is a case where a person has merged their inventory multiple times and duplicates have the same creation date. In that case the script would leave those duplicates. Be sure to write down the size of your inventory when you start, and note the size after you run the script.
Delete Duplicates in opensim database
DELETE ii1
FROM
inventoryitems ii1
INNER JOIN (
SELECT
inventoryName,
MAX(creationDate) AS max_creation_date
FROM
inventoryitems
GROUP BY
inventoryName
) ii2 ON ii1.inventoryName = ii2.inventoryName AND ii1.creationDate < ii2.max_creation_date;
Please backup your inventory first!!! Just in case you are not happy with the results. It really will do what it says. However, there is a case where a person has merged their inventory multiple times and duplicates have the same creation date. In that case the script would leave those duplicates. Be sure to write down the size of your inventory when you start, and note the size after you run the script.
Liked by: 
Comments
yes, i read how fsassets also wash baby's and create bread and .......
Tables in OpenSIM SQL data base is extreme stupid cross-linked from SL dev.team and next milion times patched from all who try to repair this or other.
Result.... all see result.
PLEASE ALL LOW, MID AND HIGH LEVEL EXPERTS TO STOP TO INVENT NEXT SHITS IN OPENSIM TOILET!!!
PLESE ALLOW TO FEW LAMERS, NEWBIES OR ALL WHAT YOU THINK FOR THEM BUT....
ALLOW TO OSGRID DEV.TEAM TO WORK AND STOP TO INVENT NEXT "GREAT SHIT"!!!
like(0)
Tables in OpenSIM SQL data base is extreme stupid cross-linked from SL dev.team and next milion times patched from all who try to repair this or other.
Result.... all see result.
PLEASE ALL LOW, MID AND HIGH LEVEL EXPERTS TO STOP TO INVENT NEXT SHITS IN OPENSIM TOILET!!!
PLESE ALLOW TO FEW LAMERS, NEWBIES OR ALL WHAT YOU THINK FOR THEM BUT....
ALLOW TO OSGRID DEV.TEAM TO WORK AND STOP TO INVENT NEXT "GREAT SHIT"!!!
haa yes, on the size side, but it is to have a cleaner inventory maybe not to reduce the number of assets.
Beside, I read that assets deduplication is made by the fsassets recording system
like(0)
Beside, I read that assets deduplication is made by the fsassets recording system
well. every object has a different uuid. :O and names and dates are included in the inventoryitems table in the robust database.
like(0)
why searching by name ? wouldn't it be better to search by uuid to remove inventory duplicates (but with a notecard telling what have been deleted ;) ) I have a hud doing that in SL, I would love to find it in OS ...
like(0)
Great! This will work only for naked and empty avatars used only to collect broken items from all possible stores but not use them.
After script may open "Trash store" with 100% broken items and partial packs...
Scripting is not mechanical proces! Must think 1 000 000 times and to make project and to define target before scripting!
like(0)
After script may open "Trash store" with 100% broken items and partial packs...
Scripting is not mechanical proces! Must think 1 000 000 times and to make project and to define target before scripting!
I have many items that are just called object but are different ones lol would be bad if I would do this
like(0)
Sounds like a great way to break outfits. And keep just the trashed version, and probably a lot more ways to save a new milliseconds of time to load inventory.
like(0)
Right you have to fix your outfits. The goal is to reduce inventory clutter. That's also why I told them to back it up, in case they are not willing to manually fix their outfits. In cases like mine where inventory had 10 or more duplicates of every item and is way over 140,000 items it's helpful.
like(0)
On an slighty unrelated note, there are PHP scripts of dubious value at Steamworks that can reduce the assets by examining all uses to reduce assets sizes. I think issues will occur as notecards can have UUIDs, and I doubt they have good UUID gatherer. I was just looking through the one in Opensim src and that would be a job to do in PHP.
like(0)