phpbb3 photo gallery?

[Red Paul]

Any tips on photo galleries for phpbb3?

It's an obvious thing for my guitar forum, but I don't want anything too complicated or that causes problems in different browsers... I'll be Googling, but would prefer real-life recommendations!

[roys]

I cannot install the db changes probably because when i go to the db_install file. It says i already have the latest version of photo gallery installed.

[dynander]

I would like to know that too

[peplas]

I have seen a few requests and such on how to add latest uploaded file and comments onto the phpbb userprofile. What you can do is do a cowboy job like I have done. First install phpbb eXtreme Styles mod, this alows you to include files on the phpbb templates. Then copy coppermine profile.php file and give it a different name. Comment out stuff like pageheader($title); , endtable(); , pagefooter(); and trial and error on other stuff to comment out. The 3rd and 4th message on this thread is how to get quotas and a percentage table without installing xtreme style mod.

Add in includes/usercp_viewprofile.php below $template->assign_vars(array(

'USERID' => $profiledata['user_id'],

then add this to profile_view_body.tpl

<!-- PHP -->
include('http://127.0.0.1/gallery/include-profile.php?uid=' . $this->vars['USERID']);
<!-- ENDPHP -->

obviously changing it to your host and renamed profile.php page.

I am working on getting upload statistics also added, as I know absolutely no php I am relying on internet tutorials to figure it out. So far I have added this to my include-profile.php page just above $image_size = compute_img_size($picture['pwidth'], $picture['pheight'], $CONFIG['thumb_width']);

$sql = 'SELECT SUM(total_filesize) AS sum_total_filesize FROM cpg132_pictures WHERE owner_id =' . $uid; 
  $result = mysql_query($sql) or die(mysql_error()); 
  $i = mysql_fetch_array($result);
  $uploaded = round($i['sum_total_filesize'] / 1024);

and added $uploaded somewhere amounst $user_thumb = .......
Will post back when/if I figure out how to get quota allowed for a group and make a nice graph thingy Smiley or someone else may like to chip in.