sript for [PaidItem]

Use Telecaster
DECLARE @id int; --accountid
DECLARE @itemcount int; --Anzahl der Items
DECLARE @item int;
DECLARE @avatarid int;

-----------Insert Settings here-----------------
SET @item = '' --INSERT ITEM ID (e.g. 2010764 R6 Cloak)
SET @itemcount = '1' --INSERT THE NUMBER OF ITEMS
SELECT @avatarid = sid FROM Character WHERE name = '' --INSERT CHARACTER NAME
------------------------------------------------

SELECT @id = account_id FROM Character WHERE sid = @avatarid

--Warning
IF @id IS NULL
BEGIN
PRINT 'WARNING: This Character does not exist. No Rows affected!'
RETURN
END

--DB Update
INSERT INTO [telecaster].[dbo].[PaidItem]([account_id],[avatar_id],[avatar_name],[item_code],[item_count],[rest_item_count],[bought_time],[valid_time],[server_name],[taken_avatar_id],[taken_avatar_name],[taken_server_name],[taken_time],[taken_account_id],[confirmed],[confirmed_time]) VALUES (@id,@avatarid,NULL,@item,@itemcount,@itemcount,'2011-10-01 12:00:00.000',NULL,NULL,NULL,NULL,NULL,NULL,@id,NULL,NULL)

USE [Telecaster]
 GO

 DECLARE @return_value int
 DECLARE @id int, @i int
 
 SET @i=1 -- or 2 if you have a card of the bear track as this card isn't displayed in table Item
 
 DECLARE ASD CURSOR DYNAMIC SCROLL READ_ONLY FOR 
 SELECT [id] FROM [ItemResource] order by id
 OPEN ASD 
 FETCH FIRST FROM ASD INTO @id
 WHILE (@@FETCH_STATUS=0)
 BEGIN
 EXEC [dbo].[smp_insert_item]
 @IN_SID = @i,
 @IN_OWNER_ID = 1, --Char ID (ID which you have created recently the new character mandatory to LEARN WHAT and to interpose for a place of this digit!!!)
 @IN_ACCOUNT_ID = 0,
 @IN_SUMMON_ID = 0,
 @IN_AUCTION_ID = 0,
 @IN_KEEPING_ID = 0,
 @IN_CODE = @id,
 @IN_IDX = @i,
 @IN_FLAG = 0,
 @IN_CNT = 1, 
 @IN_LEVEL = 1, 
 @IN_ENHANCE = 0, 
 @IN_ENDURANCE = 100,
 @IN_GCODE = 1,
 @IN_REMAIN_TIME = 1312186301,
 @IN_ELEMENTAL_EFFECT_TYPE = 0,
 @IN_ELEMENTAL_EFFECT_EXPIRE_TIME = N'1970-01-01 06:00:00.000',
 @IN_ELEMENTAL_EFFECT_ATTACK_POINT = 0,
 @IN_ELEMENTAL_EFFECT_MAGIC_POINT = 0
 set @i+=1 --or if it doesn't work that @i=@i+1 
 FETCH NEXT FROM ASD INTO @id
 END
 CLOSE ASD
 DEALLOCATE ASD

 SELECT 'Return Value' = @return_value

 GO

Use Telecaster
DECLARE @id int; --accountid
DECLARE @itemcount int; --Anzahl der Items
DECLARE @item int;
DECLARE @avatarid int;

-----------Insert Settings here-----------------
SET @item = '' --INSERT ITEM ID (e.g. 2010764 R6 Cloak)
SET @itemcount = '1' --INSERT THE NUMBER OF ITEMS
SELECT @avatarid = sid FROM Character WHERE name = '' --INSERT CHARACTER NAME
------------------------------------------------

SELECT @id = account_id FROM Character WHERE sid = @avatarid

--Warning
IF @id IS NULL
BEGIN
PRINT 'WARNING: This Character does not exist. No Rows affected!'
RETURN
END

--DB Update
INSERT INTO [telecaster].[dbo].[PaidItem]([account_id],[avatar_id],[avatar_name],[item_code],[item_count],[rest_item_count],[bought_time],[valid_time],[server_name],[taken_avatar_id],[taken_avatar_name],[taken_server_name],[taken_time],[taken_account_id],[confirmed],[confirmed_time]) VALUES (@id,@avatarid,NULL,@item,@itemcount,@itemcount,'2011-10-01 12:00:00.000',NULL,NULL,NULL,NULL,NULL,NULL,@id,NULL,NULL)