% set soru = Server.CreateObject("ADODB.RecordSet") SQL = "select * from sorular where id like '"&aktif_id&"'" soru.open SQL,anketbag,1,3 soru_id=soru("id") set secenek = Server.CreateObject("ADODB.RecordSet") SQL = "select * from secenekler where hangi_soru like '"&soru_id&"'" secenek.open SQL,anketbag,1,3 set secenek_diger = Server.CreateObject("ADODB.RecordSet") SQL = "select * from secenekler where hangi_soru like '"&soru_id&"diger'" secenek_diger.open SQL,anketbag,1,3 set say = Server.CreateObject("ADODB.RecordSet") SQL = "select Sum(hit) from secenekler where hangi_soru like '"&soru_id&"'" say.open SQL,anketbag,1,3 toplam = say(0) Set yorumlar = Server.CreateObject("Adodb.Recordset") SQL = "SELECT * FROM yorumlar where hangi_soru="&soru_id&"" yorumlar.Open SQL,anketbag,1, 3 set ip_kontrol = Server.CreateObject("Adodb.Recordset") SQL = "SELECT * FROM iplog" ip_kontrol.Open SQL,anketbag,1, 3 do while not ip_kontrol.eof if DateDiff("N", ip_kontrol("tarih"), now()) > 60 then Set ip_sil = Server.CreateObject("Adodb.Recordset") SQL = "delete from iplog where id = "&ip_kontrol("id")&"" ip_sil.Open SQL,anketbag,1, 3 end if ip_kontrol.movenext loop Set ip_kontrol2 = Server.CreateObject("Adodb.Recordset") SQL = "SELECT * FROM iplog where ip = '"&request.servervariables("REMOTE_HOST")&"' and anket_no = "&aktif_id&"" ip_kontrol2.Open SQL,anketbag,1, 3 if Request.Cookies("aspmaster_anket")("ayar(""anket_adi"")") = ""&aktif_id&" nolu anket" then cookie="var" end if %>
<%=ayar("anket_adi")%> |
<%=soru("soru")%> |
<%if ayar("sonuc")="var" then Response.Write("Sonuçlar") end if%> <%if ayar("eskiler")="var" then response.Write("Eski Anketler") end if%> |
<%=ayar("anket_adi")%> |
|||||||
<%=soru("soru")%> |
|||||||
<%Do While not secenek.Eof
If toplam > 0 Then
yuzde = Int((secenek("hit") / toplam) * 100)
Else
yuzde = 0
End If%>
") do while not secenek_diger.eof%>
|
|||||||
<%if ayar("eskiler")="var" then Response.Write("Eski Anketler") end if%> |