[Guide] Delete Invalid Hatching TacticsID

07/26/2015 04:15 witchymoo#1

Hi I'd like to share something related to "Hatching TacticsID" error. I think there's a lot of ways posted here, but I figure to post one as an alternative way :)

This is the error, some of you probably got the same:
[Only registered and activated users can see links. Click Here To Register...]

The boring part:

Code:

USE [SRO_VT_SHARD]
GO
SET NOCOUNT ON;
DECLARE @invalidTacticsID INT;
DECLARE RefNest_Cursor CURSOR FOR SELECT DISTINCT dwTacticsID FROM Tab_RefNest AS T WHERE NOT EXISTS (SELECT * FROM Tab_RefTactics AS R WHERE T.dwTacticsID = R.dwTacticsID) ORDER BY dwTacticsID ASC;
OPEN RefNest_Cursor;
FETCH NEXT FROM RefNest_Cursor INTO @invalidTacticsID;
WHILE @@FETCH_STATUS = 0
BEGIN
	DELETE FROM Tab_RefNest WHERE dwTacticsID = @invalidTacticsID;
	PRINT 'dwTacticsID: ' + CAST(@invalidTacticsID AS VARCHAR) + ' deleted from Tab_RefNest.';
	FETCH NEXT FROM RefNest_Cursor INTO @invalidTacticsID;
END;
CLOSE RefNest_Cursor;
DEALLOCATE RefNest_Cursor;
GO

And reload your GameServer to see if the error still appears ;)

Good luck and have fun, hope this helps a little bit.

07/26/2015 09:45 hossamxt#2

Nice work

07/26/2015 10:46 ILowe#3

nice
-----
How to resolve this?

[Only registered and activated users can see links. Click Here To Register...]

07/26/2015 11:10 witchymoo#4

never had that one but you can try [Only registered and activated users can see links. Click Here To Register...].

Look for "Remove the annoying Quest:RaiseEvent Error" offset.

good luck

07/26/2015 15:16 denise456#5

Code:

TRUNCATE TABLE _CharQuest
UPDATE _RefCharDefault_Quest
SET Service = 0

Quote:

Originally Posted by ILowe

nice
-----
How to resolve this?

[Only registered and activated users can see links. Click Here To Register...]

07/26/2015 15:32 witchymoo#6

Um, not so sure about that cause my [_RefCharDefault_Quest] are all active.

Spoiler

But just try that and see how it goes.

07/26/2015 15:44 blapanda#7

Usually people advice to disable the chinese tutorial quest (QTUTORIAL_CH), which seems to cause bugs by time to time (and somehow the F1 bug as well, dunno if that is true).

Anyways, they don't have a huge impact onto the gameplay.

07/26/2015 15:52 witchymoo#8

Ah, about Belt F1 slots 1-4 bug, I put this in my [_AddNewChar] in the last line of quest section (before _StaticAvatar)

Code:

UPDATE [_CharQuest] SET [Status] = '5', StartTime = '2013-10-31 00:00:00', EndTime = '2013-10-31 00:00:00', QuestData1 = 31458135, QuestData2 = 0 WHERE (CharID = @NewCharID AND QuestID IN (1,2))

and viola, belt F1 slots 1-4 cleared for the new char ;)

07/26/2015 16:58 iWillKiller#9

useful query , thanks witchy

07/26/2015 17:52 Dev.Ahmed_Elnashary#10

Woow Keep Going Bro <3

07/30/2015 00:17 Syloxx#11

Code:

DELETE Tab_RefHive WHERE dwHiveID NOT IN (SELECT dwHiveID FROM Tab_RefNest)
DELETE Tab_RefTactics WHERE dwTacticsID NOT IN (SELECT dwTacticsID FROM Tab_RefNest)

huh why using cursor? o.O

07/30/2015 06:51 Laag#82#12

nice Work

08/01/2015 00:49 synsroadmin#13

nice work