Dating Website Support Forum - Webscribble

How can I get the username or login to appear on the featured profiles instead of the profile name?

Gary

open the file in

engine/pages/index.php

near line 24 find this code...

Code: Select all

if($featured_nophoto)
      {
         $search_query = "SELECT *, p.id, p.gender, p.name FROM (dt_profile p, dt_members m, dt_privacy pr) LEFT JOIN dt_photos f ON p.member_id = f.member_id WHERE (p.status='1' AND (pr.featured_yn IS NULL OR pr.featured_yn='') AND pr.member_id=m.id AND p.member_id=m.id AND p.gender='$genders[name]') ";
      }
      else
      {
         $search_query = "SELECT p.id, p.gender, p.name, p.general_info, m.age, f.filename_1 FROM (dt_profile p, dt_photos f, dt_members m, dt_privacy pr) WHERE (p.status='1' AND (pr.featured_yn IS NULL OR pr.featured_yn='') AND pr.member_id=m.id AND p.member_id=m.id AND f.member_id=m.id AND f.filename_1<>'' AND p.gender='$genders[name]') ";
      }

change p.name to m.name in both the lines and you are done... this changed it from the profile name (which is the headline) to the member name...

Paul

Thanks Paul that helped. I wanted user login. Instead of just replacing the p to m I also replaced name to login and worked great.

Gary