For who wants to fix F1 first 4 slot bug.

[archer09]

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

execute this query when your server is offline

 

[SupremeSRO]

Re: [Guide] For who wants to fix F1 first 4 slot bug.

i will test, hope this work

 

[Heeroo]

Re: [Guide] For who wants to fix F1 first 4 slot bug.

gj works fine

 

[SupremeSRO]

Re: [Guide] For who wants to fix F1 first 4 slot bug.

what exactly does this? the query what do?

 

[sladlejrhfpq]

Re: [Guide] For who wants to fix F1 first 4 slot bug.

thank you very much, worked!!

 

[SupremeSRO]

Re: [Guide] For who wants to fix F1 first 4 slot bug.

sladlejrhfpq
what this fixed in ur game ? :S

 

[SnapPop]

Re: [Guide] For who wants to fix F1 first 4 slot bug.

sladlejrhfpq
what this fixed in ur game ? :S

humm how can i say humm first 4 slots have bugg like for example you replaced the 4 basic starter icon with some skills okay ? when you TP they return with the 4 old icons again (party matching,exchange,trace) sure you know that icons
but i don't use that query i use something else and was a bit older but works fine with me

1.Open RefCharDefult_Quest table.


1 1 3 QEV_ALL_BASIC_1 5
1 2 3 QEV_ALL_BASIC_2 8
1 3 3 QEV_ALL_BASIC_3 10
1 4 3 QEV_ALL_BASIC_4 16
1 5 3 QEV_ALL_BASIC_5 20
1 6 3 QEV_ALL_BASIC_6 24
1 7 3 QEV_ALL_BASIC_7 30
1 8 3 QEV_ALL_BASIC_8 32
1 9 3 QEV_ALL_BASIC_9 40
1 10 3 QEV_ALL_BASIC_10 42
1 11 3 QEV_ALL_BASIC_11 50
1 12 3 QEV_ALL_BASIC_12 60
1 13 3 QEV_ALL_BASIC_0 1
0 14 0 QTUTORIAL_CH 1
0 15 3 QEVENT_GUIDE 1
NULL NULL NULL NULL NULL

2.Look at this line:


0 15 3 QEVENT_GUIDE 1

3.You need to enable this quest.


1 15 3 QEVENT_GUIDE 1

Now the slots 1,2,3,4 should be fixed. If the problem is not solved you can try with this query:



DELETE FROM _CharQuest WHERE QuestID = 1
INSERT INTO _CharQuest
SELECT CharID, QuestID = 1, [Status] = 1,AchievementCount = 0, StartTime = GETDATE()-4460, EndTime = GETDATE()-4460, QuestData1 = 0, QuestData2 = 0
FROM _Char
WHERE not exists (SELECT CharID, QuestID FROM _CharQuest WHERE QuestID = 1)

Make sure you dont have the folder called Setting in the game client directory.

 

[SupremeSRO]

Re: [Guide] For who wants to fix F1 first 4 slot bug.

<3 ty

 

[hellspawn80]

Re: [Guide] For who wants to fix F1 first 4 slot bug.

that fix didnt work for me

 

[Woman]

Re: [Guide] For who wants to fix F1 first 4 slot bug.

Thx bro!

 

[lembo12]

Msg 208, Level 16, State 1, Line 1
Invalid object name '_RefCharDefault_Quest'.

 

[Maliq]

Re: [Guide] For who wants to fix F1 first 4 slot bug.

humm how can i say humm first 4 slots have bugg like for example you replaced the 4 basic starter icon with some skills okay ? when you TP they return with the 4 old icons again (party matching,exchange,trace) sure you know that icons
but i don't use that query i use something else and was a bit older but works fine with me

when i checked service was alreadty set to 1 and the skill bar was still bugged.. is there no way to fix this, i seen plenty of private servers do it...

 

[Eroticus]

Works

Thanks !

 

[asianking]

Only works for Chinese char. Eur char remains unfix.

 

[Isoline]

indeed works thank you !

 

[Changoleon1]

that works good but i have a next error now i get DC and DC in all the new chars!

 

[TheBold]

i will try it

 

[TheBold]

thx it work