The following sql should aid you in your quest to rid yourself of door and zone restrictions.
Code:
-- Removes item requirements for all doors
update doors set keyitem = 0 where keyitem != 0;
-- Removes minimum level requirements for all zones
update zone set min_level = 0 where min_level != 0;
-- Removes status requirements for all zones
update zone set min_status = 0 where min_status != 0;
/* Removes flagging requirements from all zones */
update zone set flag_needed = '' where flag_needed != '';
It has already been said before but I am going to say it again this is not fool proof and you will still encounter restrictions because a lot of things are done using perl scripts. To fully remove all restrictions you will need to learn perl so that you can mod out the restrictions or you can simply delete the scripts. Deleting the scripts to remove a restriction could deprive you of content as alot of things are done in zone instances which are script created and controlled.
Threaded Mode
