" & chr(13)
strRet = strRet & "" & chr(13)
strRet = strRet & "" & chr(13)
strRet = strRet & "" & chr(13)
'photos
rs1.Open "SELECT Photo, Priority FROM tbl_userphotos WHERE user_id_fk=" & rs("User_ID_fK") & " and priority=1 and approval='A'",cn,3,1
if not (rs1.BOF or rs1.EOF) then
strRet = strRet & " & ") "
strRet = strRet & " Enlarge | " & chr(13)
else
strRet = strRet & " Request Photo | " & chr(13)
end if
rs1.Close
set RSs2 = server.CreateObject("ADODB.Recordset")
rss2.Open "SELECT * from tbl_user WHERE user_id_pk=" & rs("User_ID_fK") & " ",cn,3,1
if not (rss2.BOF or rss2.EOF) then
strRet = strRet & " " & rss2("username") & " | " & chr(13)
end if
strRet = strRet & ""
if rs("ShortDescription")<>"" then
dim spccnt,icut,strSDesc,strSDesc1
icut = 1
spccnt = 1
strSDesc = rs("ShortDescription")
strSDesc1 = ""
for icut = 1 to len(strSDesc)
if mid(strSDesc,icut,1)=" " then
if spccnt=33 then
strSDesc1 = strSDesc1 & " "
spccnt = 1
else
spccnt = 1
end if
else
if spccnt=33 then
strSDesc1 = strSDesc1 & " "
'strSDesc1 = mid(strSDesc,1,icut) & " " & mid(strSDesc,icut+1)
spccnt = 0
end if
end if
strSDesc1 = strSDesc1 & mid(strSDesc,icut,1)
spccnt = spccnt + 1
next
strRet = strRet & strSDesc1
else
strRet = strRet & "" &trim(rs("ShortDescription")) & " "
end if
strRet = strRet & " | " & chr(13)
set RSs3 = server.CreateObject("ADODB.Recordset")
rss3.Open "SELECT * from Tbl_Preferences WHERE Prefer_ID_PK=" & rs("zodiacsign") & " ",cn,3,1
if not (rss3.BOF or rss3.EOF) then
PreferenceDesc=rss3("PreferenceDesc")
if rs("gender")="M" then
strRet = strRet & "" & PreferenceDesc& ", Male, " & year(now) - year(rs("DOB")) & " years | "
else
strRet = strRet & " " & PreferenceDesc & ", Female, " & year(now) - year(rs("DOB")) & " years | "
end if
end if
if session("userid")<> "" then
set RS2 = Server.CreateObject("ADODB.Recordset")
RS2.open "select * from Tbl_UserContacts where User_ID_FK="& session("UserID")& " and ContactUser_ID_FK="&rs("User_ID_fK"),cn,3,2
if RS2.eof <>true then
strRet = strRet & "Profile Already contacted | " & chr(13)
end if
RS2.close
end if
strRet = strRet & "Recent Visit : " & formatdatetime(rs("logintime"),2)&" | "
if rs("Online") then strRet = strRet & "Online | "
if session("IsMemberLoggedIn") = true or session("Userid")<>"" then
strRet = strRet & "View Profile | " & chr(13)
else
strRet = strRet & "View Profile | " & chr(13)
end if
strRet = strRet & "" & chr(13)
strRet = strRet & " " & chr(13)
strRet = strRet & " | " & chr(13)
strRet = strRet & "
" & chr(13)
strRet = strRet & "