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

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

Reply
 
Thread Tools Display Modes
  #1  
Old 05-21-2009, 11:27 PM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

unless he asks for actual sql comand =)

update items set augtype=1 where id=1001;

this will set item with id# 1001 to be type 1 augment

BTW considerign that ANy slot augment corespand to value 2147483647

this means thre are as many as 32 types of augments =)
Reply With Quote
  #2  
Old 05-22-2009, 06:17 AM
kimura0715
Fire Beetle
 
Join Date: Mar 2009
Location: Virginia
Posts: 27
Default

thanks for the replies, only problem is i want to change ALL augs to have all slots. the script u provided is one at a time right?
Reply With Quote
  #3  
Old 05-22-2009, 10:06 AM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

update items set augtype=2147483647 where itemtype=54;

this will set ALL augs in DB to be useable in ANY slot (in game it shows as- this aug can be placed in ANY slot rather than specific numbers)
Reply With Quote
Reply

Thread Tools
Display Modes

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 02:44 AM.


 

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