Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $arr = array(50, '011332403',
- 51, '01131448',
- 52, '01133348',
- 53, '01134950',
- 55, '01137550',
- 56, '01081548',
- 57, '010814399',
- 58, '01080347',
- 59, '01083750',
- 62, '02051648',
- 63, '02050147',
- 64, '010832399',
- 65, '02040845',
- 66, '02120345',
- 67, '02051541',
- 68, '01083448',
- 70, '010841399',
- 71, '01084248',
- 73, '010841399',
- 75, '01301050',
- 76, '01300940',
- 77, '01301150',
- 78, '02045965',
- 79, '02045762',
- 80, '02045866',
- 81, '02120996',
- 82, '02121095',
- 83, '6004039',
- 84, '6004002',
- 85, '6030001',
- 86, '6001002',
- 87, '6001039',
- 88, '6001079',
- 89, '6001029',
- 90, '6001030',
- 91, '6001012',
- 92, '6001013',
- 93, '6001038',
- 94, '6001040',
- 95, '6001043',
- 96, '6001057',
- 97, '6001024',
- 98, '6001044',
- 99, '6001023',
- 100, '6001042',
- 101, '6002042',
- 102, '01071140',
- 103, '01072540',
- 104, '010713476',
- 105, '010726476',
- 106, '01073450',
- 109, '010735476',
- 110, '01061940',
- 112, '010621476',
- 113, '010630476',
- 114, '01062940',
- 115, '01090341',
- 116, '010904476',
- 117, '010905476',
- 118, '01023040',
- 119, '01024240',
- 120, '010231476',
- 121, '010243476',
- 122, '01160739',
- 123, '011608476',
- 124, '01300540',
- 125, '013006476',
- 126, '01025440',
- 127, '01026340',
- 128, '010255476',
- 129, '02370164',
- 130, '020462524',
- 132, '02046358',
- 133, '02046458',
- 134, '02046561',
- 135, '01130940',
- 174, '021606476',
- 184, '013004476',
- 185, '01300340',
- 192, '6040301',
- 194, '6040436',
- 195, '6040303',
- 196, '6040422',
- 198, '6040423',
- 199, '6040424',
- 201, '6040428',
- 203, '6040425',
- 204, '6040426',
- 205, '6040427',
- 206, '6040431',
- 207, '6040430',
- 208, '6040421',
- 209, '6040432',
- 210, '6040435',
- 211, '6040438',
- 212, '6040439',
- 213, '6040440',
- 214, '6040302',
- 215, '6040304',
- 216, '6040309',
- 217, '6040310',
- 219, '6040311',
- 220, '6040312',
- 221, '6040313',
- 222, '6040305',
- 223, '6040306',
- 225, '6040307',
- 226, '6040308',
- 229, '6091501',
- 230, '6091502',
- 231, '6091504',
- 232, '6093501',
- 233, '6093502',
- 234, '6093504',
- 235, '6030003',
- 236, '6030002',
- 237, '6030008',
- 238, '6030009',
- 239, '6030014',
- 240, '6030011',
- 241, '6030013',
- 244, '6030021',
- 245, '6030012',
- 246, '6030010',
- 247, '6030022',
- 248, '6030018',
- 249, '6030023',
- 250, '6030025',
- 251, '6030026',
- 252, '6030029',
- 253, '6030033',
- 254, '6030036',
- 255, '6030062',
- 257, '6030078',
- 258, '6030076',
- 263, '6030085',
- 264, '6030087',
- 265, '6030088',
- 266, '6030089',
- 267, '6030090',
- 268, '6030097',
- 269, '6030103',
- 270, '6030104',
- 271, '6030106',
- 272, '6030080',
- 273, '6030108',
- 274, '6030113',
- 275, '6030118',
- 276, '6030127',
- 277, '6030119',
- 278, '6030145',
- 279, '6030121',
- 280, '6031001',
- 281, '6031002',
- 282, '6031014',
- 283, '6031018',
- 284, '6031023',
- 285, '6031026',
- 286, '6031029',
- 287, '6031106',
- 288, '6031145',
- 289, '6034001',
- 289, '6034501',
- 291, '6034002',
- 291, '6034502',
- 292, '6034018',
- 293, '6034023',
- 294, '6034026',
- 295, '6034029',
- 296, '6034078',
- 297, '6034085',
- 298, '6034088',
- 299, '6034090',
- 300, '6034106',
- 301, '6034118',
- 302, '6034145',
- 304, '6037001',
- 304, '6037501',
- 305, '6037002',
- 305, '6037502',
- 306, '6037018',
- 308, '6111001',
- 309, '6111002',
- 310, '6111003',
- 311, '6111007',
- 312, '6111012',
- 313, '6111009',
- 314, '6111005',
- 315, '6111013',
- 317, '6111016',
- 318, '6111017',
- 319, '6111018',
- 320, '311316476',
- 321, '31064350',
- 321, '31064450',
- 322, '31071140',
- 322, '31073350',
- 322, '31073450',
- 323, '310617476',
- 335, '6062001',
- 336, '6062002',
- 337, '6062003',
- 338, '6062004',
- 339, '6062005',
- 340, '6062006',
- 341, '6062007',
- 342, '6062008',
- 343, '6062009',
- 344, '6062010',
- 345, '6082521',
- 345, '6083521',
- 345, '6084521',
- 346, '6080521',
- 347, '6080536',
- 348, '6082536',
- 348, '6083536',
- 348, '6084536',
- 349, '6072471',
- 349, '6072472',
- 349, '6072473',
- 350, '6072476',
- 350, '6072477',
- 350, '6072478',
- 351, '6072486',
- 351, '6072487',
- 351, '6072488',
- 352, '6072474',
- 353, '6072489',
- 354, '6010201',
- 354, '6010202',
- 354, '6010203',
- 355, '6010207',
- 355, '6010208',
- 356, '6010214',
- 357, '6010217',
- 357, '6010220',
- 358, '6010253',
- 359, '6010254',
- 360, '6010258',
- 361, '6010259',
- 363, '6010263',
- 364, '6010264',
- 364, '6010265',
- 365, '6010229',
- 365, '6010230',
- 365, '6010231',
- 365, '6010247',
- 365, '6010248',
- 365, '6010249',
- 366, '6010236',
- 367, '6010238',
- 368, '6010240',
- 369, '6010243',
- 369, '6010246',
- 370, '6010245',
- 371, '6011302',
- 372, '6011321',
- 372, '6011322',
- 373, '6011303',
- 374, '6011301',
- 375, '6011305',
- 376, '6011318',
- 377, '6011319',
- 378, '6011313',
- 379, '6011320',
- 381, '6012354',
- 381, '6012378',
- 382, '6012351',
- 382, '6012352',
- 383, '6012356',
- 383, '6012358',
- 384, '6012360',
- 384, '6012362',
- 385, '6012364',
- 385, '6012365',
- 385, '6012366',
- 386, '6012371',
- 387, '6012372',
- 388, '6012373',
- 389, '6012374',
- 390, '6012375',
- 391, '6012376',
- 391, '6012379',
- 392, '6012380',
- 393, '6012382',
- 395, '6012384',
- 396, '6012385',
- 397, '6012389',
- 400, '6012390',
- 400, '6012391',
- 401, '6014393',
- 402, '6014394',
- 403, '6014395',
- 404, '6014396',
- 405, '6014398',
- 406, '6200001',
- 407, '6200002',
- 408, '6200003',
- 409, '6200004',
- 410, '6200005',
- 411, '6200012',
- 412, '6110602',
- 413, '6330001',
- 414, '6050435',
- 415, '6304002',
- 416, '6306255',
- 416, '6306255',
- 417, '6305258',
- 419, '6500003',
- 420, '6110603',
- 421, '6110603',
- 422, '6110605',
- 423, '6110606',
- 424, '6110607',
- 425, '6110608',
- 426, '6110609',
- 427, '6110623',
- 428, '6110642',
- 429, '6110649',
- 430, '6330002',
- 431, '6330003',
- 432, '6330004',
- 433, '6050436',
- 434, '6050437',
- 435, '6050438',
- 436, '6050439',
- 438, '6304003',
- 439, '6304258',
- 440, '6304255',
- 441, '6306255',
- 441, '6306259',
- 442, '6305255',
- 443, '6500001',
- 444, '6131001',
- 444, '6131002',
- 444, '6131003',
- 444, '6131004',
- 445, '6131201',
- 445, '6131202',
- 445, '6131203',
- 445, '6131204',
- 451, '6001001',
- 452, '6001007',
- 453, '6001008',
- 454, '6001009',
- 455, '6001010',
- 456, '6001011',
- 457, '6001014',
- 458, '6001018',
- 459, '6001017',
- 463, '6001021',
- 464, '6001050',
- 466, '6001058',
- 467, '6001059',
- 468, '6001054',
- 470, '6001060',
- 471, '6001070',
- 472, '6001080',
- 473, '6001083',
- 474, '6001104',
- 475, '6001133',
- 476, '6001135',
- 477, '6001145',
- 478, '6001148',
- 479, '6001134',
- 480, '6002008',
- 481, '6002010',
- 482, '6004001',
- 483, '6004014',
- 484, '6004018',
- 485, '6001045',
- 486, '6001107',
- 487, '6001108',
- 488, '6001152',
- 489, '6001153',
- 490, '6001169',
- 491, '6001071',
- 492, '6001109',
- 493, '6030082',
- 494, '6030081',
- 495, '6030109',
- 496, '6030117',
- 496, '6038023',
- 496, '6038024',
- 497, '6030123',
- 498, '6030125',
- 499, '6030146',
- 500, '6030161',
- 501, '6030166',
- 502, '6030133',
- 503, '6030134',
- 504, 'Ap.250.1ECM',
- 505, 'M12045',
- 506, 'AP.254 ECM',
- 507, 'AP.255ECM',
- 507, 'GI.25 ECM',
- 507, 'VE.253.1ECM',
- 508, 'AP.256 ECM',
- 508, 'ML.250 ECM',
- 508, 'PE.252 ECM',
- 508, 'VE.254.1 ECM',
- 509, 'DA.251ECM',
- 510, 'DA.252ECM',
- 511, 'HO.259ECM',
- 511, 'KY.251ECM',
- 511, 'VE.252ECM',
- 512, 'HY.250ECM',
- 513, 'HY.253ECM',
- 514, 'KY.250ECM',
- 515, 'KY.252ECM',
- 516, 'KY.253ECM',
- 517, 'KY.254ECM',
- 518, 'PI.201ECM',
- 519, 'PE.250ECM',
- 520, 'PE.251ECM',
- 521, 'PI.202ECM',
- 522, 'M19226',
- 523, 'SU.251ECM',
- 524, 'SU.255ECM',
- 526, 'YA.214ECM',
- 527, 'VE.251ECM',
- 528, 'YA.216ECM',
- 529, 'YA.256ECM',
- 530, 'YA.257ECM',
- 531, 'YA.265ECM',
- 532, 'YA.267ECM',
- 533, 'YA.268ECM',
- 534, '6030004',
- 535, '6030016',
- 536, '6030017',
- 537, '6030032',
- 538, '6030034',
- 539, '6030035',
- 540, '6030041',
- 541, '6030043',
- 543, '6030055',
- 544, '6030057',
- 545, '6030056',
- 546, '6030042',
- 547, '6030060',
- 548, '6030061',
- 549, '6030065',
- 550, '6030066',
- 551, '6030075',
- 552, '6030083',
- 553, '6030084',
- 554, '6030102',
- 556, '6031003',
- 557, '6031064',
- 558, '6031065',
- 559, '6031083',
- 561, '6034003',
- 561, '6036001',
- 561, '6036002',
- 562, '6034035',
- 562, '6036135',
- 563, '6034041',
- 564, '6034065',
- 564, '6036065',
- 564, '6036066',
- 565, '6034083',
- 565, '6036083',
- 565, '6036084',
- 565, '6036105',
- 566, '6034102',
- 566, '6036102',
- 566, '6036103',
- 566, '6036104',
- 567, '6037023',
- 568, '6037003',
- 569, '6037065',
- 570, '6037083',
- 571, '6037102',
- 572, '000B99005',
- 573, '000B99006',
- 574, '000B99007',
- 575, '000B99013',
- 576, '000B99019',
- 577, '000B99020',
- 578, '000B99021',
- 579, '000B99022',
- 580, '000B99024',
- 581, '000B99025',
- 582, '000B99026',
- 583, '000B99027',
- 584, '000B99037',
- 585, '000B99029',
- 586, '000B99030',
- 587, '000B99031',
- 588, '000B99032',
- 589, '000B99033',
- 590, '000B99034',
- 591, '000B99028',
- 593, '000B99038',
- 594, '000B99001',
- 595, '000B99002',
- 596, '000B99003',
- 597, '000B99004',
- 598, '000B99008',
- 599, '000B99009',
- 600, '000B99010',
- 601, '000B99012',
- 602, '000B99011',
- 603, '000B99014',
- 604, '000B99015',
- 605, '000B99016',
- 606, '000B99017',
- 607, '000B99018',
- 608, '000B99023',
- 609, '000B99035',
- 610, '000B99039',
- 611, '000B99040',
- 612, '000B99041',
- 613, '000B99042',
- 614, '000B99043',
- 615, 'SS.86CR80',
- 616, 'SS.86CR125',
- 617, 'SS.00CR125',
- 618, 'SS.94CR250',
- 619, 'SS.10CRF250',
- 620, 'SS.CRF150',
- 621, 'SS.85KX60',
- 622, 'SS.98KX80',
- 623, 'SS.94KX125',
- 624, 'SS.92KX250',
- 625, 'SS.04KXF250',
- 626, 'SS.06KXF450',
- 627, 'SS.KTMSX65 09',
- 628, 'SS.KTMSX85',
- 629, 'SS.98KTM125',
- 630, 'SS.KTM250SXF',
- 631, 'SS.KTM250SX',
- 632, 'SS.91RM80',
- 633, 'SS.92RM125',
- 634, 'SS.97RM250',
- 635, 'SS.05RMZ450',
- 636, 'SS.04RMZ250',
- 637, 'SS.07RMZ250',
- 638, 'SS.95YZ80',
- 640, 'SS.02YZ85',
- 641, 'SS.93YZ125',
- 642, 'SS.88YZ250',
- 643, 'SS.01YZF250',
- 644, 'SS.03YZF450',
- 645, 'SS.02RM125',
- 646, 'SS.03RM250',
- 647, 'SS.10RMZ250',
- 648, 'SS.08RMZ450',
- 649, 'SS.03KX125',
- 650, 'SK.86CR80',
- 651, 'SK.87CR125',
- 652, 'SK.00CR125',
- 653, 'SK.10CRF250',
- 654, 'SK.92CR250',
- 655, 'SK.85KX60',
- 656, 'SK.88KX80',
- 657, 'SK.98KX80',
- 658, 'SK.94KX125',
- 659, 'SK.03KX125',
- 660, 'SK.92KX250',
- 661, 'SK.06KX250',
- 662, 'SK.06KFX450',
- 663, 'SK.06SX125',
- 664, 'SK.KTMSX85',
- 665, 'SK.98KTMSX125',
- 666, 'SK.88SX250',
- 667, 'SK.KTMSX65',
- 668, 'SK.87RM80',
- 669, 'SK.92RM125',
- 670, 'SK.96RM250',
- 671, 'SK.03RM250',
- 672, 'SK.04RMZ250',
- 673, 'SK.94YZ80',
- 674, 'SK.02YZ85',
- 675, 'SK.03YZ85',
- 676, 'SK.93YZ125',
- 677, 'SK.05YZ125',
- 678, 'SK.YZF250',
- 679, 'SK.93YZ250',
- 680, 'SK.98YZF400',
- 681, 'SK.99YZF426',
- 683, 'SK.03YZF450',
- 684, 'SK.04YZF450',
- 685, 'PT.90CR80',
- 686, 'PT.86CR125',
- 687, 'PT.90CR250',
- 690, 'PT.83KX60',
- 691, 'PT.94KX125',
- 692, 'PT.03KX125',
- 693, 'PT.92KX250',
- 694, 'CP.03KX250',
- 695, 'PT.06KXF450',
- 697, 'PT.96RM125',
- 698, 'PT.96RM250',
- 699, 'CP.07RMZ250',
- 700, 'SS.00CR125',
- 701, 'SS.92CR250',
- 702, 'SK.90CR500',
- 708, 'SK.06RMZ250',
- 709, 'SK.93RM250',
- 710, 'SK.07RMZ250',
- 712, 'SK.10RMZ250',
- 718, 'SS.94CR250',
- 719, 'SS.85KX65',
- 720, 'SS.88KX80',
- 721, 'SS.92KX125',
- 722, 'SS.93KX125',
- 723, 'SS.89KX500',
- 724, 'SS.KTM450SXF 03',
- 725, 'SS.KTMSX65 98',
- 726, 'SS.KTM350SXF',
- 727, 'SS.KTM400SXF',
- 728, 'SS.KTM450 EXCF08',
- 729, 'SS.KTM450SXF 07-11',
- 730, 'SS.94RM250',
- 731, 'SS.96RM250',
- 732, 'SS.06RM250',
- 733, 'SS.DRZ400',
- 734, 'SS.02YZ125',
- 735, 'SS.93YZ250',
- 736, 'SS.00YZ250',
- 737, 'SS.02YZ250',
- 738, 'SS.08YZF250',
- 739, 'SS.01WRF250',
- 740, 'SS.98YZF400',
- 741, 'SS.00YZF426',
- 742, 'SS.01YZF426',
- 743, 'SS.05YZF450',
- 744, 'SS.07YZF450',
- 745, 'PT.00CR125');
- for($i = 0; $i<count($arr)-1; $i+=2) {
- $id = $arr[$i];
- $sku = $arr[$i+1];
- echo "UPDATE `do1340002db`.`product` SET `product`.`sku` = '{$sku}' WHERE `product`.`product_id` = '{$id}' AND `product`.`sku` = '' AND `product`.`sku` != '{$sku}'; <br/>";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement