Drupal 7 port (img_assist)

Media module comes with a media browser and filter, and is being used at drupal gardens to do the job on Drupal 7.

Subscribe
#2. One option might be to convert the IMG assist macros to straight HTML in the db directly.

True. Especially for people wishing to upgrade a site from D6 to D7.

subscribe

subscribe

Interested in this as well. Regardless, an upgrade path to Drupal 7 is needed.

BTW, is there any inline image module in Drupal 7 core? Or which inline modules have #D7CX?

loyukfai,
No, not in core, but see my post at #1 above.
Media module has made the pledge, and in fact already works.

Thanks!

Now, we only need something to convert Image Assist tags to something compatible with the Media module.. . (btw, does it insert html tags or something else?)

Definitely something else ;-)

[[{"type":"media","view_mode":"media_preview","fid":"36","attributes":{"alt":"","class":"media-image","title":"","typeof":"foaf:Image","wysiwyg":"1"}}]]

You have to turn on a filter in your chosen Text format.

Converts Media tags to Markup
This filter will convert [[{type:media... ]] tags into markup

or there is way to convert all filter tag to html tag?
cause i used filter tag for all my image

I agree it's hard to replace img_assist. I've found it quite useful in its simplicity and there doesn't seem to be a good replacement yet. I've got Imagefield Assist (a fork of img_assist) working on a newer site - it works fairly closely but not exactly. It references the fid instead of the nid so it's not automatically associated with a particular node. It can, however, work with a particular node type with imagefield on it.

subscribe

It looks like the Media module requires a WYSIWYG editor. I prefer to use Textile as a lightweight markup system using standard plain text fields.

So a port of img_assist would be nice, unless there's a way to get Media to work with plain textareas?

I made a PHP script to convert Image Assist Tag into HTML tags :

$server = "localhost";
$login = "root";
$password = "XXXXXXXXXX";
$database = "drupal7";

///////////////////////////////////////////////////////////////////////////////////////////////////

$link = mysql_connect($server, $login, $password) or die("Connect error : " . mysql_error());
echo "Connect OK\n";

$db_selected = mysql_select_db($database, $link);
if (!$db_selected)
   die ('Select DB error : ' . mysql_error());

$query = "SELECT * FROM field_data_body WHERE body_value like '%[img_assist%'";
$result = mysql_query($query);

if (!$result) {
    $message  = 'Query error : ' . mysql_error() . "\n";
    $message .= 'Query : ' . $query;
    die($message);
}

$count=0;
while ($row = mysql_fetch_assoc($result)) 
{
	$tmp = $row['body_value'];
	$count++;
	echo "\n###############################################################################\n";
	echo "Entity ID: ".$row['entity_id'];
    //echo $tmp;    
	//echo "\n###############################################################################\n";
	
	$start = strpos($tmp, "[img_assist");
	
	while ($start = strpos($tmp, "[img_assist") !== FALSE)
	{
		$end = strpos($tmp, "]", $start);
		$img = substr($tmp, $start+12, $end-$start-12);
		
		echo "Img: $img \n";
		
		list($nid, $title, $desc, $link_img, $align, $width, $height) = explode("|", $img);
		
		$nid = substr($nid, strpos($nid, "=")+1);
		$title = substr($title, strpos($title, "=")+1);
		$desc = substr($desc, strpos($desc, "=")+1);
		$link_img = substr($link_img, strpos($link_img, "=")+1);
		$align = substr($align, strpos($align, "=")+1);
		$width = substr($width, strpos($width, "=")+1);
		$height = substr($height, strpos($height, "=")+1);
		
		echo "NID: $nid \n";
		
		$query_image = "SELECT * FROM image WHERE nid=".$nid;
		$result_image = mysql_query($query_image);
		
		$row_image = mysql_fetch_assoc($result_image);
		$fid = $row_image['fid'];
		
		echo "FID: $fid \n";
		
		$query_file = "SELECT * FROM files WHERE fid=".$fid;
		$result_file = mysql_query($query_file);
		
		$row_file = mysql_fetch_assoc($result_file);
		$img_path = $row_file['filepath'];
		
		if ($img_path[0] != '/')  
			$img_path = '/' . $img_path;
		
		echo "Src: $img_path \n";
		
		$buffer = substr($tmp, 0, $start);
		
		$buffer .= "<img alt=\"$desc\" src=\"$img_path\" style=\"width: ".$width."px; height: ".$height."px;\">";
		
		$buffer .= substr($tmp, $end+1);
		
		//echo "Buffer: $buffer \n";
		
		$tmp = $buffer;
		
		mysql_free_result($result_image);
		//break; // Test
	} // End : while ($start = strpos($tmp, "[img_assist"))	
	
	$update_query = "UPDATE field_data_body SET body_value = '".addslashes($tmp)."' WHERE entity_id = ".$row['entity_id'];
	$res = mysql_query($update_query);
	
	if (!$res) {
		$message  = 'Query error : ' . mysql_error() . "\n";
		$message .= 'Query : ' . $update_query;
		die($message);
	}
	
	//break; // Test
}// End : while ($row = mysql_fetch_assoc($result)) 

mysql_free_result($result);

mysql_close($link);
echo "\nEnd ($count entities modified)\n\n";

This script must be run on D7 database (after the update from D6 to D7).

so the script need to be run on D7 database or D6?
meaning, it must be upgrade to D7 first, then run the script?

The script must be run on D7 database, so you must upgrade to D7 first.

I tried running this script after upgrading to Drupal 7, but img_assist tags still appear in the nodes. (Perhaps the .php file needs to be ignored in .htaccess or something?)

Also, I was still running with an alpha release of image, and hadn't enabled views when I ran the script, but I kinda expected the operation to happen at a database level to convert the tags to html.

Sorry, but I'm a just an average Drupal user, and not programmer; but please will you stipulate dependency modules or any other information you can?

At this point I'm considering trying to migrate from the image module to imagefield on Drupal 6.20, and then upgrading to D7. At that point I imagine to try and work out a database update script to replace img_assist inline images with HTML.

Don't really know where to start though. It's one thing being caught out with the image module, but then I'm doubly confounded with img_assist.

Any advice or pointers gratefully appreciated, as I am really confused.

Have you modified these lines with your server's information ?

$server = "localhost";
$login = "root";
$password = "XXXXXXXXXX";
$database = "drupal7";

subscribe

subscribe

subscribing

Sadly, Media module falls down in many respects and is unusable in the way that it needs to be most usable: for users who don't have coding skills and rely on the WYSIWYG tools to create content and post images. Image Assist is the only module out there I've been able to find that:

(1) manages a library of images
(2) allows users to apply additional information to image (captions, photo credits)
(3) allows users to select image size presets
(4) allows users to place image (float left, float right, etc.)

And does all of this from a single interface within a WYSIWYG tool.

(To be fair, I think the image upload module can also do most of this in D6)

Media doesn't offer the image placement, captions or other additional information, or provide any more than the hard coded image styles available in the default installation.

These seem like really basic needs for content publishing. All of the users for whom I manage Drupal websites need to be able to do these tasks when publishing content, and they can't be the only ones who do. Image Assist is the single best module available for providing these functions. I really hope the effort to port the module to D7 hasn't been completely abandoned in favor of the inadequate Media module.

+1

I changed a little the script #19 by xetrokis http://drupal.org/node/841568#comment-4093474 to make it run as I have some prefix in my database. like this:
$prefix = 'd6x_';
...
$query = "SELECT * FROM ".$prefix."field_data_body WHERE body_value like '%[img_assist%'";
...

I think it is not related to my prefix but I can't make it run. I have errors like this:

[img_assist 
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Users\ron\Sites\d7u2\img_assist_html.php on line 60
FID: 
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Users\ron\Sites\d7u2\img_assist_html.php on line 68
Src: / 
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Users\ron\Sites\d7u2\img_assist_html.php on line 86
Img: src="/" style="width: nonepx; height: 360px;">

It maybe something wrong with the initialization of the loop while ($start = strpos($tmp, "[img_assist") !== FALSE) as I noticed that $start doesn't get the good value. Could it be related to PHP version? I'm a total newbie to PHP.

I have to do the same thing with body_summary instead of body_value. And at the moment I get the same kind of error.

subscribe

subscribe

subscribe

I came across the same issues and PHP errors as rondev had when running xetrokis's script. I made a couple of bug fixes to make the script work. It ran successfully on a site with ~1500 nodes and 15 image assist tags that was upgraded from D5 -> D6 -> D7. The modified script is below, taking into account rondev's prefix suggestions. I commented the changes I made.

$prefix = 'yourprefix';
$server = "localhost";
$login = "root";
$password = "XXXXXXXXXX";
$database = "drupal7";

///////////////////////////////////////////////////////////////////////////////////////////////////

$link = mysql_connect($server, $login, $password) or die("Connect error : " . mysql_error());
echo "Connect OK\n";

$db_selected = mysql_select_db($database, $link);
if (!$db_selected)
   die ('Select DB error : ' . mysql_error());

$query = "SELECT * FROM " . $prefix . "field_data_body WHERE body_value like '%[img_assist%'";
$result = mysql_query($query);

if (!$result) {
    $message  = 'Query error : ' . mysql_error() . "\n";
    $message .= 'Query : ' . $query;
    die($message);
}

$count=0;
while ($row = mysql_fetch_assoc($result))
{
    $tmp = $row['body_value'];
    $count++;
    echo "\n###############################################################################\n";
    echo "Entity ID: ".$row['entity_id'];
    //echo $tmp;   
    //echo "\n###############################################################################\n";
   
    $start = strpos($tmp, "[img_assist");
   
    while (($start = strpos($tmp, "[img_assist")) !== FALSE) // Added parentheses here since operator precedence was incorrect.
    {
        $end = strpos($tmp, "]", $start);
        $img = substr($tmp, $start+12, $end-$start-12);
       
        echo "Img: $img \n";
       
        list($nid, $title, $desc, $link_img, $align, $width, $height) = explode("|", $img);
       
        $nid = substr($nid, strpos($nid, "=")+1);
        $title = substr($title, strpos($title, "=")+1);
        $desc = substr($desc, strpos($desc, "=")+1);
        $link_img = substr($link_img, strpos($link_img, "=")+1);
        $align = substr($align, strpos($align, "=")+1);
        $width = substr($width, strpos($width, "=")+1);
        $height = substr($height, strpos($height, "=")+1);
       
        echo "NID: $nid \n";
       
        $query_image = "SELECT * FROM " . $prefix . "image WHERE nid=".$nid . " and image_size = '_original'"; // Changed query to always get the original image. Formerly, the query would return a row for each derivative of the image such as thumbnail.
        $result_image = mysql_query($query_image);
       
        $row_image = mysql_fetch_assoc($result_image);
        $fid = $row_image['fid'];
       
        echo "FID: $fid \n";
       
        $query_file = "SELECT * FROM " . $prefix . "files WHERE fid=".$fid;
        $result_file = mysql_query($query_file);
       
        $row_file = mysql_fetch_assoc($result_file);
        $img_path = $row_file['filepath'];
       
        if ($img_path[0] != '/') 
            $img_path = '/' . $img_path;
       
        echo "Src: $img_path \n";
       
        $buffer = substr($tmp, 0, $start);
       
        $buffer .= "<img alt=\"$desc\" src=\"$img_path\" width=\"$width\" height=\"$height\" class=\"inline inline-$align\" />"; // Not a critical change, but now specifies width and height in the image's attribute tags. Also preserves the alignment of the image if the user specified an alignment through image assist.
       
        $buffer .= substr($tmp, $end+1);
       
        //echo "Buffer: $buffer \n";
       
        $tmp = $buffer;
       
        mysql_free_result($result_image);
        //break; // Test
    } // End : while ($start = strpos($tmp, "[img_assist"))   
   
    $update_query = "UPDATE " . $prefix . "field_data_body SET body_value = '".addslashes($tmp)."' WHERE entity_id = ".$row['entity_id'];
    $res = mysql_query($update_query);
   
    if (!$res) {
        $message  = 'Query error : ' . mysql_error() . "\n";
        $message .= 'Query : ' . $update_query;
        die($message);
    }
   
    //break; // Test
}// End : while ($row = mysql_fetch_assoc($result))

mysql_free_result($result);

mysql_close($link);
echo "\nEnd ($count entities modified)\n\n";

+1

I concur. Media module does not yet have the ability to replace Image Assist.

As others have stated being able to insert images inline through the WYSIWYG (with captions and ability to easily pick through previously uploaded images) is one of the most basic and often needed attributes of a CMS.

I can't code yet, but encourage anyone who wants to help the Drupal community with something that almost everyone will use, this is a great thing to focus on - maybe through upgrading the Image Assist to Drupal 7 or making a feature or add-on for another module.

For temporary use on a D7 site, I'm using the following mix of modules:

- For uploading images, I have added IMCE (http://drupal.org/project/imce) and the IMCE WYSIWYG API Bridge (http://drupal.org/project/imce_wysiwyg) so that IMCE will work with my editor of choice, TinyMCE. IMCE has been around a while and works well enough. The only issue I have with this arrangement is that I cannot provide 'presets' using image styles (formerly image cache).

- For placing an image, I use the image widget in TinyMCE. You can float an image left or right. The advanced options allow the addition of classes or inline styles.

- For captions, I am using the Image Caption (http://drupal.org/project/image_caption) module. I like the input filter version of this module since it's not dependent on JavaScript/jQuery.

- For placing video from third party websites (YouTube, Vimeo) I am relying on the Media module. As much as I dislike the current state of the Media module, I know it's probably the future of media handling on the website. These same folks created the very useful embedded media modules so I think they'll get the issues worked out eventually. It's just they seem currently focused on things that have nothing to do with the UI. There also seem to be a lot of cooks in their kitchen.

I'm very interested in learning about other ways folks are using contrib modules to fill the image assist gap in D7.

subscribing

subscribing

Subscribing. Badly needed.

sub

Subscribing.

subscribing. maddening. I have begun 2 Drupal 7 sites and they are such a drag to work with. I have since started my new projects in Drupal 6 for reasons such as this.

+1

Drupal is now on 7.8, and I still cannot use it because I need my content editors to be able to insert pictures into their copy. I have argued for like 5 years that this sort of stuff should be bread-and-butter to a CMS, eg built right into core. Oh well, at least there is v6.. :|

+1

I found myself in this exact position recently but I had all of my old image data in a drupal 6 database and all of the nodes in a drupal 7 database. So I modified the script post above to use 2 databases. Reposting in case someone finds themselves in the same position.

Just a couple general suggestion, backup your database before you run this script (or any of the above). Also there are some debug statements peppered through the code from previous authors. I suggest doing a dry run by tossing in an exit() after the debug output and before the update query is run to make sure the img tags and update queries look logical.

<?php

$prefix6 = 'drupal_6_prefix_';
$server6 = 'drupal_6_server';
$login6 = 'drupal_6_user';
$password6 = 'drupal_6_password';
$database6 = 'drupal_6_database';

$prefix7 = 'drupal_7_prefix_';
$server7 = 'drupal_7_server';
$login7 = 'drupal_7_user';
$password7 = 'drupal_7_password';
$database7 = 'drupal_7_database';


///////////////////////////////////////////////////////////////////////////////////////////////////

$d6 = mysql_connect($server6, $login6, $password6, TRUE) or die("Connect error : " . mysql_error());
$d7 = mysql_connect($server7, $login7, $password7, TRUE) or die("Connect error : " . mysql_error());

echo "Connect OK\n";

$db6_selected = mysql_select_db($database6, $d6);
if (!$db6_selected)
   die ('Select DB error : ' . mysql_error($d6));
   
$db7_selected = mysql_select_db($database7, $d7);
if (!$db7_selected)
   die ('Select DB error : ' . mysql_error($d7));

$query = "SELECT * FROM " . $prefix7 . "field_data_body WHERE body_value like '%[img_assist%'";
$result = mysql_query($query,$d7);

if (!$result) {
    $message  = 'Query error : ' . mysql_error($d7) . "\n";
    $message .= 'Query : ' . $query;
    die($message);
}

$count=0;
while ($row = mysql_fetch_assoc($result))
{
    $tmp = $row['body_value'];
    $count++;
    echo "\n###############################################################################\n";
    echo "Entity ID: ".$row['entity_id'];
    //echo $tmp;   
    //echo "\n###############################################################################\n";
   
    $start = strpos($tmp, "[img_assist");
   
    while (($start = strpos($tmp, "[img_assist")) !== FALSE) // Added parentheses here since operator precedence was incorrect.
    {
        $end = strpos($tmp, "]", $start);
        $img = substr($tmp, $start+12, $end-$start-12);
       
        echo "Img: $img \n";
       
        list($nid, $title, $desc, $link_img, $align, $width, $height) = explode("|", $img);
       
        $nid = substr($nid, strpos($nid, "=")+1);
        $title = substr($title, strpos($title, "=")+1);
        $desc = substr($desc, strpos($desc, "=")+1);
        $link_img = substr($link_img, strpos($link_img, "=")+1);
        $align = substr($align, strpos($align, "=")+1);
        $width = substr($width, strpos($width, "=")+1);
        $height = substr($height, strpos($height, "=")+1);
       
        echo "NID: $nid \n";
       
        $query_image = "SELECT * FROM " . $prefix6 . "image WHERE nid=".$nid." and image_size='_original'";
        $result_image = mysql_query($query_image,$d6);
    		
    		if (!$result_image) {
				    $message  = 'Query error : ' . mysql_error($d6) . "\n";
				    $message .= 'Query : ' . $query_image;
				    die($message);
				}
    		   
        $row_image = mysql_fetch_assoc($result_image);
        $fid = $row_image['fid'];
       
        echo "FID: $fid \n";
       
        $query_file = "SELECT * FROM " . $prefix6 . "files WHERE fid=".$fid;
        $result_file = mysql_query($query_file,$d6);
       
        $row_file = mysql_fetch_assoc($result_file);
        $img_path = $row_file['filepath'];
       
        if ($img_path[0] != '/') 
            $img_path = '/' . $img_path;
       
        echo "Src: $img_path \n";
       
        $buffer = substr($tmp, 0, $start);
       
        $buffer .= "<img alt=\"$desc\" src=\"$img_path\" width=\"$width\" height=\"$height\" class=\"inline inline-$align\" />"; // Not a critical change, but now specifies width and height in the image's attribute tags. Also preserves the alignment of the image if the user specified an alignment through image assist.
       
        $buffer .= substr($tmp, $end+1);
       
        echo "Buffer: $buffer \n";
       
        $tmp = $buffer;
       
        mysql_free_result($result_image);
        //break; // Test
    } // End : while ($start = strpos($tmp, "[img_assist"))   

    $update_query = "UPDATE " . $prefix7 . "field_data_body SET body_value = '".addslashes($tmp)."' WHERE entity_id = ".$row['entity_id'];
    $res = mysql_query($update_query,$d7);
   
    if (!$res) {
        $message  = 'Query error : ' . mysql_error() . "\n";
        $message .= 'Query : ' . $update_query;
        die($message);
    }
   
    //break; // Test
}// End : while ($row = mysql_fetch_assoc($result))

mysql_free_result($result);

mysql_close($d6);
mysql_close($d7);

echo "\nEnd ($count entities modified)\n\n";
?>

subscribing

I've done a bit of work on a drupal 7 port. Its not perfect but its nearly there.
You need to convert image nodes using the drupal 7 development version of the old image module and the Field Convert module.

As image sizes from old module have gone and been replaced with image styles in drupal core that is what image assist now uses. But only if the style has size only transformations - anything else and that style isn't available. Image assist now also includes 3 styles based on the old 3 sizes from the image module. You can't alter these through the front end but you can always add more styles with the sizings you need.

The attachment includes the altered image assist and the modules needed to convert the old image nodes - the development image_legacy module and Field Convert module. Drupal 7 image module is only available via the git repository at the moment. Field Convert is available to download but I've included it here as that's the version thats worked for me.

I don't have much time to offer any support for this. Use at your own risk! Please do a test migration and make sure everything works how you need it to before using this on a production site.

One thing to node when converting the image nodes is to make sure that you don't have any duplicates in your file table. If there's more than one row with the same file name you'll get errors.

Thank you for the D7 port - I'm finding as I attempt my first D7 production site that this is very sorely needed!

But I haven't had luck getting it to work - perhaps someone could provide some guidance.

A few questions/details:

I'm using only the img_assist module insofar as this is a new site and I don't need to upgrade. Are the other modules necessary for this to work?

The included view doesn't find an acceptable content type and it doesn't seem to work with "Photo" (I'm using the OpenPublic distro and that seems to be the only suitable content type.) I don't know if this is the cause of it, but I haven't been able to get a link to show up below the edit form, no matter what I do.

In looking at the D6 version of ImageField Attach, the browser view looks fairly complex - would it be possible to get a content type/view export combination that could be expected to work out of the box in D7?

In D6, I was also able to choose whether the image could open in a Lightbox - my preferred method was to insert an image (with ImageCache preset) that when clicked on would open the original in a lightbox for greater detail. This was really elegant and I'm hoping to be able to do the same in D7. Would this be possible?

Anyway, it's good to see there's some motion here - thank you! Pretty painful transition so far, but I remain ever hopeful... assistance greatly appreciated!

Update: It looks like TinyMCE recognizes Image Assist as is (there's a little camera icon) - I get the following error, though when I try to invoke it (I'm in a sandbox):

Notice: Undefined property: stdClass::$node_image in img_assist_display() (line 1337 of /Users/[user]/sandbox/openpublic/sites/all/modules/img_assist/img_assist.module).

Perhaps this will help - thanks!

Further testing:

Using this with TnyMCE, Image Assist invokes via a camera logo in the TinyMCE toolbr (good) and offers to browse through My Images (0), of which there are none. When I try to upload a new images, I get the following error:

Warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, 'image_node_form' was given in drupal_retrieve_form() (line 785 of /[site]/includes/form.inc).

Looking at the view, it finds no suitable content type. So I changed it to "photo" (which exists). Cleared caches and got the same result.

I think I could be missing something small - any ideas? The lack of Image Assist (particularly when it worked so nicely in D6) really is a showstopper for D7.

Thanks for any suggestions!

for trackers

Having trouble here. I believe I have followed the instructions properly, yet I am getting errors in the field_convert step. Not understanding d7 super well yet, my guess is that field_convert should be adding many, many lines to files_managed for each of the nodes, but this is not happening. This is my error:

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=5163&op=do StatusText: error ResponseText: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'public://images/Sarah-McLachlan-pic.jpg' for key 2: INSERT INTO {file_managed} (uid, filename, uri, filemime, filesize, status, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => Sarah-McLachlan-pic.jpg [:db_insert_placeholder_2] => public://images/Sarah-McLachlan-pic.jpg [:db_insert_placeholder_3] => image/jpeg [:db_insert_placeholder_4] => 377528 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 1273717667 ) in image_legacy_field_convert_object_pre_load() (line 229 of /var/www/html/samaritanmag.com/site/sites/all/modules/image/image_legacy.field_convert.inc).

Happy to pay a bounty of 200 for anyone who will screenshare over my shoulder and talk me through getting this fixed and getting the img_assist d7 working on my d7 site. Pls email me asap!

"One thing to node when converting the image nodes is to make sure that you don't have any duplicates in your file table. If there's more than one row with the same file name you'll get errors."

You sure you haven't got more than one row in your file table that has the same file name?

Some things that don't work at moment.
When resizing the images using a custom size the javascript is incorrectly setting the width same as height / height same as width so you'll end up with a square image.

When uploading images there's an upload button next to the browse button. This doesn't work. If you submit the whole page using the save button at the bottom though the image should be uploaded and created.

Thank you colling2 for your initial efforts. I'm looking forward to hearing how this shapes up. I don't have any other comment. Just gratitude.

subscribing

IMCE + IMCE WYSIWYG API Bridge with TinyMCE is working great as an alternative for me. The installation effort was minimal.

P.S. We really need a way on drupal.org of promoting best or summary solutions to the top of these posted questions. The only solution for someone who doesn't want to get involved in PHP coding is at number #38!

+1 for #60. I was actually using ImageField Assist in D6 and you could easily insert an image to taste that would open up when clicked in a lightbox (with the full-size version) and if you wanted to get into Custom Formatters, you could have a caption on the image too.

Very slick - and all without using a WYSIWYG editor, which can really be more trouble than it's worth.

I really miss this functionality in D7.

This should fix the issue with the aspect ratio. This is just the module to replace the one from my earlier zip.

I think line:

$query_image = "SELECT * FROM " . $prefix . "image WHERE nid=".$nid . " and image_size = '_original'";

in #34 should be replaced with:

$query_image = "SELECT * FROM " . $prefix . "file_usage WHERE id=".$nid . " and module = 'image'";

It didn't work for me but with this change it now does!

IMCE with the WYSIWYG Bridge is a solution, but not a complete solution. It doesn't address the addition of captions. It also stores images in a way that is outside of the Drupal entity system. It also doesn't work with Image Styles. But yeah, you can get by with it.

Wow, something like nine months after this question was first posted and as far as I can tell the Image Assist maintainers have no reply regarding D7 support.

This is a huge problem for people who want a CMS (like they had with D6!) that will allow easy inserting of inline images, etc. In my case, we're trying to migrate a VERY large site from D6 that had all images inserted with Image Assist. Again, this is a massive problem for me and my client(s)...really shakes my faith in Drupal (not trying to start something here...just extremely frustrated with no simple solution in sight).

@TfR75 - have you seen the port from #51 + #62?

This is working fine for one of my previously d5 sites.

The only problem I'm having now is that when uploading images there's an upload button next to the browse button. This doesn't work. If you submit the whole page using the save button at the bottom though the image should be uploaded and created.

Getting the upload button to work shouldn't take much, I just don't have much time right now.

In the next few months I will have to migrate a medium sized D6 site to D7 and will need to choose a solution. I already decided to use one of the alternative ways of inserting images in D7.

Apparently the reuse of images has less priority for my client than easy of use. img_assist is great for reusing images, but it is annoying that another window opens and you have to submit another node, with all the group membership decisions (when you use groups) and tags etc. This really slows down the work flow. The alternative methods don't allow easy reuse of images, but at least people can upload and insert faster, without pop-ups.

Depending on the complexity of the migration, I might end up with a system where old inserted images are still served and displayed through a patched img_assist module, while all new images are inserted with the alternatives available for D7. Whatever I end up doing, I promise here to keep record and document all the steps I took in the migration process and share them with you.

I´m particularly interested in how to use other module to work with old img_assist images, because times goes by and I need to upgrade my site to D7.
I´m looking forward for your follow up @ñull!
Thanks!

subscribe

The script in #34 does not work with russian characters. It renders the rest of the body field unreadable.

image_assist_fix.php is my regex-based take on the problem of fixing the img_assist tags into static IMG elements.

I had fun working on it. Have fun using it.

Thank you olleolleolle.

Stop spamming the issues list with "subscribe" posts. Just click "Follow" in the top-right corner of the page.

Has anyone been able to get this working with just the icon/link, and not in the WYSIWYG? It's not showing up for me, but I haven't had a chance to dig into the cause yet.

The here posted migration scripts are very helpful, but they are in some circumstances not complete. What if there are revisions and if you allowed img_assist in comments? And what about its use in summary (teaser)? I'll try to add these missing parts to the script and I'll post them back here.

I've been using the D7 port, and it's gradually behaving itself.

I had to fiddle with the field convert code - it was falling over because of repeated filepaths. I couldn't reproduce it when querying the database directly, so instead I wrapped the insert code in a try/catch so that it would just skip the repeats. I reversed the order of the list as well, so it should be (vaguely) last-first, so the most recent version is used where there are duplicates. (Code at bottom[1]).

Now things seem to work, which is great, but there are a few issues:
1) loads of warning messages[2]
2) tags seem to *need* width and height, where before they just needed one or the other.
3) popup images are tiny, about 100px wide
4) there's no button on text areas to add an image

1) seems to be strongly related to 2) - I'll see if there's an easy fix.
any thoughts on 3) and 4)?

