No trade to attunable

[xplodr]

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

[Kingly_Krab]

Read notes inside to see what each does.

/*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]

That's awesome, thanks Kingly_Krab!

[Kingly_Krab]

You're welcome!

[xplodr]

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]

Yes. :3

/*To make all items all races*/
UPDATE item SET `races` = 65535 WHERE `races` < 65535;

[Uleat]

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

[ChaosSlayerZ]

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

[xplodr]

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]

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]

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

/*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]

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

[xplodr]

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]

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]

thanks Burningsoul