OpenSimWorld is the directory of 3D Virtual Worlds based on OpenSimulator and connected through the HyperGrid. Learn More
New Members
LindaKellieH, CruelPoison, My1stlife345, Professional, Malcucio, BarryArthur, Twinkle, SelenaAnnalize, LucasAcosta, Saster, ARTHUR725, LeFay, Elgarnan, Renatoremi, ChristyShadowwraith, LeoNaoki, 93356066, Densel, Nonplayer Character, Mia EngelLikes
Churchtown is now on the new servers... We have changed the tp and LM in the Town Hall... the group gifts settings... but not the thousands LM in all the freebies boxes... we will change them one shop after an other ... It may take a long time ... Thanks
Liked by: 
Comments
Hahah thanks again... but well if you do just one shop after the other you can see little details you didn't see before... I am not perfectionnist but I like things to be easy to find and in order.... ;-)
like(0)
you can bulk update. easiest way is to create new LM and get asset id and replace all the old lm asset id's with new asset id (should be easier than editing all the lms)
SELECT p.RegionUUID, p.UUID AS PrimUUID, p.Name AS PrimName, pi.itemID, pi.name, pi.assetID, pi.assetType, pi.invType FROM primitems pi JOIN prims p ON p.UUID = pi.primID WHERE pi.assetType = 3 AND pi.name LIKE '%OLD NAME%' ORDER BY p.Name, pi.name;
gives you a list / count
like(0)
SELECT p.RegionUUID, p.UUID AS PrimUUID, p.Name AS PrimName, pi.itemID, pi.name, pi.assetID, pi.assetType, pi.invType FROM primitems pi JOIN prims p ON p.UUID = pi.primID WHERE pi.assetType = 3 AND pi.name LIKE '%OLD NAME%' ORDER BY p.Name, pi.name;
gives you a list / count
That is why I stopped putting LMs in. I have moved too much and it is a pain. If people want to find you again, they will. Being listed here helps. Good luck!
like(0)