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