[BETA] Coppermine Latest Pics In Profile 0.0.3

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Post by RMcGirr83 » Sun Oct 22, 2006 9:57 pm

That's a bug which I just verified. :(

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Post by RMcGirr83 » Mon Oct 23, 2006 9:38 pm

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
Registered User
Posts: 2110
Joined: Sun Sep 28, 2003 7:35 pm
Location: Denmark

Post by Joe Belmaati » Tue Oct 24, 2006 6:16 am

RMcGirr83 wrote: 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.
Image

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Post by RMcGirr83 » Tue Oct 24, 2006 11:36 am

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

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Post by RMcGirr83 » Tue Oct 24, 2006 12:51 pm

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

z28cave
Registered User
Posts: 27
Joined: Thu Feb 09, 2006 1:37 am
Location: Bay Area, CA
Contact:

Post by z28cave » Tue Oct 24, 2006 5:05 pm

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


even the picture order?

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Post by RMcGirr83 » Tue Oct 24, 2006 5:08 pm

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
Registered User
Posts: 2110
Joined: Sun Sep 28, 2003 7:35 pm
Location: Denmark

Post by Joe Belmaati » Fri Oct 27, 2006 7:14 pm

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

JaymeS
Registered User
Posts: 10
Joined: Sat Mar 11, 2006 2:42 pm

Post by JaymeS » Fri Oct 27, 2006 7:57 pm

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
Registered User
Posts: 10
Joined: Sat Mar 11, 2006 2:42 pm

Post by JaymeS » Fri Oct 27, 2006 8:11 pm

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

Login: guest
Pass: guest

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

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Post by RMcGirr83 » Fri Oct 27, 2006 9:24 pm

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
Registered User
Posts: 8
Joined: Sat Jul 30, 2005 7:36 am
Location: Paris, France
Contact:

Post by All4yu.com » Sat Nov 11, 2006 4:39 pm

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

I just installed the mod and nothing happens :-(

alien13
Registered User
Posts: 40
Joined: Sun Oct 30, 2005 3:43 pm

Post by alien13 » Wed Dec 06, 2006 3:58 pm

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
Registered User
Posts: 2110
Joined: Sun Sep 28, 2003 7:35 pm
Location: Denmark

Post by Joe Belmaati » Wed Dec 06, 2006 4:29 pm

alien13 wrote: 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.
Image

alien13
Registered User
Posts: 40
Joined: Sun Oct 30, 2005 3:43 pm

Post by alien13 » Wed Dec 06, 2006 6:53 pm

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!

Post Reply

Return to “[2.0.x] MODs in Development”