sabret00the
11-29-2004, 10:00 PM
Ok so i'm in the middle of developing something cool and it seems that a few people actually only want half of what i'm attempting to do so for you all here you go. Peace, Love and Happiness!
Damn almost forgot the desciption, erm this hack puts a photo, but not just any photo, your last uploaded photo into your postbit, it's s3x11111!!!!! i think :o.
Ok theirs one question i don't ever ever ever want to see in this thread, unless you're sure you have www.photopost.com's photopost installed, save us all the heartache and just don't do it, be kind, be generous, show me love, but if you aint got photopost installed then what's the point in saying "it don't show the photo for me" it's bound not to :( oh and for people who are going to ask "can you do it for the vB photo" nope i'm afraid i've never tried :(
ok after that little bit i should say something cool, like screenshots are not present since i have no desire to install this as is, no wait that sucked, however if anyone would like to provide screenies, you're welcome yay.
Damn is their nothing else i can waste your time with, surely you have no better to do than read my garbage, guess not, oh well it's an easy installation, i estimates 3.75 minutes, 2 files edits, one template mod, 1 vB option group and a setting to fill it.
big thanks to natch without him it would've been impossible and thanks to dean c (mist) too who got me through the final stages like a lucazade during a marathon.
* sabret00the does cool guy pose
have fun with it. :p :)
Query Load: beleive it or not, from the dungeon of super sucky coders this came and only adds one query to the showthread, i'm not even lying, wow, well that's what the microstats said, so if i was wrong blame Neo, he's obviously misalligned the matrix.
think i covered everything now :)
in your includes/functions_showthread.php find
// ###################### Start process_highlight_postbit #######################
function process_highlight_postbit($text, $words, $prepend)
above that add
// ###################### Start last photopost photo #######################
function fetch_galleryavatarcache()
{
global $DB_site, $galleryavatarcache;
if (!is_array($galleryavatarcache))
{
$galleryavatarcache = array();
$allgalleryavatars = $DB_site->query("
SELECT pp_photos.id, pp_photos.title, user.userid, pp_photos.cat, pp_photos.approved, pp_photos.bigimage
FROM ppost_photos AS pp_photos
LEFT JOIN " . TABLE_PREFIX ."user AS user ON pp_photos.userid = user.userid
");
while($galleryavatararray = $DB_site->fetch_array($allgalleryavatars))
{
$galleryavatarcache["$galleryavatararray[userid]"] = $galleryavatararray;
}
$DB_site->free_result($allgalleryavatars);
}
}
function fetch_cachedgalleryavatar_url($userid)
{
global $galleryavatarcache, $vboptions, $stylevar;
if(!is_array($galleryavatarcache))
{
fetch_galleryavatarcache();
}
if($galleryavatarinfo = $galleryavatarcache[$userid])
{
if ($galleryavatarinfo[bigimage] && $galleryavatarinfo[cat])
{
return "$vboptions[galleryurl]/data/$galleryavatarinfo[cat]/{$userid}".substr($galleryavatarinfo[bigimage], 0, -4)."-thumb.".file_extension($galleryavatarinfo[bigimage]);
}
else
{
return "$stylevar[imgdir_misc]/noavatar.gif";
}
}
return FALSE;
}
now in your showthread.php find
$post['musername'] = fetch_musername($post);
$post['islastshown'] = ($post['postid'] == $lastpostid);
$post['attachments'] = &$postattach["$post[postid]"];
and directly below that add:
$post['galleryavatar'] = fetch_cachedgalleryavatar_url($post[userid]);
now chuck your board into debug mode and add this setting group:
vaname: photopost
title: Photopost
vB default: no
now add to that group this option
varname: galleryurl
title: Gallery URL
Description: this is the location to your photopost installation (no trailing backslash)
Option: [leave this blank]
Default: http://www.domainname.com/directory
vB default: no
now in your postbit template, whereever you want it add
<if condition="$post[galleryavatar]"><a href="$vboption[galleryurl]/showgallery.php?cat=500&ppuser=$post[userid]"><img src="$post[galleryavatar]" border="0" alt="$post[username]'s latest photo" /></a></if>
Damn almost forgot the desciption, erm this hack puts a photo, but not just any photo, your last uploaded photo into your postbit, it's s3x11111!!!!! i think :o.
Ok theirs one question i don't ever ever ever want to see in this thread, unless you're sure you have www.photopost.com's photopost installed, save us all the heartache and just don't do it, be kind, be generous, show me love, but if you aint got photopost installed then what's the point in saying "it don't show the photo for me" it's bound not to :( oh and for people who are going to ask "can you do it for the vB photo" nope i'm afraid i've never tried :(
ok after that little bit i should say something cool, like screenshots are not present since i have no desire to install this as is, no wait that sucked, however if anyone would like to provide screenies, you're welcome yay.
Damn is their nothing else i can waste your time with, surely you have no better to do than read my garbage, guess not, oh well it's an easy installation, i estimates 3.75 minutes, 2 files edits, one template mod, 1 vB option group and a setting to fill it.
big thanks to natch without him it would've been impossible and thanks to dean c (mist) too who got me through the final stages like a lucazade during a marathon.
* sabret00the does cool guy pose
have fun with it. :p :)
Query Load: beleive it or not, from the dungeon of super sucky coders this came and only adds one query to the showthread, i'm not even lying, wow, well that's what the microstats said, so if i was wrong blame Neo, he's obviously misalligned the matrix.
think i covered everything now :)
in your includes/functions_showthread.php find
// ###################### Start process_highlight_postbit #######################
function process_highlight_postbit($text, $words, $prepend)
above that add
// ###################### Start last photopost photo #######################
function fetch_galleryavatarcache()
{
global $DB_site, $galleryavatarcache;
if (!is_array($galleryavatarcache))
{
$galleryavatarcache = array();
$allgalleryavatars = $DB_site->query("
SELECT pp_photos.id, pp_photos.title, user.userid, pp_photos.cat, pp_photos.approved, pp_photos.bigimage
FROM ppost_photos AS pp_photos
LEFT JOIN " . TABLE_PREFIX ."user AS user ON pp_photos.userid = user.userid
");
while($galleryavatararray = $DB_site->fetch_array($allgalleryavatars))
{
$galleryavatarcache["$galleryavatararray[userid]"] = $galleryavatararray;
}
$DB_site->free_result($allgalleryavatars);
}
}
function fetch_cachedgalleryavatar_url($userid)
{
global $galleryavatarcache, $vboptions, $stylevar;
if(!is_array($galleryavatarcache))
{
fetch_galleryavatarcache();
}
if($galleryavatarinfo = $galleryavatarcache[$userid])
{
if ($galleryavatarinfo[bigimage] && $galleryavatarinfo[cat])
{
return "$vboptions[galleryurl]/data/$galleryavatarinfo[cat]/{$userid}".substr($galleryavatarinfo[bigimage], 0, -4)."-thumb.".file_extension($galleryavatarinfo[bigimage]);
}
else
{
return "$stylevar[imgdir_misc]/noavatar.gif";
}
}
return FALSE;
}
now in your showthread.php find
$post['musername'] = fetch_musername($post);
$post['islastshown'] = ($post['postid'] == $lastpostid);
$post['attachments'] = &$postattach["$post[postid]"];
and directly below that add:
$post['galleryavatar'] = fetch_cachedgalleryavatar_url($post[userid]);
now chuck your board into debug mode and add this setting group:
vaname: photopost
title: Photopost
vB default: no
now add to that group this option
varname: galleryurl
title: Gallery URL
Description: this is the location to your photopost installation (no trailing backslash)
Option: [leave this blank]
Default: http://www.domainname.com/directory
vB default: no
now in your postbit template, whereever you want it add
<if condition="$post[galleryavatar]"><a href="$vboption[galleryurl]/showgallery.php?cat=500&ppuser=$post[userid]"><img src="$post[galleryavatar]" border="0" alt="$post[username]'s latest photo" /></a></if>