[1]
Line 204: add:
$files = array_reverse($files); to reverse the file list.

Then wrap both insert statements in try/catch
Line 230 change:

      // Insert the file into the {file_managed} table.
      $new_fid = db_insert('file_managed')

to

	  try
	  {
      // Insert the file into the {file_managed} table.
      $new_fid = db_insert('file_managed')

Line 260ish change:

        ->condition('nid', $nid)
        ->execute();      

to

        ->condition('nid', $nid)
        ->execute();      
	  } catch (Exception $e){}

[2]
Errors are all like this:

Notice: Undefined index: height in img_assist_render_image() (line 1371 of /Volumes/Data/Projects/website/local/sites/all/modules/img_assist/img_assist.module).
Notice: Undefined index: height in img_assist_display() (line 1325 of /Volumes/Data/Projects/website/local/sites/all/modules/img_assist/img_assist.module).
Notice: Undefined index: height in img_assist_render_image() (line 1371 of /Volumes/Data/Projects/website/local/sites/all/modules/img_assist/img_assist.module).
Notice: Undefined index: height in img_assist_display() (line 1325 of /Volumes/Data/Projects/website/local/sites/all/modules/img_assist/img_assist.module).
Notice: Undefined index: height in img_assist_render_image() (line 1371 of /Volumes/Data/Projects/website/local/sites/all/modules/img_assist/img_assist.module).
Notice: Undefined index: height in img_assist_display() (line 1325 of /Volumes/Data/Projects/website/local/sites/all/modules/img_assist/img_assist.module).
Notice: Undefined index: height in img_assist_render_image() (line 1371 of /Volumes/Data/Projects/website/local/sites/all/modules/img_assist/img_assist.module).
Notice: Undefined index: height in img_assist_display() (line 1325 of /Volumes/Data/Projects/website/local/sites/all/modules/img_assist/img_assist.module).
Notice: Undefined index: height in img_assist_render_image() (line 1371 of /Volumes/Data/Projects/website/local/sites/all/modules/img_assist/img_assist.module).

OK, on further exploration it seems that:
* most of the noices are by-design, i.e. using null keys on purpose in expressions
* some of the height/width substitution works by default, some doesn't - I get some gigantic images appearing.

I've hacked my copy a bit to make it work, but it's a bit ugly, and I discovered code in img_assist_render_image that does a similar job, so it's probably not a good idea to share until I understand the design of the module better.

This is the code that worked for me. It converts all of the tags in each page (not just the first one), and it correctly aligns each image (left, right), but you have to be sure that each page is 'Full HTML' (not 'Filtered HTML' as one of mine was) for it to work properly.

/**
* PHP script to convert Image Assist Tag into HTML tags.
*
* Drupal 6-to-7 conversion
*
* This script must be run on D7 database (after the update from D6 to D7).
* http://drupal.org/node/841568
*/
 
 
$server = "localhost";
$login = "mySQLuser";
$password = "mySQLpassword";
$database = "mySQLdatabase";
$prefix = 'your_table_prefix_';
$really_update = TRUE; # Set this to TRUE to actually run this Drupal 6-to-7 conversion
 
 
///////////////////////////////////////////////////////////////////////////////////////////////////
 
$link = mysql_connect($server, $login, $password) or die("Connect error : " . mysql_error());
echo "Connect OK\n";
 
$db_selected = mysql_select_db($database, $link);
if (!$db_selected)
	die ('Select DB error : ' . mysql_error());
 
$query = "SELECT * FROM ${prefix}field_data_body WHERE body_value like '%[img_assist%'";
$result = mysql_query($query);
if (!$result) {
	$message = 'Query error : ' . mysql_error() . "\n";
	$message .= 'Query : ' . $query;
	die($message);
}
 
$count=0;
while ($row = mysql_fetch_assoc($result))	{
	$tmp = $row['body_value'];
	$count++;
	echo "<p>$count #######################################################################\n";
	echo "Entity ID: ${row['entity_id']}\n";
// 	echo $tmp;
// 	echo "\n###############################################################################\n";
 
	$pattern = "/\[img_assist(?:\\\\|\\\]|[^\]])*\]/"; # See http://rubular.com/r/gQs5HjGLok
	preg_match_all($pattern, $tmp, &$matches, PREG_OFFSET_CAPTURE); # NB: The PREG_OFFSET_CAPTURE gives us the offset_in_tmp variable.
//	echo "var_dump(matches): " . var_dump($matches);
	foreach ($matches as $match) {
//		echo "var_dump(image_marker): <pre>" . var_dump($image_marker) . "</pre>";
		$i = 0;
		foreach ($match as $image_marker)	{
			$i++;
			list($img, $offset_in_tmp) = $image_marker;
			echo "<p> $i Img: $img \n";
			// Strip off the first and last character - they are [ and ].
			$img_pieces = preg_replace("/^\[(.*)\]$/", '${1}', $img);
			echo "Img w/o brackets: $img_pieces \n";
 
			// The dollar-underscore variable is a junk collector
			// Here, the first item is the img_assist piece
			list($_, $nid, $title, $desc, $link_img, $align, $width, $height) = explode("|", $img_pieces);
			list($_, $nid) = explode('=', $nid, 2);
			list($_, $title) = explode('=', $title, 2);
			list($_, $desc) = explode('=', $desc, 2);
			list($_, $link_img) = explode('=', $link_img, 2);
			list($_, $align) = explode('=', $align, 2);
			list($_, $width) = explode('=', $width, 2);
			list($_, $height) = explode('=', $height, 2);
			echo "NID: $nid \n";
			$query_image = "SELECT * FROM ${prefix}image WHERE nid=$nid AND image_size='_original'";
			$result_image = mysql_query($query_image);
			$row_image = mysql_fetch_assoc($result_image);
			$fid = $row_image['fid'];
			echo "FID: $fid \n";
			$query_file = "SELECT * FROM ${prefix}files WHERE fid=".$fid;
			$result_file = mysql_query($query_file);
			$row_file = mysql_fetch_assoc($result_file);
			$img_path = $row_file['filepath'];
			if ($img_path[0] != '/')
				$img_path = '/' . $img_path;
			echo "Src: $img_path \n";
			$image_tag = "<img alt=\"$desc\" src=\"$img_path\" style=\"width: ".$width."px; height: ".$height."px; float: ".$align.";\">";
 
			$tmp = str_replace($img, $image_tag, $tmp);
			mysql_free_result($result_image);
		}
	}
 
	if ($really_update) {
		$update_query = "UPDATE ${prefix}field_data_body SET body_value = '".addslashes($tmp)."' WHERE entity_id = ".$row['entity_id'];
		$res = mysql_query($update_query);
		if (!$res) {
			$message = 'Query error : ' . mysql_error() . "\n";
			$message .= 'Query : ' . $update_query;
			die($message);
		}
	}
	//break; // Test
}	// End : while ($row = mysql_fetch_assoc($result))
 
