|
|
| (4 intermediate revisions by 4 users not shown) |
| Line 1: |
Line 1: |
| − | '''Deleting prims in unusual places'''
| + | #Redirect [[Tips]] |
| − | | + | |
| − | Occaisionally, one ends up with one or more prims that go to negative co-ordinates and would like to delete them. Here is one possible solution to that problem.
| + | |
| − | | + | |
| − | From a sqlite3 prompt or a mysql prompt, one can manipulate OpenSim.db or the mysql datastore directly:
| + | |
| − | select from prims where PositionX<"0";
| + | |
| − | delete from prims where PositionX<"0";
| + | |
| − | select count(*) from prims;
| + | |
| − | select from prims where PositionY<"0";
| + | |
| − | delete from prims where PositionY<"0";
| + | |
| − | select count(*) from prims;
| + | |
| − | select from prims where PositionZ<"0";
| + | |
| − | delete from prims where PositionZ<"0";
| + | |
| − | select count(*) from prims;
| + | |
| − | | + | |
| − | | + | |
| − | '''Deleting a few recently created prims'''
| + | |
| − | | + | |
| − | Occaisionally, one ends up with one or more prims that one would like to delete on a region but doesnt know where they are. Here is one possible solution to that problem.
| + | |
| − | | + | |
| − | Given the site, http://epochconverter.com, one can enter a human date and get a binary such as an epoch. For instance, 4/21/2008 19:00:34GMT is "1208797234"
| + | |
| − | | + | |
| − | Then, from a sqlite3 prompt or a mysql prompt, one can do:
| + | |
| − | select CreationDate from prims where CreationDate>"1208797234";
| + | |
| − | delete from prims where CreationDate>"1208797234";
| + | |
