Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-17-2007, 08:09 AM
Bakersman
Sarnak
 
Join Date: Aug 2007
Posts: 34
Default 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

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 12:20 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3