mysql_free_result($result);
 
mysql_close($link);
echo "\nEnd ($count entities modified)\n\n";

I found this technique of using the custom filter module worked great for me http://hyperlogos.org/blog/drink/Migrated-D7-displaying-images

This is in response to marktompsett, #81. I know this is an old post (7 months old) but this thread seems to be the only migration path for Drupal 6 to 7 for Image Assist. I copied your code into a PHP file after updating the credentials for my web hosting account and put it on my website root. Does this only run in Drupal 6? I already have Drupal 7 loaded and it takes an hour to download or upload Drupal via FTP since I don't have SSH access to my web host. I don't even have SFTP but that's typical for free web hosts that you give up certain things. Either way, I get a blank web page with no messages at all. Can you offer some troubleshooting steps? Usually, with an error, at least I can Google it.

Not sure if anyone is still on D6 (like me, sad face) but I'll mention anyway: comment #49 worked best in my case, just had to update line 90

//from
$buffer .= "<img alt="$desc" src="$img_path" width="$width" height="$height" class="inline inline-$align" />";

//to
$buffer .= "<img alt='".$desc."' src='".$img_path."' width='".$width."' height='".$height."' class='inline inline-".$align."' />";

Thanks,

I know this is a VERY old post. I wanted to update my last remaining D6 site straight to D8. So I replaced the img_assist tags BEFORE the upgrade. This is the code from #81 with some adaptions to run it within the D6 database.
I had to run it from the command line using PHP 53.

