[Dev.Ri3o]

هتعمل ال Query ده

USE SRO_VT_SHARD
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

وطبعا هتغير SRO_VT_SHARD للى عندك
وبعد كد هتخش على dbo._RefCharDefult_Quest تتأكد انهم معمولين كدة

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 
1    14    0    QTUTORIAL_CH    1 
1    15    3    QEVENT_GUIDE    1