% 'Response.redirect("http://www.politicabr.blog.br")%>
<%
' ************************ Estatisticas do Site ************ qtde_stats=0 datainvertida=D atePart( "m", date) & "/" & DatePart( "d", date) & "/" & DatePart( "yyyy", date) sqlstats="select id_stats, data_acesso, qtde_acessos from estatistica where data_acesso=#" & datainvertida & "#" set rsVerStats=conStats.execute(sqlStats) 'qtde_stats = rsVerStats("qtde_acessos")
IF (not rsVerStats.BOF) and (not rsVerStats.EOF) THEN
qtde_stats = rsVerStats("qtde_acessos") + 1
sqlStats="Update estatistica set qtde_acessos=" & qtde_stats & " where id_stats=" & rsVerStats("id_stats")
set rsSomaStats=conStats.execute(sqlStats)
ELSE
wdatainc = date
sqlStats="Insert into estatistica (data_acesso, qtde_acessos) Values (' " & wdatainc & " ',1)"
set rsSomaStats=conStats.execute(sqlStats)
End IF
' ********************* BANNER TOPO ************** sql="SELECT * FROM banners where status='A' and mostra=1 AND local_pagina=1 order by bannerid" set rsbannerTopo=conpoliticabr.execute(sql) WIDBanner=rsBannerTopo( "BannerID") '
sql="SELECT * FROM banners where status='A ' and mostra=0 AND local_pagina=1 and BannerID>" & WIDBAnner & " order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
' 'rsBannerProximo.MoveFirst
IF (Not rsBannerProximo.EOF) THEN
WIDProximo=rsBannerProximo("BannerID")
else
sql="SELECT * FROM banners where status='A ' AND local_pagina=1 order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
'rsBannerProximo.MoveFirst IF (Not rsBannerProximo.EOF) THEN WIDProximo=rsBannerProximo( "BannerID") Else WIDProximo=WIDBAnner End If End If '
IF WIDProximo<>WIDBanner then
sql="Update banners set mostra=1 where BannerID = " & WIDProximo
set rsbannerProximo=conpoliticabr.execute(sql)
' sql="Update banners set mostra=0 where BannerID = " & WIDBanner set rsbannerProximo=conpoliticabr.execute(sql) End If '
' ********************* BANNER INFERIOR ************** sql="SELECT * FROM banners where status='A' and mostra=1 AND local_pagina=3 order by bannerid" set rsbannerInferior=conpoliticabr.execute(sql) if (not rsBannerInferior.Eof) then WIDBanner=rsBannerInferior("BannerID") '
sql="SELECT * FROM banners where status='A ' and mostra=0 AND local_pagina=3 and BannerID>" & WIDBAnner & " order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
' 'rsBannerProximo.MoveFirst
IF (Not rsBannerProximo.EOF) THEN
WIDProximo=rsBannerProximo("BannerID")
else
sql="SELECT * FROM banners where status='A ' AND local_pagina=3 order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
'rsBannerProximo.MoveFirst IF (Not rsBannerProximo.EOF) THEN WIDProximo=rsBannerProximo( "BannerID") Else WIDProximo=WIDBAnner End If End If '
IF WIDProximo<>WIDBanner then
sql="Update banners set mostra=1 where BannerID = " & WIDProximo
set rsbannerProximo=conpoliticabr.execute(sql)
' sql="Update banners set mostra=0 where BannerID = " & WIDBanner set rsbannerProximo=conpoliticabr.execute(sql) End If End If '
' ******** BANNER LATERAL 1 **************************** sql="SELECT * FROM banners where status='A' and mostra=1 AND local_pagina=2 and posicaobanner=1 order by bannerid" set rsbannerLateral1=conpoliticabr.execute(sql) WIDBanner=rsBannerLateral1("BannerID") '
sql="SELECT * FROM banners where status='A ' and mostra=0 AND local_pagina=2 and posicaobanner=1 and BannerID>" & WIDBAnner & " order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
' 'rsBannerProximo.MoveFirst
IF (Not rsBannerProximo.EOF) THEN
WIDProximo=rsBannerProximo("BannerID")
else
sql="SELECT * FROM banners where status='A ' AND local_pagina=2 and posicaobanner=1 order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
'rsBannerProximo.MoveFirst IF (Not rsBannerProximo.EOF) THEN WIDProximo=rsBannerProximo( "BannerID") Else WIDProximo=WIDBAnner End If End If '
IF WIDProximo<>WIDBanner then
sql="Update banners set mostra=1 where BannerID = " & WIDProximo
set rsbannerProximo=conpoliticabr.execute(sql)
' sql="Update banners set mostra=0 where BannerID = " & WIDBanner set rsbannerProximo=conpoliticabr.execute(sql) End If '
' ******** BANNER LATERAL 2 *************A 1 2 2 sql="SELECT * FROM banners where status='A' and mostra=1 AND local_pagina=2 and posicaobanner=2 order by bannerid" 'sql="SELECT * FROM banners where status='A ' and mostra=1 order by bannerid"
set rsbannerLateral2=conpoliticabr.execute(sql)
if (not rsBannerLateral2.BOF) and (not rsBannerLateral2.EOF) then
WIDBanner=rsBannerLateral2("BannerID")
sql="SELECT * FROM banners where status='A ' and mostra=0 AND local_pagina=2 and posicaobanner=2 and BannerID>" & WIDBAnner & " order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
else
sql="SELECT * FROM banners where status='A ' and mostra=0 AND local_pagina=2 and posicaobanner=2 order by bannerid"
'set rsbannerProximo=conpoliticabr.execute(sql) set rsbannerLateral2=conpoliticabr.execute(sql) WIDBanner=rsBannerLateral2( "BannerID") sql="SELECT * FROM banners where status='A' and mostra=1 AND local_pagina=2 and posicaobanner=2 and BannerID>"& WIDBAnner & " order by bannerid" set rsbannerProximo=conpoliticabr.execute(sql) end if '
IF (Not rsBannerProximo.EOF) THEN
WIDProximo=rsBannerProximo("BannerID")
else
sql="SELECT * FROM banners where status='A ' AND local_pagina=2 and posicaobanner=2 order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
IF (Not rsBannerProximo.EOF) THEN
WIDProximo=rsBannerProximo("BannerID")
Else
WIDProximo=WIDBAnner
End If
End If
IF WIDProximo<>WIDBanner then
sql="Update banners set mostra=1 where BannerID = " & WIDProximo
set rsbannerProximo=conpoliticabr.execute(sql)
' sql="Update banners set mostra=0 where BannerID = " & WIDBanner set rsbannerProximo=conpoliticabr.execute(sql) End If '
' ******** BANNER LATERAL 3 **************************** sql="SELECT * FROM banners where status='A' and mostra=1 AND local_pagina=2 and posicaobanner=3 order by bannerid" set rsbannerLateral3=conpoliticabr.execute(sql) WIDBanner=rsBannerLateral3(
"BannerID") '
sql="SELECT * FROM banners where status='A ' and mostra=0 AND local_pagina=2 and posicaobanner=3 and BannerID>" & WIDBAnner & " order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
' 'rsBannerProximo.MoveFirst
IF (Not rsBannerProximo.EOF) THEN
WIDProximo=rsBannerProximo("BannerID")
else
sql="SELECT * FROM banners where status='A ' AND local_pagina=2 and posicaobanner=3 order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
'rsBannerProximo.MoveFirst IF (Not rsBannerProximo.EOF) THEN WIDProximo=rsBannerProximo( "BannerID") Else WIDProximo=WIDBAnner End If End If '
IF WIDProximo<>WIDBanner then
sql="Update banners set mostra=1 where BannerID = " & WIDProximo
set rsbannerProximo=conpoliticabr.execute(sql)
' sql="Update banners set mostra=0 where BannerID = " & WIDBanner set rsbannerProximo=conpoliticabr.execute(sql) End If '
' ******** BANNER LATERAL 4 **************************** sql="SELECT * FROM banners where status='A' and mostra=1 AND local_pagina=2 and posicaobanner=4 order by bannerid" set rsbannerLateral4=conpoliticabr.execute(sql) if (Not rsBannerLateral4.Eof)
Then WIDBanner=rsBannerLateral4( "BannerID") '
sql="SELECT * FROM banners where status='A ' and mostra=0 AND local_pagina=2 and posicaobanner=4 and BannerID>" & WIDBAnner & " order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
' 'rsBannerProximo.MoveFirst
IF (Not rsBannerProximo.EOF) THEN
WIDProximo=rsBannerProximo("BannerID")
else
sql="SELECT * FROM banners where status='A ' AND local_pagina=2 and posicaobanner=4 order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
'rsBannerProximo.MoveFirst IF (Not rsBannerProximo.EOF) THEN WIDProximo=rsBannerProximo( "BannerID") Else WIDProximo=WIDBAnner End If End If '
IF WIDProximo<>WIDBanner then
sql="Update banners set mostra=1 where BannerID = " & WIDProximo
set rsbannerProximo=conpoliticabr.execute(sql)
' sql="Update banners set mostra=0 where BannerID = " & WIDBanner set rsbannerProximo=conpoliticabr.execute(sql) End If End If '
' ******** BANNER LATERAL 5 **************************** sql="SELECT * FROM banners where status='A' and mostra=1 AND local_pagina=2 and posicaobanner=5 order by bannerid" set rsbannerLateral5=conpoliticabr.execute(sql) if (Not rsbannerLateral5.Eof)
Then WIDBanner=rsBannerLateral5( "BannerID") '
sql="SELECT * FROM banners where status='A ' and mostra=0 AND local_pagina=2 and posicaobanner=5 and BannerID>" & WIDBAnner & " order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
' 'rsBannerProximo.MoveFirst
IF (Not rsBannerProximo.EOF) THEN
WIDProximo=rsBannerProximo("BannerID")
else
sql="SELECT * FROM banners where status='A ' AND local_pagina=2 and posicaobanner=5 order by bannerid"
set rsbannerProximo=conpoliticabr.execute(sql)
'rsBannerProximo.MoveFirst IF (Not rsBannerProximo.EOF) THEN WIDProximo=rsBannerProximo( "BannerID") Else WIDProximo=WIDBAnner End If End If '
IF WIDProximo<>WIDBanner then
sql="Update banners set mostra=1 where BannerID = " & WIDProximo
set rsbannerProximo=conpoliticabr.execute(sql)
' sql="Update banners set mostra=0 where BannerID = " & WIDBanner set rsbannerProximo=conpoliticabr.execute(sql) End If End If %>
<% ' Selecciono todas as perguntas por ordem decrescente de data
sql="SELECT * FROM enquete_pergunta where ativo=1 ORDER BY data DESC"
set rs_enquete_pergunta=conpoliticabr.execute(sql)
' Selecciono todas as respostas da pergunta de data mais recente if not rs_enquete_pergunta.eof then sql="SELECT * FROM enquete_respostas WHERE ID_enquete=" &rs_enquete_pergunta(0)& " and respostas<>'' ORDER BY id_resposta " set rs_enquete_respostas=conpoliticabr.execute(sql)
end if %>
<% ' Formul�rio que vai enviar o ID da resposta para adicionar mais um hit
%>
<%if not rs_enquete_pergunta.eof then %>
<%end if%>
<%set conpoliticabr = nothing%>
<%set conStats = nothing %>
Este
site é melhor visualizado com o Internet Explorer 8.0 ou
Superior e resolução 800x600.
Política de Privacidade -
PoliticaBR 2004-2016 - Todos os direitos reservados