Attachments in blogs

I just noticed after trying to upload an attachment in a blog entry that i get an invalid URL for the attachment.

I have the exact issue noted at Attachments in blogs - where it looks to have been fixed (i see it is working on this board anyway)

I have the latest version of vBSEO, vBulletin (Beta 4) and the latest version of vBulletin Blogs.

Any suggestions?

Please try to modify functions_vbseo.php file:
FIND:

PHP Code:

$find_user_ids, $find_blog_ids, $find_blogcat_ids 


REPLACE WITH:

PHP Code:

$find_user_ids, $find_blog_ids, $find_blogcat_ids, $find_blogatt_ids 


FIND:

PHP Code:

$find_user_ids = $find_blog_ids = $find_blogcat_ids = 


REPLACE WITH:

PHP Code:

$find_user_ids = $find_blog_ids = $find_blogcat_ids = $find_blogatt_ids = 


FIND:

PHP Code:

$find_blog_ids = $matches[1]; 


EDIT ADD ABOVE (not "replace with"):

PHP Code:

            if(preg_match_all('#'.$matchpre2.'blog_attachment\.'.VBSEO_VB_EXT.'\?[^"]*?attachmentid=(\d+)#', $newtext, $matches))
                $find_blogatt_ids = $matches[1]; 


FIND:

PHP Code:

$g_cache['battach'][$aid] = $att; 


ADD BELOW:

PHP Code:

            if($find_blogatt_ids)
                vbseo_get_blogatt_info($find_blogatt_ids); 


and functions_vbseo_vb.php file

FIND:

PHP Code:

function vbseo_get_blog_cats($ids) 


ADD ABOVE:

PHP Code:

function vbseo_get_blogatt_info($ids)
{
    global $g_cache;

    if (!is_array($ids)) $ids = array($ids);
    $lookupids = array();
    foreach($ids as $id)
    {
        if (isset($g_cache['battach'][$id])) continue;
        $lookupids[$id]++;
    }

    if (empty($lookupids))
        return;

    $db = vbseo_get_db();
    $db->vbseodb_select_db();
    $rid = $db->vbseodb_query($q="
            select attachmentid, blogid, userid, filename, dateline
            from " . vbseo_tbl_prefix('blog') . "blog_attachment
            where
                attachmentid in (" . join(',', array_keys($lookupids)) . ")
        ");

    if ($rid)
    {
        while ($bl = @$db->funcs['fetch_assoc']($rid))
        $g_cache['battach'][$bl['attachmentid']] = $bl;
        $db->vbseodb_free_result($rid);
    }
    return;
} 


EDIT
in functions_vbseo_createurl.php file:
FIND:

PHP Code:

$blogid = $g_cache['battach'][$attid]['blogid']; 


add below:

PHP Code:

        if(!$blogid)
            return ''; 


Thanks for your speedy reply Oleg, i made the adjustments you suggested but unfortunately it did not fix the problem.

The attachment issue remains unchanged, and now a new problem has surfaced.

Individual blog posts are no longer accessible, after following your edits the URLs are now

Code:

%user_name%/-a.html

Can you provide ftp/admincp access via support ticket for troubleshooting?

An update: one of the code edits should be "added above" (not "replace with").

Thanks for your assistance, all the links appear to be working fine now.

Just one final tiny thing, when you upload an attachment to a blog post it shows

Code:

Array (     [0] => 12 )

(where 12 is the attachment number) at the top of the window. Is there a quick change i can do to tidy that up?

That should be fixed now.