Find and Delete SQL Server database Wordpress

[jounin89]

hello i have a wordpress and a dooplay theme.. and i want to delete all my old link
openload.co and verystream.com on my wordpress site database or .sql anybody knows to do that and explain what is right method
not on manual thing.. just the code or command may be plugin..

 

[xd12345]

ask the owner his insight to this

since the embed link are formatted using json u should look into how to update them using JSON_SET() in mysql

 

[darkestblue]

ask the owner his insight to this

since the embed link are formatted using json u should look into how to update them using JSON_SET() in mysql

wrong, data is not saved as json format

 

[xd12345]

i just check its not json, it similar but its not.

@jounin89​

i suggest u try to use wp_query to get ids of all post that have openload
then use those post ids to remove openload and use wp_update_post()
the data is store in meta_input -> "repeatable_fields"
you can automate it using cron.

 

[darkestblue]

this script checks your movies-posts and remove player links with openload.co or verystream.com
make a backup and try it in a test enviroment before. work at my tests
i addet this script at wp-content\themes\dooplay\header.php and open the Main page, but this is a very dirty way to run the script, maybe you php config disallow this because of long runtime or memory use

echo "START MOVIE EDIT<br>";
$loop = new WP_Query( $array('post_type' => 'movies' ); );

while ( $loop->have_posts() ) : $loop->the_post();

    global $post;
    $repeatable_fields = get_post_meta( $post->ID, 'repeatable_fields' );

    $data_array_tmp = array();        
    $found_bad_url = false;
    foreach ( $repeatable_fields[0]  as $stream_link_object) {
                
        if(strpos ( $stream_link_object["url"] , "openload.co" ) !== false || strpos (  $stream_link_object["url"] , "verystream.com") !== false){
            $found_bad_url = true;
        }else{
            array_push ( $data_array_tmp , $stream_link_object);
        }
        
        if(    $found_bad_url){
            update_post_meta($post->ID, 'repeatable_fields',$data_array_tmp );
        }
    }
endwhile;
echo "FINISH MOVIE EDIT<br>";
exit

Post automatically merged: Apr 10, 2021

damn, did not test las tchanged, current version :

echo "START MOVIE EDIT<br>";
$loop = new WP_Query( array('post_type' => 'movies' ) );

while ( $loop->have_posts() ) : $loop->the_post();

    global $post;
    $repeatable_fields = get_post_meta( $post->ID, 'repeatable_fields' );

    $data_array_tmp = array();       
    $found_bad_url = false;
    foreach ( $repeatable_fields[0]  as $stream_link_object) {
                
        if(strpos ( $stream_link_object["url"] , "openload.co" ) !== false || strpos (  $stream_link_object["url"] , "verystream.com") !== false){
            $found_bad_url = true;
        }else{
            array_push ( $data_array_tmp , $stream_link_object);
        }
        
        if(    $found_bad_url){
            update_post_meta($post->ID, 'repeatable_fields',$data_array_tmp );
        }
    }
endwhile;
echo "FINISH MOVIE EDIT<br>";
exit

Post automatically merged: Apr 10, 2021

and again, dont drink and code

echo "START MOVIE EDIT<br>";
$loop = new WP_Query( array('post_type' => 'movies' ) );

while ( $loop->have_posts() ) : $loop->the_post();

    global $post;
    $repeatable_fields = get_post_meta( $post->ID, 'repeatable_fields' );

    $data_array_tmp = array();       
    $found_bad_url = false;
    foreach ( $repeatable_fields[0]  as $stream_link_object) {
                
        if(strpos ( $stream_link_object["url"] , "openload.co" ) !== false || strpos (  $stream_link_object["url"] , "verystream.com") !== false){
            $found_bad_url = true;
        }else{
            array_push ( $data_array_tmp , $stream_link_object);
        }
    }
    
    if(    $found_bad_url){
        update_post_meta($post->ID, 'repeatable_fields',$data_array_tmp );
    }
endwhile;
echo "FINISH MOVIE EDIT<br>";
exit

 

[jounin89]

@ dasrkest blue your code is not working

 

[darkestblue]

without more infos i cant help you, at my test enviroment its work ...

 

[jounin89]

try to install a nulled theme and test it to a test site

 

[darkestblue]

hey dude, dont explain me how to do the job.

if you are unable to do the basics i cant and will help you.
without explaining what you try, which error you have and things like this you will not solve your problem
have fun with manuel deleting the entrys

 

[jounin89]

i try xd12345 suggestion.. and for darkestblue thank you for comment