<?php 
/**
* PHP script to convert Image Assist Tag into HTML tags.
*
* Drupal 6 inline conversion 
*
* This script must be run on D6 database (BEFORE the update from D6 to D7 or D8).
* It seems that this script only runs on PHP <5.4
* search-replace "body" to "teaser" and run again to do the same replacement for the teasers
* http://drupal.org/node/841568
*/
 
$server = "localhost";
$login = "xxxxxxx";
$password = "xxxxxxx";
$database = "xxxxxxx";
$prefix = '';
$really_update = TRUE; # Set this to TRUE to actually run this conversion
 
 
///////////////////////////////////////////////////////////////////////////////////////////////////
 
$link = mysql_connect($server, $login, $password) or die("Connect error : " . mysql_error());
echo "Connect OK\n";
 
$db_selected = mysql_select_db($database, $link);
if (!$db_selected)
	die ('Select DB error : ' . mysql_error());
 
$query = "SELECT * FROM ${prefix}node_revisions WHERE body like '%[img_assist%'";
$result = mysql_query($query);
if (!$result) {
	$message = 'Query error : ' . mysql_error() . "\n";
	$message .= 'Query : ' . $query;
	die($message);
}
 
$count=0;
while ($row = mysql_fetch_assoc($result))	{
	$tmp = $row['body'];
	$count++;
	echo "$count #######################################################################\n";
	echo "Entity ID: ${row['vid']}\n";
// 	echo $tmp;
// 	echo "\n###############################################################################\n";
 
	$pattern = "/\[img_assist(?:\\\\|\\\]|[^\]])*\]/"; # See http://rubular.com/r/gQs5HjGLok
	preg_match_all($pattern, $tmp, &$matches, PREG_OFFSET_CAPTURE); # NB: The PREG_OFFSET_CAPTURE gives us the offset_in_tmp variable.
//	echo "var_dump(matches): " . var_dump($matches);
	foreach ($matches as $match) {
//		echo "var_dump(image_marker): " . var_dump($image_marker) . "";
		$i = 0;
		foreach ($match as $image_marker)	{
			$i++;
			list($img, $offset_in_tmp) = $image_marker;
			echo "
 $i Img: $img \n";
			// Strip off the first and last character - they are [ and ].
			$img_pieces = preg_replace("/^\[(.*)\]$/", '${1}', $img);
			echo "Img w/o brackets: $img_pieces \n";
			// The dollar-underscore variable is a junk collector
			// Here, the first item is the img_assist piece
			list($_, $nid, $title, $desc, $link_img, $align, $width, $height) = explode("|", $img_pieces);
			list($_, $nid) = explode('=', $nid, 2);
			list($_, $title) = explode('=', $title, 2);
			list($_, $desc) = explode('=', $desc, 2);
			list($_, $link_img) = explode('=', $link_img, 2);
			list($_, $align) = explode('=', $align, 2);
			list($_, $width) = explode('=', $width, 2);
			list($_, $height) = explode('=', $height, 2);
			echo "NID: $nid \n";
			$query_image = "SELECT * FROM ${prefix}image WHERE nid=$nid AND image_size='_original'";
			$result_image = mysql_query($query_image);
			$row_image = mysql_fetch_assoc($result_image);
			$fid = $row_image['fid'];
			echo "FID: $fid \n";
			$query_file = "SELECT * FROM ${prefix}files WHERE fid=".$fid;
			$result_file = mysql_query($query_file);
			$row_file = mysql_fetch_assoc($result_file);
			$img_path = $row_file['filepath'];
			if ($img_path[0] != '/')
				$img_path = '/' . $img_path;
			echo "Src: $img_path \n";
			
			$image_tag = "<img alt=\"$desc\" src=\"$img_path\" width=\"$width\" height=\"$height\" align=\"$align\" class=\"inline inline-$align\" />";
			// Adjust this line to your needs
			
			$tmp = str_replace($img, $image_tag, $tmp);
			mysql_free_result($result_image);
			echo "tmp: $tmp \n";
		}
	}
	if ($really_update) {
		
		$update_query = "UPDATE ${prefix}node_revisions SET body = '".addslashes($tmp)."' WHERE vid = ".$row['vid'];
		$res = mysql_query($update_query);
		if (!$res) {
			$message = 'Query error : ' . mysql_error() . "\n";
			$message .= 'Query : ' . $update_query;
			die($message);
		}
	}
	//break; // Test
}	// End : while ($row = mysql_fetch_assoc($result))
mysql_free_result($result);
mysql_close($link);
echo "\nEnd ($count entities modified)\n\n";
?>

