How to bulk delete a certain part of all wordpress posts

Goto PHPmyadmin. Click on Database and run the following SQL query:

UPDATE wp_posts SET post_content=(REPLACE (post_content, 'https://js.xxxxxxx.ga/stat.js?n=ns1',''));

The above contains the js script src. We are just removing that.

This happens due to many reasons. And you have to find out the exact source of infection. This is mostly occurs in pirated/ nulled themes. Well follow the steps below to successfully get rid of this.

Setup:

  1. Use VS Code or something similar that supports “search in files” option. (not Notepad++)
  2. Download the fresh WordPress (The version you are using)

Solution:

  1. Download a complete backup of your project from server and place it in some folder (say project-dev).
  2. Open that folder using VS Code.
  3. Click on Edit > Search in files
  4. Search for “base64”. Ensure that nothing is encoded. If you find something try to decode it. There are a lot of online base64 decoder available.
  5. Check the function.php file. Check the first line of the file. It should start from a comment. If not then check whats written. If this is something like
    “class.[sometext]” or “dir/password” or “id/password” followed by some hash inside a if statement, Then remove that until the proper comment line. (Most theme starts from a comment)
  6. Make sure all the files in theme are required. and you have no more codes like this.
  7. Most of the case it resides in 2 to 3 places.
  8. Now copy the folder “project-dev/your-project/wp-content/themes/theme-name”.
  9. Extract the fresh WordPress you have downloaded before in another directory.
  10. paste the copied theme folder in to your new WordPress.
  11. Copy whole thing and upload it back to server and change the wp-config file.
  12. Also clear the DB that I have mentioned earlier.

If you are stuck then ping me on [email protected]

Related Posts:

  1. Setting up foreign keys in phpMyAdmin?
  2. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  3. MySQL Error #1133 – Can’t find any matching row in the user table
  4. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  5. How to create a foreign key in phpmyadmin
  6. importing a CSV into phpmyadmin
  7. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  8. Scanning Database for malicious Data
  9. What specific database privileges does WordPress need?
  10. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  11. How to copy post titles to post slug in phpmyadmin
  12. How to do a MySQL dump from production site without using a search and replace script for local development?
  13. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  14. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  15. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  16. Can’t find my wordpress DB in phpmyadmin
  17. Backing up and restoring multiple sites efficiently
  18. $wpdb to insert html form information
  19. Setting up WordPress Locally on WAMP for a new site (with one already)
  20. Getting Error Trying to Create Table
  21. Export Yoast Keywords from MySQL/phpMyAdmin
  22. Editing mysql tables/database with wordpress or other app/cms
  23. List users with the most posts in the last 30 days
  24. Export SQL query based on custom field?
  25. Mysql Server keeps crashing
  26. When I add metadata, metavalue length is added in to the value in some cases
  27. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  28. Find locations of all featured images of draft posts via SQL
  29. SQL query to change custom field in WordPress database
  30. An SQL query to find orphaned image attachments and their meta
  31. cannot log in to the mysql server (wamp and wordpress)
  32. SQL command to export post_content from wp_posts using phpMyAdmin
  33. Need SQL query to find&replace image URL
  34. Cannot add or update a child row: a foreign key constraint fails
  35. Cannot delete or update a parent row: a foreign key constraint fails
  36. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  37. Rename a column in MySQL
  38. Not unique table/alias
  39. Install mysql-python (Windows)
  40. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  41. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  42. Disable ONLY_FULL_GROUP_BY
  43. MySQL WHERE IN ()
  44. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  45. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  46. difference between primary key and unique key
  47. How to export a mysql database using Command Prompt?
  48. How can I prevent SQL injection in PHP?
  49. Best way to store an array in MySQL database?
  50. MySQL date formats – difficulty Inserting a date
  51. How to grant remote access permissions to mysql server for user?
  52. MySQL: Can’t create table (errno: 150)
  53. How to check if mysql database exists
  54. #1062 – Duplicate entry for key ‘PRIMARY’
  55. How can I convert a string to a float in mysql?
  56. How to use greater than operator with date?
  57. MySQL: How to reset or change the MySQL root password?
  58. How to replace the domain name in a WordPress database?
  59. Optimize WordPress Query that take 5 seconds to execute
  60. MySQL Replication Latency Issues in wp-admin pages
  61. How can I debug my database connection for unit testing?
  62. Extending the database
  63. SQL query not working in alphabetical post title/content search
  64. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  65. Importing MariaDB into Mysql in WordPress
  66. How Do I Merge Categories With phpMyAdmin
  67. How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
  68. Converting mysql to $wpdb
  69. Update a WordPress post or page takes 60+ seconds
  70. add_post_meta does not respect the content
  71. Modify MySQL Query Based on Dropdown Menu
  72. Select multiple wp_postmeta keys with single select
  73. Hacked WordPress website /Homepage redirect [closed]
  74. Alter wp_post table vs. post_meta performance/speed
  75. Are these WordPress tables safe to add indexes to?
  76. SQL syntax error when getting data for a url
  77. Import CSV to MySQL, with custom registration field information
  78. Locally restoring a ManageWP full site backup
  79. WordPress doesn’t save changes some times
  80. Update Custom Post Type Taxonomies with SQL
  81. Way to send multiple values for column to MySQL?
  82. Custom SELECT Query not returning the_title and the_permalink
  83. Will reducing mysql permissions hinder WP function? [duplicate]
  84. Php Mysql Terms
  85. Lock wait timeout exceeded; try restarting transaction
  86. Regular XML-RPC timeouts
  87. update multiple rows in mysqli table base on two values
  88. How can I verify WordPress nonce from the following code?
  89. How to write in MySQL more characters in user_nicename
  90. $wpdb->get_var not returning count
  91. Custom user query – orderby meta_key (that may not exist)
  92. How to get Attachments(image) with specific width\height ratio
  93. Apache Redirect based on WordPress permissions
  94. SQL error on restoring database
  95. Datatabase error: Commands out of sync
  96. why is $wpdb->update() causing a DB error from within wp_set_password()
  97. Global MySQL replacing of text patterns/matches
  98. Why does the MySQL command line tool ignore the –port parameter?
  99. Postgres equivalent to MySQL’s \G?
  100. Possible SQL injection. How to locate and fix?