Vsro 1.88 not update skill in F1

[​Goofie​]

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

[DevilArrow]

Originally Posted by ​Goofie​

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

This is what you are missing @ 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

[!Ego]

Originally Posted by DevilArrow

i execute that query?
or what is that?

i have like that and still the problem bro

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 


[​Goofie​]

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.

[DevilArrow]

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

[VW2012]

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