Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- PvP Item 1.4 to vendor
- -- Non set PvP Item
- delete from npc_vendor where item in (select entry from item_template where requiredhonorrank>4 and requiredhonorrank<11 or requiredhonorrank=13);
- insert into npc_vendor value (12781, 15196, 0, 0);
- insert into npc_vendor value (12781, 15198, 0, 0);
- insert into npc_vendor value (12781, 16342, 0, 0);
- insert into npc_vendor value (12781, 18440, 0, 0);
- insert into npc_vendor value (12781, 18441, 0, 0);
- insert into npc_vendor value (12781, 18442, 0, 0);
- insert into npc_vendor value (12781, 18443, 0, 0);
- insert into npc_vendor value (12781, 18444, 0, 0);
- insert into npc_vendor value (12781, 18445, 0, 0);
- insert into npc_vendor value (12781, 18447, 0, 0);
- insert into npc_vendor value (12781, 18448, 0, 0);
- insert into npc_vendor value (12781, 18449, 0, 0);
- insert into npc_vendor value (12781, 18452, 0, 0);
- insert into npc_vendor value (12781, 18453, 0, 0);
- insert into npc_vendor value (12781, 18454, 0, 0);
- insert into npc_vendor value (12781, 18456, 0, 0);
- insert into npc_vendor value (12781, 18457, 0, 0);
- insert into npc_vendor value (12781, 18606, 0, 0);
- insert into npc_vendor value (12781, 18839, 0, 0);
- insert into npc_vendor value (12781, 18841, 0, 0);
- insert into npc_vendor value (12781, 18854, 0, 0);
- insert into npc_vendor value (12781, 18856, 0, 0);
- insert into npc_vendor value (12781, 18857, 0, 0);
- insert into npc_vendor value (12781, 18858, 0, 0);
- insert into npc_vendor value (12781, 18859, 0, 0);
- insert into npc_vendor value (12781, 18862, 0, 0);
- insert into npc_vendor value (12781, 18863, 0, 0);
- insert into npc_vendor value (12781, 18864, 0, 0);
- insert into npc_vendor value (12793, 15197, 0, 0);
- insert into npc_vendor value (12793, 15199, 0, 0);
- insert into npc_vendor value (12793, 15200, 0, 0);
- insert into npc_vendor value (12793, 16335, 0, 0);
- insert into npc_vendor value (12793, 16341, 0, 0);
- insert into npc_vendor value (12793, 16486, 0, 0);
- insert into npc_vendor value (12793, 16497, 0, 0);
- insert into npc_vendor value (12793, 16532, 0, 0);
- insert into npc_vendor value (12793, 18427, 0, 0);
- insert into npc_vendor value (12793, 18428, 0, 0);
- insert into npc_vendor value (12793, 18429, 0, 0);
- insert into npc_vendor value (12793, 18430, 0, 0);
- insert into npc_vendor value (12793, 18432, 0, 0);
- insert into npc_vendor value (12793, 18434, 0, 0);
- insert into npc_vendor value (12793, 18435, 0, 0);
- insert into npc_vendor value (12793, 18436, 0, 0);
- insert into npc_vendor value (12793, 18437, 0, 0);
- insert into npc_vendor value (12793, 18845, 0, 0);
- insert into npc_vendor value (12793, 18461, 0, 0);
- insert into npc_vendor value (12793, 18607, 0, 0);
- insert into npc_vendor value (12793, 18834, 0, 0);
- insert into npc_vendor value (12793, 18839, 0, 0);
- insert into npc_vendor value (12793, 18841, 0, 0);
- insert into npc_vendor value (12793, 18846, 0, 0);
- insert into npc_vendor value (12793, 18849, 0, 0);
- insert into npc_vendor value (12793, 18850, 0, 0);
- insert into npc_vendor value (12793, 18851, 0, 0);
- insert into npc_vendor value (12793, 18852, 0, 0);
- insert into npc_vendor value (12793, 18853, 0, 0);
- insert into npc_vendor value (12781, 18455, 0, 0);
- -- PvP set
- delete from npc_vendor where entry in (12795,12785);
- -- set 58 r10
- insert into npc_vendor value (12785,16369,0,0);
- insert into npc_vendor value (12785,16391,0,0);
- insert into npc_vendor value (12785,16392,0,0);
- insert into npc_vendor value (12785,16393,0,0);
- insert into npc_vendor value (12785,16418,0,0);
- insert into npc_vendor value (12785,16397,0,0);
- insert into npc_vendor value (12785,16401,0,0);
- insert into npc_vendor value (12785,16403,0,0);
- insert into npc_vendor value (12785,16405,0,0);
- insert into npc_vendor value (12785,16406,0,0);
- insert into npc_vendor value (12785,16409,0,0);
- insert into npc_vendor value (12785,16410,0,0);
- insert into npc_vendor value (12785,16413,0,0);
- insert into npc_vendor value (12785,16414,0,0);
- insert into npc_vendor value (12785,16415,0,0);
- insert into npc_vendor value (12785,16416,0,0);
- insert into npc_vendor value (12785,16417,0,0);
- insert into npc_vendor value (12785,16420,0,0);
- insert into npc_vendor value (12785,16396,0,0);
- insert into npc_vendor value (12785,16419,0,0);
- insert into npc_vendor value (12785,16421,0,0);
- insert into npc_vendor value (12785,16422,0,0);
- insert into npc_vendor value (12785,16423,0,0);
- insert into npc_vendor value (12785,16424,0,0);
- insert into npc_vendor value (12785,16425,0,0);
- insert into npc_vendor value (12785,16426,0,0);
- insert into npc_vendor value (12785,16427,0,0);
- insert into npc_vendor value (12785,16428,0,0);
- insert into npc_vendor value (12785,16429,0,0);
- insert into npc_vendor value (12785,16430,0,0);
- insert into npc_vendor value (12785,16431,0,0);
- insert into npc_vendor value (12785,16432,0,0);
- insert into npc_vendor value (12785,16433,0,0);
- insert into npc_vendor value (12785,16434,0,0);
- insert into npc_vendor value (12785,16435,0,0);
- insert into npc_vendor value (12785,16436,0,0);
- insert into npc_vendor value (12785,16485,0,0);
- insert into npc_vendor value (12785,16487,0,0);
- insert into npc_vendor value (12785,16489,0,0);
- insert into npc_vendor value (12785,16490,0,0);
- insert into npc_vendor value (12785,16491,0,0);
- insert into npc_vendor value (12785,16492,0,0);
- insert into npc_vendor value (12785,16494,0,0);
- insert into npc_vendor value (12785,16496,0,0);
- insert into npc_vendor value (12785,16498,0,0);
- insert into npc_vendor value (12785,16499,0,0);
- insert into npc_vendor value (12785,16501,0,0);
- insert into npc_vendor value (12785,16502,0,0);
- insert into npc_vendor value (12785,16503,0,0);
- insert into npc_vendor value (12785,16504,0,0);
- insert into npc_vendor value (12785,16505,0,0);
- insert into npc_vendor value (12785,16506,0,0);
- insert into npc_vendor value (12785,16507,0,0);
- insert into npc_vendor value (12785,16508,0,0);
- insert into npc_vendor value (12785,16509,0,0);
- insert into npc_vendor value (12785,16510,0,0);
- insert into npc_vendor value (12785,16513,0,0);
- insert into npc_vendor value (12785,16514,0,0);
- insert into npc_vendor value (12785,16515,0,0);
- insert into npc_vendor value (12785,16516,0,0);
- insert into npc_vendor value (12785,16518,0,0);
- insert into npc_vendor value (12785,16519,0,0);
- insert into npc_vendor value (12785,16521,0,0);
- insert into npc_vendor value (12785,16522,0,0);
- insert into npc_vendor value (12785,16523,0,0);
- insert into npc_vendor value (12785,16524,0,0);
- insert into npc_vendor value (12785,16525,0,0);
- insert into npc_vendor value (12785,16526,0,0);
- insert into npc_vendor value (12785,16527,0,0);
- insert into npc_vendor value (12785,16528,0,0);
- insert into npc_vendor value (12785,16530,0,0);
- insert into npc_vendor value (12785,16531,0,0);
- insert into npc_vendor value (12785,17562,0,0);
- insert into npc_vendor value (12785,17564,0,0);
- insert into npc_vendor value (12785,17566,0,0);
- insert into npc_vendor value (12785,17567,0,0);
- insert into npc_vendor value (12785,17568,0,0);
- insert into npc_vendor value (12785,17569,0,0);
- insert into npc_vendor value (12785,17570,0,0);
- insert into npc_vendor value (12785,17571,0,0);
- insert into npc_vendor value (12785,17572,0,0);
- insert into npc_vendor value (12785,17573,0,0);
- insert into npc_vendor value (12785,17576,0,0);
- insert into npc_vendor value (12785,17577,0,0);
- insert into npc_vendor value (12785,17594,0,0);
- insert into npc_vendor value (12785,17596,0,0);
- insert into npc_vendor value (12785,17598,0,0);
- insert into npc_vendor value (12785,17599,0,0);
- insert into npc_vendor value (12785,17600,0,0);
- insert into npc_vendor value (12785,17601,0,0);
- insert into npc_vendor value (12785,17610,0,0);
- insert into npc_vendor value (12785,17611,0,0);
- insert into npc_vendor value (12785,17612,0,0);
- insert into npc_vendor value (12785,17613,0,0);
- insert into npc_vendor value (12785,17616,0,0);
- insert into npc_vendor value (12785,17617,0,0);
- insert into npc_vendor value (12795,16369,0,0);
- insert into npc_vendor value (12795,16391,0,0);
- insert into npc_vendor value (12795,16392,0,0);
- insert into npc_vendor value (12795,16393,0,0);
- insert into npc_vendor value (12795,16418,0,0);
- insert into npc_vendor value (12795,16397,0,0);
- insert into npc_vendor value (12795,16401,0,0);
- insert into npc_vendor value (12795,16403,0,0);
- insert into npc_vendor value (12795,16405,0,0);
- insert into npc_vendor value (12795,16406,0,0);
- insert into npc_vendor value (12795,16409,0,0);
- insert into npc_vendor value (12795,16410,0,0);
- insert into npc_vendor value (12795,16413,0,0);
- insert into npc_vendor value (12795,16414,0,0);
- insert into npc_vendor value (12795,16415,0,0);
- insert into npc_vendor value (12795,16416,0,0);
- insert into npc_vendor value (12795,16417,0,0);
- insert into npc_vendor value (12795,16420,0,0);
- insert into npc_vendor value (12795,16396,0,0);
- insert into npc_vendor value (12795,16419,0,0);
- insert into npc_vendor value (12795,16421,0,0);
- insert into npc_vendor value (12795,16422,0,0);
- insert into npc_vendor value (12795,16423,0,0);
- insert into npc_vendor value (12795,16424,0,0);
- insert into npc_vendor value (12795,16425,0,0);
- insert into npc_vendor value (12795,16426,0,0);
- insert into npc_vendor value (12795,16427,0,0);
- insert into npc_vendor value (12795,16428,0,0);
- insert into npc_vendor value (12795,16429,0,0);
- insert into npc_vendor value (12795,16430,0,0);
- insert into npc_vendor value (12795,16431,0,0);
- insert into npc_vendor value (12795,16432,0,0);
- insert into npc_vendor value (12795,16433,0,0);
- insert into npc_vendor value (12795,16434,0,0);
- insert into npc_vendor value (12795,16435,0,0);
- insert into npc_vendor value (12795,16436,0,0);
- insert into npc_vendor value (12795,16485,0,0);
- insert into npc_vendor value (12795,16487,0,0);
- insert into npc_vendor value (12795,16489,0,0);
- insert into npc_vendor value (12795,16490,0,0);
- insert into npc_vendor value (12795,16491,0,0);
- insert into npc_vendor value (12795,16492,0,0);
- insert into npc_vendor value (12795,16494,0,0);
- insert into npc_vendor value (12795,16496,0,0);
- insert into npc_vendor value (12795,16498,0,0);
- insert into npc_vendor value (12795,16499,0,0);
- insert into npc_vendor value (12795,16501,0,0);
- insert into npc_vendor value (12795,16502,0,0);
- insert into npc_vendor value (12795,16503,0,0);
- insert into npc_vendor value (12795,16504,0,0);
- insert into npc_vendor value (12795,16505,0,0);
- insert into npc_vendor value (12795,16506,0,0);
- insert into npc_vendor value (12795,16507,0,0);
- insert into npc_vendor value (12795,16508,0,0);
- insert into npc_vendor value (12795,16509,0,0);
- insert into npc_vendor value (12795,16510,0,0);
- insert into npc_vendor value (12795,16513,0,0);
- insert into npc_vendor value (12795,16514,0,0);
- insert into npc_vendor value (12795,16515,0,0);
- insert into npc_vendor value (12795,16516,0,0);
- insert into npc_vendor value (12795,16518,0,0);
- insert into npc_vendor value (12795,16519,0,0);
- insert into npc_vendor value (12795,16521,0,0);
- insert into npc_vendor value (12795,16522,0,0);
- insert into npc_vendor value (12795,16523,0,0);
- insert into npc_vendor value (12795,16524,0,0);
- insert into npc_vendor value (12795,16525,0,0);
- insert into npc_vendor value (12795,16526,0,0);
- insert into npc_vendor value (12795,16527,0,0);
- insert into npc_vendor value (12795,16528,0,0);
- insert into npc_vendor value (12795,16530,0,0);
- insert into npc_vendor value (12795,16531,0,0);
- insert into npc_vendor value (12795,17562,0,0);
- insert into npc_vendor value (12795,17564,0,0);
- insert into npc_vendor value (12795,17566,0,0);
- insert into npc_vendor value (12795,17567,0,0);
- insert into npc_vendor value (12795,17568,0,0);
- insert into npc_vendor value (12795,17569,0,0);
- insert into npc_vendor value (12795,17570,0,0);
- insert into npc_vendor value (12795,17571,0,0);
- insert into npc_vendor value (12795,17572,0,0);
- insert into npc_vendor value (12795,17573,0,0);
- insert into npc_vendor value (12795,17576,0,0);
- insert into npc_vendor value (12795,17577,0,0);
- insert into npc_vendor value (12795,17594,0,0);
- insert into npc_vendor value (12795,17596,0,0);
- insert into npc_vendor value (12795,17598,0,0);
- insert into npc_vendor value (12795,17599,0,0);
- insert into npc_vendor value (12795,17600,0,0);
- insert into npc_vendor value (12795,17601,0,0);
- insert into npc_vendor value (12795,17610,0,0);
- insert into npc_vendor value (12795,17611,0,0);
- insert into npc_vendor value (12795,17612,0,0);
- insert into npc_vendor value (12795,17613,0,0);
- insert into npc_vendor value (12795,17616,0,0);
- insert into npc_vendor value (12795,17617,0,0);
- -- PvP r13+14 set
- insert into npc_vendor value (12785, 17580, 0, 0);
- insert into npc_vendor value (12785, 16473, 0, 0);
- insert into npc_vendor value (12785, 17581, 0, 0);
- insert into npc_vendor value (12785, 17602, 0, 0);
- insert into npc_vendor value (12785, 16451, 0, 0);
- insert into npc_vendor value (12785, 16449, 0, 0);
- insert into npc_vendor value (12785, 16466, 0, 0);
- insert into npc_vendor value (12785, 16465, 0, 0);
- insert into npc_vendor value (12785, 16468, 0, 0);
- insert into npc_vendor value (12785, 17578, 0, 0);
- insert into npc_vendor value (12785, 16441, 0, 0);
- insert into npc_vendor value (12785, 16452, 0, 0);
- insert into npc_vendor value (12785, 16463, 0, 0);
- insert into npc_vendor value (12785, 16462, 0, 0);
- insert into npc_vendor value (12785, 16443, 0, 0);
- insert into npc_vendor value (12785, 16444, 0, 0);
- insert into npc_vendor value (12785, 17605, 0, 0);
- insert into npc_vendor value (12785, 17604, 0, 0);
- insert into npc_vendor value (12785, 16480, 0, 0);
- insert into npc_vendor value (12785, 16478, 0, 0);
- insert into npc_vendor value (12785, 16477, 0, 0);
- insert into npc_vendor value (12785, 16455, 0, 0);
- insert into npc_vendor value (12785, 16457, 0, 0);
- insert into npc_vendor value (12785, 16453, 0, 0);
- insert into npc_vendor value (12785, 16476, 0, 0);
- insert into npc_vendor value (12785, 16474, 0, 0);
- insert into npc_vendor value (12795, 16534, 0, 0);
- insert into npc_vendor value (12795, 16540, 0, 0);
- insert into npc_vendor value (12795, 16539, 0, 0);
- insert into npc_vendor value (12795, 17625, 0, 0);
- insert into npc_vendor value (12795, 17620, 0, 0);
- insert into npc_vendor value (12795, 17618, 0, 0);
- insert into npc_vendor value (12795, 16543, 0, 0);
- insert into npc_vendor value (12795, 16548, 0, 0);
- insert into npc_vendor value (12795, 16545, 0, 0);
- insert into npc_vendor value (12795, 16579, 0, 0);
- insert into npc_vendor value (12795, 16574, 0, 0);
- insert into npc_vendor value (12795, 16573, 0, 0);
- insert into npc_vendor value (12795, 16558, 0, 0);
- insert into npc_vendor value (12795, 16560, 0, 0);
- insert into npc_vendor value (12795, 16564, 0, 0);
- insert into npc_vendor value (12795, 17593, 0, 0);
- insert into npc_vendor value (12795, 17588, 0, 0);
- insert into npc_vendor value (12795, 17586, 0, 0);
- insert into npc_vendor value (12795, 16552, 0, 0);
- insert into npc_vendor value (12795, 16555, 0, 0);
- insert into npc_vendor value (12795, 16554, 0, 0);
- insert into npc_vendor value (12795, 16567, 0, 0);
- insert into npc_vendor value (12795, 16571, 0, 0);
- insert into npc_vendor value (12795, 16569, 0, 0);
- insert into npc_vendor value (12795, 16535, 0, 0);
- insert into npc_vendor value (12795, 16533, 0, 0);
- insert into npc_vendor value (12795, 16536, 0, 0);
- insert into npc_vendor value (12795, 17624, 0, 0);
- insert into npc_vendor value (12795, 17622, 0, 0);
- insert into npc_vendor value (12795, 17623, 0, 0);
- insert into npc_vendor value (12795, 16544, 0, 0);
- insert into npc_vendor value (12795, 16542, 0, 0);
- insert into npc_vendor value (12795, 16541, 0, 0);
- insert into npc_vendor value (12795, 16580, 0, 0);
- insert into npc_vendor value (12795, 16578, 0, 0);
- insert into npc_vendor value (12795, 16577, 0, 0);
- insert into npc_vendor value (12795, 16562, 0, 0);
- insert into npc_vendor value (12795, 16561, 0, 0);
- insert into npc_vendor value (12795, 16563, 0, 0);
- insert into npc_vendor value (12795, 17592, 0, 0);
- insert into npc_vendor value (12795, 17590, 0, 0);
- insert into npc_vendor value (12795, 17591, 0, 0);
- insert into npc_vendor value (12795, 16550, 0, 0);
- insert into npc_vendor value (12795, 16549, 0, 0);
- insert into npc_vendor value (12795, 16551, 0, 0);
- insert into npc_vendor value (12795, 16568, 0, 0);
- insert into npc_vendor value (12795, 16566, 0, 0);
- insert into npc_vendor value (12795, 16565, 0, 0);
- insert into npc_vendor value (12785, 16467, 0, 0);
- insert into npc_vendor value (12785, 16459, 0, 0);
- insert into npc_vendor value (12785, 16448, 0, 0);
- insert into npc_vendor value (12785, 16450, 0, 0);
- insert into npc_vendor value (12785, 17583, 0, 0);
- insert into npc_vendor value (12785, 17584, 0, 0);
- insert into npc_vendor value (12785, 17579, 0, 0);
- insert into npc_vendor value (12785, 16472, 0, 0);
- insert into npc_vendor value (12785, 16471, 0, 0);
- insert into npc_vendor value (12785, 16475, 0, 0);
- insert into npc_vendor value (12785, 16446, 0, 0);
- insert into npc_vendor value (12785, 16454, 0, 0);
- insert into npc_vendor value (12785, 16456, 0, 0);
- insert into npc_vendor value (12785, 16483, 0, 0);
- insert into npc_vendor value (12785, 16484, 0, 0);
- insert into npc_vendor value (12785, 16479, 0, 0);
- insert into npc_vendor value (12785, 17608, 0, 0);
- insert into npc_vendor value (12785, 17603, 0, 0);
- insert into npc_vendor value (12785, 17607, 0, 0);
- insert into npc_vendor value (12785, 16437, 0, 0);
- insert into npc_vendor value (12785, 16440, 0, 0);
- insert into npc_vendor value (12785, 16442, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement