- Joined
- Apr 16, 2011
- Messages
- 640
- Reaction score
- 65
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.
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.
Code:
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