adinan-cenci · April 3, 2025 08:38
diff --git a/CDN bullshit.md b/CDN bullshit.md
diff --git a/drush.md b/drush.md
diff --git a/entities_general.md b/entities_general.md
diff --git a/entities_paragraphs.md b/entities_paragraphs.md
diff --git a/find-in-database.php b/find-in-database.php
 <?php

 // TODO: refactor this thing

 // Function to search for a string in all tables and columns
 function search_string_in_database($search_string) {
  // Get the database connection
  $connection = \Drupal\Core\Database\Database::getConnection();

  // Get all tables in the database
  $tables = $connection->query('SHOW TABLES')->fetchCol();

  foreach ($tables as $table_name) {
    // Get all columns for the current table
    $columns = $connection->query("DESCRIBE {$table_name}")->fetchAll();

    foreach ($columns as $column) {
      // Get the column type
      $column_name = $column->Field;
      $column_type = $column->Type;

      // Check if the column type is a string type
      if (!is_text_type($column_type)) {
        continue;
      }

      // Construct and execute the search query
      $query = $connection->select(str_replace('eq_', '', $table_name), 't')
      ->fields('t')
      ->condition($column_name, '%' . $search_string . '%', 'LIKE');

      try {
        $results = $query->execute()->fetchAll();
      }
      catch(\Exception $e) {
        $fuck = $e;
      }

      $index = [];
      if (!empty($results)) {
        // Print the results
        foreach ($results as $result) {
          $key = "$search_string.$table_name.$column_name";

          if (isset($index[$key])) {
            continue;
          }
          $index[$key] = 1;
          // You can customize the output as needed
          echo "$search_string found in $table_name.$column_name";
          echo "\n";
        }
      }
    }
  }
 }

 function search_strings_in_the_database() {
  $search_for = [
    'www.linkedin.com',
    'www.facebook.com',
    'www.twitter.com',
  ];

  foreach ($search_for as $url) {
    search_string_in_database($url);
  }
 }


 function is_text_type(string $column_type) {
  
  if (substr_count($column_type, 'string')) {
    return TRUE;
  }
  if (substr_count($column_type, 'text')) {
    return TRUE;
  }
  if (substr_count($column_type, 'varchar')) {
    return TRUE;
  }
  if (substr_count($column_type, 'longtext')) {
    return TRUE;
  }

  return FALSE;
 }
diff --git a/request.md b/request.md
diff --git a/routing.md b/routing.md
diff --git a/solr.md b/solr.md
diff --git a/theme-preprocess-node.md b/theme-preprocess-node.md
diff --git a/theme-preprocess-view.md b/theme-preprocess-view.md
diff --git a/theme-twig.md b/theme-twig.md
diff --git a/update-hooks.md b/update-hooks.md
diff --git a/user.md b/user.md
	<?php

	// TODO: refactor this thing

	// Function to search for a string in all tables and columns
	function search_string_in_database($search_string) {
	// Get the database connection
	$connection = \Drupal\Core\Database\Database::getConnection();

	// Get all tables in the database
	$tables = $connection->query('SHOW TABLES')->fetchCol();

	foreach ($tables as $table_name) {
	// Get all columns for the current table
	$columns = $connection->query("DESCRIBE {$table_name}")->fetchAll();

	foreach ($columns as $column) {
	// Get the column type
	$column_name = $column->Field;
	$column_type = $column->Type;

	// Check if the column type is a string type
	if (!is_text_type($column_type)) {
	continue;
	}

	// Construct and execute the search query
	$query = $connection->select(str_replace('eq_', '', $table_name), 't')
	->fields('t')
	->condition($column_name, '%' . $search_string . '%', 'LIKE');

	try {
	$results = $query->execute()->fetchAll();
	}
	catch(\Exception $e) {
	$fuck = $e;
	}

	$index = [];
	if (!empty($results)) {
	// Print the results
	foreach ($results as $result) {
	$key = "$search_string.$table_name.$column_name";

	if (isset($index[$key])) {
	continue;
	}
	$index[$key] = 1;
	// You can customize the output as needed
	echo "$search_string found in $table_name.$column_name";
	echo "\n";
	}
	}
	}
	}
	}

	function search_strings_in_the_database() {
	$search_for = [
	'www.linkedin.com',
	'www.facebook.com',
	'www.twitter.com',
	];

	foreach ($search_for as $url) {
	search_string_in_database($url);
	}
	}


	function is_text_type(string $column_type) {

	if (substr_count($column_type, 'string')) {
	return TRUE;
	}
	if (substr_count($column_type, 'text')) {
	return TRUE;
	}
	if (substr_count($column_type, 'varchar')) {
	return TRUE;
	}
	if (substr_count($column_type, 'longtext')) {
	return TRUE;
	}

	return FALSE;
	}