GX-Entwicklung

	public function repair($p_type = 'all', $p_id = 0)

			if(!empty($p_id))

			{

				$t_get_empty_keywords_ids = xtc_db_query("SELECT products_id

													FROM " . TABLE_PRODUCTS_DESCRIPTION . "

													WHERE

													(gm_url_keywords = '' OR LENGTH(gm_url_keywords) >= 255)

													AND products_id = '" . $p_id . "'

													", 'db_link', false);

				$t_get_double_keywords_ids = xtc_db_query("select count(gm_url_keywords) as count from `products_description` group by gm_url_keywords,language_id HAVING count > 1",

				                                          'db_link', false);

			}

			if(empty($p_id) || xtc_db_num_rows($t_get_empty_keywords_ids) > 0 || xtc_db_num_rows($t_get_double_keywords_ids) > 0)

			{

				$t_get_languages_ids = xtc_db_query("SELECT languages_id

				while($t_result_array = xtc_db_fetch_array($t_get_languages_ids))

				{

					$c_languages_id = (int)$t_result_array['languages_id'];

					$t_get_empty_keywords = xtc_db_query("SELECT

					                                     false);

					while($t_product_array = xtc_db_fetch_array($t_get_empty_keywords))

					{

						$c_cleaned_name = $this->clean_keyword($t_product_array['products_name']);

						if(strlen_wrapper($c_cleaned_name . '-' . $t_product_array['products_id']) >= 255)

						{

							$c_cleaned_name = substr_wrapper($c_cleaned_name, 0, 100);

						}

						if($c_cleaned_name != '')

						{

							$t_update = xtc_db_query("UPDATE " . TABLE_PRODUCTS_DESCRIPTION . "

						}

						else

						{

							$t_update = xtc_db_query("UPDATE " . TABLE_PRODUCTS_DESCRIPTION . "

							                         . (int)$t_product_array['products_id'] . "'

						}

					}

					$t_found_double_keywords = true;

					while($t_found_double_keywords)

					{

						$t_products_array = [];

						$t_found          = false;

						$t_get_double_keywords = xtc_db_query("SELECT DISTINCT

						                                      . $this->v_binary_string . "a.gm_url_keywords = "

						                                      . $this->v_binary_string . "b.gm_url_keywords)

						while($t_result_array = xtc_db_fetch_array($t_get_double_keywords))

						{

							$t_found                                          = true;

							$t_products_array[$t_result_array['products_id']] = $t_result_array['gm_url_keywords'];

						}

						if(!$t_found)

						{

							$t_found_double_keywords = false;

						}

						else

						{

							$t_cleared_keywords_array = [];

							foreach($t_products_array AS $t_products_id => $t_gm_url_keywords)

							{

								$t_keys_array = [];

								$t_keys_array = array_keys($t_products_array, $t_gm_url_keywords);

								for($i = 1; $i < count($t_keys_array); $i++)

								{

									if(!in_array($t_gm_url_keywords, $t_cleared_keywords_array))

									{

										$t_new_url_keyword = preg_replace('/(.+?)(-[0-9]+)$/', "$1",

										                                  $t_gm_url_keywords);

										$c_new_url_keyword = ((isset($GLOBALS["___mysqli_ston"])

										                       && is_object($GLOBALS["___mysqli_ston"]))

											? mysqli_real_escape_string($GLOBALS["___mysqli_ston"], $t_new_url_keyword)

											: ((trigger_error("[MySQLConverterToo] Fix the mysql_escape_string() call! This code does not work.",

											                  E_USER_ERROR))

												? ""

												: ""));

										$t_sql_products_id = $t_keys_array[$i];

										if($c_new_url_keyword . '-' . $t_keys_array[$i] == $t_gm_url_keywords)

										{

											$t_sql_products_id = $t_keys_array[0];

										}

										$t_update = xtc_db_query("UPDATE " . TABLE_PRODUCTS_DESCRIPTION . "

										                         . (int)$t_sql_products_id . "'

										                         'db_link', false);

									}

								}

								$t_cleared_keywords_array[] = $t_gm_url_keywords;

							}

		$this->urlKeywordsRepairer->repair('products',$product->getProductId());

	 * @param int $p_id

	 *

	public function repair($type = 'all', $p_id = 0);