[MOD Req] Members favorite links - Profile

[mawenzi]

... for 3 links per user ... you need 6 extra fields ...
... "link_url_1",  "link_url_2", "link_url_3" and "link_name_1", "link_name_2",  "link_name_3"...

[Lucifix]

Got it, here is the code.

Code: [Select]

// ----------
// User Links
// ----------
$sql = "SELECT *
FROM 4images_users
WHERE user_id = ".$user_row['user_id']."";

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

    while ($row = $site_db->fetch_array($result)){
$user_link_name1 = ($row['user_link_name1']);
$user_link_url1 = ($row['user_link_url1']);

$user_link_name2 = ($row['user_link_name2']);
$user_link_url2 = ($row['user_link_url2']);

$user_link_name3 = ($row['user_link_name3']);
$user_link_url3 = ($row['user_link_url3']);

if ($num_rows > 1) {
$br = "<br>";
}

 if (!empty($user_link_name1)) {
$flink1 = format_url($user_link_url1);
$user_links .= "<img src=\"/themes/ExtraLite/images/li-point.gif\"><a href=\"$flink1\" target=\"_blank\">$user_link_name1</a> $br";
}

 if (!empty($user_link_name2)) {
$flink2 = format_url($user_link_url2);
$user_links .= "<img src=\"/themes/ExtraLite/images/li-point.gif\"><a href=\"$flink2\" target=\"_blank\">$user_link_name2</a> $br";
}

 if (!empty($user_link_name3)) {
$flink3 = format_url($user_link_url3);
$user_links .= "<img src=\"/themes/ExtraLite/images/li-point.gif\"><a href=\"$flink3\" target=\"_blank\">$user_link_name3</a> $br";
}



$site_template->register_vars(array(
"user_links" => $user_links,
      ));
 
}
// ----------
// End User Links
// ----------
If you think that you can do some modifications please let me know. Thx!

[thunderstrike]

// ----------
// User Links
// ----------
$sql = "SELECT *
   FROM 4images_users
   WHERE user_id = ".$user_row['user_id']."";

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

    while ($row = $site_db->fetch_array($result)){
$user_link_name1 = ($row['user_link_name1']);
$user_link_url1 = ($row['user_link_url1']);

$user_link_name2 = ($row['user_link_name2']);
$user_link_url2 = ($row['user_link_url2']);

$user_link_name3 = ($row['user_link_name3']);
$user_link_url3 = ($row['user_link_url3']);

if ($num_rows > 1) {
$br = "<br>";
}

All this - no need. Jan program includes/sessions.php file for $user_info['user_id'].

but this time - change for:

Code: [Select]

// ----------
// User Links
// ----------
$additional_sql = "";
if (isset($additional_user_fields) && is_array($additional_user_fields) && !empty($additional_user_fields)) {
foreach ($additional_user_fields as $key => $val) {
$additional_sql = ", " . $key;
}
}

$sql = "

SELECT " . $additional_sql . "
FROM " . USERS_TABLE . "
WHERE " . get_user_table_field("", "user_id") . " = " . $user_info['user_id'];

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

$link_row = array();
  while ($row = $site_db->fetch_array($result)) {
    $link_row[] = $row;
  }
  $site_db->free_result($result);
  $num_links = sizeof($link_row);

if (!$num_links) {
    $user_links = $lang['no_links'];
  }
  else {
    $user_links = "";
    $br = "<br />";   
    for ($i = 0; $i < $num_comments; $i++) {

$user_link_name = $link_row['user_link_name'.[$i]];
$user_link_url = $link_row['user_link_url'.[$i]];

if (isset($user_link_name) && !empty($user_link_name) && isset($user_link_url) && !empty($user_link_url)) {
$flink[$i] = format_url($user_link_url);
$user_links .= "<img src=\"/themes/ExtraLite/images/li-point.gif\"><a href=\"".$flink[$i]."\" target=\"_blank\">" . $user_link_name . "</a>" .$br;
}
}
}

$site_template->register_vars(array(
   "user_links" => (isset($user_links)) ? trim($user_links) : "",
));

Then, in lang/your_lang/main.php file, add top of ?>:

Code: [Select]

$lang['no_links'] = "No links";


[Lucifix]

@thunderstrike:

there are some errors in this code. Right now I don't have time to correct them, but I'll try later.

1st one:

Code: [Select]

$additional_sql .= ", ", $key; - PHP Parse error: syntax error, unexpected '"' in ...

[thunderstrike]

Replace:

$additional_sql .= ", ", $key;

for:

$additional_sql .= ", " . $key;