Ver Mensaje Individual
  #4 (permalink)  
Antiguo 10/12/2002, 13:47
Avatar de Artepop
Artepop
 
Fecha de Ingreso: noviembre-2002
Ubicación: Fuengirola
Mensajes: 292
Antigüedad: 21 años, 6 meses
Puntos: 1
Este es el vículo:
Código:
<a href="philboard_reply.asp?id=root&topic=<%=id%>&recordnum=<%=recordnum%>"><img src="images/replywquote.gif" width="15" height="15" border="0" alt="Responder con quote"></a>
Script: Creo que es por aquí, soy principiante.....sorry
Código:
<%
Option Explicit
Dim sql,rsRoot,rsReplies,count,id,rsUser,username,level,recordnum,cellbgcolor,messagecount,messagepage,lastpage,moderator,forumid,locked,repliesdisplay

username = Request.Cookies("pb_username")
level = Request.Cookies("level")
recordnum = Request.QueryString("recordnum")

'repliesdisplay alters amount of replies to display on page
repliesdisplay = 20

if recordnum = "" then recordnum = 0 end if

id = Request.QueryString("id")
%>

<!--#include file="conn.asp"-->

<%
sql = "SELECT topics.*, forums.*, statusname, statuslevel, moderator, users.posts FROM (status INNER JOIN users ON status.statusid = users.status) INNER JOIN ((forums INNER JOIN moderators ON forums.forumid = moderators.moderatorforum) INNER JOIN topics ON forums.forumid = topics.forum) ON users.username = topics.by WHERE topics.id = " & id
Set rsRoot = Server.CreateObject("ADODB.Recordset")
rsRoot.Open sql, conn, 3, 3

moderator = rsRoot("moderator")
forumid = rsRoot("forumid")
locked = rsRoot("locked")

sql = "SELECT replies.*, statusname, statuslevel, users.posts FROM (status INNER JOIN users ON status.statusid = users.status) INNER JOIN replies ON users.username = replies.by WHERE replies.root = " & id & " ORDER BY date, time"
Set rsReplies = Server.CreateObject("ADODB.Recordset")
rsReplies.Open sql, conn, 3, 3

if not rsReplies.EOF then
  rsReplies.Movefirst

  for count = 1 to repliesdisplay
	rsReplies.Movenext
	if rsReplies.EOF then
	  exit for
	end if
  next
  
  if not rsReplies.EOF then
	messagecount = rsReplies.Recordcount
  end if
  
  rsReplies.Movefirst
  
end if
%>
__________________
http://www.mfo.com.es/