Loss of connection completion dialogue

zhanhang02 · 16.04.2011, 17:48

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** · 16.04.2011, 18:18

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 · 16.04.2011, 18:34

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 · 16.04.2011, 18:40

Код:

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

What I lost update?

**NeatElves** · 16.04.2011, 19:14

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 · 17.04.2011, 03:28

Код:

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 · 21.04.2011, 06:23

Updates?

**NeatElves** · 21.04.2011, 13:29

in 594

zhanhang02 · 21.04.2011, 14:57

Thanks, have used!

16.04.2011, 17:48	#1
zhanhang02 Trinity User Регистрация: 06.11.2009 Сообщений: 6 Сказал(а) спасибо: 32 Поблагодарили 7 раз(а) в 6 сообщениях	Loss of connection completion dialogue 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. Последний раз редактировалось zhanhang02; 16.04.2011 в 17:50.

Похожие темы
Тема	Автор	Раздел	Ответов	Последнее сообщение
[10633] Correct behavior for completion of quest objectives.	newsbot	CMaNGOS Commits	0	20.10.2010 15:02
[10584] Prevent lost aura connection with item at Aura::ReapplyAffectedPassiveAuras	newsbot	CMaNGOS Commits	0	07.10.2010 03:14
[8965] Implement `quit` command for close RA connection.	newsbot	CMaNGOS Commits	0	10.12.2009 19:30

16.04.2011, 18:34	#3
zhanhang02 Trinity User Регистрация: 06.11.2009 Сообщений: 6 Сказал(а) спасибо: 32 Поблагодарили 7 раз(а) в 6 сообщениях	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.

16.04.2011, 18:40	#4
zhanhang02 Trinity User Регистрация: 06.11.2009 Сообщений: 6 Сказал(а) спасибо: 32 Поблагодарили 7 раз(а) в 6 сообщениях	Код: entry gossip_menu_id 15279 0 15280 0 15284 0 15285 0 15513 0 What I lost update?

16.04.2011, 19:14	#5
NeatElves YTDB dev Регистрация: 05.11.2009 Сообщений: 5,920 Сказал(а) спасибо: 91 Поблагодарили 5,383 раз(а) в 4,847 сообщениях	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);

21.04.2011, 06:23	#7
zhanhang02 Trinity User Регистрация: 06.11.2009 Сообщений: 6 Сказал(а) спасибо: 32 Поблагодарили 7 раз(а) в 6 сообщениях	Updates?

21.04.2011, 13:29	#8
NeatElves YTDB dev Регистрация: 05.11.2009 Сообщений: 5,920 Сказал(а) спасибо: 91 Поблагодарили 5,383 раз(а) в 4,847 сообщениях	in 594

21.04.2011, 14:57	#9
zhanhang02 Trinity User Регистрация: 06.11.2009 Сообщений: 6 Сказал(а) спасибо: 32 Поблагодарили 7 раз(а) в 6 сообщениях	Thanks, have used!