l2j-server-datapack/L2J_DataPack/sql/updates/20080109update.sql

alter table weapon add change_weaponId decimal(11,0) NOT NULL default '0';

update weapon set change_weaponId=123 where item_Id=9216;
update weapon set change_weaponId=5285 where item_Id=9210;
update weapon set change_weaponId=7880 where item_Id=9211;
update weapon set change_weaponId=274 where item_Id=9212;
update weapon set change_weaponId=69 where item_Id=9213;
update weapon set change_weaponId=125 where item_Id=9214;
update weapon set change_weaponId=126 where item_Id=9215;
update weapon set change_weaponId=275 where item_Id=9217;
update weapon set change_weaponId=127 where item_Id=9218;
update weapon set change_weaponId=130 where item_Id=9219;
update weapon set change_weaponId=124 where item_Id=9220;
update weapon set change_weaponId=278 where item_Id=9221;
update weapon set change_weaponId=129 where item_Id=9222;
update weapon set change_weaponId=7881 where item_Id=9223;
update weapon set change_weaponId=279 where item_Id=9224;
update weapon set change_weaponId=2499 where item_Id=9225;
update weapon set change_weaponId=70 where item_Id=9226;
update weapon set change_weaponId=280 where item_Id=9227;
update weapon set change_weaponId=72 where item_Id=9228;
update weapon set change_weaponId=4681 where item_Id=9229;
update weapon set change_weaponId=4682 where item_Id=9230;
update weapon set change_weaponId=4683 where item_Id=9231;
update weapon set change_weaponId=71 where item_Id=9232;
update weapon set change_weaponId=4711 where item_Id=9233;
update weapon set change_weaponId=4712 where item_Id=9234;
update weapon set change_weaponId=4713 where item_Id=9235;
update weapon set change_weaponId=281 where item_Id=9236;
update weapon set change_weaponId=4810 where item_Id=9237;
update weapon set change_weaponId=4811 where item_Id=9238;
update weapon set change_weaponId=4812 where item_Id=9239;
update weapon set change_weaponId=73 where item_Id=9240;
update weapon set change_weaponId=4684 where item_Id=9241;
update weapon set change_weaponId=4685 where item_Id=9242;
update weapon set change_weaponId=4686 where item_Id=9243;
update weapon set change_weaponId=74 where item_Id=9244;
update weapon set change_weaponId=4687 where item_Id=9245;
update weapon set change_weaponId=4688 where item_Id=9246;
update weapon set change_weaponId=4689 where item_Id=9247;
update weapon set change_weaponId=131 where item_Id=9248;
update weapon set change_weaponId=4690 where item_Id=9249;
update weapon set change_weaponId=4691 where item_Id=9250;
update weapon set change_weaponId=4692 where item_Id=9251;
update weapon set change_weaponId=133 where item_Id=9252;
update weapon set change_weaponId=4693 where item_Id=9253;
update weapon set change_weaponId=4694 where item_Id=9254;
update weapon set change_weaponId=4695 where item_Id=9255;
update weapon set change_weaponId=282 where item_Id=9256;
update weapon set change_weaponId=4813 where item_Id=9257;
update weapon set change_weaponId=4814 where item_Id=9258;
update weapon set change_weaponId=4815 where item_Id=9259;
update weapon set change_weaponId=285 where item_Id=9260;
update weapon set change_weaponId=4816 where item_Id=9261;
update weapon set change_weaponId=4817 where item_Id=9262;
update weapon set change_weaponId=4818 where item_Id=9263;
update weapon set change_weaponId=75 where item_Id=9264;
update weapon set change_weaponId=4696 where item_Id=9265;
update weapon set change_weaponId=4697 where item_Id=9266;
update weapon set change_weaponId=4698 where item_Id=9267;
update weapon set change_weaponId=76 where item_Id=9268;
update weapon set change_weaponId=4699 where item_Id=9269;
update weapon set change_weaponId=4700 where item_Id=9270;
update weapon set change_weaponId=4701 where item_Id=9271;
update weapon set change_weaponId=77 where item_Id=9272;
update weapon set change_weaponId=4702 where item_Id=9273;
update weapon set change_weaponId=4703 where item_Id=9274;
update weapon set change_weaponId=4704 where item_Id=9275;
update weapon set change_weaponId=134 where item_Id=9276;
update weapon set change_weaponId=4705 where item_Id=9277;
update weapon set change_weaponId=4706 where item_Id=9278;
update weapon set change_weaponId=4707 where item_Id=9279;
update weapon set change_weaponId=132 where item_Id=9280;
update weapon set change_weaponId=6307 where item_Id=9281;
update weapon set change_weaponId=6308 where item_Id=9282;
update weapon set change_weaponId=6309 where item_Id=9283;
update weapon set change_weaponId=7882 where item_Id=9284;
update weapon set change_weaponId=8102 where item_Id=9285;
update weapon set change_weaponId=8103 where item_Id=9286;
update weapon set change_weaponId=8104 where item_Id=9287;
update weapon set change_weaponId=283 where item_Id=9288;
update weapon set change_weaponId=4819 where item_Id=9289;
update weapon set change_weaponId=4820 where item_Id=9290;
update weapon set change_weaponId=4821 where item_Id=9291;
update weapon set change_weaponId=135 where item_Id=9292;
update weapon set change_weaponId=4708 where item_Id=9293;
update weapon set change_weaponId=4709 where item_Id=9294;
update weapon set change_weaponId=4710 where item_Id=9295;
update weapon set change_weaponId=5286 where item_Id=9296;
update weapon set change_weaponId=6347 where item_Id=9297;
update weapon set change_weaponId=6348 where item_Id=9298;
update weapon set change_weaponId=6349 where item_Id=9299;
update weapon set change_weaponId=286 where item_Id=9300;
update weapon set change_weaponId=4822 where item_Id=9301;
update weapon set change_weaponId=4823 where item_Id=9302;
update weapon set change_weaponId=4824 where item_Id=9303;
update weapon set change_weaponId=142 where item_Id=9304;
update weapon set change_weaponId=4714 where item_Id=9305;
update weapon set change_weaponId=4715 where item_Id=9306;
update weapon set change_weaponId=4716 where item_Id=9307;
update weapon set change_weaponId=78 where item_Id=9308;
update weapon set change_weaponId=4723 where item_Id=9309;
update weapon set change_weaponId=4724 where item_Id=9310;
update weapon set change_weaponId=4725 where item_Id=9311;
update weapon set change_weaponId=284 where item_Id=9312;
update weapon set change_weaponId=4825 where item_Id=9313;
update weapon set change_weaponId=4826 where item_Id=9314;
update weapon set change_weaponId=4827 where item_Id=9315;
update weapon set change_weaponId=79 where item_Id=9316;
update weapon set change_weaponId=4717 where item_Id=9317;
update weapon set change_weaponId=4718 where item_Id=9318;
update weapon set change_weaponId=4719 where item_Id=9319;
update weapon set change_weaponId=7883 where item_Id=9320;
update weapon set change_weaponId=8105 where item_Id=9321;
update weapon set change_weaponId=8106 where item_Id=9322;
update weapon set change_weaponId=8107 where item_Id=9323;
update weapon set change_weaponId=287 where item_Id=9324;
update weapon set change_weaponId=4828 where item_Id=9325;
update weapon set change_weaponId=4829 where item_Id=9326;
update weapon set change_weaponId=4830 where item_Id=9327;
update weapon set change_weaponId=80 where item_Id=9328;
update weapon set change_weaponId=4720 where item_Id=9329;
update weapon set change_weaponId=4721 where item_Id=9330;
update weapon set change_weaponId=4722 where item_Id=9331;
update weapon set change_weaponId=7884 where item_Id=9332;
update weapon set change_weaponId=8108 where item_Id=9333;
update weapon set change_weaponId=8109 where item_Id=9334;
update weapon set change_weaponId=8110 where item_Id=9335;
update weapon set change_weaponId=288 where item_Id=9336;
update weapon set change_weaponId=5608 where item_Id=9337;
update weapon set change_weaponId=5609 where item_Id=9338;
update weapon set change_weaponId=5610 where item_Id=9339;
update weapon set change_weaponId=2500 where item_Id=9340;
update weapon set change_weaponId=5647 where item_Id=9341;
update weapon set change_weaponId=5648 where item_Id=9342;
update weapon set change_weaponId=5649 where item_Id=9343;
update weapon set change_weaponId=81 where item_Id=9344;
update weapon set change_weaponId=5644 where item_Id=9345;
update weapon set change_weaponId=5645 where item_Id=9346;
update weapon set change_weaponId=5646 where item_Id=9347;
update weapon set change_weaponId=289 where item_Id=9348;
update weapon set change_weaponId=5611 where item_Id=9349;
update weapon set change_weaponId=5612 where item_Id=9350;
update weapon set change_weaponId=5613 where item_Id=9351;
update weapon set change_weaponId=8678 where item_Id=9352;
update weapon set change_weaponId=8788 where item_Id=9353;
update weapon set change_weaponId=8789 where item_Id=9354;
update weapon set change_weaponId=8790 where item_Id=9355;
update weapon set change_weaponId=8679 where item_Id=9356;
update weapon set change_weaponId=8791 where item_Id=9357;
update weapon set change_weaponId=8792 where item_Id=9358;
update weapon set change_weaponId=8793 where item_Id=9359;
update weapon set change_weaponId=8684 where item_Id=9360;
update weapon set change_weaponId=8806 where item_Id=9361;
update weapon set change_weaponId=8807 where item_Id=9362;
update weapon set change_weaponId=8808 where item_Id=9363;
update weapon set change_weaponId=6364 where item_Id=9364;
update weapon set change_weaponId=6581 where item_Id=9365;
update weapon set change_weaponId=6582 where item_Id=9366;
update weapon set change_weaponId=6583 where item_Id=9367;
update weapon set change_weaponId=6372 where item_Id=9368;
update weapon set change_weaponId=6605 where item_Id=9369;
update weapon set change_weaponId=6606 where item_Id=9370;
update weapon set change_weaponId=6607 where item_Id=9371;
update weapon set change_weaponId=7575 where item_Id=9372;
update weapon set change_weaponId=7576 where item_Id=9373;
update weapon set change_weaponId=7577 where item_Id=9374;
update weapon set change_weaponId=7578 where item_Id=9375;
update weapon set change_weaponId=9442 where item_Id=9376;
update weapon set change_weaponId=9854 where item_Id=9377;
update weapon set change_weaponId=9855 where item_Id=9378;
update weapon set change_weaponId=9856 where item_Id=9379;
update weapon set change_weaponId=9443 where item_Id=9380;
update weapon set change_weaponId=9857 where item_Id=9381;
update weapon set change_weaponId=9858 where item_Id=9382;
update weapon set change_weaponId=9859 where item_Id=9383;
update weapon set change_weaponId=9445 where item_Id=9384;
update weapon set change_weaponId=9863 where item_Id=9385;
update weapon set change_weaponId=9864 where item_Id=9386;
update weapon set change_weaponId=9865 where item_Id=9387;

-- Back to normal Weps

update weapon set change_weaponId=9216 where item_Id=123;
update weapon set change_weaponId=9210 where item_Id=5285;
update weapon set change_weaponId=9211 where item_Id=7880;
update weapon set change_weaponId=9212 where item_Id=274;
update weapon set change_weaponId=9213 where item_Id=69;
update weapon set change_weaponId=9214 where item_Id=125;
update weapon set change_weaponId=9215 where item_Id=126;
update weapon set change_weaponId=9217 where item_Id=275;
update weapon set change_weaponId=9218 where item_Id=127;
update weapon set change_weaponId=9219 where item_Id=130;
update weapon set change_weaponId=9220 where item_Id=124;
update weapon set change_weaponId=9221 where item_Id=278;
update weapon set change_weaponId=9222 where item_Id=129;
update weapon set change_weaponId=9223 where item_Id=7881;
update weapon set change_weaponId=9224 where item_Id=279;
update weapon set change_weaponId=9225 where item_Id=2499;
update weapon set change_weaponId=9226 where item_Id=70;
update weapon set change_weaponId=9227 where item_Id=280;
update weapon set change_weaponId=9228 where item_Id=72;
update weapon set change_weaponId=9229 where item_Id=4681;
update weapon set change_weaponId=9230 where item_Id=4682;
update weapon set change_weaponId=9231 where item_Id=4683;
update weapon set change_weaponId=9232 where item_Id=71;
update weapon set change_weaponId=9233 where item_Id=4711;
update weapon set change_weaponId=9234 where item_Id=4712;
update weapon set change_weaponId=9235 where item_Id=4713;
update weapon set change_weaponId=9236 where item_Id=281;
update weapon set change_weaponId=9237 where item_Id=4810;
update weapon set change_weaponId=9238 where item_Id=4811;
update weapon set change_weaponId=9239 where item_Id=4812;
update weapon set change_weaponId=9240 where item_Id=73;
update weapon set change_weaponId=9241 where item_Id=4684;
update weapon set change_weaponId=9242 where item_Id=4685;
update weapon set change_weaponId=9243 where item_Id=4686;
update weapon set change_weaponId=9244 where item_Id=74;
update weapon set change_weaponId=9245 where item_Id=4687;
update weapon set change_weaponId=9246 where item_Id=4688;
update weapon set change_weaponId=9247 where item_Id=4689;
update weapon set change_weaponId=9248 where item_Id=131;
update weapon set change_weaponId=9249 where item_Id=4690;
update weapon set change_weaponId=9250 where item_Id=4691;
update weapon set change_weaponId=9251 where item_Id=4692;
update weapon set change_weaponId=9252 where item_Id=133;
update weapon set change_weaponId=9253 where item_Id=4693;
update weapon set change_weaponId=9254 where item_Id=4694;
update weapon set change_weaponId=9255 where item_Id=4695;
update weapon set change_weaponId=9256 where item_Id=282;
update weapon set change_weaponId=9257 where item_Id=4813;
update weapon set change_weaponId=9258 where item_Id=4814;
update weapon set change_weaponId=9259 where item_Id=4815;
update weapon set change_weaponId=9260 where item_Id=285;
update weapon set change_weaponId=9261 where item_Id=4816;
update weapon set change_weaponId=9262 where item_Id=4817;
update weapon set change_weaponId=9263 where item_Id=4818;
update weapon set change_weaponId=9264 where item_Id=75;
update weapon set change_weaponId=9265 where item_Id=4696;
update weapon set change_weaponId=9266 where item_Id=4697;
update weapon set change_weaponId=9267 where item_Id=4698;
update weapon set change_weaponId=9268 where item_Id=76;
update weapon set change_weaponId=9269 where item_Id=4699;
update weapon set change_weaponId=9270 where item_Id=4700;
update weapon set change_weaponId=9271 where item_Id=4701;
update weapon set change_weaponId=9272 where item_Id=77;
update weapon set change_weaponId=9273 where item_Id=4702;
update weapon set change_weaponId=9274 where item_Id=4703;
update weapon set change_weaponId=9275 where item_Id=4704;
update weapon set change_weaponId=9276 where item_Id=134;
update weapon set change_weaponId=9277 where item_Id=4705;
update weapon set change_weaponId=9278 where item_Id=4706;
update weapon set change_weaponId=9279 where item_Id=4707;
update weapon set change_weaponId=9280 where item_Id=132;
update weapon set change_weaponId=9281 where item_Id=6307;
update weapon set change_weaponId=9282 where item_Id=6308;
update weapon set change_weaponId=9283 where item_Id=6309;
update weapon set change_weaponId=9284 where item_Id=7882;
update weapon set change_weaponId=9285 where item_Id=8102;
update weapon set change_weaponId=9286 where item_Id=8103;
update weapon set change_weaponId=9287 where item_Id=8104;
update weapon set change_weaponId=9288 where item_Id=283;
update weapon set change_weaponId=9289 where item_Id=4819;
update weapon set change_weaponId=9290 where item_Id=4820;
update weapon set change_weaponId=9291 where item_Id=4821;
update weapon set change_weaponId=9292 where item_Id=135;
update weapon set change_weaponId=9293 where item_Id=4708;
update weapon set change_weaponId=9294 where item_Id=4709;
update weapon set change_weaponId=9295 where item_Id=4710;
update weapon set change_weaponId=9296 where item_Id=5286;
update weapon set change_weaponId=9297 where item_Id=6347;
update weapon set change_weaponId=9298 where item_Id=6348;
update weapon set change_weaponId=9299 where item_Id=6349;
update weapon set change_weaponId=9300 where item_Id=286;
update weapon set change_weaponId=9301 where item_Id=4822;
update weapon set change_weaponId=9302 where item_Id=4823;
update weapon set change_weaponId=9303 where item_Id=4824;
update weapon set change_weaponId=9304 where item_Id=142;
update weapon set change_weaponId=9305 where item_Id=4714;
update weapon set change_weaponId=9306 where item_Id=4715;
update weapon set change_weaponId=9307 where item_Id=4716;
update weapon set change_weaponId=9308 where item_Id=78;
update weapon set change_weaponId=9309 where item_Id=4723;
update weapon set change_weaponId=9310 where item_Id=4724;
update weapon set change_weaponId=9311 where item_Id=4725;
update weapon set change_weaponId=9312 where item_Id=284;
update weapon set change_weaponId=9313 where item_Id=4825;
update weapon set change_weaponId=9314 where item_Id=4826;
update weapon set change_weaponId=9315 where item_Id=4827;
update weapon set change_weaponId=9316 where item_Id=79;
update weapon set change_weaponId=9317 where item_Id=4717;
update weapon set change_weaponId=9318 where item_Id=4718;
update weapon set change_weaponId=9319 where item_Id=4719;
update weapon set change_weaponId=9320 where item_Id=7883;
update weapon set change_weaponId=9321 where item_Id=8105;
update weapon set change_weaponId=9322 where item_Id=8106;
update weapon set change_weaponId=9323 where item_Id=8107;
update weapon set change_weaponId=9324 where item_Id=287;
update weapon set change_weaponId=9325 where item_Id=4828;
update weapon set change_weaponId=9326 where item_Id=4829;
update weapon set change_weaponId=9327 where item_Id=4830;
update weapon set change_weaponId=9328 where item_Id=80;
update weapon set change_weaponId=9329 where item_Id=4720;
update weapon set change_weaponId=9330 where item_Id=4721;
update weapon set change_weaponId=9331 where item_Id=4722;
update weapon set change_weaponId=9332 where item_Id=7884;
update weapon set change_weaponId=9333 where item_Id=8108;
update weapon set change_weaponId=9334 where item_Id=8109;
update weapon set change_weaponId=9335 where item_Id=8110;
update weapon set change_weaponId=9336 where item_Id=288;
update weapon set change_weaponId=9337 where item_Id=5608;
update weapon set change_weaponId=9338 where item_Id=5609;
update weapon set change_weaponId=9339 where item_Id=5610;
update weapon set change_weaponId=9340 where item_Id=2500;
update weapon set change_weaponId=9341 where item_Id=5647;
update weapon set change_weaponId=9342 where item_Id=5648;
update weapon set change_weaponId=9343 where item_Id=5649;
update weapon set change_weaponId=9344 where item_Id=81;
update weapon set change_weaponId=9345 where item_Id=5644;
update weapon set change_weaponId=9346 where item_Id=5645;
update weapon set change_weaponId=9347 where item_Id=5646;
update weapon set change_weaponId=9348 where item_Id=289;
update weapon set change_weaponId=9349 where item_Id=5611;
update weapon set change_weaponId=9350 where item_Id=5612;
update weapon set change_weaponId=9351 where item_Id=5613;
update weapon set change_weaponId=9352 where item_Id=8678;
update weapon set change_weaponId=9353 where item_Id=8788;
update weapon set change_weaponId=9354 where item_Id=8789;
update weapon set change_weaponId=9355 where item_Id=8790;
update weapon set change_weaponId=9356 where item_Id=8679;
update weapon set change_weaponId=9357 where item_Id=8791;
update weapon set change_weaponId=9358 where item_Id=8792;
update weapon set change_weaponId=9359 where item_Id=8793;
update weapon set change_weaponId=9360 where item_Id=8684;
update weapon set change_weaponId=9361 where item_Id=8806;
update weapon set change_weaponId=9362 where item_Id=8807;
update weapon set change_weaponId=9363 where item_Id=8808;
update weapon set change_weaponId=9364 where item_Id=6364;
update weapon set change_weaponId=9365 where item_Id=6581;
update weapon set change_weaponId=9366 where item_Id=6582;
update weapon set change_weaponId=9367 where item_Id=6583;
update weapon set change_weaponId=9368 where item_Id=6372;
update weapon set change_weaponId=9369 where item_Id=6605;
update weapon set change_weaponId=9370 where item_Id=6606;
update weapon set change_weaponId=9371 where item_Id=6607;
update weapon set change_weaponId=9372 where item_Id=7575;
update weapon set change_weaponId=9373 where item_Id=7576;
update weapon set change_weaponId=9374 where item_Id=7577;
update weapon set change_weaponId=9375 where item_Id=7578;
update weapon set change_weaponId=9376 where item_Id=9442;
update weapon set change_weaponId=9377 where item_Id=9854;
update weapon set change_weaponId=9378 where item_Id=9855;
update weapon set change_weaponId=9379 where item_Id=9856;
update weapon set change_weaponId=9380 where item_Id=9443;
update weapon set change_weaponId=9381 where item_Id=9857;
update weapon set change_weaponId=9382 where item_Id=9858;
update weapon set change_weaponId=9383 where item_Id=9859;
update weapon set change_weaponId=9384 where item_Id=9445;
update weapon set change_weaponId=9385 where item_Id=9863;
update weapon set change_weaponId=9386 where item_Id=9864;
update weapon set change_weaponId=9387 where item_Id=9865;