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, 09:57 PM
kimura0715
Fire Beetle
 
Join Date: Mar 2009
Location: Virginia
Posts: 27
Default Augs

i have searched for a way to do this but cant figure it out. how can i make all augs set to all aug types like 1,2,3,4,5,6,7,8,9,10,11,12??
Reply With Quote
  #2  
Old 05-21-2009, 10:13 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

The answer to this question is the same one from the post that was right below yours:

http://www.eqemulator.net/forums/showthread.php?t=28296
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #3  
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
  #4  
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
  #5  
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


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 01:53 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