Hints & Tricks

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
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 08:41, 19 November 2010


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";
Personal tools
General
About This Wiki