Hints & Tricks - Revision history

Makopoppo: Redirecting to Tips

2011-05-03T10:44:34Z

Redirecting to Tips

Makopoppo: Redirecting to Tips

2011-01-03T06:38:18Z

Redirecting to Tips

Fritigern at 15:41, 19 November 2010

2010-11-19T15:41:47Z

Ideia Boa at 19:01, 21 May 2009

2009-05-21T19:01:36Z

Ckrinkea at 00:18, 27 April 2008

2008-04-27T00:18:54Z

Ckrinkea at 18:06, 26 April 2008

2008-04-26T18:06:25Z

Ckrinkea: New page: '''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 possib...

2008-04-26T17:46:40Z

New page: '''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 possib...

New page

'''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";

← Older revision		Revision as of 10:44, 3 May 2011
Line 1:		Line 1:
	#Redirect [[Tips]]		#Redirect [[Tips]]
−	~~{{delete\|The contents in this page were integrated into [[Tips]].}}~~

← Older revision		Revision as of 15:41, 19 November 2010
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]]

← Older revision		Revision as of 19:01, 21 May 2009
Line 1:		Line 1:
		+	__NOTOC__
		+	{{Template:Quicklinks}}
		+	<br />

	'''Deleting a few recently created prims'''		'''Deleting a few recently created prims'''

← Older revision		Revision as of 00:18, 27 April 2008
Line 1:		Line 1:
−	~~'''Deleting prims in unusual places'''~~
−
−	~~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'''		'''Deleting a few recently created prims'''

← Older revision		Revision as of 18:06, 26 April 2008
Line 1:		Line 1:
		+	'''Deleting prims in unusual places'''
		+
		+	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'''		'''Deleting a few recently created prims'''

@@ Line 1: / Line 1: @@
-__NOTOC__
+#Redirect [[Tips]]
-{{Template:Quicklinks}}
+{{delete|The contents in this page were integrated into [[Tips]].}}
-<br />
-−
-'''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";
-−
-−
-[[Category:Help]]