@GauGau
It's an unbridged coppermine install and not a hack or a mod. For sure it's not PHP standard, it's try and error, learning by doing, and I'm happy that it works ...
This one is in the head.php of my website (not gallery):
// new Gallery DB
$_gallery = new db($_cfg['DB_SERVER'], $_cfg['DB_GALLERY_USER'], $_cfg['DB_GALLERY_PASS'], $_cfg['DB_GALLERY_NAME']);
// gallery_pics
$gallery_pics = implode('', $_gallery->fetch_first('SELECT COUNT(*) FROM cpg132_pictures AS p, cpg132_albums AS a WHERE p.aid = a.aid '));
// gallery hits
$gallery_hits = implode('', $_gallery->fetch_first('SELECT SUM(`hits`) FROM cpg132_pictures AS p, cpg132_albums AS a WHERE p.aid = a.aid '));
And with this one in the left_login.tpl I get the result on the startpage of my website (for example
www.orst.ch after login with test test).
<li><a href="http://www.orst.ch/copper/index.php">Gallery-Fotos</a> ($gallery_pics)</li>
<li><a href="http://www.orst.ch/copper/index.php">Gallery-Views</a> ($gallery_hits)</li>
Now I'll try to build in how many users are registered in the gallery (thanks for your idea, I'll try it out).
The difference between your idea and the idea of "nol33t" I don't understand.
My website is builded around a forum (it's a very good one) but there is no gallery bridge for this forum, so I think my solution is not so bad for the moment (except the problem that everybody has to make two registrations/logins, one for the website (including the forum) and another one for the gallery).
If it would be very easy to build in automaticly all the forum users into the gallery, so that every website user after his login is also logged in into the gallery, I'm open for this solution.
hama