PageRenderTime 54ms CodeModel.GetById 22ms RepoModel.GetById 1ms app.codeStats 0ms

/wp-content/plugins/wp-shopping-cart/updates/update-to-3.6.4.php

https://github.com/alx/barceloneta
PHP | 226 lines | 189 code | 35 blank | 2 comment | 34 complexity | d2f3312dea0375d0b6fe0d3fac78d187 MD5 | raw file
    

  1. <?php
    2. 

  2. //Add table logged_subscription
    3. 

  3. if($wpdb->get_var("SHOW TABLES LIKE '".$wpdb->prefix."cart_item_extras'") != ($wpdb->prefix."cart_item_extras")) {
    4. 

  4.    $wpsc_cart_item_extras = "CREATE TABLE `".$wpdb->prefix."cart_item_extras` (
    5. 

  5.   `id` int(11) NOT NULL auto_increment,
    6. 

  6.   `cart_id` int(11) NOT NULL,
    7. 

  7.   `extra_id` int(11) NOT NULL,
    8. 

  8.   PRIMARY KEY  (`id`)
    9. 

  9. ) ENGINE=MyISAM;";
    10. 

  10.   $wpdb->query($wpsc_cart_item_extras);
    11. 

  11.   }
    12. 

  12. 

  13. 

  14. if($wpdb->get_var("SHOW TABLES LIKE '".$wpdb->prefix."extras_values'") != ($wpdb->prefix."extras_values")) {
    15. 

  15.    $wpsc_extras_values= "CREATE TABLE `".$wpdb->prefix."extras_values` (
    16. 

  16.   `id` int(11) NOT NULL auto_increment,
    17. 

  17.   `name` varchar(128) NOT NULL,
    18. 

  18.   `extras_id` int(11) NOT NULL,
    19. 

  19.   PRIMARY KEY  (`id`)
    20. 

  20. ) ENGINE=MyISAM;";
    21. 

  21.   $wpdb->query($wpsc_extras_values);
    22. 

  22.   }
    23. 

  23. 

  24. 

  25. if($wpdb->get_var("SHOW TABLES LIKE '".$wpdb->prefix."item_category_associations'") != ($wpdb->prefix."item_category_associations")) {
    26. 

  26.    $wpsc_extras_values= "CREATE TABLE `".$wpdb->prefix."item_category_associations` (
    27. 

  27.   `id` bigint(20) unsigned NOT NULL auto_increment,
    28. 

  28.   `product_id` bigint(20) unsigned NOT NULL default '0',
    29. 

  29.   `category_id` bigint(20) unsigned NOT NULL default '0',
    30. 

  30.   PRIMARY KEY  (`id`),
    31. 

  31.   UNIQUE KEY `product_id` (`product_id`,`category_id`)
    32. 

  32. ) ENGINE=MyISAM;";
    33. 

  33.   $wpdb->query($wpsc_extras_values);
    34. 

  34.   }
    35. 

  35. 

  36. if($wpdb->get_var("SHOW TABLES LIKE '".$wpdb->prefix."extras_values_associations'") != ($wpdb->prefix."extras_values_associations")) {
    37. 

  37.    $wpsc_extras_values= "CREATE TABLE `".$wpdb->prefix."extras_values_associations` (
    38. 

  38.   `id` int(11) NOT NULL auto_increment,
    39. 

  39.   `product_id` int(11) NOT NULL,
    40. 

  40.   `value_id` int(11) NOT NULL,
    41. 

  41.   `price` varchar(20) NOT NULL,
    42. 

  42.   `visible` varchar(1) NOT NULL,
    43. 

  43.   `extras_id` int(11) NOT NULL,
    44. 

  44.   PRIMARY KEY  (`id`)
    45. 

  45. ) ENGINE=MyISAM;";
    46. 

  46.   $wpdb->query($wpsc_extras_values);
    47. 

  47.   }
    48. 

  48. 

  49. if($wpdb->get_var("SHOW TABLES LIKE '".$wpdb->prefix."product_extra'") != ($wpdb->prefix."product_extra")) {
    50. 

  50.    $wpsc_extras_values= "CREATE TABLE `".$wpdb->prefix."product_extra` (
    51. 

  51.   `id` int(11) NOT NULL auto_increment,
    52. 

  52.   `name` varchar(128) NOT NULL,
    53. 

  53.   PRIMARY KEY  (`id`)
    54. 

  54. ) ENGINE=MyISAM;";
    55. 

  55.   $wpdb->query($wpsc_extras_values);
    56. 

  56.   }
    57. 

  57.   
    58. 

  58. 

  59. if($wpdb->get_results("SHOW FULL COLUMNS FROM `".$wpdb->prefix."cart_item_variations` LIKE 'venue_id';",ARRAY_A)) {
    60. 

  60. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."cart_item_variations` CHANGE `venue_id` `value_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' ");
    61. 

  61. }
    62. 

  62. 

  63. 

  64. if(!$wpdb->get_results("SHOW FULL COLUMNS FROM `".$wpdb->prefix."purchase_logs` LIKE 'find_us';",ARRAY_A)) {
    65. 

  65. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."purchase_logs` ADD `find_us` varchar(255) NOT NULL");
    66. 

  66. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."purchase_logs` ADD `engravetext` varchar(255) default NULL");
    67. 

  67. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."purchase_logs` ADD `closest_store` varchar(255) default NULL");
    68. 

  68. }
    69. 

  69. 

  70. 

  71. if(!$wpdb->get_results("SHOW FULL COLUMNS FROM `".$wpdb->prefix."download_status` LIKE 'uniqueid';",ARRAY_A)) {
    72. 

  72. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."download_status` ADD `uniqueid` VARCHAR( 64 ) NULL AFTER `purchid`;");
    73. 

  73. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."download_status` ADD UNIQUE (`uniqueid`);");
    74. 

  74. }
    75. 

  75. 

  76. 

  77. if(!$wpdb->get_results("SHOW FULL COLUMNS FROM `".$wpdb->prefix."region_tax` LIKE 'code';",ARRAY_A)) {
    78. 

  78. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."region_tax` ADD `code` char(2) NOT NULL default '' AFTER `name`;");    
    79. 

  79. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'AL' WHERE `name` IN('Alabama')LIMIT 1 ;");
    80. 

  80. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'AK' WHERE `name` IN('Alaska') LIMIT 1 ;");
    81. 

  81. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'AZ' WHERE `name` IN('Arizona') LIMIT 1 ;");
    82. 

  82. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'AR' WHERE `name` IN('Arkansas') LIMIT 1 ;");
    83. 

  83. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'CA' WHERE `name` IN('California') LIMIT 1 ;");
    84. 

  84. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'CO' WHERE `name` IN('Colorado') LIMIT 1 ;");
    85. 

  85. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'CT' WHERE `name` IN('Connecticut') LIMIT 1 ;");
    86. 

  86. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'DE' WHERE `name` IN('Delaware') LIMIT 1 ;");
    87. 

  87. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'FL' WHERE `name` IN('Florida') LIMIT 1 ;");
    88. 

  88. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'GA' WHERE `name` IN('Georgia')  LIMIT 1 ;");
    89. 

  89. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'HI' WHERE `name` IN('Hawaii')  LIMIT 1 ;");
    90. 

  90. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'ID' WHERE`name` IN('Idaho')  LIMIT 1 ;");
    91. 

  91. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'IL' WHERE `name` IN('Illinois')  LIMIT 1 ;");
    92. 

  92. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'IN' WHERE `name` IN('Indiana')  LIMIT 1 ;");
    93. 

  93. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'IA' WHERE `name` IN('Iowa')  LIMIT 1 ;");
    94. 

  94. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'KS' WHERE `name` IN('Kansas')  LIMIT 1 ;");
    95. 

  95. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'KY' WHERE `name` IN('Kentucky') LIMIT 1 ;");
    96. 

  96. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'LA' WHERE `name` IN('Louisiana') LIMIT 1 ;");
    97. 

  97. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'ME' WHERE `name` IN('Maine') LIMIT 1 ;");
    98. 

  98. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MD' WHERE `name` IN('Maryland') LIMIT 1 ;");
    99. 

  99. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MA' WHERE `name` IN('Massachusetts') LIMIT 1 ;");
    100. 

  100. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MI' WHERE `name` IN('Michigan') LIMIT 1 ;");
    101. 

  101. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MN' WHERE `name` IN('Minnesota') LIMIT 1 ;");
    102. 

  102. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MS' WHERE `name` IN('Mississippi') LIMIT 1 ;");
    103. 

  103. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MO' WHERE `name` IN('Missouri') LIMIT 1 ;");
    104. 

  104. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MT' WHERE `name` IN('Montana') LIMIT 1 ;");
    105. 

  105. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NE' WHERE `name` IN('Nebraska') LIMIT 1 ;");
    106. 

  106. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NV' WHERE `name` IN('Nevada') LIMIT 1 ;");
    107. 

  107. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NH' WHERE `name` IN('New Hampshire') LIMIT 1 ;");
    108. 

  108. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NJ' WHERE `name` IN('New Jersey') LIMIT 1 ;");
    109. 

  109. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NM' WHERE `name` IN('New Mexico') LIMIT 1 ;");
    110. 

  110. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NY' WHERE `name` IN('New York') LIMIT 1 ;");
    111. 

  111. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NC' WHERE `name` IN('North Carolina') LIMIT 1 ;");
    112. 

  112. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'ND' WHERE `name` IN('North Dakota') LIMIT 1 ;");
    113. 

  113. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'OH' WHERE `name` IN('Ohio') LIMIT 1 ;");
    114. 

  114. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'OK' WHERE `name` IN('Oklahoma') LIMIT 1 ;");
    115. 

  115. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'OR' WHERE `name` IN('Oregon') LIMIT 1 ;");
    116. 

  116. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'PA' WHERE `name` IN('Pennsylvania') LIMIT 1 ;");
    117. 

  117. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'RI' WHERE `name` IN('Rhode Island') LIMIT 1 ;");
    118. 

  118. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'SC' WHERE `name` IN('South Carolina') LIMIT 1 ;");
    119. 

  119. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'SD' WHERE `name` IN('South Dakota') LIMIT 1 ;");
    120. 

  120. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'TN' WHERE `name` IN('Tennessee') LIMIT 1 ;");
    121. 

  121. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'TX' WHERE `name` IN('Texas') LIMIT 1 ;");
    122. 

  122. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'UT' WHERE `name` IN('Utah') LIMIT 1 ;");
    123. 

  123. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'VT' WHERE `name` IN('Vermont') LIMIT 1 ;");
    124. 

  124. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'VA' WHERE `name` IN('Virginia') LIMIT 1 ;");
    125. 

  125. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'WA' WHERE `name` IN('Washington') LIMIT 1 ;");
    126. 

  126. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'DC' WHERE `name` IN('Washington DC') LIMIT 1 ;");
    127. 

  127. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'WV' WHERE `name` IN('West Virginia') LIMIT 1 ;");
    128. 

  128. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'WI' WHERE `name` IN('Wisconsin') LIMIT 1 ;");
    129. 

  129. 	$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'WY' WHERE `name` IN('Wyoming') LIMIT 1 ;");    
    130. 

  130. }
    131. 

  131. 

  132. 

  133. $coldata  = $wpdb->get_results("SHOW FULL COLUMNS FROM `".$wpdb->prefix."purchase_logs` LIKE 'totalprice'",ARRAY_A);
    134. 

  134. if($coldata[0]['Type'] != "varchar(128)")	{
    135. 

  135. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."purchase_logs` CHANGE `totalprice` `totalprice` VARCHAR( 128 ) DEFAULT '0' NOT NULL");
    136. 

  136. 	}
    137. 

  137. $coldata  = $wpdb->get_results("SHOW FULL COLUMNS FROM `".$wpdb->prefix."purchase_logs` LIKE 'base_shipping'",ARRAY_A);
    138. 

  138. if($coldata[0]['Type'] != "varchar(128)")	{
    139. 

  139. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."purchase_logs` CHANGE `base_shipping` `base_shipping` VARCHAR( 128 ) DEFAULT '0' NOT NULL");
    140. 

  140. 	}
    141. 

  141. 		
    142. 

  142. if(!$wpdb->get_results("SHOW FULL COLUMNS FROM `".$wpdb->prefix."product_list` LIKE 'no_shipping';",ARRAY_A)) {
    143. 

  143. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."product_list` ADD `no_shipping` varchar(1) NOT NULL DEFAULT '0' AFTER `donation`;");
    144. 

  144. }
    145. 

  145. 

  146. if(!$wpdb->get_results("SHOW FULL COLUMNS FROM `".$wpdb->prefix."wpsc_coupon_codes` LIKE 'every_product';",ARRAY_A)) {
    147. 

  147. 	$wpdb->query("ALTER TABLE `".$wpdb->prefix."wpsc_coupon_codes` ADD `every_product` varchar(255) NOT NULL AFTER `active`");
    148. 

  148. }
    149. 

  149. 

  150. 

  151.   
    152. 

  152.   
    153. 

  153. if($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->prefix}wpsc_categorisation_groups'") != ($wpdb->prefix."wpsc_categorisation_groups")) {
    154. 

  154.    $wpsc_categorisation_groups= "CREATE TABLE `{$wpdb->prefix}wpsc_categorisation_groups` (
    155. 

  155.   `id` bigint(20) unsigned NOT NULL auto_increment,
    156. 

  156.   `name` varchar(255) NOT NULL,
    157. 

  157.   `description` text NOT NULL,
    158. 

  158.   `active` varchar(1) NOT NULL default '1',
    159. 

  159.   `default` varchar(1) NOT NULL default '0',
    160. 

  160.   PRIMARY KEY  (`id`),
    161. 

  161.   KEY `group_name` (`name`)
    162. 

  162. ) ENGINE=MyISAM ; 
    163. 

  163. ";
    164. 

  164.   $wpdb->query($wpsc_categorisation_groups);
    165. 

  165.   
    166. 

  166.   $wpdb->query("INSERT INTO `{$wpdb->prefix}wpsc_categorisation_groups` (`id`, `name`, `description`, `active`, `default`) VALUES (1, 'Categories', 'Product Categories', '1', '1')");
    167. 

  167.   $wpdb->query("INSERT INTO `{$wpdb->prefix}wpsc_categorisation_groups` (`id`, `name`, `description`, `active`, `default`) VALUES (2, 'Brands', 'Product Brands', '1', '0')");
    168. 

  168. }
    169. 

  169. 

  170. if($wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}wpsc_categorisation_groups`") < 1) {
    171. 

  171.   $wpdb->query("INSERT INTO `{$wpdb->prefix}wpsc_categorisation_groups` (`id`, `name`, `description`, `active`, `default`) VALUES (1, 'Categories', 'Product Categories', '1', '1')");
    172. 

  172.   $wpdb->query("INSERT INTO `{$wpdb->prefix}wpsc_categorisation_groups` (`id`, `name`, `description`, `active`, `default`) VALUES (2, 'Brands', 'Product Brands', '1', '0')");
    173. 

  173. }
    174. 

  174. 

  175. 

  176. if(!$wpdb->get_results("SHOW FULL COLUMNS FROM `{$wpdb->prefix}product_categories` LIKE 'group_id';",ARRAY_A)) {
    177. 

  177. 	$wpdb->query("ALTER TABLE `{$wpdb->prefix}product_categories` ADD `group_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `id`");
    178. 

  178. 	$wpdb->query("ALTER TABLE `{$wpdb->prefix}product_categories` ADD INDEX ( `group_id` ) ;");
    179. 

  179. }
    180. 

  180. 

  181. 

  182. $brand_group = $wpdb->get_row("SELECT * FROM `{$wpdb->prefix}wpsc_categorisation_groups` WHERE `name` IN ( 'Brands' ) ",ARRAY_A);
    183. 

  183. if($brand_group == null) {
    184. 

  184. 	$wpdb->get_row("INSERT INTO `{$wpdb->prefix}wpsc_categorisation_groups` ( `name`, `description`, `active`, `default`) VALUES ( 'Brands', 'Product Brands', '1', '0');", ARRAY_A);
    185. 

  185. 	$brand_group = $wpdb->get_row("SELECT * FROM `{$wpdb->prefix}wpsc_categorisation_groups` WHERE `name` IN ( 'Brands' ) ",ARRAY_A);
    186. 

  186. }
    187. 

  187. 	
    188. 

  188. $converted_brand_count = $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}product_categories` WHERE `group_id` IN({$brand_group['id']}) AND `active` IN('1') ");
    189. 

  189. if($converted_brand_count <= 0) {
    190. 

  190. 	$brands = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}product_brands` ",ARRAY_A);
    191. 

  191. 	if(count($brands) > 0 ) {
    192. 

  192. 		foreach($brands as $brand) {
    193. 

  193. 			
    194. 

  194. 			$tidied_name = trim($brand['name']);
    195. 

  195. 			$tidied_name = strtolower($tidied_name);
    196. 

  196. 			$url_name = preg_replace(array("/(\s)+/","/[^\w-]+/"), array("-", ''), $tidied_name);
    197. 

  197. 			if($url_name != $category_data['nice-name']) {
    198. 

  198. 				$similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`nice-name`, '$url_name', '')) AS `max_number` FROM `".$wpdb->prefix."product_categories` WHERE `nice-name` REGEXP '^($url_name){1}(0-9)*$' AND `id` NOT IN ('".(int)$category_data['id']."') ",ARRAY_A);
    199. 

  199. 				//exit("<pre>".print_r($similar_names,true)."</pre>");
    200. 

  200. 				$extension_number = '';
    201. 

  201. 				if($similar_names['count'] > 0) {
    202. 

  202. 					$extension_number = (int)$similar_names['max_number']+1;
    203. 

  203. 				}
    204. 

  204. 				$url_name .= $extension_number;   
    205. 

  205. 			}
    206. 

  206. 			
    207. 

  207. 			$wpdb->query( "INSERT INTO `{$wpdb->prefix}product_categories` ( `group_id`, `name`, `nice-name`, `description`, `image`, `fee`, `active`, `category_parent`, `order`) VALUES ( {$brand_group['id']}, '{$brand['name']}', '{$url_name}', '{$brand['description']}', '', '0', '1', 0, 0)");
    208. 

  208. 		}  
    209. 

  209. 	}
    210. 

  210. }
    211. 

  211. 

  212. 

  213. if(!$wpdb->get_results("SHOW FULL COLUMNS FROM `{$wpdb->prefix}wpsc_productmeta` LIKE 'custom';",ARRAY_A)) {
    214. 

  214. 	$wpdb->query("ALTER TABLE `{$wpdb->prefix}wpsc_productmeta` ADD `custom` VARCHAR( 1 ) NOT NULL DEFAULT '0' AFTER `meta_value`;");
    215. 

  215. 	$wpdb->query("ALTER TABLE `{$wpdb->prefix}wpsc_productmeta` ADD INDEX ( `custom` ) ;");
    216. 

  216. }
    217. 

  217. 

  218. if(!$wpdb->get_results("SHOW FULL COLUMNS FROM `{$wpdb->prefix}download_status` LIKE 'ip_number';",ARRAY_A)) {
    219. 

  219. 	$wpdb->query("ALTER TABLE `{$wpdb->prefix}download_status` ADD `ip_number` varchar(255) NOT NULL AFTER `downloads`;");
    220. 

  220. }
    221. 

  221. 

  222. if(!$wpdb->get_results("SHOW FULL COLUMNS FROM `{$wpdb->prefix}product_list` LIKE 'weight';",ARRAY_A)) {
    223. 

  223. 	$wpdb->query("ALTER TABLE `{$wpdb->prefix}product_list` ADD `weight` INT( 11 ) NOT NULL DEFAULT 0 AFTER `price`;");
    224. 

  224. 	$wpdb->query("ALTER TABLE `{$wpdb->prefix}product_list` ADD `weight_unit` VARCHAR( 10 ) NOT NULL AFTER `weight`;");
    225. 

  225. }
    226. 

  226. ?>
    227.