Slettet bruger
26. december 1999 - 15:37
#1
<%
response.write "<style type='text/css'>"
response.write "a:visited { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11pt; font-style: normal; font-weight: normal; color: #0000FF}"
response.write "a:hover { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11pt; font-weight: normal; color: #FF0000; text-decoration: underline}"
response.write "a:link { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11pt; font-weight: normal; color: #0000FF}"
response.write "p { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11pt; font-weight: normal; color: #666666}"
response.write "h1 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 18pt; font-weight: normal; color: #666666}"
response.write "h2 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11pt; font-weight: normal; color: #FFFFFF}"
response.write "</style>"
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString("mode")
tempConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("Brugere.mdb") & ";UID=admin;PWD=;"
If Request.Form("Gem") <> "" Then
strError = ""
strNavn = Trim(Request.Form("Navn"))
strMobilnummer = Trim(Request.Form("Mobilnummer"))
If Len(strNavn) = 0 Then
strError = "<li>Du skal skrive dit navn!</li>"
ElseIf Len(strMobilnummer) = 0 Then
strError = "<li>Du skal skrive et mobilnummer!</li>"
End If
If Len(strError) = 0 Then
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM brugere WHERE (ID = 0)"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs("Navn") = Server.HTMLEncode(strNavn)
rs("Mobilnummer") = Server.HTMLEncode(strMobilnummer)
rs("Dato") = Now()
rs.Update
End If
rs.Close
Set rs = Nothing
Else
strError = "<p><ul><font color=#FF0000>" & strError & "</font></ul></p>"
strMode = "add"
End If
End If
%>
<html>
<head>
<title>Mobilbesked system</title>
</head>
<body vlink='#0000FF' alink='#0000FF' link='#0000FF' BACKGROUND='paw.jpg' >
<div align="center"><center><table border="0" width="600" cellspacing="0" cellpadding="3" style="border-left: 1px solid rgb(0,0,0); border-right: 1px solid rgb(0,0,0); border-top: 1px solid rgb(0,0,0); border-bottom: 2px solid rgb(0,0,0)">
<tr>
<td width="100%" bgcolor="#000000"><p><font face="verdana" size="4" color="#FFFFFF"><strong>Brugere</strong></font></td>
</tr>
<tr>
<td width="100%">
<%
Select Case strMode
Case "add"
%>
<form method="POST" action="brugere.asp">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td valign="middle" align="left" colspan="2"><font face="verdana" size="2"><br>Indtast venligst oplysningerne i følgende felter:<strong>
<%=strError%></td>
</tr>
<tr>
<td valign="middle" align="left"><div align="right"><h2>Navn</h2></td>
<td valign="middle" align="left"><input type="text" name="Navn" size="40" value="<%=strNavn%>"></td>
</tr>
<tr>
<td valign="middle" align="left"><div align="right"><h2>Mobilnummer</h2></td>
<td valign="middle" align="left"><input type="text" name="Mobilnummer" size="40" value="<%=strMobilnummer%>"></td>
</tr>
<tr>
<td valign="middle" align="left" colspan="2"><br>
<input type="submit" value="Gem" name="Gem"> <input type="button" value="Annuller" name="Annuller" onClick="java script:location.href='brugere.asp'"></td>
</tr>
</table>
</form>
<%
Case "Send"
teledk = "@sms.tdm.dk"
sonofon = "@note.sonofon.dk"
telia = "@gsm1800.telia.dk"
mobilix = "@sms.mobilix.dk"
Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.ServerAddress = "mail.euhelev.dk"
JMail.Sender = "anonym bruger af elevsiden"
JMail.Subject = "Kritik, Ris eller Ros fra websiden"
JMail.Body = strMSG
JMail.Priority = 1
JMail.AddHeader "Originating-IP", Request.ServerVariables("REMOTE_ADDR")
JMail.Execute
strSQL = "SELECT * FROM brugere ORDER BY Dato DESC;"
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write "<center><table width=80% border=1 cols='4' cellpadding=1 cellspacing=1>"
Do While Not rs.EOF
If request.form(strMobilnummer)="on" then
If Not IsNumeric(strMobilnummer) Then
gyldigt = 0
else
if left(strMobilnummer,4) < 2010 OR len(strMobilnummer) < 8 then
gyldigt = 0
else
gyldigt = 1
end if
end if
if gyldigt = 1 then
if int(left(strMobilnummer,4)) => 2010 AND int(left(strMobilnummer,4)) =< 2059 then
selskab = teledk
elseif int(left(strMobilnummer,4)) => 2060 AND int(left(strMobilnummer,4)) =< 2099 then
selskab = sonofon
elseif int(left(strMobilnummer,4)) => 2110 AND int(left(strMobilnummer,4)) =< 2199 then
selskab = teledk
elseif int(left(strMobilnummer,4)) => 2210 AND int(left(strMobilnummer,4)) =< 2299 then
selskab = sonofon
elseif int(left(strMobilnummer,4)) => 2310 AND int(left(strMobilnummer,4)) =< 2399 then
selskab = teledk
elseif int(left(strMobilnummer,4)) => 2610 AND int(left(strMobilnummer,4)) =< 2699 then
selskab = mobilix
elseif int(left(strMobilnummer,4)) => 2810 AND int(left(strMobilnummer,4)) =< 2899 then
selskab = telia
elseif int(left(strMobilnummer,4)) => 3010 AND int(left(strMobilnummer,4)) =< 3099 then
selskab = teledk
elseif int(left(strMobilnummer,4)) => 4010 AND int(left(strMobilnummer,4)) =< 4049 then
selskab = teledk
elseif int(left(strMobilnummer,4)) => 4050 AND int(left(strMobilnummer,4)) =< 4099 then
selskab = sonofon
else
gyldigt = 0
end if
end if
if gyldigt = 1 then
JMail.AddRecipient strMobilnummer & selskab
End If
rs.MoveNext
Loop
Response.Write "</table></center>"
Else
Response.Write "<p><font face=verdana size=2>Der er ikke tilføjet nogle brugere endnu!</font></p>"
End If
myConn.Close
Set myConn = Nothing
Response.Write "<center>"
Response.Write "<h1>Din post er blevet sendt</h1>"
Case Else
strAddLine = "<p><img src=add.gif width=16 height=16> <a href=brugere.asp?mode=add><strong><font face=verdana size=2>Tilføj en bruger!</font></strong></a></p>"
Response.Write strAddLine
strSQL = "SELECT * FROM brugere ORDER BY Dato DESC;"
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write "<center><table width=80% border=1 cols='4' cellpadding=1 cellspacing=1>"
Do While Not rs.EOF
dtmDato = rs("Dato")
dtmDato = FormatDateTime(dtmDato,vbLongDate) & " kl. " & FormatDateTime(dtmDato,vbLongTime)
Response.Write "<tr>"
Response.Write "<form name='" & rs("Mobilnummer") & "'>"
Response.Write "<td bgcolor=#FFFFFF width='32' height='32'><input type='checkbox' name='" & rs("Mobilnummer") & "'></td>"
Response.Write "<td bgcolor=#FFFFFF><center><p>Navn:</p></center><center>" & rs("Navn") & "</center></td>"
Response.Write "<td bgcolor=#FFFFFF width='70'><p>Nummer:</p>" & rs("Mobilnummer") & "</td>"
Response.Write "<td bgcolor=#FFFFFF width='200'><p>Tilføjet dato:</p>" & dtmDato & "</td>"
Response.Write "</form>"
rs.MoveNext
Loop
Response.Write "</table></center>"
Else
Response.Write "<p><font face=verdana size=2>Der er ikke tilføjet nogle brugere endnu!</font></p>"
End If
myConn.Close
Set myConn = Nothing
Response.Write strAddLine
End Select
%>
</tr>
<tr align="center">
<td width="100%" bgcolor="#000000"><strong><font face="verdana" size="4"><div align="center"><center><p></font></strong><font face="Verdana" size="1" color="#FFFFFF"><br></font></td>
</tr>
</table>
</center></div>
<%
Response.Write "<center>"
Response.Write "<table BORDER='0' COLS='2' WIDTH='200'>"
Response.Write "<form method='POST' action='brugere.asp?mode=Send'>"
Response.Write "<tr>"
Response.Write "<td width='24'><h2>Afsender</h2></td>"
Response.Write "<td width='64'><INPUT TYPE='TEXT' NAME='afsender' SIZE='42'></td>"
Response.Write "</tr><tr>"
Response.Write "<td width='24'><h2>Besked</h2></td>"
Response.Write "<td width='64'><TEXTAREA ROWS='3' COLS='40' NAME='besked' BORDER='0' SCROLLING='NO'></TEXTAREA></td>"
Response.Write "</tr><tr>"
'Response.Write "<td width='64'>Submit</td>"
Response.Write "<td width='24'><input type='submit' value='Send' name='Action'></td>"
Response.Write "</tr></table>"
Response.Write "</center></form>"
%>
</body>
</html>