in every value
in every value
I can only see quotes on the room id, there are no other quotes.
standardQueries.AddQuery("UPDATE items SET room_id='0', x='0', y='0', z='0', rot='0' WHERE id = " + Item.Id + " ");
No quotes?
99.9% sure thats not the query you need to edit.