all manual transactions need to be made smart

we use the search function in our code explorer to find all transactional commands and then implement smart locking. it does require knowledge of the tables involved in each transaction of course