newchar

...hat query and work only with old players but with new players the bug appears for fixed on new created characters 1. go to sro_vt_shard -->Stored Procedures 2. modify _AddNewChar 3. search for INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2) SELECT newcharID, ID, 1, 0, getdate(...

skill bar problem you can fix it via sro vt shard proc addnewchar ----------------------------------------------------------------------------- -- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â -------------------------------------------------------------...

Hello how are you. I hope you like this USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 22/08/2022 6:26:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[_AddNewChar] userJID INT, --@CharSlot INT, ...

...work with me use that in add new char INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2) SELECT newcharID, ID, 1, 0, getdate(), getdate(), 0, 0 FROM _RefQuest WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = Country or Race =...

...4 slots in the F1 Skill bar ? https://imgur.com/imPL27G.png Hi. Make a backup of your SRO_VT_SHARD database because I am not quite sure on how to do it. Go to _AddNewChar in the Stored Procedures, find this : http://i.epvpimg.com/wcobeab.jpg Replace it with this : INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, Sta...

put these lines into your addnewchar procedure DELETE FROM SRO_VT_SHARD.._CHARQUEST WHERE QUESTID BETWEEN 1 AND 2 AND CHARID newcharID INSERT SRO_VT_SHARD.._CharQuest(CharID, QuestID, Status,Achieve...

...change stone is normal change name.. so i make it different on tag item.. so if player want to removed their tag.. he can use name change stone.. UPDATE Chars SET CharName newcharName,RenameCnt=RenameCnt-1,OldCharName=@OldCharName, CharName_OLD = newcharName WHERE CharID=@CharID AND Del=0 IF @@ERROR <> 0 BEGIN GOTO ERROR_ROLLBACK END

...evel = 1, MaxLevel = 1, Strength = 20, Intellect= 20, RemainStatPoint= 0, ExpOffset = 0, RemainGold = 10000000, RemainSkillPoint = 0, InventorySize = 109 WHERE _Char.CharID = newcharID UPDATE _Items SET OptLevel='3', MagParamNum='7', MagParam1='12884901893', MagParam2='12884901899', MagParam3='21474836497', MagParam4='21474836509', MagParam5='21474836515',...

...Level = 1, MaxLevel = 1, Strength = 20, Intellect= 20, RemainStatPoint= 0, ExpOffset = 0, RemainGold = 1000000, RemainSkillPoint = 0, InventorySize = 109 WHERE _Char.CharID = newcharID UPDATE _Items SET OptLevel=10,Variance=1073741823,MagParamNum=6,MagParam1=858993459290,MagParam2=257698037898,MagParam3=5583457484950,MagParam4=30064771150 ,MagParam5=55834...

CREATE TRIGGER GimmiMaster ON dbo.tCharacter AFTER INSERT AS BEGIN DECLARE newcharNo INT SELECT newcharNo = nCharNo FROM inserted INSERT INTO dbo.tHolyPromise (nCharNo, nUpCharNo, nFlags) VALUES newcharNo, 4, 0) END GO Die 4 mit der gewünsc...

...s to add "@" at the beginning of the name, so when he logs into the account, he should pick up a new name for his character. By the way, this code of the guy above:Declare #newcharName varchar (64) = (select CharName16 from SRO_VT_SHARD.._Char where CharID = #ChariD and Charname16 not like '%@%') update SRO_VT_SHARD.._CharNameList set Charname16 = #newch...

...e16=CharName16 from SRO_VT_SHARD.._Char where CharID = ChariD Update SRO_VT_SHARD.._Char Set CharName16 = '@'+ charname16 Where CharID = ChariD Declare newcharName varchar (64) = (select CharName16 from SRO_VT_SHARD.._Char where CharID = ChariD and Charname16 not like '%@%') update SRO_VT_SHARD.._CharNameList set Charname16 ...

...se he have king honor buff, comn ofc he wont just create a new character, help me guys i need that Race changer so hard... Buffs => Easy. UPDATE _TimedJob SET CharID = newcharID WHERE CharID = OldCharID These can be done via teleporting. If you REALLY want to change the characters race, you could switch out the _Char.RefCharID. You also n...

...TCH_3.sql (_AddNewClientConfig Stored Procedure). How to deploy on dirty db: //If you are going to use dirty db then you have to execute these. INSERT _FriendGroup Values newcharID, 0, 'Unclassified') / newcharID (Write a query to get the charid from _Char table and let that query do it job) exec _AddNewClientConfig newcharID / newcharID (Write ...

...all without the gameserver / client crashing, this means the end of the avatar NPCS. DataBase Side: -Please execute SRO_VT_SHARD_PATCH_5.sql Note: you will have to edit _AddNewChar SP, if you want to use the max char count feature IF (@temp >= 4) //EDIT 4 to match your server / client config. BEGIN RETURN -2 END Note2: My client show...

...'Next') WHERE [Desc] like 'Current' /*new Random Time of Today+1*/ DECLARE nextdate datetime, Tomorrow datetime = GETDATE()+1, newcharID int; exec newcharID = SRO_VT_SHARD.dbo._RandomPlayerID exec SRO_VT_SHARD.dbo._GetRandomTime Tomorrow, nextdate OUTPUT U...

add this at between of: INSERT _CharNameList VALUES(@CharName, newcharID) Update SK_SILK SET SILK_OWN = 9999 WHERE JID = userJID if REFCharID >= 1907 and REFCharID <= 1919) EXEC....

Hi, my dears i'm trying all, use a lot of procedures _AddNewChar and nothing fix the problem... this my error im use this procedure and others but don't fix the problem USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddNewCh...

Edit: nope, it is a bug the admins are aware