[BETA] Coppermine Latest Pics In Profile 0.0.3

[RMcGirr83]

That's a bug which I just verified.

[RMcGirr83]

and another

General Error Message:

Could not obtain picture information<br /><br /><b><u>DEBUG MODE</u></b><br /><br />SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2<br /><br />SELECT pid FROM cpg135_pictures
WHERE aid = </br /><br />Line : 723<br />File : usercp_viewprofile.php

code

Code: Select all

$sql = "SELECT p.filename, p.filepath, p.aid, p.pid, p.title as p_title, p.caption, p.pic_rating, p.ctime, a.* FROM " . PICTURES_TABLE . " p, " . ALBUMS_TABLE . " a
WHERE a.aid = p.aid

[Joe Belmaati]

and another

General Error Message:

Could not obtain picture information<br /><br /><b><u>DEBUG MODE</u></b><br /><br />SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2<br /><br />SELECT pid FROM cpg135_pictures
WHERE aid = </br /><br />Line : 723<br />File : usercp_viewprofile.php

code

Code: Select all

$sql = "SELECT p.filename, p.filepath, p.aid, p.pid, p.title as p_title, p.caption, p.pic_rating, p.ctime, a.* FROM " . PICTURES_TABLE . " p, " . ALBUMS_TABLE . " a
WHERE a.aid = p.aid

That's not where that error is produced.

Code: Select all

WHERE aid = $albumid";

...I am wondering why the album_id might be empty. The pic has to be in one album or another. Can you send me a link to that page?

As for the sorting order being off that one stumps me a bit as well. That said, the CPG method of placing pictures into chronological position is bizarre and extremely in-efficient. My code tries to work around this fact, but who knows what kind of anomalies may creep in.

[RMcGirr83]

I have initiated the test users account

user: test
password: test

the users it seems to be effecting have one or two pics in their album in coppermine

[RMcGirr83]

Never mind I overwrote the code I had with that in the download and all seems to be working fine.

[z28cave]

Never mind I overwrote the code I had with that in the download and all seems to be working fine.

even the picture order?

[RMcGirr83]

no not the picture order...doesn't seem to be getting the last pic and the issue that you mentioned earlier.

No biggie for me but the mod is not "complete" IMHO (In My Humble Opinion)

[Joe Belmaati]

Is there a pattern to when the order seems to be off? I am not able to reproduce that error on my site.

[JaymeS]

In my case, this is what's happening Joe:
When a Member only has one category Album, the thumbnails on the profile page appear to be linked directly opposed in the order, ie tnail for last post to the first image on the album, tnail for second to last post to the second image uploaded to the album etc. Symmetrically opposed to the intended targets I should say.
This is rather odd Joe as others have stated that there is a switch on the code to obey Descending order.
I disabled registration for a time in case you wish to look at this:

http://illusions-designs.net/phpBB2/index.php

Thanks for your attention,
Jayme

[JaymeS]

Actually I created and account. Better that way, I feel.

Login: guest
Pass: guest

http://illusions-designs.net/phpBB2/

[RMcGirr83]

either the image or the pos is off by one. For example the image with pos=7 is actually (in coppermine) pos=6.

[All4yu.com]

Does it work when the databse isn't the same for PHPBB and COPPERMINE ?

I just installed the mod and nothing happens

[alien13]

No, the idea is the two systems must be integrated.

Joe Belmaati, is there way to make, when the user is not upload any pictures in the gallery, in Profile Page to appear some message, for example - No uploaded pictures. Thanks in advance!

[Joe Belmaati]

Joe Belmaati, is there way to make, when the user is not upload any pictures in the gallery, in Profile Page to appear some message, for example - No uploaded pictures. Thanks in advance!

Easy,

OPEN includes/usercp_viewprofile.php

FIND

Code: Select all

			'WIDTH' => 100/NUM_PICS
		));
	}
}

AFTER, ADD

Code: Select all

else
{
    $template->assign_block_vars('switch_no_pics', array(
    	'L_NO_PICS' =>  sprintf($lang['No_pics'], $profiledata['username'])
    	)
    );
}

OPEN language/lang_english/lang_main.php

FIND

Code: Select all

$lang['Latest_pics'] ='Latest pictures from %s (Files uploaded: %d)';

AFTER, ADD

Code: Select all

$lang['No_pics'] = '<b>%s</b> has not uploaded any pictures yet';

OPEN templates/subSilver/profile_view_body.tpl

FIND

Code: Select all

<!-- BEGIN switch_pics -->

BEFORE, ADD

Code: Select all

<!-- BEGIN switch_no_pics -->
<table width="100%" border="0" cellspacing="1" cellpadding="4" align="center" class="forumline">
	<tr>
		<td class="row1" align="center"><span class="genmed">{switch_no_pics.L_NO_PICS}</span></td>
	</tr>
</table>
<!-- END switch_no_pics -->

.........as for the problem with the thumbnail that points to the wrong pic - I have not been able to replicate the problem and as such, I am finding it hard to remedy the problem.

[alien13]

Thank you for fast reply. It works perfect. I have one more question. I want to show 12 pictures from the gallery. How to make, to show only 4 pictures on line and next 4 pictures to be on new line and last 4 pictures to be on tird line, because now all pictures expand my theme. Example:

| 1 | 2 | 3 | 4 |
| 5 | 6 | 7 | 8 |
| 9 |10 |11 |12|

The numbers are the diffrent pictures.

Thank you in advance!