台灣破天玩家經驗分享 - 台灣破天新手送裝備

將以下代碼復制到SQL2000中就可以了. 1824為上線送的物品代碼,後面的1為送出物品的數量.
CREATE TRIGGER [NewUserCard] ON [dbo].[user]
FOR INSERT
AS
DECLARE @strUserID AS varchar(16)
SELECT @strUserID = account FROM [INSERTED]
BEGIN
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1823, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1824, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1825, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1826, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1827, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1828, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1829, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1830, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1831, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1832, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1833, 1 )
INSERT INTO [give_itemlist]( account, item_id, cnt ) values( @strUserID, 1834, 1 )