need fix bug scroll reset stat

[NorseGodTyr]

Originally Posted by M@hmoud

error bro give me this msg

Msg 102, Level 15, State 1, Procedure _Scroll_Name, Line 16
Incorrect syntax near '@Charid'.
Msg 102, Level 15, State 1, Procedure _Scroll_Name, Line 22
Incorrect syntax near '@charname'.

If you don't know how to edit a simple query to make it work, leave the silkroad community so stupid you can't be ^^
Most people are just too stupid! so don't open a server if you can't do the simplest thing

i will give you some hints

1. use
2. fill your server with water to test whether it is watertight
3. throw the server on the window

[M@hmoud]

Originally Posted by alydandy

 Spoiler

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Scroll_Name] Script Date: 2/23/2020 1:43:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[_Scroll_Name]
@d int
as
begin

Declare @ varchar(20), @ttle int

set @ttle = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID =
(Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID = @d ))

-- Check if char ouside town dont tp him for non job cheating and other stuff ... !
if( @ttle ='1')
begin
Insert Into iLegendBot..iLegend_Tool (Service,Type,Target,Message,Date) values
(1,'Private' @,'sorry but you are not in town ',Getdate())
END
-- End of anti-cheating
else
begin
print 'ITEM_MALL_STATUS'
end
end

this should work

scroll work out town i need scroll work in town only

Originally Posted by NorseGodTyr

If you don't know how to edit a simple query to make it work, leave the silkroad community so stupid you can't be ^^
Most people are just too stupid! so don't open a server if you can't do the simplest thing

i will give you some hints

1. use
2. fill your server with water to test whether it is watertight
3. throw the server on the window

u can give me Procedure make scroll reset stat work in town only

[srothanglong]

I am using Sonzenbi's Query. It works perfectly

[M@hmoud]

Originally Posted by srothanglong

I am using Sonzenbi's Query. It works perfectly

u can give me full query scroll reset stat

[srothanglong]

Originally Posted by M@hmoud

u can give me full query scroll reset stat

Let's try it! Hope it works

[M@hmoud]

Originally Posted by srothanglong

Let's try it! Hope it works

RefSkill give me error in SR_ShardManager

_RefSkill

1	33802	1025	SKILL_STAT	    ???? ????	        SKILL_STAT	0	1	1	0	0	0	0	0	1000	0	0	0	3599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	255	255	0	0	0	0	0	255	255	255	255	item\etc\mall_optlevel_upgrade_scroll_1.ddj	SN_SKILL_RENAME	***	SN_SKILL_RENAME_TT_DESC	***	0	0	3	1667396966	1851946342	1685418593	1500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

[JoleChow*]

Originally Posted by M@hmoud

RefSkill give me error in SR_ShardManager

_RefSkill

1	33802	1025	SKILL_STAT	    ???? ????	        SKILL_STAT	0	1	1	0	0	0	0	0	1000	0	0	0	3599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	255	255	0	0	0	0	0	255	255	255	255	item\etc\mall_optlevel_upgrade_scroll_1.ddj	SN_SKILL_RENAME	***	SN_SKILL_RENAME_TT_DESC	***	0	0	3	1667396966	1851946342	1685418593	1500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

You can't only copy paste bro

[M@hmoud]

Originally Posted by JoleChow*

You can't only copy paste bro

u can give me full query scroll reset stat work with out bug or give me proc make scroll reset stst work in town only