-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathshop.sql
3010 lines (2946 loc) · 176 KB
/
shop.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*
#
# In the variable i you can choose the desired start id of npc, 70000 by default
# В переменной i укажите желаемый id of npc, 70000 by default
#
#
# For mount's vendors / ДЛЯ ВЕНДОРОВ С МАУНТАМИ
# .npc set phase 65 - ONLY ALLIANCE CAN SEE IT / ВИДИМ ТОЛЬКО ДЛЯ АЛЬЯНСА
# .npc set phase 512 - ONLY HORDE CAN SEE IT / ВИДИМ ТОЛЬКО ДЛЯ ОРДЫ
# 190011 reforger
*/
SET @i := 70000;
/*ALTER TABLE gossip_menu MODIFY MenuID MEDIUMINT;
ALTER TABLE gossip_menu_option MODIFY MenuID MEDIUMINT;*/
###########################################
# CREATURE_TEMPLATE #
###########################################
#from @i
SET @ENTRY := @i;
REPLACE INTO `creature_template` (`entry`, `modelid1`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
(@ENTRY, 21022, "Elixirs", 'Consumables', NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21022, "Flasks", 'Consumables', NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21022, "Scrolls", 'Consumables', NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21022, "Pots", 'Consumables', NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21022, "Food and Drinks", 'Consumables', NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21022, "Reagents and Arrows", 'Consumables', NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#from @i+6
(@ENTRY := @ENTRY+1, 22951, "Brace", "PvE", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 22951, "Waist", "PvE", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 22951, "Boots", "PvE", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 27153, "Neck, Ring, Cloak", "PvE", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 2967, "Axe and Ranged Weapons", NULL, NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 29604, "Mace, Spear, Sword", NULL, NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 29604, "Staff, Wrist, Dagger", NULL, NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 17822, "Shields, Offhands, Manuscripts", NULL, NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 17822, "Trinkets", NULL, NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#from @i+15
(@ENTRY := @ENTRY+1, 30199, "A8 Set", "PvP", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 22951, "A8 Nonset", "PvP", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 28597, "T10", "PvE", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#from @i+18
(@ENTRY := @ENTRY+1, 21022, "Enchantments", NULL, NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21666, "Red", "Gemstone", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21666, "Yellow", "Gemstone", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21666, "Blue", "Gemstone", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21666, "Green", "Gemstone", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21666, "Orange", "Gemstone", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21666, "Violet", "Gemstone", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 21666, "Special and Rainbow", "Gemstone", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#from i+26
(@ENTRY := @ENTRY+1, 30867, "Shirts and Tabards", NULL, NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 20806, "Bags", NULL, NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25305, "Pets", NULL, NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 0.9, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 2059, "Elusive Joe", "Poisons", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#from i+30
#mount alliance
(@ENTRY := @ENTRY+1, 31953, "Alex Wand", "Mounts", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#mount horde
(@ENTRY := @ENTRY+1, 31953, "Alex Wand", "Mounts", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#mount legendary alliance
(@ENTRY := @ENTRY+1, 18248, "Rizzy Wand", "Legendaty Mounts", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#mount legendary horde
(@ENTRY := @ENTRY+1, 18248, "Rizzy Wand", "Legendaty Mounts", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#from i+34
#offset items
(@ENTRY := @ENTRY+1, 22951, "Offset items", "PvE", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#from i+40
(@ENTRY := @ENTRY+6, 1499, "Paladin", "Glyphs", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 28143, "Mage", "Glyphs", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 17534, "Shaman", "Glyphs", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 0.9, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 10550, "Priest", "Glyphs", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 29833, "Warrior", "Glyphs", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 27998, "Hunter", "Glyphs", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 2631, "Rogue", "Glyphs", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 29780, "Druid", "Glyphs", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 0.6, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 28150, "Warlock", "Glyphs", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Death Knight", "Glyphs", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#from i+50
(@ENTRY := @ENTRY+1, 25783, "Toolkit", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Alchemy", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Mining", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Leatherworking", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Engineering", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Enchanting", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Inscription", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Tailoring", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Jewelcrafting", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Other", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
(@ENTRY := @ENTRY+1, 25783, "Fish, Meat and Grass", "Reagents", NULL, 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000'),
#from i+70
(@ENTRY := @ENTRY+10, 21623, "Weapon Trainer", "", NULL, 0, 80, 80, 0, 35, 81, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 2, '', '13000');
###########################################
# NPC_VENDOR and CREATURE_TEMPLATE_LOCALE #
###########################################
#Elixirs 70000
SET @ENTRY := @i;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Эликсиры', 'Расходные материалы', '13000');
INSERT INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '40070', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44327', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44328', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44329', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44330', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44331', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40097', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '39666', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40068', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40072', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40073', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40076', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40078', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40109', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44332', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44325', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '45621', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44012', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '37449', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '2460', '0', '0', '2', '13000');
#Flasks 70001
SET @ENTRY := @i+1;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Настойки', 'Расходные материалы', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '46376', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '46377', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '46378', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '46379', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40079', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40082', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40084', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40404', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40083', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44939', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47499', '0', '0', '2', '13000');
#Scrolls 70002
SET @ENTRY := @i+2;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Свитки', 'Расходные материалы', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '49632', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '37092', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '37094', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '37098', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43464', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43466', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44315', '0', '0', '2', '13000');
#Pots 70003
SET @ENTRY := @i+3;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Зелья', 'Расходные материалы', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '33447', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '33448', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '39327', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40087', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40211', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40212', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40093', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40081', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40213', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40214', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40215', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40216', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40217', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '41166', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42545', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43531', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43530', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '39671', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40067', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '13460', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38351', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '36770', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40077', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43569', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43570', '0', '0', '2', '13000');
#Food and drinks 70004
SET @ENTRY := @i+4;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Еда и напитки', 'Расходные материалы', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '21215', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '33444', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '33445', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34125', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34747', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34748', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34749', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34750', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34751', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34752', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34753', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34754', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34755', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34756', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34757', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34758', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34759', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34760', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34761', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34762', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34763', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34764', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34765', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34766', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34767', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34768', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '34769', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '35947', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '35948', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '35950', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '35951', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '35952', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '35953', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38698', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38706', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '39520', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '39691', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '40202', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '41729', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '41731', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42428', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42429', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42430', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42431', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42432', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42433', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42434', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42777', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42778', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42779', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42942', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42993', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42994', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42995', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42996', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42997', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42998', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42999', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43000', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43001', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43004', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43005', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43015', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43086', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43087', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43236', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43268', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43478', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43480', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43488', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43490', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43491', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43492', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43518', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43523', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44049', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44071', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44072', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44607', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44616', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44618', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44722', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44940', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44941', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44953', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '45932', '0', '0', '2', '13000');
#Reagents 70005
SET @ENTRY := @i+5;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Реагенты и стрелы', 'Расходные материалы', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '49633', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '49634', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '5565', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '16583', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '17030', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '17032', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '21177', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '6265', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '17020', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '17031', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '17033', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '37201', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44615', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44605', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44614', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '52020', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '52021', '0', '0', '2', '13000');
#Brace 70006
SET @ENTRY := @i+6;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Наручи', 'PvE', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '54582', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50651', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50686', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54580', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50670', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54584', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50630', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50655', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50687', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50611', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50659', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50721', '0', '0', '2', '13000');
#Waist 70007
SET @ENTRY := @i+7;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Пояса', 'PvE', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '50613', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50702', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50705', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50707', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50688', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50671', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54587', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50667', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50620', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50691', '0', '0', '2', '13000');
#Boots 70008
SET @ENTRY := @i+8;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Ботинки', 'PvE', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '50699', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '49893', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51850', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50665', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50607', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50711', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50652', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54577', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50632', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50625', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54578', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54586', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54579', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50639', '0', '0', '2', '13000');
#Neck 70009
SET @ENTRY := @i+9;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Ожерелья, кольца, плащи', 'PvE', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '50609', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50627', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50728', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50633', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50658', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50700', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54581', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50724', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50682', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50647', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50398', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50404', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50400', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50402', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '52572', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50610', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50618', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50604', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50614', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50622', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50636', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50644', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50664', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50693', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50720', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50642', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50657', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50678', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50714', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54567', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54576', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54585', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50628', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50653', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50668', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50677', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50718', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54583', '0', '0', '2', '13000');
#Axe and Ranged Weapons 70010 @i+10
SET @ENTRY := 70010;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Топоры и дальнее оружие', 'Оружие', '13000');
REPLACE INTO `npc_vendor` VALUES
#Топоры двуручные
(@ENTRY, @SLOT := @SLOT+1, '51389', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '49623', '0', '0', '2611', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50709', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '49888', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51905', '0', '0', '2', '13000'),
#Топоры одноручные
(@ENTRY, @SLOT := @SLOT+1, '51516', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51440', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51526', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50737', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50654', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51947', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51916', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51938', '0', '0', '2', '13000'),
#Метательное
(@ENTRY, @SLOT := @SLOT+1, '51535', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51880', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50474', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47659', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47660', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '45296', '0', '0', '2', '13000'),
#Жезлы
(@ENTRY, @SLOT := @SLOT+1, '51451', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51532', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51531', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51410', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50684', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50631', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50204', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51852', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51838', '0', '0', '2', '13000'),
#Арбалеты
(@ENTRY, @SLOT := @SLOT+1, '51412', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50733', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51940', '0', '0', '2', '13000'),
#Огнестрельное
(@ENTRY, @SLOT := @SLOT+1, '51450', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50444', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51845', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51834', '0', '0', '2', '13000'),
#Луки
(@ENTRY, @SLOT := @SLOT+1, '51395', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50638', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51927', '0', '0', '2', '13000');
#Mace, Spear, Sword 70011
SET @ENTRY := @i+11;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Дробящее, копья, мечи', 'Оружие', '13000');
REPLACE INTO `npc_vendor` VALUES
#Дробящее двуручное
(@ENTRY, @SLOT := @SLOT+1, '51391', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50603', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51946', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51833', '0', '0', '2', '13000'),
#Одноручное дробящее
(@ENTRY, @SLOT := @SLOT+1, '51520', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51454', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51446', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50734', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50738', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50685', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50708', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51944', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51893', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51875', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51937', '0', '0', '2', '13000'),
#Двуручные мечи
(@ENTRY, @SLOT := @SLOT+1, '51393', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50730', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51936', '0', '0', '2', '13000'),
#Одноручные мечи
(@ENTRY, @SLOT := @SLOT+1, '51522', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51448', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50732', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50672', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50704', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51858', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51869', '0', '0', '2', '13000'),
#Древковое
(@ENTRY, @SLOT := @SLOT+1, '51481', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50735', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50727', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51857', '0', '0', '2', '13000');
#Staff, Wrist, Dagger 70012
SET @ENTRY := @i+12;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Посохи, кистевое, кинжалы', 'Оружие', '13000');
REPLACE INTO `npc_vendor` VALUES
#Посохи
(@ENTRY, @SLOT := @SLOT+1, '51432', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51401', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51457', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51405', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51403', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50648', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50731', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50725', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50695', '0', '0', '2', '13000'),
#Кистевое
(@ENTRY, @SLOT := @SLOT+1, '51524', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51529', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51444', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50692', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50035', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50710', '0', '0', '2', '13000'),
#Кинжалы
(@ENTRY, @SLOT := @SLOT+1, '51398', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51518', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51528', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51399', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51442', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50736', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50608', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50621', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50641', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50676', '0', '0', '2', '13000');
#Shields, Offhands, Manuscripts 70013
SET @ENTRY := @i+13;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Щиты, левая рука, манускрипты', 'Оружие', '13000');
REPLACE INTO `npc_vendor` VALUES
#Щиты
(@ENTRY, @SLOT := @SLOT+1, '51452', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51455', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51533', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51812', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50729', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51909', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50616', '0', '0', '2', '13000'),
#Левая рука
(@ENTRY, @SLOT := @SLOT+1, '51408', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51396', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51407', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51409', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51922', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50635', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50719', '0', '0', '2', '13000'),
#Идолы
(@ENTRY, @SLOT := @SLOT+1, '51437', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51429', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51423', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50454', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50456', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50457', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47668', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47670', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47671', '0', '0', '2', '13000'),
#Тотемы
(@ENTRY, @SLOT := @SLOT+1, '51501', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51513', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51507', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50458', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50463', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50464', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47665', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47666', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47667', '0', '0', '2', '13000'),
#Манускрипты
(@ENTRY, @SLOT := @SLOT+1, '51472', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51478', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50455', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50461', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50460', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47661', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47662', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47664', '0', '0', '2', '13000'),
#Печати
(@ENTRY, @SLOT := @SLOT+1, '51417', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50459', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50462', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47673', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47672', '0', '0', '2', '13000');
#Trinket 70014
SET @ENTRY := @i+14;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Аксессуары', '', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '51377', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51378', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42124', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42126', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42137', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42135', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42134', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '42136', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50343', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50345', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50348', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50355', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50358', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50362', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50363', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50356', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50349', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50352', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50346', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50344', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54590', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54569', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54588', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54572', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54589', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54573', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54591', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '54571', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50706', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50365', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50364', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50366', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50726', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50354', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47131', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47464', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47303', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47059', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47041', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47432', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47271', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '50357', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '46312', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47188', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47088', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47735', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47290', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47316', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47451', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '47734', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '49080', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '48021', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '48724', '0', '0', '2', '13000');
#A8 Set 70015
SET @ENTRY := @i+15;
SET @SLOT := 0;
REPLACE INTO `creature_equip_template` VALUES (@ENTRY, '1', '48043', '48043', '0', '13000');
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'А8 сет', 'PvP', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '51415', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51418', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51413', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51414', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51416', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51421', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51424', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51419', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51420', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51422', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51427', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51430', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51425', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51426', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51428', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51435', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51438', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51433', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51434', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51436', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51460', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51462', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51458', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51459', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51461', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51465', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51467', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51463', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51464', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51466', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51470', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51473', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51468', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51469', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51471', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51476', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51479', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51474', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51475', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51477', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51484', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51486', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51482', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51483', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51485', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51489', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51491', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51487', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51488', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51490', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51494', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51496', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51492', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51493', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51495', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51499', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51502', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51497', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51498', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51500', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51505', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51508', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51503', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51504', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51506', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51511', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51514', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51509', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51510', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51512', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51538', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51540', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51536', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51537', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51539', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51543', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51545', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51541', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51542', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51544', '0', '0', '2', '13000');
#А8 nonst 70016
SET @ENTRY := @i+16;
SET @SLOT := 0;
REPLACE INTO `creature_equip_template` VALUES (@ENTRY, '1', '42322', '0', '0', '13000');
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'А8 нонсет', 'PvP', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '51331', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51333', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51335', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51347', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51349', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51353', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51355', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51357', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51330', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51332', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51334', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51346', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51348', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51354', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51356', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51329', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51339', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51342', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51345', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51352', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51361', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51364', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51367', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51370', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51373', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51376', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51327', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51337', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51340', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51343', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51350', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51359', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51362', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51365', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51368', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51371', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51374', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51328', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51338', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51341', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51344', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51351', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51360', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51363', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51366', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51369', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51372', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51375', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51336', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51358', '0', '0', '2', '13000');
#T10 70017
SET @ENTRY := @i+17;
SET @SLOT := 0;
REPLACE INTO `creature_equip_template` VALUES (@ENTRY, '1', '36942', '0', '0', '13000');
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Т10', 'PvE', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '51221', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51224', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51220', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51222', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51223', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51227', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51229', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51225', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51226', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51228', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51231', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51234', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51233', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51230', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51232', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51237', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51235', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51239', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51238', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51236', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51242', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51240', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51244', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51243', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51241', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51247', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51245', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51249', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51248', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51246', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51252', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51254', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51250', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51251', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51253', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51255', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51257', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51259', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51256', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51258', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51261', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51264', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51263', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51260', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51262', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51266', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51269', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51265', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51267', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51268', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51272', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51273', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51274', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51270', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51271', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51277', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51279', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51275', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51276', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51278', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51281', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51284', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51283', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51280', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51282', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51286', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51288', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51289', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51285', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51287', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51290', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51292', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51294', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51291', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51293', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51296', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51299', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51298', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51295', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51297', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51302', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51304', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51300', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51301', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51303', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51306', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51309', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51305', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51307', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51308', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51312', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51314', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51310', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51311', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '51313', '0', '0', '2', '13000');
#Enchantments 70018
SET @ENTRY := @i+18;
SET @SLOT := 0;
DELETE FROM `npc_vendor` WHERE (`entry`=@ENTRY);
DELETE FROM `creature_template_locale` WHERE (`entry`=@ENTRY);
INSERT INTO `creature_template_locale` VALUES
(@ENTRY, 'ruRU', 'Зачарования', 'Расходные материалы', '13000');
REPLACE INTO `npc_vendor` VALUES
(@ENTRY, @SLOT := @SLOT+1, '44075', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44150', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44159', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44149', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44152', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44701', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44702', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44069', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44068', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44067', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44133', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44134', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44135', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44136', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44957', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38373', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38374', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '41602', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '41604', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44963', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '41611', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '41976', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38840', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38868', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38871', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38872', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38873', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38925', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38926', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38927', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38947', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38948', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38963', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38965', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38972', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38988', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38995', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38998', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '43987', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44493', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44466', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44467', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44497', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '46026', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '46098', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44946', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '38981', '0', '0', '2', '13000'),
(@ENTRY, @SLOT := @SLOT+1, '44463', '0', '0', '2', '13000'),