How to insert mass in xshop to all players

[Emari]

i want to send as compansation example like cherry blossom wine to all players in xshop, if anyone have a query for this please share

by the way im using this query to insert to 1 user only maybe you can customized it to send mass to all users from memb_info data.

USE [MuOnline]
SET IDENTITY_INSERT T_InGameShop_Items ON
INSERT INTO T_InGameShop_Items (AccountID, UniqueCode, AuthCode, UniqueID1, UniqueID2, UniqueID3, InventoryType, GiftName, Message, UsedItem)
VALUES (
   (SELECT memb___id FROM MEMB_INFO WHERE memb___id = 'admin'), 
   (SELECT MAX(UniqueCode) FROM T_InGameShop_Items)+1,
   '298025574',
   '673',
   '465',
   '544',
   '1',
   NULL,
   NULL,
   '0'
);
SET IDENTITY_INSERT T_InGameShop_Items OFF

 

[KarLi]

i think here
(SELECT memb___id FROM MEMB_INFO WHERE memb___id = 'admin'),

i think it must be select memb id from memb info then update memb___id and without specific account so it updates to all accounts

 

[Emari]

i think here
(SELECT memb___id FROM MEMB_INFO WHERE memb___id = 'admin'),

i think it must be select memb id from memb info then update memb___id and without specific account so it updates to all accounts

no i want to get all the memb___id and instert into T_InGameShop_Items