Guest User

Untitled

a guest
Jan 24th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.46 KB | None | 0 0
  1.  
  2. <?php
  3.  
  4. function clean($in) {
  5. // I used this function to rename things, since the conversation also required a name change.
  6. $out = str_replace("Oldsite", "Newsite", $in);
  7. return $out;
  8. }
  9.  
  10. $source_database = 'dbname';
  11. $source_server = 'dbserver';
  12. $source_user = 'dbuser';
  13. $source_pass = 'dbpass';
  14.  
  15. $source = mysql_connect( $source_server, $source_user, $source_pass );
  16. mysql_select_db($source_database);
  17.  
  18. $result = mysql_query("SELECT cat_id, cat_father_id, cat_name, cat_desc, cat_metatitle, cat_metadesc, cat_metakeywords FROM `cubecart_category`;");
  19.  
  20. while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
  21. //af_category
  22. $af_category = "INSERT INTO `targetdatabase`.`af_category` (`id_category`, `id_parent`, `level_depth`, `active`) VALUES ('".$row[0]."', '".$row[1]."', '1', '1'); <br />";
  23.  
  24. //af_category_lang
  25. $af_category_lang = "INSERT INTO `targetdatabase`.`af_category_lang` (`id_category`, `id_lang`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`)
  26. VALUES ('".$row[0]."', '1', '".strip_tags($row[2])."', '".strip_tags($row[3])."', '".str_replace(' ', '-', strtolower($row[2]))."', '".strip_tags($row[4])."', '".strip_tags($row[5])."', '".strip_tags($row[6])."'); <br />";
  27.  
  28. $af_category_group = "INSERT INTO `targetdatabase`.`af_category_group` (`id_category`, `id_group`) VALUES ('".$row[0]."','1'); <br />";
  29.  
  30. echo clean($af_category);
  31. echo clean($af_category_lang);
  32. echo clean($af_category_group);
  33.  
  34. echo "<br /><br /><br />";
  35. }
  36.  
  37. mysql_free_result($result);
  38.  
  39.  
  40. $result = mysql_query("SELECT productId, disabled, productCode, description, image, price, name, cat_id, stock_level, prod_metatitle, prod_metadesc, prod_metakeywords FROM `cubecart_inventory`;");
  41.  
  42. while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
  43.  
  44. $disable = $row[1];
  45.  
  46. $active = 1;
  47. if ($disabled == 1) $active = 0;
  48.  
  49. // af_product
  50. $af_product = "INSERT INTO `targetdatabase`.`af_product`
  51. (`id_product`, `price`, `id_category_default`, `active`, `reference`) VALUES
  52. ('".$row[0]."', '".$row[5]."', '".$row[7]."', '".$active."', '".$row[2]."'); <br />";
  53.  
  54. // af_product_lang
  55. $af_product_lang = "INSERT INTO `targetdatabase`.`af_product_lang` (`id_product`, `id_lang`, `description`,
  56. `description_short`, `link_rewrite`, `meta_description`,
  57. `meta_keywords`, `meta_title`, `name` ) VALUES
  58.  
  59. ('".$row[0]."', '1', '".strip_tags($row[3])."',
  60. '".strip_tags($row[3])."', '".str_replace(' ', '-', strtolower($row[6]))."', '".$row[10]."',
  61. '".$row[11]."', '".$row[9]."', '".$row[6]."'); <br />";
  62.  
  63. // af_category_product
  64. $af_category_product = "INSERT INTO `targetdatabase`.`af_category_product` (`id_category`, `id_product`)
  65. VALUES ('".$row[7]."', '".$row[0]."'); <br />";
  66.  
  67. // af_image
  68. $af_image = "INSERT INTO `targetdatabase`.`af_image` (`id_image`, `id_product`, `position`, `cover`)
  69. VALUES ('".$row[0]."','".$row[0]."','1','1'); <br />";
  70.  
  71. // af_image_lang
  72. $af_image_lang = "INSERT INTO `targetdatabase`.`af_image_lang` (`id_image`, `id_lang`, `legend`)
  73. VALUES ('".$row[0]."','1','".$row[6]."'); <br />";
  74.  
  75. echo clean($af_product);
  76. echo clean($af_product_lang);
  77. echo clean($af_category_product);
  78. echo clean($af_image);
  79. echo clean($af_image_lang);
  80.  
  81. echo "<br/><br/><br/>";
  82.  
  83. }
  84.  
  85. mysql_free_result($result);
  86. mysql_close($source);
  87.  
  88. ?>
Add Comment
Please, Sign In to add comment