EQEmulator Forums - No trade to attunable

Page 1 of 3

Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - No trade to attunable (https://www.eqemulator.org/forums/showthread.php?t=36874)

xplodr

05-26-2013 08:36 AM

No trade to attunable

Is there any easy way to change all items that are no trade to attunable?

Kingly_Krab

05-26-2013 01:06 PM

Read notes inside to see what each does.

Code:

/*To make items that are No-Drop(No-Trade) Attuneable as well:*/

UPDATE items SET attuneable = 1  WHERE nodrop = 0;

/*To remove the No-Drop(No-Trade) quality and set items to Attuneable instead:*/

UPDATE items SET nodrop = 1, attuneable = 1 WHERE nodrop = 0;

xplodr

05-27-2013 02:12 AM

That's awesome, thanks Kingly_Krab!

Kingly_Krab

05-27-2013 04:27 PM

You're welcome!

xplodr

05-29-2013 12:52 PM

I don't suppose you know how to change race on items to all do you? So for example every race can wear leather tunic without modifying what classes can wear it? I mean of course besides going in and editing every single item manually lol.

Kingly_Krab

05-29-2013 04:03 PM

Yes. :3

Code:

/*To make all items all races*/

UPDATE item SET `races` = 65535 WHERE `races` < 65535;

Uleat

05-29-2013 06:10 PM

Yep..nothing like seeing a big ole' pot-bellied troll in a pink halfling-sized t-shirt that says "Princess" on it...

ChaosSlayerZ

05-29-2013 08:27 PM

all races doesn't necessarily mean all classes.
with exception of those rare all class robes

xplodr

05-30-2013 02:26 AM

Yeah, I understand that. Like the robe from Vulak going on a dorf cleric lol. I wonder if it will just show them naked on the chest :P

xplodr

05-30-2013 02:51 AM

I tried to do a command to remove LORE from all items using what I have been learning here but I failed. I typed UPDATE items lore = 0 WHERE lore = 1; but I got an error on syntax. Any idea what I did wrong? apparently quotation marks aren't necessary for my version of MySQL.

Kingly_Krab

05-30-2013 02:55 AM

Lore isn't marked by 'Lore', it's marked by 'loregroup'.

Code:

/*Takes away Lore from all items*/

UPDATE items SET `loregroup` = 0 WHERE `loregroup` = -1;

Here's a link to the Wiki Page for items: Items Wiki Page
Should help you out. :P

xplodr

05-30-2013 03:56 AM

Thanks again man, I really appreciate your help and advice!

xplodr

05-30-2013 04:01 AM

Do you know if there is a way for my players to gain their new spells when they gain a new level? Just the spells for the new level. Also, do you know how i can edit what items people start with so i can add my own server charm? And I would like to alter the starting zones so that people do not go into the tutorial because I want to turn that into an end game custom raid zone, plus I am re-itemizing the city starting areas so that people can get some starter gear from rats snakes gnolls etc.

Burningsoul

05-30-2013 04:51 AM

Starting items and zones are right next to each other in the database. Starting_items and start_zones tables.

Auto scribe is here, and comes with the bonus of skills and abilities as well.

For a reference, see the removing item limits thread. Some of it may be out of date.

cmileto

05-30-2013 06:05 AM

thanks Burningsoul

All times are GMT -4. The time now is 06:41 PM.

Page 1 of 3

Show 40 post(s) from this thread on one page