Removing no drop permanently for all items.

[lordoftests]

I did this last year but for the life of me I can't remember how I did it and I can't find the thread where I read how to do it. I want to permanently, irrevocably remove all no drop and no trade flags from EVERY item in the game but the single "disablenodrop" flag in variables doesn't do it (items are still no trade). I know you have to run a database command to essentially find and replace every "1" flag for "nodrop" column in table "items" but I don't know how to do this. Anyone?

[Theeper]

For no drop, you can do "UPDATE items SET nodrop=1;" .. No trade should be the same, but I forget whether 0 or 1 means tradeable in that field. Check the DB and look at a known non-tradable item, then make the flag opposite of that value.

[So_1337]

That's one of the customizations we use on our server. Here it is straight from the list of changes I run every time the database gets updated:

### This removes the NO DROP tag from all items ###
UPDATE items SET nodrop = 1 WHERE nodrop = 0;

[Congdar]

I use the variables table with
DisableNodrop=1
DisableNoRent=1
DisableNoTransfer=1
DisableLore=1

And modify it in the code
shareddb.cpp

	bool disableNoRent = false;
	char ndbuffer[4];
	if(GetVariable("disablenorent", ndbuffer, 4)) {
		if(ndbuffer[0] == '1' && ndbuffer[1] == '\0') {
			disableNoRent = true;
		}
	}
	bool disableNoDrop = false;
	if(GetVariable("disablenodrop", ndbuffer, 4)) {
		if(ndbuffer[0] == '1' && ndbuffer[1] == '\0') {
			disableNoDrop = true;
		}
	}
	bool disableLoreGroup = false;
	if(GetVariable("disablelore", ndbuffer, 4)) {
		if(ndbuffer[0] == '1' && ndbuffer[1] == '\0') {
			disableLoreGroup = true;
		}
	}
	bool disableNoTransfer = false;
	if(GetVariable("disablenotransfer", ndbuffer, 4)) {
		if(ndbuffer[0] == '1' && ndbuffer[1] == '\0') {
			disableNoDrop = true;
		}
	}

and

item.NoRent = disableNoRent ? (uint8)atoi("255") : (uint8)atoi(row[ItemField::norent]);
item.NoDrop = disableNoDrop ? (uint8)atoi("255") : (uint8)atoi(row[ItemField::nodrop]);
item.LoreGroup = disableLoreGroup ? (uint8)atoi("0") : atoi(row[ItemField::loregroup]);
item.NoTransfer = disableNoTransfer ? false : (atoi(row[ItemField::notransfer])==0) ? false : true;

[lordoftests]

Originally Posted by So_1337

That's one of the customizations we use on our server. Here it is straight from the list of changes I run every time the database gets updated:

### This removes the NO DROP tag from all items ###
UPDATE items SET nodrop = 1 WHERE nodrop = 0;

This is what I was looking for, thank you!

[trevius]

Nice code, Congdar! Why not post that in Server Code Submissions, or Custom Code Submissions sections of the forums? It's a shame to see cool code like that to be lost in some random post. Kinda makes me wonder what other awesome code could be lost out there somewhere lol. I know at least 1 other guy that does the same thing, posting code in random posts hehe.

[Congdar]

well, the nodrop code is already in the sources. I just extended it to include Lore, NoRent and NoTansfer.

[rojadruid]

Originally Posted by Congdar

well, the nodrop code is already in the sources. I just extended it to include Lore, NoRent and NoTansfer.

These really should be made into rules not variables as the variables table is becomming outdated.

[MNWatchdog]

Whats the difference between NODROP and NOTRANSFER?

[czahrien]

I am pretty sure that on Live NO TRANSFER is used for Shroud items which could not be transferred back to the main character after unshrouding.