You MUST read the Babiato Rules before making your first post otherwise you may get permanent warning points or a permanent Ban.
Our resources on Babiato Forum are CLEAN and SAFE. So you can use them for development and testing purposes. If your are on Windows and have an antivirus that alerts you about a possible infection: Know it's a false positive because all scripts are double checked by our experts. We advise you to add Babiato to trusted sites/sources or disable your antivirus momentarily while downloading a resource. "Enjoy your presence on Babiato"
,
Today, I want to share a little SQL magic trick 
I created with the help of a tool named GPT. This piece of code helps us delete a tricky "TRP license event" from our database, even if our table names have different prefixes. (Yes, it works across multiple websites! 
)
Now, while it might not be the simplest version out there, it does get the job done. 
And hey, perhaps with our shared knowledge, we could find a way to make it even simpler together! 
Maybe create something that checks daily to see if that naughty license reminder has sneaked back in? Like Cron Job 
Hello Babiato familly,
Being quite new to the world of coding and WordPress, I often found myself tangled up in repetitive tasks that, while manageable, took up much more time than they should have.
I stumbled upon ChatGPT, an artificial intelligence by OpenAI, and decided to seek its help in automating this task. The goal was simple: transform that manual SQL query into a scheduled task within WordPress, allowing it to run automatically every day without my intervention.
With the help of ChatGPT, I managed to create a piece of code that I placed in my functions file. Now, the task runs smoothly in the background, eliminating the need for my regular manual intervention. It’s like setting a little robot to work behind the scenes, ensuring I don’t have to worry about those license details anymore. 
function execute_my_query() {
global $wpdb;
// Retrieve table names ending with '_options' from the WordPress database
$tables = $wpdb->get_col("SELECT table_name FROM information_schema.tables WHERE table_name LIKE '%_options' AND table_schema = DATABASE()");
$totalDeleted = 0;
// Loop through the tables and delete records where option_name = 'trp_license_details'
foreach($tables as $table){
$deleted = $wpdb->delete( $table, array( 'option_name' => 'trp_license_details' ) );
$totalDeleted += $deleted;
}
// Logging or other action with $totalDeleted if necessary
error_log("Total rows deleted: $totalDeleted");
}
// Hook our function to the cron event
add_action('trp_license_removal', 'execute_my_query');
// Schedule the event if it is not already scheduled
if (!wp_next_scheduled('trp_license_removal')) {
wp_schedule_event(time(), 'daily', 'trp_license_removal');
}![XKRY0[Ita]](/data/avatars/s/43/43194.jpg?1694818084){kind=avatar}
We get it, advertisements are annoying!
However in order to keep our huge array of resources free of charge we need to generate income from ads so to use the site you will need to turn off your adblocker.
If you'd like to have an ad free experience you can become a Babiato Lover by donating as little as $5 per month. Click on the Donate menu tab for more info.
