if Rs2("privat") = 1 and egen = 0 then response.write("<br><br><br>privat<b><b><b>")
Placera koden där du tycker den passar in!
2 svar · 274 visningar · startad av Jeppeweb
Hur går jag tillväga om jag vill skriva ut <br><br><br>privat<b><b><b> när privat är satt till 1 och egen till 0 ?
tack
<%
SQL = "Select * From gastbok WHERE till = "&userid&" ORDER BY datum DESC"
Set Rs2 = Server.CreateObject("ADODB.RecordSet")
Rs2.CursorLocation = 3
'Antal inlägg som ska vissas vid katalog visning
Rs2.PageSize = 10
Rs2.Open SQL, Connect, 1,3
if Rs2.eof then
Response.Write "<br><i><center>Här var det öken..</center></i>"
else
If Rs2.PageCount > 1 Then
For i = 1 to Rs2.PageCount
If i = CLng(sida) Then
Response.Write "[" & i & "] "
Else
Response.Write "<a href=?page=61&userid="&userid&"&sida=" & i & ">" & i & "</a> "
End If
Next
End If
Dim sida
sida = Trim(Request.QueryString("sida"))
If sida = "" Then
sida = 1
End If
Rs2.AbsolutePage = sida
Dim rad
rad = 0
Response.write "<table width='100%'>"
While Not Rs2.EOF and rad < Rs2.PageSize
rad = rad + 1
if Rs2("privat") = 0 or cint(Session("cmid")) = cint(Rs2("fran")) OR cint(Session("cmid")) = cint(Rs2("till")) then
'Visa
else
'privat
end if
if Rs2("privat") = 1 AND egen = 1 OR Rs2("privat") = 1 AND Session("cmid") = Rs2("fran") OR Rs2("privat") = 0 then
if x = 0 then
bgcolor = "#E7E7FE"
x = 1
else
bgcolor = "#FFFFFF"
x = 0
end if
SQL = "Select * from medlemmar where id = '"&Rs2("fran")&"'"
Set Rs3 = Connect.execute(SQL)
Response.Write "<tr><td bgcolor="&bgcolor&">"
if Rs3("bild") = "" OR Rs3("bild") = "ingen" then
Response.Write "<img src=bilder/userspics/ingenbild.gif width=50 height=70 border=1>"
else
if Rs3("bildaccept")="1" then
Response.Write "<a href=?page=2&userID="&Rs3("ID")&" border=0><img src=bilder/userspics/"&Rs3("bild")&" width=50 height=70 border=1></a>"
else
Response.Write "<img src=bilder/userspics/ingenbild2.gif width=50 height=70>"
end if
end if
Response.Write "<td bgcolor="&bgcolor&" width=600>Skrivet av <a href=?page=2&userID="&Rs3("ID")&">"&byt(Rs3("alias"))&"</a> "
datum = rs2("datum")
select case cdate(FormatDateTime(datum,vbShortDate))
case date()
response.write "@ idag kl " & FormatDateTime(datum, vbShortTime)
case dateadd("d",-1, date())
response.write "@ igår kl " & FormatDateTime(datum, vbShortTime)
case else
response.write FormatDateTime(datum, vbLongDate) & " kl " & FormatDateTime(datum, vbShortTime)
end select
if Rs2("privat") = 1 then
Response.Write " [privat] "
end if
Response.Write "<br><br><b></b> "&Rs2("text")
if egen = 1 then
Response.Write "<br><br><br><br>"
Response.Write "<a href=?page=61&userid="&userid&"&sida=" & sida & "&delID="&CLng(Rs2("Id"))&"><img border='0' align='right' src='gb/radera.gif'></a>"
Response.Write "<a href=?page=61&userid="&CLng(Rs2("fran"))&"><img border='0' align='right' src='gb/svara.gif'></a>"
end if
Response.Write"</td></tr>"
Rs3.close
Set Rs3 = Nothing
end if
Rs2.MoveNext
Wend
Response.write "</table>"
If Rs2.PageCount > 1 Then
For i = 1 to Rs2.PageCount
If i = CLng(sida) Then
Response.Write "[" & i & "] "
Else
Response.Write "<a href=?page=61&userid="&userid&"&sida=" & i & ">" & i & "</a> "
End If
Next
End If
end if
Rs2.CLOSE
Set Rs2 = nothing
if Request.Querystring("action") = "spara" then
fran = Session("cmID")
till = userid
status = + 5
last = "0"
datum = Now
text = Replace(request.Form("text"),"'","\'")
ip = Request.ServerVariables("REMOTE_ADDR")
if request.Form("privat") = 1 then
privat = 1
else
privat = 0
end if
Connect.Execute("INSERT INTO gastbok (fran, till, text, datum, ip, privat, last) VALUES('"& fran &"','"& till &"','"& text &"','"& datum &"','"& ip &"','"& privat &"','"& last &"')")
Response.Redirect "?page=61&userid="&userid&""
end if
if Request.Querystring("delID") <> "" then %><!-- #include file="databaskopplingar.asp" --><%
sida = Request.Querystring("sida")
Connect.execute("delete from gastbok where id = "&request.querystring("delID")&"")
Response.Redirect("?page=61&sida="&sida&"")
end if
egen = ""
Connect.CLOSE
Set Connect = nothing
else
s = Request.Querystring("s")
Set FSO = Server.CreateObject("Scripting.FileSystemObject")
Set File = FSO.OpenTextFile(Server.MapPath("databaskopplingar.asp"),1)
Response.Write Replace(server.HTMLEncode(File.ReadAll),vbCrLf, "<br>")
File.Close
Set File = Nothing
Set FSO = Nothing
end if
%>
if Rs2("privat") = 1 and egen = 0 then response.write("<br><br><br>privat<b><b><b>")
Placera koden där du tycker den passar in!
Hm, det blev ju inte alls som jag tänkte mig
Hur skulle jag gå tillväga för att få precis samma struktur på inlägget som det vanliga fast det står Privat för de andra användare som inte är mottagaren eller skrivaren ?