Help with Job Reward

[putzeimer195]

Hello Guys,

I tried to use this Job Reward

IF @EventID = 97 or EventID =91 and Data1=2 or EventID =91 and Data1=3
begin
DECLARE @TradeDifficulty INT,
@REWARDCOUNT INT,
@REQLEVEL TINYINT,
@Contribution int,
@RewardCode varchar(max),
@CharName varchar(max)
set @rewardcode = 'REWARD_ITEM_CODE'
set @charname = (select charname16 from shard.._char where charid = @charid)
Set @Contribution = (select contribution from shard.._chartrijob where charid = @charid)
set @RewardCount = '20' /* coin or silk amount */
set @reqLevel = (select curlevel from shard.._char where charid = @charid)
set @difficulty = case
When @contribution between 'lowest 5 star contribution' and 'highest 5 star contribution'
then 5
else 1
end
if @difficulty = 5 and @reqlevel = 100 /* 5 star and cur level = 100 */
begin
update shard.._charcos set ownercharid = 0,refcharid = 0 where ownercharid = @charid and refcharid in (select id from _refobjcommon where codename128 like '%COS_T%')
exec shard.._add_item_extern @charname,@rewardcode,@Rewardcount,1
end
end

From Lenius

My Problem is, that I get this error:

Must declare the scalar variable "@EventID".
Msg 137, Level 15, State 2, Line 10
Must declare the scalar variable "@charid".
Msg 137, Level Msg 137, Level 15, State 2, Line 1
15, State 2, Line 11
Must declare the scalar variable "@charid".
Msg 137, Level 15, State 2, Line 13
Must declare the scalar variable "@charid".
Msg 137, Level 15, State 1, Line 14
Must declare the scalar variable "@difficulty".
Msg 137, Level 15, State 2, Line 19
Must declare the scalar variable "@difficulty".
Msg 137, Level 15, State 2, Line 21
Must declare the scalar variable "@charid".

I hope any1 can help me :/

Thanks

[mtnman33]

under DECLARE put in :
@charid int,
@EventID int,
@difficulty int
and you should be good to go

however you might wanna change all the 'charid' to 'CharID' for easy system recall for any stored procedures you may run with this script , good luck

[​Exo]

PS:- the procedure is ****

I'd not recommend using it.

[putzeimer195]

Now i get only this error

IF @EventID = 97 or EventID = 91 and Data1=2 or EventID = 91 and Data1=3
begin
DECLARE @TradeDifficulty INT,
@REWARDCOUNT INT,
@REQLEVEL TINYINT,
@Contribution int,
@CharID int,
@EventID int,
@difficulty int,
@RewardCode varchar(max),
@CharName varchar(max)
set @rewardcode = 'ITEM_ETC_ARENA_COIN'
set @charname = (select charname16 from shard.._char where CharID = @CharID)
Set @Contribution = (select contribution from shard.._chartrijob where CharID = @CharID)
set @RewardCount = '20' /* coin or silk amount */
set @reqLevel = (select curlevel from shard.._char where CharID = @CharID)
set @difficulty = case
When @contribution between 'lowest 5 star contribution' and 'highest 5 star contribution'
then 5
else 1
end
if @difficulty = 5 and @reqlevel = 100 /* 5 star and cur level = 100 */
begin
update shard.._charcos set ownercharid = 0,refcharid = 0 where ownercharid = @CharID and refcharid in (select id from _refobjcommon where codename128 like '%COS_T%')
exec shard.._add_item_extern @charname,@rewardcode,@Rewardcount,1
end
end

Error :

Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@EventID".

[​Goofie​]

And people asking why their Database/files lagging while using ****** queries...

[Anonymous-6723]

IF @EventID = 97 or EventID = 91 and Data1=2 or EventID = 91 and Data1=3

Make that line above to be the same as the one below.

IF @EventID = 97 or @EventID = 91 and @Data1=2 or @EventID = 91 and @Data1=3

Don't use this! It's crappy coded.