Latest Profile Photos

[wilsy]

Hi G6,

You know I would never disagree with you, I just didn't think there was much interest in this one thats all and I'd already answered Alex (literally!) over at SMF.

Heres the code:

Code Select Expand

global $db_prefix, $modSettings, $scripturl;

// Settings
$member_gender = 'female'; // male or female
$num_pictures = 99; // x of thumbnails to display
$order_by = 'latest'; // random or latest


$gender = ($member_gender == 'male') ? '1' : '2';
$order = ($order_by == 'random') ? 'RAND()' : 'p.time DESC';

$sql = db_query ('SELECT p.ID_PICTURE, p.ID_MEMBER, p.title, p.time, p.filename, m.realName
FROM ' . $db_prefix . 'profile_pictures AS p, ' . $db_prefix . 'members AS m
WHERE
p.ID_MEMBER = m.ID_MEMBER AND
m.gender = ' . $gender . '
ORDER BY ' . $order . '
LIMIT ' . $num_pictures, __FILE__, __LINE__);


$data = array();
while ($row = mysql_fetch_assoc ($sql)) {
$data[] = array (
'title' => $row['title'],
'thumb' => $modSettings['profile_pictures_url'] . '/' . $row['ID_MEMBER'] . '_' . $row['time'] . '_thumb.' . substr (strrchr ($row['filename'], '.'), 1),
'url' => $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . ';sa=pictures;view=' . $row['ID_PICTURE'],
'time' => timeformat ($row['time']),
'user' => $row['realName'],
'profile' => $scripturl . '?action=profile;u=' . $row['ID_MEMBER'],
);
}

echo '
<DIV ALIGN="CENTER">
<table width="90%">
<tr>';
foreach ($data as $picture)
{
echo '
<a href="', $picture['url'] ,'"><img src="' . $picture['thumb'] . '" alt="" width="65" height="65" /></a>
';

}
echo '
</tr>
</table></div>';

Regards,

Wilsy.

[Zetan]

I must say, the site looks great.  :up:

Persistent maybe.. but the additions you have incorporated make for an excellent social site.

[wilsy]

Hi ZTN,

Yes, persistent sums it up pretty well

It's frustrating when you want to achieve so much yet simply dont have the skills to carry out the tasks

Regards,

Wilsy.

[Zetan]

That maybe so, but what have you learnt in the process?
Have you been professionally trained in website design? code?
I doubt it.

Taken 2+ years out to study it?
I doubt it.

Are you likely to? Probably not.


Thats pretty much what it takes.


I never became an electrcian by waking up one day knowing how to.. I studied hard for several years and began by thinking I knew what I was talking about.. when in reality, I didn't know donkey about it.

[Reality12]

you know, i ran over to SMF as soon as you said you responded there! :laugh:

found that response and got to working on it immediately!

i do have to say it works awesome!

...and your site looks f'in great! 

[eline]

Hi wilsy
I just take a look on Yours website, its looks/have feaures like I would like to have on my web. All is clear just I dont know how did You solve Promo Girl Profile on right block?

any tips ?

regards

[wilsy]

Its a bit off topic and I know we will be shouted at here but please bear in mind that its my helpful nature that always gets me in trouble 

This is what I have for the promo girls block (php box)

Code Select Expand

$banners = array (
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=641"><img src="http://rewindlancs.com/forum/images/promos/isla_promo1.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=641"><img src="http://rewindlancs.com/forum/images/promos/isla_promo2.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo1.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo2.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo3.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo4.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo5.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo6.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo7.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo9.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo10.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo11.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=50"><img src="http://rewindlancs.com/forum/images/promos/sami_promo12.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=604"><img src="http://rewindlancs.com/forum/images/promos/katie_promo1.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=604"><img src="http://rewindlancs.com/forum/images/promos/katie_promo2.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=604"><img src="http://rewindlancs.com/forum/images/promos/katie_promo3.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=604"><img src="http://rewindlancs.com/forum/images/promos/katie_promo4.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=394"><img src="http://rewindlancs.com/forum/images/promos/emzi_promo1.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=394"><img src="http://rewindlancs.com/forum/images/promos/emzi_promo2.jpg"></a>',
'<div align="center"><a href="http://rewindlancs.com/forum/index.php?action=profile;u=394"><img src="http://rewindlancs.com/forum/images/promos/emzi_promo3.jpg"></a>',


);

shuffle($banners);

echo $banners[0];

You will need to upload your own images and make sure they link to the correct profiles. You will also need to find some great looking girls who are members of your site to agree to you using their photos.

Regards,

Wilsy.

[eline]

hehehe
I expected completly something else
like a new option it ultimate profile - to do a PROMO on profile
Tx a lot Wilsy - I will try Catch You via Your website to talk more.

[forummaker]

Question for you, I'm sure its an easy do for you. Instead of the pics showing in a row, how do I have them display in a column? And I only want the 5 most recent to display. Thanks in advance.

RemedyDog Forums
Where dogs would go if they could talk

[Angelotus]

Hi, which code do I have to use to show the album of the logged in user on the frontpage?
(Similar to the idea of the favorites: http://www.tinyportal.net/index.php?topic=23687.0 )