Go Back   EQEmulator Home > EQEmulator Forums > General > General::General Discussion

General::General Discussion General discussion about EverQuest(tm), EQEMu, and related topics.
Do not post support topics here.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-28-2009, 05:25 PM
timyarb
Fire Beetle
 
Join Date: Dec 2007
Posts: 3
Default Grrr MySQL please Help

OK So with the database updates I have to go in and manually remove to Immune to magic (B) from the npc_types table each time. I can edit and change columns in the database if the entire record is changed (like changing no trade items to tradable) but the ability to remove the "Immune to Magic" only from the record is escaping me. I have scoured the internet looking for a way to do it but this is a classic evample of the blind leading the blind.

So my question is this is there a SQL command/query I can run that will allow me to remove the "B" from the column "npcspecialattks" in the table "npc_types" from the "peq" databse, while preserving any other entries contained in the column?

I hope that makes sense, I am such a MySQL noob it is not even funny.

Tim
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 10:28 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