Advertisement
DeMorgan

Untitled

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