Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Feature Requests

Development::Feature Requests Post suggestions/feature requests here.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #21  
Old 12-16-2014, 09:26 PM
Bandor
Hill Giant
 
Join Date: May 2014
Posts: 209
Default

upon running the SQL code I ran into a couple errors. First one kept saying column type 6 is nonexistant so I removed this code and it passed through

Code:
UPDATE items SET augslot6type = (augslot6type + 2) WHERE augslot6type = 20 OR augslot6type = 21;

Then when I get down to the bottom of the code it says error in my SQL synthax

Code:
) AND (
itemtype < 6 OR
itemtype = 8 OR
itemtype = 10 OR
itemtype = 35 OR
itemtype = 45
)
AND augslot5type = 0 AND itemclass = 0;


Upon logging into my server I can see what it did,switching all container ornaments to augs instead of containers and setting special ornaments with there own slot (21). It also removed slot 20 off my weapons and changed them to slot 22. So now would I simply edit my items and decide which get slot 20 and 21?

PS slot 21 is actually labeled special ornaments but it changed them from weapon augs to armor augs lol.
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 04: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