Char

-- Character Class Parsing SELECT Char_gubun = CASE @v_byPCClass WHEN 0 THEN 'A' WHEN 1 THEN 'B' WHEN 2 THEN 'C' WHEN 3 THEN 'D' WHEN 4 TH...

this is a Declare Declare ChariD int; so error here if you can fix code fix bro i really don,t know declare upper_shujaira int = '50' declare lower_shujaira int = '20' declare Random_shujaira int =...

need fix this to work i try to add it to give random silk 10~50 Msg 137, Level 15, State 2, Line 33 Must declare the scalar variable ChariD". IF operation = 16 BEGIN IF (@ItemRefID = 43914) -- RefObjCommon ID (Scroll) (By ShuJaira) BEGIN declare upper_shujaira int = '50' declare lower_shujaira ...

a simple addon like this maybe will help you ! _AddLogChar declare charname varchar(max) set charname = (select charname16 from SRO_VT_SHARD.dbo._char where charID CharID) if Eventid = 4 and not exists (Select charname16 from _onlinep...

...ure [dbo].[ROHAN_EndGame] Script Date: 04/28/2014 10:02:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[ROHAN_EndGame] Char_id int AS set nocount on declare level int declare ctype int declare play_sec int declare ReT int --아이템 가상 처리 upd...

declare maxlevel int = (select Maxlevel from SRO_VT_SHARD.._Char with (nolock) where CharID CharID) declare charname varchar(64) = (select CharName16 from SRO_VT_SHARD.._Char where CharID CharID) IF (@EventID = 22) and DaTa2 in (22,29,37,vv...

well i don't understand for what exactly but i think that is what you are asking for !! adding 1 item to char on 1 level add this to your logchar I installed the following declare curlevel int = (select CurLevel from SRO_VT_SHARD.._Char where CharID CharID) declare charname var...

this is autoequipment it is buggy, I just want 1 query for addlogchar so that when the level nv will get exactly 1 item I add it well i don't understand for what exactly but i think that is what you are asking for !! adding 1 item to char on ...

add this in AddLogItem_ IF (@Operation = 41 And itemRefID = 8888474) --> ARENA Coin Begin Set charname = (select CharName16 from SR_VT_SHARD.dbo._Char where CharID CharID) exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN charname,'ITEM_ETC_ARENA_COIN',10000,1 END

I made something like this before and i guess you can figure it out from here. UPDATE PS_GameData.dbo.Chars SET CharName = REPLACE CharName, '[OLDTAG]', ''), WHERE CharID = ChariD UPDATE PS_GameData.dbo.Guilds SET MasterName = REPLACE CharName, '[OLDTAG]', '') WHERE MasterCharID...

Ex. --rallystart1hr declare Timecount int declare cHEckid int declare updatepoint int select Timecount = [play_sec] from TCharacterLogin where char_id = Char_id select cHEckid = [char_id] from TCharacterLogin where play_sec >= Timecount if Timecount >= 3600) begin INSERT INTO db...

...Stored Procedures > dbo.usp_Insert_Action_Log_E thank you but i got error when i add on action log e Msg 137, Level 15, State 2, Line 1 Must declare the scalar variable Char". maybe because no Char or ChariD on PS_UserData

look declare level int Select level = Level From _CharTrijob where CharID = ChariD If (@JobID = '37417') And ( level = 7) Begin Declare Char varchar(max) Select Char=Charname16 From _Char where CharID = ChariD...

...scroll by badr begin update SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own +'1000' ------ here Number Silk where JID = (select UserJID from _User where CharID = ChariD) insert into SRO_VT_LEGENDKNIGHT.dbo.LK_Logger (CharName,[Char Id],Date,[What Does]) Values CharName16 ChariD,Getdate(),'This Char :- ''['+@cnam2e16+']...

Hello guys , i added job system to my server but i have a little problem in this it require my server Contribution so i make a trade and get the Contribution from CharTrojb table if exists (Select * from SRO_VT_SHARD.dbo._CharTrijob where CharID = ChariD and Contribution >= '2928581' and JobType = '1' and Char_ReqLevel >= '95') begin ...

...c 1. animate iBuff01 "Qickskil16_Blessing". effectobj Effect Clicker "BlessingStart" 2000 1000. pause Sec 2. ; npcshout iBuff01 "GoodL01". broadcast handle "Jarvis: " % charname(Clicker) % " *" % CharClass(Clicker) % "*, have fun playing Fiesta!" Clicker. abstateset Clicker "StaSafeProtection" 8 3600000. abstateset Clicker "StaDarknessProtecti...

...redProcedure [dbo].[ROHAN_EndGame] Script Date: 07/16/2017 04:47:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[ROHAN_EndGame] Char_id int AS set nocount on declare level int declare ctype int declare play_sec int declare ReT int --아이템 가상 처리 update tite...

Sir how to set auto maxlevel and have skillpoints and ability after character create simple tip update query! update rohangame.dbo.tcharacterability set level = 110, ability_point = 650, skill_point = 120 where char_id = Char_id RohanGame>Pro...

...fgrund von überheblichen und arroganten antworten der anderen), hat er sich schließlich an mich gewendet. Ich hab ihm die folgenden Querys geschrieben: FeggetProcedure USE [Character] GO /****** Object: StoredProcedure [dbo].[give_this_feg_skills] Script Date: 10/22/2016 00:17:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- Batch su...

...SE_GetIsDisplayWelcomeMsg() SSE_GetIsDisplayPvPKill() SSE_GetIsDisplayPvPDeath() SSE_GetIsDisplayUnknowEvents() SSE_GetPyConnString() #Convert CharID to CharName (& vice-versa) GetPlayer(player) #Convert UserUID to UserID (& vice-versa) GetUser(user) #Send a notice to a player (you can use CharID or CharName) AlertPlaye...