need fix bug scroll reset stat

Quote:

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'.

Quote:

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] @[Only registered and activated users can see links. Click Here To Register...]d int as begin Declare @[Only registered and activated users can see links. Click Here To Register...] varchar(20), @[Only registered and activated users can see links. Click Here To Register...]ttle int set @[Only registered and activated users can see links. Click Here To Register...]ttle = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID = (Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID = @[Only registered and activated users can see links. Click Here To Register...]d )) -- Check if char ouside town dont tp him for non job cheating and other stuff ... ! if( @[Only registered and activated users can see links. Click Here To Register...]ttle ='1') begin Insert Into iLegendBot..iLegend_Tool (Service,Type,Target,Message,Date) values (1,'Private' @[Only registered and activated users can see links. Click Here To Register...],'sorry but you are not in town ',Getdate()) END -- End of anti-cheating else begin print 'ITEM_MALL_STATUS' end end this should work

Quote:

Originally Posted by NorseGodTyr :facepalm: 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 [Only registered and activated users can see links. Click Here To Register...] 2. fill your server with water to test whether it is watertight 3. throw the server on the window

Quote:

Originally Posted by srothanglong I am using Sonzenbi's Query. It works perfectly ;)

Quote:

Originally Posted by M@hmoud u can give me full query scroll reset stat

Quote:

Originally Posted by srothanglong Let's try it! Hope it works :) [Only registered and activated users can see links. Click Here To Register...]

_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	xxx	SN_SKILL_RENAME_TT_DESC	xxx	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

Quote:

Originally Posted by M@hmoud RefSkill give me error in SR_ShardManager Code: _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 xxx SN_SKILL_RENAME_TT_DESC xxx 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

Quote:

Originally Posted by JoleChow* You can't only copy paste bro :facepalm: