Loss of connection completion dialogue

[zhanhang02]

593_FIX_11688 for TC2

3.35a Clients


NPC Id npc_text Id
15285 9187
15513 9189
15284 9186
15280 9193
15279 9191


The above data from official games, personally find the corresponding database.
Because I do not know the number YTDB use rules, so I published correspondence, please YTDB team related dialogue.

will be finishing the other parts as soon as possible.

[NeatElves]

That way there is in the database that you do not like it here?

15280, 9193
15279, 9191, 1407
15279, 9192
15284, 9007
15284, 9186, 1519
15285, 9187, 1527
15285, 9188
15513, 9189, 1531
15513, 9190

Almost every NPC has to be 2 of the text, one for her class, another for everyone else

http://www.trinitycore.org/w/ChrClasses.dbc#Content

[zhanhang02]

I do not have these data in the database, gossip_menu_id is 0, I use the database is YTDB_0.14.2_R590_TC_R11554_TDBAI_335.0.3_RuDB_R38. 8 + 591_updatepack_world_11600 + 592_updatepack_world_11642 + 593_updatepack_world_11688.

[zhanhang02]

entry gossip_menu_id
15279 0
15280 0
15284 0
15285 0
15513 0

What I lost update?

[NeatElves]

Execute the query and write the result here

SELECT `entry` FROM `creature_template` WHERE `gossip_menu_id` =0 AND `npcflag` = `npcflag` |32 AND `entry` NOT IN (988,1231,3046,3049,3963,5501,8141,8308,9465,16646 ,16647,16648,23103);

[zhanhang02]