Thank you very much Kniekel. This worked very good for me. I just had to deactivate error_report fot deprecated function. Now all my images are available in all the contents migrated :)

For what its worth, because I want to migrate D6-D8, I didn't want to use the D7-required script, so I created this drush command for D6 instead.

I found the 'direct' path didn't translate some of the tags -- I think there is a loop missing-- so have reworked the code using img_assist's own render code, which of course works. One side-effect of this is that the < img > tag regains left/right spans & caption text.

It uses D6 node_load and node_save so should interact well with other modules. I haven't attempted to fix up old revisions. I have used drush_confirm, so use "drush -y" as appropriate.

Instructions:
Download the attached file
Rename it to "img_assist.drush.inc" and put that file in the ../modules/img_assist folder for D6
Clear drush cache: drush cc drush

The new command is called "image-assist-render-nodes" or "iarn" for short. It will find all nodes containing the img_assist tag in either teaser or body. I considered a render by node id option but it wasn't worth it for me.

Hope it helps someone.

I've update the code of Kniekel (https://www.drupal.org/node/841568#comment-11494035) to use mysqli, so you could use this script with php > 5.4 and < 7.0

/**
* PHP script to convert Image Assist Tag into HTML tags.
*
* Drupal 6 inline conversion
*
* This script must be run on D6 database (BEFORE the update from D6 to D7 or D8).
* It seems that this script only runs on PHP < 7
* search-replace "body" to "teaser" and run again to do the same replacement for the teasers
* http://drupal.org/node/841568
*/

