Send an Item to all accounts

**Military** · 28-12-10

I need some kind of SQL code that sends and item to all character's storage.

**MentaL**

**Phoenix** · 28-12-10

How about using Emisand's panel to do that? It has the option. You can get the query from there as well.

**alfredao** · 28-12-10

This from Emisand CP

Code:

INSERT INTO AccountItem (AID, ItemID, RentDate, cnt)(SELECT ac.AID, 99999, GETDATE(), 1 FROM Account ac)

Edit 99999 to your ItemID

**Military** · 28-12-10

I mean all accounts at once not one account

**wesman2232** · 28-12-10

alfredao's post should work to give every account that item.

Re: Send an Item to all accounts