Corrections to the table script_texts

Hi, KiriX
I not know why you closed the previous thread about SD2 corrections

Well, this is a partial solutions

Corrections to the table script_texts

Bye

Thank you. I did not close any thread: https://mangosr2.forumotion.com/t15-sd2-db-cleanup
Just move it in other subforum =)

I can't to post reply in that thread, say that only administrators can.

Sorry, but only administrators can reply to posts in this forum.

May be because you've moved from another thread? have already discovered something!



Bye

P.S.
As you can see there are three lines that need some study

Mrbytes wrote:I can't to post reply in that thread, say that only administrators can.

Sorry, but only administrators can reply to posts in this forum.

Fixed =)

Hi Kirix.
I have been warned to SD2 of one of the three errors that remained open (I opened an issue).
I hope @michalpolko read it and rectify.

Thk
P.S.
Remain two of R2

I'll try commit your fix today...

I can see my nick but I don't understand what you are talking about, pls explain :D

Hi michalpolko.
About an SD2 issue that has already been fixed by Schmoozerd

Cheers

---

@KiriX

Well, with these two lines is fixed all

Code:

UPDATE `script_texts` SET `sound`='12574' WHERE `entry`='-1110006';
DELETE FROM `script_texts` WHERE `entry`='-1580098';


That's all, regards

This had escaped
The line 57 of the script "mr00001_scriptdev2_trial_of_crusader.sql" is duplicated with the 56. ¡¡The 56 line must be deleted!!.

Because in the line 86 of the script: scripts/northrend/crusaders_coliseum/trial_of_the_crusader/boss_twin_valkyr.cpp, can see that makes use of entry -1713541 but not -1713741
fix:

Code:

DELETE FROM `script_texts` WHERE `entry`='-1713741';

With this the issue of duplicate sounds take it for fixed
After you fixed all run the following query in the table script_texts:

Code:

SELECT a1.entry ,a1.sound FROM script_texts a1 INNER JOIN script_texts a2 ON a1.sound <> 0 AND a1.sound = a2.sound AND a1.entry <> a2.entry ORDER BY a1.entry ASC

should not pull any lines.