Author Topic: Need help, Show random user name on the main page  (Read 10520 times)

0 Members and 1 Guest are viewing this topic.

Offline MrAndrew

  • Sr. Member
  • ****
  • Posts: 302
    • View Profile
    • Aviation PhotoBase
Need help, Show random user name on the main page
« on: June 03, 2010, 02:47:36 AM »
Good Day!

Anyone can help me?

I need to show one or two users name on the main page sort by default every refresh page. Please help me with this..

Thx!

Rembrandt

  • Guest
Re: Need help, Show random user name on the main page
« Reply #1 on: June 18, 2010, 01:22:57 PM »
Hi!

search in index.php:

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------


insert above:

//######################## Start Random Username ################################
$num_random_user 2//how many names, e.g. 2
$sql "SELECT user_id, user_name
        FROM "
.USERS_TABLE.
        ORDER BY RAND()
        LIMIT 
$num_random_user
        "

      
$result $site_db->query($sql);
      
$random_user "";
      while (
$user_row $site_db->fetch_array($result)){
        
$user_profile_link = (!empty($url_show_profile)) ? preg_replace("/{user_id}/"$user_row['user_id'], $url_show_profile) : ROOT_PATH."member.php?action=showprofile&".URL_USER_ID."=".$user_row['user_id'];
        
$random_user .="<p style=\"text-align:center\"><a href=\"".$site_sess->url($user_profile_link)."\">".format_text($user_row[$user_table_fields['user_name']])."</a></p>";
      }
        
$site_template->register_vars("random_user"$random_user);
        unset(
$random_user);
//######################## End Random Username ################################ 


write in your Templates home.html wherever you want:
Code: [Select]
{random_user}
mfg Andi
« Last Edit: October 15, 2010, 06:23:37 PM by Rembrandt »

Offline MrAndrew

  • Sr. Member
  • ****
  • Posts: 302
    • View Profile
    • Aviation PhotoBase
Re: Need help, Show random user name on the main page
« Reply #2 on: July 08, 2010, 03:37:22 PM »
Some corrections for own needs and all works well!! Thanks Rembrandt

Offline fermachado

  • Jr. Member
  • **
  • Posts: 92
    • View Profile
Re: Need help, Show random user name on the main page
« Reply #3 on: October 15, 2010, 05:35:25 PM »
Thanks for this mod :D

I possible show the user pic above the name and work with a link for profile of the user.

Thanks
www.globalfoto.net

Sintra - Portugal

Rembrandt

  • Guest
Re: Need help, Show random user name on the main page
« Reply #4 on: October 15, 2010, 06:27:04 PM »
... show the user pic above the name .....
from which mod?

Quote
...and work with a link for profile of the user.
there was not a problem, i have edit my first post..

mfg Andi

Offline fermachado

  • Jr. Member
  • **
  • Posts: 92
    • View Profile
Re: Need help, Show random user name on the main page
« Reply #5 on: October 15, 2010, 06:45:56 PM »
Thanks my friend!

The link works nice.

The userpic is from the mod of Vano  [MOD] Member personal photo v1.1.2 by V@no (2008-12-11)
 
http://www.4homepages.de/forum/index.php?topic=6797.msg29716#msg29716
www.globalfoto.net

Sintra - Portugal

Rembrandt

  • Guest
Re: Need help, Show random user name on the main page
« Reply #6 on: October 15, 2010, 07:02:46 PM »

Offline fermachado

  • Jr. Member
  • **
  • Posts: 92
    • View Profile
Re: Need help, Show random user name on the main page
« Reply #7 on: October 15, 2010, 07:25:42 PM »
Thanks,

Sorry the question.But how i can show the result in the home.html of the code from step1 :?

Code: [Select]
//--------------------------------------
//--- Random Userpic Images ------------
//--------------------------------------

$sql = "

SELECT DISTINCT ".get_user_table_field("", "user_id"). get_user_table_field(", ", "user_name"). get_user_table_field(", ", "user_level").", userpic
FROM ".USERS_TABLE."
WHERE ".get_user_table_field("", "user_level")." >= '".USER."'
ORDER BY RAND()
LIMIT 1

";

$result = $site_db->query($sql);

if (!$result) {

$userpic_img = $lang['no_random_userpic'];

} else {

while ($row = $site_db->fetch_array($result)) {

$userpic_img = ($config['userpic'] && @file_exists(ROOT_PATH."data/userpic/".$row['userpic']) && $user_info['user_level'] >= USER) ? "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&amp;".URL_USER_ID."=".$row['user_id']."&user_name=".$row['user_name'])."\"><img src=\"".ROOT_PATH."data/userpic/".$row['userpic']."\" width=\"".$config['userpic_width']."\" height=\"".$config['userpic_height']."\" border=\"0\"></a>" : $lang['no_random_userpic'];
$user_name = ($config['userpic'] && @file_exists(ROOT_PATH."data/userpic/".$row['userpic']) && $user_info['user_level'] >= USER) ? "<br /><a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&amp;".URL_USER_ID."=".$row['user_id']."&user_name=".$row['user_name'])."\">".$row['user_name']."</a>" : "<br /><br /><a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&amp;".URL_USER_ID."=".$row['user_id']."&user_name=".$row['user_name'])."\">".$row['user_name']."</a>";

} ###### End of while statement.

if ($user_info['user_level'] >= USER) {

$site_template->register_vars(array(
"user_name" => $user_name,
"userpic_img" => $userpic_img,
"lang_no_random_userpic" => $lang['no_random_userpic'],
"lang_random_userpic_images_title" => $lang['random_userpic_images_title']
));
} ###### End of if statement.
} ###### End of if statement.

unset ($userpic_img);
unset ($user_name);

www.globalfoto.net

Sintra - Portugal

Rembrandt

  • Guest
Re: Need help, Show random user name on the main page
« Reply #8 on: October 15, 2010, 07:30:34 PM »
step 2.) and step 3.) from @oracles mod

Offline fermachado

  • Jr. Member
  • **
  • Posts: 92
    • View Profile
Re: Need help, Show random user name on the main page
« Reply #9 on: October 16, 2010, 09:27:28 AM »
Hi,

Thanks a lot.

 My fault!! You talk about step 1 and I not read more. :oops:

Works fine,

Thanks
www.globalfoto.net

Sintra - Portugal

 

Post your comments here