removing locked doors referance
 

i understand that some are wanting to do this but may have a hard time finding information about how to do this so i thought it may be usefull to someone at some point.

this is under the mysql table for doors this will set the lockpick field to ( 0 ) 0 being the number to not require the door to be picked or lock picking skill

UPDATE doors SET lockpick='0' WHERE id='5876';

this entry should essentially remove the need to use a key

UPDATE doors SET keyitem='0' WHERE id='1483';

i am trying this out but i have updated my fields and this should do the trick.
please remember to update the lockpick field next to the keyitem field and set it to 0. i am just starting out with this mysql so i do not want anyone to blame me for a mishap they did not intend to do to thier server, so please backup your database, as my server is for testing only at this time it does not affect me personally. so if you have people playing on your server always backup 8)

if there is issues with the command lines. i will post about them.

new values and defaults for keyitem and lockpick, simple copy and paste


key update
UPDATE doors SET keyitem='0' WHERE id='1483';
UPDATE doors SET keyitem='0' WHERE id='1484';
UPDATE doors SET keyitem='0' WHERE id='1487';
UPDATE doors SET keyitem='0' WHERE id='1500';
UPDATE doors SET keyitem='0' WHERE id='1502';
UPDATE doors SET keyitem='0' WHERE id='1503';
UPDATE doors SET keyitem='0' WHERE id='7301';
UPDATE doors SET keyitem='0' WHERE id='7302';
UPDATE doors SET keyitem='0' WHERE id='7739';
UPDATE doors SET keyitem='0' WHERE id='8002';
UPDATE doors SET keyitem='0' WHERE id='8004';
UPDATE doors SET keyitem='0' WHERE id='8006';
UPDATE doors SET keyitem='0' WHERE id='8007';
UPDATE doors SET keyitem='0' WHERE id='8008';
UPDATE doors SET keyitem='0' WHERE id='8009';
UPDATE doors SET keyitem='0' WHERE id='8012';
UPDATE doors SET keyitem='0' WHERE id='8013';
UPDATE doors SET keyitem='0' WHERE id='8014';
UPDATE doors SET keyitem='0' WHERE id='8015';
UPDATE doors SET keyitem='0' WHERE id='8016';
UPDATE doors SET keyitem='0' WHERE id='8324';
UPDATE doors SET keyitem='0' WHERE id='8325';
UPDATE doors SET keyitem='0' WHERE id='8833';
UPDATE doors SET keyitem='0' WHERE id='8926';
UPDATE doors SET keyitem='0' WHERE id='9478';

key default settings
UPDATE doors SET keyitem='unsure' WHERE id='1483';
UPDATE doors SET keyitem='20441' WHERE id='1484';
UPDATE doors SET keyitem='20444' WHERE id='1487';
UPDATE doors SET keyitem='20445' WHERE id='1500';
UPDATE doors SET keyitem='20443' WHERE id='1502';
UPDATE doors SET keyitem='20443' WHERE id='1503';
UPDATE doors SET keyitem='6378' WHERE id='7301';
UPDATE doors SET keyitem='6378' WHERE id='7302';
UPDATE doors SET keyitem='20883' WHERE id='7739';
UPDATE doors SET keyitem='20037' WHERE id='8002';
UPDATE doors SET keyitem='20036' WHERE id='8004';
UPDATE doors SET keyitem='20035' WHERE id='8006';
UPDATE doors SET keyitem='20039' WHERE id='8007';
UPDATE doors SET keyitem='20033' WHERE id='8008';
UPDATE doors SET keyitem='20034' WHERE id='8009';
UPDATE doors SET keyitem='20035' WHERE id='8012';
UPDATE doors SET keyitem='20033' WHERE id='8013';
UPDATE doors SET keyitem='20034' WHERE id='8014';
UPDATE doors SET keyitem='20037' WHERE id='8015';
UPDATE doors SET keyitem='20036' WHERE id='8016';
UPDATE doors SET keyitem='28060' WHERE id='8324';
UPDATE doors SET keyitem='28060' WHERE id='8325';
UPDATE doors SET keyitem='8010' WHERE id='8833';
UPDATE doors SET keyitem='19719' WHERE id='8926';
UPDATE doors SET keyitem='27650' WHERE id='9478';

lockpick update
UPDATE doors SET lockpick='0' WHERE id='5876';
UPDATE doors SET lockpick='0' WHERE id='5440';
UPDATE doors SET lockpick='0' WHERE id='1483';
UPDATE doors SET lockpick='0' WHERE id='1486';
UPDATE doors SET lockpick='0' WHERE id='1487';
UPDATE doors SET lockpick='0' WHERE id='1500';
UPDATE doors SET lockpick='0' WHERE id='1502';
UPDATE doors SET lockpick='0' WHERE id='1503';
UPDATE doors SET lockpick='0' WHERE id='7321';
UPDATE doors SET lockpick='0' WHERE id='8324';
UPDATE doors SET lockpick='0' WHERE id='8325';

default lockpick settings
UPDATE doors SET lockpick='130' WHERE id='5876';
UPDATE doors SET lockpick='150' WHERE id='5440';
UPDATE doors SET lockpick='45' WHERE id='1483';
UPDATE doors SET lockpick='40' WHERE id='1486';
UPDATE doors SET lockpick='40' WHERE id='1487';
UPDATE doors SET lockpick='25' WHERE id='1500';
UPDATE doors SET lockpick='25' WHERE id='1502';
UPDATE doors SET lockpick='50' WHERE id='1503';
UPDATE doors SET lockpick='100' WHERE id='7321';
UPDATE doors SET lockpick='200' WHERE id='8324';
UPDATE doors SET lockpick='200' WHERE id='8325';

from my understanding of the wiki and i may be wrong... but by removing the flags_needed under zone should open these zones up

UPDATE zone SET flag_needed='' WHERE short_name='sebilis';
UPDATE zone SET flag_needed='' WHERE short_name='charasis';
UPDATE zone SET flag_needed='' WHERE short_name='veeshan';
UPDATE zone SET flag_needed='' WHERE short_name='sleeper';
UPDATE zone SET flag_needed='' WHERE short_name='codecay';

min level removal

UPDATE zone SET min_level='0' WHERE short_name='airplane';
UPDATE zone SET min_level='0' WHERE short_name='fearplane';
UPDATE zone SET min_level='0' WHERE short_name='hateplane';
UPDATE zone SET min_level='0' WHERE short_name='veeshan';
UPDATE zone SET min_level='0' WHERE short_name='hateplaneb';
UPDATE zone SET min_level='0' WHERE short_name='templeveeshan';
UPDATE zone SET min_level='0' WHERE short_name='growthplane';
UPDATE zone SET min_level='0' WHERE short_name='thurgadinb';
UPDATE zone SET min_level='0' WHERE short_name='vexthal';
UPDATE zone SET min_level='0' WHERE short_name='potranquility';