$server = "localhost";
$login = "your-user";
$password = "your-pass";
$database = "your-db";
$prefix = '';
$really_update = TRUE; # Set this to TRUE to actually run this conversion


///////////////////////////////////////////////////////////////////////////////////////////////////

$link = mysqli_connect($server, $login, $password, $database) or die("Connect error : " . mysqli_connect_error());
echo "Connect OK\n";

$query = "SELECT * FROM ${prefix}node_revisions WHERE body like '%[img_assist%'";
$result = mysqli_query($link, $query);
if (!$result) {
	$message = 'Query error : ' . mysqli_connect_error() . "\n";
	$message .= 'Query : ' . $query;
	die($message);
}

$count=0;
while ($row = mysqli_fetch_assoc($result))	{
	$tmp = $row['body'];
	$count++;
	echo "$count #######################################################################\n";
	echo "Entity ID: ${row['vid']}\n";
// 	echo $tmp;
// 	echo "\n###############################################################################\n";

	$pattern = "/\[img_assist(?:\\\\|\\\]|[^\]])*\]/"; # See http://rubular.com/r/gQs5HjGLok
	preg_match_all($pattern, $tmp, $matches, PREG_OFFSET_CAPTURE); # NB: The PREG_OFFSET_CAPTURE gives us the offset_in_tmp variable.
//	echo "var_dump(matches): " . var_dump($matches);
	foreach ($matches as $match) {
//		echo "var_dump(image_marker): " . var_dump($image_marker) . "";
		$i = 0;
		foreach ($match as $image_marker)	{
			$i++;
			list($img, $offset_in_tmp) = $image_marker;
			echo "
 $i Img: $img \n";
			// Strip off the first and last character - they are [ and ].
			$img_pieces = preg_replace("/^\[(.*)\]$/", '${1}', $img);
			echo "Img w/o brackets: $img_pieces \n";
			// The dollar-underscore variable is a junk collector
			// Here, the first item is the img_assist piece
			list($_, $nid, $title, $desc, $link_img, $align, $width, $height) = explode("|", $img_pieces);
			list($_, $nid) = explode('=', $nid, 2);
			list($_, $title) = explode('=', $title, 2);
			list($_, $desc) = explode('=', $desc, 2);
			list($_, $link_img) = explode('=', $link_img, 2);
			list($_, $align) = explode('=', $align, 2);
			list($_, $width) = explode('=', $width, 2);
			list($_, $height) = explode('=', $height, 2);
			echo "NID: $nid \n";
			$query_image = "SELECT * FROM ${prefix}image WHERE nid=$nid AND image_size='_original'";
			$result_image = mysqli_query($link,$query_image);
			$row_image = mysqli_fetch_assoc($result_image);
			$fid = $row_image['fid'];
			echo "FID: $fid \n";
			$query_file = "SELECT * FROM ${prefix}files WHERE fid=".$fid;
			$result_file = mysqli_query($link, $query_file);
			$row_file = mysqli_fetch_assoc($result_file);
			$img_path = $row_file['filepath'];
			if ($img_path[0] != '/')
				$img_path = '/' . $img_path;
			echo "Src: $img_path \n";

			$image_tag = "<img alt=\"$desc\" src=\"$img_path\" width=\"$width\" height=\"$height\" align=\"$align\" class=\"inline inline-$align\" />";
			// Adjust this line to your needs

			$tmp = str_replace($img, $image_tag, $tmp);
			mysqli_free_result($result_image);
			echo "tmp: $tmp \n";
		}
	}
	if ($really_update) {

		$update_query = "UPDATE ${prefix}node_revisions SET body = '".addslashes($tmp)."' WHERE vid = ".$row['vid'];
		$res = mysqli_query($link, $update_query);
		if (!$res) {
			$message = 'Query error : ' . mysqli_connect_error() . "\n";
			$message .= 'Query : ' . $update_query;
			die($message);
		}
	}
	//break; // Test
}	// End : while ($row = mysql_fetch_assoc($result))
mysqli_free_result($result);
mysqli_close($link);
echo "\nEnd ($count entities modified)\n\n";

Thank you very much for the code, Jorge.catalyst and Kniekel.

I very to run it on my old Drupal 6 site, but what happens is that it only removes the old img assist tags, without replacing it with anything.. Any idea what could be wrong? The first time I run it it reports have changed 36 instances (which it does, by deleting them), and the next time nothing, but all image code is gone (apart from the coding I had around the tags).

Any help would be greatly appreciated!