Hints & Tricks
From OpenSimulator
(Difference between revisions)
| Line 12: | Line 12: | ||
select CreationDate from prims where CreationDate>"1208797234"; | select CreationDate from prims where CreationDate>"1208797234"; | ||
delete from prims where CreationDate>"1208797234"; | delete from prims where CreationDate>"1208797234"; | ||
| + | |||
| + | |||
| + | [[Category:Help]] | ||
Revision as of 07:41, 19 November 2010
 |
Languages: |
|
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";
