1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
|
/* VGProfil Galerie by Viktor */
$vgpgal_anz = 0;
$bild = '';
$bildmid = '';
$vgpgal_anzeige = '';
if($wbbuserdata['canshowvgprofilgal']==1) {
list($vgpgal_anz) = $db->query_first("SELECT count(id) FROM bb".$n."_vgprofil_gal_user_bilder WHERE userid = '".$user_info['userid']."'");
if($vgpgal_anz!=0) {
$vgprofilgal_anz = '';
if($vgpgal_anz==1) $vgprofilgal_anz = $vgpgal_anz.' Bild hochgeladen';
else $vgprofilgal_anz = $vgpgal_anz.' Bilder hochgeladen';
/* Profilbild holen */
$prof_info = $db->query_first("SELECT * FROM bb".$n."_vgprofil_gal_user_bilder WHERE userid = '".$user_info['userid']."' AND defau = '1'");
if($prof_info['id']) {
$id = $prof_info['id'];
$vgprofilwidth = $prof_info['owidth'] + 60;
$vgprofilheight = $prof_info['oheight'] + 100;
eval ("\$bildmid = \"".$tpl->get("vgprofil_gal_pic_show_mid")."\";");
}
/* Anzahl der freigegebenen Bilder ermitteln */
list($bildercount) = $db->query_first("SELECT count(u.id)
FROM bb".$n."_vgprofil_gal_user_bilder u
LEFT JOIN bb".$n."_vgprofil_gal_user_frei uf USING (id)
WHERE u.userid = '".$user_info['userid']."' AND u.frei = '1' AND u.defau = '0'
OR ( u.userid = '".$user_info['userid']."' AND uf.id = u.id AND uf.userid = '".$wbbuserdata['userid']."')");
/* Wie viele Bilder auf einer Seite */
list($bilderperpage) = $db->query_first("SELECT config_value FROM bb".$n."_vgprofil_gal_config WHERE config_name = 'anzahl_prof'");
if(isset($_REQUEST['page'])){
$page = intval($_REQUEST['page']);
if($page == "0") $page = "1";
}
else $page = "1";
$pages = ceil($bildercount / $bilderperpage);
$result = $db->query("SELECT u.* FROM bb".$n."_vgprofil_gal_user_bilder u
LEFT JOIN bb".$n."_vgprofil_gal_user_frei uf USING (id)
WHERE u.userid = '".$user_info['userid']."' AND u.frei = '1' AND u.defau = '0'
OR ( u.userid = '".$user_info['userid']."' AND uf.id = u.id AND uf.userid = '".$wbbuserdata['userid']."' ) ORDER by u.datum DESC",$bilderperpage,$bilderperpage*($page-1));
while($row=$db->fetch_array($result)) {
$id = $row['id'];
$vgprofilwidth = $row['owidth'] + 60;
$vgprofilheight = $row['oheight'] + 100;
eval ("\$bild .= \"".$tpl->get("vgprofil_gal_pic_show_thumbnail")."\";");
}
if($bildercount) $countfrom = 1+$bilderperpage*($page-1);
else $countfrom=0;
$countto = $bilderperpage*$page;
if($countto > $bildercount) $countto = $bildercount;
if($pages > 1) $pagelink = makepagelink_pgal("overview.php?userid=$userid&sid=$session[hash]",$page,$pages,2);
eval ("\$vgpgal_anzeige .= \"".$tpl->get("profile_vgprogil_gal")."\";");
}
}
/* VGProfil Galerie by Viktor */ |