Author Topic: Featured Member Block (Read 22236 times)

Nabil · « **Reply #20 on:** January 04, 2009, 01:24:38 PM »

ok , I'm gonna make an update to solve that external links avatar problem

Nabil · « **Reply #21 on:** January 04, 2009, 01:57:07 PM »

There is no need for an update , the Avatars also will display if the user uses an external link to the Avatar because the Avatar will be saved as if someone Uploaded the Avatar , so the Avatar from an external link will be displayed as well isnt it ?

dougsbrat · « **Reply #22 on:** January 04, 2009, 02:18:50 PM »

I changed my avatar to a link to a image from my other web page...
it does not show

Nabil · « **Reply #23 on:** January 04, 2009, 02:44:36 PM »

Quote

I changed my avatar to a link to a image from my other web page...
it does not show

This is Strange !! , I have also made a test , but the result was ok , the Avatar displayed .. what do you see when you make a right mouse click on the Avatar , which properties (url addresse ?) I mean for an external link Avatar?

Nabil · « **Reply #24 on:** January 04, 2009, 04:04:42 PM »

I seeeeeeeeeeeeeeeeeeeeeee , you have not checked this thats why , see the photo

ok I will make an update

dougsbrat · « **Reply #25 on:** January 04, 2009, 04:34:04 PM »

Quote from: Nabil on January 04, 2009, 04:04:42 PM

I seeeeeeeeeeeeeeeeeeeeeee , you have not checked this thats why , see the photo

ok I will make an update

you are correct... mine looks like that

Nabil · « **Reply #26 on:** January 04, 2009, 04:44:36 PM »

So this Code will solve all Avatars problems :

Code: [Select]

<?php
global $settings;

/////////// FINDING HOW MANY Members in the Forum //////////////////
$query = mysql_query("SELECT * FROM smf_members"); 
$numberOfMembers=mysql_num_rows($query); 



/////////// SELECT A MEMBER ////////////

$randomMember=rand(1,$numberOfMembers); 
$ask=mysql_query("SELECT * FROM smf_members order by rand() limit 1");
$row = mysql_fetch_array($ask, MYSQL_ASSOC) or die (mysql_error());
$idmember1=$row[ID_MEMBER]; // Member ID
$memberName1=$row[memberName]; // Member Name
$group1=$row[ID_GROUP]; // Member Group ID
$avatarin=$row[avatar];

$postgroup1=$row[ID_POST_GROUP]; // Post Group
$gender1=$row[gender];
$lastlogin1=$row[lastLogin]; 
if ($lastlogin1!=0){ $datelog1=date("d.M.Y H:i",$lastlogin1); } 
else {
$datelog1=''; 
};
$dateReg1=$row[dateRegistered]; $dateform =date("d.M.Y H:i",$dateReg1);
$birthdate1=$row[birthdate]; if ($birthdate1=='0001-01-01'){$birthdate1=''; };
$location1=$row[location];
$post1=$row[posts]; // How Many Posts

