28. januar 2001 - 13:36Der er
16 kommentarer og 1 løsning
brugers ip
et lille nemt spm til den rette..
Jeg skal i et forum, logge brugerns ip når han/hun sender et indlæg. Ip\'n skal gemmes i min db sammen med de andre data brugeren sender.. Hvordan gør man det?
Der bliver investeret massivt i AI. Teknologien er mere tilgængelig end nogensinde, og ambitionerne er høje. Alligevel oplever mange virksomheder, at resultaterne udebliver.
<% dim useraction,fid,action,id,tid,mailme dim mesbody,name,subject dim sql_maxid,rs_maxid,maxid fid=request(\"fid\") id=request(\"id\") tid=request(\"tid\") if id=\"\" then action=\"post.asp?action=save\" else action=\"post.asp?action=replay\" end if userAction=request(\"action\") \'response.write useraction select case userAction case \"save\" call connect() sql=\"select * from mestbl\" RS.Open sql, Conn, 3, adLockOptimistic mesbody=request.form(\"message\") name=request.form(\"name\") name = replace(name,\"*\",\"\") subject=request.form(\"subject\") mailme=request.form(\"mailme\") \'htmlencode so people can post code mesbody=Server.HtmlEncode(mesbody) name=Server.HtmlEncode(name) subject=Server.HtmlEncode(subject) \'insert br when user do mesbody = Replace(mesbody, vbCrLf, \"<br>\") rs.addnew rs(\"name\")=name rs(\"subject\")=subject rs(\"email\")=request.form(\"email\") rs(\"mesdate\")=now() rs(\"mesbody\")=mesbody rs(\"thread_parent\")=0 rs(\"thread_id\")=0 rs(\"forumID\")=request.form(\"fid\") rs(\"isChecked\")=mailme rs.update call close() response.redirect \"list.asp?fid=\"&fid case \"replay\" fid=request.form(\"fid\") id=request.form(\"id\") mailme=request.form(\"mailme\") \'response.write fid & tid & tl\'***debug \'adding the replay to table: call connect() sql=\"select * from mestbl\" \'Access does not support a cursor engine so a client cursor must be used RS.Open sql, Conn, adOpenStatic, adLockOptimistic mesbody=request.form(\"message\") name=request.form(\"name\") subject=request.form(\"subject\") tid=request.form(\"tid\") if tid=0 then tid=id end if \'htmlencode so people can post code mesbody=Server.HtmlEncode(mesbody) name=Server.HtmlEncode(name) subject=Server.HtmlEncode(subject) \'insert br when user do mesbody = Replace(mesbody, vbCrLf, \"<br>\") rs.addnew rs(\"name\")=name rs(\"subject\")=subject rs(\"email\")=request.form(\"email\") rs(\"mesdate\")=now() rs(\"mesbody\")=mesbody rs(\"forumID\")=fid rs(\"thread_parent\")=id rs(\"thread_id\")=tid rs(\"isChecked\")=mailme rs.update
\'------------------------Send Mail to All \"family\"------------------------ \'if your server doesnt support the cdonts sending mail just delete the next \'3 lines
du skal oprette en kollone der hedder ip i databasen og så skulle koden vidst se sådan her ud:
<% dim useraction,fid,action,id,tid,mailme dim mesbody,name,subject dim sql_maxid,rs_maxid,maxid fid=request(\"fid\") id=request(\"id\") tid=request(\"tid\") if id=\"\" then action=\"post.asp?action=save\" else action=\"post.asp?action=replay\" end if userAction=request(\"action\") \'response.write useraction select case userAction case \"save\" call connect() sql=\"select * from mestbl\" RS.Open sql, Conn, 3, adLockOptimistic mesbody=request.form(\"message\") name=request.form(\"name\") name = replace(name,\"*\",\"\") subject=request.form(\"subject\") mailme=request.form(\"mailme\") \'htmlencode so people can post code mesbody=Server.HtmlEncode(mesbody) name=Server.HtmlEncode(name) subject=Server.HtmlEncode(subject) \'insert br when user do mesbody = Replace(mesbody, vbCrLf, \"<br>\") rs.addnew rs(\"name\")=name rs(\"subject\")=subject rs(\"email\")=request.form(\"email\") rs(\"mesdate\")=now() rs(\"mesbody\")=mesbody rs(\"thread_parent\")=0 rs(\"thread_id\")=0 rs(\"forumID\")=request.form(\"fid\") rs(\"isChecked\")=mailme rs(\"ip\")= Request.ServerVariables(\"REMOTE_ADDR\") rs.update call close() response.redirect \"list.asp?fid=\"&fid case \"replay\" fid=request.form(\"fid\") id=request.form(\"id\") mailme=request.form(\"mailme\") \'response.write fid & tid & tl\'***debug \'adding the replay to table: call connect() sql=\"select * from mestbl\" \'Access does not support a cursor engine so a client cursor must be used RS.Open sql, Conn, adOpenStatic, adLockOptimistic mesbody=request.form(\"message\") name=request.form(\"name\") subject=request.form(\"subject\") tid=request.form(\"tid\") if tid=0 then tid=id end if \'htmlencode so people can post code mesbody=Server.HtmlEncode(mesbody) name=Server.HtmlEncode(name) subject=Server.HtmlEncode(subject) \'insert br when user do mesbody = Replace(mesbody, vbCrLf, \"<br>\") rs.addnew rs(\"name\")=name rs(\"subject\")=subject rs(\"email\")=request.form(\"email\") rs(\"mesdate\")=now() rs(\"mesbody\")=mesbody rs(\"forumID\")=fid rs(\"thread_parent\")=id rs(\"thread_id\")=tid rs(\"isChecked\")=mailme rs(\"ip\")= Request.ServerVariables(\"REMOTE_ADDR\") rs.update
\'------------------------Send Mail to All \"family\"------------------------ \'if your server doesnt support the cdonts sending mail just delete the next \'3 lines
Kan man på en eller anden måde sørge for at en bestemt IP ikke kan skrive i ens forum.. Hvis nu fx. man har en gut fra 192.xxx.xxx.xxx der spammer sit board, kan man så blokere ham fra at skrive derinde på en eller anden måde??
jep, du kan jo lave et tabel i databasen hvor du så indtaster de ip\'er som ikke må skrive også laver du en if sætning der hvor du skal indsætte i databasen!
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.