Vsro 1.88 not update skill in F1

Page 2 of 2

01/12/2017 20:23 Goofie#16

Quote:

Originally Posted by peajastr

hi thank you Goofie
but i don't understand some query .. can you explain ?
or what should i do for fix this problem.. step by step

thank you!

READ -> READ -> READ -> READ

01/13/2017 03:38 DevilArrow#17

Quote:

Originally Posted by Goofie

IN [SRO_VT_SHARD].[dbo].[_AddNewChar] procedure.

This is what you are missing @[Only registered and activated users can see links. Click Here To Register...] of the file, Skip all retards above me.

i execute that query?
or what is that?

i have like that and still the problem bro
[Only registered and activated users can see links. Click Here To Register...]

01/13/2017 09:40 !Ego#18

Quote:

Originally Posted by DevilArrow

i execute that query?
or what is that?

i have like that and still the problem bro
[Only registered and activated users can see links. Click Here To Register...]

That's it
now it should be fixed on New created chars
on old one u have to use the command :

PHP Code:


			
UPDATE _RefCharDefault_Quest SET Service = 1

delete from _CHARQUEST where QuestID = 1

INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestDat a1,QuestData2) SELECT CharID, 1,5,0, '2012-04-13 20:44:00','2012-04-13 20:44:00',31458135,0 FROM _CHAR where CharID > 0

01/13/2017 18:29 Goofie#19

Quote:

Originally Posted by BuiLt4KiLl

That's it
now it should be fixed on New created chars
on old one u have to use the command :

PHP Code:

UPDATE _RefCharDefault_Quest SET Service = 1 delete from _CHARQUEST where QuestID = 1 INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestDat a1,QuestData2) SELECT CharID, 1,5,0, '2012-04-13 20:44:00','2012-04-13 20:44:00',31458135,0 FROM _CHAR where CharID > 0

That is not how you fix ur chars, you are just brain challenged. Deleting quests and enabling start quests has nothing to do with quick bar fix.

It's like saying REMOVING your database will fix your server issues, it will, but you can never run your server again.

01/13/2017 20:47 DevilArrow#20

Quote:

Originally Posted by BuiLt4KiLl

That's it
now it should be fixed on New created chars
on old one u have to use the command :

PHP Code:

UPDATE _RefCharDefault_Quest SET Service = 1 delete from _CHARQUEST where QuestID = 1 INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestDat a1,QuestData2) SELECT CharID, 1,5,0, '2012-04-13 20:44:00','2012-04-13 20:44:00',31458135,0 FROM _CHAR where CharID > 0

i execute that query and work only with old players
but with new players the bug appears

02/28/2024 19:29 VW2012#21

Quote:

Originally Posted by DevilArrow

i execute that 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

PHP Code:


			
    INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)        
    SELECT  [MENTION=993253]newchar[/MENTION]ID, ID, 1, 0, getdate(), getdate(), 0, 0        
    FROM _RefQuest
    WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest  with(nolock) WHERE (Race =  [MENTION=1575172]Country[/MENTION] or Race = 3) and RequiredLevel = 1 and Service = 1)
    IF (@@error <> 0)
    BEGIN
        ROLLBACK TRANSACTION        
        RETURN -17        
    END

4. replace with

PHP Code:


			
    INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)        
    SELECT  [MENTION=993253]newchar[/MENTION]ID, ID, 1, 0, getdate(), getdate(), 0, 0        
    FROM _RefQuest
    WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest  with(nolock) WHERE (Race =  [MENTION=1575172]Country[/MENTION] or Race = 3) and RequiredLevel = 1 and Service = 1)
    UPDATE _CharQuest SET QuestData1 = 31458135 WHERE QuestID = 1
    IF (@@error <> 0)
    BEGIN
        ROLLBACK TRANSACTION        
        RETURN -17        
    END

5. Execute query

6. Restart Server

Page 2 of 2