[buro9]

* sigh *

OK, These changes remove the word Array and put in the thumbnail data.

In functions_upload.php find the following (created by this hack):

PHP Code:

    $image['update'] = ", thumbnaildata = '". $DB_site->escape_string($thumbnail)."'";
    $image['insert'] = "'".$DB_site->escape_string($thumbnail)."',"; 


Replace it with:

PHP Code:

    $image['update'] = ", thumbnaildata = '". $DB_site->escape_string($thumbnail['filedata'])."'";
    $image['insert'] = "'".$DB_site->escape_string($thumbnail['filedata'])."',"; 


In albumcp.php, which is the one in the admincp folder, find the following:

PHP Code:

      UPDATE " . TABLE_PREFIX . "customprofilepic
      SET thumbnaildata = '" . $DB_site->escape_string($thumbnail) . "'
      WHERE picture_id = $image[picture_id] 


Replace that with:

PHP Code:

      UPDATE " . TABLE_PREFIX . "customprofilepic
      SET thumbnaildata = '" . $DB_site->escape_string($thumbnail['filedata']) . "'
      WHERE picture_id = $image[picture_id] 


Finally, you might also want to do find this in that file:

PHP Code:

if ($_REQUEST['do'] == 'rebuildthumbs')
{ 


And follow it with this, adjusting the number of seconds to suit your needs:

PHP Code:

  set_time_limit(120); 


That last bit simply allows the rebuild thumbnails thing to run for 120 seconds = 2 minutes... because there's no pagination stuff in that script and it will probably time out if you have a load of users to rebuild thumbs for.

Other things you might want to do whilst your here... take a look at this thread: https://vborg.vbsupport.ru/showthread.php?t=66765
And then execute this piece of SQL if you haven't already:
[sql]
ALTER TABLE `customprofilepic` ADD INDEX ( `userid` )
[/sql]

Obviously prepending any TABLE_PREFIX that you use, if indeed you use one.

Any more bugs with this? Probably, so let's resolve them eh? Just report them and there's nothing stopping you lot looking around and trying to figure it out too