Pasted

<?php
    $username = "";
    $password = "";
    $database = "";
    $table_prefix = "wp_";
 
    $blogs_prefixes = array();
 
    $db = new mysqli('localhost', $username, $password, $database);
 
    $query = "SELECT blog_id, domain FROM {$table_prefix}blogs";
 
    $resource = $db->query($query);
 
    if($resource)
    {
        while($row = $resource->fetch_array(MYSQLI_ASSOC))
        {
            $blogs_prefixes[$row['domain']] = "{$table_prefix}{$row['blog_id']}_"; 
        }
 
        $resource->free();
    }
 
    if(!$blogs_prefixes)
    {
        $blogs_prefixes["localhost"] = $table_prefix;
    }
 
    foreach($blogs_prefixes as $blog_domain => $blog_prefix)
    {
        $query = "SELECT notifications, form_id, title FROM {$blog_prefix}rg_form_meta INNER JOIN {$blog_prefix}rg_form ON ({$blog_prefix}rg_form.id = {$blog_prefix}rg_form_meta.form_id) WHERE is_trash = 0";
 
        $resource = $db->query($query);
 
        while($row = $resource->fetch_array(MYSQLI_ASSOC))
        {
            $data = json_decode($row['notifications']);
 
            foreach($data as $notification_key => $notification_data)
            {
                $email = $notification_data->from;
 
                // Do some tests on $email, is it a static email address, "{admin_email}" or "{field_name:field_number}"
 
                echo "{$email}\tin notification '{$notification_data->name}'\tin form {$row['form_id']}\tnamed '{$row['title']}' at site '{$blog_domain}' [{$blog_prefix}]\n";
            }
        }
 
        $resource->free();
    }