INSERT INTO `creature_template` VALUES (198);
INSERT INTO `creature_template` VALUES (328);
INSERT INTO `creature_template` VALUES (331);
INSERT INTO `creature_template` VALUES (375);
INSERT INTO `creature_template` VALUES (376);
INSERT INTO `creature_template` VALUES (377);
INSERT INTO `creature_template` VALUES (459);
INSERT INTO `creature_template` VALUES (460);
INSERT INTO `creature_template` VALUES (461);
INSERT INTO `creature_template` VALUES (837);
INSERT INTO `creature_template` VALUES (895);
INSERT INTO `creature_template` VALUES (906);
INSERT INTO `creature_template` VALUES (911);
INSERT INTO `creature_template` VALUES (912);
INSERT INTO `creature_template` VALUES (913);
INSERT INTO `creature_template` VALUES (914);
INSERT INTO `creature_template` VALUES (915);
INSERT INTO `creature_template` VALUES (916);
INSERT INTO `creature_template` VALUES (917);
INSERT INTO `creature_template` VALUES (918);
INSERT INTO `creature_template` VALUES (925);
INSERT INTO `creature_template` VALUES (926);
INSERT INTO `creature_template` VALUES (927);
INSERT INTO `creature_template` VALUES (928);
INSERT INTO `creature_template` VALUES (944);
INSERT INTO `creature_template` VALUES (985);
INSERT INTO `creature_template` VALUES (986);
INSERT INTO `creature_template` VALUES (987);
INSERT INTO `creature_template` VALUES (1226);
INSERT INTO `creature_template` VALUES (1228);
INSERT INTO `creature_template` VALUES (1229);
INSERT INTO `creature_template` VALUES (1232);
INSERT INTO `creature_template` VALUES (1234);
INSERT INTO `creature_template` VALUES (1404);
INSERT INTO `creature_template` VALUES (1411);
INSERT INTO `creature_template` VALUES (1901);
INSERT INTO `creature_template` VALUES (2119);
INSERT INTO `creature_template` VALUES (2122);
INSERT INTO `creature_template` VALUES (2123);
INSERT INTO `creature_template` VALUES (2124);
INSERT INTO `creature_template` VALUES (2126);
INSERT INTO `creature_template` VALUES (2127);
INSERT INTO `creature_template` VALUES (2128);
INSERT INTO `creature_template` VALUES (2129);
INSERT INTO `creature_template` VALUES (2130);
INSERT INTO `creature_template` VALUES (2131);
INSERT INTO `creature_template` VALUES (2485);
INSERT INTO `creature_template` VALUES (2489);
INSERT INTO `creature_template` VALUES (2492);
INSERT INTO `creature_template` VALUES (3030);
INSERT INTO `creature_template` VALUES (3031);
INSERT INTO `creature_template` VALUES (3032);
INSERT INTO `creature_template` VALUES (3036);
INSERT INTO `creature_template` VALUES (3038);
INSERT INTO `creature_template` VALUES (3039);
INSERT INTO `creature_template` VALUES (3040);
INSERT INTO `creature_template` VALUES (3044);
INSERT INTO `creature_template` VALUES (3045);
INSERT INTO `creature_template` VALUES (3047);
INSERT INTO `creature_template` VALUES (3048);
INSERT INTO `creature_template` VALUES (3059);
INSERT INTO `creature_template` VALUES (3060);
INSERT INTO `creature_template` VALUES (3061);
INSERT INTO `creature_template` VALUES (3062);
INSERT INTO `creature_template` VALUES (3063);
INSERT INTO `creature_template` VALUES (3065);
INSERT INTO `creature_template` VALUES (3066);
INSERT INTO `creature_template` VALUES (3153);
INSERT INTO `creature_template` VALUES (3154);
INSERT INTO `creature_template` VALUES (3155);
INSERT INTO `creature_template` VALUES (3156);
INSERT INTO `creature_template` VALUES (3157);
INSERT INTO `creature_template` VALUES (3169);
INSERT INTO `creature_template` VALUES (3170);
INSERT INTO `creature_template` VALUES (3171);
INSERT INTO `creature_template` VALUES (3172);
INSERT INTO `creature_template` VALUES (3173);
INSERT INTO `creature_template` VALUES (3324);
INSERT INTO `creature_template` VALUES (3325);
INSERT INTO `creature_template` VALUES (3326);
INSERT INTO `creature_template` VALUES (3327);
INSERT INTO `creature_template` VALUES (3328);
INSERT INTO `creature_template` VALUES (3344);
INSERT INTO `creature_template` VALUES (3352);
INSERT INTO `creature_template` VALUES (3353);
INSERT INTO `creature_template` VALUES (3354);
INSERT INTO `creature_template` VALUES (3401);
INSERT INTO `creature_template` VALUES (3403);
INSERT INTO `creature_template` VALUES (3406);
INSERT INTO `creature_template` VALUES (3407);
INSERT INTO `creature_template` VALUES (3408);
INSERT INTO `creature_template` VALUES (3593);
INSERT INTO `creature_template` VALUES (3594);
INSERT INTO `creature_template` VALUES (3595);
INSERT INTO `creature_template` VALUES (3596);
INSERT INTO `creature_template` VALUES (3597);
INSERT INTO `creature_template` VALUES (3598);
INSERT INTO `creature_template` VALUES (3599);
INSERT INTO `creature_template` VALUES (3600);
INSERT INTO `creature_template` VALUES (3601);
INSERT INTO `creature_template` VALUES (3602);
INSERT INTO `creature_template` VALUES (3706);
INSERT INTO `creature_template` VALUES (3707);
INSERT INTO `creature_template` VALUES (4087);
INSERT INTO `creature_template` VALUES (4089);
INSERT INTO `creature_template` VALUES (4090);
INSERT INTO `creature_template` VALUES (4091);
INSERT INTO `creature_template` VALUES (4092);
INSERT INTO `creature_template` VALUES (4138);
INSERT INTO `creature_template` VALUES (4146);
INSERT INTO `creature_template` VALUES (4163);
INSERT INTO `creature_template` VALUES (4165);
INSERT INTO `creature_template` VALUES (4205);
INSERT INTO `creature_template` VALUES (4214);
INSERT INTO `creature_template` VALUES (4215);
INSERT INTO `creature_template` VALUES (4217);
INSERT INTO `creature_template` VALUES (4218);
INSERT INTO `creature_template` VALUES (4219);
INSERT INTO `creature_template` VALUES (4563);
INSERT INTO `creature_template` VALUES (4564);
INSERT INTO `creature_template` VALUES (4565);
INSERT INTO `creature_template` VALUES (4566);
INSERT INTO `creature_template` VALUES (4567);
INSERT INTO `creature_template` VALUES (4568);
INSERT INTO `creature_template` VALUES (4582);
INSERT INTO `creature_template` VALUES (4583);
INSERT INTO `creature_template` VALUES (4584);
INSERT INTO `creature_template` VALUES (4593);
INSERT INTO `creature_template` VALUES (4594);
INSERT INTO `creature_template` VALUES (4595);
INSERT INTO `creature_template` VALUES (4606);
INSERT INTO `creature_template` VALUES (4607);
INSERT INTO `creature_template` VALUES (4608);
INSERT INTO `creature_template` VALUES (5113);
INSERT INTO `creature_template` VALUES (5114);
INSERT INTO `creature_template` VALUES (5115);
INSERT INTO `creature_template` VALUES (5116);
INSERT INTO `creature_template` VALUES (5117);
INSERT INTO `creature_template` VALUES (5141);
INSERT INTO `creature_template` VALUES (5142);
INSERT INTO `creature_template` VALUES (5143);
INSERT INTO `creature_template` VALUES (5144);
INSERT INTO `creature_template` VALUES (5145);
INSERT INTO `creature_template` VALUES (5146);
INSERT INTO `creature_template` VALUES (5147);
INSERT INTO `creature_template` VALUES (5148);
INSERT INTO `creature_template` VALUES (5149);
INSERT INTO `creature_template` VALUES (5165);
INSERT INTO `creature_template` VALUES (5166);
INSERT INTO `creature_template` VALUES (5167);
INSERT INTO `creature_template` VALUES (5171);
INSERT INTO `creature_template` VALUES (5172);
INSERT INTO `creature_template` VALUES (5173);
INSERT INTO `creature_template` VALUES (5479);
INSERT INTO `creature_template` VALUES (5480);
INSERT INTO `creature_template` VALUES (5484);
INSERT INTO `creature_template` VALUES (5489);
INSERT INTO `creature_template` VALUES (5491);
INSERT INTO `creature_template` VALUES (5492);
INSERT INTO `creature_template` VALUES (5495);
INSERT INTO `creature_template` VALUES (5496);
INSERT INTO `creature_template` VALUES (5497);
INSERT INTO `creature_template` VALUES (5498);
INSERT INTO `creature_template` VALUES (5504);
INSERT INTO `creature_template` VALUES (5505);
INSERT INTO `creature_template` VALUES (5506);
INSERT INTO `creature_template` VALUES (5515);
INSERT INTO `creature_template` VALUES (5516);
INSERT INTO `creature_template` VALUES (5517);
INSERT INTO `creature_template` VALUES (5612);
INSERT INTO `creature_template` VALUES (5880);
INSERT INTO `creature_template` VALUES (5882);
INSERT INTO `creature_template` VALUES (5883);
INSERT INTO `creature_template` VALUES (5884);
INSERT INTO `creature_template` VALUES (5885);
INSERT INTO `creature_template` VALUES (5957);
INSERT INTO `creature_template` VALUES (5958);
INSERT INTO `creature_template` VALUES (5994);
INSERT INTO `creature_template` VALUES (6014);
INSERT INTO `creature_template` VALUES (6018);
INSERT INTO `creature_template` VALUES (6251);
INSERT INTO `creature_template` VALUES (6707);
INSERT INTO `creature_template` VALUES (7311);
INSERT INTO `creature_template` VALUES (7312);
INSERT INTO `creature_template` VALUES (7315);
INSERT INTO `creature_template` VALUES (8140);
INSERT INTO `creature_template` VALUES (8142);
INSERT INTO `creature_template` VALUES (10930);
INSERT INTO `creature_template` VALUES (11397);
INSERT INTO `creature_template` VALUES (11401);
INSERT INTO `creature_template` VALUES (11406);
INSERT INTO `creature_template` VALUES (12042);
INSERT INTO `creature_template` VALUES (13283);
INSERT INTO `creature_template` VALUES (13417);
INSERT INTO `creature_template` VALUES (16266);
INSERT INTO `creature_template` VALUES (16269);
INSERT INTO `creature_template` VALUES (16270);
INSERT INTO `creature_template` VALUES (16275);
INSERT INTO `creature_template` VALUES (16276);
INSERT INTO `creature_template` VALUES (16279);
INSERT INTO `creature_template` VALUES (16651);
INSERT INTO `creature_template` VALUES (16652);
INSERT INTO `creature_template` VALUES (16653);
INSERT INTO `creature_template` VALUES (16654);
INSERT INTO `creature_template` VALUES (16655);
INSERT INTO `creature_template` VALUES (16658);
INSERT INTO `creature_template` VALUES (16659);
INSERT INTO `creature_template` VALUES (16660);
INSERT INTO `creature_template` VALUES (16672);
INSERT INTO `creature_template` VALUES (16673);
INSERT INTO `creature_template` VALUES (16674);
INSERT INTO `creature_template` VALUES (16680);
INSERT INTO `creature_template` VALUES (16679);
INSERT INTO `creature_template` VALUES (16681);
INSERT INTO `creature_template` VALUES (16684);
INSERT INTO `creature_template` VALUES (16685);
INSERT INTO `creature_template` VALUES (16686);
INSERT INTO `creature_template` VALUES (16721);
INSERT INTO `creature_template` VALUES (16749);
INSERT INTO `creature_template` VALUES (16756);
INSERT INTO `creature_template` VALUES (17121);
INSERT INTO `creature_template` VALUES (17509);
INSERT INTO `creature_template` VALUES (17510);
INSERT INTO `creature_template` VALUES (17511);
INSERT INTO `creature_template` VALUES (17513);
INSERT INTO `creature_template` VALUES (17514);
INSERT INTO `creature_template` VALUES (17844);
INSERT INTO `creature_template` VALUES (16500);
INSERT INTO `creature_template` VALUES (16501);
INSERT INTO `creature_template` VALUES (15280);
INSERT INTO `creature_template` VALUES (16738);
INSERT INTO `creature_template` VALUES (16761);
INSERT INTO `creature_template` VALUES (16771);
INSERT INTO `creature_template` VALUES (17110);
INSERT INTO `creature_template` VALUES (17120);
INSERT INTO `creature_template` VALUES (17212);
INSERT INTO `creature_template` VALUES (17480);
INSERT INTO `creature_template` VALUES (17481);
INSERT INTO `creature_template` VALUES (17482);
INSERT INTO `creature_template` VALUES (17483);
INSERT INTO `creature_template` VALUES (17504);
INSERT INTO `creature_template` VALUES (17505);
INSERT INTO `creature_template` VALUES (20407);
INSERT INTO `creature_template` VALUES (20791);
INSERT INTO `creature_template` VALUES (16503);
INSERT INTO `creature_template` VALUES (16502);
INSERT INTO `creature_template` VALUES (19340);
INSERT INTO `creature_template` VALUES (16499);
INSERT INTO `creature_template` VALUES (17089);
INSERT INTO `creature_template` VALUES (17122);
INSERT INTO `creature_template` VALUES (15279);
INSERT INTO `creature_template` VALUES (15513);
INSERT INTO `creature_template` VALUES (15284);
INSERT INTO `creature_template` VALUES (15283);
INSERT INTO `creature_template` VALUES (3064);
INSERT INTO `creature_template` VALUES (3043);
INSERT INTO `creature_template` VALUES (3042);
INSERT INTO `creature_template` VALUES (3041);
INSERT INTO `creature_template` VALUES (3034);
INSERT INTO `creature_template` VALUES (3033);
INSERT INTO `creature_template` VALUES (17105);
INSERT INTO `creature_template` VALUES (17204);
INSERT INTO `creature_template` VALUES (17219);
INSERT INTO `creature_template` VALUES (17519);
INSERT INTO `creature_template` VALUES (17520);
INSERT INTO `creature_template` VALUES (20406);
INSERT INTO `creature_template` VALUES (15285);
INSERT INTO `creature_template` VALUES (23127);
INSERT INTO `creature_template` VALUES (23128);
INSERT INTO `creature_template` VALUES (23534);
INSERT INTO `creature_template` VALUES (27703);
INSERT INTO `creature_template` VALUES (27705);
INSERT INTO `creature_template` VALUES (27704);
INSERT INTO `creature_template` VALUES (29156);
INSERT INTO `creature_template` VALUES (28956);
INSERT INTO `creature_template` VALUES (28958);
INSERT INTO `creature_template` VALUES (28471);
INSERT INTO `creature_template` VALUES (28474);
INSERT INTO `creature_template` VALUES (28472);
INSERT INTO `creature_template` VALUES (29194);
INSERT INTO `creature_template` VALUES (29195);
INSERT INTO `creature_template` VALUES (29196);
INSERT INTO `creature_template` VALUES (31084);
INSERT INTO `creature_template` VALUES (35281);

[zhanhang02]

Updates?

[NeatElves]

in 594

[zhanhang02]

Thanks, have used!