Fix My Raptor Handler

[FishCakeFoley]

Can anyone help me fix my Raptor Handler in senjin village?

At the moment he is just a npc standing there and you cannot click on him to bring up a list.

Edit:

I have now just been told that the Ram Vendor dont work in dun morogh?

[MentaL]

[Ragefire89]

fix not speakable trainers

update creature_proto set npcflags=17 where entry in (198,328,375,376,377,459,460,461,543,812,837,895,906,911,912,913,914,915,916,917
,918,925,926,927,928,944,985,986,987,988,1218,1226,1228,1229,1231,1232,1234,1292
,1355,1404,1411,1458,1680,1681,1699,1701,1901,2119,2122,2123,2124,2126,2127,2128
,2129,2130,2131,2485,2489,2492,2798,2801,2870,2878,2879,2880,2881,3001,3013,3026
,3028,3030,3031,3032,3033,3034,3036,3038,3039,3040,3041,3042,3043,3044,3045,3046
,3047,3048,3049,3059,3060,3061,3062,3063,3064,3065,3066,3087,3137,3153,3154,3155
,3156,3157,3169,3170,3171,3172,3173,3179,3181,3306,3324,3325,3326,3327,3328,3332
,3344,3352,3353,3354,3357,3373,3399,3401,3403,3404,3406,3407,3408,3545,3593,3594
,3595,3596,3597,3598,3599,3600,3601,3602,3620,3622,3624,3688,3698,3706,3707,3963
,4087,4089,4090,4091,4092,4138,4146,4156,4163,4165,4204,4205,4210,4211,4214,4215
,4217,4218,4219,4254,4320,4552,4563,4564,4565,4566,4567,4568,4573,4582,4583,4584
,4591,4593,4594,4595,4598,4606,4607,4608,4614,5113,5114,5115,5116,5117,5137,5141
,5142,5143,5144,5145,5146,5147,5148,5149,5150,5159,5161,5165,5166,5167,5171,5172
,5173,5392,5479,5480,5482,5484,5489,5491,5492,5493,5495,5496,5497,5498,5501,5502
,5504,5505,5506,5513,5515,5516,5517,5520,5566,5612,5749,5750,5753,5759,5815,5880
,5882,5883,5884,5885,5939,5943,5957,5958,6014,6018,6027,6094,6291,6292,6295,6297
,6328,6373,6374,6376,6382,7087,7088,7089,7311,7312,7315,7870,7953,8140,8141,8142
,8144,8146,8308,8665,9465,10086,10088,10089,10090,10370,10930,11044,11097,11397,
11401,11406,12030,12042,12776,12807,13283,13417,15279,15280,15283,15284,15494,15
513,22477,16266,16267,16269,16270,16271,16272,16273,16275,16276,16277,16278,1627
9,22006,16646,16647,16648,16649,16651,16652,16653,16654,16655,16658,16659,16660,
16662,16663,16672,16673,16674,16675,16680,16679,16681,16684,16685,16686,16712,16
721,16731,16738,16749,16752,16755,16756,16761,16771,16774,16780,22007,17110,1712
0,17121,17122,17204,17214,17219,19478,17480,17481,17482,17483,17484,17504,17505,
17509,17510,17511,17513,17514,17519,17520,18748,18776,18777,20407,20406,19340,17
434,17424,18755,18747,20791,18018,17212,17089,22005,16503,16502,15285,16499,1650
0,16501,17488,18779,2327,354,373,542,897,1403,1406,1408,1409,1546,2217,2218,2219
,2220,2221,2222,2223,2325,2872,2883,2885,2886,2935,2938,2939,2940,3525,3623,3697
,3699,4149,4153,4157,4206,4579,4621,4881,4882,4985,4986,4987,4988,4989,4990,4991
,4992,4993,4994,4997,4998,4999,5000,5001,5002,5003,5004,5005,5006,5008,5009,5011
,5012,5013,5015,5017,5018,5019,5020,5021,5022,5023,5024,5026,5027,5028,5029,5030
,5031,5032,5033,5034,5035,5036,5037,5038,5039,5040,5041,5104,5507,5959,5960,5961
,5962,5963,5964,5965,5966,5967,5968,5969,5970,5971,5972,5973,6242,7173,7174,7488
,7525,7526,7528,7743,7745,7746,8676,8677,8777,10291,10292,10294,10295,10297,1029
8,10362,10368,10443,10444,10446,10448,10449,10450,10451,10452,10453,10454,15465,
16000,16190,16527,16661,16720,16759,16770,18270,19145,19146,19247,19490,19491,19
492)

more....

update creature_proto set npcflags=17 where entry in (223,514,957,1103,1215,1241,1246,1300,1466,1470,1632,1702,1703,2132,2855,2857,30
08,3069,3174,3184,3290,3484,3494,3523,3549,3557,3603,3605,3606,4193,4586,4605,55
00,5695,5784,5811,6299,10266,10277,10278,10993,11025,11026,11028,11037,11041,110
44,11046,11047,11048,11050,11051,11065,11066,11067,11068,11070,11071,11083,11096
,16160,16366,16634,16639,16643,16668,16687,16703,16740,16741,16742,16743,16745,1
6746,17215,17222,17442,17487,19248,22025,15501,15400,16161,16671,16744)

more...

update creature_proto set npcflags=17 where entry in (1698,2114,2116,2117,2135,2136,3522,4083,4981,5081,19181,17409,2133)

[FishCakeFoley]

Hmm i get an error when i try to use those...

1064 - You have an error in your SQL syntax.

Any ideas?

[channel_49]

Those only gives flag 17, if any of those npcs have more function it'll be excluded. I suggest more revisions are required for that fix.