MaNGOSR2

MangosR2 is a free, open source MMORPG framework, derived from MaNGOS project


You are not connected. Please login or register

Corrections to the table script_texts

View previous topic View next topic Go down  Message [Page 1 of 1]

1 Corrections to the table script_texts on Wed Jul 04 2012, 11:46

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

View user profile http://www.eswow2.org/

2 Re: Corrections to the table script_texts on Wed Jul 04 2012, 14:25

KiriX

avatar
Admin
Thank you. I did not close any thread: http://mangosr2.2x2forum.com/t15-sd2-db-cleanup
Just move it in other subforum =)

View user profile http://aetherius.ru

3 Re: Corrections to the table script_texts on Wed Jul 04 2012, 16:53

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

View user profile http://www.eswow2.org/

4 Re: Corrections to the table script_texts on Wed Jul 04 2012, 17:23

KiriX

avatar
Admin
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 =)

View user profile http://aetherius.ru

5 Re: Corrections to the table script_texts on Thu Jul 05 2012, 09:06

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

View user profile http://www.eswow2.org/

6 Re: Corrections to the table script_texts on Thu Jul 05 2012, 09:11

KiriX

avatar
Admin
I'll try commit your fix today...

View user profile http://aetherius.ru

7 Re: Corrections to the table script_texts on Thu Jul 05 2012, 11:32

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

View user profile

8 Re: Corrections to the table script_texts on Thu Jul 05 2012, 11:53

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

View user profile http://www.eswow2.org/

9 Re: Corrections to the table script_texts on Thu Jul 05 2012, 12:58

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.

View user profile http://www.eswow2.org/

Sponsored content


View previous topic View next topic Back to top  Message [Page 1 of 1]

Permissions in this forum:
You cannot reply to topics in this forum