Quote:
Originally Posted by HECKT0R
|
going to try it just right now, hope it works :)
i will write back the result
i put this
use SRO_VT_SHARD
go
create proc _Scroll_Name
@ Charid int
as
begin
Declare @ charname varchar(20), @ isbattle int
set @ isbattle = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID =
(Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID =@ Charid ))
-- Check if char ouside town dont tp him for non job cheating and other stuff ... !
if( @ isbattle ='1')
begin
Insert into Notice (Service,Type,Target,Message,Date) values
(1,'Private',@ CharName,'sorry but you are not in town :) ',Getdate())
END
-- End of anti-cheating
else
begin
print 'ITEM_MALL_CHAR_NAME_SCROLL'
end
end
but its not working error excute pop up "Msg 102, Level 15, State 1, Procedure _Scroll_Name, Line 4
Incorrect syntax near 'int'.
Msg 102, Level 15, State 1, Procedure _Scroll_Name, Line 8
Incorrect syntax near 'varchar'.
Msg 137, Level 15, State 2, Procedure _Scroll_Name, Line 11
Must declare the scalar variable "@".
Msg 137, Level 15, State 2, Procedure _Scroll_Name, Line 14
Must declare the scalar variable "@".
Msg 137, Level 15, State 2, Procedure _Scroll_Name, Line 17
Must declare the scalar variable "@"."