if ($group1!='0'){
$ask=mysql_query("SELECT groupName, stars FROM smf_membergroups WHERE ID_GROUP='$group1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$groupName1=$row[groupName]; // Group Name
$star1=$row[stars]; // How many Stars
};

$ask=mysql_query("SELECT groupName, stars FROM smf_membergroups WHERE ID_GROUP='$postgroup1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$postgroup2=$row[groupName];
if ($star1==''){$star1=$row[stars]; };

// is the Member Online //////////////
$query = mysql_query("SELECT * FROM smf_log_online"); 
$numberOfRows=mysql_num_rows($query); 
$imagepath1=$settings['images_url'];
if ($numberOfRows>0){
$ask=mysql_query("SELECT ip FROM smf_log_online WHERE ID_MEMBER='$idmember1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$conline1=$row[ip]; 
};
/////////// how many Stars ////////////////////
$imagepath1=$settings['images_url'];
list($ngif,$gifn)=explode("#",$star1);
//////////////////////////////////////////////

///////////// Get The Avatar /////////////
if ($avatarin==''){
$ask=mysql_query("SELECT filename, ID_ATTACH FROM smf_attachments WHERE ID_MEMBER='$idmember1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$avatar1=$row[filename]; $idattach1=$row[ID_ATTACH];
}
///////////// displaying the infos //////////////// 
echo "<div align='center'>";
echo "<b>$memberName1</b>"."<br>";
if ($groupName1!='') { echo "<b>$groupName1</b><br>"; };
echo "<b>$postgroup2</b><br>";
echo "<div style='margin:5px'>";
for ($i=0; $i<$ngif; $i+=1){
echo "<img src='$imagepath1/$gifn' border='0'>";
};
echo "</div>";
if ($conline1!=''){
echo "<img src='$imagepath1/useron.gif' border='0' style='margin:5px'><br>"; } else {
echo "<img src='$imagepath1/useroff.gif' border='0' style='margin:5px'><br>";
}


if ($gender!=''){ echo "<b>Gender:</b> ".$gender1."<br>"; };
if ($datelog1==''){ $datelog1='Never'; };
echo "<b>Last Active:</b><br>".$datelog1."<br>"; 
echo "<b>Date Registered:</b><br>".$dateform."<br>";
if ($birthdate1!='') { echo "<b>Date of Birth:</b><br>".$birthdate1."<br>"; };
if ($location1!='') { echo "<b>Location:</b><br>".$location1."<br>"; };
echo "<b>Posts:</b> ".$post1."<br>";

if ($avatarin!=''){
$checkavatar1=preg_match('/http:\/\//',$avatarin);
if ($checkavatar1){ 
echo "<img src='$avatarin' border='0' style='margin:5px'><br>";
} else {
echo "<img src='avatars/$avatarin' border='0' style='margin:5px'><br>";
}
};
if ($avatar1!=''){
echo "<img src='index.php?action=dlattach;attach=$idattach1;type=avatar' border='0' style='margin:5px'><br>";
};
echo "</div>";


?>

dougsbrat · « **Reply #27 on:** January 04, 2009, 05:07:44 PM »

Perfect!

if some one wants this with the avatar on top use this one

Code: [Select]

<?php

global $settings;

/////////// FINDING HOW MANY Members in the Forum //////////////////
$query = mysql_query("SELECT * FROM smf_members"); 
$numberOfMembers=mysql_num_rows($query); 



/////////// SELECT A MEMBER ////////////

$randomMember=rand(1,$numberOfMembers); 
$ask=mysql_query("SELECT * FROM smf_members order by rand() limit 1");
$row = mysql_fetch_array($ask, MYSQL_ASSOC) or die (mysql_error());
$idmember1=$row[ID_MEMBER]; // Member ID
$memberName1=$row[memberName]; // Member Name
$group1=$row[ID_GROUP]; // Member Group ID
$avatarin=$row[avatar];

$postgroup1=$row[ID_POST_GROUP]; // Post Group
$gender1=$row[gender];
$lastlogin1=$row[lastLogin]; 
if ($lastlogin1!=0){ $datelog1=date("d.M.Y H:i",$lastlogin1); } 
else {
$datelog1=''; 
};
$dateReg1=$row[dateRegistered]; $dateform =date("d.M.Y H:i",$dateReg1);
$birthdate1=$row[birthdate]; if ($birthdate1=='0001-01-01'){$birthdate1=''; };
$location1=$row[location];
$post1=$row[posts]; // How Many Posts

if ($group1!='0'){
$ask=mysql_query("SELECT groupName, stars FROM smf_membergroups WHERE ID_GROUP='$group1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$groupName1=$row[groupName]; // Group Name
$star1=$row[stars]; // How many Stars
};

$ask=mysql_query("SELECT groupName, stars FROM smf_membergroups WHERE ID_GROUP='$postgroup1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$postgroup2=$row[groupName];
if ($star1==''){$star1=$row[stars]; };

// is the Member Online //////////////
$query = mysql_query("SELECT * FROM smf_log_online"); 
$numberOfRows=mysql_num_rows($query); 
$imagepath1=$settings['images_url'];
if ($numberOfRows>0){
$ask=mysql_query("SELECT ip FROM smf_log_online WHERE ID_MEMBER='$idmember1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$conline1=$row[ip]; 
};
/////////// how many Stars ////////////////////
$imagepath1=$settings['images_url'];
list($ngif,$gifn)=explode("#",$star1);
//////////////////////////////////////////////

///////////// Get The Avatar /////////////
if ($avatarin==''){
$ask=mysql_query("SELECT filename, ID_ATTACH FROM smf_attachments WHERE ID_MEMBER='$idmember1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$avatar1=$row[filename]; $idattach1=$row[ID_ATTACH];
}
///////////// displaying the infos //////////////// 
echo "<div align='center'>";

if ($avatarin!=''){
$checkavatar1=preg_match('/http:\/\//',$avatarin);
if ($checkavatar1){ 
echo "<img src='$avatarin' border='0' style='margin:5px'><br>";
} else {
echo "<img src='avatars/$avatarin' border='0' style='margin:5px'><br>";
}
};
if ($avatar1!=''){
echo "<img src='index.php?action=dlattach;attach=$idattach1;type=avatar' border='0' style='margin:5px'><br>";
};

echo "<b>$memberName1</b>"."<br>";
if ($groupName1!='') { echo "<b>$groupName1</b><br>"; };
echo "<b>$postgroup2</b><br>";
echo "<div style='margin:5px'>";
for ($i=0; $i<$ngif; $i+=1){
echo "<img src='$imagepath1/$gifn' border='0'>";
};
echo "</div>";
if ($conline1!=''){
echo "<img src='$imagepath1/useron.gif' border='0' style='margin:5px'><br>"; } else {
echo "<img src='$imagepath1/useroff.gif' border='0' style='margin:5px'><br>";
}


if ($gender!=''){ echo "<b>Gender:</b> ".$gender1."<br>"; };
if ($datelog1==''){ $datelog1='Never'; };
echo "<b>Last Active:</b><br>".$datelog1."<br>"; 
echo "<b>Date Registered:</b><br>".$dateform."<br>";
if ($birthdate1!='') { echo "<b>Date of Birth:</b><br>".$birthdate1."<br>"; };
if ($location1!='') { echo "<b>Location:</b><br>".$location1."<br>"; };
echo "<b>Posts:</b> ".$post1."<br>";

echo "</div>";

?>

(for new users)
1. create a new PHP block
2. copy the code
3. paste into the block (exclude the first and last line)
4. enjoy

Nabil gets all the credit, THANKS!

bmac · « **Reply #28 on:** January 05, 2009, 12:42:18 AM »

Works great, thanks for the hard work on this.

One question, Is there any way to modify the code to only show members with over "X" number of posts? ..... possibly 25, 50 or 100 or something.

Nabil · « **Reply #29 on:** January 05, 2009, 05:20:13 AM »

Quote

One question, Is there any way to modify the code to only show members with over "X" number of posts? ..... possibly 25, 50 or 100 or something.

of course this is possible ,how about selecting a Member (not Randomly) but according to posts (let say from 50 on ) you decide how many posts , every day a Member you can call the block (Member of the day) but as I said not every Member only choosing from Members that have made a minimum number of posts , all Visitors of your forum will see the same Member (unlike a Random function where every visitor sees another Member).
every day a Member is displayed one after the other and when all Members with that minimum Posts are displayed , then will start from the begining this could take maybe months according to how many Members with that minimum amount of posts and (those who reach recently this minimum Number ) will also be considered every day , how about that?

Burke Knight · « **Reply #30 on:** January 05, 2009, 08:01:41 AM »

More viable way, I think, would be setting it by member ID #. Not have it random, so the admin can set up maybe a member of the week, or month.

Also, is this for 1.1.7 or 2.0 Beta 4?

bmac · « **Reply #31 on:** January 05, 2009, 09:56:58 AM »

Quote

Also, is this for 1.1.7

I'm running 1.1.7. I'm not great at this coding stuff, but would appreciate any help you guys could provide. I love the idea of member of the week or month. Exactly what I'm looking for.

Brian

dougsbrat · « **Reply #32 on:** January 05, 2009, 01:08:45 PM »

I use 1.1.7

looks like the random code would be removed and add a line of code to set the member # to use

ie
MOW=23
and the code use that to display

surly we all can change one variable

I would prefer it be a seprate block so ether or both could be used.

dougsbrat · « **Reply #33 on:** January 06, 2009, 10:39:08 AM »

perhaps with just a few lines of code and adding or removing a "/",

you could have:
"member of the moment"(random)
or
"member of the week/month"(designated)

that would be cool

bmac · « **Reply #34 on:** January 06, 2009, 12:27:54 PM »

Quote

perhaps with just a few lines of code and adding or removing a "/",

you could have:
"member of the moment"(random)
or
"member of the week/month"(designated)

that would be coo

Thats what I'm looking for. If it is simple coding as said, I would love some help to figure this out. Like I said, this area is a big weakness of mine. I guess I need to make a better effort to learn this stuff. In the meantime any help is greatly appreciated.

thanks for your guys hard work on this.

dougsbrat · « **Reply #35 on:** January 06, 2009, 03:56:12 PM »

I talked to Nabil about my attempt at adding code...

here is what we came up with

Code: [Select]

<?php

global $settings;

/////////// FINDING HOW MANY Members in the Forum //////////////////
$query = mysql_query("SELECT * FROM smf_members");
$numberOfMembers=mysql_num_rows($query);



/////////// SELECT A MEMBER ////////////

$randomMember=rand(1,$numberOfMembers);
$ask=mysql_query("SELECT * FROM smf_members order by rand() limit 1");

//////  MEMBER SELECT OPTION ////////
/////if you want member # 5 to be used ONY 
////then change the #2 to the number you (want +1)  in this case 6     //
///// add "//" at begining on the next line to use a random member  /////
$ask=mysql_query("SELECT * FROM smf_members LIMIT 2,1");
///// end of member select option /////

$row = mysql_fetch_array($ask, MYSQL_ASSOC) or die (mysql_error());
$idmember1=$row[ID_MEMBER]; // Member ID
$memberName1=$row[memberName]; // Member Name
$group1=$row[ID_GROUP]; // Member Group ID
$avatarin=$row[avatar];

$postgroup1=$row[ID_POST_GROUP]; // Post Group
$gender1=$row[gender];
$lastlogin1=$row[lastLogin];
if ($lastlogin1!=0){ $datelog1=date("d.M.Y H:i",$lastlogin1); }
else {
$datelog1='';
};
$dateReg1=$row[dateRegistered]; $dateform =date("d.M.Y H:i",$dateReg1);
$birthdate1=$row[birthdate]; if ($birthdate1=='0001-01-01'){$birthdate1=''; };
$location1=$row[location];
$post1=$row[posts]; // How Many Posts

if ($group1!='0'){
$ask=mysql_query("SELECT groupName, stars FROM smf_membergroups WHERE ID_GROUP='$group1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$groupName1=$row[groupName]; // Group Name
$star1=$row[stars]; // How many Stars
};

$ask=mysql_query("SELECT groupName, stars FROM smf_membergroups WHERE ID_GROUP='$postgroup1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$postgroup2=$row[groupName];
if ($star1==''){$star1=$row[stars]; };

// is the Member Online //////////////
$query = mysql_query("SELECT * FROM smf_log_online");
$numberOfRows=mysql_num_rows($query);
$imagepath1=$settings['images_url'];
if ($numberOfRows>0){
$ask=mysql_query("SELECT ip FROM smf_log_online WHERE ID_MEMBER='$idmember1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$conline1=$row[ip];
};
/////////// how many Stars ////////////////////
$imagepath1=$settings['images_url'];
list($ngif,$gifn)=explode("#",$star1);
//////////////////////////////////////////////

///////////// Get The Avatar /////////////
if ($avatarin==''){
$ask=mysql_query("SELECT filename, ID_ATTACH FROM smf_attachments WHERE ID_MEMBER='$idmember1'");
$row = mysql_fetch_array($ask, MYSQL_ASSOC);
$avatar1=$row[filename]; $idattach1=$row[ID_ATTACH];
}
///////////// displaying the infos ////////////////
echo "<div align='center'>";

if ($avatarin!=''){
$checkavatar1=preg_match('/http:\/\//',$avatarin);
if ($checkavatar1){
echo "<img src='$avatarin' border='0' style='margin:5px'><br>";
} else {
echo "<img src='avatars/$avatarin' border='0' style='margin:5px'><br>";
}
};
if ($avatar1!=''){
echo "<img src='index.php?action=dlattach;attach=$idattach1;type=avatar' border='0' style='margin:5px'><br>";
};

echo "<b>$memberName1</b>"."<br>";
if ($groupName1!='') { echo "<b>$groupName1</b><br>"; };
echo "<b>$postgroup2</b><br>";
echo "<div style='margin:5px'>";
for ($i=0; $i<$ngif; $i+=1){
echo "<img src='$imagepath1/$gifn' border='0'>";
};
echo "</div>";
if ($conline1!=''){
echo "<img src='$imagepath1/useron.gif' border='0' style='margin:5px'><br>"; } else {
echo "<img src='$imagepath1/useroff.gif' border='0' style='margin:5px'><br>";
}


if ($gender!=''){ echo "<b>Gender:</b> ".$gender1."<br>"; };
if ($datelog1==''){ $datelog1='Never'; };
echo "<b>Last Active:</b><br>".$datelog1."<br>";
echo "<b>Date Registered:</b><br>".$dateform."<br>";
if ($birthdate1!='') { echo "<b>Date of Birth:</b><br>".$birthdate1."<br>"; };
if ($location1!='') { echo "<b>Location:</b><br>".$location1."<br>"; };
echo "<b>Posts:</b> ".$post1."<br>";

echo "</div>";

?>

look at the "member select option" area for the member option and what to change.

bmac · « **Reply #36 on:** January 06, 2009, 10:41:12 PM »

Quote

look at the "member select option" area for the member option and what to change

OK, I tried this and here is what I saw on my portal. It appears that it should be change the # 2 to the number you want +1, not -1. That works on my portal. Also this works fine for 1 or 2 digit userID numbers, but when I try a 3 digit userID number it fails and shows a blank block. Any ideas?

Love it so far, if I could fix the three digit problem I would be very happy. Great work!

Also, how hard would it be to have the username or avatar in this block as a link to the members profile that could be clicked on to go there?

thanks again for your continued hard work on this.

dougsbrat · « **Reply #37 on:** January 06, 2009, 10:51:27 PM »

you are correct +1

I will edit the above posted code info.

-I don't have that many users so I would have not seen this problem (yet).
-and linking would be good too.
hopefully Nabil or another can shed light on this fix

casper · « **Reply #38 on:** January 07, 2009, 12:12:31 AM »

Very nice mod. One request though - I also use SMF Media Gallery 1.5.2 and was wondering if it's possible to include the number of images that the user has uploaded?

bmac · « **Reply #39 on:** January 08, 2009, 07:50:01 PM »

One more question on this, How would I change the font size, color, face etc. ?

Would these be done by CSS or by adding other options to this php code that could be used to modify the look slightly?

I would also like to make a link out of the avatar and user ID.

Any ideas would be helpful.

thanks..Bmac

Simple Portal Archived Forum

User Info

Who's Online

Shoutbox

Team Blog

Recent Posts

Author Topic: Featured Member Block (Read 22236 times)