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

Gone

[Doha Services]

Nice

[bada_bing]

Will test tomorrow

[b6gm6n]

cheers, lovely mod

-b6

[b6gm6n]

Not mentioned in the instructions (with zip) about altering the query for your database, please explain the query to us

$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 field6 = 'Yes' WHERE ".TABLE_PREFIX."userfield.userid = $posid AND ".TABLE_PREFIX ."userfield.field6 != 'Yes'");
}

<- thats mine, no photopost field prefix and is "userfield.field6" corresponding to the id of the new profile field or what?, ( was set to userfield.field61 ) ive run the cron with no errors, i suppose we have to update thread information or any update counters also before anything shows, besides running the cron...? as yet nothing for me showing... unless i remove the if statement "<if condition="$post['6'] == 'Yes'">"

and what this ? > ../gallery/showgallery.php/cat/500/ppuser/$post[userid]

/cat/500/ppuser? your using search engine friendly, im not...

?cat=500&ppuser=$post[userid]
(for me)

-b6

[scottct1]

Not sure why mine is not working...

My pp database is in the same one I use for vbulletin not a seperate database.

Here is my gallery.php file. My custom field is feild8.

If I go into my database (database name is satellit_vb) and go to the userfield I can input Yes in field 8 and then it shows up, so this shows me it is not looking at the photopost database correctly.

Any ideas?

<?
////////////////////////////////////////////
//  MAKE SURE YOU EDIT THIS WHERE STATED  //
//  Then upload to /includes/cron/        //
////////////////////////////////////////////

// Edit - Make sure this is correct
define('FILE_VERSION', '3.5.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 pp_photos");

while ($inids = $vbulletin->db->fetch_array($photo_query)) {
	$posid = $inids[userid];
	$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."userfield SET field8 = 'Yes' WHERE ".TABLE_PREFIX."userfield.userid = $posid AND ".TABLE_PREFIX ."userfield.field8 != 'Yes'");
}

log_cron_action("gallery task updated", $nextitem);
?>

[scottct1]

Yes that works well thank you!

[KBowers]

I'm trying to get this to work, but I'm getting the following error messages:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT userid FROM mustangg_photopost.pp_photos;

MySQL Error : Access denied for user 'mustangg_bowers'@'%' to database 'mustangg_photopost'
Error Number : 1044
Date : Monday, May 8th 2006 @ 04:30:20 PM
Script : http://www.mustanggt.org/forums/cron.php?&rand=503085
Referrer : http://www.mustanggt.org/forums/showthread.php?t=41439
IP Address : 69.117.185.102
Username : Unregistered
Classname : vb_database

I'm assuming I'm getting this error message because I have my photopost database separate from my vbulletin database (and it requires different users - mustangg_bowers is the user for my vbulletin database and mustangg_bowers1 is the user for my photopost database). Is there anyway around this??

Help! :bunny: Thanks!

[KBowers]

Originally Posted by mini2

I'm not sure if you can use other username/passwords using the vbulletin mysql functions, I'll have a look at this though and report back.

The separate databases and different usernames have not been an issue with anything else I have done on my vBulletin board and Photopost gallery. This is the first time I've run into problems with it... I've already done numerous mods without issues.

vBulletin board - http://www.mustanggt.org/forums/index.php

Photopost gallery - http://www.mustanggt.org/photopost/index.php

Thanks.

[KBowers]

Originally Posted by mini2

If you could provide a link to the hack you use to display the images on your forum homepage that could help me.

Thanks.

Here you go... http://www.photopost.com/forum/showthread.php?t=121970

Thanks!