[Solved] [Problem] F1 Skill bar

[[GM]Toni]

how can i delete the first 4 slots in the F1 Skill bar ?

[Judgelemental]

Originally Posted by [GM]Toni

how can i delete the first 4 slots in the F1 Skill bar ?

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 :




Replace it with this :

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 Status = 5 , QuestData1 = 77594711 where CharID = [MENTION=993253]newchar[/MENTION]ID and QuestID = 1
   UPDATE _CharQuest set Status = 5 where CharID = [MENTION=993253]newchar[/MENTION]ID and QuestID = 2
    IF (@@error <> 0)
    BEGIN
        ROLLBACK TRANSACTION        
        RETURN -17        
    END 


The result :

 Spoiler

Now, I am not sure if it will work. Restart your GameServer and create a new character.

Also, if it doesn't work, try this:

PHP Code:

UPDATE _RefCharDefault_Quest SET Service = 1
delete from _CHARQUEST where QuestID = 1
INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestData1,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 


[[GM]Toni]

really really very thanks <3
i will try now

[[GM]Toni]

Originally Posted by Judgelemental

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 :




Replace it with this :

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 Status = 5 , QuestData1 = 77594711 where CharID = [MENTION=993253]newchar[/MENTION]ID and QuestID = 1
   UPDATE _CharQuest set Status = 5 where CharID = [MENTION=993253]newchar[/MENTION]ID and QuestID = 2
    IF (@@error <> 0)
    BEGIN
        ROLLBACK TRANSACTION        
        RETURN -17        
    END 


The result :

 Spoiler

Now, I am not sure if it will work. Restart your GameServer and create a new character.

Also, if it doesn't work, try this:

PHP Code:

UPDATE _RefCharDefault_Quest SET Service = 1
delete from _CHARQUEST where QuestID = 1
INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestData1,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 got this error ? ! what can i do now ?

[Judgelemental]

Originally Posted by [GM]Toni

i got this error ? ! what can i do now ?

My bad, sorry. EPVP automatically mentions an user if the code has @ in it.

Simply delete @ from your code.

Before : @

after @ newchar (without the space between @ and newchar)

Also, I pasted it into a text document, here:

[Devsome]

#moved

[[GM]Toni]

Originally Posted by Judgelemental

My bad, sorry. EPVP automatically mentions an user if the code has @ in it.

Simply delete @ from your code.

Before : @

after @ newchar (without the space between @ and newchar)

Also, I pasted it into a text document, here:

Thanks so much bro <3 done fixed