09. marts 2000 - 08:15
Der er
2 kommentarer og
1 løsning
Afstemnings script hvor man kun kan stemme en gang
Jeg søjer et script til en afstemning hvor men man kun kan stemme en gang derester skal funktionen til at stemme med forsvinde.
Nogen der kan hjælpe med det ?
09. marts 2000 - 10:32
#3
Kan det her bruges der er et jeg har hentet på netcoders.dk men bare lavet en hel del om i.
<%
Response.Buffer = True
font = "<font size='2' face='Verdana'>"
faktor = 5
barcolor = "#FF0000"
Set Rs = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("vote.mdb")
Rs.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
' *******************************************************
' * Opdaterer T_Voteresult og laver der efter en *
' * redirect til resultatet *
' *******************************************************
If (Request.ServerVariables("Content_length") > 0) then
Voteid=1
'Sql = "Insert into T_Voteresult (Voteid, Vote, Ip,time) values('" & Request("Voteid") & "','" & Request("R1") & "','" & Request.ServerVariables("REMOTE_ADDR") &"')"
Sql = "Insert into T_Voteresult (Voteid, Vote, Ip) values('" & Request("Voteid") & "','" & Request("R1") & "','" & Request.ServerVariables("REMOTE_ADDR") & "')"
Update="True"
Response.Cookies("UP") = Update
Response.Cookies("UP").expires = Now() + 356
Rs.Execute(Sql)
'Response.redirect Request.ServerVariables("SCRIPT_NAME") & "?id=1"
end if
' *******************************************************
' * Viser resultat *
' *******************************************************
'If "" <> Request.QueryString("id") then
'If "" = Request.QueryString("mode") then
'Sql = "Select * from T_Vote where Id = " & Request.QueryString("Id")
Sql = "Select * from T_Vote where Id = 1"
Set Record = Rs.Execute(Sql)
Dim Valg(5)
valg(1) = Record("valg1")
valg(2) = Record("valg2")
valg(3) = Record("valg3")
'
response.write "<h1 align=center><b>Afstemning om din Medarbejder PC</b></h1>"
response.write "<BR>"
response.write "<BR>"
response.write " "
response.write font & Record("Beskrivelse") & "<br><br>"
Sql = "Select count(*) as Found from T_VoteResult where VoteId = 1"
Set Record = Rs.Execute(Sql)
Ialt = Record("found")
Response.Write "<div align='left'><table border='0'><tr>"
For i = 1 to 5
If valg(i) <> "" then
Sql = "Select count(*) as Found from T_VoteResult where VoteId = 1 " & " and vote = '" & Valg(i) & "'"
Set Record = Rs.Execute(Sql)
Procent = 100/Ialt * Record("Found")
response.write "<td> " & font & Valg(i) & "</td><td>" & font & Round(procent) & "%</td><td><hr width='" & Procent * faktor & "' size='10' align='left' color='" & barcolor & "'></td></tr>"
end if
Next
Response.Write "</table></div>"
Response.Write "<BR>"
response.write "<p> Ud af " & Ialt & " Stemmer</p>"
response.write " <p> Hvis du ikke kan se skemaet hvor i du kan stemme herunder, er et forde du allerede har stemt en gang.</p>"
' *******************************************************
' * Hvis mode = vote, opbygges "stemmeseddel" *
' *******************************************************
'If "vote" = Request.QueryString("mode") then
if Request.Cookies("UP") <> "True" then
Sql = "Select * from T_Vote where Id = 1 "
Set Record = Rs.Execute(Sql)
response.write "<BR> "
response.write font & Record("Beskrivelse")
response.write "<html><head><title>Stem</title></head><body>"
response.write "<form method='POST' action='" & Request.ServerVariables("SCRIPT_NAME") & "'>"
response.write "<input type='hidden' name='Voteid' value=1>"
If Record("Valg1") <> "" then
response.write " <input type='radio' value='" & Record("Valg1") & "' name='R1'>" & Record("Valg1") & "<br>"
end if
If Record("Valg2") <> "" then
response.write " <input type='radio' value='" & Record("Valg2") & "' name='R1'>" & Record("Valg2") & "<br>"
end if
If Record("Valg3") <> "" then
response.write " <input type='radio' value='" & Record("Valg3") & "' name='R1'>" & Record("Valg3") & "<br>"
end if
response.write "<p> <input type='submit' value='Stem' name='B1'> <input type='reset' value='Slet' name='B2'></p>"
response.write "</form></body></html>"
end if
%>
<head>
<title></title>
</head>
<body bgcolor="#99CCFF">