SQL Problem

USE [RohanNet]
GO
/****** Object: StoredProcedure [dbo].[BuyItem] Script Date: 06/02/2016 14:44:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[BuyItem] @[Only registered and activated users can see links. Click Here To Register...]_id nvarchar(50)
AS
BEGIN
DECLARE
@i as integer,
@[Only registered and activated users can see links. Click Here To Register...] as integer,
@[Only registered and activated users can see links. Click Here To Register...] as INTEGER,
@[Only registered and activated users can see links. Click Here To Register...] as integer,
--
@[Only registered and activated users can see links. Click Here To Register...]_id as integer,
@[Only registered and activated users can see links. Click Here To Register...] as integer,
@[Only registered and activated users can see links. Click Here To Register...] as integer,
@[Only registered and activated users can see links. Click Here To Register...]_name as nvarchar(50),
@[Only registered and activated users can see links. Click Here To Register...]point as integer
--
Set @[Only registered and activated users can see links. Click Here To Register...] = (Select user_id from RohanUser..TUser where login_id = @[Only registered and activated users can see links. Click Here To Register...]_id)
Set @i = 0
Set @[Only registered and activated users can see links. Click Here To Register...] = (SELECT COUNT('a') FROM RohanNet..UserCart where login_id = @[Only registered and activated users can see links. Click Here To Register...]_id and active = 1)
while @i < @[Only registered and activated users can see links. Click Here To Register...]
BEGIN
Set @[Only registered and activated users can see links. Click Here To Register...] = (Select TOP(1)[id] from RohanNet..UserCart where login_id = @[Only registered and activated users can see links. Click Here To Register...]_id and active = 1 order by id asc)
Set @[Only registered and activated users can see links. Click Here To Register...]_id = (Select [item_id] from RohanNet..UserCart where id = @[Only registered and activated users can see links. Click Here To Register...])
Set @[Only registered and activated users can see links. Click Here To Register...] = (Select [quantity] from RohanNet..IM_list where item_id = @[Only registered and activated users can see links. Click Here To Register...]_id)
Set @[Only registered and activated users can see links. Click Here To Register...] = (Select [price] from RohanNet..IM_list where item_id = @[Only registered and activated users can see links. Click Here To Register...]_id)
Set @[Only registered and activated users can see links. Click Here To Register...]_name = (Select [item_name] from RohanNet..IM_list where item_id = @[Only registered and activated users can see links. Click Here To Register...]_id)
Set @[Only registered and activated users can see links. Click Here To Register...]point = (Select [im_points] from RohanNet..UserInfo where login_id = @[Only registered and activated users can see links. Click Here To Register...]_id)
Insert into RohanMall..TItem(type,attr,stack,rank,equip_level, equip_strength,equip_dexterity,equip_intelligence, user_id,date)
Values @[Only registered and activated users can see links. Click Here To Register...]_id,0x00 @[Only registered and activated users can see links. Click Here To Register...],0,0,0,0,0 @[Only registered and activated users can see links. Click Here To Register...],GETDATE())
Insert into RohanNet..Point_Log(login_id,description,price,dat e)
Values @[Only registered and activated users can see links. Click Here To Register...]_id,'Purcharsed -' + @[Only registered and activated users can see links. Click Here To Register...]_name, @[Only registered and activated users can see links. Click Here To Register...],GETDATE())
Update RohanNet..UserInfo set im_points = @[Only registered and activated users can see links. Click Here To Register...]point - @[Only registered and activated users can see links. Click Here To Register...]
Update RohanNet..UserCart Set active = 0 where id = @[Only registered and activated users can see links. Click Here To Register...]
Set @i += 1
END
select @[Only registered and activated users can see links. Click Here To Register...], @i, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]_id, @[Only registered and activated users can see links. Click Here To Register...]
END