Photopost "gallery" clickable icon in postbit(_legacy) and/or profiles.

Gone

[funkmeister]

To clarify......in 'gallery.php' do we replace the field id number (field61 in the example below) with whatever our field number is, which is created earlier in the instructions?

$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."userfield SET field61 = 'Yes' WHERE ".TABLE_PREFIX."userfield.userid = $posid AND ".TABLE_PREFIX ."userfield.field61 != 'Yes'");

Thanks in advance.

[Grunt]

Thanks once again Mini - good stuff.

Working in 3.6.4 and PP 5.6.2 (sharing DB and no prefixes on either). I had to modify code a bit. Working code if it helps anyone is:

postbit:

<if condition="$post['field7'] == 'Yes'">
<a href="/gallery/showgallery.php?cat=500&ppuser=$post[userid]" target="_blank">
<img class="inlineimg" src="$stylevar[imgdir_misc]/gallery.gif" alt="View $post[username]'s Gallery" width="19" height="18" border="0" title="View $post[username]'s Gallery" /></a> 
</if>

gallery.php:

<?
////////////////////////////////////////////
//  MAKE SURE YOU EDIT THIS WHERE STATED  //
//  Then upload to /includes/cron/        //
////////////////////////////////////////////
// Edit - Make sure this is correct
define('FILE_VERSION', '3.6.4'); // this should match install.php
error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
 exit;
}
// Edit this line to reflect your database structure
$photo_query=$vbulletin->db->query_read("SELECT userid FROM photos");
while ($inids = $vbulletin->db->fetch_array($photo_query)) {
 $posid = $inids[userid];
 $vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."userfield SET field7 = 'Yes' WHERE ".TABLE_PREFIX."userfield.userid = $posid AND ".TABLE_PREFIX ."userfield.field7 != 'Yes'");
}
log_cron_action("gallery task updated", $nextitem);
?>

[Grunt]

and a different icon

[SherryG]

*Solved*

[atvtrailrider]

Here is the error I am getting when it runs the cron:

> MySQL Error : Access denied for user 'vborforumuser'@'localhost' to database 'photopost'

vborforumuser is set as the "User Database User" in my photopost config. I think the task needs to use my "PhotoPost Database User" instead. How do I get the task to run as a different user?

Suggestions?

[Doug Nelson]

Has this been updated for 3.6.5?

[Doug Nelson]

That would be a "no"?

[PEPITO69]

Is it possible to make the same with reviewpost? showing the reviews of a member.

[sgrynd]

Thanks, great hack - running on 3.7 as well.

For those with the db error, make sure gallery.php is set to use the correct database and table name

[mirzonni]

It works with 3.6.8 after some minor modifications. Excellent hack! Cheers.