Send item to multiple players

[[ADM]_Dephisio]

I created this:

 Spoiler

declare @ tinyint, @ smallint
declare @id table (useruid int)

insert into @id (useruid)
select UserUID from PS_UserData.dbo.Users_master



SET @ = 0
SET @ = -1


WHILE @ <= 239)
BEGIN

SET @ = (SELECT COUNT(Slot) FROM PS_Billing.dbo.Users_Product WHERE UserUID in (SELECT UserUID FROM @id) AND Slot = @)

IF @ <= 0) BREAK
ELSE
SET @ = @+1

END

INSERT INTO PS_Billing.dbo.Users_Product
(UserUID, Slot, ItemID, ItemCount, ProductCode, OrderNumber, BuyDate)
SELECT UserUID, @, '1001','1','Premise', '1', GETDATE() FROM PS_UserData.dbo.Users_Master

This script send item to all players in bank teller. I want to create a condition to send 1 item for each ip address. Can someone help me??

Regards, Dephisio


EDIT: I found the solution by myself. Here's the query to send an item to bank teller to all account group by user IP. (If someone has multiple accounts with the same IP Address, it will send an item to only 1 account):

 Spoiler

DECLARE @ tinyint, @ smallint
DECLARE @ID table (UserUID int, UserIP varchar(15))

insert into @ID (UserUID, UserIP)
SELECT MAX(UserUID) as UserUID, MAX(UserIP) AS x FROM PS_USerData.dbo.Users_Master GROUP BY UserIP


SET @ = 0
SET @ = -1


WHILE @ <= 239)
BEGIN

SET @ = (SELECT COUNT(Slot) FROM PS_Billing.dbo.Users_Product WHERE UserUID in
(SELECT UserUID FROM @ID) AND Slot = @)

IF @ <= 0) BREAK
ELSE
SET @ = @+1

END

INSERT INTO PS_Billing.dbo.Users_Product
(UserUID, Slot, ItemID, ItemCount, ProductCode, OrderNumber, BuyDate)
SELECT UserUID, @, '1001','1','Premise', '1', GETDATE() FROM @ID

I didn't find anything on ePvP about it so I decided to create mine. You're welcome